NTSB investigations, 2021, IN
180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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\") = 2021
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") = 2021 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 CEN22FA080Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-32R-300 · Bloomington, INThe pilot’s failure to follow the instrument landing system (ILS) course guidance, which resulted in the pilot’s loss of airplane control during the instrument approach. Contributing to the accident was the presence of turbulence and low-level wind shear.NTSB CEN22LA074Accident · No injuriesClass 4 · LimitedFinal reportMini-MAX 1600R Sport · South Bend, INThe pilot’s low-level flight and poor visual lookout which resulted in collision with a light pole on final approach and the pilot’s improper decision to operate an airplane under the influence of alcohol.NTSB CEN21LA469Accident · Minor injuriesClass 4 · LimitedFinal reportMeuer SA900 V-STAR · Kokomo, INThe pilot’s failure to maintain adequate speed and altitude during final approach, which resulted in an off field landing short of the runway and a subsequent nose over.NTSB CEN21LA400Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Fort Wayne, INThe total loss of engine power after takeoff due to the formation of carburetor ice while on the ground and the pilot’s failure to apply carburetor heat immediately before takeoff.NTSB CEN21LA386Accident · No injuriesClass 3 · LimitedFinal reportAcro Sport II · Fishers, INThe airplane’s total loss of engine power due to fuel exhaustion as a result of leaking fuel from a loose fuel inlet fitting to the fuel control unit.NTSB CEN21LA359Accident · No injuriesClass 3 · LimitedFinal reportPiper J3C-65 · Gosport, INA total loss of engine power during cruise flight due to the failure of a cylinder exhaust valve stem, which led to a forced landing during which the airplane impacted terrain.NTSB CEN21LA356Accident · Serious injuriesClass 4 · LimitedFinal reportBell 206 · Corydon, INThe pilot’s failure to see and avoid power lines.NTSB CEN21LA353Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Jeffersonville, INA loss of directional control due to failure of the landing gear attachment hardware for reasons that could not be determined based on the available information.NTSB CEN21LA340Accident · Serious injuriesClass 4 · LimitedFinal reportStephen L Kruer Superstol · Floyds Knobs, INThe pilot’s failure to maintain clearance from the trees during a go-around.NTSB CEN21LA318Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-602 · Nappanee, INThe pilot’s failure to maintain clearance from the tower during low-level agricultural operations.NTSB CEN21LA279Accident · No injuriesClass 3 · LimitedFinal reportCessna 310R · Portland, INThe airplane’s collision with a deer on the runway during landing.NTSB CEN21LA262Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150H · Muncie, INThe non-certificated pilot's failure to maintain aircraft control on departure in high density altitude conditions which resulted in an aerodynamic stall.NTSB CEN21FA252Accident · 2 fatalClass 3 · FieldFinal reportDiamond Aircraft Ind DA 40 NG · Darlington, INA loss of control while practicing an aerodynamic stall, which resulted in a spin and impact with terrain.NTSB CEN21LA246Accident · No injuriesClass 4 · LimitedFinal reportCessna 162 · Indianapolis, INThe pilot’s improper landing flare, which resulted in a hard, bounced landing.NTSB CEN21LA200Accident · 1 fatalClass 3 · LimitedFinal reportAeropro CZ S R O A240 · Richmond, INThe noninstrument-rated pilot’s intentional flight into instrument meteorological conditions, which resulted in spatial disorientation and loss of airplane control.NTSB CEN21LA194Accident · No injuriesClass 3 · LimitedFinal reportCessna A185F · North Vernon, INThe pilot’s improper installation of the fuel selector handle, which resulted in a total loss of engine power due to fuel starvation.NTSB CEN21LA171Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-30 · Wanatah, INThe pilots’ fuel mismanagement, which resulted in fuel starvation and a total loss of engine power to both engines.NTSB CEN21LA157Accident · Minor injuriesClass 4 · LimitedFinal reportPost Thorp T-18 · Indianapolis, INThe pilot’s failure to maintain directional control during landing with a crosswind.NTSB CEN21LA134Accident · No injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA20-C1 · Indianapolis, INThe pilot’s improper landing flare that resulted in a bounced touch and go landing and subsequent nose wheel separation.NTSB CEN21LA136Accident · No injuriesClass 3 · LimitedFinal reportLearjet 55 · Jeffersonville, INThe flight crew’s failure to verify the correct runway for landing, which resulted in a landing on a snow contaminated runway and resulting damage to the airplane. The illumination of the lights associated with the closed runway contributed to the accident.NTSB CEN21LA124Accident · No injuriesClass 4 · LimitedFinal reportHiller UH12C · Lafayette, INThe pilot’s failure to maintain control of the helicopter shortly after liftoff into a hover, which resulted in a dynamic rollover when the left landing skid contacted the ground.