NTSB investigations, 1966, KS

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1966, 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\") = 1966
    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 MKC67A0039Accident · 3 fatalClosedMooney M20E · Hutchinson, KSDec 30, 1966 · N79816 · DestroyedNTSB MKC67D0397Accident · No injuriesClosedPiper PA-28 · Liberal, KSDec 28, 1966 · N8192W · Substantial damageNTSB MKC67D0371Accident · No injuriesClosedCessna 310D · Olathe, KSDec 28, 1966 · N3699D · Substantial damageNTSB MKC67D0415Accident · No injuriesClosedBeech K35 · Great Bend, KSDec 26, 1966 · N3089C · Substantial damageNTSB MKC67F0387Accident · No injuriesClosedPiper PA-23 · Augusta, KSDec 21, 1966 · N2236P · Substantial damageNTSB MKC67D0432Accident · No injuriesClosedMooney M20C · Wichita, KSDec 19, 1966 · N2632W · Substantial damageNTSB MKC67F0420Accident · Minor injuriesClosedCessna 150 · Goddard, KSDec 15, 1966 · N2213J · Substantial damageNTSB MKC67F0422Accident · No injuriesClosedCessna 150G · Manhattan, KSDec 13, 1966 · N3805J · Substantial damageNTSB MKC67F0498Accident · No injuriesClosedCessna 150G · Bogue, KSDec 10, 1966 · N3953J · Substantial damageNTSB MKC67D0533Accident · No injuriesClosedCessna 206 · Kansas City, KSDec 10, 1966 · N2679X · Substantial damageNTSB MKC67F0424Accident · Serious injuriesClosedCessna 150F · Ft.Riley, KSDec 8, 1966 · N7862F · Substantial damageNTSB MKC67D0343Accident · No injuriesClosedPiper PA-28 · Lawrence, KSDec 3, 1966 · N6265W · Substantial damageNTSB MKC67D0342Accident · No injuriesClosedCessna 150 · Olathe, KSDec 3, 1966 · N8080F · Substantial damageNTSB MKC67D0317Accident · No injuriesClosedCessna 180 · Basehor, KSNov 26, 1966 · N5274D · Substantial damageNTSB MKC67D0285Accident · No injuriesClosedPiper J-3 · Bonner Sprgs, KSNov 21, 1966 · N27020 · Substantial damageNTSB MKC67D0332Accident · No injuriesClosedPiper PA-28 · Olathe, KSNov 19, 1966 · N6439W · Substantial damageNTSB MKC67D0348Accident · No injuriesClosedBeech A23 · Hutchinson, KSNov 13, 1966 · N3574R · Substantial damageNTSB MKC67D0316Accident · No injuriesClosedPiper PA-24 · Topeka, KSNov 13, 1966 · N8031P · Substantial damageNTSB MKC67D0312Accident · No injuriesClosedBeech A23 · Garden City, KSNov 3, 1966 · N7912L · Substantial damageNTSB MKC67D0305Accident · No injuriesClosedCessna 150 · Cheney, KSNov 2, 1966 · N3160X · Substantial damageNTSB MKC67D0599Accident · No injuriesClosedCessna 310F · Salina, KSNov 1, 1966 · N6725X · Substantial damageNTSB MKC67D0324Accident · No injuriesClosedMooney M20E · Wallace, KSOct 30, 1966 · N2725W · Substantial damageNTSB MKC67D0329Accident · No injuriesClosedCessna 172 · Topeka, KSOct 29, 1966 · N5947A · Substantial damageNTSB MKC67D0331Accident · No injuriesClosedMooney M20 · Ottawa, KSOct 25, 1966 · N5252B · Substantial damageNTSB MKC67D0253Accident · No injuriesClosedMooney M20C · Dexter, KSOct 24, 1966 · N5543Q · Substantial damageNTSB MKC67D0250Accident · No injuriesClosedBeech P35 · Wichita, KSOct 24, 1966 · N1544Z · Substantial damageNTSB MKC67F0323Accident · Serious injuriesClosedBeech A23-24 · Augusta, KSOct 23, 1966 · N2325W · DestroyedNTSB MKC67F0258Accident · Serious injuriesClosedPiper PA-24 · Kingman, KSOct 23, 1966 · N5723P · Substantial damageNTSB MKC67F0300Accident · No injuriesClosedBeech 23 · Burden, KSOct 22, 1966 · N2302Z · Substantial damageNTSB MKC67D0025Accident · No injuriesClosedCessna 210B · Liberal, KSOct 20, 1966 · N908SW · Substantial damageNTSB MKC67A0028Accident · 2 fatalClosedMooney M20E · Spring Hill, KSOct 13, 1966 · N7113U · DestroyedNTSB MKC68F0331Accident · No injuriesClosedBeech 95-55 · Great Bend, KSOct 6, 1966 · N9453Y · Substantial damageNTSB MKC67F0283Accident · No injuriesClosedBeech 23 · Lawrence, KSOct 5, 1966 · N3560R · Substantial damageNTSB MKC67F0245Accident · No injuriesClosedPiper PA-28 · Dodge City, KSOct 4, 1966 · N6294W · Substantial damageNTSB MKC67F0228Accident · Minor injuriesClosedChampion 7ECA · Stanley, KSSep 23, 1966 · N8394V · Substantial damageNTSB MKC67F0221Accident · Serious injuriesClosedCessna 195 · Hutchinson, KSSep 23, 1966 · N4328V · DestroyedNTSB MKC67F0248Accident · No injuriesClosedBeech B35 · Ottawa, KSSep 21, 1966 · N5045C · Substantial damageNTSB MKC67D0264Accident · No injuriesClosedPiper PA-28 · Wellington, KSSep 15, 1966 · N4692R · Substantial damageNTSB MKC67D0230Accident · Minor injuriesClosedCessna 172 · Caldwell, KSSep 14, 1966 · N4392L · Substantial damageNTSB MKC67F0217Accident · No injuriesClosedAeronca 65-LA · Rose Hill, KSSep 11, 1966 · N24240 · Substantial damageNTSB MKC67D0220Accident · Minor injuriesClosedCessna 150 · Brewster, KSSep 10, 1966 · N4628X · Substantial damageNTSB MKC67D0212Accident · No injuriesClosedCessna 175 · Ashland, KSSep 6, 1966 · N7135M · Substantial damageNTSB MKC67F0206Accident · No injuriesClosedBeech 35 · Toronto, KSSep 4, 1966 · N3149V · Substantial damageNTSB MKC67D0268Accident · No injuriesClosedPiper PA-22 · Larned, KSSep 3, 1966 · N3269Z · Substantial damageNTSB MKC67A0021Accident · 3 fatalClosedPiper PA-28 · Kansas City, KSSep 3, 1966 · N9074W · DestroyedNTSB MKC67F0180Accident · No injuriesClosedMooney M20 · Wichita, KSSep 2, 1966 · N866B · Substantial damageNTSB MKC68D0322Accident · No injuriesClosedBeech A-23A · Garden City, KSSep 1, 1966 · N2327W · Substantial damageNTSB MKC67D0150Accident · No injuriesClosedMooney M20C · Winona, KSAug 26, 1966 · N6841U · Substantial damageNTSB MKC67D0232Accident · No injuriesClosedCessna 150E · Hays, KSAug 25, 1966 · N3028J · Substantial damageNTSB MKC67D0227Accident · No injuriesClosedCessna 150 · Wellington, KSAug 24, 1966 · N6721F · Substantial damage