Skip to content

NTSB investigations, 1976, CO

180,658 investigations by the National Transportation Safety Board since 1962: 174,636 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, 1976, CO per year, 1963–2026: 4,941 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	45

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") = 1976 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\") = 1976
    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") = 1976
  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 DEN77FA015Accident · 3 fatalClosedGrum Amer AA-1 · Alder, CODec 19, 1976 · N5679L · Destroyed NTSB DEN77FTE11Accident · No injuriesClosedPiper PA-28 · Pueblo, CODec 18, 1976 · N44558 · Substantial damage NTSB DEN77FTE10Accident · No injuriesClosedPiper PA-25 · Broomfield, CODec 18, 1976 · N8749L · Substantial damage NTSB DEN77FA019Accident · Serious injuriesClosedSikorsky S-64E · Cowdrey, CODec 13, 1976 · N6965R · Substantial damage NTSB DEN77FTE09Accident · No injuriesClosedCessna 150 · Boulder, CODec 11, 1976 · N11961 · Substantial damage NTSB DEN77FA011Accident · 2 fatalClosedPiper PA-32 · Denver, CONov 29, 1976 · N4125R · Substantial damage NTSB DEN77FTE08Accident · No injuriesClosedPiper PA-28R · Boulder, CONov 24, 1976 · N9350K · Substantial damage NTSB DCA77AA003Accident · Serious injuriesClosedDouglas DC-9 · Denver, CONov 16, 1976 · N9104 · Substantial damage NTSB DEN77DTE07Accident · No injuriesClosedHughes 269C · Two Buttes, CONov 14, 1976 · N7457F · Substantial damage NTSB DEN77DTE06Accident · No injuriesClosedPiper PA-25 · Durango, CONov 12, 1976 · N4875Y · Substantial damage NTSB DEN77DA006Accident · No injuriesClosedCessna 182J · Alamosa, COOct 30, 1976 · N2701F · 2 aircraft · Substantial damage NTSB DEN77FA004Accident · 1 fatalClosedPiper PA-32R · Matheson, COOct 27, 1976 · N9705K · Destroyed NTSB DEN76FTE04Accident · Minor injuriesClosedPiper PA-32 · Eads, COOct 17, 1976 · N4842S · Substantial damage NTSB DEN77DTE05Accident · No injuriesClosedCessna 172E · Colorado Spgs, COOct 16, 1976 · N5384 · Substantial damage NTSB DEN77FTE12Accident · No injuriesClosedBeech E18S · Colorado Spgs, COOct 14, 1976 · N136C · Substantial damage NTSB DEN77FTE02Accident · Serious injuriesClosedCessna 210L · Pueblo, COOct 10, 1976 · N732EJ · Destroyed NTSB DEN77DTE03Accident · No injuriesClosedCessna 182K · Pagosa Spgs, COOct 3, 1976 · N2578Q · Substantial damage NTSB DEN77FTE01Accident · Serious injuriesClosedGrum Amer AA-5A · Idaho Spgs, COOct 2, 1976 · N9716U · Destroyed NTSB DEN76FTF02Accident · No injuriesClosedCessna 182A · Poncha Pass, COSep 26, 1976 · N3764D · Destroyed NTSB DEN76AD074Accident · 6 fatalClosedPiper PA-23 · Steamboat Spgs, COSep 26, 1976 · N777MF · Destroyed NTSB DEN76FTE98Accident · No injuriesClosedErco 415-C · Ft.Collins, COSep 22, 1976 · N99107 · Substantial damage NTSB DEN76FTF97Accident · Serious injuriesClosedCulver LCA · Littleton, COSep 19, 1976 · N29393 · Substantial damage NTSB DEN76FTE99Accident · Serious injuriesClosedLuscombe 8E · Loma, COSep 17, 1976 · N1492K · Substantial damage NTSB DEN76FTE96Accident · No injuriesClosedPiper PA-24 · Lamar, COSep 17, 1976 · N7951P · Substantial damage NTSB DEN76FTE95Accident · No injuriesClosedStinson 108-2 · Peyton, COSep 6, 1976 · N9320K · Substantial damage NTSB DEN76FTE94Accident · Serious injuriesClosedBell 47G3B2 · Aspen, COAug 24, 1976 · N4074G · Destroyed NTSB DEN76AD069Accident · 5 fatalClosedPiper PA-28 · Lake City, COAug 24, 1976 · N2670T · Destroyed NTSB DEN76AD068Accident · 1 fatalClosedBell 47G3B1 · Alma, COAug 23, 1976 · N1338X · Destroyed NTSB DEN76DTE92Accident · No injuriesClosedLuscombe 8A · Craig, COAug 22, 1976 · N2979K · Substantial damage NTSB DEN76FTE93Accident · Serious injuriesClosedPiper PA-28 · Monte Vista, COAug 18, 1976 · N32322 · Substantial damage NTSB DEN76AD067Accident · 5 fatalClosedBeech 95-B55 · Carracas, COAug 18, 1976 · N7783R · Destroyed NTSB DEN76FTE91Accident · Minor injuriesClosedPiper PA-28 · Peyton, COAug 16, 1976 · N7900C · Substantial damage NTSB DEN76DTE01Accident · No injuriesClosedBeech V35B · Greeley, COAug 16, 1976 · N766T · Substantial damage NTSB DEN76DTE88Accident · No injuriesClosedCessna 195 · Hayden, COAug 15, 1976 · N775A · Substantial damage NTSB DEN76AD064Accident · 2 fatalClosedPiper PA-24 · Pierce, COAug 15, 1976 · N8808P · Destroyed NTSB DEN76FTE89Accident · No injuriesClosedCessna 150 · Hanover, COAug 14, 1976 · N3087J · Substantial damage NTSB DEN76AD063Accident · 2 fatalClosedStinson 108-3 · Pagosa Springs, COAug 12, 1976 · CGGDY · Destroyed NTSB DEN76FTE90Accident · No injuriesClosedCessna 172 · Englewood, COAug 11, 1976 · N35569 · Substantial damage NTSB DEN76AD062Accident · 1 fatalClosedDouglas A-26B · Grand Junction, COAug 8, 1976 · N3427G · Destroyed NTSB DEN76FTE87Accident · No injuriesClosedBeech 35 · Englewood, COAug 7, 1976 · N3144V · Substantial damage NTSB DEN76DTE86Accident · Serious injuriesClosedPiper PA-18 · Cheyenne Wells, COAug 1, 1976 · N3905Z · Destroyed NTSB DEN76FTE85Accident · Minor injuriesClosedPiper PA-28 · Ft Collins, COJul 29, 1976 · N43492 · Destroyed NTSB DEN76FTE84Accident · No injuriesClosedGrum Amer AA-5 · Boulder, COJul 22, 1976 · N7199L · Substantial damage NTSB DEN76AD059Accident · 1 fatalClosedCessna 182J · Lamar, COJul 18, 1976 · N3169F · Destroyed NTSB DEN76DTE83Accident · No injuriesClosedCessna 172 · Limon, COJul 17, 1976 · N20545 · Substantial damage NTSB DEN76AD058Accident · 1 fatalClosedDouglas A-26B · Grand Valley, COJul 16, 1976 · N5426E · Destroyed NTSB DEN76FTE82Accident · No injuriesClosedPiper PA-28 · Englewood, COJul 14, 1976 · N55542 · Substantial damage NTSB DEN76FTE81Accident · Serious injuriesClosedCessna 140 · Englewood, COJul 14, 1976 · N89070 · Substantial damage NTSB DEN76AD057Accident · 2 fatalClosedPiper PA-28R · Aurora, COJul 9, 1976 · N3784T · Destroyed NTSB DEN77DTE13Accident · No injuriesClosedBeech C45H · Buena Vista, COJul 8, 1976 · N1597 · Substantial damage