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 DEN03LA132Accident · No injuriesLimited investigationFinal reportCessna 172P · Watkins, COthe right seat shifting aft during the take off roll, rendering aircraft control not possible by the flight instructor. Contributing factors include the inboard seat pin which did not engage fully, the outboard seat pin which was installed incorrectly, the…Jul 17, 2003 · N98969 · Substantial damageNTSB CHI03LA215Accident · No injuriesLimited investigationFinal reportAyres S2R-G6 · Esmond, NDThe obstruction of the windshield by the application chemical restricting the pilot's visual lookout, and the pilot's failure to perform an aborted takeoff. Factors contributing to the accident were the leak in the hopper lid and the drainage ditch.Jul 17, 2003 · N3105U · Substantial damageNTSB IAD03CA065Accident · No injuriesData collectionFinal reportDiamond Aircraft Industries DA20-C1 Katana · Hillsboro, TXThe pilot's failure to maintain directional control of the airplane during the takeoff roll. A factor in the accident was the pilot's lack of total flying experience.Jul 16, 2003 · N905CT · Substantial damageNTSB FTW03LA187Accident · No injuriesLimited investigationFinal reportMikoyan MIG-15BIS · Little Rock, ARThe loss of engine power during takeoff for undetermined reasons.Jul 16, 2003 · N15PE · Substantial damageNTSB LAX03LA230Accident · Minor injuriesLimited investigationFinal reportAero Commander S2R · Tulelake, CAThe pilot's inadequate preflight inspection and failure to remove the gust lock, which resulted in his loss of airplane control.Jul 10, 2003 · N8912Q · Substantial damageNTSB SEA03LA126Accident · No injuriesLimited investigationFinal reportDruckman 102 · Alsea, ORThe pilot's failure to maintain directional control during the take-off roll, when his foot became lodged between the rudder pedal and the heel brake. An additional factor is a fence near the area where he was taking off from.Jul 7, 2003 · N102DR · Substantial damageNTSB CHI03LA200Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Fort Smith, ARThe loss of engine power for undetermined reasons during the climb out. A factor was the ditch encountered during the forced landing.Jul 7, 2003 · N569RA · Substantial damageNTSB CHI03LA203Accident · Serious injuriesLimited investigationFinal reportAerotrike DPS · Brandon, IAThe non-certificated pilot selected unsuitable terrain for takeoff when he departed from a bean field, and the airplane stalled as a result of low airspeed during takeoff climb. Factors to the accident included the pilot's total lack of experience, the…Jul 5, 2003 · UNREG · Substantial damageNTSB NYC03LA145Accident · No injuriesLimited investigationFinal reportMooney M20J · De Lancey, NYThe pilot's delayed decision to perform an aborted takeoff, which did not allow for sufficient room to stop. A factor was the grass runway.Jul 1, 2003 · N1084B · Substantial damageNTSB MIA03LA138Accident · No injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Belle Glade, FLThe inability of the pilot to maintain directional control of the airplane following a blown right main landing gear tire during the takeoff roll, resulting in the airplane rolling into soft terrain and subsequent nose over. A factor in the accident was the…Jul 1, 2003 · N82120 · Substantial damageNTSB CHI03LA188Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Brazil, INThe delayed aborted takeoff by the pilot-in-command. A contributing factor was the fence, which the airplane contacted during the aborted takeoff.Jun 29, 2003 · N1660H · Substantial damageNTSB NYC03LA140Accident · Minor injuriesLimited investigationFinal reportChampion 7EC · Point Pleasant, WVThe CFI's failure to maintain directional control, which resulted in a collision with trees.Jun 27, 2003 · N7570E · Substantial damageNTSB SEA03CA112Accident · No injuriesData collectionFinal reportCessna 177 · Woodland, WAThe pilot's premature liftoff and his failure to maintain/obtain airspeed and directional control during takeoff.Jun 20, 2003 · N2279Y · Substantial damageNTSB SEA03FA106Accident · 1 fatalField investigationFinal reportDowner RC-3 · Yelm, WAThe failure of the pilot to abort the takeoff roll. Factors contributing to the accident included the failure of the aircraft to accelerate for undetermined reasons and the trees.Jun 17, 2003 · N6723K · DestroyedNTSB CHI03LA168Accident · No injuriesLimited investigationFinal reportCessna A188B · Hornersville, MOThe pilot's failure to maintain directional control of the airplane during takeoff. A contributing factor was the crosswind.Jun 17, 2003 · N70403 · Substantial damageNTSB CHI03LA160Accident · No injuriesLimited investigationFinal reportPiper PA-24 · Harvey, NDThe aborted takeoff not performed by the pilot. The inadequate short field takeoff procedure by the pilot and the short grass runway were contributing factors.Jun 13, 2003 · N21533 · Substantial damageNTSB MIA03FA120Accident · Minor injuriesField investigationFinal reportAerospatiale AS355F1 · Madison, FLThe pilot in command's diverted attention and loss of control while attempting to takeoff, which resulted in the main rotor blades being dragged, and the helicopter rolling over.Jun 11, 2003 · N217ES · Substantial damageNTSB ATL03CA105Accident · Minor injuriesData collectionFinal reportAyers RV-6A · St. Simons Isld, GAThe pilot's inadequate preflight inspection that resulted in his failure to remove the seatbelt (flight control gust lock) from the right side flight control stick.Jun 11, 2003 · N221SA · Substantial damageNTSB CHI03LA156Accident · No injuriesLimited investigationFinal reportDromader M-18 · Dumas, ARThe pilot's delay in aborting the takeoff and his intentional maneuver to avoid the obstruction at the end of the runway. Contributing factors were the road and ditch.Jun 9, 2003 · N51402 · Substantial damageNTSB CHI03LA154Accident · Minor injuriesLimited investigationFinal reportBraunschmidt RV-6A · Tea, SDThe loss of engine power for undetermined reasons and the unsuitable terrain for landing encountered. Contributing factors to this accident were the crop and the collapse of the nose landing gear strut.Jun 9, 2003 · N160BM · Substantial damageNTSB ANC03LA057Accident · Minor injuriesLimited investigationFinal reportCessna 185 · Talkeetna, AKThe pilot's excessive taxi speed while attempting to turn the airplane in soft snow, which resulted in a nose over. A factor in the accident was soft snow.Jun 9, 2003 · N5246E · Substantial damageNTSB NYC03LA122Accident · No injuriesLimited investigationFinal reportCessna 150 · Culpeper, VAThe pilot's failure to maintain directional control on the runway during takeoff.Jun 8, 2003 · N92WA · Substantial damageNTSB CHI03FA151Accident · 2 fatalField investigationFinal reportCessna 172P · Sheboygan, WIThe pilot failed to maintain control of the airplane after encountering instrument meteorological conditions during takeoff. Factors associated with the accident were the low ceiling, fog and lack of instrument rating.Jun 8, 2003 · N63319 · DestroyedNTSB FTW03LA166Accident · Minor injuriesLimited investigationFinal reportBell 47G-2 · Franklinton, LAThe pilot's encounter with dynamic rollover due to his failure to properly remove the tie-down strap on the right skid prior to takeoff. Factors were the pilot's inadequate preflight preparation and failure to abort takeoff.Jun 4, 2003 · N90485 · Substantial damageNTSB CHI03LA158Accident · No injuriesLimited investigationFinal reportCessna 152 · Owensville, MOThe pilots delayed attempt to perform an aborted takeoff and subsequent overrun. Contributing factors to the accident were the fence and the ditch.Jun 2, 2003 · N68778 · Substantial damageNTSB CHI03LA148Accident · Minor injuriesLimited investigationFinal reportWSK PZL Mielec M-18A · Reydell, ARThe pilot's failure to maintain directional control during initial climb.Jun 2, 2003 · N135RA · Substantial damageNTSB MIA03LA116Accident · No injuriesLimited investigationFinal reportCessna 172N · Clearwater, FLthe pilot's failure to maintain directional control during the takeoff roll, which resulted in the airplane departing the runway, and impacting with trees.Jun 1, 2003 · N9758G · Substantial damageNTSB SEA03LA091Accident · No injuriesLimited investigationFinal reportCessna 150 · Dillon, MTThe pilot's failure to maintain directional control during the takeoff roll, and his inadequate remedial actions during his attempt to realign the aircraft with the runway. Factors include a crosswind, and the pilot's lack of experience in tailwheel-equipped…May 31, 2003 · N4424U · Substantial damageNTSB SEA03LA090Accident · No injuriesLimited investigationFinal reportBeech 95 C-55 · Canby, ORThe pilot's inadequate preflight planning resulting in fuel starvation and subsequent loss of power after takeoff. High vegetation was a factor.May 31, 2003 · N660K · Substantial damageNTSB CHI03LA144Accident · Serious injuriesLimited investigationFinal reportGrumman G-164B · Superior, NEThe pilot's failure to maintain adequate airspeed, and the delayed remedial action by the pilot, resulting in a stall. Factors to the accident included the aircraft’s low altitude and the pilot's lack of experience in the make/model of aircraft.May 31, 2003 · N48597 · Substantial damageNTSB DEN03LA083Accident · No injuriesLimited investigationFinal reportCessna 172S · Cedar City, UTthe pilot's inadequate compensation for wind conditions, and his failure to maintain directional control.May 21, 2003 · N5278H · Substantial damageNTSB CHI03LA136Accident · No injuriesLimited investigationFinal reportPiper PA-11 · Minocqua, WIThe pilot's failure to attain a proper climb rate during takeoff. A factor to the accident was the tree.May 17, 2003 · N4711U · Substantial damageNTSB LAX03LA151Accident · No injuriesLimited investigationFinal reportCessna 172S · Camarillo, CAthe student pilot's failure to maintain directional control, resulting in a collision with terrain. The flight instructor's inadequate supervision of the flight and delayed remedial action were also causal.May 15, 2003 · N585TM · Substantial damageNTSB ATL03LA093Accident · Minor injuriesLimited investigationFinal reportCessna 172K · Bristol, TNThe pilot's improper use of the rudder controls during the takeoff roll resulting in a loss of directional control, and the on-ground collision with an embankment.May 15, 2003 · N7412G · Substantial damageNTSB MIA03CA107Accident · No injuriesData collectionFinal reportMichael Allen Brown RAF 2000 GTX · Punta Gorda, FLThe pilot's failure to maintain rotor speed during the takeoff which resulted in the gyrocopter descending and the main rotor impacting the ground, incurring damage.May 10, 2003 · N9DQ · Substantial damageNTSB MIA03CA106Accident · No injuriesData collectionFinal reportEnstrom 280C · Panama City Bch, FLThe pilot's failure to maintain adequate rotor rpm and altitude during takeoff which resulted in the helicopter impacting the water during a descent in an attempt to maintain rotor rpm.May 10, 2003 · N51752 · Substantial damageNTSB MIA03LA104Accident · Minor injuriesLimited investigationFinal reportBrantly B-2B · Lantana, FLThe pilot/owner's failure to maintain rotor rpm which resulted in a loss of control. Contributing factors were high gross weight and high density altitude.May 5, 2003 · N2141U · Substantial damageNTSB FTW03LA142Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Needham, ARThe total loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Apr 29, 2003 · N7546R · Substantial damageNTSB FTW03LA141Accident · No injuriesLimited investigationFinal reportAir Tractor AT-502B · Pond Creek, OKThe pilot's failure to attain adequate airspeed during liftoff resulting in a stall.Apr 28, 2003 · N60819 · DestroyedNTSB NYC03LA091Accident · No injuriesLimited investigationFinal reportCessna 172K · Burnham, PAThe pilot's failure to maintain directional control during the takeoff roll.Apr 27, 2003 · N758XB · Substantial damageNTSB NYC03LA090Accident · 1 fatalLimited investigationFinal reportStarnes Quickie Q-200 · Henderson, KYThe pilot's improper recovery from a bounced landing and his failure to maintain directional control, after experiencing an in-flight loss of control for undetermined reasons.Apr 27, 2003 · N1V · DestroyedNTSB SEA03LA068Accident · No injuriesLimited investigationFinal reportPiper PA-18-135 · Marion, MTThe pilot-in-command's failure to maintain directional control during the takeoff roll resulting in the aircraft leaving the runway, crossing a ditch and collapsing the landing gear. A contributing factor was the ditch.Apr 23, 2003 · N60733 · Substantial damageNTSB CHI03LA111Accident · No injuriesLimited investigationFinal reportCessna 150F · Three Rivers, MIThe directional control not maintained by the student pilot. The student pilot's lack of experience was a contributing factor.Apr 23, 2003 · N8082F · Substantial damageNTSB FTW03LA140Accident · No injuriesLimited investigationFinal reportRobinson R-22 Beta · Ardmore, OKThe pilot's failure to maintain directional control during liftoff. A contributing factor was the inadvertent encounter of propeller blast from the other airplane starting at the time of takeoff.Apr 20, 2003 · N2341Z · Substantial damageNTSB SEA03LA064Accident · Serious injuriesLimited investigationFinal reportCessna 150 · Coos Bay, ORThe pilot's improper remedial action during takeoff and his failure to maintain airspeed. Contributing factors included the binding of the left brake and the trees.Apr 19, 2003 · N7057F · Substantial damageNTSB IAD03LA047Accident · No injuriesLimited investigationFinal reportCessna 170B · Randolph, NYThe pilot's failure to attain/maintain proper runway alignment. A factor in the accident was the sun glare.Apr 19, 2003 · N118F · Substantial damageNTSB FTW03LA136Accident · No injuriesLimited investigationFinal reportAir Tractor AT-301 · Batchelor, LAThe pilot's failure to abort the takeoff with adequate runway available. A contributing factor was the high density altitude.Apr 18, 2003 · N36531 · Substantial damageNTSB DEN03LA075Accident · No injuriesLimited investigationFinal reportMitsubishi MU-2B-60 · Salt Lake City, UTthe pilot improperly aligning the airplane on the runway for takeoff. Contributing factors were the reduced visibility due to rain, and the dark night.Apr 18, 2003 · N157CA · Substantial damageNTSB DEN03LA066Accident · No injuriesLimited investigationFinal reportTaylorcraft BC12-D · West Jordan, UTthe dual student's failure to maintain aircraft control and the flight instructor's inadequate supervision of the student. A contributing factor was the unfavorable wind gust.Apr 16, 2003 · N43591 · Substantial damageNTSB SEA03LA063Accident · No injuriesLimited investigationFinal reportHerb Six Northstar · Medford, ORThe compressive buckling and collapse of the right main landing gear.Apr 15, 2003 · N606HS · Substantial damage