NTSB investigations, 1973, KS

180,611 investigations by the National Transportation Safety Board since 1962: 174,590 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, 1973, 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\") = 1973
    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 MKC74DCG17Accident · No injuriesClosedCessna 172 · Leawood, KSDec 26, 1973 · N8713B · Substantial damageNTSB MKC74DCQ21Accident · No injuriesClosedCessna 177 · Great Bend, KSDec 22, 1973 · N30335 · Substantial damageNTSB MKC74DCG16Accident · No injuriesClosedCessna 150L · Pleasanton, KSDec 18, 1973 · N18640 · Substantial damageNTSB MKC74AK033Accident · 2 fatalClosedCessna 310L · Manhattan, KSDec 18, 1973 · N3269X · DestroyedNTSB MKC74FCQ20Accident · Serious injuriesClosedCessna 182 · Manhattan, KSDec 3, 1973 · N21357 · Substantial damageNTSB MKC74DCQ19Accident · No injuriesClosedCessna 190 · Bennington, KSDec 1, 1973 · N1502D · Substantial damageNTSB MKC74FCG14Accident · Minor injuriesClosedLuscombe T8-F · Lenexa, KSNov 22, 1973 · N1824B · Substantial damageNTSB MKC74FER23Accident · Serious injuriesClosedBeech V35B · St Paul, KSNov 21, 1973 · N1877W · Substantial damageNTSB MKC74FCQ17Accident · No injuriesClosedPiper PA-24 · Larned, KSNov 19, 1973 · N8131P · Substantial damageNTSB MKC74AK024Accident · No injuriesClosedPiper PA-32 · Topeka, KSNov 16, 1973 · N3412W · Substantial damageNTSB MKC74FCQ18Accident · No injuriesClosedPiper PA-23 · Colby, KSNov 12, 1973 · N3237P · Substantial damageNTSB MKC74DCQ16Accident · No injuriesClosedPiper PA-23 · Salina, KSNov 2, 1973 · N6503Y · Minor damageNTSB MKC74AK019Accident · 1 fatalClosedBoeing B75N1 · Spring Hill, KSOct 21, 1973 · N121M · DestroyedNTSB MKC74FCG13Accident · No injuriesClosedBeech TC-45J · Lawrence, KSOct 17, 1973 · N200KU · Substantial damageNTSB MKC74DCQ15Accident · No injuriesClosedBoeing A75 · Plains, KSOct 13, 1973 · N75847 · Substantial damageNTSB MKC74AK017Accident · 1 fatalClosedMooney M20E · Cassoday, KSOct 9, 1973 · N6985U · DestroyedNTSB MKC74DCQ14Accident · No injuriesClosedCessna 172 · Inman, KSSep 10, 1973 · N3734F · Substantial damageNTSB MKC74AK010Accident · 4 fatalClosedCessna 182B · Leawood, KSSep 7, 1973 · N2430G · DestroyedNTSB MKC74DCQ13Accident · No injuriesClosedSmith Trmite · Goodland, KSSep 6, 1973 · N59322 · Substantial damageNTSB MKC74DCQ12Accident · No injuriesClosedPiper PA-25 · Almena, KSSep 5, 1973 · N4976Y · Substantial damageNTSB MKC74AK009Accident · 1 fatalClosedLuscombe 8E · Harper, KSSep 3, 1973 · N1655K · DestroyedNTSB MKC74AK008Accident · 1 fatalClosedCessna 150J · Emporia, KSAug 28, 1973 · N60410 · Substantial damageNTSB MKC74DCQ10Accident · No injuriesClosedPiper PA-28 · Hays, KSAug 27, 1973 · N5722U · Substantial damageNTSB MKC74DCQ09Accident · No injuriesClosedCessna 140 · Goodland, KSAug 26, 1973 · N4190N · Substantial damageNTSB MKC74DCQ08Accident · No injuriesClosedMooney M20E · Hugoton, KSAug 23, 1973 · N5743Q · Substantial damageNTSB MKC74FCQ07Accident · Serious injuriesClosedBeech B19 · Wichita, KSAug 14, 1973 · N1923W · Substantial damageNTSB MKC74DCQ06Accident · No injuriesClosedCessna 188 · Lakin, KSAug 4, 1973 · N711RM · Substantial damageNTSB MKC74DCQ05Accident · No injuriesClosedCessna 210J · Johnson, KSAug 4, 1973 · N3365S · Substantial damageNTSB MKC74FCQ11Accident · No injuriesClosedBoeing A75L · Ingalls, KSAug 3, 1973 · N9383H · Substantial damageNTSB MKC74FCQ04Accident · Serious injuriesClosedFairchild M62C · Garden City, KSAug 3, 1973 · N57606 · Substantial damageNTSB MKC74DCQ02Accident · No injuriesClosedCessna 150 · Ashland, KSAug 1, 1973 · N60051 · Substantial damageNTSB MKC74DCQ03Accident · Minor injuriesClosedPiper PA-25 · Grove, KSJul 27, 1973 · N4927Y · Substantial damageNTSB MKC74DCQ01Accident · No injuriesClosedCessna 188A · Sublette, KSJul 26, 1973 · N5685J · Substantial damageNTSB MKC73DCQ38Accident · No injuriesClosedCessna 188 · North Fowler, KSJun 27, 1973 · N9899V · Substantial damageNTSB MKC73FCQ36Accident · No injuriesClosedHughes 369HS · Wichita, KSJun 7, 1973 · CF-IAD · Substantial damageNTSB MKC73DCQ37Accident · No injuriesClosedCessna 172D · Councl Grove, KSJun 3, 1973 · N2630U · Substantial damageNTSB MKC73DCQ35Accident · No injuriesClosedAeronca 7AC · Hunter, KSJun 3, 1973 · N84055 · Substantial damageNTSB MKC73DCG48Accident · Minor injuriesClosedBoeing B75N1 · Garnett, KSMay 30, 1973 · N75567 · Substantial damageNTSB MKC73AK071Accident · 1 fatalClosedBeech 95-B55 · Wichita, KSMay 27, 1973 · N306H · DestroyedNTSB MKC73AK069Accident · 1 fatalClosedBeech B35 · Mulvane, KSMay 26, 1973 · N5164C · DestroyedNTSB MKC73FCG42Accident · No injuriesClosedTaylorcraft BL-65 · Leavenworth, KSMay 23, 1973 · N27492 · 2 aircraft · Substantial damageNTSB MKC73DCQ33Accident · No injuriesClosedPiper PA-28 · Marysville, KSMay 23, 1973 · N5579F · Substantial damageNTSB MKC73DCQ32Accident · No injuriesClosedCessna 182A · Yates Center, KSMay 22, 1973 · N4817D · Substantial damageNTSB MKC73FCQ34Accident · No injuriesClosedCessna 182L · Scandia, KSMay 20, 1973 · N3182R · Substantial damageNTSB MKC73FCG41Accident · Serious injuriesClosedPiper PA-28 · Burlington, KSMay 20, 1973 · N95152 · DestroyedNTSB MKC73AK067Accident · No injuriesClosedCessna 182P · Yates Center, KSMay 18, 1973 · N7074Q · DestroyedNTSB MKC73DCQ31Accident · No injuriesClosedGrumman G-164A · Mccune, KSMay 16, 1973 · N4698 · Substantial damageNTSB MKC73FCQ30Accident · Serious injuriesClosedPiper PA-25 · Meade, KSMay 12, 1973 · N7277Z · DestroyedNTSB MKC73AK066Accident · 4 fatalClosedBeech E90 · Pratt, KSMay 10, 1973 · YV-TADJ · DestroyedNTSB MKC73DCQ29Accident · Minor injuriesClosedBoeing A75N1 · Pittsburg, KSMay 4, 1973 · N54782 · Substantial damage