NTSB investigations, 1965, UT

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, 1965, UT per year, 1963–2026: 2,267 cases
19631
196454
196554
196665
196752
196844
196945
197039
197127
197239
197344
197433
197538
197657
197742
197842
197941
198052
198158
198241
198345
198453
198541
198632
198737
198828
198940
199032
199131
199226
199336
199431
199524
199627
199736
199835
199929
200049
200133
200239
200340
200434
200525
200632
200744
200842
200937
201035
201131
201226
201320
201425
201525
201618
201727
201826
201929
202021
202123
202228
202335
202427
202522
202623

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\" = 'UT' 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 DEN66F0195Accident · No injuriesClosedCessna 310A · Salt Lake City, UTDec 29, 1965 · N5261A · Substantial damageNTSB DEN66A0052Accident · 3 fatalClosedBeech C35 · Coalville, UTDec 29, 1965 · N5945C · DestroyedNTSB DEN66A0038Accident · 13 fatalClosedDouglas DC-3A · Salt Lake City, UTNov 27, 1965 · N485 · DestroyedNTSB DEN66A0040Accident · 1 fatalClosedBeech T-34A · Kamas, UTNov 22, 1965 · N7826B · DestroyedNTSB DEN66F0172Accident · No injuriesClosedStinson 108 · Sandy, UTNov 20, 1965 · N9168K · Substantial damageNTSB DEN66A0036Accident · 5 fatalClosedBeech B95A · Beaver, UTNov 14, 1965 · N461T · DestroyedNTSB DEN66A0033Accident · 1 fatalClosedPiper PA-28 · New Harmony, UTNov 14, 1965 · N7044W · DestroyedNTSB DEN66F0165Accident · No injuriesClosedBeechcraft E35 · Woods Cross, UTNov 13, 1965 · N7335B · Substantial damageNTSB DCA66A0004Accident · 43 fatalClosedBoeing B-727 · Salt Lke Cty, UTNov 11, 1965 · N7030U · DestroyedNTSB DEN66F0154Accident · No injuriesClosedPiper PA-23 · Duchesne, UTNov 7, 1965 · N1331P · Substantial damageNTSB DEN66D0147Accident · No injuriesClosedBeechcraft 95-55 · Logan, UTOct 24, 1965 · N569T · Substantial damageNTSB DEN66A0029Accident · 1 fatalClosedBeechcraft B35 · Blanding, UTOct 19, 1965 · N5238C · DestroyedNTSB DEN66D0122Accident · No injuriesClosedPiper J-3 · Woodruff, UTOct 9, 1965 · N42420 · Substantial damageNTSB DEN66A0025Accident · Minor injuriesClosedBell 47G3B1 · Salt Lake City, UTOct 5, 1965 · N8537F · DestroyedNTSB DEN66D0166Accident · No injuriesClosedCessna 210A · Mexican Hat, UTSep 29, 1965 · N6692K · Substantial damageNTSB DEN66A0023Accident · 1 fatalClosedBell 47G3B1 · Monticello, UTSep 28, 1965 · N1127W · DestroyedNTSB DEN66D0110Accident · No injuriesClosedCessna 320 · Logan, UTSep 22, 1965 · N5722X · Substantial damageNTSB DEN66D0109Accident · No injuriesClosedBeechcraft K-35 · Veyo, UTSep 16, 1965 · N524T · Substantial damageNTSB DEN66A0016Accident · Minor injuriesClosedBell 47G3B1 · Bountiful, UTAug 24, 1965 · N1169W · Substantial damageNTSB DEN66F0064Accident · No injuriesClosedPiper PA-28 · Snowville, UTAug 9, 1965 · N5459W · Substantial damageNTSB DEN66F0048Accident · No injuriesClosedCessna 175 · Salt Lake City, UTAug 5, 1965 · N6770E · Substantial damageNTSB DEN66F0059Accident · No injuriesClosedCessna 172 · Salt Lake City, UTAug 3, 1965 · N7079T · Substantial damageNTSB DEN66F0058Accident · No injuriesClosedPiper PA-28 · Salt Lake City, UTAug 3, 1965 · N6043W · Substantial damageNTSB DEN66F0032Accident · No injuriesClosedPiper PA-22 · Eden, UTJul 17, 1965 · N5497Z · Substantial damageNTSB DEN66D0042Accident · No injuriesClosedPiper PA-24 · Panguitch, UTJul 16, 1965 · N6421P · Substantial damageNTSB DEN66F0052Accident · No injuriesClosedBeechcraft G35 · Salt Lake City, UTJul 13, 1965 · N4603D · Substantial damageNTSB DEN66F0033Accident · No injuriesClosedCessna 175 · Goldhill, UTJul 9, 1965 · N8180T · DestroyedNTSB DEN66D0016Accident · No injuriesClosedMooney M20A · Vernal, UTJun 26, 1965 · N6581B · Substantial damageNTSB DEN66F0001Accident · No injuriesClosedLuscombe 8F · Green River, UTJun 14, 1965 · N3535G · Substantial damageNTSB DEN65A0079Accident · 3 fatalClosedBellanca 14-133 · Panguitch, UTJun 13, 1965 · N6525N · DestroyedNTSB DEN66F0015Accident · No injuriesClosedGrasshopper D-8 · Heber, UTJun 12, 1965 · N5053K · DestroyedNTSB DEN65A0080Accident · 3 fatalClosedPiper PA-28 · Salina, UTJun 11, 1965 · N5244W · DestroyedNTSB DEN65F0103Accident · Minor injuriesClosedPiper PA-22 · Logan, UTMay 27, 1965 · N3449A · Substantial damageNTSB DEN65D0106Accident · No injuriesClosedPiper PA-22 · Woodruff, UTMay 26, 1965 · N8741D · Substantial damageNTSB DEN65F0105Accident · No injuriesClosedBeechcraft B-35 · Salt Lake City, UTMay 22, 1965 · N5126C · Substantial damageNTSB DEN65D0104Accident · No injuriesClosedCessna 172 · Cedar City, UTMay 22, 1965 · N3778S · Substantial damageNTSB DEN65D0073Accident · No injuriesClosedCessna 140 · Aneth, UTMay 3, 1965 · N76906 · Substantial damageNTSB DEN65D0072Accident · No injuriesClosedCessna 170 · La Sal, UTMay 2, 1965 · N2936D · Substantial damageNTSB DEN65F0057Accident · Minor injuriesClosedPiper PA-22 · Beryl Junction, UTApr 24, 1965 · N994A · DestroyedNTSB DEN65F0047Accident · Minor injuriesClosedCessna 182 · St George, UTApr 16, 1965 · N5490B · Substantial damageNTSB DEN65D0052Accident · Serious injuriesClosedCessna 210 · Orem, UTApr 4, 1965 · N6649X · DestroyedNTSB DEN65A0062Accident · 1 fatalClosedPiper PA-28 · Salt Lake City, UTMar 31, 1965 · N5748W · Substantial damageNTSB DEN65F0033Accident · No injuriesClosedCougar 1 · Manti, UTMar 24, 1965 · N92870 · Substantial damageNTSB DEN65A0060Accident · 4 fatalClosedCessna 170 · Ephraim, UTMar 20, 1965 · N3974V · DestroyedNTSB DEN65F0024Accident · Minor injuriesClosedCessna 170A · Huntington, UTMar 14, 1965 · N9086A · Substantial damageNTSB DEN65D0031Accident · No injuriesClosedCessna 180 · Vernal, UTMar 11, 1965 · N2661Y · Substantial damageNTSB DEN65F0028Accident · No injuriesClosedForney F-1A · Spanish Fork, UTFeb 24, 1965 · N3051G · DestroyedNTSB DEN65F0016Accident · No injuriesClosedLuscombe 8A · Bryce Canyon, UTFeb 22, 1965 · N20687 · Substantial damageNTSB DEN65F0023Accident · No injuriesClosedErcoupe 415C · Colton, UTFeb 11, 1965 · N2798H · Substantial damageNTSB DEN65A0053Accident · No injuriesClosedHughes 269B · Provo, UTFeb 4, 1965 · N9345F · Substantial damage