NTSB investigations, 2021, VT
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
| 1964 | 20 |
|---|---|
| 1965 | 16 |
| 1966 | 9 |
| 1967 | 15 |
| 1968 | 15 |
| 1969 | 18 |
| 1970 | 11 |
| 1971 | 14 |
| 1972 | 20 |
| 1973 | 18 |
| 1974 | 11 |
| 1975 | 16 |
| 1976 | 21 |
| 1977 | 9 |
| 1978 | 15 |
| 1979 | 16 |
| 1980 | 10 |
| 1981 | 3 |
| 1982 | 10 |
| 1983 | 13 |
| 1984 | 9 |
| 1985 | 11 |
| 1986 | 13 |
| 1987 | 13 |
| 1988 | 11 |
| 1989 | 8 |
| 1990 | 4 |
| 1991 | 10 |
| 1992 | 3 |
| 1993 | 8 |
| 1994 | 5 |
| 1995 | 11 |
| 1996 | 2 |
| 1997 | 5 |
| 1998 | 6 |
| 1999 | 6 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 5 |
| 2003 | 2 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 4 |
| 2007 | 7 |
| 2008 | 1 |
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 1 |
| 2012 | 6 |
| 2013 | 3 |
| 2014 | 5 |
| 2015 | 2 |
| 2016 | 4 |
| 2017 | 4 |
| 2018 | 11 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 1 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 4 |
| 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\") = 2021
AND c.\"eventStateOrRegion\" = 'VT' 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" = 'VT' 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 ERA21LA366Accident · No injuriesClass 4 · LimitedFinal reportSproul Keith A 83K-16 · Ryegate, VTThe pilot's failure to secure himself to the balloon seat which resulted in a loss of control of the balloon.NTSB ERA21LA330Accident · No injuriesClass 4 · LimitedFinal reportSchweizer SGS 2-33A · North Springfield, VTThe check pilot's failure to account for the extended departure distance from the airport during a simulated tow rope break and recovery.NTSB ERA21LA309Accident · Serious injuriesClass 3 · LimitedFinal reportEnstrom 280 · Colchester, VTAn in-flight fire originating in the engine compartment near the turbocharger from a source that could not be determined, which resulted in a loss of engine power and led to an autorotation and a hard landing.NTSB ERA21LA211Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32-260 · Burlington, VTA fire that originated in the right main landing gear brake assembly for reasons that could not be determined based on the available information.