NTSB investigations, 1976, 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, 1976, 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\") = 1976
    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 DEN77FTM08Accident · Minor injuriesClosedCessna 210 · Brigham City, UTNov 12, 1976 · N1840F · Substantial damageNTSB DEN77FA008Accident · 2 fatalClosedPiper PA-24 · Grantsville, UTNov 6, 1976 · N6180P · DestroyedNTSB DEN77FTM07Accident · 1 fatalClosedCessna P206B · Nephi, UTOct 19, 1976 · N4764F · DestroyedNTSB DEN77FTM06Accident · Minor injuriesClosedBell 47G · Beaver, UTOct 15, 1976 · N178B · DestroyedNTSB DEN76FTM05Accident · Minor injuriesClosedCessna T210L · Bullfrog Basin, UTOct 13, 1976 · N210V · DestroyedNTSB DEN77FTM04Accident · No injuriesClosedCessna 150J · Kamas, UTOct 9, 1976 · N60605 · DestroyedNTSB LAX77IA003Incident · Serious injuriesClosedBoeing 737 · Salt Lake City, UTOct 5, 1976 · N4523W · No damageNTSB DEN77DTM01Accident · No injuriesClosedCessna 172H · Parowan, UTOct 4, 1976 · N521SA · Substantial damageNTSB DEN77FTM03Accident · No injuriesClosedCessna 150 · Salt Lake City, UTSep 30, 1976 · N45230 · Substantial damageNTSB DEN76AD073Accident · 2 fatalClosedBell 47G3B2 · Mantua, UTSep 25, 1976 · N2205W · DestroyedNTSB DEN76FTM49Accident · No injuriesClosedNa Rockwell 112TC · Vernal, UTSep 22, 1976 · N4564W · Substantial damageNTSB DEN76DTM48Accident · No injuriesClosedBeech 95-E55 · Tremonton, UTSep 4, 1976 · N25612 · Substantial damageNTSB DEN76AD070Accident · 3 fatalClosedCessna 185 · Sunnyside, UTAug 25, 1976 · N9924X · DestroyedNTSB DEN76FTM47Accident · No injuriesClosedGrumman G-164A · Leland, UTAug 23, 1976 · N6589 · Substantial damageNTSB DEN76DTM46Accident · Minor injuriesClosedPiper PA-22 · Bullfrog Basin, UTAug 22, 1976 · N5927D · Substantial damageNTSB DEN76ATM45Accident · Serious injuriesClosedAmer Avco AA-1B · Escalante, UTAug 20, 1976 · N9947L · DestroyedNTSB DEN76AD066Accident · Minor injuriesClosedCessna TU206 · Ouray, UTAug 15, 1976 · N4831F · Substantial damageNTSB DEN76FTM43Accident · No injuriesClosedCessna 172M · Cedar City, UTAug 7, 1976 · N5285H · Substantial damageNTSB DEN76DTM44Accident · No injuriesClosedBensen B-8M · Lehi, UTAug 7, 1976 · N4194 · Substantial damageNTSB DEN76AD061Accident · 1 fatalClosedPiper PA-30 · Kings Peak, UTAug 1, 1976 · N7591Y · DestroyedNTSB DEN76FTM42Accident · No injuriesClosedCessna 182 · Salt Lake City, UTJul 31, 1976 · N5415B · Substantial damageNTSB DEN77FTM41Accident · Minor injuriesClosedCessna 206P · Lasal Junction, UTJul 27, 1976 · N2541X · Substantial damageNTSB DEN76FTM39Accident · Minor injuriesClosedBell 206B · Coalville, UTJul 14, 1976 · N49570 · Substantial damageNTSB DEN76DTM40Accident · No injuriesClosedCessna 150H · Howell, UTJul 13, 1976 · N22590 · Substantial damageNTSB DEN76AD055Accident · 1 fatalClosedSchweizer SGU222 · Heber City, UTJul 8, 1976 · N2769R · DestroyedNTSB DEN76AD056Accident · 4 fatalClosedStinson 108-2 · Kamas, UTJun 29, 1976 · N8015K · DestroyedNTSB DEN76FTM38Accident · Minor injuriesClosedCessna 172 · Cedar City, UTJun 26, 1976 · N7264G · Substantial damageNTSB DEN76DTM37Accident · No injuriesClosedPiper PA-28 · Hatch, UTJun 23, 1976 · N5818U · Substantial damageNTSB DEN76DTM36Accident · No injuriesClosedCessna 172F · Provo, UTJun 5, 1976 · N8770U · Substantial damageNTSB DEN76FTM31Accident · Serious injuriesClosedGrumman G-164 · Morgan, UTJun 2, 1976 · N491Y · DestroyedNTSB DEN76FTM33Accident · No injuriesClosedPiper PA-34 · Bullfrog Basin, UTMay 31, 1976 · N33025 · Substantial damageNTSB DEN76DTM32Accident · No injuriesClosedCessna T210L · Navajo Mtn, UTMay 30, 1976 · N2239S · Substantial damageNTSB DEN76DTM34Accident · No injuriesClosedCessna 172M · Manila, UTMay 29, 1976 · N80976 · Substantial damageNTSB DEN76FTM30Accident · No injuriesClosedCessna 177 · Ogden, UTMay 24, 1976 · N30367 · Substantial damageNTSB DEN76DTM29Accident · No injuriesClosedCessna 195 · Hurricane, UTMay 20, 1976 · N1537H · Substantial damageNTSB DEN76DTM35Accident · No injuriesClosedCessna 188B · New Castle, UTMay 14, 1976 · N9278R · Substantial damageNTSB DEN76FTM27Accident · Serious injuriesClosedCessna 182P · Hanksville, UTApr 30, 1976 · N5603J · Substantial damageNTSB DEN76FTM26Accident · Minor injuriesClosedCessna 182E · Salt Lake City, UTApr 25, 1976 · N3195Y · Substantial damageNTSB DEN76FTM28Accident · No injuriesClosedPiper PA-18 · Tooele, UTApr 24, 1976 · N9692P · Substantial damageNTSB DEN76FTM12Accident · No injuriesClosedErco 415-C · Heber, UTApr 11, 1976 · N2335H · Substantial damageNTSB DEN76FTM25Accident · No injuriesClosedHiller Acft UH-12D · Bountiful, UTApr 10, 1976 · N67113 · Substantial damageNTSB DEN76DTM24Accident · No injuriesClosedCessna 180 · Moab, UTMar 28, 1976 · N3642C · Substantial damageNTSB DEN76FTM23Accident · Minor injuriesClosedCessna T210L · Roosevelt, UTMar 18, 1976 · N59100 · Substantial damageNTSB DEN76AD040Accident · Serious injuriesClosedHiller Acft UH-12E · Bluff, UTMar 14, 1976 · N67159 · DestroyedNTSB DEN76DTM22Accident · No injuriesClosedStinson 108-2 · Bryce Canyon, UTMar 13, 1976 · N9698K · Substantial damageNTSB DEN76FTM21Accident · No injuriesClosedPiper PA-32 · Logan, UTMar 9, 1976 · N4174R · Substantial damageNTSB DEN76FTM19Accident · No injuriesClosedCessna 180 · St.George, UTMar 5, 1976 · N9294C · Substantial damageNTSB DEN76FTM20Accident · No injuriesClosedCessna 172M · Bryce Canyon, UTMar 4, 1976 · N9415H · Substantial damageNTSB DEN76FTM18Accident · No injuriesClosedCessna 210A · Salt Lake City, UTFeb 23, 1976 · N349CP · Substantial damageNTSB DEN76AD033Accident · 4 fatalClosedGrum Amer AA-5 · Hyrum, UTFeb 13, 1976 · N1357R · Destroyed