# NTSB investigations: Franklin 6A&6V335 series, CA

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 WPR13LA050](https://openairdocs.org/ntsb/WPR13LA050.md): Sater Coot A-Amphib · San Andreas, CA · Accident · 1 fatal · Limited investigation · Final report · Nov 23, 2012 · N8VS · Substantial damage
  > The pilot's excessive flight control inputs, which led to flight that exceeded the structural limits of the airplane and resulted in structural failure of both wings.
- [NTSB LAX03CA274](https://openairdocs.org/ntsb/LAX03CA274.md): Bell 47D1 · Chino, CA · Accident · Serious injuries · Data collection · Final report · Sep 2, 2003 · N64580 · Substantial damage
  > the student pilot's inappropriate remedial action through the application of excessive aft cyclic during a run-on landing. A factor in the accident was the student's disregard for company procedures.
- [NTSB LAX01FA236](https://openairdocs.org/ntsb/LAX01FA236.md): Bell 47D-1 · Riverside, CA · Accident · No injuries · Field investigation · Final report · Jul 6, 2001 · N64580 · Substantial damage
  > The engine crankshaft's failure as the result of fatigue cracking initiated by surface damage and localized overheating due to the installation at overhaul of incorrectly sized bearings.
- [NTSB LAX86LA277](https://openairdocs.org/ntsb/LAX86LA277.md): Hiller UH-12C · Garberville, CA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1986 · N26186 · Substantial damage
  > The student plt had just taken off on a training x-country flt when the main rotor tachometer needle decreased below the engine tachometer needle. He turned the helicopter to return to the arpt but was unable to maintain altitude and landed hard in rough…
- [NTSB LAX84LA181](https://openairdocs.org/ntsb/LAX84LA181.md): Bellanca 14-13-2 · Rialto, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1984 · N74490 · Substantial damage
  > During the initial climb after takeoff, the eng lost power. The plt then made a wheels-up landing on rough terrain & the acft was damaged. An exam revealed that the left fuel tank was empty & the right tank was full. The plt reported that he may have taken…
- [NTSB LAX74AL057](https://openairdocs.org/ntsb/LAX74AL057.md): Bell 47D1 · Westminster, CA · Accident · 2 fatal · Closed · Jan 28, 1974 · N74084 · Destroyed
- [NTSB OAK74FVD14](https://openairdocs.org/ntsb/OAK74FVD14.md): Hiller Acft UH-12C · Brentwood, CA · Accident · No injuries · Closed · Sep 14, 1973 · N5330V · Substantial damage
- [NTSB OAK73DVG61](https://openairdocs.org/ntsb/OAK73DVG61.md): Stinson 108-2 · Weed, CA · Accident · No injuries · Closed · May 7, 1973 · N9529K · Substantial damage
- [NTSB OAK71DVM12](https://openairdocs.org/ntsb/OAK71DVM12.md): Hiller Acft UH-12C · Castroville, CA · Accident · No injuries · Closed · Aug 28, 1970 · N5330V · Substantial damage
- [NTSB LAX67D0130](https://openairdocs.org/ntsb/LAX67D0130.md): Bellanca 14-19 · Oxnard, CA · Accident · No injuries · Closed · Aug 19, 1966 · N74490 · Substantial damage

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

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

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