# NTSB investigations: Piper PA-22-108: In flight encounter with weather

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 NYC01LA132](https://openairdocs.org/ntsb/NYC01LA132.md): Piper PA-22-108 · Falmouth, MA · Accident · 1 fatal · Limited investigation · Final report · Jan 16, 2001 · N5391Z · Destroyed
  > The pilot's improper decision to takeoff and attempt VFR flight in IMC conditions.
- [NTSB DEN86FA147](https://openairdocs.org/ntsb/DEN86FA147.md): Piper PA-20-160 · Buena Vista, CO · Accident · 1 fatal · Field investigation · Final report · May 31, 1986 · N5394Z · Substantial damage
  > When the plt took off, the wind was light & variable. However, when he returned to the arpt about 20 to 30 min later, dark threatening clouds had moved into the area. He attempted to land on rwy 14. During the landing, the acft bounced & went off the right…
- [NTSB SEA86LA042](https://openairdocs.org/ntsb/SEA86LA042.md): Piper PA-22-108 · Ellensburg, WA · Accident · No injuries · Limited investigation · Final report · Jan 20, 1986 · N5338Z · Substantial damage
  > A gust of wind occurred on short final and a loss of airspeed resulted at about 15 feet a.g.l the pilot failed to add power but raised the aircraft's nose to an attitude where he could no longer see the runway. Landing was accomplished to the left of the…
- [NTSB FTW84FA084](https://openairdocs.org/ntsb/FTW84FA084.md): Piper PA-22-108 · Pawnee, OK · Accident · 2 fatal · Field investigation · Final report · Dec 4, 1983 · N4579Z · Destroyed
  > The acft collided with a guy wire on a micro-wave tower during flt in IMC weather. The plt had not received a weather briefing prior to takeoff and after encountering low ceilings the plt attempted to fly along a highway at low alt. The right wing of the acft…
- [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 c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102204')
    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" = 240))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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