Final NTSB investigations, 2014

7 cases where the sequence of events included Midair collision.

Cases per year

20082026
Final NTSB investigations, 2014 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\") = 2014
    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 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.Dec 27, 2014 · N49294 · 2 aircraft · Substantial damageNTSB 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…Oct 23, 2014 · N122ES · 2 aircraft · Substantial damageNTSB 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…Oct 12, 2014 · N3558C · 2 aircraft · DestroyedNTSB 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.Sep 27, 2014 · N9679H · 2 aircraft · DestroyedNTSB 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.Jul 7, 2014 · N162CG · 2 aircraft · Substantial damageNTSB 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.Apr 27, 2014 · N4962U · 2 aircraft · DestroyedNTSB ERA14LA181Accident · No injuriesLimited investigationFinal reportVans RV-12 · Bayport, NYThe failure of both pilots to see and avoid each other, which resulted in a collision.Apr 3, 2014 · N409FM · 2 aircraft · Minor damage