NTSB investigations: Franklin 6A4165 series, CA
44 cases on aircraft whose registry engine model is Franklin 6A4165 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
| 1964 | 6 |
|---|---|
| 1965 | 1 |
| 1966 | 4 |
| 1967 | 1 |
| 1969 | 2 |
| 1970 | 2 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 1 |
| 1975 | 2 |
| 1977 | 1 |
| 1978 | 4 |
| 1979 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 2001 | 1 |
| 2006 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2016 | 1 |
| 2020 | 1 |
| 2022 | 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 ('27025'))
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 ('27025'))
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 WPR22LA085Accident · No injuriesClass 4 · LimitedFinal reportUniversal Stinson 108-2 · Byron, CAThe pilot’s inadequate flare and loss of directional control during landing which resulted in a runway excursion. Contributing to the accident was the instructor’s delayed remedial action.NTSB WPR21LA064Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · El Monte, CAA loss of directional control during the landing roll due to an undetermined failure of the tailwheel assembly.NTSB WPR16CA077Accident · No injuriesData collectionFinal reportStinson 108 3 · Livermore, CAThe pilot's failure to maintain directional control during the landing roll. Contributing to the accident was maintenance personnel's failure to detect the worn tailwheel assembly during the airplane's annual inspection.NTSB WPR12CA129Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Santa Clarita, CAThe pilot's delayed decision to abandon the landing attempt, which resulted in the airplane colliding with rising terrain. Contributing to the accident was the pilot's decision to land with a tailwind.NTSB WPR11LA307Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Columbia, CAThe airplane’s failure to climb at a sufficient rate to clear trees and terrain beyond the end of the runway for reasons that could not be determined because postaccident examination did not reveal any mechanical malfunctions or failures that would have…NTSB WPR10LA072Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Clarksburg, CAThe pilot’s improper touchdown point and excessive airspeed during landing, which resulted in a runway overrun.NTSB LAX06CA263Accident · No injuriesData collectionFinal reportStinson 108-2 · Grass Valley, CAfailure of the pilot to maintain directional control on the landing rollout due to inadequate compensation for a gusty crosswind condition and an attempt to turn at an excessive taxi speed.NTSB LAX02LA006Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Rosamond, CAThe 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 LAX95LA083Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Lodi, CAthe pilot's inadequate compensation for the existing crosswind wind condition and his failure to maintain proper alignment with the runway.NTSB LAX94LA195Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ramona, CAThe pilot of the other aircraft failed to maintain an adequate visual lookout.NTSB LAX92LA282Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Montague, CAThe disintegration of the left wheel during the landing roll out and the resultant inability of the pilot to maintain directional control of the aircraft. A factor in the accident was the soft nature of the terrain encountered by the aircraft after leaving…NTSB LAX90LA044Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Rialto, CAThe pilot's failure to maintain directional control during landing. Contributing factors were the gusty crosswind conditions.NTSB LAX86LA216Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Riverside, CAThe CFI reported that during the landing roll on runway 24, at fla-bob airport, Riverside, CA, the airplane began to 'drift to the right.' The CFI applied left rudder to correct the excursion but his left foot slipped off the rudder bar and became lodged…NTSB LAX85LA060Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Chino, CAWhen the plt received ldg instructions the wind was reported as being calm. During ldg flare on rwy 26, at 2 ft AGL, a gust was encountered. The gust was from the acft's 7 o'clock position & the plt was unable to maintain control of the acft. He stated that…NTSB LAX82FVM13Accident · 4 fatalFinal reportStinson 108-2 · Morgan Hill, CAThe pilot was observed making repeated low passes in the vicinity of the crash site. This was also close to the home of one of the passengers. The final pass was made in a westerly direction over a dam at about 50 ft AGL. Just beyond the dam, the pilot made a…NTSB OAK79FVD14Accident · No injuriesClosedStinson 108-2 · Tiburon, CANTSB LAX79FUQ07AccidentClosedBellanca 1413-2 · San Fernando, CANTSB OAK78DVD06Accident · No injuriesClosedStinson 108-3 · Concord, CANTSB LAX78FUA25Accident · No injuriesClosedStinson 108-3 · Long Beach, CANTSB OAK78DVM13Accident · Minor injuriesClosedStinson 108-3 · Carmel Valley, CANTSB OAK77DVA56Accident · No injuriesClosedStinson 108 · Groveland, CANTSB OAK76DVG24Accident · Minor injuriesClosedStinson 108-3 · Walnut Grove, CANTSB OAK75DVM38Accident · No injuriesClosedStinson 108-2 · Morgan Hill, CANTSB LAX74DUG33Accident · No injuriesClosedStinson 108-3 · Apple Vally, CANTSB OAK73FVD03Accident · Minor injuriesClosedStinson 108-2 · Concord, CANTSB OAK72DVD40Accident · No injuriesClosedStinson 108-3 · Oakland, CANTSB LAX71DUG76Accident · No injuriesClosedStinson 108 · Blythe, CANTSB OAK71FXQ34Accident · No injuriesClosedStinson 108-2 · Stead, CANTSB LAX71FUA33Accident · Minor injuriesClosedStinson 108-3 · Torrance, CANTSB LAX70DVA13Accident · No injuriesClosedStinson 108-3 · Bakersfield, CANTSB OAK69D0279Accident · No injuriesClosedStinson 108-2 · Clarksburg, CANTSB LAX69D0238Accident · Minor injuriesClosedStinson 108-3 · Mortmar, CANTSB OAK68D0263Accident · No injuriesClosedStinson 108-2 · Santa Cruz, CANTSB LAX67D0178Accident · No injuriesClosedStinson 108-3 · Van Nuys, CANTSB OAK67D0146Accident · Minor injuriesClosedStinson 108-2 · Novato, CANTSB LAX67D0126Accident · No injuriesClosedStinson 108-2 · Baker, CANTSB OAK67D0061Accident · No injuriesClosedStinson 108 · Crescent City, CANTSB UNK65X1236Accident · No injuriesClosedStinson 108-2 · Tulare, CANTSB UNK64X3844Accident · No injuriesClosedStinson 108-2 · San Lucas, CANTSB UNK64X2651Accident · Minor injuriesClosedBoeing A75 · Corcoran, CANTSB UNK64X2161Accident · 1 fatalClosedBellanca 14-132 · San Pedro, CANTSB UNK64X1799Accident · No injuriesClosedStinson 108 · El Monte, CANTSB UNK64X1277Accident · No injuriesClosedStinson 108 · Redding, CANTSB UNK64X0446Accident · No injuriesClosedStinson 108-2 · San Jose, CA