The plane crashed yards from a luxury hotel in the Trang Province while on a routine mission - as footage showed it caught mid-air in a steep, uncontrolled dive, moments before hurtling into the water