NTSB investigations: Eurocopter AS 350 B2
58 cases on aircraft the registry lists as Eurocopter AS 350 B2. 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, newest first
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 ('8680950'))
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 ('8680950'))
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 FTW01LA121Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Houston, TXthe failure of the pilot to maintain control of the helicopter following an inadvertent deactivation of the hydraulic system, during final approach. A contributory factor was the unguarded hydraulic cut-off switch.NTSB LAX01TA119Accident · No injuriesFinal reportEurocopter France AS350-B2 · Hayward, CAThe fatigue fracture of the engine accessory drive gear while maneuvering, which resulted in a loss of engine power and collision with a residential transmission line during the ensuing forced landing. A factor associated with the accident was the residential…NTSB LAX01LA083Accident · Minor injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Lihue, HIThe manufacturer's inadequate collective lock design, which resulted in the collective unlocking during a preflight check and subsequent unintentional liftoff and loss of helicopter control. The pilot's loss of control was due in part to the unavailability of…NTSB ANC01LA020Accident · No injuriesLimited investigationFinal reportEurocopter AS-350B2 · Girdwood, AKThe pilot's failure to maintain adequate altitude/clearance from terrain. A factor in the accident was flat light conditions.NTSB FTW00LA153Accident · Minor injuriesLimited investigationFinal reportEurocopter AS350B2 · Patterson, LAthe failure of the tail rotor spider bearing, the pilot's failure to follow the proper emergency procedures as stated in the helicopter's checklist by not performing a run-on landing, and the inadvertent deactivation of the hydraulic system.NTSB LAX00LA195Accident · No injuriesLimited investigationFinal reportEurocopter AS350B2 · Mesa, AZthe instructor pilot's failure to maintain control of the helicopter.NTSB ANC99FA139Accident · Serious injuriesField investigationFinal reportEurocopter AS-350B-2 · Juneau, AKThe pilot's continued flight into instrument meteorological conditions (IMC), and inadequate altitude/clearance. Factors associated with the accident were flat light and whiteout conditions, snow, and snow-covered terrain. An additional factor was the FAA's…NTSB ANC99LA036Accident · No injuriesLimited investigationFinal reportEurocopter AS-350-B2 · Girdwood, AKThe pilot's misjudged flare while landing. Factors associated with the accident were whiteout conditions, and snow-covered terrain.