NTSB investigations: Franklin 6A4165 series
12 cases on aircraft whose registry engine model is Franklin 6A4165 series, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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 | 2 |
|---|---|
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2002 | 2 |
| 2004 | 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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" = 353))
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 CHI05LA013Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Indian River, MILoss of engine power during initial climb after takeoff for undetermined reasons. A contributing factor was the unsuitable terrain for a forced landing encountered by the pilot and the airplane's low altitude at the time engine power was lost.NTSB IAD02LA064Accident · Minor injuriesLimited investigationFinal reportStinson 108-3 · Mifflintown, PAOn-ground carburetor icing.NTSB ATL02LA037Accident · Serious injuriesLimited investigationFinal reportConsolidated-Vultee 108-M · Bayou La Batre, ALThe loss of engine power for undetermined reasons.NTSB FTW96LA202Accident · No injuriesLimited investigationFinal reportStinson 108-2 · El Paso, TXthe pilot's improper inflight planning/decision, which resulted in fuel exhaustion and a subsequent forced landing. A factor relating to the accident was: the unfavorable en route wind.NTSB CHI94LA163Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Kettle River, MNThe pilot's improper use of carburetor heat and the lack of suitable terrain for a forced landing. The carburetor icing weather condition was a factor.NTSB ANC91LA157Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Cantwell, AKThe engine power loss for undetermined reasons and the lack of suitable terrain for a forced landing.NTSB SEA90LA123Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Worley, IDImproper planning/decision by the pilot, which resulted in an inadequate supply of fuel and fuel exhaustion. The high vegetation (wheat crop) and rough terrain (rut) were related factors.NTSB FTW88DPJ05Accident · 1 fatalFinal reportStinson 108-3 · Collinsville, OKThe pilot experienced a loss of engine power during the takeoff leg. Post accident investigation revealed that the fuel selector was in the near closed position. This position only allowed a small percentage of the fuel to flow but would allow operation in…NTSB ATL87LA140Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Huntersville, NCThe plt reported that he closed the throttle to simulate an engine failure after takeoff from rwy 06, at about 400-500 ft AGL. He subsequently made a 180 degree turn back toward the arpt to practice a simulated forced ldg, and the acft sink rate increased to…NTSB ATL85LA203Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Lewisburg, WVAcft lost power in cruise flight shortly after takeoff. Descent was begun to a field followed by engine quitting. During the turn to final, pilot said, left wing stalled resulting in hard landing on left wheel and left wing. Later, fuel cap vents were found…NTSB CHI83LA046Accident · No injuriesLimited investigationFinal reportStinson 108 · Milan, MIWhile on downwind the pilot stated he "pulled the carburator heat on and almost immediately reduced the power." At this point the engine stopped. Although he attempted to restart the engine while executing emergency procedures, the engine failed to respond.…NTSB SEA82FA093Accident · Serious injuriesField investigationFinal reportStinson 108-3 · Lopez Island, WAThe aircraft engine stopped at 400 feet AGL during climbout. The pilot executed a turn at minimum airspeed and landed the aircraft on a golf course. The landing gear and engine mounts failed. Investigation revealed the aircraft's fuel tanks were empty.