NTSB investigations: Bell 206B, NM
13 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.
Cases per year
| 1975 | 1 |
|---|---|
| 1976 | 2 |
| 1979 | 1 |
| 1980 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1987 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2002 | 1 |
| 2013 | 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 c.\"eventStateOrRegion\" = 'NM' 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" = 'NM' 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" 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 CEN13LA158Accident · No injuriesLimited investigationFinal reportBell 206B III · Ponderosa, NMA total loss of engine power for reasons that could not be determined because the postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation.NTSB DEN02FA065Accident · 2 fatalField investigationFinal reportBell 206BIII · Raton, NMThe pilot's failure to maintain clearance of the static wire. Factors were the static wire, and the glaring sunlight condition.NTSB FTW98TA072Accident · Serious injuriesFinal reportBell 206B-III · Reserve, NMThe pilot's inadvertent loss of tail rotor effectiveness. A factor was the high density altitude weather condition.NTSB FTW94LA110Accident · No injuriesLimited investigationFinal reportBell 206B · Belen, NMThe hard landing due to a delayed flare and improper touchdown. A factor was the loss of engine power.NTSB FTW93GA269Accident · No injuriesFinal reportBell 206B · Wht Sands Mr, NMThe pilot's failure to land an adequate distance away from the unsecured parachute.NTSB DEN88LA026Accident · Minor injuriesLimited investigationFinal reportBell 206B III · Albuquerque, NMWhile attempting to retrieve a parachute retarded rocket that came to rest in a tree by hooking the right front skid shoe under the chute, the parachute got hung up in the tree. The helicopter lifted the rocket approx 6 ft into the air before it swung into…NTSB DEN84LA124Accident · No injuriesLimited investigationFinal reportBell 206B · Farmington, NMWhile climbing, there was a heavy smell of fuel. At aprx 150 ft AGL on a precautionary landing, the eng quit. The helicopter impacted hard, collapsing the skids, & the main rotor blades sheared of the tail boom. During an investigation, the fuel hose b-nut…NTSB FTW82FQA15Accident · 1 fatalFinal reportBell 206B · Watrous, NMThe helicopter struck power and communication lines after taking off at night. After hitting the lines, it crashed into a railroad grade and bridge. The crash site was about one mile from the departure point. An inspection of the engine revealed no preimpact…NTSB FTW80FQA28Accident · No injuriesClosedBell 206B · Albuquerque, NMNTSB DEN79FA046Accident · No injuriesClosedBell 206B · Gobernador, NMNTSB DEN77DQA03Accident · No injuriesClosedBell 206B · Aztec, NMNTSB DEN76AD041Accident · No injuriesClosedBell 206B · Gobernador, NMNTSB DEN75AD052Accident · No injuriesClosedBell 206B · Gobernador, NM