NTSB investigations: Franklin 6A&6V335 series, CA
10 cases on aircraft whose registry engine model is Franklin 6A&6V335 series. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 1966 | 1 |
|---|---|
| 1970 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2012 | 1 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR13LA050Accident · 1 fatalLimited investigationFinal reportSater Coot A-Amphib · San Andreas, CAThe 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 LAX03CA274Accident · Serious injuriesData collectionFinal reportBell 47D1 · Chino, CAthe 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 LAX01FA236Accident · No injuriesField investigationFinal reportBell 47D-1 · Riverside, CAThe 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 LAX86LA277Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Garberville, CAThe 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 LAX84LA181Accident · Minor injuriesLimited investigationFinal reportBellanca 14-13-2 · Rialto, CADuring 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 LAX74AL057Accident · 2 fatalClosedBell 47D1 · Westminster, CANTSB OAK74FVD14Accident · No injuriesClosedHiller Acft UH-12C · Brentwood, CANTSB OAK73DVG61Accident · No injuriesClosedStinson 108-2 · Weed, CANTSB OAK71DVM12Accident · No injuriesClosedHiller Acft UH-12C · Castroville, CANTSB LAX67D0130Accident · No injuriesClosedBellanca 14-19 · Oxnard, CA