Skip to content

NTSB investigations, 1973, 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, 1973, 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") = 1973 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\") = 1973
    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") = 1973
  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 DEN74FTE35Accident · No injuriesClosedCessna 172G · Broomfield, CODec 29, 1973 · N7128G · Substantial damage NTSB DEN74FTE34Accident · Minor injuriesClosedCessna 421B · Aspen, CODec 29, 1973 · N421AT · Substantial damage NTSB DEN74AD052Accident · 1 fatalClosedCessna 150J · Sargents, CODec 25, 1973 · N5543G · Destroyed NTSB DEN74FTE32Accident · Serious injuriesClosedCessna 172D · Walsenburg, CODec 24, 1973 · N2324U · Destroyed NTSB DEN74DTE50Accident · No injuriesClosedCessna 182 · Ft.Lupton, CODec 21, 1973 · N21053 · Substantial damage NTSB DEN74DTE38Accident · No injuriesClosedAeronca L-3 · Stratton, CODec 14, 1973 · N49112 · Destroyed NTSB DEN74DTE33Accident · No injuriesClosedPiper PA-22 · Byers, CODec 10, 1973 · N8585C · Substantial damage NTSB DEN74AD027Accident · 1 fatalClosedCessna 182C · Walden, CONov 29, 1973 · N175X · Destroyed NTSB DEN74AD025Accident · No injuriesClosedCessna 310C · Montrose, CONov 21, 1973 · N1819H · Destroyed NTSB DEN74FTE31Accident · Minor injuriesClosedBeech M35 · Denver, CONov 19, 1973 · N9310Y · Substantial damage NTSB DEN74AD023Accident · 2 fatalClosedCessna 120 · Wiggins, CONov 17, 1973 · N3754V · Destroyed NTSB DEN74FTE30Accident · Minor injuriesClosedHughes 269B · Broomfield, CONov 14, 1973 · N9440F · Substantial damage NTSB DEN74DTE29Accident · No injuriesClosedStinson 108-3 · Kiowa, CONov 11, 1973 · N6656M · Substantial damage NTSB DEN74DTE28Accident · No injuriesClosedPiper PA-23 · Greeley, CONov 6, 1973 · N1034P · Substantial damage NTSB DEN74FTE27Accident · No injuriesClosedCessna 182A · Breckenridge, COOct 26, 1973 · N4731D · Substantial damage NTSB DEN74FTE26Accident · No injuriesClosedBeech C23 · Colo.Springs, COOct 19, 1973 · N9759L · Substantial damage NTSB DEN74AD015Accident · 1 fatalClosedPiper PA-28 · Holyoke, COOct 9, 1973 · N7088R · Destroyed NTSB DEN74FTE25Accident · Serious injuriesClosedPiper PA-32 · Aspen, COOct 7, 1973 · N3234W · Substantial damage NTSB DEN74FTE24Accident · Minor injuriesClosedStolp Starlt · Aurora, COOct 7, 1973 · N125PC · Substantial damage NTSB DEN74FTE23Accident · No injuriesClosedPiper PA-32 · Eagle, COOct 6, 1973 · N4181R · Substantial damage NTSB DEN74AD013Accident · 1 fatalClosedCessna 140 · Divide, COOct 2, 1973 · N89304 · Substantial damage NTSB DEN74FTE20Accident · Serious injuriesClosedCessna 150F · Denver, COSep 15, 1973 · N8114F · Substantial damage NTSB DEN74FTE21Accident · No injuriesClosedBell 47G3B1 · Pitkin, COSep 13, 1973 · N73978 · Substantial damage NTSB DEN74FTE19Accident · Minor injuriesClosedRyan ST-3KR · Nucla, COSep 11, 1973 · N78J · Substantial damage NTSB DEN74FTE18Accident · No injuriesClosedHughes 269A · Ft Collins, COSep 9, 1973 · N8859F · Substantial damage NTSB DEN74FTE22Accident · No injuriesClosedCessna 150G · Castle Rock, COSep 3, 1973 · N8651J · Substantial damage NTSB DEN74FTE16Accident · No injuriesClosedBoeing A75N1 · Sheridan Lke, COAug 25, 1973 · N55971 · Substantial damage NTSB DEN74FTE15Accident · Minor injuriesClosedCessna T210 · Windsor, COAug 18, 1973 · N30034 · Substantial damage NTSB DEN74AD008Accident · 1 fatalClosedCessna A150K · Louviers, COAug 17, 1973 · N8375M · Destroyed NTSB DEN74DTE13Accident · No injuriesClosedMooney M20F · Meeker, COAug 11, 1973 · N3989N · Substantial damage NTSB DEN74FTE14Accident · Minor injuriesClosedMooney M20E · Aspen, COAug 10, 1973 · N6053Q · Substantial damage NTSB DEN74FTE12Accident · Minor injuriesClosedCessna 150 · Eldorado Spg, COAug 9, 1973 · N60027 · Destroyed NTSB DEN74FTE17Accident · 1 fatalClosedPiper PA-18 · Pritchett, COAug 8, 1973 · N8438Y · Destroyed NTSB DEN74DTE10Accident · Minor injuriesClosedCessna 182H · Fraser, COAug 4, 1973 · N8322S · Substantial damage NTSB DEN74FTE09Accident · No injuriesClosedPiper PA-28 · Broomfield, COAug 1, 1973 · N16468 · Substantial damage NTSB DEN74FTE08Accident · Minor injuriesClosedBeech C-23 · Rifle, COJul 27, 1973 · N9750L · Destroyed NTSB DEN74FTE08Accident · Serious injuriesClosedMiniplane Dsai · Mack, COJul 23, 1973 · N15JH · Destroyed NTSB DEN74DTE06Accident · No injuriesClosedStinson L-5 · Fort Collins, COJul 22, 1973 · N10453 · Substantial damage NTSB DEN74AD002Accident · 2 fatalClosedPiper PA-30B · Aurora, COJul 20, 1973 · N7973Y · Destroyed NTSB DEN74FTE04Accident · No injuriesClosedHughes 269A1 · Ft.Collins, COJul 6, 1973 · N8803F · Substantial damage NTSB DEN74FTE03Accident · No injuriesClosedPiper PA-24 · Littleton, COJul 6, 1973 · N7744P · Substantial damage NTSB DEN74FTE02Accident · No injuriesClosedBell 47G-5A · Aurora, COJul 5, 1973 · N2991W · Substantial damage NTSB DEN74FTE01Accident · Minor injuriesClosedCessna 172D · Colorado Spg, COJul 1, 1973 · N2630U · Destroyed NTSB DEN74AD001Accident · 2 fatalClosedAmer Avco AA1-B · Boulder, COJul 1, 1973 · N9648L · Destroyed NTSB DEN73FTE96Accident · Serious injuriesClosedCessna 170A · Wray, COJun 30, 1973 · N5721C · Substantial damage NTSB DEN73DTE93Accident · No injuriesClosedS-Tailwind W-L-8 · Falcon, COJun 26, 1973 · N11701 · Substantial damage NTSB DEN73FTE90Accident · Serious injuriesClosedSchweizer SGS126 · Colo Springs, COJun 24, 1973 · N1144S · Destroyed NTSB DEN73FTE89Accident · Minor injuriesClosedCessna 150 · Holly, COJun 24, 1973 · N2983J · Substantial damage NTSB DEN73FTE95Accident · No injuriesClosedCessna 150 · Broomfield, COJun 23, 1973 · N8696G · Destroyed NTSB DEN73FTE94Accident · No injuriesClosedCessna 310C · Pueblo, COJun 23, 1973 · N9069R · Substantial damage