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 LAX07CA086Accident · Serious injuriesData collectionFinal reportSchweizer SGS 2-3C · Jean, NVthe tow hook jamming and failing to release from the glider.NTSB SEA07LA062Accident · No injuriesLimited investigationFinal reportCessna 172RG · Daytona Beach, FLThe fracture and failure of the right landing gear actuator, which resulted in a gear collapse during the landing roll.NTSB SEA07FA061Accident · 1 fatalField investigationFinal reportCessna T210R · Rexburg, IDThe loss of engine power due to the contamination of the fuel manifold valve, and the pilot's continued operation of the airplane with known maintenance discrepancies.NTSB SEA07CA057Accident · No injuriesData collectionFinal reportPiper PA-38-112 · Ontario, ORThe pilot's failure to obtain and maintain an airspeed above Vs after lifting off of a remote gravel airstrip. Factors include the pilot's failure to correctly understand the procedure to use for a soft-field takeoff.NTSB MIA07CA044Accident · Serious injuriesData collectionFinal reportAirborne Windsports Classic · Sebring, FLThe pilot's delay on the runway prior to takeoff that resulted in an encounter with wake turbulence from a landing jet that had to perform a go-around.NTSB MIA07LA043Accident · No injuriesLimited investigationFinal reportRyan Navion · Marco Island, FLA reported loss of engine power shortly after takeoff for undetermined reasons.NTSB CHI07LA070Accident · Minor injuriesLimited investigationFinal reportReisinger Sonerai II L · Alma, MIThe loss of engine power during takeoff-initial climb for an undetermined reason. A factor in the accident was the lack of suitable terrain for a forced landing.NTSB NYC07CA059Accident · No injuriesData collectionFinal reportCessna 182E · Ashland, VAThe pilot's failure to properly secure the seat locking pin.NTSB MIA07CA040Accident · Serious injuriesData collectionFinal reportJim Garrison N11 · Titusville, FLThe failure of the pilot to abort the takeoff after becoming airborne during taxi testing, and the failure of the pilot to maintain airspeed after becoming airborne resulting in an inadvertent stall, uncontrolled descent, and in-flight collision with a tree.NTSB LAX07MA069Accident · 2 fatalMajor investigationFinal reportCessna 525 · Van Nuys, CAThe pilot's failure to maintain an adequate airspeed during the initial climb resulting in an inadvertent stall/spin. Contributing to the accident were the second pilots inadequate preflight, failure to properly secure the front baggage door, and the front…NTSB NYC07FA055Accident · 1 fatalField investigationFinal reportPiper PA-60-601P · Jamestown, NYThe pilot's incorrect selection of the right engine fuel selector position, which resulted in fuel starvation of the right engine, a loss of the right engine's power, and a loss of control during initial climb. Contributing to the accident were the pilot's…NTSB MIA07LA041Accident · Serious injuriesLimited investigationFinal reportSchweizer SGS 2-33 · Immokalee, FLThe failure of the glider towing "weak link," for undetermined reasons, at an inadequate altitude to effect a normal landing, resulting in a hard landing.NTSB SEA07LA038Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Blaine, WAThe loss of engine power for undetermined reasons. Factors were the unsuitable rough/uneven terrain.NTSB SEA07LA037Accident · Minor injuriesLimited investigationFinal reportCavalier F51D Mustang · Rexburg, IDThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for a forced landing.NTSB MIA07LA032Accident · Minor injuriesLimited investigationFinal reportClopton Aero Aerocomp Compair 7SL · Merritt Island, FLThe airplane manufacturer's inadequate maintenance prior to final aircraft delivery, which resulted in fuel filter blockage and engine fuel starvation.NTSB NYC07FA047Accident · 1 fatalField investigationFinal reportCessna 310Q · Montgomery, NYImproper maintenance performed on the airplane by maintenance personnel, and the failure of the mechanic with an inspection authorization (IA) to verify the maintenance work performed, which resulted in a reverse elevator trim system, and subsequent loss of…NTSB CHI07CA075Accident · No injuriesData collectionFinal reportBombardier BD-100-1A10 · Waukegan, ILThe bird strike during initial climb after takeoff from the departure airport.NTSB LAX07LA055Accident · Serious injuriesLimited investigationFinal reportHigher Class Super Hornet · Chandler, AZA loss of aircraft control for undetermined reasons.NTSB DFW07CA035Accident · No injuriesData collectionFinal reportPiper J3C-65 · Humnoke, ARThe loss of engine power during initial takeoff climb for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.NTSB ATL07LA021Accident · Serious injuriesLimited investigationFinal reportTennyson Howard Baslee DR-1 · Macon, GAThe pilot/owner's improper design change which resulted in a blocked carburetor inlet and a loss of engine power.NTSB DFW07CA031Accident · No injuriesData collectionFinal reportCessna 210 · Baytown, TXThe failure of the main landing gear to fully extend for an undetermined reason during takeoff-initial climb, which resulted in a gear-up landing.NTSB LAX07FA035Accident · 3 fatalField investigationFinal reportCessna 421B · Big Bear Lake, CAFailure of the turbine wheel shaft in the left turbocharger during the takeoff initial climb for undetermined reasons, and the pilot's failure to attain and maintain safe single engine airspeed that led to a loss of control.NTSB LAX07LA032Accident · 2 fatalLimited investigationFinal reportKolb MK III · Paulden, AZfailure of the pilot to maintain an adequate airspeed that led to a stall/spin.NTSB NYC07LA027Accident · 1 fatalLimited investigationFinal reportPiper PA-32R-300 · Williamsburg, VAThe pilot's improper decision to depart into adverse weather conditions. Contributing was the gusty wind conditions.NTSB LAX07LA031Accident · No injuriesLimited investigationFinal reportRyan Navion B · Riverside, CAA leak in the fuel selector valve and gascolator that resulted in fuel starvation on takeoff due to air leakage into the fuel system. A contributing factor in the accident was the inadequate annual inspection performed by other maintenance personnel.NTSB LAX07CA028Accident · Minor injuriesData collectionFinal reportStrategie Ballloon Amazon · Page, AZThe pilot's failure to identify grass clippings in the balloon envelope during a preflight inspection, which resulted in the balloon catching fire in flight.NTSB NYC07LA021Accident · No injuriesLimited investigationFinal reportCessna 150F · McHenry, MDThe pilot's inadequate preflight inspection, which resulted in fuel exhaustion and a loss of engine power during takeoff-initial climb.NTSB DFW07LA017Accident · No injuriesLimited investigationFinal reportMooney M20E · Nacogdoches, TXThe loss of engine power for undetermined reasons.NTSB LAX07LA023Accident · 1 fatalLimited investigationFinal reportMoyes Dragonfly · Brentwood, CAthe pilot's failure to obtain and maintain an adequate airspeed during the initial climb resulting in a stall and uncontrolled descent into terrain.NTSB LAX07LA022Accident · Serious injuriesLimited investigationFinal reportFish Vans RV-6 · Turlock, CAa partial loss of engine power due to the broken piston rings in the no. 4 cylinder. Also causal was the pilot's failure to maintain adequate airspeed while maneuvering for a forced landing, which resulted in a stall/mush.NTSB DFW07CA014Accident · Minor injuriesData collectionFinal reportChampion 7ECA · Ethel, ARThe pilot's failure to maintain clearance with the trees and terrain. Contributing factors were the prevailing fog and the dark night conditions.NTSB LAX07LA020Accident · Serious injuriesLimited investigationFinal reportAero Commander 112 · Chino, CAA loss of engine power during the initial climb after takeoff due to blocked fuel vent lines that resulted in fuel starvation. Contributing to the accident was an inadequate preflight inspection by the pilot-in-command (CFI).NTSB SEA07LA009Accident · Serious injuriesLimited investigationFinal reportHelio H-295 · Lake Isabel, WAThe pilot's failure to maintain airspeed while maneuvering for a precautionary landing following a partial loss of engine power, which resulted in an inadvertent stall/mush and subsequent hard landing. A contributing factor was the partial loss of engine…NTSB SEA07CA015Accident · No injuriesData collectionFinal reportCessna 210E · Friday Harbor, WAAn in-flight collision with a bird during takeoff.NTSB DFW07LA010Accident · No injuriesLimited investigationFinal reportTaylor Zodiac 601 · San Antonio, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.NTSB ATL07LA012Accident · Minor injuriesLimited investigationFinal reportCessna A188B · New Bern, NCLoss of engine power for undetermined reasons and the pilot's continued operation of the airplane with known deficiencies with the engine, which resulted in a forced landing and in-flight collision with the ground.NTSB ATL07CA011Accident · No injuriesData collectionFinal reportAir Tractor AT-802A · Linden, ALThe pilot's attempt to takeoff downwind resulting in the airplane not clearing trees at the end of the runway.NTSB ATL07CA006Accident · No injuriesData collectionFinal reportMcCullough J-2 · Indian Trail, NCThe pilot's inadequate compensation for gusting wind conditions and his improper landing flare during an emergency landing after takeoff resulting in a hard landing.NTSB ATL07CA007Accident · No injuriesData collectionFinal reportCessna 188B · Belhaven, NCThe pilot's failure to compensate for wind conditions and maintain adequate airspeed, which resulted in an inadvertent stall and subsequent in-flight collision with terrain.NTSB ANC07LA001Accident · Serious injuriesLimited investigationFinal reportPiper PA-32-260 · Port Alsworth, AKThe pilot's inadequate compensation for wind conditions, which resulted in a loss of control while maneuvering, and an in-flight collision with tree covered terrain. Factors associated with the accident are the pilot's inadequate evaluation of weather…NTSB LAX07LA005Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Upland, CADisconnection of the throttle control linkage due to improper maintenance, which resulted in a loss of engine power during initial climb.NTSB LAX07LA003Accident · 2 fatalLimited investigationFinal reportUlfeldt Kitfox IV-1200 · Gridley, CAThe pilot's failure to maintain an adequate airspeed while attempting a return to runway maneuver that led to a stall spin. The reason for the power loss was not ascertained.NTSB DFW07CA001Accident · Serious injuriesData collectionFinal reportChampion Citabria · Slidell, TXThe pilot's failure to maintain clearance from a parked vehicle.NTSB ATL07FA002Accident · 4 fatalField investigationFinal reportCessna 177 · Stockbridge, GAThe pilot's attempted takeoff over the allowable takeoff gross weight of the airplane and his failure to maintain airspeed during climb after takeoff.NTSB SEA07LA001Accident · Minor injuriesLimited investigationFinal reportOneil Oneil Glassair II-S · Richland, WALoss of partial engine power for undetermined reasons during the initial climb after takeoff. Trees were a factor during the landing roll.NTSB SEA06LA188Accident · Minor injuriesLimited investigationFinal reportErcoupe 415-C · Trenton, FLA partial loss of engine power just after takeoff due to water contamination of the auto fuel added to the aircraft fuel system just prior to the flight. Factors include the pilot's inadequate preflight, no suitable landing area near the departure end of the…NTSB ATL06FA129Accident · 3 fatalField investigationFinal reportBeech F-33A · Alabaster, ALThe pilot's failure to maintain airspeed while maneuvering toward an emergency landing area following the total loss of engine power shortly after takeoff resulting in an inadvertent stall, uncontrolled descent, and collision with the ground, and a fence. A…NTSB LAX06LA298Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Auburn, CAthe fatigue failure of the elevator's control rod due to inadequate lubrication. Contributing factors were the inadequate maintenance and the owner-pilot's failure to comply with an airworthiness directive.NTSB NYC06LA224Accident · Serious injuriesLimited investigationFinal reportGarlick OH-58A · East Bridgewate, MAThe completion center's installation of the incorrect (shorter) release cable, and the ground crewmember's improper movement under the flight path during a bin transfer.NTSB DEN06LA126Accident · Serious injuriesLimited investigationFinal reportBeech 77 · Live Oak, FLa loss of engine power for reasons undetermined, and an inadvertent stall while maneuvering.