NTSB investigations: Bell 206A, CA
12 cases on aircraft the registry lists as Bell 206A. 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
| 1968 | 2 |
|---|---|
| 1969 | 1 |
| 1970 | 1 |
| 1972 | 2 |
| 1976 | 1 |
| 1982 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1994 | 1 |
| 2025 | 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 ('1181508'))
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 ('1181508'))
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 WPR25LA078Accident · No injuriesClass 4 · LimitedFinal reportBell 206A · Lemoore, CAThe pilot’s failure to maintain clearance from power lines while maneuvering at a low altitude.NTSB LAX94LA221Accident · Minor injuriesLimited investigationFinal reportBell 206A · Ukiah, CAthe pilot's inadequate compensation for the existing wind conditions which resulted in a loss of tail rotor effectiveness event and a subsequent loss of directional control.NTSB LAX85LA194Accident · Serious injuriesLimited investigationFinal reportBell 206A · San Diego, CADuring flt, the eng lost power & the plt began an autorotative landing in a parking lot. During the apch, he maneuvered to avoid a 100 ft crane. As the helicopter was approaching the intended touchdown point, a vehicle was driven into the flt path of the…NTSB LAX84FA483Accident · Minor injuriesField investigationFinal reportBell 206B · Long Beach, CAThe acft experienced a power loss during flare for landing. The plt pulled collective to soften the touchdown from 30 ftagl but the landing was hard. Post accident examination of the engine showed a failure of the #1 turbine disc. Lab exam of the disc showed…NTSB LAX82DA148Accident · No injuriesFinal reportBell 206A · Huntington Beac, CAThe pilot stated that he was on a ferry flight from Huntington beach, CA to an offshore platform. A hard landing was made on the platform. This resulted in damage to the skids, tail rotor, tail boom, and fuel tank.NTSB OAK76AP057Accident · 2 fatalClosedBell 206B · Bishop, CANTSB OAK73DVM05Accident · Minor injuriesClosedBell 206B · Salinas, CANTSB LAX72FUG63Accident · No injuriesClosedBell 206A · La Verne, CANTSB LAX71AL043Accident · 1 fatalClosedBell 206A · Bakersfield, CANTSB LAX69A0061Accident · 2 fatalClosedBell 206A · San Diego, CANTSB LAX69D0203Accident · No injuriesClosedBell 206A · Long Beach, CANTSB LAX68A0096Accident · 5 fatalClosedBell 206A · Carpenteria, CA