# Major NTSB investigations, UT

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB LAX08MA277](https://openairdocs.org/ntsb/LAX08MA277.md): Beech A100 · Moab, UT · Accident · 10 fatal · Major investigation · Final report · Aug 22, 2008 · N601PC · Substantial damage
  > The pilot’s failure to maintain terrain clearance during takeoff for undetermined reasons.
- [NTSB DCA90MA002](https://openairdocs.org/ntsb/DCA90MA002.md): Boeing 727-232 · Salt Lake City, UT · Accident · Minor injuries · Major investigation · Final report · Oct 14, 1989 · N530DA · Destroyed
  > A fire which started in the passenger oxygen system for undetermined reasons. Contributing to the accident was the failure of delta airlines to recognize, attend to and correct repeated leaks in the oxygen system.
- [NTSB FTW89MA047](https://openairdocs.org/ntsb/FTW89MA047.md): Mcdonnell Douglas DC-9-32F · Salt Lake City, UT · Accident · 1 fatal · Major investigation · Final report · Feb 9, 1989 · N935F · No damage
  > Improper in-flight planning/decision by the captain (pilot-in-command) and his improper use of the portable oxygen system, which resulted in his incapacitation due to hypoxia. Factors related to the accident were: inadequate maintenance/inspection of the…
- [NTSB DCA87MA018](https://openairdocs.org/ntsb/DCA87MA018.md): Swearingen SA-226TC · Kearns, UT · Accident · 10 fatal · Class 1 · Major · Final report · Jan 15, 1987 · N163SW · 2 aircraft · Destroyed
  > The two acft, a Swearingen SA-226TC and a Mooney M-20, collided in flt at aprx 7000 ft MSL in the salt lake city arpt (slc) radar service area over Kearns, UT. The SA-226 was approaching slc for lndg and the M-20 was conducting a local trng flt when the…
- [NTSB DEN86MA129](https://openairdocs.org/ntsb/DEN86MA129.md): Gulfstream 690D · Price, UT · Accident · 6 fatal · Major investigation · Final report · May 7, 1986 · N200PR · Destroyed
  > At 1042 MDT, the flt rprtd mod turbc at FL 240, but elected to remain at that alt. At 1055, they were clrd to dscnd at plt's descretion to maint 12,000'. Aprx 8 min later, shortly after bgng a dscnt, the flt was instructed to chg freq; BUT21 secs later, they…
- [NTSB DCA78AA005](https://openairdocs.org/ntsb/DCA78AA005.md): Douglas DC-8F · Kaysville, UT · Accident · 3 fatal · Closed · Dec 18, 1977 · N8047U · Destroyed
- [NTSB DEN75AD027](https://openairdocs.org/ntsb/DEN75AD027.md): Rockwell 690A · Kingston, UT · Accident · 1 fatal · Closed · Nov 12, 1974 · N40MP · 2 aircraft · Destroyed

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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 c."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA'
  AND (c.board_report_url IS NOT NULL OR c."investigationClass" = 'Class 1' OR c."caseType" = 'Major - Launch')
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?major=1&state=UT

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.