# NTSB investigations: Bell UH-1B: Collision with terr/obj (non-CFIT)

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB WPR23LA118](https://openairdocs.org/ntsb/WPR23LA118.md): Bell UH-1B · Orland, CA · Accident · No injuries · Class 4 · Limited · Final report · Mar 2, 2023 · N234SJ · Substantial damage
  > The pilot’s inadequate fuel planning, which resulted in fuel exhaustion and a loss of engine power.
- [NTSB ERA22FA279](https://openairdocs.org/ntsb/ERA22FA279.md): Bell UH-1B · Amherstdale, WV · Accident · 6 fatal · Class 1 · Field · Final report · Jun 22, 2022 · N98F · Destroyed
  > the operator’s failure to adequately inspect the former military turbine powered helicopter, which allowed an engine issue to progress and result in a loss of engine power and a subsequent loss of control after the helicopter struck powerlines during a forced…
- [NTSB WPR13FA411](https://openairdocs.org/ntsb/WPR13FA411.md): Bell UH 1B · Detroit, OR · Accident · 1 fatal · Field investigation · Final report · Sep 16, 2013 · N204UH · Substantial damage
  > The fatigue failure of the upper two tailboom attachment points, which resulted in the tailboom separating from the fuselage during logging operations. Contributing to the accident was poor maintenance throughout the helicopter’s operational life.
- [NTSB CEN09LA565](https://openairdocs.org/ntsb/CEN09LA565.md): Bell UH-1B · Arvilla, ND · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 2009 · N204JB · Substantial damage
  > The aircraft owner/mechanic/pilot's installation of an improper tail boom assembly and the resulting fatigue failure of the tail boom's attach fittings.

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/470/sequence?model=1181410

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.