NTSB investigations: Franklin 6A4150 series
421 cases on aircraft whose registry engine model is Franklin 6A4150 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 ('27024'))
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 ('27024'))
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 LAX07LA040Accident · No injuriesLimited investigationFinal reportStinson 108-1 · San Jose, CAPartial loss of engine power due to a seized exhaust valve during cruise flight. Rough terrain at the forced landing site was a contributing factor.NTSB NYC06CA200Accident · Minor injuriesData collectionFinal reportStinson 108 · Meadville, PAThe owner's failure to install the proper tailwheel spring clips, which resulted in a loss of directional control during the landing roll. A factor was his lack of a mechanic certificate.NTSB LAX05CA246Accident · Minor injuriesData collectionFinal reportStinson 108 · Hesperia, CAthe pilot's failure to maintain directional control during landing rollout.NTSB LAX05LA220Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Prescott, AZthe pilot's failure to maintain directional control during the landing rollout.NTSB LAX05FA184Accident · 2 fatalField investigationFinal reportBellanca 14-13-3 · Caliente, CAThe pilot's inadvertent encounter with instrument meteorological conditions and failure to maintain adequate terrain clearance, which resulted in controlled flight into the terrain. Contributing factors were the pilots' delayed decision to reverse course, the…NTSB ATL05LA001Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Ashland, ALA total loss of engine power in cruise flight due to the fatigue failure of the No.4 cylinder exhaust valve.NTSB SEA04FA150Accident · Minor injuriesField investigationFinal reportStinson 108 · Graham, WAThe total loss of power for undetermined reasons while maneuvering.NTSB FTW04CA098Accident · No injuriesData collectionFinal reportStinson 108-1 · Slidell, LAthe pilot's failure to compensate for the gusty wind conditions and maintain control of the airplane while landing.NTSB FTW04LA003Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Pauls Valley, OKThe loss of engine power for undetermined reasons.NTSB CHI03LA306Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Moline, ILThe partial failure of the engine driven fuel pump and fuel starvation. An additional cause was the pilot misjudging the proper glidepath and his improper in-flight decision during the precautionary landing to pull back the power and lower the flaps prior to…NTSB NYC03LA175Accident · No injuriesLimited investigationFinal reportStinson 108 · White Post, VAThe pilot/ mechanic's improper annual inspection including his rigging of the elevator flight control, and his subsequent inadequate preflight inspection of the airplane prior to flight, when he failed to detect the improperly rigged elevator flight control,…NTSB CHI03LA145Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Jenison, MIThe pilot not maintaining directional control of the airplane during landing. A factor to the accident was the overload of the right main landing gear.NTSB NYC03LA092Accident · No injuriesLimited investigationFinal reportStinson 108 · Brookville, OHThe pilot's failure to maintain directional control while landing.NTSB LAX03FA108Accident · Minor injuriesField investigationFinal reportStinson 108-1 · Eloy, AZa loss of engine power caused by the fatigue failure of the number 4 cylinder exhaust valve.NTSB ANC03LA028Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Sitka, AKThe pilot's failure to maintain directional control of the airplane during the landing roll, which resulted in an inadvertent ground loop, and the collapse of the right main landing gear.NTSB CHI03LA037Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Frankenmuth, MIThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall.NTSB SEA02LA103Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Heyburn, IDA blocked fuel line due to a gasket that had disintegrated and blocked the fuel line.NTSB NYC01LA181Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Latrobe, PAThe pilot's failure to maintain control of the airplane which resulted in the inadvertent ground loop.NTSB CHI01LA203Accident · No injuriesLimited investigationFinal reportBellanca 14-13-3 · Pierce, NEThe improper management of the fuel system by the pilot. Factors were the fuel starvation, the pilot's lack of familiarity with the airplane, the berm, and the unsuitable terrain for landing encountered by the pilot.NTSB CHI01LA137Accident · 1 fatalLimited investigationFinal reportBellanca 14-13-3 · Scott City, KSThe low level roll maneuver the pilot performed on final to runway 17 and his not maintaining clearance from terrain during the maneuver.NTSB IAD01LA047Accident · Serious injuriesLimited investigationFinal reportStinson 108 · White Post, VAthe pilot's failure to remove frost from the airplane prior to departure. A factor in the accident was the tall wet grass.NTSB LAX01LA131Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Redlands, CAA total loss of engine power during cruise flight over rough terrain for undetermined non-mechanical reasons.NTSB LAX00LA200Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Los Angeles, CAThe pilot's loss of directional control during landing rollout due to the pilot's foot becoming wedged under a rudder pedal, which restricted its movement.NTSB FTW00LA027Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Terrell, TXThe pilot's failure to maintain aircraft control during landing.NTSB DEN99LA050Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Santa Rosa, NMThe unfavorable wind gust which inverted the airplane while taxiing.NTSB LAX98LA303Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Santa Rosa, CAThe pilot's inadequate visual lookout during taxiing operations. A factor was the pilot's diverted attention while taxiing.NTSB ANC98LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Delta Junction, AKThe pilot's selection of an unsuitable takeoff area. Factors associated with the accident were willow trees, and rising terrain.NTSB CHI98LA132Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tecumseh, MIThe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control. A contributing factors were wind gusts and crosswind.NTSB ANC97LA122Accident · No injuriesLimited investigationFinal reportStinson 108 · Fairbanks, AKThe pilot's inadequate compensation for wind conditions. A factor was the crosswind.NTSB LAX97LA134Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Oroville, CAa loss of engine power due to connecting rod bolt failure. The reason for the bolt failure was not determined. A contributing factor was the presence of trees in the emergency landing path.NTSB MIA97FA014Accident · 1 fatalField investigationFinal reportBellanca 14-13-2 · Smithville, TNloss of engine power for undetermined reason(s), shortly after takeoff; and failure of the pilot to maintain adequate airspeed, while turning in an attempt to maneuver back to the airport, which resulted in an inadvertent stall and uncontrolled descent into…NTSB LAX96LA329Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Quincy, CAthe pilot's over leaning of the fuel mixture, which resulted in the initial loss of engine power; and continued fuel starvation, resulting from the pilot's inadvertent mispositioning of the fuel selector valve during an attempted restart of the engine.NTSB SEA96LA156Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Arock, ORfailure of the pilot to maintain directional control of the aircraft during the landing, which resulted in an inadvertent ground loop. The tailwind was a related factor.NTSB NYC96LA130Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Elbridge, NYThe pilot's improper decision to use auto fuel and to fly the airplane when it was in need of major repairs and overdue its annual inspection.NTSB SEA96LA095Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Cut Bank, MTthe pilot's inadequate compensation for the wind conditions during the landing roll, which resulted in a loss of directional control and an inadvertent ground swerve. Factors relating to the accident were: the unfavorable wind conditions (crosswind and…NTSB MIA95LA028Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Tunica, MSThe pilot's delay in obtaining ATC assistance after becoming lost/disoriented resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was failure of the pilot to navigate using the VOR system.NTSB ANC94LA108Accident · No injuriesLimited investigationFinal reportStinson 108 · Salcha, AKThe pilot did not maintain control of the airplane. A factor in the accident was the pilot's lack of total experience in the specific make/model/type of aircraft.NTSB SEA93LA117Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Brigham City, UTThe premature liftoff by the PIC and his failure to attain proper rate of climb. Factors relating to the accident were the gusty crosswind weather conditions, the failure of the PIC to use all available runway, and transmission wires.NTSB SEA93LA054Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Fruit Heights, UTVFR flight into IMC conditions was attempted by the pilot. Factors include rain, snow, and fog.NTSB DEN92LA061Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Falcon, COInadvertent stall during initial climb following takeoff.NTSB ANC92LA059Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Mccarthy, AKThe pilot's failure to maintain directional control of the airplane. Contributing to the accident were the snow berm and the pilot's lack of total experience in the type of operation (ski equipped airplanes).NTSB CHI92LA102Accident · No injuriesLimited investigationFinal reportStinson 108 · Heyworth, ILImproper use of the carburetor heat control which resulted in carburetor ice and subsequent loss of power. A factor related to the accident was the carburetor icing conditions which existed at the time of the accident.NTSB BFO92LA007Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Spanishburg, WVThe pilot's intentional flight into instrument meteorological conditions. Contributing to the accident was the low ceiling in conjunction with the mountainous terrain and the pilot's over confidence.NTSB LAX92LA013Accident · No injuriesLimited investigationFinal reportStinson 108-8 · Susanville, CAAn inadvertent stall due to the failure of the pilot to maintain a correct airspeed during the approach.NTSB DEN91LA122Accident · No injuriesLimited investigationFinal reportStinson 108 · Steamboat Sprin, COA swerve initiated by the pilot in command to avoid a collision with a deer during takeoff roll.NTSB CHI91LA251Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Elwood, INA premature lift-off which resulted in a mush/stall. A factor related to the accident was lack of total experience in type of operation.NTSB ANC90LA140Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Fareweel, AKThe pilot's decision to takeoff downwind.NTSB ATL90LA143Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Fort Payne, ALThe pilot's selection of a runway which afforded a tailwind, and his improper use of the elevator control during the landing roll.NTSB SEA90LA061Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boise, IDPilot did not maintain directional control of the airplane during the landing roll.NTSB DEN89LA226Accident · Minor injuriesLimited investigationFinal reportUniversal Stinson 108-1 · Hudson, COPartial loss of engine power for an unknown reason. A factor related to the accident was: the alfalfa crop.