NTSB investigations
20,557 cases where the phase of flight was Initial climb.
Cases, newest first
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.\"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."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 WPR24LA260Accident · No injuriesClass 3 · LimitedFinal reportKitfox Series V · La Grande, ORSeparation of the propeller blades from progressive damage at the blade roots due to overtightening of the hub bolts.NTSB ERA24FA318Accident · 2 fatalClass 3 · FieldFinal reportBeech A36 · Ronkonkoma, NYA loss of engine power during initial climb for undetermined reasons. Contributing to the outcome was the pilot's failure to maintain control of the airplane following the loss of engine power and his decision to perform an intersection takeoff which, reduced…NTSB CEN24LA281Accident · Serious injuriesClass 4 · LimitedFinal reportQuicksilver GT-400 · Mansfield, MOThe pilot’s failure to maintain control after takeoff, which resulted in an aerodynamic stall.NTSB GAA24WA258Accident · 3 fatalClass 5 · ForeignCessna 421C · Tofino, CanadaNTSB CEN24LA268Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Arcola, TXLoss of engine power due to fuel starvation as a result of the mechanic’s failure to properly secure the fuel system gascolator strainer bowl following an annual inspection.NTSB ERA24FA300Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-161 · Palm Beach Gardens, FLA loss of engine power for reasons that could not be determined.NTSB WPR24FA227Accident · 1 fatalClass 3 · FieldFinal reportFantasy Air Sro Allegro 2007 · Eureka, UTThe pilot’s failure to maintain airplane control during initial climb, which resulted in an in-flight upset and impact with terrain.NTSB CEN24LA246Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-402 · Helm, MSThe pilot’s failure to maintain control, which resulted in an aerodynamic stall and impact with terrain.NTSB CEN24LA245Accident · Minor injuriesClass 3 · LimitedFinal reportRaytheon A36 · Land O' Lakes, WIA partial loss of engine power for undetermined reasons.NTSB WPR24FA215Accident · 1 fatalClass 3 · FieldFinal reportCessna 182 · Big Creek, IDThe pilot’s delayed decision to go around after descending below the recommended abort altitude with a slight tailwind and an over-gross-weight airplane, which resulted in impact with trees and terrain. Contributing to the accident was the pilot’s failure to…NTSB ANC24LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland-Kenmore DHC-2 · Juneau, AKA partial loss of engine power during initial climb due to a cracked cylinder.NTSB ERA24LA279Accident · Serious injuriesClass 3 · LimitedFinal reportAlexander S Rolinski Aventura II · DeLand, FLImproper installation of the electric-driven fuel pump inlet hoses, which resulted in a hose failure and subsequent loss of engine power due to fuel starvation.NTSB DCA24WA220IncidentClass 5 · ForeignBoeing 737-8 · Seoul, South KoreaNTSB ERA24FA265Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Methuen, MAThe pilot’s failure to manage the available fuel supply, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA24FA262Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA31 · Loudonville, NYOn June 17, 2024, at 0816 eastern daylight time, a Piper PA-31-310, Canadian registration C-GKSI, was destroyed when it was involved in an accident in Loudonville, New York. The airline transport pilot was fatally injured and one person on the ground…NTSB GAA24WA221Accident · 1 fatalClass 5 · ForeignDe Havilland DHC2 · Red Lake, CanadaNTSB WPR24FA196Accident · 2 fatalClass 3 · FieldFinal reportLockheed 12A · Chino, CAThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall at an altitude insufficient for recovery. Contributing to the accident was the pilot’s failure to ensure that the airplane was…NTSB WPR24LA230Accident · No injuriesClass 3 · LimitedFinal reportCessna P210N · Reno, NVA loss of electrical power for undetermined reasons, which resulted in a partial extension of the landing gear and subsequent landing gear collapse during landing. Contributing to the accident was fuel starvation that resulted in a total loss of engine power.NTSB WPR24LA198Accident · Minor injuriesClass 3 · LimitedFinal reportWarren B Cox COX Breezy · Albuquerque, NMThe pilot’s exceedance of the airplane’s critical angle of attack while maneuvering for landing following a partial loss of engine power after takeoff, which resulted in an aerodynamic stall and loss of control. Contributing to the accident was maintenance…NTSB WPR24FA190Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Elk River, IDThe pilot’s failure to maintain clearance from terrain while climbing in mountainous terrain during moderately high density altitude conditions, and conditions conducive to severe carburetor icing.NTSB CEN24FA218Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Gainesville, TXThe fuel pump manufacturer’s improper torquing of screws on the engine-driven fuel pump, which resulted in a disruption in the fuel system and a loss of engine power on initial climb.NTSB ANC24LA049Accident · Serious injuriesClass 3 · LimitedFinal reportDehavilland Beaver L-20A (DHC-2) · Port Alsworth, AKA partial loss of engine power for reasons that could not be determined.NTSB ERA24LA257Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Zephyrhills, FLA partial loss of engine power during initial climb due to fuel contamination that resulted from corrosion and loose corrosion debris in the carburetor, which restricted fuel flow to the engine.NTSB ERA24LA248Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-25-235 · Colquitt, GAThe failure of the fuel shutoff valve from corrosion, which allowed the valve stem to obstruct the internal fuel port, resulting in a restriction of fuel flow to the engine.NTSB CEN24LA208Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-38-112 · Dalhart, TXThe pilot’s improper decision to take off with the airplane over its maximum allowable gross weight at a high density altitude, which degraded its climb performance and led an off airport landing.NTSB ANC24LA037Accident · No injuriesClass 4 · LimitedFinal reportDehavilland Beaver DHC-2 MK.1 · Fairbanks, AKThe pilot’s improper fuel management resulting in a loss of engine power due to fuel starvation.NTSB WPR24LA161Accident · Minor injuriesClass 3 · LimitedFinal reportAerospatiale SA315B · Hildale, UTMaintenance personnel’s failure to properly secure the EGT thermocouples, which resulted in catastrophic overtemperature of the engine and a total loss of engine power.NTSB CEN24LA200Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Taylor, TXA partial loss of engine power due to an incorrect carburetor air inlet hose, which led to a reduction in air flow to the engine.NTSB ERA24LA230Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Hope Mills, NCA loss of engine performance due to carbon fouling of three spark plugs that, when combined with the airplane’s high gross weight condition, resulted in a collision with trees and terrain.NTSB GAA24WA175Accident · 1 fatalClass 5 · ForeignCessna 182 · Kerestinec, CroatiaNTSB CEN24LA203Accident · No injuriesClass 3 · LimitedFinal reportPulsar Super Pulsar · Rochelle, ILA partial loss of engine power for undetermined reasons.NTSB GAA24WA176Accident · 1 fatalClass 5 · ForeignZenair Unknown · Caceres, SpainNTSB GAA24WA181Incident · No injuriesClass 3 · ForeignCessna 550 · Basseterre, St. Kitts & NevisNTSB ERA24FA219Accident · 1 fatalClass 3 · FieldPreliminary reportM-Squared Breese 2 · Culpeper, VAOn May 17, 2024, about 1430 eastern daylight time, an M-Squared Aircraft Inc. Breese 2 airplane, N99VY, was involved in an accident near the Culpeper Regional Airport (CJR), Culpeper, Virginia. The commercial pilot was fatally injured. The airplane was…NTSB WPR24LA154Accident · No injuriesClass 3 · LimitedFinal reportCessna 172G · Lakeport, CAThe pilot’s inadequate use of carburetor heat, which resulted in a total loss of engine power shortly after takeoff due to fuel starvation as a result of carburetor ice.NTSB ENG24LA014Incident · No injuriesClass 3 · LimitedFinal reportBoeing 787 · Singapore, SingaporeThe uncontained left engine failure was caused by the failure and liberation of the HPT stage 1 aft blade retainer as a result of a fatigue crack in the upper collet radius that originated from a surface connected cluster of Oxide/Carbonitride/Nitride/Carbide…NTSB WPR24LA146Accident · Minor injuriesClass 3 · LimitedFinal reportRobert Sterling 4P · Lake Havasu City, AZA loss of engine power during initial climb due to fuel vapor lock. Contributing to the accident was the incorrect installation of the ancillary fuel supply system components.NTSB GAA24WA162Accident · 3 fatalClass 5 · ForeignCessna 406 · Windhoek City, NamibiaNTSB ERA24FA206Accident · 1 fatalClass 3 · FieldFinal reportRaytheon A36 · Augusta, GAThe pilot’s excessive turn rate and bank angle while at low airspeed and altitude, resulting in an accelerated aerodynamic stall, loss of airplane control, and collision with terrain.NTSB WPR24FA132Accident · 1 fatalClass 3 · FieldFinal reportBell 206-L4 · Anaconda, MTA total loss of engine power due to a loss of cooling oil to the turbine-to-compressor coupling shaft and subsequent fracture of the shaft at an altitude too low for the pilot to complete a successful autorotation. Contributing to the accident was carbon…NTSB ERA24LA191Accident · Serious injuriesClass 3 · LimitedFinal reportSocata TBM 850 · Raleigh, NCThe pilot’s decision to continue an unstabilized approach, which resulted in a bounced landing, and his failure to maintain proper airspeed and climb attitude after aborting the landing, which led to the airplane exceeding its critical angle of attack and…NTSB WPR24LA130Accident · No injuriesClass 3 · LimitedFinal reportJames E Davidson JR Rans S-7S Courier · Benson, AZThe pilot’s unintentional use of a winter-blend fuel that was susceptible to vaporization, which resulted in fuel starvation and a loss of engine power due to vapor lock. Contributing to the accident was the airplane’s undersized fuel lines, which limited the…NTSB CEN24FA164Accident · 1 fatalClass 3 · FieldFinal reportLancair Legacy FG · Spicewood, TXThe pilot’s failure to properly configure the airplane during a go-around in gusting wind conditions, and his subsequent exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall at an altitude too low for recovery.NTSB WPR24LA127Accident · No injuriesClass 3 · LimitedFinal reportSchleicher Alexander ASH 26 E · Heber, UTReduced takeoff performance for reasons that could not be determined, which resulted in a forced landing.NTSB ERA24LA185Accident · 1 fatalClass 3 · LimitedFinal reportBailey-Moyes Dragonfly · Groveland, FLThe pilot’s improper installation and inspection of the right lower wing strut attachment bolt, which resulted in the inflight failure of the right wing.NTSB CEN24LA158Accident · No injuriesClass 3 · LimitedFinal reportJacobson SE5A Replica · Luther, OKThe pilot’s failure to use carburetor heat, which resulted in fuel starvation during the initial climb, a loss of engine power, and impact with terrain.NTSB GAA24WA147Accident · Minor injuriesClass 5 · ForeignBeech 200 · Goose Bay Newfoundland, CanadaNTSB CEN24LA153Accident · No injuriesClass 4 · LimitedFinal reportBeech B300 · Oklahoma City, OKAn in-flight collision with a bird during the initial climb.NTSB CEN24LA151Accident · Serious injuriesClass 3 · LimitedFinal reportTemco D-16A · Clarksville, ARThe pilot’s mismanagement of the fuel supply, which resulted in a loss of engine power on the left engine due to fuel starvation.NTSB ERA24LA169Accident · No injuriesClass 4 · LimitedFinal reportSnyder Robert L Challenger II · Hendersonville, NCA loss of engine power for undetermined reasons.