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 WPR11FA166Accident · 5 fatalField investigationFinal reportBeech 200 · Long Beach, CAThe pilot's failure to maintain directional control of the airplane during a momentary interruption of power from the left engine during the initial takeoff climb. Contributing to the accident was the power interruption due to water contamination of the fuel,…NTSB OPS11IA410Incident · No injuriesIncident investigationFinal reportBoeing 757-232 · Atlanta, GAThe air traffic controllers’ failure to adhere to required radar identification procedures, which resulted in loss of separation between the departing Boeing 757 and three other airplanes. Contributing to the incident was the pilots’ inadequate preflight…NTSB WPR11FA153Accident · Serious injuriesField investigationFinal reportVolin Kitfox Classic IV · Myrtle Creek, ORThe pilot's encounter with a windshear/downdraft that exceeded the climb performance capabilities of the airplane.NTSB ERA11WA362Accident · Minor injuriesForeign investigationCessna 152 · Kingston, JamaicaOn March 4, 2011, about 1000 eastern standard time, a Cessna 152, Jamaican registration 6Y-JGA, was substantially damaged during a forced landing, following a total loss of engine power during initial climb from Norman Manley International Airport (MKJP),…NTSB CEN11LA186Accident · Minor injuriesLimited investigationFinal reportGadbois Eugene W Apex CROSS-5 · Lago Vista, TXThe simultaneous loss of engine and electrical power after takeoff for undetermined reasons.NTSB DCA11WA024Accident · 7 fatalForeign investigationRaytheon Hawker · Sulaimanyia, IraqOn February 4, 2011 about 1449 UTC, OD-SKY, a Hawker Beechcraft HS-850XP, registered to Club Aviation S.A.L and operated by Sky Lounge services S.A.L., crashed during the initial takeoff climb at Suliamaniyah International Airport, Iraq. The 3 crew members…NTSB CEN11LA169Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Chesapeake, OHThe partial loss of engine power due to carburetor icing and the pilot’s delayed use of carburetor heat and failure to attain the proper touchdown point on the runway during the precautionary landing.NTSB CEN11LA161Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Matador, TXThe loss of engine power during initial climb for undetermined reasons.NTSB ERA11LA114Accident · No injuriesLimited investigationFinal reportDiamond Aircraft Ind DA 20-A1 · Pompano Beach, FLA total loss of engine power for undetermined reasons.NTSB ERA11WA119Accident · 1 fatalForeign investigationAvions Robin DR400 · Guidonia Montecelio, ItalyOn January 11, 2011, about 1430 universal coordinated time, an Avions Pierre Robin, DR400/180R, Italian registration I-ITAV, crashed during takeoff, while towing a glider, and was destroyed by fire. The airplane was departing Guidonia Airport (LIRG), Guidonia…NTSB WPR11LA095Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Lopez, WAA loss of engine power during initial climb for undetermined reasons.NTSB CEN11WA159Incident · Minor injuriesForeign investigationBeech B200 · Montpellier, FranceThe accident investigation is under the jurisdiction and control of the French government. This report is for informational purposes only and contains only information released by or obtained from the French government or Bureau d’Enquêtes et d’Analyses.…NTSB CEN11FA141Accident · 2 fatalField investigationFinal reportColumbia Aircraft Mfg LC41-550FG · Midlothian, TXThe engine's loss of power during takeoff for reasons that could not be determined because no engine anomalies were discovered during the postaccident examination.NTSB ERA11LA103Accident · No injuriesLimited investigationFinal reportCessna 152 · Wimauma, FLThe mechanic/pilot's failure to detect a visible exhaust gas leak and cracked cylinder head immediately prior to the accident flight, which resulted in a partial loss of engine power during initial climb. Contributing to the accident was an inadequate…NTSB WPR11LA080Accident · Serious injuriesLimited investigationFinal reportSchaefer Kitfox 4 · Glendale, AZThe pilot's failure to recognize the onset of and to prevent an aerodynamic stall at low altitude. Contributing to the accident were the manufacturer’s conflicting guidance about the power setting for takeoff and the pilot’s decision to conduct a…NTSB ERA11FA094Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Spencer, MAThe in-flight collision with a tree while returning to land for undetermined reasons.NTSB ERA11WA088Accident · 1 fatalForeign investigationPiper PA-32R-301T · Roma, ItalyOn December 8, 2010, at 1443 UTC, a Piper PA-32R-301T, N58SE, registered to Aircraft Guaranty Title Corporation Trustee,collided with a bus depot after departing runway 34 from Roma Urbe Airport (LIRU), Roma, Italy. The airplane had been recently purchased by…NTSB WPR11LA071Accident · Serious injuriesLimited investigationFinal reportBoeing 767 · Pago Pago, AntarcticaThe airplane’s encounter with convectively-induced turbulence, which resulted in serious injury to one flight attendant.NTSB ERA11LA079Accident · Minor injuriesLimited investigationFinal reportEasler Kelly Rans S6ES · St. Augustine, FLA total loss of engine power during initial climb for undetermined reasons.NTSB CEN11CA098Accident · No injuriesData collectionFinal reportAir Tractor AT-602 · Gregory, ARThe pilot’s inadequate preflight inspection and failure to detect water contaminated fuel, which resulted in a loss of engine power during takeoff.NTSB CEN11WA094Accident · 1 fatalForeign investigationCessna F150 · Linköping, SwedenOn December 1, 2010, at 1711 coordinate universal time, a Cessna F150H, SE-IGU, was substantially damaged upon impact with terrain after initial takeoff from the Linköping Airport (ESSL), Linköping, Sweden. The pilot was fatally injured. The airplane was…NTSB WPR11FA059Accident · 1 fatalField investigationFinal reportMooney M20R · Hollister, CAThe pilot did not ensure the airplane was loaded within its weight and balance envelope, which resulted in longitudinal instability and a loss of aircraft control during the initial climb.NTSB CEN11LA078Accident · No injuriesLimited investigationFinal reportSwiezy Glasair SHA · North Little Rock, ARThe pilot's failure to maintain adequate airspeed, resulting in an aerodynamic stall and hard landing.NTSB WPR11FA045Accident · No injuriesField investigationFinal reportEurocopter AS350B2 · Pacoima, CAThe contamination of a spool bearing in the power turbine governor during manufacture, which led to the bearing’s failure in flight, a subsequent loss of engine power during departure, and the resultant hard landing.NTSB ERA11FA054Accident · 4 fatalField investigationFinal reportPiper PA-44-180 · West Palm Beach, FLThe failure of both the pilot and the certified flight instructor to ensure that the left fuel selector was in the on position for takeoff and their failure to follow the proper procedures when the left engine lost power shortly after takeoff, resulting in an…NTSB CEN11CA062Accident · No injuriesData collectionFinal reportCessna 172 · Pineville, LAThe pilot/mechanic’s improper inspection of the airplane following the engine installation.NTSB ERA11LA049Accident · Serious injuriesLimited investigationFinal reportAirborne Classic · Stow, MAThe operator's inadequate engine maintenance, which resulted in a total loss of engine power. Contributing to the accident was the pilot's decision to conduct a downwind takeoff.NTSB DCA11WA008Accident · 21 fatalForeign investigationBeech 1900 · Karachi, PakistanOn November 5, 2010, a JS Air Pakistan, a Hawker Beechcraft B-1900, registration AP-BJD, crashed shortly after takeoff from Karachi-Jinnah International Airport (KHI), Karachi, Pakistan. All 17 passengers and 4 crewmembers onboard were fatally injured, and…NTSB CEN11LA049Accident · 1 fatalLimited investigationFinal reportLuscombe 8A · Schaumburg, ILThe pilot did not maintain airspeed following a loss of engine power during takeoff climb, which resulted in an aerodynamic stall. Contributing to the accident was the loss of engine power due to the unlocked engine primer.NTSB CEN11LA045Accident · Serious injuriesLimited investigationFinal reportWalker Kenneth Sonex · San Angelo, TXThe pilot's loss of airplane control. Contributing to the accident was the pilot's impairment due to alcohol.NTSB CEN11LA043Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Port Mansfield, TXThe total loss of engine power for undetermined reasons because examination of the airframe and engine did not reveal any anomalies that would have contributed to the loss of engine power.NTSB CEN11CA047Accident · No injuriesData collectionFinal reportAardema Robert John 1 Aardema RAG WNG SP · Oshtemo, MIThe failure of the ignition system wiring, which resulted in a total loss of engine power.NTSB CEN11LA041Accident · 1 fatalLimited investigationFinal reportDonegan Benton Kitfox II · Seguin, TXThe pilot’s failure to ensure adequate fuel on board and subsequent failure to maintain airplane control following an engine failure due to fuel exhaustion.NTSB CEN11IA106Incident · No injuriesIncident investigationFinal reportPiper PA-46-500TP · Olathe, KSThe loss of engine power for undetermined reasons.NTSB ERA11CA077Accident · Serious injuriesData collectionFinal reportAntares MA-33M R582 · Rising Fawn, GAThe student pilot's failure to relinquish control of the weight-shift control aircraft to the certified flight instructor, which resulted in an inadvertent stall.NTSB ERA11LA022Accident · 2 fatalLimited investigationFinal reportNewcomer RV6 · Monticello, GAThe pilot's loss of aircraft control during the initial climb.NTSB ERA11CA020Accident · Minor injuriesData collectionFinal reportMooney M20E · New Smyrna Beach, FLThe pilot’s inadequate preflight inspection, which resulted in the loss of engine power due to water contaminated fuel.NTSB CEN11CA071Accident · No injuriesData collectionFinal reportGrumman G-164 · Michigan, NDThe pilot's failure to abort the takeoff roll following a noticeable loss of engine power due to low engine compression and a magneto failure.NTSB WPR11LA013Accident · No injuriesLimited investigationFinal reportBeech C24 · Blanding, UTThe pilot’s failure to attain a climb gradient sufficient to clear the rising terrain, which resulted in his decision to make a forced landing on a road.NTSB ERA11LA009Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Columbia, SCA total loss of engine power due to a loss of lubrication after the engine experienced a piston ring failure for undetermined reasons.NTSB WPR11FA002Accident · Serious injuriesField investigationFinal reportCessna 310 · Avalon, CAThe pilot's improper setting of the left engine fuel selector valve, which resulted in fuel starvation of the left engine immediately after takeoff. Contributing to the accident was the pilot's decision to try to depart ahead of developing weather, which…NTSB CEN11LA001Accident · Minor injuriesLimited investigationFinal reportCessna 172D · Durango, COA total loss of engine power due to the pilot inadvertently moving the fuel selector to the OFF position. Contributing to the accident was the pilot's unfamiliarity with this model accident airplane.NTSB ERA11WA004Accident · 6 fatalForeign investigationCessna 185 · Nazca, PeruOn October 2, 2010, about 2102 Universal Coordinated Time (UTC), a Cessna 185, Peruvian registration OB-1808, operated by Air Nasca S.A.C., on a commercial air tour flight, was substantially damaged, when it impacted terrain after a loss of power during…NTSB CEN11CA016Accident · Minor injuriesData collectionFinal reportKevin Wilkinson Easy Eagle 1 · Central City, NEThe loss of engine power for undetermined reasons.NTSB CEN11CA002Accident · No injuriesData collectionFinal reportGingerich Alton & Slagel Dean Christavia MK 1 · Nappanee, INThe total loss of engine power for undetermined reasons.NTSB CEN10LA586Accident · Serious injuriesLimited investigationFinal reportCessna 175 · Deming, NMThe loss of engine power for undetermined reasons.NTSB CEN10LA573Accident · No injuriesLimited investigationFinal reportCessna 152 · Tea, SDThe loss of engine power due to fuel exhaustion as a result of the pilot’s inadequate fuel planning.NTSB CEN10CA549Accident · No injuriesData collectionFinal reportCessna 182D · Houston, TXThe loss of engine power during the initial climb due to decreased engine oil quantity and pressure as a result of the engine's oil cap not being adequately secured.NTSB ERA10WA489Accident · No injuriesForeign investigationPiper PA-31-350 · South Bimini, BahamasOn September 19, 2010, at 1440 eastern daylight time, a Piper PA31-350, N84859, registered to Spirit Air Inc, and operated by Pioneer Air Services was on initial climb out when the lower half of the main cabin door came open. The pilot reversed his course and…NTSB ERA10LA486Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Barnwell, SCThe failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.