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 LAX90DVD03Accident · No injuriesFinal reportTexas Helicopter M47A Wasp · Stockton, CAThe pilot misjudged the altitude during the flare/touchdown phase of the autorotation. Factors relating to this accident are failure of the right magneto.NTSB FTW90DPG12Accident · No injuriesFinal reportAir Tractor AT-401 · Jacksonville, ARA loss of engine power due to unknown causes. A factor was the unsuitable terrain.NTSB CHI90MA244Accident · 5 fatalMajor investigationFinal reportBell 206B · Elkhorn, WIImproper planning/decision by the pilot, and his failure to attain adequate altitude before flying over rising terrain at night. Factors related to the accident were: darkness, fog, haze, rising terrain, and the lack of visual cues that were available to the…NTSB ANC90LA156Accident · No injuriesLimited investigationFinal reportCessna 180-A · Lime Village, AKThe pilot-in-command's failure to understand the performance data during takeoff. Contributing to the accident was the unsuitable terrain not being identified by the pilot-in-command.NTSB SEA90LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA24-250 · Lagrande, ORThe pilot did not allow the airplane to attain an adequate airspeed prior to the retraction of flaps and landing gear.NTSB FTW90LA166Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Denver City, TXThe pilot's improper leaning of the fuel mixture.NTSB DEN90LA178Accident · No injuriesLimited investigationFinal reportCessna 150J · League City, TXGround collision with an object during the landing roll during a forced landing following a complete power loss. The reason for the power loss is undetermined.NTSB FTW90IA169Incident · No injuriesIncident investigationFinal reportEmbraer EMB-120 · College Station, TXPropeller and engine (powerplant) overspeed.NTSB DEN90LA175Accident · Serious injuriesLimited investigationFinal reportSchleicher ASW-19 · Alamogordo, NMThe pilot's failure to maintain control of the glider, which resulted in the pilot induced oscillations.NTSB DEN90LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28R201T · Longmont, COLoss of engine power due to fuel starvation for undetermined reasons resulting in a forced landing while the landing gear was still in transit.NTSB NYC90LA200Accident · No injuriesLimited investigationFinal reportEnstrom F-28A · Ravenna, OHA power loss, due to contamination from deteriorating fuel tank sealant, and the pilot's failure to notice the contamination during preflight.NTSB MIA90LA173Accident · No injuriesLimited investigationFinal reportPiper PA-32RT-300 · Hattiesburg, MSFailure of the pilot in command to attain adequate airspeed prior to liftoff during an attempted takeoff. The pilot then lost control of the airplane in flight. The pilot also delayed in his decision to abort the takeoff.NTSB LAX90LA302Accident · No injuriesLimited investigationFinal reportPiper PA38 · Chandler, AZThe student pilot's loss of control during takeoff. His inexperience in the aircraft and improper use of the flight controls were factors in the accident.NTSB FTW90MA161Accident · 3 fatalMajor investigationFinal reportGrumman G-159 · Houston, TXPartial failure of the left engine fuel pump, which resulted in a partial loss of power in the left engine, but not enough of a power loss to trigger and/or complete the autofeathering operation of the left propeller, thus allowing insufficient time for the…NTSB DEN90LA173Accident · No injuriesLimited investigationFinal reportCessna T-210-L · Edgewood, NMEngine failure due to a broken connecting rod. A factor was the rough uneven terrain available for the forced landing.NTSB DEN90DTE06Accident · Serious injuriesFinal reportCessna 188A · Holyoke, COA stall mush which occurred when the pilot retracted the flaps prematurely following takeoff, causing the aircraft to settle into the ground.NTSB ANC90LA151Accident · Minor injuriesLimited investigationFinal reportArtic S1B2 · Talkeetna, AKThe pilot-in-command's failure to maintain air speed on takeoff.NTSB CHI90FA236Accident · 7 fatalField investigationFinal reportPiper PA-32R-300 · Watertown, WIInitiation of VFR flight into adverse weather and instrument meteorologial conditions. Factors which contributed to the accident were the adverse weather conditions and the pilot's self-induced pressure to maintain currency.NTSB ANC90LA147Accident · No injuriesLimited investigationFinal reportAerospatiale AS-350-B · Juneau, AKFailure of the free turbine intermediate pinion driven gear and subsequent disintegration of the free turbine assembly.NTSB CHI90LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Lees Summit, MOCheck list not followed, fuel system not understood, and fuel boost pump selector improperly used, by the PIC.NTSB FTW90DPG08Accident · Serious injuriesFinal reportAir Tractor AT-301 · Corning, ARBlockage of the carburetor Air intake by a collapsed Air induction hose due to improper maintenance by an unknown party.NTSB CHI90DEC04Accident · Serious injuriesFinal reportBell 47 D-1 · Stockbridge, MIThe restricted visual lookout which resulted from the canopy fogging up.NTSB LAX90LA286Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Vacaville, CAFailure of the pilot to maintain adequate altitude resulting in an inflight encounter with an unfavorable wind at a low altitude in a hilly terrain.NTSB SEA90LA162Accident · 1 fatalLimited investigationFinal reportVaden SA102 Cavalier · Tumwater, WAThe pilot's failure to maintain airspeed during takeoff following an engine loss of power. The reason for the loss of power was not determined.NTSB SEA90IA161Incident · No injuriesIncident investigationFinal reportBoeing 727-224 · Belgrade, MTThe malfunction of the starter control valve.NTSB MIA90LA169Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Greenville, MSThe partial loss of engine power for an unknown reason.NTSB MIA90FA168Accident · 2 fatalField investigationFinal reportErco 415-C · Huntersville, NCFailure of the pilot in command to maintain airspeed.NTSB MIA90LA167Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Fajardo, PRFailure of the pilot to maintain vso during the takeoff climb, resulting in the loss of control.NTSB ATL90FA157Accident · 1 fatalField investigationFinal reportBeech E18S · Greenwood, SCThe pilot's improper emergency procedure by shutting down the wrong engine, which resulted in a forced landing. Factors related to the accident were: failure of the number three intake valve in the right engine due to fatigue, and trees in the emergency…NTSB ANC90LA140Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Fareweel, AKThe pilot's decision to takeoff downwind.NTSB CHI90LA218Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Brighton, MIA loss of engine power due to inadequate maintenance and inspection.NTSB LAX90DVG14Accident · Minor injuriesFinal reportDon G. Kaye RV-3 · Willows, CAThe pilots failure to maintain directional control on the runway after experiencing a loss of engine power.NTSB LAX90DUJ07Accident · Minor injuriesFinal reportWarkentin KR-2 · Page, AZThe pilot's inadvertent deactivation of the fuel selector when he actuated the foot operated main landing gear.NTSB CHI90LA223Accident · No injuriesLimited investigationFinal reportStearman E-75 · Mt. Grove, MOThe pilot's inadequate maintenance and servicing of the aircraft. A factor was water contamination in fuel tank.NTSB LAX90LA274Accident · No injuriesLimited investigationFinal reportCessna 340A · Stockton, CAThe pilots failure to properly position the fuel selector prior to flight, and the failure of the check pilot to adequately supervise the conduct of the flight.NTSB FTW90DPJ10Accident · No injuriesFinal reportHomebuilt Midget Mustang M1 · Bristow, OKFuel starvation induced power loss, a compromised fuel vent system, and improper installation of the plumbing in the fuel vent system.NTSB FTW90DPG07Accident · No injuriesFinal reportSchweizer G-164B · Sherrill, ARPremature lift off and subsequent stall.NTSB CHI90DEV08Accident · Minor injuriesFinal reportHilvety Cwii · Moweaqua, ILThe pilot's failure to maintain flying speed and stalling the airplane while attempting to reverse course for a forced landing. Contributing to the accident was the pilot's failure to properly reinstall spark plug cables during servicing conducted prior to…NTSB ANC90LA131Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Falls Creek, AKPilot-in-command's failure to maintain aircraft control.NTSB NYC90LA182Accident · No injuriesLimited investigationFinal reportBeech 58P · Chicopee, MADouble power loss due to improper fueling procedures. Factors relating to the accident were: improper pre-flight actions by the pilot and wrong fuel.NTSB BFO90FA067Accident · No injuriesField investigationFinal reportCessna 150K · Clinton, MDImproper planning/decision by the instructor pilot (CFI), which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB SEA90FA149Accident · 1 fatalField investigationFinal reportPiper PA-22-150 · Leavenworth, WAThe pilot's misjudgement in preflight planning when departing toward rising terrain. Contributing factors in this accident were his decision to attempt a climb-out with full flaps extended, and the minimal performance data available to him upon which he could…NTSB ANC90LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Gulkana, AKThe pilot-in-command's failure to maintain flying speed during the go-around.NTSB NYC90LA175Accident · No injuriesLimited investigationFinal reportCessna 172 · Edinburg, NYThe pilot did not maintain flying speed, the airplane stalled and descended into trees, at the departure end of the runway.NTSB MIA90LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-30 · Delray Beach, FLThe loss of directional control during the initial climb following the reported loss of power from the left engine for undetermined reasons.NTSB ANC90LA125Accident · No injuriesLimited investigationFinal reportDe Havilland DHC-2 · King Salmon, AKThe pilot-in-command's failure to maintain flying speed during climbout.NTSB NYC90DHA02Accident · 2 fatalFinal reportSnyder MA-5 Charger · Hamburg, PAFailure of the pilot to maintain adequate airspeed, while maneuvering, which resulted in an inadvertent stall/spin. The pilot's abrupt maneuver was a related factor.NTSB FTW90DPG05Accident · No injuriesFinal reportWSK PZL Mielec M18A · Hunter, ARThe pilot's continued operation with a known malfunctioning engine.NTSB NYC90FA171Accident · 1 fatalField investigationFinal reportLake LA-4-200 · Gt. Barrington, MAThe pilot in command's failure to properly maintain the engine, the inadequate annual maintenance inspection, low compression, and improper magneto timing. A factor was the resultant deteriorated climb performance.NTSB MIA90IA159Incident · No injuriesIncident investigationFinal reportde Havilland DHC-8-100 · Panama City, FLFailure of seal in the hydraulic actuator for the right outboard wing spoiler panel for unknown reasons.