NTSB investigations: Aerospatiale SA315B, 1982
7 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.
Cases per year
| 1976 | 1 |
|---|---|
| 1977 | 3 |
| 1978 | 2 |
| 1979 | 3 |
| 1980 | 3 |
| 1981 | 2 |
| 1982 | 7 |
| 1983 | 2 |
| 1984 | 4 |
| 1985 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 3 |
| 1990 | 4 |
| 1992 | 1 |
| 1993 | 2 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 2 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2005 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2012 | 1 |
| 2024 | 1 |
| 2026 | 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 year(c.\"eventDate\") = 1982
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 year(c."eventDate") = 1982
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" 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 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…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…NTSB DEN82DA118Accident · Minor injuriesFinal reportAerospatiale SA 315 B · 35 Se Moab, UTHelicopter lifting sling loads lost power in a hover. Pilot jettisoned load and made a forced landing in a ravine, engine had dirt buildup and erosion in the compressor inlet case which led to compressor stall.NTSB DEN82DTI15Accident · Serious injuriesFinal reportAerospatiale SA 315B · White Sulphur S, MTThe pilot landed beside a small building (called a dog house) which contained seismic instruments and recording equipment. He was scheduled to move the building and hooked a long line from it to the helicopter. After waiting about 45 minutes for final…NTSB DEN82FTM13Accident · Serious injuriesFinal reportAerospatiale 315B · Coalville, UTDuring a seismic exploration flight the eng quit. No eng malfunction was found.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…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…