NTSB investigations
20,559 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 OPS10IA020Incident · No injuriesIncident investigationFinal reportBoeing 777-222 · San Francisco, CAThe local controller's issuance of a takeoff clearance to the Boeing 777 without ensuring that approved separation would exist with the Cessna 182. Contributing to the incident were tower procedures that permitted transitioning aircraft to cross the runway 28…NTSB WPR10LA174Accident · No injuriesLimited investigationFinal reportPiper PA30 · Hollister, CAA partial loss of engine power during the initial climb for undetermined reasons.NTSB ANC10FA029Accident · Minor injuriesField investigationFinal reportCessna 206 · Homer, AKThe fatigue failure of the No. 4 engine cylinder head resulting in a loss of engine power. Contributing to the severity of the accident was the pilot's decision to attempt a low altitude turn back to the airport, resulting in a loss of control.NTSB ERA10CA185Accident · Serious injuriesData collectionFinal reportShaw Fisher FP 404 · Lillian, ALThe pilot’s inadequate weather evaluation and failure to maintain directional control during takeoff in gusty wind conditions.NTSB CEN10LA171Accident · No injuriesLimited investigationFinal reportLoehr Thomas H Zenith Stol CH701 · Eldon, MOA loss of engine thrust during takeoff due to the failure of the engine-to-propeller drive belts as a result of improper belt tension. Contributing to the accident was the non-certificated pilot's improper preflight inspection.NTSB WPR10CA175Accident · No injuriesData collectionFinal reportBeech 23 · Twenty Nine Palms, CAThe pilot's encounter with a wind shear/downdraft that exceeded the climb performance capabilities of the airplane during initial climb.NTSB ERA10FA178Accident · 1 fatalField investigationFinal reportBeech 95 · Lagrange, NYThe pilot’s failure to maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.NTSB ANC10LA025Accident · Serious injuriesLimited investigationFinal reportBritten-Norman BN-2A-21 · Kodiak, AKThe pilot's failure to maintain clearance from rising terrain during takeoff resulting in collision with trees.NTSB WPR10LA154Accident · No injuriesLimited investigationFinal reportSutton Avid Hauler · Rigby, IDA loss of engine power during takeoff for undetermined reasons.NTSB ERA10LA166Accident · Minor injuriesLimited investigationFinal reportBelcher William B II Firestar · Wetumpka, ALThe student pilot’s in-flight loss of control as a result of previous damage to the airplane from an undetermined event.NTSB ERA10FA161Accident · 1 fatalField investigationFinal reportCessna T303 · Louisa, VAThe pilot's failure to maintain aircraft control and secure the right engine during a loss of engine power after takeoff. Contributing to the accident was the loss of engine power on the right engine for undetermined reasons.NTSB ERA10FA150Accident · 2 fatalField investigationFinal reportBeech C23 · Winter Haven, FLThe pilot’s improper placement of the fuel selector valve during takeoff, and his failure to maintain adequate airspeed following a total loss of engine power resulting in an inadvertent stall. Contributing to the accident was the failure of maintenance…NTSB ERA10CA152Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Patillas, PRThe student pilot’s decision to abort the takeoff with insufficient runway remaining.NTSB DCA10WA040Incident · No injuriesForeign investigationBoeing 727 · Torino, ItalyOn February 21, 2010, a Thomas Cook Boeing 757-200, registration G-TCBA, experienced an uncommanded fuel dump during initial climb after takeoff from Turin International Airport (LIMF), Torino, Italy. There were no injuries to the 8 crew members and 231…NTSB ERA10LA146Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Carthage, NCA total loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB WPR10FA136Accident · 3 fatalField investigationFinal reportCessna 310R · Palo Alto, CAThe pilot’s failure follow the standard instrument departure as instructed, and his failure to attain a sufficient altitude to maintain clearance from power lines during takeoff in instrument meteorological conditions.NTSB CEN10FA122Accident · 2 fatalField investigationFinal reportPiper PA-30 · Amarillo, TXThe pilot’s failure to detect water contaminated fuel, which resulted in a loss of engine power shortly after takeoff. Contributing to the accident were the worn and loose fuel caps, which allowed water to enter the fuel tanks.NTSB ANC10LA019Accident · No injuriesLimited investigationFinal reportCessna 208B · Kwigillingok, AKThe pilot's decision to take off with ice-contaminated wings in freezing rain and mist, which resulted in an aerodynamic stall.NTSB DCA10RA023Accident · 90 fatalForeign investigationBoeing 737 · Beirut, LebanonOn January 25, 2010, about 0041 UTC, Ethiopian Airlines flight 409, Boeing 737-800, ET-ANB, crashed into the Mediterranean Sea shortly after takeoff from Beirut-Rafic Hairiri International Airport, Beirut, Lebanon. Night instrument meteorological conditions…NTSB ANC10FA014Accident · 2 fatalField investigationFinal reportBeech 1900C · Sand Point, AKAn in-flight loss of control for an undetermined reason, which resulted in an uncontrolled descent.NTSB ERA10LA120Accident · 2 fatalLimited investigationFinal reportSteele Samuel D RV-4 · Picayune, MSThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall/spin. Contributing to the accident was the overweight and aft-center-of-gravity condition of the airplane at takeoff.NTSB WPR10LA111Accident · No injuriesLimited investigationFinal reportErcoupe 415-D · Napa, CAA loss of engine power due to fuel starvation as a result of the unintentional movement of the fuel selector valve beyond its stops during takeoff initial climb resulting in restricted fuel flow.NTSB ERA10CA114Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Collegedale, TNThe pilot’s failure to maintain directional control during the initial climb after takeoff in dark light conditions.NTSB WPR10CA106Accident · Minor injuriesData collectionFinal reportCessna 140 · Chico, CAThe pilot’s inadequate weather evaluation and failure to maintain clearance from trees while maneuvering in low visibility conditions.NTSB ERA10LA104Accident · No injuriesLimited investigationFinal reportCessna 150G · Doylestown, PAA partial loss of engine power due to carburetor icing.NTSB ANC10LA011Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Willow, AKThe pilot’s failure to ensure that the airplane’s fuel selector valve was on before takeoff, resulting in a loss of engine power due to fuel starvation, and his subsequent decision to attempt a low altitude turn towards the departure airport, resulting in an…NTSB CEN10LA083Accident · No injuriesLimited investigationFinal reportBeech B35 · Santa Fe, NMAn engine overpressure condition that resulted in oil getting on the exhaust and producing smoke which entered the cockpit. Contributing to the accident was the pilot's obscured vision due to smoke.NTSB WPR10LA083Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · San Jose, CAA total loss of engine power due to water contamination in the fuel system as a result of the pilot's inadequate preflight inspection.NTSB WPR10LA074Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fresno, CAA total loss of engine power for undetermined reasons.NTSB ERA10WA081Accident · Serious injuriesForeign investigationCessna A-188B · Quevedo, EcuadorOn November 25, 2009, a Cessna A-188B, Ecuadorian registration HC-CEU, registered to and operated by Russagrif, impacted terrain in the Los Rios Provenance following a loss of engine power, immediately after takeoff. The pilot sustained serious injuries and…NTSB ERA10LA077Accident · No injuriesLimited investigationFinal reportCessna 170B · Durham, NCThe total loss of engine power in flight and a fire in the engine compartment for undetermined reasons.NTSB CEN10FA057Accident · 1 fatalField investigationFinal reportCessna 182P · Kewanee, ILThe pilot's decision to initiate a visual night flight without recent night flight experience and his failure to maintain altitude during departure.NTSB CEN10CA060Accident · No injuriesData collectionFinal reportBoeing B75N1 · St. Louis, MOA loss of engine power for undetermined reasons.NTSB ERA10LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hammonton, NJA total loss of engine power due to a blocked fuel vent.NTSB CEN10LA052Accident · No injuriesLimited investigationFinal reportPiper PA-34-200T · Saginaw, TXThe pilot's inability to maintain control of the airplane due to a pinched trim system wire that resulted in a runaway nose-down pitch trim.NTSB ERA10LA053Accident · No injuriesLimited investigationFinal reportHughes 369 · Baxley, GAA loss of engine power due to fuel starvation resulting from the pilot’s inadequate preflight inspection of the main fuel valve position.NTSB ERA10LA050Accident · Minor injuriesLimited investigationFinal reportGrumman Aircraft ENG G-111 · Ft Pierce, FLA total loss of left engine power and subsequent failure of the airplane to maintain airspeed and altitude on the remaining engine for undetermined reasons.NTSB CEN10LA036Accident · Serious injuriesLimited investigationFinal reportBell 206 · High Island A-442AA total loss of engine power due to maintenance personnel's failure to correctly torque the Pc line following removal and reinstallation of the turbine module.NTSB CEN10LA035Accident · Serious injuriesLimited investigationFinal reportBlanik L-13 · Middlefield, OHThe student pilot's improper control inputs which resulted in the inadvertent stall of the glider.NTSB WPR10LA039Accident · Minor injuriesLimited investigationFinal reportSauer KR-2S · Glendale, AZA loss of engine power due to fuel starvation as a result of a reduced fuel flow to the engine resulting from a misrouted fuel tank vent line, during initial climb.NTSB ERA10FA040Accident · 2 fatalField investigationFinal reportCessna 310J · Lawrenceville, GAThe pilot’s loss of aircraft control while maneuvering in instrument meteorological conditions, as a result of spatial disorientation.NTSB ERA10LA026Accident · 2 fatalLimited investigationFinal reportFuji LM1 · Athens, GAAn aerodynamic stall shortly after takeoff for undetermined reasons.NTSB ERA10FA024Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Summerville, SCFlight into terrain for undetermined reasons.NTSB CEN10LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Peoria, ILA loss of engine power for undetermined reasons during climb out after takeoff, which resulted in a forced landing to a roadway.NTSB ERA10LA021Accident · No injuriesLimited investigationFinal reportPalen AVRO-504K · Rhinebeck, NYA loss of engine power due to the in-flight separation of the number 3 cylinder valve rocker arm attachment hardware. Contributing to the accident was the improper maintenance inspection of the engine.NTSB CEN10LA012Accident · Serious injuriesLimited investigationFinal reportLuscombe 8E · Weeping Water, NEThe pilot’s failure to maintain aircraft control resulting in a stall. Contributing to the accident was the stuck exhaust valve resulting in the partial loss of engine power.NTSB WPR10LA010Accident · 1 fatalLimited investigationFinal reportCruz SE5A Replica · Phoenix, AZThe pilot's failure to maintain airspeed during initial climb, which resulted in a stall/spin and impact with the ground.NTSB ERA10CA006Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Gainesboro, TNThe pilot's failure to maintain clearance from trees. Contributing to the accident were the rising terrain and night light conditions.NTSB WPR09LA471Accident · Minor injuriesLimited investigationFinal reportArrow Falcon Exporters OH-58A+ · Myrtle Creek, ORA partial loss of engine power during takeoff for undetermined reasons.NTSB ERA09LA544Accident · No injuriesLimited investigationFinal reportCelier Xenon RST · Mount Pleasant, SCThe gyroplane's inadequate climb performance for undetermined reasons.