NTSB investigations, HI
24 cases where the first occurrence was “Loss of engine power”.
Cases per year
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 2 |
| 1986 | 3 |
| 1987 | 3 |
| 1988 | 1 |
| 1991 | 2 |
| 1992 | 1 |
| 1996 | 1 |
| 2001 | 2 |
| 2004 | 2 |
| 2006 | 1 |
| 2007 | 2 |
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\" = 350)
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" = 350) 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 LAX07LA253Accident · No injuriesLimited investigationFinal reportEdra Aeronautica Seastar · Kapolei, HIA loss of engine power due to fuel starvation that resulted from the pilot's inadequate preflight planning/preparation and failure to ensure that an adequate fuel supply was onboard the aircraft.NTSB SEA07CA161Accident · No injuriesData collectionFinal reportCessna 150J · Honolulu, HIThe total loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for a forced landing.NTSB LAX06FA126Accident · 3 fatalField investigationFinal reportCessna 414A · Kahului, HIThe failure of the pilot to execute the published emergency procedures pertaining to configuring the airplane for single engine flight, which would have allowed him to maintain minimum controllable airspeed (Vmc) and level flight. The pilot's failure to…NTSB LAX04LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-31 · Kahului, HIthe pilot's failure to maintain an adequate airspeed while maneuvering for landing on one engine, which resulted in an inadvertent stall. The loss of power in one engine for undetermined reasons was a factor.NTSB LAX04LA101Accident · No injuriesLimited investigationFinal reportScott RV-8A · Lihue, HIthe engine lost partial power for undetermined reasons.NTSB LAX02LA010Accident · 1 fatalLimited investigationFinal reportRhoades Jodel D-9 · Waialua, HILoss of engine power for unknown reasons. A factor was the inadvertent stall the pilot encountered while maneuvering to make a forced landing in an open taro field.NTSB LAX01LA181Accident · No injuriesLimited investigationFinal reportCessna 337C · Paauilo, HIA dual loss of engine power for undetermined reasons.NTSB LAX97LA008Accident · No injuriesLimited investigationFinal reportGrumman American AA-1B · Kona, HIloss of engine power for undetermined reason(s).NTSB LAX93LA065Accident · No injuriesLimited investigationFinal reportCessna 185F · Lanai, HIThe failure of the engine for undetermined reasons. A factor in the accident was that obstructions were hidden in the grass of the landing area chosen by the pilot for the forced landing.NTSB LAX91LA361Accident · No injuriesLimited investigationFinal reportCessna 172G · Hilo, HIFuel exhaustion due to the installation of a non standard propeller for which no performance charts were available.NTSB LAX91LA198Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Keanae, HIThe total failure in fatigue of the helicopter's spur adapter gearshaft. A contributing factor was related to the lack of a suitable emergency landing site.NTSB LAX89LA049Accident · No injuriesLimited investigationFinal reportCessna 337E · Kahului, HIThe plt rprtd that after about 10 hrs on an overwater ferry flt, he noticed high oil temp & low oil pressure indcns fromthe rear eng. Eventually the rear eng began running rough, so he shut it down, feathered its prop and 'increased power on the front…NTSB LAX88FA075Accident · 8 fatalField investigationFinal reportPiper PA-31-350 · Maunaloa, HIThe flight was to be flown across a 22 mile channel between islands on an overcast night with no moon and no ground reference lights. The aircraft disappeared from radar and, after extensive searches, could not be found. A three dimensional flight track was…NTSB LAX88LA049Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe pilot stated that the engine lost power while he was flying low over the ocean on a fish spotting flight. Subsequently, he ditched the aircraft in the ocean & it was not retrieved.NTSB LAX87LA161Accident · 1 fatalLimited investigationFinal reportBell 206B · Kona, HIThe pilot picked up two of the passengers at a resort hotel and then flew to kailua-Kona airport (koa). After hot refueling the helicopter with the two passengers on board, two more passengers boarded the helicopter and then the flight departed koa. When the…NTSB LAX87DJA02Accident · No injuriesFinal reportCessna 172N · Honolulu, HIThe acft experienced a loss of engine power while descending during a practice instrument apch. The temperature was 81 degrees (f) with the dew point of 71 degrees (f). According to the icing probability chart, there is a possibility of serious carburetor…NTSB LAX87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Eleele Kauai, HIA Piper pa 31-350 lost power and collided with sign posts after landing on a road. It was reported to the FAA that the aircraft's right engine was producing partial power and the aircraft was unable to maintain altitude on the left engine. The pilot never…NTSB LAX86LA188Accident · Minor injuriesLimited investigationFinal reportHughes 269 · Kahului, HIA Hughes 269 went out of control after turning left into a 20 kt tailwind condition. The plt indicated that the engine failed. The eng was run on a eng test stand and no deficientcies were found. A fuel sample was found to be within specified parameters. Ac…NTSB LAX86LA043Accident · No injuriesLimited investigationFinal reportHughes 369D · Kunia, Oahu, HIWhile cruising the plt detected a loss of engine power & elected to make a precautionary landing. During landing flare engine power was lost & the acft touched down hard & with excessive ground speed. Exam of the acft's fuel control valve governor failed to…NTSB LAX85LA356Accident · No injuriesLimited investigationFinal reportCessna R182RG · Hilo, HIOn August 16, 1985, a Cessna 182 ditched at sea following fuel starvation about 200 miles northeast of Hawaii while on a ferry flight. The pilot reported that he had 23 hours of fuel onboard for the 16 hour flight. The aircraft was equipped with auxiliary…NTSB LAX84LA499Accident · 1 fatalLimited investigationFinal reportGrumman American AA1C · Molokai, HIThe student plt was on the last leg of his 1st x-country flt from honolulu, HI, to lanai, HI, to Molokai, HI, & return to honolulu. He departed Molokai at 1304 HST & at 1311, he reported abeam laau point. About 5 min later, the plt reported that he was 15 to…NTSB LAX83LJA04Accident · Minor injuriesFinal reportPiper PA-28-151 · Near Honolulu, HIThe plt & passengers departed on a sight-seeing flt to view a volcano on the island of Hawaii via kona, HI & return. The fuel tanks had been topped off before departure, & reportedly, there was sufficient fuel for the flt. Except for difficulties in starting…NTSB LAX83FA055Accident · 2 fatalField investigationFinal reportPiper PA-31-350 · 500 Nm E, Honolulu, HIThe acft departed oakland, CA at 1733 PST on a night flight to honolulu, HI. The flt proceeded without incident until aprx 0050 PST when the plt advised that the left eng was slowly losing oil pressure. At that time, the acft was at an alt of 6000 ft. at…NTSB DEN82FA074Accident · 2 fatalField investigationFinal reportBeech E18S · Hakalau, HIThe aircraft departed hilo on the last leg of a 3 flight. A few minutes after takeoff, the pilot called the tower to askfor return and indicated he had a difficulty. No further transmission was made. Witnesses heard intermittent engine sputtering and then the…