NTSB investigations: Franklin 6V 350 series, FL
15 cases on aircraft whose registry engine model is Franklin 6V 350 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
| 1969 | 2 |
|---|---|
| 1970 | 1 |
| 1971 | 2 |
| 1973 | 2 |
| 1976 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1989 | 2 |
| 2011 | 1 |
| 2013 | 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 ('27043'))
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 ('27043'))
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 ERA13LA127Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Merritt Island, FLA total loss of engine power due to fuel starvation, which resulted from an overstress failure of a fitting on the fuel supply line and led to an autorotation and hard landing.NTSB ERA12LA071Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S205-22R · Okeechobee, FLA partial loss of engine power due to a failure of the drive bearings in the alternator drive system. Contributing to the accident was the inadequate maintenance.NTSB MIA90LA004Accident · No injuriesLimited investigationFinal reportMaule M-4-220C · Orlando, FLFailure of the left main landing gear.NTSB MIA89LA092Accident · No injuriesLimited investigationFinal reportBell 47G · Oklawaha, FLPilot's failure to properly control the helicopter during an attempted landing on the back of a truck. Contributing to the accident was the pilot's lack of experience in performing similar landings.NTSB MIA84LA103Accident · No injuriesLimited investigationFinal reportMaule M4-220 · Boca Raton, FLThe plt stated that while practicing touch & go's he lost directional control & the left landing gear collapsed.NTSB MIA83LA035Accident · Minor injuriesLimited investigationFinal reportMaule M-5-220C · Near Ocala, FLThe pilot reported that during flight, the engine stopped and the cockpit filled with smoke. He shut down fuel to the engine and started to glide toward an airport, but it was too FAR away. He then selected a field, but had to stay high on final approach to…NTSB MIA79DKT15Accident · No injuriesClosedCessna 172 · W Palm Beach, FLNTSB MIA76DLA52Accident · No injuriesClosedMaule M4-220 · Gainesville, FLNTSB MIA74D5T43Accident · No injuriesClosedMaule M4-220 · Ft Lauderdale, FLNTSB MIA73DLD59Accident · No injuriesClosedMaule M4220C · Lakeland, FLNTSB MIA72DKT15Accident · No injuriesClosedSiai-Marche S.205 · W Palm Beach, FLNTSB MIA71FKT46Accident · No injuriesClosedBell 47G · Loxahatchee, FLNTSB MIA71FLD06Accident · Serious injuriesClosedMaule M-4 · Brandon, FLNTSB MIA70D0009Accident · No injuriesClosedBell 47G · Groveland, FLNTSB MIA69D0428Accident · No injuriesClosedCessna 172F · Balm, FL