NTSB investigations: Franklin 6A4165 series
40 cases on aircraft whose registry engine model is Franklin 6A4165 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1982 | 1 |
|---|---|
| 1984 | 3 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 3 |
| 1990 | 3 |
| 1991 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1995 | 4 |
| 1996 | 3 |
| 1999 | 2 |
| 2000 | 4 |
| 2001 | 3 |
| 2002 | 1 |
| 2003 | 3 |
| 2006 | 1 |
| 2007 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('27025')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 260))
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 260))
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 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 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 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 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 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 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 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 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 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 CHI96LA138Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Pontiac, MIfailure of the pilot to maintain control of the airplane during the landing roll. A factor relating to the accident was: the crosswind condition.NTSB ANC96LA048Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Soldotna, AKThe pilot's inadequate compensation for wind conditions. The gusty/crosswind condition was a related factor.NTSB CHI96LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Sandstone, MNthe pilot's selection of an ice-covered runway for takeoff. A factor was the icy runway.NTSB CHI95LA299Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Tribune, KSthe pilot's use of excessive braking during the landing roll. A factor associated with the accident was the pilot's failure to maintain directional control of the airplane during the landing roll.NTSB ANC95LA099Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Anchorage, AKThe pilot's loss of directional control, during the takeoff roll, which resulted in an inadvertent swerve, and the pilot's excessive application of brake pressure, which resulted in a nose down condition.NTSB NYC95LA096Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Clarion, PAA partial failure of the brake system.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 CHI94LA208Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warren, MNthe pilot's improper use of the parking brake.NTSB NYC93LA070Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Norridgewock, METhe pilot at the controls failed to maintain directional control of the airplane, and the flight instructor provided inadequate supervision. A related factor was the pilot at the controls had no flight experience in the make and model of airplane being flown.NTSB CHI93LA085Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Omaha, NEThe pilot's failure to maintain directional control.NTSB DEN91LA080Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Santa Fe, NMA forward aft pilot seat adjustment locking mechanism failure.NTSB NYC90LA109Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Warehouse Point, CTThe pilot failed to maintain directional control during a landing with a gusty crosswind.NTSB NYC90LA085Accident · Minor injuriesLimited investigationFinal reportStinson 108-2 · Hudson, NYThe pilots improper operation of the flight controls which resulted in the loss of control of directional control of the airplane during a touch and go landing. Factors related to the accident were the pilot's lack of total experience.NTSB SEA90LA062Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hillsboro, ORPilot displayed poor starting procedures by proceeding with known deficiencies with the parking brake and the inadequacies of the tie down. The pilot did not attain assistance for this procedure which resulted in the airplane getting away and colliding with…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 DEN90LA019Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108-3 · Fort Collins, COInadequate compensation for wind conditons by the pilot which resulted in his failure to maintain directional control. Factors related to the accident were: the unfavorable wind condition and soft terrain.NTSB DEN89LA107Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Aurora, COThe inadequate compensation for wind conditions by the pilot. Lack of recent experience in the type of aircraft is considered a contributing factor.NTSB NYC88LA124Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Warwick, NYDuring takeoff and landing practice, the aircraft veered left off of the runway despite reported full right rudder application by the pilot. The aircraft continued to roll across the grass and came to rest after colliding with a construction ditch.NTSB ANC88LA016Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Alexander Lake, AKThe relatively inexperienced private pilot attempted to land his float equipped airplane with a tailwind and gusty winds in choppy water conditions. He lost control of the airplane and it was substantially damaged.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 CHI85LA061Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Sterling, ILThe acft ground looped & cartwheeled while landing during a personal flt. The plt lacked experience in tailwheel type acft.NTSB SEA84LA106Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Carson City, NVAccording to the plt, the wind was from 230 deg at 12 gusting 18 KTS. He said that he had just lifted the tailwheel when a 'dust devil' push the acft to the right of the rwy. The acft then struck sage brush & a barbed wire fence & nosed over.NTSB ATL82DA137Accident · Minor injuriesFinal reportStinson 108-3 · Hartford, KYDuring flight, the pilot encountered heavy thunderstorm activity. He was unable to circumnavigate the build-ups and elected to land on a gravel road toward the northwest. The pilot reported that during the landing roll, he was just about stopped when the…