Skip to content

NTSB investigations, 1968, KS

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 MKC69F0295Accident · No injuriesClosedPiper PA-32 · Salina, KSDec 18, 1968 · N3464W · Substantial damage NTSB MKC69D0305Accident · No injuriesClosedCessna 182 · Leawood, KSNov 27, 1968 · N3139R · Substantial damage NTSB MKC69F0271Accident · No injuriesClosedBeech A23A · Wichita, KSNov 24, 1968 · N6942Q · Substantial damage NTSB MKC69F0257Accident · No injuriesClosedBeech 60 · Newton, KSNov 22, 1968 · N7660D · Substantial damage NTSB MKC69D0259Accident · No injuriesClosedCessna 182L · Garden City, KSNov 10, 1968 · N42105 · Substantial damage NTSB MKC69A0031Accident · 2 fatalClosedCessna 180 · Victoria, KSNov 8, 1968 · N4991A · Destroyed NTSB MKC69A0030Accident · 3 fatalClosedNavion A · St.John, KSNov 8, 1968 · N91684 · Destroyed NTSB MKC69A0029Accident · 1 fatalClosedBeech A65 · Wichita, KSNov 7, 1968 · F-BRAR · Destroyed NTSB MKC69F0249Accident · Minor injuriesClosedCamair 480 · Stilwell, KSNov 3, 1968 · N10600 · Substantial damage NTSB MKC69F0240Accident · Serious injuriesClosedPiper PA-22 · Goodland, KSOct 30, 1968 · N2803P · No damage NTSB MKC69D0245Accident · No injuriesClosedStinson 108-2 · Sharon Sprgs, KSOct 29, 1968 · N9807K · Substantial damage NTSB MKC69F0223Accident · No injuriesClosedErcoupe 415-C · South Haven, KSOct 28, 1968 · N37139 · Substantial damage NTSB MKC69D0256Accident · No injuriesClosedStinson 108-3 · Hill City, KSOct 27, 1968 · N856C · Substantial damage NTSB MKC69D0255Accident · No injuriesClosedStinson 108-3 · Beaumont, KSOct 26, 1968 · N6676M · Substantial damage NTSB MKC69D0260Accident · No injuriesClosedCessna 150 · Kansas City, KSOct 20, 1968 · N6451F · Substantial damage NTSB MKC69D0250Accident · No injuriesClosedCessna 150 · Lake City, KSOct 19, 1968 · N7810E · Substantial damage NTSB MKC69F0221Accident · Serious injuriesClosedCessna 172 · Wakeeney, KSOct 15, 1968 · N6064A · Substantial damage NTSB MKC69A0025Accident · 1 fatalClosedPiper PA-23 · Colby, KSOct 15, 1968 · N6515Y · Destroyed NTSB MKC69A0024Accident · 2 fatalClosedBeech 95 · Kansas City, KSOct 15, 1968 · N8217D · Destroyed NTSB MKC69D0230Accident · No injuriesClosedCessna 150 · Alma, KSOct 13, 1968 · N8895G · Substantial damage NTSB MKC69D0217Accident · No injuriesClosedPiper PA-22 · Salina, KSOct 7, 1968 · N9247D · Substantial damage NTSB MKC69D0188Accident · No injuriesClosedBensen B-8 · Pratt, KSOct 6, 1968 · N9144 · Substantial damage NTSB MKC69A0018Accident · 1 fatalClosedBeech V35A · Augusta, KSSep 30, 1968 · N7519N · Destroyed NTSB MKC69D0233Accident · No injuriesClosedCessna 150 · Kansas City, KSSep 29, 1968 · N22595 · 2 aircraft · Substantial damage NTSB MKC69F0180Accident · No injuriesClosedBeech 23 · Garden City, KSSep 27, 1968 · N8711M · Destroyed NTSB MKC69F0216Accident · No injuriesClosedMooney M20E · Johnson, KSSep 25, 1968 · N6009Q · Substantial damage NTSB MKC69A0016Accident · No injuriesClosedHughes 269B · Kansas City, KSSep 25, 1968 · N9325F · Destroyed NTSB MKC69A0015Accident · 2 fatalClosedCessna 182B · Olathe, KSSep 24, 1968 · N2316G · Destroyed NTSB MKC69D0234Accident · No injuriesClosedCessna 150 · Leavenworth, KSSep 19, 1968 · N23226 · Substantial damage NTSB MKC69F0224Accident · No injuriesClosedBeech 95-B55 · Kansas City, KSSep 18, 1968 · N173D · Substantial damage NTSB MKC69D0139Accident · No injuriesClosedPiper PA-24 · Winfield, KSSep 11, 1968 · N8381P · Substantial damage NTSB MKC69D0117Accident · No injuriesClosedCessna 170B · Wichita, KSSep 5, 1968 · N3143B · Substantial damage NTSB MKC69D0181Accident · No injuriesClosedCessna 182 · Pratt, KSSep 2, 1968 · N2811F · Substantial damage NTSB MKC69D0123Accident · No injuriesClosedPiper PA-22 · Blue Rapids, KSSep 1, 1968 · N4690Z · Substantial damage NTSB MKC69F0210Accident · Serious injuriesClosedPiper PA-28 · Bonner Sprgs, KSAug 29, 1968 · N4917J · Substantial damage NTSB MKC69D0206Accident · Minor injuriesClosedLuscombe 8A · Bonner Sprgs, KSAug 25, 1968 · N71574 · Substantial damage NTSB MKC69D0146Accident · No injuriesClosedPiper PA-25 · Scott City, KSAug 23, 1968 · N4804Y · Substantial damage NTSB MKC69D0061Accident · No injuriesClosedCessna 177 · Wichita, KSAug 18, 1968 · N30183 · Substantial damage NTSB MKC69D0215Accident · No injuriesClosedBeech A23 · Topeka, KSAug 17, 1968 · N3653Q · Substantial damage NTSB MKC69D0063Accident · No injuriesClosedPiper PA-24 · Tribune, KSAug 15, 1968 · N9206P · Substantial damage NTSB MKC69D0205Accident · No injuriesClosedCessna 177 · Topeka, KSAug 13, 1968 · N2883X · Substantial damage NTSB MKC69D0172Accident · No injuriesClosedPiper PA-22 · Dighton, KSAug 12, 1968 · N5246Z · Substantial damage NTSB MKC69D0116Accident · No injuriesClosedCessna A188 · Scott City, KSAug 11, 1968 · N8081V · Substantial damage NTSB MKC69D0108Accident · No injuriesClosedPiper PA-18A · Concordia, KSAug 3, 1968 · N4891A · Destroyed NTSB MKC69D0109Accident · No injuriesClosedCessna 188 · Ulysses, KSAug 2, 1968 · N8086V · Substantial damage NTSB MKC69A0006Accident · 1 fatalClosedPiper PA-28 · Ness City, KSJul 28, 1968 · N5148L · Destroyed NTSB MKC69A0005Accident · 3 fatalClosedMooney M20G · Phillipsburg, KSJul 24, 1968 · N6850N · Destroyed NTSB MKC69D0062Accident · Minor injuriesClosedPiper PA-28 · Summerfield, KSJul 14, 1968 · N7519R · Substantial damage NTSB MKC69D0173Accident · Minor injuriesClosedTaylorcraft BC12-D · Lacygne, KSJul 13, 1968 · N96438 · Substantial damage NTSB MKC69D0204Accident · No injuriesClosedErco 415-C · Stilwell, KSJul 1, 1968 · N93624 · Substantial damage