NTSB investigations, 1974, 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.

Cases per year

19632026
NTSB investigations, 1974, CO per year, 1963–2026: 4,941 cases
19631
1964117
1965112
1966149
1967145
1968130
1969123
1970100
1971118
197291
1973107
1974130
1975104
1976100
1977121
1978118
1979120
198098
198194
1982105
1983106
198494
198588
198671
198795
198886
198980
199078
199189
199290
199371
199463
199574
199685
199769
199866
199986
200074
200170
200273
200365
200473
200575
200654
200763
200860
200951
201047
201154
201257
201348
201449
201539
201631
201734
201833
201935
202044
202147
202234
202338
202431
202543
202645

Latest cases

Query with SQL
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\") = 1974
    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.

NTSB DEN75DTE44Accident · No injuriesClosedCessna 150 · Salida, CODec 28, 1974 · N2920V · Substantial damageNTSB DEN75FTE42Accident · Minor injuriesClosedAmer Avco AA5 · Ward, CODec 24, 1974 · CF-FGZ · DestroyedNTSB DEN75AD035Accident · 1 fatalClosedCessna 182B · Naturita, CODec 24, 1974 · N2493G · DestroyedNTSB DEN75AD030Accident · No injuriesClosedBeech 18 · Denver, CODec 12, 1974 · N172M · Substantial damageNTSB DEN75DTE38Accident · No injuriesClosedCessna 150 · Greeley, CODec 11, 1974 · N5690G · Substantial damageNTSB MKC75FCJ42Accident · Minor injuriesClosedBellanca 7GCBC · Wray, CODec 9, 1974 · N57456 · Substantial damageNTSB DEN75DTE37Accident · No injuriesClosedPiper PA-24 · Limon, CODec 9, 1974 · N7136P · Substantial damageNTSB DEN75FTE36Accident · No injuriesClosedPiper PA-28R · Longmont, CONov 29, 1974 · N2079T · Substantial damageNTSB DEN75DTE39Accident · No injuriesClosedCessna 150 · Ellicott, CONov 24, 1974 · N11420 · Substantial damageNTSB DEN75DTE35Accident · No injuriesClosedCessna 172 · Englewood, CONov 20, 1974 · N13938 · Substantial damageNTSB DEN75AD029Accident · 2 fatalClosedCessna 180 · Sedalia, CONov 15, 1974 · N1523C · 2 aircraft · DestroyedNTSB DEN75AD028Accident · 2 fatalClosedCessna 182G · Delta, CONov 10, 1974 · N3271S · DestroyedNTSB DEN75AD026Accident · 1 fatalClosedPiper PA-22 · Craig, CONov 10, 1974 · N5165Z · DestroyedNTSB DEN75AD024Accident · 2 fatalClosedCessna 182A · Springfield, CONov 2, 1974 · N3737D · DestroyedNTSB DEN75FTE33Accident · Serious injuriesClosedCessna 150F · Durango, COOct 28, 1974 · N6435F · DestroyedNTSB DEN75AD023Accident · 2 fatalClosedBeech 95-B55 · Pagosa Spgs, COOct 28, 1974 · N414K · DestroyedNTSB DEN75AD021Accident · 1 fatalClosedCessna 182 · Burlington, COOct 27, 1974 · N2894Y · Substantial damageNTSB DEN75DTE34Accident · No injuriesClosedCessna 180 · Leadville, COOct 26, 1974 · N1617C · Substantial damageNTSB DEN75DTE32Accident · No injuriesClosedCessna 150 · Greeley, COOct 26, 1974 · N5349Q · DestroyedNTSB DEN75FTE25Accident · Serious injuriesClosedCessna 210-5 · Louviers, COOct 19, 1974 · N8211Z · Substantial damageNTSB DEN75ATE28Accident · No injuriesClosedCessna 150J · Kim, COOct 18, 1974 · N5058Z · Substantial damageNTSB DEN75ATE22Accident · No injuriesClosedCessna 150 · Greeley, COOct 14, 1974 · N19040 · Substantial damageNTSB DEN75FTE27Accident · No injuriesClosedPiper PA-34 · Englewood, COOct 11, 1974 · N44211 · Substantial damageNTSB DEN75AD020Accident · 2 fatalClosedPiper PA-28 · Aurora, COOct 11, 1974 · N3994R · DestroyedNTSB DEN75FTE31Accident · 1 fatalClosedN.American T-28A · Aurora, COOct 4, 1974 · N14119 · Substantial damageNTSB DEN75AD018Accident · 1 fatalClosedBellanca 14-19 · Vail, COOct 4, 1974 · N8538R · DestroyedNTSB DEN75AD017Accident · 5 fatalClosedCessna 182J · Springfield, COOct 4, 1974 · N2869F · DestroyedNTSB DEN75FTE30Accident · Minor injuriesClosedCessna 182P · Center, COOct 1, 1974 · N7381N · Substantial damageNTSB DEN75AD016Accident · 2 fatalClosedCessna 150L · Parker, COSep 29, 1974 · N11945 · DestroyedNTSB DEN75FTE26Accident · No injuriesClosedCessna 310D · Englewood, COSep 23, 1974 · N6835T · Substantial damageNTSB DEN75DTE29Accident · No injuriesClosedCessna 177 · Colorado Spg, COSep 23, 1974 · N29596 · Substantial damageNTSB DEN75AD013Accident · 2 fatalClosedPiper PA-28 · Eldora, COSep 14, 1974 · N7062R · DestroyedNTSB DEN75AD012Accident · 1 fatalClosedCessna 140 · Virginia Dle, COSep 12, 1974 · N72537 · DestroyedNTSB DEN75AD010Accident · Minor injuriesClosedCessna 402 · Littleton, COSep 10, 1974 · N3600T · Substantial damageNTSB DEN75FTE24Accident · No injuriesClosedHughes 269B · Ft.Collins, COSep 8, 1974 · N9440F · Substantial damageNTSB DEN75FTE21Accident · No injuriesClosedBell 47G3B1 · Grand Valley, COSep 6, 1974 · N1135W · Substantial damageNTSB DEN75DTE23Accident · No injuriesClosedCessna A188B · Center, COSep 4, 1974 · N9150G · Substantial damageNTSB DEN75AD007Accident · 4 fatalClosedGates Lear 25B · Briggsdale, COAug 31, 1974 · N366AA · DestroyedNTSB DEN75DTE20Accident · No injuriesClosedStinson 108 · Montrose, COAug 29, 1974 · N9416K · Substantial damageNTSB DEN75FTE19Accident · Serious injuriesClosedChampion 7ECA · Englewood, COAug 25, 1974 · N11032 · Substantial damageNTSB DEN75FTE17Accident · No injuriesClosedCessna 172 · Colo Springs, COAug 13, 1974 · N13548 · Substantial damageNTSB DEN75DTE14Accident · Serious injuriesClosedPiper PA-18 · Kit Carson, COAug 9, 1974 · N3825Z · DestroyedNTSB DEN75AD004Accident · 1 fatalClosedBell 206B · Berthoud Fls, COAug 8, 1974 · N32TA · DestroyedNTSB DEN75FTE18Accident · No injuriesClosedAero Comdr 680E · Longmont, COAug 7, 1974 · N6888S · Substantial damageNTSB DEN75FTE15Accident · Minor injuriesClosedPiper PA-28 · Antonito, COAug 5, 1974 · N8766N · Substantial damageNTSB DEN75DTE13Accident · No injuriesClosedCessna 310H · Denver, COAug 1, 1974 · N1007Q · Substantial damageNTSB DEN75FTE10Accident · Minor injuriesClosedNaval Fcty N3N-3 · La Salle, COJul 31, 1974 · N45054 · 2 aircraft · Substantial damageNTSB DEN75DTE11Accident · Minor injuriesClosedBeech H35 · Hugo, COJul 31, 1974 · N5445D · Substantial damageNTSB DEN75FTE12Accident · No injuriesClosedPiper PA-23 · Grand Jctn, COJul 30, 1974 · N203S · Substantial damageNTSB DEN75DTE09Accident · No injuriesClosedLuscombe 8F · Del Norte, COJul 29, 1974 · N3545G · Substantial damage