NTSB investigations, 1986, WV
180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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\") = 1986
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") = 1986 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 BFO87LA010Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Beckley, WVThe plt stated that before takeoff he did not see anything on the rwy. The landing and taxi lights on the acft were on for the takeoff. During the takeoff roll when the acft was almost at takeoff speed the plt heard a loud bang followedby the acft yawing to…NTSB CHI87FA018Accident · Serious injuriesField investigationFinal reportGates Learjet 23 · Charleston, WVThe PIC lost consciousness during cruise near Charleston WV while on a revenue flt. The co-plt assumed command and landed at Charleston WV without further incident. The PIC was hospitalized and the flt continued on to detroit mi after a replacement PIC was…NTSB ATL86FA239Accident · 1 fatalField investigationFinal reportCessna P206-B · Wht Sulphur Spr, WVAfter completing the revenue producing portion of this trip the company president called his company operations and told his secretary to send everyone home since it was a holiday. He was going to return the acft to its home base himself. The plt departed…NTSB ATL86LA237Accident · No injuriesLimited investigationFinal reportCessna 152 · Charleston, WVThe plt flew the aircraft twice, another plt flew it once then the plt attempted another flight. He reported to app control that he thought he was out of fuel. An off airport landing was attempted. Examination of the aircraft showed less than one gallon of…NTSB ATL86FA212Accident · 2 fatalField investigationFinal reportCessna 172 · Bridgeport, WVThe aircraft collided with a tree while on final approach to runway 21. The flight had been cleared for the approach after the pilot reported having the airport in sight. There was no current weather observation available at that time, but a local air taxi…NTSB ATL86LA188Accident · Serious injuriesLimited investigationFinal reportPiper J3C-65 · Welch, WVWitnesses reported that the pilot had worked on the engine carburetor for some time as well as just before the accident takeoff. At about 200 feet after takeoff from rwy 27 the engine quit and the pilot made a left turn back to the rwy and tried to align the…NTSB ATL86LA141Accident · Serious injuriesLimited investigationFinal reportHughes 269A · Daniels, WVThe plt stated that he noted a 'large vibration' after he had taken off. He suspected a psbl bird strike or bearing failure, & subsequently, the helicopter crashed into trees. According to the plt, the eng did not fail; however, witnesses saw the helicopter…