NTSB investigations, 2020, CT
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
| 1962 | 1 |
|---|---|
| 1964 | 32 |
| 1965 | 45 |
| 1966 | 50 |
| 1967 | 48 |
| 1968 | 34 |
| 1969 | 31 |
| 1970 | 34 |
| 1971 | 40 |
| 1972 | 31 |
| 1973 | 34 |
| 1974 | 24 |
| 1975 | 22 |
| 1976 | 18 |
| 1977 | 27 |
| 1978 | 26 |
| 1979 | 26 |
| 1980 | 21 |
| 1981 | 14 |
| 1982 | 22 |
| 1983 | 21 |
| 1984 | 33 |
| 1985 | 17 |
| 1986 | 23 |
| 1987 | 24 |
| 1988 | 17 |
| 1989 | 18 |
| 1990 | 17 |
| 1991 | 15 |
| 1992 | 21 |
| 1993 | 15 |
| 1994 | 13 |
| 1995 | 10 |
| 1996 | 14 |
| 1997 | 8 |
| 1998 | 16 |
| 1999 | 10 |
| 2000 | 9 |
| 2001 | 15 |
| 2002 | 12 |
| 2003 | 8 |
| 2004 | 13 |
| 2005 | 9 |
| 2006 | 7 |
| 2007 | 7 |
| 2008 | 9 |
| 2009 | 2 |
| 2010 | 4 |
| 2011 | 11 |
| 2012 | 6 |
| 2013 | 7 |
| 2014 | 5 |
| 2015 | 9 |
| 2016 | 8 |
| 2017 | 13 |
| 2018 | 8 |
| 2019 | 8 |
| 2020 | 5 |
| 2021 | 5 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 6 |
| 2025 | 9 |
| 2026 | 3 |
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\") = 2020
AND c.\"eventStateOrRegion\" = 'CT' 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") = 2020 AND c."eventStateOrRegion" = 'CT' 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 ERA21LA016Accident · Minor injuriesClass 4 · LimitedFinal reportEnstrom 480 · Woodstock, CTThe pilot’s failure to maintain control of the helicopter while attempting to land on a trailer in gusting wind conditions, which resulted in a dynamic rollover.NTSB ERA20LA337Accident · No injuriesClass 4 · LimitedFinal reportLancair 235 · Chester, CTThe pilot's unstable approach, which resulted in a hard landing, and the separation of the left main landing gear.NTSB ERA20CA294Accident · No injuriesClass 4 · Data collectionFinal reportSocata TB200 · Simsbury, CTA runway excursion following an aborted takeoff in tailwind conditions.NTSB ERA20LA287Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA34 · Groton, CTThe reported partial loss of right engine power for reasons that could not be determined based on available evidence.NTSB ERA20CA190Accident · No injuriesClass 4 · Data collectionFinal reportCessna 305 · Oxford, CTThe pilot's failure to maintain directional control during the landing roll, which resulted in a ground-loop.