Skip to content

NTSB investigations, WV

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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 NYC67A0061Accident · 4 fatalClosedPiper PA-22 · Maysville, WVOct 16, 1966 · N3473A · Destroyed NTSB NYC67A0060Accident · 1 fatalClosedLockheed L-18 · Short Creek, WVOct 13, 1966 · N131E · Destroyed NTSB NYC67D0325Accident · No injuriesClosedCessna 140A · Sutton, WVOct 12, 1966 · N5619C · Substantial damage NTSB NYC67F0305Accident · Serious injuriesClosedCessna 175 · Beaver, WVOct 6, 1966 · N7174M · Substantial damage NTSB NYC67A0056Accident · 1 fatalClosedPiper PA-30 · Ceredo, WVSep 30, 1966 · N7472Y · Destroyed NTSB NYC67D0324Accident · No injuriesClosedPiper PA-12 · Bluefield, WVAug 18, 1966 · N4346M · Substantial damage NTSB NYC67F0193Accident · No injuriesClosedAero Cmdr 500-B · Elkins, WVAug 16, 1966 · N2001 · Substantial damage NTSB NYC67A0025Accident · Minor injuriesClosedNord 262 · Martinsburg, WVAug 11, 1966 · N26212 · Substantial damage NTSB NYC67A0023Accident · Serious injuriesClosedNord-Avion 262A12 · Morgantown, WVAug 4, 1966 · N26207 · Substantial damage NTSB NYC67F0161Accident · No injuriesClosedCessna 337 · N.Cumberland, WVJul 23, 1966 · N6363F · Substantial damage NTSB NYC67A0012Accident · 1 fatalClosedBell 47G-2 · Hinton, WVJul 14, 1966 · N7889B · Destroyed NTSB NYC67F0129Accident · No injuriesClosedAeronca 7FC · New Cumbrlnd, WVJul 11, 1966 · N9882B · Substantial damage NTSB NYC67D0216Accident · No injuriesClosedPiper PA-22 · Bellington, WVJul 10, 1966 · N5847Z · Destroyed NTSB NYC67D0202Accident · No injuriesClosedCessna 182F · Clarksburg, WVJul 3, 1966 · N3153U · Substantial damage NTSB NYC67D0201Accident · No injuriesClosedPiper PA-18 · Clarksburg, WVJul 1, 1966 · N4206Z · Substantial damage NTSB NYC66F0695Accident · No injuriesClosedGlobe GC1B · Philippi, WVMay 15, 1966 · N77753 · Substantial damage NTSB NYC66F0702Accident · No injuriesClosedCessna 205 · Charleston, WVMay 13, 1966 · N8215Z · Substantial damage NTSB NYC66A0112Accident · 2 fatalClosedCessna 172D · Princeton, WVApr 5, 1966 · N2486U · Destroyed NTSB NYC66F0673Accident · Minor injuriesClosedAeronca 7AC · Union, WVMar 21, 1966 · N2732E · Destroyed NTSB NYC66F0530Accident · Minor injuriesClosedPiper PA-28 · Chester, WVMar 3, 1966 · N5586W · Substantial damage NTSB NYC66D0698Accident · Minor injuriesClosedCessna 172 · Charleston, WVDec 30, 1965 · N2413U · Substantial damage NTSB NYC66D0419Accident · Minor injuriesClosedPiper PA-16 · Spencer, WVDec 1, 1965 · N5977H · Substantial damage NTSB NYC66A0061Accident · Serious injuriesClosedCessna 172 · Petersburg, WVNov 30, 1965 · N8147U · Minor damage NTSB NYC66F0270CaseClosedCessna 180D · Morgantown, WVOct 2, 1965 · CF-NRD NTSB NYC66F0243Accident · No injuriesClosedCessna 150 · Weston, WVSep 5, 1965 · N8602S · Substantial damage NTSB NYC66D0286Accident · No injuriesClosedCessna 140 · Cameron, WVSep 5, 1965 · N76651 · Substantial damage NTSB NYC66F0235Accident · Minor injuriesClosedStinson 108-2 · Oak Hill, WVSep 4, 1965 · N9429K · Substantial damage NTSB NYC66D0298Accident · Minor injuriesClosedCessna 172 · Coburn, WVAug 16, 1965 · N2430Y · Destroyed NTSB NYC66D0176Accident · No injuriesClosedLuscombe 8E · Culloden, WVAug 4, 1965 · N2188B · Substantial damage NTSB NYC66F0297Accident · No injuriesClosedPiper PA-28 · Weirton, WVJul 26, 1965 · N6407W · Substantial damage NTSB NYC66F0161Accident · No injuriesClosedDehavilland M3 · Bridgeport, WVJul 16, 1965 · N6876D · Substantial damage NTSB NYC66F0128Accident · No injuriesClosedBeechcraft M-35 · Kenova, WVJul 16, 1965 · N9303Y · Substantial damage NTSB NYC66A0007Accident · 5 fatalClosedBeechcraft C-45G · Parkersburg, WVJul 13, 1965 · N2818G · Destroyed NTSB NYC66D0109Accident · No injuriesClosedPiper PA-22 · Buckhannon, WVJul 1, 1965 · N3362Z · Substantial damage NTSB NYC66F0068Accident · No injuriesClosedPiper PA-24 · Huntington, WVJun 27, 1965 · N6818P · Substantial damage NTSB NYC66D0182Accident · No injuriesClosedAeronca 7AC · Pickens, WVJun 23, 1965 · N1766E · Substantial damage NTSB NYC66D0017Accident · No injuriesClosedCessna 172 · Greenbank, WVJun 13, 1965 · N7165A · Substantial damage NTSB NYC65A0143Accident · 1 fatalClosedLuscombe 8A · 2e Littleton, WVJun 7, 1965 · N72044 · Destroyed NTSB NYC66D0018Accident · No injuriesClosedCessna 172 · Hillsboro, WVMay 24, 1965 · N8774B · Substantial damage NTSB NYC65F0238Accident · No injuriesClosedStinson 108 · Kingwood, WVMay 16, 1965 · N97709 · Destroyed NTSB NYC66F0008Accident · No injuriesClosedCessna 150 · Huntington, WVApr 17, 1965 · N3031J · Substantial damage NTSB NYC65A0125Accident · No injuriesClosedBell Tomcat · Harman, WVApr 17, 1965 · N6590D · Substantial damage NTSB NYC65D0153Accident · No injuriesClosedSwift GC-1B · Morgantown, WVApr 12, 1965 · N3876K · Substantial damage NTSB NYC65F0132Accident · No injuriesClosedAero Cmdr 560E · Wiley Ford, WVApr 1, 1965 · N6231D · Substantial damage NTSB NYC65D0180Accident · No injuriesClosedCessna 172 · Parsons, WVMar 12, 1965 · N5550T · Substantial damage NTSB UNK65X1470Accident · 4 fatalClosedBeechcraft E-18S · Bridgeport, WVMar 10, 1965 · N844K · Destroyed NTSB NYC65I0104Incident · No injuriesClosedLockheed 18 · Wheeling, WVFeb 14, 1965 · N678L · No damage NTSB UNK65X1318Accident · Serious injuriesClosedCessna 172 · Wellsburg, WVJan 19, 1965 · N7775U · Substantial damage NTSB UNK65X1180Accident · No injuriesClosedPiper PA28 · Morgantown, WVDec 29, 1964 · N6337W · Substantial damage NTSB NYC65A0089Accident · 2 fatalClosedCessna 182G · Kasson, WVDec 17, 1964 · N3283S · Destroyed