Skip to content

NTSB investigations, 1977, 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, 1977, 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") = 1977 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\") = 1977
    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") = 1977
  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 MKC78DCQ12Accident · Minor injuriesClosedCessna 150 · Russell, KSDec 30, 1977 · N704ES · Destroyed NTSB MKC78DCQ11Accident · No injuriesClosedCessna 172 · Phillipsburg, KSDec 27, 1977 · N75556 · Substantial damage NTSB MKC78DCQ10Accident · No injuriesClosedPiper PA-28 · Leoti, KSDec 20, 1977 · N4692R · Substantial damage NTSB MKC78DCQ09Accident · No injuriesClosedCessna 172N · Wichita, KSDec 17, 1977 · N738KL · Substantial damage NTSB MKC78FCQ08Accident · Minor injuriesClosedPiper PA-18 · Cimarron, KSDec 13, 1977 · N161T · Substantial damage NTSB MKC78FCG11Accident · Minor injuriesClosedCessna 177 · Olathe, KSDec 5, 1977 · N2860X · Destroyed NTSB MKC78DCQ05Accident · Minor injuriesClosedCessna 150 · Wellington, KSNov 27, 1977 · N704VU · Substantial damage NTSB MKC78FCQ07Accident · No injuriesClosedCessna 152 · Wilmont, KSNov 19, 1977 · N25057 · Destroyed NTSB MKC78DCQ06Accident · No injuriesClosedCessna 177RG · Wichita, KSNov 11, 1977 · N1917Q · Substantial damage NTSB MKC78DCG07Accident · No injuriesClosedCessna 182 · Kansas City, KSNov 5, 1977 · N3704U · Substantial damage NTSB MKC78FA007Accident · 1 fatalClosedCessna 310 · Kansas City, KSNov 4, 1977 · N777BB · Destroyed NTSB MKC78DCQ03Accident · No injuriesClosedAero Comdr 112A · Moran, KSOct 30, 1977 · N76EE · Substantial damage NTSB MKC78FCQ02Accident · No injuriesClosedCessna 150 · Emporia, KSOct 27, 1977 · N10996 · Substantial damage NTSB MKC78FCQ04Accident · No injuriesClosedBeech A-36 · Garden City, KSOct 22, 1977 · N950V · Substantial damage NTSB MKC78FCQ01Accident · Minor injuriesClosedCessna 152 · Stafford, KSOct 8, 1977 · N757ZT · Substantial damage NTSB MKC78DCG03Accident · No injuriesClosedCessna 172 · Lawrence, KSOct 8, 1977 · N737DC · Substantial damage NTSB MKC78FA001Accident · 2 fatalClosedNavion A · Caldwell, KSOct 6, 1977 · N91482 · Destroyed NTSB MKC77DCQ61Accident · No injuriesClosedCessna 170A · Syracuse, KSSep 28, 1977 · N166LJ · Substantial damage NTSB MKC77DCQ60Accident · No injuriesClosedChampion 7ECA · Byers, KSSep 24, 1977 · N1811G · Substantial damage NTSB MKC77DCQ59Accident · No injuriesClosedCessna 172 · Kiowa, KSSep 22, 1977 · N733XB · Substantial damage NTSB MKC77FCQ58Accident · No injuriesClosedBeech C-23 · Wichita, KSSep 17, 1977 · N246CB · Substantial damage NTSB MKC77FA039Accident · 2 fatalClosedCessna 177 · Coldwater, KSSep 15, 1977 · N29358 · Destroyed NTSB MKC77FCQ56Accident · No injuriesClosedBeech T34A · Johnson, KSAug 30, 1977 · N1115V · Substantial damage NTSB MKC77FCG51Accident · No injuriesClosedBeech A23-19 · Lyndon, KSAug 28, 1977 · N4746J · Substantial damage NTSB MKC77FCG50Accident · No injuriesClosedCessna 150E · Topeka, KSAug 27, 1977 · N3062J · Substantial damage NTSB MKC77FCG46Accident · Minor injuriesClosedCessna 172 · Topeka, KSAug 14, 1977 · N3871Q · Substantial damage NTSB MKC77DCQ55Accident · No injuriesClosedPiper PA-18 · Manhatton, KSAug 13, 1977 · N217T · Substantial damage NTSB MKC77DCQ53Accident · No injuriesClosedCessna 172 · Benton, KSAug 10, 1977 · N9621H · Substantial damage NTSB MKC77DCQ52Accident · No injuriesClosedCessna 188 · Meade, KSAug 8, 1977 · N9899V · Substantial damage NTSB MKC77DCQ51Accident · No injuriesClosedCessna 150 · Greensburg, KSAug 8, 1977 · N11619 · Substantial damage NTSB MKC77DCQ50Accident · No injuriesClosedCessna 172 · Oakley, KSAug 8, 1977 · N736RM · Substantial damage NTSB MKC77FCQ49Accident · Minor injuriesClosedPiper PA-22 · Larned, KSJul 25, 1977 · N3659A · Substantial damage NTSB MKC77FCG38Accident · No injuriesClosedCessna 188 · De Soto, KSJul 17, 1977 · N21691 · Substantial damage NTSB MKC77FCQ48Accident · Minor injuriesClosedHughes 269A · Herndon, KSJul 15, 1977 · N8892F · Substantial damage NTSB MKC77DCQ54Accident · No injuriesClosedCessna 210 · Paxico, KSJul 15, 1977 · N9501T · Substantial damage NTSB MKC77DCQ47Accident · Minor injuriesClosedPiper PA-28 · Hoxie, KSJul 14, 1977 · N7221F · Substantial damage NTSB MKC77FCQ46Accident · Minor injuriesClosedCessna U206G · Wichita, KSJul 10, 1977 · N7711N · Substantial damage NTSB MKC77FCQ44Accident · No injuriesClosedGrumman G-164A · Junction City, KSJun 27, 1977 · N5396 · Substantial damage NTSB MKC77FCQ45Accident · No injuriesClosedCessna 210B · Mullinville, KSJun 26, 1977 · N9723X · Substantial damage NTSB MKC77FCG31Accident · No injuriesClosedCessna 177RG · Gardner, KSJun 25, 1977 · N1927Q · Substantial damage NTSB MKC77FCQ43Accident · No injuriesClosedPiper PA-30 · Wichita, KSJun 24, 1977 · N8695Y · Substantial damage NTSB MKC77DCG34Accident · No injuriesClosedCessna 182 · Kansas City, KSJun 17, 1977 · N8358S · Substantial damage NTSB MKC77FCQ42Accident · 1 fatalClosedCessna 188B · Olsburg, KSJun 16, 1977 · N4809Q · Destroyed NTSB MKC77FCQ41Accident · No injuriesClosedPiper PA-23 · Minneapolis, KSJun 15, 1977 · N54797 · Destroyed NTSB MKC77DCG30Accident · Serious injuriesClosedPiper PA-22 · Leavenworth, KSJun 13, 1977 · N2656P · Substantial damage NTSB MKC77DCG29Accident · No injuriesClosedHuey-Smith H-1 · Eudora, KSJun 12, 1977 · N88C · Substantial damage NTSB MKC77FCQ40Accident · No injuriesClosedTaylorcraft DCO-65 · Salina, KSJun 5, 1977 · N50373 · Substantial damage NTSB MKC77DCQ39Accident · No injuriesClosedPiper PA-28 · Yates Center, KSJun 5, 1977 · N9736W · Substantial damage NTSB MKC77DCQ38Accident · Minor injuriesClosedCessna 150 · Maize, KSMay 29, 1977 · N11550 · Substantial damage NTSB MKC77DEQ36Accident · No injuriesClosedCessna 182 · Derby, KSMay 21, 1977 · N2445R · Substantial damage