NTSB investigations, 2021, NE
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
| 1962 | 1 |
|---|---|
| 1964 | 58 |
| 1965 | 67 |
| 1966 | 72 |
| 1967 | 89 |
| 1968 | 80 |
| 1969 | 88 |
| 1970 | 74 |
| 1971 | 93 |
| 1972 | 64 |
| 1973 | 52 |
| 1974 | 71 |
| 1975 | 47 |
| 1976 | 64 |
| 1977 | 52 |
| 1978 | 49 |
| 1979 | 41 |
| 1980 | 36 |
| 1981 | 34 |
| 1982 | 42 |
| 1983 | 39 |
| 1984 | 40 |
| 1985 | 31 |
| 1986 | 27 |
| 1987 | 21 |
| 1988 | 16 |
| 1989 | 22 |
| 1990 | 13 |
| 1991 | 24 |
| 1992 | 20 |
| 1993 | 21 |
| 1994 | 20 |
| 1995 | 16 |
| 1996 | 14 |
| 1997 | 14 |
| 1998 | 28 |
| 1999 | 23 |
| 2000 | 13 |
| 2001 | 19 |
| 2002 | 14 |
| 2003 | 12 |
| 2004 | 11 |
| 2005 | 15 |
| 2006 | 17 |
| 2007 | 11 |
| 2008 | 13 |
| 2009 | 15 |
| 2010 | 13 |
| 2011 | 7 |
| 2012 | 21 |
| 2013 | 11 |
| 2014 | 11 |
| 2015 | 11 |
| 2016 | 10 |
| 2017 | 9 |
| 2018 | 12 |
| 2019 | 13 |
| 2020 | 9 |
| 2021 | 9 |
| 2022 | 14 |
| 2023 | 10 |
| 2024 | 17 |
| 2025 | 11 |
| 2026 | 4 |
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\" = 'NE' 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" = 'NE' 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 CEN22FA042Accident · 3 fatalClass 3 · FieldFinal reportCessna T310R · Chadron, NEThe incapacitating effects of a myocardial infarction (heart attack), which resulted in the pilot's loss of airplane control and impact with terrain.NTSB CEN22FA023Accident · 2 fatalClass 3 · FieldFinal reportBeech P35 · Harrison, NEThe pilot’s decision to continue the flight into instrument and icing conditions, which resulted in loss of control and impact with terrain. Contributing to the accident was the pilot’s failure to obtain a timely weather briefing.NTSB CEN21LA351Accident · Serious injuriesClass 3 · LimitedFinal reportCozy Mark IV · Rushville, NEA total loss of engine power due to an obstruction of airflow to the engine as a result of the landing brake being deployed in flight.NTSB CEN21LA348Accident · Serious injuriesClass 4 · LimitedFinal reportRobinson Helicopter R66 · Merry, NEThe pilot’s failure to maintain clearance from a wire during a low-level aerial application flight.NTSB CEN21LA264Accident · No injuriesClass 3 · LimitedFinal reportBoeing B75N1 · Elwood, NEThe failure of the engine master rod, resulting in a total loss of engine power and a forced landing.NTSB CEN21LA242Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J4A · Omaha, NEA total loss of engine power due to a blocked fuel tank cap vent hole, which resulted in fuel starvation. Contributing to the accident was the mechanic’s and the pilot’s inadequate inspections of the fuel tank cap.NTSB CEN21LA206Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Curtis, NEWater contamination of the airplane’s fuel supply which resulted in a total loss of engine power.NTSB CEN21LA179Accident · Serious injuriesClass 4 · LimitedFinal reportDestiny Powered Parachutes 2000 · Saint Paul, NEThe uncertificated pilot’s failure to maintain control of the powered parachute during low altitude flight in gusting wind conditions.NTSB CEN21FA150Accident · 1 fatalClass 3 · FieldFinal reportAviat A-1B · Berwyn, NEA loss of control and subsequent impact with terrain as a result of spatial disorientation during cruise in dark night conditions.