OpenAirDocs.org

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.

NTSB ATL00LA095Accident · 2 fatalLimited investigationFinal reportWilliam J. Knowles KNOWLES-THORP KT-18 · Opa-Locka, FLThe pilot's failure to maintain flying airspeed during initial climb, resulting in an inadvertent stall/spin.Sep 30, 2000 · N37BK · DestroyedNTSB SEA00LA190Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Miles City, MTA loss of engine power for undetermined reasons.Sep 27, 2000 · N4686R · Substantial damageNTSB ATL00LA096Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Deland, FLA partial loss of engine power during initial climb following takeoff, due to the restricted movement of the number two cylinder's exhaust valve.Sep 21, 2000 · N5530F · Substantial damageNTSB IAD00LA084Accident · No injuriesLimited investigationFinal reportCessna 150G · Conesus, NYthe pilot's inadequate preflight performance planning.Sep 19, 2000 · N8376J · Substantial damageNTSB FTW00LA264Accident · No injuriesLimited investigationFinal reportBeech H35 · Wagoner, OKThe loss of engine power during the takeoff initial climb, for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Sep 17, 2000 · N5448D · Substantial damageNTSB MIA00LA263Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Zephyrhills, FLthe intentional stall/mush by the pilot-in-command due to obstructions ahead resulting in a hard landing. Contributing to the accident was the partial loss of engine power due to fuel starvation caused by wear, fatigue, then overstress separation of the…Sep 16, 2000 · N7196L · Substantial damageNTSB LAX00LA336Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Phoenix, AZLoss of engine power for undetermined reasons. A factor was the lack of suitable terrain available for a straight ahead landing during the takeoff initial climb.Sep 15, 2000 · N381AS · Substantial damageNTSB NYC00LA262Accident · No injuriesLimited investigationFinal reportCessna 150L · Salem, OHA partial power loss for undetermined reasons.Sep 14, 2000 · N10825 · Substantial damageNTSB ANC00LA135Accident · No injuriesLimited investigationFinal reportChampion 7GCBC · Sparrevohn, AKThe pilot's inadequate compensation for wind conditions. Factors associated with the accident were variable winds, and a crosswind.Sep 14, 2000 · N9654S · Substantial damageNTSB SEA00LA176Accident · Minor injuriesLimited investigationFinal reportCessna 150H · Ontario, ORThe pilot-in-command/flight instructor's failure to adequately refuel the aircraft, resulting in fuel exhaustion, and his subsequent high flare in a forced landing attempt, resulting in a stall and touchdown/impact on the nose gear.Sep 13, 2000 · N22237 · Substantial damageNTSB LAX00LA350Accident · No injuriesLimited investigationFinal reportWorgull Hornet · Camp Verde, AZSeparation of the forward spark plug due to wear damage to the cylinder head threads. A factor in the accident was traffic on the highway and the pilot having to maneuver to avoid the traffic.Sep 11, 2000 · N707BD · Substantial damageNTSB DEN00FA169Accident · Serious injuriesField investigationFinal reportPiper PA-28-180 · Englewood, COthe pilot's failure to maintain aircraft control, which resulted in a collision with terrain. A contributing factor was the high-density altitude weather condition.Sep 11, 2000 · N2190R · DestroyedNTSB ANC00LA119Accident · Serious injuriesLimited investigationFinal reportPiper PA-18 · Sleetmute, AKThe loss of aircraft control precipitated by the pilot's inadvertent stall. Factors associated with the accident are the disengagement of the stabilizer trim system, which resulted in reduced aircraft control, an inadvertent stall by the pilot, and a large…Sep 11, 2000 · N9692P · Substantial damageNTSB FTW00LA255Accident · No injuriesLimited investigationFinal reportMooney M20 · Owasso, OKThe loss of engine power for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Sep 10, 2000 · N866B · Substantial damageNTSB CHI00LA294Accident · No injuriesLimited investigationFinal reportBeech B24 · Necedah, WIThe pilot did not properly flare the airplane during the aborted takeoff and he failed to maintain directional control of the airplane during the landing roll. Factors associated with the accident were the partial power loss for undetermined reasons and the…Sep 10, 2000 · N4342W · Substantial damageNTSB LAX00LA332Accident · No injuriesLimited investigationFinal reportCessna 120 · Sacramento, CAThe pilot's inadequate preflight planning and his improper use of carburetor heat that resulted in a loss of engine power due to carburetor icing following a delayed takeoff in conditions that were conducive to carburetor icing. A factor was the nonsuitable…Sep 9, 2000 · N76261 · Substantial damageNTSB NYC00LA261Accident · Minor injuriesLimited investigationFinal reportCarlson CA-8 · East Palestine, OHFuel starvation as a result of the pilot's inadequate pre-flight inspection. A factor in this accident was the inadequate marking of the fuel selector valve to clearly indicate a fully open position.Sep 8, 2000 · N47XY · Substantial damageNTSB ANC00LA117Accident · No injuriesLimited investigationFinal reportCessna 180 · Sterling, AKThe pilot's failure to attain clearance from trees during takeoff from a touch-and-go landing. A factor associated with the accident is the pilot's failure to attain a proper touchdown point.Sep 8, 2000 · N2347C · Substantial damageNTSB FTW00LA248Accident · No injuriesLimited investigationFinal reportCessna 150F · Guthrie, OKThe partial loss of engine power due to undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Sep 4, 2000 · N8783S · Substantial damageNTSB NYC00FA247Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Apple Creek, OHThe pilot's premature liftoff and failure to attain a proper climb rate. Factors related to the accident were the over-gross weight conditions, and the low cloud ceilings.Sep 2, 2000 · N2102X · DestroyedNTSB ANC00LA112Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe pilot's inadequate removal of frost from the airplane, and the inadvertent stall during takeoff. A factor was wind gusts.Sep 2, 2000 · N10572 · Substantial damageNTSB LAX00FA322Accident · 4 fatalField investigationFinal reportPiper PA-46-310P · So. Lake Tahoe, CAThe pilot's in-flight loss of control in the takeoff initial climb for undetermined reasons.Sep 1, 2000 · N88AM · DestroyedNTSB CHI00LA289Accident · No injuriesLimited investigationFinal reportCessna A188B · Nickerson, KSaltidude/clearance not obtained/maintained by the pilot. Factors to the accident were the hay bale, the inadequate preflight planning/preparation by the pilot, the high-density altitude, and the high weight of the aircraft at the time of the accident.Sep 1, 2000 · N9326R · Substantial damageNTSB CHI00FA276Accident · 2 fatalField investigationFinal reportBeech E-55 · Grafton, ILThe pilot not maintaining aircraft control and altitude/clearance from the river. Factors to the accident included the pilot not obtaining an air traffic control clearance prior to departure into instrument meteorological conditions, the pilot becoming…Aug 30, 2000 · N9047V · DestroyedNTSB LAX00TA318Accident · Minor injuriesFinal reportBell 206L-1 · Los Angeles, CAThe probable loss of the main rotor tip weight on the red blade for undetermined reasons resulting in main rotor vibration and oscillation. Sideward movement during the ensuing emergency landing resulted in a dynamic rollover.Aug 29, 2000 · N5758H · Substantial damageNTSB SEA00LA170Accident · No injuriesLimited investigationFinal reportHughes 369E · Coolin, IDThe turbine outlet temperature indicating system was out of calibration. Factors included improper maintenance calibration, which resulted in the over temperature of the turbine assembly.Aug 25, 2000 · N570CA · Substantial damageNTSB MIA00LA247Accident · No injuriesLimited investigationFinal reportCessna 182Q · Fayetteville, TNthe pilot's failure to maintain adequate airspeed during the takeoff/initial climb, which resulted in an inadvertent stall/mush and collision with the runway that resulted in substantial damage to the airplane.Aug 25, 2000 · N759CW · Substantial damageNTSB CHI00LA270Accident · Minor injuriesLimited investigationFinal reportRaven AS-55A · Lincoln, ILThe pilot failed to maintain clearance with the power lines. Factors associated with the accident were the pilot's attention was diverted and the power lines which the balloon contacted.Aug 25, 2000 · N1073R · Substantial damageNTSB MIA00LA244Accident · No injuriesLimited investigationFinal reportSiai-Marchetti F260B · Meridianville, ALthe pilot's inadequate preflight planning/preparation which resulted in fuel contamination going undetected, which resulted in a forced landing and substantial damage to the aircraft during the emergency landing.Aug 23, 2000 · N800RH · Substantial damageNTSB FTW00LA239Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Kaplan, LAthe failure of the supercharger during takeoff. A contributing factor was the lack of suitable terrain for the forced landing.Aug 21, 2000 · N6506K · Substantial damageNTSB NYC00LA233Accident · Serious injuriesLimited investigationFinal reportGrooms Titan Tornado · Libertytown, MDAn engine seizure due to improper reconditioning of piston/cylinder after a previous seizure. A factor was the unsuitable terrain, to which, the forced landing was made.Aug 20, 2000 · N61246 · Substantial damageNTSB DEN00LA155Accident · Serious injuriesLimited investigationFinal reportTrammell Avid Flyer · Trinidad, COthe failure of wing lift strut attachment rod for an unknown reason, which resulted in a loss of aircraft control during initial takeoff climb.Aug 20, 2000 · N7081M · Substantial damageNTSB NYC00LA234Accident · No injuriesLimited investigationFinal reportCessna 152 · Culpeper, VAThe partial loss of power due to an inadequate annual inspection, which resulted in the throttle linkage becoming disconnected from the throttle.Aug 19, 2000 · N67495 · Substantial damageNTSB CHI00LA260Accident · Minor injuriesLimited investigationFinal reportCessna 150M · Chapin, ILthe pilot's failure to refuel the aircraft prior to the flight and exhaustion of the fuel supply. A factor to the accident was the embankment.Aug 17, 2000 · N304JF · Substantial damageNTSB ANC00LA102Accident · Minor injuriesLimited investigationFinal reportPiper J-3 · Anchorage, AKThe loss of engine power due to water contamination of the fuel system, the airplane's lack of the required center fuel tank quick drain, and the pilot's inadequate preflight.Aug 17, 2000 · N88283 · Substantial damageNTSB NYC00FA229Accident · 2 fatalField investigationFinal reportCessna 182RG · Princeton, KYThe pilot's failure to clear trees, for undetermined reasons.Aug 16, 2000 · N3674C · DestroyedNTSB DEN00LA152Accident · No injuriesLimited investigationFinal reportRosenbarger Lancair IV · Artesia, NMFailure by the pilot in command to maintain control of the aircraft during initial climb following takeoff.Aug 15, 2000 · N494R · Substantial damageNTSB CHI00FA263Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Watertown, WIAircraft control not being maintained during initial climb resulting in a stall/mush. Factors to the accident were the pilot's inadequate preflight planning/preparation, the pilot operating over the airplane's certified maximum gross weight, and the pilot…Aug 15, 2000 · N8126V · DestroyedNTSB SEA00LA165Accident · Serious injuriesLimited investigationFinal reportLadd Nieuport 11 · White Pine, MTThe pilot's failure to maintain adequate airspeed during takeoff after becoming airborne. Contributing factors were his lack of overall recent flight experience and the stall.Aug 14, 2000 · UNREG · Substantial damageNTSB NYC00FA226Accident · 1 fatalField investigationFinal reportCessna 172 · Davis, WVThe pilot-in-command's inadequate weather evaluation, which resulted in a takeoff with a tailwind, and a subsequent inadvertent stall. Factors were a high gross weight, a high density altitude, and a tailwind.Aug 12, 2000 · N8874B · Substantial damageNTSB ATL00FA079Accident · 3 fatalField investigationFinal reportCessna 172H · Peachtree City, GAThe pilot's improper use of takeoff checklist procedures, and his failure to maintain flying speed, which resulted in a stall and subsequent collision with the ground. Factors: A factor was the landing flaps were not retracted.Aug 12, 2000 · N1749F · Substantial damageNTSB LAX00LA290Accident · No injuriesLimited investigationFinal reportCessna 150H · Corona, CAThe student pilot's inadequate preflight planning which included improper fuel consumption calculations that led to fuel exhaustion and loss of engine power during takeoff.Aug 9, 2000 · N7011S · Substantial damageNTSB MIA00LA234Accident · 1 fatalLimited investigationFinal reportEachon Time Warp Spitfire 9 · Lakeland, FLa loss of control which resulted in an inadvertent stall at too low an altitude to allow recovery. Factors in this accident were, the pilot/owner did not verify that the airplane was balanced before the flight, and he did not perform any weight or balance…Aug 8, 2000 · N355DE · DestroyedNTSB DCA00MA079Accident · Minor injuriesMajor investigationFinal reportDouglas DC-9-32 · Greensboro, NCA phase-to-phase arc in the left heat exchanger cooling fan relay, which ignited the surrounding wire insulation and other combustible materials within the electrical power center panel. Contributing to the left heat exchanger fan relay malfunction was the…Aug 8, 2000 · N838AT · Substantial damageNTSB FTW00LA225Accident · Minor injuriesLimited investigationFinal reportBrown/Morrison Rans S-12 · Bonham, TXThe pilot's failure to maintain control of the airplane while maneuvering to return to the airport. Factors were the gusty wind conditions and the pilot's lack of experience.Aug 7, 2000 · UNREG · Substantial damageNTSB NYC00LA217Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · E. Stroudsburg, PAThe pilot's decision to takeoff with only partial engine power available.Aug 6, 2000 · N5731U · Substantial damageNTSB CHI00LA240Accident · Minor injuriesLimited investigationFinal reportThompson Avid Mark IV · Springfield, MOthe pilot's inadequate preflight planning, his failure to abort the takeoff, and the inadequate airspeed. Factors included the tall runway grass, the quartering tailwind, and the trees.Aug 5, 2000 · N619T · DestroyedNTSB SEA00LA151Accident · Serious injuriesLimited investigationFinal reportKokenge Glastar · Butte, MTA loss of aircraft control for undetermined reasons.Aug 2, 2000 · N4350K · DestroyedNTSB LAX00FA283Accident · 2 fatalField investigationFinal reportMooney M20E · Jackpot, NVThe pilot inadvertently became lost/disoriented during initial climb and collided with terrain. A related factor was the dark night.Jul 30, 2000 · N5853Q · DestroyedNTSB FTW00LA219Accident · 1 fatalLimited investigationFinal reportLet L-23 Super Blankit · Waller, TXthe pilot's failure to maintain control of the glider while maneuvering. Contributory factors were the in-flight separation of the tow rope and the pilot's physical impairment from his use of diphenhyrdramine.Jul 29, 2000 · N105LW · Destroyed