NTSB investigations, 1980, 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, 1980, 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\") = 1980
    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 MKC81FCQ07Accident · Minor injuriesClosedScorpion 133 · Ulysses, KSDec 27, 1980 · N4990Y · Substantial damageNTSB MKC81FCQ06Accident · No injuriesClosedPiper PA-28 · Wellington, KSDec 18, 1980 · N6847J · Substantial damageNTSB MKC81FA010Accident · No injuriesClosedSwearingen SA226T · Kansas City, KSDec 10, 1980 · N11RM · Substantial damageNTSB MKC81FCQ04Accident · No injuriesClosedPiper PA-28 · Wichita, KSNov 20, 1980 · N8807J · Substantial damageNTSB MKC81FCG16Accident · No injuriesClosedBellanca 17-31 · Kansas City, KSNov 15, 1980 · N103CB · Substantial damageNTSB MKC81FCQ05Accident · Minor injuriesClosedVarieze 01 · Pittsburg, KSNov 11, 1980 · N62MV · Substantial damageNTSB MKC81DA011Accident · No injuriesClosedBarnes AX-7 · Topeka, KSNov 2, 1980 · N27045 · Substantial damageNTSB MKC81DCQ03Accident · No injuriesClosedCassutt 3M · Liberal, KSOct 25, 1980 · N533V · Substantial damageNTSB MKC81DCQ02Accident · No injuriesClosedCessna 182A · Cedar Vale, KSOct 18, 1980 · N991T · Substantial damageNTSB MKC81FCG03Accident · No injuriesClosedBeech 58 · Olathe, KSOct 5, 1980 · N555GP · Substantial damageNTSB MKC81DCQ01Accident · No injuriesClosedHelio Acft H-295 · Johnson, KSOct 4, 1980 · N6469V · Substantial damageNTSB MKC81DCG01Accident · No injuriesClosedStinson 108-1 · Olathe, KSOct 1, 1980 · N97072 · Substantial damageNTSB MKC80DCG48Accident · No injuriesClosedCessna 172 · Holton, KSSep 29, 1980 · N7424A · Substantial damageNTSB MKC80FA058Accident · 1 fatalClosedCessna 172M · Cassoday, KSSep 23, 1980 · N1841V · DestroyedNTSB MKC80DCQ34Accident · No injuriesClosedCessna 150 · Mcpherson, KSSep 20, 1980 · N3540L · Substantial damageNTSB MKC80FCG46Accident · No injuriesClosedCessna 150 · Desoto, KSSep 8, 1980 · N5452Q · Substantial damageNTSB MKC80FA053Accident · 2 fatalClosedTaylorcraft BC12-D · Sedan, KSSep 6, 1980 · N44149 · DestroyedNTSB MKC80DCG44Accident · No injuriesClosedBeech 95-B55 · Olathe, KSSep 5, 1980 · N4267S · Substantial damageNTSB MKC80DCQ33Accident · No injuriesClosedCessna 188 · Protection, KSSep 1, 1980 · N9429G · Substantial damageNTSB MKC80DCQ32Accident · No injuriesClosedCessna 172 · Wichita, KSSep 1, 1980 · N6592D · Substantial damageNTSB MKC80FA052Accident · No injuriesClosedGlobe GC-1B · Benton, KSAug 30, 1980 · N3859K · Substantial damageNTSB MKC80FCQ31Accident · No injuriesClosedCessna 177B · Dodge City, KSAug 21, 1980 · N32549 · Substantial damageNTSB MKC80FCG42Accident · No injuriesClosedCessna 182G · Ft Leavenworth, KSAug 21, 1980 · N2483R · Substantial damageNTSB MKC80DCQ30Accident · No injuriesClosedGrumman G-164B · Cimarron, KSAug 17, 1980 · N6611Q · DestroyedNTSB MKC80DCG39Accident · No injuriesClosedCessna 150J · Horton, KSAug 10, 1980 · N61024 · Substantial damageNTSB MKC80DCQ29Accident · No injuriesClosedCessna 172 · Hoxie, KSAug 8, 1980 · N736FX · Substantial damageNTSB MKC80DCQ28Accident · No injuriesClosedVarieze 01 · Dodge City, KSAug 7, 1980 · N124G · Substantial damageNTSB MKC80DCQ27Accident · No injuriesClosedCessna 140 · El Dorado, KSAug 3, 1980 · N76448 · Substantial damageNTSB MKC80DCQ26Accident · No injuriesClosedCessna 152 · Norwick, KSAug 3, 1980 · N5338M · Substantial damageNTSB MKC80FCQ25Accident · 1 fatalClosedPiper PA-25 · Garden City, KSJul 29, 1980 · N8759L · DestroyedNTSB MKC80FCG34Accident · No injuriesClosedBeech 58 · Kansas City, KSJul 18, 1980 · N4494A · Substantial damageNTSB MKC80DCG33Accident · No injuriesClosedRose A&M Parake · Ottawa, KSJul 17, 1980 · N14883 · Substantial damageNTSB MKC80FA044Accident · No injuriesClosedCessna P210N · Winfield, KSJul 14, 1980 · N731XK · DestroyedNTSB MKC80DCQ23Accident · No injuriesClosedPiper PA-32 · Kiowa, KSJul 1, 1980 · N3532W · Substantial damageNTSB MKC80DCQ24Accident · Minor injuriesClosedCessna 210P · Pratt, KSJun 30, 1980 · N3761P · Substantial damageNTSB MKC80FCQ22Accident · Minor injuriesClosedCessna 150L · Mcpherson, KSJun 24, 1980 · N11319 · DestroyedNTSB MKC80DCQ21Accident · No injuriesClosedPiper PA-36 · Kanorado, KSJun 23, 1980 · N9933P · Substantial damageNTSB MKC80DCQ20Accident · No injuriesClosedCessna 172 · Coldwater, KSJun 16, 1980 · N1297F · Substantial damageNTSB MKC80FCQ19Accident · 1 fatalClosedBenchmark 01 · Newton, KSJun 8, 1980 · N79FG · DestroyedNTSB MKC80FA040Accident · Serious injuriesClosedCessna 337B · Olathe, KSJun 5, 1980 · N2323S · DestroyedNTSB MKC80DCG24Accident · No injuriesClosedCessna 206 · Atchinson, KSJun 3, 1980 · N8611Z · Substantial damageNTSB MKC80FA038Accident · 4 fatalClosedPiper PA-28 · Brookville, KSJun 1, 1980 · N9594K · DestroyedNTSB MKC80DCQ18Accident · No injuriesClosedCessna 172 · Quinter, KSMay 31, 1980 · N73069 · Substantial damageNTSB MKC80DCG23Accident · No injuriesClosedPiper PA-28 · Perry, KSMay 25, 1980 · N2870X · Substantial damageNTSB MKC80FA034Accident · 1 fatalClosedPitts S2S · Olathe, KSMay 7, 1980 · N22EL · DestroyedNTSB MKC80FCQ14Accident · Minor injuriesClosedBucker Jung BU131 · Colwich, KSMay 4, 1980 · N80424 · Substantial damageNTSB MKC80DCQ16Accident · No injuriesClosedBeech 23 · Beaumont, KSMay 4, 1980 · N9150S · Substantial damageNTSB MKC80FCQ15Accident · No injuriesClosedPiper PA-34 · Hays, KSMay 2, 1980 · N47347 · Substantial damageNTSB MKC80FCQ13Accident · Serious injuriesClosedCessna A188B · Winfield, KSApr 23, 1980 · N4760Q · Substantial damageNTSB MKC80DCG20Accident · No injuriesClosedGrumman AA1B · Lebo, KSApr 21, 1980 · N1425R · Substantial damage