NTSB investigations, 1964, KS

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.

Cases per year

19632026
NTSB investigations, 1964, KS per year, 1963–2026: 2,834 cases
19632
1964134
1965112
1966134
1967136
1968109
1969106
197092
197191
197281
197365
197484
197584
197691
197785
197867
197983
198060
198171
198259
198363
198449
198555
198652
198735
198836
198916
199035
199128
199223
199325
199432
199533
199630
199730
199822
199932
200020
200114
200219
200320
200425
200518
200619
200724
200827
200919
201018
201115
201222
201324
201415
201524
201620
201718
201817
201919
202011
202115
202215
202321
202413
20259
202611

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\" = 'KS' 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 UNK65X1160Accident · No injuriesClosedPiper PA28 · Wichita, KSDec 27, 1964 · N7700W · Substantial damageNTSB UNK65X1153Accident · No injuriesClosedCessna 182 · Wichita, KSDec 27, 1964 · N9232X · Substantial damageNTSB UNK65X1130Accident · No injuriesClosedErcoupe 415C · Phillipsbur, KSDec 25, 1964 · N3804H · Substantial damageNTSB UNK65X1121Accident · 1 fatalClosedPiper PA-24 · Hutchinson, KSDec 24, 1964 · N8463P · Substantial damageNTSB UNK65X1079Accident · No injuriesClosedCessna 337 · Wichita, KSDec 21, 1964 · N2119X · Substantial damageNTSB UNK65X1074Accident · No injuriesClosedCessna 140 · Bonner Springs, KSDec 20, 1964 · N89799 · Substantial damageNTSB UNK65X0993Accident · No injuriesClosedCessna 182 · Olathe, KSDec 12, 1964 · N2316G · 2 aircraft · Minor damageNTSB UNK65X0987Accident · No injuriesClosedMooney M20B · Emporia, KSDec 12, 1964 · N74587 · Substantial damageNTSB UNK65X0985Accident · Minor injuriesClosedCessna 172 · Larned, KSDec 12, 1964 · N8812B · DestroyedNTSB UNK65X0983Accident · No injuriesClosedBeechcraft S35 · Plainfield, KSDec 12, 1964 · N6864Q · Substantial damageNTSB UNK65X0930Accident · No injuriesClosedPiper PA22 · Marquette, KSDec 5, 1964 · N3652A · Substantial damageNTSB UNK65X0923Accident · No injuriesClosedPiper PA22 · Kansas City, KSDec 5, 1964 · N8298C · Substantial damageNTSB UNK65X0920Accident · No injuriesClosedCessna 170B · Fall River, KSDec 5, 1964 · N2265D · DestroyedNTSB UNK65X0815Accident · Serious injuriesClosedAeronca 65TC · Salina, KSNov 24, 1964 · N34474 · DestroyedNTSB UNK65X0810Accident · No injuriesClosedBeechcraft B90 · Newton, KSNov 23, 1964 · N13309 · Substantial damageNTSB UNK65X0792Accident · No injuriesClosedStinson 108 · Emporia, KSNov 22, 1964 · N97350 · Substantial damageNTSB UNK65X0780Accident · No injuriesClosedPiper PA-12 · Atchison, KSNov 21, 1964 · N3889M · Substantial damageNTSB UNK65X0769Accident · No injuriesClosedPiper PA-24 · Olathe, KSNov 21, 1964 · N6822P · Substantial damageNTSB UNK65X0732Accident · Serious injuriesClosedLockheed L-749A · Wichita Kans, KSNov 15, 1964 · N6013C · Minor damageNTSB UNK65X0641Accident · No injuriesClosedBeechcraft K35 · Kansas City, KSNov 10, 1964 · N9507R · Substantial damageNTSB UNK65X0483Accident · No injuriesClosedBeechcraft 35 · Smith Center, KSOct 30, 1964 · N4540V · Substantial damageNTSB UNK65X0469Accident · No injuriesClosedLuscombe 8A · Olathe, KSOct 29, 1964 · N1985B · Substantial damageNTSB UNK65X0451Accident · No injuriesClosedBeechcraft C35 · Salina, KSOct 27, 1964 · N5905C · Substantial damageNTSB UNK65X0369Accident · No injuriesClosedMooney M20 · Wichita, KSOct 22, 1964 · N866B · Substantial damageNTSB UNK65X0316Accident · No injuriesClosedPiper PA22 · Topeka, KSOct 18, 1964 · N3171Z · Substantial damageNTSB UNK65X0304Accident · No injuriesClosedCessna 206 · Emporia, KSOct 17, 1964 · N5019U · Substantial damageNTSB UNK65X0291Accident · Minor injuriesClosedPiper PA28 · Topeka, KSOct 16, 1964 · N8703W · DestroyedNTSB UNK65X0246Accident · No injuriesClosedBeechraft 35 · Sabetha, KSOct 11, 1964 · N442B · Substantial damageNTSB UNK65X0243Accident · No injuriesClosedCessna 182 · Lawrence, KSOct 11, 1964 · N3560U · Substantial damageNTSB UNK65X0241Accident · No injuriesClosedCessna 172 · Windom, KSOct 11, 1964 · N7536T · Substantial damageNTSB UNK65X0220Accident · No injuriesClosedPiper PA24 · Atchison, KSOct 10, 1964 · N5024P · Substantial damageNTSB UNK65X0182Accident · No injuriesClosedBeechcraft 95 · Ness City, KSOct 7, 1964 · N2700Y · Substantial damageNTSB UNK64X4205Accident · No injuriesClosedMooney MK21 · Holsinton, KSSep 29, 1964 · N133W · Substantial damageNTSB UNK64X4190Accident · No injuriesClosedPiper PA-22 · Osage City, KSSep 28, 1964 · N1814A · Substantial damageNTSB UNK64X3942Accident · No injuriesClosedCessna 140 · Bloom, KSSep 12, 1964 · N1806V · Substantial damageNTSB UNK64X3875Accident · No injuriesClosedPiper PA-22 · Liberal, KSSep 8, 1964 · N8908D · Substantial damageNTSB UNK64X3836Accident · Serious injuriesClosedScheibe SF26A · Phillipsburg, KSSep 6, 1964 · N1151Q · Substantial damageNTSB UNK64X3801Accident · No injuriesClosedBeechraft 23 · Osawatomie, KSSep 5, 1964 · N2359L · Substantial damageNTSB UNK64X3796Accident · No injuriesClosedMooney M20 · Kansas City, KSSep 5, 1964 · N6501U · Substantial damageNTSB UNK64X3635Accident · 2 fatalClosedCessna P206 · Wichita, KSAug 27, 1964 · N8464Z · Substantial damageNTSB UNK64X3628Accident · No injuriesClosedBeechcraft M23 · Liberal, KSAug 27, 1964 · N2303Q · Substantial damageNTSB UNK64X3580Accident · No injuriesClosedCessna 182 · Topeka, KSAug 25, 1964 · N6161B · Substantial damageNTSB UNK64X3574Accident · Minor injuriesClosedCessna 170 · Hays, KSAug 24, 1964 · N4612C · DestroyedNTSB UNK64X3564Accident · Minor injuriesClosedBeechcraft F35 · Haddam, KSAug 23, 1964 · N3868B · Substantial damageNTSB UNK64X3454Accident · No injuriesClosedBeechcraft M23 · Wichita, KSAug 18, 1964 · N2390J · Substantial damageNTSB UNK64X3398Accident · No injuriesClosedCessna 150 · Frankfort, KSAug 15, 1964 · N5539E · Substantial damageNTSB UNK64X3345Accident · No injuriesClosedPiper PA24 · Fall River, KSAug 12, 1964 · N7797P · Substantial damageNTSB UNK64X3316Accident · No injuriesClosedCessna 172 · Hill City, KSAug 10, 1964 · N8812B · Substantial damageNTSB UNK64X3311Accident · No injuriesClosedBell 47D1 · Rose Hill, KSAug 9, 1964 · N9713C · Substantial damageNTSB UNK64X3290Accident · No injuriesClosedBeechcraft 35 · Meade Lake, KSAug 9, 1964 · N3758N · Substantial damage