NTSB investigations: Turbomeca ARTOUSTE II series
7 cases on aircraft whose registry engine model is Turbomeca ARTOUSTE II series. 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 2001 | 1 |
| 2007 | 1 |
| 2012 | 1 |
| 2023 | 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.engine_model_code IN ('60002'))
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.engine_model_code IN ('60002'))
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 GAA23WA118Accident · 4 fatalClass 5 · ForeignSud Aviation/Eurocopter Alouette II SE313B · Mangsee Island, PhilippinesNTSB WPR12CA303Accident · No injuriesData collectionFinal reportSud Aviation/Eurocopter Alouette II SE313B · Glenn, CAThe pilot's inadequate compensation for a tailwind while hovering, which resulted in a loss of directional control.NTSB NYC07CA072Accident · No injuriesData collectionFinal reportSud SE3130 Alouette II · Davenport, VAThe pilot's inadequate visual lookout, which resulted in an in flight collision with utility wires during takeoff, and a subsequent impact with terrain.NTSB CHI01FA180Accident · 2 fatalField investigationFinal reportPotez-Air Fouga CM 170 · La Crosse, WIThe fatigue failure of the aircraft's left wing tip fuel tank rear attachment, while the aircraft was being maneuvered in a low approach, leading to the tank's in-flight separation and subsequent in-flight break up of the airplane and the aircraft's control…NTSB ANC88LA046Accident · Minor injuriesLimited investigationFinal reportAerospatiale SA315B · Near Central, AKThe pilot-in-command landed at the 'hot' refueling site and was attempting to exit the helicopter for a crew change. The hot refueling landing pad consisted of a black membrane with bundles of laths placed perpendicular to the helicopter's skids to prevent…NTSB LAX85LA345Accident · No injuriesLimited investigationFinal reportAerospatiale SF3130 · Buckeye, AZDuring a hover in a confined area the plt misinterpeted his passg signal to move to a diferent location as a signal that the tail rotor was in danger. The plt used abrupt control movements that resulted in the toe of a skid hooking into a wire fence. The…NTSB DEN84FA017Accident · No injuriesField investigationFinal reportAerospatiale SE 3180 · Salt Lake City, UTThe helicopter crashed during a landing on the crest of a mountain. The french helicopter unlike American helicopters has a main rotor that rotates clockwise. To compensate for increased torque the plt must use right pedal instead of leftpedal. The plt in…