Skip to content

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19632026

NTSB investigations, 1972, 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") = 1972 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\") = 1972
    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") = 1972
  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 MKC73DCQ24Accident · No injuriesClosedCessna 210 · Manhattan, KSDec 29, 1972 · N19BB · Substantial damage NTSB MKC73FCQ23Accident · 1 fatalClosedBeard-Parkr Mini · Benton, KSDec 26, 1972 · N6699 · Substantial damage NTSB MKC73AK046Accident · 2 fatalClosedPiper PA-32 · Great Bend, KSDec 23, 1972 · N5263S · Destroyed NTSB MKC73AK044Accident · 4 fatalClosedCessna 320E · Goodland, KSDec 22, 1972 · N2208Q · Destroyed NTSB MKC73AK042Accident · 2 fatalClosedCessna 172 · Concordia, KSDec 19, 1972 · N46155 · Destroyed NTSB MKC73FCQ22Accident · No injuriesClosedCessna 402B · Wichita, KSDec 3, 1972 · N13GM · Substantial damage NTSB MKC73FCG23Accident · No injuriesClosedCessna 177 · Olathe, KSNov 18, 1972 · N3452T · Substantial damage NTSB MKC73DCG20Accident · No injuriesClosedPiper PA-28 · Louisburg, KSNov 12, 1972 · N9354N · Substantial damage NTSB MKC73AK035Accident · 2 fatalClosedCessna 320F · Ashland, KSNov 4, 1972 · N9900X · Destroyed NTSB MKC73DCQ21Accident · Minor injuriesClosedCessna 150J · Derby, KSOct 29, 1972 · N61140 · Substantial damage NTSB MKC73DCQ20Accident · No injuriesClosedCessna 182 · Benton, KSOct 19, 1972 · N91703 · Substantial damage NTSB MKC73DCQ19Accident · No injuriesClosedPiper PA-32 · Pittsburg, KSOct 18, 1972 · N4005R · Substantial damage NTSB MKC73FCQ17Accident · No injuriesClosedBede BD5A · Newton, KSOct 8, 1972 · N501BD · Substantial damage NTSB MKC73FCG14Accident · No injuriesClosedPiper PA-28 · Leawood, KSOct 8, 1972 · N6698J · Substantial damage NTSB MKC73DCQ18Accident · No injuriesClosedMini-Ace CA-61 · Garden City, KSOct 7, 1972 · N612S · Substantial damage NTSB MKC73AKO25Accident · No injuriesClosedPiper PA-32 · Lawrence, KSOct 5, 1972 · N3655W · Substantial damage NTSB MKC73DCQ16Accident · No injuriesClosedCessna 150D · Great Bend, KSOct 3, 1972 · N4477U · Substantial damage NTSB MKC73AK024Accident · 1 fatalClosedAeronca 7AC · Ulysses, KSOct 1, 1972 · N1720E · Destroyed NTSB MKC73FCG12Accident · Minor injuriesClosedCessna 172E · Ft.Leavenwth, KSSep 27, 1972 · N6048 · Substantial damage NTSB MKC73DCQ15Accident · No injuriesClosedCessna 140 · Abilene, KSSep 17, 1972 · N89378 · Substantial damage NTSB MKC73FCQ13Accident · No injuriesClosedPiper PA-28 · Kalvesta, KSSep 13, 1972 · N7150W · Substantial damage NTSB MKC73DCQ14Accident · No injuriesClosedBellanca 14193A · Edna, KSSep 13, 1972 · N1250R · Substantial damage NTSB MKC73FCQ12Accident · Minor injuriesClosedCessna 150 · Goodland, KSSep 9, 1972 · N6292G · Destroyed NTSB MKC73DCQ11Accident · No injuriesClosedBeech C-45H · Wichita, KSAug 23, 1972 · N90682 · Substantial damage NTSB MKC73AK015Accident · Serious injuriesClosedPiper PA-23 · Fort Scott, KSAug 8, 1972 · N6550Y · Destroyed NTSB MKC73AK012Accident · 4 fatalClosedPiper PA-30 · Overbrook, KSAug 3, 1972 · N8245Y · Destroyed NTSB MKC73DCQ09Accident · No injuriesClosedBoeing E75 · Copeland, KSAug 1, 1972 · N65013 · Substantial damage NTSB MKC73AK011Accident · 2 fatalClosedN.American SNJ-5 · Kingman, KSJul 31, 1972 · N3194G · Destroyed NTSB MKC73DCQ07Accident · No injuriesClosedPiper J4A · Beaumont, KSJul 29, 1972 · N27078 · Substantial damage NTSB MKC73DCG03Accident · No injuriesClosedCessna 150G · Rantoul, KSJul 25, 1972 · N3868J · Destroyed NTSB MKC73DCQ08Accident · No injuriesClosedPiper PA-32 · Marysville, KSJul 24, 1972 · N4279R · Substantial damage NTSB MKC73FCQ05Accident · No injuriesClosedCessna A150K · Oakley, KSJul 16, 1972 · N5915J · Substantial damage NTSB MKC73AK009Accident · 1 fatalClosedCessna 150J · Caldwell, KSJul 15, 1972 · N61025 · Destroyed NTSB MKC73DCQ06Accident · No injuriesClosedPiper PA-28 · Utica, KSJul 14, 1972 · N5298S · Substantial damage NTSB MKC73FCQ03Accident · Serious injuriesClosedTaylorcraft BC12-D · Minneola, KSJul 9, 1972 · N95537 · Destroyed NTSB MKC73DCQ04Accident · No injuriesClosedCessna 180 · Newton, KSJul 9, 1972 · N2204C · Substantial damage NTSB MKC73FCO02Accident · No injuriesClosedBeech H35 · Newton, KSJul 7, 1972 · N5025B · Substantial damage NTSB MKC73DCQ01Accident · No injuriesClosedCessna 182M · Wichita, KSJul 6, 1972 · N91621 · Substantial damage NTSB MKC72DCQ63Accident · Minor injuriesClosedCessna 182 · Russell, KSJun 30, 1972 · N9364X · Substantial damage NTSB MKC73FCQ10Accident · No injuriesClosedCessna 150 · Augusta, KSJun 24, 1972 · N6458G · Substantial damage NTSB MKC73FCG07Accident · No injuriesClosedCessna 210 · Leawood, KSJun 23, 1972 · N7453E · Substantial damage NTSB MKC72DCG68Accident · Minor injuriesClosedCessna 172H · Lawrence, KSJun 17, 1972 · N3999Q · Substantial damage NTSB MKC72DCQ60Accident · Serious injuriesClosedCessna 150 · Phillipsburg, KSJun 16, 1972 · N4673X · Minor damage NTSB MKC72DCQ62Accident · No injuriesClosedBeech 23 · Riley, KSJun 15, 1972 · N6985Q · Substantial damage NTSB MKC72DCQ59Accident · No injuriesClosedCessna 172K · Hardtner, KSJun 11, 1972 · N7010G · Substantial damage NTSB MKC72DCG64Accident · No injuriesClosedPiper PA-28 · Basehor, KSJun 9, 1972 · N1877J · Substantial damage NTSB MKC72FCQ58Accident · 1 fatalClosedCallair A-9B · Ulysses, KSJun 4, 1972 · N7980V · Destroyed NTSB MKC72FCG57Accident · No injuriesClosedAeronca 7AC · Leawood, KSJun 4, 1972 · N1483E · Substantial damage NTSB MKC72DCG61Accident · No injuriesClosedBeech V35 · Valley Falls, KSJun 3, 1972 · N3772Q · Substantial damage NTSB MKC72AK064Accident · 2 fatalClosedBeech E18S · Winfield, KSJun 3, 1972 · N234AP · Destroyed