# NTSB investigations: Piper PA-28RT-201T, 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 MKC88LA033](https://openairdocs.org/ntsb/MKC88LA033.md): Piper PA-28R-201T · Hays, KS · Accident · No injuries · Limited investigation · Final report · Dec 26, 1987 · N83BC · Substantial damage
  > During a personal cross country IFR flt, PIC encountered forecast icing conditions. He then made a 180 degree turn to an alternate airfield. He said the acft accumulated substantial icing on propeller, wings and windshield. He said full pwr was necessary to…
- [NTSB CHI87LA218](https://openairdocs.org/ntsb/CHI87LA218.md): Piper PA-28RT-201T · Grayslake, IL · Accident · No injuries · Limited investigation · Final report · Sep 20, 1987 · N8315S · Substantial damage
  > The aircraft landed off the right side of the runway on a dark night when the pilot was unable to identify the intended landing runway. The aircraft landed in soft turf and during subsequent loss of control, turned right and nosed down into a ravine. The…
- [NTSB MIA87LA212](https://openairdocs.org/ntsb/MIA87LA212.md): Piper PA-28RT · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Jul 22, 1987 · N42921 · Substantial damage
  > Shortly after rotation a wasp landed on the passenger. In his attempt to kill it he inadvertently contacted the yoke, causing the acft to descent onto the rwy. After the propeller contacted the rwy the plt aborted the takeoff, & landed. The acft continued off…
- [NTSB DEN87FA134](https://openairdocs.org/ntsb/DEN87FA134.md): Piper PA-28RT-201T · Ogden, UT · Accident · Serious injuries · Field investigation · Final report · May 25, 1987 · N2888B · Destroyed
  > Acft departed rapid city, SD, en route to elko, NV. While in cruise flt in IMC at 12,000 ft, eng lost all pwr. Acft was over mountainous terrain and ATC issued plt vectors through canyon. Acft broke out of overcast at 8000 ft MSL (about 1500 ft AGL) and 6 mi…
- [NTSB LAX87LA138](https://openairdocs.org/ntsb/LAX87LA138.md): Piper PA-28RT-201T · Santa Ynez, CA · Accident · No injuries · Limited investigation · Final report · Mar 9, 1987 · N8162X · Substantial damage
  > Just after takeoff, the plt reported an engine failure. Unable to return to the airport the plt landed in an open field and collided with the terrain. During the engine examination the fuel diverter valve was removed. Low air pressure was applied to all three…

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

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