Fatal NTSB investigations, 2016

10 cases where the sequence of events included Midair collision.

Cases per year

20082026
Fatal NTSB investigations, 2016 per year, 2008–2026: 111 cases
20085
20098
20106
20118
20125
20133
20146
20157
201610
20173
20186
20196
20207
20213
20225
20235
20247
20258
20263

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\") = 2016
    AND c.\"highestInjuryLevel\" = 'Fatal'
    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 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.Dec 31, 2016 · N4407T · 2 aircraft · DestroyedNTSB CEN17WA052Accident · 1 fatalForeign investigationPZL Bielsko SZD51 · Husbands Bosworth, United KingdomOn December 4, 2016, about 1230 coordinated universal time, a PZL Bielsko SZD-51-1 glider, G-CSFT, and a Cessna 150L airplane, G-CSFC, collided in midair near Husbands Bosworth, Leicestershire, United Kingdom. The glider impacted terrain and the pilot was…Dec 4, 2016 · G-CSFT · 2 aircraft · DestroyedNTSB 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 collisionOct 21, 2016 · N10EB · 2 aircraft · Substantial damageNTSB 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.Sep 25, 2016 · N3580V · 2 aircraft · DestroyedNTSB CEN16WA377Accident · 4 fatalForeign investigationPiper PA28 · Gödöllo, Pest, Hungary, HungarySep 18, 2016 · HA-APZ · 2 aircraft · DestroyedNTSB ERA16WA317Accident · 2 fatalForeign investigationPiper PA28 · Flanders, ColombiaOn September 15, 2016, about 1523 universal coordinated time, a Piper PA-28-140; Colombian registration, HK1328G, operated by Aeroandes Flight Training School, and a Cessna 152; Columbian registration, HK2092G, operated by Acahel Flight Training School…Sep 15, 2016 · HK1328G · 2 aircraft · Substantial damageNTSB 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.Sep 7, 2016 · N6027K · 2 aircraft · Substantial damageNTSB 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.Aug 31, 2016 · N752RV · 2 aircraft · DestroyedNTSB 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…Jul 23, 2016 · N502WC · 2 aircraft · Substantial damageNTSB 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.Feb 5, 2016 · N9872R · 2 aircraft · Substantial damage