# NTSB investigations: Piper PA-22: 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 DFW06CA107](https://openairdocs.org/ntsb/DFW06CA107.md): Piper PA-22 · Tecumseh, OK · Accident · No injuries · Data collection · Final report · Apr 17, 2006 · N945A · Substantial damage
  > The pilot's failure to maintain clearance from the trees. Contributing factors were the pilot's inadequate preflight planning/preparation and the high-density altitude.
- [NTSB FTW98LA250](https://openairdocs.org/ntsb/FTW98LA250.md): Piper PA-22 · Balko, OK · Accident · Minor injuries · Limited investigation · Final report · May 31, 1998 · N200HA · Substantial damage
  > The pilot's inadequate preflight planning which failed to assure adequate climb performance to clear an obstacle (fence) during takeoff climb.
- [NTSB LAX96LA018](https://openairdocs.org/ntsb/LAX96LA018.md): Piper PA-22 · Battle Mountain, NV · Accident · Minor injuries · Limited investigation · Final report · Oct 21, 1995 · N1845A · Substantial damage
  > the pilot's failure to see and avoid utility transmission wires suspended across the final approach flight path.
- [NTSB LAX95LA065](https://openairdocs.org/ntsb/LAX95LA065.md): Piper PA-22-161 · Elko, NV · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1994 · N2269Z · Substantial damage
  > The pilot selected unsuitable terrain for takeoff.
- [NTSB SEA94FA174](https://openairdocs.org/ntsb/SEA94FA174.md): Piper PA-22-135 · Leavenworth, WA · Accident · 3 fatal · Field investigation · Final report · Jul 9, 1994 · N3645A · Destroyed
  > The pilot's inadequate preflight planning/preparation. Factors related to the accident were: high density altitude, the runway condition (with areas of soft or uneven terrain and tall grass), and obstructions (trees) near the departure end of the runway.
- [NTSB DEN88FA212](https://openairdocs.org/ntsb/DEN88FA212.md): Piper PA-22-150 · Kanosh, UT · Accident · 2 fatal · Field investigation · Final report · Jul 13, 1988 · N3541Z · Destroyed
  > Plt obtained wx briefing and filed VFR flt plan from burley, ID, to chandler, AZ, with enroute refueling stop at fillmore, UT. Plt landed on dirt road at fillmore and taxiied acft to roadside truck stop. Acft serviced with auto gas. Acft departed fillmore but…

## 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 ('7102202')
    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=7102202&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.
