NTSB investigations: Bell UH-1H, CA
11 cases on aircraft the registry lists as Bell UH-1H. 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
| 1996 | 1 |
|---|---|
| 1997 | 1 |
| 1998 | 1 |
| 1999 | 1 |
| 2003 | 1 |
| 2010 | 1 |
| 2018 | 2 |
| 2020 | 1 |
| 2022 | 1 |
| 2023 | 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\" = '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.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_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.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 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 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 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 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 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 WPR10TA318Accident · No injuriesFinal reportBell UH-1H · Santa Barbara, CAThe failure of left tailboom upper attachment fitting as a result of fatigue.NTSB LAX04TA018Accident · No injuriesFinal reportBell UH-1H · Sacramento, CAThe loss of engine power due to the fatigue failure of a planetary reduction gear.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 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 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.