NTSB investigations: Aerospatiale AS 355 F ECUREUIL

6 cases on aircraft the registry lists as Aerospatiale AS 355 F ECUREUIL, where the first occurrence was “Airframe/component/system failure/malfunction”. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19832026

NTSB investigations: Aerospatiale AS 355 F ECUREUIL per year, 1983–2026: 6 cases
1983	1
1987	1
1988	2
1991	1
1997	1

Where

Open the map

Latest cases

Query with SQL

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 ('8680806') 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" = 130)) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('8680806')
      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\" = 130))
  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 ('8680806')
    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" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 NYC97LA058Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS-355F · Washington, PAThe malfunction of a cyclic servo which resulted in a cyclic hard over at a hover.Mar 5, 1997 · N101UC · Substantial damage NTSB SEA92LA029Accident · No injuriesLimited investigationFinal reportAerospatiale AS355F1 · Billings, MTThe unlatching and subsequent opening inflight of the left-rear engine cowl door. A factor contributing to the accident was the failure of company maintenance personnel to execute the manufacturer's service bulletin.Oct 29, 1991 · N101UC · Substantial damage 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…Nov 4, 1988 · N355EH · Destroyed NTSB ATL88IA171Incident · No injuriesIncident investigationFinal reportAerospatiale AS-355-F · Reidsville, NCMay 13, 1988 · N101UC · Minor damage NTSB FTW87FA203Accident · Serious injuriesField investigationFinal reportAerospatiale AS-355F-1 · Ship Shoal 214cAcft experienced a tail rotor drive shaft failure during t/o from an offshore platform. Acft spun left and completed 6 to 7 revolutions prior to water contact as the single plt could not reach the throttles to reduce pwr to idle. Acft landed hard and the rt…Aug 19, 1987 · N359E · Substantial damage 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…Dec 7, 1983 · N57901 · Destroyed