# NTSB investigations: Piper PA-34-200: On ground/water encounter with terrain/water

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 LAX90LA100](https://openairdocs.org/ntsb/LAX90LA100.md): Piper PA-34-200 · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1990 · N222ES · Substantial damage
  > The pilot's improper handling of the airplane during taxi.
- [NTSB ATL86LA185](https://openairdocs.org/ntsb/ATL86LA185.md): Piper PA-34-200 · Columbus, GA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1986 · N57308 · Substantial damage
  > The flight departed venice, FL enroute to cleveland, TN. The plt related that he elected to make an unscheduled landing at the Columbus airport, Columbus, GA due to thunderstorm activity in the area. The aircraft reportedly encountered wind shear, landed…
- [NTSB SEA84LA053](https://openairdocs.org/ntsb/SEA84LA053.md): Piper PA-34-200 · Burns, OR · Accident · No injuries · Limited investigation · Final report · Feb 10, 1984 · N16333 · Substantial damage
  > On departure the pilot heard a thumping noise from the undercarriage and the landing gear position lights went out. He executed a visual return and approach to a precautionary landing. During the landing roll, the left main gear collapsed.
- [NTSB FTW82DA038](https://openairdocs.org/ntsb/FTW82DA038.md): Piper PA-34 · Tomball, TX · Accident · No injuries · Final report · Jan 9, 1982 · N55489 · Substantial damage
  > After being cleared by the tower to taxi onto the runway from an unlighted taxiway the right main landing gear fell into a hole. Construction work was being done in the area and no warning lights had been erected. The pilot stated that the tower personnel had…

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

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

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