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 ATL88FA174Accident · 4 fatalField investigationFinal reportMooney M20F · Middlesboro, KYWitnesses rprted the eng did not sound like it was providing full power drg takeoff & that abt 3/4 of the 3600' rwy was used for the takeoff roll. After lift-off, the acft climbed at a shallow angle to abt 250 to 300 ft AGL. It then entereda shallow left…May 14, 1988 · N9654M · Substantial damageNTSB FTW88LA099Accident · No injuriesLimited investigationFinal reportBeech B55 · Ada, OKThe plt said all pre-flt prep were normal including an eng run-up. The takeoff was being made with light winds. After rolling about 300 ft the acft began a swerve to the rt which the plt perceived was associated with a loss of pwr on the rt eng. The plt…May 12, 1988 · N7330R · Substantial damageNTSB ANC88LA055Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Kodiak, AKThe pilot stated that during the takeoff run he lost control of the aircraft causing the aircraft to nose over on its back at the departure end of the lake. The plt had been issued a special VFR clearance by Kodiak tower due to existing wx conditions. The plt…May 9, 1988 · N8842D · Substantial damageNTSB LAX88DUG03Accident · No injuriesFinal reportStolp-Starduster Too SA-300-A · Chino, CADuring the ground run for take off, the left main gear strut broke. The main landing gear collapsed resulting in substantial damage. The reason for the strut failure was undetermined.May 5, 1988 · N1300S · Substantial damageNTSB LAX88DVG04Accident · No injuriesFinal reportHiller UH-12E · Winters, CAThe pilot was taking off from a loading truck for his 16th aerial application. He reduced the load from 90 to 70 gals because the winds had become variable. The helicopter descended into ground effect where it normally attains translational lift. The…May 4, 1988 · N62391 · DestroyedNTSB ATL88FA162Accident · No injuriesField investigationFinal reportBeech 55 · Atlanta, GAMay 2, 1988 · N2025W · Substantial damageNTSB FTW88DRA10Accident · Minor injuriesFinal reportNew Rutan LONG-EZE · Friendswood, TXThe pilot overrotated the aircraft on takeoff to a nose high attitude, then overcontrolled in the opposite direction to get the nose down. The aircraft touched down nose gear first and all three landing gears collapsed, a wing sheared off, and the aircraft…May 1, 1988 · N331LB · Substantial damageNTSB ANC88LA048Accident · No injuriesLimited investigationFinal reportCessna 206 · Cantwell, AKThe air-taxi pilot stated that he attempted to takeoff from a private, dirt runway that was dry in the middle and muddy towards the edges. During the takeoff roll, the airplane's left main gear tire encountered the soft, muddy area and turned abruptly towards…Apr 19, 1988 · N51205 · Substantial damageNTSB ANC88LA044Accident · No injuriesLimited investigationFinal reportAeronca 7DC · Talkeetna, AKThe pilot stated that during the takeoff run on the frozen field the aircraft struck a snow berm causing the aircraft to ground loop.Apr 17, 1988 · N2532E · Substantial damageNTSB LAX88LA166Accident · No injuriesLimited investigationFinal reportChampion 7EC · Mayer, AZApr 13, 1988 · N7586E · Substantial damageNTSB NYC88LA122Accident · No injuriesLimited investigationFinal reportCessna 172 · Myerstown, PAThe pilot stated that during takeoff the aircraft veered to the left and the left wheel dug into the sod. At the same time the right wing lifted up and the aircraft rolled over. The wind was variable at 10 to 15 knots, gusting to 30.Apr 10, 1988 · N2825U · DestroyedNTSB FTW88LA086Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Grand Prairie, TXThe student pilot lost directional control on the takeoff ground run and the aircraft was damaged after it ran off the runway. The reported weather showed a 90 degree left crosswind at 12 knots velocity with gusts to 20 knots. The plt did not file an acc…Apr 2, 1988 · N9213T · Substantial damageNTSB ATL88LA130Accident · No injuriesLimited investigationFinal reportBeech A-36 · Nashville, TNThe pilot aborted a takeoff after he felt that the aircraft was not performing properly. The pilot had four passengers on board which put the aircraft near its gross weight. The runway was 4300 feet long and the pilot needed about 1100 feet of runway for the…Apr 2, 1988 · N7243B · Substantial damageNTSB MIA88LA130Accident · No injuriesLimited investigationFinal reportChampion 7ECA · La Belle, FLDuring the ground run to take off, the unidentified pilot lost control of the acft. It departed the rwy, collided with a fence, nosed over, then came to rest. The identity of the plt has not been determined.Mar 27, 1988 · N9097L · Substantial damageNTSB ANC88LA041Accident · No injuriesLimited investigationFinal reportCessna 177 · Tok, AKThe private pilot attempted to take-off at dusk with a left main gear wheel brake that was frozen in the 'on' position. He had unsuccessfully attempted to free the brake prior to TAKE0FF, but felt that he could get the airplane airborne by skidding the tire…Mar 17, 1988 · N34603 · Substantial damageNTSB NYC88LA107Accident · No injuriesLimited investigationFinal reportCessna T210M · Greene, NYDuring takeoff roll, the aircraft drifted to the right edge of the runway in a soft-field takeoff attitude. The right main gear contacted the top of a snowbank. The aircraft then yawed to the right and impacted a second snowbank where it came to rest.Mar 12, 1988 · N761BU · Substantial damageNTSB CHI88DCA01Accident · No injuriesFinal reportBell 206B · Cahokia, ILThe instructor was giving a pilot an employment evaluation in the helicopter when during the startup the pilot prematurely added full power causing the helicopter to rotate rapidly to the right. The helicopter had been positioned on a trailer. During the…Mar 10, 1988 · N13Q · Substantial damageNTSB ANC88LA042Accident · No injuriesLimited investigationFinal reportCessna 185F · Ophir, AKDuring the takeoff roll from the frozen lake the pilot lost directional control of the aircraft causing the aircraft to nose over on its back. The pilot stated during the takeoff roll the aircraft crossed a snowmachine track causing him to lose control of the…Mar 10, 1988 · N5045R · Substantial damageNTSB ANC88LA038Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Mcgrath, AKThe private pilot-in-command of the Piper PA-18 lost control of the airplane while attempting to takeoff from a section of snow covered river ice.Mar 10, 1988 · N78AJ · Substantial damageNTSB NYC88LA095Accident · No injuriesLimited investigationFinal reportStinson 108-1 · Burlington, VTThe flight was taking off for an instructional flight in the local area. During ground run, the aircraft veered to the left and the pilot was unable to bring the aircraft under control. The aircraft collided with a snowbank and flipped inverted. The aircraft…Feb 28, 1988 · N97979 · Substantial damageNTSB FTW88LA073Accident · No injuriesLimited investigationFinal reportBrantly Helicopter B-2B · Decatur, TXThe non-certificated pilot flew the helicopter from his ranch to Decatur for refueling. After landing, he realized that he was too FAR from the fuel pump. Upon liftoff to move closer to the pump the helicopter rolled over. The pilot attributed the accident to…Feb 27, 1988 · N2233U · Substantial damageNTSB FTW88DRA04Accident · Serious injuriesFinal reportBarnett Drifter XP503 · Alvin, TXThe pilot reassembled the flight controls just prior to flight, and installed the aileron pins to connect the cables, but forget the safety locking devices. During flight, the pins fell out causing a total loss of aileron control.Feb 27, 1988 · N247JB · Substantial damageNTSB CHI88LA070Accident · No injuriesLimited investigationFinal reportCessna 172A · Crivitz, WIThe aircraft did not accelerate as anticipated by the pilot, who was attempting to takeoff from a wet sod strip. The pilot elected to abort the takeoff, however was unable to stop on the remaining runway, exited the departure end, struck a snow bank and nosed…Feb 26, 1988 · N9751T · Substantial damageNTSB ATL88DKG04Accident · Serious injuriesFinal reportWeber Evans VF-1 · Fort Payne, ALFeb 26, 1988 · N18JW · Substantial damageNTSB ATL88LA099Accident · No injuriesLimited investigationFinal reportBeech 18S · Morganton, NCPIC aborted first takeoff attempt due to crosswind induced directional control difficulties. During second takeoff attempt, gusty crosswind lifted left wing & acft became airborne. PIC forced acft back onto rwy, lost directional control and veered off rwy…Feb 24, 1988 · N1480K · Substantial damageNTSB NYC88LA092Accident · No injuriesLimited investigationFinal reportCessna 182 · Westfield, PAThe pilot was attempting a soft field takeoff with full power and right rudder applied. During ground run, the tail of the aircraft struck a snowbank, pulling the aircraft into the snow. When the left main gear hit the snow the aircraft flipped over onto its…Feb 23, 1988 · N3374F · Substantial damageNTSB FTW88LA071Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · San Benito, TXThe student plt was making a touch and go on his second solo flt. After the flaps were retracted and the power was increased, the acft veered to the right and hit a runway light. The acft then continued into the dirt beside the runway where the nose gear…Feb 23, 1988 · N24447 · Substantial damageNTSB ATL88LA097Accident · No injuriesLimited investigationFinal reportCessna 172 · Jackson, TNWhile returning home with his newly purchased acft the plt made a refueling stop. The winds were strong and gusting upwards of thirty KTS at the refueling arpt and the destination arpt. During the takeoff roll the winds shifted to a right crosswind. The acft…Feb 22, 1988 · N6285E · Substantial damageNTSB MKC88FA054Accident · 1 fatalField investigationFinal reportBell 47D1 · Nixa, MODuring the process of moving the helicopter from the hangar the right skid slipped off the concrete helipad and became stuck in the mud. The pilot attempted to dislodge the skid by bringing the aircraft to a hover. The left skid became airborne and contacted…Feb 21, 1988 · N7735 · DestroyedNTSB ATL88LA098Accident · No injuriesLimited investigationFinal reportBeech 77 · Concord, GAPIC obtained wx brief of high winds from northwest with strong gusts. Takeoff was from pvt strip with wind sock which showed wind aligned with rwy 01. As takeoff roll was begun wind shifted to 90 degrees left crosswind. At rotation left wing was lifted by…Feb 21, 1988 · N623CH · Substantial damageNTSB MIA88LA111Accident · No injuriesLimited investigationFinal reportCessna A188B · Macon, MSThe plt stated that during the takeoff roll, the left lndg gear failed causing the acft to swerve off the rwy & into a ditch bordering the rwy. An exam by FAA personnel revealed tire marks on the rwy which continued off the rwy & into the ditch. According to…Feb 20, 1988 · N4489Q · DestroyedNTSB FTW88LA067Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Washington, OKThe student pilot received dual instruction in crosswind takeoffs and landings after which the instructor pilot deplaned to observe the student. The student lost directional control on the first takeoff attempt and the aircraft collided with a ditch after…Feb 19, 1988 · N9331T · Substantial damageNTSB DEN88LA074Accident · No injuriesLimited investigationFinal reportCessna 152 · Hurricane, UTThe student plt said that when he departed st. george, UT for Hurricane, which is 21 NM northeast, the wind was from the south at about 5 KTS. He landed to the north at Hurricane. He said he did not notice any wind as he prepared to depart to the south. Upon…Feb 18, 1988 · N67515 · Substantial damageNTSB FTW88DRA03Accident · Serious injuriesFinal reportHiller UH-12-D · Bon-Wier, TXGround crewmember's failure to follow established procedures for secureing the aircraft to the transport trailer.Feb 17, 1988 · N48265 · DestroyedNTSB ATL88LA092Accident · No injuriesLimited investigationFinal reportCessna 172P · Wakeman, OHThe 106 hour pvt plt reptd that he had rented the acft for a LCL flt from the uncontrolled airport. The rwy was snow and ice covered with a 12 kt wind from 240 degrees. After conferring with the LCL CFI on duty, he elected to make the LCL flt. During the t.o.…Feb 14, 1988 · N633BC · Substantial damageNTSB SEA88LA049Accident · No injuriesLimited investigationFinal reportPiper Aerostar 602P · Lovelock, NVThe non-multiengine rated pilot (left seat) executed a takeoff during which the aircraft developed a slight right drift. The pilot then attempted to utilize nose wheel steering to correct and a hard left swerve ensued resulting in a loss of directional…Feb 13, 1988 · N68915 · Substantial damageNTSB CHI88DEP03Accident · Minor injuriesFinal reportPiper PA-38-112 · Sheboygan, WIThe aircraft experienced a loss of control during the takeoff portion of a touch and go. The aircraft departed the runway and struck a snowbank collapsing the nose gear. The aircraft was substantially damaged.Jan 24, 1988 · N25760 · Substantial damageNTSB DEN88LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Duchesne, UTThe student plt was performing a cross country training flight. At his first stop, during the takeoff portion of a touch and go landing, the aircraft swerved to the left and struck a three foot snow bank on the left side of the runway. The plt reported that…Jan 22, 1988 · N4897G · Substantial damageNTSB FTW88IA055Incident · No injuriesIncident investigationFinal reportSwearingen SA227-AC · College Station, TXThe aircraft's nose gear struck a deer during the takeoff roll and the takeoff was aborted. The aircraft taxied back to the terminal and was examined by the flight crew. No damage was found. It then departed on its scheduled flight. It flew 18 flights during…Jan 20, 1988 · N3107P · Minor damageNTSB DEN88LA055Accident · Minor injuriesLimited investigationFinal reportCessna 402 · Albuquerque, NMThe ATP rated plt and a commercial rated passenger were taking a scheduled cargo flight from Albuquerque to las cruces, new Mexico. The runway was covered with snow, ice and water from a snow storm the previous night. It was snowing lightly at the time of the…Jan 18, 1988 · N2614U · Substantial damageNTSB SEA88LA035Accident · No injuriesLimited investigationFinal reportCessna 172 · Everett, WAThe student pilot had landed with full flaps prior to the application of full power for takeoff. The aircraft veered to the left side of the runway into mud and nosed over inverted. The aircraft's flap indicator had been placarded inoperative by the operator.Jan 17, 1988 · N2811Q · Substantial damageNTSB ATL88LA080Accident · No injuriesLimited investigationFinal reportPiper PA-44-180 · Florence, SCThe left main ldg gear collapsed during takeoff roll, following a touch & go ldg. The airplane subsequently veered into a snowbank. Post-crash examination of the airplane revealed that the left MLG truss bracket assy had pulled loose from the acft structure…Jan 16, 1988 · N268NA · Substantial damageNTSB ATL88LA075Accident · No injuriesLimited investigationFinal reportCessna 150 · Carolina Beach, NCThe aircraft sustained substantial airframe damage when the acft collided with the ground following an aborted t/o. the instructor reported that the student pulled the throttle back after the aircraft broke ground. The instructor attempted to recover, but the…Jan 12, 1988 · N50738 · Substantial damageNTSB DEN88LA042Accident · No injuriesLimited investigationFinal reportCessna 152 · Greeley, COThe plt reported that he was making touch and go landings on rwy 09, an asphalt rwy 6200 x 75 ft. the wind was light and variable. The plt said that during the 4th t&g, he landed a little fast and not perfectly aligned with the rwy. When he applied pwr to…Jan 8, 1988 · N280SV · Substantial damageNTSB MKC88LA035Accident · No injuriesLimited investigationFinal reportCessna 182Q · Davenport, IAThe PIC had chosen rwy 15 for the LOC app and was cleared by approach control. The PIC stated that he cancelled his IFR flt plan entering clear conditions at 3,000 ft. the PIC further stated that he planned an approach using a ltl higher spd for the gusty…Dec 31, 1987 · N96934 · Substantial damageNTSB DEN88LA040Accident · No injuriesLimited investigationFinal reportBeech A36 · Angel Fire, NMThe private plt and five pax were returning home from a skiing trip. During takeoff the acft encountered a left crosswind from 270 degrees, at an estimated 40 knots. The plt lifted off early, then the wind pulled. The acft stalled and impacted right of the…Dec 23, 1987 · N27LH · Substantial damageNTSB DEN88LA038Accident · No injuriesLimited investigationFinal reportCessna T210R · Bismarck, NDThe plt was attempting to takeoff at dusk on a gravel road. The acft veered off of road and hit a ditch.Dec 19, 1987 · N7381U · Substantial damageNTSB ANC88FA022Accident · Minor injuriesField investigationFinal reportCessna 208 · Bethel, AKThe plt had planned to back taxi for takeoff on rwy 36. The tower controller asked if a rwy 18 departure would be acceptable to accommodate an arriving acft & the plt accepted a clnc. He started his takeoff with 3900' remaining on the 6399' rwy. After initial…Dec 19, 1987 · N9438F · Substantial damageNTSB NYC88LA023Accident · No injuriesLimited investigationFinal reportGulfstream American AA-5B · Morristown, NJThe Gulfstream-american AA5B was making a takeoff with a flight instructor and student pilot on board. At 65 knots during the takeoff, a deer was struck on the runway and killed. The takeoff was aborted on the runway. The student pilot and flight instructor…Nov 30, 1987 · N4533Q · Substantial damageNTSB CHI88LA029Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Lake City, MIThe student pilot initiated a takeoff from a snow covered runway. During the initial ground run, he lost directional control. Subsequently, the aircraft ran off the side of the runway & collided with trees. The plt rprtd the wind was from the south at 8 to 10…Nov 22, 1987 · N9817W · Substantial damage