NTSB investigations: Bell 206L-3, CO
7 cases on aircraft the registry lists as Bell 206L-3. 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
| 1984 | 2 |
|---|---|
| 1988 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2002 | 1 |
| 2014 | 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\" = 'CO' 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 ('1182108'))
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" = 'CO' 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 ('1182108'))
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 CEN14FA122Accident · 3 fatalField investigationFinal reportBell 206L 3 · Silt, COThe pilot’s inadequate preflight planning for a low-level aerial surveillance flight of power transmission lines, which led to his being unaware of the crossing power line while flying toward the sun and his subsequent failure to maintain sufficient clearance…NTSB DEN02LA101Accident · Serious injuriesLimited investigationFinal reportBell 206L-III · Canon City, COthe pilot's failure to maintain clearance of a static wire, and the subsequent loss of aircraft control due to the main rotor pitch change tubes being severed.NTSB FTW97LA217Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Weston, COthe pilot's improper in-flight planning/decision and failure to maintain adequate altitude and/or clearance from rising mountainous/hilly terrain. The unfavorable wind condition and low airspeed were related factors.NTSB FTW94LA071Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Cascade, COThe pilot's improper in-flight planning which resulted in the aircraft's yaw performance being exceeded. A factor was the high density altitude.NTSB DEN89FA019Accident · 2 fatalField investigationFinal reportBell 206L-3 · Deckers, COWhile on a corporate flt thru a canyon in marginal wx conds, the helicopter collided with the static portion of a power transmission line & crashed. The acdnt occurred where a 2,554 ft span of the power line crossed the south platte river. The power line…NTSB DEN84FA290Accident · Serious injuriesField investigationFinal reportBell 206L-3 · Denver, COPlt had slowed the helicopter to 30 KIAS using 50 to 60% pwr at an alt of 700 ft AGL. Plt the heard 'two beeps' from the eng out warning horn, saw eng out annunciator lights illuminate & the 'turbine neddle dropping.' Plt 'bottomed'the collective, lowering…NTSB DEN84LA093Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Lake City, COThe helicopter took off in marginal VMC conditions at close to conditions requiring maximum performance for takeoff. The plt attempted to hover at 90 percent RPM waiting he said 'for a breeze'. The hover stirred up snow causing a whiteout and loss of visual…