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 ERA11LA496Accident · 1 fatalLimited investigationFinal reportAero Adventure Zephyr II · Sylacauga, ALThe pilot's incapacitation due to a heart attack during takeoff, which led to an in-flight loss of airplane control.Sep 18, 2011 · N3577F · Substantial damageNTSB CEN11LA651Accident · Serious injuriesLimited investigationFinal reportNorth American AT-6 · Nunica, MIThe loss of engine power due to fuel starvation during climbout for undetermined reasons, because postaccident examination of the fuel system did not reveal any discrepancies that would have precluded normal engine operation. Contributing to the accident was…Sep 17, 2011 · N217RK · Substantial damageNTSB ANC11CA105Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Bethel, AKThe pilot's delayed decision to abort the takeoff.Sep 17, 2011 · N82907 · Substantial damageNTSB ANC11CA102Accident · No injuriesData collectionFinal reportCessna 180 · Ambler, AKThe pilot's decision to takeoff with a tailwind, which resulted in a runway excursion.Sep 13, 2011 · N9019C · Substantial damageNTSB CEN11LA642Accident · No injuriesLimited investigationFinal reportPiper PA16 · Muskegan, MIThe pilot's loss of directional control during the takeoff roll and the flight instructor's inability to apply remedial action due to the opposite corrective control inputs by the pilot.Sep 11, 2011 · N5383H · Substantial damageNTSB ANC11CA094Accident · No injuriesData collectionFinal reportPiper PA-12 · North Pole, AKThe pilot's failure to maintain adequate airspeed during takeoff, resulting in an aerodynamic stall and collision with the water.Sep 5, 2011 · N78463 · Substantial damageNTSB WPR11FA424Accident · Serious injuriesField investigationFinal reportConsolidated Aeronautics Lake LA-4-200 · Lakeport, CAThe pilot's decision to continue the takeoff with reduced engine power, which resulted in a collision with terrain during the takeoff initial climb. Contributing to the accident was the partial loss of engine power for reasons that could not be determined…Sep 2, 2011 · N80033 · Substantial damageNTSB WPR11CA418Accident · Minor injuriesData collectionFinal reportChristen Industries A-1 · Dorris, CAThe pilot’s failure to maintain lateral aircraft control while taking off with a gusting crosswind.Aug 30, 2011 · N2868A · Substantial damageNTSB CEN11LA610Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Monette, ARThe fracture of the throttle cable in tensile overstress because of wear damage, which resulted in the partial loss of engine power.Aug 29, 2011 · N48378 · Substantial damageNTSB CEN11LA601Accident · Minor injuriesLimited investigationFinal reportVan's RV-12 · Windom, MNThe pilot's loss of airplane control after liftoff due to his distraction with the unsecured canopy, which he did not lock before takeoff.Aug 29, 2011 · N73712 · Substantial damageNTSB CEN11WA617Accident · 4 fatalForeign investigationRobinson R44 · St. Ferdinand, CanadaOn August 27, 2011, at 2115 eastern daylight time, a Robinson R44 helicopter, C-GEBY, sustained substantial damage when it impacted terrain shortly after takeoff near St. Ferdinand, Quebec, Canada. The pilot and three passengers sustained fatal injuries. The…Aug 28, 2011 · C-GEBY · Substantial damageNTSB CEN11CA600Accident · No injuriesData collectionFinal reportCessna 182C · Grand Marais, MNThe pilot's delayed decision to land the airplane when he realized the airplane's performance was insufficient to clear approaching terrain during the initial climb after takeoff. Contributing to the accident was the pilot's inadequate preflight planning.Aug 27, 2011 · N9011T · Substantial damageNTSB CEN11CA662Accident · No injuriesData collectionFinal reportPiper PA-30 · Saguache, COThe pilot's failure to maintain airplane control during the aborted takeoff.Aug 26, 2011 · N75BA · Substantial damageNTSB CEN11CA627Accident · No injuriesData collectionFinal reportRobinson Helicopter R44 · Batesville, TXThe pilot’s inadequate preflight inspection that failed to ensure all tie-down clamps were removed prior to takeoff, which resulted in the helicopter’s dynamic rollover.Aug 26, 2011 · N99FJ · Substantial damageNTSB CEN11FA597Accident · 1 fatalField investigationFinal reportNichols Lancair 235 · Heath, OHThe pilot's failure to obtain adequate familiarization with the accident airplane type before the accident flight, which resulted in his failure to maintain airplane control during takeoff.Aug 25, 2011 · N777BN · DestroyedNTSB ANC11CA086Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Beluga Lake, AKThe pilot's decision to takeoff with an unfavorable wind which resulted in a loss of directional control, and collision with terrain.Aug 25, 2011 · N8491Y · Substantial damageNTSB CEN11CA589Accident · No injuriesData collectionFinal reportAir Tractor AT-502B · Matthews, MOThe pilot's failure to maintain control of the airplane during takeoff.Aug 22, 2011 · N113AA · Substantial damageNTSB WPR11LA400Accident · No injuriesLimited investigationFinal reportCessna 182Q · Alton, UTThe pilot’s failure to abort the takeoff in a timely manner, which resulted in insufficient altitude to clear obstructions.Aug 21, 2011 · N79ES · Substantial damageNTSB CEN11WA587Accident · 2 fatalForeign investigationGardan GY80-160 · Mauterndorf, AustriaUnder the jurisdiction and control of the Austrian Government.Aug 21, 2011 · D-EKCN · Substantial damageNTSB ERA11CA478Accident · No injuriesData collectionFinal reportCano Dave Avid Flyer Mkiv · Smithville, TNThe pilot's failure to maintain directional control during the takeoff roll due to his distraction by an open door.Aug 20, 2011 · N52CH · Substantial damageNTSB CEN11LA591Accident · Minor injuriesLimited investigationFinal reportAmerican Autogyro Sparrowhawk · Delaware, OHThe noncertificated pilot did not maintain adequate airspeed and aircraft control during initial climb.Aug 20, 2011 · N2631B · Substantial damageNTSB WPR11WA393Accident · 3 fatalForeign investigationAerospatiale AS355 · Marree, Australia, AustraliaOn August 18, 2011, at 1008 universal coordinated time, an Aerospatiale AS 355F2, VH-NTV, operated by Australian Broadcasting Corporation, collided with terrain shortly after takeoff near Marree, Australia. The helicopter was substantially damaged and…Aug 18, 2011 · VH-NTV · Substantial damageNTSB WPR11LA386Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Hardin, MTThe loss of engine power during takeoff due to the fatigue failure of the turbine wheel blades, which resulted from inadequate maintenance and inspections.Aug 16, 2011 · N1012T · Substantial damageNTSB CEN11CA631Accident · No injuriesData collectionFinal reportCessna A188 · Ord, NEThe pilot's loss of directional control during a crosswind takeoff.Aug 16, 2011 · N9742V · Substantial damageNTSB ANC11LA080Accident · 2 fatalLimited investigationFinal reportPiper PA-18-150 · Cape Yakataga, AKA collision into water during initial climb after takeoff for undetermined reasons.Aug 16, 2011 · N4205Z · Substantial damageNTSB WPR11LA379Accident · No injuriesLimited investigationFinal reportBell 47G-3B-2 · Los Banos, CAThe pilot’s inadequate preflight, and contamination of both the engine compressor section and the main rotor blades, which resulted in reduced performance of the engine and rotor system.Aug 14, 2011 · N475AL · Substantial damageNTSB WPR11FA382Accident · 4 fatalField investigationFinal reportCessna P210N · Burley, IDThe pilot's failure to attain sufficient altitude and maintain aircraft control during a turn shortly after liftoff while operating at maximum gross weight, with a tailwind, and in high density altitude conditions.Aug 14, 2011 · N7825K · Substantial damageNTSB CEN11LA577Accident · Minor injuriesLimited investigationFinal reportCessna 400 · Eastland, TXA loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any anomalies that would have precluded normal operation. .Aug 14, 2011 · N2515G · Substantial damageNTSB CEN11CA576Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Stanberry, MOThe pilot’s failure to maintain directional control during takeoff.Aug 14, 2011 · N42860 · Substantial damageNTSB ERA11CA455Accident · No injuriesData collectionFinal reportG-Dawg Just Acft Highlander · Abingdon, VAThe pilot's inadequate compensation for wind conditions during the aborted takeoff.Aug 13, 2011 · N376CG · Substantial damageNTSB CEN11LA563Accident · No injuriesLimited investigationFinal reportGrumman Acft ENG Cor-Schweizer G-164A · Mansfield, SDThe loss of engine power due to debris in the engine air intake system.Aug 10, 2011 · N127FC · Substantial damageNTSB ERA11CA446Accident · No injuriesData collectionFinal reportCessna 172S · St. Augustine, FLThe student pilot's loss of directional control while attempting to close the airplane's door during takeoff roll.Aug 8, 2011 · N65777 · Substantial damageNTSB ANC11CA074Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Coldfoot, AKThe pilot's inadequate directional control of the airplane during takeoff. Contributing to the accident was the pilot’s fatigue.Aug 7, 2011 · N762LA · Substantial damageNTSB ENG11IA043Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-51 · Atlanta, GAThe probable cause of the No. 2 engine failure and subsequent aborted takeoff was the high cycle fatigue failure of a fan blade near the blade root that resulted in extensive low pressure compressor damage and compressor case breach.Aug 6, 2011 · N676MC · Minor damageNTSB ERA11CA440Accident · Minor injuriesData collectionFinal reportNelsen Lynn H Lightning · Frostproof, FLThe pilot's premature rotation during takeoff.Aug 5, 2011 · N13LN · Substantial damageNTSB CEN11CA560Accident · No injuriesData collectionFinal reportCessna 182S · Los Cruces, NMThe pilot's loss of aircraft control due to insufficient aircraft performance during takeoff, with a heavy gross weight and a high density altitude.Aug 5, 2011 · N493JL · Substantial damageNTSB CEN11CA548Accident · Minor injuriesData collectionFinal reportPiper PA-18A · Sherman, TXThe pilot's improper fuel management, which resulted in a loss of engine power due to fuel exhaustion.Aug 5, 2011 · N150CW · Substantial damageNTSB WPR11LA369Accident · No injuriesLimited investigationFinal reportCessna 140 · Wilkeson, WAA partial loss of engine power during takeoff due to water contamination in the fuel system.Aug 4, 2011 · N2199N · Substantial damageNTSB CEN11LA549Accident · No injuriesLimited investigationFinal reportAerosport Ikarus C42E · East Troy, WIThe flight instrctor's delayed remedial action during landing. Contributing to the accident was the student pilot’s loss of directional control when he became distracted with the open door.Aug 4, 2011 · N577JP · Substantial damageNTSB CEN11LA546Accident · 2 fatalLimited investigationFinal reportReinboldt Richard A Challenger II · Reedsburg, WIThe pilot did not maintain adequate airspeed during takeoff, which resulted in an aerodynamic stall.Aug 4, 2011 · N340BR · Substantial damageNTSB WPR11LA366Accident · No injuriesLimited investigationFinal reportAyres S2R-600 · Hazelton, IDPartial loss of engine power for undetermined reasons.Aug 3, 2011 · N4021S · Substantial damageNTSB ERA11LA438Accident · Serious injuriesLimited investigationFinal reportPiper PA-30 · St. Petersburg, FLThe pilot's improper rotation during takeoff, resulting in a stall and subsequent collision with the ground.Aug 3, 2011 · N8314Y · Substantial damageNTSB WPR11CA365Accident · No injuriesData collectionFinal reportCessna 162 · Rawlings, WYThe pilot's decision to attempt a takeoff at a density altitude that was outside the performance envelope of the airplane. Also causal was the flight's likely encounter with a sudden tailwind gust.Aug 1, 2011 · N7024V · Substantial damageNTSB CEN11FA531Accident · 1 fatalField investigationFinal reportEdwards Douglas L SKY Ranger · Wautoma, WIThe pilot’s failure to maintain proper airspeed and attitude control of the airplane in the turn, which resulted in an aerodynamic stall.Aug 1, 2011 · N7501Y · Substantial damageNTSB WPR11CA394Accident · No injuriesData collectionFinal reportBell 47G · Porterville, CAThe pilot's decision to takeoff in a tailwind condition, and his subsequent failure to attain sufficient lift during the takeoff.Jul 31, 2011 · N6260C · Substantial damageNTSB ERA11CA432Accident · Serious injuriesData collectionFinal reportMcfarland WM H Rans S6S · Huntington, WVThe failure of both pilots to maintain proper pitch control during takeoff. Contributing to the accident was both pilots' inexperience in the airplane make/model.Jul 30, 2011 · N434WM · Substantial damageNTSB WPR11CA353Accident · No injuriesData collectionFinal reportSloan Roger D Vans RV7A · Sheridan, WYThe pilot's failure to maintain aircraft control during takeoff due to cockpit distractions.Jul 29, 2011 · N742RJ · Substantial damageNTSB CEN11FA500Accident · 3 fatalField investigationFinal reportPiper PA 46-350P · Rantoul, ILThe pilot did not maintain airplane control during takeoff with approaching thunderstorms. Contributing to the accident was the pilot's decision to depart into adverse weather conditions.Jul 24, 2011 · N46TW · Substantial damageNTSB ANC11CA072Accident · No injuriesData collectionFinal reportAeronca 7AC · McCarthy, AKThe separation of the right main landing gear oleo strut assembly, resulting in the collapse of the main landing gear during the landing roll.Jul 24, 2011 · N85194 · Substantial damageNTSB WPR11FA349Accident · No injuriesField investigationFinal reportHawker Beechcraft G36 · Hailey, IDThe pilot's inadvertent activation of the auxiliary fuel pump, which resulted in a loss of engine power during takeoff.Jul 23, 2011 · N536BB · Substantial damage