Video shows mangled train cars piled on top of each other on the tracks, as emergency crews attended the scene