Skip to content

NTSB investigations, 1970, 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, 1970, 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") = 1970 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\") = 1970
    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") = 1970
  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 DEN71DXD43Accident · No injuriesClosedAmer Avco AA-1 · Longmont, CODec 29, 1970 · N5981L · Substantial damage NTSB DEN71DXD42Accident · No injuriesClosedCessna 172 · Broomfield, CODec 24, 1970 · N2407U · Substantial damage NTSB DEN71DXD41Accident · No injuriesClosedCessna 150 · Wray, CODec 20, 1970 · N7231X · Substantial damage NTSB DEN71FXD40Accident · No injuriesClosedMooney M20F · Aurora, CODec 5, 1970 · N9698M · Substantial damage NTSB DEN71FXD39Accident · No injuriesClosedCessna 172I · Broomfield, CONov 30, 1970 · N8483L · Substantial damage NTSB DEN71AD025Accident · 2 fatalClosedPiper PA-18 · Montrose, CONov 29, 1970 · N1874P · Destroyed NTSB DEN71FXD38Accident · No injuriesClosedPiper PA-24 · Aurora, CONov 22, 1970 · N7864P · Substantial damage NTSB DEN71AD024Accident · 2 fatalClosedPiper PA-18 · Grand Junct, CONov 21, 1970 · N1094A · Destroyed NTSB DEN71AD023Accident · Serious injuriesClosedBoeing 727 · Denver, CONov 20, 1970 · N88714 · No damage NTSB DEN71FXD34Accident · Minor injuriesClosedAmer Avco AA-1 · Aurora, CONov 11, 1970 · N5610L · Substantial damage NTSB DEN71DXD37Accident · No injuriesClosedCessna P206A · Cortez, CONov 9, 1970 · N4609F · Substantial damage NTSB DEN71FXD36Accident · Minor injuriesClosedAmer Avco AA-1 · Longmont, CONov 6, 1970 · N5607L · Substantial damage NTSB DEN71DXD35Accident · No injuriesClosedPiper PA-28 · Littleton, CONov 2, 1970 · N8061N · Substantial damage NTSB DEN71DXD34Accident · No injuriesClosedStinson 108-3 · Campo, COOct 31, 1970 · N6278M · Substantial damage NTSB DEN71AD019Accident · 2 fatalClosedMooney M20A · Roggen, COOct 25, 1970 · N8316E · Destroyed NTSB DEN71FXD33Accident · Minor injuriesClosedAeronca 0-58B · Loveland, COOct 24, 1970 · N46653 · Substantial damage NTSB DEN71AD021Accident · Minor injuriesClosedBeech D18S · Aurora, COOct 24, 1970 · N342D · Substantial damage NTSB DEN71DXD31Accident · No injuriesClosedBell 47G3B2 · Ft.Collins, COOct 19, 1970 · N2747R · Destroyed NTSB DEN71FXD32Accident · Serious injuriesClosedCessna 150F · Watkins, COOct 17, 1970 · N8056F · Substantial damage NTSB DEN71AD017Accident · 2 fatalClosedBeech V35B · Aspen, COOct 17, 1970 · N3958A · Destroyed NTSB DEN71FXD29Accident · Serious injuriesClosedPiper PA-28 · Almont, COOct 16, 1970 · N9415W · Destroyed NTSB DEN71DXD30Accident · No injuriesClosedCessna 310 · Stmboat Spgs, COOct 16, 1970 · N3187L · Substantial damage NTSB DCA71AZ004Accident · 30 fatalClosedMartin 404 · Silver Plume, COOct 2, 1970 · N464M · Destroyed NTSB DEN71FXD27Accident · Serious injuriesClosedPiper PA-25 · Fruita, COSep 24, 1970 · N6392Z · Destroyed NTSB DEN71DXD28Accident · Minor injuriesClosedBeech 23 · Twin Lakes, COSep 21, 1970 · N7636R · Substantial damage NTSB DEN71AD013Accident · Serious injuriesClosedDouglas DC-8 · Denver, COSep 21, 1970 · N8022U · Minor damage NTSB DEN71DXD26Accident · Serious injuriesClosedBeech 35-A33 · Salida, COSep 20, 1970 · N309Z · Substantial damage NTSB DEN71AD012Accident · 2 fatalClosedPiper PA-30 · Boulder, COSep 18, 1970 · N8414Y · Destroyed NTSB DEN71DXD24Accident · No injuriesClosedPiper PA-28 · Colo Springs, COAug 23, 1970 · N8354W · Substantial damage NTSB DEN71DXD23Accident · No injuriesClosedPiper PA-28 · Fort Collins, COAug 20, 1970 · N8295N · Substantial damage NTSB DEN71DXD21Accident · No injuriesClosedChampion 7ECA · Aurora, COAug 16, 1970 · N9561S · Substantial damage NTSB DEN71DXD20Accident · No injuriesClosedPiper PA-25 · Walsh, COAug 15, 1970 · N8737L · Substantial damage NTSB DEN71DXD19Accident · Minor injuriesClosedVolksplane WE-1 · Aurora, COAug 8, 1970 · N77PC · Substantial damage NTSB DEN71AD004Accident · No injuriesClosedCessna 177 · Montrose, COAug 3, 1970 · N2901X · Substantial damage NTSB DEN71FXD16Accident · No injuriesClosedCessna 150H · Fort Collins, COAug 1, 1970 · N23381 · Substantial damage NTSB DEN71FXD22Accident · Serious injuriesClosedCessna 172 · Denver, COJul 31, 1970 · N8585B · Substantial damage NTSB DEN71FXD15Accident · No injuriesClosedPiper PA-28 · Ft.Collins, COJul 29, 1970 · N7921N · Substantial damage NTSB DEN71FXD10Accident · Minor injuriesClosedPiper PA-23 · Greeley, COJul 26, 1970 · N1061P · Substantial damage NTSB DEN71DXD11Accident · No injuriesClosedCessna 150J · Limon, COJul 26, 1970 · N51406 · Substantial damage NTSB DEN71AD002Accident · 3 fatalClosedCessna 182J · Ouray, COJul 26, 1970 · N2713F · Destroyed NTSB DEN71FXD12Accident · 1 fatalClosedPiper PA-28R · Montrose, COJul 25, 1970 · N7569J · Destroyed NTSB DEN71DXD09Accident · No injuriesClosedCessna 150 · Sterling, COJul 24, 1970 · N579MA · Substantial damage NTSB DEN71DXD07Accident · Minor injuriesClosedCessna 172F · Fort Carson, COJul 18, 1970 · N7968U · Substantial damage NTSB DEN71DXD06Accident · No injuriesClosedCessna 177 · Eagle, COJul 13, 1970 · N29581 · Substantial damage NTSB DEN71DXD05Accident · No injuriesClosedCessna 172 · Grand Junctn, COJul 13, 1970 · N8644T · Substantial damage NTSB DEN71DXD13Accident · Minor injuriesClosedPiper PA-28 · Littleton, COJul 6, 1970 · N8043N · Substantial damage NTSB DEN71DXD04Accident · No injuriesClosedCessna 150 · Englewood, COJul 6, 1970 · N60891 · Substantial damage NTSB DEN71DXD18Accident · No injuriesClosedPiper PA-28 · Alamosa, COJul 4, 1970 · N7678J · Substantial damage NTSB DEN71DXD08Accident · No injuriesClosedPiper PA-28 · Pagosa Spgs, COJul 4, 1970 · N3492R · Substantial damage NTSB DEN71DXD02Accident · No injuriesClosedSchweizer SGS126 · Walsenburg, COJul 3, 1970 · N2422W · Substantial damage