Skip to content

NTSB investigations, 1966, 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, 1966, 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") = 1966 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\") = 1966
    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") = 1966
  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 MKC67F0394Accident · Serious injuriesClosedCessna 172E · Farmington, MODec 19, 1966 · N5732T · Destroyed NTSB MKC67F0351Accident · No injuriesClosedCessna 150 · Columbia, MODec 17, 1966 · N3131X · Substantial damage NTSB MKC67D0373Accident · No injuriesClosedPiper PA-22 · Macon, MODec 15, 1966 · N3555P · Substantial damage NTSB MKC67F0388Accident · No injuriesClosedCessna 310K · Kansas City, MODec 12, 1966 · N6959L · Substantial damage NTSB MKC67D0372Accident · No injuriesClosedMaule M-4 · Gravois Mills, MODec 3, 1966 · N4747T · Substantial damage NTSB MKC67D0341Accident · No injuriesClosedCessna 150 · Springfield, MODec 3, 1966 · N4154U · Substantial damage NTSB MKC67F0335Accident · No injuriesClosedPiper PA-24 · Republic, MONov 28, 1966 · N6264P · Substantial damage NTSB MKC67F0400Accident · Serious injuriesClosedCessna 310C · Neosho, MONov 25, 1966 · N1771H · Destroyed NTSB MKC67F0390Accident · No injuriesClosedMooney M20C · Faucett, MONov 25, 1966 · N9226M · Substantial damage NTSB MKC67D0352Accident · No injuriesClosedCessna 172 · Bixby, MONov 21, 1966 · N5607R · Destroyed NTSB MKC67D0346Accident · No injuriesClosedPiper PA-22 · Independence, MONov 20, 1966 · N7159D · Substantial damage NTSB MKC67A0035Accident · 1 fatalClosedCessna 150 · Creve Coeur, MONov 20, 1966 · N6791F · Destroyed NTSB MKC67F0369Accident · No injuriesClosedPiper PA-24 · St.Louis, MONov 16, 1966 · N8440P · Substantial damage NTSB MKC67D0363Accident · No injuriesClosedAeronca 7AC · Perryville, MONov 13, 1966 · N2653E · Substantial damage NTSB MKC67F0304Accident · No injuriesClosedBellanca 14-19 · Bridgeton, MONov 11, 1966 · N8545R · Substantial damage NTSB MKC67D0295Accident · No injuriesClosedDehaviland DHC-2 · Forsyth, MONov 8, 1966 · N192Z · Substantial damage NTSB MKC67F0336Accident · Serious injuriesClosedPiper PA-24 · Rolla, MONov 6, 1966 · N8678P · Destroyed NTSB MKC67D0326Accident · No injuriesClosedCessna 150 · Branson, MOOct 31, 1966 · N7702F · Substantial damage NTSB MKC67F0382Accident · No injuriesClosedPiper PA-22 · Post Oak, MOOct 30, 1966 · N8231C · Substantial damage NTSB MKC67D0307Accident · No injuriesClosedPiper PA-28 · Linn Creek, MOOct 30, 1966 · N7539W · Substantial damage NTSB MKC67A0032Accident · No injuriesClosedBeech J35 · St.Louis, MOOct 28, 1966 · N7260B · Substantial damage NTSB MKC67F0288Accident · No injuriesClosedCessna 170 · Ft.L.Wood, MOOct 27, 1966 · N5728C · Substantial damage NTSB MKC67F0296Accident · No injuriesClosedPiper PA-28 · St.Charles, MOOct 23, 1966 · N7040R · Substantial damage NTSB MKC67D0284Accident · No injuriesClosedBeech D35 · Warsaw, MOOct 22, 1966 · N2996B · Substantial damage NTSB MKC67D0240Accident · No injuriesClosedNavion A · Unionville, MOOct 18, 1966 · N8546H · Substantial damage NTSB MKC67F0246Accident · No injuriesClosedCessna 150 · Berkeley, MOOct 14, 1966 · N6678F · Substantial damage NTSB MKC67F0487Accident · Minor injuriesClosedPiper PA-22 · Bowling Green, MOOct 9, 1966 · N8263C · Substantial damage NTSB MKC67D0252Accident · No injuriesClosedBeech A23-19 · St.Joseph, MOOct 9, 1966 · N7913L · Substantial damage NTSB MKC67F0291Accident · 1 fatalClosedCessna 205 · Fredericktown, MOOct 2, 1966 · N1852Z · Destroyed NTSB MKC67F0281Accident · No injuriesClosedGlobe GC-1A · St.Louis, MOOct 2, 1966 · N90321 · Substantial damage NTSB MKC67F0315Accident · Minor injuriesClosedWaco RNF · Chesterfield, MOSep 29, 1966 · N144Y · Substantial damage NTSB MKC67F0236Accident · No injuriesClosedBeech G35 · St.Louis, MOSep 29, 1966 · N4519D · Substantial damage NTSB MKC67D0249Accident · No injuriesClosedAeronca 7FC · Sikeston, MOSep 24, 1966 · N4870E · Substantial damage NTSB MKC67F0259Accident · Minor injuriesClosedPiper PA-28 · Parkville, MOSep 20, 1966 · N6906W · Substantial damage NTSB MKC67D0229Accident · No injuriesClosedBeech 35-33 · Marshall, MOSep 19, 1966 · N9718Y · Substantial damage NTSB MKC67A0024Accident · 1 fatalClosedLuscombe 8E · Eolia, MOSep 18, 1966 · N1208B · Destroyed NTSB MKC67D0278Accident · No injuriesClosedPiper PA-25 · Wardell, MOSep 14, 1966 · N6679Z · Substantial damage NTSB MKC67F0218Accident · No injuriesClosedPiper PA-28 · Webb City, MOSep 12, 1966 · N8803W · Substantial damage NTSB MKC67F0233Accident · Serious injuriesClosedCessna 182 · West Alton, MOSep 10, 1966 · N2837Y · Destroyed NTSB MKC67F0257Accident · No injuriesClosedCessna 172E · St.Charles, MOSep 5, 1966 · N7730U · Substantial damage NTSB MKC67F0204Accident · Minor injuriesClosedStinson 105 · Camdenton, MOSep 5, 1966 · N21197 · Substantial damage NTSB MKC67D0223Accident · No injuriesClosedCessna 150 · Sedalia, MOSep 5, 1966 · N7927F · Substantial damage NTSB MKC67A0018Accident · 1 fatalClosedCessna 172E · Knox City, MOAug 28, 1966 · N3915S · Destroyed NTSB MKC67D0209Accident · No injuriesClosedCessna 150 · St.Charles, MOAug 26, 1966 · N8320G · Substantial damage NTSB MKC67F0208Accident · No injuriesClosedCessna 210 · Fruitland, MOAug 21, 1966 · N8299Z · Substantial damage NTSB MKC67F0192Accident · Serious injuriesClosedPiper PA-24 · Mt Vernon, MOAug 21, 1966 · N5701P · Substantial damage NTSB MKC67D0165Accident · No injuriesClosedBeech 35 · Excelsior Spgs, MOAug 21, 1966 · N1224Z · Substantial damage NTSB MKC67F0276Accident · Minor injuriesClosedCessna 150F · Jackson, MOAug 20, 1966 · N8096S · Destroyed NTSB MKC67D0486Accident · Minor injuriesClosedCessna 150 · West Plains, MOAug 19, 1966 · N6830F · Substantial damage NTSB MKC67D0151Accident · No injuriesClosedLuscombe 8A · Lone Jack, MOAug 16, 1966 · N45792 · Substantial damage