NTSB investigations: Bell 206B, 2016
8 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
| 1967 | 1 |
|---|---|
| 1968 | 1 |
| 1969 | 1 |
| 1970 | 1 |
| 1971 | 1 |
| 1972 | 7 |
| 1973 | 12 |
| 1974 | 6 |
| 1975 | 20 |
| 1976 | 16 |
| 1977 | 18 |
| 1978 | 16 |
| 1979 | 18 |
| 1980 | 22 |
| 1981 | 25 |
| 1982 | 14 |
| 1983 | 18 |
| 1984 | 19 |
| 1985 | 18 |
| 1986 | 17 |
| 1987 | 11 |
| 1988 | 12 |
| 1989 | 23 |
| 1990 | 20 |
| 1991 | 13 |
| 1992 | 9 |
| 1993 | 16 |
| 1994 | 22 |
| 1995 | 13 |
| 1996 | 23 |
| 1997 | 15 |
| 1998 | 13 |
| 1999 | 14 |
| 2000 | 15 |
| 2001 | 10 |
| 2002 | 10 |
| 2003 | 17 |
| 2004 | 17 |
| 2005 | 14 |
| 2006 | 8 |
| 2007 | 17 |
| 2008 | 5 |
| 2009 | 4 |
| 2010 | 11 |
| 2011 | 9 |
| 2012 | 11 |
| 2013 | 12 |
| 2014 | 11 |
| 2015 | 8 |
| 2016 | 8 |
| 2017 | 11 |
| 2018 | 8 |
| 2019 | 10 |
| 2020 | 5 |
| 2021 | 7 |
| 2022 | 11 |
| 2023 | 8 |
| 2024 | 9 |
| 2025 | 7 |
| 2026 | 2 |
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 year(c.\"eventDate\") = 2016
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 year(c."eventDate") = 2016
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 WPR17LA019Accident · Serious injuriesLimited investigationFinal reportBell 206B · Yuma, AZThe pilot’s inability to maintain helicopter control after its skid got caught on the landing pad while he was maneuvering the helicopter to land on it, which resulted in a dynamic roll-over.NTSB WPR16LA188Accident · No injuriesLimited investigationFinal reportBell 206B · Rockport, WAThe pilot's failure to maintain helicopter control while on the ground, which resulted in mast bumping.NTSB GAA16CA405Accident · Minor injuriesData collectionFinal reportBell 206 · Outlook, WAThe pilot and ground crew's failure to visually inspect the helicopter's skids before takeoff, which resulted in a water hose becoming entangled on the right skid, a loss of control, an impact with terrain, and a post-crash fire.NTSB CEN16WA402Accident · Serious injuriesForeign investigationBell 206 · Mexico City, MexicoNTSB ERA16CA160Accident · No injuriesData collectionFinal reportBell 206 · Baltimore, MDThe pilot's inadequate compensation for the wind while hovering out of ground effect, which resulted in a loss of tail rotor effectiveness.NTSB GAA16CA165Accident · Minor injuriesData collectionFinal reportBell 206B · Hanford, CAThe pilot's decision to release the collective while flying at 10 feet above ground level, resulting in the rapid helicopter descent and impact with terrain.NTSB WPR16FA072Accident · 1 fatalField investigationFinal reportBell 206B · Honolulu, HIThe in-flight failure of the engine-to-transmission drive shaft due to improper maintenance, which resulted in low main rotor rpm and a subsequent hard landing to water.NTSB ERA16LA104Accident · Serious injuriesLimited investigationFinal reportBell 206 · Linden, NJThe pilot receiving instruction's failure to maintain helicopter control during the initial takeoff, which resulted in a dynamic rollover. Contributing to the accident was the flight instructor's inadequate remedial action due to his distraction by looking…