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 CEN20CA411Accident · Minor injuriesClass 4 · Data collectionFinal reportCessna R182 · Marksville, LAThe pilot’s inadequate preflight inspection, during which he failed to ensure the landing gear handle in the “down” position which resulted in the landing gear retracting during takeoff, a loss of directional control, and a runway excursion.Sep 17, 2020 · N6208T · Substantial damageNTSB WPR20LA324Accident · No injuriesClass 4 · LimitedFinal reportPilatus PC-12/47E · Lake Abert, ORThe pilot’s failure to maintain clearance from an object during the takeoff ground roll due to inadequate monitoring of the environment.Sep 15, 2020 · N1220A · Substantial damageNTSB ANC20CA094Accident · No injuriesClass 4 · Data collectionFinal reportCessna 170 · Kiana, AKThe pilot’s improper decision to perform a takeoff from an unsuitable surface, which resulted in a loss of control and nose over.Sep 13, 2020 · N3068A · Substantial damageNTSB ANC20CA096Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Chitina, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.Sep 12, 2020 · N416RK · Substantial damageNTSB GAA20WA138Incident · No injuriesForeign investigationPiper PA28R · Slagelse, DenmarkThe government of Denmark has notified the NTSB of an accident involving a PIPER PA28R airplane that occurred on September 10, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Denmark's investigation under the…Sep 10, 2020 · OY-BYC · Minor damageNTSB ERA20CA319Accident · No injuriesClass 4 · Data collectionFinal reportRotorway Exec 162F · Kenansville, FLThe pilot’s failure to maintain control of the helicopter during takeoff.Sep 10, 2020 · N57AN · Substantial damageNTSB DCA20WA151Incident · No injuriesClass 5 · ForeignBombardier CL600 2D24 · Gallivare, SwedenSep 10, 2020 · EC-ACD · Minor damageNTSB ANC20CA092Accident · No injuriesClass 4 · Data collectionFinal reportHelio H 295 · Fairbanks, AKThe pilot’s decision to initiate a right turn immediately after departure and his failure to maintain a proper crosswind correction, which resulted in a collision with terrain.Sep 10, 2020 · N68857 · Substantial damageNTSB ERA20LA310Accident · No injuriesClass 3 · LimitedFinal reportRobinson R22 · Fort Myers, FLForeign object damage of the turning tailrotor by a soft-bodied object, which resulted in the sudden stoppage of the tailrotor and the catastrophic failure of the tailrotor assembly and its mount structure.Sep 6, 2020 · N194HC · Substantial damageNTSB ERA20LA311Accident · No injuriesClass 4 · LimitedFinal reportZenith CH650LS · Villa Rica, GAA loss of directional control during the landing roll.Sep 5, 2020 · N232PA · Substantial damageNTSB ERA20CA307Accident · Serious injuriesClass 4 · Data collectionFinal reportCessna 170 · Morrisville, VTThe pilot's failure to maintain directional control and subsequent exceedance of the airplane's critical angle of attack during takeoff, which resulted in an aerodynamic stall and collision with terrain.Sep 3, 2020 · N170JS · Substantial damageNTSB CEN20LA372Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 414 · Ray, MIThe pilot’s loss of directional control on takeoff.Aug 30, 2020 · N698D · Substantial damageNTSB CEN20LA370Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA24 · Bryan, TXA total loss of engine power on takeoff due to fuel starvation.Aug 30, 2020 · N7469P · Substantial damageNTSB ERA20CA303Accident · No injuriesClass 4 · Data collectionFinal reportZenith CH601 · Punta Gorda, FLAn inadvertent opening of the airplane’s canopy on takeoff, which resulted in a loss of control and runway excursion.Aug 29, 2020 · N354DM · Substantial damageNTSB WPR20LA289Accident · 2 fatalClass 3 · LimitedFinal reportBeech A36 · Redding, CAThe pilot’s failure to recognize the airplane’s inadequate takeoff performance given the length of the available runway and to abort the takeoff, which resulted in a runway excursion.Aug 27, 2020 · N1550G · DestroyedNTSB ERA20LA302Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Fletcher, NCA partial loss of engine power for reasons that could not be determined based on available evidence.Aug 27, 2020 · N9341N · Substantial damageNTSB WPR20LA301Accident · 1 fatalClass 3 · LimitedFinal reportLake LA4 · Rawlins, WYThe pilot’s decision to depart despite a known mechanical trim malfunction and with a high-density altitude and the airplane at or above its maximum gross weight.Aug 25, 2020 · N93AB · Substantial damageNTSB WPR20CA297Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Givens Hot Springs, IDPilot's failure to maintain directional control on takeoff.Aug 25, 2020 · N334SC · Substantial damageNTSB GAA20WA141IncidentClass 5 · ForeignRobinson R44 · Gulf of Glyfada, GreeceAug 24, 2020 · N115VC · Minor damageNTSB CEN20LA364Accident · No injuriesClass 3 · LimitedFinal reportGrumman G164 · Ogallala, NEThe total loss of engine power due to a failure of the master connecting rod.Aug 24, 2020 · N2437D · Substantial damageNTSB ERA20CA294Accident · No injuriesClass 4 · Data collectionFinal reportSocata TB200 · Simsbury, CTA runway excursion following an aborted takeoff in tailwind conditions.Aug 22, 2020 · N156BB · Substantial damageNTSB ANC20CA088Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Kotzebue, AKThe pilot's failure to maintain an airspeed conducive to flight during takeoff.Aug 22, 2020 · N9128T · Substantial damageNTSB ANC20CA087Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA22 · Lake Louise, AKThe pilot’s decision to takeoff in shifting winds from a remote unimproved gravel bar, which resulted in a failure to attain an airspeed suitable for flight and a loss of control.Aug 22, 2020 · N3251Z · Substantial damageNTSB CEN20CA359Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA28 · Corsicana, TXThe student pilot did not maintain control of the airplane during the takeoff roll.Aug 21, 2020 · N8267N · Substantial damageNTSB CEN20LA352Accident · 1 fatalClass 3 · LimitedFinal reportBeech 200 · Rockford, ILThe pilot’s failure to maintain airplane control following a reduction of thrust in the left engine during takeoff. The reason for the reduction in thrust could not be determined based on the available evidence.Aug 20, 2020 · N198DM · DestroyedNTSB ERA20LA290Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA32 · Tallahassee, FLA partial loss of engine power on takeoff due to an intermittently blocked fuel injector on the number 3 cylinder.Aug 19, 2020 · N4089R · Substantial damageNTSB CEN20WA439Accident · Serious injuriesClass 4 · ForeignCessna F-172 · Nabern-Teck, GermanyAug 19, 2020 · D-ECKT · Substantial damageNTSB CEN20CA350Accident · No injuriesClass 4 · Data collectionFinal reportCessna 140 · Olustee, OKThe pilot's decision to attempt a takeoff from the middle of the runway in shifting wind conditions, which resulted in an aborted takeoff and runway excursion.Aug 18, 2020 · N2207N · Substantial damageNTSB CEN20CA348Accident · No injuriesClass 4 · Data collectionFinal reportProgressive Aerodyne Searey · League City, TXThe pilot's failure to maintain airplane control during a water takeoff after an encounter with the wake from a boat.Aug 17, 2020 · N502BK · Substantial damageNTSB CEN20LA346Accident · Serious injuriesClass 3 · LimitedFinal reportBeech 36 · San Benito, TXA loss of engine power for a reason that could not be determined.Aug 16, 2020 · N3256V · Substantial damageNTSB CEN20CA344Accident · No injuriesClass 4 · Data collectionFinal reportBeech 35 · White Owl, SDThe pilot's failure to maintain directional control during the takeoff, which resulted in a runway excursion and subsequent impact with an obstacle and terrain.Aug 16, 2020 · N6643Y · Substantial damageNTSB WPR20LA270Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA 14 · Susanville, CAThe pilot’s decision to conduct a steep departure at a high-density altitude and the exceedance of the airplane’s critical angle of attack during a climb, which resulted in an accelerated stall and subsequent loss of control. Contributing to the accident was…Aug 15, 2020 · N91449 · Substantial damageNTSB CEN20LA343Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA18 · Brandon, MNThe partial loss of engine power during takeoff due to carburetor icing.Aug 15, 2020 · N2510H · DestroyedNTSB CEN20LA338Accident · Minor injuriesClass 3 · LimitedFinal reportCessna A185F · Sugar Land, TXA total loss of engine power after takeoff for undetermined reasons, and the pilot’s subsequent exceedance of the airplane’s critical angle of attack during landing, which resulted in an aerodynamic stall.Aug 15, 2020 · N5418E · Substantial damageNTSB WPR20CA265Accident · No injuriesClass 4 · Data collectionFinal reportCessna 180 · Stanley, IDThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a ground loop.Aug 11, 2020 · N9917N · Substantial damageNTSB ERA20LA284Accident · No injuriesClass 3 · LimitedFinal reportRotorsport UK MTOsport 2017 · Springfield, TNThe pilot’s decision to continue the takeoff when the gyroplane’s actual performance failed to match that predicted in his performance planning. Contributing to the accident was the gyrocopter’s insufficient performance for reasons that could not be…Aug 11, 2020 · N615MW · Substantial damageNTSB CEN20CA387Accident · Serious injuriesClass 4 · Data collectionFinal reportPowrachute Airwolf · Casco, MIThe pilot's decision to takeoff towards known obstacles which resulted in an impact with a power line.Aug 11, 2020 · N465JP · Substantial damageNTSB ANC20CA076Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA18 · Wasilla, AKThe pilot's failure to maintain directional control during takeoff in crosswind conditions, which resulted in a runway excursion and collision with trees.Aug 4, 2020 · N82566 · Substantial damageNTSB CEN20LA327Accident · Serious injuriesClass 3 · LimitedFinal reportGrumman G164 · Alicia, ARInadequate maintenance of panel fasteners, which led to a side panel coming loose during takeoff and the pilot having to make a subsequent forced landing to a flooded rice field when the airplane became difficult to control.Aug 3, 2020 · N8105K · Substantial damageNTSB ERA20LA272Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 30 · Alabaster, ALA loss of control and lack of climb performance shortly after takeoff for reasons that could not be determined based on available evidence, resulting in a collision with terrain.Aug 2, 2020 · N7750Y · Substantial damageNTSB WPR20CA275Accident · No injuriesClass 4 · Data collectionFinal reportCessna A185 · Susanville, CAThe pilot's failure to maintain directional control during takeoff with a tailwind, which resulted in a subsequent collapse of the right main landing gear.Aug 1, 2020 · N60934 · Substantial damageNTSB ERA20LA274Accident · No injuriesClass 3 · LimitedFinal reportPiper PA32RT · Honesdale, PAThe pilot’s premature rotation for takeoff, which resulted in a tail strike and subsequent runway excursion. Contributing to the accident was the pilot’s inadequate preflight planning, which failed to accurately determine and account for the effects of…Aug 1, 2020 · N3025L · Substantial damageNTSB CEN20LA321Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Seiling, OKThe pilot’s incorrect takeoff performance calculations and delayed aborted takeoff, which resulted in a runway excursion and collision with trees.Aug 1, 2020 · N9765C · Substantial damageNTSB ERA20CA269Accident · No injuriesClass 4 · Data collectionFinal reportCessna 172 · Hudson, NYThe pilot's failure to maintain directional control during the takeoff, which resulted in a runway excursion and impact with vegetation.Jul 29, 2020 · N6705E · Substantial damageNTSB CEN20CA331Accident · No injuriesClass 4 · Data collectionFinal reportCessna A188 · Hartington, NEThe pilot's failure to ensure that the engine oil cap was installed before takeoff, which resulted in the oil obscuring the pilot’s view through the windshield and necessitated a forced landing on unsuitable terrain. Contributing to the accident were the…Jul 27, 2020 · N9278G · Substantial damageNTSB ANC20CA080Accident · No injuriesClass 4 · Data collectionFinal reportPiper PA 18 · Fairbanks, AKThe pilot's improper decision to depart from an off-airport surface that had standing water, which resulted in a loss of control and impact with terrain.Jul 27, 2020 · N1277A · Substantial damageNTSB DCA20WA137Incident · No injuriesForeign investigationBoeing 737 · Palma, SpainThe government of Spain has notified the NTSB of an accident involving a Boeing 737 airplane that occurred on July 19, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Spain's investigation under the provisions of ICAO…Jul 19, 2020 · EI-EFJ · No damageNTSB ERA20CA252Accident · Minor injuriesClass 4 · Data collectionFinal reportFurlong CA-6 · Manville, NJA loss of directional control on takeoff for undetermined reasons.Jul 14, 2020 · N12LF · Substantial damageNTSB CEN20CA284Accident · No injuriesClass 4 · Data collectionFinal reportBeech 95 55 · Spring, TXExcessive wear of the left brake liners which reduced brake effectiveness resulting in a runway excursion.Jul 14, 2020 · N1332Z · Substantial damageNTSB ERA20CA246Accident · Minor injuriesClass 4 · Data collectionFinal reportPiper PA22 · Cortland, NYThe mechanic’s incorrect rigging of the aileron control cables, which resulted in a reversal of aileron control inputs applied by the pilot during the takeoff. Also causal was the mechanic’s inadequate post-maintenance inspection and the pilot's inadequate…Jul 13, 2020 · N2716P · Substantial damage