Skip to content

NTSB investigations, 1967, CO

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

19632026

NTSB investigations, 1967, CO per year, 1963–2026: 4,940 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	44

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" = '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\") = 1967
    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") = 1967
  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 DEN68A0030Accident · 1 fatalClosedCessna 182 · Idaho Spring, CODec 31, 1967 · N681JF · Destroyed NTSB DEN68F0179Accident · Minor injuriesClosedCessna 210 · Denver, CODec 29, 1967 · N6641X · Destroyed NTSB DEN68D0175Accident · No injuriesClosedLuscombe 8F · Broomfield, CODec 28, 1967 · N2109B · Substantial damage NTSB DEN68D0183Accident · No injuriesClosedLuscombe 8E · Castle Rock, CODec 26, 1967 · N1273K · Substantial damage NTSB DEN68F0172Accident · No injuriesClosedPiper PA-24 · Littleton, CODec 21, 1967 · N5133P · Substantial damage NTSB DEN68A0027Accident · 2 fatalClosedDouglas DC-3C · Denver, CODec 21, 1967 · N65276 · Destroyed NTSB DEN68D0182Accident · No injuriesClosedCessna 150 · Longmont, CODec 16, 1967 · N1901Z · Substantial damage NTSB MKC68A0037Accident · Serious injuriesClosedBoeing 720 · Denver, CODec 8, 1967 · N3158 · No damage NTSB DEN68D0149Accident · No injuriesClosedCessna 310 · Grand Junct, CODec 1, 1967 · N5266A · Substantial damage NTSB DEN68F0174Accident · Serious injuriesClosedCessna T337B · Cortez, CONov 26, 1967 · N913PA · Substantial damage NTSB DEN68A0023Accident · 1 fatalClosedMooney M20E · Glenwood Spg, CONov 25, 1967 · N3392X · Destroyed NTSB DEN68D0151Accident · No injuriesClosedCessna 172 · Denver, CONov 24, 1967 · N3749R · Substantial damage NTSB DEN68F0173Accident · No injuriesClosedBeech 35 · Boulder, CONov 22, 1967 · N3870N · Substantial damage NTSB DEN68D0150Accident · No injuriesClosedChampion 7EC · Cheyene Well, CONov 15, 1967 · N9872B · Substantial damage NTSB LAX68I0051Incident · No injuriesClosedBoeing 727 · Alamosa, CONov 12, 1967 · N1935 · Minor damage NTSB DEN68D0139Accident · No injuriesClosedCessna 182E · Colo Springs, CONov 12, 1967 · N3183Y · Substantial damage NTSB DEN68D0137Accident · No injuriesClosedCessna 182 · Gunnison, CONov 11, 1967 · N3589U · Substantial damage NTSB DEN68D0138Accident · No injuriesClosedGlobe GC-1B · Aurora, CONov 10, 1967 · N3246K · Substantial damage NTSB DEN68F0148Accident · No injuriesClosedPiper PA-24 · Denver, CONov 9, 1967 · N6919P · Substantial damage NTSB DEN68A0022Accident · 4 fatalClosedCessna 172 · Greeley, CONov 5, 1967 · N1754F · 2 aircraft · Destroyed NTSB DEN38D0143Accident · Minor injuriesClosedPiper PA-24 · Cedaredge, CONov 4, 1967 · N7254P · Substantial damage NTSB DEN68A0021Accident · No injuriesClosedBell 204-B · Evergreen, CONov 3, 1967 · N7937S · Substantial damage NTSB DEN68F0158Accident · No injuriesClosedCessna T-210 · Denver, CONov 1, 1967 · N6702R · Substantial damage NTSB DEN68A0024Accident · 2 fatalClosedCessna 172 · Pueblo, CONov 1, 1967 · N5753R · Destroyed NTSB DEN68F0176Accident · Minor injuriesClosedCessna 172G · Boulder, COOct 29, 1967 · N5949R · Substantial damage NTSB DEN68F0135Accident · No injuriesClosedPiper PA-28 · Boulder, COOct 27, 1967 · N8806W · Substantial damage NTSB DEN68D0127Accident · No injuriesClosedBeech S35 · Antonito, COOct 24, 1967 · N8933U · Substantial damage NTSB DEN68F0108Accident · No injuriesClosedBeech C35 · Broomfield, COOct 22, 1967 · N1833D · Substantial damage NTSB DEN68D0142Accident · Minor injuriesClosedCessna 182F · Mesa, COOct 20, 1967 · N3402U · Substantial damage NTSB DEN68D0140Accident · Minor injuriesClosedBeech B95 · Longmont, COOct 17, 1967 · N3051 · Substantial damage NTSB DEN68D0136Accident · No injuriesClosedCessna 150 · Watkins, COOct 17, 1967 · N7942F · Substantial damage NTSB DEN68D0111Accident · No injuriesClosedCessna 150 · Pierce, COOct 15, 1967 · N3614J · Substantial damage NTSB DEN68A0020Accident · Minor injuriesClosedBell 47G-3B · Silverthorne, COOct 12, 1967 · N1397X · Substantial damage NTSB DEN68F0119Accident · Minor injuriesClosedCessna 150G · Aurora, COOct 10, 1967 · N4077J · Substantial damage NTSB DEN68D0118Accident · Minor injuriesClosedCessna 150 · Loveland, COOct 2, 1967 · N3557L · Substantial damage NTSB DEN68D0117Accident · Minor injuriesClosedCessna 182 · Colo.Springs, COOct 1, 1967 · N4048D · Substantial damage NTSB DEN68F0109Accident · Minor injuriesClosedPiper PA-24 · Boulder, COSep 30, 1967 · N7500P · Destroyed NTSB DEN68D0141Accident · No injuriesClosedCessna T-210 · Pueblo, COSep 30, 1967 · N6884R · Substantial damage NTSB DEN68D0112Accident · No injuriesClosedCessna 172 · Boulder, COSep 30, 1967 · N2569L · Substantial damage NTSB DEN68D0110Accident · Minor injuriesClosedCessna 172 · Montrose, COSep 29, 1967 · N2534L · Destroyed NTSB DEN68F0113Accident · Minor injuriesClosedBeech 35 · Littleton, COSep 25, 1967 · N2951V · Substantial damage NTSB DEN68D0090Accident · No injuriesClosedBellanca 14-13 · Littleton, COSep 19, 1967 · N74341 · Substantial damage NTSB DEN68F0098Accident · No injuriesClosedCessna 150 · Lamar, COSep 17, 1967 · N6623F · Substantial damage NTSB DEN68D0092Accident · No injuriesClosedCessna 182H · Ft Collins, COSep 9, 1967 · N1809X · Substantial damage NTSB DEN68F0084Accident · Minor injuriesClosedGlobe GC-1B · Littleton, COSep 8, 1967 · N782E · Substantial damage NTSB DEN68D0083Accident · No injuriesClosedCessna 310 · Aspen, COSep 8, 1967 · N440X · Substantial damage NTSB DEN68A0017Accident · No injuriesClosedConvair 580 · Denver, COSep 8, 1967 · N73145 · Substantial damage NTSB DEN68D0089Accident · No injuriesClosedCessna 206 · Lajara, COSep 6, 1967 · N2585X · Substantial damage NTSB DEN68F0075Accident · No injuriesClosedBeech 35 · Broomfield, COSep 2, 1967 · N3922N · Substantial damage NTSB DEN68F0072Accident · No injuriesClosedBeech 35-A33 · Aspen, COSep 1, 1967 · N927Q · Substantial damage