NTSB investigations: Aerospatiale SA316B ALOUETTE III, 1984
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
| 1972 | 1 |
|---|---|
| 1973 | 1 |
| 1980 | 1 |
| 1981 | 3 |
| 1982 | 1 |
| 1984 | 4 |
| 1985 | 2 |
| 1987 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 2 |
| 1994 | 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 year(c.\"eventDate\") = 1984
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 year(c."eventDate") = 1984
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 DEN85IA025Incident · Minor injuriesIncident investigationFinal reportAerospatiale SA315B (Lama) · Oak City, UTBoth acft were performing external load operations. N5785V was in level flt to the north. N9362 was in a 60-70 kt slight climb to the southeast. Neither plt, both in rt seats, saw the other acft before contact. Three main rotor blades of N5785V passed through…NTSB DEN85LA020Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA316B · Lima, MTAprx 35 min prior to the accident the seismic operations being conducted about 10 mi NE were secured due to poor visibility and high winds. The plt estimated wind to have been from 180 deg at 40 KTS gusting to 60. As the plt approached the landing zone…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…