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 NYC97LA086Accident · No injuriesLimited investigationFinal reportCessna 177 · Lancaster, OHThe flight instructor's inadequate supervision and his failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway and striking the precision approach path indicator lights.Apr 30, 1997 · N2921X · Substantial damageNTSB CHI97IA117Incident · Minor injuriesIncident investigationFinal reportBoeing 737-200 · Chicago, ILinadequate nickel plating was applied to the compressor disk during the rework process at the operator's overhaul facility, which resulted in a brittle fracture in the disk and an uncontained engine failure. A factor was the operator's lack of written…Apr 28, 1997 · N9063U · Minor damageNTSB ATL97LA063Accident · No injuriesLimited investigationFinal reportRockwell S-2R · Lincolnton, GAThe pilot's inadequate preflight planning of the fuel requirement for this flight that resulted in fuel exhaustion and the subsequent loss of engine power.Apr 26, 1997 · N8473V · Substantial damageNTSB ANC97LA053Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Nikiski, AKthe pilot's improper installation of the landing gear wheel.Apr 18, 1997 · N92793 · Substantial damageNTSB CHI97LA104Accident · No injuriesLimited investigationFinal reportCessna 177 · Harrisburg, ILthe loss of engine power followed by an engine fire for reason or reasons undetermined.Apr 15, 1997 · N3322T · DestroyedNTSB MIA97LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-160 · Pickens, SCfailure of the student pilot to maintain directional control during the takeoff roll from a touch-and-go landing, which resulted in the airplane going off the side of the runway, down an embankment, and into brush/trees.Apr 14, 1997 · N5363W · Substantial damageNTSB ATL97FA057Accident · 2 fatalField investigationFinal reportDouglas C54A-DC · Griffin, GAThe flightcrew's inadequate procedures, during a rejected takeoff following a possible engine malfunction at a critical time in the takeoff, and the second pilot's physical impairment.Apr 4, 1997 · N83FA · DestroyedNTSB SEA97LA079Accident · 1 fatalLimited investigationFinal reportRose VP-1 · Gardiner, WAThe pilot-in-command's failure to maintain control of the aircraft. Factors contributing to the accident were gusty and high winds.Mar 30, 1997 · N89PR · DestroyedNTSB FTW97LA143Accident · No injuriesLimited investigationFinal reportCessna 180D · Erie, COThe pilot's failure to maintain airplane directional control. A factor was the crosswind.Mar 27, 1997 · N6484X · Substantial damageNTSB FTW97LA140Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Watson, ARThe pilot's failure to attain lift off speed and the ground loop/swerve encountered. Factors were the gravel and soft terrain at the end of the runway.Mar 23, 1997 · N9185G · Substantial damageNTSB FTW97LA139Accident · No injuriesLimited investigationFinal reportPiper PA-16 · Abilene, TXThe unlatching of the front bench seat for an undetermined reason.Mar 20, 1997 · N6883K · Substantial damageNTSB ANC97LA043Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe pilot's failure to maintain directional control during the takeoff roll.Mar 16, 1997 · N3486C · Substantial damageNTSB CHI97LA087Accident · No injuriesLimited investigationFinal reportCessna T210 · Janesville, WIthe pilot inadvertently retracting the landing gear during the takeoff roll.Mar 15, 1997 · N6677N · Substantial damageNTSB CHI97FA083Accident · No injuriesField investigationFinal reportMcDonnell Douglas DC-9-87 · Detroit, MIthe captains failure to have the airplane deiced prior to takeoff which resulted in ice ingestion into both engines. Factors associated with the accident were the icing weather conditions, wing ice, an inadequate detection of the ice during the preflight, and…Mar 14, 1997 · N753RA · Substantial damageNTSB SEA97IA071Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-8-71F · Portland, ORimproper installation of four attach bolts on the elevator drive torque tube.Mar 12, 1997 · N830BX · No damageNTSB ATL97LA048Accident · 2 fatalLimited investigationFinal reportBill Parson Parson 2+2 · Bunnell, FLThe owner/pilot mechanic's improper bending of the front flight control stick that resulted in an fatigue failure, and the subsequent loss of flight control.Mar 11, 1997 · N254WP · DestroyedNTSB FTW97IA119Incident · No injuriesIncident investigationFinal reportBoeing 727-2K5 · Dfw Airport, TXfailure of the outer bearing for undetermined reason(s).Mar 10, 1997 · N909PG · Minor damageNTSB MIA97FA095Accident · 3 fatalField investigationFinal reportCessna T210L · Meridianville, ALthe pilot's improper decision to takeoff downwind which resulted in his failure to maintain control of the airplane. The winds were a factor.Mar 6, 1997 · N2142S · DestroyedNTSB ANC97LA030Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Dillingham, AKthe pilot's selection of unsuitable terrain for departure, and his inadequate evaluation of the wind conditions. Factors associated with the accident were: a snow/slush covered runway, and a quartering tailwind.Feb 26, 1997 · N32979 · Substantial damageNTSB ANC97LA028Accident · No injuriesLimited investigationFinal reportCessna 185F · Delta Junction, AKthe pilot's inadequate compensation of wind conditins, and failure to maintain directional control during the takeoff run. The crosswind was a related factor.Feb 23, 1997 · N93189 · Substantial damageNTSB NYC97LA056Accident · No injuriesLimited investigationFinal reportCessna 150 · Clarksville, MDThe pilot's failure to maintain directional control and failure to abort the takeoff.Feb 20, 1997 · N11438 · Substantial damageNTSB FTW97LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Salida, COThe airplane's performance being exceeded due to the pilot's inadequate preflight planning. Factors were the uphill runway, high density altitude, and the pilot's lack of experience performing takeoffs from a high altitude airport.Feb 18, 1997 · N4477F · Substantial damageNTSB CHI97TA070Accident · No injuriesFinal reportCessna 172 · Oconto, WIthe failure of the pilot to maintain proper runway alignment and thus clearance with the snow drifts during takeoff. A factor was the distance the snow drifts extended past the runway edge.Feb 15, 1997 · N61914 · Substantial damageNTSB ATL97IA042Incident · No injuriesIncident investigationFinal reportBoeing 727-232 · Atlanta, GAfailure of ground service personnel to properly close the aft cargo door before the airplane departed.Feb 13, 1997 · N416DA · Minor damageNTSB LAX97LA099Accident · No injuriesLimited investigationFinal reportAyres S2R-T65 · Firebaugh, CAfailure of the pilot to compensate for crosswind conditions and to maintain proper runway alignment. Factors relating to the accident were: the crosswind, narrow runway condition, and the soft terrain and ditch beside the runway.Feb 8, 1997 · N3101K · Substantial damageNTSB MIA97LA084Accident · No injuriesLimited investigationFinal reportHughes 269A · Homosassa, FLthe unqualified person's poor judgment, by taking the helicopter without the owner's permission and attempting an unauthorized flight at night; and his failure (or inability) to maintain control the helicopter. Darkness was a related factor.Feb 7, 1997 · N9061R · Substantial damageNTSB CHI97LA064Accident · No injuriesLimited investigationFinal reportCessna 150G · Dowagiac, MIthe pilot's failure to maintain directional control. A factor was the snowbank.Feb 1, 1997 · N4655X · Substantial damageNTSB MIA97LA071Accident · No injuriesLimited investigationFinal reportSocata TB-9 · Daytona Beach, FLthe student pilot's failure to maintain direction control of the airplane during takeoff. The crosswind was a factor.Jan 22, 1997 · N121ER · Substantial damageNTSB FTW97LA082Accident · Minor injuriesLimited investigationFinal reportJohn T. Garrett Baby Great Lakes · El Paso, TXThe pilot's failure to maintain control during takeoff.Jan 14, 1997 · N1030G · Substantial damageNTSB CHI97LA051Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · St. Ignace, MIthe pilot's failure to maintain proper runway alignment during the takeoff roll. A factor associated with the accident was the snowbank which the airplane contacted.Jan 13, 1997 · N33797 · Substantial damageNTSB LAX97LA084Accident · No injuriesLimited investigationFinal reportBeech N35 · Holbrook, AZfatigue failure of the propeller hub, which resulted in separation of the propeller assembly and reduction of aircraft control. Also causal was: the resultant lack of compliance with Airworthiness Directive (AD) 89-26-08, due to ambiguous and unclear wording…Jan 9, 1997 · N7HB · Substantial damageNTSB IAD97LA041Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Blue Bell, PAthe pilot's inadequate handling of the airplane and failure to maintain adequate airspeed, which resulted in a stall, and collision with the ground.Jan 9, 1997 · N68304 · Substantial damageNTSB IAD97FA039Accident · 4 fatalField investigationFinal reportAerostar 601P · Chesapeake, VAfailure of the pilot to maintain proper altitude/clearance above the ground after takeoff. A related factor was the pilot's self-induced pressure to depart before the arrival of bad weather.Jan 3, 1997 · N3CD · DestroyedNTSB MIA97LA056Accident · Minor injuriesLimited investigationFinal reportCessna 441 · Lakeland, FLFailure of the electronic engine control, which caused an overtorque condition in the right engine that made directional control of the airplane not possible by the pilot when the power to the left engine was retarded to idle during the takeoff roll.Jan 2, 1997 · N441MS · DestroyedNTSB MIA97LA054Accident · Serious injuriesLimited investigationFinal reportCessna 150K · Daytona Beach, FLthe pilot's improper planning/decision, by failing to ensure there was sufficient fuel for continued flight, which resulted in fuel exhaustion and subsequent collision with objects (concrete blocks) during a forced landing. Factors relating to the accident…Jan 1, 1997 · N5813G · Substantial damageNTSB MIA97IA050Incident · No injuriesIncident investigationFinal reportDouglas DC8-62 · Orlando, FLThe failure of the captain to center the rudder and close all engine throttles during an aborted takeoff resulting in an uncontrolled turn to the right due to nose wheel steering through the rudder pedals and asymmetric engine thrust. A factor in the incident…Dec 31, 1996 · N804AX · Minor damageNTSB LAX97LA081Accident · No injuriesLimited investigationFinal reportGlobe GC-1B · Jean, NVThe failure of both pilots to maintain directional control of the aircraft, and the instructor's inadequate supervision of the flight. A factor in the accident was the limited conventional gear experience of both pilots.Dec 31, 1996 · N3325K · Substantial damageNTSB NYC97LA028Accident · No injuriesLimited investigationFinal reportCessna 152 · Mansfield, MAthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane veering into a snowbank. The proximity of the snowbank was a related factor.Dec 11, 1996 · N68180 · Substantial damageNTSB ANC97LA010Accident · No injuriesLimited investigationFinal reportCessna 172M · Bethel, AKthe pilot's improper planning/decision, and resultant failure to obtain/maintain sufficient airspeed during takeoff. A factor related the accident was: taking off with a tailwind.Dec 4, 1996 · N20024 · Substantial damageNTSB LAX97LA055Accident · No injuriesLimited investigationFinal reportCessna 170A · El Cajon, CAfailure of the pilot to maintain directional control, which resulted in a ground swerve. The pilot's low total time in conventional gear aircraft was a related factor.Nov 28, 1996 · N1729D · Substantial damageNTSB NYC97LA020Accident · No injuriesLimited investigationFinal reportZukowski EAA Biplane · Williamsport, PAthe pilot's inadequate preflight preparation, which resulted in opening of the unsecured canopy during the takeoff roll, and subsequent loss of directional control and a nose over. A factor was: the pilot's failure to use a checklist.Nov 23, 1996 · N818Z · Substantial damageNTSB FTW97IA045Incident · Minor injuriesIncident investigationFinal reportMcDonnell Douglas MD-82 · Dfw Airport, TXThe failure of the low pressure turbine shaft. A factor was the coke build up on the low pressure turbine shaft.Nov 23, 1996 · N3507A · Minor damageNTSB IAD97FA023Accident · Serious injuriesField investigationFinal reportBeech 65-A90 · Orange, VAThe pilot's inadequate preflight inspection and his failure to complete the pretakeoff checklist which resulted in a takeoff roll with the control lock in place.Nov 16, 1996 · N814SW · DestroyedNTSB LAX97LA041Accident · No injuriesLimited investigationFinal reportBeech F33A · Marana, AZimproper planning/decision by the flight instructor (CFI), which resulted in his failure to recover from a descent during demonstration of a simulated (engine-out) emergency procedure.Nov 14, 1996 · N1567P · Substantial damageNTSB ATL97LA018Accident · No injuriesLimited investigationFinal reportPiper PA-30-160 · Cartersville, GAthe flight instructor's (CFI's) inadequate supervision by failing to ensure that directional control of the aircraft was maintained, during a simulated engine failure. The student pilot's delay in performing the appropriate single-engine emergency procedure…Nov 11, 1996 · N7392Y · Substantial damageNTSB LAX97LA045Accident · No injuriesLimited investigationFinal reportAir Tractor AT-401 · Calexico, CAthe pilot's premature lift-off from the runway and his failure to attain adequate airspeed.Nov 9, 1996 · N1014N · Substantial damageNTSB SEA97LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Bruneau, IDthe pilot's failure to perform adequate preflight planning to ensure that the aircraft could complete a takeoff in the distance available. Factors relating to the accident included: a short takeoff area, and a dirt bank at the end of the road from which the…Nov 7, 1996 · N32518 · Substantial damageNTSB ATL97FA014Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Avon Park, FLThe pilot's improper use of the elevator trim, which resulted in runway contact by the propeller during the takeoff roll and subsequent loss of aircraft control.Oct 31, 1996 · N8353P · Substantial damageNTSB CHI97MA017Accident · 4 fatalMajor investigationFinal reportGulfstream G-IV · Wheeling, ILfailure of the pilot-in-command (PIC) to maintain directional control of the airplane during the takeoff roll in a gusty crosswind, his failure to abort the takeoff, and failure of the copilot to adequately monitor and/or take sufficient remedial action to…Oct 30, 1996 · N23AC · DestroyedNTSB SEA97LA020Accident · Minor injuriesLimited investigationFinal reportKarmy Rotorway Exec · Redmond, ORThe pilot's failure to remove the dolly wheels during the preflight inspection.Oct 25, 1996 · N728PC · Substantial damage