NTSB investigations
197 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.\"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."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 ERA12WA089Accident · 2 fatalForeign investigationPiper PA-28-236 · Mercedes, ArgentinaOn November 21, 2011, about 1320 coordinated universal time, a Piper PA-28-236, Argentine Air Force designation PF-449, and a Cessna 152, Argentine registration LV-OOF, collided while on approach to Mercedes Airfield (MRD), Mercedes, Buenos Aires Province,…NTSB WPR12FA020Accident · 1 fatalField investigationFinal reportPiper PA-44-180 · St. Paul, ORThe pilot was unable to see the other aircraft to avoid a collision.NTSB WPR12CA005Accident · No injuriesData collectionFinal reportCombs Dale B RV-4 · Madera, CAThe third airplane pilot’s failure to maintain visual contact with the second airplane during the formation flight.NTSB ANC11FA091Accident · 1 fatalField investigationFinal reportCessna 208B · Nightmute, AKThe failure of the pilot of the other airplane to maintain adequate clearance while performing an unexpected and unannounced abrupt maneuver, resulting in a midair collision between the two airplanes.NTSB ERA11FA468Accident · 1 fatalField investigationFinal reportMitchell David N Lancair IV P · Hammonton, NJThe Lancair pilot's failure to see and avoid the aerobatic airplane. Contributing to the accident was the Lancair pilot's inadequate use of collision avoidance strategies while inbound to an area of known potential aerobatic activity.NTSB CEN11LA573Accident · 1 fatalLimited investigationFinal reportStevens R P/Mccright D W Vans RV-6 · Conroe, TXThe failure of the pilot of the RV-6 airplane to maintain clearance from the RV-8 airplane while practicing formation flight.NTSB ANC11FA071Accident · 4 fatalField investigationFinal reportCessna U206G · Talkeetna, AKThe inadequate visual lookout and failure to see and avoid by the pilots of both airplanes while maneuvering to land, which resulted in a midair collision. Contributing to the accident was the lack of standardized, unequivocal procedures concerning common…NTSB ANC11FA062Accident · No injuriesField investigationFinal reportCessna U206 · Port Alsworth, AKThe pilot’s failure to see and avoid the approaching airplane. Contributing to the accident was that the pilot’s failure to listen to radio position reports from the other airplane on the common traffic advisory frequency and the absence of any forward-facing…NTSB CEN11WA458Accident · 1 fatalForeign investigationVans RV6 · Shoreham, United KingdomOn July 4, 2011, at 1528 Universal Coordinated Time (UTC), a Vans RV-6A single-engine airplane, G-RVCG, and a Diamond DA-40 single-engine airplane, G-CEZR, collided in midair while maneuvering near Shoreham, West Sussex, United Kingdom. G-RVGC was destroyed…NTSB ERA11FA291Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · New Hampton, NYThe PA24 pilot’s failure to maintain adequate clearance from the PA28, resulting in an in-flight collision. Contributing to the accident was the PA24 pilot's decision to overtake the PA28.NTSB CEN11LA296Accident · Serious injuriesLimited investigationFinal reportAir Tractor AT-802A · New Madrid, MOThe failure of both pilots to see and avoid the other airplane, which resulted in a midair collision.NTSB ERA11FA101Accident · 2 fatalField investigationFinal reportCessna 172H · Weyers Cave, VAThe inherent limitations of the see-and-avoid concept, which made it difficult for the helicopter pilot to see the airplane before the collision. Contributing to the accident was the airplane pilot’s non-standard entry to the airport traffic pattern, which,…NTSB WPR11LA068Accident · No injuriesLimited investigationFinal reportTaylorcraft BC-65 · Madras, ORThe failure of both pilots to see and avoid the other airplane while in the traffic pattern to land, which resulted in a midair collision.NTSB WPR11LA017Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons 90A · Cottonwood, AZThe paraglider pilot's failure to see and avoid the hot air balloon, which resulted in a midair collision.NTSB ANC10LA094Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Dillingham, AKBoth pilots’ failure to see and avoid each other during initial climb, resulting in a midair collision. Contributing to the accident was the pilot of N9699P’s inability to use his airplane's radio for air traffic advisories.NTSB CEN10WA538Accident · 2 fatalForeign investigationMooney M20J · Ryde, United KingdomOn September 4, 2010, approximately 1600 Universal Coordinated Time (UTC), a Mooney M20J single-engine airplane, G-JAST, and a Vans RV-4 single-engine airplane, G-MARX, collided in midair while maneuvering near Ryde, Isle of Wight, United Kingdom. G-JAST was…NTSB CEN10LA459Accident · 1 fatalLimited investigationFinal reportSchempp-Hirth VENTUS-2B · Batesville, TXBoth glider pilots' inability to see and avoid the other resulting in a mid-air collision.NTSB CEN10IA447Incident · No injuriesIncident investigationFinal reportPiper PA-32R-301 · Ripon, WIThe inability of either pilot to see the other airplane due to the blind spot created by their respective airplane's wings.NTSB WPR10LA294Accident · No injuriesLimited investigationFinal reportSchleicher Alexander ASH 26 E · Parowan, UTThe pilot's failure to see and avoid the other glider climbing in the same thermal.NTSB ERA10FA180Accident · 3 fatalField investigationFinal reportPiper PA-32R-300 · Williston, FLThe pilots of both airplanes did not maintain an adequate visual lookout to see and avoid each other.NTSB CEN10FA115Accident · 3 fatalField investigationFinal reportPiper PA-25-235 · Boulder, COThe failure of both pilots to see and avoid the other resulting in a midair collision. Contributing to the accident was the lack of perceived visual relative motion of the Piper and the Cirrus to the pilot of each airplane, the terrain background, and the…NTSB CEN10LA099Accident · 2 fatalLimited investigationFinal reportBuckeye DM · Sublette, KSThe failure of both pilots to see and avoid the other aircraft, which resulted in a midair collision while maneuvering at low altitude.NTSB WPR10FA068Accident · 2 fatalField investigationFinal reportSchleicher ASW-27 · Middletown, CAThe failure of both pilots to see and avoid the other airplane. Contributing to the accident was the pilot's failure to yield right of way to the glider.NTSB CEN10FA011Accident · 2 fatalField investigationFinal reportCessna 150F · Alexandria, LAFailure of the wingman to maintain proper separation from the lead airplane during formation maneuvers. Contributing to the accident was lead's abrupt right bank and both pilots' lack of formation training.NTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.NTSB CEN09WA582Accident · 2 fatalForeign investigationReims F172 · Commune de Brethencourt, FranceUnder the jurisdiction and control of the French government.NTSB CEN09LA555Accident · 1 fatalLimited investigationFinal reportDestiny Powered Parachutes Destiny 2000 · Arcanum, OHThe failure of pilot to maintain an adequate visual lookout in order to avoid the collision with an aircraft on final approach to land.NTSB ERA09MA447Accident · 9 fatalClass 1 · MajorFinal reportPiper PA-32R-300 · Hoboken, NJ(1) the inherent limitations of the see-and-avoid concept, which made it difficult for the airplane pilot to see the helicopter until the final seconds before the collision, and (2) the Teterboro Airport local controller’s nonpertinent telephone conversation,…NTSB CEN09LA491Accident · Minor injuriesLimited investigationFinal reportCessna 182J · Iowa Falls, IABoth pilots' failure to execute adequate visual lookout, resulting in the two airplanes colliding over the runway.NTSB ERA09LA302Accident · 1 fatalLimited investigationFinal reportHazelwood Michael S RV-8 · Decatur, ALThe RV-8 pilot's failure to maintain adequate clearance from the CJ-6A while maneuvering. This report was modified on September 10, 2010.NTSB WPR09FA248Accident · 3 fatalField investigationFinal reportCessna 172N · Long Beach, CAThe failure of both pilots to see and avoid each other's aircraft.NTSB WPR09LA228Accident · Serious injuriesLimited investigationFinal reportAyres S2R-T34 · Marysville, CAThe failure of both pilots to see and avoid the other airplane while making their final approach for landing.NTSB CEN09IA161Incident · No injuriesIncident investigationFinal reportPiper PA28 · Fairmont, NEBoth pilots' failure to see and avoid the other aircraft.NTSB CEN09LA149Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Cypress, TXBoth pilot's failure to see and avoid the other aircraft.NTSB ERA09FA080Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · Ft. Lauderdale, FLThe failure of both pilots to see and avoid the other aircraft.NTSB ERA09LA067Accident · No injuriesLimited investigationFinal reportBeech V35 · Winter Haven, FLBoth pilots’ failure to see and avoid the other airplane. Contributing to the accident was the Beech pilot’s failure to monitor or utilize the common traffic advisory frequency.NTSB ANC09LA011Accident · No injuriesLimited investigationFinal reportCessna 152 · Fairbanks, AKThe failure of the instructor pilot in the other airplane to maintain separation from the Cessna 182R, and his failure to follow the tower controller’s instructions.NTSB ERA09LA033Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Plymouth, NCThe Piper Dakota (PA-28-236) pilot's failure to see and avoid the Piper Cherokee (PA-32-260).NTSB CEN09LA031Accident · No injuriesLimited investigationFinal reportCessna 180 · Whitewater, COBoth pilots' failure to see and avoid the other airplane. Contributing factors in this accident were the Cessna 180 pilot's attention being diverted and the Cessna 210 pilot's vision being affected by the sun glare.NTSB LAX08FA265Accident · 3 fatalField investigationFinal reportCessna R172K · Rock Springs, WYThe failure of both pilots to see and avoid each other's aircraft.NTSB DEN08LA137Accident · Serious injuriesLimited investigationFinal reportSchempp-Hirth Ventus 2A · Brackettville, TXThe failure of the pilot of N777UN to exit the thermal upon losing visual contact with the other gliders, resulting in a midair collision.NTSB LAX08LA254Accident · No injuriesLimited investigationFinal reportSchweizer SGS 2-33A · Jean, NVThe failure of both pilots to see and avoid the other aircraft while maneuvering over the airport.NTSB DEN08MA116Accident · 7 fatalMajor investigationFinal reportBell 407 · Flagstaff, AZBoth helicopter pilots’ failure to see and avoid the other helicopter on approach to the helipad. Contributing to the accident were the failure of N407GA’s pilot to follow flight arrival route guidelines, and the failure of N407MJ’s pilot to follow…NTSB SEA08FA116Accident · 3 fatalField investigationFinal reportCessna 172N · McCall, IDThe failure of the pilot to maintain adequate visual lookout and clearance from another airplane while attempting to land on the same runway. Contributing to the accident was the non-standard pattern entry of the pilot.NTSB DFW08LA089Accident · No injuriesLimited investigationFinal reportPiper PA24-260 · Abbeville, LAThe failure of both pilots to see and avoid the other approaching airplane. A contributing factor was the close proximity between the two private airstrips.NTSB LAX08FA049Accident · 5 fatalField investigationFinal reportCessna 172N · Corona, CAThe failure of both pilots to see and avoid the other airplane.NTSB SEA08LA057Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Sonoma, CAThe departing pilot's inadequate visual lookout.