NTSB investigations, 2017, IN
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
| 1963 | 1 |
|---|---|
| 1964 | 107 |
| 1965 | 116 |
| 1966 | 119 |
| 1967 | 132 |
| 1968 | 106 |
| 1969 | 88 |
| 1970 | 83 |
| 1971 | 81 |
| 1972 | 88 |
| 1973 | 77 |
| 1974 | 66 |
| 1975 | 86 |
| 1976 | 78 |
| 1977 | 90 |
| 1978 | 95 |
| 1979 | 70 |
| 1980 | 76 |
| 1981 | 52 |
| 1982 | 55 |
| 1983 | 54 |
| 1984 | 55 |
| 1985 | 54 |
| 1986 | 58 |
| 1987 | 53 |
| 1988 | 66 |
| 1989 | 45 |
| 1990 | 42 |
| 1991 | 33 |
| 1992 | 29 |
| 1993 | 35 |
| 1994 | 38 |
| 1995 | 33 |
| 1996 | 31 |
| 1997 | 36 |
| 1998 | 35 |
| 1999 | 22 |
| 2000 | 34 |
| 2001 | 29 |
| 2002 | 25 |
| 2003 | 20 |
| 2004 | 26 |
| 2005 | 20 |
| 2006 | 28 |
| 2007 | 23 |
| 2008 | 22 |
| 2009 | 30 |
| 2010 | 27 |
| 2011 | 26 |
| 2012 | 26 |
| 2013 | 22 |
| 2014 | 16 |
| 2015 | 19 |
| 2016 | 23 |
| 2017 | 22 |
| 2018 | 19 |
| 2019 | 22 |
| 2020 | 17 |
| 2021 | 21 |
| 2022 | 21 |
| 2023 | 16 |
| 2024 | 17 |
| 2025 | 13 |
| 2026 | 9 |
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\") = 2017
AND c.\"eventStateOrRegion\" = 'IN' 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") = 2017 AND c."eventStateOrRegion" = 'IN' 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 CEN18LA062Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 525A · Michigan City, INThe flight crew's improper decision to land on a snow-covered runway that had insufficient runway distance for the airplane to land with the contamination, which resulted in a runway overrun and impact with obstacles.NTSB CEN18FA053Accident · 3 fatalField investigationFinal reportCessna T210M · Oldenburg, INA total loss of engine power due to the failure of the No. 4 piston, which resulted in an attempted forced landing in dark night conditions and a subsequent in-flight collision with trees and terrain. Contributing to the accident were the pilot's situational…NTSB CEN18LA048Accident · No injuriesLimited investigationFinal reportPiper PA 31-310 · Jeffersonville, INThe right main landing gear’s failure to fully extend for reasons that could not be determined because postaccident testing revealed no mechanical anomalies that would have precluded normal operation.NTSB CEN17LA365Accident · No injuriesLimited investigationFinal reportGaddis Michael Exec 162 F · Plymouth, INA failure of the drive belt for reasons that could not be determined based on the available information.NTSB CEN17LA348Accident · No injuriesLimited investigationFinal reportBeech N35 · South Bend, INThe improperly seated fuel cap, which resulted in an in-flight fuel leak and subsequent total loss of engine power due to fuel starvation.NTSB CEN17LA375Accident · No injuriesLimited investigationFinal reportHiller UH 12A · Griffith, INThe loss of tail rotor thrust due to a failed tail rotor driveshaft, which resulted in a loss of tail rotor control and a hard landing.NTSB CEN17FA334Accident · 1 fatalField investigationFinal reportVans RV-12 · Fishers, INThe pilot's failure to latch the canopy before takeoff, and his failure to maintain pitch control following the in-flight opening of the canopy during the initial climb resulting in a subsequent impact with terrain and ground fire.NTSB CEN17LA318Accident · Minor injuriesLimited investigationFinal reportKnapp Easy Raider · Rochester, INA partial loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB CEN17LA302Accident · Minor injuriesLimited investigationFinal reportJames F Hake MTO Sport · Mentone, INThe pilot’s failure to maintain a proper touchdown attitude, which resulted in a loss of directional control during the landing roll.NTSB CEN17LA267Accident · Serious injuriesLimited investigationFinal reportRobinson Helicopter R44 · Ireland, INThe pilot's failure to apply the proper procedures to recover from a loss of tail rotor effectiveness, which resulted in a loss of control during an aerial application turn.NTSB GAA17CA401Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Paoli, INThe pilot's decision to maneuver an overgross weight helicopter at a low altitude and airspeed with a gusting tailwind, which resulted in a high descent rate and collision with terrain. Contributing to the accident was the pilot's self-induced pressure to…NTSB CEN17LA271Accident · No injuriesLimited investigationFinal reportPiper PA 32-300 · Rushville, INThe pilot’s inability to properly control engine power because of an improperly installed throttle control arm, which resulted in a partial loss of engine power and led to a forced landing.NTSB GAA17CA336Accident · No injuriesData collectionFinal reportPiper PA 28 · Auburn, INThe pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.NTSB CEN17LA205Accident · No injuriesLimited investigationFinal reportAmstutz Curtis J BD-5B · Portland, INA failure of the wiring between the engine control unit and the fuel injector, which resulted in a total loss of engine power.NTSB GAA17CA279Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Vevay, INThe pilot’s failure to see and avoid power lines during an agricultural application flight due to distraction when reading a map.NTSB GAA17CA237Accident · No injuriesData collectionFinal reportBrantly B 2B · Earl Park, INThe pilot’s failure to recognize that he was operating in the weathercock stability flight regime of loss of tail rotor effectiveness, which resulted in a loss of directional control during the execution of a right pedal turn.NTSB CEN17FA152Accident · 1 fatalField investigationFinal reportTemco GC 1B · Hartsville, INThe pilot's loss of control after exceeding the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall.NTSB CEN17LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-135 · Greensburg, INThe pilot's failure to maintain control during landing, which resulted in an impact with terrain.NTSB CEN17LA144Accident · Serious injuriesLimited investigationFinal reportCirrus Design SR20 · Fort Wayne, INThe pilot receiving instruction’s failure to maintain airplane control during a crosswind landing in high gusting winds, and the flight instructor’s failure to maintain a proper airspeed and angle of attack during the go-around, which resulted in an…NTSB CEN17FA127Accident · 1 fatalField investigationFinal reportMcdonnell Douglas Heli 369FF · Chalmers, INThe pilot's failure to ensure that the needle did not entangle with the tower's vertical lattice as he moved the helicopter rearward, which resulted in the helicopter becoming tethered to the tower and a subsequent loss of control.NTSB GAA17CA153Accident · No injuriesData collectionFinal reportStinson 108 · Valparaiso, INThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB CEN17LA082Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Hobart, INThe pilot's failure to abort the landing when he recognized the airplane was traveling too fast, which resulted in impact with trees off the end of the runway.