Fatal NTSB investigations: Aerospatiale AS 355 F ECUREUIL
5 cases on aircraft the registry lists as Aerospatiale AS 355 F ECUREUIL. 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
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1988 | 1 |
| 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.\"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 ('8680806'))
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 ('8680806'))
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 FTW99FA001Accident · 1 fatalField investigationFinal reportBell 407 · Vermilion 331the failure of both pilots to see and avoid each other's aircraft during cruise flight. Factors were the failure of both pilots to use a known safety advisory recommendation and the failure of both operators to implement the recommendation as a company…NTSB FTW89FA013Accident · 4 fatalField investigationFinal reportAerospatiale AS-355F-1 · W. Cameron 617The loss of control of the aircraft which occurred when the tail rotor drive shaft experienced a fatigue induced material failure and tail rotor thrust was lost. Evidence indicated that the shaft was under designed for the loads that were encountered during…NTSB FTW84FA189Accident · 4 fatalField investigationFinal reportAerospatiale AS 355F · W Cameron 540While the plt was taking off from an unmanned rig, the tail section of the helicopter contacted a rotating beacon support bracket on top of a crane structure. The crane structure was located below the elevation of the landing pad. The helicopter then crashed…NTSB FTW84FA107Accident · 2 fatalField investigationFinal reportAerospatiale AS-355F · Morgan City, LAThe plts in a helicopter encountered foggy weather during a positioning flt and crashed into a lake about 4 mi from the departure point, a fisherman who witnessed the accident said the acft descended into the water in a nose low attitude. The acft skipped and…NTSB LAX84FA095Accident · 3 fatalField investigationFinal reportAerospatiale AS 355F · Black Mountain, NVThe helicopter tookoff on an air ambulance flt at about 1219 PST. According to tower personnel, the departure appeared normal. Radar service was terminated at 1227 & there was no further radio contact with the helicopter. Later, the helicopter was found where…