NTSB investigations: Bell Helicopter Textron 206L-1
13 cases on aircraft the registry lists as Bell Helicopter Textron 206L-1, where the first occurrence was “In flight collision with object”. 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
| 1984 | 1 |
|---|---|
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1995 | 1 |
| 1999 | 2 |
| 2001 | 1 |
| 2002 | 1 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182107')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1182107')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 DFW08IA002Incident · No injuriesIncident investigationFinal reportBell Helicopter Textron 206L-1 · Galveston, TXThe loss of tail rotor control during initial takeoff climb due to the fracture of a tail rotor blade as result of impact with a foreign object.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 ANC01LA030Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Tyonek, AKThe pilot's failure to maintain adequate tail rotor clearance while maneuvering to land.NTSB SEA00LA020Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Neihart, MTClearance from an object was not maintained. Gusting wind conditions was a factor.NTSB NYC99GA234Accident · Serious injuriesFinal reportBell 206L-1 · Randolph, NYThe pilot's failure to maintain visual separation from the wires. A factor was sunglare.NTSB LAX95FA313Accident · 2 fatalField investigationFinal reportBell 206-L1 · Johnsondale, CAthe pilot's failure to maintain an adequate obstacle clearance altitude while operating at a very low level. The aircraft's lack of wire cutters was a factor in this accident.NTSB MKC89LA041Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Linwood, KSPoor in-flight planning and decision, inadequate visual lookout, and clearance not attained by the pilot in command.NTSB LAX88LA304Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Barrett Junct., CAWhile descending into a canyon, the aircraft struck powerlines, went into an uncontrolled descent and collided with the terrain. The pilot stated that he could not see the powerlines and that his visibility was restricted by the sun. All four passengers…NTSB FTW87LA194Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Eugene IslandThe acft experienced a main rotor blade strike during takeoff from an offshore platform. The rotor blade struck the underside of a cable raceway on a drilling rig that was situated adjacent to the platform helideck. The raceway was 9 feet laterally and 22…NTSB SEA86LA204Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · Grangeville, IDThe helicopter plt was on an emergency medical service (ems/medivac) flt to transport survivors from an airplane accident. He landed at night on a ridge about 1/4 mi from the airplane crash site. At about 2400 MDT, the plt attempted to takeoff from the…NTSB MKC86FA020Accident · 1 fatalField investigationFinal reportBell 206L-1 · Mansfield, MOAfter departing west plains hospital for springfield, transferring a critically injured patient, the plt of the EMS helicopter began to encounter deteriorating weather. The plt was concerned about the close spread of temperature and dew point, but had…NTSB FTW85FA287Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Saginaw, TXThe helicopter had landed in the road to pick up an injured auto accident patient. The plt made an aerial check prior to landing to the west in a calm wind condition. The patient was loaded in a secure stretcher and all was ready for liftoff. The plt stated…NTSB FTW84LA316Accident · Minor injuriesLimited investigationFinal reportBell 206L-1 · High Isl Blk298The helicopter skid contacted a net fence around the landing platform on an oil rig. The safety net broke and the acft rocked over the side of the platform. The plt attempted to autorotate into the water. The landing was hard and one floatseparated. The…