Skip to content

NTSB investigations, 1968, 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, 1968, 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") = 1968 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\") = 1968
    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") = 1968
  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 DEN69D0205Accident · No injuriesClosedPiper PA-23 · Boulder, CODec 31, 1968 · N1097P · Substantial damage NTSB DEN69D0157Accident · No injuriesClosedPiper PA-28 · Sheridan Lke, CODec 29, 1968 · N9899W · Substantial damage NTSB DEN69D0171Accident · No injuriesClosedBeech A23-19 · Greeley, CODec 28, 1968 · N5089T · Substantial damage NTSB DEN69A0030Accident · Minor injuriesClosedCessna 150 · Aurora, CODec 26, 1968 · N6253R · 2 aircraft · Substantial damage NTSB DEN69F0167Accident · No injuriesClosedCessna 172 · Denver, CODec 25, 1968 · N4411L · Substantial damage NTSB DEN69F0168Accident · No injuriesClosedPiper PA-23 · Denver, CODec 22, 1968 · N1135P · Substantial damage NTSB DEN69I0027Incident · No injuriesClosedBoeing 7270C · Gnd Junction, CODec 21, 1968 · N7411U · No damage NTSB DEN69D0204Accident · No injuriesClosedPiper PA-18 · Fountain, CODec 12, 1968 · N1983C · Destroyed NTSB DEN69D0152Accident · No injuriesClosedPiper PA-30 · Denver, CODec 11, 1968 · N84337 · Substantial damage NTSB DEN69D0231Accident · Minor injuriesClosedCessna 182 · Collbran, CODec 7, 1968 · N3140F · Substantial damage NTSB DEN69D0151Accident · No injuriesClosedLuscombe 8F · Aurora, CODec 5, 1968 · N812B · Substantial damage NTSB DEN69F0153Accident · No injuriesClosedBeech 60 · Denver, CONov 30, 1968 · N7064D · Substantial damage NTSB DEN69A0026Accident · 1 fatalClosedPiper PA-28 · Creede, CONov 21, 1968 · N7481R · Substantial damage NTSB DEN69I0025Incident · No injuriesClosedBoeing 707 · Denver, CONov 19, 1968 · N17325 · Minor damage NTSB DEN69A0024Accident · 2 fatalClosedPiper PA-24 · Platteville, CONov 16, 1968 · N6524P · Destroyed NTSB DEN69F0156Accident · No injuriesClosedBeech D35 · Broomfield, CONov 12, 1968 · N2911B · Substantial damage NTSB DEN69A0022Accident · 1 fatalClosedBeech 35-C33 · Colo.Sprgs, CONov 7, 1968 · N699K · Destroyed NTSB DEN69D0139Accident · No injuriesClosedCessna 177 · Englewood, CONov 1, 1968 · N2335Y · Substantial damage NTSB DEN69D0154Accident · No injuriesClosedMooney M20C · Loveland, COOct 31, 1968 · N6935N · Substantial damage NTSB DEN69F0166Accident · No injuriesClosedCessna 310C · Broomfield, COOct 25, 1968 · N1813H · Substantial damage NTSB DEN69D0143Accident · No injuriesClosedCessna 150 · Colo Springs, COOct 17, 1968 · N8880G · Substantial damage NTSB DEN69D0133Accident · No injuriesClosedErco 415-C · Littleton, COOct 17, 1968 · N99905 · Substantial damage NTSB DEN69D0130Accident · No injuriesClosedCessna 180 · Steamboat Sg, COOct 14, 1968 · N4660B · Substantial damage NTSB DEN69F0158Accident · Serious injuriesClosedErco 415-C · Montrose, COOct 13, 1968 · N93542 · Substantial damage NTSB DEN69A0019Accident · 2 fatalClosedFleet Acft 16B · Niwot, COOct 13, 1968 · N9427H · Destroyed NTSB DEN69D0129Accident · No injuriesClosedCessna 310F · Watkins, COOct 12, 1968 · N5821X · Substantial damage NTSB DEN69D0121Accident · No injuriesClosedReeves Teller · Watkins, COOct 12, 1968 · N1685 · Substantial damage NTSB DEN69D0106Accident · No injuriesClosedPiper PA-28 · Rangely, COOct 3, 1968 · N9639W · Substantial damage NTSB DEN69D0126Accident · No injuriesClosedBeech 36 · Denver, COOct 1, 1968 · N7505N · Substantial damage NTSB DEN69D0100Accident · No injuriesClosedPiper PA-28 · Aspen, COSep 27, 1968 · N7796W · Substantial damage NTSB DEN69D0150Accident · No injuriesClosedCessna 172 · Ft.Carson, COSep 26, 1968 · N7156A · Substantial damage NTSB DEN69F0116Accident · Serious injuriesClosedPiper PA-24 · Grnd Juncton, COSep 23, 1968 · N7294P · Destroyed NTSB DEN69A0014Accident · 5 fatalClosedCessna 210 · Fort Morgan, COSep 21, 1968 · N3745Y · Destroyed NTSB DEN69F0122Accident · Minor injuriesClosedStinson 108-2 · Aurora, COSep 19, 1968 · N8096K · Destroyed NTSB DEN69F0117Accident · Serious injuriesClosedPiper PA-28 · Grnd Jnction, COSep 19, 1968 · N6962W · Substantial damage NTSB DEN69F0114Accident · No injuriesClosedPiper PA-32 · Littleton, COSep 19, 1968 · N3284W · Substantial damage NTSB DEN69D0142Accident · No injuriesClosedPiper PA-31 · Denver, COSep 19, 1968 · N9036Y · Substantial damage NTSB DEN69D0104Accident · No injuriesClosedCessna 150 · Englewood, COSep 15, 1968 · N22028 · Substantial damage NTSB DEN69F0189Accident · 2 fatalClosedPiper PA-24 · Littleton, COSep 14, 1968 · N7915P · Destroyed NTSB DEN69D0131Accident · No injuriesClosedCessna 195 · Broomfield, COSep 14, 1968 · N1015D · 2 aircraft · Substantial damage NTSB DEN69D0115Accident · Serious injuriesClosedPiper PA-28 · Rangely, COSep 8, 1968 · N3966T · Destroyed NTSB DEN69F0107Accident · No injuriesClosedLincoln Sport · Aurora, COSep 6, 1968 · N9139 · Substantial damage NTSB DEN69D0096Accident · No injuriesClosedMooney M20B · Eagle, COSep 1, 1968 · N74508 · Substantial damage NTSB DEN69F0118Accident · No injuriesClosedPiper PA-28 · Greely, COAug 30, 1968 · N7076R · Substantial damage NTSB DEN69F0113Accident · No injuriesClosedBeech 95B55 · Greely, COAug 30, 1968 · N8437N · Substantial damage NTSB DEN69A0011Accident · 1 fatalClosedBeech G35 · Castle Rock, COAug 29, 1968 · N1020A · Destroyed NTSB DEN69A0010Accident · 1 fatalClosedCessna T-210F · Mesa, COAug 28, 1968 · N6196R · Destroyed NTSB DEN69D0077Accident · No injuriesClosedPiper PA-30 · Littleton, COAug 24, 1968 · N8469Y · Substantial damage NTSB DEN69D0087Accident · No injuriesClosedBeech A23-19 · Greeley, COAug 14, 1968 · N5089T · Substantial damage NTSB DEN69A0006Accident · 1 fatalClosedMooney M20C · Wetmore, COAug 10, 1968 · N5917Q · Destroyed