Fatal NTSB investigations, MN
14 cases where the first occurrence was “In flight collision with object”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1999 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2007 | 1 |
Where
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.
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
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
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…NTSB 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.NTSB 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.NTSB 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…NTSB 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.NTSB 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.NTSB CHI93LA134Accident · 1 fatalLimited investigationFinal reportCessna T188C · Belview, MNThe pilot-in-command's not maintaining proper altitude.NTSB 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.NTSB 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).NTSB 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.NTSB 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…NTSB 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.NTSB 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…NTSB 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…