My comment was only made to suggest which has more catastrophic potential: Rail vs Pipeline...you took it in a completely different direction but if you insist here are some ones close to home...

British Columbia South Coast
July 15, 2005: 210,000 litres (1,320 barrels) of crude oil were leaked at the Sumas Tank Farm operated by Kinder Morgan (BC Metis Kinder Morgan Assessment, p. 4).
June 4, 2007: 69,950 litres (440 barrels) of crude oil were spilled at former Wahleach pump station, and reports indicate that the Kinder Morgan pipeline may have been leaking for weeks beforehand (BC Metis Kinder Morgan Assessment, p. 4).
July 24, 2007: 250,000 litres (1,500 barrels) of crude oil spilled out of the pipeline in Burnaby, BC. The crude oil flowed through neighbourhood storm sewers and ditches before entering and contaminating a large portion of Burrard Inlet (CBC).
May 6, 2009: An estimated 200,000 litres (1,260 barrels) of crude oil leaked from Kinder Morgan’s oil storage facility in Burnaby, BC (CBC).
January 24, 2012: An estimated 110,000 litres of crude oil leaked from Kinder Morgan’s oil storage facility on Sumas Mountain in Abbotsford (BC Metis Kinder Morgan Assessment, p. 4).