Fatal NTSB investigations, MN

17 cases where the first occurrence was “In flight collision with terrain/water”.

Cases per year

19822026
Fatal NTSB investigations, MN per year, 1982–2026: 17 cases
19821
19831
19851
19861
19871
19881
19901
19912
19932
19941
19991
20021
20032
20041

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 c.\"eventStateOrRegion\" = 'MN' AND c.\"eventCountry\" = 'USA'
    AND c.\"highestInjuryLevel\" = 'Fatal'
    AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 230)
  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 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 CHI04LA007Accident · 1 fatalLimited investigationFinal reportAviat Pitts S-2B · Cromwell, MNThe altitude/clearance not maintained by the pilot while performing aerobatic maneuvers. Contributing factors were the planning/decision to perform an aerobatic maneuver at a low altitude.Oct 10, 2003 · N68PS · DestroyedNTSB CHI03FA219Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · Jackson, MNThe pilot's intentional flight into terrain as an act of suicide.Jul 21, 2003 · N33774 · DestroyedNTSB CHI03LA036Accident · 2 fatalLimited investigationFinal reportNorth American T-28B · Glenwood, MNThe altitude/clearance not maintained by the pilot-in-command. The low altitude maneuvering by the pilot-in-command was a contributing factor.Dec 10, 2002 · N114DH · DestroyedNTSB CHI00FA020Accident · 2 fatalField investigationFinal reportBell 206B · Cottage Grove, MNUndetermined.Nov 1, 1999 · N565KS · DestroyedNTSB BFO94FA103Accident · 3 fatalField investigationFinal reportBeech A-36 · Brainerd, MNThe pilot's failure to follow the published missed approach procedure, and his failure to obtain and/or maintain adequate altitude to avoid collision with the terrain. Factors in the accident were: the pilot's lack of instrument flying experience, and the…Jun 17, 1994 · N1525G · DestroyedNTSB DCA94MA022Accident · 18 fatalClass 1 · MajorFinal reportJetstream BA-3100 · Hibbing, MNThe captain's actions that led to a breakdown in crew coordination and the loss of altitude awareness by the flightcrew during an unstabilized approach in night instrument meteorological conditions. Contributing to the accident were: the failure of the…Dec 2, 1993 · N334PX · DestroyedNTSB CHI93DER01Accident · 1 fatalFinal reportPitts S1 · Madison, MNThe pilot's failure to maintain adequate terrain clearance during aerobatic maneuvers.May 12, 1993 · N17FS · DestroyedNTSB CHI91DER08Accident · 1 fatalFinal reportBellanca 8GCBC · St. Hilaire, MNThe pilot's failure to maintain sufficient altitude while maneuvering.Jun 28, 1991 · N8714V · DestroyedNTSB CHI91FA108Accident · 4 fatalField investigationFinal reportPiper PA-30 · Thief River Fls, MNImproper IFR procedure of the pilot, while intercepting the ILS localizer, by not maintianing the minimum descent altitude (mda) for that segment of the approach.Mar 18, 1991 · N8290Y · DestroyedNTSB CHI90DER02Accident · 2 fatalFinal reportNorth American P-51D · Mayer, MNUndeterminedJul 18, 1990 · N512ED · DestroyedNTSB CHI88FA092Accident · 1 fatalField investigationFinal reportCessna 207 · Hardwick, MNWitnesses observed the aircraft for aprx 8 minutes in erratic diving, climbing, and steep-turning maneuvers which culminated in a 12 degree descent to the ground. The sound of the eng was heard throughout the sequence and other evidence indicated engine power…Apr 4, 1988 · N207CA · DestroyedNTSB CHI87FA083Accident · 4 fatalField investigationFinal reportCessna 172N · Fergus Falls, MNFollowing a 1.5 hour personal flight at night, the aircraft crashed into the side of a low hill near the destination airport. Although the pilot had a total of 6 hours of night time, most of his solo night time was during this last flight. Hazy VFR conditions…Feb 12, 1987 · N734MV · DestroyedNTSB CHI86FER13Accident · 1 fatalFinal reportBell 47G-5 · Elrosa, MNThe helicopter was seen flying at a low altitude by witnesses and appeared to be flying straight and level and sounded normal. The helicopter impacted the ground in a northeasterly direction, 180 degrees from it's observed flight path. There were no witnesses…Jul 7, 1986 · N94458 · DestroyedNTSB CHI85FA186Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Lakeville, MNThe acft was observed to enter a spin from aprx 3000 ft AGL. The acft continued the spin to ground contact which witnesses stated occurred as the acft seemed to level off. Witnesses also reported seeing the acft perform aerobatics, which included loops, prior…May 5, 1985 · N2475L · DestroyedNTSB CHI83FA407Accident · 2 fatalField investigationFinal reportCessna 152 · Anoka, MNThe plt rented the acft & reported that he & his friend would be going on a local flt. A witness stated that he saw the acft fly over at an estimated 1000 to 1500 ft AGL. Reportedly, the acft was in level flt when the plt 'cut' the power, the acft 'nosed up a…Sep 2, 1983 · N4975A · DestroyedNTSB CHI82FA206Accident · 1 fatalField investigationFinal reportMcclary Mong Sport · Cedar, MNWitnesses observed the acft enter a steep nose down attitude & slow spiral from which the acft did not recover.Jun 13, 1982 · N5099 · Destroyed