# NTSB investigations: Lycoming 0-320 series, UT: In flight collision with terrain/water

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 SEA07LA251](https://openairdocs.org/ntsb/SEA07LA251.md): Cessna 172M · Thompson, UT · Accident · No injuries · Limited investigation · Final report · Sep 5, 2007 · N8945V · Substantial damage
  > The pilot's failure to maintain terrain clearance while maneuvering in a box canyon.
- [NTSB DEN02LA073](https://openairdocs.org/ntsb/DEN02LA073.md): Piper PA-28-140 · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Jul 14, 2002 · N4690R · Substantial damage
  > the pilot-in-command failure to obtain/maintain proper rate of climb, resulting in a collision with terrain. Contributing factors were the high density altitude and exceeding the airplane's forward center of gravity limit.
- [NTSB SEA92FA042](https://openairdocs.org/ntsb/SEA92FA042.md): Piper PA-28-161 · Ogden, UT · Accident · 1 fatal · Field investigation · Final report · Feb 6, 1992 · N4370B · Destroyed
  > The improper decision by the instructor pilot to perform maintenance in flight and his failure to maintain terrain clearance. Factors relating to the accident were the dark night light conditions, mountainous terrain in the area, and the instructor diverting…
- [NTSB DEN86LA187](https://openairdocs.org/ntsb/DEN86LA187.md): Cessna 172N · Richfield, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1986 · N8291E · Substantial damage
  > Plt stated after the accident, '...I noticed the wind sock and it was drooping...I went to final approach (for rwy 1)... Noticed a little wind so I crabbed into it, and I noticed my approach didn't look good so I went to do a go-around. I went to raise the…
- [NTSB DEN84LA127](https://openairdocs.org/ntsb/DEN84LA127.md): Piper PA-28-140 · Monticello, UT · Accident · No injuries · Limited investigation · Final report · Apr 13, 1984 · N4FN · Substantial damage
  > The pilot departed uphill with a tailwind at near gross weight with a high density altitude. The flight was late gettingstarted & an excessive magneto drop was attributed to a fouled plug. The pilot also stated that he was under mental stress. The acft lifted…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41508')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41508&occurrence=230&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.