NTSB investigations: Hiller UH-12E, FL
8 cases on aircraft the registry lists as Hiller UH-12E. 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
| 1964 | 1 |
|---|---|
| 1979 | 1 |
| 1984 | 1 |
| 1988 | 2 |
| 1993 | 1 |
| 1996 | 1 |
| 2002 | 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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4360122', '4360137'))
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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('4360122', '4360137'))
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 ATL02LA044Accident · Minor injuriesLimited investigationFinal reportHiller UH12E · Miami, FLFatigue cracking in the main rotor hub that resulted in the separation of the main rotor system. A factor was corrosive deposits on the exposed portion of the plate set pin.NTSB ATL96LA104Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Cottondale, FLfailure of the main rotor drive torsional coupling and inner gimbal ring, which resulted in jamming of the flight controls during an attempted autorotation.NTSB MIA94LA029Accident · Minor injuriesLimited investigationFinal reportHiller UH-12E · Moore Haven, FLFailure of the pilot-in-command to maintain aircraft control following loss of engine power for undetermined reasons.NTSB MIA88LA225Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Clewiston, FLThe plt stated the fuel gages indicated 20 gals when he took off on spraying flt. He had just completed the spray run & started to pull up from about 10 ft & 25 mph. At that time the eng quit '& sounded just like it would if it ran out of gas'. There was not…NTSB MIA88LA183Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Gretna, FLWhile on an aerial application flt, the plt stated he maneuvered the helicopter to release the remaining chemical. He then heard a loud 'screeching' noise followed by silence as the eng quit. The helicopter landed hard breaking the skids. It came to rest on…NTSB MIA84FA078Accident · Serious injuriesField investigationFinal reportHiller UH-12E · Waldo, FLThe acft was being used to dispense aerial incendiary devices (aids) to control forest burning. The aids were 1.25 inch diameter polystyrene balls containing potassium permanganate. They were injected with ethylene glycol prior to being dropped out of the…NTSB MIA79FA095Accident · Serious injuriesClosedHiller UH-12E · Homestead, FLNTSB UNK64X0314Accident · No injuriesClosedHiller UH12E · Miami, FL