# NTSB investigations: Piper PA-22-160, 2000

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 IAD01LA001](https://openairdocs.org/ntsb/IAD01LA001.md): Piper PA-22-160 · Lewisberg, PA · Accident · No injuries · Limited investigation · Final report · Oct 1, 2000 · N9697D · Substantial damage
  > The loss of engine power for undetermined reasons.
- [NTSB LAX00LA267](https://openairdocs.org/ntsb/LAX00LA267.md): Piper PA-22-160 · Lancaster, CA · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 2000 · N8768D · Substantial damage
  > The pilot's inadequate compensation for gusty winds conditions that resulted in the collision with a power line during final approach.
- [NTSB CHI00LA194](https://openairdocs.org/ntsb/CHI00LA194.md): Piper PA-22-160 · Olivia, MN · Accident · No injuries · Limited investigation · Final report · Jul 13, 2000 · N8136D · Substantial damage
  > the failure of the pilot to maintain directional control of the aircraft. A factor to the accident was the pocket gopher mound in the wheat field.
- [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 NYC00LA088](https://openairdocs.org/ntsb/NYC00LA088.md): Piper PA-22 · Conesus, NY · Accident · Serious injuries · Limited investigation · Final report · Mar 7, 2000 · N9040D · Destroyed
  > The contamination of the aircraft's fuel. Contributing factors were the pilot's failure to maintain adequate altitude and his diversion of attention during the base turn, dark night conditions, and the tree.

## 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") = 2000
  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=2000

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