Skip to content

NTSB investigations: Franklin 6A4150 series, NY

25 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

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" = 'NY' 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\" = 'NY' 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" = 'NY' 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 ERA16LA173Accident · No injuriesLimited investigationFinal reportUniversal Stinson 108 · Calverton, NYThe pilot's failure to maintain directional control during the landing roll.Apr 30, 2016 · N8660K · Substantial damage NTSB ERA10LA111Accident · No injuriesLimited investigationFinal reportStinson 108 · Bayport, NYA total loss of engine power during cruise flight due to fuel contamination.Jan 9, 2010 · N97223 · 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 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 NTSB NYC80FFA17Accident · Minor injuriesClosedStinson 108-2 · Durhamville, NYMay 25, 1980 · N413C · Substantial damage NTSB NYC79FHM16Accident · Minor injuriesClosedBellanca 14-13 · Warwick, NYApr 28, 1979 · N86725 · Destroyed NTSB NYC77FHJ08Accident · No injuriesClosedStinson 108 · Amityville, NYMar 2, 1978 · N97371 · Substantial damage NTSB NYC77FFJ22Accident · No injuriesClosedStinson 108-1 · Newark, NYMay 18, 1977 · N8193K · Substantial damage NTSB NYC76FFA35Accident · No injuriesClosedStinson 108-1 · Johnstown, NYMay 15, 1976 · N97509 · Substantial damage NTSB NYC76DFJ19Accident · No injuriesClosedStinson 108-1 · Perry, NYMar 26, 1976 · N9015K · Substantial damage NTSB NYC75DFA11Accident · Minor injuriesClosedStinson 108 · Andes, NYOct 5, 1974 · N97370 · Substantial damage NTSB NYC74AN053Accident · Serious injuriesClosedStinson 108-1 · Amityville, NYDec 15, 1973 · N2641 · 2 aircraft · Destroyed NTSB NYC74FFA10Accident · No injuriesClosedStinson 108 · Albany, NYSep 9, 1973 · N97954 · Substantial damage NTSB NYC72FHJ14Accident · No injuriesClosedStinson 108-1 · Deer Park, NYJan 12, 1972 · N8803K · Substantial damage NTSB NYC71FFJ33Accident · No injuriesClosedStinson 108-1 · Skaneateles, NYMay 19, 1971 · N9198K · Substantial damage NTSB NYC71DFA18Accident · No injuriesClosedStinson 108-2 · Heuvelton, NYOct 13, 1970 · N97230 · Substantial damage NTSB NYC70D0129Accident · No injuriesClosedStinson 108 · Poestenkill, NYAug 7, 1969 · N97992 · Substantial damage NTSB NYC70F0013Accident · Serious injuriesClosedStinson 108-1 · Babylon, NYMay 18, 1969 · N8458K · Substantial damage NTSB NYC68F0219Accident · Minor injuriesClosedStinson 108-1 · New Hudson, NYOct 1, 1967 · N97518 · Substantial damage NTSB NYC68D0029Accident · No injuriesClosedStinson 108-1 · Brookhaven, NYApr 9, 1967 · N40182 · Substantial damage NTSB NYC67D0529Accident · No injuriesClosedStinson 108 · Deer Park, NYMar 12, 1967 · N97371 · Substantial damage NTSB NYC67D0254Accident · No injuriesClosedStinson 108 · Richland, NYSep 15, 1966 · N97488 · Substantial damage NTSB NYC67F0069Accident · No injuriesClosedBellanca 14-132 · Old Forge, NYJul 8, 1966 · N74314 · Substantial damage NTSB NYC66F0266Accident · No injuriesClosedStinson 108 · Amherst, NYSep 22, 1965 · N97498 · Substantial damage NTSB NYC65F0112Accident · No injuriesClosedStinson 108 · Weedsport, NYApr 4, 1965 · N97488 · Substantial damage