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 GAA15CA075Accident · Minor injuriesData collectionFinal reportHead Balloons AX8 105 - NO Series · Intercourse, PAThe pilot's selection of unsuitable terrain/location for takeoff in gusting wind conditions, resulting in a collision with a building, and substantial damage to the hot air balloon.Apr 12, 2015 · N3099F · Substantial damageNTSB WPR15FA143Accident · 4 fatalField investigationFinal reportCessna T210M · Challis, IDThe pilot's attempt to depart in conditions that resulted in the airplane having insufficient performance capability, which resulted in a collision with a tree.Apr 10, 2015 · N732YQ · Substantial damageNTSB CEN15CA197Accident · No injuriesData collectionFinal reportRennicke Midget Musta MM1 · Longmont, COThe pilot's failure attain/maintain pitch control prior to attaining a proper takeoff speed during takeoff roll, which resulted in a premature liftoff of the airplane and loss of control.Apr 10, 2015 · N824C · Substantial damageNTSB ERA15LA177Accident · No injuriesLimited investigationFinal reportMooney M20J · Allentown, PAA total loss of engine power during takeoff due to an interruption of fuel flow to the engine. The reason for the interruption of the fuel flow could not be determined during postaccident examination and testing.Apr 6, 2015 · N4826H · Substantial damageNTSB WPR15LA139Accident · No injuriesLimited investigationFinal reportBeech H35 · Tucson, AZA partial loss of engine power during initial takeoff climb for reasons that could not be determined because postaccident examination revealed no evidence of a mechanical anomaly that would have precluded normal operation.Mar 30, 2015 · N112F · Substantial damageNTSB ERA15FA171Accident · 2 fatalField investigationFinal reportPiper PA28 · West Chester, PAThe failure of the flight instructor and the pilot to abort the takeoff after the airplane experienced a partial loss of engine power with adequate runway remaining, and their subsequent failure to maintain adequate airspeed, which led to the airplane…Mar 29, 2015 · N6842W · DestroyedNTSB CEN15WA186Accident · 1 fatalForeign investigationRobinson R44 - II · Modrava, CzechiaOn March 29, 2015, at 0920 universal coordinated time (UTC), a Robinson model R44 Raven II helicopter, Czech Republic registration OK-RRJ, serial number 12464, sustained substantial damage when it collided with wooded terrain within Šumava National Park, near…Mar 29, 2015 · OK-RRJ · Substantial damageNTSB CEN15FA181Accident · 2 fatalField investigationFinal reportPiper J-4A · Pine River, MNThe pilot' failure to maintain adequate airspeed after takeoff, which resulted in the airplane's wing exceeding its critical angle-of-attack and a subsequent aerodynamic stall. Contributing to the accident was the pilot's decision to conduct the flight…Mar 28, 2015 · N30341 · Substantial damageNTSB CEN15CA184Accident · No injuriesData collectionFinal reportCessna T188C · Burdett, KSThe pilot did not maintain directional control of the airplane in gusting wind conditions.Mar 28, 2015 · N2093J · Substantial damageNTSB GAA15LA025Accident · Serious injuriesLimited investigationFinal reportSpaulding Errol Rans S 7 Courier · Pinedale, WYThe pilot’s decision to take off in a crosswind that exceeded the airplane’s maximum demonstrated crosswind capability and his subsequent inability to maintain directional control.Mar 27, 2015 · N4272M · Substantial damageNTSB CEN15LA206Accident · Serious injuriesLimited investigationFinal reportPiper PA 32R-301T · Stephenville, TXThe partial loss of engine power after takeoff for undetermined reasons, which necessitated a forced landing, during which the airplane impacted trees and a power line.Mar 27, 2015 · N9284 · Substantial damageNTSB GAA15CA014Accident · No injuriesData collectionFinal reportCostruzioni Aeronautiche Tecna P92 Eaglet · Cambridge, MDThe pilot's failure to maintain directional control during takeoff.Mar 19, 2015 · N731HG · Substantial damageNTSB WPR15FA125Accident · 1 fatalField investigationFinal reportBAE Systems MK-67 Hawk · Yuma, AZThe pilot’s initiation of an early rotation during takeoff, which led to an aerodynamic stall and loss of airplane control. Contributing to the accident were the pilot's use of nose up pitch trim and the operator's policy to use nose-up pitch trim during…Mar 11, 2015 · N506XX · Substantial damageNTSB ERA15CA152Accident · No injuriesData collectionFinal reportCessna 182L · Waycross, GAThe pilot's failure to use any airport guidance while taxiing, which resulted in geographic disorientation and a takeoff attempt from an inadequate length and unsuitable surface.Mar 10, 2015 · N42667 · Substantial damageNTSB ANC15CA014Accident · No injuriesData collectionFinal reportPiper PA18 - 150 · Talkeetna, AKThe pilot's failure to maintain control of the airplane during takeoff from an icy surface in gusty wind conditions.Mar 8, 2015 · N5348T · Substantial damageNTSB CEN15CA158Accident · Minor injuriesData collectionFinal reportPiper PA 28-140 · Kansas City, MOThe loss of engine power due to fuel starvation.Mar 2, 2015 · N1513J · Substantial damageNTSB CEN15CA165Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Lee's Summit, MOThe pilot-receiving-instruction's excessive pitch control during takeoff, which resulted in an aerodynamic stall shortly after liftoff and the subsequent loss of control. Contributing to the accident was the flight crew's decision to have the flight…Mar 1, 2015 · N3575X · Substantial damageNTSB DCA15WA075Accident · No injuriesForeign investigationBoeing 747 - 468 · Jeddah, Saudi ArabiaThe Aviation Investigation Bureau of the Kingdom of Saudi Arabia has notified the NTSB of an accident involving a Boeing 747-400, which occurred on February 25, 2015. The NTSB has appointed a U.S. Accredited Representative to assist the investigation under…Feb 25, 2015 · HZ-AIXNTSB WPR15LA111Accident · 1 fatalLimited investigationFinal reportPiper PA46 - 350P · Spokane, WAA total loss of engine power due to the refueler’s incorrect refueling of the airplane. Contributing to the accident was the fixed-base operator’s improper fueling nozzle, which facilitated the use of an incorrect fuel, and the pilot’s inadequate preflight…Feb 22, 2015 · CGVZW · DestroyedNTSB CEN15LA149Accident · No injuriesLimited investigationFinal reportPiper PA 32RT-300T · Lubbock, TXThe pilot's delayed decision to abort the takeoff after the airplane did not lift off as expected due to an inaccurate airspeed indication and tailwind condition, which resulted in a subsequent runway overrun.Feb 20, 2015 · N22267 · Substantial damageNTSB ERA15LA134Accident · No injuriesLimited investigationFinal reportCirrus Design SR22 · Lexington, KYMaintenance personnel's failure to properly inspect and clean the engine ignition harness spark plug terminals, which resulted in a partial loss of engine power during an attempted takeoff.Feb 19, 2015 · N358CD · Substantial damageNTSB OPS15IA011Incident · No injuriesIncident investigationFinal reportEmbraer EMB 145LR · Chicago, ILThe flight crew's failure to manage cockpit tasks during taxi resulting in a loss of situation awareness and subsequently taxiing past a required turn point and onto an active runway without clearance. Contributing to the runway incursion was the ground…Feb 18, 2015 · N698CB · 2 aircraft · No damageNTSB ENG15RA015Incident · No injuriesForeign investigationBoeing 767 - 204ER · Islamabad, Pakistan, PakistanOn February 15, 2015, a Jordan Air Boeing 767-204ER, leased by Shaheen Air International (SAI), experienced a failure of the No. 1 engine, a General Electric CF6-80A2 turbofan engine, during the takeoff roll from the Islamabad International Airport (ISB),…Feb 17, 2015 · JY-JAG · Minor damageNTSB CEN15LA144Accident · No injuriesLimited investigationFinal reportBeech 58 · Denver, COThe pilot’s failure to maintain airplane control during a rejected takeoff from a slush-covered runway at night.Feb 16, 2015 · N297AT · Substantial damageNTSB ERA15LA138Accident · No injuriesLimited investigationFinal reportBell 206 · Sevierville, TNAn uncontained engine failure, which resulted from insufficient lubrication of the No. 4 bearing due to carbon buildup on the filter screen of the bearing's oil supply nozzle.Feb 15, 2015 · N3176L · Substantial damageNTSB CEN15WA150Accident · Minor injuriesForeign investigationPiper PA46 500TP · Björnön, SwedenFeb 15, 2015 · N164ST · Substantial damageNTSB WPR15LA113Accident · No injuriesLimited investigationFinal reportMooney M20E - NO Series · Bakersfield, CAThe collapse of all three landing gear during the takeoff roll for reasons that could not be determined because postaccident examination did not reveal any anomalies that would have precluded normal operation.Feb 14, 2015 · N11LV · Substantial damageNTSB ERA15FA129Accident · 4 fatalField investigationFinal reportBeech 1900 · Miami, FLThe left engine propeller's uncommanded travel to the feathered position during takeoff for reasons that could not be determined due to impact damage. Contributing to the accident was the flight crew's failure to establish a coordinated climb once the left…Feb 11, 2015 · YV1674 · DestroyedNTSB ERA15LA123Accident · Serious injuriesLimited investigationFinal reportAmerican AA-1 · Fort Meade, MDThe mechanic’s failure to detect the incorrect dry valve tappet clearances while troubleshooting ongoing engine issues, which resulted in partial loss of engine power during takeoff. Contributing to the partial loss of engine power was the mechanic's failure…Feb 8, 2015 · N6116L · Substantial damageNTSB CEN15IA139Incident · No injuriesIncident investigationFinal reportGulfstream Aerospace G IV · Eagle, COThe pilot's rejected takeoff due to perceived flight control system anomalies, which led to excessive brake temperatures and resulted in a right main landing gear brake fire.Feb 8, 2015 · N701DB · Minor damageNTSB CEN15LA138Accident · No injuriesLimited investigationFinal reportAir Tractor AT 602 · Slaton, TXMaintenance personnel’s improper installation of the engine data monitor (EDM), which was not in accordance with the supplemental type certificate instructions and resulted in engine warning indications and the pilot’s subsequent reaction to the warning…Feb 5, 2015 · N602PB · Substantial damageNTSB ERA15CA121Accident · No injuriesData collectionFinal reportAutogyro Calidus · Crozet, VAThe pilot's improper control inputs which resulted in a loss of control and rollover during the takeoff roll.Feb 4, 2015 · N595X · Substantial damageNTSB DCA15RA059Accident · 43 fatalForeign investigationATR 72 · Taipei, TaiwanimportFeb 4, 2015 · B-22816 · DestroyedNTSB CEN15WA133Accident · 1 fatalForeign investigationPiper PA 46 350P · Meyrin, SwitzerlandJan 30, 2015 · N246PR · DestroyedNTSB WPR15CA097Accident · No injuriesData collectionFinal reportSchneider Richard J Alaskan Bushmaster · Newburg, ORThe pilot's failure to maintain directional control during the takeoff roll into sunlight, which restricted his visibility.Jan 29, 2015 · N36NC · Substantial damageNTSB WPR15CA094Accident · No injuriesData collectionFinal reportDiamond Aircraft Ind DA 40 · La Verne, CAThe student pilot's loss of directional control during takeoff from a runway, which resulted in a collision with a sign.Jan 27, 2015 · N805ER · Substantial damageNTSB ANC15LA008Accident · No injuriesLimited investigationFinal reportCessna 170B · Anchorage, AKThe pilot’s loss of directional control during takeoff, which resulted in a runway excursion.Jan 21, 2015 · N2580D · Substantial damageNTSB CEN15LA099Accident · No injuriesLimited investigationFinal reportCessna 195B · Llano, TXThe pilot’s overrotation of the airplane when lifting the tail during the takeoff roll, which allowed the propeller to come in contact with the runway and resulted in a reduction in engine power and the pilot’s subsequent loss of directional control.Jan 6, 2015 · N2125C · Substantial damageNTSB CEN15CA097Accident · No injuriesData collectionFinal reportCessna 172M · Marquette, MIThe pilot did not maintain directional control during takeoff on the snow and ice covered runway in gusting crosswind conditions.Jan 5, 2015 · N6591H · Substantial damageNTSB WPR15CA073Accident · Minor injuriesData collectionFinal reportCessna 140 · Yuma, AZThe pilot's failure to compensate for crosswind conditions during takeoff, which resulted in the loss of directional control and collision with terrain.Jan 1, 2015 · N2841N · Substantial damageNTSB CEN15FA088Accident · 1 fatalField investigationFinal reportPiper PA 23-160 · Port Clinton, OHThe pilot's loss of control following a loss of left engine power for reasons that could not be determined because an examination of the airframe and engine did not reveal any preimpact abnormalities.Dec 29, 2014 · N222CP · DestroyedNTSB WPR15LA067Accident · Serious injuriesLimited investigationFinal reportFarthing James W II Beaver · Perris, CAThe partial loss of engine power during takeoff due to an improperly configured carburetor and fuel supply system. Contributing to the accident was the pilot's loss of airplane control during the off-field landing, which resulted in an aerodynamic stall.Dec 21, 2014 · N105JF · Substantial damageNTSB WPR15CA066Accident · No injuriesData collectionFinal reportFerdon Thorp T 18 · San Rafael, CAThe pilot's delayed decision to abort the takeoff. Contributing to the accident are an inadequate modification to the seat position, and the pilot's failure to check flight controls for freedom and correct movement.Dec 20, 2014 · N25VP · Substantial damageNTSB ANC15IA006Incident · No injuriesIncident investigationFinal reportCessna 180J · Nome, AKThe disengagement and subsequent binding of the right tailwheel steering cable, which disabled the rudder system.Dec 20, 2014 · N393B · Minor damageNTSB DCA15RA045Incident · No injuriesForeign investigationBoeing 757 - 236 · Warsaw, PolandThe State Commission on Aircraft Accident Investigation (SCAAI) of Poland has notified the NTSB of an incident involving a Boeing 757-236 that occurred on December 17, 2014. The NTSB has appointed a U.S. Accredited Representative to assist the SCAAI of…Dec 17, 2014 · DALED · No damageNTSB ERA15LA075Accident · 1 fatalLimited investigationFinal reportJohnson David Earl Renegade Spirit · Brunswick, GAThe pilot's decision to fly the airplane with known engine deficiencies and his subsequent exceedance of the airplane's critical angle of attack following a loss of engine power, which resulted in an aerodynamic stall and loss of control after takeoff.Dec 13, 2014 · N955R · Substantial damageNTSB WPR15LA052Accident · Minor injuriesLimited investigationFinal reportNanchang CJ-6 · Mesa, AZThe total loss of engine power during takeoff following a touch-and-go landing for reasons that could not be determined because postaccident examination of the engine did not reveal any anomalies that would have precluded normal operation.Dec 2, 2014 · N4350D · Substantial damageNTSB ERA15FA066Accident · 1 fatalField investigationFinal reportPiper PA28 · Sommerville, TNThe noninstrument-rated pilot's improper decision to attempt visual flight in instrument meteorological conditions, which resulted in an in-flight loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s impaired…Dec 2, 2014 · N8607W · DestroyedNTSB CEN15LA063Accident · Serious injuriesLimited investigationFinal reportSiegel Gerald Long EZ · McGregor, TXA loss of engine power during takeoff due to excessive debris in the fuel system.Nov 30, 2014 · N7015T · Substantial damageNTSB CEN15WA080Accident · No injuriesForeign investigationGulfstream Aerospace G 1159A · London, United KingdomNov 24, 2014 · N103CD · Substantial damage