NTSB investigations, 2010, 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\") = 2010
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") = 2010 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 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 CEN11LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-350P · Lake Elmo, MNThe pilot's improper fuel management which resulted in the loss of engine power due to fuel starvation. Contributing to the accident was the distraction of the cabin depressurization.NTSB CEN11LA120Accident · No injuriesLimited investigationFinal reportBeech 300 · Minneapolis, MNThe pilot's failure to follow the aircraft checklist in locking the cabin door prior to departure which resulted in its in-flight separation.NTSB CEN11LA077Accident · No injuriesLimited investigationFinal reportHalbrook Rans S-6S · St. Cloud, MNThe airplane kit manufacturer’s recommended use of an improper nut type for securing the door hinge.NTSB CEN11LA072Accident · No injuriesLimited investigationFinal reportEmbraer ERJ 170-200 LR · Minneapolis, MNThe in-flight collision with a flock of birds during climb.NTSB CEN11CA017Accident · Serious injuriesData collectionFinal reportLuscombe 8D · Clarrisa, MNThe partial loss of engine power for undetermined reasons.NTSB CEN11CA010Accident · Minor injuriesData collectionFinal reportMartin Curtis Zenair CH701 SP · Lonsdale, MNThe pilot's failure to maintain clearance from a power line while on approach to land.NTSB CEN10CA576Accident · No injuriesData collectionFinal reportCessna 172M · Belle Plaine, MNThe pilot's loss of directional control due to an encounter with soft terrain while landing.NTSB CEN10LA556Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Duluth, MNThe pilot's failure to identify and arrest the helicopter's descent due to spatial disorientation.NTSB OPS10IA574Incident · No injuriesIncident investigationFinal reportAirbus Industrie A320-214 · Minneapolis, MNThe Local North Controller's issuance of a left-turn heading to the Airbus without establishing the position and heading of the Beech. Contributing to the incident was the Local South Controller's distraction with a ground movement operation and lack of…NTSB CEN10FA519Accident · Serious injuriesField investigationFinal reportKwech Glasair RG Super 11S · Lake Elmo, MNThe pilot's failure to maintain control of the airplane during takeoff with gusty wind conditions, which resulted in a collision with terrain.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 CEN10LA484Accident · Serious injuriesLimited investigationFinal reportRammel Thomas W Searey · Cokato, MNSeparation of the composite skin on one of the three propeller blades that resulted in an in-flight vibration, and the pilot's failure to maintain clearance with the water while maneuvering to avoid obstacles in preparation for a precautionary landing.NTSB CEN10CA461Accident · No injuriesData collectionFinal reportWing Kitfox II · Park Rapids, MNA partial loss of engine power for undetermined reasons and the pilot's failure to adequately flare during the water landing.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 CEN10CA356Accident · No injuriesData collectionFinal reportBeech C23 · Eden Prairie, MNThe student pilot’s loss of airplane control while landing with gusting wind.NTSB CEN10CA354Accident · No injuriesData collectionFinal reportCessna 175 · Brainerd, MNThe pilot's loss of airplane control while taking off with gusting wind.NTSB CEN10LA338Accident · No injuriesLimited investigationFinal reportPilatus P3-05 · Canby, MNThe North American's pilot's failure to maintain adequate visual lookout, which resulted in an on-ground collision with the Pilatus.NTSB CEN10CA329Accident · No injuriesData collectionFinal reportPiper/Wally'S Flyers J3C-65 · Crystal, MNThe pilot's failure to maintain directional control during the crosswind landing and the instructor pilot's delayed remedial action.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 ENG10IA037Incident · No injuriesIncident investigationFinal reportDouglas DC9 · Minneapolis, MNThe failure of the facility that overhauled the 1st stage fan blade to properly restore the leading edge, which caused a flutter mode resulting in a fatigue crack and fracture of the fan blade.NTSB CEN10CA304Accident · No injuriesData collectionFinal reportBordelon Kitfox IV · Stanton, MNThe pilot’s inadvertent propeller blade pitch change and subsequent loss of forward thrust.NTSB CEN10CA280Accident · No injuriesData collectionFinal reportHughes 269A · Cannon Falls, MNThe pilot's failure to maintain rotor speed during the autorotation, which resulted in an excessive sink rate and a hard landing.NTSB CEN10CA254Accident · No injuriesData collectionFinal reportNelson Steven Paul WAG-AEROSPORTSMAN2+2 · Milica, MNA loss of engine power due to fuel starvation as a result of the pilot's inadequate in-flight fuel management.NTSB CEN10CA260Accident · No injuriesData collectionFinal reportCessna 180 · Duluth, MNThe pilot's failure to maintain directional control during landing.NTSB CEN10CA224Accident · No injuriesData collectionFinal reportCessna 170-B · White Bear Lake, MNThe flight instructor's inadequate attempted recovery from a bounced landing and the student pilot's abrupt use of the brakes, which resulted in the airplane nosing over.NTSB CEN10CA211Accident · Minor injuriesData collectionFinal reportPiper J3C-65 · White Bear Lake, MNA total loss of engine power during takeoff due to fuel contamination as a result of the pilot's inadequate preflight inspection.NTSB CEN10CA195Accident · No injuriesData collectionFinal reportCessna 175 · Eveleth, MNThe pilot's selection of unsuitable terrain for landing.NTSB CEN10CA193Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Brook Park, MNThe pilot’s failure to maintain directional control during landing rollout in variable wind conditions.NTSB CEN10LA188Accident · Serious injuriesLimited investigationFinal reportBeech 95 · Eden Prairie, MNThe fatigue failure of an intake valve spring on the right engine, which resulted in a partial loss of engine power on takeoff.NTSB CEN10CA154Accident · No injuriesData collectionFinal reportGrumman American AA-5 · Maple Lake, MNThe pilot's failure to maintain a proper glide path during a simulated forced landing and the flight instructor's delayed remedial action to execute a go-around.NTSB CEN10LA127Accident · No injuriesLimited investigationFinal reportHawker Beechcraft 65-B80 · Minneapolis, MNThe pilot of the other airplane not setting the parking brake adequately while holding for departure. Contributing to the accident was the pilot of the other airplane being distracted while doing his paperwork.