# NTSB investigations: Continental TSIO-520 series, 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 NYC01FA109](https://openairdocs.org/ntsb/NYC01FA109.md): Beech A-36 · Middletown, RI · Accident · 2 fatal · Field investigation · Final report · Apr 28, 2001 · N55588 · Destroyed
  > The pilot's failure to maintain airspeed while landing.
- [NTSB NYC97LA014](https://openairdocs.org/ntsb/NYC97LA014.md): Cessna 340A · Pawtucket, RI · Accident · Serious injuries · Limited investigation · Final report · Nov 7, 1996 · N36JM · Destroyed
  > failure of the pilot to comply with the published instrument approach procedure, by continuing the ILS approach below the decision height, rather than performing a missed approach; and his failure to attain a proper touchdown point for the continued landing.…
- [NTSB NYC91LA216](https://openairdocs.org/ntsb/NYC91LA216.md): Cessna TU206G · Block Island, RI · Accident · No injuries · Limited investigation · Final report · Aug 22, 1991 · N756UF · Substantial damage
  > Improper planning/decision by the pilot by electing to takeoff with a known deficiency with the equipment. The deficiency (cracked/leaking float) was a related factor.
- [NTSB NYC89LA066](https://openairdocs.org/ntsb/NYC89LA066.md): Cessna T210 · Newport, RI · Accident · Minor injuries · Limited investigation · Final report · Jan 14, 1989 · N6556A · Destroyed
  > Loss of control during an attempted go-around due to raising the flaps at low airspeed, in a nose high attitude.
- [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,…

## 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 c."eventStateOrRegion" = 'RI' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('17040'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=17040&state=RI

---
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.