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 ATL80FIJ11Accident · No injuriesClosedHiller UH-12E · Beverly, WVSep 12, 1980 · N9735C · Destroyed NTSB NYC80FGM30Accident · No injuriesClosedCessna 182 · New Cumberland, WVSep 3, 1980 · N3054Y · Substantial damage NTSB ATL80FIJ08Accident · Serious injuriesClosedPiper PA-28 · Huntington, WVAug 24, 1980 · N5723U · Substantial damage NTSB ATL80FIJ09Accident · No injuriesClosedCessna T188C · Pineville, WVAug 20, 1980 · N2075J · Substantial damage NTSB ATL80FIJ05Accident · Serious injuriesClosedHiller Acft UH-12E · St Albans, WVJul 8, 1980 · N5370V · Substantial damage NTSB ATL80FIJ04Accident · Minor injuriesClosedGrum Amer AA1-B · Philippi, WVJul 5, 1980 · N9611L · Substantial damage NTSB ATL80DIJ03Accident · No injuriesClosedCessna 182 · Huntington, WVJun 30, 1980 · N3194Y · Substantial damage NTSB ATL80FIJ02Accident · No injuriesClosedHiller Acft UH-12E · Oak Hill, WVMay 12, 1980 · N40289 · Substantial damage NTSB IAD80FA044Accident · 2 fatalClosedCessna 172 · Bethany, WVMay 3, 1980 · N19672 · Destroyed NTSB IAD80FA039Accident · 3 fatalClosedBalloon WKS AX-7 · Hurricane, WVApr 20, 1980 · N40452 · Substantial damage NTSB IAD80IA038Incident · No injuriesClosedNamc YS-11A · Beckley, WVApr 18, 1980 · N224P · Minor damage NTSB IAD80FIG07Accident · Minor injuriesClosedCessna 150K · Keyser, WVApr 6, 1980 · N6273G · Destroyed NTSB IAD80FA035Accident · 2 fatalClosedPiper PA-28 · Elk Garden, WVApr 1, 1980 · N8796E · Destroyed NTSB IAD80FA033Accident · 1 fatalClosedMooney M20C · Beckley, WVMar 25, 1980 · N44Z · Destroyed NTSB IAD80DIG06Accident · No injuriesClosedSchweizer 1-26C · Charlestown, WVMar 9, 1980 · N2781Z · Substantial damage NTSB IAD80FA021Accident · 1 fatalClosedBeech E55 · Amherstdale, WVJan 22, 1980 · N39PG · Destroyed NTSB IAD80FA014Accident · 4 fatalClosedPiper PA-32 · Davis, WVNov 25, 1979 · N3409W · Destroyed NTSB IAD80FA005Accident · 1 fatalClosedRockwell 114 · Bethany, WVOct 11, 1979 · N4989W · Destroyed NTSB IAD79DA091Incident · No injuriesClosedBeech 200 · Charleston, WVSep 27, 1979 · N200EA · No damage NTSB IAD79DA085Accident · No injuriesClosedCessna 150 · Lansing, WVSep 19, 1979 · N1499Q · Destroyed NTSB IAD79FIJ14Accident · No injuriesClosedPiper PA-28 · Point Pleasant, WVSep 12, 1979 · N4573Q · Substantial damage NTSB IAD79FA081Accident · 1 fatalClosedCessna 172 · Elkins, WVSep 10, 1979 · N80979 · Destroyed NTSB IAD79FA074Accident · Serious injuriesClosedCessna 120 · Riverton, WVSep 5, 1979 · N3000N · Destroyed NTSB IAD79FIJ13Accident · Minor injuriesClosedCessna 175 · Parkersburg, WVAug 25, 1979 · N6975E · Substantial damage NTSB IAD79DIJ11Accident · No injuriesClosedBell 47G-4A · Kentuck, WVAug 20, 1979 · N13PL · Substantial damage NTSB IAD79FGN43Accident · No injuriesClosedCessna A150K · Herron, WVAug 13, 1979 · N8448M · Substantial damage NTSB IAD79FIJ10Accident · Serious injuriesClosedForney F-1 · Fayetteville, WVJul 31, 1979 · N7501C · Substantial damage NTSB IAD79FGN34Accident · Minor injuriesClosedCessna 150 · Moundsville, WVJul 14, 1979 · N1614Q · Substantial damage NTSB IAD79DIJ09Accident · No injuriesClosedBell 206 · Gary, WVJul 6, 1979 · N90315 · Substantial damage NTSB IAD79FA060Accident · No injuriesClosedMooney M20G · Bluefield, WVJul 5, 1979 · N6791N · 2 aircraft · Substantial damage NTSB IAD79FA059Accident · No injuriesClosedCessna 310L · Summerville, WVJun 28, 1979 · N3288X · Substantial damage NTSB IAD79FA058Accident · 3 fatalClosedCessna 421B · Charleston, WVJun 19, 1979 · N69733 · Destroyed NTSB IAD79FA054Accident · Serious injuriesClosedDouglas DC-6B · Charleston, WVJun 6, 1979 · AN-BFN · Destroyed NTSB IAD79DIJ07Accident · No injuriesClosedHughes 369D · Amherstdale, WVMay 30, 1979 · N8674F · Substantial damage NTSB IAD79FA050Accident · 1 fatalClosedBeech D-18 · Charleston, WVMay 25, 1979 · N1812D · Destroyed NTSB IAD79PGN26Accident · No injuriesClosedCessna 172 · New Cumberland, WVMay 19, 1979 · N1109F · Substantial damage NTSB IAD79FIJ06Accident · No injuriesClosedCessna 172L · Fayetteville, WVMay 14, 1979 · N3987Q · Substantial damage NTSB IAD79FA049Accident · 1 fatalClosedPiper PA-24 · Welch, WVMay 13, 1979 · N8179P · Destroyed NTSB IAD79DIJ04Accident · No injuriesClosedPiper PA-28 · Point Pleasant, WVApr 26, 1979 · N3028E · Substantial damage NTSB IAD79FIJ05Accident · No injuriesClosedMaule M5-235 · Daybrook, WVApr 21, 1979 · N5630Y · Substantial damage NTSB IAD79FIG04Accident · No injuriesClosedBeech B55 · Kearneysville, WVMar 14, 1979 · N13Q · Substantial damage NTSB DCA79AA008Accident · 2 fatalClosedFrakes M298 · Clarksburg, WVFeb 12, 1979 · N29824 · Destroyed NTSB IAD79FIJ03Accident · No injuriesClosedCessna 337 · Huntington, WVFeb 10, 1979 · N86397 · No damage NTSB IAD79FA029Accident · Serious injuriesClosedCessna 310Q · Beckley, WVJan 26, 1979 · N7671Q · Substantial damage NTSB IAD79FIJ02Accident · No injuriesClosedCessna 182P · Fayetteville, WVDec 11, 1978 · N1197M · Substantial damage NTSB IAD79FA020Accident · 3 fatalClosedPiper PA-24 · Marlinton, WVNov 23, 1978 · N5022P · Destroyed NTSB IAD79FA013Accident · 1 fatalClosedCessna 152 · Spencer, WVNov 18, 1978 · N7359B · Destroyed NTSB IAD78IA009Incident · No injuriesClosedNord 262A · Clarksburg, WVNov 7, 1978 · N29811 · No damage NTSB IAD79FA005Accident · 2 fatalClosedPiper PA-28 · Harpers Ferry, WVOct 27, 1978 · N38463 · Destroyed NTSB IAD78FIJ19Accident · Minor injuriesClosedMooney M20F · Charleston, WVSep 7, 1978 · N6464Q · Destroyed