NTSB investigations, HI
9 cases where the first occurrence was “Loss of engine power(partial) - mech failure/malf”.
Cases per year
| 1986 | 1 |
|---|---|
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1994 | 1 |
| 1997 | 1 |
| 2000 | 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\" = 'HI' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 352)
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" = 'HI' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 352) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
Run 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 LAX00FA310Accident · 1 fatalField investigationFinal reportPiper PA-31-350 · Hilo, HIDeterioration and failure of the oil filter converter plate gasket, which resulted in a loss of engine power and a subsequent in-flight fire.NTSB LAX97LA088Accident · No injuriesLimited investigationFinal reportMcDonnell Douglas 369D · Kamuela, HIfuel system contamination resulting in a partial loss of power, and the failure of the pilot to maintain adequate rotor rpm to cushion the autorotative landing and prevent main rotor blade contact with the tailboom. Factors were the inadequacy of…NTSB LAX94FA317Accident · No injuriesField investigationFinal reportAerospatiale AS350-D · Kukuihaele, HIa fatigue crack in the 'T' fitting on the power turbine governor pneumatic accumulator. A factor was the rough, rock-covered landing area.NTSB LAX90LA050Accident · No injuriesLimited investigationFinal reportHughes 369HS · Waimea, HIThe improper installation of the pc tube by company maintenance personnel, which resulted in fatigue failure of the tube due to induced bending stresses.NTSB LAX89LA197Accident · Minor injuriesLimited investigationFinal reportAerospatiale AS350D · Waialae Falls, HIImproper maintenance/adjustment of the engine fuel control unit by company maintenance personnel, which resulted in a slight loss of engine power, and failure of the pilot to maintain rotor RPM, while turning and taking off from a hover with a relatively…NTSB LAX89LA063Accident · No injuriesLimited investigationFinal reportHughes 369E · Hanalei, HIDuring a local sightseeing flight, the pilot reported that he heard a muffled bang and simultaneously the engine out warning lights and audio alarm activated. The pilot initiated a forced landing on the beach which resulted in the helicopter nosing over. An…NTSB LAX87DJA09Accident · No injuriesFinal reportEmair MA-1-B · Paauilo, HIDuring an aerial application flt, just after take off, the plt noted that the engine oil temp was high and that blue smoke was coming from the engine. Unable to land at the airport, the acft collided with the terrain short of the runway and nosed over.…NTSB LAX87LA242Accident · No injuriesLimited investigationFinal reportCessna 310R · Kailua, HIA Cessna 310R ditched in the pacific ocean aprx 500 NM sw Hawaii after an eng failure. The plt indicated that the #2 eng failed while in cruise flt at 8,000 ft MSL. Oil was observed leaking from the eng cowling. The acft was unable to maintain alt on #1 eng.…NTSB LAX87LA051Accident · No injuriesLimited investigationFinal reportCessna 152 · Waipahu, HIThe plt dragged both wings through a sugar cane crop during landing roll on a gravel road after a partial loss of power. The engine had 4040 total hours and had been previously overhauled 1655 hours prior. The plt indicated that the eng had a top overhaul…