Final NTSB investigations: Bell 214B-1

12 cases on aircraft the registry lists as Bell 214B-1. 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

19772026

Final NTSB investigations: Bell 214B-1 per year, 1977–2026: 12 cases
1977	4
1979	1
1985	1
1986	1
1989	1
1990	1
1992	2
2004	1

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."completionStatus" = 'Completed' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182105')) 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.\"completionStatus\" = 'Completed'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182105'))
  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."completionStatus" = 'Completed'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182105'))
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 DEN04LA145Accident · No injuriesLimited investigationFinal reportBell 214B-1 · Aspen, COthe inadvertent activation of the engine's fuel shut off valve, resulting in the reduction of engine power to 50 percent due to an improper cannon plug wire repair on the engine's wire harness assembly. Contributing factors include the improper wire repair,…Sep 17, 2004 · N214B · Substantial damage NTSB ANC92FA044Accident · Serious injuriesField investigationFinal reportBell 214B-1 · Hobart Bay, AKFatigue failure of the compressor assembly impeller, and inadequate quality control by the manufacturer. A factor which contributed to the accident was the mountainous/hilly terrain.Mar 6, 1992 · N314RM · Substantial damage NTSB ANC92FA040Accident · 6 fatalField investigationFinal reportBell 214B-1 · Hobart Bay, AKSeparation of the tail rotor and 90 degree gearbox due to the pilot's failure to follow procedures/directives which resulted in the external load cable becoming entangled in the tail rotor. Factors were the turbulent weather and the lack of suitable terrain…Feb 23, 1992 · N814RM · Destroyed NTSB SEA90LA148Accident · No injuriesLimited investigationFinal reportBell BH-214 · Thompson Falls, MTCrew's encounter with soft terrain while attempting an autorotation landing after the failure of the main rotor drive system.Jul 28, 1990 · N314RM · Substantial damage NTSB SEA89LA088Accident · Serious injuriesLimited investigationFinal reportBell 214B-1 · Ketchikan, AKThe pilot misjudging clearance from trees during a hover descent.May 17, 1989 · N614RM · Substantial damage NTSB ATL86FA084Accident · Minor injuriesField investigationFinal reportBell B-214-B-1 · Bullard, GAA helicopter involved in a logging operation was in process of lifting a log when crew reported a 'loud explosion' and a loss of power was experienced. An autorotative landing was accomplished and a small engine fire was extinguished. The 1st stage turbine…Mar 3, 1986 · N114RM · Substantial damage NTSB SEA85LA060Accident · Minor injuriesLimited investigationFinal reportBell 214B1 · Lowell, ORThe acft collided with hilly terrain during an emergency autorotation landing attempt following a reported eng overspeed. The crew reported there was an indication of eng overspeed which they could not control. Post acc examinationrevealed no evidence of…Feb 19, 1985 · N314RM · Substantial damage NTSB SEA79FA031Accident · 2 fatalClosedBell 214B-1 · Darby, MTApr 19, 1979 · N226RM · Destroyed NTSB DEN77FTE74Accident · No injuriesClosedBell 214B-1 · Silverthorne, COAug 13, 1977 · N226RM · No damage NTSB OAK77FVG54Accident · Serious injuriesClosedBell 214B1 · Sawyers Bar, CAJul 30, 1977 · N16805 · Substantial damage NTSB SEA77FA024Accident · 2 fatalClosedBell 214B-1 · Liberty, WAMar 31, 1977 · N90128 · Destroyed NTSB SEA77FYA09Accident · Serious injuriesClosedBell 214B1 · Salmon, IDJan 26, 1977 · N225RM · Substantial damage