# NTSB investigations, 1987, RI

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 NYC87LA254](https://openairdocs.org/ntsb/NYC87LA254.md): Beech E55 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Sep 26, 1987 · N4158A · Substantial damage
  > Just before lift-off, after the aircraft had accellerated to about 115 mph, the door on the passenger's side came open. The pilot immediately aborted the takeoff, but was unable to stop on the remaining portion of the 2500' runway. After departing the runway,…
- [NTSB NYC87LA222](https://openairdocs.org/ntsb/NYC87LA222.md): Robinson R22 · Burrville, RI · Accident · No injuries · Limited investigation · Final report · Aug 5, 1987 · N2285Z · Substantial damage
  > Aircraft lost engine power shortly after takeoff at an altitude of about 200 feet. Pilot attempted to autorotate back to the lake but during a turn to avoid collision with a boat, the helicopter crashed into the water. The reason for the engine power loss was…
- [NTSB NYC87LA270](https://openairdocs.org/ntsb/NYC87LA270.md): Rockwell 112A · No Kingstown, RI · Accident · No injuries · Limited investigation · Final report · Jul 30, 1987 · N1223J · Substantial damage
  > The aircraft bounced on landing and directional control was lost. The airplane veered to the left side of the runway and struck a pile of rubble and continued into the bay.
- [NTSB NYC87LA143](https://openairdocs.org/ntsb/NYC87LA143.md): Cessna 172 · Block Island, RI · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1987 · N79041 · Substantial damage
  > The plt rprtd that drg takeoff, the eng lost power. Subsequently, the acft crashed into an area of brush on level terrain about 1/2 mi off the departure end of the rwy. The operator rprtd that in a conversation with the plt, the plt indicated that he had…
- [NTSB NYC87FA109](https://openairdocs.org/ntsb/NYC87FA109.md): Cessna P210R · Block Island, RI · Accident · 1 fatal · Field investigation · Final report · Mar 13, 1987 · N6434A · Destroyed
  > The aircraft disappeared from the controller's scope while receiving radar vectors. The aircraft was missing until March 20, 1987 when fishermen pulled part of the wreckage out of ocean waters near Block Island, RI. The engine and propeller, engine firewall,…
- [NTSB NYC87FA061](https://openairdocs.org/ntsb/NYC87FA061.md): Piper PA-32-260 · Westerly, RI · Accident · No injuries · Field investigation · Final report · Jan 20, 1987 · N3293W · 2 aircraft · Minor damage
  > The Piper PA-32-260 was taking off from an uncontrolled airport and making a left downwind departure. A second aircraft, a Piper PA-28-181 was transiting the area 1 mile south of the airport an an altitude of 1500 ft AGL. The PA-28-181 saw the PA-32-260 just…

## 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."eventStateOrRegion" = 'RI' AND c."eventCountry" = 'USA'
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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