A pilot has died after a light aircraft crashed into the runway at a north Wales airport and burst into flames, police said.