# NTSB investigations: Franklin 6A4165 series: Loss of engine power(partial) - 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 LAX02LA006](https://openairdocs.org/ntsb/LAX02LA006.md): Stinson 108-3 · Rosamond, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 14, 2001 · N735C · Substantial damage
  > The pilot's failure to attain sufficient airspeed during the attempted takeoff, which resulted in a stall/mush. The airplane's failure to accelerate was due to a disintegrated bearing on the camshaft. The pilot's failure to make a timely abort decision was a…
- [NTSB ANC99LA060](https://openairdocs.org/ntsb/ANC99LA060.md): Aeronca 15AC · Pedro Bay, AK · Accident · Serious injuries · Limited investigation · Final report · May 8, 1999 · N1315H · Substantial damage
  > A separation of the number 3 engine cylinder head assembly, and a burned through fuel line.
- [NTSB NYC99LA065](https://openairdocs.org/ntsb/NYC99LA065.md): Stinson 108-3 · Bristol, CT · Accident · No injuries · Limited investigation · Final report · Feb 21, 1999 · N6191M · Substantial damage
  > The partial loss of power due to the failure of a fatigued connecting rod bolt.
- [NTSB FTW96LA077](https://openairdocs.org/ntsb/FTW96LA077.md): Stinson ST-108-2 · Lake Dallas, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 27, 1995 · N135C · Destroyed
  > the failure of the #6 connecting rod assembly. A factor was the lack of suitable terrain for a forced landing which resulted in a water landing.
- [NTSB NYC88LA090](https://openairdocs.org/ntsb/NYC88LA090.md): Stinson 108 · Oswego, NY · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 1988 · N6939M · Substantial damage
  > During a local pleasure flight, a decrease in engine power was experienced and a puff of smoke observed in the cockpit. The pilot applied full power in an attempt to return to the airport, but realized it was not possible. The pilot put the aircraft down in…

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27025')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=27025&occurrence=352

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