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 LAX75DUJ90Accident · No injuriesClosedStinson 108-3 · Tucson, AZJun 7, 1975 · N871C · Substantial damage NTSB NYC75FHM21Accident · Minor injuriesClosedStinson 108-3 · Teterboro, NJMay 28, 1975 · N6961M · Substantial damage NTSB CHI75DEP49Accident · No injuriesClosedStinson 108-3 · Sturtevant, WIApr 10, 1975 · N508C · Substantial damage NTSB CHI75FEP41Accident · No injuriesClosedStinson 108-2 · Dodgeville, WIMar 2, 1975 · N9401K · Substantial damage NTSB FTW75FQG33Accident · Minor injuriesClosedStinson 108-3 · Plains, TXNov 27, 1974 · N6192M · Substantial damage NTSB CHI75FEV12Accident · No injuriesClosedStinson 108 · Savoy, ILNov 12, 1974 · N596C · Substantial damage NTSB CHI75FEC07Accident · No injuriesClosedStinson 108 · Dansville, MIJul 29, 1974 · N9805K · Substantial damage NTSB MKC75FCG02Accident · Minor injuriesClosedStinson 108-3 · Harrisonville, MOJul 14, 1974 · N6782M · Substantial damage NTSB MIA74DKJ30Accident · No injuriesClosedStinson 108 · Dothan, ALApr 7, 1974 · N925D · Substantial damage NTSB CHI74DEM42Accident · Minor injuriesClosedStinson 108 · Grant, MIMar 19, 1974 · N97226 · Substantial damage NTSB MKC74DCD23Accident · No injuriesClosedStinson 108 · Sheldon, IAMar 5, 1974 · N6688M · Substantial damage NTSB LAX74DUG33Accident · No injuriesClosedStinson 108-3 · Apple Vally, CADec 23, 1973 · N6206M · Substantial damage NTSB FTW74DPD32Accident · No injuriesClosedStinson 108 · Mineral Wells, TXDec 12, 1973 · N8406K · Substantial damage NTSB DEN74DTE29Accident · No injuriesClosedStinson 108-3 · Kiowa, CONov 11, 1973 · N6656M · Substantial damage NTSB MKC74FER19Accident · No injuriesClosedStinson 108-3 · Blaine, MNNov 8, 1973 · N4028C · Substantial damage NTSB ANC74FAA08Accident · No injuriesClosedStinson 108-2 · North Pole, AKAug 26, 1973 · N9525K · Substantial damage NTSB ANC74FAA04Accident · No injuriesClosedStinson 108-2 · North Pole, AKAug 20, 1973 · N9743K · Substantial damage NTSB MIA74DLD01Accident · No injuriesClosedStinson 108-3 · Ft.Pierce, FLJul 4, 1973 · N6954M · Substantial damage NTSB ANC73FAA25Accident · No injuriesClosedStinson 108-3 · Fairbanks, AKJun 3, 1973 · N6177M · Substantial damage NTSB MKC73FTK16Accident · No injuriesClosedStinson 108-3 · Pierre, SDMay 8, 1973 · N6402M · Substantial damage NTSB CHI73FEA31Accident · No injuriesClosedStinson 108-3 · Carmel, INApr 5, 1973 · N747C · Substantial damage NTSB SEA73DYA16Accident · Minor injuriesClosedStinson 108-3 · New Meadows, IDFeb 3, 1973 · N771C · Substantial damage NTSB ANC73FAG73Accident · Minor injuriesClosedStinson 108-3 · Soldotna, AKJan 10, 1973 · N4205C · Substantial damage NTSB CHI73FEC18Accident · No injuriesClosedStinson 108-3 · Brighton, MIDec 17, 1972 · N6769M · Substantial damage NTSB MKC73DCD38Accident · No injuriesClosedStinson 108-3 · Mason City, IANov 5, 1972 · N4097C · Substantial damage NTSB SEA73DYG16Accident · No injuriesClosedStinson 108-2 · Republic, WAOct 23, 1972 · N201C · Substantial damage NTSB SEA73FYG08Accident · Serious injuriesClosedStinson 108-2 · Asotin, WAAug 3, 1972 · N9572K · Destroyed NTSB OAK73FVD03Accident · Minor injuriesClosedStinson 108-2 · Concord, CAJul 14, 1972 · N9870K · Substantial damage NTSB FTW72FPM30Accident · Serious injuriesClosedStinson 108-2 · Catoosa, OKMay 12, 1972 · N395C · Substantial damage NTSB NYC72FNC42Accident · Serious injuriesClosedStinson 108-3 · Princeton, MEApr 30, 1972 · N6070M · Substantial damage NTSB LAX72DUJ96Accident · No injuriesClosedStinson 108-3 · Pierce Fery, AZApr 30, 1972 · N817C · Substantial damage NTSB OAK72DVD40Accident · No injuriesClosedStinson 108-3 · Oakland, CAApr 18, 1972 · N6295M · Substantial damage NTSB MKC72FER47Accident · No injuriesClosedStinson 108-2 · Rosemont, MNMar 18, 1972 · N9256K · Substantial damage NTSB DEN72DTE58Accident · No injuriesClosedStinson 108-3 · Lamar, COFeb 13, 1972 · N160C · Substantial damage NTSB MIA72DKT55Accident · No injuriesClosedStinson 108-2 · Marco Island, FLFeb 12, 1972 · N184C · Substantial damage NTSB NYC72FHM26Accident · No injuriesClosedStinson 108 · Morganville, NJJan 22, 1972 · N745C · Substantial damage NTSB NYC72FNC21Incident · 1 fatalClosedStinson 108-3 · Princeton, MEJan 7, 1972 · N6070M · Minor damage NTSB NYC72AN070Accident · 3 fatalClosedCessna 170B · Fallston, PANov 28, 1971 · N2535D · 2 aircraft · Destroyed NTSB NYC72AN024Accident · No injuriesClosedCessna 150K · Frederick, MDAug 13, 1971 · N6273G · 2 aircraft · Minor damage NTSB ANC72FAG41Accident · No injuriesClosedStinson 108-3 · Bethel, AKAug 12, 1971 · N6031M · Substantial damage NTSB SEA72FYA01Accident · No injuriesClosedStinson 108-3 · Boise, IDJul 17, 1971 · N6392M · Substantial damage NTSB MIA72FLA03Accident · No injuriesClosedStinson 108-1 · Pensacola, FLJul 14, 1971 · N8861K · Substantial damage NTSB IAD72FIG04Accident · No injuriesClosedStinson 108-3 · Wiley Ford, WVJul 14, 1971 · N936C · Substantial damage NTSB FTW72FPM02Accident · No injuriesClosedBellanca 14-13 · Collinsville, OKJul 10, 1971 · N86754 · Substantial damage NTSB ANC71DAA28Accident · No injuriesClosedStinson 108-2 · Fairbanks, AKMay 26, 1971 · N9743K · Substantial damage NTSB CHI71FEM82Accident · No injuriesClosedStinson 108-3 · Wayland, MIMay 23, 1971 · N717C · Substantial damage NTSB NYC71FFJ34Accident · No injuriesClosedStinson 108-2 · Endicott, NYMay 17, 1971 · N925D · Substantial damage NTSB MKC71FCG63Accident · No injuriesClosedStinson 108-3 · Bahner, MOApr 28, 1971 · N6431M · Substantial damage NTSB LAX71DUG76Accident · No injuriesClosedStinson 108 · Blythe, CAApr 24, 1971 · N926D · Substantial damage NTSB OAK71FXQ34Accident · No injuriesClosedStinson 108-2 · Stead, CAApr 12, 1971 · N228C · Substantial damage