A man has died after a light aircraft crashed into a field in Fife.