Skip to content

NTSB investigations: Franklin 6V4 series, FL

27 cases on aircraft whose registry engine model is Franklin 6V4 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" = '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 ('27033')) 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\" = '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 ('27033'))
  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 ('27033'))
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 ERA10CA262Accident · Minor injuriesData collectionFinal reportHiller UH12 · Sarasota, FLThe pilot's delayed remedial action to maintain main rotor rpm, which resulted in a loss of lift and hard landing.May 9, 2010 · N116S · Substantial damage NTSB ANC04LA027Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Bradenton, FLThe pilot's inadequate in-flight planning/decision which resulted in fuel exhaustion. Also causal was the pilot's failure to maintain adequate rotor speed, resulting in a hard landing.Feb 22, 2004 · N5304V · Substantial damage NTSB MIA00LA111Accident · Minor injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLThe pilot's improper collective and cyclic control usage during an emergency descent, following the onset of a 1 to 1 vibration for undetermined reasons, resulting in the helicopter landing hard and rolling over.Mar 17, 2000 · N5304V · Substantial damage NTSB ATL99LA108Accident · No injuriesLimited investigationFinal reportHiller UH12-C · Venice, FLLoss of engine power due to fuel starvation as a result of the passenger inadvertently shutting off the fuel supply.Jul 16, 1999 · N5317V · Substantial damage NTSB MIA98LA170Accident · No injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot-in-command(CFI) failure to maintain control of the aircraft.May 28, 1998 · N182JR · Substantial damage NTSB MIA98LA051Accident · No injuriesLimited investigationFinal reportBell 47D1 · Bunnell, FLthe student pilot's improper planning/decision, which resulted in fuel exhaustion, loss of engine power, and a forced landing.Jan 3, 1998 · N59326 · Substantial damage NTSB MIA94FA125Accident · 2 fatalField investigationFinal reportBell 47D1 · Marathon, FLSeparation of the tail rotor gearbox and tail rotor blades for an undetermined reason. Factors related to the accident were: failure of maintenance personnel to follow the proper maintenance procedure after a previous tail rotor strike, and failure to conduct…Apr 22, 1994 · N9660 · Destroyed NTSB MIA93LA144Accident · Minor injuriesLimited investigationFinal reportBell 47G · Panama City, FLImproper planning/decision by the pilot-in-command and his failure to maintain rotor RPM, which resulted in failure of the helicopter to attain effective translational lift. Factors related to the accident were: the fence & terrain conditions.Jun 19, 1993 · N3628G · Substantial damage NTSB MIA93LA032Accident · No injuriesLimited investigationFinal reportHiller UH-12C · New Smyrna Bch, FLThe pilot-in-command's improper application of cyclic and collective pitch control during an autorotative landing.Dec 21, 1992 · N38767 · Substantial damage NTSB MIA92LA069Accident · No injuriesLimited investigationFinal reportBell 47D1 · Cross City, FLPartial loss of engine power due to undetermined reasons and unsuitable terrain encountered during the autorotative landing.Jan 27, 1992 · N93067 · Substantial damage NTSB MIA90LA111Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Sanford, FLLoss of engine power for an unknown reason.Apr 26, 1990 · N5306V · Substantial damage NTSB MIA90LA023Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Loxahatchee, FLFailure of the pilot to maintain rotor RPM after pulling up from a swath run. A related factor was the presence of trees.Nov 2, 1989 · N93067 · Substantial damage NTSB MIA89LA133Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Miami, FLThe unqualified persons failure to maintain clearance from the fence. Pressure induced by others, lack of experience, and over confidence in personal ability are contributing factors to this accident.Apr 17, 1989 · N342L · Substantial damage NTSB MIA76DLA48Accident · No injuriesClosedBell 47D-1 · Lake Butler, FLMay 21, 1976 · N74123 · Substantial damage NTSB MIA76DKT59Accident · No injuriesClosedBell 47D1 · South Bay, FLMar 1, 1976 · N12088 · Substantial damage NTSB MIA76FLD46Accident · Minor injuriesClosedBell 47G · Clearwater, FLFeb 22, 1976 · N3628G · Substantial damage NTSB MIA76DLA08Accident · No injuriesClosedBell 47D1 · Monticello, FLAug 21, 1975 · N74123 · Substantial damage NTSB MIA74DKT61Accident · No injuriesClosedBell 47D1 · Ochopee, FLMar 16, 1974 · N9660 · Substantial damage NTSB MIA73DKT67Accident · No injuriesClosedBell 47H-1 · Naples, FLNov 26, 1972 · N2818B · Substantial damage NTSB MIA72FKT22Accident · No injuriesClosedBell 47D-1 · South Bay, FLOct 20, 1971 · N160B · Substantial damage NTSB MIA69F0017Accident · No injuriesClosedBell 47H-1 · Cape Canaverl, FLApr 20, 1968 · N2891B · Substantial damage NTSB MIA68A0011Accident · No injuriesClosedBell 47D1 · Pnama Cty Bch, FLJul 22, 1967 · N322A · Substantial damage NTSB MIA66A0086Accident · Minor injuriesClosedBell 47D1 · Florida City, FLJan 31, 1966 · N322A · Substantial damage NTSB MIA66A0082Accident · Serious injuriesClosedBell 47G-1 · N.Miami Beach, FLJan 13, 1966 · N2821B · Substantial damage NTSB MIA66A0016Accident · No injuriesClosedBell 47G · Panama City, FLJul 26, 1965 · N3628G · Substantial damage NTSB MIA65A0099Accident · No injuriesClosedHiller UH12C · N Miami Beach, FLApr 7, 1965 · N5317V · Substantial damage NTSB UNK64X1986Accident · No injuriesClosedBell 47H1 · Miami, FLMay 28, 1964 · N981B · Substantial damage