# NTSB investigations: Franklin 6V 350 series, 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 ATL87LA229](https://openairdocs.org/ntsb/ATL87LA229.md): Bell 47G (TOM CAT) · Dothan, AL · Accident · Minor injuries · Limited investigation · Final report · Aug 10, 1987 · N10175 · Substantial damage
  > The plt rprtd that while he was making a turn-around over trees after the 1st swath run, the helicopter enctrd a sudden wind change. He stated that the wind cond was from a cumulus buildup which put him in a tailwind situation. As he completed his turn with…
- [NTSB NYC87LA210](https://openairdocs.org/ntsb/NYC87LA210.md): Bell 47G3 · Marston Mills, MA · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 1987 · N6355 · Substantial damage
  > The helicopter reached an altitude of about 50 feet when a loss of power was experienced. Immediately the pilot set up for an emergency landing and set the helicopter down. The aircraft, however, collided with the ground hard and incurred substantial damage.…
- [NTSB NYC87LA182](https://openairdocs.org/ntsb/NYC87LA182.md): Maule M-4 · Wellsville, NY · Accident · No injuries · Limited investigation · Final report · Jun 20, 1987 · N40354 · Substantial damage
  > The flight experienced a violent shimmy upon t/d and the acft veered to the right. The pilot made a go-around and experienced the same condition on the second t/d. on the third t/d, the pilot landed but was only able to maintain control of the acft until it…
- [NTSB CHI87FA139](https://openairdocs.org/ntsb/CHI87FA139.md): Bell 47G · Dayton, MN · Accident · 2 fatal · Field investigation · Final report · Jun 3, 1987 · N128B · Destroyed
  > Aircraft collided with terrain after tailboom structure failed because of internal corrosion. The aircraft was not registered at the time of the accident and the pilot/operator failed to assure that proper or timely preventive maintenance was performed on the…

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

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