# NTSB investigations: Piper PA-22-150, 2004

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 FTW04LA231](https://openairdocs.org/ntsb/FTW04LA231.md): Piper PA-22 · Mountain Home, TX · Accident · No injuries · Limited investigation · Final report · Sep 3, 2004 · N2972P · Substantial damage
  > The pilot's failure to maintain adequate airspeed which resulted in a stall.
- [NTSB CHI04CA228](https://openairdocs.org/ntsb/CHI04CA228.md): Piper PA-22-150 · Elkhart, IN · Accident · No injuries · Data collection · Final report · Aug 15, 2004 · N4303A · Substantial damage
  > The failure of the seat during landing roll and the subsequent pilot's airplane handling not being possible.
- [NTSB SEA04CA151](https://openairdocs.org/ntsb/SEA04CA151.md): Piper PA22-20 · Wht Sulphur Spg, MT · Accident · No injuries · Data collection · Final report · Aug 1, 2004 · N3838P · Substantial damage
  > The failure of the private pilot receiving flight training for a tail wheel endorsement to maintain aircraft control, and his excessive braking during the landing roll, subsequently nosing over the airplane. A contributing factor was the flight instructor's…
- [NTSB SEA04LA086](https://openairdocs.org/ntsb/SEA04LA086.md): Piper PA-22-20 · Shelton, WA · Accident · No injuries · Limited investigation · Final report · May 13, 2004 · N1829P · Substantial damage
  > The pilot's failure to adequately compensate for wind conditions during landing. Factors include a crosswind, fracture/collapse of the landing gear hydrasorb and an improper weld on the landing gear assembly.
- [NTSB LAX04CA189](https://openairdocs.org/ntsb/LAX04CA189.md): Piper PA-22-150 · Minden, NV · Accident · No injuries · Data collection · Final report · Apr 18, 2004 · N6062D · Substantial damage
  > the pilot's inadequate compensation for the gusty wind conditions and failure to maintain directional control of the airplane, resulting in a collision with terrain.

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

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

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