NTSB investigations, 2016, 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\") = 2016
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") = 2016 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 CEN17LA048Accident · No injuriesLimited investigationFinal reportArion Lightning LS-1 · Goshen, INA partial loss of engine power due to carburetor icing and the subsequent forced landing on a rough/soft field.NTSB CEN17FA046Accident · 1 fatalField investigationFinal reportGordon Pegazair P 100 · Mt Vernon, INThe pilot's failure to maintain airplane control, which resulted in a collision with terrain. Contributing to the accident was the pilot's impairment resulting from the combination of his progressive degenerative neurologic condition and his use of alcohol.NTSB CEN17LA029Accident · No injuriesLimited investigationFinal reportBeech 100 · Jeffersonville, INThe pilot’s inadequate preflight planning, his decision to take off knowing the airplane was over its gross takeoff weight, and his failure to abort the takeoff after he realized that the airplane was not accelerating as expected, which resulted in a runway…NTSB GAA17CA021Accident · Minor injuriesData collectionFinal reportLuscombe 8 · Huntingburg, INThe pilot’s delayed crosswind correction during the landing roll with a gusting left crosswind, which resulted in the airplane weathervaning and nosing over.NTSB CEN16CA390Accident · Minor injuriesData collectionFinal reportCessna 182 · Rensselaer, INThe pilot's improper touchdown point during landing, which resulted in the left wing's subsequent impact with a cornfield.NTSB GAA16CA491Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Valparaiso, INThe pilot’s improper landing flare, which resulted in a bounced landing.NTSB CEN16FA333Accident · 1 fatalField investigationFinal reportCessna 172N · Terre Haute, INThe pilot's failure to maintain a normal approach path to the runway, which resulted in the airplane colliding with a tree and a house during final approach. Contributing to the accident was the pilot's lack of recent flight experience.NTSB CEN16CA360Accident · No injuriesData collectionFinal reportCessna 140 · Lebanon, INPC The unseen standing water on the runway that abruptly slowed the tailwheel equipped airplane during landing resulting in a nose-over.NTSB CEN16CA317Accident · No injuriesData collectionFinal reportErcoupe 415 · Eminence, INThe pilot's failure to maintain a proper glide path during the landing approach and his failure to use available engine power to arrest the descent, resulting in an undershoot and collision with terrain.NTSB CEN16LA300Accident · Serious injuriesLimited investigationFinal reportWings AN Things Avid Flyer · Bluffton, INThe loss of roll control during climb for reasons that could not be determined because postaccident examination of the airframe revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB GAA16CA334Accident · No injuriesData collectionFinal reportHubbard William H Lightning · Kokomo, INThe pilot's failure to maintain directional control during the landing flare at night, which resulted in an impact with a runway light and runway sign.NTSB CEN16FA220Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Madison, INThe pilot’s failure to maintain a proper climb rate after takeoff and the subsequent collision with transmission line structures.NTSB CEN16FA216Accident · 2 fatalField investigationFinal reportCessna 150F · Rockville, INThe pilot's use of an improper soft-field takeoff procedure, which resulted in the airplane having insufficient airspeed to climb out of ground effect and its subsequent impact with trees near the departure end of the runway.NTSB GAA16CA307Accident · No injuriesData collectionFinal reportLuscombe 8 · Valparaiso, INThe pilot's improper descent rate during landing, which resulted in a bounced landing, failure of the tailwheel suspension leaf spring, a ground loop, and substantial damage to the left wing.NTSB GAA16LA329Accident · Serious injuriesLimited investigationFinal reportMini Max 1200 · Batesville, INThe 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 decision to depart without obtaining flight training in the…NTSB GAA16CA244Accident · Minor injuriesData collectionFinal reportSchleicher ASW 19 · Frankton, INThe pilot's exceedance of the critical angle of attack on final approach in turbulent conditions, which resulted in an aerodynamic stall and collision with terrain.NTSB GAA16CA226Accident · No injuriesData collectionFinal reportCessna TR182 · Bloomington, INThe pilot's failure to maintain the airplane's descent rate resulting in a hard landing, and subsequent substantial damage to the firewall.NTSB CEN16LA170Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine 582 · Fortville, INThe collapse of the powered parachute's canopy for a reason that could not be determined, because postaccident examination revealed no anomalies with the parachute.NTSB GAA16LA199Accident · Serious injuriesLimited investigationFinal reportBuckeye Industries Dream Machine · Culver, INThe noncertificated pilot’s failure to attain a climb in the powered-parachute and its subsequent impact with a tree.NTSB CEN16LA163Accident · Minor injuriesLimited investigationFinal reportCessna 162 · Zionsville, INThe flight instructor’s improper decision to depart on a local instructional flight in rapidly deteriorating weather conditions, including thunderstorms and hail, which resulted in subsequent impact with terrain during a go-around.NTSB CEN16LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA24 · Kentland, INThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical anomalies that would have precluded normal operation. Contributing to the accident was the flight…NTSB GAA16CA159Accident · No injuriesData collectionFinal reportCessna 152 · Valparaiso, INThe student pilot's failure to maintain pitch control during the landing flare, which resulted in a porpoise and substantial damage to the firewall.NTSB CEN16LA115Accident · No injuriesLimited investigationFinal reportBeech V35 · Seymour, INThe pilot's improper placement of the fuel selector handle between two tank positions, which resulted in a restricted fuel flow to the engine and the initial loss of engine power, and his improper decision to use the high-boost auxiliary fuel pump for an…