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 CHI69D0312Accident · No injuriesClosedStinson 108-1 · Northbrook, ILOct 2, 1968 · N8849K · Substantial damage NTSB CHI69D0298Accident · No injuriesClosedStinson 108-1 · Northfield, OHSep 6, 1968 · N8409K · Substantial damage NTSB CHI69D0209Accident · No injuriesClosedStinson 108-1 · Freeland, MIAug 13, 1968 · N8546K · Substantial damage NTSB NYC69D0131Accident · No injuriesClosedStinson 108-1 · Central City, PAAug 11, 1968 · N8212K · Substantial damage NTSB OAK69D0071Accident · Minor injuriesClosedStinson 108-1 · Livermore, CAJul 29, 1968 · N97882 · Substantial damage NTSB DEN69D0064Accident · No injuriesClosedBellanca 14-13 · Canon City, COJul 14, 1968 · N74299 · Substantial damage NTSB DIA68F0233Accident · Minor injuriesClosedBellanca 14-13 · Fredericksburg, VAJun 9, 1968 · N74422 · Substantial damage NTSB MIA68D0532Accident · Minor injuriesClosedStinson 108-1 · Chipley, FLApr 28, 1968 · N97195 · Substantial damage NTSB FTW68D0512Accident · No injuriesClosedBellanca 14-13 · Littlefield, TXMar 23, 1968 · N117U · Substantial damage NTSB LAX68D0338Accident · No injuriesClosedBellanca 14-13 · Colton, CAFeb 10, 1968 · N74328 · Substantial damage NTSB LAX68D0330Accident · Minor injuriesClosedStinson 108-1 · Redlands, CAJan 21, 1968 · N8233K · Substantial damage NTSB LAX68F0278Accident · Minor injuriesClosedCessna 150H · San Frnando, CAJan 7, 1968 · N7004S · 2 aircraft · Substantial damage NTSB LAX68D0255Accident · No injuriesClosedBellanca 14-13 · Compton, CADec 31, 1967 · N74368 · Substantial damage NTSB FTW68D0394Accident · Minor injuriesClosedStinson 108-1 · Gueydan, LADec 25, 1967 · N8238K · Substantial damage NTSB NYC68D0375Accident · No injuriesClosedStinson 108-3 · Berlin, NJDec 23, 1967 · N97062 · Substantial damage NTSB MIA68A0044Accident · 1 fatalClosedLuscombe 8C · Temple Terrac, FLNov 5, 1967 · N28708 · 2 aircraft · Destroyed NTSB SEA68D0198Accident · No injuriesClosedStinson 108 · Enterprise, ORNov 4, 1967 · N97408 · Substantial damage NTSB CHI68F0404Accident · No injuriesClosedStinson 108-1 · Brookville, OHOct 28, 1967 · N97364 · Substantial damage NTSB CHI68F0396Accident · Serious injuriesClosedStinson 108 · Moweaqua, ILOct 22, 1967 · N40114 · Substantial damage NTSB OAK68F0145Accident · No injuriesClosedBellanca 14-13 · Hawthorne, NVOct 11, 1967 · N568CD · Substantial damage NTSB NYC68F0219Accident · Minor injuriesClosedStinson 108-1 · New Hudson, NYOct 1, 1967 · N97518 · Substantial damage NTSB NYC68F0196Accident · Serious injuriesClosedBellanca 14-13 · So.Plainfield, NJSep 22, 1967 · N6503N · Substantial damage NTSB DEN68D0090Accident · No injuriesClosedBellanca 14-13 · Littleton, COSep 19, 1967 · N74341 · Substantial damage NTSB SEA68F0182Accident · No injuriesClosedBellanca 14-13 · Aurora, ORAug 28, 1967 · N74325 · Substantial damage NTSB OAK68D0208Accident · No injuriesClosedBellanca 14-13 · Clarksburg, CAAug 3, 1967 · N86898 · Substantial damage NTSB NYC68F0030Accident · No injuriesClosedStinson 108-1 · Mt.Pocono, PAJul 5, 1967 · N8420K · Substantial damage NTSB FTW68F0178Accident · Serious injuriesClosedBellanca 14-13 · Austin, TXJul 3, 1967 · N86797 · Destroyed NTSB MKC68A0001Accident · 3 fatalClosedBellanca 14-13 · Viburnum, MOJul 1, 1967 · N74333 · Destroyed NTSB CHI68D0072Accident · No injuriesClosedStinson 108-1 · N.Philadelph, OHMay 30, 1967 · N8355K · Substantial damage NTSB CHI68D0014Accident · No injuriesClosedStinson 108-1 · Scottsburg, INMay 26, 1967 · N8361K · Substantial damage NTSB OAK68D0076Accident · No injuriesClosedStinson 108 · Jackson, CAMay 20, 1967 · N97602 · Substantial damage NTSB MKC68D0043Accident · No injuriesClosedStinson 108 · Lewellen, NEMay 8, 1967 · N97152 · Substantial damage NTSB CHI68F0025Accident · No injuriesClosedStinson 108-1 · Lake City, MIMay 6, 1967 · N8874K · Substantial damage NTSB NYC67F0595Accident · No injuriesClosedStinson 108-1 · University Prk, PAApr 18, 1967 · N8866K · Substantial damage NTSB NYC68D0029Accident · No injuriesClosedStinson 108-1 · Brookhaven, NYApr 9, 1967 · N40182 · Substantial damage NTSB CHI67D0544Accident · No injuriesClosedBellanca 14-132 · Cahokia, ILMar 18, 1967 · N86887 · Substantial damage NTSB MIA67D0482Accident · No injuriesClosedStinson 108 · Lake Wales, FLMar 17, 1967 · N75295 · Substantial damage NTSB NYC67D0529Accident · No injuriesClosedStinson 108 · Deer Park, NYMar 12, 1967 · N97371 · Substantial damage NTSB NYC67D0495Accident · No injuriesClosedStinson 108-1 · Erie, PAFeb 14, 1967 · N8992K · Substantial damage NTSB NYC67F0471Accident · Minor injuriesClosedBellanca 14-13 · Tridelphia, WVDec 28, 1966 · N74264 · Substantial damage NTSB MIA67F0293Accident · No injuriesClosedBellanca 14-13- · Bessemer, ALNov 26, 1966 · N86761 · Substantial damage NTSB LAX67D0187Accident · No injuriesClosedStinson 108 · Mormon Lake, AZNov 13, 1966 · N97417 · Substantial damage NTSB MIA67F0279Accident · No injuriesClosedBellanca 14-13 · T. Simons Isle, GANov 8, 1966 · N74384 · Substantial damage NTSB LAX67F0195Accident · No injuriesClosedBellanca 14-13 · Hawthorne, CANov 6, 1966 · N86943 · Substantial damage NTSB NYC67D0339Accident · No injuriesClosedStinson 108-1 · Linden, NJOct 13, 1966 · N40152 · Substantial damage NTSB NYC67D0254Accident · No injuriesClosedStinson 108 · Richland, NYSep 15, 1966 · N97488 · Substantial damage NTSB MKC67D0171Accident · No injuriesClosedBellanca 14-13 · Fountain, MNAug 29, 1966 · N86719 · Substantial damage NTSB DEN67D0042Accident · No injuriesClosedBellanca 14-13 · Panguitch, UTJul 13, 1966 · N74209 · Substantial damage NTSB NYC67F0069Accident · No injuriesClosedBellanca 14-132 · Old Forge, NYJul 8, 1966 · N74314 · Substantial damage NTSB CHI67F0077Accident · No injuriesClosedStinson 108 · Ravenna, MIJul 4, 1966 · N97616 · Substantial damage