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 CEN21LA243Accident · Serious injuriesClass 3 · LimitedFinal reportPhillips Ralph W Vans RV8 · San Angelo, TXThe loss of engine power due to fuel starvation. Contributing to the accident was the installation of a reduced flow fitting in the fuel line to the carburetor by maintenance personnel.May 27, 2021 · N274CV · Substantial damageNTSB CEN21LA240Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT602 · Trumann, ARThe pilot’s failure to review the weather conditions before the flight, which resulted in a loss of directional control during takeoff due to a sudden change in wind direction and speed associated with an approaching thunderstorm.May 27, 2021 · N602NY · Substantial damageNTSB CEN21LA237Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G164 · Celina, OHA loss of engine power for undetermined reasons.May 27, 2021 · N8376K · Substantial damageNTSB ERA21LA231Accident · Minor injuriesClass 4 · LimitedFinal reportLuscombe 8A · Skaneateles, NYThe pilot’s failure to maintain directional control during the takeoff roll which resulted in a runway excursion and nose-over event.May 24, 2021 · N1331K · Substantial damageNTSB CEN21LA229Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Washington Court House, OHThe pilot's failure to maintain directional control during a soft field takeoff.May 20, 2021 · N15033 · Substantial damageNTSB WPR21LA199Accident · Minor injuriesClass 4 · LimitedFinal reportHarry Crosby RV-6 · Byron, CAThe pilot’s failure to maintain directional control of the airplane during takeoff while operating in gusting wind conditions, which resulted in a runway excursion and subsequent collision with terrain.May 18, 2021 · N16CX · Substantial damageNTSB ANC21LA041Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-105 Special · Palmer, AKThe pilot’s selection of unsuitable terrain for takeoff, which resulted in a loss of control and ground loop.May 13, 2021 · N154T · Substantial damageNTSB WPR21LA195Accident · No injuriesClass 4 · LimitedFinal reportGulfstream American AA-5B · Hillsboro, ORThe pilot’s delayed remediation following an aborted takeoff run, which resulted in a runway overrun and collision with trees.May 12, 2021 · N51LL · Substantial damageNTSB ANC21LA037Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-18-150 · Cold Bay, AKThe pilot’s failure to maintain directional control during takeoff in a gusty crosswind condition.May 7, 2021 · N717DR · Substantial damageNTSB WPR21LA327Accident · No injuriesClass 4 · LimitedFinal reportCessna 180J · Buffalo, WYThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a ground loop and collision with terrain.May 6, 2021 · N7770K · Substantial damageNTSB WPR21LA185Accident · No injuriesClass 4 · LimitedFinal reportMcdonnell Douglas Heli 369FF · Palm Gardens, NVThe pilot’s failure to maintain helicopter control during an encounter with a dust devil shortly after takeoff.May 6, 2021 · N972BW · Substantial damageNTSB WPR21LA180Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 172 · Cuba, NMThe pilot's failure to maintain lateral control during takeoff after an encounter with a gusting wind, which resulted in a wing strike.May 2, 2021 · N9127B · Substantial damageNTSB ERA21LA227Accident · No injuriesClass 4 · LimitedFinal reportCessna 550 · Charleston, SCThe airplane's impact with a deer during takeoff.May 2, 2021 · N803SC · Substantial damageNTSB OPS21LA002Incident · No injuriesClass 3 · LimitedFinal reportAirbus A319-112 · St Petersburg-Clearwater, FLThe air traffic controller’s failure to properly scan the runway and local area, and their general loss of situational awareness, resulting in a near midair collision. Contributing to the incident was the Cessna 337 pilot's poor decision making when he failed…Apr 29, 2021 · N306NV · 2 aircraft · No damageNTSB GAA21WA099Accident · 6 fatalClass 5 · ForeignPiper PA-32-260 · Monterrey, MexicoApr 29, 2021 · N15349 · Substantial damageNTSB ERA21LA199Accident · Serious injuriesClass 4 · LimitedFinal reportMooney M20C · Warwick, NYA loose stand-off clamp which resulted in a throttle assembly malfunction, and the inability of the engine to produce full power during the attempted takeoff.Apr 29, 2021 · N6448U · Substantial damageNTSB GAA21WA095Accident · 1 fatalClass 5 · ForeignCessna 182 · Fundo, VenezuelaApr 25, 2021 · YV2324 · DestroyedNTSB WPR21LA172Accident · No injuriesClass 4 · LimitedFinal reportMichael J Robbins Searey · Friday Harbor, WAPartial loss of engine power due to the detachment of the throttle cable from the carburetor arm, as a result of the pilot’s inadequate maintenance which resulted in an off-airport landing and impact with vegetation.Apr 22, 2021 · N888MJ · Substantial damageNTSB CEN21LA197Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Faribault, MNThe student pilot’s failure to maintain control during takeoff in gusty wind conditions and the flight instructor’s delayed remedial action, which resulted in the airplane colliding with trees and subsequently the ground.Apr 22, 2021 · N7114C · Substantial damageNTSB WPR21LA168Accident · No injuriesClass 4 · LimitedFinal reportDavis Donald M Bushby Mustang II · Maricopa, AZThe pilot’s failure to maintain airplane control during takeoff with a quartering right tailwind.Apr 20, 2021 · N284ND · Substantial damageNTSB WPR21LA162Accident · No injuriesClass 4 · LimitedFinal reportThrush S2R-T660 · Hermiston, ORThe pilot’s loss of directional control due to a blown tire, which resulted in a runway excursion and impact with terrain.Apr 17, 2021 · N51080 · Substantial damageNTSB DCA21WA123IncidentClass 5 · ForeignBoeing 777 · Mexico City,, MexicoApr 13, 2021 · FG-ZNC · No damageNTSB ERA21LA181Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-32R-300 · Stockbridge, GAThe flying pilot’s failure to configure the flaps for a short field takeoff and delayed decision to abort the takeoff, which resulted in a runway overrun.Apr 9, 2021 · N1664H · Substantial damageNTSB ERA21FA178Accident · 1 fatalClass 3 · FieldFinal reportCessna 177B · Great Valley, NYThe pilot’s failure to maintain control during takeoff.Apr 7, 2021 · N24RG · DestroyedNTSB ERA21LA177Accident · No injuriesClass 3 · LimitedFinal reportForisch Edward Bushby Mustang M II · Worcester, MABinding of the left aileron bellcrank push/pull rod, which resulted in an uncommanded right turn.Apr 6, 2021 · N61EF · Substantial damageNTSB ERA21LA173Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-23-250 · Springfield, TNThe flight instructor’s failure to abort the takeoff following a loss of left engine power due to fuel starvation. Also causal was the inadequate maintenance of the left fuel cap by unknown maintenance personnel, which resulted in a blockage of the fuel…Apr 5, 2021 · N5018Y · Substantial damageNTSB ERA21LA170Accident · No injuriesClass 3 · LimitedFinal reportMooney M20C · College Park, MDImproper maintenance of the airplane by its owners and their failure to have qualified maintenance personnel determine the root cause of water infiltration into the fuel system. Also causal was the pilot’s inadequate preflight inspection, which failed to…Apr 3, 2021 · N2953L · Substantial damageNTSB GAA21WA153Incident · No injuriesClass 5 · ForeignPiper PA-34-200T · Tambor, Costa RicaApr 2, 2021 · TI-APINTSB ERA21LA167Accident · No injuriesClass 4 · LimitedFinal reportAyres S2R-G6 · Vienna, GAThe pilot’s improper decision to attempt a takeoff with a quartering tailwind and his failure to reject the takeoff in a timely manner, which resulted in a runway excursion.Mar 31, 2021 · N3299X · DestroyedNTSB WPR21LA146Accident · No injuriesClass 4 · LimitedFinal reportCostruzioni Aeronautiche Tecna P2002 Sierra · Watsonville, CAThe pilot’s inadequate fuel management which resulted in the loss of engine power due to fuel starvation.Mar 28, 2021 · N656DF · Substantial damageNTSB ENG21WA020Incident · No injuriesClass 5 · ForeignBoeing 737 · Jakarta, IndonesiaMar 27, 2021 · PK-YSC · Minor damageNTSB WPR21LA140Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Everett, WAA total loss of engine power during climb, for reasons that could not be determined based on available evidence.Mar 23, 2021 · N2164Z · Substantial damageNTSB ERA21LA396Accident · No injuriesClass 4 · LimitedFinal reportSonex Waiex · Doylestown, PAThe pilot’s failure to maintain a proper glidepath during landing. Contributing to the accident was his failure to ensure the canopy locks were properly configured prior to flight.Mar 22, 2021 · N220JD · Substantial damageNTSB ERA21LA161Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · West Chester, PAThe pilot's failure to maintain directional control during the takeoff roll, which resulted in a runway excursion and impact with airport lights and a hangar.Mar 21, 2021 · N24JN · Substantial damageNTSB CEN21LA160Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Watkins, COThe pilot’s failure to maintain directional control during takeoff and the instructor pilot’s inadequate supervision of the pilot’s takeoff.Mar 17, 2021 · N786CP · Substantial damageNTSB ERA21LA156Accident · Serious injuriesClass 3 · LimitedFinal reportSchempp-Hirth K G MINI-NIMBUS C · Groveland, FLThe pilot’s unsuccessful initial attempt to release from the tow plane at the start of an unstable takeoff roll, which resulted in a runway excursion and collision with a parked vehicle. Contributing to the severity of the accident was the vehicle’s proximity…Mar 16, 2021 · N16MG · Substantial damageNTSB CEN21LA158Accident · Minor injuriesClass 4 · LimitedFinal reportCessna 150H · Paris, TXThe pilot’s decision to takeoff with known obstacles on the runway and his subsequent failure to avoid the windsock on takeoff.Mar 13, 2021 · N50326 · Substantial damageNTSB ERA21LA152Accident · No injuriesClass 3 · LimitedFinal reportCessna 421 · Franklin, NCThe reason for this accident could not be determined based on the available information.Mar 12, 2021 · N80056 · Substantial damageNTSB WPR21LA129Accident · Serious injuriesClass 4 · LimitedFinal reportCubcrafters CC11-160 · Arlington, AZThe pilot’s failure to maintain obstacle clearance during takeoff, which resulted in a collision with a cactus and impact with terrain.Mar 11, 2021 · N38LW · Substantial damageNTSB ENG21WA018IncidentClass 5 · ForeignAirbus A300 · Bogota, ColombiaMar 11, 2021 · YV560T · Minor damageNTSB ANC21LA021Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-20 · Anchorage, AKThe pilot’s failure to maintain directional control during takeoff in gusty tailwind conditions, which resulted in a runway excursion and nose down.Mar 6, 2021 · N7054K · Substantial damageNTSB GAA21WA075Incident · No injuriesClass 5 · ForeignCessna 501 · Odesa, UkraineMar 3, 2021 · YR-CMO · Minor damageNTSB ERA21LA138Accident · Serious injuriesClass 3 · LimitedFinal reportDassault Mirage F1 B · Panama City, FLNose landing gear contact with a raised aircraft arresting system during takeoff, which damaged components of the nose wheel steering system and resulted in an uncommanded left turn and loss of directional control.Feb 25, 2021 · N601AX · Substantial damageNTSB GAA21WA025Accident · Minor injuriesClass 5 · ForeignPiper PA-28-140 · North Cat Cay, BahamasFeb 20, 2021 · N75392 · Substantial damageNTSB WPR21LA113Accident · No injuriesClass 4 · LimitedFinal reportCubcrafter CCK-1865 · Quartzite, AZThe pilot’s failure to maintain airplane control during takeoff while operating in gusting wind conditions, which resulted in a collision with a cactus and the subsequent impact with terrain.Feb 16, 2021 · N53KK · Substantial damageNTSB WPR21LA110Accident · No injuriesClass 3 · LimitedFinal reportDassault FALCON900EX · San Diego, CAThe flight crew’s operation of the airplane outside of the manufacturer’s specified weight and balance limitations and with an improper trim setting, which resulted in the airplane’s inability to rotate during the attempted takeoff. Contributing to the…Feb 13, 2021 · N823RC · Substantial damageNTSB CEN21LA127Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Prairie du Sac, WIThe student pilot’s loss of directional control during takeoff, which resulted in the collision with a snowbank. Contributing to the accident was the compacted snow conditions on the runway surface.Feb 12, 2021 · N3477E · Substantial damageNTSB WPR21LA112Accident · No injuriesClass 4 · LimitedFinal reportMaule M-5-180C · Price, UTThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a ground loop, runway excursion and collision with terrain.Feb 8, 2021 · N62055 · Substantial damageNTSB CEN21LA129Accident · No injuriesClass 3 · LimitedFinal reportColumbia Aircraft Mfg LC42-550FG · Larned, KSThe pilot’s failure to allow sufficient time for the brakes to cool after a previous aborted takeoff, resulting in a runway excursion during a second aborted takeoff due to degraded braking performance. Contributing to the accident was the contact of the hot…Feb 5, 2021 · N115FP · Substantial damageNTSB GAA21WA014Accident · No injuriesClass 5 · ForeignCessna 188 · Viamao, BrazilFeb 1, 2021 · PR-STO · Substantial damage