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 IAD76AI053Accident · 3 fatalClosedPiper PA-39 · Clover Lick, WVJan 21, 1976 · N8868Y · Destroyed NTSB IAD76AI052Accident · 2 fatalClosedAero Comdr 560A · Elkins, WVJan 21, 1976 · N91NR · Destroyed NTSB IAD76FIJ09Accident · Serious injuriesClosedCessna 172C · Lansing, WVNov 16, 1975 · N1632Y · Substantial damage NTSB IAD76II032Incident · No injuriesClosedPiper PA-23 · Beckley, WVNov 12, 1975 · N100BA · Minor damage NTSB IAD76AI028Accident · 6 fatalClosedBeech C90 · Charleston, WVNov 4, 1975 · N221MJ · Destroyed NTSB IAD76DIJ07Accident · No injuriesClosedBeech C23 · Summersville, WVNov 1, 1975 · N9295S · Substantial damage NTSB IAD76FIJ06Accident · No injuriesClosedCessna 150G · Leading Creek, WVOct 12, 1975 · N4680X · Destroyed NTSB IAD76FIG05Accident · No injuriesClosedHelio Acft H395 · Martinsburg, WVOct 12, 1975 · N4160D · Substantial damage NTSB IAD76FIJ05Accident · Serious injuriesClosedBell 47G4 · Tams Mt, WVSep 26, 1975 · N73943 · Substantial damage NTSB IAD76AI017Accident · 2 fatalClosedCessna 172K · Parkersburg, WVSep 20, 1975 · N7272G · Destroyed NTSB IAD76FGM07Accident · Minor injuriesClosedCessna 150G · New Cumberland, WVSep 18, 1975 · N1795Z · Substantial damage NTSB IAD76FIJ04Accident · No injuriesClosedCessna 170A · Charleston, WVSep 16, 1975 · N9544A · Substantial damage NTSB IAD76FIJ03Accident · Serious injuriesClosedCessna 150 · Cottageville, WVSep 10, 1975 · N71925 · Substantial damage NTSB IAD76FGM06Accident · No injuriesClosedCessna 172H · New Cumberland, WVSep 2, 1975 · N8237L · Substantial damage NTSB IAD76AI011Accident · 3 fatalClosedBeech B24R · Gerrardstown, WVAug 31, 1975 · N2535W · Destroyed NTSB IAD76FIJ02Accident · Minor injuriesClosedCessna 210L · Poca, WVJul 26, 1975 · N59196 · Substantial damage NTSB NYC75AN003Accident · 2 fatalClosedCessna 177RG · Gilbert, WVJul 6, 1975 · N25JC · Destroyed NTSB IAD76FIJ01Accident · No injuriesClosedPiper PA-28 · Weston, WVJul 6, 1975 · N8848J · Substantial damage NTSB IAD75FIJ20Accident · No injuriesClosedPiper PA-28 · Taplin, WVJun 28, 1975 · N4469T · Substantial damage NTSB IAD75FIJ19Accident · No injuriesClosedBell 47G-4A · Monterville, WVJun 24, 1975 · N7888S · Substantial damage NTSB IAD75AI067Accident · 2 fatalClosedAeronca 7GCBC · West Hamlin, WVJun 24, 1975 · N8345V · Destroyed NTSB IAD75FIJ17Accident · No injuriesClosedBeech C23 · Beaver, WVApr 4, 1975 · N24676 · Substantial damage NTSB IAD75AI055Accident · 1 fatalClosedLuscombe 8E · Amma, WVApr 2, 1975 · N1879K · Destroyed NTSB IAD75AI054Accident · 1 fatalClosedBoeing A75N1 · Morgantown, WVApr 2, 1975 · N52485 · Destroyed NTSB IAD75DIJ16Accident · No injuriesClosedCessna 182 · Glenville, WVMar 18, 1975 · N6436A · Substantial damage NTSB IAD75FIJ14Accident · No injuriesClosedCessna 182H · Charleston, WVMar 12, 1975 · N3461S · Substantial damage NTSB IAD75II051Incident · No injuriesClosedBeech 99 · Morgantown, WVMar 11, 1975 · N8558R · Minor damage NTSB IAD75DI213Accident · No injuriesClosedEnstrom F-28A · Willow Is, WVDec 24, 1974 · N9278 · Substantial damage NTSB NYC75FGM20Accident · No injuriesClosedBeech A90 · Wheeling, WVNov 21, 1974 · N52C · Substantial damage NTSB IAD75FIJ12Accident · No injuriesClosedCessna 172 · Ellamore, WVNov 20, 1974 · N8614U · Substantial damage NTSB IAD75AI029Accident · 3 fatalClosedPiper PA-28 · Morgantown, WVNov 9, 1974 · N6545J · Destroyed NTSB IAD75AIJ11Accident · No injuriesClosedCessna 172 · Hazelgreen, WVOct 24, 1974 · N7242A · Destroyed NTSB IAD75FIJ10Accident · Minor injuriesClosedBell 47G4A · Wayne, WVOct 17, 1974 · N8124J · Destroyed NTSB IAD75AI018Accident · 1 fatalClosedPiper PA-22 · Huntington, WVOct 4, 1974 · N1822P · Destroyed NTSB IAD75FIJ08Accident · Serious injuriesClosedPiper PA-28 · Elkins, WVAug 31, 1974 · N56845 · Destroyed NTSB IAD75FGM08Accident · No injuriesClosedCessna 172 · N Cumberland, WVAug 26, 1974 · N174KA · Substantial damage NTSB IAD75DIG04Accident · No injuriesClosedCessna 182N · Slanesville, WVAug 25, 1974 · N92816 · Substantial damage NTSB IAD75DIJ04Accident · No injuriesClosedPiper PA-24 · Morgantown, WVAug 13, 1974 · N5676P · Substantial damage NTSB IAD75DIJ03Accident · Serious injuriesClosedBell 47G2A1 · Layland, WVAug 10, 1974 · N1215W · Substantial damage NTSB IAD75FIJ05Accident · No injuriesClosedAero Sport D-260 · Hurricane, WVAug 4, 1974 · N3669 · Substantial damage NTSB IAD75FIJ06Accident · No injuriesClosedBeech 65-80 · Charleston, WVAug 1, 1974 · N242Q · Substantial damage NTSB IAD75AI003Accident · No injuriesClosedCessna 172K · Hinton, WVJul 23, 1974 · N79031 · Substantial damage NTSB IAD75FIJ02Accident · No injuriesClosedPiper PA-28 · Morgantown, WVJul 18, 1974 · N203CB · Substantial damage NTSB IAD75FIJ01Accident · No injuriesClosedPiper PA-22 · Fayetteville, WVJul 17, 1974 · N3748A · Substantial damage NTSB IAD74DIG28Accident · Minor injuriesClosedCessna 172G · Petersburg, WVJun 11, 1974 · N4638L · Substantial damage NTSB NYC74AM106Accident · 1 fatalClosedPiper PA-28 · Huntington, WVJun 8, 1974 · N7302F · Destroyed NTSB IAD74AI067Accident · 2 fatalClosedPiper PA-28 · Harper Ferry, WVJun 7, 1974 · N9979W · Destroyed NTSB IAD74DIJ17Accident · No injuriesClosedCessna 140 · Gary, WVMay 24, 1974 · N72829 · Destroyed NTSB IAD74DIJ16Accident · No injuriesClosedPiper PA-28 · S.Charleston, WVMay 17, 1974 · N9442J · Substantial damage NTSB IAD74FIJ15Accident · No injuriesClosedCessna 172 · Charlestown, WVMay 12, 1974 · N78600 · Substantial damage