Skip to content

NTSB investigations: Franklin 6A4165 series, MI

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

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19652026

Where

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."eventStateOrRegion" = 'MI' 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 ('27025')) 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.\"eventStateOrRegion\" = 'MI' 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 ('27025'))
  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" = 'MI' 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 ('27025'))
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 CEN20LA377Accident · No injuriesClass 3 · LimitedFinal reportStinson 108-3 · Coleman, MIThe pilot’s improper installation of the generator drive gear, which resulted in a total loss of engine power.Sep 1, 2020 · N909C · Substantial damage NTSB CEN17LA057Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Ionia, MIA failure of the aft support cable on the left main landing ski due to an inadequately formed nicopress sleeve, which allowed the ski to rotate into a vertical position shortly after liftoff, and its unavoidable separation during the subsequent landing.Dec 16, 2016 · N812C · Substantial damage 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.Oct 21, 2004 · N425C · Substantial damage NTSB CHI96LA138Accident · No injuriesLimited investigationFinal reportStinson 108-3 · Pontiac, MIfailure of the pilot to maintain control of the airplane during the landing roll. A factor relating to the accident was: the crosswind condition.Apr 5, 1996 · N6179M · Substantial damage NTSB CHI94LA201Accident · Serious injuriesLimited investigationFinal reportAeronca 15AC · Napoleon, MIa loss of engine power for unknown reasons. A factor related tot he accident were the trees encountered.Jun 17, 1994 · N5114Y · Substantial damage NTSB CHI85LA272Accident · No injuriesLimited investigationFinal reportStinson 108-2 · Hastings, MIThe purpose of the flight was to break in the newly overhauled engine. The pilot stated that he had been flying around the local area for about 25 minutes when he heard a clank and the engine lost complete power. The pilot determined that a tree landing was…Jul 5, 1985 · N9306K · Destroyed 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.…Nov 21, 1982 · N8836K · Substantial damage NTSB CHI81DEM19Accident · Minor injuriesClosedStinson 108-3 · Midland, MIJun 11, 1981 · N676C · Substantial damage NTSB CHI78FEC19Accident · No injuriesClosedStinson 108-3 · Fraser, MIFeb 19, 1978 · N6042M · Substantial damage NTSB CHI76FEC64Accident · No injuriesClosedStinson 108-3 · Deckerville, MISep 18, 1976 · N6108M · Substantial damage NTSB CHI76FEM58Accident · No injuriesClosedStinson 108-3 · Cedar Springs, MISep 5, 1976 · N6580M · Substantial damage NTSB CHI75FEC07Accident · No injuriesClosedStinson 108 · Dansville, MIJul 29, 1974 · N9805K · Substantial damage NTSB CHI74DEM42Accident · Minor injuriesClosedStinson 108 · Grant, MIMar 19, 1974 · N97226 · Substantial damage NTSB CHI73FEC18Accident · No injuriesClosedStinson 108-3 · Brighton, MIDec 17, 1972 · N6769M · Substantial damage NTSB CHI71FEM82Accident · No injuriesClosedStinson 108-3 · Wayland, MIMay 23, 1971 · N717C · Substantial damage NTSB CHI71FBJ32Accident · Minor injuriesClosedStinson 108-2 · Greenville, MIOct 7, 1970 · N9418K · Substantial damage NTSB CHI71FDW07Accident · No injuriesClosedStinson 108-3 · Drayton Plns, MIJul 13, 1970 · N6208M · Substantial damage NTSB CHI70FDW14Accident · No injuriesClosedStinson 108-3 · Flushing, MIMay 20, 1970 · N712C · Substantial damage NTSB CHI69F0024Accident · No injuriesClosedStinson 108-3 · Petersburg, MIJun 24, 1968 · N6428M · Substantial damage NTSB CHI69F0026Accident · Minor injuriesClosedStinson 108-3 · Flushing, MIJun 15, 1968 · N980C · Substantial damage NTSB CHI68F0765Accident · No injuriesClosedStinson 108-3 · Belleville, MIMay 17, 1968 · N4120C · Substantial damage NTSB CHI68F0208Accident · No injuriesClosedStinson 108-3 · Flushing, MIAug 28, 1967 · N712C · Substantial damage NTSB CHI66F0215Accident · No injuriesClosedStinson 108 · St Helen, MIAug 30, 1965 · N97226 · Substantial damage NTSB CHI66F0110Accident · No injuriesClosedStinson 108-2 · Freeland, MIJun 11, 1965 · N9344K · Substantial damage NTSB CHI65F0164Accident · No injuriesClosedStinson 108-2 · Holland, MIMay 15, 1965 · N8052K · Substantial damage