Sadly, this one is totally REAL, according to snopes.com, which said the incident occurred in Kansas in 2002 after one of the cars experienced an overheated axle that caused it to derail on the bridge.
While the crew went out to investigate, the axle set the wooden bridge on fire. No one was injured in the accident, but the damage was estimated at over $2 million, according to the site.