NTSB investigations, 1970, WV
180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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\") = 1970
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") = 1970 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 IAD71AI030Accident · 1 fatalClosedPiper PA-24 · Clarksburg, WVNTSB IAD71DIJ13Accident · No injuriesClosedPiper PA-28 · Morgantown, WVNTSB DCA71AZ005Accident · 75 fatalClosedDouglas DC-9 · Huntington, WVNTSB IAD71AI024Accident · 1 fatalClosedPiper PA-22 · Hamlin, WVNTSB IAD71AI022Accident · 2 fatalClosedPiper PA-28 · Terra Alta, WVNTSB IAD71FIG18Accident · Serious injuriesClosedPiper PA-28R · Martinsburg, WVNTSB IAD71DIG20Accident · No injuriesClosedBeech 58 · Capon Sprngs, WVNTSB IAD71AI016Accident · 2 fatalClosedLake LA-4 · New Cumbrlnd, WVNTSB IAD71II013Incident · No injuriesClosedConvair 580 · Wheeling, WVNTSB IAD71FIJ09Accident · Minor injuriesClosedCessna 172I · Ronceverte, WVNTSB IAD71FIG17Accident · Minor injuriesClosedTaylorcraft BC-65 · Fort Ashby, WVNTSB IAD71DIJ08Accident · Minor injuriesClosedCessna 182J · Taplin, WVNTSB IAD71DIJ07Accident · Serious injuriesClosedMooney M20C · Huntington, WVNTSB IAD71FIJ05Accident · Serious injuriesClosedCessna 175A · Clarksburg, WVNTSB IAD71FIJ05Accident · No injuriesClosedCessna 182A · Morgantown, WVNTSB IAD71AI005Accident · 1 fatalClosedBeech 35-33 · Hacker Vally, WVNTSB IAD71DIJ02Accident · Minor injuriesClosedCessna 172 · Bridgeport, WVNTSB IAD71FIG04Accident · Serious injuriesClosedStinson 108-3 · Springfield, WVNTSB IAD71DIJ01Accident · No injuriesClosedChampion 7-FC-3 · Ripley, WVNTSB IAD71FGN02Accident · Minor injuriesClosedCessna 177 · Chester, WVNTSB IAD71DIG01Accident · No injuriesClosedPiper PA-23 · Petersburg, WVNTSB IAD71AI001Accident · No injuriesClosedSikorsky S-55B · Davis, WVNTSB IAD70II066Incident · No injuriesClosedConvair 580 · Morgantown, WVNTSB IAD70AI065Accident · 3 fatalClosedCessna 310D · West Union, WVNTSB IAD70DIJ07Incident · No injuriesClosedCessna 337 · Beaver, WVNTSB IAD70DIJ06Accident · No injuriesClosedCessna 150 · Pineville, WVNTSB IAD70FGN19Accident · No injuriesClosedBeech 23 · Wierton, WVNTSB IAD70DIJ04Accident · No injuriesClosedChampion L-16B · Pt Pleasant, WVNTSB IAD70II058Incident · No injuriesClosedNihon YS-11A · Parkersburg, WVNTSB IAD70AI057Accident · No injuriesClosedNihon YS-11A · Charleston, WVNTSB IAD70FIJ02Accident · No injuriesClosedPiper PA-24 · Bridgeport, WVNTSB IAD70DIJ03Accident · No injuriesClosedCessna 172 · Lewisburg, WV