Skip to content

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

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 NYC72DIJ40Accident · No injuriesClosedPiper PA-18 · Hamlin, WVApr 18, 1972 · N3842Z · Substantial damage NTSB NYC72AN133Accident · 2 fatalClosedHughes 269 · Bergoo, WVApr 18, 1972 · N9635F · Destroyed NTSB NYC72FIJ38Accident · Minor injuriesClosedCessna 177 · Spencer, WVApr 16, 1972 · N3220T · Substantial damage NTSB NYC72DIJ39Accident · Minor injuriesClosedCessna 172 · Bluefield, WVApr 9, 1972 · N79146 · Substantial damage NTSB NYC72DIJ37Accident · No injuriesClosedCessna 150F · Williamson, WVFeb 19, 1972 · N7870F · Substantial damage NTSB NYC72FIG19Accident · No injuriesClosedBeech B50 · Petersburg, WVFeb 12, 1972 · N3749B · Substantial damage NTSB NYC72DIJ35Accident · No injuriesClosedAmer Avco AA-1A · Buckhannon, WVFeb 9, 1972 · N9407L · Substantial damage NTSB NYC72FGM29Accident · No injuriesClosedBeech A35 · Weirton, WVJan 23, 1972 · N8542A · Substantial damage NTSB NYC72AN090Accident · 2 fatalClosedPiper PA-24 · Morgantown, WVJan 21, 1972 · N5986P · Destroyed NTSB NYC72AN077Accident · 1 fatalClosedCessna 172 · Buckhannon, WVDec 11, 1971 · N2501Y · Destroyed NTSB NYC72FIJ33Accident · Minor injuriesClosedCessna 140 · Summersville, WVNov 24, 1971 · N76540 · Destroyed NTSB NYC72FIJ32Accident · Minor injuriesClosedChampion 7KCAB · Grantsville, WVNov 6, 1971 · N1855G · Substantial damage NTSB NYC72FIJ31Accident · No injuriesClosedCessna 182 · Parkersburg, WVSep 25, 1971 · N2572R · Substantial damage NTSB NYC72FIJ30Accident · Minor injuriesClosedPiper PA-25 · Huntington, WVSep 24, 1971 · N8938L · Substantial damage NTSB NYC72FIG11Accident · Serious injuriesClosedBellanca 14-19 · Augusta, WVAug 18, 1971 · N8505R · Substantial damage NTSB IAD72AI002Accident · 4 fatalClosedPiper PA-30 · Huntington, WVJul 20, 1971 · N7276Y · Destroyed NTSB IAD72FIG04Accident · No injuriesClosedStinson 108-3 · Wiley Ford, WVJul 14, 1971 · N936C · Substantial damage NTSB IAD72DIJ25Accident · No injuriesClosedBensen B8M-AX · Hamlin, WVJul 4, 1971 · N30067 · Substantial damage NTSB IAD71DIJ24Accident · No injuriesClosedTaylorcraft BC12C · Frankford, WVJun 27, 1971 · N43909 · Substantial damage NTSB IAD71DIJ23Accident · No injuriesClosedChampion 7GCAA · Washington, WVJun 14, 1971 · N1820G · Destroyed NTSB IAD72DIJ21Accident · No injuriesClosedPiper PA-28 · Amherstdale, WVJun 6, 1971 · N5906U · Substantial damage NTSB IAD71DIJ22Accident · No injuriesClosedBensen B8M · Hamlin, WVMay 16, 1971 · N4682S · Substantial damage NTSB IAD71AI051Accident · No injuriesClosedPiper PA-32 · Buckhannon, WVMay 8, 1971 · N3344W · Substantial damage NTSB IAD71DIJ19Accident · Minor injuriesClosedCessna 172 · Welch, WVApr 16, 1971 · N46494 · Substantial damage NTSB IAD71FIJ15Accident · Minor injuriesClosedCessna 182 · W Sulphr Spg, WVFeb 25, 1971 · N2442R · Substantial damage NTSB IAD71AI030Accident · 1 fatalClosedPiper PA-24 · Clarksburg, WVDec 21, 1970 · N7689P · Destroyed NTSB IAD71DIJ13Accident · No injuriesClosedPiper PA-28 · Morgantown, WVDec 17, 1970 · N8986J · Substantial damage NTSB DCA71AZ005Accident · 75 fatalClosedDouglas DC-9 · Huntington, WVNov 14, 1970 · N97S · Destroyed NTSB IAD71AI024Accident · 1 fatalClosedPiper PA-22 · Hamlin, WVNov 8, 1970 · N26F · Substantial damage NTSB IAD71AI022Accident · 2 fatalClosedPiper PA-28 · Terra Alta, WVNov 3, 1970 · N6529J · Destroyed NTSB IAD71FIG18Accident · Serious injuriesClosedPiper PA-28R · Martinsburg, WVOct 31, 1970 · N3990T · Destroyed NTSB IAD71DIG20Accident · No injuriesClosedBeech 58 · Capon Sprngs, WVOct 31, 1970 · N633D · Substantial damage NTSB IAD71AI016Accident · 2 fatalClosedLake LA-4 · New Cumbrlnd, WVOct 24, 1970 · N7633L · Destroyed NTSB IAD71II013Incident · No injuriesClosedConvair 580 · Wheeling, WVOct 20, 1970 · N5814 · Minor damage NTSB IAD71FIJ09Accident · Minor injuriesClosedCessna 172I · Ronceverte, WVOct 18, 1970 · N35713 · Substantial damage NTSB IAD71FIG17Accident · Minor injuriesClosedTaylorcraft BC-65 · Fort Ashby, WVOct 17, 1970 · N26644 · Destroyed NTSB IAD71DIJ08Accident · Minor injuriesClosedCessna 182J · Taplin, WVOct 3, 1970 · N2941F · Substantial damage NTSB IAD71DIJ07Accident · Serious injuriesClosedMooney M20C · Huntington, WVAug 16, 1970 · N9710M · Substantial damage NTSB IAD71FIJ05Accident · Serious injuriesClosedCessna 175A · Clarksburg, WVJul 28, 1970 · N7920T · Destroyed NTSB IAD71FIJ05Accident · No injuriesClosedCessna 182A · Morgantown, WVJul 19, 1970 · N3864D · Substantial damage NTSB IAD71AI005Accident · 1 fatalClosedBeech 35-33 · Hacker Vally, WVJul 15, 1970 · N630V · Destroyed NTSB IAD71DIJ02Accident · Minor injuriesClosedCessna 172 · Bridgeport, WVJul 13, 1970 · N4400L · Substantial damage NTSB IAD71FIG04Accident · Serious injuriesClosedStinson 108-3 · Springfield, WVJul 12, 1970 · N4207C · Destroyed NTSB IAD71DIJ01Accident · No injuriesClosedChampion 7-FC-3 · Ripley, WVJul 9, 1970 · N7495B · Substantial damage NTSB IAD71FGN02Accident · Minor injuriesClosedCessna 177 · Chester, WVJul 4, 1970 · N3350T · Substantial damage NTSB IAD71DIG01Accident · No injuriesClosedPiper PA-23 · Petersburg, WVJul 1, 1970 · N6949Y · Substantial damage NTSB IAD71AI001Accident · No injuriesClosedSikorsky S-55B · Davis, WVJun 30, 1970 · N414A · Substantial damage NTSB IAD70II066Incident · No injuriesClosedConvair 580 · Morgantown, WVJun 28, 1970 · N5826 · No damage NTSB IAD70AI065Accident · 3 fatalClosedCessna 310D · West Union, WVJun 26, 1970 · N6841T · Destroyed NTSB IAD70DIJ07Incident · No injuriesClosedCessna 337 · Beaver, WVJun 16, 1970 · N6333F · Minor damage