NTSB investigations: Turbomeca ARTOUSTEIIIB, 1998
3 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\") = 1998
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") = 1998
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 SEA99LA001Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA-315B · Big Sky, MTThe failure of the ground handlers (chokers) to follow procedures, and separation of the tail rotor system. Contributing factors were incorrect long line hook (size), jamming of the hook release, trees and gusty wind conditions.NTSB LAX98TA278Accident · No injuriesFinal reportAerospatiale SA316B · Porterville, CAThe pilot's failure to maintain adequate in-flight clearance between the bucket and trees resulting in the entanglement/separation of the long line and subsequent impact with and separation of the tail rotor assembly. A factor was the trees.NTSB FTW98LA367Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Naturita, COPartial loss of engine power resulting from heat induced deterioration of the gas generator turbine. Factors were a forced landing in hilly unsuitable terrain containing mature trees.