A commercial pilot is under investigation after falling asleep in the cockpit of a freight plane and overflying his Australian island destination by 29 miles.