NTSB investigations, 2014, MN
180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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\") = 2014
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") = 2014 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 CEN15CA074Accident · No injuriesData collectionFinal reportCessna 150L · New Buffalo, MNThe student pilot's failure to maintain directional control and the flight instructor's delayed remedial action during landing. Contributing was the snow on the runway surface.NTSB CEN15CA041Accident · No injuriesData collectionFinal reportCessna 510 · Faribault, MNAn inflight collision with a goose while descending to land at the destination airport.NTSB DCA15CA012Accident · No injuriesData collectionFinal reportEmbraer-Empresa Brasileira De ERJ 170 200 LR · Minneapolis, MNthe B757 Captain's failure to maintain a safe clearance between his wing and the wingtip of the ERJ-170. Contributing to the accident was the positioning of the ERJ-170 by the Compass ground personnel.NTSB CEN15CA036Accident · Minor injuriesData collectionFinal reportFlight Design CTLSi · White Bear Lake, MNThe pilot's exceedance of the airplane's critical angle of attack during the landing, which resulted in an inadvertent aerodynamic stall, a hard landing, and a nose over.NTSB CEN14CA501Accident · Serious injuriesData collectionFinal reportCirrus Design SR22 · Longville, MNThe pilot's loss of control during an attempted go-around following a multiple bounce landingNTSB CEN14LA486Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Langola Township, MNMaintenance personnel’s failure to apply sufficient torque on the throttle control lever nut, which resulted in a loss of throttle control and subsequent loss of engine power.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 CEN14CA470Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Minneapolis, MNThe pilot's loss of control while landing with a crosswind. Contributing to the accident was the pilot lack of experience flying in similar weather conditions.NTSB CEN14CA479Accident · No injuriesData collectionFinal reportQuicksilver 2S · Frontenac, MNThe loss of engine power during cruise due to fuel exhaustion resulting in a forced landing on a cornfield.NTSB CEN14CA442Accident · No injuriesData collectionFinal reportRockwell International S 2R · Kerkhoven, MNThe pilot failure to see and avoid the guide wire during the aerial application flight.NTSB CEN14CA444Accident · No injuriesData collectionFinal reportHughes 369HS · Saint Peter, MNThe pilot did not see the wires resulting in the subsequent wire collision.NTSB CEN14LA411Accident · Minor injuriesLimited investigationFinal reportHanson Lonn Avid Amphibian · Waterville, MNThe noncertificated pilot’s failure to maintain airplane control after an inadvertent takeoff, which resulted in collision with terrain.NTSB CEN14CA391Accident · No injuriesData collectionFinal reportContinental Copters Tomcat MK5A · Osage, MNThe total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing and impact with terrain. Contributing to the accident was the pilot's decision to operate the helicopter without resolving the fuel…NTSB CEN14LA417Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Bruno, MNThe total loss of engine power due to an anomaly with the carburetor system that could not be determined during postaccident examination.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 CEN14LA320Accident · No injuriesLimited investigationFinal reportCessna 172XP · St. Cloud, MNThe pilot's failure to maintain the proper airspeed and angle-of-attack after a partial loss of engine power on takeoff, which resulted in a stall and the subsequent impact with water. Contributing to the accident was the partial loss of engine power due to…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 CEN14LA279Accident · Minor injuriesLimited investigationFinal reportCessna 177A · Sauk Centre, MNThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle-of-attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s failure to retract the flaps after beginning the go-around.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 CEN14LA244Accident · Minor injuriesLimited investigationFinal reportCrawford Preceptor Ultra PUP · Mabel, MNThe loss of engine power as a result of carburetor icing.NTSB CEN14CA158Accident · Minor injuriesData collectionFinal reportAmerican Champion 8GCBC · Chisago City, MNThe unsuitable landing area encountered by the pilot due to wet soft snow conditions that resulted in a nose over.NTSB CEN14CA154Accident · No injuriesData collectionFinal reportCessna 185 · Eden Prairie, MNThe pilot's loss of directional control during takeoff with a gusty crosswind.NTSB CEN14CA156Accident · No injuriesData collectionFinal reportOlson Kenneth H T Zodiac 601 HDS · Garrison, MNThe pilot's failure to maintain directional control during takeoff which resulted in the airplane striking a snow bank.NTSB CEN14CA130Accident · Minor injuriesData collectionFinal reportTaylorcraft BC12 D · Worthington, MNThe pilot's loss of control during a crosswind landing.