Fatal NTSB investigations, MN

14 cases where the first occurrence was “In flight collision with object”.

Cases per year

19822026
Fatal NTSB investigations, MN per year, 1982–2026: 14 cases
19822
19831
19851
19892
19901
19931
19941
19991
20032
20041
20071

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\" = 220)
  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 CHI08FA027Accident · 2 fatalField investigationFinal reportPiper PA-44-180 · Browerville, MNAn in-flight collision with at least one Canada goose, and the resulting damage to the left stabilator that caused the airplane to become uncontrollable. Contributing to the accident was the night lighting condition, which precluded any possibility of the…Oct 24, 2007 · N327ND · Substantial damageNTSB 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 CHI03FA296Accident · 2 fatalField investigationFinal reportBeech 58P · Grand Marais, MNThe continued descent below minimum descent altitude and the altitude/clearance not maintained by the pilot during approach to the airport. The low ceiling was a contributing factor.Aug 28, 2003 · N285V · DestroyedNTSB CHI03FA057Accident · 2 fatalField investigationFinal reportCirrus Design SR-22 · Hill City, MNSpatial disorientation experienced by the pilot, due to a lack of visual references, and a failure to maintain altitude. Contributing factors were the pilot's improper decision to attempt flight into marginal VFR conditions, his inadvertent flight into…Jan 18, 2003 · N9523P · DestroyedNTSB CHI99FA223Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Fertile, MNthe inadvertent stall. Factors relating to this accident were the instructor pilot maneuvering the airplane at very low altitude and the trees.Jul 9, 1999 · N7314P · DestroyedNTSB CHI95FA011Accident · 2 fatalField investigationFinal reportBeech 58 · Park Rapids, MNthe pilot-in-command's failure to obtain/maintain clearance. Factors were a dark night, low ceiling, high terrain, and weather service not used by the pilot-in-command.Oct 8, 1994 · N258CH · DestroyedNTSB CHI93LA134Accident · 1 fatalLimited investigationFinal reportCessna T188C · Belview, MNThe pilot-in-command's not maintaining proper altitude.Apr 10, 1993 · N2975J · DestroyedNTSB MKC90FA057Accident · 1 fatalField investigationFinal reportBeech B36TC · Inver Grove Hgt, MNPremature lift-off by the pilot, while taking off with a heavy gross weight in unfavorable winds, and the pilot's failure to attain/maintain adequate airspeed, which resulted in an inadvertent stall/mush.Mar 1, 1990 · N3077G · Substantial damageNTSB MKC90FA005Accident · 2 fatalField investigationFinal reportPiper PA-28 · Delavan, MNFailure of the pilot to maintain proper altitude during a low pass, and to see-and-avoid obstructions (inadequate visual lookout). Factors related to the accident were: the pilot's ostentatious display and the obstructions (powerlines).Oct 9, 1989 · N6340R · Substantial damageNTSB MKC89FA060Accident · 1 fatalField investigationFinal reportCessna 150K · Pemberton, MNPoor judgement on the part of the pilot in that he attempted a down wind take off without adequate distance to clear obstacles in his flight path.Feb 22, 1989 · N6010G · Substantial damageNTSB CHI85FA226Accident · 1 fatalField investigationFinal reportSchweizer G-164A · Red Lake Falls, MNThe plt had been spray a field in north & south directions, then elected to make a swath run from east to west toward the sun. This pass was made late in the day. While on the swath run, the acft collided with an unmarked wire, then veered & crashed in a…Jun 8, 1985 · N6761Q · DestroyedNTSB CHI83FA393Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Graceville, MNWhile spraying a field adjacent to a house the acft struck a guy wire which had been strung between a 82 ft tower on the house & a 28 ft pole supported by wires.Aug 26, 1983 · N6253Z · DestroyedNTSB CHI82FA231Accident · 2 fatalField investigationFinal reportCessna 150J · New York Mills, MNThe acft took off from a 2,500 ft alfalfa field which initially sloped downward then upward near the point of lift-off. A witness stated the acft did not appear to climb. The acft collided with 40 ft high power lines approximately 1000 ft from the point of…Jul 3, 1982 · N61330 · Substantial damageNTSB CHI82FA174Accident · 1 fatalField investigationFinal reportCessna A188 · Blue Earth, MNThe flagman stated that during the swath run the acft was following the contour of the field. The flagman thought the plt was getting close to the end of the field & was about to call him on the radio when the acft pulled up to about a 45 deg nose high…May 19, 1982 · N9819V · Destroyed