Final NTSB investigations
149 cases where the sequence of events included Midair collision.
Cases, newest first
Query with SQL
duckdb -csv -c "SELECT c.\"ntsbNumber\", c.\"eventDate\", c.\"eventType\", c.\"eventCity\", c.\"eventStateOrRegion\", a.n_number, a.\"aircraftMake\", a.\"aircraftModel\", c.\"highestInjuryLevel\", c.\"totalFatal\", c.\"completionStatus\", c.report_url
FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c.\"mKey\" AND a.position = 1
WHERE c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '250' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '250' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB CEN19LA074Accident · No injuriesLimited investigationFinal reportCessna 172 · Grand Prairie, TXThe failure of the pilots of both airplanes to see and avoid the other airplane while entering the airport traffic pattern in visual meteorological conditions. Contributing to the accident was the tower controller's failure to recognize the proximity of the…NTSB WPR18LA267Accident · No injuriesLimited investigationFinal reportAero Vodochody L39 · Reno, NVThe pilot of the race 13 airplane's failure to maintain clearance from the race 37 airplane during the closed course air race.NTSB DCA18IA264Incident · No injuriesIncident investigationFinal reportLindstrand 105A · Driggs, IDthe drone pilot's decision to fly without pre-coordination, and without the requisite skills and knowledge, to maneuver the drone in close proximity to another aircraft.NTSB CEN18LA298Accident · Minor injuriesLimited investigationFinal reportExtra EA300 · North Fox Island, MIThe Extra pilot’s failure to see and avoid the Cessna, which resulted in an in-flight collision. Contributing to the accident was the failure of the Extra pilot to tune his radio to the correct frequency, which resulted in no common traffic advisories being…NTSB ERA18FA194Accident · 4 fatalField investigationFinal reportPiper PA34 · Miami, FLThe failure of both pilots in both airplanes to see and avoid the other airplane as they converged nearly head-on at the same altitude.NTSB ANC18FA045Accident · 1 fatalField investigationFinal reportCessna 175 · Anchorage, AKThe failure of both pilots to see and avoid the other airplane while in level cruise flight, which resulted in a midair collision.NTSB WPR18LA144Accident · No injuriesLimited investigationFinal reportRyan Navion · Jasper, ALThe other pilot's failure to maintain clearance from another airplane in the formation flight due to sun glare.NTSB ERA18LA109Accident · No injuriesLimited investigationFinal reportCirrus Design SR20 · Palatka, FLBoth pilots’ and the flight instructor’s failure to identify, see, and avoid the other airplane, which resulted in a midair collision.NTSB CEN18LA087Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Loveland, COThe airplane pilot’s failure to see and avoid the helicopter while in the traffic pattern, which resulted in a midair collision between the two aircraft. Contributing to the accident was the airplane pilot’s misunderstanding of the helicopter pilot’s…NTSB WPR18LA071Accident · Serious injuriesClass 3 · LimitedFinal reportSix Chuter Spirit · Marana, AZThe noncertificated pilots’ failure to maintain an adequate visual lookout, which resulted in a midair collision.NTSB ERA18LA055Accident · No injuriesLimited investigationFinal reportCessna 182 · Burlington, NCThe pilot's failure to maintain adequate clearance from another airplane before beginning an inverted flight maneuver, which resulted in a collision with the airplane when he rolled his airplane upright.NTSB WPR18LA003Accident · No injuriesClass 3 · LimitedFinal reportBorom Marcus P Long EZ · Tucson, AZThe failure of both pilots to see and avoid the other airplane while maneuvering in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the controller's failure to provide adequate traffic information, issue necessary…NTSB ERA17LA332Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 · Clearwater, FLThe airplane pilot's inadequate visual lookout, which resulted in an in-flight collision with a helicopter. Contributing to the accident was the airplane pilot's failure to adequately transmit his position while operating in the airport traffic pattern.NTSB DCA17IA202Incident · No injuriesIncident investigationFinal reportDJI Phantom · Hoffman Island, NYthe failure of the sUAS pilot to see and avoid the helicopter due to his intentional flight beyond visual line of sight. Contributing to the incident was the sUAS pilot's incomplete knowledge of the regulations and safe operating practices.NTSB WPR17LA209Accident · No injuriesLimited investigationFinal reportTrudel GP 4 · Reno, NVThe other pilot's failure to maintain clearance from the airplane during the line-abreast formation.NTSB ERA17FA143Accident · 2 fatalField investigationFinal reportCessna 170B · Edgewater, FLThe Cessna pilot's failure to maintain clearance from the Grumman during the transition to a different formation. Contributing to the accident was the stepped down configuration of the formation flight which was composed of dissimilar aircraft.NTSB CEN17FA063Accident · 3 fatalField investigationFinal reportPiper PA28R · McKinney, TXThe other pilot's use of an alternate traffic pattern entry procedure, which resulted in his inability to see and avoid the airplane, which was flying the preferred traffic pattern, and the subsequent midair collision.NTSB ERA17FA027Accident · 1 fatalField investigationFinal reportNanchang CJ6 · Blackshear, GAThe Bama 3 pilot's failure to properly conduct an overshoot maneuver and his premature climb before he was clear of the lead airplane, Bama 1, which lead to a midair collisionNTSB ERA16FA324Accident · 3 fatalField investigationFinal reportCessna 120 · North Collins, NYThe failure of the second airplane's pilot to see and avoid the first airplane as he was overtaking the first airplane.NTSB ERA16FA312Accident · 3 fatalField investigationFinal reportBeech F33 · Carrollton, GAThe failure of the Beech pilot to see and avoid the Diamond that was in front of and below his airplane on final approach and his use of an incorrect radio communication frequency for the airport.NTSB ANC16FA061Accident · 5 fatalField investigationFinal reportCessna 208 · Russian Mission, AKThe failure of both pilots to see and avoid each other while in level cruise flight, which resulted in a midair collision.NTSB ANC16FA052Accident · Minor injuriesField investigationFinal reportCessna 210-5 · Wasilla, AKThe failure of both pilots to see and avoid each other while landing at a non-tower-controlled airport, which resulted in a midair collision. Contributing to the accident was the absence of radio calls from the Cessna during the traffic pattern preceding the…NTSB WPR16FA148Accident · 1 fatalField investigationFinal reportAir Tractor AT 502B · Zamora, CAThe failure of both pilots to maintain an adequate visual lookout, which resulted in a midair collision. Also causal was the other pilot's use of two sedating antihistamines and two impairing medication and the effect of sun glare on his visual lookout, which…NTSB WPR16LA146Accident · No injuriesLimited investigationFinal reportCessna 172 · Emmett, IDThe failure of both pilots to see and avoid each other during cruise flight, which resulted in a midair collision.NTSB WPR16FA065Accident · 3 fatalField investigationFinal reportBeech M35 · San Pedro, CAThe failure of the pilots of both airplanes to see and avoid each other as they converged nearly head-on, which resulted in a midair collision. Contributing to the accident was sun glare on the pilot.NTSB WPR16LA016Accident · No injuriesLimited investigationFinal reportCessna 310C · Primm, NVThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision. Contributing to the accident was the pilots' failure to tune to, monitor, and communicate over the common traffic advisory frequency their relative positions…NTSB WPR15MA243Accident · 5 fatalMajor investigationFinal reportCessna 172M · San Diego, CAThe local controller's (LC) failure to properly identify the aircraft in the pattern and to ensure control instructions provided to the intended Cessna on downwind were being performed before turning Eagle1 into its path for landing. Contributing to the LC's…NTSB ERA15MA259Accident · 2 fatalClass 2 · MajorFinal reportCessna 150M · Moncks Corner, SCThe approach controller's failure to provide an appropriate resolution to the conflict between the F-16 and the Cessna. Contributing to the accident were the inherent limitations of the see-and-avoid concept, resulting in both pilots' inability to take…NTSB GAA15CA157Accident · Minor injuriesData collectionFinal reportBalloon Works FIREFLY8 - 24 · Provo, UT**This report was modified on 4/21/2016. Please see the public docket for this accident for more information.** The failure of the Balony balloon pilot to see and avoid the Balloon Works balloon during an ascent, which resulted in the basket of the Balony…NTSB ANC15LA033Accident · Serious injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe other pilot’s failure to maintain an adequate visual lookout, which resulted in a midair collision. Contributing to the accident was the other pilot’s failure to follow Federal Aviation Administration-recommended traffic pattern procedures.NTSB ERA15LA172Accident · No injuriesClass 3 · LimitedFinal reportMerian Richard F RV 8 · Tuscaloosa, ALThe RV-8 pilot's failure to maintain adequate clearance from the RV-6 while maneuvering during an air show, which resulted in a midair collision.NTSB ANC15FA009Accident · Serious injuriesField investigationFinal reportPiper PA 18 · Wasilla, AKBoth pilots’ inadequate visual lookout and failure to see and avoid each other while in level cruise flight, which resulted in a midair collision. Contributing to the accident was the obscuration of the other pilot’s visibility due to sun glare.NTSB ERA15LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · West Palm Beach, FLThe failure of the airplane pilots to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident was the failure of the airplane pilots to announce their intentions before…NTSB ERA15LA084Accident · Serious injuriesLimited investigationFinal reportAerotek Pitts Special S-1S · Westminster, MDThe pilot’s failure to see and avoid the other airplane, which resulted in a midair collision while both airplanes were on final approach to land.NTSB ERA15FA025Accident · 3 fatalField investigationFinal reportCirrus Design SR22 · Frederick, MDThe failure of the helicopter pilots and the airplane pilot to maintain an adequate visual lookout for known traffic in the traffic pattern, which resulted in a midair collision. Contributing to the accident were the airplane pilot's descent below the…NTSB WPR15FA010Accident · 2 fatalField investigationFinal reportCessna 170B · Yerington, NVThe failure of the Savannah pilot to maintain awareness of the position of the Cessna while attempting a join up maneuver. Contributing to the accident was the impaired decision-making of the Savannah's pilot due to the combined effects of licit and illicit…NTSB ERA14FA459Accident · 2 fatalField investigationFinal reportCessna 172M · Lancaster, NYThe other airplane pilot’s failure to maintain an adequate visual lookout for known traffic in the fly-in event traffic pattern, which resulted in a midair collision.NTSB WPR14FA283Accident · 1 fatalField investigationFinal reportAmerican Champion 7GCBC · Landmark, IDThe failure of the overtaking airplane’s pilot to maintain visual contact and separation from the airplane being overtaken.NTSB WPR14FA174Accident · 1 fatalField investigationFinal reportCessna 210E · Richmond, CABoth pilots’ failure to maintain adequate clearance from each other during cruise flight while in visual contact with each other. Contributing to the accident was the unexpected abrupt maneuver made by the other pilot.NTSB ERA14LA181Accident · No injuriesLimited investigationFinal reportVans RV-12 · Bayport, NYThe failure of both pilots to see and avoid each other, which resulted in a collision.NTSB CEN14LA036Accident · Minor injuriesLimited investigationFinal reportCessna 182L · Superior, WIThe failure of the pilot who was flying the trail airplane to maintain separation from the lead airplane. Contributing to the accident was the inadequate pilot training for formation skydiving operations.NTSB CEN13LA506Accident · Serious injuriesLimited investigationFinal reportBuckeye Breeze · Franklin, ILThe failure of both pilots, one of whom was noncertificated, to maintain adequate visual lookout while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the pilots’ inadequate communication about their intended…NTSB WPR13FA296Accident · 1 fatalField investigationFinal reportPiper PA-22-135 · Yellow Pine, IDThe pilot's failure to see and avoid the airplane ahead of his position in the airport traffic pattern, which resulted in a midair collision while both airplanes were on approach to land. Contributing to the accident was both pilots’ failure to adequately…NTSB WPR13LA270Accident · No injuriesLimited investigationFinal reportAero Vodochody L39C · Reno, NVThe other pilot’s failure to see and avoid the airplane during an air race training session, which resulted in a midair collision.NTSB WPR13FA254Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Anthem, AZThe failure of the pilots in both aircraft to maintain adequate visual lookout in a known training area where multiple aircraft frequently operated, which resulted in a midair collision.NTSB WPR13FA211Accident · 2 fatalClass 3 · FieldFinal reportCessna 172RG · Calabasas, CAThe failure of the pilots in both aircraft to maintain an adequate visual lookout, which resulted in a midair collision.NTSB CEN13LA149Accident · Minor injuriesLimited investigationFinal reportCirrus Design SR22 · College Station, TXThe flight instructor’s and commercial pilot’s failure to see and avoid the other airplane, which resulted in a collision during cruise flight. Contributing to the accident was the failure of the flight instructor to activate the transponder before departure,…NTSB ERA13LA054Accident · No injuriesLimited investigationFinal reportVans RV-12 · Williamson, GAThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision.NTSB ERA13LA022Accident · No injuriesLimited investigationFinal reportHughes/Helicopter Assocs 369A · West Chester, PAThe pilot’s failure to see and avoid the preceding helicopter while maneuvering for landing. Contributing to the accident were the flight lead pilot’s inadequate preflight briefing and in-flight instruction to the formation pilots, which resulted in the loss…NTSB WPR13LA004Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chandler, AZThe failure of both flight instructors to see and avoid the other airplane while providing instrument flight training, which resulted in a midair collision.