NTSB investigations: S N I A S AS350D ASTAR, LA
8 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 | 1 |
|---|---|
| 1981 | 2 |
| 1983 | 1 |
| 1985 | 2 |
| 1989 | 1 |
| 1990 | 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.\"eventStateOrRegion\" = 'LA' AND c.\"eventCountry\" = 'USA'
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 c."eventStateOrRegion" = 'LA' AND c."eventCountry" = 'USA'
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 FTW90LA143Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350D · Berwick, LAPilot in command's failure to see and avoid obstacles in the landing zone. Contributing to the accident was the pilot's lack of familiarity with the landing zone.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 FTW85FA300Accident · 1 fatalField investigationFinal reportS.N.I.A.S. AS350D Astar · Houma, LAThe plt landed at a microwave antenna tower and did not shut down the eng or deplane. An employee at the tower retrievedcargo from the helicopter (a small box of parts) and went back inside the tower building. Shortly thereafter, the plt apparently initiated…NTSB FTW85FA282Accident · 1 fatalField investigationFinal reportAerospatiale AS-350D · Matagorda Islng, LAThe acft touched down hard during an attempted autorotation to an abandoned air base. Initial touchdown occurred on the stinger and the acft yawed to the left of rwy heading 30 to 40 degrees. The next touchdown was on the skids and the acft yawed further to…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…NTSB FTW82DA007Accident · No injuriesClosedAerospatle AS350D · Houma, LANTSB FTW81FA098Accident · 1 fatalClosedAerospatial AS-350 · Cameron, LANTSB FTW80FRD12Accident · Serious injuriesClosedAerospatle AS-350 · Intracstl Cy, LA