NTSB investigations, HI
42 cases where the sequence of events included Collision with terr/obj (non-CFIT).
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 4 |
| 2010 | 1 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 1 |
| 2014 | 4 |
| 2015 | 3 |
| 2016 | 5 |
| 2017 | 2 |
| 2018 | 5 |
| 2019 | 4 |
| 2020 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '470' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) 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 ANC24LA016Accident · No injuriesClass 4 · LimitedFinal reportHughes 369D · Hana, HIThe pilot’s failure to ensure the passenger’s gear was properly secured before departure.NTSB ANC24LA005Accident · Serious injuriesClass 3 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Kapolei, HIA partial loss of engine power due to lose baffling from the muffler, which resulted in an obstruction of the exhaust system.NTSB ANC22FA041Accident · Serious injuriesClass 3 · FieldFinal reportBell 407 · Kalea, HIThe in-flight separation of the tail boom as a result of abnormal loading and fracture of the upper-left tail boom attachment bolt due to a gap between the upper-left longeron and aft fuselage bulkhead.NTSB ANC21LA003Accident · No injuriesClass 3 · LimitedFinal reportHughes 369 · Honolulu, HIA partial loss of engine power due to an obstructed fuel line as a result of the separation of the circlip from the pin used on the fuel start pump. The reason for the circlip separation could not be determined based on the available evidence.NTSB ANC20CA012Accident · Minor injuriesClass 4 · Data collectionFinal reportCirrus SR22 · Kapolei, HIThe student pilot's loss of airplane control during a short field takeoff in gusting crosswind conditions, and the designated pilot examiner's delayed remedial action.NTSB WPR19LA185Accident · No injuriesClass 3 · LimitedFinal reportCessna TU206 · Waikoloa Village, HIThe total loss of engine power due to the failure of the No. 4 connecting rod crankshaft end and cap.NTSB WPR19MA177Accident · 11 fatalClass 2 · MajorFinal reportBeech 65-A90 · Mokuleia, HIThe pilot’s aggressive takeoff maneuver, which resulted in an accelerated stall and subsequent loss of control at an altitude that was too low for recovery. Contributing to the accident were (1) the operation of the airplane near its aft center of gravity…NTSB WPR19LA111Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Hauula, HIFuel exhaustion as a result of the pilot’s fuel burn miscalculation. Contributing to the accident was the inoperative caution light indicating low fuel level.NTSB GAA19CA181Accident · Minor injuriesData collectionFinal reportAir Creation Tanarg · Kailua-Kona, HIThe pilot's improper preflight fuel planning, which resulted in a total loss of engine power due to fuel exhaustion.NTSB WPR19LA041Accident · Serious injuriesClass 3 · LimitedFinal reportHawker Hawker Hntr FMK 58 · Honolulu, HIA total loss of engine power for undetermined reasons.NTSB GAA19CA059Accident · No injuriesData collectionFinal reportEugene Wells Dragon Fly-B · Kailua/Kona, HIThe pilot's failure to maintain directional control during landing in a crosswind. Contributing to the accident was the pilot’s lack of experience in tailwheel airplanes for which he did not have an endorsement.NTSB WPR18LA280Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Kapolei, HILoss of engine power due to water in the fuel lines.NTSB WPR18LA269Accident · No injuriesClass 3 · LimitedFinal reportRobinson R44 · Wahiawa, HILoss of oil in flight as a result of a loose oil filter adapter which resulted in the pilot initiating an immediate landing to an open field. Contributing to the accident was the pilot's manipulation of the throttle that led to a reduction in rotor rpm, which…NTSB WPR18TA236Accident · Minor injuriesClass 3Final reportPiper PA28 · Mokuleia, HIA total loss of engine power due to fuel starvation as a result of the flight instructor's inadequate preflight inspection.NTSB WPR18LA010Accident · 2 fatalLimited investigationFinal reportRobinson Helicopter R44 · Molokai, HIA descent and subsequent impact with open ocean waters for reasons that could not be determined based on the available information.NTSB GAA17CA191Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna 208 · Kalaupapa, HIThe pilot's attempted aborted landing late in the landing sequence because she saw another airplane on the runway facing her with its propeller turning, which resulted in a hard landing, a subsequent loss of directional control, and ground loop.NTSB WPR17FA021Accident · 2 fatalField investigationFinal reportHughes 369 · Pukoo, HIThe pilot's decision to continue visual flight into an area of instrument meteorological conditions at night in rain, which resulted in his geographic disorientation and controlled flight into terrain.NTSB WPR16LA175Accident · Serious injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 500N · Honolulu, HIThe pilot's failure to maintain helicopter control in gusting wind conditions, which resulted in the helicopter rescue net’s contact with a utility pole and serious injury to an occupant who fell from the rescue net. Contributing to the accident was the…NTSB WPR16LA168Accident · No injuriesLimited investigationFinal reportRobinson R44 · Kailua/Kona, HIAn on-ground upset for reasons that could not be determined because postaccident examination of the helicopter revealed no evidence of mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR16FA116Accident · 5 fatalField investigationFinal reportCessna 182 · Hanapepe, HIThe pilot's failure to maintain airspeed following a partial loss of engine power for reasons that could not be determined during postaccident examination, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic…NTSB WPR16FA072Accident · 1 fatalField investigationFinal reportBell 206B · Honolulu, HIThe in-flight failure of the engine-to-transmission drive shaft due to improper maintenance, which resulted in low main rotor rpm and a subsequent hard landing to water.NTSB GAA15CA147Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Kailua-Kona, HIThe flight instructor's decision to conduct a high altitude pinnacle landing without adequate power, which resulted in the helicopter impacting terrain during the approach. Contributing to the accident was the density altitude at the high altitude pinnacle…NTSB WPR15LA148Accident · No injuriesLimited investigationFinal reportCessna 206H · Honolulu, HIA blown nose landing gear tire during landing, which resulted in the pilot’s inability to maintain directional control.NTSB WPR15LA086Accident · Serious injuriesLimited investigationFinal reportCessna 172N · Ualapue, HIA partial loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered.NTSB WPR14CA389Accident · No injuriesData collectionFinal reportPiper PA25 - 260 · Mokuleia, HIThe pilot's improper preflight planning and reliance of fuel gauge readings, which resulted in a loss of engine power due to fuel exhaustion.NTSB WPR14CA325Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Honolulu, HIThe pilot's inadequate compensation for the wind conditions and failure to maintain aircraft control during taxi, which resulted in a loss of tail rotor effectiveness and subsequent impact with the taxiway and a parked fuel truck.NTSB WPR14FA135Accident · 2 fatalField investigationFinal reportEvolution Trikes Revo · Kekaha, HIThe pilot's reconfiguration of the fuel venting system, which resulted in a loss of engine power and subsequent loss of aircraft control.NTSB WPR14CA129Accident · No injuriesData collectionFinal reportPartenavia P 68 Observer · Molokai, HIThe pilot's inadequate decision to continue an unstable approach in dark night conditions, which resulted in a collision with trees and hard landing.NTSB WPR13LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Waihee-Waiehu, HIThe loss of engine power for reasons that could not be determined because postaccident examination did not reveal any anomalies due to saltwater immersion.NTSB WPR13LA062Accident · 1 fatalLimited investigationFinal reportCessna 172S · Kahului, HIThe noninstrument-rated pilot’s spatial disorientation and subsequent failure to maintain airplane control while operating over water in dark night conditions with reduced visibility due to rain in the area.NTSB WPR13CA027Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Hanapepe, HIThe pilot's selection of an unsuitable landing area. Contributing to the pilot’s decision to land in an unsuitable landing area was his lack of helicopter experience, which led him to misidentify the precursor event.NTSB WPR13LA007Accident · Serious injuriesLimited investigationFinal reportSchleicher ASH25M · Kamuela, HIThe pilot’s failure to maintain control of the glider after it encountered atmospheric conditions while maneuvering where the lift was not sufficient to maintain flight, which resulted in a stall and impact with terrain during the subsequent approach to land.NTSB WPR12CA082Accident · No injuriesData collectionFinal reportCessna 172P · Honolulu, HIThe student pilot’s improper landing flare and inadequate directional control while performing an aborted landing.NTSB WPR12MA034Accident · 5 fatalMajor investigationFinal reportEurocopter EC 130 B4 · Pukoo, HIThe pilot's failure to maintain clearance from mountainous terrain while operating in marginal weather conditions, which resulted in the impact of the horizontal stabilizer and lower forward portion of the fenestron with ground and/or vegetation and led to…NTSB WPR11FA225Accident · 2 fatalField investigationFinal reportP&M Pegasus Quik 912S · Hanalei, HIThe pilot's continued operation of the aircraft with deteriorated wing fabric and his aggressive maneuvering at low altitude, which resulted in the right wing fabric’s failure during flight. Contributing to the accident was the pilot's loading of the aircraft…NTSB WPR11FA138Accident · 2 fatalField investigationFinal reportAirBorne WindSport Edge XT-912-L · Hanapepe, HIThe flight instructor did not maintain aircraft control while maneuvering at low altitude. Contributing to the accident was the inadvertent application of the choke, which resulted in a momentary interruption of engine power.NTSB WPR10CA224Accident · No injuriesData collectionFinal reportEvolution Trikes Revo · Eleele, HIA loss of engine power as a result of fuel exhaustion due to the pilot's improper decision to continue the flight after the low fuel warning. Contributing to the accident was the typographical error in the flight manual concerning the unusable fuel quantity.NTSB WPR10CA019Accident · Minor injuriesData collectionFinal reportCessna 172S · Honolulu, HIThe student pilot's distraction and subsequent loss of airplane control after the cabin window opened during the takeoff roll.NTSB WPR09LA386Accident · Serious injuriesLimited investigationFinal reportAirborne Windsports PTY XT-912-L · Lihue, HIThe flight instructor's failure to maintain control of the airplane following an in-flight encounter with turbulence during descent.NTSB WPR09CA090Accident · Minor injuriesData collectionFinal reportMulec Frank A FP-404 · Hilo, HIA total loss of engine power due to fuel starvation as a result of a clogged fuel filter.NTSB WPR09FA089Accident · 1 fatalField investigationFinal reportGlaser-Dirks DG-400 · Volcano, HIThe pilot's loss of pitch control and subsequent exceedance of the glider's airspeed limit for undetermined reasons.NTSB SEA08FA071Accident · Minor injuriesField investigationFinal reportMcdonnell Douglas 369E · Hilo, HIA leak in the fuel filter pressure differential switch that resulted in a loss of engine power. Contributing to the accident was uneven terrain that hindered a successful emergency landing.