# NTSB investigations: Piper PA-28RT-201T, 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 FTW98LA404](https://openairdocs.org/ntsb/FTW98LA404.md): Piper PA-28RT-201T · Duck Creek, UT · Accident · No injuries · Limited investigation · Final report · Sep 18, 1998 · N8252S · Substantial damage
  > Loose intake valve rocker arm studs that allowed a loss of compression and a loss of oil. A factor was unsuitable terrain on which to make a forced landing and poles next to a cattle guard.
- [NTSB DEN87FA134](https://openairdocs.org/ntsb/DEN87FA134.md): Piper PA-28RT-201T · Ogden, UT · Accident · Serious injuries · Field investigation · Final report · May 25, 1987 · N2888B · Destroyed
  > Acft departed rapid city, SD, en route to elko, NV. While in cruise flt in IMC at 12,000 ft, eng lost all pwr. Acft was over mountainous terrain and ATC issued plt vectors through canyon. Acft broke out of overcast at 8000 ft MSL (about 1500 ft AGL) and 6 mi…
- [NTSB DEN83LA197](https://openairdocs.org/ntsb/DEN83LA197.md): Piper PA-28RT-201T · Vernal, UT · Accident · No injuries · Limited investigation · Final report · Aug 13, 1983 · N29649 · Substantial damage
  > During takeoff initial climb, as the gear was retracted, the turbo charger overboost light flashed once & the eng coughed & quit. The plt stated all gages were normal until the eng quit. The acft was still over the rwy, & the plt maintained 75 KTS with 1…

## 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.aircraft_model_code IN ('7102817'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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