NTSB investigations, HI
24 cases where the sequence of events included Loss of control in flight.
Cases per year
| 2009 | 3 |
|---|---|
| 2010 | 1 |
| 2011 | 2 |
| 2012 | 1 |
| 2014 | 1 |
| 2015 | 1 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 4 |
| 2022 | 4 |
| 2024 | 1 |
| 2025 | 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\" = '240' 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" = '240' 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 ANC25LA020Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172M · Kapolei, HIThe flight instructor’s failure to avoid wake turbulence from a heavy airplane departing from a parallel runway, which resulted in a loss of airplane control during initial climb after a touch-and-go landing.NTSB ANC24FA063Accident · 3 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Kekaha, HIAn encounter with turbulence due to downdraft winds that resulted in mast bumping and an in-flight breakup.NTSB ANC23FA008Accident · 3 fatalClass 3 · FieldFinal reportRaytheon C90A · Kaupo, HIGuardian Flight’s inadequate pilot training and performance tracking, which failed to identify and correct the pilot’s consistent lack of skill, and which resulted in the pilot’s inability to maintain his position inflight using secondary instruments to…NTSB WPR23LA043Accident · No injuriesClass 4 · LimitedFinal reportRobinson Helicopter R22 · Kapolei, HIThe pilot receiving instruction’s rapid reduction in throttle during hover autorotation training which resulted in a loss of control and collision with the ground.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 ANC22FA018Accident · 4 fatalClass 3 · FieldFinal reportSikorsky S-61N · Kekaha, HIThe improper installation of the fore/aft primary servo by maintenance personnel, which resulted in the attaching hardware backing out and which subsequently rendered the helicopter uncontrollable. Contributing to the accident was the company’s quality…NTSB ANC20CA034Accident · Minor injuriesData collectionFinal reportCessna 172 · Kahului, HIThe student pilot's failure to avoid wake turbulence while landing behind a heavy jet airplane, which resulted in a loss of roll control and subsequent hard landing.NTSB ANC20LA028Accident · Minor injuriesClass 3 · LimitedFinal reportEurocopter EC130 · Kalapana, HIA loss of control due to the fatigue fracture of a tail rotor fenestron blade due to the geometry of the water drain hole positioning on the rib.NTSB ANC20FA024Accident · 2 fatalClass 3 · FieldFinal reportCessna 305 · Mokuleia, HIA separation of the left rudder cable due to inadequate maintenance, which resulted in an in-flight loss of control and impact with terrain.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 WPR19FA123Accident · 3 fatalClass 3 · FieldFinal reportRobinson R44 · Kailua, HIThe helicopter’s encounter with a strong downdraft or outflow boundary while operating at a higher than recommended airspeed in turbulence which resulted in a low-G condition, excessive main rotor flapping, and an in-flight breakup when the main rotor…NTSB WPR19LA013Accident · Serious injuriesClass 3 · LimitedFinal reportRobinson R44 · Kaneohe, HIThe pilot’s sudden incapacitation from an undiagnosed heart condition during flight, which resulted in a hard landing.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 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 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 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 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 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 WPR10FA211Accident · 2 fatalField investigationFinal reportAirBorne WindSport Edge XT-912-L · Captain Cook, HIThe pilot’s intentional in-flight maneuvers that exceeded the structural limits of the aircraft, which resulted in structural failure of the wings.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 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.