NTSB investigations: Bell 206B, 2002
10 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\") = 2002
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") = 2002
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 NYC03LA031Accident · No injuriesLimited investigationFinal reportBell 206B · Odenton, MDThe pilot's failure to monitor his fuel supply which resulted in a power loss due to fuel exhaustion, and the pilot's misjudged flare, which resulted in a hard landing.NTSB ANC03LA015Accident · 1 fatalLimited investigationFinal reportBell 206B · Kingman, AZThe pilot's failure to maintain altitude/clearance from obstacles during cruise flight, which resulted in the helicopter striking a transmission line, and subsequently the ground.NTSB SEA02LA137Accident · No injuriesLimited investigationFinal reportBell 206B · Elsie, ORThe shattering and separation of the forward right (pilot's) windscreen for undetermined reason(s).NTSB CHI02LA181Accident · No injuriesLimited investigationFinal reportBell 206B · Three Rivers, MIA loss of tail rotor effectiveness.NTSB DEN02FA065Accident · 2 fatalField investigationFinal reportBell 206BIII · Raton, NMThe pilot's failure to maintain clearance of the static wire. Factors were the static wire, and the glaring sunlight condition.NTSB SEA02TA110Accident · No injuriesFinal reportBell 206B · Rainier, WAThe pilot's failure to maintain aircraft control while trying to land. Rough/uneven terrain, inaccurate performance data calculations, inadequate in-flight planning and lack of familiarity with the geographic area were factors.NTSB DEN02LA046Accident · No injuriesLimited investigationFinal reportBell 206B-III · Moab, UTThe pilot's failure to maintain rotor rpm during a forced landing. A contributing factor was fuel starvation.NTSB FTW02LA143Accident · Serious injuriesLimited investigationFinal reportBell 206B · Rosenberg, TXThe pilot's failure to maintain terrain clearance.NTSB FTW02LA117Accident · Minor injuriesLimited investigationFinal reportBell 206B · Walnut Hill, TXThe loss of engine power as a result of the backing off of the PC air line "B" nut due to the improper installation by the company maintenance personnel. Contributing factors were the inadequate preflight by the pilot and the lack of suitable terrain for the…NTSB DEN02LA036Accident · No injuriesLimited investigationFinal reportBell 206B-III · Leadville, COthe pilot's inadvertent flight into adverse weather, which resulted in a collision with terrain. A contributing factor was the downdraft.