Fatal NTSB investigations, MN

8 cases where the first occurrence was “Loss of engine power(total) - nonmechanical”.

Cases per year

19852026
Fatal NTSB investigations, MN per year, 1985–2026: 8 cases
19851
19861
19881
19902
19911
19921
20001

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\" = 353)
  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 CHI00FA180Accident · 1 fatalField investigationFinal reportCessna 152 · Brownton, MNIn flight collision with the terrain for undetermined reason.Jul 2, 2000 · N757SL · DestroyedNTSB CHI93LA037Accident · 1 fatalLimited investigationFinal reportCessna 172 · Elk River, MNFailure of the pilot to refuel the airplane before the flight.Nov 17, 1992 · N7463A · Substantial damageNTSB CHI91FA116Accident · 1 fatalField investigationFinal reportMooney M-20C · Prior Lake, MNFailure to maintain airspeed while executing a forced landing. Factors related to the accident were the pilot's improper inflight planning/decision, and fuel exhaustion.Mar 26, 1991 · N9692M · DestroyedNTSB CHI90FA252Accident · 1 fatalField investigationFinal reportCessna 172N · Pine City, MNThe pilot's misjudgement of the fuel supply, and his failure to maintain adequate airspeed. A factor was the pilot's lack of experience in the make and model of aircraft.Sep 2, 1990 · N733CH · DestroyedNTSB CHI90FA250Accident · 1 fatalField investigationFinal reportBeech A23A · St Paul, MNImproper planning/decision by the pilot, which resulted in fuel exhaustion, due to an inadequate supply of fuel, and failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall/spin.Aug 30, 1990 · N8871M · Substantial damageNTSB CHI88DER07Accident · 2 fatalFinal reportChampion 7CCM · Int'L Falls, MNThere were no eyewitnesses to this accident. The aircraft with an instructor and student aboard was reported missing. When located the seaplane had descended into a wooded swamp and the aircraft was substantially damaged and both occupants received fatal…Aug 6, 1988 · N1744E · DestroyedNTSB CHI87FA015Accident · 1 fatalField investigationFinal reportSikorsky S-58ET · Becker, MNThe helicopter (hel) was being used on an external load opn to psn a 2500 lb ventilator to the roof of a bldg. On the next to last load, the plt radioed that he noted a momentary illumination of the fuel bypass advisory light. He elected to cont the opn &…Nov 4, 1986 · N4247S · Substantial damageNTSB CHI85FA269Accident · 2 fatalField investigationFinal reportChamberlain Viking Dragonfly · Faribault, MNThe acft collided with trees and burst into flames during a forced landing. On the plt's second radio contact with Faribault municipal airport UNICOM he declared, 'I have engine failure. I'm going down in a corn field.' Post accident inspection of the…Jul 7, 1985 · N59BC · Destroyed