NTSB investigations, 2023, IN
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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\") = 2023
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") = 2023 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 CEN24LA103Accident · No injuriesClass 4 · LimitedFinal reportVans RV6 · Bremen, INThe collapse of the nose landing gear after it contacted soft terrain during the landing roll.NTSB CEN24FA045Accident · 2 fatalClass 3 · FieldFinal reportCirrus Design SR22T · Fairland, INBoth pilots’ failure to maintain adequate airspeed during departure from the airport, which led to the airplane exceeding its critical angle of attack, entering an aerodynamic stall, and impacting terrain.NTSB CEN24LA038Accident · Minor injuriesClass 3 · LimitedFinal reportBede BD-4 · Lowell, INFatigue cracking of the propeller blade root, which resulted in the in-flight separation of the propeller blade from its root. Contributing to the accident was the improper machining of the blade root threads, which resulted in chatter/ratchet marks that…NTSB CEN24LA032Accident · Minor injuriesClass 4 · LimitedFinal reportTom Hodgson 29 · Kokomo, INThe pilot’s failure to maintain directional control during the landing roll.NTSB CEN24LA017Accident · No injuriesClass 4 · LimitedFinal reportBell Helicopter Textron Canada 206L-4 · Mitchell, INThe inflight collision with a bird while in cruise flight.NTSB CEN23LA384Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-44-180 · West Lafayette, INAn in-flight collision with a bird during initial climb.NTSB CEN23LA373Accident · No injuriesClass 4 · LimitedFinal reportCessna 150D · New Haven, INThe pilot’s loss of directional control while landing, which resulted in a runway excursion, impact with corn stalks, and subsequent nose over.NTSB CEN23LA381Accident · Serious injuriesClass 4 · LimitedFinal reportGeorge Stone KIT FOX Model 3 · Scottsburg, INThe student pilot’s failure to maintain airplane control after takeoff that resulted in an impact with terrain.NTSB CEN23LA429Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · Muncie, INA loss of directional control during the landing roll due to the left wheel seizing from insufficient grease in the left wheel bearing.NTSB CEN23LA307Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Greenwood, INThe student pilot’s failure to maintain directional control during takeoff.NTSB CEN23LA281Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Jeffersonville, INThe pilot’s improper fuel management, which resulted in fuel exhaustion and a total loss of engine power.NTSB CEN23LA247Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R22 Beta · Cedar Lake, INThe failure of the flight instructor to attain/maintain aircraft control while maneuvering, which resulted in an uncontrolled descent and impact with the lake.NTSB CEN23LA156Accident · No injuriesClass 4 · LimitedFinal reportBoeing A75N1(PT17) · Evansville, INThe pilot’s failure to engage the tailwheel lock before landing which resulted in the loss of control and ground loop.NTSB CEN23LA119Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Martinsville, INThe pilot’s inadequate weather evaluation and failure to abort the takeoff that resulted in an impact with terrain.NTSB DCA23LA170Accident · Serious injuriesClass 4 · LimitedFinal reportBoeing 737 · Rushville, INAn encounter with clear air turbulence during descent.NTSB CEN23LA093Accident · 1 fatalClass 4 · LimitedFinal reportCirrus Design SR20 · Indianapolis, INThe pilot’s intentional flight into terrain as an act of suicide.