Skip to content

NTSB investigations, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 c."eventStateOrRegion" = 'WV' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 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 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 DIA69F0031Accident · Minor injuriesClosedBeech A23-24 · Petersburg, WVJul 21, 1968 · N5975S · Substantial damage NTSB DIA69A0004Accident · 2 fatalClosedCessna 402 · Beverly, WVJul 20, 1968 · N4090Q · Destroyed NTSB DIA69F0151Accident · Serious injuriesClosedCessna 182L · Nitro, WVJul 17, 1968 · N42188 · Destroyed NTSB DIA69D0093Accident · No injuriesClosedCessna 140A · Kerens, WVJun 17, 1968 · N9688A · Substantial damage NTSB DIA69F0011Accident · Serious injuriesClosedCessna 177 · Wheeling, WVJun 12, 1968 · N2348Y · No damage NTSB DIA68F0235Accident · No injuriesClosedMooney M20C · N.Cumberland, WVJun 6, 1968 · N1321W · Substantial damage NTSB DIA69D0086Accident · No injuriesClosedPiper PA-22 · Parkersburg, WVJun 3, 1968 · N3578A · Substantial damage NTSB DIA69D0027Accident · No injuriesClosedPiper PA-32 · Ravenswood, WVMay 30, 1968 · N3854W · Substantial damage NTSB DIA68A0050Accident · 1 fatalClosedPiper PA-30 · New Mrtnsvil, WVMay 27, 1968 · N7996Y · Destroyed NTSB DIA69D0026Accident · No injuriesClosedCessna 182 · Spencer, WVApr 28, 1968 · N3388U · Substantial damage NTSB DIA68D0218Accident · No injuriesClosedCessna 210D · Bluefield, WVApr 16, 1968 · N3937Y · Substantial damage NTSB DIA69D0021Accident · Minor injuriesClosedCessna 172 · Poca, WVApr 12, 1968 · N7031T · Substantial damage NTSB DIA68I0041Incident · 1 fatalClosedMcbee AM B8 · Buckhannon, WVMar 24, 1968 · N291M · Substantial damage NTSB DIA68D0211Accident · No injuriesClosedChampion 7ECA · Cowen, WVMar 21, 1968 · N11052 · Substantial damage NTSB DIA68A0037Accident · 6 fatalClosedM.Dessault Falcon · Parkersburg, WVMar 13, 1968 · N1846 · Destroyed NTSB DIA68A0036Accident · 2 fatalClosedPiper PA-22 · Kasson, WVMar 10, 1968 · N2356A · Destroyed NTSB DIA68A0045Accident · 1 fatalClosedPiper PA-28 · Lizemores, WVMar 6, 1968 · N9835W · Destroyed NTSB DIA68D0202Accident · No injuriesClosedCessna 140 · Morgantown, WVMar 5, 1968 · N89072 · Substantial damage NTSB DIA68D0203Accident · No injuriesClosedCessna 150 · Logan, WVJan 27, 1968 · N4586U · Substantial damage NTSB DIA68F0158Accident · Minor injuriesClosedCessna 150 · Charleston, WVJan 20, 1968 · N7938E · Substantial damage NTSB DIA68D0173Accident · No injuriesClosedPiper PA-18 · Pt.Pleasant, WVJan 18, 1968 · N4322Z · Substantial damage NTSB DIA68A0030Accident · No injuriesClosedCessna P206 · White Sul Sp, WVJan 10, 1968 · N4782F · Substantial damage NTSB DIA68D0150Accident · No injuriesClosedPiper PA-28 · Summersville, WVJan 1, 1968 · N8251W · Substantial damage NTSB DIA68D0172Accident · No injuriesClosedCessna 210 · Gassaway, WVDec 27, 1967 · N9470T · Substantial damage NTSB DIA68D0171Accident · No injuriesClosedMooney M20C · Fairmont, WVNov 29, 1967 · N2940L · Substantial damage NTSB DIA68F0127Accident · No injuriesClosedCessna 172F · N.Cumberland, WVNov 21, 1967 · N8350U · Substantial damage NTSB DIA68A0019Accident · 3 fatalClosedStinson 108 · Cairo, WVNov 10, 1967 · N97702 · Destroyed NTSB DIA68F0137Accident · No injuriesClosedGlobe GC-1B · Short Creek, WVOct 29, 1967 · N80933 · Substantial damage NTSB DIA68D0157Accident · No injuriesClosedCessna 150 · Parkersburg, WVOct 22, 1967 · N4294U · Substantial damage NTSB DIA68D0170Accident · No injuriesClosedBeech C35 · Alderson, WVOct 16, 1967 · N8977A · Substantial damage NTSB DIA68D0151Accident · No injuriesClosedBeech J35 · Charleston, WVSep 10, 1967 · N8381D · Substantial damage NTSB DIA68A0009Accident · 1 fatalClosedAeronca 11CC · Enoch, WVAug 27, 1967 · N2094A · Destroyed NTSB DIA68D0063Accident · No injuriesClosedCessna 150 · Forest Hill, WVAug 21, 1967 · N2668J · Substantial damage NTSB DIA68D0169Accident · No injuriesClosedBellanca 14-193 · Russelville, WVAug 16, 1967 · N6853D · Substantial damage NTSB DIA68D0068Accident · Minor injuriesClosedCessna 182 · New Martnsvl, WVJul 31, 1967 · N5772B · Substantial damage NTSB DIA68D0074Accident · No injuriesClosedPiper PA-24 · Charleston, WVJul 30, 1967 · N6553P · Substantial damage NTSB DIA68A0002Accident · 2 fatalClosedPiper PA-18 · Accoville, WVJul 24, 1967 · N110R · Destroyed NTSB DIA68D0113Accident · Serious injuriesClosedRearwin 185 · Glenville, WVJul 23, 1967 · N92931 · Substantial damage NTSB DIA68D0006Accident · No injuriesClosedPiper PA-28 · Charleston, WVJun 11, 1967 · N6083W · Substantial damage NTSB DIA68D0067Accident · No injuriesClosedAero Comdr 680F · Summerville, WVMay 30, 1967 · N1174Z · Substantial damage NTSB DIA67A0018Accident · 1 fatalClosedBeech C35 · Keyser, WVMay 9, 1967 · N5853C · Destroyed NTSB DIA67D0092Accident · No injuriesClosedPiper PA-24 · Mullens, WVApr 23, 1967 · N6376P · Substantial damage NTSB DIA67D0038Accident · No injuriesClosedPiper PA-24 · Colfax, WVJan 20, 1967 · N7571P · Substantial damage NTSB DIA67A0004Accident · No injuriesClosedCessna 310K · Bluefield, WVJan 4, 1967 · N7024L · Substantial damage NTSB NYC67F0471Accident · Minor injuriesClosedBellanca 14-13 · Tridelphia, WVDec 28, 1966 · N74264 · Substantial damage NTSB NYC67F0421Accident · No injuriesClosedBeech G18S · Wheeling, WVDec 2, 1966 · N9711 · Substantial damage NTSB NYC67A0079Accident · 2 fatalClosedPiper PA-24 · Spencer, WVNov 11, 1966 · N5834P · Destroyed NTSB NYC67D0390Accident · No injuriesClosedChampion 7ECA · Lewisburg, WVNov 10, 1966 · N2522F · Substantial damage NTSB NYC67A0066Accident · No injuriesClosedBeech D18S · Parkersburg, WVOct 21, 1966 · N9111 · Substantial damage NTSB NYC67D0336Accident · No injuriesClosedCessna 172 · Charleston, WVOct 20, 1966 · N6272E · Substantial damage