NTSB investigations, 1969, WV

180,630 investigations by the National Transportation Safety Board since 1962: 174,609 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.

Cases per year

19632026
NTSB investigations, 1969, WV per year, 1963–2026: 869 cases
19631
196420
196528
196626
196721
196831
196935
197032
197116
197228
197323
197431
197525
197618
197721
197819
197928
198021
198121
198216
198318
198417
198521
19867
19879
198822
198913
199016
199113
199216
199311
19949
19955
199613
199715
19988
19998
20007
200115
20027
200311
200412
20057
20067
20076
20083
200911
201010
20119
20127
20135
20146
20153
20168
20176
20183
20194
20201
20214
20225
20236
202410
20254
202610

Latest cases

Query with SQL
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 year(c.\"eventDate\") = 1969
    AND 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.

NTSB IAD70D0124Accident · Minor injuriesClosedCessna 150 · Poca, WVDec 13, 1969 · N5662G · Substantial damageNTSB IAD70F0108Accident · Minor injuriesClosedChampion 7ECA · Martinsburg, WVNov 11, 1969 · N9503S · Substantial damageNTSB IAD70F0101Accident · Minor injuriesClosedPiper J-3 · Glendale, WVOct 19, 1969 · N21631 · DestroyedNTSB IAD70D0096Accident · No injuriesClosedPiper PA-12 · Buckhannon, WVOct 5, 1969 · N3395M · Substantial damageNTSB IAD70D0094Accident · No injuriesClosedPiper PA-28 · Buckhannon, WVOct 4, 1969 · N5409W · Substantial damageNTSB IAD70I0024Incident · No injuriesClosedHoward Aero 500 · Wheeling, WVOct 3, 1969 · N8020 · Minor damageNTSB IAD70D0098Accident · No injuriesClosedCessna 182 · Charleston, WVOct 1, 1969 · N3421R · Substantial damageNTSB IAD70D0077Accident · No injuriesClosedAeronca 7AC · Talcott, WVSep 22, 1969 · N83410 · Substantial damageNTSB IAD70A0022Accident · 2 fatalClosedPiper PA-23 · M Of Seneca, WVSep 20, 1969 · N6834Y · DestroyedNTSB IAD70D0093Accident · No injuriesClosedPiper PA-24 · Parkersburg, WVSep 13, 1969 · N5508P · Substantial damageNTSB IAD70F0092Accident · No injuriesClosedPiper PA-22 · Fayetteville, WVSep 9, 1969 · N6075D · Substantial damageNTSB IAD70D0091Accident · No injuriesClosedAeronca 7AC · Buckhannon, WVAug 23, 1969 · N84528 · Substantial damageNTSB IAD70A0014Accident · No injuriesClosedBeech D18S · Martinsburg, WVAug 15, 1969 · N273C · Substantial damageNTSB DIA70F0039Accident · Minor injuriesClosedBellanca 14-13 · Vally Chapel, WVAug 4, 1969 · N74294 · Substantial damageNTSB IAD70A0010Accident · 2 fatalClosedCougar I · Landisberg, WVJul 30, 1969 · N196D · DestroyedNTSB DIA70I0009Incident · No injuriesClosedNord-Avion 262 · Charleston, WVJul 29, 1969 · N26203 · No damageNTSB IAD70A0008Accident · 3 fatalClosedCessna 172 · Amherstdale, WVJul 27, 1969 · N8460X · DestroyedNTSB DIA70F0022Accident · No injuriesClosedCessna 150 · Fayetteville, WVJul 16, 1969 · N23385 · Substantial damageNTSB DIA70A0001Accident · No injuriesClosedHoward Aero 500 · Charleston, WVJul 10, 1969 · N320L · DestroyedNTSB DIA70F0028Accident · Serious injuriesClosedChampion 7AC · Charles Town, WVJul 4, 1969 · N83944 · DestroyedNTSB DIA69A0070Accident · 4 fatalClosedCessna 172 · Charleston, WVJun 29, 1969 · N5936R · DestroyedNTSB IAD70F0015Accident · No injuriesClosedPiper PA-30 · Kenova, WVJun 26, 1969 · N7196Y · Substantial damageNTSB DIA69A0067Accident · 2 fatalClosedCessna 182E · East Bank, WVJun 9, 1969 · N2960Y · DestroyedNTSB DIA69F0209Accident · No injuriesClosedAeronca 65-LB · Wh Sul Sprgs, WVJun 4, 1969 · N31845 · Substantial damageNTSB DIA69D0208Accident · No injuriesClosedCessna 177 · Philippi, WVMay 30, 1969 · N2329Y · DestroyedNTSB DIA70F0026Accident · No injuriesClosedPiper PA-22 · Weirton, WVMay 29, 1969 · N6859B · Substantial damageNTSB DIA70F0035Accident · No injuriesClosedCessna 336 · Taplin, WVMay 25, 1969 · N3834U · Substantial damageNTSB DIA69A0059Accident · No injuriesClosedCessna 182 · Taplin, WVApr 22, 1969 · N71748 · Substantial damageNTSB DIA69D0165Accident · No injuriesClosedSikorsky S-55 · Alderson, WVMar 30, 1969 · N1562 · Substantial damageNTSB DIA69D0155Accident · Minor injuriesClosedCessna 177 · Chester, WVMar 9, 1969 · N30229 · Substantial damageNTSB DIA69D0152Accident · No injuriesClosedSikorsky S-55 · Alderson, WVFeb 28, 1969 · N1562 · Substantial damageNTSB DIA69I0043Incident · No injuriesClosedNord-Avion 262A12 · Elkins, WVFeb 12, 1969 · N26203 · Minor damageNTSB DIA69A0038Accident · 1 fatalClosedCessna 150D · Martinsburg, WVFeb 1, 1969 · N5900T · DestroyedNTSB DIA69F0136Accident · Serious injuriesClosedCessna 337C · Wiley Ford, WVJan 14, 1969 · N2464S · DestroyedNTSB DIA69A0029Accident · No injuriesClosedBeech D18S · Kenna, WVJan 6, 1969 · N2913B · Substantial damage