Skip to content

NTSB investigations: Franklin 6A4165 series

438 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, newest first

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 ('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.\"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."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 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 NTSB MIA65F0089Accident · No injuriesClosedStinson 108-3 · Pink Hill, NCApr 22, 1965 · N6302M · Substantial damage NTSB NYC65F0140Accident · Minor injuriesClosedStinson 108-2 · Ashland, VAApr 20, 1965 · N9717K · Destroyed NTSB MKC65F0130Accident · No injuriesClosedStinson 108-3 · St Paul, MNMar 21, 1965 · N653C · Substantial damage NTSB NYC65F0059Accident · Minor injuriesClosedStinson 108-2 · Rocky Hill, NJMar 14, 1965 · N9622K · Substantial damage NTSB NYC65F0072Accident · No injuriesClosedStinson 108-3 · Clinton, MDMar 1, 1965 · N6756M · Minor damage NTSB CHI65F0056Accident · No injuriesClosedStinson 108-2 · Hinsdale, ILFeb 20, 1965 · N9712K · Substantial damage NTSB UNK65X1436Accident · No injuriesClosedStinson 108-2 · Columbus, GAFeb 19, 1965 · N8019K · Substantial damage NTSB UNK65X1236Accident · No injuriesClosedStinson 108-2 · Tulare, CAJan 6, 1965 · N382C · Substantial damage NTSB UNK65X1224Accident · No injuriesClosedStinson 108 · Fallon, NVJan 3, 1965 · N6322M · Substantial damage NTSB UNK65X0507Accident · No injuriesClosedStinson 108-3 · Plympton, MANov 1, 1964 · N4145C · Substantial damage NTSB UNK65X0476Accident · No injuriesClosedStinson 108 · Panama City, FLOct 29, 1964 · N399C · Substantial damage NTSB UNK65X0464Accident · No injuriesClosedStinson 108-3 · Glacier, MTOct 28, 1964 · N4161C · Substantial damage NTSB UNK64X4157Accident · No injuriesClosedStinson 1082 · Hillsboro, ORSep 26, 1964 · N9351K · Substantial damage NTSB UNK64X3844Accident · No injuriesClosedStinson 108-2 · San Lucas, CASep 7, 1964 · N975D · Substantial damage NTSB UNK64X3822Accident · No injuriesClosedStinson 108-1 · Ardmore, OKSep 6, 1964 · N8149K · Substantial damage NTSB UNK64X3783Accident · No injuriesClosedStinson 108-3 · Tolland, CTSep 5, 1964 · N687C · Substantial damage NTSB UNK64X3517Accident · No injuriesClosedStinson 108-2 · Des Moines, IAAug 21, 1964 · N9478K · Substantial damage NTSB UNK64X3044Accident · No injuriesClosedStinson 108-2 · Woonsocket, RIJul 26, 1964 · N875D · Substantial damage NTSB UNK64X2921Accident · No injuriesClosedStinson 108-2 · Cheyenne, WYJul 19, 1964 · N288C · Substantial damage NTSB UNK64X2651Accident · Minor injuriesClosedBoeing A75 · Corcoran, CAJul 4, 1964 · N53229 · 2 aircraft · Substantial damage NTSB UNK64X2173Accident · Minor injuriesClosedStinson 108-3 · Solon Springs, WIJun 7, 1964 · N644C · Destroyed NTSB UNK64X2161Accident · 1 fatalClosedBellanca 14-132 · San Pedro, CAJun 6, 1964 · N74371 · Destroyed NTSB UNK64X1944Accident · No injuriesClosedStinson 108-3 · Ninilchik, AKMay 24, 1964 · N6637M · Substantial damage NTSB UNK64X1875Accident · Minor injuriesClosedStinson 108-3 · Isabelle, MNMay 22, 1964 · N6937M · Substantial damage NTSB UNK64X1799Accident · No injuriesClosedStinson 108 · El Monte, CAMay 17, 1964 · N6206M · Substantial damage NTSB UNK64X1786Accident · No injuriesClosedStinson 108-3 · Burlington, IAMay 16, 1964 · N6103M · Substantial damage NTSB UNK64X1769Accident · Serious injuriesClosedStinson 108 · Uniontown, PAMay 14, 1964 · N9712F · Destroyed NTSB UNK64X1670Accident · No injuriesClosedStinson 108-3 · Lindenhurst, NYMay 8, 1964 · N6100M · Substantial damage NTSB UNK64X1318Accident · No injuriesClosedStinson 108-3 · Pendleton, NYApr 14, 1964 · N6875M · Substantial damage NTSB UNK64X1277Accident · No injuriesClosedStinson 108 · Redding, CAApr 12, 1964 · N418C · Substantial damage NTSB UNK64X1155Accident · No injuriesClosedStinson 108 2 · Gr Barrington, MAApr 4, 1964 · N970D · Destroyed NTSB UNK64X0886Accident · No injuriesClosedStinson 1082 · Orlando, FLMar 11, 1964 · N8049K · Substantial damage NTSB UNK64X0835Accident · No injuriesClosedStinson 108-3 · Punxtawney, PAMar 7, 1964 · N6829M · Substantial damage NTSB UNK64X0634Accident · No injuriesClosedStinson 108-2 · Federal Way, WAFeb 21, 1964 · N9613K · Substantial damage NTSB UNK64X0446Accident · No injuriesClosedStinson 108-2 · San Jose, CAFeb 2, 1964 · N9553K · Substantial damage NTSB UNK64X0413Accident · Minor injuriesClosedStinson 108-3 · Silver City, NCJan 31, 1964 · N651C · Substantial damage