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 CEN22LA394Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA28 · Liberty, MOThe flight instructor’s improper decision to take off without adequate airspeed which resulted in degraded performance and a collision with trees.Aug 24, 2022 · N1815J · Substantial damageNTSB WPR22LA313Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-30 · St Ignatius, MTA partial loss of power during takeoff for undetermined reasons.Aug 23, 2022 · N4009Y · Substantial damageNTSB ENG22WA047OccurrenceClass 5 · ForeignAirbus Canada BD500 · Zurich, SwitzerlandAug 22, 2022 · HB-JBH · Minor damageNTSB WPR22LA314Accident · Minor injuriesClass 3 · LimitedFinal reportBeech F33A · Wilder, IDCatastrophic engine failure during the initial climb due to an incorrectly installed crankshaft counterweight retaining ring.Aug 21, 2022 · N4133S · Substantial damageNTSB WPR22LA310Accident · Serious injuriesClass 3 · LimitedFinal reportStucker Gary Banty · Camarillo, CAThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Aug 18, 2022 · N995GS · Substantial damageNTSB WPR22FA304Accident · 2 fatalClass 3 · FieldFinal reportAviat A-1A · Yellow Pine, IDThe pilot's failure to maintain adequate airspeed during an initial climb, which resulted in the exceedance of the critical angle of attack, subsequent aerodynamic stall, and impact with terrain. Contributing was the pilot’s decision to operate the airplane…Aug 15, 2022 · N26HV · Substantial damageNTSB GAA22WA251Incident · No injuriesClass 5 · ForeignChristen Industries A1 · Menuma, JapanAug 15, 2022 · JA4083 · No damageNTSB ENG22WA042IncidentClass 5 · ForeignBoeing 737 · Gdansk, PolandAug 15, 2022 · SP-ENU · No damageNTSB ERA22LA372Accident · Minor injuriesClass 3 · LimitedFinal reportThomas Wayne L THOMAS' Flyer · Searsmont, MEA total loss of engine power during the initial climb for reasons that could not be determined.Aug 13, 2022 · N35WT · Substantial damageNTSB WPR22LA301Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Laurel, MTThe loss of climb performance due to undetermined reasons.Aug 11, 2022 · N5780F · Substantial damageNTSB ANC22FA066Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-12 · Arctic Village, AKThe pilot’s decision to depart in turbulent and gusting wind conditions, which resulted in a loss of control and impact with terrain.Aug 11, 2022 · N3937M · Substantial damageNTSB ENG22WA040IncidentClass 5 · ForeignBombardier CL600 2B16 · Farnborough, United KingdomAug 10, 2022 · D-AAAY · No damageNTSB GAA22WA243Accident · No injuriesClass 5 · ForeignPiper PA-34-200T · Bueanaventura Beach, PanamaAug 8, 2022 · HP-1685 · DestroyedNTSB CEN22LA380Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · McCarthy, AKThe pilot’s failure to maintain control of the airplane during takeoff in turbulent weather conditions.Aug 7, 2022 · N171Q · Substantial damageNTSB GAA22WA244Accident · No injuriesClass 5 · ForeignPiper PA-28-161 · Hampshire, United KingdomAug 6, 2022 · G-JASE · Substantial damageNTSB CEN22LA367Accident · No injuriesClass 3 · LimitedFinal reportCessna 182 · Benton, KSThe loss of engine power for undetermined reasons.Aug 5, 2022 · N97683 · Substantial damageNTSB GAA22WA258Accident · Minor injuriesClass 5 · ForeignAir Tractor AT-802A · Cranbrook, CanadaAug 3, 2022 · C-FFQS · Substantial damageNTSB ERA22LA345Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8A · Ephratah, NYA loss of engine power for undetermined reasons.Jul 30, 2022 · N1358K · Substantial damageNTSB CEN22LA349Accident · No injuriesClass 3 · LimitedFinal reportSchweizer G-164B · Knox, INA partial loss of engine power for undetermined reasons.Jul 26, 2022 · N629EH · Substantial damageNTSB ANC22LA063Accident · Serious injuriesClass 4 · LimitedFinal reportDe Havilland DHC2 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions which resulted in the wing exceeding its critical angle of attack, a loss of control and impact with the water.Jul 26, 2022 · N9776R · Substantial damageNTSB CEN22LA336Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36 · Ray, MIThe pilot’s early rotation on takeoff, which resulted in insufficient airspeed and an inability to gain sufficient altitude to clear the trees.Jul 24, 2022 · N60ED · Substantial damageNTSB GAA22WA237Accident · No injuriesClass 5 · ForeignRobinson R44 · Buenos Aires, ArgentinaJul 22, 2022 · LV-WMB · DestroyedNTSB ERA22LA322Accident · Serious injuriesClass 3 · LimitedFinal reportVans RV10 · Palatka, FLTotal loss of engine power due to the improper installation of an electronic ignition system connector plug.Jul 18, 2022 · N910BW · Substantial damageNTSB ERA22LA325Accident · No injuriesClass 4 · LimitedFinal reportRaytheon 400A · Brunswick, GAAn in-flight collision with a bird.Jul 15, 2022 · N400MX · Substantial damageNTSB ERA22FA314Accident · 2 fatalClass 3 · FieldFinal reportCessna 210C · Shelby, MIThe non-instrument rated pilot’s decision to commence the flight in instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of airplane control. Contributing to the accident was the pilot’s self-induced pressure to…Jul 15, 2022 · N3659Y · DestroyedNTSB ERA22LA312Accident · Serious injuriesClass 3 · LimitedFinal reportFlightstar Flightstar II SC · Russell, PAThe pilot failed to maintain adequate airspeed and exceeded the airplane’s critical angle of attack while attempting to climb over trees, which resulted in an aerodynamic stall and loss of airplane control.Jul 14, 2022 · N6116U · Substantial damageNTSB ERA22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150F · Pittstown, NJThe partial loss of engine power due to a stuck exhaust valve.Jul 13, 2022 · N8761G · Substantial damageNTSB ERA22LA301Accident · 1 fatalClass 3 · LimitedFinal reportKolb Firestar · Cleveland, GAThe pilot’s failure to maintain control of the airplane on takeoff for unknown reasons.Jul 8, 2022 · N6136Y · Substantial damageNTSB DCA22WA147IncidentClass 5 · ForeignBoeing 737-924ER · San Salvador, El SalvadorJul 7, 2022 · N69833 · No damageNTSB ERA22LA300Accident · Minor injuriesClass 4 · LimitedFinal reportCessna A185F · Plymouth, CTThe pilot’s encounter with known and forecast adverse weather which resulted in a collision with trees during the initial climb.Jul 5, 2022 · N2423A · Substantial damageNTSB CEN22LA308Accident · Minor injuriesClass 3 · LimitedFinal reportVans RV6 · Aurora, COA total loss of engine power due to foreign object debris blockage of engine air intake. The source of the debris could not be determined based on the available information.Jul 3, 2022 · N184CB · Substantial damageNTSB CEN22LA303Accident · 1 fatalClass 3 · LimitedFinal reportPiper PA-28-140 · Oklahoma City, OKThe pilot’s failure to maintain adequate airspeed for unknown reasons during the initial climb, which resulted in an inadvertent aerodynamic stall and impact with terrain.Jul 2, 2022 · N270SA · Substantial damageNTSB CEN22FA298Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-24-250 · St. Jacob, ILThe inadequate maintenance of the airplane fuel system that resulted in fuel exhaustion and a loss of engine power.Jul 2, 2022 · N5235P · DestroyedNTSB GAA22WA309Accident · No injuriesClass 5 · ForeignCassult Racer Iiim · Henstridge, Somerset, United KingdomJul 1, 2022 · G-BPVO · Substantial damageNTSB GAA22WA219Accident · No injuriesClass 5 · ForeignCassutt Iiim · Henstridge, United KingdomJul 1, 2022 · G-BPBO · Substantial damageNTSB ERA22LA366Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT · Wilmington, NCA partial loss of engine power during initial climb for reasons that could not be determined.Jun 29, 2022 · N4321M · Substantial damageNTSB WPR22LA242Accident · No injuriesClass 3 · LimitedFinal reportCessna 120 · San Carlos, CAThe total loss of engine power for undetermined reasons.Jun 28, 2022 · N2056V · Substantial damageNTSB WPR22LA238Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA20 · Challis, IDThe pilot's turn towards rising terrain with limited climb performance and his subsequent failure to maintain clearance from terrain that resulted in an impact with terrain.Jun 27, 2022 · N1231C · Substantial damageNTSB GAA22WA209Accident · No injuriesClass 5 · ForeignCessna TU206G · Bielsko Biala, PolandJun 24, 2022 · OK-ROY · Substantial damageNTSB ERA22LA294Accident · Serious injuriesClass 3 · LimitedFinal reportBucker BU-133 · Hartford, KYThe pilot’s exceedance of the airplane’s critical angle of attack during the initial climb, which resulted in an aerodynamic stall during an attempted return to the runway.Jun 24, 2022 · N1940H · Substantial damageNTSB CEN22LA283Accident · No injuriesClass 3 · LimitedFinal reportOsprey II · Bulverde, TXA loss of engine power due to fuel starvation due to a blockage of the fuel tank outlet port.Jun 24, 2022 · N10236 · Substantial damageNTSB GAA22WA214Accident · No injuriesClass 5 · ForeignCessna 182P · Benevides, BrazilJun 22, 2022 · PT-ILH · Substantial damageNTSB CEN22LA258Accident · No injuriesClass 3 · LimitedFinal reportEurocopter Deutschland EC 135 P2+ · Waukesha, WIThe separation and subsequent ingestion of the fenestron fairing cover into the fenestron blades for undetermined reasons.Jun 18, 2022 · N226SA · Substantial damageNTSB WPR22LA219Accident · Minor injuriesClass 3 · LimitedFinal reportCessna TR182 · Davis, CAAn in-flight fire during the initial takeoff climb for reasons that could not be determined based on the available evidence.Jun 16, 2022 · N756EG · DestroyedNTSB CEN22LA256Accident · No injuriesClass 3 · LimitedFinal reportBellanca 17-30A · Madison, MSThe failure of a muffler weld due to inadequate maintenance, which resulted in a fire.Jun 16, 2022 · N39880 · Substantial damageNTSB CEN22LA252Accident · No injuriesClass 3 · LimitedFinal reportMeyers Industries 200A · Weslaco, TXA total loss of engine power for reasons that could not be determined.Jun 16, 2022 · N489C · Substantial damageNTSB CEN22LA249Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Eaton Rapids, MIThe pilot’s failure to maintain airspeed in the climb with a quartering tailwind which resulted in an aerodynamic stall and subsequent impact with trees.Jun 14, 2022 · N3553M · Substantial damageNTSB ERA22LA267Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 172 · Bluffton, OHThe student pilot’s loss of control during climb after an aborted landing, which resulted in an aerodynamic stall.Jun 13, 2022 · N78755 · Substantial damageNTSB DCA23WA187IncidentClass 5 · ForeignBoeing 737 · Perth, AustraliaJun 10, 2022 · ZK-TLJ · No damageNTSB WPR22LA211Accident · Minor injuriesClass 3 · LimitedFinal reportRans S21 · Fairfield, UTThe owner’s (pilot) failure to properly torque a fuel filter b-nut fitting, which likely introduced air into the fuel system and resulted in a loss of engine power. Contributing to the loss of power was a missing restricted bypass line and a header tank vent…Jun 9, 2022 · N46JH · Substantial damage