NTSB investigations, 1965, KS

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, 1965, 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\") = 1965
    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 MKC66F0336Accident · Minor injuriesClosedCessna U206 · Augusta, KSDec 31, 1965 · N8059Z · Substantial damageNTSB MKC66D0371Accident · No injuriesClosedMooney M20A · Kansas City, KSDec 31, 1965 · N6562B · Substantial damageNTSB MKC66D0335Accident · No injuriesClosedCessna 182 · Wichita, KSDec 31, 1965 · N2621F · Substantial damageNTSB MKC66D0334Accident · Minor injuriesClosedCessna 172 · Wichita, KSDec 19, 1965 · N7648X · DestroyedNTSB MKC66D0436Accident · No injuriesClosedCessna 170 · Russell, KSDec 9, 1965 · N8001A · Substantial damageNTSB MKC66D0348Accident · No injuriesClosedAeronca 7AC · Lincoln, KSDec 8, 1965 · N83703 · No damageNTSB UNK66X0113Accident · No injuriesClosedErcoupe 415-C · Stafford, KSDec 5, 1965 · N99578 · Substantial damageNTSB MKC66A0033Accident · 1 fatalClosedAeronca 11AC · Iola, KSDec 5, 1965 · N9749E · DestroyedNTSB MKC66F0309Accident · No injuriesClosedBeechcraft J35 · Salina, KSNov 14, 1965 · N8797D · Substantial damageNTSB MKC66F0318Accident · Minor injuriesClosedPiper PA-22 · Salina, KSNov 12, 1965 · N1669A · Substantial damageNTSB MKC66F0304Accident · No injuriesClosedLuscombe 8C · Wellington, KSNov 8, 1965 · N28617 · Substantial damageNTSB MKC66F0350Accident · Serious injuriesClosedForney F-1 · Burrton, KSNov 5, 1965 · N3011G · DestroyedNTSB MKC66F0319Accident · Serious injuriesClosedGlobe GC-1B · Salina, KSOct 29, 1965 · N93072 · Substantial damageNTSB MKC66F0302Accident · No injuriesClosedCessna 210 · Oakley, KSOct 26, 1965 · N9643T · Substantial damageNTSB MKC66D0299Accident · No injuriesClosedPiper PA-28 · Wichita, KSOct 23, 1965 · N8746W · Substantial damageNTSB MKC66F0275Accident · No injuriesClosedMooney M20C · Carbondale, KSOct 17, 1965 · N1374W · Substantial damageNTSB MKC66D0310Accident · No injuriesClosedLuscombe 8A · Coffeyville, KSOct 9, 1965 · N71368 · Substantial damageNTSB MKC66D0281Accident · Minor injuriesClosedCessna 140 · Holton, KSOct 9, 1965 · N76939 · Substantial damageNTSB MKC66F0354Accident · No injuriesClosedPiper PA-28 · Mcpherson, KSOct 8, 1965 · N5332W · Substantial damageNTSB MKC66F0264Accident · No injuriesClosedCessna 310I · Wichita, KSOct 5, 1965 · N8037M · Substantial damageNTSB MKC66D0282Accident · No injuriesClosedCessna 180 · Oakley, KSOct 3, 1965 · N1638C · Substantial damageNTSB MKC66A0021Accident · 1 fatalClosedCessna 188 · Wichita, KSSep 28, 1965 · N3756C · DestroyedNTSB MKC66F0232Accident · Serious injuriesClosedChampion 7FC · Bonner Sprgs, KSSep 26, 1965 · N7580E · Substantial damageNTSB MKC66F0262Accident · No injuriesClosedPiper PA-24 · Wichita, KSSep 25, 1965 · N6839P · Substantial damageNTSB NYC66F0224Accident · Minor injuriesClosedCessna 150F · Gardner, KSSep 18, 1965 · N8257S · Substantial damageNTSB MKC66D0240Accident · No injuriesClosedCessna 140 · Castleton, KSSep 11, 1965 · N3604V · Substantial damageNTSB MKC66A0017Accident · 4 fatalClosedBeechcraft B-95 · Newton, KSSep 11, 1965 · N9695Y · DestroyedNTSB MKC66F0247Accident · No injuriesClosedPiper PA-22 · Atchison, KSSep 7, 1965 · N2438P · Substantial damageNTSB MKC66D0274Accident · No injuriesClosedCessna 150 · Lacygne, KSSep 6, 1965 · N4203U · Substantial damageNTSB MKC66F0246Accident · No injuriesClosedCallair A-5 · Munden, KSSep 4, 1965 · N9956C · Substantial damageNTSB MKC66D0212Accident · No injuriesClosedCessna 180 · Maize, KSSep 4, 1965 · N1577C · Substantial damageNTSB MKC66F0223Accident · No injuriesClosedBeechcraft 23 · Wichita, KSSep 1, 1965 · N2347Z · Substantial damageNTSB MKC66A0014Accident · 2 fatalClosedBeech M35 · Hutchinson, KSAug 31, 1965 · N9731R · DestroyedNTSB MKC66F0204Accident · No injuriesClosedStinson 108-1 · Derby, KSAug 28, 1965 · N97048 · Substantial damageNTSB MKC66F0193Accident · No injuriesClosedMooney M-20 · Kingman, KSAug 27, 1965 · N853B · Substantial damageNTSB MKC66F0173Accident · No injuriesClosedCessna 210E · Wichita, KSAug 26, 1965 · N2312F · Substantial damageNTSB MKC66F0177Accident · No injuriesClosedCessna 180 · Wichita, KSAug 25, 1965 · N2915C · Substantial damageNTSB MKC66A0010Accident · Serious injuriesClosedBoeing B-720B · Leavenworth, KSAug 17, 1965 · N57202 · No damageNTSB MKC66F0167Accident · No injuriesClosedCessna 172 · Wichita, KSAug 15, 1965 · N5945A · Substantial damageNTSB MKC66D0172Accident · Minor injuriesClosedCessna 210 · Ottawa, KSAug 15, 1965 · N9488X · Substantial damageNTSB MKC66F0155Accident · No injuriesClosedCessna 182H · Leawood, KSAug 13, 1965 · N8334S · Substantial damageNTSB MKC66F0171Accident · No injuriesClosedPiper PA-24 · Wichita, KSAug 6, 1965 · N8056P · Substantial damageNTSB MKC66F0120Accident · No injuriesClosedAeronca 7DC · Hill City, KSJul 29, 1965 · N2525E · Substantial damageNTSB MKC66F0110Accident · No injuriesClosedBeechcraft B-50 · Emporia, KSJul 25, 1965 · N3597B · Substantial damageNTSB MKC66A0006Accident · No injuriesClosedBell 47D-1 · Wichita, KSJul 24, 1965 · N9713C · DestroyedNTSB MKC66F0143Accident · No injuriesClosedPiper PA-28 · Kansas City, KSJul 22, 1965 · N6110W · Substantial damageNTSB MKC66F0109Accident · No injuriesClosedLear Jet 23 · Wichita, KSJul 21, 1965 · N388R · Substantial damageNTSB MKC66F0096Accident · No injuriesClosedCessna 210E · Mccracken, KSJul 19, 1965 · N2312F · Substantial damageNTSB MKC66D0103Accident · No injuriesClosedCessna 182 · Gardner, KSJul 17, 1965 · N8412T · Substantial damageNTSB MKC66F0141Accident · Minor injuriesClosedBoeing E75 · Dodge City, KSJul 6, 1965 · N5353N · Destroyed