Skip to content

NTSB investigations: Bell 206B, MT

15 cases on aircraft the registry lists as Bell 206B. 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

19722026

Where

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."eventStateOrRegion" = 'MT' 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 ('1181511')) 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.\"eventStateOrRegion\" = 'MT' 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 ('1181511'))
  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" = 'MT' 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 ('1181511'))
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 WPR14CA041Accident · No injuriesData collectionFinal reportBell 206B · Superior, MTThe pilot's failure to maintain aircraft control while maneuvering during a long-line operation.Nov 2, 2013 · N888DR · Substantial damage NTSB WPR13FA208Accident · 1 fatalField investigationFinal reportBell 206B · Shepherd, MTThe pilot’s loss of control while maneuvering during low-altitude operations due to sudden neurological impairment or incapacitation and the helicopter’s subsequent collision with power lines.Apr 27, 2013 · N150SP · Substantial damage NTSB WPR11CA101Accident · No injuriesData collectionFinal reportBell 206B3 · Three Forks, MTThe pilot’s inadequate use of throttle during the practice autorotation that resulted in a hard landing.Jan 15, 2011 · N78BR · Substantial damage NTSB WPR10CA100Accident · No injuriesData collectionFinal reportBell 206B · Kalispell, MTThe pilot's failure to maintain lateral drift control during landing.Jan 7, 2010 · N127TP · Substantial damage NTSB SEA07CA200Accident · Minor injuriesData collectionFinal reportBell 206B II · Sheep Mountain, MTThe external load net, attached directly to the cargo hook without the use of a long line, oscillated and made contact with the tail rotor system while maneuvering.Jul 16, 2007 · N164JS · Substantial damage NTSB SEA07CA069Accident · No injuriesData collectionFinal reportBell 206 B3 · Custer, MTThe pilot’s failure to maintain clearance between the tail rotor of his helicopter and a piece of farm equipment during the landing sequence.Mar 5, 2007 · N150SP · Substantial damage NTSB SEA95GA062Accident · No injuriesFinal reportBell 206 · Dillon, MTThe pilot's selection of a landing site that was not suitable to support the weight of the helicopter. Factors include terrain covered with soft snow.Feb 24, 1995 · N2277T · Substantial damage NTSB DEN83FA045Accident · 1 fatalField investigationFinal reportBell 206B III · Sula, MTThe helicopter crashed tail low and rolled over in an open field during marginal weather. The pilot was flying on an expired student certificate and expired medical. According to a pilot who had worked with him the pilot had no helicopter rating. Witnesses…Jan 6, 1983 · N55LW · Substantial damage NTSB DEN83LA022Accident · No injuriesLimited investigationFinal reportBell 206B · Near Kalispell, MTAcft departed hospital at missoula in good wx to assist highway accident victim 5 mi east of clinton. Victim was placed aboard helicopter on stretcher for emergency flight to hospital. About 5-6 mi east of missoula plt noticed light snow falling & observed a…Nov 21, 1982 · N5011G · Substantial damage NTSB DEN82FTI02Accident · No injuriesClosedBell 206B · Whitehall, MTOct 25, 1981 · N90142 · Substantial damage NTSB DEN81FTA04Accident · Minor injuriesClosedBell 206B · Columbus, MTJan 28, 1981 · N8533K · Substantial damage NTSB SEA79FTA19Accident · No injuriesClosedBell 206B · Absarokee, MTAug 28, 1979 · N5013C · Substantial damage NTSB SEA76FTA09Accident · No injuriesClosedBell 206B · Miles City, MTDec 14, 1975 · N59495 · Substantial damage NTSB SEA74FTA07Accident · Minor injuriesClosedBell 206B · Lewistown, MTSep 10, 1973 · N8110J · Destroyed NTSB SEA73FTI01Accident · Minor injuriesClosedBell 206A · Paradise, MTJul 8, 1972 · N6273N · Substantial damage