NTSB investigations: Aerospatiale AS350BA, CA
4 cases on aircraft the registry lists as Aerospatiale AS350BA. 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
| 2001 | 1 |
|---|---|
| 2004 | 1 |
| 2009 | 1 |
| 2020 | 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\" = 'CA' 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 ('8680817'))
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" = 'CA' 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 ('8680817'))
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 DCA20IA081Incident · No injuriesClass 3 · IncidentFinal reportAerospatiale AS350BA · Johnson Valley, CAthe failure of the small UAS remote pilot to give way to the helicopter, resulting in an inflight collision. Contributing to the incident was the sUAS remote pilot’s failure to assess and mitigate the risks of operations in close proximity to other aircraft.…NTSB WPR10FA055Accident · 3 fatalField investigationFinal reportAerospatiale AS350BA · Doyle, CAThe pilot became spatially disoriented while maneuvering on a dark night, which resulted in a loss of helicopter control.NTSB LAX05FA056Accident · 1 fatalField investigationFinal reportEurocopter France AS350BA · Panamint Spring, CAThe pilot's misjudged lateral distance from a mountainside and failure to maintain an adequate clearance from terrain and obstacles while performing a low altitude filming maneuver.NTSB LAX01LA304Accident · 1 fatalLimited investigationFinal reportAerospatiale AS350BA · Chico, CAthe pilot's inadequate in-flight decision and delay in initiating a go-around during an encounter with brown out conditions, which led to his failure to maintain alignment of the helicopter with the intended go-around flight path and a resulting collision…