Skip to content

NTSB investigations: Franklin 6A4150 series

421 cases on aircraft whose registry engine model is Franklin 6A4150 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 ('27024')) 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 ('27024'))
  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 ('27024'))
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 OAK66A0060Accident · 2 fatalClosedStinson 108-1 · Samoa, CAJun 27, 1966 · N9225K · Destroyed NTSB UNK66X0152Accident · No injuriesClosedBellanca 14-132 · Scum Lake, CanadaJun 25, 1966 · N74414 · Substantial damage NTSB MIA67F0095Accident · Serious injuriesClosedStinson 108-2 · Atlanta, GAJun 12, 1966 · N40155 · Destroyed NTSB CHI67F0007Accident · Minor injuriesClosedStinson 108-1 · Kenoska, WIJun 1, 1966 · N9055K · Substantial damage NTSB SEA66D0288Accident · No injuriesClosedBellanca 14-13 · Boulder, MTMay 21, 1966 · N86916 · Substantial damage NTSB DEN66F0332Accident · No injuriesClosedBellanca 14-13 · Mexican Hat, UTMay 15, 1966 · N86825 · Substantial damage NTSB LAX66D0343Accident · No injuriesClosedBellanca 14-13 · Needles, CAMay 1, 1966 · N86718 · Substantial damage NTSB CHI66F0760Accident · No injuriesClosedStinson 108-1 · Walbridge, OHMay 1, 1966 · N97510 · Substantial damage NTSB MKC66F0489Accident · Minor injuriesClosedStinson 108-1 · Waynesville, MOMar 31, 1966 · N8153K · Destroyed NTSB SEA66A0048Accident · 1 fatalClosedStinson 108 · Port Angeles, WAMar 21, 1966 · N8930K · No damage NTSB NYC66D0551Accident · No injuriesClosedStinson 108-1 · Mohrsville, PAMar 20, 1966 · N97870 · Substantial damage NTSB DEN66D0259AccidentClosedStinson 108 · Buckeye, AZMar 17, 1966 · N9147K · Substantial damage NTSB OAK66D0226Accident · No injuriesClosedBellanca 14-13 · Lake Tahoe, CAMar 13, 1966 · N86831 · Substantial damage NTSB MIA66D0472Accident · No injuriesClosedStinson 108 · Merritt Is, FLMar 8, 1966 · N97806 · Substantial damage NTSB CHI66F0594Accident · No injuriesClosedStinson 108-1 · Sparta, MIFeb 26, 1966 · N8437K · Substantial damage NTSB SEA66F0194Accident · Minor injuriesClosedStinson 108-1 · Springfield, ORDec 28, 1965 · N8641K · Substantial damage NTSB SEA66D0195Accident · No injuriesClosedBellanca 14-13 · Billings, MTDec 9, 1965 · N86720 · Substantial damage NTSB LAX66D0233Accident · No injuriesClosedStinson 108 · Hemet, CADec 6, 1965 · N97648 · Substantial damage NTSB DEN66F0172Accident · No injuriesClosedStinson 108 · Sandy, UTNov 20, 1965 · N9168K · Substantial damage NTSB NYC66F0376Accident · No injuriesClosedBellanca 14-13 · Somerset, PAOct 31, 1965 · N74392 · Substantial damage NTSB MIA66F0299Accident · No injuriesClosedStinson 108-1 · Plantation, FLOct 17, 1965 · N8472K · Substantial damage NTSB NYC66F0293Accident · No injuriesClosedStinson 108-1 · Westfield, MAOct 8, 1965 · N97376 · Substantial damage NTSB CHI66F0329Accident · No injuriesClosedStinson 108-1 · Grand Rapids, MISep 28, 1965 · N8220K · Substantial damage NTSB NYC66F0259Accident · No injuriesClosedStinson 108 · Ocean City, MDSep 26, 1965 · N9209K · Substantial damage NTSB NYC66F0266Accident · No injuriesClosedStinson 108 · Amherst, NYSep 22, 1965 · N97498 · Substantial damage NTSB MKC66F0204Accident · No injuriesClosedStinson 108-1 · Derby, KSAug 28, 1965 · N97048 · Substantial damage NTSB FTW66D0271Accident · No injuriesClosedStinson 108-1 · Houston, TXAug 25, 1965 · N312C · Destroyed NTSB CHI66D0190Accident · No injuriesClosedStinson 108-1 · Youngstown, OHAug 6, 1965 · N8715K · Substantial damage NTSB SEA66D0114Accident · No injuriesClosedStinson 108 · Sultan, WAJul 30, 1965 · N8760K · Substantial damage NTSB MIA66D0430Accident · No injuriesClosedBellanca 14-13 · Palatka, FLJul 25, 1965 · N74485 · Substantial damage NTSB CHI66D0183Accident · Minor injuriesClosedStinson 108 · Put In Bay, OHJul 3, 1965 · N8173K · Destroyed NTSB NYC66D0052Accident · No injuriesClosedStinson 108-1 · Bridgeville, PAMay 16, 1965 · N8914K · Substantial damage NTSB NYC65F0238Accident · No injuriesClosedStinson 108 · Kingwood, WVMay 16, 1965 · N97709 · Destroyed NTSB LAX66F0039Accident · No injuriesClosedBellanca 14-13 · Banning, CAMay 16, 1965 · N74450 · Substantial damage NTSB MKC65F0140Accident · No injuriesClosedStinson 108-1 · Hugoton, KSMay 15, 1965 · N8334K · Substantial damage NTSB CHI65F0144Accident · No injuriesClosedBellanca 14-13 · Orient, OHMay 8, 1965 · N86861 · Substantial damage NTSB DEN65D0071Accident · No injuriesClosedStinson 108 · Worland, WYApr 24, 1965 · N97328 · Substantial damage NTSB NYC65F0116Accident · No injuriesClosedStinson 108-2 · Allentown, PAApr 11, 1965 · N386C · Substantial damage NTSB CHI65D0122Accident · No injuriesClosedStinson 108-1 · Chagrin Falls, OHApr 10, 1965 · N8514K · Substantial damage NTSB NYC65F0112Accident · No injuriesClosedStinson 108 · Weedsport, NYApr 4, 1965 · N97488 · Substantial damage NTSB FTW66F0009Accident · No injuriesClosedStinson 108-1 · Texarkana, ARMar 14, 1965 · N8755K · Substantial damage NTSB UNK65X1025Accident · No injuriesClosedStinson 108-1 · Groveland, FLDec 16, 1964 · N8645K · Substantial damage NTSB UNK65X1020Accident · No injuriesClosedBellanca 14-13 · Lexington, MADec 15, 1964 · N86803 · Destroyed NTSB UNK65X0792Accident · No injuriesClosedStinson 108 · Emporia, KSNov 22, 1964 · N97350 · Substantial damage NTSB UNK65X0655Accident · No injuriesClosedStinson 108-1 · Painesville, OHNov 11, 1964 · N97761 · Substantial damage NTSB UNK64X3867Accident · No injuriesClosedBeechcraft C18 · Brownsburg, INSep 7, 1964 · N44569 · 2 aircraft · Minor damage NTSB UNK64X3851Accident · No injuriesClosedBellanca 14132 · Valparaiso, INSep 7, 1964 · N74388 · Substantial damage NTSB UNK64X3643Accident · No injuriesClosedBellanca 1412 · Columbia, CAAug 28, 1964 · N25312 · Substantial damage NTSB UNK64X3552Accident · No injuriesClosedStinson 108 · Aliquippa, PAAug 23, 1964 · N8320K · Substantial damage NTSB UNK64X3538Accident · No injuriesClosedStinson 108 · Marion, IAAug 22, 1964 · N97656 · Substantial damage