NTSB investigations, 1973, 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, 1973, 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\") = 1973
    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 DEN74FTM10Accident · No injuriesClosedCessna 205 · Bountiful, UTDec 26, 1973 · N1828Z · Substantial damageNTSB DEN74FTM09Accident · No injuriesClosedCessna 172D · West Jordan, UTDec 19, 1973 · N2651U · Substantial damageNTSB DEN74AD030Accident · 1 fatalClosedCessna 320 · Spanish Fork, UTDec 2, 1973 · N5204X · DestroyedNTSB DEN74AD029Accident · 2 fatalClosedBeech A35 · Plain City, UTDec 1, 1973 · N8512A · DestroyedNTSB DEN74AD026Accident · 2 fatalClosedCessna 421A · Roosevelt, UTNov 21, 1973 · N2217Q · DestroyedNTSB DEN74AD020Accident · 2 fatalClosedPiper PA-34 · Levan, UTNov 2, 1973 · N56025 · DestroyedNTSB DEN74AD019Accident · 1 fatalClosedPiper PA-28R · Salt Lake City, UTOct 29, 1973 · N3735T · DestroyedNTSB DEN74DTM08Accident · No injuriesClosedCessna U206D · St.George, UTOct 27, 1973 · N72081 · Substantial damageNTSB DEN74AD017Accident · 2 fatalClosedCessna 177B · West Delta, UTOct 11, 1973 · N34319 · DestroyedNTSB DEN74FTM06Accident · Minor injuriesClosedWittman W-8 · Salt Lake City, UTOct 4, 1973 · N11511 · Substantial damageNTSB DEN74FTM05Accident · No injuriesClosedHoward, Dee DGA15J · Richfield, UTSep 1, 1973 · N67425 · Substantial damageNTSB DEN74DTM07Accident · No injuriesClosedCessna 172 · Green River, UTAug 25, 1973 · N5934A · Substantial damageNTSB DEN74FTM04Accident · No injuriesClosedCessna 177A · Ogden, UTAug 4, 1973 · N30367 · Substantial damageNTSB DEN74FTM03Accident · No injuriesClosedCessna 305A · Ogden, UTJul 28, 1973 · N5271G · Substantial damageNTSB DEN74FTM02Accident · Serious injuriesClosedMooney M20C · Hurricane Mesa, UTJul 22, 1973 · N9557M · DestroyedNTSB DEN74FTM01Accident · Serious injuriesClosedPiper PA-28 · Cisco, UTJul 7, 1973 · N98087 · Substantial damageNTSB DEN73AD056Accident · 5 fatalClosedCessna 310 · Provo, UTJun 27, 1973 · N7714H · DestroyedNTSB DEN73DTM34Accident · No injuriesClosedCessna 320C · Vernal, UTJun 24, 1973 · N3060T · Substantial damageNTSB DEN73FTM33Accident · Serious injuriesClosedCessna 188 · Farmington, UTJun 21, 1973 · N9891V · DestroyedNTSB DEN73DTM31Accident · No injuriesClosedHiller Acft UH-12E · Richfield, UTJun 17, 1973 · N5332V · DestroyedNTSB DEN73DTM32Accident · Minor injuriesClosedPiper PA-28 · Beaver, UTJun 16, 1973 · N95400 · Substantial damageNTSB DEN73DTM30Accident · Minor injuriesClosedBell 47G3B1 · Magna, UTJun 12, 1973 · N8532F · DestroyedNTSB DEN73AD054Accident · 1 fatalClosedChampion 7GCAA · Blanding, UTJun 10, 1973 · N3039G · DestroyedNTSB DEN73AD051Accident · No injuriesClosedCessna 185 · Vernal, UTJun 6, 1973 · N4188Y · Substantial damageNTSB DEN73AD050Accident · 4 fatalClosedCessna A185F · Moab, UTMay 19, 1973 · N70298 · DestroyedNTSB DEN73DTM29Accident · No injuriesClosedCessna 180 · Bryce Canyon, UTMay 4, 1973 · N1680C · Substantial damageNTSB DEN73DTM28Accident · No injuriesClosedBeech V35B · Ogden, UTMay 3, 1973 · N5622S · Substantial damageNTSB DEN73FTM27Accident · No injuriesClosedWaco UMF · Ogden, UTApr 27, 1973 · N14076 · Substantial damageNTSB DEN73FTM26Accident · No injuriesClosedCessna 182 · Sandy, UTApr 25, 1973 · N2306G · DestroyedNTSB DEN73AD048Accident · 1 fatalClosedCessna 205A · Parowan, UTApr 14, 1973 · N8490Z · DestroyedNTSB DEN73DTM25Accident · No injuriesClosedBeech V35-TC · Hanksville, UTApr 1, 1973 · N9478S · Substantial damageNTSB DEN73DTM24Accident · No injuriesClosedCessna 172 · Navajo Mt, UTMar 25, 1973 · N4181F · Substantial damageNTSB DEN73DTM23Accident · Minor injuriesClosedCessna 170B · Bryce Canyon, UTMar 19, 1973 · N8017A · Substantial damageNTSB DEN73FTM21Accident · No injuriesClosedCessna 305A · Nephi, UTFeb 24, 1973 · N5270G · Substantial damageNTSB DEN73AD039Accident · No injuriesClosedBell 47G3B1 · Salt Lake City, UTFeb 21, 1973 · N73972 · Substantial damageNTSB DEN73FTM22Accident · No injuriesClosedCessna 320C · Ogden, UTFeb 20, 1973 · N3017T · Substantial damageNTSB DEN73DTM20Accident · No injuriesClosedCessna 182 · Brigham City, UTFeb 13, 1973 · N8489T · Substantial damageNTSB DEN73DTM19Accident · No injuriesClosedCessna 172 · Vernal, UTFeb 10, 1973 · N7022A · Substantial damageNTSB DEN73AD036Accident · 4 fatalClosedCessna 210 · Milford, UTFeb 8, 1973 · N9418X · DestroyedNTSB DEN73AD075Accident · 1 fatalClosedBeech K35 · Salt Lake City, UTFeb 7, 1973 · N6023E · DestroyedNTSB DEN73FTM18Accident · No injuriesClosedPiper PA-24 · Bountiful, UTFeb 5, 1973 · N6594P · Substantial damageNTSB DEN73DTM17Accident · No injuriesClosedPiper PA-18 · Tremonton, UTFeb 1, 1973 · N1249A · Substantial damageNTSB DEN73DTM16Accident · No injuriesClosedCessna 150G · Tooele, UTJan 27, 1973 · N8447G · Substantial damageNTSB DEN73FTM15Accident · No injuriesClosedPiper PA-22 · Provo, UTJan 14, 1973 · N3929P · Substantial damage