An unauthorized helicopter flight in northern Australia ended in tragedy when a man crashed into the roof of a hotel in Cairns and was killed.