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

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 ATL88LA039](https://openairdocs.org/ntsb/ATL88LA039.md): Piper PA-34-200 · Murfreesboro, TN · Accident · No injuries · Limited investigation · Final report · Nov 14, 1987 · N41298 · Substantial damage
  > The rt wheel brake failed while the airplane was taxiing on a parallel taxiway. The failure occurred near the end of the taxiway, just as the plt was about to turn the airplane onto the rwy. The plt subsequently attempted to turn the airplane using…
- [NTSB ATL87IA163](https://openairdocs.org/ntsb/ATL87IA163.md): Piper PA-34-200 · Birmingham, AL · Incident · No injuries · Incident investigation · Final report · Jun 9, 1987 · N56657 · Minor damage
  > The pilot reported that during a landing, he forgot to extend the landing gear. He was wearing a 'dave clark' headset with earplugs & did not hear the landing gear warning horn. During a subsequent check of the landing gear, it operated normally.
- [NTSB FTW87LA131](https://openairdocs.org/ntsb/FTW87LA131.md): Piper PA-34-200 · Grand Prairie, TX · Accident · No injuries · Limited investigation · Final report · May 27, 1987 · N41788 · Substantial damage
  > During landing roll the right main landing gear tire failed causing a loss of directional control. The acft departed the right side of the rwy, and the right main landing gear collapsed.
- [NTSB MIA87FA098](https://openairdocs.org/ntsb/MIA87FA098.md): Piper PA-34-200 · Miami, FL · Accident · No injuries · Field investigation · Final report · Mar 4, 1987 · N41531 · Substantial damage
  > The plt stated that he was on final approach & cleared to land long, when a 737 was cleared for an immediate takeoff and he was told to make s turns or whatever necessary. He slowed to land and when he was approximately 10 to 20 ft. in the air he encountered…

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

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