NTSB investigations, 1981, CO

180,610 investigations by the National Transportation Safety Board since 1962: 174,589 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, 1981, CO per year, 1963–2026: 4,939 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
202643

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\") = 1981
    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 DEN82FA014Accident · Minor injuriesClosedCessna 340A · Pueblo, CODec 31, 1981 · N6272N · DestroyedNTSB DCA82AA007Accident · 4 fatalClosedPiper PA-31 · Durango, CODec 31, 1981 · N41070 · DestroyedNTSB DEN82FA013Accident · Serious injuriesClosedCessna T210M · Gunnison, CODec 28, 1981 · N732RN · DestroyedNTSB DEN82FA012Accident · 3 fatalClosedBeech E55 · Hayden, CODec 26, 1981 · N1766C · DestroyedNTSB DEN82FTE14Accident · 1 fatalClosedPiper PA-32 · Buena Vista, CODec 24, 1981 · N32916 · Substantial damageNTSB DEN82FTE13Accident · Minor injuriesClosedRand KR-2 · Watkins, CODec 20, 1981 · N8524P · Substantial damageNTSB DEN82FTE12Accident · No injuriesClosedGulf-Amer AA-5A · Longmont, CODec 19, 1981 · N26872 · Substantial damageNTSB DEN82FTE11Accident · Serious injuriesClosedHughes 369D · Leadville, CODec 15, 1981 · N1102A · Substantial damageNTSB DEN82FA010Accident · 1 fatalClosedMooney M-21 · La Veta, CONov 24, 1981 · N9777M · DestroyedNTSB DEN82FTE10Accident · No injuriesClosedMome II · Longmont, CONov 23, 1981 · N9993A · Substantial damageNTSB DEN82FA008Accident · 7 fatalClosedMitsubishi MU-2B · Eagle, CONov 18, 1981 · N444AR · DestroyedNTSB DEN81DTE08Accident · No injuriesClosedHiller UH12E · Craig, CONov 17, 1981 · N400AH · Substantial damageNTSB DEN82FTE09Accident · 1 fatalClosedAeronca 7KCAB · Morrison, CONov 14, 1981 · N6340N · Substantial damageNTSB DEN82FTE07Accident · No injuriesClosedAerospatial AS350B · Tarryall, CONov 2, 1981 · N350DY · Substantial damageNTSB DEN82FTE06Accident · No injuriesClosedBell 206B · Colorado Spgs, COOct 30, 1981 · N3887Z · Substantial damageNTSB DEN82FTE05Accident · No injuriesClosedPiper PA-28 · Durango, COOct 24, 1981 · N80904 · Substantial damageNTSB DEN82FTE04Accident · No injuriesClosedCessna 182P · Steamboat Spgs, COOct 18, 1981 · N1775M · Substantial damageNTSB DEN81DTE03Accident · No injuriesClosedCessna 180 · Canon City, COOct 11, 1981 · N14JM · Substantial damageNTSB DEN81FTE02Accident · No injuriesClosedBell 206L · Grand Junction, COOct 6, 1981 · N2137U · Substantial damageNTSB DEN82FTE01Accident · No injuriesClosedPiper PA-32 · Akron, COOct 3, 1981 · N3900W · Substantial damageNTSB DEN81FTE73Accident · No injuriesClosedPiper PA-24 · Parker, COSep 29, 1981 · N14DK · Substantial damageNTSB DEN81FTE72Accident · No injuriesClosedCessna 210 · Rifle, COSep 26, 1981 · N6208W · Substantial damageNTSB DEN81FA069Accident · 1 fatalClosedCessna 185 · Collbran, COSep 24, 1981 · N1343Q · DestroyedNTSB DEN81DTE74Accident · No injuriesClosedErco 415-C · Aurora, COSep 21, 1981 · N93682 · Substantial damageNTSB DEN81FTE71Accident · Serious injuriesClosedCaldwell Folker · Broomfield, COSep 17, 1981 · N10217 · DestroyedNTSB DEN81FTE70Accident · 1 fatalClosedChristen Eagle · Longmont, COSep 17, 1981 · N1CG · DestroyedNTSB DEN81FTE69Accident · Minor injuriesClosedMooney M20C · Delta, COSep 13, 1981 · N78899 · DestroyedNTSB DEN81FTE51Accident · No injuriesClosedHiller UHI2D · Craig, COSep 8, 1981 · N96107 · DestroyedNTSB DEN81FA063Accident · 3 fatalClosedCessna TR182 · 17nne Durango, COAug 31, 1981 · N736KV · DestroyedNTSB DEN81FTE68Accident · Serious injuriesClosedBell 206B · Rio Blanco, COAug 25, 1981 · N39082 · Substantial damageNTSB DEN81FTE67Accident · Minor injuriesClosedCessna 172RG · Walden, COAug 20, 1981 · N6324R · Substantial damageNTSB DEN81FTE63Accident · Minor injuriesClosedLuscombe 8A · Byers, COAug 13, 1981 · N77810 · Substantial damageNTSB DEN81FTE66Accident · Serious injuriesClosedAeronca 7ECA · Akron, COAug 7, 1981 · N1665G · Substantial damageNTSB DEN81DTE65Accident · Serious injuriesClosedRaven RX-6 · Golden, COAug 5, 1981 · N5557B · No damageNTSB DEN81FTE64Accident · Minor injuriesClosedBeech C24R · Broomfield, COAug 1, 1981 · N60129 · Substantial damageNTSB DEN81FA053Accident · 2 fatalClosedLet Blanik · Aspen, COJul 26, 1981 · N38928 · DestroyedNTSB DEN81IA052Incident · No injuriesClosedRockwell 690B · Denver, COJul 23, 1981 · N690SE · Minor damageNTSB DEN81DTE62Accident · No injuriesClosedWeatherly 201B · Beulah, COJul 23, 1981 · N1266W · Substantial damageNTSB DEN81DTE60Accident · No injuriesClosedCessna 172N · Durango, COJul 21, 1981 · N75564 · Substantial damageNTSB DEN81FTE61Accident · No injuriesClosedRand KR-2 · Rocky Ford, COJul 20, 1981 · N8068Y · Substantial damageNTSB DEN81FA050Accident · 2 fatalClosedPiper 602P · Mead, COJul 17, 1981 · N68904 · DestroyedNTSB DEN81FTE58Accident · No injuriesClosedBeech 23 · Eaton, COJul 13, 1981 · N1963F · Substantial damageNTSB DEN81FTE59Accident · No injuriesClosedCessna 177B · New Raymer, COJul 12, 1981 · N30781 · Substantial damageNTSB DEN81FA049Accident · 4 fatalClosedGulf-Amer AA-5B · Crested Butte, COJul 12, 1981 · N4539Q · DestroyedNTSB DEN81FA048Accident · 1 fatalClosedRyan Aero ST-A · Eaton, COJul 10, 1981 · N27JG · DestroyedNTSB DEN81FTE56Accident · Minor injuriesClosedPiper 601P · Crested Butte, COJul 9, 1981 · N36342 · Substantial damageNTSB DEN81FTE55Accident · Minor injuriesClosedPiper PA-28R · Westcliffe, COJul 7, 1981 · N31568 · Substantial damageNTSB DEN81FTE54Accident · No injuriesClosedPiper PA-31 · Walsenburg, COJul 5, 1981 · N27561 · Substantial damageNTSB DEN81FTE53Accident · No injuriesClosedCessna T210N · Colorado Spgs, COJul 3, 1981 · N4658Y · Substantial damageNTSB DEN81FTE52Accident · No injuriesClosedCessna 150G · Hudson, COJul 1, 1981 · N2934J · Substantial damage