NTSB investigations: Bell Helicopter Textron 206L-1, 2002
9 cases on aircraft the registry lists as Bell Helicopter Textron 206L-1. 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
| 1978 | 1 |
|---|---|
| 1979 | 2 |
| 1980 | 5 |
| 1981 | 16 |
| 1982 | 7 |
| 1983 | 5 |
| 1984 | 9 |
| 1985 | 7 |
| 1986 | 4 |
| 1987 | 5 |
| 1988 | 13 |
| 1989 | 4 |
| 1990 | 4 |
| 1991 | 3 |
| 1992 | 1 |
| 1993 | 3 |
| 1994 | 2 |
| 1995 | 4 |
| 1996 | 1 |
| 1997 | 5 |
| 1998 | 2 |
| 1999 | 5 |
| 2000 | 5 |
| 2001 | 4 |
| 2002 | 9 |
| 2003 | 4 |
| 2004 | 4 |
| 2005 | 5 |
| 2006 | 5 |
| 2007 | 4 |
| 2008 | 3 |
| 2009 | 5 |
| 2010 | 1 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 7 |
| 2014 | 1 |
| 2015 | 3 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 3 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 3 |
| 2024 | 1 |
| 2025 | 1 |
| 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 ('1182107'))
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 ('1182107'))
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 IAD03LA015Accident · No injuriesLimited investigationFinal reportBell 206L1 · Albany, KYThe pilot's inadequate in-flight planning, which resulted in an angle of approach in relative wind conditions conducive to a loss of helicopter tail rotor effectiveness. A factor was the obstacles surrounding the landing field.NTSB FTW03LA015Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Edinburg, TXThe loss of tailrotor effectiveness due to the right quartering tailwind, which resulted in a hard landing. Factors were the lack of suitable surrounding terrain for landing, which included numerous surrounding obstacles, and the tailwind.NTSB LAX02LA295Accident · No injuriesLimited investigationFinal reportBell 206L-1 · North Las Vegas, NVthe pilot's inadequate in-flight planning/decision, which resulted in fuel exhaustion and loss of engine power due to an inadequate fuel supply.NTSB CHI02FA288Accident · 4 fatalField investigationFinal reportBell 206L-1 · Doland, SDPilot spatial disorientation while flying in dark night conditions, resulting in a loss of aircraft control; and the company's inadequate remedial actions after identifying the pilot's night flying deficiency over areas without lighted references. A factor to…NTSB FTW02LA228Accident · No injuriesLimited investigationFinal reportBell 206L-1 · E Cameron 190The loss of engine power for undetermined reasons.NTSB FTW02LA176Accident · No injuriesLimited investigationFinal reportBell 206L-3 · Dover, ARThe pilot's failure to maintain clearance with trees during the approach. A contributing factor was dark night light conditions.NTSB LAX02LA178Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Meadview, AZthe pilot's failure to maintain distance and altitude during landing approach, resulting in the helicopter striking the ground during approach.NTSB DEN02LA044Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Salem, UTa loss of tail rotor effectiveness during takeoff. A contributing factor was the wind gusts.NTSB ATL02FA048Accident · 2 fatalField investigationFinal reportBell 206L-1 · New Smyrna Bch., FLThe pilot continued visual flight into instrument conditions that resulted in the in-flight collision with trees. Factor were the pilot's alcohol impaired condition, and low cloud conditions.