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 SEA79DYA05Accident · No injuriesClosedStinson 108-3 · Smiths Prairie, IDDec 5, 1978 · N783C · Substantial damage NTSB LAX79FUQ07AccidentClosedBellanca 1413-2 · San Fernando, CADec 5, 1978 · N74459 · Substantial damage NTSB OAK78DVD06Accident · No injuriesClosedStinson 108-3 · Concord, CANov 23, 1978 · N965C · Substantial damage NTSB ANC78DAA38Accident · Minor injuriesClosedStinson 108-2 · Totatlanika Rv, AKAug 31, 1978 · N374C · Substantial damage NTSB LAX78FUA25Accident · No injuriesClosedStinson 108-3 · Long Beach, CAAug 15, 1978 · N4108C · Substantial damage NTSB SEA78FA053Accident · 1 fatalClosedStinson 108E · Enumclaw, WAAug 10, 1978 · N4122C · Destroyed NTSB MKC78FTK31Accident · No injuriesClosedStinson 108-3 · Miller, SDAug 6, 1978 · N6854M · Substantial damage NTSB SEA78FYM45Accident · No injuriesClosedStinson 108-3 · The Dalles, ORJul 9, 1978 · N4050C · Substantial damage NTSB MKC78DER40Accident · No injuriesClosedStinson 108-2 · Minneapolis, MNJun 15, 1978 · N916D · Substantial damage NTSB LAX78DUJ57Accident · Minor injuriesClosedStinson 108-3 · Camp Verde, AZMay 20, 1978 · N665C · Substantial damage NTSB SEA78DYE18Accident · No injuriesClosedStinson 108-1 · Bremerton, WAApr 23, 1978 · N8136K · Substantial damage NTSB DEN78FTM17Accident · Minor injuriesClosedStinson 108-2 · Vernal, UTApr 8, 1978 · N328C · Substantial damage NTSB DEN78DDQ15Accident · No injuriesClosedStinson 108-3 · Las Cruces, NMApr 2, 1978 · N811C · Substantial damage NTSB OAK78DVM13Accident · Minor injuriesClosedStinson 108-3 · Carmel Valley, CAMar 18, 1978 · N6930M · Substantial damage NTSB ANC78DAG32Accident · No injuriesClosedStinson 108-2 · Wasilla, AKMar 17, 1978 · N143C · Substantial damage NTSB CHI78DEX13Accident · No injuriesClosedStinson 108-2 · Connersville, INFeb 26, 1978 · N9451K · Substantial damage NTSB ANC78FAG26Accident · Minor injuriesClosedStinson 108-2 · Glenallen, AKFeb 21, 1978 · N9542K · Substantial damage NTSB CHI78FEC19Accident · No injuriesClosedStinson 108-3 · Fraser, MIFeb 19, 1978 · N6042M · Substantial damage NTSB FTW78DQD04Accident · No injuriesClosedStinson 108-1 · Marfa, TXNov 19, 1977 · N8553K · Substantial damage NTSB OAK77DVA56Accident · No injuriesClosedStinson 108 · Groveland, CASep 17, 1977 · N9825K · Substantial damage NTSB NYC77FNC55Accident · No injuriesClosedStinson 108-3 · Saco, MESep 11, 1977 · N6678M · Substantial damage NTSB MIA77FK030Accident · No injuriesClosedStinson 108-3 · Quitman, MSAug 14, 1977 · N6509M · Substantial damage NTSB ANC77FA066Accident · 5 fatalClosedCessna 170-A · Portage Pass, AKJul 30, 1977 · N9543A · Destroyed NTSB NYC77FNA30Accident · No injuriesClosedStinson 108-3 · Marshfield, MAJul 27, 1977 · N584C · Substantial damage NTSB ANC77DAA37Accident · No injuriesClosedStinson 108 · Kotzebue, AKJul 23, 1977 · N696C · Substantial damage NTSB ANC77DAA36Accident · No injuriesClosedStinson 108 · Northway, AKJul 6, 1977 · N8270K · Substantial damage NTSB MKC77DTK25Accident · No injuriesClosedStinson 108-2 · Ft Thompson, SDJun 11, 1977 · N392C · Substantial damage NTSB IAD77FIA11Accident · Minor injuriesClosedStampe SV4C · Bealeton, VAApr 8, 1977 · N47SV · Destroyed NTSB DEN77DTC07Accident · No injuriesClosedStinson 108-2 · Laramie, WYMar 12, 1977 · N992D · Substantial damage NTSB MKC77FCD07Accident · No injuriesClosedStinson 108 · Griswold, IAJan 7, 1977 · N8035K · Substantial damage NTSB ANC76DAA69Accident · No injuriesClosedStinson 108-3 · Nenana, AKOct 28, 1976 · N4205C · Substantial damage NTSB DEN76FQA64Accident · Minor injuriesClosedStinson 108-3 · Albuquerque, NMSep 25, 1976 · N6577M · Substantial damage NTSB CHI76FEC64Accident · No injuriesClosedStinson 108-3 · Deckerville, MISep 18, 1976 · N6108M · Substantial damage NTSB DEN76FTE95Accident · No injuriesClosedStinson 108-2 · Peyton, COSep 6, 1976 · N9320K · Substantial damage NTSB CHI76FEM58Accident · No injuriesClosedStinson 108-3 · Cedar Springs, MISep 5, 1976 · N6580M · Substantial damage NTSB MKC76FCJ62Accident · No injuriesClosedStinson 108-2 · Mccook, NEAug 6, 1976 · N9661K · Substantial damage NTSB IAD76FLJ32Accident · No injuriesClosedStinson 108 · Durham, NCJul 27, 1976 · N9432K · Substantial damage NTSB CHI76FEK17Accident · No injuriesClosedStinson 108-3 · Delaware, OHJun 2, 1976 · N6898M · Substantial damage NTSB NYC76DNA39Accident · No injuriesClosedStinson 108-3 · Oak Bluffs, MAMay 23, 1976 · N6275M · Substantial damage NTSB FTW76DPD39Accident · No injuriesClosedStinson 108-3 · Vernon, TXMay 4, 1976 · N646C · Substantial damage NTSB CHI76FEI27Accident · No injuriesClosedUniv Acft 108-2 · Thompson, OHApr 7, 1976 · N442C · Substantial damage NTSB ANC76FAA29Accident · Serious injuriesClosedStinson 108-3 · Koyuk, AKMar 21, 1976 · N6946M · Substantial damage NTSB ANC76DAG87Accident · No injuriesClosedStinson 108 · Willow, AKFeb 1, 1976 · N691C · Substantial damage NTSB IAD76FIG07Accident · Minor injuriesClosedStinson 108 · Davidsonville, MDNov 29, 1975 · N9520K · Substantial damage NTSB ANC76DAG56Accident · No injuriesClosedStinson 108-2 · Gulkana, AKOct 17, 1975 · N9462K · Substantial damage NTSB NYC76AN037Accident · 1 fatalClosedStinson 108-3 · Chenamgo Brg, NYSep 28, 1975 · N6729M · Destroyed NTSB OAK76DXQ13Accident · No injuriesClosedStinson 108-3 · Winnemucca, NVSep 1, 1975 · N6355M · Substantial damage NTSB OAK76DVG24Accident · Minor injuriesClosedStinson 108-3 · Walnut Grove, CAAug 29, 1975 · N6768M · Substantial damage NTSB NYC76DNC08Accident · Minor injuriesClosedStinson 108 · Bangor, MEAug 10, 1975 · N9368K · Substantial damage NTSB OAK75DVM38Accident · No injuriesClosedStinson 108-2 · Morgan Hill, CAJun 20, 1975 · N9502K · Substantial damage