NTSB investigations: Bell Helicopter Textron 206L-1
12 cases on aircraft the registry lists as Bell Helicopter Textron 206L-1, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1985 | 1 |
| 1988 | 2 |
| 1989 | 1 |
| 1990 | 2 |
| 1998 | 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\" = 351))
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" = 351))
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 LAX98LA140Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Los Angeles, CAAn overtemp of the engine during start within 10 hours of the accident, and the failure to report the event to the maintenance facility.NTSB ANC90FA117Accident · Serious injuriesField investigationFinal reportBell 206L-1 · Farewell, AKAn internal engine failure due to a thermal fatigue failure of the 1st stage turbine wheel as a result of overtemperature. The high rough/uneven terrain prevented a successful autorotation.NTSB FTW90LA096Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · E. Island Blk15The loss of continuity in the compressor section of the engine due to a fatique failure of the spur adapter gear shaft.NTSB MIA89IA186Incident · No injuriesIncident investigationFinal reportBell 206L-1 · Chiefland, FLEngine failure due to failure of the first stage turbine wheel disk.NTSB FTW89LA021Accident · Serious injuriesLimited investigationFinal reportBell 206L-1 · Gulf-Of-Mexico (Gulf of Mexico)Engine failure for undetermined reasons and the pilot misjudging his altitude during the flare resulting in a hard landing.NTSB LAX88FA330Accident · No injuriesField investigationFinal reportBell 206L-1 · Santa Barbara, CAFailure of the #1 turbine wheel. Contributing to this accident was the unreported over temperature cycles of the engine. Also contributing was the unsuitability of the landing surface from the presence of the 1/4 inch steel sheeting.NTSB FTW85FA100Accident · No injuriesField investigationFinal reportBell 206L-1 · Lafayette, LAThe acft departed at 2040 CST as a flt of 2 on a ferry flt. Shortly after level-off at 700 ft and power stabilized at 72% torque the engine failed and the acft yawed left and right. An autoration was initiated into a soft plowed field with a slight…NTSB FTW84LA414Accident · No injuriesLimited investigationFinal reportBell 206L-1 · West Delta 105While in cruise flt, total pwr loss was experienced. Plt setup autorotative water landing, deployed emergency floats. Right float was not fully inflated by water touchdown, acft rolled right to inverted position. Eng teardown revealed carbon buildup between…NTSB ANC84LA071Accident · No injuriesLimited investigationFinal reportBell 206L-1 · Mt Mckinley Vil, AKThe helicopter experienced an engine failure while cruising at about 600 ft AGL. The pilot made a forced landing during which the main rotor blades collided with trees. Examination of the aircraft fuel system revealed that the check valves located in the fuel…NTSB ANC83FA144Accident · No injuriesField investigationFinal reportBell 206L-1 · Bettles, AKAccording to the plt, the low fuel warning light illuminated when the fuel gage was indicating 200 lbs. He reported he could see the arpt lights & elected to continue the flt. After arriving, he terminated his apch to a 30 to 50 ft hover with no forward…NTSB NYC82DA206Accident · No injuriesFinal reportBell 206L-1 · Ho Ho Kus, NJWhile in straight and level flight at 1000 ft, the pilot heard a "pop" in the engine area. He noted that the turbine outlet temperature (tot) began an immediate rise to the high yellow area initially, the power was reduced to 50% torque and the tot returned…NTSB FTW82DA201Accident · No injuriesFinal reportBell 206L-1 · High Island 389Pilot approaching landing platform heard a loud bang and autorotated to water. Aircraft rolled inverted and was damaged by waves banging it against platform. A teardown of the engine revealed that the first stage turbine wheel, pn 6895801G, had failed and…