NTSB investigations: S N I A S AS350D ASTAR, 1989
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\") = 1989
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") = 1989
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 FTW90LA003Accident · No injuriesLimited investigationFinal reportAerospatiale 350D · New Iberia, LAThe second pilot's (under instruction) misjudgement of aircraft attitude during the level off phase of the autorotationNTSB ATL89FA220Accident · 1 fatalField investigationFinal reportAerospatiale AS 350D · Chamblee, GAFailure of the main rotor swashplate bearing due to lack of lubricant.NTSB DEN89FA202Accident · 4 fatalField investigationFinal reportAerospatiale AS-350D · Blanchard, IDOverheating and seizure of the swashplate bearing, which resulted in an inflight breakup of the helicopter and subsequent impact with the ground.NTSB LAX89IA242Incident · Minor injuriesIncident investigationFinal reportAerospatiale AS350D · Long Beach, CAThe failure of the engine driven fuel pump.NTSB FTW89FA133Accident · 2 fatalField investigationFinal reportAerospatiale AS-350-D · Galveston, TXFailure of both pilots to see-and-avoid the other aircraft (inadequate visual lookout).NTSB LAX89LA197Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS350D · Waialae Falls, HIImproper maintenance/adjustment of the engine fuel control unit by company maintenance personnel, which resulted in a slight loss of engine power, and failure of the pilot to maintain rotor RPM, while turning and taking off from a hover with a relatively…