Skip to content

NTSB investigations: Franklin 6A4150 series, WA

19 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

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" = 'WA' 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

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\" = 'WA' 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" = 'WA' 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

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 WPR23LA271Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Burlington, WAThe pilot’s failure to maintain directional control during the landing roll with a quartering tailwind.Jul 11, 2023 · N8889K · Substantial damage NTSB WPR20CA168Accident · No injuriesClass 4 · Data collectionFinal reportStinson 108 · Yakima, WAThe pilot's failure to maintain directional control of the airplane during an aborted landing, which resulted in a ground loop, runway excursion, and subsequent nose over.Jun 4, 2020 · N87607 · Substantial damage NTSB GAA19CA522Accident · No injuriesData collectionFinal reportStinson 108 · Bandera, WAThe pilot's selection of unsuitable terrain for a simulated rejected takeoff, which resulted in a runway overrun and noseover.Sep 1, 2019 · N97699 · Substantial damage NTSB GAA18CA238Accident · No injuriesData collectionFinal reportStinson 108 · Spokane, WAThe pilot’s failure to maintain directional control during landing.Apr 28, 2018 · N35VM · Substantial damage NTSB GAA18CA165Accident · No injuriesData collectionFinal reportBellanca 1413 · Anacortes, WAThe pilot’s failure to maintain directional control during landing.Mar 10, 2018 · N74445 · Substantial damage NTSB WPR11CA345Accident · No injuriesData collectionFinal reportStinson 108-1 · Moses Lake, WAThe pilot's failure to maintain directional control during an aborted takeoff.Jul 23, 2011 · N8318K · Substantial damage NTSB WPR09LA022Accident · 1 fatalLimited investigationFinal reportStinson 108-1 · Concrete, WAThe loss of engine power during initial climb due to the pilot's improper exhaust system maintenance, which resulted in restriction of the carburetor's air intake.Oct 23, 2008 · N97946 · Substantial damage NTSB SEA04FA150Accident · Minor injuriesField investigationFinal reportStinson 108 · Graham, WAThe total loss of power for undetermined reasons while maneuvering.Aug 1, 2004 · N97599 · Substantial damage NTSB SEA86FA034Accident · 2 fatalField investigationFinal reportStinson 108 · Hoquiam, WAThe acft contacted terrain 680 ft north of rwy 06 at bowerman airfield. The acft departed elma arpt, ocean shores, WA, sometime around 2330 PST, on 12-29-85. Prior to the departure the passenger stated to persons they were waiting for the fog to clear for…Dec 30, 1985 · N40199 · Destroyed NTSB SEA84FA032Accident · 1 fatalField investigationFinal reportStinson 108-1 · Vashon, WAJust after taking off in IMC at night, the acft crashed near the departure end of rwy 36. According to a witness, the acft climbed after takeoff to about 200 ft above the trees, then entered a descent & disappeared behind a tree line. After crashing, the acft…Jan 5, 1984 · N97016 · Destroyed NTSB SEA78DYP11Accident · No injuriesClosedStinson 108 · Mead, WAFeb 6, 1978 · N97675 · Substantial damage NTSB SEA74FYG27Accident · Minor injuriesClosedStinson 108-1 · Tekoa, WAMar 17, 1974 · N97675 · Substantial damage NTSB SEA73FYE29Accident · No injuriesClosedStinson 108 · Kent, WAMar 17, 1973 · N9150K · Substantial damage NTSB SEA72FYE36Accident · No injuriesClosedStinson 108 · Seattle, WAJul 7, 1972 · N97909 · Substantial damage NTSB SEA72FYE35Accident · Minor injuriesClosedBellanca 14-13 · Blaine, WAMay 25, 1972 · N86897 · Substantial damage NTSB SEA69D0180Accident · No injuriesClosedStinson 108 · Vancouver, WADec 8, 1968 · N97887 · Substantial damage NTSB SEA66A0048Accident · 1 fatalClosedStinson 108 · Port Angeles, WAMar 21, 1966 · N8930K · No damage NTSB SEA66D0114Accident · No injuriesClosedStinson 108 · Sultan, WAJul 30, 1965 · N8760K · Substantial damage NTSB UNK64X1611Accident · No injuriesClosedStinson 108 · Chelan, WAMay 4, 1964 · N97626 · Substantial damage