NTSB investigations, 1997, WV
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
| 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\") = 1997
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") = 1997 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 NYC98LA057Accident · Minor injuriesLimited investigationFinal reportCessna 421C · Elkins, WVThe flight instructor's failure to identify an unsafe runway condition and his delay in aborting the takeoff. Contributing was the aircraft's maximum takeoff weight exceeded, and a snow-covered runway.NTSB NYC98LA045Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Fairplain, WVan improper overhaul of the fuel servo by the manufacturer, which resulted in the loss of engine power. Factors in the accident were the dark night conditions and rough forced landing terrain.NTSB IAD98LA014Accident · Minor injuriesLimited investigationFinal reportJones Mini 500 · Bluefield, WVPilot's unfamiliarity with reciprocating engine powered helicopter lead to a reduction in main rotor rpm and subsequent uncontrolled rate of descent with insufficient altitude to recover.NTSB NYC98LA028Accident · No injuriesLimited investigationFinal reportBeech 65-A90 · Wheeling, WVthe failure of the pilot to maintain the minimum required airspeed while operating in icing conditions which resulted in ice accumulations and an inadvertent stall while on approach. Factors were the icing conditions and the pilot's lack of experience in the…NTSB IAD98LA011Accident · No injuriesLimited investigationFinal reportSilvaire Luscombe 8B · Bluefield, WVThe pilot failed to maintain control of the airplane.NTSB NYC98FA016Accident · 1 fatalField investigationFinal reportCessna 182P · Morgantown, WVThe loss of engine power due to carburetor ice and the pilot's failure to follow ATC instructions during the emergency descent.NTSB IAD98FA005Accident · 4 fatalField investigationFinal reportBell 206B · Sago, WVThe improper overhaul of the turbine governor by the manufacturer, which resulted in the loss of power.NTSB NYC98LA005Accident · No injuriesLimited investigationFinal reportCessna 120 · Mineral Wells, WVA loss of engine power to a blockage in the carburetor resulting in fuel starvation.NTSB IAD97LA118Accident · Serious injuriesLimited investigationFinal reportReynolds MARSKE-MONARCH 1997 · Sutton, WVThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. A related factors was the pilot lack of familiarity with the airplane.NTSB NYC97LA156Accident · No injuriesLimited investigationFinal reportCessna 172M · Milton, WVThe student pilot's improper recovery from a bounced landing.NTSB NYC97LA146Accident · No injuriesLimited investigationFinal reportTaylorcraft DCO-65 · Charleston, WVthe pilot's inadequate compensation for unfavorable (variable) wind conditions, and his failure to maintain directional control of the airplane. The wind condition and proximity of a hangar were related factors.NTSB NYC97IA123Incident · No injuriesIncident investigationFinal reportBeech 1900D · Clarksburg, WVThe right outboard flap detaching from the flap aft roller bearings, at the flap track, which was a result of the manufacturer's inadequate inspection program.NTSB IAD97LA074Accident · No injuriesLimited investigationFinal reportAmerican AA-1 · Lewisburg, WVThe pilot's inadequate preflight, which led to the loss of a fuel cap and subsequent fuel exhaustion.NTSB NYC97FA057Accident · 2 fatalField investigationFinal reportBeech E-18S · Mabie, WVThe pilot's disregard of the preflight weather briefing for severe weather along his route of flight, and his departure into the known and forecasted severe weather. A factor in the accident was the inadequate FAA oversight of the operator, which fostered an…NTSB CHI97IA075Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Charleston, WVa fractured fusion weld in the piston of the roll spoiler servoactuator, which allowed the plug at the base of the piston to separate and jam the piston. A factor relating to the incident was: the inadequate design of the airplane's roll spoiler servoactuator…