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 FTW71DPJ39Accident · No injuriesClosedStinson 108-3 · Shattuck, OKApr 9, 1971 · N6946M · Substantial damage NTSB SEA71FDA15Accident · No injuriesClosedStinson 108-2 · Alzada, MTMar 19, 1971 · N171C · Substantial damage NTSB MIA71AM079Accident · 1 fatalClosedStinson 108-3 · W.Palm Beach, FLFeb 25, 1971 · N6387M · Destroyed NTSB FTW71FPA20Accident · No injuriesClosedStinson 108-3 · Midlothian, TXDec 21, 1970 · N910C · Substantial damage NTSB LAX71FUA33Accident · Minor injuriesClosedStinson 108-3 · Torrance, CADec 13, 1970 · N6927M · Substantial damage NTSB CHI71FBJ32Accident · Minor injuriesClosedStinson 108-2 · Greenville, MIOct 7, 1970 · N9418K · Substantial damage NTSB DEN71FQA16Accident · No injuriesClosedStinson 108-2 · Espanola, NMSep 30, 1970 · N9558K · Substantial damage NTSB CHI72DDJ17Accident · Minor injuriesClosedStinson 108-3 · Bruce, WISep 20, 1970 · N960C · Substantial damage NTSB SEA71FDG13Accident · No injuriesClosedCessna 170A · Fort Benton, MTSep 14, 1970 · N9543A · Substantial damage NTSB MKC71DDD06Accident · No injuriesClosedStinson 108-3 · Detroit Lks, MNAug 15, 1970 · N737C · Substantial damage NTSB MKC71DCG19Accident · No injuriesClosedStinson 108 · Ethel, MOAug 15, 1970 · N8040K · Substantial damage NTSB NYC71FFJ02Accident · Serious injuriesClosedStinson 108-3 · Jamestown, NYJul 29, 1970 · N739C · Destroyed NTSB CHI71FDW07Accident · No injuriesClosedStinson 108-3 · Drayton Plns, MIJul 13, 1970 · N6208M · Substantial damage NTSB IAD71FIG04Accident · Serious injuriesClosedStinson 108-3 · Springfield, WVJul 12, 1970 · N4207C · Destroyed NTSB CHI70FDW14Accident · No injuriesClosedStinson 108-3 · Flushing, MIMay 20, 1970 · N712C · Substantial damage NTSB LAX70DVA13Accident · No injuriesClosedStinson 108-3 · Bakersfield, CAMay 3, 1970 · N6308M · Substantial damage NTSB SEA70DXM05Accident · Serious injuriesClosedStinson 108 · Rexburg, IDFeb 22, 1970 · N9527K · Substantial damage NTSB FTW70D0282Accident · No injuriesClosedStinson 108-2 · Fayetteville, AROct 27, 1969 · N444C · Substantial damage NTSB MKC70D0226Accident · No injuriesClosedStinson 108-3 · St.Charles, MOSep 21, 1969 · N6545M · Substantial damage NTSB ANC70A0025Accident · 2 fatalClosedStinson 108-2 · Kenai, AKSep 14, 1969 · N480C · Destroyed NTSB MKC70D0144Accident · No injuriesClosedStinson 108-3 · Mcgregor, IAAug 12, 1969 · N6427M · Substantial damage NTSB DIA70F0039Accident · Minor injuriesClosedBellanca 14-13 · Vally Chapel, WVAug 4, 1969 · N74294 · Substantial damage NTSB MKC70D0043Accident · Minor injuriesClosedStinson 108-2 · Papillion, NEJul 3, 1969 · N9447K · Substantial damage NTSB NYC70D0005Accident · Minor injuriesClosedStinson 108-2 · Red Bank, NJMay 30, 1969 · N9344K · Substantial damage NTSB CHI70F0018Accident · No injuriesClosedStinson 108-2 · Peoria, ILMay 21, 1969 · N130C · Substantial damage NTSB SEA69D0261Accident · No injuriesClosedStinson 108-2 · Bellevue, WAMay 15, 1969 · N9714K · Substantial damage NTSB CHI69D0628Accident · No injuriesClosedStinson 108-2 · Lombard, ILApr 30, 1969 · N9837K · Substantial damage NTSB FTW69F0494Accident · No injuriesClosedBellanca 14-13 · Mountain Home, ARApr 20, 1969 · N6502N · Substantial damage NTSB OAK69D0279Accident · No injuriesClosedStinson 108-2 · Clarksburg, CAMar 29, 1969 · N9443K · Substantial damage NTSB DEN69D0195Accident · No injuriesClosedStinson 108-3 · Albuquerque, NMMar 9, 1969 · N6656M · Substantial damage NTSB CHI69D0499Accident · Minor injuriesClosedStinson 108 · Laurel, INFeb 26, 1969 · N4147C · Substantial damage NTSB CHI69D0486Accident · No injuriesClosedStinson 108-2 · Superior, WIFeb 13, 1969 · N962D · Substantial damage NTSB LAX69D0238Accident · Minor injuriesClosedStinson 108-3 · Mortmar, CAJan 4, 1969 · N6902M · Substantial damage NTSB MIA69F0324Accident · No injuriesClosedStinson 108-3 · Gainesville, FLDec 7, 1968 · N6771M · Substantial damage NTSB MKC69D0256Accident · No injuriesClosedStinson 108-3 · Hill City, KSOct 27, 1968 · N856C · Substantial damage NTSB MKC69D0255Accident · No injuriesClosedStinson 108-3 · Beaumont, KSOct 26, 1968 · N6676M · Substantial damage NTSB SEA69D0113Accident · No injuriesClosedStinson 108-3 · Gooding, IDOct 13, 1968 · N4017C · Substantial damage NTSB DEN69F0122Accident · Minor injuriesClosedStinson 108-2 · Aurora, COSep 19, 1968 · N8096K · Destroyed NTSB NYC69D0183Accident · No injuriesClosedStinson 108-3 · Dublin, PASep 7, 1968 · N6866M · Substantial damage NTSB CHI69F0233Accident · Minor injuriesClosedStinson 108-2 · Baraboo, WISep 7, 1968 · N333C · Substantial damage NTSB DEN69D0088Accident · Minor injuriesClosedStinson 108-2 · Aurora, COAug 9, 1968 · N8124K · Substantial damage NTSB SEA69D0062Accident · No injuriesClosedStinson 108-1 · Warden, WAAug 6, 1968 · N9105K · Substantial damage NTSB MKC69F0093Accident · Minor injuriesClosedStinson 108-3 · Grassy Bute, NDJul 24, 1968 · N891C · Substantial damage NTSB CHI69F0024Accident · No injuriesClosedStinson 108-3 · Petersburg, MIJun 24, 1968 · N6428M · Substantial damage NTSB MIA69F0073Accident · Serious injuriesClosedStinson 108-3 · Kennesaw, GAJun 16, 1968 · N635C · Substantial damage NTSB CHI69F0026Accident · Minor injuriesClosedStinson 108-3 · Flushing, MIJun 15, 1968 · N980C · Substantial damage NTSB CHI69D0015Accident · No injuriesClosedStinson 108-2 · Burkhardt, WIMay 31, 1968 · N9472K · Substantial damage NTSB CHI68F0765Accident · No injuriesClosedStinson 108-3 · Belleville, MIMay 17, 1968 · N4120C · Substantial damage NTSB FTW68F0584Accident · No injuriesClosedStinson 108-2 · Alexandria, LAMay 5, 1968 · N361C · Substantial damage NTSB NYC68F0414Accident · Minor injuriesClosedStinson 108-3 · Warren, PAMar 31, 1968 · N6686M · Destroyed