NTSB investigations, 1964, OK

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

19642026
NTSB investigations, 1964, OK per year, 1964–2026: 2,798 cases
1964108
1965105
1966100
1967134
1968100
196999
197081
1971102
197256
197377
197466
197560
197666
197772
197863
197966
198064
198179
198263
198364
198465
198547
198642
198745
198838
198940
199029
199130
199236
199323
199432
199542
199635
199731
199841
199936
200031
200124
200226
200322
200423
200525
200621
200728
200825
200923
201023
201119
201218
201323
201411
201517
201621
201720
201815
201915
202018
202117
202222
202323
202419
202519
202613

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\") = 1964
    AND c.\"eventStateOrRegion\" = 'OK' 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 UNK65X1203Accident · 2 fatalClosedPiper PA24 · Cushing, OKDec 31, 1964 · N5399P · DestroyedNTSB UNK65X1195Accident · No injuriesClosedPiper PA24 · El Reno, OKDec 31, 1964 · N7124P · Substantial damageNTSB UNK65X1184Accident · No injuriesClosedTaylorcraft DCO · Vinita, OKDec 29, 1964 · N50605 · Substantial damageNTSB UNK65X1159Accident · No injuriesClosedCessna 150 · Cushing, OKDec 27, 1964 · N5779E · Substantial damageNTSB UNK65X1101Accident · No injuriesClosedBeech 35 · Broken Arrow, OKDec 23, 1964 · N2863V · Substantial damageNTSB UNK65X1073Accident · No injuriesClosedPiper PA28 · Elmore City, OKDec 20, 1964 · N5767W · Substantial damageNTSB UNK65X1039Accident · No injuriesClosedGlobe GC1B · Purcell, OKDec 18, 1964 · N3398K · Substantial damageNTSB UNK65X0992Accident · 2 fatalClosedRyan ST3KR · Altus, OKDec 12, 1964 · N88717 · DestroyedNTSB UNK65X0962Accident · Serious injuriesClosedCessna 210 · Sayre, OKDec 9, 1964 · N9554T · Substantial damageNTSB UNK65X0954Accident · No injuriesClosedErcoupe 415C · El Reno, OKDec 8, 1964 · N93578 · Substantial damageNTSB UNK65X0917Accident · Minor injuriesClosedCessna 140A · Ardmore, OKDec 4, 1964 · N5369C · DestroyedNTSB UNK65X0885Accident · No injuriesClosedLuscombe 8A · Colony, OKNov 29, 1964 · N71389 · Substantial damageNTSB UNK65X0880Accident · No injuriesClosedBoeing B-720 · Okla City, OKNov 29, 1964 · N113 · Substantial damageNTSB UNK65X0875Accident · No injuriesClosedCessna 182 · Broken Arrow, OKNov 28, 1964 · N5381B · Substantial damageNTSB UNK65X0767Accident · No injuriesClosedBrantly B2 · Muskogee, OKNov 20, 1964 · N5947X · Substantial damageNTSB UNK65X0744Accident · 1 fatalClosedCessna 140A · Tulsa, OKNov 16, 1964 · N5379C · DestroyedNTSB UNK65X0693Accident · No injuriesClosedBell 47G2A · Yukon, OKNov 13, 1964 · N3355D · Substantial damageNTSB UNK65X0662Accident · 1 fatalClosedMooney M18C · Perry, OKNov 11, 1964 · N484M · DestroyedNTSB UNK65X0661Accident · Serious injuriesClosedDean Case Specl · Fairview, OKNov 11, 1964 · N117Q · DestroyedNTSB UNK65X0635Accident · 2 fatalClosedCessna 206 · Ponca City, OKNov 9, 1964 · N5034U · 2 aircraft · Substantial damageNTSB UNK65X0597Accident · No injuriesClosedCessna 172 · Lawton, OKNov 7, 1964 · N3062U · Substantial damageNTSB UNK65X0388Accident · No injuriesClosedAero Comm 520 · El Reno, OKOct 23, 1964 · N4153B · Substantial damageNTSB UNK65X0238Accident · No injuriesClosedCessna 182 · Cache, OKOct 11, 1964 · N4898D · Substantial damageNTSB UNK65X0190Accident · Minor injuriesClosedCessna C37 · Shawnee, OKOct 8, 1964 · N17057 · DestroyedNTSB UNK64X4088Accident · Serious injuriesClosedLuscombe 8E · Sapulpa, OKSep 21, 1964 · N2045K · Substantial damageNTSB UNK64X4041Accident · Serious injuriesClosedPiper PA15 · Wetumka, OKSep 18, 1964 · N4674H · Substantial damageNTSB UNK64X3978Accident · No injuriesClosedPiper J3 · Guthrie, OKSep 13, 1964 · N25803 · No damageNTSB UNK64X3976Accident · No injuriesClosedPiper PA24 · Okla City, OKSep 13, 1964 · N6747P · Substantial damageNTSB UNK64X3885Accident · No injuriesClosedCessna 140 · El Reno, OKSep 9, 1964 · N2228V · Substantial damageNTSB UNK64X3822Accident · No injuriesClosedStinson 108-1 · Ardmore, OKSep 6, 1964 · N8149K · Substantial damageNTSB UNK64X3812Accident · No injuriesClosedPiper PA24 · Perry, OKSep 6, 1964 · N6839P · Substantial damageNTSB UNK64X3804Accident · 2 fatalClosedTaylorcraft BC-12D · Douglas, OKSep 5, 1964 · N95505 · DestroyedNTSB UNK64X3773Accident · No injuriesClosedPiper PA28 · Kingston, OKSep 4, 1964 · N8702W · Substantial damageNTSB UNK64X3750Accident · Minor injuriesClosedErcoupe 415C · Eufaula, OKSep 3, 1964 · N3206H · Substantial damageNTSB UNK64X3479Accident · No injuriesClosedCessna 182 · Mcalester, OKAug 19, 1964 · N6246A · Substantial damageNTSB UNK64X3252Accident · No injuriesClosedPiper PA24 · Prague, OKAug 7, 1964 · N7137P · Substantial damageNTSB UNK64X3189Incident · No injuriesClosedLockheed L-188A · Tulsa, OKAug 3, 1964 · N6119 · Minor damageNTSB UNK64X3151Accident · No injuriesClosedMooney MK20C · Okla City, OKAug 1, 1964 · N6751U · Substantial damageNTSB UNK64X3049Accident · No injuriesClosedCessna 310F · Durant, OKJul 26, 1964 · N6761X · Substantial damageNTSB UNK64X3048Accident · No injuriesClosedErcoupe 415C · Bartlesville, OKJul 26, 1964 · N94027 · DestroyedNTSB UNK64X3019Accident · No injuriesClosedChampion 7EC · Guymon, OKJul 25, 1964 · N8954B · Substantial damageNTSB UNK64X2998Accident · No injuriesClosedBeech F35 · Okla City, OKJul 23, 1964 · N271S · Substantial damageNTSB UNK64X2853Accident · No injuriesClosedCessna 182 · Weatherford, OKJul 16, 1964 · N3971D · Substantial damageNTSB UNK64X2782Accident · Serious injuriesClosedForney 415C · Purcell, OKJul 12, 1964 · N3244H · DestroyedNTSB UNK64X2756Accident · 1 fatalClosedBeechcraft A45 · Anadarko, OKJul 11, 1964 · N9191R · DestroyedNTSB UNK64X2712Accident · No injuriesClosedCessna 310G · Stillwater, OKJul 8, 1964 · N8943Z · Substantial damageNTSB UNK64X2648Accident · 2 fatalClosedCessna 172 · Tulsa, OKJul 4, 1964 · N6496E · Substantial damageNTSB UNK64X2646Accident · No injuriesClosedMooney MK20D · Gage, OKJul 4, 1964 · N6618U · DestroyedNTSB UNK64X2583Accident · 4 fatalClosedCessna 170B · Muskogee, OKJun 30, 1964 · N2550D · DestroyedNTSB UNK64X2514Accident · No injuriesClosedBeechcraft 23 · Yukon, OKJun 27, 1964 · N2364Z · Substantial damage