NTSB investigations: Sikorsky S-61A
7 cases on aircraft the registry lists as Sikorsky S-61A. 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
| 1972 | 1 |
|---|---|
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2003 | 2 |
| 2015 | 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 ('814210C'))
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 ('814210C'))
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 WPR15LA248Accident · Minor injuriesLimited investigationFinal reportSikorsky S 61A · Ironside, ORA loss of power to the No. 2 engine due to the failure of the accessory gearbox drivetrain. Also causal was the pilot’s inability to release the external longline due to the use of a safety wire across the coupling of the quick-disconnect mechanism, which…NTSB ATL03FA065Accident · 1 fatalField investigationFinal reportSikorsky S-61A · Kimble, TNThe interruption of rotor system drive power due to the input free wheeling unit malfunctioning , and the pilot's operation of the helicopter in the critical area of the height-velocity curve.NTSB NYC03LA037Accident · Serious injuriesLimited investigationFinal reportSikorsky S-61A · Glady, WVThe improper installation of the left tailrotor control cable by company maintenance personnel.NTSB LAX02FA116Accident · 1 fatalField investigationFinal reportSikorsky S-61A · Lakehead, CAA loss of engine power for undetermined reasons, and the flight crew's failure to maintain rotor rpm following a loss of engine power while maneuvering.NTSB ANC01LA109Accident · No injuriesLimited investigationFinal reportSikorsky S61A · Wrangell, AKThe separation of a steel long line cable that failed and rebounded from a load of logs into the helicopter's main and tail rotors.NTSB LAX00LA193Accident · Minor injuriesLimited investigationFinal reportSikorsky S61A · Eureka, CAthe loss of power in all engines due to the pilot's inadequate in-flight decision to continue flight with fuel level below the landing minimums specified in the flight manual, which resulted in the unporting of the fuel supply line and fuel starvation. A…NTSB SEA73FYG21Accident · 2 fatalClosedSikorsky S-61A · Chelan, WA