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 FTW92LA041Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Houston, TXThe pilot's failure to correctly calculate fuel consumption and the loss of engine power. A factor was the unsuitable terrain.NTSB CHI92LA056Accident · No injuriesLimited investigationFinal reportCessna 177 · Elkhart, INThe pilot in command's failure to use carburetor heat. A factor to the accident was the carburetor icing conditions.NTSB LAX92LA061Accident · No injuriesLimited investigationFinal reportNorth American-Kenney T-28D-5, NA-260 · Bermuda Dunes, CAAn inadequate annual inspection performed by the mechanic. Contributing to this accident was the deterioration of the fuel bladder self-sealing lining and partial blockage of the fuel screens.NTSB NYC92LA039Accident · No injuriesLimited investigationFinal reportCessna 182 · Westerly, RIThe failure of the pilot to remove all the water from the fuel system prior to takeoff which resulted in a power loss.NTSB CHI92FA037Accident · No injuriesField investigationFinal reportBeech G-18S · West Chicago, ILA result of the pilot in command's not maintaining directional control, an improper inflight decision, and improper remedial action once the loss of directional control was recognized by the pilot. Factors contributing to this accident are inadequate cargo…NTSB ATL92LA027Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Statesville, NCLoss of engine power for undetermined reasons. A factor was the lack of a suitable landing site.NTSB LAX92LA049Accident · No injuriesLimited investigationFinal reportPiper PA28R-201 · Gila Bend, AZThe animal on the runway. Contributing to this accident was separation of the right main landing gear due to overload and the dark night.NTSB CHI92LA031Accident · No injuriesLimited investigationFinal reportCessna 310R · South St Paul, MNThe inadequate design of the propeller hub assembly which resulted in metal fatigue and propeller blade separation during initial climbout.NTSB DEN92LA008Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Greeley, COA partial loss of engine power on initial takeoff climb due to a bent and loose carburetor heat control mechanism.NTSB NYC92DNE01Accident · Serious injuriesFinal reportAdvanced Buccaneer SX B1B-503 · Palmer, MAA failed lower rudder attach pivot bolt which resulted in jammed flight controls and an uncontrolled descent into trees.NTSB SEA92FA019Accident · 2 fatalField investigationFinal reportCessna C-402B · Boise, IDThe loss of power on the right engine during initial climb after takeoff due to inadequate maintenance inspection and adjustment of the engine by company maintenance personnel, and the loss of control by the pilot due to his failure to properly configure the…NTSB NYC92LA033Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS-1-36 · Erwinna, PAThe pilot rotated the glider prematurely, resulting in an inadvertent stall at too low an altitude to allow recovery. Factors related to the accident were the pilot's total lack of experience in gliders, no experience in this type of glider, and improper trim…NTSB BFO92LA006Accident · No injuriesLimited investigationFinal reportCessna 150L · Portsmouth, VACollisiion with the deer on the runway. A factor was the dark night.NTSB SEA92LA018Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Auburn, WAThe loss of control on takeoff by the pilot due to the improper flap setting, the premature liftoff and his failure to attain proper climb airspeed after takeoff.NTSB ANC92LA017Accident · No injuriesLimited investigationFinal reportCessna 172 · Moose Pass, AKThe pilot's premature lift-off, causing the airplane to settle back to the ground. Contributing to the accident was the pilot's loss of directional control after settling back on the runway, due to his visibility being restricted by frost on the windshield.NTSB SEA92FA016Accident · 1 fatalField investigationFinal reportBell 206B · Salt Lake City, UTThe pilot failed to maintain directional control. Factors to the accident were: inadeqaute remedial action, over confidence in personal ability, and lack of recent expereince.NTSB ATL92FA020Accident · 1 fatalField investigationFinal reportPiper PA-24 · Engelhard, NCThe spatial disorientation experienced by the pilot, and his inadvertent descent into the terrain. A factor was the dark, night lighting condition at the time of the accident.NTSB LAX92LA036Accident · No injuriesLimited investigationFinal reportCessna 152 · Hayward, CAThe failure of the pilot to maintain directional control of the aircraft after it settled back onto the runway following a premature takeoff rotation. A factor in the accident was the lack of total experience of the pilot.NTSB CHI92LA021Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Bemidji, MNInadequate preflight planning and preparation by the pilot in command, the non performance o fan emergency procedure and not maintaining a positive rate of climb on behalf of the pilot in command. Factors contributing to the accident were the pilot in…NTSB LAX92LA031Accident · No injuriesLimited investigationFinal reportCessna T210L · Van Nuys, CAThe inadvertent loss of control during the initial climb after takeoff that resulted from the collapse of the rudder pedal because of a worn locking pin hole in the rudder pedal stowing system, which allowed the pin to disengage.NTSB NYC92LA022Accident · Minor injuriesLimited investigationFinal reportCessna 150 · Beekmantown, NYAn inadvertent stall due to the pilot's decision to prematurely retract the wing flaps. A factor related to the accident was the lack of altitude for recovery.NTSB NYC92LA023Accident · No injuriesLimited investigationFinal reportBeech B23 · Bombay, NYFailure of the pilot to use all the available take off area.NTSB FTW92FA015Accident · Serious injuriesField investigationFinal reportBellanca 17-30A · Cotulla, TXThe pilot's failure to maintain aircraft control. Factors related to the accident were: darkness, and a short in the electrical system which resulted in partial failure of the instrument lights and a malfunction of the autopilot.NTSB LAX92FA017Accident · 2 fatalField investigationFinal reportCessna 414 · Long Beach, CAThe pilot's improper emergency procedures by not retracting the landing gear when he shut the engine down and his failure to maintain airspeed. The scavenge pump failure, shutting down the engine and the inadvertent stall were factors in the accident.NTSB ANC92LA010Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-6 · Chevak, AKThe high crosswind condition, the pilot in commands inability to compensate for the wind conditions, and his failure to follow company procedures and the procedures recommended in the aircraft flight manual. Factor relating to the accident was the captain's…NTSB ATL92LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-25-235 · Thomasville, GAA total loss of engine power for undetermined reasons, and the pilot's failure to maintain a proper descent rate during the forced landing attempt.NTSB FTW92LA013Accident · No injuriesLimited investigationFinal reportCessna 150M · Matagorda, TXThe pilot's failure to maintain adequate flying speed during the attempted takeoff.NTSB NYC92LA011Accident · No injuriesLimited investigationFinal reportAerospatiale ND-26 · Albany, NYInadequate quality control during maintenance or manufacturing by failing to use corrosion inhibiter, which resulted in corrosion, fatigue, and subsequent failure.NTSB FTW92LA012Accident · No injuriesLimited investigationFinal reportNorth American Navion · Denison, TXThe exceeding of the airplane's takeoff performance capability by the pilot's inadequate preflight preparation..NTSB CHI92FA013Accident · 2 fatalField investigationFinal reportPiper PA28-140 · Lafayette, INFailure of the pilot to compensate for wind conditions during initial climb. Factors associated with the accident are crosswind conditions and a dark night light condition.NTSB ATL92LA009Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Whitesburg, GAA sudden wind shift during initial climb which resulted in an uncontrolled descent.NTSB LAX92LA016Accident · Minor injuriesLimited investigationFinal reportCessna 182K · Reno, NVA partial loss of engine power for undetermined non-mechanical reasons.NTSB NYC92LA008Accident · Serious injuriesLimited investigationFinal reportTaylorcraft BC12D · Townshend, VTThe pilot allowed the speed of the airplane to get too slow, resulting in inadvertent stall at too low an altitude to allow recovery.NTSB FTW92LA008Accident · Serious injuriesLimited investigationFinal reportBellanca 17-31 · Big Spring, TXThe complete loss of engine power due to a failed piston rod. A factor was the lack of suitable terrain for the forced landing.NTSB NYC92LA007Accident · Serious injuriesLimited investigationFinal reportGrumman AA-5A · Boxboro, MAThe pilot's failure to perform an adequate preflight to remove ice/frost from the aircraft wings.NTSB NYC92LA006Accident · Minor injuriesLimited investigationFinal reportBell 47G-3B-1 · Catawissa, PAPilot factor in that the pilot used poor judgement and loaded more passengers than were seats on the helicopter this resulted in control interference and subsequent loss of control. Contributing was the pilot's failure to check the weight and balance for the…NTSB SEA92LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA28-140 · Renton, WAA loss of engine power for undetermined reasons and unsuitable terrain available for a forced landing.NTSB NYC92LA004Accident · No injuriesLimited investigationFinal reportCessna 172 · Toledo, OHThe pilot's failure to preform an aircraft preflight, and remove the gust lock from the aileron, resulting in a loss of airplane control during initial climb.NTSB SEA92LA015Accident · No injuriesLimited investigationFinal reportCessna 177A · Trout Lake, WAAn inadequate compensation for wind, and proper climb rate not being maintained. Factors include inadequate preflight planning, the pilot's over-confidence in his own ability and the ability of the aircraft, lack of experience in this type of operation, and a…NTSB SEA92LA003Accident · No injuriesLimited investigationFinal reportCessna 337A-RG · Snohomish, WAFuel system starvation, due to the pilot's improper fuel tank selection. Factors include procedures not being followed, and inattentiveness.NTSB MIA92LA007Accident · Minor injuriesLimited investigationFinal reportO'Dell, Herbert L. Evans VP-1 · Summerfield, FLTotal loss of engine power due to fuel exhaustion and inadequate preflight by the pilot-in-command.NTSB FTW92LA003Accident · No injuriesLimited investigationFinal reportBeech C-45H · Edinburg, TXPower loss due to a loss of oil pressure for undetermined reasons. A factor was the lack of suitable terrain for forced landing.NTSB LAX92LA008Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5A · Flagstaff, AZAn inadvertent stall/mush due to the pilot's failure to maintain the appropriate airspeed during the takeoff attempt. Factors in the accident were the high density altitude and the inadequate preflight planning by the pilot.NTSB ATL92LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260 · Sanford, NCThe loss of engine power due to unknown reasons.NTSB DEN92LA001Accident · No injuriesLimited investigationFinal reportEnstrom F-28C · Evergreen, COIn flight encounter with a sudden downdraft. A factor was: the pilot's lack of total experience in aircraft type.NTSB BFO91FA087Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Laurel, MDA loss of engine power for undetermined reasons.NTSB SEA91FA255Accident · 3 fatalField investigationFinal reportLake LA-250 · Sisters, ORImproper planning/decision by the pilot(s), and failure to attain sufficient altitude to remain clear of obstructions. Factors related to the accident were: the pilot(s) failure to use all available runway, high density altitude, rising terrain and trees…NTSB NYC91LA249Accident · No injuriesLimited investigationFinal reportDavis D1K · Chester, CTImproper maintenance on the engine which resulted in a power loss due to a stuck exhaust valve and subsequent forced landing in unsuitable terrain.NTSB CHI91DEV05Accident · No injuriesFinal reportUllman Vari Viggen · Greenville, ILImproper maintenance installation of the propeller.NTSB SEA91LA254Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Kaycee, WYInadequate clearance with the vehicle and the pilot's failure to obtain proper assistance for the takeoff. Factors contributing to the accident were 1) the pilot's inadequate preflight planning, 2) the vehicle, and 3) high density altitude conditions.