NTSB investigations: Eurocopter AS 350 B3
6 cases on aircraft the registry lists as Eurocopter AS 350 B3, where the defining event was Loss of control in flight. 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
| 2009 | 1 |
|---|---|
| 2013 | 2 |
| 2014 | 1 |
| 2017 | 1 |
| 2023 | 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 ('8680954')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '240'))
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 ('8680954')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '240'))
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 WPR23LA200Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B3 · San Diego, CAThe pilot’s failure to maintain altitude during a hover taxi due to distraction resulting from the unanticipated activation of strobing lights while using night vision googles.NTSB GAA17CA404Accident · Minor injuriesData collectionFinal reportEurocopter AS 350 · King Vale, CAThe pilot’s failure to maintain clearance from trees while landing in a dusty, unimproved landing zone.NTSB CEN14IA329Incident · No injuriesIncident investigationFinal reportEurocopter AS 350 B3 · Temple, TXThe pilot’s failure to reposition the yaw servo hydraulic switch to the “on” position during the pretakeoff hydraulic system check, which resulted in a complete lack of hydraulic boost to the tail rotor system and increased the load required to move the…NTSB CEN13FA331Accident · Minor injuriesField investigationFinal reportEurocopter AS 350 B3 · Grand Prairie, TXThe pilot receiving instruction's failure to maintain adequate airspeed during a simulated hydraulics failure training maneuver, which resulted in his loss of control of the helicopter and its subsequent impact with terrain, and the flight instructor's…NTSB ANC13GA036Accident · 3 fatalClass 1Final reportEurocopter AS350 · Talkeetna, AKThe pilot's decision to continue flight under visual flight rules into deteriorating weather conditions, which resulted in the pilot's spatial disorientation and loss of control. Also causal was the Alaska Department of Public Safety's punitive culture and…NTSB ERA09TA440Accident · Minor injuriesFinal reportEurocopter AS 350B3 · Jacksonville, FLThe flight instructor's improper decision to attempt hover flight without hydraulic power and his subsequent loss of control.