NTSB investigations: Bell 206B, 2012
7 cases on aircraft the registry lists as Bell 206B, where the sequence of events included Collision with terr/obj (non-CFIT). 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
| 2008 | 2 |
|---|---|
| 2010 | 2 |
| 2011 | 3 |
| 2012 | 7 |
| 2013 | 4 |
| 2014 | 2 |
| 2015 | 6 |
| 2016 | 5 |
| 2017 | 5 |
| 2018 | 3 |
| 2019 | 4 |
| 2020 | 3 |
| 2021 | 2 |
| 2022 | 4 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
Where
Latest 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 year(c.\"eventDate\") = 2012
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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 year(c."eventDate") = 2012
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')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 CEN13FA009Accident · 1 fatalField investigationFinal reportBell 206B · Crowley, LAThe pilot’s failure to maintain clearance from the broadcast tower guy-wires.NTSB WPR12CA236Accident · No injuriesData collectionFinal reportBell 206B · Burbank, WAThe failure of maintenance personnel to properly torque an air tube fitting, which resulted in a total loss of engine power.NTSB ERA12LA366Accident · No injuriesLimited investigationFinal reportBell 206B · Longboat Key, FLUnknown personnel's failure to comply with the engine manufacturer's engine fuel pump replacement guidance, which resulted in a total loss of engine power due to the engine fuel pump failure.NTSB CEN12LA282Accident · No injuriesLimited investigationFinal reportBell 206B-III · Flora, INThe pilot allowed the helicopter to settle with power.NTSB CEN12LA267Accident · Minor injuriesLimited investigationFinal reportBell 206B · Valley Falls, KSThe pilot’s inadequate compensation for the wind conditions during a hover maneuver, which resulted in a loss of tail rotor effectiveness.NTSB CEN12LA258Accident · Minor injuriesLimited investigationFinal reportBell 206B · Amarillo, TXThe pilot's failure to maintain helicopter control during landing in gusty wind conditions associated with a thunderstorm, which resulted in a loss of tail rotor effectiveness.NTSB WPR12CA183Accident · No injuriesData collectionFinal reportBell 206B · Arvin, CAThe pilot did not maintain clearance from power lines during low altitude maneuvering.