NTSB investigations, 1992, WV
180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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
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\") = 1992
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") = 1992 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 BFO93FA005Accident · 3 fatalField investigationFinal reportCessna 177B · War, WVVFR flight by the pilot into instrument meteorological conditions, his failure to maintain control of the airplane due to spatial disorientation, and the pilot allowing the design stress limits of the aircraft to be exceeded. Factors related to the accident…NTSB BFO93FA003Accident · 1 fatalField investigationFinal reportCessna 310R · Summersville, WVThe pilot's inadequate altitude (or clearance) from mountainous hilly terrain. Factors related to the accident were darkness, low clouds, and light snow.NTSB NYC93LA035Accident · No injuriesLimited investigationFinal reportCessna 172M · Mallory, WVThe pilot failed to maintain control of the airplane, which resulted in the airplane departing the runway and striking a tree.NTSB NYC93LA027Accident · No injuriesLimited investigationFinal reportCessna 177 · Morgantown, WVThe pilot's improper preflight and planning, which resulted in fuel exhaustion and a forced landing on a highway.NTSB NYC93FA028Accident · 2 fatalField investigationFinal reportBeech A36 · Middlebourne, WVThe pilot's decision to intentionally fly into known icing conditions which resulted in an inadvertent stall and uncontrolled descent into trees. A factor related to the accident was the icing conditions.NTSB NYC93FA005Accident · 3 fatalField investigationFinal reportBeech 35 · New Manchester, WVThe pilot's failure to obtain adequate airspeed and abort the takeoff. The pilot's premature rotation, upsloping runway, and a tailwind are contributing factors.NTSB BFO92LA149Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Glenville, WVThe pilot failed to follow the takeoff procedure which to led to a partial loss of power during takeoff. Contributing to the accident was the trees.NTSB BFO92FA152Accident · 2 fatalField investigationFinal reportMooney M20K · Weston, WVTotal loss of engine power due to the inadequate torque of the no. 1 cylinder attach bolts and studs, fatique failure of the bolts/studs, and separation of the no. 1 cylinder. Factors related to the accident were: darkness and hilly terrain, which were…NTSB NYC92LA182Accident · No injuriesLimited investigationFinal reportCessna 172H · New Cumberland, WVThe pilot's improper takeoff procedures and his lack of understanding of airplane performance which resulted in an aborted takeoff with insufficient runway to stop and the subsequent collision with a fence. Factors related to the accident were; the pilot's…NTSB NYC92LA151Accident · Minor injuriesLimited investigationFinal reportRockwell 112-TC · St Mary'S, WVThe fatigue cracking fracture of the propeller hub, resulting in a forced landing, and collision with a house.NTSB BFO92LA111Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Charleston, WVThe pilot's failure to attain adequate airspeed to outclimb obstacles.NTSB NYC92LA111Accident · Serious injuriesLimited investigationFinal reportBellanca 8KCAB · Lewisburg, WVThe failure of the instructor pilot to take proper remedial action during a takeoff resulting in a loss of airplane control and subsequent inadvertant stall. Factors related to the accident were the instructor's lack of total, recent and instructional flight…NTSB NYC92LA080Accident · No injuriesLimited investigationFinal reportCessna 180 · Winfield, WVThe improper in-flight planning and decision of the pilot to land on the strip and the pilot's delay in attempting the go-around. Factors in this accident were: the pilot was unable to maintain control of the aircraft due to the wet grass and the tail wind.NTSB BFO92FA048Accident · 2 fatalField investigationFinal reportMooney M20M · Youngs Bottom, WVThe pilot's inadequate inflight decision to continue flight in icing condition which resulted in degraded aircraft performance, inadequate airspeed, and aerodynamic stall. A related factor is the pilot's inadequate evaluation of the weather.NTSB BFO92LA029Accident · No injuriesLimited investigationFinal reportCessna 195 · Charleston, WVFailure of the pilot to maintain clearance from the taxiway sign.NTSB NYC92FA061Accident · 1 fatalField investigationFinal reportMooney M20K · Wheeling, WVThe pilot's failure to maintain airspeed and his improper handling of the aircraft which resulted in an inadvertent stall at an altitude insufficient for proper recovery. A factor related to the accident was icing conditions which resulted in airframe ice.