# NTSB investigations: Takeoff NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 138 of 281 · 14,038 cases ## Cases, newest first - [NTSB ANC87FA080](https://openairdocs.org/ntsb/ANC87FA080.md): Piper PA-22 · Theodore River, AK · Accident · No injuries · Field investigation · Final report · Jun 16, 1987 · N2447P · Substantial damage > The 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… - [NTSB FTW87DRA04](https://openairdocs.org/ntsb/FTW87DRA04.md): Aero Commander Callair B-1A · Louise, TX · Accident · No injuries · Final report · Jun 15, 1987 · N7287V · Destroyed > Acft 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… - [NTSB ATL87DEI05](https://openairdocs.org/ntsb/ATL87DEI05.md): Bell 47G-2 · Lisbon, OH · Accident · Minor injuries · Final report · Jun 14, 1987 · N984B · Substantial damage > The 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… - [NTSB DEN87LA143](https://openairdocs.org/ntsb/DEN87LA143.md): Beech 19A · Erie, CO · Accident · No injuries · Limited investigation · Final report · Jun 13, 1987 · N7650R · Substantial damage > The 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… - [NTSB NYC87LA169](https://openairdocs.org/ntsb/NYC87LA169.md): Cessna 414A · Binghamton, NY · Accident · No injuries · Limited investigation · Final report · Jun 11, 1987 · N2691S · Substantial damage > During 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… - [NTSB ANC87LA078](https://openairdocs.org/ntsb/ANC87LA078.md): de Havilland DHC-2 · King Salmon, AK · Accident · No injuries · Limited investigation · Final report · Jun 11, 1987 · N98EL · Substantial damage > The 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. - [NTSB MKC87LA120](https://openairdocs.org/ntsb/MKC87LA120.md): Eagle DW-1 · Mediapolis, IA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N8803S · Destroyed > The 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. - [NTSB FTW87MA135](https://openairdocs.org/ntsb/FTW87MA135.md): MBB BO-105CBS · Bay City, MI · Accident · 2 fatal · Major investigation · Final report · Jun 7, 1987 · N550H · Destroyed > Acft 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… - [NTSB MKC87LA118](https://openairdocs.org/ntsb/MKC87LA118.md): Cessna 188C · Dalton, NE · Accident · No injuries · Limited investigation · Final report · Jun 5, 1987 · N4219J · Destroyed > The 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. - [NTSB NYC87FA170](https://openairdocs.org/ntsb/NYC87FA170.md): Cessna 310Q · Montgomery, NY · Accident · 2 fatal · Field investigation · Final report · Jun 4, 1987 · N5527K · Destroyed > N5527K 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… - [NTSB CHI87LA145](https://openairdocs.org/ntsb/CHI87LA145.md): Piper PA-28-180 · Marion, IN · Accident · No injuries · Limited investigation · Final report · Jun 3, 1987 · N2180R · Substantial damage > As 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… - [NTSB LAX87LA220](https://openairdocs.org/ntsb/LAX87LA220.md): Ryan ST-A · Mariposa, CA · Accident · No injuries · Limited investigation · Final report · May 30, 1987 · N14954 · Substantial damage > At 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… - [NTSB BFO87LA040](https://openairdocs.org/ntsb/BFO87LA040.md): Cessna 152 · Fredericksburg, VA · Accident · No injuries · Limited investigation · Final report · May 30, 1987 · N25448 · Substantial damage > The 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… - [NTSB SEA87LA103](https://openairdocs.org/ntsb/SEA87LA103.md): Ayres S2R · Walla Walla, WA · Accident · No injuries · Limited investigation · Final report · May 29, 1987 · N3693X · Substantial damage > During 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… - [NTSB FTW87LA128](https://openairdocs.org/ntsb/FTW87LA128.md): Mooney M20J · Marietta, OK · Accident · No injuries · Limited investigation · Final report · May 25, 1987 · N4787H · Substantial damage > The 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… - [NTSB FTW87LA125](https://openairdocs.org/ntsb/FTW87LA125.md): Quickie Q2 · Sherman, TX · Accident · No injuries · Limited investigation · Final report · May 25, 1987 · N85Q · Substantial damage > The 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.… - [NTSB MKC87LA105](https://openairdocs.org/ntsb/MKC87LA105.md): Grumman G-164 · Knobel, AR · Accident · No injuries · Limited investigation · Final report · May 21, 1987 · N484Y · Substantial damage > The 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… - [NTSB ATL87DLQ03](https://openairdocs.org/ntsb/ATL87DLQ03.md): Air & Space 18A · Paducah, KY · Accident · Minor injuries · Final report · May 19, 1987 · N6154S · Substantial damage > The 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… - [NTSB BFO87DIA01](https://openairdocs.org/ntsb/BFO87DIA01.md): Lake LA-4 · Stafford, VA · Accident · No injuries · Final report · May 17, 1987 · N527B · Substantial damage > During 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… - [NTSB FTW87LA120](https://openairdocs.org/ntsb/FTW87LA120.md): Cessna 152 · Sargent, TX · Accident · Serious injuries · Limited investigation · Final report · May 16, 1987 · N48735 · Substantial damage > The 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… - [NTSB ANC87LA071](https://openairdocs.org/ntsb/ANC87LA071.md): Cessna 182A · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · May 16, 1987 · N4600W · Substantial damage > The 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. - [NTSB LAX87LA204](https://openairdocs.org/ntsb/LAX87LA204.md): Piper PA-38-112 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · May 10, 1987 · N2315V · Substantial damage > During 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… - [NTSB LAX87LA203](https://openairdocs.org/ntsb/LAX87LA203.md): Beech A65 · Coalinca, CA · Accident · Minor injuries · Limited investigation · Final report · May 8, 1987 · N7872R · Substantial damage > The 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. - [NTSB DEN87LA118](https://openairdocs.org/ntsb/DEN87LA118.md): Piper PA-22-150 · Missoula, MT · Accident · No injuries · Limited investigation · Final report · May 3, 1987 · N7511D · Substantial damage > The 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… - [NTSB ANC87LA064](https://openairdocs.org/ntsb/ANC87LA064.md): Cessna 206 · Pt. Mackenzie, AK · Accident · No injuries · Limited investigation · Final report · Apr 30, 1987 · N51205 · Substantial damage > The 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. - [NTSB LAX87DVG05](https://openairdocs.org/ntsb/LAX87DVG05.md): Aero Commander S2R · Gridley, CA · Accident · No injuries · Final report · Apr 27, 1987 · N5644X · Substantial damage > On 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… - [NTSB LAX87LA190](https://openairdocs.org/ntsb/LAX87LA190.md): Hughes 269B · Rubidoux, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 26, 1987 · N101DN · Destroyed > A 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… - [NTSB FTW87LA103](https://openairdocs.org/ntsb/FTW87LA103.md): Cessna 172N · Pond Creek, OK · Accident · No injuries · Limited investigation · Final report · Apr 26, 1987 · N2114E · Substantial damage > Pilot 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… - [NTSB ATL87FA124](https://openairdocs.org/ntsb/ATL87FA124.md): Cessna 500 · Willoughby, OH · Accident · No injuries · Field investigation · Final report · Apr 25, 1987 · N82AT · Substantial damage > Acft 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'… - [NTSB MKC87LA089](https://openairdocs.org/ntsb/MKC87LA089.md): Cessna 172E · Moorhead, IA · Accident · No injuries · Limited investigation · Final report · Apr 23, 1987 · N3777S · Substantial damage > According 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… - [NTSB LAX87LA192](https://openairdocs.org/ntsb/LAX87LA192.md): Beech 35-A33 · Novato, CA · Accident · No injuries · Limited investigation · Final report · Apr 22, 1987 · N573T · Substantial damage > The 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… - [NTSB FTW87FA100](https://openairdocs.org/ntsb/FTW87FA100.md): Beech D55 · Cameron, LA · Accident · No injuries · Field investigation · Final report · Apr 21, 1987 · N413S · Substantial damage > The 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… - [NTSB CHI87LA115](https://openairdocs.org/ntsb/CHI87LA115.md): Piper PA-32-260 · Byron Center, MI · Accident · No injuries · Limited investigation · Final report · Apr 20, 1987 · N5593J · Substantial damage > The 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… - [NTSB SEA87LA082](https://openairdocs.org/ntsb/SEA87LA082.md): Bell 206-BIII · Kent, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 19, 1987 · N9KT · Substantial damage > During 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… - [NTSB NYC87LA128](https://openairdocs.org/ntsb/NYC87LA128.md): Piper PA-28R-201 · Lehighton, PA · Accident · No injuries · Limited investigation · Final report · Apr 19, 1987 · N43758 · Substantial damage > During 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. - [NTSB ANC87LA061](https://openairdocs.org/ntsb/ANC87LA061.md): Piper PA-18 · Goose Bay, AK · Accident · No injuries · Limited investigation · Final report · Apr 18, 1987 · N7081D · Substantial damage > The 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. - [NTSB ANC87LA060](https://openairdocs.org/ntsb/ANC87LA060.md): Piper PA-12 · Yentna River, AK · Accident · No injuries · Limited investigation · Final report · Apr 18, 1987 · N92524 · Substantial damage > The 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. - [NTSB ANC87LA059](https://openairdocs.org/ntsb/ANC87LA059.md): Cessna 170 · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · Apr 18, 1987 · N1604D · Substantial damage > On 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… - [NTSB DEN87LA096](https://openairdocs.org/ntsb/DEN87LA096.md): Piper PA-18-150 · Glenrock, WY · Accident · No injuries · Limited investigation · Final report · Apr 14, 1987 · N1851P · Substantial damage > The 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… - [NTSB LAX87DJA05](https://openairdocs.org/ntsb/LAX87DJA05.md): Nihon YS-11A · Honolulu, HI · Accident · Serious injuries · Final report · Apr 10, 1987 · N118MP · No damage > During 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… - [NTSB DEN87LA093](https://openairdocs.org/ntsb/DEN87LA093.md): Piper PA-25-235 · Idalia, CO · Accident · No injuries · Limited investigation · Final report · Apr 10, 1987 · N4765Y · Substantial damage > An 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,… - [NTSB DEN87LA092](https://openairdocs.org/ntsb/DEN87LA092.md): Cessna A185F · Gillette, WY · Accident · Minor injuries · Limited investigation · Final report · Apr 10, 1987 · N6670N · Substantial damage > The 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… - [NTSB ATL87LA112](https://openairdocs.org/ntsb/ATL87LA112.md): Piper PA-38-112 · Ravenna, OH · Accident · No injuries · Limited investigation · Final report · Apr 10, 1987 · N2606K · Substantial damage > The 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… - [NTSB CHI87IA109](https://openairdocs.org/ntsb/CHI87IA109.md): Boeing 727-222 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Apr 7, 1987 · N7258U · No damage > A 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… - [NTSB MIA87FA129](https://openairdocs.org/ntsb/MIA87FA129.md): Bellanca 7GCBG · New Smyrna Bch, FL · Accident · Serious injuries · Field investigation · Final report · Apr 5, 1987 · N8678V · Substantial damage > The 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… - [NTSB ATL87LA105](https://openairdocs.org/ntsb/ATL87LA105.md): Air & Space 18A · Paducah, KY · Accident · Serious injuries · Limited investigation · Final report · Apr 5, 1987 · N6141S · Substantial damage > The 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… - [NTSB DEN87LA082](https://openairdocs.org/ntsb/DEN87LA082.md): Champion 7GCBC · Rock Rover, WY · Accident · Serious injuries · Limited investigation · Final report · Apr 3, 1987 · N1653G · Destroyed > The 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… - [NTSB MKC87LA071](https://openairdocs.org/ntsb/MKC87LA071.md): Cessna 140 · Creve Coeur, MO · Accident · No injuries · Limited investigation · Final report · Apr 1, 1987 · N89316 · Substantial damage > The 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… - [NTSB DEN87LA077](https://openairdocs.org/ntsb/DEN87LA077.md): Pitts Special S2C · Deming, NM · Accident · Serious injuries · Limited investigation · Final report · Mar 30, 1987 · N58DC · Substantial damage > The 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… - [NTSB ATL87LA099](https://openairdocs.org/ntsb/ATL87LA099.md): Grumman G-164 · Shelbyville, TN · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N654Y · Destroyed > The 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… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=139 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql 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 ``` This list as a web page: https://openairdocs.org/ntsb-phases/300/cases?page=138 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.