Harrowing footage from the cockpit shows the moment the pilot realised the plane was going to crash