# NTSB investigations: Piper PA-22-160, 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 LAX05LA040](https://openairdocs.org/ntsb/LAX05LA040.md): Piper PA-22-160 · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Nov 24, 2004 · N9827D · Substantial damage
  > the pilot's failure to maintain directional control during landing rollout. A contributing factor in the accident was the pilot's unfamiliarity with the airplane.
- [NTSB LAX05CA019](https://openairdocs.org/ntsb/LAX05CA019.md): Piper PA-22-160 · Vacaville, CA · Accident · No injuries · Data collection · Final report · Oct 30, 2004 · N8158D · Substantial damage
  > the pilot's failure to maintain directional control during the landing rollout.
- [NTSB SEA05CA003](https://openairdocs.org/ntsb/SEA05CA003.md): Piper PA-22/20 · Medford, OR · Accident · No injuries · Data collection · Final report · Oct 2, 2004 · N2849Z · Substantial damage
  > The pilot's inadequate compensation for crosswind conditions during landing, resulting in his failure to maintain directional control. Factors include the presence of crosswinds.
- [NTSB ANC04LA118](https://openairdocs.org/ntsb/ANC04LA118.md): Piper PA-22-160 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Sep 6, 2004 · N9028D · Substantial damage
  > The pilot's selection of an unsuitable landing/takeoff site, which resulted in a loss of control and a nose over during an aborted takeoff. Factors in the accident were soft terrain, and the pilot's failure to maintain directional control.
- [NTSB ANC04LA072](https://openairdocs.org/ntsb/ANC04LA072.md): Piper PA-22-160 · Beluga, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 2004 · N9038D · Substantial damage
  > The pilot's selection of an unsuitable area for landing, which resulted in an on ground encounter with rocks during the landing roll, and the collapse of the left main landing gear.
- [NTSB LAX04LA109](https://openairdocs.org/ntsb/LAX04LA109.md): Piper PA 22-160 · Carefree, AZ · Accident · No injuries · Limited investigation · Final report · Jan 17, 2004 · N8718D · Substantial damage
  > The pilot's inadequate fuel management by his failure to switch the fuel tank selector position, which resulted in fuel starvation, a loss of engine power.

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

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