NTSB investigations, 2004, MN
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 1964 | 113 |
|---|---|
| 1965 | 115 |
| 1966 | 117 |
| 1967 | 130 |
| 1968 | 95 |
| 1969 | 113 |
| 1970 | 88 |
| 1971 | 80 |
| 1972 | 82 |
| 1973 | 77 |
| 1974 | 83 |
| 1975 | 98 |
| 1976 | 78 |
| 1977 | 92 |
| 1978 | 98 |
| 1979 | 76 |
| 1980 | 66 |
| 1981 | 89 |
| 1982 | 61 |
| 1983 | 68 |
| 1984 | 51 |
| 1985 | 57 |
| 1986 | 43 |
| 1987 | 40 |
| 1988 | 52 |
| 1989 | 50 |
| 1990 | 42 |
| 1991 | 59 |
| 1992 | 25 |
| 1993 | 40 |
| 1994 | 39 |
| 1995 | 37 |
| 1996 | 40 |
| 1997 | 37 |
| 1998 | 36 |
| 1999 | 33 |
| 2000 | 39 |
| 2001 | 40 |
| 2002 | 46 |
| 2003 | 40 |
| 2004 | 32 |
| 2005 | 31 |
| 2006 | 29 |
| 2007 | 25 |
| 2008 | 31 |
| 2009 | 29 |
| 2010 | 32 |
| 2011 | 28 |
| 2012 | 28 |
| 2013 | 33 |
| 2014 | 24 |
| 2015 | 15 |
| 2016 | 26 |
| 2017 | 20 |
| 2018 | 14 |
| 2019 | 16 |
| 2020 | 26 |
| 2021 | 12 |
| 2022 | 24 |
| 2023 | 34 |
| 2024 | 24 |
| 2025 | 22 |
| 2026 | 13 |
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 year(c.\"eventDate\") = 2004
AND c.\"eventStateOrRegion\" = 'MN' AND c.\"eventCountry\" = 'USA'
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 year(c."eventDate") = 2004 AND c."eventStateOrRegion" = 'MN' AND c."eventCountry" = 'USA' 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 CHI05FA042Accident · 2 fatalField investigationFinal reportPiper PA-32R-301T · Glenwood, MNThe pilot's failure to execute a missed approach and his failure to maintain sufficient altitude and clearance from terrain and obstructions. Contributing factors were the pilot's failure to obtain a preflight weather briefing, his decision to delay descent…NTSB CHI05LA037Accident · No injuriesLimited investigationFinal reportCessna 172H · Belle Plaine, MNA loss of engine power for undetermined reasons during descent, and the unsuitable terrain encountered during the forced landing.NTSB CHI05CA034Accident · No injuriesData collectionFinal reportCessna 172N · Lakeville, MNThe pilot misjudged his distance and speed which resulted in an overrun.. Factors were the wet runway, the grass and the berm.NTSB CHI05CA005Accident · No injuriesData collectionFinal reportBuss Rotorway Exec · Eden Prairie, MNThe pilot's inadvertent deactivation of the battery switch leading to the helicopter's loss of engine power on base leg. A factor was the crops he encountered during the emergency landing.NTSB CHI04LA285Accident · Minor injuriesLimited investigationFinal reportPiper PA-12 · Perham, MNThe dual student's improper compensation for the crosswind condition and his subsequent failure to maintain control of the airplane. An additional cause was the flight instructor's inadequate remedial action. A contributing factor was the crosswind condition.NTSB CHI04FA284Accident · 1 fatalField investigationFinal reportCessna 182Q · Morris, MNThe pilot's inadequate weather evaluation that resulted flight into night instrument meteorological conditions and a subsequent loss of aircraft control. Factors to the accident were the pilot's lack of recent night experience and the low cloud ceiling at…NTSB CHI04CA291Accident · No injuriesData collectionFinal reportJohnson Titan Tornado I · Carlton, MNThe pilot's failure to abort the takeoff. Factors to the accident included the diminished takeoff performance due to the incorrect propeller pitch setting and the tree that the airplane impacted.NTSB CHI04CA252Accident · No injuriesData collectionFinal reportCessna T310R · Marshall, MNThe pilot rated passenger selecting an improper fuel selector position, and the pilot in command not verifying the fuel selector position which resulted in fuel starvation. Contributing factors were the pilot's failure to feather the right engine propeller…NTSB CHI04CA244Accident · Minor injuriesData collectionFinal reportBeech BE-18 · Lakeville, MNThe pilot's inadequate flare, the improper recovery from a bounced landing, the loss of directional control, and inadequate compensation for the crosswind. A factor was the crosswind.NTSB CHI04WA235Accident · 2 fatalForeign investigationChampion 7ECA · Angle Inlet, MNNTSB CHI04CA237Accident · Serious injuriesData collectionFinal reportEnstrom F-28A · Leroy, MNThe partial loss of engine power due to the missing 1/8-27 NPT Allen plug as a result of other maintenance personnel undertorquing the plug. Additionally, the pilot improperly excecuted a run on landing. A factor was the loss of tail rotor effectiveness.NTSB CHI04CA190Accident · No injuriesData collectionFinal reportSelby Dean KR-2-SS · Lake Elmo, MNThe pilot's inadequate compensation for wind conditions and his failure to maintain aircraft control. A related factor was the crosswind.NTSB CHI04LA181Accident · No injuriesLimited investigationFinal reportBeech BE-N35 · Austin, MNThe loss of engine power due to the fatigue fracture of the piston pin plug that lead to engine oil starvation/exhaustion and the subsequent overload fracture of the piston rod and crankcase.NTSB CHI04CA180Accident · No injuriesData collectionFinal reportTexas Helicopter M-74 · Clear Lake, MNThe pilot failed to maintain a proper glidepath to the landing zone. A factor was the truck pad.NTSB CHI04LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Waubun, MNThe pilot's failure to get the proper rest prior to the night cross country flight and the pilot's failure to maintain altitude. Contributing factors to the accident were fatigue as a result of inadequate sleep, conditions conducive to fatigue, and night.NTSB CHI04FA177Accident · 1 fatalField investigationFinal reportRobinson R-22 Beta · Rochester, MNThe loss of control due to the student pilot's failure to maintain rotor RPM and the flight instructor's inadequate supervision.NTSB CHI04CA170Accident · No injuriesData collectionFinal reportPiper PA28-140 · Rush City, MNThe pilot's inadequate compensation for wind conditions which led to his loss of aircraft control. Factors were the wind gusts, the ditch, and the fence.NTSB CHI04CA169Accident · Minor injuriesData collectionFinal reportBellanca 8GCBC · Mankato, MNThe pilot's improper decision to initiate the flight given the crosswind wind condition. Additional causes were the pilot's inadequate compensation for the crosswind and his subsequent failure to maintain aircraft control. The crosswind and the runway light…NTSB CHI04CA163Accident · No injuriesData collectionFinal reportGrumman G-164A · Hutchinson, MNThe pilot's failure to maintain airspeed during the low altitude turn after takeoff. A factor to the accident was the low altitude and the swampy terrain condition.NTSB CHI04CA143Accident · No injuriesData collectionFinal reportCessna 150F · Forest Lake, MNThe pilot's inaccurate fuel consumption calculations which resultied in fuel exhaustion and loss of engine power. Factors associated with the accident were the dark light conditions and the water on which the forced landing was made.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 CHI04CA122Accident · No injuriesData collectionFinal reportCessna 180J · South St. Paul, MNThe total loss of engine power during takeoff climb due to fuel starvation as a result of the pilot's failure to follow the aircraft's checklist and leaving the fuel selector in the OFF positon.NTSB CHI04LA119Accident · Minor injuriesLimited investigationFinal reportRobinson R22 Beta · Winsted, MNThe failure of the main rotor drive belts for an undetermined reason, and the pilot's misjudged flare during the autorotation.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.NTSB CHI04CA111Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Rochester, MNThe pilot's failure to maintain control of the helicopter during landing. Contributing factors were the aircraft's low altitude and the pilot's limited flight experience.NTSB CHI04CA110Accident · Minor injuriesData collectionFinal reportRobinson R22 Beta · Shakopee, MNThe dual student's failure to maintain control of the helicopter during hovering flight and the flight instructor's delayed remedial action in order to prevent a loss of control. Contributing factors were the flight instructor's lack of dual instruction…NTSB CHI04CA108Accident · Minor injuriesData collectionFinal reportPiper PA-18-150 · Minneapolis, MNThe pilot not verifying the position of the fuel selector prior to the takeoff, resulting in the loss of engine power during initial climb due to fuel starvation. Factors to the accident were the power pole and the trees.NTSB CHI04CA105Accident · Minor injuriesData collectionFinal reportCessna A185E · Hastings, MNThe pilot not verifying the fuel selector valve's position during the preflight leading to the fuel starvation and subsequent loss of engine power during the flight's initial climb.NTSB CHI04LA082Accident · No injuriesLimited investigationFinal reportAlon A2 Ercoupe · Hawley, MNThe loss of engine power for undetermined reasons. A contributing factor was the fence post.NTSB CHI04LA072Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Sunburg, MNThe pilot's improper in-flight decision to land off-airport. A factor to the accident was the snow covered ditch.NTSB CHI04LA060Accident · No injuriesLimited investigationFinal reportPiper PA-46-500TP · Minneapolis, MNA loss of engine power for undetermined reasons.NTSB CHI04FA055Accident · 2 fatalField investigationFinal reportCessna 182P · Baudette, MNThe pilot's intentional flight into adverse weather conditions, and his failure to maintain adequate terrain clearance. Contributing factors were the pilot's lack of an instrument rating, low ceiling, low altitude, and the dark night conditions.