Franklin 6V4 series
NTSB investigations · 285
Matched to the registry by N-number and event date, newest first.
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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = a.case_mkey
WHERE a.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_aircrafts.parquet' a JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = a.case_mkey
WHERE a.engine_model_code IN ('27033')
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 WPR26LA247Accident · Serious injuriesClass 4 · LimitedFinal reportBell 47G · Springtown, TXThe pilot’s failure to maintain clearance from trees while in a low hover.NTSB WPR21LA077Accident · Minor injuriesClass 4 · LimitedFinal reportBell 47D · Marana, AZThe pilot's failure to maintain helicopter control, which resulted in a hard landing.NTSB CEN17LA264Accident · No injuriesLimited investigationFinal reportBell 47D1 · Big Lake, MNThe failure of the metal core assembly within a wooden main rotor blade due to undetected corrosion and fatigue, which caused the wooden blade to separate from the rotor mast.NTSB CEN17LA113Accident · Serious injuriesLimited investigationFinal reportBell-Transworld Helicopters 47D1 · Archer City, TXThe total loss of engine power due to fuel starvation, which resulted from the pilot’s inadvertent positioning of the mixture control to the “fuel cutoff” position.NTSB GAA15CA221Accident · No injuriesData collectionFinal reportBell 47D1 · Clanton, ALThe student pilot's abrupt cyclic and collective inputs during the approach to land which resulted in abnormal runway contact and a subsequent tail boom strike by the main rotor blades.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.NTSB ERA14LA099Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Pell City, ALThe pilot’s use of an improper clutch engagement procedure, which resulted in clutch glazing, slippage, and, ultimately, the in-flight disengagement of the clutch and a loss of rotor rpm. Contributing to the accident were the installation of a light-weight…NTSB ERA13LA390Accident · No injuriesLimited investigationFinal reportContinental Copters 47G · Sandy Hook, KYThe in-flight disengagement of the tail rotor extension shaft from the tail rotor gearbox, resulting in a loss of tail rotor control.NTSB ERA13LA308Accident · Serious injuriesLimited investigationFinal reportHiller UH-12A · Florence, ALThe student pilot’s failure to maintain control of the helicopter while landing, which resulted in a tail rotor ground strike and collision with terrain.NTSB CEN13LA396Accident · No injuriesLimited investigationFinal reportBell 47D1 · Lake Ozark, MOThe improper rebuild and maintenance of the helicopter and inadequate subsequent inspections, which resulted in undetected fuel contamination and a subsequent total loss of engine power during cruise flight.NTSB WPR12LA244Accident · No injuriesLimited investigationFinal reportHiller UH-12B · Pasco, WAThe pilot's failure to maintain the helicopter's rotor rpm while maneuvering at a low altitude over a fruit orchard.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…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.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.NTSB ERA10CA001Accident · No injuriesData collectionFinal reportBell 47D1 · Dorrance, PAA total loss of engine power due to fuel exhaustion for undetermined reasons.NTSB DFW07WA062Accident · Serious injuriesForeign investigationHiller UH-12B · Panama City, PanamaNTSB 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.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.NTSB LAX05LA022Accident · No injuriesLimited investigationFinal reportBell 47D1 · San Martin, CAA loss of power for undetermined reasons.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.NTSB NYC03LA069Accident · Minor injuriesLimited investigationFinal reportBell 47D · Princetown, NYThe student's failure to maintain control while executing a takeoff to a hover, and the flight instructor's delayed remedial action. A factor in the accident was the muddy ground.NTSB FTW02LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Ardmore, OKthe flight instructor's selection of an unsuitable area for practicing a full touchdown autorotation, which resulted in a nose over. A contributing factor was the soft ground.NTSB ATL01LA108Accident · No injuriesLimited investigationFinal reportBell 47G · Berry, ALThe failure of the main rotor system stabilizer damper control horn assembly, resulting in an uncontrolled descent and subsequent collision with a tree and terrain.NTSB CHI01FA231Accident · 2 fatalField investigationFinal reportWorld Helicopters 47D1 · Ballard, MOThe pilot's improper preflight planning which resulted in fuel exhaustion, and the pilot's subsequent improper autorotation.NTSB LAX00LA288Accident · No injuriesLimited investigationFinal reportBell 47D · Stockton, CAThe pilot's inadequate planning by which he miscalculated fuel consumption which resulted in fuel exhaustion.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.NTSB NYC00LA044Accident · No injuriesLimited investigationFinal reportBell 47G · Coudersport, PAThe pilot's improper preflight planning and decision to attempt a takeoff with the passenger from the confined area.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.NTSB CHI99LA012Accident · No injuriesLimited investigationFinal reportHiller UH-12C · Clinton, IAthe failure of the 90 degree gearbox for reasons undetermined. Factors were the failure of the gearbox, and it not being possible for the pilot to maintain control of the aircraft.NTSB MIA98LA254Accident · Minor injuriesLimited investigationFinal reportBell 47-D1 · Oxford, MSThe pilot's failure to maintain directional control due to vibration from the main rotor blade for undetermined reasons. A related finding was the improper repair of a crack in the laminant of the blue main rotor blade by other maintenance personnel.NTSB MIA98LA170Accident · No injuriesLimited investigationFinal reportBell 47G · Bunnell, FLThe pilot-in-command(CFI) failure to maintain control of the aircraft.NTSB FTW98LA144Accident · Minor injuriesLimited investigationFinal reportBell 47D1 · Jeanerette, LAThe in-flight disconnect of the rotating scissors due to the separation of its hinge bolt.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.NTSB MIA97FA248Accident · 2 fatalField investigationFinal reportBell 47G · Saluda, SCin-flight collision with a tree, for undetermined reason(s).NTSB ATL97LA121Accident · No injuriesLimited investigationFinal reportBell 47-D1 · Holcomb, MSThe failure of the pilot to adequately see and avoid all obstructions while doing aerial application work.NTSB FTW96LA192Accident · No injuriesLimited investigationFinal reportBell 47D1 · Ardmore, OKthe student's inadvertent dynamic rollover, and inadequate supervision by the flight instructor.NTSB ATL96LA023Accident · No injuriesLimited investigationFinal reportHiller 12C · N. Myrtle Beach, SCThe pilot's improper operation of the flight controls during a practice autorotation, and the certified flight instructor's inadequate supervision of the operationNTSB LAX96FA045Accident · 2 fatalField investigationFinal reportBell 47D1 · Shafter, CAthe pilot misjudged the altitude and ground clearance while performing an unwarranted low altitude flight maneuver.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.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…NTSB ATL94LA172Accident · No injuriesLimited investigationFinal reportBell 47D1 Wasp · Hazel Green, ALUndetermined.NTSB FTW94LA221Accident · No injuriesLimited investigationFinal reportBell OH-13E · Mountain View, ARThe fuel exhaustion as result of a struck fuel drain valve. Factors were the high density altitude, and the unsuitable terrain at the pilot's disposal for the forced landing.NTSB FTW94LA193Accident · No injuriesLimited investigationFinal reportBell 47H-1 · Tulsa, OKThe pilot's failure to maintain rotor RPM, his delayed landing flare, and the improper touchdown.NTSB FTW94LA166Accident · No injuriesLimited investigationFinal reportBell 47G · Sulphur, OKThe loss of engine power due to the failure of an engine accessory oil pump gear. A factor was the lack of suitable terrain for the autorotation.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…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.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.NTSB SEA92LA141Accident · No injuriesLimited investigationFinal reportBell-World 47D1 · Wenatchee, WACarburetor ice and the pilot in command's not being able to maintain clearance. Factors contributing to the accident were: carburetor icing conditions and tree(s).NTSB MIA92LA102Accident · Minor injuriesLimited investigationFinal reportBell 47-D-1 · Fayette, MSThe pilot in commands failure to insure the proper fuel quantity for the flight was placed on the aircraft and his failure to monitor fuel quantity during flight resulting in fuel exhaustion.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.
Back to Franklin 6V4 series