Fatal NTSB investigations, MN
36 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 2 |
| 2013 | 6 |
| 2014 | 4 |
| 2015 | 1 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 1 |
Where
Open the mapLatest 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 CEN24FA125Accident · 2 fatalClass 3 · FieldFinal reportGlobe GC-1B · Afton, MNThe pilot’s failure to maintain airplane control while maneuvering, which resulted in an aerodynamic stall and spin.NTSB CEN23LA324Accident · 1 fatalClass 3 · LimitedFinal reportAir Tractor AT-402B · Clara City, MNThe pilot’s failure to maintain clearance from a transmission line during an aerial application flight.NTSB ERA23FA130Accident · 1 fatalClass 3 · FieldFinal reportCirrus Design SR22 · Duluth, MNA rapid descent and subsequent collision with terrain for reasons that could not be determined based on the available evidence.NTSB ERA23FA001Accident · 3 fatalClass 3 · FieldFinal reportCessna 172S · Hermantown, MNThe pilot’s loss of airplane control due to spatial disorientation during initial climb in dark night and low instrument meteorological conditions, which resulted in a descent into terrain. Contributing to the accident was the pilot’s fatigue due to a long…NTSB ERA22FA387Accident · 2 fatalClass 3 · FieldFinal reportSea & Sky Krucker Cygnet · Emily, MNThe pilot’s operation of the weight-shift control aircraft over its design gross weight and his decision to take off with the engine operating at less than the specified takeoff rpm, which resulted in degraded takeoff and climb performance. Contributing to…NTSB CEN20LA374Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA28 · Walker, MNThe pilot’s impairment from the effects of an undiagnosed brain tumor.NTSB CEN20FA096Accident · 1 fatalClass 3 · FieldFinal reportBeech A36 · Rogers, MNInadequate maintenance that resulted in improper torque to the engine-driven fuel pump inlet fitting, which led to a loss of engine power and forced landing into unsuitable terrain.NTSB CEN19FA218Accident · 1 fatalField investigationFinal reportGIbb AR-1 · Hawley, MNAn in-flight loss of control and collision with terrain for reasons that could not be determined based on the available information.NTSB CEN19FA139Accident · 1 fatalClass 3 · FieldFinal reportMooney M20J · Moose Lake, MNThe pilot’s failure to maintain control of the airplane after departing into a snowstorm.NTSB CEN18FA297Accident · 1 fatalField investigationFinal reportAeronca 7AC · Alexandria, MNThe pilot's intentional low-altitude flight, which resulted in an impact with power lines.NTSB CEN18FA011Accident · 2 fatalField investigationFinal reportCessna 172M · Ramsey, MNThe pilot's decision to fly along the river at a low altitude contrary to applicable regulations and safety of flight considerations which resulted in the impact with the power lines. Contributing to the accident was the pilot's inability to see the and avoid…NTSB CEN18FA003Accident · 1 fatalField investigationFinal reportSchaffer Fisher Horizon 2 · Eden Prairie, MNAn inflight loss of control and collision with terrain for undetermined reasons after a thorough examination of the airplane's flight controls was unable to confirm control continuity. Contributing to the accident was the pilot's lack of experience in the…NTSB CEN17LA250Accident · 1 fatalLimited investigationFinal reportNorth American T-28A · Moorhead, MNControlled descent into terrain due to engine issues, the reason for which could not be determined because examination of the engine revealed no evidence of malfunctions or failures that would have precluded normal operation.NTSB CEN17FA012Accident · 2 fatalField investigationFinal reportFairchild Hiller FH 1100 · Lino Lakes, MNThe separation of the main rotor assembly due to mast bumping.NTSB CEN16LA326Accident · 1 fatalLimited investigationFinal reportThrush S2R T660 · Ruthton, MNThe pilot's failure to see and avoid the tower guy-wire during an agricultural spraying operation.NTSB CEN16LA175Accident · 1 fatalLimited investigationFinal reportAirborne Windsports PTY Edge X Classic · Rush City, MNThe student pilot's failure to maintain the appropriate pitch attitude during initial climb, which resulted in an aerodynamic stall. Contributing to the accident was the student pilot’s decision to conduct a solo flight without a solo endorsement in an…NTSB CEN15FA181Accident · 2 fatalField investigationFinal reportPiper J-4A · Pine River, MNThe pilot' failure to maintain adequate airspeed after takeoff, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot's decision to conduct the flight…NTSB CEN14LA485Accident · 2 fatalLimited investigationFinal reportCismowski Tierra II · Montevideo, MNThe pilot's impaired judgment due to the use of marijuana, which led to his improper decision to fly the airplane over its maximum gross weight and his subsequent loss of airplane control during takeoff with gusting wind conditions.NTSB CEN14FA306Accident · 2 fatalField investigationFinal reportBrumwell RV-6 · Sauk Rapids, MNThe pilot’s loss of pitch control due to the in-flight opening of the canopy during cruise flight for reasons that could not be determined because fire damage precluded examination of the airplane’s canopy and systems.NTSB CEN14FA278Accident · 1 fatalField investigationFinal reportHermann Bjorn Lancair IV · Duluth, MNThe pilot's failure to maintain airplane control while operating in instrument flight rules (IFR) conditions, which was due to spatial disorientation resulting from erroneous heading and bank angle information shown on the primary flight display. Contributing…NTSB CEN14LA418Accident · 1 fatalLimited investigationFinal reportTexas Helicopter OH 13H/M74A · Little Falls, MNThe pilot's failure to maintain clearance from a tree at the edge of a field that he was spraying.NTSB CEN14FA034Accident · 3 fatalField investigationFinal reportPiper PA 23-250 · Caledonia, MNThe pilot's loss of control for reasons that could not be determined because the postaccident airplane examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN14LA028Accident · 1 fatalLimited investigationFinal reportPiper PA 22-150 · Princeton, MNThe pilot's loss of airplane control during takeoff.NTSB CEN13FA357Accident · 1 fatalField investigationFinal reportBell 47G-3B-1 · Maplewood, MNThe loss of helicopter control for reasons that could not be determined because an examination of the helicopter and its systems revealed no malfunctions or failures that would have precluded normal operation.NTSB CEN13LA256Accident · 1 fatalLimited investigationFinal reportEskildsen Steen Skybolt · Easton, MNThe pilot's medical incapacitation due to an acute cardiac event after performing aerobatic maneuvers.NTSB CEN13FA214Accident · 1 fatalField investigationFinal reportCessna 152 · Hawley, MNThe noninstrument-rated pilot’s improper decision to conduct a flight into known instrument meteorological conditions, which resulted in a loss of control.NTSB CEN13FA172Accident · 1 fatalField investigationFinal reportMaule MXT-7-180 · Parkers Parairie, MNThe pilot’s failure to transfer fuel from the auxiliary fuel tanks to the main fuel tanks in a timely manner, which resulted in fuel starvation to the engine.NTSB CEN12FA091Accident · 1 fatalField investigationFinal reportRobinson Helicopter R44 II · Hackensack, MNThe helicopter's sudden yaw and subsequent impact with the water for reasons that could not be determined during postaccident examination of the helicopter and its systems.NTSB CEN11LA623Accident · 1 fatalLimited investigationFinal reportHoffmann HK36R Super Dimona · Winsted, MNThe pilot did not maintain adequate airspeed while maneuvering at low altitude, which resulted in an aerodynamic stall.NTSB CEN11FA133Accident · 2 fatalField investigationFinal reportPiper PA-46-310P · Milaca, MNThe pilot did not recover from an unusual attitude while operating in instrument meteorological conditions following a disconnect of the autopilot system for undetermined reasons. Contributing to the accident were the pilot’s lack of recent flight experience…NTSB CEN10LA491Accident · 2 fatalLimited investigationFinal reportSchneider Christen Eagle II · Clearwater, MNThe pilot's failure to maintain aircraft control and his improper decision to perform aerobatic maneuvers without proper experience or training in aerobatic flight. Also causal was his conduct of aerobatic flight in an airplane loaded outside its weight and…NTSB CEN10LA431Accident · 1 fatalLimited investigationFinal reportBell 47G-4A · Rochester, MNThe total loss of engine power due to a high-cycle fatigue fracture of a first-stage compressor blade. The reason for the fracture could not be determined during postaccident examination.NTSB CEN10FA322Accident · 3 fatalField investigationFinal reportPiper PA-23 · Rochester, MNThe loss of engine power and the pilot's subsequent loss of control for undetermined reasons.NTSB CEN09FA518Accident · 2 fatalField investigationFinal reportBeech E18S · Eden Prairie, MNThe pilot’s lack of experience flying the accident make and model of airplane, which led to a loss of control while maneuvering to return to the airport. Contributing to the accident was a partial loss of engine power for undetermined reasons.NTSB CEN09FA363Accident · 1 fatalField investigationFinal reportCirrus Design SR22 · Crystal, MNThe pilot's failure to maintain airspeed which resulted in a loss of aircraft control during a go-around. Factors associated with the accident were the dark night lighting conditions, moderate to heavy rain, and fatigue.NTSB CHI08LA080Accident · 1 fatalLimited investigationFinal reportCessna 140 · Grand Meadow, MNThe pilot's continued visual flight into an area of known instrument meteorological conditions in an airplane not equipped for instrument flight, and his failure to maintain control of the airplane while maneuvering at low altitude.