NTSB investigations, 1981, KS

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1981, 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\") = 1981
    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 MKC82FCG15Accident · Serious injuriesClosedVarga 2150A · Topeka, KSDec 24, 1981 · N8256J · Substantial damageNTSB MKC82FCG14Accident · No injuriesClosedCessna 421C · Olathe, KSDec 22, 1981 · N990MB · Substantial damageNTSB MKC82FA012Accident · 2 fatalClosedCessna 172N · Hillsboro, KSDec 13, 1981 · N734EF · DestroyedNTSB MKC82DCQ07Accident · No injuriesClosedPiper PA-28 · Moscow, KSDec 6, 1981 · N5510F · Substantial damageNTSB MKC82DCQ06Accident · No injuriesClosedCessna 182 · Garden City, KSNov 29, 1981 · N759GC · Substantial damageNTSB MKC82FA009Accident · 5 fatalClosedCessna 177A · Ellinwood, KSNov 25, 1981 · N30288 · DestroyedNTSB MKC82FCG11Accident · Serious injuriesClosedCessna 182P · Olathe, KSNov 23, 1981 · N9164M · Substantial damageNTSB MKC82DCQ05Accident · No injuriesClosedCessna 182 · Yates Center, KSNov 17, 1981 · N2336G · Substantial damageNTSB MKC82DCQ04Accident · No injuriesClosedCessna P210N · Fort Scott, KSNov 11, 1981 · N4834K · Substantial damageNTSB MKC82DCQ03Accident · No injuriesClosedPiper PA-24 · Wichita, KSNov 6, 1981 · N6243P · Substantial damageNTSB MKC82FCG04Accident · No injuriesClosedPiper PA-28R · Kansas City, KSOct 28, 1981 · N55222 · Substantial damageNTSB MKC82DCQ02Accident · No injuriesClosedPiper PA-23 · Goodland, KSOct 18, 1981 · N5096Y · Substantial damageNTSB MKC82FCQ01Accident · Minor injuriesClosedBeech M35 · Garden City, KSOct 12, 1981 · N9766R · DestroyedNTSB MKC81DCQ51Accident · No injuriesClosedCessna 152 · Hays, KSSep 22, 1981 · N49009 · Substantial damageNTSB MKC81FA053Accident · 4 fatalClosedAero Comdr 685 · Kansas City, KSSep 4, 1981 · N777MM · DestroyedNTSB MKC81FCQ48Accident · Minor injuriesClosedCessna T210N · Wichita, KSAug 31, 1981 · N4673C · Substantial damageNTSB MKC81FCQ49Accident · Minor injuriesClosedCessna 177RG · Leoti, KSAug 27, 1981 · N1579H · Substantial damageNTSB MKC81DCQ50Accident · No injuriesClosedPiper PA-25 · Ness City, KSAug 22, 1981 · N8501L · Substantial damageNTSB MKC81FCG53Accident · Serious injuriesClosedFlybaby 1A-BIS · Paola, KSAug 14, 1981 · N59229 · Substantial damageNTSB MKC81DCQ47Accident · No injuriesClosedSpartan 7W · Phillipsburg, KSAug 3, 1981 · N17658 · Substantial damageNTSB MKC81DA047Accident · 1 fatalClosedPitts S-1 · Dodge City, KSAug 1, 1981 · N1ES · DestroyedNTSB MKC81FA043Accident · 4 fatalClosedBeech 58TC · Kansas City, KSJul 23, 1981 · N17705 · DestroyedNTSB MKC81FCG51Accident · No injuriesClosedCessna 210J · Olathe, KSJul 18, 1981 · N3380S · Substantial damageNTSB MKC81DCQ46Accident · No injuriesClosedCessna 150 · Coldwater, KSJul 18, 1981 · N8853G · Substantial damageNTSB MKC81DCQ45Accident · No injuriesClosedPiper PA-22 · Moran, KSJul 2, 1981 · N7700D · Substantial damageNTSB MKC81FA040Accident · 1 fatalClosedCessna 404 · Belton, KSJun 30, 1981 · N6810N · DestroyedNTSB MKC81FCG41Accident · No injuriesClosedTravel Air D4D · Kansas City, KSJun 21, 1981 · N434P · Substantial damageNTSB MKC81DCQ44Accident · No injuriesClosedBeech C23 · Fowler, KSJun 20, 1981 · N23824 · Substantial damageNTSB MKC81DCQ43Accident · No injuriesClosedBell 47G-2 · Sublette, KSJun 20, 1981 · N7735 · Substantial damageNTSB MKC81FCQ42Accident · No injuriesClosedCessna U206C · Wichita, KSJun 16, 1981 · N71900 · Substantial damageNTSB MKC81FCG39Accident · No injuriesClosedCessna 182Q · Paola, KSJun 11, 1981 · N735SV · Substantial damageNTSB MKC81DCQ41Accident · Minor injuriesClosedGrumman AA-5A · Beaumont, KSJun 7, 1981 · N9839V · DestroyedNTSB MKC81DCQ40Accident · No injuriesClosedCessna A152 · Eldorado, KSJun 6, 1981 · N761EL · Substantial damageNTSB MKC81FCQ39Accident · No injuriesClosedPiper PA-24 · Emporia, KSJun 4, 1981 · N6621P · Substantial damageNTSB MKC81FCQ35Accident · Minor injuriesClosedStinson 108-2 · Valley Center, KSMay 31, 1981 · N97899 · Substantial damageNTSB MKC81DCQ37Accident · No injuriesClosedCessna 172L · Sublette, KSMay 31, 1981 · N7855G · Substantial damageNTSB MKC81DCQ36Accident · No injuriesClosedCessna A188-B · Murdock, KSMay 31, 1981 · N731WP · DestroyedNTSB MKC81FCQ38Accident · No injuriesClosedCessna 180 · Mankato, KSMay 30, 1981 · N9305C · Substantial damageNTSB MKC81FA037Accident · Minor injuriesClosedCessna 210N · Olathe, KSMay 27, 1981 · N7317A · Substantial damageNTSB MKC81FCQ34Accident · Minor injuriesClosedCessna 177RG · Newton, KSMay 23, 1981 · N45354 · DestroyedNTSB MKC81FA036Accident · 2 fatalClosedCessna 172 · Carbondale, KSMay 22, 1981 · N4509E · DestroyedNTSB MKC81DCQ33Accident · Serious injuriesClosedPiper PA-25 · Ingalls, KSApr 29, 1981 · N82438 · Substantial damageNTSB MKC81DCQ31Accident · No injuriesClosedCessna 172 · Manhattan, KSApr 26, 1981 · N20317 · DestroyedNTSB MKC81DCQ32Accident · No injuriesClosedPitts S-1S · Conway Springs, KSApr 25, 1981 · N80PF · Substantial damageNTSB MKC81FCQ30Accident · No injuriesClosedCessna 188 · Selden, KSApr 18, 1981 · N8107G · Substantial damageNTSB MKC81FCQ29Accident · Serious injuriesClosedCessna 172 · Cullison, KSApr 18, 1981 · N8379B · DestroyedNTSB MKC81FCQ28Accident · 1 fatalClosedAyers S2R-34 · Hillsboro, KSApr 17, 1981 · N4122X · DestroyedNTSB MKC81FCQ27Accident · Serious injuriesClosedCessna 188B · Roxbury, KSApr 15, 1981 · N86236 · DestroyedNTSB MKC81FCQ25Accident · Minor injuriesClosedCessna A188B · Mcpherson, KSApr 12, 1981 · N21738 · Substantial damageNTSB MKC81DCQ26Accident · No injuriesClosedCessna 182 · Moundridge, KSApr 10, 1981 · N42611 · Destroyed