OpenAirDocs.org

NTSB investigations

14,038 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 NYC01LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Elizabethtown, KYThe pilot's failure to maintain directional control during the takeoff roll.May 12, 2001 · N6899W · Substantial damageNTSB SEA01LA081Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Seattle, WAThe high wind conditions encountered as the aircraft began its takeoff roll. Contributing factors were the variable and gusty wind conditions.Apr 30, 2001 · N6781L · Substantial damageNTSB IAD01LA047Accident · Serious injuriesLimited investigationFinal reportStinson 108 · White Post, VAthe pilot's failure to remove frost from the airplane prior to departure. A factor in the accident was the tall wet grass.Apr 26, 2001 · N97168 · Substantial damageNTSB SEA01LA075Accident · Minor injuriesLimited investigationFinal reportCessna 177RG · Seattle, WAthe reverse rigging of the aileron flight control system resulting in aileron deflections opposite that of the pilot's inputs which lead to an uncontrolled descent into the terrain. Factors include the pilot's failure to detect the misrigged ailerons during…Apr 21, 2001 · N8283G · Substantial damageNTSB MIA01LA125Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chapel Hill, NCThe loss of engine power for undetermined reasons during takeoff, resulting in an inflight collision with trees during the subsequent emergency landing. A factor in the accident was the lack of suitable terrain to conduct an emergency landing.Apr 19, 2001 · N118AW · Substantial damageNTSB SEA01LA072Accident · Minor injuriesLimited investigationFinal reportMaule M-4-210C · Bonners Ferry, IDInadequate preflight inspection/preparation of the aircraft by the pilot and consequent foreign object fouling of the rudder control, rendering directional control impossible. A factor was the pilot's distraction/preoccupation with personal problems.Apr 16, 2001 · N51463 · Substantial damageNTSB CHI01LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Culver, INthe CFI delayed remedial action during the takeoff. Additional factors were the wrong runway was selected, the tailwind, and the trees.Apr 13, 2001 · N3573S · Substantial damageNTSB MIA01LA120Accident · 1 fatalLimited investigationFinal reportHenry Pelican · Lakeland, FLThe pilot's delay in aborting the takeoff in a downwind condition resulting in an overrun and subsequent collision with a ditch. Contributing to the accident was the pilot's failure to conduct performance planning for the flight.Apr 9, 2001 · N696DH · Substantial damageNTSB LAX01LA142Accident · Minor injuriesLimited investigationFinal reportSchweizer 2-33A · Peoria, AZThe glider's encounter with a dust devil during takeoff that resulted in a loss of control.Apr 8, 2001 · N7778S · Substantial damageNTSB NYC01LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lexington, VAThe pilot's inadequate compensation for the runway conditions. Factors included the soggy runway conditions, and the lack of available takeoff performance data in the owners manual.Apr 4, 2001 · N4586J · Substantial damageNTSB FTW01LA105Accident · No injuriesLimited investigationFinal reportCessna 195B · Conroe, TXthe pilot's failure to compensate for the wind conditions during takeoff, which resulted in a ground loop.Apr 1, 2001 · N195S · Substantial damageNTSB DEN01LA080Accident · No injuriesLimited investigationFinal reportFox Pegazair 100 · Angel Fire, NMthe pilot's failure to maintain directional control during takeoff. A contributing factors was the gusty crosswind condition.Apr 1, 2001 · N679WB · Substantial damageNTSB ANC01LA045Accident · No injuriesLimited investigationFinal reportPiper PA-22-108 · Palmer, AKThe pilot's selection of an unsuitable takeoff area. A factor associated with the accident was rough/uneven terrain.Mar 31, 2001 · N4606Z · Substantial damageNTSB DEN01LA078Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Grand Junction, COFailure by the pilot to maintain directional control during takeoff roll. A factor was a crosswind.Mar 29, 2001 · N9464D · Substantial damageNTSB SEA01LA069Accident · No injuriesLimited investigationFinal reportCessna 180H · Coeur d'Alene, IDThe pilot's failure to maintain aircraft control during the aborted takeoff. A factor was gusty crosswinds.Mar 27, 2001 · N2780X · Substantial damageNTSB ANC01LA042Accident · No injuriesLimited investigationFinal reportCessna 180 · Soldotna, AKThe private pilot/student's inadequate compensation for crosswind conditions and subsequent loss of directional control of the airplane during a touch and go, and the instructor pilot's inadequate supervision of the flight. Factors in the accident were a…Mar 22, 2001 · N1702C · Substantial damageNTSB CHI01LA107Accident · No injuriesLimited investigationFinal reportCessna 172K · Holland, MIThe pilot failed to maintain directional control of the airplane. Factors included the soft ground and the runway lights.Mar 20, 2001 · N79301 · Substantial damageNTSB CHI01FA104Accident · Minor injuriesField investigationFinal reportAirbus Industrie A320-200 · Detroit, MIThe pilot induced oscillations and the delay in aborting the takeoff. Factors associated with the accident were the first officer used an improper trim setting and the captain did not identify and correct the setting during the taxi checklist, and the wet…Mar 17, 2001 · N357NW · Substantial damageNTSB LAX01IA118Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-88 · Tucson, AZthe failure of 4th stage turbine blades during takeoff roll, which resulted in a dynamic imbalance in the engine.Mar 15, 2001 · N996DL · Minor damageNTSB FTW01LA075Accident · No injuriesLimited investigationFinal reportCessna 172F · Clovis, NMthe pilot's failure to maintain directional control during take off roll resulting in a ground loop. A contributing factor was the crosswind.Mar 6, 2001 · N5175F · Substantial damageNTSB ANC01LA040Accident · No injuriesLimited investigationFinal reportTaylorcraft 19 · Salcha, AKThe pilot's failure to compensate for a tailwind during takeoff, and his delay in aborting the takeoff. Factors in the accident were a tailwind, and snow-covered terrain.Mar 4, 2001 · N22N · Substantial damageNTSB IAD01LA036Accident · No injuriesLimited investigationFinal reportLenart Rotorway Exec 162F · Wallingford, CTflight instructor's failure to follow published checklist procedures, which resulted in the forward ballast weight not being moved to the tailboom prior to departure.Mar 3, 2001 · N929BL · Substantial damageNTSB LAX01LA106Accident · Minor injuriesLimited investigationFinal reportAscher Yakolev YAK 11 · Ione, CAThe failure of the pilot to maintain directional control during the takeoff run. A factor in the accident was the pilot's lack of total experience in the type aircraft.Feb 27, 2001 · N18AW · Substantial damageNTSB LAX01LA104Accident · No injuriesLimited investigationFinal reportSchneider, Edmund, Pty. Starduster SA300 · Chino Valley, AZThe pilot's inadequate preflight planning and his failure to dissiminate/coordinate the total distance required to successfully operate the airplane.Feb 23, 2001 · N1173 · Substantial damageNTSB SEA01LA051Accident · No injuriesLimited investigationFinal reportLandry Gyrobee · Chehalis, WAThe pilot-in-command's reverse application of cyclic to counteract a right drift during the takeoff roll in a gyroplane whose controls had been designed reverse of standard. Contributing factors were the gusty wind conditions and the pilot's "expectancy" or…Feb 19, 2001 · N392JL · Substantial damageNTSB CHI01IA124Incident · No injuriesIncident investigationFinal reportBoeing 717-231 · Milwaukee, WIThe failure of the operator to provide complete and comprehensive thrust reverser lock-out maintenance procedures and guidance to the contract maintenance personnel resulting in a partial and inadequate securing of the faulty thrust reverser and a subsequent…Feb 19, 2001 · N2410W · No damageNTSB CHI01FA089Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Webb Lake, WIthe pilot not maintaining altitude/clearance from the trees during takeoff. Factors were the trees, transmission wire, and the dark night.Feb 15, 2001 · N120CC · DestroyedNTSB CHI01LA092Accident · No injuriesLimited investigationFinal reportCessna 172R · Battle Creek, MIAircraft control not maintained by the student pilot during the takeoff roll. Factors to the accident were the student pilot's lack of experience and the snowbank.Feb 13, 2001 · N975BC · Substantial damageNTSB DEN01LA049Accident · No injuriesLimited investigationFinal reportCessna 180K · Clovis, NMThe pilot's failure to maintain directional control, which resulted in the subsequent swerve of the airplane. Contributing factors were the pilot's lack of experience in make and model and his diverted attention while attempting to adjust the trim.Feb 4, 2001 · N180PG · Substantial damageNTSB CHI01LA106Accident · No injuriesLimited investigationFinal reportCessna 172RG · Sunfield, MIThe pilot's inadequate preflight preparation and the unsuitable terrain for takeoff encountered. Factors included the slushy runway and the snowbank.Jan 31, 2001 · N6448V · Substantial damageNTSB MIA01LA064Accident · No injuriesLimited investigationFinal reportRobinson R22 · Long Beach, MSThe student pilot's failure to relinquish the flight controls while the CFI was demonstrating a takeoff to a hover. This resulted in an in-flight loss of directional control, in-flight collision with terrain, and subsequent roll over.Jan 27, 2001 · N128PH · Substantial damageNTSB LAX01LA081Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Camarillo, CAThe failure of the pilot to maintain directional control during takeoff.Jan 27, 2001 · N9411D · Substantial damageNTSB FTW01LA053Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Damon, TXthe pilot's failure to maintain helicopter control during takeoff to a hover, which resulted in a dynamic rollover.Jan 27, 2001 · N99DK · Substantial damageNTSB IAD01LA030Accident · No injuriesLimited investigationFinal reportCessna 120 · Trenton, METhe pilot's improper touchdown in the snow after the airplane became prematurely airborne during an attempted takeoff. A factor was the pilot's inadequate training.Jan 25, 2001 · N3070N · Substantial damageNTSB CHI01LA072Accident · No injuriesLimited investigationFinal reportCessna 172P · Prairie Du Sac, WIthe improper trim setting and the pilot failed to maintain control of the airplane. A factor was the snowbank.Jan 21, 2001 · N53118 · Substantial damageNTSB IAD01LA029Accident · No injuriesLimited investigationFinal reportPiper PA 46-350P · Chillicothe, OHpilot's improper pre-flight planning and failure to follow the published checklist procedures, which resulted in ice and snow not being removed from the wings prior to take-off.Jan 19, 2001 · N747RC · Substantial damageNTSB ANC01LA031Accident · No injuriesLimited investigationFinal reportCessna 207 · Kongiganak, AKThe pilot's inadequate compensation for wind conditions during the takeoff roll. A factor associated with the accident was a crosswind.Jan 19, 2001 · N7340U · Substantial damageNTSB CHI01LA062Accident · No injuriesLimited investigationFinal reportCessna 152 · Mattoon, ILthe pilot's failure to maintain directional control. Factors were the crosswind, the pilots lack of total experience, and the snow covered terrain adjacent to the runway.Jan 10, 2001 · N5394Q · Substantial damageNTSB IAD01LA022Accident · No injuriesLimited investigationFinal reportLearjet 35 · Schenectady, NYThe pilot's improper trim setting, which resulted in a runway overrun and impact with a fence.Jan 4, 2001 · N435JL · Substantial damageNTSB CHI01LA060Accident · No injuriesLimited investigationFinal reportCessna 172S · Sioux Falls, SDAircraft directional control not being maintained by the student pilot during the takeoff roll. Factors to the accident were the snow bank and the student pilot's lack of total experience.Jan 4, 2001 · N727SP · Substantial damageNTSB CHI01LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Lincoln, ILThe pilot's failure to maintain directional control on the runway. Factors relating to this accident were the aborted takeoff attempt, the pilot's improper in-flight planning/decision, and the snowbank.Jan 1, 2001 · N737WQ · Substantial damageNTSB NYC01LA063Accident · No injuriesLimited investigationFinal reportCessna 172M · Farmville, VAthe failure of the pilot to maintain directional control.Dec 29, 2000 · N73404 · Substantial damageNTSB NYC01FA062Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-51 · Jamaica, NYThe low cycle fatigue fracturing of the approach lighting cover securing bolts.Dec 28, 2000 · N769NC · Substantial damageNTSB MIA01LA047Accident · No injuriesLimited investigationFinal reportLarry Groover Eagle · Auburndale, FLthe pilot's failure to maintain adequate clearance during takeoff, which resulted in an inflight collision with a fence and substantial damage to the aircraft.Dec 22, 2000 · N8132L · Substantial damageNTSB CHI01LA051Accident · No injuriesLimited investigationFinal reportCessna 172M · Sturgis, SDThe pilot failed to maintain control of the airplane during takeoff and he discontinued an aborted takeoff once initiated. Factors associated with the accident were the inaccurate elevator trim indicator, the pilot's failure to verify the trim setting,…Dec 19, 2000 · N13584 · Substantial damageNTSB MIA01LA036Accident · No injuriesLimited investigationFinal reportAir Tractor AT-602 · Clarksville, FLThe pilot's delay in aborting a takeoff after hitting a soft spot (sand) in the runway resulting in the airplane going off the end of the runway and colliding with trees. Contributing to the accident was the pilots decision to attempt the flight in an over…Dec 6, 2000 · N9046D · Substantial damageNTSB NYC01LA047Accident · No injuriesLimited investigationFinal reportCessna 152 · Cross Keys, NJThe overstress separation of the control yoke from the control column.Dec 2, 2000 · N757RR · Substantial damageNTSB SEA01LA022Accident · Minor injuriesLimited investigationFinal reportAerofab Lake 250 · Mercer Island, WAThe pilot's failure to maintain aircraft control during a left turning step taxi to takeoff, resulting in a wing contacting the water during the step turn.Dec 1, 2000 · N8551Z · Substantial damageNTSB NYC01LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Lebanon, OHThe flight instructor's failure to maintain aircraft control during an aborted takeoff. A factor in the accident was a partial loss of engine power.Nov 28, 2000 · N5035W · Substantial damageNTSB CHI01LA041Accident · No injuriesLimited investigationFinal reportCessna 150M · Jefferson City, MOthe student pilots failure to maintain directional control. Factors were the service road and the nose gear collapse.Nov 24, 2000 · N66633 · Substantial damage