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 CHI91DEC01Accident · 1 fatalFinal reportMocock Avid Amphibian · Milford, MIThe pilot's failure to maintain adequate airspeed during takeoff which resulted in a stall. A factor related to the accident were the gusty wind conditions.NTSB ATL91FA039Accident · 1 fatalField investigationFinal reportBeech 35 · Arden, NCFor undetermined reasons, the engine lost power.NTSB ATL91LA038Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Bolivar, TNThe interruption of fuel to the left engine due to contamination of the left fuel tank, resulting in engine stoppage.NTSB FTW91FA029Accident · Serious injuriesField investigationFinal reportBeech F-90 · Nacogdoches, TXThe loss of thrust due to the propeller's feathering on liftoff as a result of improper adjustments made during an engine change. A factor was the lack of suitable terrain to which the pilot could execute a forced landing.NTSB CHI91LA064Accident · Minor injuriesLimited investigationFinal reportCessna 320E · Elkhart, INA fractured landing gear retraction assembly component and the pilot's improper emergency procedure.NTSB LAX91LA069Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Hilo, HIThe failure of the pilot to maintain an adequate airspeed while maneuvering. A factor in the accident was the pilot's decision to attempt steep and abrupt maneuvers during the takeoff initial climb phase.NTSB LAX91FA066Accident · 1 fatalField investigationFinal reportCessna T210M · Sacramento, CAThe failure of the pilot-in-command to maintain control of the airplane while flying in instrument meteorological conditions and spatial disorientation of the pilot-in-command. Contributing to the accident was diversion of the pilot's attention to…NTSB FTW91FA027Accident · 6 fatalField investigationFinal reportCessna 421B · Muskogee, OKThe pilot's failure to maintain control of the aircraft, due to spatial disorientation. Factors related to the accident were: darkness, adverse weather conditions, and the pilot's physical impairment from the chronic sinus infection.NTSB CHI91LA060Accident · No injuriesLimited investigationFinal reportCessna 150D · Ft. Atkinson, WIThe pilot's failure to refuel. A factor was unsuitable terrain for landing.NTSB MIA91IA061Incident · No injuriesIncident investigationFinal reportCessna 210M · Lutz, FLFuel line chafing, and in-flight fire caused by shorting of the electrical system which resulted in a forced landing with the landing gear not extended.NTSB DEN91LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Deming, NMPilot failure to maintain airspeed during takeoff climb resulting in a stall and subsequent loss of control of the aircraft. A factor was: the failure of the CFI to adequately supervise the student pilot.NTSB NYC91LA056Accident · Minor injuriesLimited investigationFinal reportCessna 182P · Princeton, NJPilot factor in that the pilot failed to use carburetor heat resulting in engine power loss due to carburetor ice. Factors were unsuitable terrain and obstructions.NTSB SEA91FA038Accident · 2 fatalField investigationFinal reportCessna 182B · Estacada, ORA power loss due to carburetor ice, and missing muffler cones as a result of inadequate maintenance inspection. In addition, the pilot failed to maintain adequate airspeed during the forced landing which resulted in a stall.NTSB LAX91LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-150 · Sierra Vista, AZLoss of engine power due to carburetor ice from improper use of the carburetor heat control.NTSB FTW91FA025Accident · 1 fatalField investigationFinal reportPiper PA28-181 · Olla, LAThe collapsed carburetor float and restricted movement of the fuel metering needle. Factors were the darknight, the unsuitable terrain, and the operator's maintenance personnel failure to inspect (repair) the engine.NTSB DEN91LA025Accident · No injuriesLimited investigationFinal reportGrumman AA1B · Roswell, NMLow cylinder compression and fouled spark plug.NTSB CHI91LA057Accident · No injuriesLimited investigationFinal reportCessna 172M · Austin, MNThe pilot-in-command (student)'s failure to properly evaluate and compensate for gusty wind condiitons and to maintain directional of the aircraft during initial climb. Contributing was the student pilot's lack of total experience and wind gusts.NTSB MIA91LA042Accident · Serious injuriesLimited investigationFinal reportCessna 172G · Jacksonville, FLFailure to maintain aircraft control after intentional flight into known adverse weather conditions.NTSB LAX91FA052Accident · Minor injuriesField investigationFinal reportde Havilland DHC-6-100 · Perris Valley, CAA loss of power on the left engine due to a fatigue failure of a compressor turbine blade leading to further compressor blade damage; a worn power turbine governor throttle cam assembly which led to loss of power on the right engine; and inadequate…NTSB FTW91LA022Accident · No injuriesLimited investigationFinal reportTaylorcraft DC-65 · Boerne, TXThe pilot's inability to climb over obstacles due to encountering a downdraft which exceeded the climb capability of the airplane. Factors in the accident were the gusty wind conditions and the downdraft.NTSB FTW91LA021Accident · Serious injuriesLimited investigationFinal reportCessna 150E · Amarillo, TXAn underpowered takeoff attempt due to incorrectly set magnetos. Contributing was the transmission lines.NTSB LAX91LA050Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Big Bear City, CAThe pilot's failure to maintain adequate airspeed during takeoff and his incorrect use of full flaps. Factors related to the high density altitude condition and to the pilot's abrupt airplane handling techniques.NTSB NYC91LA045Accident · No injuriesLimited investigationFinal reportCessna 150J · Columbus, OHThe pilot's improper recovery from a bounced landing. Factors in the accident were: a downwind landing, and loss of engine power for undetermined reasons.NTSB CHI91LA039Accident · No injuriesLimited investigationFinal reportCessna 150 · Niota, ILFuel consumption calculations misjudged by the PIC. Contributing factors were a tailwind landing and no suitable terrain.NTSB NYC91LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Marshfield, MAThe partial loss of engine power for undetermined reasons. Contributing to the accident was the unsuitable terrain in which the emergency landing was made.NTSB MIA91LA031Accident · No injuriesLimited investigationFinal reportCessna 152 · Opa Locka, FLThe pilot's failure to maintain a positive rate of climb while maneuvering to avoid a flock of birds, resulting in an in flight collision with trees. Factor(s) included: attention diverted.NTSB DEN91LA023Accident · Serious injuriesLimited investigationFinal reportCessna 150H · Clifton, TXInadvertent stall. Factors were: tailwind, wrong runway selected, and failure to raise flaps.NTSB ANC91FA014Accident · 1 fatalField investigationFinal reportCessna 170 · 40 W Of Clear, AKThe non-instrument rated pilot-in-command's loss of control while attempting to operate under visual flight rule while in instrument meteorological conditions. Contributing to the accident was the whiteout condition created by the vast expanse of white lake…NTSB NYC91LA036Accident · 3 fatalLimited investigationFinal reportPiper PA-28-140 · Cheswold, DEA loss of control in flight, by a non-instrument rated pilot in instrument meteorological conditions. Factors related to the accident were: his decision to fly after he received weather briefings which inlcuded 'VFR flight not recommended'.NTSB DEN91LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Sherman, TXA pilot induced inadvertent stall.NTSB SEA91LA018Accident · Serious injuriesLimited investigationFinal reportChampion 7ECA · Bremerton, WAThe pilot did not maintain altitude.NTSB NYC91DNE01Accident · No injuriesFinal reportCraig A. Gordon Teenie TWO · Oxford, CTThe failure of the pilot to maintain airspeed which resulted in an inadvertent stall and hard landing. Factors related to the accident were: the power loss and improper maintenance on the engine.NTSB SEA91LA016Accident · Serious injuriesLimited investigationFinal reportCessna 172A · Brigham City, UTThe pilot did not maintain a proper climb rate.NTSB MIA91LA026Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Pierce, FLImproper preflight decision of the instructor pilot to allow the student to takeoff from the soft grass runway and his failure to abort the takeoff.NTSB LAX91LA025Accident · Serious injuriesLimited investigationFinal reportCessna 182Q · Pacoima, CAAn engine failure for undetermined reasons.NTSB BFO91DID01Accident · 2 fatalFinal reportAeronca Champion 7BCM · Suffolk, VAA loss of engine power due to low cylinder compression. The low compression was a result of exhaust valve leakage and inadequate maintenance and inspection. In addition, the pilot failed to maintain adequate airspeed which resulted in the airplane stalling.NTSB MIA91LA021Accident · No injuriesLimited investigationFinal reportCessna 170 · Patillas, PRThe accident was failure of the non certificated pilot to lower the flaps to the correct position for takeoff and failure to abort the takeoff due to insufficient acceleration.NTSB NYC91DNC02Accident · Serious injuriesFinal reportMarier Early Bird Jenny · Concord, NHThe failure of the pilot to maintain adequate airspeed, which resulted in an inadvertent stall spin. A factor related to the accident was: the pilot's lack of experience in the make and model of aircraft.NTSB ATL91IA014Incident · No injuriesIncident investigationFinal reportBell 412 · Knoxville, TNThe pilot's failure to see and avoid the wires prior to the collision. Factors in the incident were the failure of the ground personnel to adequately inspect the landing zone, the presence of high intensity lights at the lz, and the dark lighting conditions.NTSB FTW91DPD01Accident · No injuriesFinal reportRans S-9 · Iowa Park, TXThe total loss of engine power due to fuel starvation as the result of a blocked fuel filter in the fuel system.NTSB CHI91FA022Accident · 2 fatalField investigationFinal reportCessna 195 · Flint, MIThe pilot-in-command's inadequate preflight inspection of the fuel tank system. Factor(s) were: water contamination in the fuel.NTSB BFO91FA008Accident · Serious injuriesField investigationFinal reportPiper PA-28-181 · Elkton, MDLoss of engine power for an undetermined reason, and the pilot's failure to maintain adequate airspeed, which resulted in a stall and an inflight collision with the terrain.NTSB BFO91LA007Accident · No injuriesLimited investigationFinal reportCessna 185 · Ridgely, MDThe loss of engine power for undetermined reasons.NTSB ATL91LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Summerville, SCAn eroded exhaust stack which allowed hot gases to impinge upon the firewall, and ignite cabin insulation.NTSB LAX91LA017Accident · Minor injuriesLimited investigationFinal reportBeech F33A · Mobile, AZA fuel flow interruption due to a fuel system seal fragment becoming lodged in the fuel control unit and the manufacturer's inadequate quality control procedures.NTSB MIA91FA014Accident · 1 fatalField investigationFinal reportDaniel S. Taylor Sonerai II LS · Prattville, ALThe pilot's failure to maintain airspeed. Factors were undetermined loss of engine power and lack of experience in type.NTSB LAX91DUJ02Accident · No injuriesFinal reportJoe L. Harr SE-5A · Camp Verde, AZThe pilot's inadvertent shut-off of the fuel supply to the engine shortly after takeoff.NTSB BFO91LA004Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Amelia, VAThe pilot's improper in-flight planning/decision and his intere uphill runway and tailwind.NTSB LAX91DUM02Accident · Serious injuriesFinal reportAyres S2RT-T34 · El Centro, CACollision with a ground object after the pilot successfully made a night time emergency landing after experiencing an engine power interruption for undetermined reasons.NTSB LAX91DUJ01Accident · Serious injuriesFinal reportJoseph W. Hillbrand Sonerai IIL · Maricopa, AZAn engine failure due to improper fuel.