It was blown off the Huey P. Long Bridge in Louisiana.
http://www.cnn.com/videos/us/2015/04/28/vo-train-falls-off-huey-p-long-bridge.wgno
http://www.cnn.com/videos/us/2015/04/28/vo-train-falls-off-huey-p-long-bridge.wgno