Fatal NTSB investigations, 2012, NE

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.

Cases per year

19642026
Fatal NTSB investigations, 2012, NE per year, 1964–2026: 255 cases
196410
19657
19668
19673
19686
19698
19706
19716
19728
19738
19743
19758
19768
19776
19789
19793
19803
19813
19825
19834
19847
19855
19867
19877
19881
19898
19903
19913
19924
19936
19946
19953
19963
19972
19982
19993
20002
20011
20022
20031
20043
20053
20061
20072
20082
20092
20103
20112
20125
20132
20141
20152
20164
20172
20183
20191
20201
20213
20223
20234
20244
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\") = 2012
    AND c.\"eventStateOrRegion\" = 'NE' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
  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 CEN13FA081Accident · 1 fatalField investigationFinal reportErcoupe 415-C · Blair, NEThe pilot's loss of control due to physical incapacitation.Nov 29, 2012 · N720RC · Substantial damageNTSB CEN13FA045Accident · 1 fatalField investigationFinal reportCessna 150F · Gothenburg, NEThe student pilot’s failure to maintain adequate airspeed on final approach, which resulted in an inadvertent aerodynamic stall and subsequent impact with terrain.Nov 4, 2012 · N8375G · Substantial damageNTSB CEN12FA517Accident · 1 fatalField investigationFinal reportBellanca 7GCBC · Imperial, NEThe pilot’s failure to maintain adequate clearance from rising terrain while flying toward the rising sun, which interfered with his ability to see the terrain.Aug 4, 2012 · N36286 · Substantial damageNTSB CEN12LA488Accident · 1 fatalLimited investigationFinal reportJoseph C. Andrews, Jr. Vans · Valentine, NEThe RV-6 pilot's failure to monitor the location of the RV-4, resulting in the on-ground collision. Contributing to the accident was the RV-6 pilot not ensuring proper separation from the RV-4 and his expectation that the pilot of RV-4 would roll out to the…Jul 27, 2012 · N122JA · 2 aircraft · Substantial damageNTSB CEN12FA210Accident · 1 fatalField investigationFinal reportBeech E-55 · Broken Bow, NEThe pilot’s failure to maintain airspeed and subsequent loss of airplane control during a single-engine landing approach. Contributing to the accident was the pilot's improper fuel management during cruise flight, which resulted in an initial loss of power in…Mar 28, 2012 · N1567W · Substantial damage