# NTSB investigations: Piper PA-24-180, 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 DEN88LA027](https://openairdocs.org/ntsb/DEN88LA027.md): Piper PA-24-180 · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Nov 23, 1987 · N7291P · Substantial damage
  > The private pilot was flying to build time. After an hour of flight, the plt returned to the home airport and attempted to land. Landing gear would not extend properly and manual gear extension did not help. All gear was partially extended and would not…
- [NTSB ATL88LA005](https://openairdocs.org/ntsb/ATL88LA005.md): Piper PA-24-180 · Collegedale, TN · Accident · No injuries · Limited investigation · Final report · Oct 8, 1987 · N5988P · Substantial damage
  > The airplane touched down while the ldg gear were extending. A witness reported that the acft began the ldg flare with the gear completely retracted, and that the gear began to extend when the airplane was 3-4 ft above the rwy. The main ldg gear contacted the…
- [NTSB DEN87LA131](https://openairdocs.org/ntsb/DEN87LA131.md): Piper PA-24-180 · Emerado, ND · Accident · No injuries · Limited investigation · Final report · May 22, 1987 · N8088P · Substantial damage
  > The commercial plt was en route on a personal flt. Thirteen miles from his destination, he smelled oil fumes and the cabin filled with oil smoke. The engine oil pressure dropped to zero. The plt shut down the engine, ventilated the cabin, and declared an…

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

This list as a web page: https://openairdocs.org/ntsb?model=7102403&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.