Skip to content

NTSB investigations, 1968, MO

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

19622026

NTSB investigations, 1968, MO per year, 1962–2026: 3,555 cases
1962	1
1963	1
1964	118
1965	136
1966	155
1967	173
1968	100
1969	83
1970	111
1971	112
1972	80
1973	80
1974	80
1975	98
1976	101
1977	96
1978	111
1979	100
1980	85
1981	95
1982	86
1983	84
1984	74
1985	72
1986	54
1987	59
1988	67
1989	47
1990	41
1991	37
1992	40
1993	58
1994	47
1995	39
1996	28
1997	33
1998	29
1999	43
2000	31
2001	33
2002	30
2003	30
2004	32
2005	31
2006	27
2007	31
2008	31
2009	23
2010	23
2011	32
2012	33
2013	21
2014	19
2015	31
2016	29
2017	28
2018	22
2019	20
2020	24
2021	15
2022	19
2023	25
2024	22
2025	19
2026	20

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" = 'MO' 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\" = 'MO' 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" = 'MO' 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 MKC69A0042Accident · 1 fatalClosedCessna 172F · Kennett, MODec 27, 1968 · N7878U · Destroyed NTSB MKC69F0298Accident · No injuriesClosedCessna 140 · Chesterfield, MODec 26, 1968 · N2459N · Substantial damage NTSB MKC69I0041Incident · No injuriesClosedFairchild FH-227 · St.Louis, MODec 22, 1968 · N4233 · Minor damage NTSB MKC69A0040Accident · 2 fatalClosedBeech V35 · Piedmont, MODec 21, 1968 · N7904M · Destroyed NTSB MKC69A0039Accident · 5 fatalClosedMitsubishi MU-2B · Springfield, MODec 21, 1968 · N3550X · Destroyed NTSB MKC69F0293Accident · No injuriesClosedPiper PA-22 · St Charles, MODec 19, 1968 · N4950V · Substantial damage NTSB MKC69A0037Accident · Minor injuriesClosedCessna 182 · Bolivar, MODec 13, 1968 · N42215 · Substantial damage NTSB MKC69D0338Accident · No injuriesClosedPiper PA-28 · Brookfield, MODec 6, 1968 · N5196L · Substantial damage NTSB MKC69I0036Incident · No injuriesClosedBoeing 727 · St Louis, MONov 28, 1968 · N7277F · Minor damage NTSB MKC69F0287Accident · Serious injuriesClosedAeronca 7DC · Sikeston, MONov 28, 1968 · N82685 · Destroyed NTSB MKC69D0283Accident · No injuriesClosedHelio Acft H-295 · Van Buren, MONov 26, 1968 · N427MT · Substantial damage NTSB MKC69F0270Accident · Serious injuriesClosedAeronca 65-TAL · Houston, MONov 24, 1968 · N31354 · Destroyed NTSB MKC69F0282Accident · Minor injuriesClosedMooney M20C · Festus, MONov 23, 1968 · N7192U · Destroyed NTSB MKC69F0269Accident · Minor injuriesClosedBeech A23-19 · Chesterfield, MONov 17, 1968 · N6934Q · Substantial damage NTSB MKC69F0284Accident · No injuriesClosedCessna 172 · Carrollton, MONov 14, 1968 · N4097F · Substantial damage NTSB MKC69D0304Accident · No injuriesClosedCessna 150H · Hinton, MONov 13, 1968 · N22113 · Substantial damage NTSB MKC69F0324Accident · Serious injuriesClosedPiper PA-24 · Kansas City, MOOct 26, 1968 · N8418P · Substantial damage NTSB MKC69I0022Incident · No injuriesClosedBeech 18S · St Louis, MOOct 10, 1968 · N313A · Minor damage NTSB MKC69A0019Accident · 4 fatalClosedCessna 172D · Lexington, MOOct 6, 1968 · N2428U · Destroyed NTSB MKC69D0241Accident · No injuriesClosedBeech A23-19 · Sheldon, MOOct 2, 1968 · N3671Q · Substantial damage NTSB MKC69F0185Accident · Serious injuriesClosedCessna 177 · St.Charles, MOSep 29, 1968 · N3235T · Substantial damage NTSB MKC69F0200Accident · No injuriesClosedCessna 150J · Ft.Lenard Wood, MOSep 27, 1968 · N50579 · Substantial damage NTSB MKC69D0189Accident · No injuriesClosedCessna 172 · Spring City, MOSep 15, 1968 · N8116L · Substantial damage NTSB MKC69D0243Accident · No injuriesClosedCessna 177 · Gravois Mills, MOSep 2, 1968 · N2955X · Destroyed NTSB MKC69D0232Accident · No injuriesClosedPitts SC-1 · Waldron, MOAug 31, 1968 · N1128 · Substantial damage NTSB MKC69D0212Accident · No injuriesClosedPiper PA-22 · Laredo, MOAug 31, 1968 · N2866Z · Substantial damage NTSB MKC69F0126Accident · No injuriesClosedBeech A23-19 · Chesterfield, MOAug 29, 1968 · N2319W · Substantial damage NTSB MKC69A0012Accident · 1 fatalClosedPiper PA-22 · Gravois Mills, MOAug 29, 1968 · N5955D · Destroyed NTSB MKC69F0132Accident · No injuriesClosedPiper PA-12 · St.Charles, MOAug 21, 1968 · N92579 · Substantial damage NTSB MKC69D0211Accident · No injuriesClosedCessna 150 · Columbia, MOAug 20, 1968 · N8500G · Substantial damage NTSB MKC69D0214Accident · No injuriesClosedBeech S35 · Bethany, MOAug 18, 1968 · N8636Q · Substantial damage NTSB MKC69D0178Accident · No injuriesClosedChampion 7KC · Gravois Mills, MOAug 17, 1968 · N6315N · Substantial damage NTSB MKC69D0207Accident · No injuriesClosedCessna 182 · Grain Valley, MOAug 14, 1968 · N42339 · Substantial damage NTSB MKC69F0069Accident · No injuriesClosedCessna 180H · St Paul, MOAug 13, 1968 · N7903V · Substantial damage NTSB MKC69F0056Accident · No injuriesClosedCessna 210 · Poplar Bluff, MOAug 11, 1968 · N2322F · Substantial damage NTSB MKC69D0220Accident · Minor injuriesClosedMooney M20C · Gainesville, MOAug 9, 1968 · N5739Q · Substantial damage NTSB MKC69D0065Accident · No injuriesClosedLuscombe 8A · Mountain View, MOAug 9, 1968 · N1325B · Substantial damage NTSB MKC69A0010Accident · 2 fatalClosedCessna 150H · Republic, MOAug 9, 1968 · N7115S · Destroyed NTSB MKC69F0150Accident · Serious injuriesClosedErcoupe 415-C · New London, MOAug 3, 1968 · N2989H · Destroyed NTSB MKC69F0114Accident · Serious injuriesClosedPiper PA-22 · St Charles, MOAug 1, 1968 · N5188Z · Destroyed NTSB MKC69A0004Accident · 2 fatalClosedBellanca 17-30 · Lees Summit, MOJul 25, 1968 · N4746V · Destroyed NTSB MKC69F0137Accident · Minor injuriesClosedPiper PA-18 · Creve Coeur, MOJul 23, 1968 · N263T · Substantial damage NTSB MKC69D0149Accident · No injuriesClosedCessna 182 · Monett, MOJul 22, 1968 · N8482S · Substantial damage NTSB MKC69D0194Accident · No injuriesClosedBoeing B75N1 · Mountain Grove, MOJul 19, 1968 · N69246 · Substantial damage NTSB MKC69D0057Accident · No injuriesClosedPiper PA-22 · St.Charles, MOJul 17, 1968 · N4812Z · Substantial damage NTSB MKC69D0201Accident · No injuriesClosedCessna 172 · Springfield, MOJul 16, 1968 · N2145Y · Substantial damage NTSB MKC69D0202Accident · No injuriesClosedBeech 95-C55 · Kansas City, MOJul 15, 1968 · N9465S · Substantial damage NTSB MKC69D0193Accident · No injuriesClosedBoeing B75N1 · Lebanon, MOJul 10, 1968 · N66607 · Substantial damage NTSB MKC69F0104Accident · Minor injuriesClosedPiper J3L-65 · Creve Coeur, MOJul 9, 1968 · N33252 · Substantial damage NTSB MKC69D0143Accident · No injuriesClosedPiper PA-20 · Gravois Mills, MOJul 5, 1968 · N7075K · Substantial damage