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 SEA98LA191Accident · No injuriesLimited investigationFinal reportCessna 172L · Puyallup, WAThe pilot-in-command's failure to refuel en-route resulting in fuel exhaustion. Contributing factors were a vehicle (in the landing path) and dark night conditions.NTSB CHI98LA365Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Wheatfield, INthe pilot's failure to apply carburetor heat when the engine lost power. Factors associated with the accident were the carburetor icing conditions which prevailed, the low altitude at which the loss of power occurred, and the soybean crop in which the…NTSB SEA98LA190Accident · No injuriesLimited investigationFinal reportCessna 150L · Bonners Ferry, IDImproper maintenance by an outsourcing facility which resulted in a lack of identification of scoring of the interior of the #3 cylinder rocker shaft bosses. The scoring resulted in a fatigue fracture and subsequent permanent closure of both intake and…NTSB ANC98LA163Accident · No injuriesLimited investigationFinal reportCessna 170B · Igiugig, AKThe pilot's failure to maintain directional control of the aircraft. Contributing factors were the crosswind condition, the pilot's lack of total experience in make/model of the aircraft, and the pilot not achieving a climb on takeoff.NTSB SEA98LA193Accident · No injuriesLimited investigationFinal reportCessna T-50 · Missoula, MTA quick drain was open due to the pilot's inadequate preflight.NTSB FTW98LA419Accident · No injuriesLimited investigationFinal reportHundere Kitfox II · Somerset, TXThe pilot's inadvertent stall. Factors were the wind sock that was displaying inaccurate information, the gusty wind condition, and the pilot's lack of experience in the tailwheel equipped airplane.NTSB ATL98LA131Accident · No injuriesLimited investigationFinal reportPiper PA 22-150 · Lancaster, SCThe loss of engine power for undetermined reasons. Factor were conditions favorable for the formation of carburetor ice..NTSB ATL98LA129Accident · No injuriesLimited investigationFinal reportConvair 240 · Loiza, PRThe loss of power in the No. 2 engine for undetermined reasons, and the inability of the pilot to establish a climb and/or maintain altitude. A factor was the incompletely feathered No. 2 propeller..NTSB CHI98LA360Accident · Minor injuriesLimited investigationFinal reportCessna P210N · Amery, WIA loss of engine power due to fatigue failure of the crankshaft from frictional heating for undetermined reasons. A related factor was the unsuitable terrain.NTSB NYC98LA195Accident · No injuriesLimited investigationFinal reportCessna 172D · Louisville, KYThe student pilot's failure to perform a preflight inspection of the airplane before his first solo flight, and inadequate supervision by the certified flight instructor, which resulted in fuel exhaustion.NTSB MIA98FA250Accident · 5 fatalField investigationFinal reportPiper Aerostar 600 · N. Myrtle Beach, SCThe pilot's failure to maintain airspeed (Vs) during a single engine approach resulting in an inadvertent stall. Factors contributing to the accident were a fatigue crack in the exhaust pipe in the right engine, the aircraft weight and balance was exceeded,…NTSB LAX98LA300Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dayton, NVLoss of engine power for unknown reasons. Factors were conditions conducive to carburetor icing and the use of automotive fuel.NTSB FTW98LA402Accident · No injuriesLimited investigationFinal reportFairchild M-62A-3 · Amarillo, TXThe inadvertent stall due to the pilot's failure to maintain proper airspeed during the takeoff.NTSB CHI98LA352Accident · No injuriesLimited investigationFinal reportFieseler Flugzeugbau F-156C-1 · Irish Hills, MIthe pilot selected to operate the airplane with a known deficiency. A factor in this accident was the vapor lock experienced by the engine's carburetor.NTSB CHI98TA354Accident · No injuriesFinal reportBell 206B-3 · Hinkley, MNLoss of engine power due to failure of the engine governor.NTSB SEA98LA176Accident · No injuriesLimited investigationFinal reportCessna 175 · Emmett, IDThe pilot's failure to ensure an adequate fuel supply for the flight, resulting in fuel exhaustion. A factor was a fence in the forced landing area.NTSB FTW98LA391Accident · No injuriesLimited investigationFinal reportCessna 180F · Douglas, WYA collision with a deer during take-off.NTSB CHI98LA337Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec PZL M18B · Tappen, NDthe pilot's improper preflight preparation resulting in the airplane exceeding the available airstrip distance during takeoff. A factor contributing to this accident was the swamp.NTSB MIA98LA245Accident · Serious injuriesLimited investigationFinal reportWood Glasair SH2 · Holly Hill, SCThe pilot's failure to maintain airspeed, and his failure to perform a go-around. The pilot's misjudgment of speed and distance during the landing is a contributing factor.NTSB LAX98LA289Accident · No injuriesLimited investigationFinal reportGlasflugel H 301 B Libelle · Tucson, AZFailure of the pilot to properly connect the aileron controls during reassembly of the glider, and, his inadequate preflight inspection of the glider.NTSB FTW98LA388Accident · Minor injuriesLimited investigationFinal reportAeronca 7AC · Kaufman, TXThe pilot's failure to maintain adequate altitude and clearance of obstructions during takeoff.NTSB LAX98LA283Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Truckee, CAThe pilot's failure to use carburetor heat in temperature conditions conducive to carburetor icing and his failure to lean the engine in a high density altitude environment, which combined, led to a partial loss of engine power and the onset of a stall during…NTSB ANC98LA143Accident · No injuriesLimited investigationFinal reportPiper PA-31-350 · Homer, AKA total loss of power in the right engine for undetermined reasons.NTSB FTW98LA386Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Hilltop Lakes, TXThe pilot's failure to maintain control of the aircraft during takeoff. Factors were the pilot's lack of experience in grass field operations, the unsuitable terrain for takeoff, and the pilot's failure to perform a soft field takeoff procedure more suitable…NTSB NYC98FA179Accident · 1 fatalField investigationFinal reportSmith, Ted Aerostar TS-600 · Marietta, PAThe failure of the pilot to maintain airspeed during a precautionary landing which resulted in a loss of control while operating with one engine shutdown. An additional cause was the improper maintenance procedures that resulted in the #5 cylinder not being…NTSB MIA98FA237Accident · 1 fatalField investigationFinal reportGlasair SH-2R · Panama City, FLThe pilot's failure to maintain a proper descent rate during a precautionary landing following a loss of engine power for undetermined reasons.NTSB LAX98LA280Accident · No injuriesLimited investigationFinal reportCessna 188B · Dixon, CAA partial loss of engine power for an undetermined reason, and the ignition of a highly combustible compound in the application hopper.NTSB IAD98FA103Accident · 2 fatalField investigationFinal reportBeech T-34B · Quantico, VAThe failure of the flight instructor to maintain airspeed which resulted in an inadvertent stall/spin.NTSB FTW98LA379Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Lamar, COThe pilot's failure to maintain climb airspeed, and inadvertently allowing the airplane to stall/mush. A factor was the embankment.NTSB NYC98LA173Accident · Serious injuriesLimited investigationFinal reportRobinson R22 · Duncannon, PAThe pilot's disregard of the fuel condition during the preflight which resulted in a takeoff with contaminated fuel and a loss of power. A factor was the pilot's lack of recent experience.NTSB CHI98LA328Accident · No injuriesLimited investigationFinal reportBeech B35 · Iowa City, IAThe fuel starvation due to improper fuel management by the pilot-in-command. Also, the aircraft procedures and directives which were not followed by the pilot-in-command is an additional cause. The rough and uneven terrain in addition to the low altitude of…NTSB FTW98FA372Accident · 3 fatalField investigationFinal reportCessna 175A · Erie, COThe pilot's failure to maintain flying speed (above stall speed) and the subsequent stall/spin. Contributing factors were the tailwind, high density altitude, and aircraft overweight conditions.NTSB IAD98FA097Accident · 1 fatalField investigationFinal reportCessna 182N · Painesville, OHThe pilot's failure to maintain adequate airspeed, while maneuvering back toward the runway resulting in an inadvertent stall. Also causal was the pilot's inadequate preflight inspection which resulted in his failure to secure the oil filler cap. A…NTSB FTW98FA365Accident · 1 fatalField investigationFinal reportCessna 150F · Wilton, ARThe pilot's failure to maintain minimum required airspeed for flight, which resulted in an inadvertent stall. Factors were the pilot's improper use of flaps during the takeoff climb and the high density altitude.NTSB FTW98FA364Accident · Minor injuriesField investigationFinal reportBeech 1900D · Denver, CODebonding of the propeller erosion shield due to an improper overhaul and repair by other maintenance personnel.NTSB LAX98LA271Accident · Minor injuriesLimited investigationFinal reportClark Barnett J4B2 · Marysville, CAThe pilot's inadequate rigging of the rotor blades and rudder, which led to an inability to maintain control of the gryocopter. The pilot's inadequate landing flare in soft terrain, which resulted in a nose low touchdown and subsequent nose over, and, his…NTSB FTW98LA363Accident · Serious injuriesLimited investigationFinal reportAero Commander S2R · Beeville, TXThe pilot's failure to maintain aircraft control and the ensuing inadvertent stall.NTSB ATL98LA115Accident · No injuriesLimited investigationFinal reportSchweizer G164B · Newton, MSThe erosion of the compressor impeller and the unsecured fuel control unit resulted in the loss of engine power during the initial climb.NTSB ANC98LA124Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Tok, AKThe pilot's inadequate compensation for wind conditions. A factor associated with the accident were gusty winds.NTSB LAX98LA265Accident · No injuriesLimited investigationFinal reportRaymond C. Voegele Mini IMP RC-2 · Sonoma, CAA loss of power due to a loose magneto cap and a binding throttle control cable. The deficiencies were the result of the owner/pilot's improper installation and/or adjustments.NTSB IAD98LA096Accident · No injuriesLimited investigationFinal reportCessna 172G · Williamson, NYDirectional control not maintained by one of the pilot's on board the airplane.NTSB FTW98LA390Accident · No injuriesLimited investigationFinal reportBeech E35 · Fort Worth, TXThe pilot's failure to maintain aircraft control during takeoff initial climb. A factor was the pilot lifting off the aircraft prematurely.NTSB CHI98LA314Accident · No injuriesLimited investigationFinal reportValentin Taifun 17E · Lake Geneva, WIthe pilot's failure to maintain directional control and obtain proper climb rate during initial climb after takeoff. A factor was trees.NTSB ANC98LA131Accident · No injuriesLimited investigationFinal reportCessna 172 · Palmer, AKFatigue of the forward end of the engine crankshaft resulting in separation of the propeller assembly, and the operator's failure to comply with a required maintenance procedure. A factor was uneven terrain.NTSB ANC98LA121Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Arctic Village, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable, and gusty wind conditions.NTSB CHI98LA311Accident · No injuriesLimited investigationFinal reportGrumman American AA-5B · Decatur, INthe pilot's failure to maintain adequate airspeed during the takeoff and his premature raising of the flaps which resulted in the stall/mush condition.NTSB CHI98LA305Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Edgeley, NDThe pilot's failure to maintain flying airspeed resulting in a stall/mush condition during the initial climb. Contributing factors were the high density altitude, high aircraft weight, and pilot's delayed jettison of the load, as well as the roadway and crop.NTSB CHI98LA302Accident · Serious injuriesLimited investigationFinal reportCessna 421B · Columbus, INthe pilot-in-commands failure to maintain airspeed and the subsequent stall/mush. Factors associated with the accident were the open baggage door and the inadequate aircraft preflight.NTSB CHI98FA300Accident · 2 fatalField investigationFinal reportPiper PA-18-150 · Rosemount, MNThe loss of engine power due to water-contaminated fuel and the pilot's failure to maintain adequate airspeed which resulted in a stall.NTSB ANC98LA117Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Delta Junction, AKThe pilot's selection of an unsuitable takeoff area. Factors associated with the accident were willow trees, and rising terrain.