NTSB investigations: S N I A S AS350D ASTAR
4 cases on aircraft the registry lists as S N I A S AS350D ASTAR, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1990 | 1 |
| 1994 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680803')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('8680803')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 LAX94FA100Accident · 2 fatalField investigationFinal reportAerospatiale AS-350D · Lebec, CAThe pilot-in-command's inadequate in-flight planning and inadequate visual lookout. Factors in the accident were mountainous terrain which masked the presence of the wires and the pilot-in-command's lack of familiarity with the geographic area.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 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 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…