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 GAA23WA046Accident · 1 fatalClass 5 · ForeignAir Tractor AT502 · Brasnorte, BrazilDec 22, 2022 · PP-IRC · Substantial damageNTSB CEN23LA068Accident · No injuriesClass 3 · LimitedFinal reportGrumman American AA-5B · Reserve, LAThe partial loss of engine power due to carburetor icing and the flight instructor’s failure to use carburetor heat in weather conditions conducive to serious carburetor icing.Dec 21, 2022 · N321GD · Substantial damageNTSB CEN23FA060Accident · 3 fatalClass 3 · FieldFinal reportBeech F33A · Yukon, OKThe pilot’s loss of airplane control for reasons that could not be determined.Dec 6, 2022 · N9142Q · DestroyedNTSB CEN23FA057Accident · 2 fatalClass 3 · FieldFinal reportCessna 210-5(205) · Cleburne, TXAn in-flight loss of control as a result of spatial disorientation in night instrument meteorological conditions.Dec 5, 2022 · N8149Z · DestroyedNTSB ERA23FA079Accident · 3 fatalClass 3 · FieldFinal reportPiper PA28 · Venice, FLThe pilot’s spatial disorientation during takeoff in dark night visual meteorological conditions, which resulted in his failure to maintain a positive rate of climb and a subsequent descent into the water.Dec 4, 2022 · N4676F · Substantial damageNTSB ERA23FA078Accident · 1 fatalClass 3 · FieldFinal reportRotorsport UK Cavalon · Beverly, MAThe pilot’s improper yaw control during the takeoff initial climb, which resulted in an excessive sideslip and a subsequent loss of aircraft control.Dec 4, 2022 · N401GR · Substantial damageNTSB ERA23LA076Accident · Minor injuriesClass 4 · LimitedFinal reportPhantom Aeronautics X1 · Trinity, NCThe pilot's failure to maintain control of the airplane during initial climb in gusting wind conditions, which resulted in a collision with power lines and trees.Nov 27, 2022 · N5205A · Substantial damageNTSB ERA23LA072Accident · Serious injuriesClass 4 · LimitedFinal reportDaniel Anthony Proctor M24 Orion Plus · Suches, GAThe pilot's decision to take off from the runway midpoint with a tailwind, which resulted in impact with terrain.Nov 26, 2022 · N728RJ · Substantial damageNTSB CEN23FA045Accident · No injuriesClass 3 · FieldFinal reportCirrus Design SF50 · Mount Comfort, INThe uncommanded activation of the CAPS autopilot mode due to corrosion of the system’s electrical components. Contributing to the accident was the pilot’s failure to identify the CAPS autopilot mode and promptly follow the procedures in the airplane flight…Nov 25, 2022 · N15VJ · Substantial damageNTSB GAA23WA029Accident · 8 fatalClass 3 · ForeignPiper PA-31-350 · Medellin, ColombiaNov 21, 2022 · HK 5121 · DestroyedNTSB ERA23LA061Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Lancaster, OHA loss of engine power during initial climb for undetermined reasons.Nov 14, 2022 · N6303J · Substantial damageNTSB CEN23LA035Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Olathe, KSThe inflight collision with multiple geese during initial climb.Nov 12, 2022 · N5258Y · Substantial damageNTSB CEN23LA032Accident · No injuriesClass 4 · LimitedFinal reportMulholland Robert A Vans RV-7 · Englewood, COAn encounter with windshear during the initial climb after takeoff, which resulted in a loss of control. Contributing to the accident was the pilot’s improper decision to takeoff with a tailwind.Nov 9, 2022 · N771RG · Substantial damageNTSB CEN23LA025Accident · Minor injuriesClass 3 · LimitedFinal reportBell 206 · Greenville, ILThe mechanic’s failure to inspect and clean the entire fuel nozzle assembly in accordance with the engine maintenance manual, which resulted in fuel starvation and a partial loss of engine power, an autorotation, and a hard landing.Nov 3, 2022 · N61KH · Substantial damageNTSB GAA23WA027AccidentClass 5 · ForeignLeonardo AW109 · Gien, FranceNov 1, 2022 · G-RAYN · Substantial damageNTSB ANC23LA005Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-22-160 · Kenai, AKImproper installation of the crankshaft drive gear by maintenance personnel, who failed to install all required hardware, resulting in an in-flight engine failure.Oct 27, 2022 · N8119D · Substantial damageNTSB ERA23LA040Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-32RT-300T · Lake Worth, FLA loss of engine power for reasons that could not be determined.Oct 23, 2022 · N39628 · Substantial damageNTSB ERA23LA037Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-235 · Spartanburg, SCA partial separation of the crankshaft gear/bolt, which resulted in a total loss of engine power.Oct 23, 2022 · N8580N · Substantial damageNTSB ERA23LA026Accident · Serious injuriesClass 4 · LimitedFinal reportKolb Firestar II · West Alexandria, OHThe pilot’s failure to maintain airplane control after takeoff, resulting in an aerodynamic stall and collision with terrain.Oct 16, 2022 · N4878P · Substantial damageNTSB CEN23LA013Accident · Serious injuriesClass 4 · LimitedFinal reportPober Pixie · Sterling, COThe pilot’s failure to maintain control during the takeoff with strong gusty surface wind.Oct 11, 2022 · N872UE · Substantial damageNTSB ERA23FA008Accident · 1 fatalClass 3 · FieldFinal reportCessna 172 · Newport News, VAThe flight instructor’s failure to monitor the student pilot on takeoff and her delayed remedial action to stop him from exceeding the airplane’s critical angle of attack, which resulted in a low altitude aerodynamic stall from which she was unable to recover.Oct 6, 2022 · N97883 · Substantial damageNTSB ENG23WA001IncidentClass 5 · ForeignBoeing 777 · Islamabad, PakistanOct 3, 2022 · HZ-AK18 · No damageNTSB CEN23LA004Accident · Minor injuriesClass 4 · LimitedFinal reportTaylorcraft F19 · Waconia, MNThe pilot's failure to maintain aircraft control during a touch-and-go landing.Oct 3, 2022 · N3560T · Substantial damageNTSB CEN23LA003Accident · No injuriesClass 3 · LimitedFinal reportEmbraer S A EMB-545 · Houston, TXThe crew failed to ensure the main entry door was locked before departure. Contributing to the accident was a corroded/jammed door sensor that provided an erroneous locked indication to the crew alerting system.Oct 3, 2022 · N179SP · Substantial damageNTSB ERA23FA001Accident · 3 fatalClass 3 · FieldFinal reportCessna 172S · Hermantown, MNThe pilot’s loss of airplane control due to spatial disorientation during initial climb in dark night and low instrument meteorological conditions, which resulted in a descent into terrain. Contributing to the accident was the pilot’s fatigue due to a long…Oct 2, 2022 · N262TA · Substantial damageNTSB ERA22LA432Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Winterville, NCThe student pilot’s improper recovery from a bounced landing. A factor in the accident was the instructor’s delayed remedial action which resulted in an inability to recover the airplane from an aerodynamic stall.Sep 28, 2022 · N2509N · Substantial damageNTSB CEN22FA436Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28-140 · Allentown, PAA partial loss of engine power for undetermined reasons.Sep 28, 2022 · N7329F · DestroyedNTSB ERA22LA430Accident · Serious injuriesClass 4 · LimitedFinal reportTaylorcraft BC12 · Buffalo, NYThe pilot’s failure to maintain aircraft control during initial climb after a go-around, which resulted in an aerodynamic stall and spin at low altitude.Sep 24, 2022 · N5619M · Substantial damageNTSB ERA22FA426Accident · 2 fatalClass 3 · FieldFinal reportChampion Aeronca 7AC · Bridgeton, NJThe pilot's exceedance of the airplane’s critical angle of attack shortly after takeoff, which resulted in an aerodynamic stall, loss of control, and impact with terrain.Sep 19, 2022 · N2716E · Substantial damageNTSB GAA22WA293AccidentClass 5 · ForeignFairchild 227 · Queretaro, MexicoSep 15, 2022 · XA-UMW · Substantial damageNTSB CEN22LA421Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-180 · Broomfield, COA partial loss of engine power due to a collapsed induction hose that blocked engine intake airflow.Sep 14, 2022 · N3713T · Substantial damageNTSB CEN22FA419Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28R-201 · Conway, SCThe mechanic’s failure to install the required gasket on the vacuum pump drive pad in accordance with the maintenance manual, which resulted in oil exhaustion and the subsequent loss of engine power. Contributing to the accident was the Director of…Sep 14, 2022 · N62FC · DestroyedNTSB ERA22LA413Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Chattanooga, TNA total loss of engine power due to of carburetor ice. Contributing to the accident was the pilot’s failure to apply carburetor heat.Sep 13, 2022 · N388TC · Substantial damageNTSB CEN22LA423Accident · Minor injuriesClass 3 · LimitedFinal reportLuscombe 8 · Kingsbury, TXA total loss of engine power due to a failure of the ignition switch from carbon tracking, which resulted in a forced landing and a subsequent impact with trees.Sep 10, 2022 · N25144 · Substantial damageNTSB ERA22LA412Accident · No injuriesClass 3 · LimitedFinal reportEngineering & Research 415-C · Galion, OHA partial loss of engine power due to an exhaust valve that was stuck in the open position.Sep 9, 2022 · N99209 · Substantial damageNTSB CEN22LA417Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Delta Junction, AKThe pilot’s decision to depart during high, gusty wind conditions which resulted sink and subsequent impact with terrain.Sep 9, 2022 · N303T · Substantial damageNTSB CEN22LA413Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Bulverde, TXThe partial loss of engine power due to excessive carbon deposits that resulted in one or more stuck exhaust valves.Sep 9, 2022 · N31981 · Substantial damageNTSB WPR22LA342Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Salt Lake City, UTThe airplane’s encounter with a microburst during initial climb that resulted in a loss of altitude and subsequent collision with a tree.Sep 7, 2022 · N48918 · Substantial damageNTSB WPR22LA341Accident · No injuriesClass 3 · LimitedFinal reportCessna 750 · Mesa, AZThe pilot’s improper decision to depart on the accident flight with a known hydraulic leak, resulting in an in-flight hydraulic system failure, and the pilot’s attempt to land during an unstabilized approach, which resulted in a loss of control during the…Sep 7, 2022 · N15TZ · Substantial damageNTSB GAA22WA265Accident · 2 fatalClass 3 · ForeignRobinson R66 · Zapallar, ChileSep 4, 2022 · CC-DFY · Substantial damageNTSB ERA22LA411Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Clearfield, PAA sudden partial loss of engine power for undetermined reasons, which resulted in an off-airport landing.Sep 3, 2022 · N9619H · Substantial damageNTSB ERA22LA401Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Wadsworth, OHA total loss of engine power for reasons that could not be determined.Sep 3, 2022 · N5666U · Substantial damageNTSB GAA22WA267Accident · No injuriesClass 5 · ForeignBell 205 · La Ronge, SK, CanadaAug 31, 2022 · C-GZGK · Substantial damageNTSB ERA22FA391Accident · 1 fatalClass 3 · FieldFinal reportAeronca 7AC · Jacksboro, TNThe pilot's exceedance of the airplane’s critical angle of attack during takeoff, which resulted in an aerodynamic stall and loss of control.Aug 29, 2022 · N1478E · DestroyedNTSB ERA22FA387Accident · 2 fatalClass 3 · FieldFinal reportSea & Sky Krucker Cygnet · Emily, MNThe pilot’s operation of the weight-shift control aircraft over its design gross weight and his decision to take off with the engine operating at less than the specified takeoff rpm, which resulted in degraded takeoff and climb performance. Contributing to…Aug 28, 2022 · N505DB · Substantial damageNTSB ERA22LA389Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 140 · Slocomb, ALThe partial loss of engine power during takeoff for reasons that could not be determined.Aug 27, 2022 · N76527 · Substantial damageNTSB ENG22WA041IncidentClass 5 · ForeignATR ATR42 · Eberdeen, United KingdomAug 27, 2022 · G-LMRC · No damageNTSB WPR22LA322Accident · Minor injuriesClass 3 · LimitedFinal reportRay E Roberts Kitfox V Vixen · Caldwell, IDThe partial loss of engine power due to a loose wire leading to the engine’s electronic control unit (ECU). Contributing was the pilot’s exceedance of the critical angle of attack while maneuvering, which resulted in an aerodynamic stall at an altitude too…Aug 26, 2022 · N52367 · Substantial damageNTSB WPR22LA316Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 150H · Vacaville, CAThe partial loss of engine power due to a stuck exhaust valve.Aug 24, 2022 · N22507 · Substantial damageNTSB ENG22WA044IncidentClass 3 · ForeignAirbus A320 · Guadalajara, MexicoAug 24, 2022 · XA-VAJ · No damage