NTSB investigations: Sikorsky S-58ET
8 cases on aircraft the registry lists as Sikorsky S-58ET. 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
| 1978 | 1 |
|---|---|
| 1985 | 1 |
| 1989 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2011 | 1 |
| 2019 | 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 ('8141803'))
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 ('8141803'))
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 WPR19LA255Accident · No injuriesClass 3 · LimitedFinal reportSikorsky S58 · Azusa, CAThe in-flight separation of a section of the tail rotor blade due to a fatigue crack, which resulted in the pilot’s forced autorotation into a field.NTSB WPR11FA163Accident · Serious injuriesField investigationFinal reportSikorsky S-58ET · El Segundo, CAA partial loss of engine power and the failure of the external hook to release the load for undetermined reasons.NTSB LAX03FA232Accident · Serious injuriesField investigationFinal reportSikorsky S-58ET · Rancho P.Verdes, CAA total loss of antitorque control, due to the fatigue-induced failure of a gear within the drive shaft's intermediate gear box (IGB). Contributing factors were the pilot's improper on-ground decision to continue flight operations following discovery of…NTSB CHI02FA189Accident · 1 fatalField investigationFinal reportSikorsky S-58ET · Brookville, INThe pilot's intentional low altitude fight and his failure to maintain clearance from power transmission lines. Factors to the accident were the power transmission lines followed by the inability to control the aircraft after the collision with power…NTSB LAX94FA106Accident · 1 fatalField investigationFinal reportSikorsky S-58 · San Jose, CAThe pilot's inadequate preflight planning/preparation and subsequent fuel starvation, due to an inadequate supply of fuel. A factor related to the accident was: the proximity of high obstructions.NTSB LAX89FA160Accident · Minor injuriesField investigationFinal reportSikorsky S-58ET · Santa Ana, CAFailure of the landing gear resulting from excessive loading during ground operations, and fatigue cracking.NTSB MIA85FA153Accident · 3 fatalField investigationFinal reportSikorsky S-58ET · Gulf Of MexicoThe helicopter disappeared while on an overwater flt from key west, FL to ft peirce, FL. One occupant & the wreckage of the helicopter were subsequently recovered from the Gulf Of Mexico. The plt & the other occupant were not located & were presumed dead.…NTSB DEN79FA001Accident · 1 fatalClosedSikorsky S58ET · Steamboat Spgs, CO