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 CHI03LA020Accident · Minor injuriesLimited investigationFinal reportCessna 182N · Wheatfield, INThe pilot not maintaining aircraft control and the pilot's inadequate compensation for the gusting wind condition. Factors to the accident were the gusting wind condition and the inadvertent stall at a low altitude.Nov 9, 2002 · N253R · Substantial damageNTSB ANC03LA014Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Anchorage, AKThe pilot's failure to adequately remove frost/ice from the airplane which resulted in an inadvertent stall/mush during the takeoff/initial climb.Nov 9, 2002 · N80948 · Substantial damageNTSB ANC03LA009Accident · No injuriesLimited investigationFinal reportArima Kolb Fire Star II · Chugiak, AKThe pilot's inadequate preflight inspection which failed to remove contaminated fuel from the airplane's fuel system, resulting in a loss of engine power during takeoff.Nov 1, 2002 · N8199 · Substantial damageNTSB FTW03LA040Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Porter, TXThe loss of engine power for an undetermined reason.Oct 31, 2002 · N1317E · Substantial damageNTSB FTW03FA024Accident · 1 fatalField investigationFinal reportPiper PA-31T · Hobbs, NMThe pilot's loss of control while in instrument meteorological conditions during initial takeoff climb. Contributing factors were the prevailing clouds and fog.Oct 30, 2002 · N3998Y · DestroyedNTSB LAX03LA016Accident · Minor injuriesLimited investigationFinal reportHubbard StddHmltn GlasairIIS · Chino, CAFuel starvation for undetermined reasons.Oct 29, 2002 · N98TR · Substantial damageNTSB CHI03LA016Accident · No injuriesLimited investigationFinal reportLaFerriere Vans RV-4 · Lake Geneva, WIThe loss of engine power due to carburetor ice. A contributing factor was the ditch adjacent to the roadway.Oct 27, 2002 · N994RV · Substantial damageNTSB MIA03FA005Accident · 1 fatalField investigationFinal reportCessna 310 · Merritt Island, FLThe pilot's decision to take off with a known equipment deficiency, and his failure to maintain airspeed (VMC) following a loss of engine power to one of the airplane's two engines for undetermined reasons, which resulted in descent and an impact with terrain.Oct 22, 2002 · N5247A · Substantial damageNTSB IAD03LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · Middlesboro, KYThe pilot's operation of the airplane with a known deficiency. Factors related to the accident were the loss of engine power of the left engine due to a failure of the left engine-driven and electric fuel pumps, and inadequate maintenance.Oct 22, 2002 · N8770Y · Substantial damageNTSB LAX03FA013Accident · 3 fatalField investigationFinal reportPiper Aerostar 601 · Agua Dulce, CAthe pilot's failure to attain and maintain a sufficient airspeed, which led to an inadvertent stall mush. The pilot's selection of the wrong runway for departure, considering the uphill gradient, the wind direction, and a takeoff path into rising terrain are…Oct 20, 2002 · N700US · DestroyedNTSB LAX03LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Van Nuys, CAfuel starvation due to the pilot's mismanagement of the fuel system and failure to select a tank containing fuel.Oct 19, 2002 · N9483W · Substantial damageNTSB IAD03IA007Incident · No injuriesIncident investigationFinal reportBoeing 767-222 · Boston, MAAn inadvertant collision with birds during the initial climb out.Oct 19, 2002 · N607UA · Minor damageNTSB DEN03LA010Accident · No injuriesLimited investigationFinal reportHildebrandt Rutan/Defiant · Watkins, COthe pilot's failure to use the checklist, resulting in his forgetting to lower the nose landing gear. Contributing factors included the pilot's attention being diverted by the loss of oil pressure on the rear engine due to a broken oil pressure sensor line,…Oct 19, 2002 · N219DF · Substantial damageNTSB NYC03FA008Accident · Minor injuriesField investigationFinal reportPilatus PC-12/45 · Trenton, NJA power loss, due to failure of the No. 1 bearing, which was a result of previous electrical discharge damage (EDD). Factors were the low ceiling and a wet runway.Oct 16, 2002 · N96WF · Substantial damageNTSB ATL03LA003Accident · No injuriesLimited investigationFinal reportCessna 172N · Pompano Beach, FLThe loss of engine power for undetermined reasons.Oct 13, 2002 · N6542J · Substantial damageNTSB IAD03TA003Accident · Minor injuriesFinal reportBeech A200 · Cleveland, OHInadequate operating clearance between the ring gear and pinion gear during the manufacturing process resulting in the failure of the landing gear actuator gear ring.Oct 9, 2002 · N200NG · Substantial damageNTSB DEN03LA004Accident · No injuriesLimited investigationFinal reportBeech C24R · Newcastle, UTthe pilot's failure to maintain clearance from the tree during takeoff. A factor was the reduced light conditions.Oct 9, 2002 · N18917 · Substantial damageNTSB IAD03LA002Accident · No injuriesLimited investigationFinal reportTaylorcraft 15A · Somerset, PAThe mechanic's failure to discover several mechanical deficiencies during a pre-buy inspection, which either independently or collectively resulted in a subsequent engine failure. A factor was the power lines in the forced landing area.Oct 7, 2002 · N6652N · Substantial damageNTSB FTW03LA006Accident · Serious injuriesLimited investigationFinal reportSIAI-Marchetti L1019 · Midland, TXThe loss of engine power resulting from a loose "B" nut on the line going from the bleed air filter to the fuel control unit. Also causal was the inadequate maintenence of the fuel control unit and filters during the last conditional inspection.Oct 6, 2002 · N2069W · Substantial damageNTSB LAX03LA009Accident · No injuriesLimited investigationFinal reportQuicksilver Challenger II · Porterville, CAThe loss of engine power for undetermined reasons. A factor in the accident was the lack of suitable terrain for a forced landing.Oct 5, 2002 · UNREG · Substantial damageNTSB LAX03GA001Accident · Serious injuriesFinal reportMcDonnell Douglas 600N · Rialto, CAan engine deceleration event due to a loose HMU fuel line fitting, which was a result of inadequate maintenance procedures in the 100/300-hour inspection. Also causal was the flying pilot's and pilot-in-command's delayed recognition of the power loss, as well…Oct 4, 2002 · N625SB · Substantial damageNTSB NYC03FA001Accident · 1 fatalField investigationFinal reportBeagle B.206 Basset · West Carrollton, OHThe pilots inadequate preflight inspection, his operation of the airplane with an overdue annual inspection, and his failure to maintain airspeed after the failure of an engine which resulted in an inadvertent stall/spin. A factor related to the accident was…Oct 2, 2002 · N72KB · DestroyedNTSB CHI03LA002Accident · No injuriesLimited investigationFinal reportTanner Kitfox · Coldwater, MIThe low altitude at which an undetermined loss of engine power occurred following takeoff.Oct 2, 2002 · N633KF · Substantial damageNTSB NYC02FA200Accident · 1 fatalField investigationFinal reportMooney M20E · West Creek, NJThe pilot's inadequate preflight inspection which failed to detect water-contaminated fuel, and his failure to maintain airspeed.Sep 30, 2002 · N5556Q · DestroyedNTSB MIA02LA175Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Irvington, ALThe loss of engine power due to internal contamination (rust and water) of the servo fuel injector resulting in it flowing approximately half of the required fuel flow at full throttle. A contributing factor was the unsuitable terrain encountered by the pilot…Sep 29, 2002 · N2963R · Substantial damageNTSB LAX02LA297Accident · Minor injuriesLimited investigationFinal reportPaige Kolb MK III · Fresno, CAthe student pilot's excessive rotation and failure to obtain/maintain adequate airspeed during takeoff, resulting in a stall.Sep 27, 2002 · N6124U · Substantial damageNTSB FTW02LA265Accident · No injuriesLimited investigationFinal reportCessna 320 · Gatesville, TXThe loss of engine power to the left engine for undetermined reasons. A contributing factor was the rough and uneven terrain.Sep 26, 2002 · N382MR · Substantial damageNTSB CHI02FA292Accident · 1 fatalField investigationFinal reportPiper PA-24-260 · Ankeny, IAThe pilot applied an excessive angle of bank and failed to maintain terrain clearance. An additonal factor was the pilot's attention being diverted.Sep 24, 2002 · N8782P · DestroyedNTSB FTW02LA261Accident · No injuriesLimited investigationFinal reportBeech V35 · Del Rio, TXThe loss of engine power due to the low-pressure pump separating internally. Contributing factors were the deterioration of the fuel pump and the lack of suitable terrain for the forced landing.Sep 21, 2002 · N9486S · Substantial damageNTSB ANC02LA123Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Bethel, AKThe instructor pilot's inadequate preflight by his failure to remove all frost from the wings prior to takeoff, which resulted in an inadvertent stall and in-flight collision with terrain.Sep 20, 2002 · N144Q · Substantial damageNTSB NYC02LA188Accident · Serious injuriesLimited investigationFinal reportMooney M20J · Canadaigua, NYThe pilot's inadequate preflight inspection of the airplane, which resulted in a loss of engine power due to fuel contamination.Sep 16, 2002 · N201ZC · Substantial damageNTSB MIA02LA169Accident · No injuriesLimited investigationFinal reportCharles Maxted RV6 · Bay Minette, ALThe intentional operation of the airplane with known deficiencies with the right magneto resulting in the partial loss of engine power during the initial climb.Sep 16, 2002 · N440CM · Substantial damageNTSB NYC02LA192Accident · Minor injuriesLimited investigationFinal reportHughes 369A · Burtonsville, MDThe failure of the tailrotor gearbox for undetermined reasons.Sep 15, 2002 · N336SP · Substantial damageNTSB CHI02LA290Accident · No injuriesLimited investigationFinal reportChristen Industries A-1 · Chetek, WIThe pilot's failure to maintain directional control of the airplane, and his failure to maintain clearance from the utility pole. A factor was the utility pole.Sep 15, 2002 · N9598C · Substantial damageNTSB ANC02LA121Accident · No injuriesLimited investigationFinal reportGardner Kitfox · Fairbanks, AKA partial loss of engine power due to an engine bearing failure during the takeoff initial climb. A factor in the accident was unsuitable terrain for a forced landing.Sep 15, 2002 · N996DG · Substantial damageNTSB CHI02LA283Accident · Serious injuriesLimited investigationFinal reportTerning Sky Scout · Sedan, KSThe loss of engine power for undetermined reasons and the pilot's failure to maintain airspeed resulting in a stall.Sep 12, 2002 · N174BT · Substantial damageNTSB ANC02LA119Accident · No injuriesLimited investigationFinal reportCessna 185 · Mc Grath, AKThe pilot's inadequate compensation for wind conditions during takeoff, which resulted in an in-flight collision with trees. A factor associated with the accident was a variable wind condition.Sep 11, 2002 · N1987U · Substantial damageNTSB ATL02LA168Accident · Serious injuriesLimited investigationFinal reportCessna 172P · Mocksville, NCThe pilot's failure to maintain airspeed during the takeoff and initial climb which resulted in an inadvertent stall and the subsequent collision with trees.Sep 10, 2002 · N62602 · Substantial damageNTSB SEA02FA171Accident · 1 fatalField investigationFinal reportCessna 175B · Arlington, WAA partial loss of engine power for undetermined reasons during the initial climb, followed by the pilot's failure to maintain airspeed while maneuvering. Impairing drugs found in the pilot's system at the time of the accident were a factor.Sep 9, 2002 · N8195T · Substantial damageNTSB LAX02LA279Accident · Serious injuriesLimited investigationFinal reportLockamy Sonex · Oxnard, CAthe loosening of the tapered spacer, which resulted in the propeller hub separating from the crankshaft. A factor in the accident was the unsuitable terrain for landing.Sep 8, 2002 · N164JL · Substantial damageNTSB ANC02LA118Accident · No injuriesLimited investigationFinal reportCessna 180 · Port Heiden, AKThe pilot's inadequate compensation for wind conditions during initial climb, which resulted in an in-flight collision with trees. A factor associated with the accident was a variable wind.Sep 8, 2002 · N4563B · Substantial damageNTSB CHI02LA277Accident · No injuriesLimited investigationFinal reportGrumman-Schweizer G-164B · Martin, MIThe pilot's inadequate aircraft preflight and his inability to abort the takeoff due to the obscured windshield. Contributing to the accident was the bent hopper latch and the pilot's failure to maintain directional control.Sep 6, 2002 · N48417 · Substantial damageNTSB CHI02LA274Accident · Minor injuriesLimited investigationFinal reportBrooks Sonerai 2L · Canton, ILThe partial failure of the ignition system, the induction air leak at the carburetor mounting plate, and the pilot's inadvertant stall during the forced landing. Contributing factors were the crack in the electronic ignition coil, and the improper…Sep 6, 2002 · N356RB · Substantial damageNTSB CHI02LA268Accident · 1 fatalLimited investigationFinal reportRebholz Rans S-10 · Cottage Grove, WIThe pilot's decision to turn back to the airport following the loss of engine power during initial climb, the pilot not maintaining airspeed and aircraft control, which resulted in the stall at a low altitude. An additional cause was the seizure of the engine…Sep 4, 2002 · N92PD · Substantial damageNTSB ANC02LA117Accident · No injuriesLimited investigationFinal reportPiper PA-32R · Manley Hot Spgs, AKA bird strike during takeoff, which resulted in substantial damage to the right wing.Sep 4, 2002 · N40449 · Substantial damageNTSB ANC02LA114Accident · No injuriesLimited investigationFinal reportCessna 185 · Pilot Point, AKThe pilot's inadequate compensation for P-factor, and his failure to abort the takeoff which resulted in a collision with trees during the takeoff initial climb.Sep 4, 2002 · N9563H · Substantial damageNTSB NYC02FA178Accident · 7 fatalField investigationFinal reportBeechcraft 58P · Swanzey, NH**This report was modified on 2/24/2016. Refer to the public docket for this accident for additional information.** the pilot's improper preflight planning and his decision to depart with known landing gear system mechanical deficiencies, which resulted in a…Sep 2, 2002 · N6688D · DestroyedNTSB FTW02LA248Accident · Serious injuriesLimited investigationFinal reportCessna 150F · Deming, NMThe loss of engine power due to carburetor ice as a result of the pilot's failure to apply carburetor heat. A contributing factor was the weather conducive to carburetor icing conditions.Sep 2, 2002 · N8351G · Substantial damageNTSB MIA02FA162Accident · 1 fatalField investigationFinal reportGulfstream American AA-5A · Greeneville, TNA loss of engine power for undetermined reasons and the pilot's decision to continue flight with a known equipment deficiency. Also causal was the pilot's failure to maintain airspeed which resulted in a stall.Sep 1, 2002 · N9807U · Substantial damageNTSB MIA02FA161Accident · Serious injuriesField investigationFinal reportSikorsky S76A+ · Miami, FLThe flight crew's diverted attention, inadequate visual lookout, and failure to ensure adequate main rotor clearance. Factors in the accident were the continued operation, with known obstructions in the area, and the failure of the FAA to initially certify…Aug 31, 2002 · N15460 · Substantial damage