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 SEA07CA144Accident · No injuriesData collectionFinal reportBillings/Humbyrd Thorpe T-18 · Corona, CAA loss of engine power during the initial climb due to a fuel system malfunction. The pilot's incorrect maintenance modification to the fuel system and continued operation with known deficiencies were factors.NTSB DFW07LA124Accident · 1 fatalLimited investigationFinal reportAdams RV-6A · Boerne, TXThe pilot's failure to maintain the best angle of climb speed resulting in an inadvertent stall. A contributing factor was the high density altitude.NTSB CHI07LA157Accident · 1 fatalLimited investigationFinal reportPurvis Rans S6S · Newark, ILThe pilot's failure to maintain control of the airplane which resulted in inadequate airspeed and a subsequent stall. Contributing to the accident were the pilot's improper installation of the altimeter and airspeed indicator which rendered them inoperative…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 CHI07CA155Accident · No injuriesData collectionFinal reportChampion 7EC · Sioux Falls, SDThe pilot's inadequate compensation for the wind conditions and the excessive pull-up during the initial takeoff climb which resulted in the stall. A factor associated with the accident was the crosswind condition.NTSB CHI07LA154Accident · Serious injuriesLimited investigationFinal reportCessna 421 · Chesterfield, MOMaintenance personnel failed to comply with an Airworthiness Directive which resulted in the total failure of the starter adapter gear teeth and the crankshaft gear teeth and the pilot failed to follow the published emergency procedures. Contributing to the…NTSB LAX07CA172Accident · No injuriesData collectionFinal reportSchweizer SGS2-33A · Los Alamitos, CAfailure of the towrope during the initial climb out.NTSB CHI07CA152Accident · No injuriesData collectionFinal reportCessna 421C · Kokomo, INThe pilot not obtaining proper alignment with the runway during the emergency landing after takeoff, which imparted an excessive side load on the landing gear. Factors contributing to the accident were the unstabilized approach and engine shutdown due to the…NTSB CHI07CA148Accident · No injuriesData collectionFinal reportCessna A188 · Scotland, SDThe pilot not maintaining adequate airspeed during takeoff, which resulted in an inadvertent stall. Factors contributing to the accident were the sudden wind shift and the low altitude at which the stall occurred.NTSB SEA07LA126Accident · 1 fatalLimited investigationFinal reportCessna 150G · Pahrump, NVThe loss of engine power due to fuel contamination followed by the pilot's failure to maintain aircraft control during takeoff. Contributing factors were the pilot's inadequate preflight and an inadequate 100-hour maintenance inspection by other maintenance…NTSB SEA07CA130Accident · No injuriesData collectionFinal reportAircraft Mfg & Dev. CH 2000 · Merced, CAThe student pilot's inadvertent stall/mush during a simulated power loss after takeoff and the flight instructor's delayed remedial action, which resulted in a hard landing. A contributing factor was the flight instructor's lack of familiarity with the…NTSB CHI07CA139Accident · No injuriesData collectionFinal reportCessna 150 · English, INThe pilot's inadequate preflight planning due to his decision to takeoff downwind, and his subsequent failure to maintain adequate clearance from the power line. Contributing factors to the accident were the power line and the trees.NTSB LAX07LA167Accident · 1 fatalLimited investigationFinal reportSheely Rans S-12XL · Pinetop, AZthe pilot's failure to maintain adequate airspeed, which resulted in a stall and collision with terrain.NTSB LAX07CA165Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Moab, UTThe pilot's failure to obtain and maintain an adequate airspeed that resulted in a stall/mush. Also causal was the pilot's failure to abort the takeoff in a timely way. A factor in the accident was the high density altitude.NTSB ANC07CA033Accident · No injuriesData collectionFinal reportCessna 185 · Cantwell, AKThe pilot's inadequate compensation for wind conditions during takeoff initial climb, which resulted in a descent into high vegetation, and a nose over. Factors contributing to the accident were the pilot's inadequate weather evaluation and a downdraft.NTSB MIA07LA091Accident · 1 fatalLimited investigationFinal reportLee Stevens Sorrell SNS-2 Guppy · Stewartstown, PAThe pilot's failure to maintain airspeed resulting in inadvertent stall. Contributing to the accident was the pilot's lack of experience in the airplane.NTSB DFW07LA105Accident · Serious injuriesLimited investigationFinal reportAviat A-1A · Farmingdale, NYThe pilot's failure to maintain control of the airplane during a short-field takeoff, which resulted in an inadvertent stall.NTSB SEA07CA122Accident · Serious injuriesData collectionFinal reportPiper PA-22 · Chiloquin, ORThe pilot's failure to maintain aircraft control during takeoff and initial climb. High vegetation was a factor.NTSB ANC07FA037Accident · 1 fatalField investigationFinal reportCessna 170 · Wasilla, AKA total loss of engine power during takeoff initial climb due to fuel contamination, and the pilot's inadequate preflight inspection.NTSB DFW07LA103Accident · 2 fatalLimited investigationFinal reportLivpt Lancair IV-P · McAllen, TXA loss of power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB CHI07LA126Accident · Serious injuriesLimited investigationFinal reportLuscombe 8A · Fruitport, MIThe flight instructor failed to use carburetor heat during takeoff in icing conditions. A factor was the power line pole.NTSB SEA07LA114Accident · Minor injuriesLimited investigationFinal reportBritten-Norman BN-2A-20 · Hamilton, MTThe loss of power in one engine, for undetermined reasons, soon after establishing the takeoff departure climb. Factors include rough/uneven terrain.NTSB DFW07CA098Accident · No injuriesData collectionFinal reportFlagg Kitfox IV · Centerville, TXThe loss of engine power due to the failure of the air induction ducting. A contributing factor was the lack of suitable terrain for the forced landing.NTSB LAX07CA135Accident · Minor injuriesData collectionFinal reportCessna 150L · Watsonville, CAa partial loss of engine power for undertermined reasons during takeoff.NTSB LAX07LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Palo Alto, CAa loss of engine power for undetermined reasons.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 NYC07CA101Accident · Minor injuriesData collectionFinal reportStinson 108-3 · Pompton Plains, NJA loss of engine power during the initial climb for undetermined reasons.NTSB MIA07LA081Accident · 2 fatalLimited investigationFinal reportCessna U206G · Welaka, FLThe pilot's continued visual flight into instrument meteorological conditions and his failure to maintain clearance from utility poles. Contributing to the accident were the fog and haze.NTSB NYC07FA096Accident · 1 fatalField investigationFinal reportBeech 95-B55 · Saranac Lake, NYThe pilot's failure to maintain adequate airspeed during initial climb after takeoff, which resulted in an inadvertent stall.NTSB ANC07LA029Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Anchorage, AKThe improper installation/reversal of the aileron flight control system by other maintenance personnel, and the pilot's inadequate preflight inspection, which resulted in a loss of control during takeoff initial climb.NTSB SEA07CA102Accident · Minor injuriesData collectionFinal reportNorth American Aviation Div. T-28C · Red Lodge, MTThe lack of suitable terrain for a forced landing. Contributing factors were the loss of engine power during takeoff for undetermined reasons, and rough/uneven condition of the terrain.NTSB CHI07LA121Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Sidney, OHThe total loss of engine power during initial climb due to oil starvation as a result of improper maintenance. The fixed base operator's failure to advise the pilot that the engine had been operated without oil in the engine and soft terrain were factors.NTSB NYC07LA094Accident · 2 fatalLimited investigationFinal reportRomeo Lancair Legacy RG · Fulton, NYA loss of engine power during the initial climb after takeoff for undetermined reasons.NTSB MIA07LA074Accident · Serious injuriesLimited investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Sarasota, FLThe total loss of engine power for undetermined reasons during initial climb after takeoff, resulting in a forced landing, and an in-flight collision with transmission wires and terrain.NTSB DEN07LA083Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Topeka, KSThe use of unapproved bolts to mount the crankshaft and gear together, causing fatigue and failure of those mounting bolts, resulting in the subsequent loss of engine power. Factors contributing to the accident were the separation of the crankshaft gear, and…NTSB SEA07LA095Accident · No injuriesLimited investigationFinal reportDiemert/Rotorway Exec 162 F · Roseburg, ORa total loss of engine power due to the failure of the primary and secondary electronic control units (ECU's) within the engine's Fully Automated Digital Electronic Control.NTSB SEA07LA092Accident · No injuriesLimited investigationFinal reportPiper PA-32R-301T · Lincoln, CAAn in-flight fire occurred during the initial climb as a result of the aviation maintenance technician's failure to sufficiently tighten the b-nut that was found disconnected post-accident. A contributing factor was the engine manufacturer's failure to…NTSB LAX07CA120Accident · No injuriesData collectionFinal reportCarpenter Lancair 320 · Los Angeles, CAcontamination of the number 2 fuel injector nozzle that lead to a partial loss of engine power.NTSB ATL07LA063Accident · No injuriesLimited investigationFinal reportRandy Stanley Rotoway Exc 162F · Foley, ALLoss of engine power due to failure of the No. 4 engine exhaust valve.NTSB DFW07LA087Accident · No injuriesLimited investigationFinal reportPZL 101A · Spicewood, TXThe loss of engine power due to water contamination in the fuel system. A contributing factor was the lack of suitable terrain available for the forced landing.NTSB MIA07CA061Accident · Minor injuriesData collectionFinal reportBruce E. Hotz Wind Wagon · Leesburg, FLThe failure of the pilot to abort the takeoff after recognizing that the engine rpm was 760 less than desired after becoming airborne, and the inability of the airplane to maintain a positive rate of climb resulting in a controlled descent, and in-flight…NTSB MIA07LA063Accident · Serious injuriesLimited investigationFinal reportJimenez Reymundo Challenger II Specia · Arecibo, PRThe uncertificated pilot's failure to remove the aft seat belt from around the aft control stick prior to flight.NTSB CHI07LA093Accident · No injuriesLimited investigationFinal reportBoeing 767-300 · Chicago, ILThe contained fan blade tip separation following the ingestion of several birds into the left engine during takeoff and the lack of an adequate response time available to crew to avert the bird strike.NTSB MIA07FA056Accident · 1 fatalField investigationFinal reportBeech 95-C55 · Port Orange, FLThe pilot's failure to maintain airspeed during initial climb resulting in inadvertent stall. Contributing to the accident was the pilot's improper positioning of the left fuel selector which resulted in fuel starvation to the left engine.NTSB SEA07LA066Accident · No injuriesLimited investigationFinal reportScherer Europa · Upland, CAThe pilot's inadequate condition inspection and subsequent loss of engine power due to fuel starvation as a result of a blocked fuel filter.NTSB ATL07LA045Accident · 2 fatalLimited investigationFinal reportHiller UH-12A · Bethlehem, GAThe pilot's failure to maintain adequate rotor rpm, which resulted in an attempted autorotation and in-flight collision with trees. Contributing to the severity of the accident was the pilot exceeding the helicopters takeoff capability.NTSB NYC07LA068Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Saluda, VAThe improper repair of the carburetor heat control linkage by person(s) unknown. Contributing to the accident was the pilot's improper decision to takeoff, with the engine developing partial power.NTSB SEA07LA059Accident · Minor injuriesLimited investigationFinal reportBarnhart RV-6 · Auburn, WAA loss of engine power due to the obstruction of the engine's air inlet by a fabricated neoprene seal, and inadequate maintenance by unknown maintenance personnel. A contributing factor was the lack of suitable terrain for a forced landing.NTSB DEN07IA069Incident · No injuriesIncident investigationFinal reportAirbus Industrie A319-111 · Denver, COFracturing of the aircraft windscreens due to impact with foreign object debris. Contributing to the event was the high, gusty surface winds.NTSB MIA07LA049Accident · Minor injuriesLimited investigationFinal reportMcDonnell Douglas 369FF · Placida, FLThe in-flight separation of the tail rotor pitch change control rod and bellcrank during takeoff-initial climb.