Skip to content

NTSB investigations, 1979, 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, 1979, 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") = 1979 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\") = 1979
    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") = 1979
  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 DEN80DTE17Accident · No injuriesClosedCessna 150M · Peyton, CODec 30, 1979 · N9424U · Substantial damage NTSB DEN80FTE16Accident · Minor injuriesClosedCessna 150 · Paonia, CODec 28, 1979 · N50089 · Substantial damage NTSB DEN80FA016Accident · 1 fatalClosedBeech B60 · Hayden, CODec 28, 1979 · N6030S · Destroyed NTSB DEN79FA015Accident · 5 fatalClosedCessna 421B · Eagle.Co, CODec 26, 1979 · N100RV · Destroyed NTSB DEN80FA014Accident · 1 fatalClosedPiper PA-23 · Grand Lake, CODec 23, 1979 · N2013P · Substantial damage NTSB DEN80FTE13Accident · Minor injuriesClosedCessna 182 · Gunnison, CODec 15, 1979 · N2191G · Destroyed NTSB DEN80DTE15Accident · No injuriesClosedCessna 182 · Ft Collins, CODec 15, 1979 · N735JB · Substantial damage NTSB DEN80FTE14Accident · Minor injuriesClosedCessna R172K · Montrose, CODec 14, 1979 · N736LR · Substantial damage NTSB DEN80FTE12Accident · 2 fatalClosedDelta Dyke · Broomfield, CODec 13, 1979 · N99DD · Substantial damage NTSB DEN80FTE07Accident · No injuriesClosedCessna 310K · Longmont, CODec 12, 1979 · N7058L · Substantial damage NTSB DEN80FTE11Accident · No injuriesClosedPiper PA-18 · Englewood, CODec 5, 1979 · N82065 · Substantial damage NTSB DEN80FA011Accident · 2 fatalClosedCessna 182 · Longmont, CODec 3, 1979 · N3194S · Destroyed NTSB DEN80FTE10Accident · No injuriesClosedCessna 182 · Longmont, CODec 2, 1979 · N97640 · Substantial damage NTSB DEN80FTE09Accident · 1 fatalClosedWoody Push WAS-2 · Rocky Ford, CONov 23, 1979 · N8450 · Substantial damage NTSB DEN80FA009Accident · 2 fatalClosedCessna 500 · Castle Rock, CONov 19, 1979 · N555AJ · Destroyed NTSB DEN80FTE08Accident · Minor injuriesClosedSkybolt Newlnd · Fort Collins, CONov 17, 1979 · N24GN · Destroyed NTSB DEN80DTE06Accident · No injuriesClosedBellanca 14-19 · Center, CONov 16, 1979 · N8525R · Substantial damage NTSB DEN80DTE05Accident · No injuriesClosedCessna 185 · Greeley, CONov 13, 1979 · N4742E · Substantial damage NTSB DEN80FTE04Accident · No injuriesClosedPiper PA-23 · Peyton, COOct 25, 1979 · N4038P · Substantial damage NTSB DEN80DTE03Accident · No injuriesClosedPiper PA-28 · Byers, COOct 17, 1979 · N3986X · Substantial damage NTSB DEN80FTE02Accident · Minor injuriesClosedPiper PA-18 · Evergreen, COOct 15, 1979 · N5770D · Substantial damage NTSB DEN80FA003Accident · 8 fatalClosedCessna T210N · Gunnison, COOct 14, 1979 · N7618N · Destroyed NTSB DEN80DTE01Accident · No injuriesClosedCessna T182RG · Wolcott, COOct 12, 1979 · N757HW · Substantial damage NTSB DEN80FA001Accident · Serious injuriesClosedBrittnorman BN2A-9 · Crested Butte, COOct 8, 1979 · N13CA · Substantial damage NTSB DEN79FTE83Accident · No injuriesClosedSmith Mini DSA1 · East Fruita, COSep 29, 1979 · N15JH · Substantial damage NTSB DEN79FTE86Accident · No injuriesClosedBellanca 8GCBC · Wellington, COSep 26, 1979 · N7871S · Destroyed NTSB DEN79DTE85Accident · Serious injuriesClosedSchweizer SGS233 · Colorado Spgs, COSep 26, 1979 · N65840 · Substantial damage NTSB DEN79IA063Incident · No injuriesClosedEnstrom 280-C · Brighton, COSep 19, 1979 · N598H · No damage NTSB DEN79FTE82Accident · No injuriesClosedCessna TU206G · Rifle, COSep 16, 1979 · N756KW · Substantial damage NTSB DEN79FA061Accident · 2 fatalClosedBeech A-36 · Garfield, COSep 14, 1979 · N2847W · Destroyed NTSB DEN79FA060Accident · Minor injuriesClosedCessna 206 · Grand Junction, COSep 11, 1979 · N8301Q · Substantial damage NTSB DEN79FTE84Accident · No injuriesClosedCessna 182 · Loveland, COSep 10, 1979 · N92286 · Substantial damage NTSB DEN79DTE81Accident · No injuriesClosedCessna A188B · Monte Vista, COSep 9, 1979 · N4781Q · Substantial damage NTSB DEN79FTE80Accident · Serious injuriesClosedVarieze 1 · Fort Collins, COSep 1, 1979 · N60HD · Substantial damage NTSB DEN79DTE79Accident · No injuriesClosedCessna 172 · Dove Creek, COAug 30, 1979 · N30509 · Substantial damage NTSB DEN79FTE77Accident · Minor injuriesClosedCessna 152 · Center, COAug 27, 1979 · N24967 · Substantial damage NTSB DEN79FTE76Accident · No injuriesClosedBellanca 17-30 · Colorado Sprng, COAug 21, 1979 · N4853V · Destroyed NTSB DEN79IA062Incident · No injuriesClosedBellanca 7ECA · Peyton, COAug 19, 1979 · N2888Z · No damage NTSB DEN79DTE75Accident · No injuriesClosedCessna 340 · Colorado City, COAug 19, 1979 · N1536G · Substantial damage NTSB DEN79FA055Accident · 2 fatalClosedBell 47G3B1 · Rico, COAug 17, 1979 · N73963 · Destroyed NTSB DEN79DTE78Accident · No injuriesClosedMaule M4-210 · Virginia Dale, COAug 16, 1979 · N9843M · Substantial damage NTSB DEN79DTE73Accident · Minor injuriesClosedCessna 182 · Frederick, COAug 12, 1979 · N9020T · Substantial damage NTSB DEN79FTE74Accident · No injuriesClosedGrumman AA-5A · Gunnison, COAug 7, 1979 · N5455L · Substantial damage NTSB DEN79FTE70Accident · No injuriesClosedPiper PA-36 · Pueblo, COAug 7, 1979 · N3724E · Substantial damage NTSB DEN79FA053Accident · No injuriesClosedCessna TU206 · Ft Collins, COAug 4, 1979 · N4862F · Substantial damage NTSB DEN79FTE72Accident · Minor injuriesClosedBell 47G · Greeley, COAug 3, 1979 · N72487 · Substantial damage NTSB DEN79FTE69Accident · No injuriesClosedCessna 152 · Englewood, COAug 1, 1979 · N757JG · Substantial damage NTSB DEN79FTE67Accident · Minor injuriesClosedCessna 180 · Montrose, COJul 29, 1979 · N4692B · Substantial damage NTSB DEN79DTE71Accident · No injuriesClosedPiper PA-18 · Colorado Spngs, COJul 29, 1979 · N33CB · Substantial damage NTSB DEN79DTE68Accident · Serious injuriesClosedBalloon WKS Fire 7 · Firestone, COJul 29, 1979 · N40458 · Substantial damage