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 FTW87FA080Accident · No injuriesField investigationFinal reportConvair CV-580 · Dallas, TXMetro flight airlines Convair CV-580 attempted takeoff from runway 35L at the Dallas/fort worth airport (dfw) with crosswinds exceeding demonstrated capability of the aircraft. The takeoff attempt violated company limitations for crosswinds in the Convair…Mar 25, 1987 · N73107 · Substantial damageNTSB DEN87LA071Accident · No injuriesLimited investigationFinal reportCessna 172H · Larimore, NDThe plt was practicing stop and go landings at an arpt near his home. His passenger was a rated plt. On takeoff the aircraft swerved to the right. The right main gear struck a snow bank and the acft nosed over.Mar 23, 1987 · N1725F · Substantial damageNTSB FTW87DPJ06Accident · No injuriesFinal reportAir Tractor AT301 · El Dorado, OKThe pilot stated that during takeoff from a county road, black smoke started coming out of the engine exhaust. The aircraft then collided with a tree and a post causing substantial damage. It was found that the carburetor heat system had been modified and the…Mar 22, 1987 · N3655G · Substantial damageNTSB SEA87LA067Accident · No injuriesLimited investigationFinal reportGrumman G164B · Reubens, IDDuring takeoff run the aircraft veered to the right of the runway, struck a ditch, and then nosed over inverted. The pilot found that the right dowel pin on the right main gear had broken. The reason for the failure could not be determined.Mar 20, 1987 · N6798Q · Substantial damageNTSB ANC87LA054Accident · No injuriesLimited investigationFinal reportCessna 170B · Dillingham, AKAs the plt was taking off from a frozen lake with a ski equipped acft, it collided with a snowbank & was damaged. The plt rprtd that he had just landed a few minutes earlier & that the wind was blowing differently when he took off again. After the acdnt,…Mar 19, 1987 · N3439D · Substantial damageNTSB ANC87LA053Accident · No injuriesLimited investigationFinal reportCessna 185F · Skwentna, AKWhile taxiing on skis at excess speed, the pilot lost control of the airplane in a crosswind. The landing gear box failed causing substantial damage to the airframe and propeller.Mar 15, 1987 · N9618H · Substantial damageNTSB ANC87LA050Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Kotzebue, AKThe student pilot elected to make an off airport landing in his ski-equipped Piper PA18 airplane. He landed the acft successfully, but the right ski attachment and left gear leg collapsed on take off from the uneven terrain. The acft was substantially…Mar 12, 1987 · N135RB · Substantial damageNTSB NYC87IA105Incident · No injuriesIncident investigationFinal reportMcDonnell Douglas MD-80 · Baltimore, MDMain landing gear upper torque link attach bolt separated during takeoff as a result of preexisting stress corrosion cracking. McDonnell-douglas issued alert MD-80 service bulletin A32-220 following the incident.Mar 8, 1987 · N236AA · No damageNTSB CHI87DEE05Accident · Serious injuriesFinal reportResney Commander 447 · Lansing, ILThe acft made a forced landing in a field due to fuel starvation. The acc plt offered to fly the acft out. He had 30 min of dual flt in this type acft. He sat on the left side of the acft for the flt which resulted in an unbalanced condition. The acft entered…Mar 8, 1987 · N447MR · Substantial damageNTSB ANC87LA046Accident · No injuriesLimited investigationFinal reportCessna 170B · Fairbanks, AKThe plt lost control of the acft after the tail was raised during takeoff. The acft groundlooped and collided with a snow bank which damaged the rt wing, landing gear and elevator.Mar 8, 1987 · N4570C · Substantial damageNTSB DEN87LA060Accident · No injuriesLimited investigationFinal reportGates Learjet 35A · Englewood, COThe rwy was plowed aprx 15 minutes prior to this takeoff. One-half inch of snow still remained along the rwy centerline with up to 3 1/2 inches along the edge of the rwy. The acft veered to the left side of the rwy during the takeoff run and continued aprx 80…Feb 26, 1987 · N888DJ · Substantial damageNTSB LAX87LA122Accident · Serious injuriesLimited investigationFinal reportBoeing PT-13D · Vacaville, CAThe aircraft were in the holding area short of runway 19 at the uncontrolled nut tree airport. The Cessna pilot taxied into position behind landing traffic and allowed his aircraft to roll slowly forward while waiting for the landing aircraft to clear the…Feb 22, 1987 · N620BD · 2 aircraft · Substantial damageNTSB FTW87LA068Accident · Minor injuriesLimited investigationFinal reportBell 206B · New Braunfels, TXAcft had been parked in an open field and when the plt returned he noticed that the left skid had sunk into the mud. After eng start and run up, the plt attempted to takeoff with right cyclic applied to un-stick the left skid. The acft lifted off with a right…Feb 22, 1987 · N1082Z · Substantial damageNTSB MIA87FA091Accident · Serious injuriesField investigationFinal reportBeech A36TC · Orlando, FLDrg the takeoff roll, lgt colored smoke was seen trailing the the acft. The plt rprtd that at 100 to 200 ft AGL, the englost partial pwr. He said he checked all ctls & raised the lndg gear. Witnesses rprtd that at about that time, heavy smoke bgn trailing the…Feb 21, 1987 · N47EE · Substantial damageNTSB SEA87LA058Accident · No injuriesLimited investigationFinal reportCessna 188 · Genesee, IDAfter operation in light winds, plt attempted takeoff in calm wind conditions. Gravel runway was soft from overnight rains. Acft became airborne briefly in ground effect near end of runway, settled back into muddy terrain and nosed over inverted.Feb 19, 1987 · N531SF · Substantial damageNTSB NYC87LA088Accident · Minor injuriesLimited investigationFinal reportCessna 180H · New Paltz, NYThe Cessna 180/H was departing the runway at night with two passengers on board. The pilot lost control of the aircraft as the tail came up and veered left into a snow bank. After striking the left snow bank, the aircraft veered right and struck the right…Feb 17, 1987 · N9708G · Substantial damageNTSB ANC87LA039Accident · No injuriesLimited investigationFinal reportPiper PA-34 · Tyonek, AKThe on-demand air taxi flight struck a moose during the takeoff roll at a private rural airstrip. The two pilot crew and one passenger were uninjured. The leading edge of the aircraft's left wing was substantially damaged; but the pilot-in-command elected to…Feb 14, 1987 · N6970J · Substantial damageNTSB SEA87LA057Accident · No injuriesLimited investigationFinal reportCessna 140 · Nyssa, ORDuring takeoff roll, a domestic sheep crossed the strip in front of the aircraft. The pilot cut engine power and maneuvered to avoid, but the animal crossed back in front. Contact with the propeller caused the aircraft to flip inverted.Feb 12, 1987 · N72166 · Substantial damageNTSB BFO87DIG01Accident · No injuriesFinal reportCessna 152C · Gaithersburg, MDWhile taking off on rwy 32, the acft veered to the left & collided with a snowbank before the student plt could regain control. The student rprtd the winds were from 280 deg at 10 KTS.Feb 10, 1987 · N25846 · Substantial damageNTSB FTW87FA061Accident · Serious injuriesField investigationFinal reportPiper PA-42 · Horseshoe Bay, TXThe pilot made a fairly long taxi from the ramp to the end of the runway and then started his takeoff roll with the parking brake still partially set. The brakes became very hot and the component parts expanded. After rolling almost 3,000 feet the brakes…Feb 7, 1987 · N81SM · DestroyedNTSB CHI87LA076Accident · No injuriesLimited investigationFinal reportCessna 152 · Little Falls, MNDuring takeoff roll at about 50-55 KTS plt lost directional control. As the acft started going to the left, the plt applied the brakes. When the acft departed rwy 30, the nose wheel collapsed.Feb 6, 1987 · N757SX · Substantial damageNTSB NYC87LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Duanesburg, NYOn lndg the acft ran into a snowbank causing minor dmg to the acft. Aft determining it airworthy the plt elected to depart and ran into another snowbank on the takeoff. He stated that the accd occurred because of poor judgement to attempt a takeoff from an…Feb 4, 1987 · N9193G · Substantial damageNTSB LAX87LA108Accident · No injuriesLimited investigationFinal reportCessna 172N · Yuma, AZA Cessna 172M veered left during takeoff ground run on rwy 8 and nosed down on the rwy. The plt indicated that he encountered a left 90 degree x-wind gusting up to 20 KTS. The acft began to veer uncontrolled into the wind. He elected to abort the takeoff at…Feb 4, 1987 · N64484 · Substantial damageNTSB CHI87LA077Accident · No injuriesLimited investigationFinal reportLake LA-4-200 · Bridgman, MIPlt was attempting to takeoff from a soft field. The gear caught a rise in the field and acft settled back to the soft ground tearing off the nose wheel and damaging both wings.Feb 4, 1987 · N6686L · Substantial damageNTSB FTW87LA048Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Alpine, TXStudent pilot on solo flight attempted takeoff in strong gusty winds and dragged left wing tip on runway. Pilot leveled wings and attempted to land aircraft but departed left side of runway and collided with ditch.Jan 24, 1987 · N2592C · Substantial damageNTSB CHI87LA064Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Decatur, ILFollowing taxi to rwy 36, the plt stated that he completed an engine run-up. On the takeoff roll, the acft swerved to the left before colliding with a snowbank approximately 800 feet from the apch end of the rwy. According to the plt, opposite rudder was…Jan 23, 1987 · N2536A · Substantial damageNTSB CHI87DEX05Accident · No injuriesFinal reportCessna 340A · Bloomington, INThe plt rprtd that drg preflt, there was snow on the acft which would move with hand brushing, so he elected not to remove it. Drg departure, as he rotated the acft to lift-off, he noted the acft did not feel right. He intentionally aborted the takeoff, but…Jan 22, 1987 · N3961G · Substantial damageNTSB ATL87LA063Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Wilkesboro, NCDuring a takeoff attempt, the right seat pilot did not get an airspeed indication. However, the left airspeed indicated 45 mph when the pilot aborted the takeoff. The aircraft veered off the right side of the runway 1700 feet from the initial takeoff roll.…Jan 22, 1987 · N2489R · Substantial damageNTSB LAX87LA090Accident · Minor injuriesLimited investigationFinal reportCessna 170B · Yucca Valley, CAThe pilot reported that during the takeoff roll, a wind gust caused the left wing to raise and the airplane veered to the right. He immediately applied left aileron and rudder, but to no avail. The airplane went off the runway, hit a tree and fence, and…Jan 17, 1987 · N2293D · DestroyedNTSB LAX87LA080Accident · Minor injuriesLimited investigationFinal reportCessna 152 · Palo Alto, CAThe student pilot stated that he had just finished practicing 4 touch-and-go with his flight instructor. The flight instructor then exited the aircraft and instructed the student to practice 5 solo touch-and-go. On the take-off run just prior to rotation, the…Jan 10, 1987 · N46354 · Substantial damageNTSB LAX87LA078Accident · Serious injuriesLimited investigationFinal reportChampion 7EC · Oakland, CAA Champion 7EC went out of control during the takeoff initial climb. The aircraft dragged a wing during takeoff ground run. The pilot was observed looking back towards the runway during the initial climb. The aircraft stalled and descended uncontrolled to the…Jan 9, 1987 · N7515E · Substantial damageNTSB DEN87FA036Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Rawlins, WYThe plt took off on a 7000 ft long runway with a heavy coat of frost on the acft. The acft became airborne and flew in ground effect until it impacted a 30 ft high pile of sand 200 yards beyond the end of the runway.Dec 29, 1986 · N4388X · DestroyedNTSB NYC87DNC04Accident · Serious injuriesFinal reportTaylorcraft BC12D · West Farmington, METhe aircraft climbed in a steep attitude after takeoff to an alt of aprx 100 ft AGL. The acft then stalled and impacted the terrain in a left wing low attitude.Dec 27, 1986 · N95575 · Substantial damageNTSB MIA87LA052Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Hollywood, FLThe plt stated that the acft tilted shortly after liftoff and he elected to abort the takeoff. While on roll out, when the brakes were applied, the acft veered to the left and ran off the rwy colliding with a fence. The plt reported no mechanical difficulties…Dec 18, 1986 · N2279Q · Substantial damageNTSB DEN87LA030Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Opheim, MTThe plt elected to take off downhill because he said the hill was too steep to try a takeoff uphill even into the wind. He said that just prior to lift off, he hit a snowbank which slowed the acft down. Deeper snow was then contacted and the acft flipped over.Dec 15, 1986 · N78588 · Substantial damageNTSB ATL87FA039Accident · 1 fatalField investigationFinal reportCessna 170B · Madison, GAAlthough there were no witnesses to the crash, one witness did observe the acft taxiing at a very slow speed toward the dept end of the rwy. Abt 30 mins later the wreckage was fd in a fld east of the airstrip. Exam indicated it collided w the gd in a near…Dec 9, 1986 · N2464D · Substantial damageNTSB ATL87LA037Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Cullowhee, NCAfter not flying for about 7 yrs, the plt obtained flt instruction in preparation for a biennial flt review. His 1st flt was completed 4 days prior to the acdnt. The acdnt flt was to be devoted primarily to takeoffs & landings. The student plt was rprtd to…Dec 7, 1986 · N6860G · DestroyedNTSB NYC87LA047Accident · No injuriesLimited investigationFinal reportPiper J-3 · East Moriches, NYDuring the takeoff roll on an instructional solo flight, the flight encountered a crosswind which pushed the Piper off the runway to the left colliding with trees and bush.Dec 6, 1986 · N26057 · Substantial damageNTSB MIA87FA040Accident · No injuriesField investigationFinal reportde Havilland DHC-6 · San Juan, PRThe plt stated that on takeoff roll as the nose wheel was lifted at aprx 60 knots, the acft veered sharply to the left, ran off the runway and collided with the glide slope building. The left eng and propeller were examined and both components were found to…Nov 29, 1986 · N930MA · Substantial damageNTSB LAX87LA054Accident · No injuriesLimited investigationFinal reportNorth American-Maslon SNJ-4 · El Cajon, CAA North American SNJ-4 ground looped after a loss of control during takeoff roll on runway 27R. The aircraft swerved to the left twice and then lifted off the ground with a high angle of attack and low airspeed. The aircraft then 'mushed along' at…Nov 28, 1986 · N269WB · Substantial damageNTSB DEN87LA022Accident · No injuriesLimited investigationFinal reportCessna 150 · St. George, UTDuring a touch and go landing, the acft's left landing gear tangled in loose wire. The acft swerved to the the left, struck a used tire barrier then nosed over. The landing was made on a closed rwy.Nov 26, 1986 · N19224 · Substantial damageNTSB BFO87LA013Accident · No injuriesLimited investigationFinal reportCessna 152 · Manassas, VAAccording to the student plt, during the apch for the touch-and-go landing, he applied left rudder pressure to line up the acft with the rwy centerline. After touchdown he did not adequetely release pressure from the left rudder and as takeoff was started the…Nov 25, 1986 · N4599L · Substantial damageNTSB DEN87LA021Accident · No injuriesLimited investigationFinal reportCessna A188B · Rock Springs, MTDuring the initial takeoff ground run in high wind conditions the acft drifted to the right, impacted a dirt bank, ground looped and nosed down. During the ground loop the left wing struck the ground, damaging the main spar.Nov 24, 1986 · N4862Q · Substantial damageNTSB MIA87FA035Accident · 1 fatalField investigationFinal reportCessna T210F · West Palm Bch, FLThe eng was reported to be sputtering during the takeoff roll. The plt continued the takeoff and after liftoff declared an emergency. As the acft turned to a downwind position at a low alt with the eng still sputtering it struck a tree and a building at which…Nov 22, 1986 · N6194R · DestroyedNTSB BFO87LA010Accident · No injuriesLimited investigationFinal reportBeech BE-55 · Beckley, WVThe plt stated that before takeoff he did not see anything on the rwy. The landing and taxi lights on the acft were on for the takeoff. During the takeoff roll when the acft was almost at takeoff speed the plt heard a loud bang followedby the acft yawing to…Nov 19, 1986 · N42P · Substantial damageNTSB ANC87LA015Accident · No injuriesLimited investigationFinal reportCessna 207A · Manokotak, AKThe pilot stated that he lost directional control of the aircraft on the takeoff roll. The aircraft exited the departure end of the runway into the open tundra.Nov 19, 1986 · N1763U · Substantial damageNTSB CHI87LA031Accident · No injuriesLimited investigationFinal reportCessna 150F · Nicollet, MNThe plt experienced fuel exhaustion and made an emergency forced landing. With the help of a farmer he refueled the acft and got it to nearby highway 14, where he attempted to takeoff while state police provided road blocks. While on takeoff, the plt lost…Nov 16, 1986 · N6442F · DestroyedNTSB DEN87LA020Accident · Minor injuriesLimited investigationFinal reportCessna 120 · Peyton, CONC3004N, registered to the plt, ground looped during takeoff in a right quartering tailwind, with a check plt aboard. The plt said that upon rotation he elected to abort the flt. He abruptly reduced the power, the acft settled to the ground and ground looped.…Nov 15, 1986 · N3004N · Substantial damageNTSB FTW87LA016Accident · Minor injuriesLimited investigationFinal reportBell 206L · Galveston, TXThe plt was attempting to hover in a tailwind of 35 KTS which exceeded the acft manufacturers performance limitiations for operations in allowable relative wind. The plt lost control of the acft on lift-off. The acft rolled over and came to rest on its right…Nov 11, 1986 · N16772 · Substantial damageNTSB CHI87LA023Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Winamac, INAfter noticing a vague shape off the right side of the aircraft, during takeoff run at night, the pilot continued down the runway until the aircraft collided with a 180 pound deer.Nov 11, 1986 · N75363 · Substantial damage