NTSB investigations: Aerospatiale SA316B ALOUETTE III, WY
4 cases on aircraft the registry lists as Aerospatiale SA316B ALOUETTE III. 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
| 1982 | 1 |
|---|---|
| 1984 | 2 |
| 1990 | 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.\"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 ('8680515'))
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 ('8680515'))
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 DEN90FA172Accident · Serious injuriesField investigationFinal reportAerospatiale SA316B · Meeteetse, WYA main rotor head blade dampener failure. A factor in the accident was the subsequent failure of a blade restraining cable.NTSB DEN84LA282Accident · No injuriesLimited investigationFinal reportAerospatiale 316B Alouette III · Cokeville, WYThe plt stated that he lost tailrotor control while maneuvering for a landing. He elected to return to Cokeville airport and make the landing. The plt executed an aitorotation to the runway and during the landing flare, the tail skid struck the runway,…NTSB DEN84LA168Accident · No injuriesLimited investigationFinal reportAerospatiale SA316B · Alcova, WYPlt stated that the approach and landing were normal until ground resonance started and the brakes did not hold. The plt attempted to pick back up to a hover to reposition, but lost directional control. The acft yawed and rolled to the left on nose. The plt…NTSB DEN82DA130Accident · Serious injuriesFinal reportAerospatiale SA316B · Meeteetse, WYPrior to this flight, a long line had been attached to the helicopter for an external load operation. However, there wasa change in the schedule and the pilot was instructed to return to the base camp with six passengers. When the pilot took off, he was…