NTSB investigations: Turbomeca ARTOUSTEIIIB, 1984
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\") = 1984
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") = 1984
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 DEN85IA025Incident · Minor injuriesIncident investigationFinal reportAerospatiale SA315B (Lama) · Oak City, UTBoth acft were performing external load operations. N5785V was in level flt to the north. N9362 was in a 60-70 kt slight climb to the southeast. Neither plt, both in rt seats, saw the other acft before contact. Three main rotor blades of N5785V passed through…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 DEN84FA106Accident · Serious injuriesField investigationFinal reportAerospatiale SA-316B · Story, WYOn the day prior to the accident, the plt noted that the fuel gage indicated 30 to 35 gal remaining. He added 40 gal & made a flt of about 15 min. On the next day, he noted that the gage indicated about 40 gal of fuel remaining. The reported fuel consumption…