NTSB investigations: Franklin 6V 350 series, AK
15 cases on aircraft whose registry engine model is Franklin 6V 350 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
| 1968 | 1 |
|---|---|
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2016 | 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\" = 'AK' 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 ('27043'))
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" = 'AK' 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 ('27043'))
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 GAA16CA141Accident · No injuriesData collectionFinal reportMaule M 4 · Anchorage, AKThe inadvertent rudder input by the passenger, resulting in a runway excursion during takeoff and collision with a taxiway sign.NTSB ANC09CA044Accident · No injuriesData collectionFinal reportMaule M-4-220C · Nenana, AKThe pilot's failure to maintain directional control while landing, resulting in a ground loop and substantial damage to the airplane.NTSB ANC08LA003Accident · No injuriesLimited investigationFinal reportMaule M-5-220C · Aniak, AKThe pilot's improper fuel tank selection and fuel starvation, while doing touch-and-go landings.NTSB ANC01FA095Accident · Serious injuriesField investigationFinal reportCessna 172 · Eagle River, AKThe fatigue induced fracture of a connecting rod wrist pin, resulting in a complete loss of engine power.NTSB ANC97LA142Accident · No injuriesLimited investigationFinal reportMaule ML-4-220C · Aniak, AKThe inadvertent swerve during landing on calm water. A factor was the pilot's lack of certification in single engine seaplanes.NTSB ANC91LA054Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Beluga, AKThe engine failure due to undetermined causes. Contributing to the accident was the unsuitability of the available landing area.NTSB ANC89LA110Accident · Minor injuriesLimited investigationFinal reportMaule M-4-2205 · Beluga, AKThe pilot's failure to properly correct for a crosswind during landing which resulted in a loss of control.NTSB SEA86LA164Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Juneau, AKThe acft veered left and ground looped during landing roll. The right main gear strut collapsed during the landing. The plt had 5 hours total flt time in this acft and stated the toe brakes seemed 'touchy' during the landing.NTSB ANC82FA037Accident · 1 fatalField investigationFinal reportMaule M-4-220C · Homer, AKThe pilot departed Homer airport on a special VFR clearance after being advised numerous times that VFR flight was not recommended. Shortly after takeoff (8 minutes) the aircraft dove out of the clouds and crashed near the airport. The pilot was not…NTSB ANC79FAG11Accident · No injuriesClosedMaule M-4 · Palmer, AKNTSB ANC75DAG23Accident · No injuriesClosedMaule M4220C · Dillingham, AKNTSB ANC74DAG57Accident · No injuriesClosedMaule M4220C · Bethel, AKNTSB ANC72AA043Accident · 2 fatalClosedMaule M4220C · Cordova, AKNTSB ANC72DAG81Accident · No injuriesClosedMaule M-4 · Skwentna, AKNTSB ANC69F0006Accident · No injuriesClosedMaule M-4 · Wasilla, AK