OpenAirDocs.org

NTSB investigations

14,035 cases where the phase of flight was Takeoff.

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 = 300)
  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 CEN23LA196Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Kansas City, MOThe student pilot's failure to maintain directional control during takeoff.May 22, 2023 · N227XY · Substantial damageNTSB WPR23LA194Accident · No injuriesClass 4 · LimitedFinal reportCubcrafters CCX-2300 · Spanish Fork, UTThe pilot's decision to attempt an unfamiliar takeoff technique, his failure to maintain pitch control during takeoff, and his subsequent decision to retract flaps at a low altitude, which resulted in a descent into a building.May 21, 2023 · N668LD · Substantial damageNTSB ANC23LA037Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Hunter Creek, AKThe pilot’s loss of directional control during takeoff roll in gusting wind conditions.May 20, 2023 · N4231Z · Substantial damageNTSB ENG23WA028AccidentClass 5 · ForeignLearjet 35 · Hohn, GermanyMay 15, 2023 · D-CGFQ · DestroyedNTSB GAA23WA149Accident · No injuriesClass 5 · ForeignRobinson R66 · Konakovo, RussiaMay 13, 2023 · RA-07372 · DestroyedNTSB CEN23LA184Accident · Serious injuriesClass 4 · LimitedFinal reportRans S7 · Gardner, KSThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff, which resulted in an aerodynamic stall and loss of airplane control at too low of an altitude to recover.May 13, 2023 · N8932L · Substantial damageNTSB ERA23LA229Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 172 · South Bethlehem, NYThe pilot’s improper decision to attempt an intersection takeoff in a tailwind when the full runway in the opposite, headwind direction was available.May 11, 2023 · N1596E · Substantial damageNTSB CEN23LA182Accident · No injuriesClass 3 · LimitedFinal reportLoehle Acft 5151 Mustang · Hector, MNA total loss of engine power due to fuel starvation as a result of the pilot’s modifications to the fuel system. Contributing to the accident was the pilot’s decision to continue the takeoff despite observing lower than anticipated propeller rpm, his decision…May 11, 2023 · N91026 · Substantial damageNTSB ERA23LA222Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150M · Hernando, FLThe pilot’s failure to maintain adequate clearance from obstacles during takeoff at night.May 8, 2023 · N150VL · Substantial damageNTSB WPR23LA178Accident · No injuriesClass 4 · LimitedFinal reportUniversal Globe GC-1A · Belen, NMThe airplane’s encounter with downdraft on takeoff, which resulted in a loss of control.May 7, 2023 · N80892 · DestroyedNTSB ERA23LA227Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5A · Knoxville, TNThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions.May 4, 2023 · N26941 · Substantial damageNTSB ERA23LA217Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Defuniak Springs, FLThe pilot's failure to maintain directional control while taking off in a crosswind, which resulted in a runway excursion and impact with a berm. Contributing was the automated weather briefing which failed to include accurate wind information.May 4, 2023 · N3796T · Substantial damageNTSB CEN23LA175Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Brookings, SDThe student pilot’s failure to maintain pitch and directional control during the takeoff roll. Contributing to the accident, was the student pilot’s delay in relinquishing control of the airplane and the instructor's delayed reaction before the loss of…May 4, 2023 · N1674E · Substantial damageNTSB CEN23LA171Accident · No injuriesClass 4 · LimitedFinal reportKitfox IV · Gretna, NEThe pilot’s failure to maintain clearance from terrain during a turn immediately after takeoff.May 4, 2023 · N440RS · Substantial damageNTSB ERA23LA212Accident · Serious injuriesClass 4 · LimitedFinal reportGulfstream Aerospace GVII-G500 · Dulles, VAThe initiation of the takeoff while before the flight attendant had returned to her seat, which resulted in a serious injury during takeoff.Apr 28, 2023 · N507GD · No damageNTSB WPR23LA168Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 140 · Nyssa, ORThe pilot’s failure to maintain adequate airspeed on takeoff that resulted in an aerodynamic stall and subsequent impact with trees.Apr 26, 2023 · N140D · Substantial damageNTSB WPR23LA165Accident · No injuriesClass 4 · LimitedFinal reportOneal J R/Oneal R C EDI Express · Tracy, CAThe pilot’s failure to maintain directional control during the takeoff roll.Apr 24, 2023 · N92734 · Substantial damageNTSB GAA23WA134Accident · Minor injuriesClass 5 · ForeignPiper PA28 · Bogota, ColombiaApr 20, 2023 · HK-1577G · Substantial damageNTSB ENG23WA046IncidentClass 5 · ForeignBoeing 747 · Nairobi, KenyaApr 17, 2023 · 9V-SFO · No damageNTSB DCA23WA238Incident · No injuriesClass 5 · ForeignBoeing 747 · Nairobi, KenyaApr 17, 2023 · 9V-SF0 · Minor damageNTSB DCA23WA245Incident · No injuriesClass 5 · ForeignBoeing 737 · Luqa, MaltaApr 13, 2023 · 9H-VVH · Minor damageNTSB ERA23LA193Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · West Mifflin, PAThe student pilot’s decision to abort the takeoff and land on the runway without sufficient runway remaining, which resulted in a runway overrun.Apr 10, 2023 · N476TA · Substantial damageNTSB ERA23LA199Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Somerset, KYThe pilot’s failure to maintain control of the airplane during the takeoff, which resulted in a runway excursion and collision with an airport navigation antenna.Apr 8, 2023 · N2448R · Substantial damageNTSB WPR23LA152Accident · No injuriesClass 4 · LimitedFinal reportGrumman G-44A · Los Alamos, NMThe pilot receiving instruction’s failure to maintain directional control during the takeoff roll, resulting in a runway excursion and ground collision.Apr 5, 2023 · N444M · Substantial damageNTSB ANC23LA029Accident · No injuriesClass 4 · LimitedFinal reportCessna 170 · Wasilla, AKThe pilot’s failure to maintained directional control and the instructor pilot's inadequate supervision, which resulted in a loss of control during takeoff.Apr 3, 2023 · N4464B · Substantial damageNTSB ERA23LA161Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-46-350P · St. Augustine, FLThe pilot's inadequate preflight planning, which resulted in a takeoff above the airplane’s maximum gross weight, a CG forward of the limit, and a tailwind component that prevented the airplane from climbing above trees.Mar 23, 2023 · N280KC · DestroyedNTSB WPR23LA124Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Van Nuys, CAThe pilots failure to maintain directional control during takeoff.Mar 10, 2023 · N73726 · Substantial damageNTSB ERA23LA145Accident · No injuriesClass 4 · LimitedFinal reportCirrus Design SR22T · Knoxville, TNThe pilot's failure to maintain directional control during the takeoff roll where a gusting and shifting crosswind prevailed.Mar 7, 2023 · N320CA · Substantial damageNTSB CEN23FA125Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R44 · Port O'Connor, TXThe pilot’s initiation of the visual flight into instrument meteorological conditions, which resulted in spatial disorientation and a subsequent loss of helicopter control. Contributing to the accident was the pilot’s flicker vertigo during the flight.Mar 7, 2023 · N494SH · DestroyedNTSB DCA23WA205Incident · No injuriesClass 5 · ForeignBoeing 737 · East Midlands, United KingdomMar 6, 2023 · G-JMCU · No damageNTSB ERA23LA152Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Kinston, NCThe airplane’s impact with two deer while performing a takeoff at night.Mar 5, 2023 · N2527L · Substantial damageNTSB DCA23LA192IncidentClass 4 · LimitedFinal reportLearjet 60 · Boston, MAThe Hop-a-Jet flight crew taking off without a takeoff clearance which resulted in a conflict with a JetBlue flight that had been cleared to land on an intersecting runway.Feb 27, 2023 · N280LJ · 2 aircraft · No damageNTSB CEN23LA122Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Princeton, MNThe pilot’s failure to maintain directional control during the takeoff roll. Contributing to the accident, was the runway condition combined with a right crosswind.Feb 25, 2023 · N208SP · Substantial damageNTSB DCA23LA185Incident · No injuriesClass 3 · LimitedFinal reportBombardier CL-600-2D24 · Burbank, CAThe interruption of the local controller’s workflow due to the necessitated management of a go-around of a third airplane that was approaching a different runway. Contributing to the incident was: 1) the controller’s decision to continue the landing of…Feb 23, 2023 · N954LR · 2 aircraft · No damageNTSB WPR23LA111Accident · Serious injuriesClass 4 · LimitedFinal reportGlasair Sportsman · Cal-Nev-Ari, NVThe pilot’s improper decision to takeoff with known damage to the wing and his failure to maintain directional control during takeoff on rough terrain.Feb 19, 2023 · N2847H · Substantial damageNTSB CEN23LA110Accident · No injuriesClass 3 · LimitedFinal reportTitan Tornado II · Windom, MNThe fatigue failure of the right landing gear leg that resulted in its separation from the airplane during takeoff.Feb 18, 2023 · N9168P · Substantial damageNTSB ANC23LA023Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P337H · Kona, HIThe failure of the pilot to recognize that the rear engine was not operating during takeoff, which resulted in an attempted single-engine takeoff and the airplane’s subsequent descent and impact with terrain. Contributing to the accident was a loss of rear…Feb 14, 2023 · N5KR · Substantial damageNTSB ANC23LA022Accident · No injuriesClass 4 · LimitedFinal reportCessna U206F · Chugiak, AKThe pilot’s failure to maintain directional control during takeoff in flat light conditions which resulted in a loss of control and impact with a snow berm.Feb 14, 2023 · N9572G · Substantial damageNTSB ANC23LA020Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-16 · Soldotna, AKA total loss of engine power for undetermined reasons.Feb 9, 2023 · N5987H · Substantial damageNTSB CEN23LA100Accident · No injuriesClass 4 · LimitedFinal reportCessna 152 · Denton, TXThe student pilot’s failure to maintain directional control during a touch-and-go landing.Feb 5, 2023 · N5442B · Substantial damageNTSB DCA23FA149Incident · No injuriesClass 1 · FieldFinal reportBoeing 737-79P · Austin, TXthe local controller’s incorrect assumption that the Southwest Airlines (SWA) airplane would depart from the runway before the Federal Express airplane arrived on the same runway, which resulted in a loss of separation between both airplanes. Contributing to…Feb 4, 2023 · N7827A · 2 aircraft · No damageNTSB GAA23WA064Accident · No injuriesClass 5 · ForeignLearjet 60 · Buenos Aires, ArgentinaFeb 2, 2023 · LV-JJQ · Substantial damageNTSB ERA23LA123Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA46 · Port Orange, FLThe pilot’s failure to maintain aircraft control during a takeoff attempt, which resulted in an aerodynamic stall, runway excursion, and collision with trees.Feb 2, 2023 · N864JB · Substantial damageNTSB CEN23LA102Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Limon, COThe pilot’s failure to maintain directional control during the takeoff roll.Feb 1, 2023 · N5163H · Substantial damageNTSB GAA23WA061AccidentClass 5 · ForeignAir Tractor AT-502 · Puerto Barrios, GuatemalaJan 31, 2023 · N4507U · Substantial damageNTSB ERA23LA153Accident · No injuriesClass 4 · LimitedFinal reportGreen Richard H VAN'S RV7A · Williston, FLThe hard landing and subsequent nose over during the forced landing. Contributing to the accident were the improperly secured canopy, and the distraction it created.Jan 31, 2023 · N4811E · Substantial damageNTSB WPR23LA101Accident · No injuriesClass 4 · LimitedFinal reportCub Crafters CC18-180 · Dallesport, WAThe flight instructor’s failure to see and avoid a channel marker during a step taxi in preparation for takeoff on the water.Jan 29, 2023 · N127DT · Substantial damageNTSB ERA23LA121Accident · Serious injuriesClass 3 · LimitedFinal reportRichard Brinkman Lancair 4P · Hartford, CTThe pilot’s takeoff with a significant fuel imbalance, which resulted in the airplane lacking the roll authority to overcome the left rolling tendency and subsequently impacting terrain. Contributing to the accident was the pilot’s inadequate preflight…Jan 28, 2023 · N550LX · Substantial damageNTSB CEN23LA098Accident · No injuriesClass 4 · LimitedFinal reportCessna 120 · Eagle River, WIThe pilot’s decision to takeoff from an unsuitable surface which resulted in collision with an object.Jan 25, 2023 · N73034 · Substantial damageNTSB WPR23LA091Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · San Diego, CAThe flight instructor’s failure to maintain altitude while maneuvering to another runway after the engine cowling opened shortly after takeoff. Contributing to the accident was the failure of both the student pilot and flight instructor to conduct an adequate…Jan 15, 2023 · N9687J · Substantial damage