NTSB investigations: Bell UH-1B

7 cases on aircraft the registry lists as Bell UH-1B, where the first occurrence was “Loss of control - in flight”. 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

19822026

NTSB investigations: Bell UH-1B per year, 1982–2026: 7 cases
1982	2
1990	1
1991	1
1994	1
2007	2

Where

Open the map

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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181410') AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181410')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
  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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181410')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 SEA08LA043Accident · No injuriesLimited investigationFinal reportBell UH-1B · Ennis, MTThe loss of collective control friction during takeoff that resulted in a collective bounce oscillation. Contributing to the accident was the pilot's failure to maintain aircraft control during the aborted takeoff and the snow covered terrain.Dec 5, 2007 · N46969 · Substantial damage NTSB SEA07LA154Accident · No injuriesLimited investigationFinal reportBell UH-1B · Biggs, CALoss of control during hover for undetermined reasons.Jun 12, 2007 · N2087S · Substantial damage NTSB SEA94LA183Accident · Serious injuriesLimited investigationFinal reportBell UH-1B · Pilot Rock, ORDirectional control was not maintained for undetermined reasons.Jul 17, 1994 · N9645A · Substantial damage NTSB ANC91LA058Accident · 1 fatalLimited investigationFinal reportBell UH-1B · Dog Fish Bay, AKThe pilot's exceeding the gross weight of the aircraft and inadequate supervision by company management. Contributing to the accident was the high vegetation.May 21, 1991 · N87966 · Destroyed NTSB LAX90DXQ04Accident · Serious injuriesFinal reportBell UH-1B · Bieber, CAThe pilot's failure to maintain aircraft control when intentionally slowing his aircraft to off load water on fire. Contributing to the accident was the pilot's failure to arm and release the external load.Aug 14, 1990 · N64789 · Substantial damage NTSB DEN82DA147Accident · No injuriesFinal reportBell UH1B · Bryce Canyon, UTThe pilot was making an approach to a 10,000 ft mountain, let the RPM decay and made a hard landing. The density altitude was 12,500 feet. There was about 500 or 600 pounds of cargo on the long line.Jul 28, 1982 · N88389 · Substantial damage NTSB LAX82DA264Accident · No injuriesFinal reportBell 204 · Delano, CAThe acft was spraying for mediterranean fruit flies with another acft. Entering a "scissors" or opposite direction pattern with the second helicopter spraying in the opposite direction, the plt had to slow down in order to begin his swath at the completion of…Jul 18, 1982 · N910PD · Destroyed