NTSB investigations, 1994, WV
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 | 20 |
| 1965 | 28 |
| 1966 | 26 |
| 1967 | 21 |
| 1968 | 31 |
| 1969 | 35 |
| 1970 | 32 |
| 1971 | 16 |
| 1972 | 28 |
| 1973 | 23 |
| 1974 | 31 |
| 1975 | 25 |
| 1976 | 18 |
| 1977 | 21 |
| 1978 | 19 |
| 1979 | 28 |
| 1980 | 21 |
| 1981 | 21 |
| 1982 | 16 |
| 1983 | 18 |
| 1984 | 17 |
| 1985 | 21 |
| 1986 | 7 |
| 1987 | 9 |
| 1988 | 22 |
| 1989 | 13 |
| 1990 | 16 |
| 1991 | 13 |
| 1992 | 16 |
| 1993 | 11 |
| 1994 | 9 |
| 1995 | 5 |
| 1996 | 13 |
| 1997 | 15 |
| 1998 | 8 |
| 1999 | 8 |
| 2000 | 7 |
| 2001 | 15 |
| 2002 | 7 |
| 2003 | 11 |
| 2004 | 12 |
| 2005 | 7 |
| 2006 | 7 |
| 2007 | 6 |
| 2008 | 3 |
| 2009 | 11 |
| 2010 | 10 |
| 2011 | 9 |
| 2012 | 7 |
| 2013 | 5 |
| 2014 | 6 |
| 2015 | 3 |
| 2016 | 8 |
| 2017 | 6 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 5 |
| 2023 | 6 |
| 2024 | 10 |
| 2025 | 4 |
| 2026 | 10 |
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\") = 1994
AND c.\"eventStateOrRegion\" = 'WV' 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") = 1994 AND c."eventStateOrRegion" = 'WV' 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 NYC95LA045Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Wheeling, WVThe student pilot's inadequately planned cross-country flight, and his subsequent disorientation, resulting in fuel exhaustion and a collision with an object.NTSB NYC94LA172Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201T · Lockwood, WVAn electrical ground short of the ignition wires which resulted in a loss of engine power.NTSB BFO94LA158Accident · Serious injuriesLimited investigationFinal reportCessna 140 · Ravenswood, WVThe poorly planned approach which resulted in unporting of fuel from the left fuel tank and loss of engine power due to fuel starvation.NTSB NYC94FA145Accident · 1 fatalField investigationFinal reportCessna 210N · Martinsburg, WVFailure of the pilot to maintain adequate altitude and proper climb during the missed approach. Factors related to the accident were: darkness, fog, and conditions conducive to pilot fatigue.NTSB BFO94FA121Accident · 3 fatalField investigationFinal reportBeech 58TC · St Marys, WVAn in-flight fire of undetermined origin, prior to the in-flight breakup.NTSB NYC94LA083Accident · Minor injuriesLimited investigationFinal reportBellanca 7GCBC · Lewisburg, WVThe pilot's inadequate inflight decision, inadvertent VFR flight into IMC, and failure to maintain adequate terrain clearance which resulted in inflight collision with trees. A factor was inadequate altitude.NTSB BFO94LA061Accident · No injuriesLimited investigationFinal reportCessna 172N · Clarksburg, WVthe pilot's selection of a downwind runway, and his inadequate compensation for the wind conditions. A factor was the gusting tailwind.NTSB BFO94LA060Accident · Serious injuriesLimited investigationFinal reportTalago Thundergull JT2 · Clarksburg, WVThe builder's inadequate maintenance adjustment which resulted in the aileron control assembly becoming disconnected.NTSB NYC94LA057Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Beckley, WVA loss of engine power due to fuel contamination, while operating over unsuitable terrain, after the pilot failed to remove all the water from the tank prior to departure. A factor was the pilot's decision to operate the airplane with a known leaking fuel cap.