Skip to content

NTSB investigations, 1974, KS

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1974, KS per year, 1963–2026: 2,834 cases
1963	2
1964	134
1965	112
1966	134
1967	136
1968	109
1969	106
1970	92
1971	91
1972	81
1973	65
1974	84
1975	84
1976	91
1977	85
1978	67
1979	83
1980	60
1981	71
1982	59
1983	63
1984	49
1985	55
1986	52
1987	35
1988	36
1989	16
1990	35
1991	28
1992	23
1993	25
1994	32
1995	33
1996	30
1997	30
1998	22
1999	32
2000	20
2001	14
2002	19
2003	20
2004	25
2005	18
2006	19
2007	24
2008	27
2009	19
2010	18
2011	15
2012	22
2013	24
2014	15
2015	24
2016	20
2017	18
2018	17
2019	19
2020	11
2021	15
2022	15
2023	21
2024	13
2025	9
2026	11

Where

Latest cases

Query with SQL

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") = 1974 AND c."eventStateOrRegion" = 'KS' AND c."eventCountry" = 'USA' ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\") = 1974
    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.

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") = 1974
  AND c."eventStateOrRegion" = 'KS' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB MKC75DCQ31Accident · No injuriesClosedBeech J35 · Scott City, KSDec 29, 1974 · N7269B · Substantial damage NTSB MKC75FCG24Accident · Minor injuriesClosedBeech P35 · Leawood, KSDec 23, 1974 · N1582S · Substantial damage NTSB MKC75DCQ26Accident · No injuriesClosedCessna 172 · Conway, KSDec 12, 1974 · N8857B · Substantial damage NTSB MKC75ACQ28Accident · No injuriesClosedBeech 95-B55 · Phillipsburg, KSDec 11, 1974 · N5603K · Substantial damage NTSB MKC75DCQ25Accident · No injuriesClosedPiper PA-28 · St Francis, KSNov 27, 1974 · N6367J · Substantial damage NTSB MKC75DCG20Accident · No injuriesClosedCessna 150 · Olathe, KSNov 24, 1974 · N6420F · Substantial damage NTSB MKC75FCQ24Accident · Minor injuriesClosedHughes 269C · Greenwich, KSNov 20, 1974 · N8968F · Substantial damage NTSB MKC75DCQ23Accident · No injuriesClosedAmer Avco AA1-B · Norton, KSNov 14, 1974 · N9971L · Substantial damage NTSB MKC75AK026Accident · 1 fatalClosedHughes 269C · Topeka, KSNov 1, 1974 · N9648F · Destroyed NTSB MKC75AK025Accident · 1 fatalClosedCessna 172 · Abilene, KSOct 25, 1974 · N7300T · Destroyed NTSB MKC75FCQ21Accident · Serious injuriesClosedBeech A24R · Caney, KSOct 9, 1974 · N9768L · Destroyed NTSB MKC75FCQ20Accident · Minor injuriesClosedGrumman G-21 · Wichita, KSOct 9, 1974 · N75333 · Substantial damage NTSB MKC75DCQ19Accident · No injuriesClosedChampion 7GCBC · Marysville, KSOct 9, 1974 · N1852G · Substantial damage NTSB MKC75FCQ22Accident · 2 fatalClosedPlayboy SA-3B · Goodland, KSOct 8, 1974 · N19MM · Destroyed NTSB MKC75AK023Accident · No injuriesClosedBeech E18S · Topeka, KSOct 7, 1974 · N995H · Substantial damage NTSB MKC75FCQ18Accident · No injuriesClosedCessna 177 · Spivey, KSOct 2, 1974 · N29581 · Substantial damage NTSB MKC75FCG16Accident · No injuriesClosedPiper PA-30 · Leavenworth, KSOct 2, 1974 · N88BA · Substantial damage NTSB MKC75FCQ16Accident · Serious injuriesClosedCessna 140 · Moline, KSSep 19, 1974 · N76254 · Destroyed NTSB MKC75FCQ15Accident · No injuriesClosedBeech 58 · Wichita, KSSep 18, 1974 · N416D · Substantial damage NTSB MKC75DCQ17Accident · No injuriesClosedErco 415-C · Hill City, KSSep 15, 1974 · N2012H · Substantial damage NTSB MKC75FCG13Accident · No injuriesClosedCessna 150 · Kansas City, KSSep 8, 1974 · N3369J · Substantial damage NTSB MKC75DCQ14Accident · Minor injuriesClosedPiper PA-28 · Iola, KSAug 31, 1974 · N5659U · Substantial damage NTSB MKC75AK016Accident · 3 fatalClosedCessna 177B · Moundridge, KSAug 30, 1974 · N34478 · Destroyed NTSB MKC75FCQ13Accident · Minor injuriesClosedGrumman G-164 · Valley Ctr, KSAug 29, 1974 · N10283 · Substantial damage NTSB MKC75AK014Accident · 1 fatalClosedCessna 414 · Woodbine, KSAug 22, 1974 · N911BS · Destroyed NTSB MKC75DCQ11Accident · No injuriesClosedCessna 140 · Argonia, KSAug 16, 1974 · N76520 · Substantial damage NTSB MKC75FCJ19Accident · Serious injuriesClosedCessna 188A · Summerfield, KSAug 14, 1974 · N2452U · Substantial damage NTSB MKC75DCG11Accident · No injuriesClosedCessna 172 · Gardner, KSAug 13, 1974 · N13230 · Substantial damage NTSB MKC75FCQ12Accident · Minor injuriesClosedBellanca 7KCAB · Liberal, KSAug 12, 1974 · N41823 · Substantial damage NTSB MKC75FCG10Accident · No injuriesClosedPiper PA-28 · Meridan, KSAug 11, 1974 · N5125W · Substantial damage NTSB MKC75FCG09Accident · Minor injuriesClosedCessna 177 · Mclouth, KSAug 4, 1974 · N29545 · Substantial damage NTSB MKC75DCQ10Accident · No injuriesClosedPiper PA-28 · Larned, KSAug 3, 1974 · N5683U · Substantial damage NTSB MKC75DCQ09Accident · No injuriesClosedCessna 337D · Ulysses, KSAug 2, 1974 · N86238 · Substantial damage NTSB MKC75DCG06Accident · No injuriesClosedCessna 172 · Leawood, KSJul 24, 1974 · N5958R · Substantial damage NTSB MKC75FCQ05Accident · Serious injuriesClosedBede BD-5J · Newton, KSJul 17, 1974 · N152BD · Substantial damage NTSB MKC75FCQ04Accident · Serious injuriesClosedPiper PA-30 · Newton, KSJul 17, 1974 · N7432Y · Substantial damage NTSB MKC74FCQ08Accident · Serious injuriesClosedCessna 188 · Leoti, KSJul 17, 1974 · N21621 · Destroyed NTSB MKC75DCQ07Accident · No injuriesClosedRobinson MERE-M · Maize, KSJul 13, 1974 · N6827D · Substantial damage NTSB MKC75DCQ06Accident · No injuriesClosedMooney M20C · Sublette, KSJul 13, 1974 · N78934 · Substantial damage NTSB MKC75DCQ03Accident · No injuriesClosedPiper PA-25 · Stafford, KSJul 10, 1974 · N6004Z · Substantial damage NTSB MKC75DCQ02Accident · No injuriesClosedPiper PA-28 · Ellsworth, KSJul 6, 1974 · N5799U · Substantial damage NTSB MKC75DC001Accident · No injuriesClosedCessna 180 · Wichita, KSJul 6, 1974 · N2204C · Substantial damage NTSB MKC74DCG45Accident · Minor injuriesClosedCessna 140 · Paola, KSJun 29, 1974 · N72597 · Substantial damage NTSB MKC74FCQ45Accident · Minor injuriesClosedLuscombe 8A · Furley, KSJun 25, 1974 · N71721 · Destroyed NTSB MKC74FCQ46Accident · No injuriesClosedBoeing A75N1 · Hope, KSJun 24, 1974 · N268HC · Destroyed NTSB MKC74FCQ44Accident · No injuriesClosedPiper PA-12 · Newton, KSJun 23, 1974 · N4044M · Substantial damage NTSB MKC74DCQ48Accident · No injuriesClosedCessna 150 · Leoti, KSJun 19, 1974 · N18700 · Destroyed NTSB MKC74DCQ47Accident · No injuriesClosedBoeing A75 · Hepler, KSJun 18, 1974 · N69624 · Substantial damage NTSB MKC74FCQ41Accident · No injuriesClosedBell 47G-3B · Dodge City, KSJun 10, 1974 · N1380X · Substantial damage NTSB MKC74DCG42Accident · No injuriesClosedCessna 175 · Muscotah, KSJun 8, 1974 · N7401M · Substantial damage