NTSB investigations, 1991, 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
Latest 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\") = 1991
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") = 1991 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 BFO92FA005Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · West Wardsboro, VTThe pilot's flight into known adverse weather. Contributing to the accident was the pilot's inadequate flight and weather planning.NTSB NYC92LA019Accident · No injuriesLimited investigationFinal reportPiper J3C-65 · Manchester, VTThe pilot's inadequate aircraft preflight. A factor was the pilot's lack of flight experience.NTSB NYC92LA008Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Townshend, VTThe pilot allowed the speed of the airplane to get too slow, resulting in inadvertent stall at too low an altitude to allow recovery.NTSB NYC92DNC01Accident · No injuriesFinal reportDenney Aircraft Behn KIT FOX III · Hartford, VTAn inadvertent stall/spin. Factors related to the accident were an improperly planned approach by the pilot, the failure of the pilot to attain and maintain flying speed, rising terrain, and turbulent air conditions.NTSB NYC91FA239Accident · 2 fatalField investigationFinal reportConvair CV-580 · Belvedere Ctr, VTFailure of the first officer (co-pilot) to maintain control of the aircraft after becoming spatially disoriented, and his exceeding the design stress limits of the aircraft. Factors related to the accident were: the lack of two pilots in the cockpit,…NTSB NYC91DNC03Accident · 1 fatalFinal reportValentin GMB H Taifun 17E · West Arlington, VTPhysiological incapacitation due to cardiovascular disease which resulted in incapacitation and inflight collision with trees.NTSB NYC91LA170Accident · No injuriesLimited investigationFinal reportCessna 152 · Rutland, VTThe student pilot improper recovery from a bounced landing which resulted in the collapsing of the nose gear. A factor related to the accident was the student pilot's lack of total flight experience.NTSB NYC91FA140Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Shelburne, VTPremature lift-off by the pilot, which resulted in a subsequent stall/mush and collision with trees. Factors related to the accident were: the pilot's inadequate preflight planning/preparation, and the unfavorable wind condition.NTSB NYC91LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Vergennes, VTThe pilot's excessive taxi speed, resulted in an on ground loss of control.NTSB NYC91LA061Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Sherburne, VTThe pilots intentional flight into icing conditions with an airplane not equipped for flight in known icing conditions. This resulted in an uncontrolled descent and contact with trees in instrument meteorological conditions. Factors related to the accident…