NTSB investigations: Franklin 6A4165 series
438 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, newest first
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.\"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."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 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 CEN10CA214Accident · No injuriesData collectionFinal reportStinson 108-2 · Dexter, MOA loss of engine power for an undetermined reason.NTSB WPR10CA179Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Lebanon, ORThe pilot's failure to release his brake application after adding power to regain directional control during the landing roll.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 WPR09LA382Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Salt Lake City, UTA total loss of engine power during cruise flight due to the failure of the crankshaft gear.NTSB CEN09CA473Accident · Minor injuriesData collectionFinal reportStinson 108 · Gardner, KSThe pilot's failure to ensure that the fuel selector valve was set properly in its detent prior to takeoff, resulting in fuel starvation.NTSB CEN09LA384Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Llano, TXThe pilot's inability to maintain aircraft control due to the failure of the left main landing gear wheel, which resulted in the separation of the wheel from the aircraft.NTSB SEA08CA201Accident · No injuriesData collectionFinal reportStinson 108-1 · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing.NTSB DFW08LA144Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Roanoke, TXThe departing pilot's inadequate visual lookout resulting in his airplane colliding with the landing airplane. Contributing to the accident was the trees/visual obstructions along the runway's approach path.NTSB SEA08CA118Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Libby, MTThe pilot's inadequate compensation for the crosswind gusts and failure to maintain directional control during the landing rollout.NTSB ANC08CA043Accident · Minor injuriesData collectionFinal reportStinson 108 · Chugiak, AKThe reversal of the aileron control cables by maintenance personnel, and the pilot's inadequate preflight inspection.NTSB DFW08CA005Accident · No injuriesData collectionFinal reportStinson 108-2 · Indianola, MSThe pilot's failure to compensate for the existing wind conditions while landing. A contributing factor was the crosswind.NTSB LAX07CA269Accident · Minor injuriesData collectionFinal reportStinson 108-2 · Port Townsend, WAThe pilot's failure to adequately compensate for a wind conditions and maintain directional control during the touchdown and a subsequent aborted landing attempt.NTSB NYC07CA101Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Pompton Plains, NJA loss of engine power during the initial climb for undetermined reasons.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 SEA06CA106Accident · No injuriesData collectionFinal reportCessna 170B · West Glacier, MTThe pilot's failure to attain sufficient airspeed for flight, his attempt to abort the takeoff, and the airplane's subsequent departure off the end of the runway. Contributing factors were the impacted fence and vegetation, and his total lack of experience in…NTSB CHI05LA013Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Indian River, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing encountered by the pilot and the airplane's low altitude at the time engine power was lost.NTSB FTW04LA171Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Tulsa, OKThe loss of engine power for undetermined reasons.NTSB ANC04LA036Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Levelock, AKThe pilot's selection of unsuitable terrain for landing, which resulted in an overrun. Factors contributing to the accident were the pilot's inadequate weather evaluation, a tailwind, and a slippery, ice-covered landing surface.NTSB NYC04LA060Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sanford, MEAn engine fire for undetermined reasons during start-up.NTSB ATL04LA007Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Lake Placid, FLThe pilot's failure to maintain airspeed which resulted in an inadvertent stall.NTSB CHI03LA322Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Lincoln, NEThe total loss of engine power due to the fatigue fracture of the engine accessory gear drive. A factor was the concrete marker.NTSB DEN03LA131Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Vernal, UTthe pilot's improper recovery from a bounced landing, and his failure to maintain directional control during landing that resulted in an inadvertent ground loop/swerve.NTSB ATL03LA117Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Hendersonville, TNThe total loss of engine power due to loss of oil pressure for undetermined reasons, resulting in a forced landing and nose over on none suitable terrain.NTSB CHI03LA115Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Romeoville, ILThe pilot not maintaining directional control during the landing rollout. A factor to the accident was the gusting crosswind.NTSB DEN03LA036Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Elbert, COthe pilot's inability to maintain aircraft control resulting in the ground loop. Factors relating to the accident were the crosswinds and the wind gusts.NTSB NYC02LA136Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Lincoln Park, NJThe pilot's failure to abort the takeoff when diminished performance was noted. A factor was carburetor icing, accumulated before the takeoff attempt.NTSB IAD02LA064Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mifflintown, PAOn-ground carburetor icing.NTSB DEN02LA062Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falcon, COthe pilot's failure to maintain aircraft control during the takeoff roll and subsequent abort. Factors relating to the accident were the gusting crosswinds and the unsuitable terrain encountered when the airplane departed the runway.NTSB SEA02LA074Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Helena, MTFracture of the left main wheel assembly during the takeoff roll. Factors include the use of a wheel assembly not approved for the accident airplane, and the use of an oversized tire.NTSB ATL02LA037Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee 108-M · Bayou La Batre, ALThe loss of engine power for undetermined reasons.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 CHI01LA333Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Duluth, MNThe pilots failure to maintain directional control during the landing. Factors were the crosswind and the soft terrain.NTSB FTW01LA192Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Dover, ARthe pilot's delay in aborting the landing.NTSB ANC01LA104Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Palmer, AKThe pilot's selection of an unsuitable area for an off-airport landing.NTSB NYC01LA164Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Friendly, MDA baffling failure within the exhaust system. Factors were an inadequate annual inspection and the pilot's operation of the airplane with known deficiencies in equipment.NTSB ANC01LA050Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Glennallen, AKA total failure of the engine and subsequent rupture of the crankcase during cruise flight. A factor in the accident was unsuitable terrain for a forced landing.NTSB NYC01LA093Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Falmouth, MAThe pilot's failure to maintain directional control while landing. Factors were the pilot's inadequate weather evaluation and a tailwind.NTSB SEA01LA041Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Arlington, WAThe pilot's failure to maintain directional control during landing roll.NTSB ANC00LA113Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Yakutat, AKThe pilot's selection of an unsuitable landing area. Factors associated with the accident were the oil sprayed windshield, the sunglare, and an object in the water which the pilot did not see.NTSB CHI00LA187Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Topeka, KSthe restricted fuel line, and the pilot not attaining proper runway alignment during the forced landing. Factors were the low altitude at which the engine failure occurred, and the landing gear overload.NTSB LAX00LA255Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Minden, NVfailure of the pilot to compensate for a sudden wind shift resulting in a loss of directional control and collision with high vegetation.NTSB FTW00LA139Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Socorro, NMThe pilot's failure to maintain directional control during the aborted takeoff, which resulted in an inadvertent groundloop.NTSB DEN00LA068Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Las Cruces, NMThe pilot's failure to maintain directional control, resulting in an inadvertent ground loop/swerve. Factors were a burnt and unseated intake valve, and the tail wind.NTSB ANC00LA032Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Fairbanks, AKThe pilot's inadvertent ground loop.NTSB MIA00LA071Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Deland, FLThe pilot's evasive maneuver during landing roll due to panic after hearing another pilot report landing on the opposite runway resulting in the pilot losing directional control and nosing over in soft terrain. A factor in the accident was the pilot of the…NTSB LAX00LA008Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Yuma, AZThe pilot's inadequate compensation for the existing crosswind conditions.NTSB SEA99LA162Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Burley, IDThe pilot's failure to maintain directional control during the landing roll. Factors include a taxiway marking sign located adjacent to the runway.NTSB CHI99LA294Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Johnson Creek, WIthe pilot's failure to maintain directional control of the airplane.NTSB ANC99LA060Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Pedro Bay, AKA separation of the number 3 engine cylinder head assembly, and a burned through fuel line.