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 SEA01LA153Accident · Serious injuriesLimited investigationFinal reportLet Blanik L-13 · Enumclaw, WAThe premature release of the towline and the pilot's improper selection of a landing area following the release. Factors include improper preflight planning.Aug 19, 2001 · N82AS · Substantial damageNTSB MIA01FA223Accident · 3 fatalField investigationFinal reportBeech A23 · Blairsville, GAThe failure of the pilot to maintain airspeed resulting in an inadvertent stall an subsequent in-flight collision with trees then the ground during the uncontrolled descent.Aug 19, 2001 · N8869M · DestroyedNTSB FTW01LA185Accident · Minor injuriesLimited investigationFinal reportBeech A-36TC · Fort Worth, TXthe partial loss of engine power for an undetermined reason and the pilot's decision to initiate the takeoff downwind.Aug 19, 2001 · N1852Z · Substantial damageNTSB LAX01LA282Accident · Minor injuriesLimited investigationFinal reportCessna 172-A · Groveland, CAa loss of engine power due to water contamination forced the pilot to land in an unsuitable area resulting in collision with a tree.Aug 18, 2001 · N7198T · Substantial damageNTSB MIA01LA218Accident · Serious injuriesLimited investigationFinal reportCessna 182R · Winder, GAA total loss of engine power due to fatigue failure of the number two piston immediately after takeoff, resulting in collision with trees and the terrain during an emergency descent.Aug 17, 2001 · N2405E · Substantial damageNTSB CHI01LA283Accident · No injuriesLimited investigationFinal reportCessna 177RG · Sikeston, MOThe loss of engine power during the initial climb due to fuel contamination, water. A factor relating to the accident was the trees.Aug 16, 2001 · N27JS · Substantial damageNTSB NYC01LA208Accident · Minor injuriesLimited investigationFinal reportPiper J3C-65 · Gasport, NYThe pilot's failure to obtain a proper climb airspeed which resulted in an inadvertent stall and subsequent impact with a hangar.Aug 11, 2001 · N6153H · Substantial damageNTSB CHI01LA271Accident · Minor injuriesLimited investigationFinal reportPiper PA-46-310P · Milwaukee, WIthe rich fuel mixture and the unsuitable landing area encountered by the pilot. Contributing factors were the high output of the fuel pump and the low altitude.Aug 10, 2001 · N9106V · Substantial damageNTSB DEN01LA142Accident · No injuriesLimited investigationFinal reportPiper PA-60-602P · Rock Springs, WYthe right main tire blowing out in flight, which resulted in a loss of directional control during landing.Aug 9, 2001 · N44JH · DestroyedNTSB MIA01LA210Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Fort Lauderdale, FLThe failure of the mechanic who installed the carburetor after overhaul to safety the throttle linkage at the carburetor per an Airworthiness Directive resulting in separation of the throttle linkage and subsequent partial loss of engine power. Contributing…Aug 7, 2001 · N78933 · Substantial damageNTSB CHI01LA264Accident · Minor injuriesLimited investigationFinal reportBeech 23 · West Bend, WIThe pilot not following the aircraft fuel management procedures. Factors were the fuel starvation, the low altitude, the manufacturers service instruction not complied with, and the tree.Aug 6, 2001 · N2367J · Substantial damageNTSB CHI01LA262Accident · No injuriesLimited investigationFinal reportGrice Avid Flyer · Belle Fourche, SDThe pilot failed to maintain aircraft control during the forced landing. A factor associated with the accident was the excessive adjustment that the pilot made to the propeller's pitch prior to the flight.Aug 6, 2001 · N312GR · Substantial damageNTSB LAX01FA270Accident · 1 fatalField investigationFinal reportBeech B36TC · Weaverville, CAthe pilot's selection of the wrong runway, which resulted in an attempted takeoff uphill in a prevailing tailwind toward rising terrain and high obstacles. Also causal was the pilot's loading of the airplane above maximum gross weight and his failure to…Aug 5, 2001 · N1109T · DestroyedNTSB CHI01LA258Accident · Serious injuriesLimited investigationFinal reportCessna A185F · Crane Lake, MNThe inadvertant control interference by the passenger's knee leading to the pilot's directional control of the floatplane not being possible.Aug 5, 2001 · N2904Q · Substantial damageNTSB DEN01LA138Accident · Serious injuriesLimited investigationFinal reportCessna 182H · Pueblo, COthe loss of engine power due to fuel starvation as a result of the pilot's improper fuel selector position. A factor was the lack of suitable terrain for the forced landing.Aug 4, 2001 · N8549S · Substantial damageNTSB MIA01LA204Accident · Minor injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Edison, GAPartial loss of engine power for undetermined reasons during takeoff resulting in the airplane descending, colliding with the ground, and nosing over.Jul 31, 2001 · N6816Q · Substantial damageNTSB FTW01LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Tulsa, OKthe partial loss of engine power for an undetermined reason. A factor was the lack of suitable terrain for the forced landing.Jul 31, 2001 · N525Z · Substantial damageNTSB SEA01FA145Accident · 6 fatalField investigationFinal reportPiper PA-32-260 · Puyallup, WAThe pilot's failure to maintain adequate airspeed during departure resulting in a stall. Trees were a factor in the accident.Jul 29, 2001 · N3479W · DestroyedNTSB NYC01LA188Accident · No injuriesLimited investigationFinal reportCessna 172P · Odenton, MDA loss of engine power for undetermined reasons.Jul 25, 2001 · N52266 · Substantial damageNTSB LAX01IA262Incident · No injuriesIncident investigationFinal reportMdhi 520N · Los Angeles, CAthe excitation of the first bending mode natural frequency of the aft tube assembly that is installed through the rotating NOTAR fan drive system. Contributing factors to the incident included the operator's maintenance practice of hand-sanding the pitch…Jul 25, 2001 · N953SD · Minor damageNTSB CHI01LA238Accident · No injuriesLimited investigationFinal reportHiller UH-12E · Hastings, NEAircraft control not being maintained by the pilot which resulted in the encountered settling with power flight condition during the initial climb. Factors to the accident were the reported variable winds during the takeoff and the corn crop.Jul 25, 2001 · N67067 · Substantial damageNTSB ANC01LA117Accident · No injuriesLimited investigationFinal reportCessna 207 · Kalskag, AKThe pilot's failure to maintain adequate clearance from an object during the initial climb after takeoff.Jul 25, 2001 · N9973M · Substantial damageNTSB FTW01LA168Accident · 1 fatalLimited investigationFinal reportSchnitz FIIC-2 Goshawk · Marion, TXthe loss of control on takeoff for undetermined reasons.Jul 23, 2001 · N393Y · DestroyedNTSB CHI01LA228Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Tracy, MNThe inadvertent stall during the initial takeoff. Factors relating to the accident were the student pilot's premature lift-off of the airplane during the initial takeoff, the instructor pilot's inadequate supervision, and the fences.Jul 23, 2001 · N23475 · DestroyedNTSB CHI01FA234Accident · 3 fatalField investigationFinal reportCessna 177 · Benton, ILThe pilot's failure to maintain adequate airspeed, resulting in a stall.Jul 22, 2001 · N235LA · DestroyedNTSB ATL01LA088Accident · Serious injuriesLimited investigationFinal reportW. E. Simmons Max Air Drifter ARV 582 · Collington, NCThe internal seizing of the engine assembly that resulted in a total loss of engine power during climb out.Jul 22, 2001 · N102WS · Substantial damageNTSB MIA01FA192Accident · 1 fatalField investigationFinal reportBeech BE-35-F35 · Bamberg, SCthe failure of the pilot to maintain airspeed, while attempting a forced landing following a loss of engine power for undetermined reasons, which resulted in an inadvertent stall/spin, and subsequent impact with the terrain. A factor in this accident was…Jul 21, 2001 · N5058S · DestroyedNTSB FTW01LA167Accident · No injuriesLimited investigationFinal reportCessna 152 · Springdale, ARthe instructor's failure to refuel the airplane, which resulted in fuel exhaustion.Jul 21, 2001 · N50SX · Substantial damageNTSB DEN01LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Calhan, COthe loss of engine power due to fuel contamination (water). A contributing factor was the lack of suitable terrain on which to perform a forced landing.Jul 21, 2001 · N6276W · Substantial damageNTSB CHI01FA233Accident · 2 fatalField investigationFinal reportPiper PA-32-260 · Chenoa, ILThe inadvertent stall the pilot encountered during his turn with an in-flight loss of engine power due to fuel starvation on initial climbout and the improper in-flight decision he made to continue the turn. Factors were the fuel starvation and the incorrect…Jul 21, 2001 · N27AP · Substantial damageNTSB LAX01LA251Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Carson City, NVThe pilot's failure to follow the approved procedures for the aircraft when he attempted to takeoff at high density altitude with the wing flaps fully extended.Jul 19, 2001 · N20466 · Substantial damageNTSB CHI01LA216Accident · No injuriesLimited investigationFinal reportStemme S10-VT · Antigo, WIThe cause of the loss of engine power and in-flight fire was undetermined.Jul 14, 2001 · N502SC · DestroyedNTSB CHI01LA212Accident · 1 fatalLimited investigationFinal reportReitz Mohawk 1 · Camdenton, MOThe pilot not performing an aborted takeoff and the inadvertent stall he encountered on his inadvertent initial climb. Factors were his inadvertent lift-off, the reported inadequate rudder control, his inadvertent flight with known deficiencies, and the…Jul 14, 2001 · N109WR · DestroyedNTSB ATL01IA083Incident · No injuriesIncident investigationFinal reportBoeing B-727-100 · Memphis, TNThe failure of the #3 engine starter turbine.Jul 13, 2001 · N189FE · Minor damageNTSB NYC01LA166Accident · Minor injuriesLimited investigationFinal reportCessna 402C · Boston, MAThe pilot's improper decision to waive the wake turbulence hold time, and his subsequent loss of control when wake vortex turbulence was encountered.Jul 8, 2001 · N760EA · DestroyedNTSB CHI01LA200Accident · No injuriesLimited investigationFinal reportCessna 175 · Tomahawk, WIThe inadequate preflight preparation that did not include calculating the density altitude and the pilot not maintaining clearance from the second row of trees on initial climb. Factors include those trees and the high density altitude present at the time of…Jul 8, 2001 · N103DL · Substantial damageNTSB ATL01LA077Accident · 1 fatalLimited investigationFinal reportKenneth West ARV 582 · Sebring, FLThe pilot's failure to maintain flying speed, followed by a subsequent inadvertent stall spin.Jul 7, 2001 · N3395H · Substantial damageNTSB NYC01LA164Accident · Serious injuriesLimited investigationFinal reportStinson 108-3 · Friendly, MDA baffling failure within the exhaust system. Factors were an inadequate annual inspection and the pilot's operation of the airplane with known deficiencies in equipment.Jul 5, 2001 · N6647M · Substantial damageNTSB SEA01LA124Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Lewistown, MTPilot's failure to maintain directional control of the aircraft while landing.Jul 1, 2001 · N3251Z · Substantial damageNTSB LAX01LA229Accident · Serious injuriesLimited investigationFinal reportSmith FW-190 · Reedley, CAThe pilot's failure to maintain airspeed during takeoff, which resulted in an inadvertent stall.Jul 1, 2001 · N376FW · Substantial damageNTSB CHI01LA191Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Grygla, MNThe pilot not maintaining altitude/clearance from terrain on takeoff. A factor was the high density altitude.Jun 30, 2001 · N3656B · Substantial damageNTSB NYC01LA156Accident · No injuriesLimited investigationFinal reportPiper J3F-65 · Findlay, OHTwo chafed ignition switch leads, which resulted in a failure of the ignition system and subsequent total loss of engine power.Jun 29, 2001 · N40782 · Substantial damageNTSB ANC01LA078Accident · Serious injuriesLimited investigationFinal reportPiper PA-18-150 · Palmer, AKFuel starvation due to the pilot's selection of an empty fuel tank during takeoff.Jun 29, 2001 · N6881B · Substantial damageNTSB SEA01LA123Accident · Minor injuriesLimited investigationFinal reportBreiter Aerosport Quail · Idaho Falls, IDThe pilot's failure to maintain an airspeed above stall velocity (Vs) during his attempt to stretch a reduced power forced landing glide. Factors include fuel starvation, a partial loss of power due to fuel contamination, and the pilots inadequate preflight…Jun 28, 2001 · N47075 · Substantial damageNTSB ANC01LA077Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Willow, AKA loss of engine power for an undetermined reason.Jun 28, 2001 · N364Y · Substantial damageNTSB FTW01LA155Accident · No injuriesLimited investigationFinal reportAmerican Champion 8GCBC · Paris, TXthe excessive pull up by the passenger along with the certified flight instructor's inadequate supervision leading to a loss of control during the takeoff initial climb.Jun 26, 2001 · N249SF · Substantial damageNTSB ANC01GA075Accident · 1 fatalFinal reportPiper PA-18-150 · King Salmon, AKThe pilot's selection of the incorrect fuel tank, subsequent fuel starvation, and inadvertent stall during initial climb. Factors associated with the accident were inadequate transition training, and insufficient training standards of the operator/management.Jun 26, 2001 · N7050 · Substantial damageNTSB FTW01LA152Accident · 1 fatalLimited investigationFinal reportMottier RV-6 · Hammond, LAthe pilot's failure to maintain aircraft control following a loss of engine power. A factor was the loss of engine power during takeoff initial climb for undetermined reasons.Jun 25, 2001 · N149 · DestroyedNTSB MIA01LA175Accident · 1 fatalLimited investigationFinal reportBucker-Jungmann Aero Z-131 · Rupert, GAThe pilot's failure to maintain adequate airspeed which resulted in a stall.Jun 24, 2001 · N4842 · Substantial damageNTSB CHI01LA190Accident · Serious injuriesLimited investigationFinal reportTerminella Glasair II RG · Bolivar, MOThe pilot not maintaining aircraft control during the initial climb after takeoff. A factor to the accident was the pilot's decision to operate the airplane over the kit manufacture's recommended maximum gross weight.Jun 24, 2001 · N96L · Destroyed