NTSB investigations, 1999, 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\") = 1999
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") = 1999 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 IAD00LA007Accident · No injuriesLimited investigationFinal reportCessna 172XP · Phillipi, WVThe pilot's improper flare that resulted in a hard landing.NTSB NYC00LA033Accident · Minor injuriesLimited investigationFinal reportGrumman American AA-5B · Fayetteville, WVThe pilot's decision to continue the landing attempt too far down the runway. A factor was the pilot's self-induced pressure to land the airplane, due to the sickness of the front seat passenger.NTSB NYC99LA166Accident · No injuriesLimited investigationFinal reportCessna 140 · Beckley, WVThe pilot's loss of aircraft control during the landing roll, which resulted in an inadvertent ground loop.NTSB NYC99FA157Accident · 1 fatalField investigationFinal reportRobinson R-22 · Hurricane, WVA loss of engine power for undetermined reasons. Contributing to the accident was the pilot's failure to maintain rotor rpm and the transmission wires.NTSB NYC99LA152Accident · Serious injuriesLimited investigationFinal reportCessna 172M · Fayetteville, WVThe pilot's failure to maintain directional control during the aborted landing. A factor in this accident was the crosswind condition.NTSB NYC99LA141Accident · No injuriesLimited investigationFinal reportPrendergast Seawind · Martinsburg, WVThe air-intake's inner liner separating from its outer liner, which blocked airflow to the fuel servo, resulting in a loss of engine power. A factor in the accident was the owner/builder's inadequate inspection of the airplane.NTSB NYC99LA116Accident · 1 fatalLimited investigationFinal reportNations Acro Sport II · Pence Springs, WVThe student pilot's improper decision to perform aerobatics, and his failure to maintain aircraft control, which resulted in an inadvertent spin. A factor in the accident was the pilot's lack of aerobatic experience.NTSB NYC99FA091Accident · Serious injuriesField investigationFinal reportRaytheon Corporate Jets BE-400A · Beckley, WVThe pilot-in-command misjudged his altitude and airspeed which resulted in an overrun. Contributing to the accident were the pilot's lack of total flight experience in make and model, the pilot's reliance on the airplane's optional thrust reverser system and…