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 IAD74DIJ14Accident · Serious injuriesClosedStits SA3B · Rainelle, WVApr 19, 1974 · N5145 · Substantial damage NTSB IAD74AI056Accident · 2 fatalClosedPiper PA-28 · Maysville, WVApr 8, 1974 · N41953 · Destroyed NTSB IAD74FIJ13Accident · No injuriesClosedCessna 310C · Greenbank, WVMar 17, 1974 · N1791H · Substantial damage NTSB IAD74AI045Accident · 4 fatalClosedBeech 65 · Williamstown, WVFeb 24, 1974 · N9535Q · Destroyed NTSB IAD74DIJ12Accident · Minor injuriesClosedDart RP-S1 · Marlinton, WVFeb 17, 1974 · N3116 · Substantial damage NTSB IAD74DIJ10Accident · No injuriesClosedCessna 150F · Minerl Wells, WVJan 27, 1974 · N8048S · Substantial damage NTSB IAD74DIJ09Accident · Minor injuriesClosedPiper PA-28 · Pineville, WVJan 24, 1974 · N7285J · Substantial damage NTSB IAD74AI038Accident · No injuriesClosedCessna 177 · Parkersburg, WVJan 7, 1974 · N34667 · Minor damage NTSB IAD74DIJ08Accident · No injuriesClosedCessna 170A · S Charlstown, WVNov 12, 1973 · N9544A · Substantial damage NTSB IAD74AI023Accident · 2 fatalClosedPiper PA-23 · Riverton, WVOct 31, 1973 · N5141Y · Destroyed NTSB IAD74FIG12Accident · Minor injuriesClosedPiper PA-22 · Maysville, WVOct 14, 1973 · N9204D · Substantial damage NTSB IAD74FIG09Accident · Serious injuriesClosedAmer Avco AA-1B · Springfield, WVSep 2, 1973 · N9694L · Substantial damage NTSB IAD74DIJ02Accident · No injuriesClosedMaule M4220C · Ranger, WVSep 1, 1973 · N2035U · Substantial damage NTSB NYC74ANO10Accident · 4 fatalClosedBeech D55 · Kopperston, WVAug 1, 1973 · N1895A · Destroyed NTSB IAD74FIG05Accident · Serious injuriesClosedEnstrom F-28A · Augusta, WVJul 31, 1973 · N101EB · Destroyed NTSB IAD74FIJ03Accident · Serious injuriesClosedCessna 172 · Mann, WVJul 28, 1973 · N7074G · Substantial damage NTSB IAD74AI006Accident · 4 fatalClosedPiper PA-23 · Ona, WVJul 21, 1973 · N3249P · Destroyed NTSB IAD74AI001Accident · 2 fatalClosedPiper PA-28 · W.Slphr Spg, WVJul 1, 1973 · N1518J · Destroyed NTSB IAD73DIG29Accident · No injuriesClosedPiper PA-18 · Antioch, WVJun 14, 1973 · N4460Z · Destroyed NTSB IAD73FIJ25Accident · 1 fatalClosedBell 47G2A1 · Stickney, WVJun 7, 1973 · N1215W · Destroyed NTSB IAD73AI017Accident · 1 fatalClosedLuscombe 8A · Grafton, WVJun 1, 1973 · N778W · Destroyed NTSB IAD73DIJ23Accident · No injuriesClosedChampion 7GCBC · Spring Hill, WVMay 19, 1973 · N10989 · Substantial damage NTSB IAD73FIJ22Accident · Serious injuriesClosedPiper PA-32 · Fleminton, WVMay 17, 1973 · N3442W · Substantial damage NTSB IAD73DIG26Accident · No injuriesClosedPiper PA-18 · Ridgeley, WVMay 1, 1973 · N9292D · Substantial damage NTSB IAD73FI620Accident · No injuriesClosedCessna 172B · Berkely Spgs, WVMar 11, 1973 · N7764X · Substantial damage NTSB IAD73DIJ21Accident · Serious injuriesClosedSchweizer SGS233 · Huntington, WVMar 6, 1973 · N7535 · Substantial damage NTSB NYC73FIJ20Accident · Minor injuriesClosedCessna T210L · Macfarlan, WVMar 4, 1973 · N22405 · Substantial damage NTSB NYC73AN1L5Accident · 1 fatalClosedCessna 310G · Sutton, WVFeb 22, 1973 · N5025C · Destroyed NTSB NYC73FIJ18Accident · Serious injuriesClosedCessna 172 · Ripley, WVFeb 12, 1973 · N1353Y · Substantial damage NTSB NYC73FIJ16Accident · No injuriesClosedHelio Acft H-295 · Durbin, WVJan 22, 1973 · N6479V · Substantial damage NTSB NYC73FIJ15Accident · No injuriesClosedPiper J3 · Brucetn Mill, WVJan 14, 1973 · N42516 · Substantial damage NTSB NYC73DIJ12Accident · No injuriesClosedBeech 65-A80 · Ceredo, WVDec 11, 1972 · N314Q · Substantial damage NTSB NYC73DIJ13Accident · No injuriesClosedCessna U206 · Willamson, WVNov 26, 1972 · N4955F · Substantial damage NTSB NYC73AN071Accident · 2 fatalClosedPiper PA-28R · Weston, WVNov 23, 1972 · N2335T · Destroyed NTSB NYC73FIG17Accident · No injuriesClosedPiper PA-28 · Martinsburg, WVNov 7, 1972 · N2382T · Substantial damage NTSB NYC73AN060Accident · 3 fatalClosedBeech A36 · Morgantown, WVNov 1, 1972 · N9160Q · Destroyed NTSB NYC73AN055Accident · 1 fatalClosedPiper PA-28 · Keyser, WVOct 28, 1972 · N917HP · Destroyed NTSB NYC73FIJ08Accident · No injuriesClosedPiper PA-22 · Maysel, WVOct 18, 1972 · N3386A · Substantial damage NTSB NYC73DIJ07Accident · No injuriesClosedCessna 182M · Hurricane, WVOct 15, 1972 · N71133 · Substantial damage NTSB NYC73FIJ05Accident · No injuriesClosedHelio H-295 · Pineville, WVSep 23, 1972 · N6462V · Substantial damage NTSB NYC73DIJ06Accident · No injuriesClosedCessna 140 · Buckhannon, WVSep 18, 1972 · N76919 · Substantial damage NTSB NYC73DIJ04Accident · No injuriesClosedAmer Avco AA1-A · Buckhannon, WVSep 4, 1972 · N9453L · Substantial damage NTSB NYC73AN026Accident · 3 fatalClosedAero Comdr 690 · Wellsburg, WVAug 14, 1972 · N1NR · Destroyed NTSB NYC73FIJ01Accident · No injuriesClosedPiper PA-30 · Charleston, WVJul 26, 1972 · N8258Y · Substantial damage NTSB NYC73AN005Accident · 3 fatalClosedMooney M10 · Bridgeport, WVJul 1, 1972 · N9794M · Destroyed NTSB NYC72AN148Accident · Minor injuriesClosedBell 206A · Matewan, WVJun 6, 1972 · N163AC · Substantial damage NTSB NYC72FIG25Accident · Serious injuriesClosedPiper PA-22 · Berkley Spgs, WVMay 26, 1972 · N7192B · Substantial damage NTSB NYC72FIG24Accident · Serious injuriesClosedPiper PA-23 · Charlestown, WVMay 24, 1972 · N4419P · Destroyed NTSB NYC72FGM43Accident · No injuriesClosedAeronca 7AC · New Cumbrlnd, WVApr 29, 1972 · N83075 · Substantial damage NTSB NYC72FGM42Accident · No injuriesClosedPiper PA-28 · New Cumbrlnd, WVApr 28, 1972 · N4522R · Substantial damage