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 DEN04IA012Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas DC-10-10 · Denver, COthe manufacturer's improper installation of the inboard slat drive mechanism's lower left hand anti-torque strut, which resulted in the axial migration of the rod-end bearing, the binding of the anti-torque strut, and the subsequent activation of the slat…Oct 12, 2003 · N375FE · Minor damageNTSB LAX04LA009Accident · Minor injuriesLimited investigationFinal reportLuscombe 8F · Murrieta, CAThe pilot's inadequate evaluation of the weather which resulted in VFR flight into IMC, and his failure to maintain terrain clearance. Fog and rising terrain were contributing factors.Oct 11, 2003 · N1918B · Substantial damageNTSB LAX04CA010Accident · No injuriesData collectionFinal reportAvions Max Holste MH 1521 Broussard · El Cajon, CAthe pilot's premature liftoff and his failure to attain an adequate takeoff airspeed, which resulted in a stall. The pilot's failure to correctly set the pitch trim before takeoff was a factor.Oct 11, 2003 · N239HL · Substantial damageNTSB ATL04LA006Accident · No injuriesLimited investigationFinal reportPiper J-3 -C65 · Jackson, TNThe pilot's improper us of flight controls during an attempted takeoff, which resulted in an collision with the specially equipped automobile.Oct 4, 2003 · N38272 · Substantial damageNTSB FTW03CA233Accident · Minor injuriesData collectionFinal reportHughes 269C · Gail, TXThe loss of control for undetermined reasons.Sep 28, 2003 · N9620F · Substantial damageNTSB ATL03LA150Accident · Minor injuriesLimited investigationFinal reportSherman Holie Freebird · Newnan, GAThe failure of the aileron control rod, and subsequent loss of control in-flight.Sep 27, 2003 · UNREG · Substantial damageNTSB CHI03FA320Accident · 1 fatalField investigationFinal reportCessna 152 · Three Oaks, MIThe pilot not maintaining adequate airspeed resulting in a stall during takeoff. Contributing factors were the buzzing flight and trees.Sep 25, 2003 · N25787 · DestroyedNTSB CHI03LA325Accident · No injuriesLimited investigationFinal reportBrice Lancair Legacy · Kimberling City, MOThe pilot's delayed aborted takeoff. Contributing to the accident was the pilot's inadequate preflight planning/preparation in his failure to remove the pitot cover.Sep 19, 2003 · N27RM · Substantial damageNTSB MIA03LA183Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Fort Pierce, FLFailure of one blade in the engine compressor turbine disk due to fatigue which was caused by loss of gap between the blade platforms as a result of corrosion due to a foreign element (phosphate). This resulted in loss of engine power during takeoff and…Sep 18, 2003 · N1528T · DestroyedNTSB ANC03LA122Accident · No injuriesLimited investigationFinal reportCessna 180 · Cape Yakataga, AKThe pilot's selection of unsuitable terrain for departure, which resulted in a collision with a log during the takeoff roll. Factors contribuiting to the accident were the presence of hidden obstructions, and sunglare.Sep 18, 2003 · N2162Z · Substantial damageNTSB LAX03CA296Accident · No injuriesData collectionFinal reportCessna 182K · Young, AZthe collision with a bull during takeoff.Sep 17, 2003 · N2646R · Substantial damageNTSB NYC03LA200Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Ashland, VAThe pilot's decision to perform an aborted takeoff after he perceived a power loss. A factor was the unsuitable terrain the airplane encountered after it overran the end of the runway.Sep 15, 2003 · N32DQ · Substantial damageNTSB ANC03LA115Accident · Minor injuriesLimited investigationFinal reportPiper PA-18 · Iliamna, AKThe pilot's failure to maintain control of the airplane during the takeoff run, which resulted in the airplane nosing over in the water. Factors contributing to the accident were wind gusts, and the pilot's inadequate evaluation of the wind conditions.Sep 15, 2003 · N3795Z · Substantial damageNTSB ANC03LA121Accident · No injuriesLimited investigationFinal reportCessna 180 · Kenai, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in an overrun and nose over during an aborted takeoff. Factors contributing to the accident were soft, sandy terrain, and a tailwind.Sep 14, 2003 · N9907V · Substantial damageNTSB CHI03LA310Accident · No injuriesLimited investigationFinal reportCessna 182D · Rushville, INThe pilot failed to maintain control of the airplane during the initial takeoff climb which resulted in an inadvertent stall.Sep 12, 2003 · N8702X · Substantial damageNTSB CHI03LA311Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Cash, ARThe delayed aborted takeoff by the pilot. The ditch was a factor to the accident.Sep 9, 2003 · N3299X · Substantial damageNTSB NYC03CA193Accident · No injuriesData collectionFinal reportCessna 150M · Jetersville, VAThe pilot's delayed decision to abort the takeoff, which resulted in an overrun. A factor was the dew on the grass.Sep 7, 2003 · N63600 · Substantial damageNTSB FTW03FA212Accident · 2 fatalField investigationFinal reportCessna 172L · New Braunfels, TXThe pilot's failure to maintain airspeed sufficient for flight resulting in an inadvertent stall/spin during takeoff.Sep 6, 2003 · N7632G · DestroyedNTSB CHI03LA318Accident · Minor injuriesLimited investigationFinal reportDixon Glasair II · Columbia, ILThe pilot's failure to maintain directional control during an aborted takeoff. Contributing factors were the open cabin door, the grass runway and the soft terrain adjacent to the runway.Sep 6, 2003 · N817CD · Substantial damageNTSB ANC03LA120Accident · No injuriesLimited investigationFinal reportCessna 150 · Tanana, AKThe pilot's failure to abort the takeoff after encountering muddy terrain during the takeoff roll, which resulted in a runway overrun and collision with trees. A factor in the accident was the muddy runway.Sep 6, 2003 · N6767F · Substantial damageNTSB FTW03FA211Accident · Minor injuriesField investigationFinal reportAgusta A109E · Dallas, TXThe reported loss of engine power for undetermined reasons. A contributing factor was the failure to maintain clearance with the safety fence during the aborted takeoff, which resulted in a dynamic rollover of the helicopter.Sep 4, 2003 · N143CF · Substantial damageNTSB NYC03CA188Accident · No injuriesData collectionFinal reportLancair IVP · Manassas, VAThe pilot's failure to follow the published takeoff procedures for the make and model airplane and his failure to maintain directional control during takeoff.Sep 2, 2003 · N789HS · Substantial damageNTSB ATL03CA135Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Murfreesboro, TNAn on-ground collision with an animal (deer) during an attempted takeoff. .Sep 1, 2003 · N3542K · Substantial damageNTSB MIA03CA174Accident · No injuriesData collectionFinal reportCessna 152 · Ocala, FLthe student pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with a ditch.Aug 30, 2003 · N93193 · Substantial damageNTSB LAX03CA269Accident · Minor injuriesData collectionFinal reportPiper PA-38-112 · Joshua Tree, CAthe student pilot failed to maintain directional control of the airplane during the takeoff roll.Aug 30, 2003 · N2318L · Substantial damageNTSB SEA03CA178Accident · No injuriesData collectionFinal reportBeech C24R · Bend, ORThe first pilot's premature liftoff and his failure to abort the takeoff. Factors include a fence and a ditch bank located upwind of the runway.Aug 26, 2003 · N6536C · Substantial damageNTSB FTW03LA235Accident · No injuriesLimited investigationFinal reportVelocity RG · Skiatook, OKThe pilot's delay in aborting the takeoff. A contributing factor was the high density altitude.Aug 23, 2003 · N113JG · Substantial damageNTSB CHI03LA265Accident · No injuriesLimited investigationFinal reportCessna 188B · Monette, ARFailure of the right brake and the pilot's inability to maintain directional control. A factor associated with the accident was the ditch.Aug 23, 2003 · N5647G · Substantial damageNTSB MIA03LA163Accident · No injuriesLimited investigationFinal reportBeech 400A · St. Augustine, FLThe inadvertent left brake application by the copilot during the takeoff roll and the delay by the pilot-in-command to abort the takeoff resulting in a loss of directional control, and on-ground encounter with terrain.Aug 18, 2003 · N51NP · Substantial damageNTSB LAX03IA259Incident · No injuriesIncident investigationFinal reportAirbus A340-300 · Honolulu, HIthe failure of the center landing gear tires as a result of low tire pressure.Aug 18, 2003 · C-FYKX · Minor damageNTSB ANC03CA097Accident · No injuriesData collectionFinal reportCessna 170B · Sparrevohn, AKThe pilot's inadequate compensation for a crosswind, which resulted in collapse of the left main landing gear during the takeoff roll. A factor was the crosswind.Aug 18, 2003 · N8016A · Substantial damageNTSB FTW03LA202Accident · Minor injuriesLimited investigationFinal reportBeech BE-36TC · Temple, TXThe pilot's failure to attain adequate airspeed and his failure to abort the takeoff roll resulting in an overrun.Aug 16, 2003 · N93PP · Substantial damageNTSB CHI03LA270Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Hudson, ILThe pilot failed to abort the takeoff. A factor was the soybean crop.Aug 15, 2003 · N9187Z · Substantial damageNTSB ANC03CA114Accident · No injuriesData collectionFinal reportCessna 206 · Ketchikan, AKThe pilot's selection of an unsuitable takeoff area, which resulted in an in-flight collision with ocean waves. A factor associated with the accident was large waves/swells.Aug 14, 2003 · N59352 · Substantial damageNTSB MIA03CA165Accident · No injuriesData collectionFinal reportCessna 170B · La Belle, FLThe failure of the pilot to maintain directional control during takeoff resulting in ground looping and substantial damage.Aug 13, 2003 · N2987D · Substantial damageNTSB CHI03FA259Accident · 3 fatalField investigationFinal reportBell 206L-3 · E.I. 276, LAThe inadequate compensation for crosswind conditions and the directional control not obtained/maintained by the pilot during takeoff. Contributing factors were the crosswind and the planned approach to position the helicopter with a crosswind in order to…Aug 13, 2003 · N41128 · Substantial damageNTSB SEA03LA168Accident · No injuriesLimited investigationFinal reportNolen Kitfox Lite Squared · Homedale, IDThe pilot's inadequate compensation for winds and his failure to maintain an airspeed above stalling speed (Vs) just as the aircraft was becoming airborne during the takeoff roll. Factors include a gusty quartering tailwind, and the pilot's preflight decision…Aug 12, 2003 · N222JN · Substantial damageNTSB ANC03LA093Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glennallen, AKThe pilot's selection of unsuitable terrain for takeoff, which resulted in a nose over. A factor contributing to the accident was the soft sand of the sandbar.Aug 10, 2003 · N3695P · Substantial damageNTSB CHI03FA251Accident · 1 fatalField investigationFinal reportCessna 182G · Topeka, KSThe pilot's failure to maintain adequate airspeed resulting in a stall during takeoff. Contributing factors were the low altitude he was at during the takeoff, and the trees.Aug 8, 2003 · N2064R · DestroyedNTSB MIA03CA158Accident · No injuriesData collectionFinal reportCessna 172S · Orlando, FLThe failure of the student pilot to maintain directional control of the airplane during takeoff roll resulting in the aircraft departing the runway and incurring substantial damage.Aug 7, 2003 · N775SP · Substantial damageNTSB ANC03LA104Accident · No injuriesLimited investigationFinal reportAviat A-1A · Sitka, AKThe pilot's delay in aborting the takeoff, which resulted in a collision with the shoreline during an aborted takeoff.Aug 7, 2003 · N113N · Substantial damageNTSB DEN03LA140Accident · No injuriesLimited investigationFinal reportCessna 337F · Las Cruces, NMLack of adequate power from the rear engine for undetermined reasons and the pilot's failure to maintain aircraft control during take-off. A contributing factor to the accident was the low altitude.Aug 6, 2003 · N8921M · Substantial damageNTSB CHI03LA247Accident · Minor injuriesLimited investigationFinal reportTexas Helicopter OH-13E · Byron, ILThe pilot not attaining translational lift during the takeoff. A factor was the high gross weight.Aug 6, 2003 · N38096 · Substantial damageNTSB NYC03CA170Accident · No injuriesData collectionFinal reportBell 47G-2A · Jackson, NJPilot's inadequate preflight inspection and failure to remove a pesticide spraying hose from the helicopter prior to takeoff, which resulted in a loss of control.Jul 30, 2003 · N7796C · Substantial damageNTSB MIA03TA152Accident · No injuriesFinal reportBell BHT-206-B3 · Fort Myers, FLThe pilot's failure to adequately clear the right skid of obstructions which resulted in a dynamic rollover to the right during takeoff and damage to the helicopter.Jul 30, 2003 · N876M · Substantial damageNTSB MIA03LA150Accident · 1 fatalLimited investigationFinal reportTurkan Delta Wing Kite Trik · Odessa, FLThe pilot's improper assembly and failure to connect a bolt following an attempted modification that resulted in airframe malfunction, and uncontrolled descent, and an impact with the ground.Jul 28, 2003 · UNREG · Substantial damageNTSB SEA03CA155Accident · Minor injuriesData collectionFinal reportCessna 170B · Schafer, MTThe pilot's delayed remedial action during the takeoff roll. Factors include wet terrain, a fence and an embankment located at the end of the runway.Jul 27, 2003 · N1979C · Substantial damageNTSB CHI03LA228Accident · Minor injuriesLimited investigationFinal reportFerence Varieze · Macomb, MIThe pilot's failure to secure the window canopy before takeoff and his failure to maintain directional control which resulted in a loss of control. The pilot's diverted attention is a contributing factor.Jul 26, 2003 · N617JF · Substantial damageNTSB CHI03LA225Accident · No injuriesLimited investigationFinal reportBeech C23 · Madison, WIThe dual student's delay in executing the aborted takeoff. Also causal was the pilot-in-command's delayed remedial action.Jul 25, 2003 · N9361S · Substantial damageNTSB DEN03LA135Accident · No injuriesLimited investigationFinal reportCessna A185F · Angel Fire, NMthe instructor's inadequate supervision which resulted in the pilot's loss of directional control and the subsequent impact with the ditch. Contributing factors include the instructor's inadequate remedial action and the inadvertent ground loop/swerve.Jul 22, 2003 · N60VA · Substantial damage