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 CEN17LA303Accident · No injuriesLimited investigationFinal reportCessna A188B · Marshall, MOThe pilot's inability to accurately monitor the airplane's airspeed after takeoff due to an inoperative airspeed indicator, which resulted in the pilot's failure to maintain adequate airspeed and his exceedance of the airplane's critical angle of attack and…Aug 4, 2017 · N3047J · Substantial damageNTSB CEN17LA312Accident · No injuriesLimited investigationFinal reportRalph Marine Devil DOG · Danville, ARA separation of the left tire from its wheel because of the use of an improper substance and wheel size, which resulted in a loss of directional control during landing.Aug 3, 2017 · N165AB · Substantial damageNTSB ERA17LA263Accident · Minor injuriesLimited investigationFinal reportSikorsky S-97A · Jupiter, FLA design change in the helicopter's fly-by-wire control system that resulted in an increase in the sensitivity of the cyclic stick while transitioning from ground to flight mode, magnifying the pilot's control inputs, which resulted in unintentional over…Aug 2, 2017 · N971SK · Substantial damageNTSB CEN17RA377Accident · Minor injuriesForeign investigationMcdonnell Douglas MD900 · Heiligenblut, AustriaOn August 1, 2017, at 1815 UTC, a McDonnell Douglas MD 900 Helicopter, Austrian registration OE-XWF, impacted mountainous terrain about 8 miles west-northwest of Heiligenblut, Austria. One medical crewmember sustained minor injuries. The pilot, the other…Aug 1, 2017 · OE-XWF · Substantial damageNTSB GAA17CA450Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R44 · Dunlap, ILThe pilot’s failure to visually confirm that the helicopter was disconnected from hoses during refueling operations. Contributing to the accident was the pilot’s and ground crew’s misunderstanding of the hand signals.Jul 31, 2017 · N344MM · Substantial damageNTSB CEN17LA293Accident · Serious injuriesLimited investigationFinal reportChapman T-BIRD II · Potosi, MOThe pilot's loss of airplane control during a departure turn for reasons that could not be determined.Jul 31, 2017 · N204BC · Substantial damageNTSB GAA17CA480Accident · No injuriesData collectionFinal reportThomas J Hankamp VAN'S Aircraft RV4 · Poughkeepsie, NYThe pilot’s failure to maintain directional control during takeoff.Jul 28, 2017 · N9214 · Substantial damageNTSB CEN17FA287Accident · 2 fatalField investigationFinal reportAerofab Lake LA 4 250 · Oshkosh, WIThe pilot's failure to properly configure the airplane for takeoff and his decision to takeoff with a tailwind in unfavorable water conditions, which resulted in the airplane entering an aerodynamic stall and the pilot losing control.Jul 28, 2017 · N1400P · Substantial damageNTSB WPR17LA167Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Santa Ana, CAThe pilot's failure to maintain helicopter control while maneuvering during takeoff.Jul 27, 2017 · N7535G · Substantial damageNTSB CEN17WA291Incident · No injuriesForeign investigationCessna 402 · British Virgin Islands, British Virgin IslandsOn July 27, 2017, a Cessna 402C airplane, N618CA, exited the prepared surface during an aborted takeoff at the Terrance B. Lettsome International Airport, British Virgin Islands. The pilots and occupants were not injured and the airplane was not damaged.The…Jul 27, 2017 · N618CA · No damageNTSB WPR17LA164Accident · No injuriesLimited investigationFinal reportPiper PA 28R-180 · San Jose, CAMaintenance personnel's incorrect installation of the aileron control cables and subsequent failure to verify proper aileron functionality following the maintenance, which resulted in roll control that was opposite of that commanded by the pilot, and the…Jul 23, 2017 · N4594J · Substantial damageNTSB GAA17CA440Accident · No injuriesData collectionFinal reportMitchell Derryle V Rans S 7 Courier · Cordova, AKThe pilot’s improper decision to take off from a lake in gusting wind conditions, which resulted in a loss of airplane control.Jul 23, 2017 · N6333Y · Substantial damageNTSB GAA17CA429Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Edgartown, MAThe airplane’s collision with geese during the takeoff roll.Jul 23, 2017 · N831SR · Substantial damageNTSB WPR17LA160Accident · No injuriesLimited investigationFinal reportCessna 182L · Arbuckle, CAThe pilot’s delayed decision to abort the takeoff and his failure to properly conduct a rejected takeoff, which resulted in a runway overrun.Jul 22, 2017 · N42143 · Substantial damageNTSB GAA17CA439Accident · No injuriesData collectionFinal reportCessna A185 · Arctic Village, AKThe pilot’s failure to maintain directional control after an aborted takeoff.Jul 22, 2017 · N5227R · Substantial damageNTSB GAA17CA435Accident · No injuriesData collectionFinal reportGilbert Thomas Jeffrey Lancair 235 · Denison, TXThe pilot’s failure to maintain directional control during the takeoff roll.Jul 22, 2017 · N91JG · Substantial damageNTSB GAA17CA433Accident · No injuriesData collectionFinal reportStinson SR9 · Bode, IAThe pilot’s decision to take off from an unimproved bean field with insufficient length for the airplane to clear adjacent corn stalks.Jul 22, 2017 · N83K · Substantial damageNTSB GAA17CA574Accident · No injuriesData collectionFinal reportCessna 208 · New York, NYThe airplane’s encounter with boat wake and multiple swells during a water takeoff.Jul 21, 2017 · N802TW · Substantial damageNTSB DCA17WA157Incident · No injuriesForeign investigationBoeing 737-86J · Belfast, United KingdomThe United Kingdom AAIB has notified the NTSB of an incident involving a Boeing 737-86J airplane that occurred on July 21, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the United Kingdom's investigation under the provisions of ICAO…Jul 21, 2017 · C-FWGHNTSB ANC17CA038Accident · No injuriesData collectionFinal reportDehavilland DHC 2 · Dilllingham, AKThe pilot's failure to set the wing flaps to the "takeoff" position, which resulted in a longer-than-normal takeoff run and collision with terrain.Jul 21, 2017 · N364RA · Substantial damageNTSB GAA17CA424Accident · Minor injuriesData collectionFinal reportSalerno Kenneth G JR Kitfox Series 7 · Owyhee, ORThe pilot's failure to maintain directional control during takeoff from a rough, dirt airstrip.Jul 18, 2017 · N702KF · Substantial damageNTSB CEN17LA275Accident · Minor injuriesLimited investigationFinal reportGolden Circle Air T-BIRD II · Dunn Center, NDThe pilot's failure to maintain airplane control, his inadequate quartering tailwind correction during takeoff, and his decision to continue the takeoff to the south with insufficient road length remaining.Jul 18, 2017 · UNREG · Substantial damageNTSB DCA17WA166Incident · No injuriesForeign investigationBoeing 747-87UF · Narita, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of a serious incident involving a BOEING 747-87UF airplane that occurred on July 15, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation…Jul 15, 2017 · N852GT · Minor damageNTSB CEN17LA274Accident · No injuriesLimited investigationFinal reportEndler Glasair/Glasair 1-Td SH2 · Colorado Springs, COThe pilot's failure to lock the castering tailwheel in accordance with the airplane Owner's Manual and a checklist item and to abort the takeoff after the airplane exceeded its normal takeoff distance and/or reached the limit of the rudder control authority…Jul 15, 2017 · N181AL · DestroyedNTSB GAA17CA407Accident · No injuriesData collectionFinal reportGerald Donovan Rans S-16 · Los Lunas, NMThe pilot's failure to maintain directional control during takeoff.Jul 12, 2017 · N116GD · Substantial damageNTSB GAA17CA403Accident · No injuriesData collectionFinal reportLuscombe 8 · Grand Island, NEThe student pilot’s failure to maintain directional control during the takeoff roll and the flight instructor’s delayed remedial action.Jul 6, 2017 · N45609 · Substantial damageNTSB ERA17WA228Accident · 1 fatalForeign investigationBell 206 · Republic of Buryatia, RussiaThe government of Russia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on July 05, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of…Jul 5, 2017 · RA-01625 · Substantial damageNTSB CEN17LA257Accident · No injuriesLimited investigationFinal reportCessna 182T · Jackson, MIThe pilot's failure to maintain pitch control during the takeoff roll during an attempted takeoff. Contributing to the accident was the pilot's selection of takeoff flaps after he began the takeoff roll.Jul 5, 2017 · CGBFY · Substantial damageNTSB GAA17CA383Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Easton, PAThe pilot’s distraction during liftoff due to the tail rotor chip warning light illuminating, which resulted in the helicopter drifting right, the skid touching down, and a dynamic roll-over.Jul 4, 2017 · N3025J · Substantial damageNTSB ERA17WA238Accident · 4 fatalForeign investigationCessna 210M · Cantá Municipality, State, BrazilOn July 3, 2017, about 1500 universal time coordinated, a Cessna 210M, Brazilian registration PR-MFR, was destroyed when it impacted terrain near Canta Municipality, State of Roraima, Brazil. The pilot and three passengers were fatally injured and one…Jul 3, 2017 · PR-MFR · Substantial damageNTSB ERA17LA225Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 15 · Farmville, VAThe pilot’s improper decision to depart from an unsuitable off-airport surface which resulted in his subsequent exceedance of the airplane's critical angle of attack, an aerodynamic stall and loss of control.Jul 3, 2017 · N4195H · DestroyedNTSB CEN17LA251Accident · No injuriesLimited investigationFinal reportCody Hawkins JA30 Superstol · Ponca City, OKContamination of the fuel system, resulting in a partial loss of engine power and subsequent off-airport landing.Jul 2, 2017 · N2463H · Substantial damageNTSB CEN17WA262Incident · No injuriesForeign investigationEmbraer ERJ190 · Mérida, Yucatán, MexicoOn June 30, 2017, at 2133 universal coordinated time, an Embraer ERJ190 airplane, XA-GAH, experienced an engine problem and returned to the Manuel Crescencio Rejón International Airport (MMMD), Mérida, Yucatán. The aircrew performed a precautionary landing…Jun 30, 2017 · XA-GAH · Minor damageNTSB GAA17CA370Accident · Minor injuriesData collectionFinal reportAero-Ace CE 1 · Cottonwood, AZThe pilot’s failure to maintain directional control during takeoff in gusting crosswind conditions.Jun 26, 2017 · N473CQ · Substantial damageNTSB ERA17LA217Accident · No injuriesLimited investigationFinal reportBarnes Richard B/Howe Michael Vans RV 10 · Blairsville, GAThe pilot’s loss of directional control upon landing.Jun 26, 2017 · N865HB · Substantial damageNTSB CEN17LA238Accident · Serious injuriesLimited investigationFinal reportAeronca 7BCM · Mahnomen, MNThe pilot’s failure to abort the takeoff after recognizing a partial loss of engine power during the takeoff roll and his subsequent inability to maintain adequate airspeed during a turn to avoid power lines, which resulted in an aerodynamic stall. The…Jun 21, 2017 · N2558E · Substantial damageNTSB GAA17CA358Accident · No injuriesData collectionFinal reportVans RV-12 · Eugene, ORThe student pilot’s failure to maintain directional control during takeoff.Jun 20, 2017 · N234VA · Substantial damageNTSB GAA17CA350Accident · No injuriesData collectionFinal reportWard Christopher Barry RAI 6 · Williston, FLThe pilot’s failure to maintain the airplane’s pitch control during rotation and his subsequent loss of directional control.Jun 18, 2017 · N251CW · Substantial damageNTSB ANC17LA032Accident · Minor injuriesClass 2 · LimitedFinal reportDehavilland DHC-2 · Ketchikan, AKThe pilot's misjudgment of the takeoff distance needed to depart the lake, and his subsequent failure to maintain clearance from the water during a turn to avoid terrain, which resulted in impact with water.Jun 18, 2017 · N930TG · Substantial damageNTSB GAA17CA359Accident · No injuriesData collectionFinal reportCessna A188 · Salem, ORThe pilot’s failure to maintain directional control during the takeoff roll, which resulted in the airplane contacting tall grass.Jun 14, 2017 · N4877Q · Substantial damageNTSB GAA17CA341Accident · No injuriesData collectionFinal reportCessna 172 · Galena, IDThe pilot's exceedance of the airplane’s critical angle of attack, which resulted in a power-on stall and subsequent loss of airplane control.Jun 14, 2017 · N9912Q · Substantial damageNTSB ENG17IA028Incident · No injuriesIncident investigationFinal reportBombardier CL 600 2C10 · Chicago, ILA Bombardier CRJ700 No. 1 engine failure caused by buckling of the combustion outer liner due to fatigue cracks. The liner buckling resulted in airflow disruption and reduced engine performance. The engine fuel control unit attempted to compensate for the…Jun 10, 2017 · N715SK · Minor damageNTSB CEN17LA229Accident · No injuriesLimited investigationFinal reportHughes 269C · Tallulah, LAThe pilot's failure to reset the cyclic trim before takeoff, which resulted in ground resonance.Jun 10, 2017 · N7482F · Substantial damageNTSB GAA17CA336Accident · No injuriesData collectionFinal reportPiper PA 28 · Auburn, INThe pilot’s decision to continue to attempt to take off despite the airplane’s inability to attain a positive climb rate, which resulted in little runway remaining, and his subsequent decision to turn off the runway, which resulted in a collision with a barn.Jun 8, 2017 · N4543R · Substantial damageNTSB CEN17LA224Accident · No injuriesLimited investigationFinal reportMckenna SD-1A · Juneau, WIThe pilot’s difficulty controlling the airplane due to his incorrect reinstallation of the wings, which led to a bounced precautionary landing. Contributing to the accident was the failure of the pilot and the mechanic to verify the wings’ angle of incidence.Jun 7, 2017 · N31313 · Substantial damageNTSB GAA17CA323Accident · No injuriesData collectionFinal reportAir Tractor AT 802 · Prosser, WAThe pilot’s abrupt maneuver to avoid hay bales during the takeoff roll, which resulted in a loss of directional control.Jun 5, 2017 · N802NB · Substantial damageNTSB GAA17CA326Accident · No injuriesData collectionFinal reportCessna 150 · Newburyport, MAThe student pilot's decision to attempt to close the cockpit window during takeoff and his subsequent failure to maintain directional control.Jun 4, 2017 · N6511S · Substantial damageNTSB DCA17WA138Incident · No injuriesForeign investigationBoeing 737 · Lima, PeruThe Comision de Investigacion de Accidentes de Aviacion of Peru has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on June 03, 2017. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's…Jun 3, 2017 · OB-2138-P · No damageNTSB CEN17LA206Accident · No injuriesLimited investigationFinal reportKenneth B Hines Nieuport 28 · Boonville, MOA partial loss of engine power due to a compromised induction system.Jun 1, 2017 · N6165 · Substantial damageNTSB ERA17WA193Accident · 1 fatalForeign investigationCessna 172 · Chernihiv, UkraineOn May 26, 2017, about 1200 coordinated universal time, a Cessna 172M, Ukrainian registration UR-WTA, was substantially damaged when it impacted a one-story building after takeoff from the Pivtsi Airport, Chernihiv, Ukraine. The pilot was fatally injured. The…May 26, 2017 · UR-WTA · Substantial damage