# NTSB investigations: Piper PA-28RT-201, 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 ATL88FA068](https://openairdocs.org/ntsb/ATL88FA068.md): Piper PA-28RT-201 · Rutherfordton, NC · Accident · 4 fatal · Field investigation · Final report · Dec 25, 1987 · N2869C · Destroyed
  > The pilot was cleared for the adf approach. The aircraft was last observed on radar about one mile inside the rbn. The aircraft was located on December 27 about 4 NM NE of the airport. The aircraft impacted the trees at about the 2270-foot level of carson Mt.…
- [NTSB MIA88LA038](https://openairdocs.org/ntsb/MIA88LA038.md): Piper PA-28RT-201 · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Nov 16, 1987 · N539FT · Substantial damage
  > During an instructional flt while practicing accuracy touch-and-go landings, the student plt flared the acft for landing at low altitude, aprx 45-60 feet from the apch end of the rwy. The acft landed hard short of the runway. As a result the landing gear…
- [NTSB NYC88LA056](https://openairdocs.org/ntsb/NYC88LA056.md): Piper PA-28R-201 · Beaver Falls, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1987 · N8364N · No damage
  > During hand-propping of Piper PA-28R, the passenger slipped and fell into the turning prop. He received a serious head injury.
- [NTSB CHI87LA166](https://openairdocs.org/ntsb/CHI87LA166.md): Piper PA-28RT-201 · Chelsea, MI · Accident · No injuries · Limited investigation · Final report · Jul 12, 1987 · N2904A · Substantial damage
  > The pilot and three passengers attempted a takeoff from a 1800 foot sod, upsloping runway with tall, wet grass. Density altitude was 2700 feet. As the aircraft climbed out of ground effect the pilot said the engine sounded 'funny' and aborted the takeoff. The…
- [NTSB MIA87IA134](https://openairdocs.org/ntsb/MIA87IA134.md): Piper PA-28RT-201 · Grant, FL · Incident · No injuries · Incident investigation · Final report · Apr 16, 1987 · N539FT · Minor damage
  > The CFI closed the throttle & announced a simulated forced ldg. Moments later, he advanced the throttle to clear the engine & found it would not respond. A forced ldg was then performed in a field without further incident. A subsequent exam of the engine,…

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

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