Fatal NTSB investigations, 2000, 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, 2000, 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\") = 2000
    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.