NTSB investigations: Bell 206L-3, CA
8 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
| 1993 | 1 |
|---|---|
| 1999 | 1 |
| 2000 | 1 |
| 2004 | 1 |
| 2020 | 1 |
| 2021 | 2 |
| 2024 | 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\" = 'CA' 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" = 'CA' 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 WPR24LA134Accident · No injuriesClass 3 · LimitedFinal reportBell 206L-3 · Tracy, CAA loss of collective control authority due to fatigue failure of the collective servo cylinder extension arms from corrosion pitting.NTSB WPR22LA031Accident · No injuriesClass 4 · LimitedFinal reportBell 206L-3 · Covelo, CAA passenger’s unsecured object departed the cabin resulted in a collision with the tail rotor drive shaft.NTSB WPR21LA133Accident · Minor injuriesClass 4 · LimitedFinal reportBell 206 · Lucerne Valley, CAThe pilot's failure to maintain aircraft control while maneuvering with a tailwind, resulting in the helicopter spinning and colliding with terrain.NTSB WPR20LA163Accident · 3 fatalClass 3 · LimitedFinal reportBell 206 · Fairfield, CAThe pilot’s failure to maintain adequate clearance from powerlines while conducting external load operations, which resulted in the main rotor contacting a wire and a subsequent collision with terrain.NTSB LAX04LA216Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · Palmdale, CAThe momentary loss of engine power for undetermined reasons.NTSB LAX00LA326Accident · No injuriesLimited investigationFinal reportBell 206B-3 · Salinas, CAThe pilot's inadequate visual surveillance of the worksite to see and avoid power transmission wires.NTSB LAX00LA024Accident · No injuriesLimited investigationFinal reportBell 206-L4 · Santa Clarita, CAThe pilot's delay in adding power during a power-on recovery from an autorotation, which resulted in a hard landing and rollover. The flight instructor's inadequate supervision of the flight was also causal.NTSB LAX93GA270Accident · Minor injuriesFinal reportBell 206L-3 · Agoura Hills, CAThe improper configuration of the aerial ignition device by the crew chief and an inadvertent activation of the unit by the pilot. The improper installation and configuration of the unit by maintenance personnel, inadequate crew coordination, and insufficient…