Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 MKC80FA017Accident · 1 fatalClosedCessna 175 · Shawnee, KSDec 23, 1979 · N7253M · Destroyed NTSB MKC80FA016Accident · 1 fatalClosedCessna 150G · Anthony, KSDec 22, 1979 · N8409J · Destroyed NTSB MKC80FA015Accident · 1 fatalClosedCessna 152 · Olathe, KSDec 21, 1979 · N25494 · Destroyed NTSB MKC80DCQ09Accident · No injuriesClosedCessna 210 · Hutchinson, KSDec 21, 1979 · N5470C · Substantial damage NTSB MKC80DCQ08Accident · No injuriesClosedCessna 170B · Kingman, KSDec 20, 1979 · N3050A · Substantial damage NTSB MKC80FCQ07Accident · No injuriesClosedPiper PA-32 · Cedar Vale, KSDec 15, 1979 · N2162E · Substantial damage NTSB MKC80FCQ08Accident · No injuriesClosedPiper PA-34 · Osawatomie, KSDec 14, 1979 · N2078N · Substantial damage NTSB MKC80DCQ06Accident · No injuriesClosedCessna 182 · Glasco, KSDec 13, 1979 · N5113D · Substantial damage NTSB MKC80FCQ05Accident · Minor injuriesClosedCessna 150G · Onaga, KSDec 9, 1979 · N3165X · Substantial damage NTSB MKC80FCQ04Accident · Minor injuriesClosedPiper PA-28 · Dodge City, KSDec 9, 1979 · N5298S · Substantial damage NTSB MKC80FCQ03Accident · No injuriesClosedHughes 269C · Garden City, KSDec 4, 1979 · N7481F · Substantial damage NTSB MKC80FCG06Accident · Serious injuriesClosedBeech B-95 · Leawood, KSDec 3, 1979 · N2781Y · Substantial damage NTSB MKC80FA009Accident · 1 fatalClosedMooney M-20J · Coffeyville, KSNov 23, 1979 · N201UP · Destroyed NTSB MKC79FA006Accident · 1 fatalClosedPazmany PL-2 · Olathe, KSNov 16, 1979 · N72KA · Minor damage NTSB MKC79DCQ01Accident · No injuriesClosedBeech 100 · Hutchinson, KSOct 14, 1979 · YV125CP · Substantial damage NTSB MKC80FCQ02Accident · No injuriesClosedAiryplane PDQ · Lyons, KSOct 12, 1979 · N1053E · Substantial damage NTSB MKC79DCQ47Accident · No injuriesClosedPiper PA-28 · Goodland, KSSep 27, 1979 · N6484W · Substantial damage NTSB MKC79FA056Accident · Minor injuriesClosedPiper PA-28 · Chanute, KSSep 20, 1979 · N6146H · Substantial damage NTSB MKC79DCQ45Accident · No injuriesClosedCessna 210 · Wichita, KSSep 18, 1979 · N732PY · Substantial damage NTSB MKC79DCQ46Accident · No injuriesClosedCessna 172 · Wichita, KSSep 16, 1979 · N2234E · Substantial damage NTSB MKC79FA051Accident · 2 fatalClosedCessna 210L · Garden City, KSSep 5, 1979 · N59200 · Destroyed NTSB MKC79DCQ44Accident · No injuriesClosedBeech C23 · Newton, KSSep 4, 1979 · N2007L · Substantial damage NTSB MKC79FCG75Accident · Minor injuriesClosedCessna 340A · Topeka, KSAug 24, 1979 · N800BC · Substantial damage NTSB MKC79DCQ43Accident · No injuriesClosedCessna 172N · Wichita, KSAug 21, 1979 · N738AT · Substantial damage NTSB MKC79FCG71Accident · No injuriesClosedBeech A23-24 · Reading, KSAug 11, 1979 · N4744J · Substantial damage NTSB MKC79DCQ42Accident · No injuriesClosedCessna 152 · Clements, KSAug 11, 1979 · N89876 · Substantial damage NTSB MKC79FCG70Accident · No injuriesClosedCessna 150L · Bonner Springs, KSAug 9, 1979 · N19030 · Substantial damage NTSB MKC79FCQ41Accident · No injuriesClosedGrumman AA5B · Hoxie, KSAug 6, 1979 · N28756 · Substantial damage NTSB MKC79FCG67Accident · Minor injuriesClosedBeech 35 · Stilwell, KSAug 6, 1979 · N4513V · Substantial damage NTSB MKC79FA046Accident · 7 fatalClosedMitsubishi MU-2B · Hays, KSAug 3, 1979 · N208MA · Destroyed NTSB MKC79FCQ38Accident · No injuriesClosedCessna 150H · Columbus, KSJul 28, 1979 · N5131G · Substantial damage NTSB MKC79FCQ39Accident · No injuriesClosedDyke Delta JD-2 · Tribune, KSJul 27, 1979 · N18DW · Substantial damage NTSB MKC79DCQ40Accident · No injuriesClosedCessna 172 · Sharon Springs, KSJul 27, 1979 · N7129T · Substantial damage NTSB MKC79FCQ37Accident · No injuriesClosedPiper PA-28 · Halstead, KSJul 26, 1979 · N6462C · Substantial damage NTSB MKC79DCG62Accident · No injuriesClosedBoeing A75 · Effingham, KSJul 21, 1979 · N75360 · Substantial damage NTSB MKC79FCG60Accident · No injuriesClosedPitts S2A · Ottawa, KSJul 20, 1979 · N60LG · Substantial damage NTSB MKC79DCG56Accident · No injuriesClosedPiper PA-28 · Leawood, KSJul 4, 1979 · N3935K · Substantial damage NTSB MKC79DCG54Accident · No injuriesClosedPitts S2 · Garnett, KSJul 4, 1979 · N4TW · Substantial damage NTSB MKC79FCQ35Accident · No injuriesClosedPiper PA-18A · Westfall, KSJul 1, 1979 · N8098D · Substantial damage NTSB MKC79FCQ34Accident · Minor injuriesClosedInterceptor Super · Johnson, KSJun 29, 1979 · N10347 · Substantial damage NTSB MKC79FCG52Accident · No injuriesClosedGrumman AA1B · Garnett, KSJun 29, 1979 · N8861L · Destroyed NTSB MKC79DCQ36Accident · Serious injuriesClosedCessna 152 · Arkansas City, KSJun 27, 1979 · N89142 · Destroyed NTSB MKC79FCG51Accident · No injuriesClosedMooney M20A · Hillsdale, KSJun 26, 1979 · N6072X · Substantial damage NTSB MKC79FCQ33Accident · No injuriesClosedRockwell S2R · Hoxie, KSJun 24, 1979 · N5008X · Substantial damage NTSB MKC79DCQ32Accident · Minor injuriesClosedPiper PA-18 · Great Bend, KSJun 23, 1979 · N74990 · Substantial damage NTSB LAX791A068Incident · No injuriesClosedLockheed L-1011 · Hutchinson, KSJun 21, 1979 · N11001 · Minor damage NTSB MKC79DCQ31Accident · No injuriesClosedPiper PA-28 · Wellington, KSJun 17, 1979 · N7633F · Substantial damage NTSB MKC79DCQ30Accident · No injuriesClosedGrumman G-164A · Moscow, KSJun 17, 1979 · N8842H · Destroyed NTSB MKC79FCQ29Accident · Serious injuriesClosedPiper PA-25 · Atwood, KSJun 14, 1979 · N6045Z · Substantial damage NTSB MKC79DCQ28Accident · No injuriesClosedCessna 340 · Manhattan, KSJun 6, 1979 · N512SK · Substantial damage