Skip to content

NTSB investigations, 1971, KS

180,616 investigations by the National Transportation Safety Board since 1962: 174,594 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, 1971, 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") = 1971 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\") = 1971
    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") = 1971
  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 MKC72AK040Accident · 2 fatalClosedCessna 150L · Clay Center, KSDec 25, 1971 · N1776Q · Destroyed NTSB MKC72AK037Accident · 3 fatalClosedCessna 175 · Clyde, KSDec 19, 1971 · N7436M · Destroyed NTSB MKC72DCQ37Accident · No injuriesClosedCessna 150L · Clay Center, KSDec 16, 1971 · N1248Q · Substantial damage NTSB MKC72AK036Accident · No injuriesClosedPiper PA-32 · Topeka, KSDec 15, 1971 · N4105W · Substantial damage NTSB MKC72AK030Accident · 4 fatalClosedBeech E35 · Garden City, KSNov 24, 1971 · N3202C · Destroyed NTSB MKC72FCQ36Accident · Minor injuriesClosedBeech 35 · Junction Cty, KSNov 22, 1971 · N735JS · Substantial damage NTSB MKC72FCG34Accident · 1 fatalClosedPiper PA-22 · Lansing, KSNov 22, 1971 · N1792P · Substantial damage NTSB MKC72FCQ34Accident · No injuriesClosedCessna 180 · Valley Cntr, KSNov 14, 1971 · N2204C · Substantial damage NTSB MKC72FCQ33Accident · No injuriesClosedCessna 170B · Wichita, KSNov 11, 1971 · N1660D · Substantial damage NTSB MKC72FCQ32Accident · No injuriesClosedCessna 182N · Wichita, KSNov 10, 1971 · N8964G · Substantial damage NTSB MKC72DCQ31Accident · No injuriesClosedBeech B95 · Salina, KSOct 28, 1971 · N9629R · Substantial damage NTSB MKC72DCQ35Accident · No injuriesClosedDouglas A-26C · Hutchinson, KSOct 20, 1971 · N6841D · Substantial damage NTSB MKC72AK028Accident · 3 fatalClosedCessna 182J · Longton, KSOct 20, 1971 · N2784F · Destroyed NTSB MKC72DCG29Accident · Serious injuriesClosedCessna 150 · Leawood, KSOct 17, 1971 · N2494J · No damage NTSB MKC72AK027Accident · 2 fatalClosedErco 415-C · Topeka, KSOct 16, 1971 · N37106 · Destroyed NTSB MKC72DCG26Accident · No injuriesClosedBeech G35 · Leawood, KSOct 14, 1971 · N4587D · Substantial damage NTSB MKC72AK026Accident · 3 fatalClosedBeech S35 · Topeka, KSOct 8, 1971 · N5883S · 2 aircraft · Destroyed NTSB MKC72DCQ30Accident · Minor injuriesClosedCessna 170B · Wilson, KSOct 7, 1971 · N2727D · Substantial damage NTSB MKC72FCQ29Accident · No injuriesClosedCessna 140 · Mcdonald, KSSep 27, 1971 · N4283N · Substantial damage NTSB MKC72AK020Accident · 2 fatalClosedAmer Avco AA1 · Potwin, KSSep 25, 1971 · N5770L · Destroyed NTSB MKC71DCQ28Accident · No injuriesClosedMinicab GY-20 · Goodland, KSSep 19, 1971 · N6824D · Substantial damage NTSB MKC72DCG21Accident · Minor injuriesClosedCessna 172 · Topeka, KSSep 12, 1971 · N1345Y · Substantial damage NTSB MKC72DCQ26Accident · No injuriesClosedPiper PA-25 · Richfield, KSSep 9, 1971 · N8829L · Substantial damage NTSB MKC72FCQ24Accident · No injuriesClosedCessna 182J · Arkansas Cty, KSSep 4, 1971 · N3596F · Substantial damage NTSB MKC72DCQ27Accident · No injuriesClosedMaule M-4 · Newton, KSSep 4, 1971 · N40307 · Substantial damage NTSB MKC72DCQ23Accident · No injuriesClosedCessna 150 · Med Lodge, KSAug 30, 1971 · N3915U · Substantial damage NTSB MKC72DCQ25Accident · No injuriesClosedCessna 421A · Wichita, KSAug 26, 1971 · N2243Q · Substantial damage NTSB MKC72DCQ21Accident · No injuriesClosedBeech M35 · Goddard, KSAug 22, 1971 · N9839R · Substantial damage NTSB MKC72AK016Accident · 1 fatalClosedCessna 150B · Victoria, KSAug 21, 1971 · N1291Y · Destroyed NTSB MKC72FCQ20Accident · Serious injuriesClosedPiper PA-28 · Hutchinson, KSAug 17, 1971 · N1299G · Minor damage NTSB MKC72AK015Accident · 2 fatalClosedAeronca 11AC · Admire, KSAug 16, 1971 · N86032 · Destroyed NTSB MKC72DCQ19Accident · No injuriesClosedBeech 35 · Derby, KSAug 15, 1971 · N4474V · Substantial damage NTSB MKC72DCQ22Accident · No injuriesClosedPiper PA-28 · Seneca, KSAug 11, 1971 · N9878W · Substantial damage NTSB MKC72FCQ18Accident · No injuriesClosedStandard J-1 · Haven, KSAug 10, 1971 · N2826D · Substantial damage NTSB MKC72DCQ17Accident · No injuriesClosedPiper PA-30 · Mankato, KSAug 7, 1971 · N7065Y · Substantial damage NTSB MKC72AK010Accident · 2 fatalClosedBeech 95-C55 · Coats, KSAug 6, 1971 · N4893J · Destroyed NTSB MKC72DCQ16Accident · No injuriesClosedCessna 170A · Hoisington, KSAug 4, 1971 · N5738C · Substantial damage NTSB MKC72FCQ15Accident · Serious injuriesClosedPiper PA-18 · Johnson, KSJul 29, 1971 · N4328Z · Substantial damage NTSB MKC72DCQ13Accident · No injuriesClosedPiper PA-28 · Oakley, KSJul 24, 1971 · N5172L · Substantial damage NTSB MKC72DCQ12Accident · No injuriesClosedPiper PA-32 · Emporia, KSJul 24, 1971 · N4105W · Substantial damage NTSB MKC72FCQ10Accident · No injuriesClosedBoeing A75N1 · Abilene, KSJul 19, 1971 · N66617 · Substantial damage NTSB MKC72DCQ09Accident · No injuriesClosedBellanca 14-193 · Howard, KSJul 19, 1971 · N7607E · Substantial damage NTSB MKC72FCG05Accident · No injuriesClosedPiper PA-28 · Leawood, KSJul 16, 1971 · N5170W · Substantial damage NTSB MKC72DCQ08Accident · No injuriesClosedPiper PA-25 · Sharon Sprgs, KSJul 16, 1971 · N6191Z · Substantial damage NTSB MKC72AK005Accident · 2 fatalClosedBeech 35 · Mankato, KSJul 14, 1971 · N4538V · Destroyed NTSB MKC72DC014Accident · No injuriesClosedCessna 150 · Stafford, KSJul 12, 1971 · N3915U · Substantial damage NTSB MKC72DCQ06Accident · No injuriesClosedPiper PA-25 · Marion, KSJul 9, 1971 · N6583Z · Substantial damage NTSB MKC72FCQ05Accident · 1 fatalClosedSpinks 10 · Rose Hill, KSJul 6, 1971 · N12851 · Destroyed NTSB MKC72DCQ03Accident · Minor injuriesClosedCassutt Sport · Newton, KSJul 3, 1971 · N1115G · Substantial damage NTSB MKC72FCQ02Accident · Minor injuriesClosedPiper PA-28 · Great Bend, KSJul 2, 1971 · N7496R · Substantial damage