NTSB investigations: Bell Helicopter Textron 206L-1, IN
6 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
| 1979 | 1 |
|---|---|
| 2003 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2008 | 1 |
| 2018 | 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\" = 'IN' 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 ('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 c."eventStateOrRegion" = 'IN' 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 ('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 GAA18CA424Accident · No injuriesData collectionFinal reportBell 206 · New Castle, INThe pilot's failure to ensure that the fill hose was disconnected from the helicopter before takeoff, which resulted in the fill hose striking the tail rotor and the subsequent loss of tail rotor effectiveness. Contributing to the accident was inadequate…NTSB CHI08FA269Accident · 3 fatalField investigationFinal reportBell 206L-1 · Greensburg, INThe in-flight separation of a main rotor blade due to a fatigue failure of the blade spar, rendering the helicopter uncontrollable, and the manufacturer's production of main rotor blades with latent manufacturing defects, which precipitated the fatigue…NTSB CHI06LA074Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Chesterfield, INThe pilot's failure to maintain aircraft control after becoming spatially disorientated shortly after departure. Contributing to the accident was the pilot's inadequate preflight weather evaluation, his inadvertent flight into night instrument meteorological…NTSB CHI04FA107Accident · 1 fatalField investigationFinal reportBell 206L-1 · Boonville, INThe pilot's inadequate planning/decision which resulted in his failure to maintain terrain clearance. Contributing factors were the pilot's inadequate preflight planning, his diverted attention, and the dark night conditions.NTSB CHI03LA319Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Shoals, INThe pilot not maintaining a proper descent rate during the touchdown once visual reference was reduced by the dust in the rotor downwash. Factors were the dusty gravel landing area and the pilot's visual lookout not being possible due to the dust the rotor…NTSB CHI79FEX26Accident · No injuriesClosedBell 206-11 · Indianapolis, IN