NTSB investigations: Franklin 4AC176C-D-F

6 cases on aircraft whose registry engine model is Franklin 4AC176C-D-F. 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

19662026

NTSB investigations: Franklin 4AC176C-D-F per year, 1966–2026: 6 cases
1966	1
1971	2
1993	1
2011	1
2014	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 ('27007')) 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 ('27007'))
  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 ('27007'))
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 ERA14FA337Accident · 1 fatalField investigationFinal reportCulver LFA · Limington, METhe pilot’s failure to maintain airspeed during initial climb, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall.Jul 12, 2014 · N41716 · Substantial damage NTSB ERA12LA087Accident · No injuriesLimited investigationFinal reportSmith Miniplane DSA-4 · Hernando, FLThe pilot's failure to apply carburetor heat while descending in conditions conducive to carburetor icing, which resulted in carburetor icing and a subsequent total loss of engine power.Nov 27, 2011 · N1321 · Substantial damage NTSB BFO93LA139Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BF12-65 · Sunappee, NHThe passenger's failure to follow proper procedures and inadequate supervision by the pilot.Jul 25, 1993 · N36452 · No damage NTSB MIA72FLG06Accident · No injuriesClosedTaylorcraft BC12 · Sullivans Is., SCAug 10, 1971 · N36452 · Substantial damage NTSB CHI71AC075Accident · 2 fatalClosedPiper J3C-65 · Sunbury, OHApr 11, 1971 · N6752H · Destroyed NTSB MKC67D0144Accident · No injuriesClosedRepublic RC-3 · Warrensburg, MOJul 2, 1966 · N6438K · Substantial damage