Fatal NTSB investigations, 2004, 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, 2004, 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\") = 2004
    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 CHI05FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Glenwood, MNThe pilot's failure to execute a missed approach and his failure to maintain sufficient altitude and clearance from terrain and obstructions. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his decision to delay descent…Dec 9, 2004 · N587C · Substantial damageNTSB CHI04FA284Accident · 1 fatalField investigationFinal reportCessna 182Q · Morris, MNThe pilot's inadequate weather evaluation that resulted flight into night instrument meteorological conditions and a subsequent loss of aircraft control. Factors to the accident were the pilot's lack of recent night experience and the low cloud ceiling at…Sep 27, 2004 · N735VY · DestroyedNTSB CHI04WA235Accident · 2 fatalForeign investigationChampion 7ECA · Angle Inlet, MNAug 23, 2004 · N11083 · DestroyedNTSB CHI04FA177Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Rochester, MNThe loss of control due to the student pilot's failure to maintain rotor RPM and the flight instructor's inadequate supervision.Jul 8, 2004 · N8118L · DestroyedNTSB CHI04FA133Accident · 4 fatalField investigationFinal reportCessna U206F · Owatonna, MNThe altitude/clearance not maintained by the pilot-in-command during a precision instrument approach. A contributing factor was the instrument meteorological conditions.Jun 2, 2004 · N81685 · DestroyedNTSB CHI04LA112Accident · 1 fatalLimited investigationFinal reportGrumman American AA-1B · Dodge Center, MNThe pilot's failure maintain climb and his failure to maintain clearance from the terrain during initial climb out after takeoff. The aircraft's low altitude, high gusty winds and low level turbulence were contributing factors.Apr 28, 2004 · N9919L · DestroyedNTSB CHI04FA055Accident · 2 fatalField investigationFinal reportCessna 182P · Baudette, MNThe pilot's intentional flight into adverse weather conditions, and his failure to maintain adequate terrain clearance. Contributing factors were the pilot's lack of an instrument rating, low ceiling, low altitude, and the dark night conditions.Jan 11, 2004 · N5787J · Destroyed