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 CHI89DET03Accident · No injuriesFinal reportNorth American F-51D · Fort Wayne, INPilot's failure to maintain aircraft control during the crosswind takeoff. Contributing to the accident was the premature lift off and the crosswind condition.NTSB FTW89FA078Accident · Serious injuriesField investigationFinal reportMBB BK-117A-4 · Houston, TXFailure of the pilot to maintain clearance from the obstruction (garage). Factors related to the accident were: darkness, adverse weather conditions, personnel in the area of the temporary heliport, lack of security provided by hospital management, which…NTSB MIA89FA124Accident · Serious injuriesField investigationFinal reportBeech C-45H · Tampa, FLFuel contamination of the left engine fuel system which resulting in a failure of the left engine.NTSB LAX89LA151Accident · No injuriesLimited investigationFinal reportMooney M20F · Prescott, AZThe failure of the plt to lean the fuel mixture for the high density altitude. Contributing to the accident was the cfi's lack of familiarity with the airplane and engine operating procedures.NTSB DEN89LA103Accident · Minor injuriesLimited investigationFinal reportCessna P172D · Crested Butte, COThe pilot selected a runway with unsuitable conditions for taking off. The unfavorable wind and terrain conditions were related factors.NTSB LAX89LA150Accident · No injuriesLimited investigationFinal reportCessna 172N · Prescott, AZImproper use of the elevator flight control by the pilot and his failure to maintain a proper rate of climb after lift-off. Contributing factors were: improper use of elevator trim by the pilot, his lack of total experience, and an inadvertent porpoise.NTSB ANC89FA056Accident · No injuriesField investigationFinal reportPiper PA-18 · Chugiak, AKCarburetor ice due to the pilot's improper use of powerplant controls; and failure of the pilot to maintain adequate airspeed, while maneuvering (turning left), which resulted in an inadvertent stall. Factors related to the accident were: failure of the pilot…NTSB SEA89GA064Accident · Minor injuriesFinal reportCessna 172P · Hawthorne, NVThe failure of the pilot to maintain flying speed and proper flying attitude resulting in a stall mush. Contributing to the accident were the density altitude and the variable winds.NTSB LAX89LA143Accident · Minor injuriesLimited investigationFinal reportCessna 150J · Bermuda Dunes, CAImproper assistance by ground personnel who inadvertently overloaded the airplane and the pilot's delay in jettisoning the load.NTSB MKC89LA086Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Papillion, NEThe contamination of the fuel screen by foreign matter and operation of the aircraft with known deficiencies.NTSB ATL89FA114Accident · Serious injuriesField investigationFinal reportBoeing A75N1 · Covington, GAInadequate preflight by the pilot by inadvertently allowing the carburetor heat to be in the 'hot' position for takeoff. The high density altitude and trees were considered to be contributing factors.NTSB SEA89LA059Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164A · Rosalia, WAA loss of engine power due to a supercharger failure. Contributing to the accident was the soft terrain on which the forced landing was made.NTSB ATL89DLG01Accident · No injuriesFinal reportUpchurch Rotorway Executive · Lugoff, SCImproper evaluation of existing conditions during preflight inspection resulting in a dynamic rollover due to drag from an imbedded left skid.NTSB LAX89LA134Accident · No injuriesLimited investigationFinal reportNaval Aircraft Factory N3N-3 · Phoenix, AZLoss of control due to inadequate preflight and control interference.NTSB LAX89LA132Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Oceanside, CAThe failure of the student pilot to compensate adequately for wind conditions and to relinquish the flight controls to the instructor. Contributing to the accident was inadequate supervision by the instructor.NTSB FTW89IA070Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9 · Houston, TXCrew's failure to follow taxi instructions and to insure that they were on the proper runway prior to initiation of the takeoff roll.NTSB ATL89FA112Accident · Serious injuriesField investigationFinal reportBell 206B · Atlanta, GAFatigue failure of the engine spur adapter gearshaft in an area where there was a lack of lubrication (oil starvation) due to a partially blocked oil delivery tube. Contributing factors were: inattentive maintenance or servicing of the aircraft by unknown…NTSB MKC89IA082Incident · No injuriesIncident investigationFinal reportGulfstream 690A · Bismark, NDA failed (cracked) engine plenum resulting in loss of engine power.NTSB MIA89FA111Accident · Serious injuriesField investigationFinal reportCessna 172H · Melbourne, FLThe pilot's selection of an inappropriate runway for takeoff and his inadequate compensation for crosswind conditions.NTSB LAX89LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Fullerton, CAEngine failure due to fuel starvation, the selection of the improper fuel tank by the student, and poor supervision by the instructor. Contributing to the cause of the accident was an inadequate preflight of the airplane by the dual student.NTSB DEN89LA088Accident · Minor injuriesLimited investigationFinal reportMiller S.A.L. 2/3 Mustang · Erie, COLoss of engine power for an unknown reason. Soft uneven terrain was a contributing factor.NTSB ATL89DKJ02Accident · No injuriesFinal reportAircraft Parts & Dev. A-9B · Athens, ALThe pilot's inadequate preflight preparation/planning to assure sufficient runway length for clearing obstructions.NTSB CHI89DEC03Accident · Minor injuriesFinal reportPiper PA-28 · Birmingham, MIAn undetermined fuel system blockage. Contributing to the accident was the lack of a suitable forced landing area.NTSB BFO89FA022Accident · 5 fatalField investigationFinal reportBeech A60 · Manassas, VAA loss of aircraft control due to the pilot's failure to maintain minimum engine control speed after a partial loss of power of the left engine for undetermined reasons. The pilot's inexperience in type of aircraft and an over maximum gross weight aircraft…NTSB ATL89FA098Accident · 1 fatalField investigationFinal reportBeech BE-18 · Covington, KYPilot attempted a takeoff with coating of frost on the airframe which resulted in a loss of lift during climbout.NTSB DEN89LA082Accident · Serious injuriesLimited investigationFinal reportStinson 108-2 · Custer, SDThe improper maintenance by the pilot in command/owner in that the magneto drive gear retaining nuts were not safetied which resulted in them backing off, disconnecting the magnetoes and one of the gears falling into the engine.NTSB ANC89FA049Accident · Minor injuriesField investigationFinal reportCessna A-185-F · Puntilla Lake, AKThe pilot's failure to obtain an adequate airspeed, the turn to reverse course maneuver performed at the reduced airspeed and poor preflight planning. Contributing to the accident were the mountainous terrain and the downdraft conditions.NTSB CHI89LA053Accident · No injuriesLimited investigationFinal reportAeronca 7KCAB · Pine Creek, WIThe pilot's selection of unsuitable terrain which resulted in the failure to achieve a proper climb rate which resulted in the collision with trees. Contributing to the accident was the uphill, snow covered terrain.NTSB ATL89LA094Accident · No injuriesLimited investigationFinal reportCessna 150G · Springboro, OHLoss of power (takeoff) from carburetor ice due to improper use of carburetor heat during extended ground operation using auto fuel in weather which was conducive to icing.NTSB MKC89LA066Accident · No injuriesLimited investigationFinal reportCessna 182RG · Ft. Madison, IAAn electrical wiring short that caused an in flight fire.NTSB CHI89DEV05Accident · No injuriesFinal reportCessna 182A · Sparta, ILPoor and improper maintenance which resulted in the carburetor venturi being blocked by the duct tape. Contributing to the accident was the soft terrain on which the forced landing was made.NTSB DEN89LA080Accident · Minor injuriesLimited investigationFinal reportEller BD-5B · Colorado Spring, COThe improper installation of fuel lines which were pinched off causing fuel starvation when the gear was retracted. A factor in the accident were the terrain features including loose gravel short of the runway.NTSB LAX89LA114Accident · Minor injuriesLimited investigationFinal reportNorth American AT-6 · Compton, CAFatigue cracks that existed in an engine cylinder.NTSB ANC89LA047Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Igiugig, AKThe pilot's failure to maintain control of the airplane and his failure to understand the performance parameters of his airplane.NTSB MKC89FA060Accident · 1 fatalField investigationFinal reportCessna 150K · Pemberton, MNPoor judgement on the part of the pilot in that he attempted a down wind take off without adequate distance to clear obstacles in his flight path.NTSB DEN89LA078Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Angel Fire, NMInadequate compensation for wind conditions by the pilot, which resulted in a loss of aircraft control. The adverse wind conditions and snowbank were related factors.NTSB MIA89LA084Accident · No injuriesLimited investigationFinal reportCessna 172M · San Juan, PRThe failure of the pilot to properly use carburetor heat in conditions conducive to the formation of carburetor ice.NTSB NYC89LA079Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Hammonton, NJA bird strike shortly after takeoff.NTSB MIA89LA077Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Bunnell, FLThe failure of the instructor to maintain the proper airspeed during a simulated engine failure on initial climb. The instructor, after taking control of the aircraft, also failed to properly flare the aircraft resulting in a hard landing during which the…NTSB DEN89IA071Incident · No injuriesIncident investigationFinal reportBeech E90 · Lander, WYDeer on the runway.NTSB LAX89LA098Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · San Martin, CAEngine failure due to a loose spark plug with the reminaing plugs fouled with carbon deposits.NTSB NYC89LA077Accident · No injuriesLimited investigationFinal reportCessna 150 · Craley, PAThe loss of control during takeoff due to a pilot induced stall. Contributing to the accident was the wrong runway selected by the pilot which put the aircraft in a downwind takeoff situation and the pilots misjudgement of the distance it would take the…NTSB LAX89FA099Accident · 1 fatalField investigationFinal reportSilvaire 8F · Lake Elsinore, CALoss of aircraft control due to improper and/or unapproved modifications to the aircraft's aileron control system by the pilot/owner. A contributing factor was the pilot/owner's overconfidence in his ability to modify the aileron control system without…NTSB NYC89FA074Accident · 1 fatalField investigationFinal reportCessna 305A · Blairstown, NJDelays by both pilots in releasing the glider tow line after the glider pilot allowed the glider to maneuver excessively above the tow aircraft. The weather conditions were factors.NTSB DEN89LA069Accident · No injuriesLimited investigationFinal reportCessna P210N · Durango, COFailure of the pilot to maintain runway alignment during takeoff. That the pilot attempted flight into known adverse conditions from an airport that was not approved for IMC operations is considered to be a contributing factor.NTSB SEA89FA040Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Carson City, NVLoss of power on the left engine due to a foreign object which obstructed the fuel flow, and the pilot's failure to maintain airspeed above VMC during his attempted return to the airfield. Contributing to the accident was the lack of recent flight time by the…NTSB MIA89LA074Accident · Minor injuriesLimited investigationFinal reportBeech G-35 · Panacea, FLPilots loss of control when entering the fog bank during the takeoff, due to spatial disorientation.NTSB LAX89FA095Accident · 1 fatalField investigationFinal reportMooney M20F · Truckee, CAThe pilot's decision to fly with a known deficiency of the aircraft, the worn fuel injector with an interior leak, which resulted in loss of engine power, and the pilot's failure to maintain adequate airspeed, which resulted in a stall.NTSB LAX89DUJ04Accident · 2 fatalFinal reportLehman/Jerrell Vans RV-4 · Tucson, AZPoor judgement by the pilot in attempting and then improperly performing an aerobatic maneuver after takeoff, resulting in a stall/spin to the ground.NTSB ATL89FA081Accident · 2 fatalField investigationFinal reportCessna 172 · Hartsville, TNThe pilot allowing the aircraft to lift-off prematurly at a slow airspeed and his failure to maintain directional control before inadvertently entering a stall. Contributing to the accident was the pilot's experience level and lack of qualifications.