NTSB investigations, HI
75 cases where the phase of flight was Initial climb.
Cases per year
| 1964 | 1 |
|---|---|
| 1965 | 5 |
| 1966 | 2 |
| 1967 | 1 |
| 1968 | 3 |
| 1969 | 1 |
| 1971 | 2 |
| 1972 | 2 |
| 1973 | 5 |
| 1975 | 3 |
| 1976 | 3 |
| 1978 | 3 |
| 1979 | 3 |
| 1980 | 3 |
| 1982 | 2 |
| 1983 | 1 |
| 1984 | 2 |
| 1986 | 2 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 3 |
| 1999 | 1 |
| 2003 | 2 |
| 2006 | 1 |
| 2007 | 3 |
| 2008 | 1 |
| 2014 | 1 |
| 2016 | 2 |
| 2017 | 1 |
| 2018 | 2 |
| 2020 | 1 |
| 2021 | 1 |
| 2024 | 1 |
| 2025 | 1 |
Where
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 = 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.
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 = 350)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 ANC25FA010Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 208B · Honolulu, HIOn December 17, 2024, about 1515 Hawaii-Aleutian Standard time, a turbine-powered Cessna 208B airplane, N689KA, was destroyed when it was involved in an accident near Honolulu, Hawaii. The two pilots onboard were fatally injured. The airplane was operated as…NTSB DCA21FA174Accident · Serious injuriesClass 2 · FieldFinal reportBoeing 737-275C · Honolulu, HIThe flight crewmembers’ misidentification of the damaged engine (after leveling off the airplane and reducing thrust) and their use of only the damaged engine for thrust during the remainder of the flight, resulting in an unintentional descent and forced…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 WPR18LA280Accident · No injuriesClass 3 · LimitedFinal reportMooney M20J · Kapolei, HILoss of engine power due to water in the fuel lines.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 WPR17LA138Accident · Serious injuriesLimited investigationFinal reportPiper PA 28-140 · Honolulu, HIA total loss of engine power during initial climb for reasons that could not be determined due to impact and fire damage.NTSB WPR17LA005Accident · No injuriesLimited investigationFinal reportMcdonnell Douglas Helicopter 369E · Waimea, HIImpact of the lift cable after it exited the helicopter during liftoff with the main rotor (MR) blades, which resulted in the separation of an MR blade tip and the vertical vibration of the helicopter.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 WPR14FA124Accident · 3 fatalField investigationFinal reportPiper PA31 · Lanai City, HIThe pilot’s spatial disorientation while turning during flight in dark night conditions and terrain-induced turbulence, which resulted in controlled flight into terrain. Contributing to the accident was the pilot’s impairment from a sedating antihistamine.NTSB WPR09FA060Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Kapolei, HIThe partial loss of engine power during the initial climb due to the failure of both pilots to use carburetor heat during a long descent for landing in carburetor icing conditions, and, the flight instructor's inadequate supervision of the flight.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 LAX07CA176Accident · No injuriesData collectionFinal reportI.C.A.-Brasov IS-28B2 · Mokuleia, HIthe pilot's inadequate compensation for the gusting tailwind conditions and failure to maintain directional control. The failure of the tow rope during takeoff was also causal.NTSB SEA07LA110Accident · Minor injuriesLimited investigationFinal reportEurocopter EC 130 B4 · Makawao, HIThe pilot's improper decision to takeoff downwind in a confined landing zone, which resulted in a failure to attain translational lift and a loss of control.NTSB LAX06LA155Accident · Serious injuriesLimited investigationFinal reportPartenavia P68 · Kaunakakai, HIthe pilot's failure to attain a proper climb rate and to maintain adequate clearance from the terrain during the initial climb in dark night conditions, which resulted in an in-flight collision with terrain.NTSB LAX04LA116Accident · No injuriesLimited investigationFinal reportHughes 369D · Wahiawa, HIThe pilot's failure to properly secure the external sling load, which allowed the load to shift, and subsequently strike and remove the tail rotor.NTSB LAX03LA171Accident · No injuriesLimited investigationFinal reportDenis Cozy · Kailua-Kona, HIA clogged fuel filter, which resulted in fuel starvation and a total loss of engine power during takeoff-initial climb.NTSB LAX99FA242Accident · 1 fatalField investigationFinal reportBeech 58 · Hilo, HIThe pilot's improper fuel system modifications resulting in inadequate fuel flow to the left engine during a critical phase of flight. Factors in the accident were the operation at an over gross weight condition with a CG more than 2 inches aft of the rear…NTSB LAX97LA139Accident · Minor injuriesLimited investigationFinal reportCessna 182F · Mokuleia, HIAn unintentional stall for undetermined reasons.NTSB LAX97FA108Accident · Minor injuriesField investigationFinal reportBeech H18 · Honolulu, HIloss of aircraft control for undetermined reason(s).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 LAX96LA110Accident · Serious injuriesLimited investigationFinal reportStolp Starduster II · Kahului, HIa faulty engine magneto, and decision by the pilot-in-command to operate the airplane with known deficiencies. A factor relating to the accident was: the airplane was overdue for an annual inspection.NTSB LAX96FA103Accident · 1 fatalField investigationFinal reportCessna 402B · Kamuela, HIfailure of the copilot (pilot-rated cargo loader, who was flying the aircraft) to establish and maintain a positive rate of climb after taking off at night; and inadequate supervision by the pilot-in-command (PIC), by failing to ensure that proper altitude…NTSB LAX96LA009Accident · Minor injuriesLimited investigationFinal reportHughes 369HS · Hana, HIthe loss of engine power due to inadequate maintenance inspection of the fuel system which permitted air to enter the engine fuel supply. A factor in the accident was the pilot's improper execution of the autorotation landing.NTSB LAX95FA031Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Honolulu, HIImproper loading of the airplane. Contributing to the accident was the pilot's failure to maintain minimum control airspeed.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 LAX91LA069Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Hilo, HIThe failure of the pilot to maintain an adequate airspeed while maneuvering. A factor in the accident was the pilot's decision to attempt steep and abrupt maneuvers during the takeoff initial climb phase.NTSB LAX89FA307Accident · 1 fatalField investigationFinal reportAero Commander 680FLP · Kailua-Kona, HIInadequate maintenance, and operation by the pilot with known deficiencies in the aircraft. Factors related to the accident were: excessive wear in both engines, improper use of powerplant controls by the pilot, subsequent overtemperature/detonation in both…NTSB LAX88LA203Accident · Minor injuriesLimited investigationFinal reportBell 206B · Honolulu, HIDuring a sightseeing flt, just after take off, the helicopter began to spin to the right, the plt tried to correct the situation by applying left rudder. The helicopter continued to spin. The plt reduced the throttle and adjusted the collective. The spin…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 LAX87FA112Accident · 1 fatalField investigationFinal reportHughes 369D · Honolulu, HIDrg tkof clb, a loud noise occurred as 1 of 5 main rotors (mrb's) & the tail boom sepd fm the helicopter (hel). The hel then crashed & hit a submerged reef aprx 200' fm the heliport. An exam of the failed mrb showed its retention strap assy(rsa), pn…NTSB LAX86FA243Accident · Serious injuriesField investigationFinal reportBell 206B · Hanalei, HIThe helicopter had just departed runway 05. Ground witnesses and several occupants in the helicopter reported that when it was about 150 ft AGL it sustained a total engine power loss. The pilot immediately entered into an abrupt right turn autorotation. The…NTSB LAX86LA090Accident · No injuriesLimited investigationFinal reportCessna 402B · Kalaupapa, HIThe plt said that when he departed rwy 5, the acft 'became airborne prematurely due to a hump and rough nature of the runway.' He further said that 'after wallowing monentarily behind the power curve,' the acft began a normal climb and acceleration profile.…NTSB LAX84LA401Accident · No injuriesLimited investigationFinal reportBeech H18S · Honolulu, HIDuring takeoff at about 50 ft AGL & 4,000 ft down rwy 4R, the right eng lost power. According to the plt, his airspeed was 105 mph & the right eng 'popped' before it lost power. He also stated that power on the left eng deteriorated after the the right prop…NTSB LAX84LA314Accident · No injuriesLimited investigationFinal reportHughes 369D · Honolulu, HIThe helicopter experienced a tail rotor failure shortly after departing the airport on a VFR local sling loading flt. The plt stated that, 'at approx 500 ft asl on climb out experienced sudden, severe vibration. Made a 180 degree turn to return to airport &…NTSB LAX83LA427Accident · Serious injuriesLimited investigationFinal reportBeech H18S · Kailua-Kona, HIAbout 1 min after takeoff, between 400-500 ft MSL & during the first power reduction, the right eng backfired. Followingsome more violent backfires the RPM went to zero. The right eng was restarted but the same result occurred. The plt attempted to feather…NTSB LAX82FJA05Accident · No injuriesFinal reportSchweizer SGS 1-34 · Dillingham, HIThe glider was about 5 feet above the rwy during a tow takeoff with the L-19 tow plane about ready to leave the ground when the glider plt switched hands on the control stick & apparently hit the cockpit canopy latch causing the canopy to open violently. The…NTSB LAX82DA042Accident · Minor injuriesFinal reportConvair 440 · Honolulu, HIAfter lift-off, the pilot called for the landing gear to be raised. As the plane was climbing through about 100 ft AGL, the pilot noted a loss of power in the right engine and saw a fire light. Ground witnesses heard a muffled explosion and saw smoke and fire…NTSB LAX81FJA04Accident · Serious injuriesClosedCessna 182H · Haleiwa, HINTSB LAX80FJA23Accident · Serious injuriesClosedHiller UH-12E · Honolulu, HINTSB LAX80FJA20Accident · Serious injuriesClosedSchweizer SGS126 · Oahu, HINTSB LAX80DJA07Accident · Minor injuriesClosedGrum Amer AA-5A · Honolulu, HINTSB OAK79FJA07Accident · Serious injuriesClosedCessna 152 · Pearl Harbor, HINTSB OAK79DJA06Accident · No injuriesClosedEmair MA-1 · Keaau, HINTSB OAK79DJA03Accident · No injuriesClosedMurrayair MA1B · Honokaa, HINTSB OAK78FJA12Accident · No injuriesClosedPiper PA-28 · Honolulu, HINTSB OAK78IA056Incident · No injuriesClosedDouglas DC-4 · Honolulu, HINTSB OAK76AP067Accident · Serious injuriesClosedCessna 402B · Molokai, HINTSB OAK76FJA20Accident · 1 fatalClosedBeech M35 · Honolulu, HINTSB OAK76FJA14Accident · No injuriesClosedPiper PA-32 · Lihue, HI