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 ERA21LA311Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Martinsburg, WVThe flight instructor’s loss of directional control after an aerodynamic stall at takeoff.Jul 31, 2021 · N805CP · Substantial damageNTSB DCA21WA191Incident · No injuriesClass 5 · ForeignBAE RJ85 · Santa Cruz de la Sierra, BoliviaJul 30, 2021 · CP-2889 · No damageNTSB CEN21LA346Accident · Serious injuriesClass 3 · LimitedFinal reportHpH, Spol. S.R.O. Glasflügel 304S · Briggs, TXThe overstress fracture of the elevator control tube due to reduced wall thickness from water intrusion and subsequent corrosion. Contributing to the accident was the lack of a drain hole at the bottom of the elevator control tube, which allowed the tube to…Jul 30, 2021 · N304AB · Substantial damageNTSB DCA21WA188Incident · No injuriesClass 5 · ForeignBoeing 747 · Zhengzhou City, ChinaJul 28, 2021 · LX-GCL · No damageNTSB ERA21LA371Accident · No injuriesClass 4 · LimitedFinal reportMooney M20K · New Shoreham, RIThe pilot’s improper decision to reject the takeoff at an excessive speed, resulting in a runway excursion and collision with a fence. Contributing to the accident was the pilot’s failure to lock the door as required by the placarded door closing procedures.Jul 27, 2021 · N110CG · Substantial damageNTSB CEN21FA334Accident · 1 fatalClass 3 · FieldFinal reportAir Tractor AT-802 · Benoit, MSThe pilot’s exceedance of the airplane’s takeoff performance capabilities and his failure to abort the takeoff in a timely manner. Contributing to the accident was the pilot’s impairment due to his use of ethanol and prohibited medications.Jul 25, 2021 · N363BG · Substantial damageNTSB WPR21LA345Accident · No injuriesClass 4 · LimitedFinal reportCessna 340 · Rock Springs, WYThe pilot’s improper pitch control during takeoff which resulted in an aerodynamic stall and subsequent hard landingJul 24, 2021 · N419TT · Substantial damageNTSB WPR21LA302Accident · No injuriesClass 4 · LimitedFinal reportPiper J3C-65 · Sandpoint, IDThe pilot’s failure to maintain directional control during landing with a crosswind which, resulted in a runway excursion and impact with terrain.Jul 24, 2021 · N946PD · Substantial damageNTSB CEN21LA337Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA18 · Larimore, NDThe pilot’s loss of control during the initial climb for reasons that could not be determined based on the available information.Jul 24, 2021 · N83411 · Substantial damageNTSB DCA22WA171Incident · No injuriesClass 5 · ForeignEmbraer ERJ190 · Caracas, VenezuelaJul 23, 2021 · YV3052 · No damageNTSB WPR21LA295Accident · No injuriesClass 4 · LimitedFinal reportCessna 172I · Renton, WAThe boat operator’s failure to remain a safe distance from the floatplane during the takeoff run, which resulted in a collision.Jul 21, 2021 · N46287 · Substantial damageNTSB CEN21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 180 · Brenham, TXThe pilot’s failure to maintain control of the airplane during takeoff from a rough field.Jul 19, 2021 · N9024M · Substantial damageNTSB ERA21LA293Accident · Minor injuriesClass 4 · LimitedFinal reportErcoupe 415-C · Frostproof, FLThe pilot’s loss of directional control during takeoff as a result of a child reaching for and manipulating the flight controls.Jul 18, 2021 · N3044H · Substantial damageNTSB ANC21LA061Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172 · Skwentna, AKA partial loss of engine power due to detonation/preignition damage to the No. 2 cylinder. The reason for the detonation/preignition damage could not be determined based on the available evidence.Jul 16, 2021 · N7137T · Substantial damageNTSB WPR21FA272Accident · 4 fatalClass 3 · FieldFinal reportMooney M20J · Dinsmore, CAThe airplane’s degraded engine performance due to wear to the intake cam lobes, which diminished the airplane’s takeoff and climb performance, resulting in a subsequent collision with trees.Jul 15, 2021 · N4474H · DestroyedNTSB ERA21LA329Accident · No injuriesClass 4 · LimitedFinal reportAlexander Schleicher ASW 27-18 · Sterling, MAThe pilot’s failure to maintain the glider’s stability in the roll axis during the takeoff roll, which resulted in a dragged wingtip and ground loop.Jul 15, 2021 · N129MG · Substantial damageNTSB ENG21WA034AccidentClass 5 · ForeignCessna P206 · Kamarang, GuyanaJul 15, 2021 · 8R-DAC · Substantial damageNTSB CEN21LA322Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT502 · Edcouch, TXThe pilot’s inadequate compensation for a gusting wind during takeoff.Jul 15, 2021 · N334LA · Substantial damageNTSB WPR21LA287Accident · Serious injuriesClass 3 · LimitedFinal reportBeech A36TC · Chandler, AZThe pilot’s delayed decision to abort the takeoff due to insufficient airspeed.Jul 10, 2021 · N222HC · Substantial damageNTSB GAA21WA170Accident · 1 fatalClass 5 · ForeignJoplin Tundra · Athens, CanadaJul 10, 2021 · C-IJGB · Substantial damageNTSB CEN21LA315Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 421C · Longmont, COThe loss of performance for reasons that could not be determined.Jul 10, 2021 · N66NC · Substantial damageNTSB ANC21LA057Accident · No injuriesClass 4 · LimitedFinal reportDehavilland DHC-2-L-20 · Coffman Cove, AKThe pilot’s impact with a buoy on takeoff which resulted in a nose-over.Jul 9, 2021 · N9279Z · Substantial damageNTSB ANC21LA053Accident · No injuriesClass 4 · LimitedFinal reportCessna 185 · Kenney Lake, AKThe pilot’s failure to maintain adequate clearance from a tree during takeoff, which resulted in a loss of directional control and impact with terrain.Jul 6, 2021 · N185YT · Substantial damageNTSB GAA21WA165Accident · 2 fatalClass 5 · ForeignIai 1124 · Treasure Cay, BahamasJul 5, 2021 · N790JR · DestroyedNTSB ANC21LA055Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Talkeetna, AKThe pilot’s improper flight control inputs which resulted in a loss of directional control and a nose-over.Jul 4, 2021 · N82547 · Substantial damageNTSB CEN21LA306Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Pottsboro, TXThe airplane’s degraded performance from the rough, grass runway surface and the pilot’s delayed decision to abort the takeoff resulting in a runway excursion.Jul 3, 2021 · N181BW · Substantial damageNTSB ERA21LA281Accident · No injuriesClass 4 · LimitedFinal reportCessna 402A · Fort Lauderdale, FLThe pilot’s loss of directional control during takeoff with a fogged wind screen and sun glare, which resulted in a runway excursion and a collision with a taxiway sign.Jul 2, 2021 · N4550Q · Substantial damageNTSB ANC21LA056Accident · Serious injuriesClass 3 · LimitedFinal reportCessna 170B · North Pole, AKThe pilot’s exceedance of the airplane’s takeoff performance limitations, which prevented the airplane from gaining sufficient altitude to clear the trees off the departure end of the runway.Jul 1, 2021 · N2746D · DestroyedNTSB CEN21FA297Accident · 1 fatalClass 3 · FieldFinal reportEarthstar Gull 2000 · Curtiss, WIThe non-instrument-rated pilot’s decision to depart into instrument meteorological conditions with dense fog and low clouds, which resulted in spatial disorientation and a loss of airplane control. Contributing to the accident was the pilot’s self-imposed…Jun 30, 2021 · N1712L · Substantial damageNTSB WPR21LA252Accident · No injuriesClass 4 · LimitedFinal reportSilverLight AR-1 · Lakeside, ORThe pilot’s inadequate decision to continue the takeoff after sufficient airspeed was not attained and his failure to maintain aircraft control while maneuvering to avoid obstructions, which resulted in a collision with the ground.Jun 29, 2021 · N159WT · Substantial damageNTSB CEN21LA294Accident · No injuriesClass 3 · LimitedFinal reportConsolidated Aeronautics Lake LA-4-200 · Mio, MIThe pilot’s failure to abort the takeoff roll when the engine did not produce full power.Jun 28, 2021 · N963L · Substantial damageNTSB ANC21LA050Accident · No injuriesClass 4 · LimitedFinal reportCessna A185F · Dillingham, AKThe pilot’s failure to maintain directional control during takeoff in gusting wind conditions which resulted in a loss of control and impact with terrain.Jun 28, 2021 · N8216J · Substantial damageNTSB WPR21LA244Accident · No injuriesClass 4 · LimitedFinal reportCessna 182E · Ririe, IDThe pilot’s encounter with a tailwind during takeoff roll, which resulted in an aborted takeoff, collision with a ditch and subsequent nose over.Jun 26, 2021 · N3208Y · Substantial damageNTSB CEN21LA288Accident · No injuriesClass 3 · LimitedFinal reportVining SD1 Minisport · Butler, OHThe pilot’s failure to maintain adequate airspeed following a partial loss of engine power, which resulted in an aerodynamic stall and impact with terrain. The reason for the partial loss of engine power could not be determined based on available information.Jun 23, 2021 · N72DX · Substantial damageNTSB WPR21LA239Accident · No injuriesClass 4 · LimitedFinal reportMooney M20J · West Glacier, MTThe pilot’s inadequate performance planning and decision to continue the takeoff which, resulted in a runway overrun and collision with terrain.Jun 20, 2021 · N5765N · Substantial damageNTSB WPR21FA232Accident · 1 fatalClass 3 · FieldFinal reportKitfox Series 6 · Likely, CAThe pilot’s poor decision making in attempting a takeoff from a field with high vegetation and a high-density altitude, which resulted in decreased takeoff performance and impact with terrain.Jun 20, 2021 · N617Y · Substantial damageNTSB CEN21LA301Accident · No injuriesClass 4 · LimitedFinal reportChristen Industries A-1 · Wilmington, OHThe pilot’s failure to maintain directional control during takeoff with gusting winds, which resulted in an inflight collision with a fence.Jun 20, 2021 · N2932W · Substantial damageNTSB ERA21LA314Accident · No injuriesClass 4 · LimitedFinal reportCessna 172S · Clarksville, TNThe flight instructor’s inadequate remedial action during takeoff, which resulted in a runway excursion.Jun 17, 2021 · N35585 · Substantial damageNTSB WPR21FA227Accident · 1 fatalClass 3 · FieldFinal reportCovey Tri Quickie · Gila Bend, AZThe pilot’s exceedance of the airplane’s critical angle of attack during the takeoff initial climb, which resulted in an aerodynamic stall and loss of airplane control. Contributing to the accident was the reduced airplane performance due to high density…Jun 15, 2021 · N8054Y · DestroyedNTSB CEN21LA269Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Corpus Christi, TXThe pilot’s failure to maintain directional control during the takeoff roll.Jun 14, 2021 · N7476J · Substantial damageNTSB WPR21LA226Accident · No injuriesClass 4 · LimitedFinal reportCessna 170B · Miles City, MTThe pilot’s failure to maintain directional control during takeoff which resulted in a ground loop and collision with terrain.Jun 11, 2021 · N2218B · Substantial damageNTSB DCA21WA154IncidentClass 5 · ForeignBoeing 777 · London, United KingdomJun 11, 2021 · G-YMMR · No damageNTSB CEN21LA262Accident · Serious injuriesClass 4 · LimitedFinal reportCessna 150H · Muncie, INThe non-certificated pilot's failure to maintain aircraft control on departure in high density altitude conditions which resulted in an aerodynamic stall.Jun 11, 2021 · UNREG · Substantial damageNTSB CEN21LA284Accident · No injuriesClass 3 · LimitedFinal reportRobinson Helicopter R44 II · Reserve, LAA total loss of engine power for undetermined reasons.Jun 10, 2021 · N202SM · Substantial damageNTSB WPR21FA223Accident · 1 fatalClass 3 · FieldFinal reportVans RV6 · Porterville, CAA loss of engine power for reasons that could not be determined based on available information.Jun 7, 2021 · N94PJ · DestroyedNTSB CEN21LA254Accident · Minor injuriesClass 3 · LimitedFinal reportAir Tractor AT-602 · Drew, MSA loss of control during takeoff for reasons that could not be determined.Jun 4, 2021 · N51037 · Substantial damageNTSB CEN21LA257Accident · No injuriesClass 3 · LimitedFinal reportQuad City Challenger · Wallingford, IAImpact with trees and terrain during takeoff for reasons that could not be determined based on the available information.Jun 2, 2021 · N3281P · Substantial damageNTSB CEN21LA242Accident · Minor injuriesClass 3 · LimitedFinal reportPiper J4A · Omaha, NEA total loss of engine power due to a blocked fuel tank cap vent hole, which resulted in fuel starvation. Contributing to the accident was the mechanic’s and the pilot’s inadequate inspections of the fuel tank cap.May 30, 2021 · N8501Z · Substantial damageNTSB WPR21LA218Accident · Minor injuriesClass 4 · LimitedFinal reportBeech A36 · Sulphur Creek, IDThe pilot’s inability to maintain airplane control during takeoff when the airplane encountered a tailwind and gusting winds which resulted in an aborted takeoff and forced landing to rough terrain.May 28, 2021 · N8140G · Substantial damageNTSB ANC21LA044Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Perryville, AKThe airplane’s encounter with windshear on takeoff, which resulted in a loss of control and impact with the ground.May 28, 2021 · N4323Z · Substantial damage