OpenAirDocs.org

NTSB investigations: Franklin 6A4150 series

7 cases on aircraft whose registry engine model is Franklin 6A4150 series, where the first occurrence was “In flight encounter with weather”. 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

19832026

Where

Open the map

Latest 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 ('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\" = 240))
  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.

NTSB LAX05FA184Accident · 2 fatalField investigationFinal reportBellanca 14-13-3 · Caliente, CAThe pilot's inadvertent encounter with instrument meteorological conditions and failure to maintain adequate terrain clearance, which resulted in controlled flight into the terrain. Contributing factors were the pilots' delayed decision to reverse course, the…May 20, 2005 · N6511N · DestroyedNTSB SEA93LA054Accident · 1 fatalLimited investigationFinal reportStinson 108-2 · Fruit Heights, UTVFR flight into IMC conditions was attempted by the pilot. Factors include rain, snow, and fog.Jan 16, 1993 · N8004K · DestroyedNTSB BFO92LA007Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Spanishburg, WVThe pilot's intentional flight into instrument meteorological conditions. Contributing to the accident was the low ceiling in conjunction with the mountainous terrain and the pilot's over confidence.Nov 16, 1991 · N97684 · DestroyedNTSB ATL87LA193Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Hamilton, OHThe plt rptd that he made a non-std rt-hand departure after t/o from rwy 29, to avoid traffic departing to the left. The acft began to sink as he attempted to climb over the lee side of a 200 ft-high ridge less than 1 mile northwest of the arpt. The acft…Jun 27, 1987 · N74259 · Substantial damageNTSB SEA86LA251Accident · 2 fatalLimited investigationFinal reportStinson 108-1 · Grangeville, IDPlt called fss over lws for wx brief lws-bke-boi. VFR not recommended for route, mountains obscured in rain showers. Plt called fss 30 min later, reported lost in clouds attempting route. Radio contact lost before location established (2305 MST, 04-26-86).…Apr 27, 1986 · N8165K · DestroyedNTSB 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 · DestroyedNTSB NYC83LA216Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Tully, NYAt 2,000 ft near syracuse the plt decided he had enough fuel to continue on to his home base at cortland. He added full power to climb back to 3,000 ft & encountered turbulence. With full power & 80 KTS indicated the acft was losing altitude. The acft…Aug 18, 1983 · N8470K · Destroyed