Fatal NTSB investigations: Kaman HH-43F
4 cases on aircraft the registry lists as Kaman HH-43F. 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
| 1991 | 1 |
|---|---|
| 1993 | 1 |
| 1999 | 1 |
| 2006 | 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.\"highestInjuryLevel\" = 'Fatal'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4800708'))
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."highestInjuryLevel" = 'Fatal'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4800708'))
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 SEA06LA162Accident · 1 fatalLimited investigationFinal reportKaman HH-43F · Metaline Falls, WAThe failure of the left-hand cross-shaft input internal spline while the helicopter was in a hover, which resulted in the loss of gear box timing, in-flight blade contact and separation, and the subsequent loss of control and impact with a log deck.NTSB LAX99FA317Accident · 2 fatalField investigationFinal reportKaman HH-43F · Phoenix, AZFailure of the horizontal stabilizer left outboard forward attach point because of a previously existing crack that resulted from inadequate maintenance inspection by the operator. A factor was the use of automotive parts.NTSB SEA93LA105Accident · 1 fatalLimited investigationFinal reportKaman HH-43F · Anatone, WAFatigue failure of the rotor transmission drive system, resulting from the improper certification/approval of the aircraft modification by the federal aviation administration.NTSB LAX91LA377Accident · 1 fatalLimited investigationFinal reportKaman HH43 B/F · Coleville, CAThe failure of the pilot to adequately calculate the helicopter performance. Contributing to the accident was a delay in jettisoning the external load; the pilot's overconfidence in his abilities; and exceeding of the helicopter's hover ability during high…