Skip to content

NTSB investigations, 1967, MO

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1967, MO per year, 1962–2026: 3,556 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	21

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" = '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\") = 1967
    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") = 1967
  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 MKC68F0441Accident · No injuriesClosedPiper PA-22 · Edwards, MODec 31, 1967 · N640A · Substantial damage NTSB MKC68D0459Accident · No injuriesClosedBeech 35 · Linneus, MODec 28, 1967 · N2851V · Substantial damage NTSB MKC68F0463Accident · No injuriesClosedPiper PA-24 · Cedar City, MODec 26, 1967 · N8803P · Substantial damage NTSB MKC68D0452Accident · No injuriesClosedCessna 172 · Fenton, MODec 24, 1967 · N2811L · Substantial damage NTSB MKC68F0472Accident · No injuriesClosedCessna 175 · Fenton, MODec 19, 1967 · N7593M · Substantial damage NTSB MKC68D0426Accident · No injuriesClosedPiper PA-22 · Fayette, MODec 13, 1967 · N5969Z · Substantial damage NTSB MKC68D0425Accident · No injuriesClosedPiper PA-23 · Montrose, MODec 12, 1967 · N6059Y · Substantial damage NTSB MKC68F0407Accident · No injuriesClosedBellanca 14-193 · St.Joseph, MODec 8, 1967 · N1260R · Substantial damage NTSB MKC68D0378Accident · No injuriesClosedCessna 150 · Creve Coeur, MODec 6, 1967 · N3457J · Substantial damage NTSB MKC68D0435Accident · No injuriesClosedPiper PA-32 · Warrensburg, MODec 3, 1967 · N3385W · Substantial damage NTSB MKC68D0424Accident · No injuriesClosedCessna 150F · Ferrelview, MODec 3, 1967 · N6684F · Substantial damage NTSB MKC68D0369Accident · Serious injuriesClosedPiper PA-28 · St.Charles, MONov 25, 1967 · N7020W · No damage NTSB MKC68D0410Accident · No injuriesClosedCessna 172 · Kansas City, MONov 24, 1967 · N8673B · Substantial damage NTSB MKC68D0405Accident · No injuriesClosedMooney M20C · Kansas City, MONov 24, 1967 · N9226M · Substantial damage NTSB MKC68A0034Accident · 2 fatalClosedPiper PA-24 · Aurora, MONov 23, 1967 · N6275P · Destroyed NTSB MKC68F0349Accident · Minor injuriesClosedCessna 170B · Salem, MONov 13, 1967 · N1894C · Substantial damage NTSB MKC68D0460Accident · No injuriesClosedCessna 150 · Springfield, MONov 13, 1967 · N7702F · Substantial damage NTSB MKC68F0406Accident · No injuriesClosedCessna 170 · Eldon, MONov 12, 1967 · N4254V · Substantial damage NTSB MKC68F0442Accident · Serious injuriesClosedPiper PA-28 · Willard, MONov 7, 1967 · N9459J · Substantial damage NTSB MKC68D0392Accident · No injuriesClosedPiper J3C-65 · Lancaster, MONov 5, 1967 · N6510H · Substantial damage NTSB MKC68F0313Accident · No injuriesClosedPiper PA-22 · St.Charles, MONov 4, 1967 · N4708Z · Substantial damage NTSB MKC68D0409Accident · No injuriesClosedPiper PA-28 · Columbia, MONov 3, 1967 · N6147W · Substantial damage NTSB MKC68F0415Accident · No injuriesClosedPiper PA-24 · Lambert Field, MOOct 31, 1967 · N8016P · Substantial damage NTSB MKC68A0031Accident · No injuriesClosedPiper PA-32 · Kirksville, MOOct 26, 1967 · N3841W · Substantial damage NTSB MKC68F0307Accident · No injuriesClosedAlon A-2 · Chesterfield, MOOct 23, 1967 · N5613F · Substantial damage NTSB MKC68F0284Accident · Serious injuriesClosedBeech V35 · Cedar City, MOOct 23, 1967 · N6238V · Substantial damage NTSB MKC68D0377Accident · No injuriesClosedPiper PA-23 · Cassville, MOOct 21, 1967 · N4438P · Substantial damage NTSB MKC68A0030Accident · 3 fatalClosedBeech A23 · Stoutland, MOOct 15, 1967 · N5971S · Destroyed NTSB MKC68A0029Accident · 3 fatalClosedCessna 182F · Leopold, MOOct 13, 1967 · N3591U · Destroyed NTSB MKC68F0427Accident · No injuriesClosedBeech E35 · Springfield, MOOct 12, 1967 · N7364B · Substantial damage NTSB MKC68D0466Accident · No injuriesClosedCessna 182 · Osage Beach, MOOct 11, 1967 · N2159R · Substantial damage NTSB MKC68F0329Accident · No injuriesClosedCessna 182 · Mathews, MOOct 9, 1967 · N2408X · Substantial damage NTSB MKC68A0027Accident · No injuriesClosedDouglas DC-6A · Kansas City, MOOct 5, 1967 · N34956 · Substantial damage NTSB MKC68F0403Accident · Serious injuriesClosedPiper PA-28 · Gower, MOOct 1, 1967 · N9063W · Substantial damage NTSB MKC68F0380Accident · No injuriesClosedPiper PA-28 · Clinton, MOSep 25, 1967 · N6906W · Substantial damage NTSB MKC68D0306Accident · Minor injuriesClosedPiper PA-20 · Camden Point, MOSep 24, 1967 · N1973A · Substantial damage NTSB MKC68D0304Accident · No injuriesClosedLake LA-4 · Hermitage, MOSep 24, 1967 · N1138L · Substantial damage NTSB MKC68A0024Accident · No injuriesClosedHughes 269A · Sibley, MOSep 21, 1967 · N8820F · Destroyed NTSB MKC68A0023Accident · 2 fatalClosedPiper PA-30 · Winona, MOSep 20, 1967 · N8360Y · Destroyed NTSB MKC68F0352Accident · Minor injuriesClosedPiper PA-28 · Chesterfield, MOSep 18, 1967 · N9764W · Substantial damage NTSB MKC68F0280Accident · Minor injuriesClosedPiper PA-22 · Saco, MOSep 18, 1967 · N2543A · Substantial damage NTSB MKC68D0297Accident · No injuriesClosedGlobe GC-1B · Harrisonville, MOSep 16, 1967 · N3843K · Substantial damage NTSB MKC68D0316Accident · No injuriesClosedCessna 180 · Hardin, MOSep 12, 1967 · N6502A · Substantial damage NTSB MKC68D0251Accident · Minor injuriesClosedCessna 172 · Clinton, MOSep 11, 1967 · N3738L · Substantial damage NTSB MKC68D0279Accident · No injuriesClosedPiper PA-28 · St.Joseph, MOSep 9, 1967 · N6397W · Substantial damage NTSB MKC68D0226Accident · No injuriesClosedStinson 108-3 · Painton, MOSep 9, 1967 · N625C · Substantial damage NTSB MKC68A0021Accident · 2 fatalClosedPiper PA-28 · Kennett, MOSep 8, 1967 · N5354W · Destroyed NTSB MKC68D0219Accident · No injuriesClosedCessna 140A · Pittsville, MOSep 6, 1967 · N5621C · Substantial damage NTSB MKC68A0016Accident · 2 fatalClosedCessna 172F · Chesterfield, MOAug 30, 1967 · N8621U · Destroyed NTSB MKC68F0365Accident · No injuriesClosedNorthrup 1-D · Amoret, MOAug 28, 1967 · N13777 · Substantial damage