NTSB investigations: S N I A S AS350D ASTAR, TX
7 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 |
|---|---|
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 2 |
| 1986 | 1 |
| 1989 | 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\" = 'TX' 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" = 'TX' 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 FTW89FA133Accident · 2 fatalField investigationFinal reportAerospatiale AS-350-D · Galveston, TXFailure of both pilots to see-and-avoid the other aircraft (inadequate visual lookout).NTSB FTW86LRA06Accident · Minor injuriesFinal reportAerospatiale AS-350D · Freeport, TXWhile on a maintenance test flt the helicopter experienced an eng failure. An autorotation was entered and a hard landing occurred which resulted in a roll over. The flt originated at oyster creek heliport and returned twice for maintenance adjustments and…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 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 FTW81IA112Incident · No injuriesClosedAerospatial AS350 · Port Arthur, TXNTSB FTW81FA012Accident · 3 fatalClosedAerospatle AS350 · Waxahachie, TXNTSB FTW79DQD07Accident · No injuriesClosedAerospatial 350C · Salt Flat, TX