NTSB investigations: S N I A S AS350D ASTAR, 1982
6 cases on aircraft the registry lists as S N I A S AS350D ASTAR. 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
| 1979 | 2 |
|---|---|
| 1980 | 4 |
| 1981 | 8 |
| 1982 | 6 |
| 1983 | 3 |
| 1985 | 3 |
| 1986 | 3 |
| 1988 | 1 |
| 1989 | 6 |
| 1990 | 3 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 5 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2014 | 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.aircraft_model_code IN ('8680803'))
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.aircraft_model_code IN ('8680803'))
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 FTW83FRA03Accident · Serious injuriesFinal reportS.N.I.A.S. AS350D · Houston, TXThe pilot stated that as he came to a hover to land, an engine surge occurred which sent the helicopter back into the air. Reportedly, the engine continued to surge off and on, and as helicopter came down, it would impact the ground and bounce back in the…NTSB DEN82IA150Incident · No injuriesIncident investigationFinal reportAerospatiale 350D · Near Winter Par, COWitnesses who were aboard the aircraft stated that the aircrafts rotor struck a tree during a "straffing run" on a railroad trestle just below the Continental divide. The pilot stated that the engine flamed out as he passed over the trestle. The aircraft was…NTSB FTW82DA285Accident · No injuriesFinal reportAerospatiale AS-350D · Gulf Of MexicoDuring an over water flight, the engine chip detector light illuminated and shortly thereafter, the engine failed. The pilot made an autorotative landing in the Gulf Of Mexico with no further damage. All three rotor blades were full of holes and tears and one…NTSB FTW82DA150Accident · No injuriesFinal reportAerospatiale AS-350D · Houston, TXThe purpose of the flight was for the pilot to practice maneuvers in preparation for a part 135 check ride. The pilot was practicing power recovery autorotations to a height of about 5 ft ag. He reported that on his fourth autorotation, the engine did not…NTSB LAX82DA147Accident · 1 fatalFinal reportS.N.I.A.S. AS350 · Gold Strike, NVThe helicopter had just returned from a sightseeing tour of the grand canyon. The pilot reported that the passengers wanted to get out while the helicopter was undergoing its two-minute, cool-down period. The pilot escorted four of the passengers from the…NTSB ATL82DA100Accident · Minor injuriesFinal reportS.N.I.A.S. AS350D Astar · Alcoa, TNWhile preparing to land, the pilot experienced a tail rotor drive failure at a speed of less than 60 knots. At that speed, he was unable to make the necessary right turn from his position to land on the runway. Instead, he climbed about 50 ft in a left turn…