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 ATL92LA051Accident · No injuriesLimited investigationFinal reportCessna 172I · Bainbridge, GAThe pilot's failure to maintain airspeed on the initial climbout, and the inadvertent stall/mush which resulted. Factors in this accident were: the high obstructions (trees) near the airstrip.NTSB LAX92FA130Accident · 2 fatalField investigationFinal reportCessna 150M · San Ysidro, CAThe certified flight instructor's improper supervision of the flight to correct the student pilot's improper use of the flight controls resulting in an excessive angle of attack and failure to maintain the proper airspeed. Contributing to this accident was…NTSB ANC92LA042Accident · No injuriesLimited investigationFinal reportPiper PA-18A-135 · Paxson, AKThe pilot failed to attain & maintain takeoff airspeed. Factors to the accident were: takeoff was performed with a tailwind, and inadequate remedial action.NTSB LAX92LA126Accident · No injuriesLimited investigationFinal reportGrumman G-164B · Dixon, CAThe pilot's premature lift-off. Contributing to the accident was the inadvertent stall/mush and the soft dirt airstrip.NTSB NYC92LA065Accident · Minor injuriesLimited investigationFinal reportCessna 305A · Plymouth, MAThe failure of the pilot to use carburetor heat which resulted in the formation of carburetor ice and a subsequent loss of engine power and forced landing in trees.NTSB LAX92LA124Accident · Minor injuriesLimited investigationFinal reportCessna 150 · San Jose, CAThat the certified flight instructor's (CFI) misjudged approach which resulted in a long landing, the cfi's in-flight decision to a go-around with partial power, and the failure of the CFI to maintain aircraft control in the initial climb segment of the…NTSB FTW92LA072Accident · Serious injuriesLimited investigationFinal reportRyan Navion A · Oklahoma City, OKThe propeller hydraulic control pitch setting being incorrect for undetermined reasons. A factor in the accident was the pilot's failure to identify and correct the pitch setting as the propeller went to a higher setting.NTSB DEN92LA037Accident · No injuriesLimited investigationFinal reportCessna 177RG · Durango, COA total loss of power due to a mechanical failure of the engine. Factors were: rough and uneven snow covered terrain.NTSB ANC92LA039Accident · Minor injuriesLimited investigationFinal reportCessna 185F · Pelican, AKThe pilot's inadequate visual lookout during takeoff. Contributing to the accident was the glare from the sun.NTSB MIA92LA088Accident · No injuriesLimited investigationFinal reportBeech E-55 · Tallahassee, FLFailure of the pilot to attain the proper airspeed (vhc) before rotation which resulted in failure to maintain directional control following total loss of engine power from the right engine. Contributing to the accident was failure of the right engine, engine…NTSB SEA92LA047Accident · Minor injuriesLimited investigationFinal reportKna,Ken,Dac,Wel Tern Sailplane · Cottage Grove, ORThe pilot's inadequate preflight of the sailplane. Factors contributing to the accident were improper tow equipment and lack of total glider experience.NTSB NYC92LA060Accident · Serious injuriesLimited investigationFinal reportPiper PA-22-20 · Isle Au Haut, MEFuel system icing and contamination which resulted in a loss of engine power and subsequent stall and loss of control during a forced landing.NTSB LAX92LA117Accident · No injuriesLimited investigationFinal reportCessna 152 · Show Low, AZThe total loss of engine power due to undetermined reason(s). A factor in this accident was the soft soil the airplane encountered during landing roll which caused the airplane to nose over.NTSB MIA92IA081Incident · No injuriesIncident investigationFinal reportBoeing 727-214A · San Juan, PRThe flight engineer's lack of training in emergency procedures and his failure to follow published emergency procedures, resulting in his not being able to manually extend the right main landing gear, following the loss of the 'a' hydraulic system.…NTSB LAX92LA113Accident · No injuriesLimited investigationFinal reportCessna 150M · Tucson, AZFuel exhaustion due to the instructor pilot's failure to refuel the aircraft.NTSB LAX92LA107Accident · No injuriesLimited investigationFinal reportCessna 150D · Carson City, NVThe pilot's premature liftoff which resulted in a stall mush.NTSB DEN92LA029Accident · Minor injuriesLimited investigationFinal reportWarfield BD-4 · Englewood, COImproper vr speed used, causing an inadvertent stall/mush. A factor was: the pilot's lack of total experience in aircraft make and model.NTSB CHI92FA084Accident · 3 fatalField investigationFinal reportPiper PA-31T · Swanton, OHLoss of aircraft control for an undetermined reason.NTSB BFO92LA028Accident · No injuriesLimited investigationFinal reportPiper PA-46 · Baltimore, MDThe failure of the fuel line, for undetermined reasons, resulting in a fuel leak causing an engine fire and total power loss.NTSB FTW92FA061Accident · 1 fatalField investigationFinal reportBellanca 17-30 · Oklahoma City, OKThe second pilot's (left seat) failure to attain a positive rate-of-climb during an instrument takeoff, and inadequate supervision by the pilot-in-command. Factors were: the weather, and the copilot's lack of instrument flight time and training.NTSB DEN92LA027Accident · No injuriesLimited investigationFinal reportCessna 172P · Englewood, COA loss of control due to the pilot's failure to follow proper soft field takeoff procedures by flying out of ground effect at an inadequate airspeed. A factor was the pilot's improper use of flaps.NTSB BFO92FA025Accident · 1 fatalField investigationFinal reportBeech V35B · Manassas, VAThe pilot's failure to remove ice from the wings during the preflight inspection which resulted in a stall during takeoff due to ice on the wings.NTSB LAX92LA100Accident · Serious injuriesLimited investigationFinal reportJames Houston KR2 · Chandler, AZThe pilot's improper emergency procedures, misjudging the airplane's altitude, failure to attain the proper touchdown point and excessive airspeed. Contributing to this accident was an undetermined loss of power and the pilot's lack of familiarity with the…NTSB FTW92LA059Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Denton, TXFouled spark plugs, loose spark plug ignition lead, exhaust leak, and cylinder leak. Factors were an inadequate annual inspection, poor maintenance, and operation by the pilot with known mechanical deficiencies.NTSB LAX92LA097Accident · No injuriesLimited investigationFinal reportCessna 120 · Sonoma, CAEngine failure due to a binding mixture control shaft. The binding mixture control shaft was the result of inadequate maintenance which allowed the accumulation of moisture and water in the carburetor to remain for an extended period of time causing rust and…NTSB LAX92FA094Accident · 2 fatalField investigationFinal reportMooney M-20-C · Santa Monica, CAFuel contamination by water due to the; 1) failure of the fuel caps to properly seal against water ingestion, 2) the pilots failure to adequately perform a preflight inspection of the aircraft sufficient to detect the presence of water in the fuel tanks.…NTSB CHI93LA381Accident · No injuriesLimited investigationFinal reportCessna 172 · Union Center, SDImproper planning/decision by the pilot, and his failure to abort the takeoff, while there was sufficient runway remaining. Factors related to the accident were: the soft runway condition & fence at the end of the runway.NTSB CHI92LA073Accident · No injuriesLimited investigationFinal reportCessna 177RG · Indianapolis, INEngine loss of power for undetermined reasons. The lack of suitable terrain for a forced landing was a factor.NTSB ATL92FA040Accident · 2 fatalField investigationFinal reportCessna 140 · Columbia, SCThe pilot-in-command's failure to assure that an adequate supply of fuel was on board the airplane for the intended flight, and his failure to maintain adequate airspeed during the forced landing resulting in a stall/spin. A factor contributing to the…NTSB BFO92LA019Accident · No injuriesLimited investigationFinal reportPiper PA-46-350P · Bowling Green, KYThe pilot's premature flare, stalling the airplane which resulted in a hard landing. Factors related to the accident were the dual fuel flow gauge failures and deteriorating weather conditions.NTSB BFO92IA017Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-102 · Baltimore, MDImproper installation of the low fuel pressure warning switch snubber on the #1 engine, resulting in fatigue failure of the snubber, a fuel leak (spray), and subsequent explosion/fire damage. A factor related to the incident was: inadequate design of the…NTSB ATL92LA036Accident · Serious injuriesLimited investigationFinal reportMosley HS GN-1 · Cullman, ALThe pilot's failure to maintain a safe flying speed.NTSB FTW92IA055Incident · No injuriesIncident investigationFinal reportBoeing 737-232 · Dfw Airport, TXThe failure of the aft cone bolt as result of preexisting fatigue cracking due to improper maintenance, and the failure of the secondary support structure as a result of loads that exceeded the capacity of the attaching hardware and the crushable honeycomb…NTSB BFO92LA021Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Edgartown, MAFailure of the pilot to attain adequate airspeed, which resulted in a stall. Factors related to the accident were the crosswind, the pilot's inadequate compensation for the wind and failure to maintain proper alignment with the runway, and high obstructions.NTSB LAX92LA080Accident · Serious injuriesLimited investigationFinal reportCessna 150L · Fresno, CAThe improper major repair of the carburetor heat control by unidentified persons that resulted the failure of the air intake distribution system and the loss of engine power.NTSB LAX92FA078Accident · 2 fatalField investigationFinal reportCessna 182R · Flagstaff, AZThe pilot became spatially disoriented and lost control of the airplane as he turned away from ground lights toward unlighted terrain. The clouds, fog, and dark night condition were factors.NTSB FTW92LA053Accident · No injuriesLimited investigationFinal reportBeech B19 · Bonham, TXInadvertent stall during the forced landing approach. A factor was the partial loss of power for undetermined reasons.NTSB ANC92LA060Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · Port Walter, AKThe design stress limits of the airplane were exceeded. A factor to the accident was: rough water.NTSB FTW92LA050Accident · No injuriesLimited investigationFinal reportBeech 95-C55 · Tyler, TXThe pilot's failure to feather the propeller and maintain directional control. Factors were the lose of power on one engine for undetermined reasons and the soft terrain.NTSB NYC92LA051Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-260C · Stratford, CTWater/ice in the fuel system, which resulted in fuel starvation and a loss of engine power. Factors related to the accident were: freezing temperatures and inadequate pre-flight preparation by the pilot.NTSB DEN92FA020Accident · 3 fatalField investigationFinal reportGrumman American AA-5A · Monte Vista, COAn inadvertent stall by the pilot in command at an altitude insufficient to effect recovery. Factors were: aircraft gross weight above maximum; physical impairment of the pilot; lack of total experience; lack of recent experience; and lack of experience in…NTSB MIA92LA050Accident · No injuriesLimited investigationFinal reportMooney M-20C · Plant City, FLTotal loss of engine power (nonmechanical) for undetermined reasons. This resulted in a forced landing to an unsuitable landing area and collision with terrain.NTSB DEN92LA017Accident · Minor injuriesLimited investigationFinal reportStinson 108-1 · Longmont, COA loss of engine power due to fouled spark plugs. The inadequate maintenance of the engine was a factor in the accident.NTSB ANC92LA021Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kenai, AKEngine failure due to fuel contamination. Contributing to the accident was unsuitable terrain.NTSB ANC92LA019Accident · 1 fatalLimited investigationFinal reportCessna 185 · Ketchikan, AKAn inadvertent stall while maneuvering for a precautionary landing. Factors include a partial loss of engine power for undetermined reasons, and inadequate altitude for the maneuver.NTSB MIA92LA047Accident · No injuriesLimited investigationFinal reportCessna 150M · Hollywood, FLTotal loss of engine power during the initial climb due to fuel starvation as a result of the pilot's failure to perform an adequate preflight to determine the quantity of fuel on board.NTSB NYC92LA041Accident · No injuriesLimited investigationFinal reportCessna 150 · Gansevoort, NYThe pilot's improperly planned approach, resulting in a landing on an icy runway at excessive speed; and unable to stop on the available runway and subsequent collision with trees. Factors related to the accident were the pilot's failure to obtain a weather…NTSB LAX92LA062Accident · No injuriesLimited investigationFinal reportCessna 210M · Palo Alto, CAAn engine power loss due to a partial blockage of the fuel selector valve with debris.NTSB CHI92LA052Accident · Serious injuriesLimited investigationFinal reportCessna 172 · Carlyle, ILFuel contamination and blockage of the carburetor, which restuled in fuel starvation. The high obstructions (trees) were a related factor.NTSB CHI92LA048Accident · 1 fatalLimited investigationFinal reportBeech A36 · Rensselaer, INThe pilot's improper aircraft handling which resulted in an inadvertent stall and descent. Factors related to the accident were the obscuration & icing conditions.