# NTSB investigations: Continental R670-SERIES 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 CHI87LA225](https://openairdocs.org/ntsb/CHI87LA225.md): Boeing A75N1 · Rochester, IN · Accident · No injuries · Limited investigation · Final report · Sep 28, 1987 · N61V · Substantial damage
  > The tailwheel aircraft was landed into a strong left crosswind, experienced a loss of directional control, followed by a ground loop, and nose over.
- [NTSB SEA87FA165](https://openairdocs.org/ntsb/SEA87FA165.md): Fleet 16B · Bellevue, WA · Accident · 1 fatal · Field investigation · Final report · Aug 16, 1987 · N41871 · Destroyed
  > The pilot executed an emergency landing on a golf course after a power loss which he attributed to carburetor ice. Subsequent to the landing the aircraft was fueled with 10 gallons of automotive gasoline. The fuel was checked for water at the strainer drain…

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

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