NTSB investigations: Aerospatiale SA-360C "DAUPHIN"
5 cases on aircraft the registry lists as Aerospatiale SA-360C "DAUPHIN". 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 |
|---|---|
| 1983 | 2 |
| 1984 | 1 |
| 1985 | 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 ('8680662'))
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 ('8680662'))
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 DCA85AA020Accident · 1 fatalFinal reportAerospatiale SA360C Dauphin · New York, NYAt laguardia arpt, wnd was fm 320 deg at 16 gstg 22 KTS. PIC rprtd wnd at heliport (on west bank of east RVR) was fm sw. Obstacles were located along west edge of heliport. PIC rprtd he made pwr check, then bgn rolling takeoff with rgt qtrg hdwnd. As acft was…NTSB NYC84LA320Accident · No injuriesLimited investigationFinal reportAerospatiale SA-360C · New York, NYDuring approach to heliport, the plt heard two loud 'pops' from the engine. The plt activated the emergency floats and continued the approach. The plt stated that the 'popping', recognized as a compressor stall started again on final. He lowered the…NTSB NYC84FA061Accident · Serious injuriesField investigationFinal reportAerospatiale SA-360C · Newark, NJThe helicopter arrived at the Newark intl arpt at 1531 after an uneventful flt from new york, NY with 2 en route stops. At 1540, the plt taxied from the passenger gate for departure. According to him, he had no control problems, while taxiing. He checked the…NTSB NYC83FA210Accident · Minor injuriesField investigationFinal reportAerospatiale SA-360C · New York, NYWhile on final apch to a heliport, the helicopter was at aprx 70 KTS & 100 ft AGL when the plt applied power to begin decelerating. As collective pitch was applied, he heard a series of banging noises which he described as similar to compress stalls.…NTSB FTW82FRA15Accident · Serious injuriesFinal reportAerospatiale SA-360C · Hitchcock, TXDuring a return flight from an offshore platform, the pilot encountered strong headwinds and elected to land at lake jackson, Texas for fuel. He lacked a proper mode of payment; therefore, he was unable to purchase fuel. He departed for galveston, Texas with…