# NTSB investigations: Piper PA-22-160: In flight collision with object

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 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 FTW96LA083](https://openairdocs.org/ntsb/FTW96LA083.md): Piper PA-22-160 · Waller, TX · Accident · No injuries · Limited investigation · Final report · Dec 22, 1995 · N9591D · Substantial damage
  > the pilot's failure to maintain obstacle clearance.
- [NTSB NYC89LA001](https://openairdocs.org/ntsb/NYC89LA001.md): Piper PA-22-150 · Mayville, NY · Accident · No injuries · Limited investigation · Final report · Oct 1, 1988 · N3112Z · Substantial damage
  > While on short final for landing, the flt encountered turbulence and began settling over trees located near the end of the runway. In the attempt to go around the plt allowed the acft to decelerate. The acft drifted 30 degrees right of the runway and crashed…
- [NTSB MKC82DA120](https://openairdocs.org/ntsb/MKC82DA120.md): Piper PA-22-160 · Stockton, MO · Accident · No injuries · Final report · Jul 11, 1982 · N9319D · Substantial damage
  > The aircraft was one of a flight of four, making demonstration flybys at the airport. The pilot stated that he was slow flying, about 80 to 85 ft AGL, when the aircraft started to sink. At that time, he was about 1000 to 1500 ft behind, to the right, and 20…

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

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

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