Skip to content

NTSB investigations: Franklin 6A4150 series, PA

22 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 per year

19642026

Where

Latest cases

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."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA' AND 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.\"eventStateOrRegion\" = 'PA' AND c.\"eventCountry\" = 'USA'
    AND 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."eventStateOrRegion" = 'PA' AND c."eventCountry" = 'USA'
  AND 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 ERA15LA239Accident · Serious injuriesLimited investigationFinal reportStinson 108 · Dushore, PAThe total loss of engine power during the initial climb for reasons that could not be determined because postaccident examination of the engine revealed no anomalies that would have precluded normal operation.Jun 14, 2015 · N97505 · Substantial damage NTSB NYC06CA200Accident · Minor injuriesData collectionFinal reportStinson 108 · Meadville, PAThe owner's failure to install the proper tailwheel spring clips, which resulted in a loss of directional control during the landing roll. A factor was his lack of a mechanic certificate.Aug 11, 2006 · N97541 · Substantial damage NTSB NYC01LA181Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Latrobe, PAThe pilot's failure to maintain control of the airplane which resulted in the inadvertent ground loop.Jul 20, 2001 · N8212K · Substantial damage NTSB NYC82DA070Accident · No injuriesFinal reportStinson 108-1 · Factoryville, PAThe pilot was practicing landings in gusty wind conditions. He reported that the first landing was uneventful, but the second landing was aborted due to gusty turbulence. He stated that the third landing was made in relatively calm wind conditions until just…Apr 14, 1982 · N8933K · Substantial damage NTSB NYC82FGT06Accident · No injuriesClosedStinson 108 · Brogue, PADec 12, 1981 · N97206 · Substantial damage NTSB NYC76DGM18Accident · No injuriesClosedStinson 108 · Listonburg, PADec 6, 1975 · N8212K · Substantial damage NTSB NYC75DGM35Accident · No injuriesClosedStinson 108 · Clarion, PAApr 30, 1975 · N40105 · Destroyed NTSB NYC75DHA26Accident · No injuriesClosedStinson 108-1 · Spring City, PADec 31, 1974 · N8854K · Substantial damage NTSB NYC75FHA19Accident · No injuriesClosedStinson 108-1 · Berwick, PAOct 11, 1974 · N8904K · Substantial damage NTSB NYC73DHA14Accident · No injuriesClosedBellanca 14-13 · Erwinna, PAFeb 3, 1973 · N74267 · Substantial damage NTSB NYC73DGM03Accident · No injuriesClosedStinson 108 · Central City, PAJul 29, 1972 · N40105 · Substantial damage NTSB NYC70F0151Accident · No injuriesClosedStinson 108-1 · Perkasie, PASep 29, 1969 · N8915K · Substantial damage NTSB NYC69D0131Accident · No injuriesClosedStinson 108-1 · Central City, PAAug 11, 1968 · N8212K · Substantial damage NTSB NYC68F0030Accident · No injuriesClosedStinson 108-1 · Mt.Pocono, PAJul 5, 1967 · N8420K · Substantial damage NTSB NYC67F0595Accident · No injuriesClosedStinson 108-1 · University Prk, PAApr 18, 1967 · N8866K · Substantial damage NTSB NYC67D0495Accident · No injuriesClosedStinson 108-1 · Erie, PAFeb 14, 1967 · N8992K · Substantial damage NTSB NYC66D0551Accident · No injuriesClosedStinson 108-1 · Mohrsville, PAMar 20, 1966 · N97870 · Substantial damage NTSB NYC66F0376Accident · No injuriesClosedBellanca 14-13 · Somerset, PAOct 31, 1965 · N74392 · Substantial damage NTSB NYC66D0052Accident · No injuriesClosedStinson 108-1 · Bridgeville, PAMay 16, 1965 · N8914K · Substantial damage NTSB NYC65F0116Accident · No injuriesClosedStinson 108-2 · Allentown, PAApr 11, 1965 · N386C · Substantial damage NTSB UNK64X3552Accident · No injuriesClosedStinson 108 · Aliquippa, PAAug 23, 1964 · N8320K · Substantial damage NTSB UNK64X3210Accident · No injuriesClosedBellanca 14132 · Cresson, PAAug 4, 1964 · N74392 · Substantial damage