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 IAD78FA094Accident · 4 fatalClosedPiper PA-28 · Hemlock, WVAug 13, 1978 · N8789W · Destroyed NTSB IAD78FIJ18Accident · Serious injuriesClosedCessna 414 · Bluefield, WVAug 4, 1978 · N33BN · Destroyed NTSB IAD78FIJ17Accident · Serious injuriesClosedCessna 210A · Parkersburg, WVJul 7, 1978 · N9452X · Substantial damage NTSB IAD78FIG11Accident · Minor injuriesClosedCessna 172 · Martinsburg, WVJun 27, 1978 · N7847T · Substantial damage NTSB IAD78DIJ16Accident · No injuriesClosedPiper PA-28 · New Martinsvl, WVJun 25, 1978 · N7706C · Substantial damage NTSB IAD78FIJ15Accident · Minor injuriesClosedCessna 182E · Charleston, WVJun 23, 1978 · N2992Y · Substantial damage NTSB IAD78FIJ14Accident · Serious injuriesClosedCessna 172 · Hopeville, WVJun 10, 1978 · N2689L · Destroyed NTSB IAD78FIJ13Accident · Minor injuriesClosedCessna 150 · Thomas, WVJun 6, 1978 · N60233 · Substantial damage NTSB IAD78FIJ12Accident · Minor injuriesClosedCessna 182L · Man, WVJun 4, 1978 · N42366 · Substantial damage NTSB IAD78FA069Accident · No injuriesClosedAerospatial SA341G · Wharton, WVMay 31, 1978 · N9988F · Substantial damage NTSB IAD78DIJ09Accident · No injuriesClosedPiper PA-32 · Morgantown, WVFeb 5, 1978 · N55193 · Substantial damage NTSB IAD78IA037Incident · No injuriesClosedBeech B99 · Morgantown, WVJan 31, 1978 · N8558R · Minor damage NTSB IAD78FA033Accident · Minor injuriesClosedBeech B99A · Clarksburg, WVJan 17, 1978 · N1924T · Substantial damage NTSB IAD78FA021Accident · No injuriesClosedPiper PA-32R · Buckhannon, WVDec 11, 1977 · N200HM · Substantial damage NTSB IAD78DIJ05Accident · No injuriesClosedCessna 172 · Fairmont, WVDec 4, 1977 · N5738T · Substantial damage NTSB IAD78FIJ04Accident · Minor injuriesClosedVarga 2150A · Charleston, WVDec 1, 1977 · N5071V · Substantial damage NTSB IAD78DIJ03Accident · No injuriesClosedCessna 180 · Belington, WVNov 27, 1977 · N3480Y · Substantial damage NTSB IAD78FIJ07Accident · Serious injuriesClosedRockwell 114 · Parkersburg, WVNov 25, 1977 · N4872W · Substantial damage NTSB IAD78FA014Accident · 6 fatalClosedPiper PA-31T · Beckley, WVNov 24, 1977 · N801HD · Destroyed NTSB IAD78DIJ02Accident · Minor injuriesClosedCessna 150 · Summersville, WVNov 5, 1977 · N2905J · Substantial damage NTSB IAD77FA067Accident · 1 fatalClosedPiper PA-32R · Williamson, WVSep 22, 1977 · N8653C · Destroyed NTSB IAD78FA012Accident · 1 fatalClosedPiper PA28 · Ashford, WVSep 14, 1977 · N9483J · Destroyed NTSB IAD77FIJ10Accident · Serious injuriesClosedBeech C23 · Charleston, WVAug 17, 1977 · N18788 · Destroyed NTSB IAD77FA059Accident · 4 fatalClosedBeech 58 · Parkersburg, WVAug 12, 1977 · N9265Q · Destroyed NTSB IAD77FIJ08Accident · No injuriesClosedBeech 19 · Charleston, WVAug 10, 1977 · N1925L · Substantial damage NTSB IAD77FIG23Accident · No injuriesClosedCessna 210 · Martinsburg, WVJul 4, 1977 · N6633X · Substantial damage NTSB IAD77FA041Accident · 1 fatalClosedPiper PA-34 · Bridgeport, WVMay 26, 1977 · N1153H · Destroyed NTSB IAD77FIJ07Accident · Minor injuriesClosedCessna 150 · Charleston, WVMay 18, 1977 · N9110U · Substantial damage NTSB IAD77FGM22Accident · No injuriesClosedCessna 172 · New Cumberland, WVMay 7, 1977 · N8237L · Substantial damage NTSB IAD77FA039Accident · 3 fatalClosedPiper PA-31 · Taplin, WVMay 6, 1977 · N7439L · Destroyed NTSB IAD77FA031Accident · 1 fatalClosedPiper PA-28 · Morgantown, WVMar 25, 1977 · N1500J · Destroyed NTSB IAD77DIJ06Accident · No injuriesClosedHughes 269C · Clarksburg, WVMar 24, 1977 · N9571F · Substantial damage NTSB IAD77FIG12Accident · Serious injuriesClosedCessna 150E · Berkley Sprngs, WVMar 6, 1977 · N3081J · Destroyed NTSB IAD77FIJ04Accident · Serious injuriesClosedBellanca 17-30 · Point Pleasant, WVJan 29, 1977 · N4862V · Substantial damage NTSB IAD77FIG07Accident · No injuriesClosedCessna 172 · Mathias, WVNov 25, 1976 · N3982F · Substantial damage NTSB IAD77FIG08Accident · Serious injuriesClosedPiper PA-22 · Lost River, WVNov 24, 1976 · N6718B · Destroyed NTSB IAD77DIJ01Accident · No injuriesClosedCessna 310K · Weston, WVOct 15, 1976 · N7070L · Substantial damage NTSB IAD76FIJ19Accident · No injuriesClosedPiper PA-30 · Daybrook, WVSep 13, 1976 · N7972Y · Substantial damage NTSB IAD76FIJ18Accident · No injuriesClosedCessna 180 · Daybrook, WVSep 12, 1976 · N2631Y · Substantial damage NTSB IAD76DIJ16Accident · No injuriesClosedPiper PA-22 · Morgantown, WVAug 26, 1976 · N8689C · Substantial damage NTSB IAD76DIG25Accident · No injuriesClosedSchleicher AS-K14 · Mineral County, WVAug 16, 1976 · N169US · Destroyed NTSB IAD76FIJ15Accident · Minor injuriesClosedCessna 210 · Pineville, WVAug 8, 1976 · N123BD · Substantial damage NTSB IAD76FGN39Accident · Minor injuriesClosedGrum Amer AA-1B · New Cumberland, WVJul 13, 1976 · N1609R · Substantial damage NTSB IAD76FIJ13Accident · Serious injuriesClosedCessna 182L · Parkersburg, WVJul 12, 1976 · N3481R · Substantial damage NTSB IAD76AI077Accident · No injuriesClosedPiper PA-32R · Davis, WVJun 22, 1976 · N4505X · Substantial damage NTSB IAD76AI069Accident · 1 fatalClosedPiper PA-30 · Charleston, WVMay 3, 1976 · N7075Y · Destroyed NTSB IAD76AI067Accident · 1 fatalClosedCessna T337C · Williamstown, WVApr 16, 1976 · N2477S · Destroyed NTSB IAD76DIJ12Accident · No injuriesClosedHughes 369HS · Albright, WVApr 12, 1976 · N9188F · Substantial damage NTSB IAP76AI064Accident · 2 fatalClosedCessna 310Q · Ranelle, WVApr 4, 1976 · N7663Q · Destroyed NTSB IAD76FIJ10Accident · Serious injuriesClosedPiper PA-28 · Greenwood, WVFeb 29, 1976 · N6438J · Destroyed