A pilot has died after a mid-air collision with another plane.