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 ATL99LA096Accident · No injuriesLimited investigationFinal reportRutan VERI-EZE · Enterprise, ALThe pilot's failure to remove covers from the fuel tank vent which resulted in fuel starvation.NTSB DEN99LA080Accident · No injuriesLimited investigationFinal reportArtic S-1B2 · Lamar, COThe pilot's failure to maintain directional control during initial climb following takeoff. A factor was the pilot's lack of experience in the type of aircraft, and the fence.NTSB ATL99LA089Accident · Serious injuriesLimited investigationFinal reportBoyd Dan MONO-WHEEL; Euro · Smith, ALThe loss of engine power for undetermined reasons.NTSB FTW99LA141Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Roanoke, TXThe partial loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA140Accident · Minor injuriesLimited investigationFinal reportAir Tractor AT-301 · Brownwood, TXThe failure of the pilot-in-command to use the manufacturer's published checklist and extend the flaps prior to takeoff. A factor was the pilot's fatigued physiological condition as a result of extended flight and ground duty hours.NTSB ATL99LA083Accident · 1 fatalLimited investigationFinal reportMichael W. Campbell Lancair 320 · Tallessee, ALThe pilot's failure to maintain flying speed during the takeoff to initial climb that resulted in the a stall and the inflight collision with the trees.NTSB LAX99FA177Accident · 2 fatalField investigationFinal reportAerostar Rally RX-8 · Morgan Hill, CAThe pilot's selection of an inadequate takeoff site that did not allow sufficient horizontal clearance from obstacles in the takeoff path, and, his failure to ensure that all burners were connected to fuel sources, which reduced the available climb capability…NTSB IAD99FA043Accident · 6 fatalField investigationFinal reportCessna 205 · Celina, OHwas the pilot's failure to refuel the airplane which resulted in fuel exhaustion and a loss of engine power. Also causal to the accident was the pilot's failure to maintain aircraft control after the power loss. A factor in the accident was a lack of…NTSB FTW99LA134Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G164-B · Garwood, TXThe pilot's failure to maintain adequate airspeed which resulted in an inadvertent stall. A related factor was the high density altitude.NTSB FTW99LA133Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Lancaster, TXThe pilot's inadequate preflight inspection which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB ATL99FA081Accident · 4 fatalField investigationFinal reportPiper PA-24-180 · Vicksburg, MSThe pilot's failure to obtain and maintain flying speed that resulted in an inadvertent stall, and the collision with trees. A factor is the dark night.NTSB LAX99LA180Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Maxwell, CAFailure of the pilot to attain and maintain the proper reference climb airspeed during the rotation and initial climb, which resulted in a stall/mush condition.NTSB MIA99LA149Accident · 2 fatalLimited investigationFinal reportR.O. and D.O Hewitt Kitfox IV-1200 · Kannapolis, NCThe failure of the pilot-in-command to maintain airspeed and the inadvertent stall resulting in the uncontrolled descent with terrain. A factor in the accident was the impairment of the pilot by drugs (tetrahydrocannabinol).NTSB MIA99LA148Accident · No injuriesLimited investigationFinal reportCessna 172N · Eagleville, TNThe dual's student failure to maintain adequate altitude/clearance from the wire during takeoff/initial climb. Also causal was the certified flight instructor's inadequate supervision.NTSB CHI99LA142Accident · Minor injuriesLimited investigationFinal reportBeech BE-23 · Houghton Lake, MIThe loss of engine power for undetermined reasons.NTSB CHI99FA140Accident · 3 fatalField investigationFinal reportPiper PA-28R-201 · Curran, MIthe inadvertent stall/mush. Factor which contributed to this accident were the pilot's inadequate preflight planning, the premature lift-off during the takeoff, the airplane's low airspeed following lift-off, and the trees.NTSB CHI99LA137Accident · 2 fatalLimited investigationFinal reportBerrick GP-4 · Plattsmouth, NEaircraft control and airspeed not maintained by the pilot-in-command. A factor to the accident was the inadvertent stall.NTSB ATL99LA079Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Seneca, SCThe pilot's failure to maintain adequate airspeed which resulted in a stall and subsequent impact with trees.NTSB MIA99FA142Accident · 4 fatalField investigationFinal reportCessna 210L · Vero Beach, FLA loss of engine power due to a disconnected throttle/power lever, cable. Also causal was the failure of the mechanic to install a cotter pin in the throttle control cable attach hardware at the throttle control arm, and failure of the company quality control…NTSB FTW99LA124Accident · Serious injuriesLimited investigationFinal reportWsk Pzl Mielec M-18A · Hickory Ridge, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall/spin.NTSB ATL99LA077Accident · Serious injuriesLimited investigationFinal reportBeech 23-B24R · Boone, NCThe pilots failure to obtain/maintain proper climb rate during initial climbout. This resulted in the collision with the mountain/hilly terrain.NTSB CHI99LA134Accident · Minor injuriesLimited investigationFinal reportDawe Arnet Pereyra AV II · Fremont, MIthe seizure of the powerplant.NTSB DEN99FA066Accident · 2 fatalField investigationFinal reportSmith, Ted Aerostar 601P · Ruidoso, NMThe pilot's failure to maintain aircraft control for undetermined reason. A factor was the low ceiling IMC weather condition.NTSB LAX99LA157Accident · No injuriesLimited investigationFinal reportSchweizer G-164B · Marysville, CAA loss of engine power due to a leaking surge bleed valve which induced compressor stalls within the engine.NTSB LAX99LA156Accident · No injuriesLimited investigationFinal reportBeech A23-24 · Yerington, NVThe partial loss of engine power due to the pilot's failure to properly lean the engine for the high density altitude takeoff.NTSB FTW99LA117Accident · No injuriesLimited investigationFinal reportCessna 170B · Fayetteville, ARThe pilot's failure to obtain the proper climb rate resulting in an inadvertent stall. Factors were the rising terrain and the variable winds.NTSB ANC99LA048Accident · No injuriesLimited investigationFinal reportElam RAF 2000-GTX · Palmer, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident was a downdraft.NTSB LAX99LA153Accident · Serious injuriesLimited investigationFinal reportVentura Rans S-12 · El Cajon, CAEngine power loss due to an interruption of fuel to or within a carburetor, and the resultant overheating of its associated cylinder. The reason for the fuel flow interruption could not be determined.NTSB CHI99LA127Accident · No injuriesLimited investigationFinal reportReindl Quickie 2 · Olathe, KSThe loss of engine power for undetermined reasons. A factor associated with the accident is the lack of suitable terrain for a forced landing.NTSB CHI99LA125Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Mora, MNthe student pilot's improper soft field takeoff technique in that excessive back pressure was used which resulted in an inadvertent stall/mush. A factor associated with the accident was the student's lack of total experience.NTSB FTW99LA113Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Franklinton, LALoss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.NTSB ANC99LA043Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R · Fairbanks, AKThe loss of engine power due to the failure of maintenance personnel to properly torque a connecting rod bolt during an engine overhaul, and the subsequent disconnection of the connecting rod bolt and connecting rod.NTSB ATL99FA066Accident · 1 fatalField investigationFinal reportPiper PA-34-200 · Tallahassee, FLThe pilot's failure to maintain flying speed during initial climb which resulted in a stall and uncontrolled collision with terrain.NTSB NYC99LA083Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Orient, NYThe pilot's inadequate compensation for crosswind conditions during takeoff.NTSB FTW99LA101Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Jennings, LAThe pilot's inadvertent stall during the departure turn to downwind. A factor was the tailwind.NTSB LAX99LA122Accident · Serious injuriesLimited investigationFinal reportAero Commander 500B · Shelter Cove, CAFuel exhaustion due to the pilot's failure to ensure that an adequate fuel supply was onboard. A contributing factor was the lack of suitable terrain for the forced landing.NTSB FTW99LA095Accident · Minor injuriesLimited investigationFinal reportGrumman G-164A · Gillett, ARThe pilot's failure to maintain terrain clearance during the downwind departure. Factors were the tailwind and the wet soft grass airstrip.NTSB CHI99LA110Accident · Serious injuriesLimited investigationFinal reportSocata TB-9C · Cahokia, ILthe in-flight loss of control by the student pilot due to wind turbulence. Additional causes were the flight instructor's inadequate supervision of the flight and the flight instructor's decision to continue the touch and go after encountering turbulence on…NTSB LAX99LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Truckee, CAThe pilot's failure to obtain and maintain the proper climb airspeed during the initial takeoff climb, including his failure to anticipate the gust factor and density altitude effects in determining a safe airspeed.NTSB LAX99LA119Accident · Minor injuriesLimited investigationFinal reportGallob Rans S4 · Mesa, AZThe pilot's failure to adequately compensate for the existing crosswind condition and to maintain lateral control of the aircraft.NTSB ANC99LA033Accident · No injuriesLimited investigationFinal reportCessna 180G · Fairbanks, AKWater contamination of the fuel supply, and the pilot's inadequate preflight inspection to ensure all water was removed from the fuel supply. Factors in the accident were a wrinkle in the wing fuel tank bladder, and snow covered terrain.NTSB ANC99LA032Accident · No injuriesLimited investigationFinal reportCessna 170B · Palmer, AKThe pilot's inadequate preflight inspection, and his failure to refuel the airplane that resulted in fuel exhaustion.NTSB ATL99LA054Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-20 · Knoxville, TNA loss of engine power for undetermined reasons. Contributing to the accident was the failure of the landing gear to extend for undetermined reasons.NTSB FTW99LA088Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Denton, TXThe total loss of engine power on takeoff resulting from the failure of an incorrect throttle control cable clamp, which was installed by an unknown person. A factor was the lack of suitable terrain for the forced landing.NTSB DEN99LA043Accident · No injuriesLimited investigationFinal reportBeech 35-C33 · Leadville, COThe pilot's in-flight decision to turn into rising terrain, and his decision to fly into and out of the airport in a heavy weight condition after the local flight instructor/FAA accident prevention counselor recommended that he should not. Factors were the…NTSB CHI99LA092Accident · No injuriesLimited investigationFinal reportCessna 172RG · Lawrenceville, ILthe fatigue fracture of the landing gear actuator.NTSB FTW99LA080Accident · No injuriesLimited investigationFinal reportEurocopter BK 117 B-1 · Hockley, TXThe pilot's failure to maintain clearance with the power lines. A factor was the sunglare reducing the pilot's visibility.NTSB CHI99LA084Accident · Minor injuriesLimited investigationFinal reportBeech 35 · Lincoln, NEthe pilot's failure to perform an aircraft preflight which resulted in him selecting a fuel tank which had insufficient fuel for the flight and the subsequent fuel starvation.NTSB IAD99LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-32RT-300 · Medina, OHWas the pilot's failure to remove snow from the horizontal stabilator prior to take-off and his improper decision to depart downwind. Factors in the accident were the heavy snow squall and tailwind.NTSB FTW99FA075Accident · 5 fatalField investigationFinal reportCessna 182B · Ozona, TXthe pilot's failure to obtain/maintain clearance from terrain during initial climb after take off. A contributing factor was the dark night.