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 ATL97LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Olive Branch, MSThe farmer's failure to maintain security of his livestock/animals.Oct 16, 1996 · N16413 · Substantial damageNTSB FTW97LA012Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502 · Idalou, TXthe pilot's improper planning/decision, which resulted in an overrun during takeoff and an encounter with cotton (crop) and rough/uneven terrain. Factors relating to the accident were: the excessive loading of the airplane for the existing conditions, the…Oct 8, 1996 · N4533H · Substantial damageNTSB SEA97FA003Accident · No injuriesField investigationFinal reportEnstrom F-28C · Spokane, WAa loss of engine power for undetermined reasons.Oct 5, 1996 · N574H · Substantial damageNTSB IAD97LA003Accident · No injuriesLimited investigationFinal reportMaule MX-7 · Mahopac, NYthe pilot's failure to maintain directional control during takeoff, which resulted in a inflight collision with trees (sapplings). A factor related to the accident was: the quartering tailwind that was encountered during takeoff.Oct 5, 1996 · N6124Q · Substantial damageNTSB FTW97LA011Accident · Serious injuriesLimited investigationFinal reportAvian Balloon Skyhawk · Albuquerque, NMThe ground crew member's failure keep clear from the gondola during take off. A factor was the pilot's failure to insure crew coordination during take off.Oct 5, 1996 · N47AV · No damageNTSB FTW97LA008Accident · No injuriesLimited investigationFinal reportCessna 172M · Tuttle, OKfailure of the pilot to maintain directional control during takeoff roll, which resulted in a ground swerve. Factors relating to the accident were: tall grass along the edges of the runway, and the proximity of the fence, fence posts, and trees.Oct 5, 1996 · N172JF · Substantial damageNTSB SEA96LA221Accident · No injuriesLimited investigationFinal reportCessna 172M · Cedar City, UTthe pilot's failure to attain proper airspeed during takeoff, which resulted in a premature lift-off and an encounter with the terrain during the aborted landing. Excessive extension of the wing flaps was a related factor.Oct 1, 1996 · N5459H · Substantial damageNTSB FTW97LA001Accident · Serious injuriesLimited investigationFinal reportContinental Copters EL Tomcat MK-5A · Lafayette, LAthe pilot's failure to ensure a proper preflight and the groundcrew's failure to remove the tiedown. Factors were pilot and groundcrew fatigue.Oct 1, 1996 · N7MH · Substantial damageNTSB ANC96LA164Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · Aniak, AKThe pilot's failure to remove all snow and ice from the airplane prior to takeoff.Sep 24, 1996 · N5343G · Substantial damageNTSB CHI96LA345Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Kearney, MOthe pilot's improper use of carburetor heat, which resulted in a reduction of engine power and subsequent collision with the terrain, during a forced landing.Sep 20, 1996 · N25920 · Substantial damageNTSB CHI96FA342Accident · Serious injuriesField investigationFinal reportGrumman F9F-2 · Kalamazoo, MIThe overrun of the runway as a result of the pilot's misjudgment of speed and distance because of an unreliable airspeed indication; reason for the unreliable airspeed indication was undetermined. Contributing to the accident was the pilot's perception of a…Sep 19, 1996 · NX72WP · Substantial damageNTSB LAX96LA337Accident · No injuriesLimited investigationFinal reportCessna 152 · San Carlos, AZthe pilot's decision to attempt a takeoff with the runway lights inoperative, and his failure to maintain runway alignment during an aborted takeoff, after failure of the landing light. Factors relating to the accident were: darkness, inoperative runway…Sep 16, 1996 · N5120H · Substantial damageNTSB IAD96LA145Accident · Serious injuriesLimited investigationFinal reportDickmann Pitts S-1 · Meriden, CTfailure of the pilot to maintain control of the airplane during take off.Sep 11, 1996 · N27DD · Substantial damageNTSB LAX96LA332Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Lancaster, CAfailure of the student pilot to maintain direction control of the airplane, which resulted in an inadvertent ground swerve and subsequent collapse of the nose gear, during an encountered with soft terrain.Sep 10, 1996 · N4308F · Substantial damageNTSB MIA96LA228Accident · Minor injuriesLimited investigationFinal reportCanadair T-33 · Punta Gorda, FLfailure of the pilot to extend the wing flaps for takeoff, and his failure to attain sufficient airspeed for flight with the flaps retracted, which resulted in a stall/mush after lift-off.Sep 7, 1996 · N99195 · Substantial damageNTSB FTW96LA378Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Loreauville, LAThe pilot's inadequate preflight planning/preparation for the flight, resulting in exceeding the maximum gross weight and performance of the helicopter. A factor was the high density altitude.Sep 6, 1996 · N80750 · Substantial damageNTSB FTW96LA377Accident · Serious injuriesLimited investigationFinal reportPzl-Mielec MIG-17 · Amarillo, TXThe pilot's excessive takeoff rotation which led to premature lift-off at a speed inadequate to maintain flight. A factor was the pilot's lack of experience in the MIG-17.Sep 6, 1996 · N1719 · DestroyedNTSB MIA96TA221Accident · No injuriesFinal reportBell OH-58A · Wetumpka, ALThe student pilot improper use of flight controls (cyclic a nd collective) on a takeoff to a hover, resulting in the helicopter rolling to the right, and the main rotor blade colliding with the ground.Sep 3, 1996 · N160SA · Substantial damageNTSB ANC96LA138Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mccarthy, AKThe pilot's inadequate compensation for gusty wind conditions, and his selection of an unsuitable landing/takeoff site. A factor associated with the accident was the gusty wind.Sep 1, 1996 · N1879A · Substantial damageNTSB ANC96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Tyonek, AKthe pilot's premature liftoff and subsequent inadvertent stall.Sep 1, 1996 · N4393Z · Substantial damageNTSB ANC96LA169Accident · No injuriesLimited investigationFinal reportPiper PA-18-160 · Northway, AKThe pilot's premature lift-off. A factor associated with the accident was the rough and uneven airstrip.Aug 26, 1996 · N2683A · Substantial damageNTSB NYC96LA177Accident · No injuriesLimited investigationFinal reportCessna 152 · Rome, NYThe pilot's improper decision to take off on a runway of insufficient length, and his failure to obtain adequate airspeed.Aug 25, 1996 · N45949 · Substantial damageNTSB MIA96LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Williamson, GAThe failure of the pilot to maintain directional control during takeoff.Aug 24, 1996 · N7061R · Substantial damageNTSB LAX96LA313Accident · No injuriesLimited investigationFinal reportPiper PA-46-310P · Redlands, CAthe pilot's improper weather evaluation. The uphill runway condition and weather associated with thunderstorm(s) were related factors.Aug 23, 1996 · N9130N · Substantial damageNTSB FTW96LA356Accident · No injuriesLimited investigationFinal reportBell 47 Soloy · Intracoastal, LAthe loss of aircraft control by unknown person(s).Aug 23, 1996 · N1169W · DestroyedNTSB ANC96LA127Accident · No injuriesLimited investigationFinal reportCessna 170B · Cantwell, AKA failure of the pilot to provide sufficient takeoff distance from the edge of the departure lake and his premature liftoff.Aug 18, 1996 · N3546C · Substantial damageNTSB FTW96LA364Accident · No injuriesLimited investigationFinal reportCessna 152 · Spring, TXfailure of the pilot to maintain directional control of the airplane during a touch-and-go, which resulted in an inadvertent ground swerve, an encounter with soft terrain, and a nose over of the airplane.Aug 17, 1996 · N89032 · Substantial damageNTSB FTW96LA349Accident · 1 fatalLimited investigationFinal reportAyres S2R-T34 · W. Helena, ARThe inadequate visual lookout of the vehicle driver and his inadvertent driving of the vehicle onto the runway resulting in the pilot of the departing aircraft performing an evasive maneuver in an attempt to avoid the collision.Aug 17, 1996 · N3095X · DestroyedNTSB ATL96LA120Accident · No injuriesLimited investigationFinal reportGreat Lakes GL2T-1A-2 · Montgomery, ALThe locked rudder in a fully deflected position which resulted in the pilot's inability to maintain directional control.Aug 17, 1996 · N47L · Substantial damageNTSB SEA96LA193Accident · No injuriesLimited investigationFinal reportCessna A185E · Cody, WYfailure of the pilot to maintain directional control of the airplane and runway alignment during the takeoff roll. Factors relating to the accident were: the crosswind, and possible dragging of the right brake.Aug 15, 1996 · N185K · Substantial damageNTSB IAD96LA133Accident · No injuriesLimited investigationFinal reportPiper PA-31T · Pottstown, PAThe pilot's failure to maintain directional control during takeoff/ground run resulting in in-flight collision with a fence. Related factors were the pilot's poor planning/decision making, and the fog.Aug 14, 1996 · N163SA · Substantial damageNTSB IAD96LA130Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Gaithersburg, MDthe unexpected appearance of a deer on the runway.Aug 9, 1996 · N1439T · Substantial damageNTSB MIA96LA206Accident · No injuriesLimited investigationFinal reportGrumman 164A · Marks, MSthe pilot's failure to remain clear of the known high point on runway.Aug 7, 1996 · N665U · Substantial damageNTSB FTW96LA338Accident · No injuriesLimited investigationFinal reportCessna A188B · Winnsboro, LAThe pilot's failure to maintain airspeed and altitude/clearance during the takeoff. A factor was the density altitude.Aug 7, 1996 · N92917 · Substantial damageNTSB ATL96LA117Accident · No injuriesLimited investigationFinal reportGrumman G164 · Dawson, GAloss of engine power for undetermined reason(s), which resulted in an overrun, an encounter with soft terrain, and a nose over.Aug 7, 1996 · N8672H · DestroyedNTSB FTW96LA333Accident · No injuriesLimited investigationFinal reportEmroth-Emair MA-1B · Clayton, LAThe pilot's failure to maintain directional control during the takeoff roll. A factor was the wet grass runway.Aug 4, 1996 · N9918M · Substantial damageNTSB FTW96LA332Accident · No injuriesLimited investigationFinal reportAyres S2R-G5 · Start, LAa leak in the turbine scavenge pump oil supply line, due to chafing of its separated shield assembly, which resulted in an oil leak, oil starvation, and activation of the propeller feathering system.Aug 4, 1996 · N20GH · DestroyedNTSB CHI96LA279Accident · No injuriesLimited investigationFinal reportSchleicher ASK-13 · Thompsonville, MIan evasive maneuver necessitated by the tow plane's aborted takeoff.Aug 4, 1996 · N11EK · Substantial damageNTSB FTW96LA330Accident · No injuriesLimited investigationFinal reportSchleicher KA6-CR · Forrest City, ARthe pilot's failure to abort the takeoff. Factors were the dust restricting his visibility and the uneven terrain.Aug 3, 1996 · N445M · Substantial damageNTSB CHI96LA268Accident · No injuriesLimited investigationFinal reportUltravia Aero Int'l Pelican · Winneconne, WIfailure of the pilot to maintain directional control of the airplane during the takeoff roll, which resulted in a ground swerve. The location of the tree was a related factor.Aug 1, 1996 · CFPWZ · Substantial damageNTSB CHI96LA261Accident · No injuriesLimited investigationFinal reportCessna 188B · Cimarron, KSthe pilot's failure to make a timely decision to abort the takeoff or dump the payload.Jul 30, 1996 · N441Q · Substantial damageNTSB ANC96LA107Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's inadequate preflight planning for departure and his selection of unsuitable terrain. Factors in the accident were soft, snow covered terrain and the pilot's delay in aborting the takeoff.Jul 28, 1996 · N70018 · DestroyedNTSB CHI96LA265Accident · No injuriesLimited investigationFinal reportGrumman G-164A · Macksville, KSfailure of the pilot to allow the airplane to achieve sufficient airspeed for takeoff, and the resultant loss of aircraft control. Factors relating to the accident were: the rough runway, and the mound of dirt at the end of the runway.Jul 27, 1996 · N4630 · Substantial damageNTSB NYC96LA159Accident · No injuriesLimited investigationFinal reportAeronca 11AC · Alexandria, NJfailure of the commercial pilot to ensure that directional control was maintained during takeoff, which led to a ground swerve and collision with a fence.Jul 26, 1996 · N9232E · Substantial damageNTSB ANC96LA106Accident · Minor injuriesLimited investigationFinal reportCessna 182 · Nikiski, AKThe pilot's failure to maintain directional control during takeoff.Jul 24, 1996 · N2831F · Substantial damageNTSB SEA96LA162Accident · No injuriesLimited investigationFinal reportConkey/Wapelhorst Lancair 235 · Cottage Grove, ORrelease of the main landing gear locking mechanism for undetermined reason(s).Jul 20, 1996 · N235WC · Substantial damageNTSB MIA96LA191Accident · Serious injuriesLimited investigationFinal reportFairchild Hiller FH1100 · Lutz, FLthe pilot's improper use of the flight controls (collective and cyclic), while conducting a ground run, resulting in a roll over.Jul 19, 1996 · N5061F · Substantial damageNTSB SEA96LA155Accident · No injuriesLimited investigationFinal reportGrumman G-164A · New Plymouth, IDa cracked cylinder head, which resulted in partial loss of engine power during takeoff. Factors relating to the accident were: the pilot allowed the gross weight of the airplane to be exceeded, and tall wheat (crop) in the emergency landing area.Jul 15, 1996 · N48442 · Substantial damageNTSB IAD96LA114Accident · No injuriesLimited investigationFinal reportCessna 152 · Blue Ash, OHfailure of the pilot to maintain directional control of the airplane, while rolling to takeoff from a touch-and-go landing.Jul 14, 1996 · N6468Q · Substantial damageNTSB CHI96LA243Accident · No injuriesLimited investigationFinal reportBeech C-45H · Marshall, MIfailure of the pilot to maintain directional control during the takeoff roll, which resulted in an inadvertent ground swerve. The crosswind (quartering headwind) was a related factor.Jul 14, 1996 · N9772Z · Substantial damage