NTSB investigations: Franklin 6A4150 series, ID
10 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 per year
| 1964 | 1 |
|---|---|
| 1971 | 1 |
| 1973 | 1 |
| 1976 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 2002 | 1 |
| 2012 | 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\" = 'ID' 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 ('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."eventStateOrRegion" = 'ID' 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 ('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 WPR12CA148Accident · No injuriesData collectionFinal reportStinson 108-1 · Coolin, IDThe pilot’s decision to land on a snow-covered runway.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 SEA90LA061Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Boise, IDPilot did not maintain directional control of the airplane during the landing roll.NTSB SEA87IA093Incident · No injuriesIncident investigationFinal reportStinson 108-1 · Idaho Falls, IDDuring a go around the pilot decided to attempt to reland the aircraft. Gusty crosswind conditions existed at the time and directional control was lost during which the aircraft entered into a ground loop maneuver and the left main landing gear strut…NTSB SEA86LA251Accident · 2 fatalLimited investigationFinal reportStinson 108-1 · Grangeville, IDPlt called fss over lws for wx brief lws-bke-boi. VFR not recommended for route, mountains obscured in rain showers. Plt called fss 30 min later, reported lost in clouds attempting route. Radio contact lost before location established (2305 MST, 04-26-86).…NTSB SEA82DA158Accident · No injuriesFinal reportStinson 108-1 · Twin Falls, IDPilot ground looped while doing touch and go landings. Wind 5 KTS.NTSB SEA77DYA01Accident · No injuriesClosedStinson 108 · Soda Springs, IDNTSB SEA74DYG11Accident · No injuriesClosedBellanca 14-193 · Orofino, IDNTSB SEA72FYG08Accident · Serious injuriesClosedBellanca 14-13 · Orofino, IDNTSB UNK64X3273Accident · No injuriesClosedStinson 108 · Montour, ID