NTSB investigations: Franklin 6A4150 series

7 cases on aircraft whose registry engine model is Franklin 6A4150 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19852026

NTSB investigations: Franklin 6A4150 series per year, 1985–2026: 7 cases
1985	1
1987	1
1992	1
1994	1
1996	2
2001	1

Where

Open the map

Latest cases

Query with SQL

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 ('27024') 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

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 ('27024')
      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 ('27024')
    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

Run 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 LAX01LA131Accident · Serious injuriesLimited investigationFinal reportStinson 108-1 · Redlands, CAA total loss of engine power during cruise flight over rough terrain for undetermined non-mechanical reasons.Mar 31, 2001 · N8158K · Substantial damage NTSB LAX96LA329Accident · Minor injuriesLimited investigationFinal reportStinson 108 · Quincy, CAthe pilot's over leaning of the fuel mixture, which resulted in the initial loss of engine power; and continued fuel starvation, resulting from the pilot's inadvertent mispositioning of the fuel selector valve during an attempted restart of the engine.Sep 8, 1996 · N97337 · Substantial damage NTSB NYC96LA130Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Elbridge, NYThe pilot's improper decision to use auto fuel and to fly the airplane when it was in need of major repairs and overdue its annual inspection.Jun 14, 1996 · N8073K · Substantial damage NTSB MIA95LA028Accident · No injuriesLimited investigationFinal reportBellanca 14-13 · Tunica, MSThe pilot's delay in obtaining ATC assistance after becoming lost/disoriented resulting in the total loss of engine power due to fuel exhaustion. Contributing to the accident was failure of the pilot to navigate using the VOR system.Nov 24, 1994 · N74232 · Substantial damage NTSB CHI92LA102Accident · No injuriesLimited investigationFinal reportStinson 108 · Heyworth, ILImproper use of the carburetor heat control which resulted in carburetor ice and subsequent loss of power. A factor related to the accident was the carburetor icing conditions which existed at the time of the accident.Mar 3, 1992 · N97599 · Substantial damage NTSB NYC87LA130Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Rumford Point, MEWhile circling a pond, the plt failed to switch fuel tanks and the engine lost power. He attempted to switch from the right to the left tank but was forced to set the acft down in a nearby field. The left wing, fuselage, landing gear, prop, and engine mounts…Apr 25, 1987 · N9119K · Substantial damage 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…Jun 20, 1985 · N9070K · Substantial damage