Skip to content

NTSB investigations, 1975, 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1975, 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") = 1975 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\") = 1975
    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") = 1975
  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 MKC76FCQ26Accident · Minor injuriesClosedPiper PA-24 · Hays, KSDec 21, 1975 · N8637P · Substantial damage NTSB MKC76FCG40Accident · Minor injuriesClosedCessna 150 · Lyndon, KSDec 20, 1975 · N7789E · Substantial damage NTSB MKC76DCQ25Accident · Minor injuriesClosedCessna 172 · Caldwell, KSDec 16, 1975 · N61548 · Substantial damage NTSB MKC76DCQ24Accident · Minor injuriesClosedCessna 182J · Garden City, KSNov 5, 1975 · N3330F · Substantial damage NTSB MKC76AK029Accident · 1 fatalClosedCessna 182A · Rush Center, KSNov 5, 1975 · N4710D · Destroyed NTSB MKC76FCG31Accident · Serious injuriesClosedCessna 180 · Edgerton, KSNov 2, 1975 · N41CH · Substantial damage NTSB MKC76DCQ23Accident · No injuriesClosedCessna 188 · Leoti, KSOct 30, 1975 · N9380R · Substantial damage NTSB MKC76FCQ22Accident · Serious injuriesClosedPiper PA-28 · Haven, KSOct 29, 1975 · N4515R · Destroyed NTSB MKC76DCQ20Accident · No injuriesClosedHughes 269A · Wichita, KSOct 14, 1975 · N8960F · Substantial damage NTSB MKC76DCQ21Accident · No injuriesClosedGreat Lakes S-BABY · Phillipsburg, KSOct 8, 1975 · N8727 · Substantial damage NTSB MKC76AK026Accident · 1 fatalClosedBeech V35A · Russell, KSOct 6, 1975 · N7091N · Destroyed NTSB MKC76FCG26Accident · Minor injuriesClosedBeech F35 · Leawood, KSOct 4, 1975 · N3867B · Substantial damage NTSB MKC76AK024Accident · 2 fatalClosedBeech N35 · Wichita, KSOct 4, 1975 · N9454Y · Destroyed NTSB MKC76FCQ19Accident · No injuriesClosedCessna 172B · Mankato, KSOct 2, 1975 · N7943X · Substantial damage NTSB MKC75AK023Accident · 1 fatalClosedMitsubishi MU-2K · Beloit, KSSep 30, 1975 · XBLIJ · Destroyed NTSB MKC76DCQ18Accident · No injuriesClosedBeech A23-24 · Liberal, KSSep 24, 1975 · N7966L · Substantial damage NTSB MKC76AK020Accident · 2 fatalClosedPiper PA-23 · Mulberry, KSSep 18, 1975 · N524PR · Destroyed NTSB MKC76DCQ17Accident · No injuriesClosedPiper PA-28 · Hoxie, KSSep 13, 1975 · N5504U · Substantial damage NTSB MKC76DCQ15Accident · No injuriesClosedCessna 150 · Council Grove, KSSep 7, 1975 · N6095J · Substantial damage NTSB MKC76DCQ16Accident · No injuriesClosedCessna 401 · Wichita, KSSep 4, 1975 · N499V · Substantial damage NTSB MKC76FCG22Accident · No injuriesClosedCessna 140 · Mission, KSSep 3, 1975 · N2185N · Substantial damage NTSB MKC76AK018Accident · 1 fatalClosedPiper PA-18 · Atkinson, KSSep 1, 1975 · N177T · Destroyed NTSB MKC76DCQ13Accident · No injuriesClosedPiper PA-28 · Protection, KSAug 31, 1975 · N43439 · Substantial damage NTSB MKC76DCQ14Accident · No injuriesClosedPiper PA-34 · Hutchinson, KSAug 29, 1975 · N1040U · Substantial damage NTSB MKC76FCQ12Accident · No injuriesClosedBell 47G3B1 · Ingalls, KSAug 23, 1975 · N73976 · Destroyed NTSB MKC76FCG18Accident · Minor injuriesClosedMeek DSM-1 · Lyndon, KSAug 22, 1975 · N1418 · Destroyed NTSB MKC76FCG48Accident · No injuriesClosedAeronca 65-CA · Atchison, KSAug 17, 1975 · N34523 · Substantial damage NTSB MKC76DCQ10Accident · No injuriesClosedBaby Ace Corbin · Tennis, KSAug 17, 1975 · N8RM · Substantial damage NTSB MKC76FCQ11Accident · Minor injuriesClosedCessna T210L · Wellington, KSAug 15, 1975 · N9214M · Destroyed NTSB MIA76FCQ09Accident · 1 fatalClosedPiper PA-18 · Tribune, KSAug 12, 1975 · N4348Z · Destroyed NTSB MKC76FCQ07Accident · 1 fatalClosedKennedy-Wat KW-1 · Fowler, KSAug 10, 1975 · N371M · Destroyed NTSB MKC76AK013Accident · No injuriesClosedCessna 207 · Topeka, KSAug 10, 1975 · N1568U · Substantial damage NTSB MKC76FCQ05Accident · No injuriesClosedPiper PA-24 · Liberal, KSAug 8, 1975 · N6270P · Substantial damage NTSB MKC76DCQ06Accident · Serious injuriesClosedCessna A188 · Natoma, KSAug 8, 1975 · N8119V · Destroyed NTSB MKC76DCQ08Accident · No injuriesClosedHegy RCH-1 · Uniontown, KSAug 7, 1975 · N9360 · Substantial damage NTSB MKC76DCQ03Accident · No injuriesClosedHughes 269C · Holcomb, KSAug 4, 1975 · N9582F · Substantial damage NTSB MKC76FCG12Accident · No injuriesClosedCessna 182M · Kansas City, KSAug 1, 1975 · N91703 · Substantial damage NTSB MKC76ACQ02Accident · No injuriesClosedPiper PA-25 · Herkimer, KSJul 28, 1975 · N6997Z · Destroyed NTSB MKC76FCG08Accident · No injuriesClosedAero Comdr A-9B · Baldwin, KSJul 25, 1975 · N671W · Substantial damage NTSB MKC76FCG07Accident · Minor injuriesClosedBeech D45 · Olathe, KSJul 14, 1975 · N13616 · Substantial damage NTSB MKC76AK008Accident · No injuriesClosedHughes 269C · Wichita, KSJul 7, 1975 · N8968F · Substantial damage NTSB MKC75FCQ59Accident · No injuriesClosedCessna 185 · Wichita, KSJun 27, 1975 · AP-AXX · Substantial damage NTSB MKC75DCQ58Accident · No injuriesClosedHughes 269A · Atwood, KSJun 26, 1975 · N8892F · Substantial damage NTSB MKC75FCQ57Accident · 1 fatalClosedPiper PA-25 · Greensburg, KSJun 24, 1975 · N4474Y · Destroyed NTSB MKC75DCQ56Accident · No injuriesClosedBoeing A75N1 · Stafford, KSJun 24, 1975 · N61419 · Substantial damage NTSB MKC75FCG51Accident · Minor injuriesClosedCessna 172 · Leawood, KSJun 20, 1975 · N5586R · Substantial damage NTSB MKC75DCQ55Accident · No injuriesClosedBellanca 7GCBC · Minneola, KSJun 17, 1975 · N87069 · Substantial damage NTSB MKC75DCQ54Accident · Minor injuriesClosedMiller Teenie · Pratt, KSJun 15, 1975 · N4608 · Substantial damage NTSB NYC75DCQ53Accident · No injuriesClosedAmer Avco AA1-B · Manhattan, KSJun 13, 1975 · N8889L · Substantial damage NTSB MKC75FCQ52Accident · No injuriesClosedBell 47D1 · Holcomb, KSJun 12, 1975 · N7735 · Substantial damage