NTSB investigations: Aerospatiale SA316B ALOUETTE III
4 cases on aircraft the registry lists as Aerospatiale SA316B ALOUETTE III, where the first occurrence was “Loss of control - in flight”. 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
| 1984 | 2 |
|---|---|
| 1990 | 1 |
| 1993 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680515')
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\" = 250))
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 ('8680515')
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" = 250))
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 FTW93LA203Accident · Serious injuriesLimited investigationFinal reportAerospatiale SA316B · Snyder, TXFailure of the pilot in command to properly compensate for wind conditions resulting in the loss of directional control through loss of tail rotor authority. Factors were high winds, high density altitude, and failure to jettison the external load.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 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 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…