NTSB investigations, 2015, 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\") = 2015
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") = 2015 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 CEN16LA076Accident · No injuriesLimited investigationFinal reportBeech 200 · Gary, INThe pilot's failure to maintain the glidepath and appropriate airspeed during landing in icing conditions, which resulted in an aerodynamic stall and a hard landing.NTSB CEN16LA047Accident · No injuriesLimited investigationFinal reportEurocopter EC120B · Goshen, INThe failure of the Thomas coupling at the interface with the main gear box tail rotor output shaft, which resulted in the helicopter's loss of tail rotor control.NTSB CEN15LA433Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Fort Wayne, INThe pilot's inadequate preflight planning and fuel management, which resulted in a total loss of engine power due to fuel exhaustion.NTSB CEN15LA415Accident · No injuriesLimited investigationFinal reportBeech 58 · Gary, INThe pilot’s failure to ensure that the landing gear was down while on short final, his subsequent failure to conduct a go-around, and his loss of situational awareness of the airplane’s altitude above the runway while landing.NTSB CEN15CA410Accident · No injuriesData collectionFinal reportPiper PA-17 · Delphi, INThe pilot's attempt to start the engine by himself without properly securing the airplane.NTSB CEN15LA417Accident · No injuriesLimited investigationFinal reportGrumman American Avn. AA 5 · Pekin, INThe pilot's loss of directional control during the landing roll due to contact with a corn crop that extended into the runway area. Contributing to the accident were the lack of accurate available information to the pilot regarding the runway condition, the…NTSB GAA15CA234Accident · Minor injuriesData collectionFinal reportBurton Dennis W Sonex · Wolcottville, INThe pilot's improper fuel planning, which resulted in fuel exhaustion, a forced off-airport landing, and nose over.NTSB GAA15CA208Accident · No injuriesData collectionFinal reportCessna 172R · North Vernon, INThe pilot's failure to maintain pitch control during the landing touchdown, resulting in a hard landing.NTSB CEN15CA373Accident · No injuriesData collectionFinal reportErcoupe 415-C · Alexandria, INThe pilot's failure to maintain/attain adequate airspeed and attitude during landing that resulted in a hard landing. Contributing was the pilot's diverted attention to air traffic and the reduction of perceptible audio cues due to noise attenuating headsets.NTSB CEN15CA293Accident · Serious injuriesData collectionFinal reportCessna A188B · Crawfordsville, INThe pilot's failure to maintain clearance from the powerline during an aerial application operations.NTSB CEN15LA451Accident · No injuriesLimited investigationFinal reportCessna 150L · Carthage, INThe partial loss of engine power due to carburetor icing.NTSB GAA15CA105Accident · No injuriesData collectionFinal reportRans S 12XL · Sharpsville, INThe pilot's failure to maintain directional control during takeoff, which resulted in a collision with a building.NTSB CEN15LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-235 · Huntington, INThe pilot’s inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN15FA194Accident · 1 fatalField investigationFinal reportS C Aerostar S A YAK 52TW · Advance, INThe pilot’s loss of airplane control while maneuvering for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.NTSB GAA15CA022Accident · No injuriesData collectionFinal reportBeech A36 · New Market, INThe pilot's improper fuel planning, which resulted in fuel exhaustion, and a loss of engine power en-route.NTSB CEN15CA155Accident · No injuriesData collectionFinal reportGaddis Michael Exec 162 F · Plymouth, INThe failure of the helicopter's main drive belt resulting in the pilot performing a forced landing, during which the helicopter's fuselage was substantially damage.NTSB CEN15LA106Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20 C1 · Shipshewana, INThe total loss of engine power due to impact ice obstructing the primary air induction system, which resulted from the student pilot’s failure to operate the alternate air control. Contributing to the accident was the student pilot’s lack of knowledge about…NTSB CEN15LA103Accident · Serious injuriesLimited investigationFinal reportLindstrand Balloons USA 120A · Peru, INThe hard landing due to a higher-than-forecast surface wind, which resulted in a serious neck injury to the pilot.NTSB CEN15LA098Accident · Serious injuriesLimited investigationFinal reportRaytheon A36 · Parker City, INThe pilot’s loss of airplane control while troubleshooting an engine issue in instrument meteorological conditions, which resulted in impact with trees and terrain.