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 DCA11WA054Incident · No injuriesForeign investigationBoeing 767 · Fukuoka, JapanThe Japan Transport Safety Board (JTSB) has notified the NTSB of an incident involving a B767-300 and a DHC-8-402 that occurred on May 10, 2011. The NTSB has appointed a U.S. Accredited Representative to assist the JTSB investigation under the provisions of…May 10, 2011 · JA602A · 2 aircraft · No damageNTSB CEN11LA335Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Bono, ARA loss of engine power for undetermined reasons.May 9, 2011 · N8930H · Substantial damageNTSB WPR11CA219Accident · No injuriesData collectionFinal reportEvektor-Aerotechnik Sportstar · Scottsdale, AZThe pilot's failure to maintain directional control during the takeoff roll.May 8, 2011 · N636EV · Substantial damageNTSB ERA11CA286Accident · No injuriesData collectionFinal reportCessna 172R · Hollywood, FLThe student pilot's failure to maintain directional control of the airplane during a touch-and-go landing.May 4, 2011 · N2434T · Substantial damageNTSB WPR11LA218Accident · No injuriesLimited investigationFinal reportPiper PA46-500TP · Rock Springs, WYThe overstress fracture of the right aileron midspan hinge bracket due to modal vibrations created by a deflated right main landing gear tire during the takeoff roll.May 3, 2011 · N46ME · Substantial damageNTSB ERA11CA277Accident · No injuriesData collectionFinal reportCessna A185F · Ocean City, NJThe pilot's failure to maintain directional control during the takeoff roll.May 3, 2011 · N6389E · Substantial damageNTSB CEN11LA317Accident · No injuriesLimited investigationFinal reportTexas Helicopter OH-13E/M74 · New Columbia, ILThe pilot's failure to maintain adequate clearance from the wheat crop during takeoff.May 3, 2011 · N38096 · Substantial damageNTSB ERA11CA275Accident · No injuriesData collectionFinal reportBeech A23 · Hammonton, NJThe pilot's failure to maintain directional control during the aborted takeoff.May 1, 2011 · N3594R · Substantial damageNTSB CEN11LA308Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Streetman, TXThe airplane’s inability to establish a climb for undetermined reasons, which resulted in a collision with trees.Apr 25, 2011 · N6492J · Substantial damageNTSB CEN11CA301Accident · No injuriesData collectionFinal reportAyres S2R-R1340 · Estelline, SDThe pilot's failure to maintain directional control of the airplane during takeoff.Apr 25, 2011 · N3104S · Substantial damageNTSB ERA11CA256Accident · No injuriesData collectionFinal reportVans RV8 · Locust Grove, GAThe pilot's failure to maintain aircraft control during the takeoff roll.Apr 21, 2011 · N190GE · Substantial damageNTSB ERA11LA249Accident · No injuriesLimited investigationFinal reportBeech D-45 (T-34B) · Linden, NCThe pilot's inadequate takeoff performance planning and procedures, which resulted in an attempted takeoff on a grass runway that was not long enough for the given conditions and airplane configuration.Apr 14, 2011 · N93013 · Substantial damageNTSB ERA11CA244Accident · No injuriesData collectionFinal reportCessna 172S · Saint Petersburg, FLThe failure of the student pilot to maintain directional control during a touch-and-go landing.Apr 13, 2011 · N2468Z · Substantial damageNTSB CEN11CA282Accident · No injuriesData collectionFinal reportDelf Tim Zenith CH-701 · Davenport, IAThe improper installation of the rudder cable to rudder pedal attachment hardware.Apr 12, 2011 · N701YB · Substantial damageNTSB CEN11LA275Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Oklahoma City, OKThe loss of aircraft control due to the failure of the stabilator control cable turnbuckle.Apr 7, 2011 · N31407 · Substantial damageNTSB WPR11LA190Accident · Minor injuriesLimited investigationFinal reportBell 47G · Torrance, CAThe pilot did not maintain adequate altitude during takeoff, which resulted in ground contact and a dynamic rollover.Apr 6, 2011 · N9FK · Substantial damageNTSB DCA11WA041Incident · No injuriesForeign investigationBoeing B737 · Bucharest, RomaniaOn April 4, 2011, a Boeing 737-300, Romanian registration YR-BGD, operated by TAROM Airlines experienced a tailstrike on takeoff from the Henri Coanda Airport, Bucharest, Romania (LROP). The flight crew reported a loss of lift after rotation, and was…Apr 4, 2011 · YR-BGD · Substantial damageNTSB WPR11LA183Accident · 1 fatalLimited investigationFinal reportTomei S12 XL · Pleasant Grove, CAThe pilot’s failure to allow the airplane’s engine to properly warm up before applying takeoff power, which resulted in the forward cylinder's piston seizing and a subsequent loss of engine power. Also causal was the pilot's failure to maintain an adequate…Apr 3, 2011 · N8113N · Substantial damageNTSB DCA11MA076Accident · 4 fatalClass 1 · MajorFinal reportGulfstream GVI · Roswell, NMThe National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…Apr 2, 2011 · N652GD · Substantial damageNTSB CEN11CA271Accident · No injuriesData collectionFinal reportCessna 172N · Appleton, WIThe student pilot's failure to maintain directional control of the airplane during takeoff.Mar 31, 2011 · N73836 · Substantial damageNTSB CEN11LA254Accident · No injuriesLimited investigationFinal reportNorth American B25 · Encinal, TXThe co-pilot’s premature retraction of the landing gear during takeoff, which resulted in a gear collapse and impact with the runway surface.Mar 26, 2011 · N747AF · Substantial damageNTSB CEN11LA252Accident · Minor injuriesLimited investigationFinal reportBell 206L-3 · (Gulf of Mexico)The loss of engine power due to an engine compressor stall as a result of ingesting methane gas during takeoff.Mar 24, 2011 · N32041 · Substantial damageNTSB CEN11LA273Accident · No injuriesLimited investigationFinal reportCessna 414A · Aberdeen, SDThe pilot's inadequate compensation for gusty crosswinds during takeoff, which resulted in a loss of directional control.Mar 23, 2011 · N4057C · Substantial damageNTSB ERA11LA208Accident · 1 fatalLimited investigationFinal reportJennings John C Mini Max · Clinton, SCThe pilot's inadequate performance planning, which resulted in a collision with a tree during takeoff.Mar 19, 2011 · UNREG · Substantial damageNTSB ERA11CA194Accident · No injuriesData collectionFinal reportRobinson R44 · Petersburg, WVThe pilot's failure to maintain control during the takeoff.Mar 17, 2011 · N555FP · Substantial damageNTSB CEN11CA236Accident · No injuriesData collectionFinal reportPiper PA-22-150 · South St. Paul, MNThe pilot's failure to maintain directional control of the airplane during the takeoff roll.Mar 16, 2011 · N2816Z · Substantial damageNTSB WPR11CA157Accident · No injuriesData collectionFinal reportAeronca 7EC · Big Bear City, CAThe pilot's improper maintenance, which resulted in a wheel separating from the airplane during takeoff, and the airplane's subsequent nose over during the landing rollout.Mar 11, 2011 · N2349E · Substantial damageNTSB WPR11CA162Accident · No injuriesData collectionFinal reportCessna 180 · Pine, AZThe pilot's failure to maintain directional control of the airplane during takeoff, which resulted in a runway excursion and collision with terrain.Mar 10, 2011 · N9330C · Substantial damageNTSB CEN11LA219Accident · No injuriesLimited investigationFinal reportAeronca 7AC · Delphi, INThe pilot's loss of directional control, resulting in a runway excursion, and the subsequent separation of the left main landing gear for undetermined reasons.Mar 4, 2011 · N82429 · Substantial damageNTSB ERA11CA177Accident · No injuriesData collectionFinal reportQuist Kitfox · Indian Trail, NCThe pilot's failure to maintain directional control during an aborted landing, resulting in a runway excursion and collision with a vehicle.Mar 3, 2011 · N788Q · Substantial damageNTSB ERA11CA174Accident · Serious injuriesData collectionFinal reportPiper J3C-65 · Maysvile, NCThe pilot-rated passenger’s loss of directional control during takeoff and the pilot’s delayed remedial action, which resulted in a runway excursion and collision with trees.Mar 2, 2011 · N23249 · Substantial damageNTSB CEN11CA213Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 II · Glenwood Springs, COThe pilot’s improper takeoff procedure, which resulted in a dynamic rollover when the left skid contacted the ground.Mar 1, 2011 · N74816 · Substantial damageNTSB WPR11GA144Accident · Minor injuriesFinal reportEurocopter AS 350 B2 · Riverside, CAThe failure of both pilots to follow proper procedures during a simulated hydraulic emergency that resulted in a loss of helicopter control. Contributing to the accident was the flight instructor’s delayed remedial action.Feb 24, 2011 · N965SD · Substantial damageNTSB ERA11LA154Accident · No injuriesLimited investigationFinal reportCessna 177B · Reading, PAInadequate maintenance inspection of the airplane which resulted in a shift of the shock mounted portion of the pilot's instrument panel, causing an interference of the pitch control during takeoff.Feb 18, 2011 · N11625 · Substantial damageNTSB CEN11FA195Accident · 2 fatalField investigationFinal reportCessna 182P · Levelland, TXThe pilot’s failure to maintain control of the airplane during a landing and subsequent go-around with a crosswind.Feb 18, 2011 · N325LA · Substantial damageNTSB ERA11LA149Accident · No injuriesLimited investigationFinal reportCessna 150H · Jonesborough, TNA partial loss of engine power during initial climb for undetermined reasons.Feb 17, 2011 · N7237S · Substantial damageNTSB CEN11CA184Accident · No injuriesData collectionFinal reportCessna 172N · Poplar Grove, ILThe student pilot's failure to maintain directional control of the airplane during the takeoff.Feb 12, 2011 · N733TM · Substantial damageNTSB WPR11CA132Accident · Minor injuriesData collectionFinal reportCessna 170A · Baker Lake, WAThe pilot's encounter with soft terrain during an attempted takeoff from a dry lake bed.Feb 11, 2011 · N9768A · Substantial damageNTSB WPR11CA124Accident · No injuriesData collectionFinal reportCessna 182D · Quartzsite, AZThe pilot's inadequate compensation for the wind and subsequent loss of directional control, which resulted in a runway excursion and collision with a parked aircraft.Feb 6, 2011 · N8859X · Substantial damageNTSB ERA11CA128Accident · Serious injuriesData collectionFinal reportExcalibur Excalibur · Immokalee, FLThe pilot's failure to maintain control of the airplane during a high speed taxi test resulting in unintentional flight and ground collision.Jan 30, 2011 · N818RJ · Substantial damageNTSB CEN11CA191Accident · No injuriesData collectionFinal reportErcoupe 415-CD · Newaygo, MIThe pilot's loss of directional control during takeoff from a frozen lake.Jan 30, 2011 · N127G · Substantial damageNTSB CEN11CA167Accident · Serious injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Anoka, MNThe student pilot's control inputs that resulted in an inadvertent dynamic rollover and the CFI's inadequate supervision of the flight.Jan 29, 2011 · N7195B · Substantial damageNTSB CEN11CA165Accident · No injuriesData collectionFinal reportCulver Glenn Kitfox III · Terlingua, TXThe pilot's loss of directional control on takeoff.Jan 25, 2011 · N947RG · Substantial damageNTSB ERA11CA123Accident · No injuriesData collectionFinal reportCirrus Design SR22 · Jasper, ALThe pilot's loss of directional control on a wet runway during takeoff from a touch and go landing resulting in a runway excursion.Jan 24, 2011 · N1116C · Substantial damageNTSB CEN11CA158Accident · No injuriesData collectionFinal reportCessna 172S · McKinney, TXThe student pilot's loss of directional control during takeoff, which resulted in a runway excursion and impact with terrain.Jan 22, 2011 · N348ME · Substantial damageNTSB ERA11WA122Accident · No injuriesForeign investigationBell 212 · Cuzco, PeruOn January 17, 2011, at 1940 universal coordinated time, a Bell 212 helicopter, Peruvian registration OB-1767-P, registered to Helicopters Service, and operated by Heliamerica S.A.C., experienced an un-commanded roll over during takeoff from a remote helipad…Jan 17, 2011 · OB-1767P · Substantial damageNTSB ERA11LA117Accident · No injuriesLimited investigationFinal reportConvair 340-71 · Charlotte AmalieThe captain’s decision to continue the flight with the left engine backfiring, resulting in an engine fire shortly after takeoff. Contributing to the accident were the captain’s decision to continue the flight following a report of black smoke trailing the…Jan 17, 2011 · N8277Q · Substantial damageNTSB ERA11CA115Accident · No injuriesData collectionFinal reportCessna 172N · Lebanon, TNThe student pilot´s failure to maintain directional control during an aborted takeoff, resulting in a runway excursion.Jan 15, 2011 · N1946F · Substantial damageNTSB WPR11CA098Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Austin, NVThe pilot’s failure to maintain directional control during the takeoff roll.Jan 13, 2011 · N4030Z · Substantial damageNTSB DCA11WA023Incident · No injuriesForeign investigationBoeing 737 · Montpelier, FranceOn January 10, 2011, at 1330 local time a Boeing 737-700, registration F-GIXD experienced an AOA sensor blockage resulting in false stick-shaker during takeoff from Montpelier, France. The airplane was on a ferry flight to Toulouse, France, and returned to…Jan 10, 2011 · F-GIXD · No damage