NTSB investigations: Franklin 6A4150 series, MN
11 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
| 1966 | 1 |
|---|---|
| 1971 | 1 |
| 1975 | 1 |
| 1977 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 2013 | 2 |
| 2014 | 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\" = 'MN' 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" = 'MN' 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 CEN14LA417Accident · No injuriesLimited investigationFinal reportStinson 108 1 · Bruno, MNThe total loss of engine power due to an anomaly with the carburetor system that could not be determined during postaccident examination.NTSB CEN13CA412Accident · No injuriesData collectionFinal reportUniversal Stinson 108-1 · Hector, MNThe pilot’s inadvertent application of the brakes and failure to main directional control of the airplane during the takeoff roll, which resulted in the airplane nosing over.NTSB CEN13CA284Accident · No injuriesData collectionFinal reportStinson 108-1 · Cambridge, MNThe pilot’s loss of directional control while landing with a gusting crosswind.NTSB MKC89LA052Accident · No injuriesLimited investigationFinal reportStinson 108-1 · South St. Paul, MNThe failure of the pilot to maintain directional control of the airplane. Contributing to the accident were the crosswind conditions.NTSB CHI87LA155Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Big Sandy Lake, MNThe engine stalled for undetermined reasons after the pilot made a wide circle turn. During a forced landing in a lake, the aircraft nosed over. The last annual aircraft inspection was 15 months prior to the date of the accident.NTSB CHI85LA260Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Roseau, MNThe plt intentionally ground looped the acft during a forced landing to avoid obstacles following a loss of power en route. Aprx 1 1/2 hrs into the flt the plt noticed an engine roughness followed by an increase in oil temp which returned to normal shortly…NTSB CHI81FER62Accident · No injuriesClosedStinson 108-1 · Wells, MNNTSB MKC78DER05Accident · No injuriesClosedStinson 108-1 · Alexandria, MNNTSB MKC75DER37Accident · No injuriesClosedStinson 108 · Vermillion, MNNTSB MKC72FER15Accident · No injuriesClosedBellanca 14-13 · Effie, MNNTSB MKC67D0171Accident · No injuriesClosedBellanca 14-13 · Fountain, MN