OpenAirDocs.org

NTSB investigations, HI

75 cases where the phase of flight was Approach.

Cases per year

19642026

Where

Open the map

Latest cases

Query with SQL
duckdb -csv -c "WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')),
    crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')),
    current_codes AS (
      SELECT e.case_mkey, TRY_CAST(e.\"tier1Number\" AS INTEGER) AS code,
        row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e.\"isDefiningEvent\", false) DESC, e.position) AS n
      FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e
      WHERE e.aircrafts_position = 1 AND e.\"tier1Number\" GLOB '[1-9][0-9]*'
        AND (e.\"isDefiningEvent\" OR e.case_mkey IN (SELECT \"mKey\" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE \"isPre1982\"))
    ),
    phases AS (
      SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main
      FROM current_codes WHERE n = 1
      UNION ALL
      SELECT o.case_mkey, 'older', o.\"phaseOfFlightCode\", w.main
      FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o.\"phaseOfFlightCode\"
      WHERE o.aircrafts_position = 1 AND o.\"occurrenceNumber\" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes)
    ),
    case_phases AS (
      SELECT p.*, c.\"eventDate\", c.\"highestInjuryLevel\" = 'Fatal' AS fatal, a.aircraft_model_code
      FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c.\"mKey\" = p.case_mkey
      LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1
      WHERE c.\"eventDate\" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names)
    )
  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 case_mkey FROM case_phases WHERE main = 500)
  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.

NTSB ANC24LA084Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 182B · Hawi, HIThe airplane’s loss of engine power due to carburetor ice that formed during a long descent, contributing to the outcome is the pilot’s delayed use of carburetor heat.Aug 28, 2024 · N2728B · Substantial damageNTSB ANC24LA011Accident · No injuriesClass 3 · LimitedFinal reportCessna 172P · Kahului, HIA partial loss of engine power due to the formation of carburetor ice, which resulted in the inability to maintain altitude in the traffic pattern. Contributing to the outcome was the pilot’s delayed use of carburetor heat in conditions conducive to the…Dec 23, 2023 · N53725 · Substantial damageNTSB ANC23LA012Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 208B · Kualapuu, HIThe pilot’s failure to maintain adequate altitude during a circling approach procedure in dark night visual meteorological conditions, which resulted in a collision with terrain.Jan 16, 2023 · N236KA · Substantial damageNTSB WPR23LA061Accident · Minor injuriesClass 4 · LimitedFinal reportEurocopter EC 130 B4 · Waimea, HIThe pilot's loss of helicopter control on approach to land due to entering a vortex ring state condition, which resulted in a hard landing.Dec 8, 2022 · N130WS · Substantial damageNTSB ANC21LA018Accident · Serious injuriesClass 4 · LimitedFinal reportDiamond Aircraft Ind DA 40 · Lanai, HIA total loss of engine power for reasons that could not be determined based on the available evidence.Feb 26, 2021 · N680DS · Substantial damageNTSB WPR19LA087Accident · Serious injuriesClass 3 · LimitedFinal reportMD Helicopter 369 · Kukuihaele, HIThe partial loss of engine power due to corrosion in the engine bleed valve due to wash solution intrusion. Contributing to the accident was the installation of a bushing manufactured to incorrect dimensions in the bleed valve, and the uneven terrain at the…Feb 21, 2019 · N506PH · Substantial damageNTSB ANC18FA012Accident · 2 fatalField investigationFinal reportCessna U206 · Maunaloa, HIThe pilot's decision to continue visual flight into an area of instrument meteorological conditions while conducting an instrument approach, which resulted in a loss of visual reference and subsequent controlled flight into terrain.Dec 10, 2017 · N732DF · DestroyedNTSB 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.Mar 11, 2017 · N865MA · Substantial damageNTSB WPR14CA385Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Mokuleia, HIThe pilot's failure to maintain aircraft control during landing with a quartering tailwind, which resulted in a hard landing.Sep 22, 2014 · N8375E · Substantial damageNTSB 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.Feb 28, 2014 · N947MZ · Substantial damageNTSB WPR14LA038Accident · Minor injuriesLimited investigationFinal reportEurocopter France AS 350 · Kailua Kona, HIThe pilot receiving instruction’s failure to maintain main rotor rpm while practicing manual throttle control and the flight instructor’s delayed remedial action, which resulted in a hard landing.Oct 30, 2013 · N985EW · Substantial damageNTSB WPR13CA342Accident · No injuriesData collectionFinal reportMcdonnell Douglas Helicopter 369E · Hilo, HIA loss of engine power due to the pilot's improper planning and mismanagement of the fuel supply, which resulted in fuel exhaustion.Jul 25, 2013 · N500PH · Substantial damageNTSB OPS12IA122Incident · No injuriesIncident investigationFinal reportKahului, HIFailure of the Honolulu Control Facility controller to issue control instructions necessary to establish and maintain required separation between all three aircraft. Contributing to the losses of separation was inadequate training provided to controllers…Nov 3, 2011 · No damageNTSB 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.Apr 19, 2010 · N98EV · Substantial damageNTSB WPR10FA107Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Honolulu, HIThe pilot's continued visual flight into instrument meteorological conditions at an altitude insufficient to ensure adequate terrain clearance. Contributing to the accident was the air traffic controller's failure to issue a safety alert after observing the…Jan 10, 2010 · N8934N · Substantial damageNTSB WPR09CA481Accident · No injuriesData collectionFinal reportS.C. Aerostar YAK-52W · Kaunakakai, HIThe pilot's failure to maintain clearance from terrain while in the airport traffic pattern in dark night conditions.Jul 25, 2009 · N691T · Substantial damageNTSB WPR09FA072Accident · No injuriesField investigationFinal reportEurocopter AS 350 BA · Honolulu, HIThe partial loss of engine power during landing for an undetermined reason.Jan 5, 2009 · N141MK · Substantial damageNTSB SEA08FA062Accident · 1 fatalField investigationFinal reportHawker Beechcraft 1900C · Lihue, HIThe pilot's spatial disorientation and loss of situational awareness. Contributing to the accident were the dark night and the task requirements of simultaneously monitoring the cockpit instruments and the other airplane.Jan 14, 2008 · N410UB · DestroyedNTSB SEA07LA108Accident · Minor injuriesLimited investigationFinal reportHughes 369D · Kahuku, HIFatigue cracking of the oil line from the engine gearbox to the oil pressure gauge, which resulted in loss of engine lubricating oil, leading to seizure of the power turbine.Apr 20, 2007 · N911FT · Substantial damageNTSB 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…Mar 9, 2006 · N5601C · DestroyedNTSB LAX00FA191Accident · 6 fatalField investigationFinal reportRockwell NA-265-65 · Kaunakakai, HIInadequate crew coordination led to the captain's decision to discontinue the instrument approach procedure and initiate a maneuvering descent solely by visual references at night in an area of mountainous terrain. The crew failed to review the instrument…May 11, 2000 · N241H · DestroyedNTSB LAX99LA282Accident · No injuriesLimited investigationFinal reportAerospatiale AS350BA · Kahului, HIThe pilot's initial misjudgment of the wind speed and his decision to continue a downwind landing approach when his speed and altitude profile was inadequate, and his failure to maintain main rotor rpm, resulting in settling with power and a hard landing.Aug 24, 1999 · N6094S · Substantial damageNTSB LAX99LA238Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe airplane's encounter with turbulent air from the rotor wash of a large military helicopter, which resulted from the instructor's decision to continue the approach while the helicopter was on the runway.Jun 30, 1999 · N63614 · Substantial damageNTSB LAX97LA322Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Hilo, HIfailure of the pilot to verify the quantity of fuel before departure, and to monitor fuel consumption during the flight, which led to fuel exhaustion, loss of engine power, and a forced landing. Tall grass in the emergency landing was a related factor.Sep 12, 1997 · N18503 · Substantial damageNTSB LAX97FA069Accident · No injuriesField investigationFinal reportde Havilland DHC-8 · Honolulu, HIA failure of the normal landing gear extension system due to a hydraulic leak, and the failure of the airplane's emergency landing gear extension system due to inadequate servicing by company maintenance personnel. Factors were the emergency landing gear…Dec 16, 1996 · N801WP · Substantial damageNTSB LAX95LA343Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Kona, HIthe failure of the student pilot to properly execute a planned steep approach and long landing so as to avoid wake turbulence behind the preceding large aircraft.Sep 23, 1995 · N10637 · Substantial damageNTSB LAX94IA206Incident · Minor injuriesIncident investigationFinal reportBoeing 737-209 · Honolulu, HIThe failure of the battery transfer relay resulting in multiple system failures.Apr 27, 1994 · N804AL · No damageNTSB LAX94LA124Accident · No injuriesLimited investigationFinal reportSchweizer 2-33-A · Dillingham, HIthe pilot's failure to maintain an adequate airspeed margin while maneuvering in the traffic pattern and his inadvertent entry into a stall/mush condition.Feb 13, 1994 · N3622Z · Substantial damageNTSB LAX91LA248Accident · Serious injuriesLimited investigationFinal reportBell 206B · Lihue, HIFuel exhaustion. Factors related to the accident was the failure of the pilot-in-command to ensure that sufficient fuel was available for the flight.Jun 7, 1991 · N212OX · DestroyedNTSB LAX90DJA02Accident · Minor injuriesFinal reportBryce Duster BJ-1B · Haleiwa, Oahu, HIThe separation in flight of the vertical wood fin from the main structure. It was not determined if the separation was due to overload forces or fatigue.Dec 11, 1989 · N25601 · Substantial damageNTSB LAX89LA222Accident · 2 fatalLimited investigationFinal reportAmerican AA-1C · Kalaupapa, HIThe pilot's failure to maintain sufficient airspeed to prevent a stall from which there was insufficient altitude to recover.Jun 19, 1989 · N88ME · DestroyedNTSB LAX89FA103Accident · Minor injuriesField investigationFinal reportCessna 150K · Honolulu, HIInadequate control tower service provided by the local controller (lc), and failure of the two pilots to see and avoid each other's aircraft. Related factors were: identification of the wrong aircraft by the local controller, his excessive workload (heavy…Feb 9, 1989 · N6149G · 2 aircraft · Substantial damageNTSB LAX88LA325Accident · No injuriesLimited investigationFinal reportBell 206L · Lihue, HIDuring a local sightseeing flight, the pilot reported that while on final approach for landing, the audio and light for low RPM sounded and illuminated. The helicopter was autorotated. It initially bounced when it touched down, then landed hard. The engine…Sep 17, 1988 · N278KA · Substantial damageNTSB LAX87LA205Accident · No injuriesLimited investigationFinal reportCessna 150M · Honolulu, HIThe student and CFI landed at ford island and the CFI deplaned to observe the student perform solo landings. The studentexecuted one takeoff and landing without incident. On the second approach the student elected to make a go-around. He used full flaps for…May 14, 1987 · N704QH · Substantial damageNTSB LAX87LA195Accident · Serious injuriesLimited investigationFinal reportCessna 402A · Kahului, HIShortly after takeoff, the plt reqd an 'immediate downwind' to rtrn to the arpt & was clrd to land. When asked if equip-ment was needed, he replied, 'negative, sir, a little matter of fuel.' A witness said the acft appeared very low on final apch with both…Apr 29, 1987 · N4588Q · DestroyedNTSB 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…Nov 7, 1986 · N6184D · DestroyedNTSB LAX85LA335Accident · Minor injuriesLimited investigationFinal reportBeech 23 · Kamuela, HIOn July 31, 1985, a Beech BE-23 operated by a student pilot, crashed during an attempted go-around at the waimea-kohala airport in Hawaii. The acft sustained substantial damage and the plt received minor injuries. The plt indicated he had not used full flaps…Jul 31, 1985 · N2354Z · Substantial damageNTSB LAX85LA339Accident · Minor injuriesLimited investigationFinal reportCessna 310D · Kahului, HIOn July 22, 1985, a Cessna 3100, N6740T experienced a loss of engine power while on final approach to the Kahului arpt in maui, Hawaii. The ac sustained substantial damage and the plt received minor injuries. The ac has a fuel capacity of 90 gal useable. The…Jul 22, 1985 · N6740T · Substantial damageNTSB LAX85LA112Accident · No injuriesLimited investigationFinal reportHughes 369D · Kahului,Maui, HIAccording to the plt, about 1.4 hours into a local photo flt, the fuel gage showed 125 pounds and he elected to return to the arpt for more fuel. With the fuel gage showing just under 100 pounds, engine flamed out on approach to the arpt and plt executed an…Jan 16, 1985 · N58399 · Substantial damageNTSB LAX84LA305Accident · Serious injuriesLimited investigationFinal reportBellanca 7GCAA · Waipahu,Oahu, HIThe CFI gave the student a simulated forced landing and the student spiraled down to 400 ft AGL. When the CFI said 'i'vegot the airplane' the acft nose came up and the acft started to settle. The CFI stated he applied power but the acft continued to settle,…May 20, 1984 · N4166Y · Substantial damageNTSB LAX84IA204Incident · No injuriesIncident investigationFinal reportCessna 402C · Kalaupapa, HIWhile on final to rwy 23, a 20 ft wave ricocheted off the rwy embankment, striking the acft's rt flap. The plt executed a go-around & landed on rwy 05 without incident. Investigation revealed that the rt flap cable had broken.Feb 28, 1984 · N206RH · Minor damageNTSB LAX84LA115Accident · Serious injuriesLimited investigationFinal reportde Havilland DHC 7-102 · Honolulu, HIWhile on a five mile final apch to rwy 26R the dhc 7 encountered moderate turbulence and two cabin attendants sustained injuries. At 1506:02 hours HST a western airlines DC10 requested an s turn to lose altitude in order land on rwy 26L. Seven seconds later…Dec 23, 1983 · N929HA · No damageNTSB LAX84LA135Accident · No injuriesLimited investigationFinal reportSchweizer SGS-2-33A · Mokuleia, HIThe plt was rated for airplanes & helicopters, but did not have a glider rating. He had only 2.5 hrs in gliders, all of which was in this same make & model. During a solo instructional flt, he encountered a high sink while on a base turn to land. He stated…Dec 18, 1983 · N17SH · Substantial damageNTSB LAX83FA310Accident · No injuriesField investigationFinal reportDouglas DC-4-C55B · Kahului, HIDuring arrival, a descent was begun from 8000 to 7000 ft MSL at 0151 HST. At 0155 HST, the aircrew was cleared for a visual apch from 7000 ft MSL & a rapid descent was started with 20 deg of flaps & aprx 25 inches map (manifold pressure). The acft was…Jun 29, 1983 · N300JT · Substantial damageNTSB LAX81FJA03Accident · Minor injuriesClosedBell 206L · Kauai, HINov 2, 1980 · N59358 · Substantial damageNTSB LAX80FA109Accident · 2 fatalClosedPiper PA-34 · Lihue, HIJun 15, 1980 · N2564Q · DestroyedNTSB LAX80FJA18Accident · 3 fatalClosedCessna 172N · Kahului, HIJun 14, 1980 · N172JB · DestroyedNTSB LAX80DJA04Accident · No injuriesClosedCessna 152 · Honolulu, HINov 18, 1979 · N89774 · Substantial damageNTSB OAK78FJA15Accident · Minor injuriesClosedPiper PA-28 · Kailua-Kona, HIAug 23, 1978 · N8898E · Substantial damageNTSB OAK78DA012Accident · 2 fatalClosedPiper PA-28R · Ke-Ahole, HIDec 31, 1977 · N56357 · Destroyed