Fatal NTSB investigations, 2000, MN

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, MN per year, 1964–2026: 391 cases
19648
19659
196613
19677
19689
19699
19706
197111
19729
19739
197413
197510
19767
19776
197810
19797
19809
198111
19828
19837
19847
198510
19868
198711
19889
19898
19906
19916
19924
19935
19946
19954
19965
19975
19984
19996
20008
20014
20025
200312
20047
20053
20062
20074
20082
20093
20104
20112
20124
20136
20144
20152
20163
20174
20182
20193
20205
20212
20223
20237
20241
20254
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\") = 2000
    AND c.\"eventStateOrRegion\" = 'MN' 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 CHI00FA214Accident · 1 fatalField investigationFinal reportPiper PA-23 · Dodge Center, MNThe pilot not maintaining airplane control in his turn back in the direction of the airport and the pilot not performing an emergency landing straight ahead. Factors were the water and debris contamination found in the fuel screens and carburetor bowl and the…Jul 22, 2000 · N1069P · DestroyedNTSB CHI00FA185Accident · 3 fatalField investigationFinal reportPiper PA-30 · Duluth, MNloss of control in flight for undetermined reason(s).Jul 8, 2000 · N7213Y · DestroyedNTSB CHI00FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Brownton, MNIn flight collision with the terrain for undetermined reason.Jul 2, 2000 · N757SL · DestroyedNTSB CHI00LA179Accident · 1 fatalLimited investigationFinal reportNorton Volksplane VP-1 · Waconia, MNthe inadvertent stall by the pilot. The low attitude at the time of the stall was a contributing factor.Jul 1, 2000 · N256DN · DestroyedNTSB CHI00FA170Accident · 1 fatalField investigationFinal reportAeronca 7AC · Lakeville, MNthe pilot not maintaining aircraft control and the stall/spin she encountered during the approach on base to final. A factor was the pilot passenger not detecting the remedial action needed to correct the aircraft's nose up attitude during the approach.Jun 24, 2000 · N81681 · Substantial damageNTSB CHI00FA107Accident · 1 fatalField investigationFinal reportAeronca 7AC · Embarrass, MNthe inadvertent stall/spin the pilot encountered. A factor was the wind gusts.Apr 8, 2000 · N84424 · DestroyedNTSB CHI00FA080Accident · 3 fatalField investigationFinal reportBeech 95-B55 · Moorhead, MNthe pilot's failure to maintain aircraft control during the missed approach. Factors to the accident were, the pilot's improper decision to attempt the approach in weather conditions below the approach/landing minimums, the weather, the pilot's lack of…Feb 24, 2000 · N7736R · DestroyedNTSB CHI00LA072Accident · 1 fatalLimited investigationFinal reportCessna 180 · Tower, MNthe passenger not maintaining clearance from the rotating propeller.Feb 20, 2000 · N6545A · No damage