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.aircraft_model_code IN ('1181407')
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.aircraft_model_code IN ('1181407')
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 ERA26LA193Accident · No injuriesClass 4 · LimitedFinal reportBell UH1 · Enterprise, ALThe in-flight separation of a turn lock fastener stud, which resulted in substantial damage to one tail rotor blade.NTSB WPR24LA030Accident · No injuriesClass 3 · LimitedFinal reportArrow Falcon Exporters UH-1H · Firebaugh, CAAn on-ground fuel fire for reasons that could not be determined due to extensive thermal damage.NTSB CEN23LA295Accident · No injuriesClass 3 · LimitedFinal reportBell UH-1H · Woodlawn, ILThe separation of the tail boom from the fuselage for reasons that could not be determined.NTSB CEN22FA317Accident · 4 fatalClass 3 · FieldFinal reportBell UH-1H · Chapelle, NMThe total loss of engine power due to the fatigue failure of the starter-generator input (zerol) gear which failed due to poor maintenance. Contributing to the accident was the unsuccessful autorotation complicated by the setting sun and high density altitude.NTSB WPR22FA098Accident · 1 fatalClass 3 · FieldFinal reportBell UH-1H · Coalinga, CAThe pilot’s loss of situational awareness for reasons that could not be determined given the available evidence, which led to controlled flight into terrain. Contributing to the accident was the pilot’s decision to operate the helicopter while ill and…NTSB WPR21LA236Accident · No injuriesClass 4 · LimitedFinal reportBell UH-1H · Townsend, MTThe pilot’s failure to maintain helicopter control after an encounter with settling with power during approach at an altitude that was too low for recovery, which resulted in a hard landing.NTSB WPR20LA280Accident · 1 fatalClass 3 · LimitedFinal reportArrow-Falcon Exporters UH-1H · Coalinga, CAThe pilot’s inability to maintain control of the helicopter due to a hydraulic system failure for reasons that could not be fully determined due to the thermal destruction from the postimpact fire.NTSB WPR20LA211Accident · 1 fatalClass 3 · LimitedFinal reportBell UH1H · Payson, AZA flight control malfunction due to either a hydraulic hardover or a flight control stiffness event, which resulted in a loss of control.NTSB WPR20LA130Accident · 1 fatalClass 3 · LimitedFinal reportBell UH 1H · Mesa, AZAn in-flight separation of the tail rotor gearbox from the airframe due to fatigue failure of the gearbox attachment studs, resulting in a loss of directional control and subsequent ground impact. Contributing to the accident were 1) the improper application…NTSB GAA19CA344Accident · No injuriesData collectionFinal reportBell UH 1H · Bethel, AKThe pilot's improper fuel planning, which resulted in fuel exhaustion and a total loss of engine power, and his improper landing flare during a forced autorotation, which resulted in a hard landing. Contributing to the accident were the inoperative fuel…NTSB WPR18LA206Accident · Minor injuriesClass 3 · LimitedFinal reportBell UH 1H · Oakdale, CAThe pilot's loss of control during a precautionary landing following an abnormal noise in-flight, the source of which could not be determined.NTSB WPR18LA147Accident · Serious injuriesClass 3 · LimitedFinal reportBell UH 1H · Olympia, WAA loss of tail rotor thrust due to the improper installation of the tail rotor assembly by maintenance personnel resulted in the pilot’s inability to maintain control of the helicopter as he began transition into forward flight from a hover, which resulted in…NTSB CEN18FA078Accident · 5 fatalField investigationFinal reportBell UH-1H · Raton, NMThe pilot's failure to maintain adequate altitude above mountainous terrain during cruise flight in dark night conditions, which resulted in controlled flight into terrain.NTSB GAA18CA107Accident · No injuriesData collectionFinal reportBell UH 1H · Van Nuys, CAThe pilot’s failure to maintain clearance from a stationary helicopter during landing. Contributing to the accident was the ground crew’s failure to ensure that the helicopter would clear the stationary helicopter.NTSB WPR17LA002Accident · Minor injuriesLimited investigationFinal reportTamarack Helicopters UH-1H · Gila Bend, AZThe separation of the 90° tail rotor gearbox assembly as a result of fatigue to the tail rotor gearbox input quill assembly attachment studs due to the helicopter experiencing highly repetitive agricultural flight profiles for which it was not designed.NTSB WPR16LA142Accident · No injuriesLimited investigationFinal reportBell UH 1H · Mt. Adams, WAThe pilot’s failure to maintain yaw control as he slowed the helicopter during a landing approach, which resulted in the loss of helicopter control due to the loss of tail rotor effectiveness.NTSB WPR15LA219Accident · Minor injuriesLimited investigationFinal reportGarlick UH1H · Walla Walla, WAThe helicopter’s reduction in aerodynamic lift while operating in variable wind conditions for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have…NTSB WPR15LA109Accident · No injuriesLimited investigationFinal reportBell/Garlick UH 1H · Shelton, WAThe fatigue failure of the engine-to-transmission driveshaft adapter attachment bolt due to the application of inadequate torque on the bolt during assembly.NTSB CEN15TA035Accident · No injuriesFinal reportBell UH1H · San Isidro, TXThe flight crew's failure to ensure that the sliding cabin door was properly secured before the flight.NTSB CEN13FA415Accident · 1 fatalField investigationFinal reportBell UH-1H · Dove Creek, COPilot-induced oscillations caused by the loss of hydraulic assist of the flight controls due to an excessive loss of hydraulic fluid during a critical phase of flight, which resulted in ground impact. Contributing to the accident was an inadequate analysis of…NTSB WPR10TA318Accident · No injuriesFinal reportBell UH-1H · Santa Barbara, CAThe failure of left tailboom upper attachment fitting as a result of fatigue.NTSB LAX08LA230Accident · Minor injuriesLimited investigationFinal reportBell UH-1H · Rock Springs, WYA total loss of engine power due to the failure of the No. 1 bearing for undetermined reasons.NTSB SEA07TA202Accident · Minor injuriesFinal reportBell UH-1H · Benchmark, MTDense smoke/haze which restricted the pilot's visibility and the pilot's failure to maintain aircraft control during the emergency descent resulting in impact with terrain.NTSB DEN07LA024Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Melrose, NMthe in-flight failure and separation of both tail rotor blades. Contributing factors in this accident were the check pilot interferring with the controls and his failure to relinquish control to the pilot-in-command.NTSB DFW05WA254Accident · 1 fatalForeign investigationBell UH-1H · Pisa Flores, MexicoNTSB ATL05LA035Accident · No injuriesLimited investigationFinal reportBell UH-1H · Rockford, ALThe pilot's failure to maintain adequate obstacle clearance, which resulted in an in-flight collision with a tree.NTSB ATL04TA142Accident · No injuriesFinal reportBell UH-1H · Childs, FLThe vehicle driver's inadequate visual lookout and his failure to maintain clearance. A factor was the lack of company standards and operation procedures.NTSB LAX04TA018Accident · No injuriesFinal reportBell UH-1H · Sacramento, CAThe loss of engine power due to the fatigue failure of a planetary reduction gear.NTSB LAX03LA160Accident · 1 fatalLimited investigationFinal reportBell UH-1H · Kahoolawe, HIThe pilot's failure to remove the external load cable before the repositioning flight, which resulted in the cable striking the tail rotor in cruise flight.NTSB SEA02FA108Accident · 1 fatalField investigationFinal reportGarlick UH-1H · Clark Fork, IDA failure of unknown origin in the tail rotor drive assembly. Factors include mountainous terrain unsuitable for an emergency landing.NTSB DEN01LA077Accident · No injuriesLimited investigationFinal reportBell UH-1H · Zuni, NMa hard landing due to the pilot's failure to maintain aircraft control during autorotation/flare. A factor was the total loss of engine power due to mechanical failure.NTSB SEA01LA046Accident · 1 fatalLimited investigationFinal reportWestern International UH-1H · Darby, MTInflight loss of a tail rotor pitch change link-to-blade grip attach bolt, resulting partial loss of tail rotor control, and subsequent entanglement of the helicopter's external load cable with a tree during emergency descent. Factors included the pilot's…NTSB MIA00GA264Accident · 2 fatalFinal reportBell UH-1H · Waynesville, NCAn in-flight encounter with ground level fog due to the pilot's decision to continue VMC flight into instrument conditions, resulting in an in-flight collision with trees.NTSB MIA00GA184Accident · 1 fatalFinal reportBell UH-1H · Fort Myers, FLthe pilot's failure to maintain control of the helicopter for undetermined reasons. Factors in this accident were self-induced pressure and fatigue due to lack of sleep and rest.NTSB NYC00FA136Accident · 1 fatalField investigationFinal reportBell UH-1H · Frenchville, PAForeign object damage to the compressor and turbine sections of the engine, which resulted in a loss of power.NTSB MIA00TA070Accident · Minor injuriesFinal reportBell UH-1H · Fort Myers, FLA total loss of engine power due to turbine wheel fracture resulting from fatigue for undetermined reasons that resulted in an autorotation to unsuitable terrain and hard touchdown and rollover.NTSB DEN99LA160Accident · Minor injuriesLimited investigationFinal reportBell UH-1H · Silverton, COThe total loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB LAX99LA108Accident · 1 fatalLimited investigationFinal reportBell UH-1H · Glenn, CAAn inflight loss of control for undetermined reasons.NTSB LAX99FA057Accident · 1 fatalField investigationFinal reportBell UH-1H · Quincy, CAAn inaccurate exhaust gas temperature gauge, that allowed the engine to be run over-temperature unknowingly by the pilot, which resulted in the subsequent failure of the turbine sections. Also causal was the pilot's failure to maintain rotor RPM during the…NTSB SEA99LA020Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1H · Darrington, WAThe total separation of the vertical fin (stabilizer), as the result of fatigue cracks which initiated in the fourth rivet hole above where the fin extends from the tailboom.NTSB SEA98FA104Accident · No injuriesField investigationFinal reportGarlick UH-1H · Couer D'Alene, IDFatigue failure of a reduction drive planetary gear. Factors include an unapproved part and plating process, and uneven terrain at the emergency landing site.NTSB MIA98GA069Accident · 4 fatalFinal reportBell UH-1H · Savannah, TNfailure of the flight crew to maintain sufficient altitude/clearance from the pole and workman. Related factors were: the gusty wind condition, inadequate communication/coordination between the flight crew and ground personnel, and an improper external system…NTSB LAX97TA289Accident · Minor injuriesFinal reportBell UH-1H · Tahoe City, CAThe pilot's decision to attempt a takeoff in environmental conditions which exceeded the helicopter's performance capability, and his improper use of the collective, which caused a decay of the main rotor rpm, the collision with the lake, and the subsequent…NTSB FTW96LA380Accident · Serious injuriesLimited investigationFinal reportBell UH-1H · Leadville, COThe pilot's improper inflight planning/decision in that he used an inadequate airspeed or an inadequate altitude, or both, for the intentional autorotation.NTSB SEA96FA187Accident · Serious injuriesField investigationFinal reportGarlick UH-1H · Coeur D'Alene, IDFatigue fracture of the left forward vertical stabilizer spar, resulting in loss of the vertical stabilizer and tail rotor and subsequent loss of control. A factor was insufficient applicability (by make and model) of an existing FAA airworthiness directive…NTSB LAX96TA298Accident · No injuriesFinal reportBell UH-1H · Ukiah, CAthe commercial/student pilot's improper/abrupt use of aft cyclic during the flare, and the instructor's inadequate supervision of the flight.NTSB SEA96FA076Accident · No injuriesField investigationFinal reportBell UH-1H · Rainier, WAfailure of the forward power shaft (number 21) bearing. A factor relating to the accident was: the lack of suitable, unobstructed terrain for an emergency landing.NTSB ATL95LA160Accident · No injuriesLimited investigationFinal reportBell UH-1H · Montgomery, ALthe pilot's failure to maintain clearance from the trees.NTSB SEA92TL#03Accident · No injuriesClass 3Final reportBell 206L-3 · Kent, WA
Back to Bell UH-1H