Final NTSB investigations, 2009

11 cases where the sequence of events included Midair collision.

Cases per year

20082026
Final NTSB investigations, 2009 per year, 2008–2026: 149 cases
200813
200911
201010
20119
20129
20137
20147
20158
20169
20176
20189
20198
20209
20216
20227
20237
202410
20253
20261

Latest cases

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 year(c.\"eventDate\") = 2009
    AND 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.

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.Nov 28, 2009 · N127AL · 2 aircraft · Substantial damageNTSB 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.Oct 10, 2009 · N8642S · 2 aircraft · Substantial damageNTSB WPR09FA437Accident · 1 fatalField investigationFinal reportCessna 152 · Coolidge, AZThe failure of both safety/spotter pilots to see and avoid the other airplane.Sep 9, 2009 · N94741 · 2 aircraft · Substantial damageNTSB 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.Aug 25, 2009 · N5604B · 2 aircraft · Substantial damageNTSB 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,…Aug 8, 2009 · N71MC · 2 aircraft · Substantial damageNTSB 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.Jul 31, 2009 · N989TP · 2 aircraft · Substantial damageNTSB 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.May 23, 2009 · N875MH · 2 aircraft · Substantial damageNTSB WPR09FA248Accident · 3 fatalField investigationFinal reportCessna 172N · Long Beach, CAThe failure of both pilots to see and avoid each other's aircraft.May 19, 2009 · N738NN · 2 aircraft · Substantial damageNTSB 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.May 6, 2009 · N40208 · 2 aircraft · Substantial damageNTSB CEN09IA161Incident · No injuriesIncident investigationFinal reportPiper PA28 · Fairmont, NEBoth pilots' failure to see and avoid the other aircraft.Feb 7, 2009 · N55502 · 2 aircraft · Minor damageNTSB CEN09LA149Accident · No injuriesLimited investigationFinal reportNorth American T-6G · Cypress, TXBoth pilot's failure to see and avoid the other aircraft.Jan 31, 2009 · N51KT · 2 aircraft · Minor damage