Nigeria has struggled to meet sustainable development goals (SDGs) on environmental sustainability, transportation, and petroleum product distribution for decades, endangering human and ecological health. Petroleum product spills contaminate soil, water, and air, harming humans, aquatic life, and biodiversity. The oil and gas industry contributes to environmental sustainability and scientific and technological advancement through its supply chain activities in the transport and logistics sectors. This paper reviewed the effects of petroleum product transportation at three accident hotspots on Nigeria highway, where traffic and accident records are alarming due to the road axis connecting the southern and northern regions of the country. The preliminary data was statistically analysed to optimise the review process and reduce risk factors through ongoing data monitoring. Studies on Nigeria's petroleum product transportation spills and environmental impacts between the years 2013 and 2023 were critically analysed to generate updated information. The searches include Scopus, PubMed, and Google Scholar. Five hundred and forty peer-reviewed studies were analysed, and recommendations were established through the conclusions. The findings show that petroleum product transport causes heavy metal deposition in the environment as heavy metals damage aquatic life and build up in the food chain, posing a health risk to humans. The study revealed that petroleum product spills have far-reaching environmental repercussions and, therefore, recommended that petroleum product spills must be mitigated immediately. Furthermore, the study revealed that better spill response and stricter legislation are needed to reduce spills, while remediation is necessary to lessen the effects of spills on environmental and human health.