Skip to content

NTSB investigations, 1966, CO

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, 1966, CO per year, 1963–2026: 4,939 cases
1963	1
1964	117
1965	112
1966	149
1967	145
1968	130
1969	123
1970	100
1971	118
1972	91
1973	107
1974	130
1975	104
1976	100
1977	121
1978	118
1979	120
1980	98
1981	94
1982	105
1983	106
1984	94
1985	88
1986	71
1987	95
1988	86
1989	80
1990	78
1991	89
1992	90
1993	71
1994	63
1995	74
1996	85
1997	69
1998	66
1999	86
2000	74
2001	70
2002	73
2003	65
2004	73
2005	75
2006	54
2007	63
2008	60
2009	51
2010	47
2011	54
2012	57
2013	48
2014	49
2015	39
2016	31
2017	34
2018	33
2019	35
2020	44
2021	47
2022	34
2023	38
2024	31
2025	43
2026	43

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" = 'CO' 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\" = 'CO' 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" = 'CO' 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 DEN67D0184Accident · No injuriesClosedCessna 210 · Seibert, CODec 28, 1966 · N7487E · Substantial damage NTSB DEN67D0187Accident · No injuriesClosedCessna 180 · Broomfield, CODec 18, 1966 · N3354D · Substantial damage NTSB DEN67D0188Accident · No injuriesClosedCessna 185 · Watkins, CODec 17, 1966 · N9955X · Substantial damage NTSB DEN67D0189Accident · No injuriesClosedCessna 180 · Aurora, CODec 16, 1966 · N2904C · Substantial damage NTSB DEN67D0179Accident · No injuriesClosedCessna 150 · Montrose, CODec 5, 1966 · N8804S · Substantial damage NTSB DEN67D0174Accident · Minor injuriesClosedLuscombe 8A · Greeley, CODec 1, 1966 · N77831 · Substantial damage NTSB DEN67D0167Accident · No injuriesClosedCessna 150 · Logmont, CONov 30, 1966 · N3817J · Substantial damage NTSB DEN67F0156Accident · Minor injuriesClosedPiper PA-28 · Littleton, CONov 26, 1966 · N8509W · Substantial damage NTSB DEN67D0173Accident · No injuriesClosedPiper PA-28 · Aurora, CONov 26, 1966 · N7171R · Substantial damage NTSB DEN67D0164Accident · No injuriesClosedCessna 140 · Aurora, CONov 26, 1966 · N3532V · Substantial damage NTSB DEN67D0163Accident · No injuriesClosedMooney M20C · Colorado Spg, CONov 26, 1966 · N3381X · Substantial damage NTSB DEN67A0033Accident · 1 fatalClosedStinson 108-1 · Sterling, CONov 23, 1966 · N880C · Destroyed NTSB DEN67F0159Accident · No injuriesClosedBeech 35 · Loveland, CONov 19, 1966 · N2838V · Substantial damage NTSB DEN67F0157Accident · No injuriesClosedCessna 182H · Denver, CONov 19, 1966 · N8440S · Substantial damage NTSB DEN67D0218Accident · No injuriesClosedCessna 310 · Denver, CONov 16, 1966 · N440LM · Substantial damage NTSB DEN67D0150Accident · No injuriesClosedCessna 172 · Denver, CONov 16, 1966 · N1836Y · Substantial damage NTSB DEN67D0155Accident · No injuriesClosedCessna 150 · Aurora, CONov 14, 1966 · N8056F · Substantial damage NTSB DEN67A0032Accident · 1 fatalClosedCessna 182 · Lamar, CONov 9, 1966 · N3247S · Destroyed NTSB DEN67D0165Accident · No injuriesClosedCessna 310H · Greeley, CONov 7, 1966 · N1135Q · Substantial damage NTSB DEN67D0183Accident · No injuriesClosedCessna 172 · Aurora, CONov 5, 1966 · N3147X · Substantial damage NTSB DEN67A0031Accident · 2 fatalClosedCessna 150F · Erie, CONov 5, 1966 · N7981F · Destroyed NTSB DEN67I0030Incident · No injuriesClosedBoeing 707 124 · Denver, CONov 4, 1966 · N74612 · No damage NTSB DEN67D0136Accident · No injuriesClosedCessna 210B · Broomfield, COOct 28, 1966 · N9738X · Substantial damage NTSB DEN67F0135Accident · No injuriesClosedPiper PA-23 · Sterling, COOct 24, 1966 · N1094P · Substantial damage NTSB DEN67F0134Accident · No injuriesClosedCessna 150 · Denver, COOct 24, 1966 · N7979E · Substantial damage NTSB DEN67F0131Accident · No injuriesClosedMooney M20E · Denver, COOct 24, 1966 · N9355M · Substantial damage NTSB DEN67F0126Accident · No injuriesClosedBeech C35 · Littleton, COOct 16, 1966 · N1885D · Substantial damage NTSB DEN67F0127Accident · No injuriesClosedPiper PA-24 · Denver, COOct 15, 1966 · N5468P · Substantial damage NTSB DEN67D0178Accident · No injuriesClosedCessna 182 · Lamar, COOct 15, 1966 · N2111R · Substantial damage NTSB DEN67D0130Accident · No injuriesClosedCessna 172 · Denver, COOct 13, 1966 · N3905L · Substantial damage NTSB DEN67D0128Accident · No injuriesClosedStinson L-5 · Arvada, COOct 9, 1966 · N67123 · Substantial damage NTSB DEN67I0027Incident · No injuriesClosedLockheed TV-2 · Colo.Springs, COOct 6, 1966 · N155 · Minor damage NTSB DEN67F0175Accident · No injuriesClosedPiper PA-22 · Greeley, COSep 30, 1966 · N7614D · Substantial damage NTSB DEN67D0149Accident · No injuriesClosedCessna 150 · Artesia, COSep 28, 1966 · N5747E · Substantial damage NTSB DEN67F0106Accident · No injuriesClosedPiper PA-30 · Fountain, COSep 27, 1966 · N7903Y · Substantial damage NTSB DEN67D0137Accident · No injuriesClosedBeech A23 · Lake George, COSep 25, 1966 · N5780V · Substantial damage NTSB DEN67F0132Accident · Minor injuriesClosedErcoupe 415-C · Aurora, COSep 24, 1966 · N2839H · Substantial damage NTSB DEN67A0025Accident · 2 fatalClosedMooney M20C · Rye, COSep 24, 1966 · N6777U · Destroyed NTSB DEN67D0140Accident · No injuriesClosedBoeing A75 · Broomfield, COSep 23, 1966 · N9040R · Substantial damage NTSB DEN67D0148Accident · No injuriesClosedPiper PA-28 · Stratton, COSep 19, 1966 · N8674W · Substantial damage NTSB DEN67F0104Accident · Minor injuriesClosedCessna 172B · Larkspur, COSep 15, 1966 · N7403X · Substantial damage NTSB DEN67A0020Accident · 2 fatalClosedBeech J35 · Watkins, COSep 15, 1966 · N7225B · Destroyed NTSB DEN67A0019Accident · 1 fatalClosedPiper PA-32 · Granby, COSep 12, 1966 · N3387W · Destroyed NTSB DEN67D0105Accident · Serious injuriesClosedPiper J-3 · Center, COSep 9, 1966 · N70875 · Destroyed NTSB DEN67D0085Accident · No injuriesClosedPiper PA-30 · Denver, COSep 5, 1966 · N7778V · Substantial damage NTSB DEN67D0087Accident · No injuriesClosedCessna 320B · Haswell, COSep 4, 1966 · N986J · Substantial damage NTSB DEN67F0103Accident · No injuriesClosedPiper PA-24 · Erie, COSep 2, 1966 · N7940P · Substantial damage NTSB DEN67D0139Accident · No injuriesClosedBeech C-45H · Alamosa, COSep 2, 1966 · N111Z · Destroyed NTSB DEN67F0092Accident · No injuriesClosedCessna 172 · Littleton, COAug 30, 1966 · N4624L · Substantial damage NTSB DEN67F0102Accident · No injuriesClosedLuscombe 8A · Littleton, COAug 28, 1966 · N1095K · Substantial damage