Pilot shot while flying on New Year's Eve