# NTSB investigations: Piper PA-34-200, 1986

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 MIA86LA248](https://openairdocs.org/ntsb/MIA86LA248.md): Piper PA-34-200 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Sep 13, 1986 · N1421T · Substantial damage
  > The plt stated that his landing apch was high. The acft touched down too fast and the plt veered the acft off the left side of the rwy to avoid contacting a fence at the end of the rwy. The acft traveled into soft dirt and the landing gear collapsed.
- [NTSB LAX86LA329](https://openairdocs.org/ntsb/LAX86LA329.md): Piper PA-34-200 · Salinas, CA · Accident · No injuries · Limited investigation · Final report · Aug 25, 1986 · N56710 · Substantial damage
  > The acft collided with the surface of rwy 13 after the nose gear collapsed. The plt indicated the three green gear safe indicator lights were illuminated prior to touchdown. The acft was landed on the main gear first and then the nose gear. The nose gear…
- [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…

## 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") = 1986
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103405'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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

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