Final NTSB investigations: Aerospatiale SE3160 ALOUETTE III
10 cases on aircraft the registry lists as Aerospatiale SE3160 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 | 2 |
|---|---|
| 1974 | 1 |
| 1975 | 1 |
| 1978 | 1 |
| 1982 | 2 |
| 1984 | 3 |
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.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680605'))
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."completionStatus" = 'Completed'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680605'))
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 DEN85LA004Accident · Minor injuriesLimited investigationFinal reportAerospatiale SE316B · East Glacier, MTThe acft crashed at a remote landing site while on a seismic operation. The plt stated that he departed a ridge- top with intentions of dropping off 2 to 4 passg at another ridgetop located one-half mi south. The intended ldg point was a narrow ridgetop at…NTSB DEN84LA239Accident · No injuriesLimited investigationFinal reportAerospatiale 316B · Naturita, COOne of the axial compressor blades separated resulting in internal engine damage and loss of engine power. Examination of the blades showed evidence of corrosion beyond acceptable limits. The engine was not equipped with an air filter or particle separator.…NTSB DEN84LA139Accident · No injuriesLimited investigationFinal reportAerospatiale 316B · Near Dillon, COWhen the plt took off from a mountainous ski area, light to moderate snow was falling & the winds were coming up the valley at 5 to 10 KTS. During the flt, he encountered an estimated 35 kt upslope wind as he was proceeding on the upwind side of a ridge at an…NTSB LAX82FA232Accident · 3 fatalField investigationFinal reportAerospatiale SA-316B · Dardanelle, CAThe pilot took off from modesto, CA on a medivac flight to pick up a victim that was injured in an automobile accident. A nurse and a medical technician were on board. Spotlights on vehicles were used to illuminate the landing area as well as high surrounding…NTSB LAX82FA117Accident · Serious injuriesField investigationFinal reportAerospatiale SA316B · Near Brideport, CAAfter taking off in a mountainous area, the pilot began climbing in up-currents on the side of a canyon. While following a ridge at about 100 ft AGL (11,000 ft MSL), he heard a loud noise that was followed by a shudder and vibrations. The helicopter began…NTSB DEN78FTE91Accident · Minor injuriesClosedAerospatle SA316B · Norwood, CONTSB OAK75AP049Accident · No injuriesClosedAlouette III · Avery, CANTSB ANC75AA015Accident · Serious injuriesClosedAerospatle SE3160 · Colorado Sta, AKNTSB DEN73FTC05Accident · Serious injuriesClosedAlouette III · Greybull, WYNTSB LAX72FUJ97Accident · No injuriesClosedS.N.I.A.S. SE3160 · Mayer, AZ