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 SEA68F0254Accident · No injuriesClosedStinson 108-3 · Yakima, WAMar 13, 1968 · N6116M · Substantial damage NTSB SEA68D0258Accident · No injuriesClosedStinson 108-2 · Seattle, WAFeb 25, 1968 · N250C · Substantial damage NTSB MIA68F0364Accident · No injuriesClosedStinson 108-3 · Belle Glade, FLJan 1, 1968 · N6597M · Substantial damage NTSB OAK68D0263Accident · No injuriesClosedStinson 108-2 · Santa Cruz, CADec 10, 1967 · N9403K · Substantial damage NTSB FTW68D0351Accident · Minor injuriesClosedStinson 108-2 · Houston, TXNov 14, 1967 · N9668K · Substantial damage NTSB MIA68D0246Accident · No injuriesClosedCessna 170 · Kissimmee, FLOct 13, 1967 · N5745C · Substantial damage NTSB UNK67X0159Accident · Minor injuriesClosedStinson 108-3 · Wauchula, FLSep 22, 1967 · N6019M · Substantial damage NTSB MKC68D0226Accident · No injuriesClosedStinson 108-3 · Painton, MOSep 9, 1967 · N625C · Substantial damage NTSB CHI68F0208Accident · No injuriesClosedStinson 108-3 · Flushing, MIAug 28, 1967 · N712C · Substantial damage NTSB ANC68F0057Accident · No injuriesClosedStinson 108-2 · Homer, AKAug 2, 1967 · N480C · Substantial damage NTSB NYC68A0003Accident · 2 fatalClosedStinson 108-3 · Woodstock, CTJul 6, 1967 · N595C · Destroyed NTSB CHI68D0160Accident · No injuriesClosedStinson 108 · Hobart, INJun 30, 1967 · N9788K · Substantial damage NTSB NYC68D0033Accident · No injuriesClosedStinson 108-3 · St.Regis Falls, NYMay 30, 1967 · N6759M · Substantial damage NTSB MIA67D0564Accident · Minor injuriesClosedStinson 108-3 · Satsuma, FLMay 20, 1967 · N6964M · Substantial damage NTSB NYC67F0666Accident · No injuriesClosedStinson 108-2 · Matamoras, PAMay 10, 1967 · N9403K · Substantial damage NTSB FTW67D0473Accident · No injuriesClosedStinson 108 · Abilene, TXMar 26, 1967 · N8012K · Substantial damage NTSB NYC67D0544Accident · No injuriesClosedStinson 108-3 · Spring Valley, NYFeb 27, 1967 · N6961M · Substantial damage NTSB MKC67F0460Accident · Minor injuriesClosedStinson 108-3 · Lincoln, NEFeb 26, 1967 · N831C · Substantial damage NTSB CHI67D0532Accident · No injuriesClosedStinson 108-2 · Clinton, INFeb 2, 1967 · N9276K · Substantial damage NTSB FTW67D0336Accident · No injuriesClosedStinson 108-3 · Houston, TXNov 26, 1966 · N798C · Substantial damage NTSB DEN67D0161Accident · No injuriesClosedBellanca 14-133 · Portales, NMNov 3, 1966 · N6502N · Substantial damage NTSB SEA67D0195Accident · No injuriesClosedStinson 108-3 · Malta, MTOct 19, 1966 · N659C · Substantial damage NTSB MKC67D0265Accident · No injuriesClosedStinson 108-2 · Ely, MNOct 12, 1966 · N9475K · Substantial damage NTSB LAX67D0178Accident · No injuriesClosedStinson 108-3 · Van Nuys, CAOct 8, 1966 · N671C · Substantial damage NTSB OAK67D0146Accident · Minor injuriesClosedStinson 108-2 · Novato, CASep 29, 1966 · N376C · Substantial damage NTSB SEA67D0185Accident · No injuriesClosedStinson 108-2 · Laurel, MTSep 11, 1966 · N967D · Substantial damage NTSB LAX67D0126Accident · No injuriesClosedStinson 108-2 · Baker, CASep 10, 1966 · N479C · Substantial damage NTSB DEN67D0080Accident · Minor injuriesClosedStinson 108-3 · Whites City, NMSep 1, 1966 · N969C · Substantial damage NTSB OAK67D0061Accident · No injuriesClosedStinson 108 · Crescent City, CAAug 10, 1966 · N6356M · Substantial damage NTSB MIA67D0121Accident · No injuriesClosedStinson 108-3 · Wauchula, FLAug 3, 1966 · N6944M · Substantial damage NTSB SEA67F0104Accident · No injuriesClosedStinson 108-3 · Portland, ORJul 13, 1966 · N6238M · Destroyed NTSB CHI67F0090Accident · Minor injuriesClosedStinson 108 · Mishawaka, INJul 10, 1966 · N4002C · Substantial damage NTSB CHI67D0219Accident · No injuriesClosedStinson 108 · Grays Lake, ILJul 10, 1966 · N39468 · Substantial damage NTSB OAK67D0029Accident · No injuriesClosedStinson 108-2 · Goodsprings, NVJun 18, 1966 · N382C · Substantial damage NTSB DEN66D0323Accident · Minor injuriesClosedBellanca 14-13 · Questa, NMJun 4, 1966 · N66324 · Substantial damage NTSB FTW66F0686Accident · No injuriesClosedStinson 108-2 · Shreveport, LAJun 3, 1966 · N8012K · Substantial damage NTSB NYC66F0646Accident · No injuriesClosedStinson 108-2 · Deer Park, NYMay 3, 1966 · N8070K · Substantial damage NTSB ANC66A0037Accident · 1 fatalClosedStinson 108-2 · Anchorage, AKApr 18, 1966 · N9278K · Destroyed NTSB ANC66D0102Accident · No injuriesClosedStinson 108-2 · Nondalton, AKApr 13, 1966 · N9297K · Substantial damage NTSB SEA66D0236Accident · No injuriesClosedStinson 6A · Burley, IDMar 26, 1966 · N9718K · Substantial damage NTSB NYC66D0445Accident · No injuriesClosedStinson 108-3 · Hartford, CTJan 11, 1966 · N4213C · Substantial damage NTSB CHI66A0060Accident · 3 fatalClosedPiper PA-23 · Knox, INDec 19, 1965 · N1100P · 2 aircraft · Destroyed NTSB CHI66D0436Accident · Minor injuriesClosedStinson 108-3 · Portage, WIOct 24, 1965 · N1000M · Substantial damage NTSB NYC66F0227Accident · No injuriesClosedStinson 108-2 · Franklin, PASep 6, 1965 · N964D · Substantial damage NTSB NYC66F0235Accident · Minor injuriesClosedStinson 108-2 · Oak Hill, WVSep 4, 1965 · N9429K · Substantial damage NTSB CHI66F0215Accident · No injuriesClosedStinson 108 · St Helen, MIAug 30, 1965 · N97226 · Substantial damage NTSB ANC66D0028Accident · No injuriesClosedStinson 108-3 · Gold King, AKAug 30, 1965 · N6629M · Substantial damage NTSB CHI66F0181Accident · No injuriesClosedStinson 108-3 · Springfield, ILAug 12, 1965 · N726C · Substantial damage NTSB NYC66F0188Accident · No injuriesClosedStinson 108-3 · Amherst, NYJul 18, 1965 · N860C · Substantial damage NTSB MKC66D0079Accident · No injuriesClosedStinson 108-3 · Branson, MOJun 20, 1965 · N6082M · Substantial damage