NTSB investigations: Turbomeca ARTOUSTEIIIB, CO
7 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
| 1978 | 1 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1993 | 1 |
| 1998 | 1 |
| 2002 | 1 |
| 2007 | 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.\"eventStateOrRegion\" = 'CO' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'CO' AND c."eventCountry" = 'USA'
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 DEN07CA073Accident · No injuriesData collectionFinal reportAerospatiale SA315B · Norwood, COThe inflight collision with a bird(s).NTSB DEN02GA085Accident · 1 fatalFinal reportAerospatiale SA315B · Estes Park, COthe pilot's abrupt collective input during water application to a forest fire. Contributing factors were encountering a vortex ring state, the inadvertent settling with power, the low altitude, and the mountainous terrain.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.NTSB DEN93FA038Accident · 3 fatalField investigationFinal reportAerospatiale SA316B · Aspen, COFailure of the flight control lower mixing unit due to fatigue, which resulted in the loss of control.NTSB DEN85FA241Accident · 1 fatalField investigationFinal reportAerospatiale SA315B · Craig, COThe helicopter was long-lining a 1280-pound air compressor to an 8500-foot MSL mountain drilling site. Witnesses heard a squealing sound and bang. They observed gray-white smoke and orange-blue flame emitting from the exhaust. The plt released the load and…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 DEN78FTE91Accident · Minor injuriesClosedAerospatle SA316B · Norwood, CO