As for the deaths and injuries, check Wikipedia ( http://en.wikipedia.org/wiki/List_of_pipeline_accidents#United_States )

As for the number of incidents, check:
( http://en.wikipedia.org/wiki/List_of_pipeline_accidents_in_the_United_States_in_the_21st_century )

As for other facts on pipelines, check: ( https://opsweb.phmsa.dot.gov/pipelineforum/facts-and-stats/incidents-and-mileage-report/ )

True, there a a number of extra jobs that will be aided by the pipeline (e.g., retail sales, auto sales and mechanics, etc.), the fact remains that many of these jobs already exist and will not be newly created.

And, the fact remains that pipeline accident clean-up is expensive and should be paid by the pipeline, not the US taxpayer. If TransCanada, an international company, desires to walk away from a spill and not pay for the clean-up, it will be the taxpayer who pays. Certainly, paying eight cents per 42 gallon barrel into the Trust Fund is not too much to pay.