Fatal NTSB investigations: Bell 206L
9 cases on aircraft the registry lists as Bell 206L. 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 |
|---|---|
| 1980 | 1 |
| 1985 | 3 |
| 1990 | 1 |
| 1998 | 1 |
| 2001 | 1 |
| 2016 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181522'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('1181522'))
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 ERA16FA144Accident · 5 fatalField investigationFinal reportBell 206 · Pigeon Forge, TNAn inflight loss of engine power due to a failure of the engine fuel pump, which resulted in a collision with trees and terrain during the subsequent autorotation. The failure of the engine fuel pump resulted from the absence of adequate grease leading to…NTSB SEA02FA008Accident · 3 fatalField investigationFinal reportBell 206L · Anchorage, AKThe pilot's failure to maintain clearance from the surface of an open body of water while intentionally attempting to maintain a very low altitude while in cruise flight. Factors include falling snow, low ceilings, whiteout/greyout conditions, and flat/glassy…NTSB CHI98FA159Accident · 4 fatalField investigationFinal reportBell 206L-1 · Arlington Hgts, ILLoss of helicopter control for unknown reasons.NTSB NYC90FA067Accident · 1 fatalField investigationFinal reportBell 206L · New York City, NYThe pilot's misjudgement of the wind resulting in a downwind takeoff. Additionally the loss of lift when the helicopter flew off the heliport platform, prior to reaching effective translational lift, resulted in the helicopter settling into the water.NTSB MKC86FA037Accident · 3 fatalField investigationFinal reportBell 206L · Ainsworth, NEThis med-evac helicopter was being positioned to pick up a patient. The plt obtained a wx briefing which included a forecast for a chance of marginal VMC along the planned route, although at the time of the briefing the dest weather was VMC. The flt departed…NTSB ATL85FA170Accident · 2 fatalField investigationFinal reportBell 206L · Duluth, GAAfter loading a seriously burned patient in the helicopter, the plt started the eng & lifted off from the hospital parking lot. Immediately after lift-off, he started forward translational flt. About 65 ft from the lift-off point, an advancing main rotor…NTSB ATL85FA112Accident · 4 fatalField investigationFinal reportBell 206L · Dauphin Island, ALPlt departed for offshore oil rig 3 times. Two times reported returning due to fog. After third report, plt said he was IFR. No further radio communication. Wreckage indicative of high speed water impact. Dense fog and low ceiling reported offshore south of…NTSB FTW80FA069Accident · 2 fatalClosedBell 206L-1 · Gibson, LANTSB NYC78FA020Accident · 3 fatalClosedBell 206L · Courtney, PA