Moving dangerous stuff is always risky, there’s plenty of disasters from both. https://en.wikipedia.org/wiki/List_of_pipeline_accidents
From 1994 through 2013, the U.S. had 745 serious incidents with gas distribution, causing 278 fatalities and 1059 injuries, with $110,658,083 in property damage.
US: From 1994 through 2013, there were an additional 110 serious incidents with gas transmission, resulting in 41 fatalities, 195 injuries, and $448,900,333 in property damage.[83] From 1994 through 2013, there were an additional 941 serious incidents with gas all system type, resulting in 363 fatalities, 1392 injuries, and $823,970,000 in property damage.[84]” The US list is so long it’s broken out by year: https://en.wikipedia.org/wiki/List_of_pipeline_accidents_in_...
The pipeline page lists individual highlights starting: Belgium 2004, killing 24 people and leaving 122 wounded… with some highlights being Quebec killing 28, 2013. China 2013 55 people were killed. India 2014 killed 22 people and injured 37, Kenya 2011 killed 100 hospitalized 120.
Mexico: 12 people were killed, killing 52 people, killed at least 27 people and injured more than 50, 2019: killed at least 96 people and injured dozens more
Russia: 1989 Up to 645 people were reported killed on June 4, 1989
Taiwan: At least 30 people were killed and over 300 injured
Of course Nigeria is the scariest with several accidents each of which killed hundreds.