Skip to content

NTSB investigations: Franklin 6V4 series, CA

58 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

NTSB investigations: Franklin 6V4 series, CA per year, 1964–2026: 58 cases
1964	5
1965	1
1966	3
1967	4
1968	1
1969	5
1970	3
1971	2
1972	1
1973	2
1974	3
1975	2
1976	3
1977	1
1978	2
1979	1
1980	4
1982	1
1983	1
1984	1
1987	1
1988	1
1995	3
2000	1
2004	1
2005	2
2011	2
2014	1

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" = 'CA' 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\" = 'CA' 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" = 'CA' 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 WPR14LA180Accident · Minor injuriesLimited investigationFinal reportBell 47G · El Monte, CAA partial loss of engine power during climbout due to a malfunctioning magneto and spark plugs.May 3, 2014 · N7895B · Substantial damage NTSB WPR12LA029Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Diego, CAThe flight instructor's inadequate supervision of the student pilot during a simulated autorotation and the pilots’ failure to use carburetor heat while operating at reduced engine power while in carburetor icing conditions, which resulted in a loss of engine…Nov 8, 2011 · N4251A · Substantial damage NTSB WPR11LA469Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Ahwahnee, CAThe pilot’s failure to maintain adequate main rotor rpm during the landing approach, which resulted in a loss of control.Sep 27, 2011 · N9158R · Substantial damage NTSB LAX06LA030Accident · Serious injuriesLimited investigationFinal reportBell 47D1 · Rancho Murieta, CAa separation of the tail rotor assembly due to the reverse bending fatigue fracture of a tail rotor pitch change link bolt, resulting in a loss of control of the helicopter, and a hard landing during the uncontrolled descent.Nov 10, 2005 · N16356 · Substantial damage NTSB LAX05LA112Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Thermal, CAthe pilot's inadequate in-flight planning and failure to refuel the helicopter, which resulted in fuel exhaustion.Mar 12, 2005 · N5311V · Substantial damage NTSB LAX05LA022Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Martin, CAA loss of power for undetermined reasons.Oct 31, 2004 · N903B · Substantial damage NTSB LAX00LA288Accident · No injuriesLimited investigationFinal reportBell 47D · Stockton, CAThe pilot's inadequate planning by which he miscalculated fuel consumption which resulted in fuel exhaustion.Aug 5, 2000 · N39KH · Substantial damage NTSB LAX96FA045Accident · 2 fatalField investigationFinal reportBell 47D1 · Shafter, CAthe pilot misjudged the altitude and ground clearance while performing an unwarranted low altitude flight maneuver.Nov 12, 1995 · N78900 · Destroyed NTSB LAX95LA326Accident · Minor injuriesLimited investigationFinal reportHiller UH-12C · Porterville, CAthe flight instructor's inadequate supervision of the flight; the dual student's improper use of the flight controls; and improper remedial action.Sep 6, 1995 · N1348Z · Substantial damage NTSB LAX95LA238Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Rio Vista, CAThe result of a chafing failure of the left anti-torque control cable while the aircraft was in flight. An inadequate preflight inspection by the pilot-in-command, and an inadequate 100-hour inspection by company maintenance personnel were factors in this…Jul 3, 1995 · N1348Z · Substantial damage NTSB LAX88LA160Accident · No injuriesLimited investigationFinal reportBell 47D1 · Taft, CAApr 13, 1988 · N917B · Substantial damage NTSB LAX87LA294Accident · No injuriesLimited investigationFinal reportBell 47D-1 · Taft, CAThe plt rprtd the eng lost power at about 300' AGL after the helicopter had flown aprx 2.7 hrs without refueling. He initiated an autorotative landing; however, before touchdown, the main rotor blades contacted & severed the tail boom. An exam revealed the…Aug 5, 1987 · N917B · Substantial damage NTSB LAX85LA079Accident · No injuriesLimited investigationFinal reportBell 47G · Chatsworth, CAThe plt was practicing off airport touch & go's. on the second lndg the left skid contacted a hidden dirt embankment andthe acft rolled over. A post impact fire consumed the aircraft. Both certificated commercial plts aboard the helicopter escaped unharmed.…Dec 22, 1984 · N182JR · Destroyed NTSB LAX84LA108Accident · No injuriesLimited investigationFinal reportBell 47G · El Cajon, CADuring a demonstration to show his student how to autorotate fm a 2 ft height AGL the instructor reduced pwr and inadvertently applied fwd cyclic. The front portion of the skids hit the gd followed by the main rotor blades. Helicopter then rocked backwards,…Dec 21, 1983 · N4475 · Substantial damage NTSB LAX82FA341Accident · Minor injuriesField investigationFinal reportBell 47G-2 · San Diego, CAThe plt was in the local pattern practicing maneuvers. After completing a quick stop maneuver & hovering, another takeoff was initiated. The plt stated that it seemed to take an unusual amount of forward cyclic to initiate forward flt. During the final…Sep 11, 1982 · N4242A · Destroyed NTSB LAX81DUG05Accident · No injuriesClosedHiller Acft UH-12B · Rialto, CANov 18, 1980 · N5310V · Destroyed NTSB LAX80DVA64Accident · No injuriesClosedBell 47G · Bakersfield, CAAug 23, 1980 · N148B · Substantial damage NTSB LAX80FVM17Accident · No injuriesClosedBell 47D1 · Salinas, CAMar 9, 1980 · N78900 · Substantial damage NTSB LAX80FUQ11Accident · No injuriesClosedBell 47G · Pacoima, CAFeb 26, 1980 · N182JR · Substantial damage NTSB LAX79DUQ26Accident · No injuriesClosedBell 47G2M · Guadalupe, CAApr 2, 1979 · N6327D · Substantial damage NTSB OAK78FVM46Accident · No injuriesClosedBell 47D1 · Castroville, CASep 17, 1978 · N78900 · Substantial damage NTSB LAX78FUA13Accident · No injuriesClosedBell 47G · Torrance, CAMar 25, 1978 · N4475 · Substantial damage NTSB LAX77FUA06Accident · Minor injuriesClosedBell 47D-1 · Long Beach, CAFeb 23, 1977 · N74120 · Substantial damage NTSB LAX76FUQ32Accident · No injuriesClosedBell 47D-1 · Lancaster, CAApr 7, 1976 · N917B · Substantial damage NTSB OAK76FVG43Accident · No injuriesClosedBell 47D-1 · Sacramento, CAJan 13, 1976 · N2134 · Substantial damage NTSB LAX76FVA18Accident · No injuriesClosedBell 47D-1 · Capistrano, CAJan 1, 1976 · N9673Z · Substantial damage NTSB OAK76DVM08Accident · Minor injuriesClosedBell 47G · King City, CAAug 20, 1975 · N933B · Substantial damage NTSB OAK75FVG66Accident · No injuriesClosedBell 47D-1 · Sacramento, CAMay 13, 1975 · N342L · Substantial damage NTSB LAX75FUQ09Accident · No injuriesClosedBell 47G · Lancaster, CASep 27, 1974 · N6327D · Substantial damage NTSB OAK75FVG13Accident · No injuriesClosedBell 47G · Sacramento, CAAug 13, 1974 · N7985A · Substantial damage NTSB LAX75FUA04Accident · No injuriesClosedBell 47D-1 · Seal Beach, CAJul 28, 1974 · N5226 · Substantial damage NTSB OAK74DVM02Accident · No injuriesClosedHiller Acft UH-12C · Gonzalez, CAJul 13, 1973 · N5320V · Substantial damage NTSB OAK73DVG41Accident · No injuriesClosedBell 47D1 · Marysville, CAJan 27, 1973 · N10190 · Destroyed NTSB LAX72DVA60Accident · No injuriesClosedBell 47G · Wasco, CAApr 2, 1972 · N153B · Destroyed NTSB LAX71FUA47Accident · No injuriesClosedBell 47D1 · Long Beach, CAFeb 8, 1971 · N74124 · Substantial damage NTSB OAK71FVA53Accident · No injuriesClosedHiller UH12B · Fresno, CAJan 17, 1971 · N5104V · Substantial damage NTSB LAX71FUA08Accident · No injuriesClosedHiller Acft UH-12A · Tustin, CAAug 4, 1970 · N2827D · Substantial damage NTSB LAX70FUD08Accident · No injuriesClosedBell 47D · Venice, CAMar 18, 1970 · N234B · Substantial damage NTSB OAK70DVM09Accident · Minor injuriesClosedHiller Acft UH-12C · Castroville, CAMar 17, 1970 · N5320V · Destroyed NTSB LAX70F0171Accident · No injuriesClosedBell 47D1 · Santa Ana, CAOct 10, 1969 · N9673Z · Substantial damage NTSB LAX70D0129Accident · No injuriesClosedBell 47D1 · Shafter, CASep 13, 1969 · N153B · Substantial damage NTSB OAK70D0145Accident · Minor injuriesClosedBell 47G · Hollister, CASep 8, 1969 · N7985A · Destroyed NTSB LAX69D0326Accident · No injuriesClosedBell 47D1 · Calabasas, CAApr 30, 1969 · N8116 · Substantial damage NTSB LAX69D0317Accident · No injuriesClosedHiller UH-12C · Compton, CAFeb 13, 1969 · N5326V · Substantial damage NTSB LAX68A0068Accident · No injuriesClosedBell 47G-2 · Culver City, CAJan 17, 1968 · N412SF · Substantial damage NTSB LAX68A0021Accident · No injuriesClosedBell 47D1 · Buttonwilow, CAAug 18, 1967 · N10190 · Substantial damage NTSB LAX67A0105Accident · No injuriesClosedBell 47G · Bakersfield, CAMay 8, 1967 · N148B · Substantial damage NTSB LAX67A0103Accident · No injuriesClosedBell 47D1 · Bakersfield, CAMay 3, 1967 · N12888 · Substantial damage NTSB OAK67A0071Accident · 3 fatalClosedBell 47D1 · Martinez, CAMar 25, 1967 · N74123 · Destroyed NTSB LAX67A0043Accident · No injuriesClosedBell 47D1 · Fontana, CAOct 31, 1966 · N5166V · Substantial damage