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 DCA16WA227Incident · No injuriesForeign investigationBoeing 777 · Abu Dhabi, United Arab EmiratesThe General Civil Aviation Authority (GCAA) of the United Arab Emirates has notified the NTSB of an incident involving a Boeing 777 that occurred on September 27, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the GCAA's investigation…Sep 27, 2016 · A6-ETL · Minor damageNTSB ANC16LA071Accident · No injuriesLimited investigationFinal reportHelio H-295 · Delta Junction, AKThe pilot’s decision to take off from a wet, snowy airstrip and his delayed decision to abort the takeoff, which resulted in a runway excursion.Sep 26, 2016 · N68857 · Substantial damageNTSB GAA16CA526Accident · No injuriesData collectionFinal reportSix Chuter Legend XL · Arcadia, FLThe pilot’s decision to take off in high-density altitude conditions, which resulted in the powered parachute being unable to maintain a sufficient climb rate and its subsequent impact with power lines.Sep 24, 2016 · N149SC · Substantial damageNTSB GAA16CA503Accident · Minor injuriesData collectionFinal reportCessna 185 · Fairbanks, AKThe pilot’s failure to recognize he was taking off with a tailwind and his inadequate compensation for taking off with a tailwind, which led to the airplane’s failure to attain a climb and a subsequent forced landing.Sep 22, 2016 · N5892T · Substantial damageNTSB CEN16FA378Accident · 2 fatalField investigationFinal reportPiper PA 28-235 · Lee's Summit, MOThe pilot's improper control inputs during takeoff, which resulted in the exceedance of the airplane's critical angle of attack and subsequent departure stall, and loss of airplane control.Sep 20, 2016 · N8983W · Substantial damageNTSB ENG16IA037Incident · No injuriesIncident investigationFinal reportAirbus A320 · Miami, FLthe incorrect latching of the #2 Engine Fan Cowl following a routine maintenance check that resulted in separation of the cowl during takeoff.Sep 19, 2016 · P4-AAA · Minor damageNTSB CEN16LA375Accident · No injuriesLimited investigationFinal reportPiper PA 32R-300 · Grants, NMA loss of engine power for reasons that could not be determined based on the available information.Sep 19, 2016 · N4477F · DestroyedNTSB WPR16LA185Accident · Minor injuriesLimited investigationFinal reportHoover David Arnold AR 6 · Reno, NVThe pilot of Race 11’s failure to maintain clearance from Race 1 during takeoff, and the insufficient abort procedures specified within the race rules. Contributing to the accident was the pilot of Race 1’s decision to shut down the engine on the runway and…Sep 18, 2016 · N616DH · 2 aircraft · Substantial damageNTSB GAA16CA499Accident · No injuriesData collectionFinal reportAlex Michael Bantum/Tercel USA TERCEL-GYROPLANE · Blairstown, NJThe student pilot’s incorrect takeoff procedure, which resulted in a loss of main rotor rpm and the subsequent loss of directional control and runway excursion.Sep 17, 2016 · N528WM · Substantial damageNTSB GAA16CA498Accident · No injuriesData collectionFinal reportAirtime Cygnet · Venice, FLThe student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action, which resulted in a runway excursion.Sep 16, 2016 · N145AT · Substantial damageNTSB ANC16LA067Accident · No injuriesLimited investigationFinal reportHelio H 295 · Fairbanks, AKExcessive side loads imposed on the tailwheel A-frame during the takeoff roll, which resulted in a separation of the tailwheel and the subsequent loss of directional control.Sep 16, 2016 · N6464V · Substantial damageNTSB WPR16FA176Accident · Serious injuriesField investigationFinal reportCessna 310N · Wickenburg, AZTotal loss of power to the right engine during takeoff due to a fuel contaminant, which blocked the fuel flow transducer and resulted in fuel starvation to the engine.Sep 9, 2016 · N126P · Substantial damageNTSB GAA16CA477Accident · No injuriesData collectionFinal reportPacific Aerospace 750XL · Warrenton, VAThe pilot's failure to set the wing flaps for takeoff, which resulted in an aerodynamic stall, an aborted takeoff, and a runway overrun.Sep 9, 2016 · N750SS · Substantial damageNTSB GAA16CA478Accident · No injuriesData collectionFinal reportCessna 180 · Clemson, SCThe pilot’s loss of directional control during the takeoff roll, which resulted in a runway excursion.Sep 5, 2016 · N451SW · Substantial damageNTSB GAA16CA486Accident · No injuriesData collectionFinal reportChampion 7GC · Palmer, AKThe pilot’s inadequate preflight inspection and failure to assess the airplane’s fuel quantity before departure, which resulted in fuel exhaustion.Sep 4, 2016 · N4831E · Substantial damageNTSB GAA16CA485Accident · Minor injuriesData collectionFinal reportDormaier Monte R Baby Great Lakes · Mazama, WAThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a runway excursion.Sep 3, 2016 · N110MD · Substantial damageNTSB CEN16FA341Accident · 1 fatalField investigationFinal reportBeech A36 · Bentonville, ARThe pilot's failure to monitor and/or transmit his position over the uncontrolled airport's common traffic advisory frequency, and his decision to continue the takeoff when he observed conflicting traffic on the runway.Aug 31, 2016 · N8283D · DestroyedNTSB DCA16WA228Incident · No injuriesForeign investigationBoeing 777 · London, United KingdomThe Aircraft Accident Investigation Bureau (AAIB) of India has notified the NTSB of an accident involving a Boeing 777 that occurred on August 30, 2016. The NTSB has appointed a U.S. Accredited Representative to assist the AAIB's investigation under the…Aug 30, 2016 · VT-JEK · No damageNTSB CEN16CA359Accident · No injuriesData collectionFinal reportBeech 58 · Wichita Falls, TXThe incorrect maintenance of the airplane's ventilation system which resulted in an obstruction of the elevator control system.Aug 26, 2016 · N15MD · Substantial damageNTSB WPR16LA167Accident · Minor injuriesClass 3 · LimitedFinal reportSiai-Marchetti SF260 · Fullerton, CAThe failure of the pilot to set the flaps to the proper takeoff setting before takeoff, resulting in an aerodynamic stall during takeoff and loss of control.Aug 25, 2016 · N16FD · Substantial damageNTSB ERA16WA310Accident · No injuriesForeign investigationLearjet 55 · Eleuthera, BahamasOn August 25, 2016, about 1903 universal coordinated time, a Learjet 55, N666TK, operated by RCR7 LLC, was substantially damaged during a runway excursion following an aborted takeoff at North Eleuthera Airport, Eleuthera, Bahamas. The two pilots and seven…Aug 25, 2016 · N666TK · Substantial damageNTSB ERA16LA299Accident · Serious injuriesLimited investigationFinal reportProgressive Aerodyne Searey · Sebring, FLA disconnected ground wire during initial climb, which degraded the fuel boost pumps’ performance and resulted in a total loss of engine power due to fuel starvation.Aug 23, 2016 · N801SR · Substantial damageNTSB GAA16CA497Accident · No injuriesData collectionFinal reportCirrus Design SR20 · Brunswick, GAThe total loss of engine power during takeoff due to a loose B-nut on the fuel flow divider input fuel line fitting, which resulted in a fuel leak and fuel starvation.Aug 22, 2016 · N204AK · Substantial damageNTSB ERA16LA305Accident · No injuriesLimited investigationFinal reportDayton A Babcock Storm · Eustis, FLThe pilot's failure to maintain directional control during an aborted takeoff. Contributing to the accident were the loss of engine power due to a malfunctioning alternator, which precipitated the off-field landing, and the pilot’s decision to attempt to take…Aug 20, 2016 · N516VB · Substantial damageNTSB CEN16LA329Accident · Serious injuriesLimited investigationFinal reportCollins RV6A · Pekin, ILThe pilot's failure to latch the canopy before takeoff, and his subsequent distraction and failure to maintain control while attempting to close the open canopy, which resulted in an aerodynamic stall.Aug 18, 2016 · N576RV · Substantial damageNTSB GAA16CA437Accident · No injuriesData collectionFinal reportCessna 152 · Belle Plaine, MNThe student pilot's improper pitch technique after rotation during a short field take off, which resulted in the right wing impacting the ground and a nose gear collapse.Aug 17, 2016 · N631TK · Substantial damageNTSB GAA16CA430Accident · No injuriesData collectionFinal reportPzl-Swidnik PW 6U · Llano, CAThe pilot’s failure to properly secure the two aft canopy latches during the preflight inspection, which resulted in the canopy separating from the glider during the takeoff roll and substantial damage to the vertical stabilizer.Aug 14, 2016 · N212EC · Substantial damageNTSB CEN16LA324Accident · No injuriesLimited investigationFinal reportBellanca 7ECA · Lino Lakes, MNA partial loss of engine power due to the formation of carburetor ice, which resulted in reduced climb capability and impact with vegetation and terrain during takeoff.Aug 14, 2016 · N50437 · Substantial damageNTSB CEN16WA340Accident · 1 fatalForeign investigationQuad City Challenger II · Amos, CanadaOn August 9, 2016, at 1530 UTC, a Quad City Challenger II (S/N CH2-0903-2368), C-IIJW, impacted terrain near the runway end at Amos/Magny Airport (CYEY), Amos, Quebec, Canada. The aircraft was destroyed and sole occupant on board was fatally injured. The…Aug 9, 2016 · C-IIJW · DestroyedNTSB CEN16FA307Accident · 1 fatalField investigationFinal reportWilson BUGATTI-DEMONGE 100P · Burns Flat, OKThe pilot's failure to maintain airspeed following an engine anomaly during the initial climb after takeoff, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was an…Aug 6, 2016 · N110PX · DestroyedNTSB CEN16LA302Accident · Serious injuriesLimited investigationFinal reportSonex Waiex · Fond du Lac, WIA partial loss of engine for reasons that could not be determined during an examination of the engine.Aug 3, 2016 · N12YX · Substantial damageNTSB GAA16CA419Accident · No injuriesData collectionFinal reportCessna 172 · Lewiston, MTThe pilot's failure to ensure that his seat was adjusted and locked, which resulted in his seat sliding aft during the takeoff roll, and the subsequent loss of directional control and runway excursion.Aug 2, 2016 · N734GM · Substantial damageNTSB ERA16CA278Accident · Minor injuriesData collectionFinal reportTrick Trikes Storm · Valkaria, FLThe pilot’s premature rotation during takeoff, which resulted in an aerodynamic stall and a hard landing.Jul 31, 2016 · N4367X · Substantial damageNTSB ANC16CA053Accident · No injuriesData collectionFinal reportCessna U206G · Sleetmute, AKThe pilot's failure to maintain adequate airspeed during the initial climb after taking off from a wet runway and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Jul 31, 2016 · N206JC · Substantial damageNTSB GAA16CA415Accident · No injuriesData collectionFinal reportCessna 172 · Kissimmee, FLThe student pilot's failure to maintain directional control during takeoff.Jul 30, 2016 · N1688C · Substantial damageNTSB CEN16LA293Accident · No injuriesLimited investigationFinal reportBoam Larry Rans S 7 · Oshkosh, WIThe pilot's failure to maintain airplane control on takeoff, which resulted in his remedial action to induce an aerodynamic stall and the subsequent impact with terrain.Jul 30, 2016 · N6271X · Substantial damageNTSB GAA16CA403Accident · No injuriesData collectionFinal reportCessna 172 · Rexburg, IDThe student pilot's failure to retract the flaps during a go-around in high density altitude conditions, resulting in the airplane's inability to climb and a subsequent collision with terrain and nose over.Jul 28, 2016 · N3677S · Substantial damageNTSB GAA16CA394Accident · No injuriesData collectionFinal reportAlon A2 · Alamosa, COThe pilot's failure to maintain aircraft control during takeoff on an uneven runway surface, which resulted in it becoming airborne prematurely, an aerodynamic stall, and impact with terrain.Jul 27, 2016 · N5690F · Substantial damageNTSB GAA16CA395Accident · No injuriesData collectionFinal reportEngineering & Research 415 · Collinsville, OKThe pilot's failure to maintain directional control during takeoff in a high density altitude condition, which resulted in a runway excursion and impact with a tree.Jul 23, 2016 · N2377H · Substantial damageNTSB GAA16CA390Accident · No injuriesData collectionFinal reportPiper PA46 · Claremore, OKThe pilot's failure to maintain directional control during takeoff after multiple climb attempts at insufficient airspeed, which resulted in a runway excursion, a landing gear collapse, and a collision with a ditch.Jul 22, 2016 · N9111P · Substantial damageNTSB WPR16RA151Accident · 5 fatalForeign investigationCessna 208 · Shanghai, ChinaOn July 20, 2016 about 0422 Coordinated Universal Time, a float equipped Cessna 208, B10-FW, collided with a bridge shortly after takeoff from Jinshan City Beach, Shanghai, P.R. China. The airplane was operated by Avic Joy General Aviation under the pertinent…Jul 20, 2016 · B-10FW · Substantial damageNTSB ERA16LA263Accident · No injuriesLimited investigationFinal reportTecnam P2008 · Warrenton, VAThe pilot’s decision to begin the takeoff roll with helicopter traffic on the runway, which led to a rejected takeoff. Contributing to the accident was the pilot’s improper use of the toe brakes, which he had limited experience using and resulted in a runway…Jul 19, 2016 · N615BS · Substantial damageNTSB ANC16LA047Accident · No injuriesLimited investigationFinal reportAeropro CZ A220 · McCarthy, AKThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in a loss of control and impact with terrain. Contributing to the accident were engine power surges due to the bent carburetor throttle valve lever.Jul 19, 2016 · N151J · Substantial damageNTSB WPR16CA145Accident · Minor injuriesData collectionFinal reportBeech 19A · Helena, MTThe pilot's failure to reposition the fuel selector valve to the on position prior to takeoff resulting in a loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to properly complete the pre-takeoff checklist.Jul 18, 2016 · N7645R · Substantial damageNTSB WPR16LA141Accident · Minor injuriesLimited investigationFinal reportLuscombe 8A · Minden, NVThe failure of a main landing gear leg during takeoff due to corrosion, which resulted in a nose-over during the subsequent landing on a grassy area.Jul 17, 2016 · N2759K · Substantial damageNTSB ERA16CA259Accident · Minor injuriesData collectionFinal reportHirn Associates Zodiac CH601XL · Hedgesville, WVThe pilot’s inadvertent activation of the elevator trim, which resulted in a premature takeoff and subsequent loss of airplane control and collision with trees.Jul 17, 2016 · N650WP · Substantial damageNTSB ERA16WA340Accident · Minor injuriesForeign investigationCessna 172 · Valday-avia, RussiaOn July 16, 2016, about 1024 universal coordinated time, a Cessna 172K, Russian registration RA-67480, was substantially damaged when it experienced a runway excursion during takeoff from Valday-Avia Airfield, Valday, Novgorod, Russia. The pilot and two…Jul 16, 2016 · RA-67480 · Substantial damageNTSB CEN16LA267Accident · Minor injuriesLimited investigationFinal reportAeronca 7BCM · Longmont, COThe pilot's decision to continue the takeoff after observing a partial loss of engine power, the reason for which could not be determined because postaccident examination of the airframe and engine revealed no evidence of mechanical malfunctions or failures.Jul 16, 2016 · N2576E · Substantial damageNTSB GAA16CA376Accident · No injuriesData collectionFinal reportCessna 182 · Stevensville, MTThe pilot's failure to maintain adequate clearance from ground equipment during takeoff, which resulted in an impact with irrigation pipes, a loss of directional control, an impact with a fence, and a nose over.Jul 15, 2016 · N9928B · Substantial damageNTSB ANC16WA042Accident · 1 fatalForeign investigationAero Commander B1A · Hoey, CanadaOn July 14, 2016, about 0230 Coordinated Universal Time, an Aero Commander B1A airplane, C-GSQY, lost engine power and impacted terrain after takeoff near Hoey, Saskatchewan, Canada. The pilot sustained fatal injuries. The Transportation Safety Board (TSB) of…Jul 14, 2016 · C-GSQY · Destroyed