# NTSB investigations: Franklin 6A8 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 CHI01LA013](https://openairdocs.org/ntsb/CHI01LA013.md): Republic RC-3 · Baraboo, WI · Accident · No injuries · Limited investigation · Final report · Oct 12, 2000 · N6175K · Substantial damage
  > the failure of the number five intake valve spring during initial climbout and that there was no suitable terrain during the forced landing. A factor was the corn crop.
- [NTSB DEN85LA218](https://openairdocs.org/ntsb/DEN85LA218.md): Downer Aircraft Industries REP. Seabee RC-3 · Haugan, MT · Accident · No injuries · Limited investigation · Final report · Aug 13, 1985 · N6305K · Substantial damage
  > The plt had reconditioned N6305K and was flying the acft to his home in Texas. He continued to state that while climbing through 6500 ft, he heard an unusual noise followed by a substantial loss in pwr. The plt executed an emergency landing on a forest…
- [NTSB LAX84LA229](https://openairdocs.org/ntsb/LAX84LA229.md): Republic RC-3 · Lakeport, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 22, 1984 · N6470K · Substantial damage
  > The plt reported that on his preflight he found the eng compression & oil level to be low but after servicing the oil to the proper level he departed & on initial climb, after reaching about 100 ft AGL, the eng started popping & losing RPM. The plt made a…

## 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 ('27030')
    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=27030&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.
