NTSB investigations: Aerospatiale AS350B
8 cases on aircraft the registry lists as Aerospatiale AS350B, where the first occurrence was “Airframe/component/system failure/malfunction”. 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
| 1987 | 1 |
|---|---|
| 1989 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1995 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2003 | 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 ('8680800')
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\" = 130))
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 ('8680800')
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" = 130))
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 LAX03LA225Accident · Minor injuriesLimited investigationFinal reportAmerican Eurocopter AS350BA · Temple Bar, AZthe pilot's failure to follow the published electrical system emergency procedures for a hot battery, and his misjudged landing flare during the terminal phase of the autorotation maneuver at low level.NTSB LAX02FA281Accident · Minor injuriesField investigationFinal reportAerospatiale AS350BA · Peach Springs, AZthe pilot's failure to maintain an adequate airspeed and main rotor rpm during the landing approach as prescribed in the hydraulic pump failure emergency procedures found in the rotorcraft flight manual, thus resulting in a loss of control of the aircraft and…NTSB LAX00FA136Accident · Serious injuriesField investigationFinal reportAerospatiale AS350B · Van Nuys, CAthe pilot's failure to land as soon as practical and to utilize the available accumulator pressure to transition from hover to flight. Contributing to the accident was the pilot's physical stature and strength, and the inadequate and incomplete emergency…NTSB MIA95LA131Accident · Serious injuriesLimited investigationFinal reportAerospatiale AS-350B · Tampa, FLThe failure of the pilot to follow manufacturers procedures after failure of the hydraulic system resulting in loss of control of the helicopter. Contributing to the accident was the failure of maintenance personnel to follow manufacturers procedures for…NTSB LAX92FA025Accident · Minor injuriesField investigationFinal reportAerospatiale AS350B · Scottsdale, AZAn undetermined malfunction of the hydraulic system in which the system was locked, preventing the movement of the flight controls, and loss of directional control.NTSB LAX90LA132Accident · No injuriesLimited investigationFinal reportAerospatiale AS350B · Saipan (Pacific Ocean)The partial failure of a rotor system component for undetermined reasons.NTSB FTW90LA044Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350B · Grand Prairie, TXManufacturer's failure to property install the left side components of the dual control system following its removal for additional completion work prior to delivery of the aircraft. Contributing to the accident was the failure of quality control personnel to…NTSB NYC87LA220Accident · No injuriesLimited investigationFinal reportAerospatiale AS350D · Nantucket, MAThe flight was enroute from Nantucket to hyannis when the pilot heard a loud bang followed by a severe vibration, loss of power to the main rotor system, and a loss of hydraulic pressure. The helicopter made an autorotative landing in water about 25 feet in…