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 IAD70DIJ06Accident · No injuriesClosedCessna 150 · Pineville, WVJun 9, 1970 · N6642F · Substantial damage NTSB IAD70FGN19Accident · No injuriesClosedBeech 23 · Wierton, WVMay 29, 1970 · N2359L · Substantial damage NTSB IAD70DIJ04Accident · No injuriesClosedChampion L-16B · Pt Pleasant, WVApr 27, 1970 · N3938A · Substantial damage NTSB IAD70II058Incident · No injuriesClosedNihon YS-11A · Parkersburg, WVApr 6, 1970 · N254P · Minor damage NTSB IAD70AI057Accident · No injuriesClosedNihon YS-11A · Charleston, WVApr 6, 1970 · N189P · Substantial damage NTSB IAD70FIJ02Accident · No injuriesClosedPiper PA-24 · Bridgeport, WVFeb 20, 1970 · N6204P · Substantial damage NTSB IAD70DIJ03Accident · No injuriesClosedCessna 172 · Lewisburg, WVFeb 20, 1970 · N79919 · Substantial damage NTSB IAD70D0124Accident · Minor injuriesClosedCessna 150 · Poca, WVDec 13, 1969 · N5662G · Substantial damage NTSB IAD70F0108Accident · Minor injuriesClosedChampion 7ECA · Martinsburg, WVNov 11, 1969 · N9503S · Substantial damage NTSB IAD70F0101Accident · Minor injuriesClosedPiper J-3 · Glendale, WVOct 19, 1969 · N21631 · Destroyed NTSB IAD70D0096Accident · No injuriesClosedPiper PA-12 · Buckhannon, WVOct 5, 1969 · N3395M · Substantial damage NTSB IAD70D0094Accident · No injuriesClosedPiper PA-28 · Buckhannon, WVOct 4, 1969 · N5409W · Substantial damage NTSB IAD70I0024Incident · No injuriesClosedHoward Aero 500 · Wheeling, WVOct 3, 1969 · N8020 · Minor damage NTSB IAD70D0098Accident · No injuriesClosedCessna 182 · Charleston, WVOct 1, 1969 · N3421R · Substantial damage NTSB IAD70D0077Accident · No injuriesClosedAeronca 7AC · Talcott, WVSep 22, 1969 · N83410 · Substantial damage NTSB IAD70A0022Accident · 2 fatalClosedPiper PA-23 · M Of Seneca, WVSep 20, 1969 · N6834Y · Destroyed NTSB IAD70D0093Accident · No injuriesClosedPiper PA-24 · Parkersburg, WVSep 13, 1969 · N5508P · Substantial damage NTSB IAD70F0092Accident · No injuriesClosedPiper PA-22 · Fayetteville, WVSep 9, 1969 · N6075D · Substantial damage NTSB IAD70D0091Accident · No injuriesClosedAeronca 7AC · Buckhannon, WVAug 23, 1969 · N84528 · Substantial damage NTSB IAD70A0014Accident · No injuriesClosedBeech D18S · Martinsburg, WVAug 15, 1969 · N273C · Substantial damage NTSB DIA70F0039Accident · Minor injuriesClosedBellanca 14-13 · Vally Chapel, WVAug 4, 1969 · N74294 · Substantial damage NTSB IAD70A0010Accident · 2 fatalClosedCougar I · Landisberg, WVJul 30, 1969 · N196D · Destroyed NTSB DIA70I0009Incident · No injuriesClosedNord-Avion 262 · Charleston, WVJul 29, 1969 · N26203 · No damage NTSB IAD70A0008Accident · 3 fatalClosedCessna 172 · Amherstdale, WVJul 27, 1969 · N8460X · Destroyed NTSB DIA70F0022Accident · No injuriesClosedCessna 150 · Fayetteville, WVJul 16, 1969 · N23385 · Substantial damage NTSB DIA70A0001Accident · No injuriesClosedHoward Aero 500 · Charleston, WVJul 10, 1969 · N320L · Destroyed NTSB DIA70F0028Accident · Serious injuriesClosedChampion 7AC · Charles Town, WVJul 4, 1969 · N83944 · Destroyed NTSB DIA69A0070Accident · 4 fatalClosedCessna 172 · Charleston, WVJun 29, 1969 · N5936R · Destroyed NTSB IAD70F0015Accident · No injuriesClosedPiper PA-30 · Kenova, WVJun 26, 1969 · N7196Y · Substantial damage NTSB DIA69A0067Accident · 2 fatalClosedCessna 182E · East Bank, WVJun 9, 1969 · N2960Y · Destroyed NTSB DIA69F0209Accident · No injuriesClosedAeronca 65-LB · Wh Sul Sprgs, WVJun 4, 1969 · N31845 · Substantial damage NTSB DIA69D0208Accident · No injuriesClosedCessna 177 · Philippi, WVMay 30, 1969 · N2329Y · Destroyed NTSB DIA70F0026Accident · No injuriesClosedPiper PA-22 · Weirton, WVMay 29, 1969 · N6859B · Substantial damage NTSB DIA70F0035Accident · No injuriesClosedCessna 336 · Taplin, WVMay 25, 1969 · N3834U · Substantial damage NTSB DIA69A0059Accident · No injuriesClosedCessna 182 · Taplin, WVApr 22, 1969 · N71748 · Substantial damage NTSB DIA69D0165Accident · No injuriesClosedSikorsky S-55 · Alderson, WVMar 30, 1969 · N1562 · Substantial damage NTSB DIA69D0155Accident · Minor injuriesClosedCessna 177 · Chester, WVMar 9, 1969 · N30229 · Substantial damage NTSB DIA69D0152Accident · No injuriesClosedSikorsky S-55 · Alderson, WVFeb 28, 1969 · N1562 · Substantial damage NTSB DIA69I0043Incident · No injuriesClosedNord-Avion 262A12 · Elkins, WVFeb 12, 1969 · N26203 · Minor damage NTSB DIA69A0038Accident · 1 fatalClosedCessna 150D · Martinsburg, WVFeb 1, 1969 · N5900T · Destroyed NTSB DIA69F0136Accident · Serious injuriesClosedCessna 337C · Wiley Ford, WVJan 14, 1969 · N2464S · Destroyed NTSB DIA69A0029Accident · No injuriesClosedBeech D18S · Kenna, WVJan 6, 1969 · N2913B · Substantial damage NTSB DIA69F0123Accident · Minor injuriesClosedMooney M20C · Petersburg, WVDec 16, 1968 · N6816N · Substantial damage NTSB DIA69A0026Accident · No injuriesClosedBoeing 707 · Martinsburg, WVNov 19, 1968 · N7599 · Substantial damage NTSB DIA69A0024Accident · Serious injuriesClosedSud SE3130 · Hamlin, WVNov 3, 1968 · N504 · Destroyed NTSB DIA69D0113Accident · No injuriesClosedCessna 172 · Bridgeport, WVOct 20, 1968 · N2008Y · Substantial damage NTSB DIA69A0018Accident · 1 fatalClosedBeech D-17S · Glenville, WVOct 6, 1968 · N75606 · Destroyed NTSB DIA69F0075Accident · No injuriesClosedPiper PA-22 · Weirton, WVSep 29, 1968 · N8833D · Substantial damage NTSB DCA69A0002Accident · 35 fatalClosedFairchild FH-227 · Charleston, WVAug 10, 1968 · N712U · Destroyed NTSB DIA69A0005Accident · Minor injuriesClosedConvair 580 · Morgantown, WVJul 25, 1968 · N5817 · Substantial damage