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 MIA80FKJ17Accident · Serious injuriesClosedStinson 108-1 · Irvington, ALFeb 6, 1980 · N8537K · Destroyed NTSB IAD79FKM18Accident · No injuriesClosedStinson 108 · Mooresville, NCJul 4, 1979 · N474C · Substantial damage NTSB DEN79FTC12Accident · No injuriesClosedStinson 108 · Point Of Rocks, WYMay 4, 1979 · N97419 · Substantial damage NTSB NYC79FHM16Accident · Minor injuriesClosedBellanca 14-13 · Warwick, NYApr 28, 1979 · N86725 · Destroyed NTSB LAX79FA029Accident · 2 fatalClosedBellanca 14-13 · Compton, CAFeb 10, 1979 · N86724 · Destroyed NTSB CHI79DEG07Accident · No injuriesClosedStinson 108 · Cincinnati, OHDec 1, 1978 · N97343 · Substantial damage NTSB MIA79DKT05Accident · Serious injuriesClosedStinson 108-1 · Delray Beach, FLOct 18, 1978 · N8472K · Destroyed NTSB CHI78FEM27Accident · No injuriesClosedStinson 108-1 · Lake Ann, MIJul 14, 1978 · N8568K · Substantial damage NTSB CHI78FEC24Accident · No injuriesClosedStinson 108-1 · Pontiac, MIApr 2, 1978 · N97876 · Substantial damage NTSB NYC77FHJ08Accident · No injuriesClosedStinson 108 · Amityville, NYMar 2, 1978 · N97371 · Substantial damage NTSB SEA78DYP11Accident · No injuriesClosedStinson 108 · Mead, WAFeb 6, 1978 · N97675 · Substantial damage NTSB IAD78DA042Accident · 1 fatalClosedStinson 108 · Ocean City, MDJan 27, 1978 · N8980K · Destroyed NTSB MKC78DER05Accident · No injuriesClosedStinson 108-1 · Alexandria, MNOct 16, 1977 · N97834 · Substantial damage NTSB ANC77DAH01Accident · Serious injuriesClosedStinson 108 · Anchorage, AKAug 20, 1977 · N97426 · Substantial damage NTSB LAX77FUJ78Accident · 3 fatalClosedBellanca 14-13 · Mesa, AZAug 7, 1977 · N86769 · Destroyed NTSB MIA77FKG61Accident · No injuriesClosedStinson 108-1 · Stanfordville, GAAug 4, 1977 · N97885 · Substantial damage NTSB CHI77EEP48Accident · 1 fatalClosedBellanca 14-13 · Prairie Du Chn, WIJul 30, 1977 · N86709 · Substantial damage NTSB OAK77FXQ23Accident · Minor injuriesClosedBellanca 14-13 · Minden, NVJun 11, 1977 · N15MP · Substantial damage NTSB LAX77DUJ60Accident · No injuriesClosedStinson 108 · Mesa, AZJun 6, 1977 · N40150 · Substantial damage NTSB SEA77DYM38Accident · No injuriesClosedStinson 108 · Long Creek, ORJun 4, 1977 · N9043K · Substantial damage NTSB NYC77FFJ22Accident · No injuriesClosedStinson 108-1 · Newark, NYMay 18, 1977 · N8193K · Substantial damage NTSB OAK77DVD33Accident · No injuriesClosedStinson 108-1 · Healdsburg, CAMay 14, 1977 · N97115 · Substantial damage NTSB CHI77DEE14Accident · No injuriesClosedStinson 108-1 · Rockford, ILApr 3, 1977 · N8863K · Substantial damage NTSB MIA77FLD43Accident · Serious injuriesClosedBellanca 14-13 · Merritt Is, FLApr 2, 1977 · N86858 · Substantial damage NTSB ANC77DAG43Accident · No injuriesClosedStinson 108-1 · Twin Lakes, AKMar 18, 1977 · N8578K · Substantial damage NTSB IAD77FLT02Accident · No injuriesClosedBellanca 14-13 · Parsons, TNFeb 25, 1977 · N86841 · Substantial damage NTSB ANC77DAG27Accident · Minor injuriesClosedStinson 108-1 · Kenai, AKJan 29, 1977 · N97884 · Substantial damage NTSB NYC77DNC19Accident · Minor injuriesClosedStinson 108-1 · Salem, NHJan 23, 1977 · N8874K · Substantial damage NTSB CHI77FEP08Accident · No injuriesClosedStinson 108-1 · Burlington, WINov 25, 1976 · N97849 · Substantial damage NTSB SEA77DYA01Accident · No injuriesClosedStinson 108 · Soda Springs, IDOct 8, 1976 · N97182 · Substantial damage NTSB CHI76FET50Accident · No injuriesClosedStinson 108-1 · Woodburn, INSep 5, 1976 · N8826K · Substantial damage NTSB FTW76FRD63Accident · No injuriesClosedStinson 108 · Baton Rouge, LAAug 22, 1976 · N97647 · Substantial damage NTSB LAX76FUJ99Accident · No injuriesClosedBellanca 14-132 · Sedona, AZAug 11, 1976 · N74405 · Substantial damage NTSB FTW76FRG56Accident · No injuriesClosedStinson 108-1 · Killeen, TXJun 6, 1976 · N9197K · Substantial damage NTSB CHI76DEG15Accident · Minor injuriesClosedStinson 108 · Cincinnati, OHJun 6, 1976 · N97343 · Substantial damage NTSB NYC76FFA35Accident · No injuriesClosedStinson 108-1 · Johnstown, NYMay 15, 1976 · N97509 · Substantial damage NTSB MKC76DCA26Accident · No injuriesClosedStinson 108-1 · Creve Coeur, MOMay 9, 1976 · N8614K · Substantial damage NTSB ANC76DAA34Accident · No injuriesClosedStinson 108-2 · Fairbanks, AKApr 18, 1976 · N904D · Substantial damage NTSB NYC76DFJ19Accident · No injuriesClosedStinson 108-1 · Perry, NYMar 26, 1976 · N9015K · Substantial damage NTSB NYC76DGM18Accident · No injuriesClosedStinson 108 · Listonburg, PADec 6, 1975 · N8212K · Substantial damage NTSB ANC76AAG71Accident · Minor injuriesClosedStinson 108 · Port Alsworth, AKNov 12, 1975 · N97677 · Substantial damage NTSB LAX76FUA04Accident · No injuriesClosedBellanca 14-132 · Long Beach, CAAug 23, 1975 · N74306 · Substantial damage NTSB OAK76DVD04Accident · No injuriesClosedStinson 108-1 · Concord, CAAug 17, 1975 · N9092K · Substantial damage NTSB CHI76AC015Accident · 1 fatalClosedBellanca 14-13 · Alma, MIAug 15, 1975 · N62277 · 2 aircraft · Destroyed NTSB LAX76DUJ09Accident · No injuriesClosedStinson 108 · Prescott, AZAug 6, 1975 · N97324 · Substantial damage NTSB OAK76DVG08Accident · No injuriesClosedStinson 108 · Vacaville, CAJul 19, 1975 · N97342 · Substantial damage NTSB CHI76DEG02Accident · No injuriesClosedStinson 108 · Batavia, OHJul 12, 1975 · N97706 · Substantial damage NTSB CHI75DEP71Accident · No injuriesClosedStinson 108-1 · Montello, WIJun 27, 1975 · N8784K · Substantial damage NTSB IAD75FID25Accident · No injuriesClosedBellanca 14-19 · New London, VAJun 9, 1975 · N74388 · Substantial damage NTSB NYC75DGM35Accident · No injuriesClosedStinson 108 · Clarion, PAApr 30, 1975 · N40105 · Destroyed