Skip to content

NTSB investigations, 1969, KS

180,624 investigations by the National Transportation Safety Board since 1962: 174,602 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, 1969, 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") = 1969 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\") = 1969
    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") = 1969
  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 MKC70F0316Accident · Minor injuriesClosedCessna 182H · Kansas City, KSDec 27, 1969 · N1803X · Substantial damage NTSB MKC70D0293Accident · No injuriesClosedCessna 170B · Baldwin City, KSDec 20, 1969 · N3468C · Substantial damage NTSB MKC70A0034Accident · 3 fatalClosedMooney M-20C · Pittsburg, KSDec 19, 1969 · N9101V · Destroyed NTSB MKC70D0285Accident · No injuriesClosedPiper PA-22 · Hudson, KSDec 7, 1969 · N6705B · Substantial damage NTSB MKC70A0031Accident · 2 fatalClosedCessna 172K · Ulysses, KSDec 3, 1969 · N78585 · Destroyed NTSB MKC70F0279Accident · No injuriesClosedPiper PA-28 · Miltonvale, KSNov 30, 1969 · N8226N · Substantial damage NTSB MKC70D0294Accident · No injuriesClosedAeronca 11CC · Bonner Sprgs, KSNov 30, 1969 · N4222E · Substantial damage NTSB MKC70D0268Accident · No injuriesClosedCessna 182 · Topeka, KSNov 12, 1969 · N42887 · Substantial damage NTSB MKC70F0263Accident · Serious injuriesClosedPiper PA-28 · Beaumont, KSNov 9, 1969 · N5257L · Substantial damage NTSB MKC70D0283Accident · No injuriesClosedBeech V35A · Lawrence, KSNov 9, 1969 · N7073N · Substantial damage NTSB MKC70A0025Accident · 4 fatalClosedBeech 35-C33 · Wichita, KSNov 8, 1969 · N4800J · Destroyed NTSB MKC70F0261Accident · No injuriesClosedCessna 150C · Morrowville, KSNov 5, 1969 · N7875Z · Substantial damage NTSB MKC70D0253Accident · No injuriesClosedPiper PA-22 · Hutchinson, KSNov 3, 1969 · N1541P · Substantial damage NTSB MKC70D0245Accident · No injuriesClosedHughes 269A · Wichita, KSNov 1, 1969 · N8793F · Substantial damage NTSB MKC70F0307Accident · No injuriesClosedFairchild 24R-46 · Eudora, KSOct 31, 1969 · N81278 · Substantial damage NTSB MKC70D0277Accident · No injuriesClosedPiper J3C-65 · Trading Post, KSOct 29, 1969 · N87942 · Substantial damage NTSB MKC70F0304Accident · Minor injuriesClosedCessna 150 · Leawood, KSOct 21, 1969 · N4070U · Substantial damage NTSB MKC70D0243Accident · No injuriesClosedLuscombe 8F · Olathe, KSOct 11, 1969 · N9946C · Substantial damage NTSB MKC70A0017Accident · 1 fatalClosedChampion 7GCB · Kismet, KSOct 9, 1969 · N9882Y · Destroyed NTSB MKC70D0272Accident · No injuriesClosedCessna 170 · Olathe, KSOct 4, 1969 · N3048A · Substantial damage NTSB MKC70F0223Accident · No injuriesClosedMooney M20G · Olathe, KSSep 18, 1969 · N6944N · Substantial damage NTSB MKC70A0010Accident · No injuriesClosedPiper PA-30 · Topeka, KSSep 12, 1969 · N8701Y · Substantial damage NTSB MKC70F0213Accident · No injuriesClosedCessna 195B · Wellington, KSSep 7, 1969 · N4485C · Substantial damage NTSB MKC70D0200Accident · No injuriesClosedBeech A23-19 · Leloup, KSSep 4, 1969 · N2390W · Substantial damage NTSB MKC70D 229Accident · Minor injuriesClosedBensen B-8 · Valley Centr, KSAug 31, 1969 · N9144 · Substantial damage NTSB MKC70D0165Accident · Minor injuriesClosedPiper PA-32 · Garden City, KSAug 30, 1969 · N4202R · Substantial damage NTSB MKC70D0155Accident · No injuriesClosedGrumman G-164 · Johnson, KSAug 29, 1969 · N518Y · Substantial damage NTSB MKC70A0006Accident · No injuriesClosedPiper PA-32 · Topeka, KSAug 25, 1969 · N4105W · Substantial damage NTSB MKC70D0148Accident · No injuriesClosedCessna 172H · Hill City, KSAug 22, 1969 · N3744F · Substantial damage NTSB MKC70D0171Accident · No injuriesClosedCessna 177 · Ashland, KSAug 19, 1969 · N3253T · Substantial damage NTSB MKC70F0197Accident · No injuriesClosedFly-Baby Hughs · Vinland, KSAug 13, 1969 · N74080 · Substantial damage NTSB MKC70D0140Accident · Minor injuriesClosedCessna 210T · Ulysses, KSAug 11, 1969 · N6150R · Substantial damage NTSB MKC70D0109Accident · No injuriesClosedCessna A188 · Maize, KSAug 9, 1969 · N3564Q · Substantial damage NTSB MKC70D0124Accident · No injuriesClosedCallair A-9 · Plains, KSAug 7, 1969 · N2916G · Substantial damage NTSB MKC70D0134Accident · No injuriesClosedPiper PA-18 · Johnson, KSAug 5, 1969 · N5923Z · Substantial damage NTSB MKC70D0107Accident · No injuriesClosedCessna 150 · Olathe, KSAug 5, 1969 · N6419S · Substantial damage NTSB MKC70A0004Accident · 1 fatalClosedErco 415-C · Paola, KSAug 5, 1969 · N99662 · Destroyed NTSB MKC70D0184Accident · No injuriesClosedCessna 210D · Lawrence, KSAug 1, 1969 · N3950Y · Substantial damage NTSB MKC70D0128Accident · No injuriesClosedCessna 177 · Ottawa, KSJul 29, 1969 · N30209 · Substantial damage NTSB MKC70A0002Accident · 1 fatalClosedChampion 7KCAB · Vally Center, KSJul 29, 1969 · N6354N · Destroyed NTSB MKC70D0186Accident · No injuriesClosedPiper PA-25 · Kansas City, KSJul 25, 1969 · N7641Z · Substantial damage NTSB MKC70D0121Accident · No injuriesClosedPiper PA-25 · Hugoton, KSJul 25, 1969 · N6555L · Substantial damage NTSB MKC70F0084Accident · Serious injuriesClosedPiper PA-18A · Belleville, KSJul 22, 1969 · N2896Z · Destroyed NTSB MKC70F0077Accident · No injuriesClosedPiper PA-28 · Wichita, KSJul 17, 1969 · N6466R · Substantial damage NTSB MKC70D0067Accident · No injuriesClosedPiper PA-28 · Rose Hill, KSJul 15, 1969 · N1730J · Substantial damage NTSB MKC70F0089Accident · Serious injuriesClosedPiper PA-18 · Gove, KSJul 13, 1969 · N4174Z · Destroyed NTSB MKC70D0115Accident · No injuriesClosedCessna 182 · Leawood, KSJul 9, 1969 · N42349 · Substantial damage NTSB MKC70F0198Accident · Serious injuriesClosedBoeing A75N1 · Basehor, KSJul 6, 1969 · N61673 · Substantial damage NTSB MKC70D0041Accident · No injuriesClosedCessna 172I · Scott City, KSJul 6, 1969 · N46088 · Substantial damage NTSB MKC70D0093Accident · Serious injuriesClosedCessna 177 · Stanley, KSJul 3, 1969 · N3494T · Substantial damage