NTSB investigations: Franklin 6A4165 series
19 cases on aircraft whose registry engine model is Franklin 6A4165 series, where the defining event was Loss of control on ground. 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
| 2008 | 2 |
|---|---|
| 2010 | 1 |
| 2014 | 1 |
| 2016 | 3 |
| 2017 | 3 |
| 2018 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 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.\"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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '230'))
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_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '230'))
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 WPR25LA179Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · East Wenatchee, WAThe pilot’s failure to maintain directional control during the landing roll with a left crosswind.NTSB ERA24LA210Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Titusville, FLThe pilot’s failure to maintain directional control while landing in variable wind conditions, which resulted in runway excursion and collision with an approach light.NTSB ERA24LA052Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-2 · Martinsville, VAThe pilot’s failure to maintain directional control during a wheel landing in crosswind conditions and the flight instructor’s delayed remedial action, which resulted in a ground loop on the runway.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 ANC21LA086Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Port Alsworth, AKA loss of directional control for reasons that could not be determined based on the available information.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 CEN20LA345Accident · No injuriesClass 3 · LimitedFinal reportStinson 108 · Glenwood Springs, COThe pilot’s loss of directional control upon landing due to a sheared tailwheel locking pin.NTSB CEN20CA204Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Denver, COThe pilot’s failure to maintain directional control while landing during variable wind conditions.NTSB GAA18CA156Accident · No injuriesData collectionFinal reportStinson 108 · Cedar Rapids, IAThe pilot’s improper landing flare, which resulted in a loss of directional control and a nose-over.NTSB GAA18CA028Accident · No injuriesData collectionFinal reportStinson 108 · Lewiston, IDThe pilot’s failure to maintain directional control during the landing roll. Contributing to the accident was the pilot’s failure to obtain appropriate training in the airplane before flying solo.NTSB GAA17CA224Accident · No injuriesData collectionFinal reportStinson 108 · Woodruff, WIThe pilot receiving instruction's incorrect brake usage and failure to maintain directional control during the landing roll.NTSB GAA17CA153Accident · No injuriesData collectionFinal reportStinson 108 · Valparaiso, INThe pilot’s failure to maintain directional control while landing with a crosswind.NTSB GAA17CA015Accident · No injuriesData collectionFinal reportStinson 108 · Rifle, COThe pilot's failure to maintain directional control during the landing roll, which resulted in a runway excursion.NTSB GAA16CA424Accident · No injuriesData collectionFinal reportStinson 108 · Sunriver, ORThe pilot's failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in runway excursion and nose-over.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 CEN14CA183Accident · No injuriesData collectionFinal reportStinson 108 · Broomfield, COThe pilot's failure to maintain directional control during the landing, which resulted in the airplane departing the runway and nosing over.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 SEA08CA201Accident · No injuriesData collectionFinal reportStinson 108-1 · Kalispell, MTThe pilot's failure to maintain directional control of the airplane during landing.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.