NTSB investigations, 1965, CO

180,641 investigations by the National Transportation Safety Board since 1962: 174,620 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, 1965, CO per year, 1963–2026: 4,940 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
202644

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\") = 1965
    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 DEN66D0212Accident · No injuriesClosedCessna 150 · Littleton, CODec 20, 1965 · N8435G · Substantial damageNTSB DEN66A0048Accident · 3 fatalClosedLockheed L-1049 · Alamosa, CODec 15, 1965 · N6914C · DestroyedNTSB DEN66A0045Accident · 3 fatalClosedBeech B95 · Aspen, CODec 12, 1965 · N9975R · DestroyedNTSB DEN66A0046Accident · 1 fatalClosedCessna 172 · Kremmling, CODec 11, 1965 · N1469Y · DestroyedNTSB DEN66F0173Accident · No injuriesClosedBeechcraft D35 · Broomfield, CODec 9, 1965 · N3447B · Substantial damageNTSB DEN66D0190Accident · No injuriesClosedPiper PA-28 · Fountain, CODec 8, 1965 · N8253W · Substantial damageNTSB DEN66D0182Accident · No injuriesClosedPiper PA-28 · Avondale, CODec 4, 1965 · N6626W · Substantial damageNTSB DEN66D0189Accident · No injuriesClosedCessna 170 · Montrose, CONov 30, 1965 · N3517C · Substantial damageNTSB DEN66F0188Accident · No injuriesClosedMooney M20C · Denver, CONov 28, 1965 · N1219X · Substantial damageNTSB DEN66F0162Accident · Minor injuriesClosedLuscombe T-8F · Greely, CONov 23, 1965 · N2176B · Substantial damageNTSB DEN66F0156Accident · No injuriesClosedCessna 172 · Usaf Academy, CONov 14, 1965 · N346TC · Substantial damageNTSB DEN66F0155Accident · No injuriesClosedLuscombe 8A · Rocky Ford, CONov 14, 1965 · N71481 · DestroyedNTSB DEN66F0148Accident · No injuriesClosedPiper PA-22 · Broomfield, CONov 11, 1965 · N4626Z · Substantial damageNTSB DEN66D0146Accident · No injuriesClosedCessna 180 · Fort Collins, CONov 9, 1965 · N3253D · Substantial damageNTSB DEN66F0183Accident · No injuriesClosedCessna 150 · Pueblo, CONov 8, 1965 · N8618S · Substantial damageNTSB DEN66A0031Accident · Minor injuriesClosedBell 204B · Georgetown, CONov 5, 1965 · N73273 · Substantial damageNTSB DEN66D0143Accident · No injuriesClosedMooney M20E · Aspen, COOct 24, 1965 · N55760 · Substantial damageNTSB DEN66F0149Accident · No injuriesClosedPiper PA-22 · Fountain, COOct 23, 1965 · N8541D · Substantial damageNTSB DEN66F0132Accident · Minor injuriesClosedAero Cmdr 680 · Meeker, COOct 18, 1965 · N6228D · DestroyedNTSB DEN66A0030Accident · 4 fatalClosedCessna 182 · Sapinero, COOct 18, 1965 · N3836D · DestroyedNTSB DEN66A0028Accident · Serious injuriesClosedBoeing 707 320C · Glenwood Spgs, COOct 17, 1965 · N17321 · No damageNTSB FTW66D0417Accident · No injuriesClosedPiper PA-22 · Sand Springs, COOct 11, 1965 · N6912D · Substantial damageNTSB DEN66F0164Accident · Serious injuriesClosedPiper PA18 · Grd Junction, COOct 10, 1965 · N7260D · DestroyedNTSB DEN66D0202Accident · No injuriesClosedCessna 210 · Denver, COOct 10, 1965 · N1814F · Substantial damageNTSB DEN66D0119Accident · No injuriesClosedCessna 120 · Castle Rock, COOct 9, 1965 · N90185 · Substantial damageNTSB DEN66F0118Accident · No injuriesClosedMooney M20C · Boulder, COOct 1, 1965 · N6722U · Substantial damageNTSB DEN66F0117Accident · Serious injuriesClosedMonocoupe 110SPL · Grd Junction, COSep 26, 1965 · M15E · Substantial damageNTSB DEN66A0022Accident · No injuriesClosedBrantly B2B · Denver, COSep 25, 1965 · N2160U · Substantial damageNTSB DEN66F0100Accident · No injuriesClosedPiper PA-20 · Akron, COSep 14, 1965 · N6969K · Substantial damageNTSB DEN66A0021Accident · Minor injuriesClosedBell 47G3 · South Fork, COSep 14, 1965 · N73913 · Substantial damageNTSB UNK65X1533Accident · 1 fatalClosedCallair A-9 · La Veta, COSep 11, 1965 · XB-ZIB · DestroyedNTSB DEN66A0020Accident · No injuriesClosedBell 47G3B1 · Commerce Cty, COSep 9, 1965 · N1135W · Substantial damageNTSB DEN66F0133Accident · No injuriesClosedCessna 310 · Pueblo, COSep 6, 1965 · N191R · Substantial damageNTSB DEN66D0107Accident · No injuriesClosedBellanca 14-13 · Security, COSep 5, 1965 · N74286 · Substantial damageNTSB DEN66D0089Accident · No injuriesClosedBeechcraft 35-B33 · Watkins, COSep 1, 1965 · N8520M · Substantial damageNTSB DEN66A0018Accident · Serious injuriesClosedBell 47G3B · Durango, COSep 1, 1965 · N73249 · Substantial damageNTSB DEN66F0094Accident · No injuriesClosedCessna 140 · Aurora, COAug 29, 1965 · N77045 · Substantial damageNTSB DEN66D0114Accident · No injuriesClosedBeechcraft 25 · Greely, COAug 28, 1965 · N8718M · Substantial damageNTSB DEN66F0113Accident · Minor injuriesClosedLuscombe 8A · Greely, COAug 25, 1965 · N45709 · Substantial damageNTSB DEN66A0017Accident · No injuriesClosedBell 47G3B1 · Salida, COAug 25, 1965 · N1180W · Substantial damageNTSB DEN66D0142Accident · No injuriesClosedLuscombe 8E · Glenwood Sps, COAug 24, 1965 · N1200K · Substantial damageNTSB DEN66D0090Accident · No injuriesClosedPiper PA-30 · Delta, COAug 23, 1965 · N7049Y · Substantial damageNTSB DEN66D0099Accident · No injuriesClosedN American P-51D · Grand Junctn, COAug 21, 1965 · N6322T · Substantial damageNTSB DEN66D0083Accident · No injuriesClosedCessna 180 · Alamosa, COAug 15, 1965 · N7766A · Substantial damageNTSB DEN66D0076Accident · No injuriesClosedBeechcraft C-35 · Denver, COAug 15, 1965 · N728D · Substantial damageNTSB DEN66D0073Accident · No injuriesClosedBeechcraft 35 · Denver, COAug 15, 1965 · N3815N · Substantial damageNTSB DEN66D0084Accident · No injuriesClosedLuscombe 8E · Greeley, COAug 14, 1965 · N1984K · Substantial damageNTSB DEN66D0081Accident · No injuriesClosedTaylorcraft BC-12D · Orchard, COAug 8, 1965 · N43244 · Substantial damageNTSB DEN66D0079Accident · Minor injuriesClosedMooney M20C · Pueblo, COAug 8, 1965 · N6259U · Substantial damageNTSB DEN66D0061Accident · No injuriesClosedPiper PA-24 · Taylor, COAug 8, 1965 · N6218P · Substantial damage