# NTSB investigations, RI: Loss of engine power(total) - mech failure/malf

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 NYC98FA112](https://openairdocs.org/ntsb/NYC98FA112.md): Beech A36 · Middletown, RI · Accident · 2 fatal · Field investigation · Final report · May 25, 1998 · N4507S · Destroyed
  > The shift of the number 2 engine bearing, which in turn blocked oil lubrication, and resulted in crankshaft failure. Also causal, was the pilot's decision to continue toward the airport instead of performing a forced landing to an available field. Factors…
- [NTSB NYC95LA023](https://openairdocs.org/ntsb/NYC95LA023.md): Beech 35-C33 · Coventry, RI · Accident · No injuries · Limited investigation · Final report · Nov 11, 1994 · N5869S · Destroyed
  > improper emergency procedures by the pilot and inadequate supervision by the flight instructor which resulted in their failure to restart the engine after it lost power due to a failed engine driven fuel pump.
- [NTSB NYC93LA163](https://openairdocs.org/ntsb/NYC93LA163.md): Cessna 172 · Hope Valley, RI · Accident · No injuries · Limited investigation · Final report · Aug 19, 1993 · N9845J · Substantial damage
  > The engine failure as the result of ingestion of pieces of carburetor into the cylinders, and the subsequent forced landing and nose over during the landing roll after encountering soft terrain.
- [NTSB NYC89LA154](https://openairdocs.org/ntsb/NYC89LA154.md): Piper PA-28R-200 · Middletown, RI · Accident · No injuries · Limited investigation · Final report · Jul 1, 1989 · N5029S · Substantial damage
  > The failure of both magnetos shortly after takeoff..
- [NTSB NYC85FA244](https://openairdocs.org/ntsb/NYC85FA244.md): Beech V35B · Warwick, RI · Accident · 2 fatal · Field investigation · Final report · Sep 21, 1985 · N5NG · Destroyed
  > While en route at 5000' MSL, the plt transmitted that he had an eng problem & requested clearance to land at the providence/theodore francis green state arpt, which was aprx 12 mi away. The plt then asked the controller if that was the closest arpt; however,…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 351)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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