NTSB investigations: Bell UH-1B, FL
5 cases on aircraft the registry lists as Bell UH-1B. 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
| 1986 | 1 |
|---|---|
| 1991 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2002 | 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\" = '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.aircraft_model_code IN ('1181410'))
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.aircraft_model_code IN ('1181410'))
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 MIA02LA133Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Lorida, FLThe pilot's continued operation with known engine anomalies resulting in loss of engine power due to failure of the engine fuel control pump drive clutch assembly due to wear and collision with the terrain during the resultant descent.NTSB MIA97LA099Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Labelle, FLCompany maintenance personnel's failure to properly evaluate a main rotor system problem resulting in main rotor straps with multiple laminates separated due to fatigue cracking being allowed to continue in service until failure and separation of a main rotor…NTSB MIA96LA166Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Lorida, FLfailure of company maintenance personnel to properly torque the tail rotor 90 degree gear box mounting bolts during installation, which resulted in failure of the mounting studs due to bending fatigue and subsequent separation of the gearbox.NTSB MIA91LA113Accident · Minor injuriesLimited investigationFinal reportBell UH-1B · Vero Beach, FLImproper maintenance adjustment by company maintenance personnel resulting in overtorque of a tailboom attach bolt which allowed the tailboom to shift. This disengaged the tail rotor drive shaft at a coupling resulting in the loss of tail rotor drive.NTSB MIA86LA138Accident · No injuriesLimited investigationFinal reportBell UH-1B · North Port, FLThe flt experienced an eng failure at an alt of aprx 8 ft AGL shortly after takeoff and the helicopter sustained substantial damage when a hard landing was made. Post accident inspection of the eng revealed the pwr turbine wheel experienced a loss of two…