Final NTSB investigations

13,325 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.\"completionStatus\" = 'Completed'
    AND 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 ERA26LA101Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Summerdale, ALThe pilot’s decision to abort the takeoff with insufficient runway remaining, which resulted in a runway overrun and impact with a fence post.Jan 29, 2026 · N4178V · Substantial damageNTSB WPR26LA081Accident · No injuriesClass 4 · LimitedFinal reportCessna 172E · Kingman, AZThe pilot’s failure to use a pre-takeoff checklist, which resulted in the fuel selector being in the off position, and subsequent loss of engine power during takeoff.Jan 14, 2026 · N7783U · Substantial damageNTSB CEN26LA092Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · San Marcos, TXThe flight instructor’s failure to properly configure the elevator trim for the takeoff, that resulted in a hard landing. Contributing to the accident was the flight instructor’s failure to follow the before takeoff checklist.Jan 7, 2026 · N5136E · Substantial damageNTSB CEN26LA083Accident · No injuriesClass 4 · LimitedFinal reportCessna 150 · Round Lake Park, ILThe student pilot’s failure to maintain directional control during a soft-field takeoff and the flight instructor’s delayed remedial action.Jan 5, 2026 · N101FA · Substantial damageNTSB ERA26LA080Accident · No injuriesClass 4 · LimitedFinal reportVarga 2150A · Frostproof, FLThe pilot’s failure to maintain control of the airplane during takeoff, resulting in a runway excursion and collision with terrain.Dec 28, 2025 · N5062V · Substantial damageNTSB CEN26LA084Accident · No injuriesClass 3 · LimitedFinal reportCessna 172 · Taylor, TXThe pilot’s inadequate preflight inspection that resulted in a loss of engine power due to water contamination.Dec 26, 2025 · N172BX · Substantial damageNTSB CEN26LA081Accident · No injuriesClass 4 · LimitedFinal reportEla ELA10 · Morris, ILThe pilot’s failure obtain the proper rotor rpm before applying power for the takeoff roll which resulted in a loss of control.Dec 23, 2025 · N396S · Substantial damageNTSB CEN26LA067Accident · No injuriesClass 4 · LimitedFinal reportMark O Treidel American Ranger AR-1 · Denver, COThe pilot’s failure to attain rotor RPM and maintain proper rotor disc angle during takeoff which resulted in a rotor strike with the rudder.Dec 16, 2025 · N529MW · Substantial damageNTSB CEN26LA058Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Conroe, TXThe collision with a deer during takeoff.Dec 10, 2025 · N6058F · Substantial damageNTSB ERA26LA058Accident · No injuriesClass 4 · LimitedFinal reportHuebbe Tom MAX TH · Inverness Highlands South, FLThe pilot’s failure to maintain directional control on takeoff. Contributing to the accident was the aircraft design that did not incorporate differential braking.Nov 26, 2025 · N48TH · Substantial damageNTSB CEN26LA054Accident · Minor injuriesClass 4 · LimitedFinal reportLou Malinchak Titan T-51D · Bristow, OKThe collision with two deer during takeoff which resulted in a loss of control and impact with terrain.Nov 26, 2025 · N251LM · Substantial damageNTSB ERA26LA037Accident · No injuriesClass 4 · LimitedFinal reportBeech 95-A55 · Southern Pines, NCThe pilot’s failure to maintain directional control during takeoff at night, while distracted by an animal approaching the runway, which resulted in collision with a runway light.Nov 9, 2025 · N500CA · Substantial damageNTSB WPR26LA038Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 182P · San Andreas, CAThe pilot’s decision to adjust his seat during the takeoff roll, which resulted in the seat sliding aft and a subsequent loss of directional control.Nov 3, 2025 · N1303S · Substantial damageNTSB CEN26LA041Accident · No injuriesClass 4 · LimitedFinal reportDouglas B-26B · Ponca City, OKFailure of the nose landing gear link which resulted in a loss of directional.Nov 1, 2025 · N9682C · Substantial damageNTSB WPR26LA033Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 152 · Richfield, UTThe pilot’s failure to maintain directional control in gusting wind conditions during the takeoff roll.Oct 27, 2025 · N49792 · Substantial damageNTSB WPR26LA029Accident · No injuriesClass 4 · LimitedFinal reportRoderick James Willmore Kitfox S7 Supersport · Kilgore, IDThe pilot's failure to maintain directional control during the takeoff. Contributing to the accident was the separation of the control stick grip.Oct 18, 2025 · N98RW · Substantial damageNTSB ERA26LA017Accident · Serious injuriesClass 4 · LimitedFinal reportTricks Trike Storm · Gaffney, SCThe pilot’s failure to maintain aircraft control during the initial climb, which resulted in an impact with terrain.Oct 13, 2025 · UNREG · Substantial damageNTSB CEN26LA017Accident · No injuriesClass 4 · LimitedFinal reportRans S20 · Springfield, COThe pilot's failure to maintain directional control during the takeoff with a right crosswind.Oct 12, 2025 · N319WD · Substantial damageNTSB ERA26LA021Accident · No injuriesClass 4 · LimitedFinal reportCessna 140 · Plymouth, CTThe plot’s failure to account sufficiently for the decrease in the airplane’s takeoff performance due to the wet turf runway, which resulted in a collision with a log barrier and subsequent nose over after aborting the takeoff.Oct 11, 2025 · N2812N · Substantial damageNTSB ERA26LA015Accident · No injuriesClass 4 · LimitedFinal reportSocata TB 10 · New Milford, CTThe pilot’s decision to depart from an unlit turf runway at night, which resulted in a loss of directional control, and subsequent runway excursion.Oct 10, 2025 · N28170 · Substantial damageNTSB WPR26LA018Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 180 · Imnaha, ORThe pilot’s continued application of brakes during an aborted takeoff in a tailwind on down-sloping terrain, which resulted in a nose-over.Oct 9, 2025 · N249MD · Substantial damageNTSB ERA26LA005Accident · Minor injuriesClass 3 · LimitedFinal reportBellanca 7GCBC · Reedville, VAThe pilot’s sudden incapacitation by an episode of abnormal heartbeat due to heart disease during a takeoff attempt, which resulted in a loss of directional control and runway excursion.Oct 4, 2025 · N289PS · Substantial damageNTSB CEN25LA405Accident · Minor injuriesClass 4 · LimitedFinal reportSukhoi SU-26MX · Longmont, COThe pilot's failure to maintain directional control during takeoff.Sep 30, 2025 · N25SU · Substantial damageNTSB ERA25LA371Accident · Minor injuriesClass 4 · LimitedFinal reportNorth American T-6G · Rossville, TNThe pilot’s failure to adequately monitor the airplane’s path during takeoff toward the setting sun. Contributing was the undetected worn and fractured tailwheel locking pin.Sep 28, 2025 · N888WV · Substantial damageNTSB CEN25LA397Accident · No injuriesClass 4 · LimitedFinal reportDe Havilland DH82 · Harvard, ILThe pilot’s failure of the pilot to maintain directional control during takeoff which resulted in a collision with cornstalks. Contributing to the accident was the pilot’s partially obscured vision due to sun glare.Sep 27, 2025 · UNREG · Substantial damageNTSB ANC25LA110Accident · No injuriesClass 4 · LimitedFinal reportCessna 208B · Healy, AKThe pilot’s failure to maintain directional control during the departure roll resulting in a collision with a tractor/loader.Sep 23, 2025 · N976E · Substantial damageNTSB ERA25LA359Accident · No injuriesClass 4 · LimitedFinal reportEdwin Miller Calidus · Hopkinsville, KYThe pilot’s failure to maintain control of the gyroplane, which resulted in dynamic rollover and impact with terrain.Sep 20, 2025 · N4779M · Substantial damageNTSB CEN25LA392Accident · No injuriesClass 4 · LimitedFinal reportDiamond DA20-C1 · Terre Haute, INThe failure of the nose landing gear strut and associated nosewheel separation during takeoff.Sep 19, 2025 · N544KC · Substantial damageNTSB WPR25LA306Accident · No injuriesClass 4 · LimitedFinal reportTemco GC-1B · Toledo, WAThe pilot’s failure to maintain control of the airplane during takeoff in crosswind conditions..Sep 18, 2025 · N78316 · Substantial damageNTSB CEN25LA387Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-32R-301 · Oxford, MSThe pilot’s exceedance of the airplane’s critical angle of attack during the initial takeoff climb, which resulted in an aerodynamic stall and impact with terrain.Sep 18, 2025 · N318JM · Substantial damageNTSB ANC25LA121Accident · No injuriesClass 4 · LimitedFinal reportMaule M-4-210C · Lime Village, AKA collision with terrain during takeoff.Sep 18, 2025 · N4612T · Substantial damageNTSB ANC25LA108Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Delta Junction, AKThe pilot’s failure to maintain clearance from an object during takeoff, which resulted in a collision and ground loop. Contributing was the pilot’s selection of an unsuitable takeoff area.Sep 17, 2025 · N7777D · Substantial damageNTSB CEN25LA383Accident · No injuriesClass 4 · LimitedFinal reportQuad City Challenger · Crystal Mountain, MIThe pilot’s failure to maintain aircraft control during initial climb.Sep 16, 2025 · N65176 · Substantial damageNTSB ANC25LA120Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · St Mary's, AKThe pilot’s improper decision to takeoff with a tailwind, from a short off-airport strip, which degraded the climb performance of the airplane and led to impact with trees at the end of the strip.Sep 14, 2025 · N3797Z · Substantial damageNTSB ANC25LA103Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-11 · Lake Louise, AKThe pilot’s encounter with gusting crosswind conditions during takeoff, which resulted in a loss of control and subsequent impact with terrain.Sep 10, 2025 · N5025H · Substantial damageNTSB ANC25LA104Accident · No injuriesClass 4 · LimitedFinal reportJeremy Price Smith Super CUB · Chisana, AKThe pilot’s failure to maintain directional control during the takeoff roll.Sep 8, 2025 · N9930D · Substantial damageNTSB ERA25LA347Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 170 · Eustis, METhe pilot’s failure to maintain control of the airplane during takeoff, which resulted in an inadvertent descent, contact with the water, and a subsequent nose over.Sep 1, 2025 · N3576D · Substantial damageNTSB ANC25LA101Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Willow, AKThe pilot’s decision to takeoff from an unsuitable runway due to large puddles of water, which resulted in a nose over.Sep 1, 2025 · N2996C · Substantial damageNTSB ERA25LA325Accident · No injuriesClass 4 · LimitedFinal reportCessna 182 · Lebanon, OHThe pilot’s failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with a sign.Aug 31, 2025 · N628FN · Substantial damageNTSB CEN25LA340Accident · No injuriesClass 4 · LimitedFinal reportBurkhart Grob Flugzeugbau G102 Club Astir Iiib · Highland, ILThe pilot’s failure to maintain directional control during takeoff which resulted in a collision with a parked vehicle.Aug 24, 2025 · N424BG · Substantial damageNTSB ANC25LA092Accident · No injuriesClass 4 · LimitedFinal reportEurocopter AS 350 B2 · Juneau, AKThe pilot’s failure to maintain adequate obstacle clearance during takeoff from uneven, snow-covered terrain in flat light conditions.Aug 22, 2025 · N149TH · Substantial damageNTSB ANC25LA095Accident · No injuriesClass 4 · LimitedFinal reportHelio H-395 · Pilot Point, AKThe pilot's inadequate takeoff performance planning, which resulted in a runway excursion and collision with terrain.Aug 21, 2025 · N44344 · Substantial damageNTSB ERA25LA322Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 182 · Edgartown, MAThe accident was the pilot’s failure to properly configure the airplane for a soft-field takeoff, which resulted in his decision to abort the takeoff and the subsequent runway overrun.Aug 19, 2025 · N691DM · Substantial damageNTSB ANC25LA088Accident · No injuriesClass 4 · LimitedFinal reportCessna 180G · Delta Junction, AKThe pilot’s failure to maintain a rate of climb sufficient to clear obstacles during takeoff, resulting in a collision with tree-covered terrain.Aug 19, 2025 · N4721U · Substantial damageNTSB ANC25LA090Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Willow, AKThe pilot’s loss of control after a rejected takeoff, which resulted in a noseover.Aug 18, 2025 · N4387Z · Substantial damageNTSB ERA25LA303Accident · Serious injuriesClass 4 · LimitedFinal reportCentrair 101A · Springfield, VTThe pilot’s failure to assemble the glider’s elevator control before takeoff.Aug 16, 2025 · N99KG · Substantial damageNTSB CEN25LA316Accident · Serious injuriesClass 4 · LimitedFinal reportXag P100 PRO · Depew, IAThe pilot’s failure to maintain clearance from the unmanned aircraft system during takeoff.Aug 12, 2025 · N467GE · Substantial damageNTSB WPR25LA247Accident · Minor injuriesClass 4 · LimitedFinal reportAviat A1 · Etna, WYThe pilot’s premature rotation at insufficient airspeed during takeoff to avoid an unexpected animal on the runway, which resulted in a loss of control and subsequent nose-over during the aborted takeoff. Contributing to the accident was the pilot’s excessive…Aug 10, 2025 · N801RA · Substantial damageNTSB ERA25LA291Accident · Minor injuriesClass 4 · LimitedFinal reportBeech 35-C33 · Kingston, TNThe pilot’s failure to maintain directional control during takeoff roll, which resulted in a runway excursion and collision with haybales.Aug 6, 2025 · N500HT · Substantial damageNTSB CEN25LA303Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-400A · Lamoni, IAThe pilot’s failure to maintain airplane control during an aborted takeoff.Aug 3, 2025 · N3157B · Substantial damage