NTSB investigations: Aerospatiale SA315B, WY

11 cases on aircraft the registry lists as Aerospatiale SA315B. 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

19772026

NTSB investigations: Aerospatiale SA315B, WY per year, 1977–2026: 11 cases
1977	1
1980	2
1982	4
1984	2
1988	1
2001	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."eventStateOrRegion" = 'WY' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680615')) 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.\"eventStateOrRegion\" = 'WY' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680615'))
  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."eventStateOrRegion" = 'WY' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680615'))
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 DEN01LA125Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Cody, WYthe failure of the turbine assembly due to an over temperature condition. A contributing factor was the lack of suitable terrain for a forced landing.Jul 17, 2001 · N2128Z · Substantial damage NTSB DEN88FA151Accident · Serious injuriesField investigationFinal reportAerospatiale SA-315B · Dubois, WYJul 10, 1988 · N47274 · Substantial damage NTSB DEN84LA292Accident · No injuriesLimited investigationFinal reportAerospatiale SA315B Lama · Mountain View, WYThe helicopter experienced a loss of power during an external load operation. The plt released the load and performed an autorotation. A hard landing resulted during which the tail boom was severed by the main rotor blades. Metallurgical examination of the…Sep 17, 1984 · N49532 · Substantial damage NTSB DEN84LA286Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Lyman, WYThe plt stated that engine RPM began deteriorating during a climb to cruise flt. He returned to the landing site where the RPM decayed to flt idle, an autorotation was entered and a hard landing resulted. The engine ran for 1 hour in a test cell after the…Sep 7, 1984 · N62338 · Substantial damage NTSB DEN82DA159Accident · No injuriesFinal reportAerospatiale SA-315B · Afton, WYEn route during a seismic operation a loud screeching, grinding sound was heard. The pilot reported the aircraft seemed to buck. A long flame emitting from the aft end of the aircraft was observed by witnesses. The engine ceased and the aircraft crashed into…Aug 9, 1982 · N10067 · Destroyed NTSB DEN82DA126Accident · No injuriesFinal reportAerospatiale SA 315B · Big Piney, WYThe pilot stated that he felt a shudder while he was taking off with a long line attached. He began a descent, and when the helicopter was about 5 ft above the ground, the long line caught a tree. Subsequently, the helicopter pitched nose down and the rotor…Jul 2, 1982 · N49532 · Substantial damage NTSB DEN82FTC03Accident · Serious injuriesFinal reportAerospatiale SA315B · Big Piney, WYThe acft was engaged in seismic activity supplying explosives by long line. The eng failed at about 400-500 ft AGL. The load was released & an open field was selected. At about 150 ft AGL the plt was unable to maintain rotor RPM & the acft impacted the ground…Apr 20, 1982 · N9007N · Destroyed NTSB DEN82DA088Accident · Minor injuriesFinal reportAerospatiale SA315B · Thayne, WYThe helicopter was hovering to pick up a sling load when a loud bang was heard and the aircraft began to spin counter clockwise. Investigation revealed that the tail rotor drive shaft had broken. "Examination of the shaft break disclosed a small fracture…Apr 15, 1982 · N48089 · Substantial damage NTSB DEN80FA052Accident · 2 fatalClosedAerospatial SA315 · Meeteetse, WYAug 1, 1980 · N47294 · Destroyed NTSB DEN80FA038Accident · No injuriesClosedAlouette SA315B · Jackson, WYJun 11, 1980 · N10067 · Substantial damage NTSB DEN77FTC15Accident · Serious injuriesClosedAerospatial SA315B · Jackson, WYJun 22, 1977 · N62345 · Destroyed