NTSB investigations: Turbomeca ARTOUSTEIIIB, 1982
4 cases on aircraft whose registry engine model is Turbomeca ARTOUSTEIIIB. 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 |
|---|---|
| 1976 | 1 |
| 1977 | 1 |
| 1978 | 3 |
| 1979 | 2 |
| 1980 | 2 |
| 1981 | 3 |
| 1982 | 4 |
| 1984 | 4 |
| 1985 | 1 |
| 1987 | 1 |
| 1990 | 3 |
| 1993 | 4 |
| 1996 | 1 |
| 1997 | 1 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2005 | 1 |
| 2007 | 1 |
| 2010 | 1 |
| 2012 | 2 |
| 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.engine_model_code IN ('60003'))
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.engine_model_code IN ('60003'))
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 DEN82FTM13Accident · Serious injuriesFinal reportAerospatiale 315B · Coalville, UTDuring a seismic exploration flight the eng quit. No eng malfunction was found.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…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…