# NTSB investigations: Piper PA-22, 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 SEA97LA018](https://openairdocs.org/ntsb/SEA97LA018.md): Piper PA-22-150 · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Oct 21, 1996 · N3461A · Substantial damage
  > the pilot's inadequate compensation for wind conditions, while landing, which resulted in a loss of directional control and an inadvertent ground swerve. The crosswind was a related factor.
- [NTSB DEN88FA212](https://openairdocs.org/ntsb/DEN88FA212.md): Piper PA-22-150 · Kanosh, UT · Accident · 2 fatal · Field investigation · Final report · Jul 13, 1988 · N3541Z · Destroyed
  > Plt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…
- [NTSB DEN66D0333](https://openairdocs.org/ntsb/DEN66D0333.md): Piper PA-22 · Hanksville, UT · Accident · No injuries · Closed · Jun 1, 1966 · N829A · Substantial damage
- [NTSB DEN65F0057](https://openairdocs.org/ntsb/DEN65F0057.md): Piper PA-22 · Beryl Junction, UT · Accident · Minor injuries · Closed · Apr 24, 1965 · N994A · Destroyed
- [NTSB UNK64X2636](https://openairdocs.org/ntsb/UNK64X2636.md): Piper PA22 · Green River, UT · Accident · No injuries · Closed · Jul 4, 1964 · N1448C · Substantial damage

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

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