# NTSB investigations: Piper PA-22-108, 1982

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 SEA82DA056](https://openairdocs.org/ntsb/SEA82DA056.md): Piper PA-22-108 · Snohomish, WA · Accident · No injuries · Final report · Aug 5, 1982 · N5001Z · Substantial damage
  > The pilot stated that he kept his speed up and landed farther down the runway than usual due to other traffic. After touchdown he found that the brakes had failed so he attempted to slow down the aircraft by swerving back and forth and finally turning off on…
- [NTSB MIA82DA121](https://openairdocs.org/ntsb/MIA82DA121.md): Piper PA-22-108 · Tampa, FL · Accident · No injuries · Final report · May 23, 1982 · N4607Z · Substantial damage
  > While circling over the area where the pilot resided, a complete loss of power occurred. During the emergency landing the pilot stalled the aircraft while attempting to avoid a collision with an autombile. Both the aircraft and the automobile were…
- [NTSB LAX82FA036](https://openairdocs.org/ntsb/LAX82FA036.md): Piper PA-22 · Black Canyon Ci, AZ · Accident · 1 fatal · Field investigation · Final report · Jan 5, 1982 · N4696Z · Destroyed
  > The wreckage was located at the 3,030 foot elevation on the south side of a plateau. The weather in the area of the accident would have approximated the reported conditions at prescott, AZ located approximately 40 mi nnw.

## 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 year(c."eventDate") = 1982
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102204'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=7102204&year=1982

---
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.
