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 ANC87FA080Accident · No injuriesField investigationFinal reportPiper PA-22 · Theodore River, AKThe private pilot elected to abort the takeoff attempt from an abandoned roadway too late to stop in time to avoid going into brush and small trees. He said he decided against the takeoff at about the mid-point in the 4000 foot gravel section of the road. The…Jun 16, 1987 · N2447P · Substantial damageNTSB FTW87DRA04Accident · No injuriesFinal reportAero Commander Callair B-1A · Louise, TXAcft was departing from a 1500' private strip on an aerial application flt. Opr had reduced the fertilizer load on this flt in order to compensate for the higher ambient temps in the afternoon. On takeoff, the acft lifted off normally, but settled back onto…Jun 15, 1987 · N7287V · DestroyedNTSB ATL87DEI05Accident · Minor injuriesFinal reportBell 47G-2 · Lisbon, OHThe helicopter rolled over as it was lifting off from a transport trailer. A post-crash exam revealed that the left rear tie-down strap on the trailer was wrapped around one of the helicopter skids. The ground crewman believed he had removed all of the straps…Jun 14, 1987 · N984B · Substantial damageNTSB DEN87LA143Accident · No injuriesLimited investigationFinal reportBeech 19A · Erie, COThe instructor (CFI) was instructing the student plt, who was the new owner of the acft. The CFI rprtd the acft was 'very close to gross weight due to having so much fuel aboard and the density altitude was high.' He estd the density altitude was 7600 ft. drg…Jun 13, 1987 · N7650R · Substantial damageNTSB NYC87LA169Accident · No injuriesLimited investigationFinal reportCessna 414A · Binghamton, NYDuring takeoff roll, full throttle was applied to both engines but the left engine was slow to respond. When full pwr was not reached, the flight was aborted. The acft continued to roll off the dept end of the rwy and down a ravine. The plt stated that on the…Jun 11, 1987 · N2691S · Substantial damageNTSB ANC87LA078Accident · No injuriesLimited investigationFinal reportde Havilland DHC-2 · King Salmon, AKThe pilot stated that he started his takeoff run in the middle of the lake. The aircraft overran the lake and ended up on the tundra approximately 75 yards from the lake shore.Jun 11, 1987 · N98EL · Substantial damageNTSB MKC87LA120Accident · No injuriesLimited investigationFinal reportEagle DW-1 · Mediapolis, IAThe PIC attempted to depart downwind on a rural farm landing strip during an aerial application operation. The acft failed to attain flying speed and the acft struck a fence and ditch beyond the airport boundary.Jun 7, 1987 · N8803S · DestroyedNTSB FTW87MA135Accident · 2 fatalMajor investigationFinal reportMBB BO-105CBS · Bay City, MIAcft was involved in EMS static demonstration at beaver township fire dept, near Bay City. Following demonstration, shortly after takeoff, the pilot attempted a steep downwind turn at low altitude. Reported winds at the time of the accident were 250 degrees…Jun 7, 1987 · N550H · DestroyedNTSB MKC87LA118Accident · No injuriesLimited investigationFinal reportCessna 188C · Dalton, NEThe PIC attempted to depart a rural farm ldg strip during an aerial application operation. The acft left spray boom struck tall standing wheat prior to lift off speed causing loss of control and subsequent ground loop and nose over.Jun 5, 1987 · N4219J · DestroyedNTSB NYC87FA170Accident · 2 fatalField investigationFinal reportCessna 310Q · Montgomery, NYN5527K crashed about 2 miles south of the orange cnty airport shortly after a night tkof fm runway 21. Departure instructions for the IFR flt included a right turn of 130 degrees, to 340 degrees magnetic to intercept V-58 and climb to 5000 ft. the plt…Jun 4, 1987 · N5527K · DestroyedNTSB CHI87LA145Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Marion, INAs the student plt was making a x-wind takeoff on a dual instructional flt, the instructor (CFI) reduced the power at about 15 ft AGL to simulate an eng failure. The student reacted by raising the nose of the acft, but the instructor corrected this by…Jun 3, 1987 · N2180R · Substantial damageNTSB LAX87LA220Accident · No injuriesLimited investigationFinal reportRyan ST-A · Mariposa, CAAt the start of a pleasure flight, the plt reported that during the takeoff roll the acft started to veer to the left. The plt applied right rudder to correct, however, the acft did not respond before the left main left the edge of the rwy and dug in the soft…May 30, 1987 · N14954 · Substantial damageNTSB BFO87LA040Accident · No injuriesLimited investigationFinal reportCessna 152 · Fredericksburg, VAThe CFI stated that drg tkof, the acft accelerated slower than normal. After rolling abt 1800', the student rotated the acft to a normal climb attitude & it climbed aprx 5' to 10'. At about that time, the CFI noted that the airspeed indcn had dropped to abt…May 30, 1987 · N25448 · Substantial damageNTSB SEA87LA103Accident · No injuriesLimited investigationFinal reportAyres S2R · Walla Walla, WADuring takeoff run the right main gear collapsed. The right wing dropped and the aircraft spun to the right. The plt discovered that the right main gear failed at the weld. The pilot, who is also an a & p mechanic, stated that this was an original weld from…May 29, 1987 · N3693X · Substantial damageNTSB FTW87LA128Accident · No injuriesLimited investigationFinal reportMooney M20J · Marietta, OKThe plt attempted takeoff from the 2450 ft rwy at the mcgeehe catfish airport near Marietta, OK. The rwy was soft with a sharp rise in the direction of takeoff. The plt failed to maintain airspeed after liftoff and directional control was lost resulting in…May 25, 1987 · N4787H · Substantial damageNTSB FTW87LA125Accident · No injuriesLimited investigationFinal reportQuickie Q2 · Sherman, TXThe pilot stated that during the takeoff run the left side of the aircraft appeared to be developing more lift than the right. The right wing tip dragged, causing the aircraft to veer to the right side into the mud where it flipped inverted before stopping.…May 25, 1987 · N85Q · Substantial damageNTSB MKC87LA105Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Knobel, ARThe PIC stated that the acft was struck by a gust of wind, and he lost control. The PIC applied rt rudder towards a 1OFT ditch in an att to get over it. The acft was too heavy to fly over the ditch and the acft impacted into the ditch. A review of wx cond's…May 21, 1987 · N484Y · Substantial damageNTSB ATL87DLQ03Accident · Minor injuriesFinal reportAir & Space 18A · Paducah, KYThe gryoplane had been overhauled to new specifications and was making its first test flight. During takeoff the acft experienced a slight left yaw, and attempts to correct the yaw only increased it. The plt aborted the takeoff and the acft landed in a yawed…May 19, 1987 · N6154S · Substantial damageNTSB BFO87DIA01Accident · No injuriesFinal reportLake LA-4 · Stafford, VADuring takeoff the aircraft collided with a submerged object which penetrated the hull and dislodged the right pontoon. The aircraft sank in approximately 4 feet of water and was substantially damaged. The pilot and his two passengers were not injured. A boat…May 17, 1987 · N527B · Substantial damageNTSB FTW87LA120Accident · Serious injuriesLimited investigationFinal reportCessna 152 · Sargent, TXThe plt decided to takeoff twd the NE on a pvt road (which he referred to as 'shell rd . . . Beach'). He used 10 deg of flaps & applied full power before releasing the brakes. He stated that after becoming airborne about 2 to 5 ft, the acft 'shifted slightly…May 16, 1987 · N48735 · Substantial damageNTSB ANC87LA071Accident · No injuriesLimited investigationFinal reportCessna 182A · Talkeetna, AKThe pilot was tardy when deciding to abort the takeoff attempt from a rough short strip. The airplane ran into soft over-run and nosed over.May 16, 1987 · N4600W · Substantial damageNTSB LAX87LA204Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Chandler, AZDuring an instructional flt, the student plt had control of the acft during a soft field take-off. The student did not keep the acft aligned with the centerline even after the instructor told the student to add right rudder to stop the drift. Just prior to…May 10, 1987 · N2315V · Substantial damageNTSB LAX87LA203Accident · Minor injuriesLimited investigationFinal reportBeech A65 · Coalinca, CAThe pilot attempted to takeoff from the 2,820 foot runway with a makeshift flight control gust lock in place. He was unable to liftoff with the controls locked and the nose gear collapsed when the aircraft overran the runway onto the rough/uneven terrain.May 8, 1987 · N7872R · Substantial damageNTSB DEN87LA118Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Missoula, MTThe private plt was practicing touch and go landings. While on a takeoff roll, a gust of wind lifted the right wing and pushed the acft off the rwy to the left. Directional control was lost and the acft taxied through high grass parallel to the rwy. The nose…May 3, 1987 · N7511D · Substantial damageNTSB ANC87LA064Accident · No injuriesLimited investigationFinal reportCessna 206 · Pt. Mackenzie, AKThe pilot stated that during the takeoff roll on the beach the aircraft struck a sand bar causing the aircraft to nose over on the beach.Apr 30, 1987 · N51205 · Substantial damageNTSB LAX87DVG05Accident · No injuriesFinal reportAero Commander S2R · Gridley, CAOn takeoff from a farmer's field the aircraft's engine lost power. The aircraft was unable to clear a levee, struck the levee and came to rest in a rice field. The aircraft's fuel pump was removed and tested. After one minute of operation the pump pressure…Apr 27, 1987 · N5644X · Substantial damageNTSB LAX87LA190Accident · Minor injuriesLimited investigationFinal reportHughes 269B · Rubidoux, CAA Hughes 269B went out of control and collided with the ground during a t/o to a hover. The pilot had purchased the aircraft recently and was learning to fly it. He was scheduled for his first flight lesson on the day of the accident. The CFI reported that he…Apr 26, 1987 · N101DN · DestroyedNTSB FTW87LA103Accident · No injuriesLimited investigationFinal reportCessna 172N · Pond Creek, OKPilot failed to lower flaps for a short field takeoff. After rotation the pilot realized that the aircraft would not clear a power line off the end of the runway and aborted the takeoff. The aircraft ran off the end of the runway and contacted a fence and…Apr 26, 1987 · N2114E · Substantial damageNTSB ATL87FA124Accident · No injuriesField investigationFinal reportCessna 500 · Willoughby, OHAcft had been flown over 4 hrs on pers. Business for owner. Plts had stopped at lnn to drop off pax. Start & taxi were norm for positioning flt back to home base. Started t.o. roll and when eng RPM reached 80-85% toward tgt of 95.7%, plts reptd loud 'bang'…Apr 25, 1987 · N82AT · Substantial damageNTSB MKC87LA089Accident · No injuriesLimited investigationFinal reportCessna 172E · Moorhead, IAAccording to FAA statements, the pilot was attempting a takeoff from a taxiway when a wing dipped. The pilot then lost control as the wing dragged, causing the aircraft to ground loop/swerve onto the terrain. The nose gear tire blew during the swerve and the…Apr 23, 1987 · N3777S · Substantial damageNTSB LAX87LA192Accident · No injuriesLimited investigationFinal reportBeech 35-A33 · Novato, CAThe plt aborted the takeoff attempt before becoming airborne at a point near midfield on the 3360 ft rwy. He rptd smoke in the cockpit from an electrical short of unrptd origin. Both the plt and the plt-rated pax thought they would be able to stop on the…Apr 22, 1987 · N573T · Substantial damageNTSB FTW87FA100Accident · No injuriesField investigationFinal reportBeech D55 · Cameron, LAThe left engine lost power at rotation but, due to the short runway (2500-SOD), the pilot elected to continue the takeoff. He switched the left fuel selector, placed the boost pump switch in the 'high' position and retracted the landing gear and flaps but did…Apr 21, 1987 · N413S · Substantial damageNTSB CHI87LA115Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Byron Center, MIThe plt stated that following a preflight inspection and engine run-up, he attempted a soft field takeoff on the 2070 foot turf rwy. According to the plt, he aborted the takeoff aprx 1035 feet down the rwy because he held the nose too high and he was dragging…Apr 20, 1987 · N5593J · Substantial damageNTSB SEA87LA082Accident · Minor injuriesLimited investigationFinal reportBell 206-BIII · Kent, WADuring takeoff to a hover the helicopter rolled to the left. The student pilot over corrected. The helicopters right skid contacted the ground with the student pilot making a rapid increase in collective rate causing the helicopter to roll to the right onto…Apr 19, 1987 · N9KT · Substantial damageNTSB NYC87LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Lehighton, PADuring takeoff roll, the flight encountered a wind gust and the plt aborted the takeoff at about 1500 feet from the takeoff point. The acft continued to slide off the end of the runway, down a slope and across a road impacting two trees.Apr 19, 1987 · N43758 · Substantial damageNTSB ANC87LA061Accident · No injuriesLimited investigationFinal reportPiper PA-18 · Goose Bay, AKThe pilot stated that during the takeoff roll at a gravel air strip he lost directional control of the aircraft causing the aircraft to nose over on its back.Apr 18, 1987 · N7081D · Substantial damageNTSB ANC87LA060Accident · No injuriesLimited investigationFinal reportPiper PA-12 · Yentna River, AKThe pilot stated that during the takeoff roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back.Apr 18, 1987 · N92524 · Substantial damageNTSB ANC87LA059Accident · No injuriesLimited investigationFinal reportCessna 170 · Talkeetna, AKOn acceleration for takeoff the front seat adjusting catch became disengaged sliding aft to the rear. The pilot lost directional control of the aircraft causing the aircraft to nose over on its back. Examination of the left seat track shows the track was worn…Apr 18, 1987 · N1604D · Substantial damageNTSB DEN87LA096Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Glenrock, WYThe private plt planned a takeoff from the unimproved ranch rwy for a local flt. Elevator trim was not set for takeoff according to the plt. When the tailwheel came up during the takeoff roll, the acft swerved left, and the plt attempted to correct with…Apr 14, 1987 · N1851P · Substantial damageNTSB LAX87DJA05Accident · Serious injuriesFinal reportNihon YS-11A · Honolulu, HIDuring the takeoff ground run approaching V1/VR, the #1 engine fire warning light illuminated and the fire bell sounded. The takeoff was aborted and the acft was turned off the rwy onto a taxiway. The engines were shutdown and the captain ordered a right side…Apr 10, 1987 · N118MP · No damageNTSB DEN87LA093Accident · No injuriesLimited investigationFinal reportPiper PA-25-235 · Idalia, COAn ag plt was attempting a takeoff on a dirt road for an aerial application flt. The wind was from the northwest and the acft was aligned to the south. During the takeoff ground run a gust from the rear lifted the acft. The acft departed the road to the left,…Apr 10, 1987 · N4765Y · Substantial damageNTSB DEN87LA092Accident · Minor injuriesLimited investigationFinal reportCessna A185F · Gillette, WYThe plt reports that just after the tail was raised on the takeoff roll, his seat slid full aft on the rails. He said he was unable to reach the rudder pedals and the acft swerved to the lt, ground looped, and nosed over. The plt was not injured but the…Apr 10, 1987 · N6670N · Substantial damageNTSB ATL87LA112Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Ravenna, OHThe student plt was making a touch and go ldg on rwy 27. After touchdown, he retracted the flaps and applied full power to takeoff again. The acft began to veer left after power was applied. The CFI reported that she told the student to apply right rudder as…Apr 10, 1987 · N2606K · Substantial damageNTSB CHI87IA109Incident · No injuriesIncident investigationFinal reportBoeing 727-222 · Chicago, ILA united airlines Boeing 727 domestic passenger flight was holding short of runway 32L at the Chicago-o'hare international airport awaiting clearance for an intersection takeoff. A northwest airlines Boeing 747 international passenger flight was holding in…Apr 7, 1987 · N7258U · No damageNTSB MIA87FA129Accident · Serious injuriesField investigationFinal reportBellanca 7GCBG · New Smyrna Bch, FLThe plt had just returned from a banner tow flight and had refueled. Witnesses stated that on departure the acft banked steeply during the initial climb to pick up another banner. The wings then rocked back and forth and the acft mushed until impact with a…Apr 5, 1987 · N8678V · Substantial damageNTSB ATL87LA105Accident · Serious injuriesLimited investigationFinal reportAir & Space 18A · Paducah, KYThe plt reported that he spun the rotor up to 350 RPM in preparation for a maximum performance takeoff. During takeoff roll, the gyroplane experienced ground resonance. The plt reduced the throttle to idle, but the oscillations continued and the rt main ldg…Apr 5, 1987 · N6141S · Substantial damageNTSB DEN87LA082Accident · Serious injuriesLimited investigationFinal reportChampion 7GCBC · Rock Rover, WYThe plt was using a pasture for takeoff. The winds were calm and the takeoff run was slightly uphill. There was a low spot in the pasture which was soft from melting snow. The acft did not reach takeoff speed before reaching the end of the pasture. During the…Apr 3, 1987 · N1653G · DestroyedNTSB MKC87LA071Accident · No injuriesLimited investigationFinal reportCessna 140 · Creve Coeur, MOThe PIC was practicing landings in gusty crosswind conditions. PIC landed long, and after rolling a short distance, perceived that the wind direction had changed. The PIC stated that this new wind direction was now more of a tailwind. The PIC did not select a…Apr 1, 1987 · N89316 · Substantial damageNTSB DEN87LA077Accident · Serious injuriesLimited investigationFinal reportPitts Special S2C · Deming, NMThe acft swerved during takeoff and the swerve severity increased during acceleration. The plt lifted off before reaching proper speed to sustain flt. The acft stall mushed into the ground to the left of the rwy, bounced into the air and stalled again. The…Mar 30, 1987 · N58DC · Substantial damageNTSB ATL87LA099Accident · No injuriesLimited investigationFinal reportGrumman G-164 · Shelbyville, TNThe acft was being operated from a dirt road that was reportedly only slightly wider than the acft. The plt reported that he had just completed a spraying operation and was about to put out some fertilizer. He stated that he installed the spreader, but left…Mar 27, 1987 · N654Y · Destroyed