NTSB investigations: Bell UH-1B, 1997
4 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
| 1980 | 2 |
|---|---|
| 1981 | 2 |
| 1982 | 5 |
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 4 |
| 1986 | 3 |
| 1987 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1990 | 3 |
| 1991 | 4 |
| 1993 | 1 |
| 1994 | 3 |
| 1996 | 2 |
| 1997 | 4 |
| 1998 | 1 |
| 1999 | 2 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 2 |
| 2009 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 1 |
| 2022 | 2 |
| 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 year(c.\"eventDate\") = 1997
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 year(c."eventDate") = 1997
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 SEA97LA198Accident · Serious injuriesLimited investigationFinal reportGarlick UH-1B · Dayville, ORImproper installation of the transmission door by a company mechanic, resulting in inflight separation of the door (which then struck the tail rotor system) and consequent total loss of the tail rotor. Contributing to the accident were: inadequate…NTSB SEA97FA196Accident · 1 fatalField investigationFinal reportSouthern Aero UH-1B · Skykomish, WAA fatigue fracture in the main rotor mast, which resulted in an in flight separation of the main rotor from the helicopter. Contributing to the accident was insufficient Federal Aviation Administration airworthiness standards and requirements for the aircraft.NTSB LAX97LA206Accident · No injuriesLimited investigationFinal reportBell UH-1B · Heron, CApartial loss of engine power for undetermined reasons. A factor relating to the accident was that the engine lost power when the helicopter was outside (below) the limits of the height/velocity curve.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…