NTSB investigations: S N I A S AS350D ASTAR, 1983
3 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\") = 1983
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") = 1983
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 SEA84IA008Incident · No injuriesIncident investigationFinal reportS.N.I.A.S. AS350D · Seattle, WAThe acft sustained a complete failure of the tail rotor drine shaft due to fatigue from stress corrosion precipitated byprevious damage at which time no logbook entry was recorded to indicate that the shaft had been inspected.NTSB ANC83FA122Accident · Serious injuriesField investigationFinal reportAerospatiale AS-350D · Dutch Harbor, AKAprx 2 min after takeoff, the plt & passengers heard a loud muffled boom from behind the firewall, then the rotor RPM began to decay. The plt entered an autorotation & selected a landing area. He noted that the eng was not driving the rotor sys, so he shut it…NTSB FTW83FA238Accident · 1 fatalField investigationFinal reportAerospatiale AS-350D · Venice, LAThe acft crashed into a swamp with low rotor RPM after a failure of the accessory gearbox power output gear. The pilot radioed an emergency call saying he was experiencing severe vibrations and was landing. A few seconds later, he radioed that he was…