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 FTW75DPG44Accident · No injuriesClosedBal-Aire BA · Carlisle, ARMar 26, 1975 · N4951E · Substantial damage NTSB ANC75DAG74Accident · No injuriesClosedStinson 108-1 · Iliamna, AKMar 13, 1975 · N9109K · Substantial damage NTSB IAD75FIG14Accident · No injuriesClosedStinson 108-1 · Edgewater, MDFeb 22, 1975 · N8721K · Substantial damage NTSB ANC75DAG69Accident · No injuriesClosedStinson 108-1 · Talkeetna, AKFeb 9, 1975 · N8578K · Substantial damage NTSB MKC75DER37Accident · No injuriesClosedStinson 108 · Vermillion, MNJan 5, 1975 · N97369 · Substantial damage NTSB NYC75DHA26Accident · No injuriesClosedStinson 108-1 · Spring City, PADec 31, 1974 · N8854K · Substantial damage NTSB LAX75D4G23Accident · No injuriesClosedStinson 108-1 · Rubidoux, CADec 1, 1974 · N8358K · Substantial damage NTSB NYC75FHA19Accident · No injuriesClosedStinson 108-1 · Berwick, PAOct 11, 1974 · N8904K · Substantial damage NTSB NYC75DFA11Accident · Minor injuriesClosedStinson 108 · Andes, NYOct 5, 1974 · N97370 · Substantial damage NTSB LAX75DUJ28Accident · Minor injuriesClosedStinson 108-2 · Rillito, AZSep 29, 1974 · N97595 · Substantial damage NTSB IAD75DLJ06Accident · Serious injuriesClosedBellanca 14-13 · Fayetteville, NCAug 11, 1974 · N74375 · Substantial damage NTSB MIA75DLG08Accident · No injuriesClosedChampion 7ECA · Aiken, SCJul 28, 1974 · N1814G · 2 aircraft · Substantial damage NTSB ANC75DAG06Accident · No injuriesClosedStinson 108-2 · Anchorage, AKJul 28, 1974 · N97612 · Substantial damage NTSB ANC74FAG99Accident · No injuriesClosedStinson 108-1 · Cantwell, AKApr 15, 1974 · N8489K · Substantial damage NTSB LAX74FUQ33Accident · Serious injuriesClosedStinson 108 · Santa Paula, CAApr 7, 1974 · N40198 · Substantial damage NTSB SEA74FYG27Accident · Minor injuriesClosedStinson 108-1 · Tekoa, WAMar 17, 1974 · N97675 · Substantial damage NTSB FTW74FPG48Accident · No injuriesClosedStinson 108-1 · N.Little Rock, ARMar 2, 1974 · N8213K · Substantial damage NTSB ANC74DAG88Accident · No injuriesClosedStinson 108 · Soldotna, AKJan 31, 1974 · N97326 · Substantial damage NTSB FTW74FPM19Accident · No injuriesClosedBellanca 14-13 · Stilwell, OKJan 25, 1974 · N86833 · Substantial damage NTSB MIA74DLA29Accident · No injuriesClosedStinson 108-1 · Pensacola, FLDec 23, 1973 · N8869K · Substantial damage NTSB CHI74DEE43Accident · No injuriesClosedStinson 108 · Kewanee, ILDec 20, 1973 · N8546K · Substantial damage NTSB NYC74AN053Accident · Serious injuriesClosedStinson 108-1 · Amityville, NYDec 15, 1973 · N2641 · 2 aircraft · Destroyed NTSB MIA74FLA22Accident · Minor injuriesClosedStinson 108 · Baker, FLNov 18, 1973 · N97378 · Substantial damage NTSB SEA74DTI13Accident · No injuriesClosedStinson 108-2 · Plains, MTNov 9, 1973 · N9610K · Substantial damage NTSB NYC74FFA10Accident · No injuriesClosedStinson 108 · Albany, NYSep 9, 1973 · N97954 · Substantial damage NTSB ANC74DAG45Accident · No injuriesClosedStinson 108 · Aniak, AKSep 9, 1973 · N97942 · Substantial damage NTSB SEA74DYG11Accident · No injuriesClosedBellanca 14-193 · Orofino, IDAug 26, 1973 · N74450 · Substantial damage NTSB CHI74FEE02Accident · Minor injuriesClosedStinson 108 · Wheeling, ILJul 5, 1973 · N9177K · Substantial damage NTSB SEA73DYC25Accident · No injuriesClosedStinson 108 · The Dalles, ORApr 21, 1973 · N9019K · Substantial damage NTSB DEN73FTE69Accident · No injuriesClosedBellanca 14-13 · Denver, COApr 17, 1973 · N74377 · Substantial damage NTSB NYC73FNE26Accident · No injuriesClosedStinson 108-1 · Somers, CTMar 28, 1973 · N8485K · Substantial damage NTSB SEA73FYE29Accident · No injuriesClosedStinson 108 · Kent, WAMar 17, 1973 · N9150K · Substantial damage NTSB NYC73DHA14Accident · No injuriesClosedBellanca 14-13 · Erwinna, PAFeb 3, 1973 · N74267 · Substantial damage NTSB MIA73AM041Accident · 2 fatalClosedStinson 108-1 · Ocala, FLOct 16, 1972 · N8529K · Destroyed NTSB NYC73DGM03Accident · No injuriesClosedStinson 108 · Central City, PAJul 29, 1972 · N40105 · Substantial damage NTSB ANC73DAA04Accident · No injuriesClosedStinson 108-2 · Mt Mckinley, AKJul 24, 1972 · N904D · Substantial damage NTSB SEA72FYE36Accident · No injuriesClosedStinson 108 · Seattle, WAJul 7, 1972 · N97909 · Substantial damage NTSB NYC72FLJ35Accident · No injuriesClosedBellanca 14-13 · Goldsboro, NCJun 14, 1972 · N74232 · Substantial damage NTSB CHI72DEM71Accident · No injuriesClosedStinson 108-1 · Traverse Cty, MIMay 28, 1972 · N8874K · Substantial damage NTSB SEA72FYE35Accident · Minor injuriesClosedBellanca 14-13 · Blaine, WAMay 25, 1972 · N86897 · Substantial damage NTSB MIA72FLA41Accident · No injuriesClosedBellanca 1413-3 · Starke, FLMay 7, 1972 · N69L · Substantial damage NTSB NYC72FHD30Accident · No injuriesClosedPiper PA-22 · Medford, NJMar 4, 1972 · N2930Z · 2 aircraft · Substantial damage NTSB SEA72DYI13Accident · No injuriesClosedStinson 108-1 · Brookings, ORFeb 2, 1972 · N97782 · Substantial damage NTSB NYC72FHJ14Accident · No injuriesClosedStinson 108-1 · Deer Park, NYJan 12, 1972 · N8803K · Substantial damage NTSB SEA72DYI10Accident · No injuriesClosedStinson 108-1 · Klamath Flls, ORJan 2, 1972 · N8336K · Substantial damage NTSB MIA72FLD41Accident · No injuriesClosedStinson 108-1 · Oklawaha, FLDec 24, 1971 · N8470K · Substantial damage NTSB FTW72FPM12Accident · Minor injuriesClosedStinson 108-1 · Calera, OKNov 7, 1971 · N97441 · Substantial damage NTSB DEN72FTE40Accident · No injuriesClosedStinson 108-2 · Watkins, CONov 4, 1971 · N97086 · Substantial damage NTSB LAX72DUQ39Accident · Minor injuriesClosedBellanca 14-13 · Saugus, CAOct 30, 1971 · N74421 · Substantial damage NTSB ANC72DAG67Accident · No injuriesClosedStinson 108 · Anchorage, AKOct 20, 1971 · N44BS · Substantial damage