A firefighting pilot battling a wildfire in Colorado has died after his plane crashed into a reservoir.