NTSB investigations: Franklin 6A4150 series, OH
20 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.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 4 |
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 2 |
| 1975 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1981 | 1 |
| 1987 | 1 |
| 2003 | 1 |
| 2022 | 1 |
| 2024 | 1 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'OH' 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" = 'OH' 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" DESCRun 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 ERA24LA201Accident · No injuriesClass 4 · LimitedFinal reportStinson 108 · Beach City, OHA total loss of engine power due to the due to the pilot’s delayed application of carburetor heat.NTSB ERA22LA353Accident · No injuriesClass 4 · LimitedFinal reportStinson 108-1 · Columbus, OHThe pilot’s improper landing flare, which resulted in a bounced landing and a collapse of the left main landing gear.NTSB NYC03LA092Accident · No injuriesLimited investigationFinal reportStinson 108 · Brookville, OHThe pilot's failure to maintain directional control while landing.NTSB ATL87LA193Accident · Serious injuriesLimited investigationFinal reportBellanca 14-13-2 · Hamilton, OHThe plt rptd that he made a non-std rt-hand departure after t/o from rwy 29, to avoid traffic departing to the left. The acft began to sink as he attempted to climb over the lee side of a 200 ft-high ridge less than 1 mile northwest of the arpt. The acft…NTSB CHI81FEI26Accident · Minor injuriesClosedStinson 108-1 · Chardon, OHNTSB CHI79DEG07Accident · No injuriesClosedStinson 108 · Cincinnati, OHNTSB CHI76DEG15Accident · Minor injuriesClosedStinson 108 · Cincinnati, OHNTSB CHI76DEG02Accident · No injuriesClosedStinson 108 · Batavia, OHNTSB CHI71FGG16Accident · Minor injuriesClosedStinson 108 · Nelsonville, OHNTSB CHI70FGG25Accident · Minor injuriesClosedStinson 108-1 · New Lexingtn, OHNTSB CHI70D0146Accident · No injuriesClosedStinson 108 · Elyria, OHNTSB CHI69D0298Accident · No injuriesClosedStinson 108-1 · Northfield, OHNTSB CHI68F0404Accident · No injuriesClosedStinson 108-1 · Brookville, OHNTSB CHI68D0072Accident · No injuriesClosedStinson 108-1 · N.Philadelph, OHNTSB CHI66F0760Accident · No injuriesClosedStinson 108-1 · Walbridge, OHNTSB CHI66D0190Accident · No injuriesClosedStinson 108-1 · Youngstown, OHNTSB CHI66D0183Accident · Minor injuriesClosedStinson 108 · Put In Bay, OHNTSB CHI65F0144Accident · No injuriesClosedBellanca 14-13 · Orient, OHNTSB CHI65D0122Accident · No injuriesClosedStinson 108-1 · Chagrin Falls, OHNTSB UNK65X0655Accident · No injuriesClosedStinson 108-1 · Painesville, OH