NTSB investigations: Franklin 6A4150 series, FL
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 | 2 |
| 1966 | 1 |
| 1967 | 2 |
| 1968 | 2 |
| 1970 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 2 |
| 1977 | 1 |
| 1978 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 2012 | 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\" = 'FL' 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" = 'FL' 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 ERA12CA529Accident · No injuriesData collectionFinal reportStinson 108-2 · Winter Haven, FLThe pilot’s failure to maintain directional control during the takeoff, which resulted in a runway excursion.NTSB MIA89LA069Accident · No injuriesLimited investigationFinal reportBellanca 14-13-2 · Sebring, FLFailure of the cam gear snap ring, which allowed the camshaft gear to become disconnected. Factors related to the accident were trees in the emergency landing area.NTSB MIA87LA193Accident · No injuriesLimited investigationFinal reportStinson 108-1 · West Palm Beach, FLWhile on an instructional flt during the landing roll the acft began to drift to the right. The student plt corrected the drift with left rudder, however he then added full power. The acft then ground looped to the left, during which the right main gear…NTSB MIA79DKT05Accident · Serious injuriesClosedStinson 108-1 · Delray Beach, FLNTSB MIA77FLD43Accident · Serious injuriesClosedBellanca 14-13 · Merritt Is, FLNTSB MIA74DLA29Accident · No injuriesClosedStinson 108-1 · Pensacola, FLNTSB MIA74FLA22Accident · Minor injuriesClosedStinson 108 · Baker, FLNTSB MIA73AM041Accident · 2 fatalClosedStinson 108-1 · Ocala, FLNTSB MIA72FLA41Accident · No injuriesClosedBellanca 1413-3 · Starke, FLNTSB MIA72FLD41Accident · No injuriesClosedStinson 108-1 · Oklawaha, FLNTSB MIA71DLA53Accident · Serious injuriesClosedBellanca 14-13 · Jacksonville, FLNTSB MIA71DLD40Accident · No injuriesClosedBellanca 14-13 · Clearwater, FLNTSB MIA69D0284Accident · Minor injuriesClosedStinson 108 · Fort Myers, FLNTSB MIA68D0532Accident · Minor injuriesClosedStinson 108-1 · Chipley, FLNTSB MIA68A0044Accident · 1 fatalClosedLuscombe 8C · Temple Terrac, FLNTSB MIA67D0482Accident · No injuriesClosedStinson 108 · Lake Wales, FLNTSB MIA66D0472Accident · No injuriesClosedStinson 108 · Merritt Is, FLNTSB MIA66F0299Accident · No injuriesClosedStinson 108-1 · Plantation, FLNTSB MIA66D0430Accident · No injuriesClosedBellanca 14-13 · Palatka, FLNTSB UNK65X1025Accident · No injuriesClosedStinson 108-1 · Groveland, FL