# NTSB investigations: Piper PA-22-160: Nose over

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 CHI00LA106](https://openairdocs.org/ntsb/CHI00LA106.md): Piper PA-22-160 · Saint Joseph, MO · Accident · No injuries · Limited investigation · Final report · Apr 7, 2000 · N8943D · Substantial damage
  > the pilot's inadequate compensation for the wind condition. A factor to the accident was the high winds.
- [NTSB SEA98LA137](https://openairdocs.org/ntsb/SEA98LA137.md): Piper PA-22-160 · Pacific City, OR · Accident · No injuries · Limited investigation · Final report · Jul 15, 1998 · N9199D · Substantial damage
  > The pilot's improper compensation for wind conditions (landing with a tail wind.) Related factors were tail wind conditions, a short runway, and diminished brake system effectiveness.
- [NTSB SEA96LA018](https://openairdocs.org/ntsb/SEA96LA018.md): Piper PA-22-160 · Seeley Lake, MT · Accident · No injuries · Limited investigation · Final report · Nov 15, 1995 · N8431D · Substantial damage
  > The pilot's selection of unsuitable terrain for landing. The snow covered runway was a factor.
- [NTSB LAX89LA148](https://openairdocs.org/ntsb/LAX89LA148.md): Piper PA-22 · Lancaster, CA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1989 · N3508Z · Substantial damage
  > Improper planning/decision by the pilot. Strong/gusty winds contributed to the accident.
- [NTSB NYC82DA202](https://openairdocs.org/ntsb/NYC82DA202.md): Piper PA-22-160 · Tunkhannock, PA · Accident · No injuries · Final report · Aug 16, 1982 · N3732Z · Substantial damage
  > During a landing in calm wind conditions, the aircraft was high on final approach, so the pilot added flaps and slipped the plane to lose altitude. He touched down about 1000 ft down the 2000 ft runway. He reported that after landing, he applied the brakes,…

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

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

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