A man has died following a light aircraft crash near Fife Airport.