Skip to content

NTSB investigations, 1967, 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, 1967, 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") = 1967 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\") = 1967
    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") = 1967
  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 MKC68A0040Accident · 1 fatalClosedLuscombe 8A · Lyons, KSDec 24, 1967 · N71543 · Destroyed NTSB MKC68A0039Accident · 1 fatalClosedCessna 150D · Hillsboro, KSDec 24, 1967 · N4227U · Destroyed NTSB MKC68D0389Accident · No injuriesClosedCessna 172 · Ames, KSDec 20, 1967 · N7048T · Substantial damage NTSB MKC68D0374Accident · No injuriesClosedCessna 150F · Severy, KSDec 20, 1967 · N6778F · Substantial damage NTSB MKC68D0370Accident · No injuriesClosedCessna 172G · St.Francis, KSDec 7, 1967 · N3735L · Substantial damage NTSB MKC68D0368Accident · No injuriesClosedLuscombe 8A · Fostoria, KSDec 1, 1967 · N71382 · Substantial damage NTSB MKC68A0035Accident · No injuriesClosedPiper PA-24 · Sharn Sprngs, KSNov 26, 1967 · N9184P · Substantial damage NTSB MKC68D0417Accident · No injuriesClosedPiper PA-28 · Olathe, KSNov 25, 1967 · N6452W · Substantial damage NTSB MKC68F0320Accident · Serious injuriesClosedTaylorcraft DCO-65 · Leoti, KSNov 19, 1967 · N47672 · Substantial damage NTSB MKC68F0324Accident · No injuriesClosedCessna 182K · Augusta, KSNov 18, 1967 · N3103F · Substantial damage NTSB CHI68F0424Accident · No injuriesClosedCessna 310L · Wichita, KSNov 14, 1967 · N2207F · Substantial damage NTSB MKC68D0341Accident · No injuriesClosedBeech 35 · Smith Center, KSNov 12, 1967 · N4540V · Substantial damage NTSB MKC68D0461Accident · No injuriesClosedBeech 23 · Lawrence, KSNov 11, 1967 · N2314Z · Substantial damage NTSB MKC68D0419Accident · No injuriesClosedPiper PA-28 · Ottawa, KSNov 11, 1967 · N5366W · Substantial damage NTSB MKC68F0300Accident · No injuriesClosedPiper PA-25 · Leroy, KSNov 10, 1967 · N6591Z · Substantial damage NTSB MKC68D0405Accident · No injuriesClosedCessna 150E · Leawood, KSNov 4, 1967 · N3502J · Substantial damage NTSB MKC68F0301Accident · Minor injuriesClosedCessna 310 · Concordia, KSOct 28, 1967 · N191R · Substantial damage NTSB MKC68A0033Accident · No injuriesClosedCessna 210 · Iola, KSOct 27, 1967 · N5800F · Substantial damage NTSB MKC68D0294Accident · No injuriesClosedPiper PA-22 · Tribune, KSOct 12, 1967 · N2860Z · Substantial damage NTSB MKC68D0381Accident · No injuriesClosedCessna 182 · Bonner Sprgs, KSOct 11, 1967 · N2613Q · Substantial damage NTSB MKC68F0268Accident · Minor injuriesClosedCessna 182 · Wichita, KSOct 6, 1967 · N3354F · Substantial damage NTSB MKC68D0291Accident · No injuriesClosedCessna 140 · Junction Cty, KSSep 28, 1967 · N3604V · Substantial damage NTSB MKC68D0243Accident · No injuriesClosedPiper PA-22 · Independence, KSSep 24, 1967 · N99570 · Substantial damage NTSB MKC68F0256Accident · Serious injuriesClosedPiper PA-23 · Emporia, KSSep 21, 1967 · N3321P · Substantial damage NTSB MKC68D0223Accident · Minor injuriesClosedCessna 140 · Clay Center, KSSep 13, 1967 · N89378 · Substantial damage NTSB MKC68D0387Accident · No injuriesClosedCessna 150 · Olathe, KSSep 11, 1967 · N6664F · Substantial damage NTSB MKC68D0202Accident · No injuriesClosedBeech 35 · Augusta, KSSep 11, 1967 · N3758N · Substantial damage NTSB MKC68F0248Accident · No injuriesClosedPiper PA-28 · Easton, KSSep 6, 1967 · N7182R · Substantial damage NTSB MKC68D0168Accident · No injuriesClosedCessna 150 · Emporia, KSSep 4, 1967 · N3854J · Substantial damage NTSB MKC68F0321Accident · No injuriesClosedBeech B35 · Coldwater, KSSep 3, 1967 · N5026C · Substantial damage NTSB MKC68F0190Accident · No injuriesClosedBeech 65 · Wichita, KSSep 3, 1967 · N154F · Substantial damage NTSB MKC68D0196Accident · Minor injuriesClosedPiper PA-22 · Goodland, KSSep 2, 1967 · N2705P · Substantial damage NTSB MKC68A0017Accident · 2 fatalClosedCessna 182D · Grenola, KSSep 2, 1967 · N9096X · Destroyed NTSB MKC68F0383Accident · Minor injuriesClosedErco 415C · Bonner Sprngs, KSAug 25, 1967 · N99771 · Substantial damage NTSB MKC68D0165Accident · No injuriesClosedCessna 188 · Johnson, KSAug 24, 1967 · N8005V · Destroyed NTSB MKC68D0169Accident · No injuriesClosedCessna 150 · Rosehill, KSAug 22, 1967 · N8568J · Substantial damage NTSB MKC68A0012Accident · Minor injuriesClosedCessna 182H · Leawood, KSAug 21, 1967 · N3459S · Substantial damage NTSB MKC68D0198Accident · No injuriesClosedCessna 182H · Hammond, KSAug 19, 1967 · N2434X · Substantial damage NTSB MKC68D0295Accident · No injuriesClosedMooney M20C · Johnson, KSAug 14, 1967 · N5641Q · Substantial damage NTSB MKC68D0201Accident · No injuriesClosedCessna 172C · Clyde, KSAug 13, 1967 · N9151B · Substantial damage NTSB MKC68F0179Accident · No injuriesClosedPiper PA-24 · Hutchinson, KSAug 12, 1967 · N8829P · Substantial damage NTSB MKC68F0278Accident · Minor injuriesClosedAero Comdr 200-E · Augusta, KSAug 11, 1967 · N4001X · Substantial damage NTSB MKC68D0222Accident · No injuriesClosedPiper PA-18A · Antonino, KSAug 10, 1967 · N9847D · Substantial damage NTSB MKC68D0247Accident · No injuriesClosedCessna 172G · Eudora, KSAug 6, 1967 · N3682L · Substantial damage NTSB MKC68D0167Accident · No injuriesClosedSnow S2A · Ruleton, KSAug 6, 1967 · N9463R · Substantial damage NTSB MKC68D0157Accident · No injuriesClosedCessna 172 · Mclouth, KSAug 5, 1967 · N5787R · Substantial damage NTSB MKC68D0183Accident · No injuriesClosedBellanca 14-13 · Garden City, KSAug 4, 1967 · N86877 · Substantial damage NTSB MKC68D0305Accident · No injuriesClosedStits SA3D · Bonner Sprgs, KSAug 3, 1967 · N6103U · Substantial damage NTSB MKC68D0264Accident · No injuriesClosedCessna 150 · Leona, KSAug 2, 1967 · N5642E · Substantial damage NTSB MKC68D0258Accident · No injuriesClosedCessna U206 · Topeka, KSJul 29, 1967 · N2130F · Substantial damage