# 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 155 of 281 · 14,038 cases ## Cases, newest first - [NTSB FTW83LA255](https://openairdocs.org/ntsb/FTW83LA255.md): Glasflugel H-301 · Los Lunas, NM · Accident · No injuries · Limited investigation · Final report · May 28, 1983 · N1017 · Substantial damage > The glider ground looped off the rwy after the wingtip contacted tall grass. The acft had gone to the right early in thetow but the plt thought the tow would straighten him out even after the wing dropped to the ground. When the right wing contacted tall… - [NTSB DEN83LA128](https://openairdocs.org/ntsb/DEN83LA128.md): Cessna 180B · Decker, MT · Accident · No injuries · Limited investigation · Final report · May 28, 1983 · N5259E · Substantial damage > The tailwheel acft groundlooped on takeoff as the tail came up and the acft swerved sharply to the left. During the turn at about 40 mph the acft nosed over. The pilot noticed a pulling to the left as the takeoff roll commenced but thought he could contain it… - [NTSB LAX83LA252](https://openairdocs.org/ntsb/LAX83LA252.md): Cessna 170B · Yreka, CA · Accident · No injuries · Limited investigation · Final report · May 27, 1983 · N8018A · Substantial damage > The plt landed at the montague arpt for fuel, but fuel was not available, so he proceeded to rohrer field where 18 gal was onloaded. During takeoff with a density alt of aprx 4200 ft, he lifted off after using aprx 2/3 of the 3360 ft rwy. He reported that at… - [NTSB FTW83LA282](https://openairdocs.org/ntsb/FTW83LA282.md): Piper PA-28-140 · Mount Ida, AR · Accident · No injuries · Limited investigation · Final report · May 27, 1983 · N56255 · Substantial damage > During the takeoff portion of a touch and go lndg the plt applied pwr and the acft drifted off the left side of the 50 ft wide rwy onto soft terrain. The nose gear collapsed and the propeller and leading edge of the rt wingtip were damaged. - [NTSB CHI83LA229](https://openairdocs.org/ntsb/CHI83LA229.md): Cessna 152 · Holland, MI · Accident · No injuries · Limited investigation · Final report · May 27, 1983 · N4805B · Substantial damage > While the student plt was taking off with a left crosswind, he reportedly became distracted when he became aware that he was applying incorrect aileron deflection for wind correction. He stated that he corrected the ailerons, but in the meantime, the acft… - [NTSB ATL83IA201](https://openairdocs.org/ntsb/ATL83IA201.md): Boeing 727-200 · Charlotte, NC · Incident · No injuries · Incident investigation · Final report · May 27, 1983 · N856N · Minor damage > The #3 eng sustained an uncontained failure of the #4 1/2 bearing of the turbine section, due to fatigue cracking of the roller bearing cage. - [NTSB LAX83LA235](https://openairdocs.org/ntsb/LAX83LA235.md): Piper PA 28-236 · Emigrant Gap, CA · Accident · No injuries · Limited investigation · Final report · May 18, 1983 · N2960X · Substantial damage > The acft collided with trees during takeoff. The CFI and student had made a landing on a rwy that was 2/3 covered with snow. They thought they could make a short field landing and a short field running takeoff. They nosed down in the snow during the attempted… - [NTSB FTW83LA240](https://openairdocs.org/ntsb/FTW83LA240.md): Cessna 152 · Woodward, OK · Accident · No injuries · Limited investigation · Final report · May 16, 1983 · N65412 · Substantial damage > As the a/s increased drng tkof roll the acft started to skid to the rt. The student plt stated that with full l aileron and no rt rudder the acft continued to skid to the rt. He then atmptd to apply l rudder and abort the tkof by reducing pwr. The acft veered… - [NTSB ANC83LA081](https://openairdocs.org/ntsb/ANC83LA081.md): Bellanca 8GCBC · Twin Hills, AK · Accident · No injuries · Limited investigation · Final report · May 16, 1983 · N5042Q · Substantial damage > The acft nosed over during takeoff when the landing gear dug into the soft sand. The weather was VMC but the wind was gusting up to 40 mph. The pilot did not claim any problems with the wind or the acft but he did have a strong crosswind. The accident site… - [NTSB FTW83LA231](https://openairdocs.org/ntsb/FTW83LA231.md): Cessna 150 · Wheeler, TX · Accident · Minor injuries · Limited investigation · Final report · May 15, 1983 · N5525E · Substantial damage > The plt stated that before reaching rotation speed, with about 250 ft of rwy remaining, the left main landing gear dropped off into a chug hole in the rwy. The acft became prematurely airborne, heading off the rwy to the left. It came down in rough terrain… - [NTSB DEN83LA113](https://openairdocs.org/ntsb/DEN83LA113.md): Cessna 182Q · Townsend, MT · Accident · No injuries · Limited investigation · Final report · May 15, 1983 · N759LW · Substantial damage > The acft nosed over in a plowed field off the end of the rwy during an attempted aborted takeoff. The acft had departed one arpt and landed again at a private strip to onload a passenger clothes bag. The landing was uphill into the wind. There was no windsock… - [NTSB DEN83LA112](https://openairdocs.org/ntsb/DEN83LA112.md): Stinson 108-3 · Buffalo, WY · Accident · No injuries · Limited investigation · Final report · May 15, 1983 · N585C · Substantial damage > The plt reported that he attempted to takeoff on rwy 30 with a left x-wind from 210 deg at 25, gusting 30 KTS. At aprx 45 mph, after he had raised the tail of the acft into the takeoff attitude, a gust of wind was encountered & the acft weathervaned to the… - [NTSB LAX83FU003](https://openairdocs.org/ntsb/LAX83FU003.md): Homebuilt None · Tracy, CA · Accident · 1 fatal · Final report · May 14, 1983 · UNREG · Destroyed > The plt had built the ultralight vehicle at home by using the plans of a weedhopper. Reportedly, he had used materials that would have been similar to or stronger than those that would have been supplied by a weedhopper kit. A friend, who had flown the… - [NTSB CHI83LA210](https://openairdocs.org/ntsb/CHI83LA210.md): Piper PA-28R · Mora, MN · Accident · No injuries · Limited investigation · Final report · May 11, 1983 · N36804 · Substantial damage > The acft ran off the departure end of the rwy into a cornfield during an aborted takeoff. The pilot stated that after liftoff the stall warning came on and the acft would not accelerate or climb. He pulled the power off and aborted the takeoff. The acft… - [NTSB CHI83LA207](https://openairdocs.org/ntsb/CHI83LA207.md): Cessna 152 · Smithfield, OH · Accident · No injuries · Limited investigation · Final report · May 10, 1983 · N69057 · Substantial damage > The plt had been practicing touch-and-go landings. On about the 6th or 7th touch-and-go, he applied power to takeoff when a group of deer crossed the rwy. He steered to the left to avoid the animals, went off the rwy, hit a large mound of dirt, then the acft… - [NTSB CHI83FA205](https://openairdocs.org/ntsb/CHI83FA205.md): Beech A36 · Minonk, IL · Accident · Serious injuries · Field investigation · Final report · May 9, 1983 · N6039Z · Substantial damage > The plt reported that during takeoff from a private farm strip, he had only 70 KTS as he apchd the end of the rwy. By then, there was not enough room to abort & he believed the acft had insufficient airspeed to clear wires along a roadway about 330 ft from… - [NTSB ANC83LA078](https://openairdocs.org/ntsb/ANC83LA078.md): Cessna U206 · Twin Hills, AK · Accident · No injuries · Limited investigation · Final report · May 8, 1983 · N49HH · Substantial damage > The plt was dispatched to a beach area to pick up passengers. After landing, the passengers & baggage were loaded & the plt attempted to takeoff. The top & bottom of the beach area had some humps of gravel that blended into the beach sand. During the takeoff… - [NTSB LAX83LA222](https://openairdocs.org/ntsb/LAX83LA222.md): Grumman 164B · Lodi, CA · Accident · No injuries · Limited investigation · Final report · May 7, 1983 · N6530K · Destroyed > The aircraft was rolling for takeoff at dawn when it collided with another crop duster taxiing in the opposite directionthe aircraft taking off had rolled about 100 feet when the pilot saw a red light on the runway and aborted the takeoff and attempted to… - [NTSB ATL83FA178](https://openairdocs.org/ntsb/ATL83FA178.md): Cessna 150 · Kennesaw, GA · Accident · 1 fatal · Field investigation · Final report · May 7, 1983 · N5835G · Substantial damage > The acft crashed in a wooded area after a touch and go landing. The wing flaps lever had been placed to the up position but the flaps did not retract. When the CFI finally noticed that the flaps were not up he took over at about 200 ft AGL and started a… - [NTSB LAX83LA215](https://openairdocs.org/ntsb/LAX83LA215.md): North American Rockwell S2R800 · Fallon, NV · Accident · No injuries · Limited investigation · Final report · May 4, 1983 · N4985X · Destroyed > The acft overran the departure end of the rwy during takeoff. The acft had a full load of fuel and about 250 lbs. Of insecticide. The acft had attained a speed of 65 mph as the end of the rwy was approached. The pilot stated that he thought he could make the… - [NTSB CHI83LA204](https://openairdocs.org/ntsb/CHI83LA204.md): Cessna 180J · Ely, MN · Accident · No injuries · Limited investigation · Final report · May 3, 1983 · N9906N · Substantial damage > The plt was practicing water takeoffs & landings. He stated that during takeoff a gust of wind caught the acft lifting the right wing. The left wing struck the water & the acft flipped inverted. - [NTSB ATL83FA175](https://openairdocs.org/ntsb/ATL83FA175.md): Cessna 182A · Monticello, GA · Accident · Minor injuries · Field investigation · Final report · May 3, 1983 · N3721D · Substantial damage > The acft was damaged in a forced landing off arpt after a power loss at 500-600 AGL during climb. The engine would not restart. Post accident examination showed 3.5 ounces of water in the carburetor bowl with 1 ounce of fuel. The fuel tankcaps had good seals… - [NTSB MIA83LA134](https://openairdocs.org/ntsb/MIA83LA134.md): Gulfstream American AA1B · Moore Haven, FL · Accident · No injuries · Limited investigation · Final report · May 1, 1983 · N6286L · Substantial damage > According to the plt he collided with a large ant hill during the takeoff roll, lost directional control, & veered off the rwy into trees. - [NTSB ANC83FAG08](https://openairdocs.org/ntsb/ANC83FAG08.md): Cessna 180 · Kenai, AK · Accident · No injuries · Final report · May 1, 1983 · N2661Y · Substantial damage > The acft nosed over during takeoff roll. The pilot of the tailwheel acft pushed the yoke foward during the roll and thenreleased the pressure he said the tail of the acft came up too high and the pilot said he ould not overcome this action with back pressure… - [NTSB FTW83LA216](https://openairdocs.org/ntsb/FTW83LA216.md): Piper PA-18-150 · Roswell, NM · Accident · No injuries · Limited investigation · Final report · Apr 30, 1983 · N82946 · Substantial damage > The CFI stated, the acft was lined up on the center line at the end of runway 17. The student pilot applied power and the acft veered to the left, he over-corrected to the right. He further stated, 'I reduced the power to idle as the right landing gear… - [NTSB FTW83LA210](https://openairdocs.org/ntsb/FTW83LA210.md): Cessna A188B · Winsboro, LA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1983 · N70203 · Substantial damage > Aprx 600 feet of the 2300 foot strip is concrete and the remainder is turf. According to the pilot, he raised the tail prior to running off the concrete. As the takeoff roll continued onto the turf, the acft veered sharply to the right. Full left rudder,… - [NTSB SEA83LA090](https://openairdocs.org/ntsb/SEA83LA090.md): Maule M-4-220C · Malad City, ID · Accident · No injuries · Limited investigation · Final report · Apr 26, 1983 · N40314 · Substantial damage > During an interview, the plt reported that he had removed ice from the acft & attempted to depart from a snow covered alfalfa field, aprx 1000 ft long. The acft did not become airborne & the plt elected to abort the takeoff. During the abort, the acft… - [NTSB NYC83LA101](https://openairdocs.org/ntsb/NYC83LA101.md): Aeronca 7AC · Millbrook, NY · Accident · Minor injuries · Limited investigation · Final report · Apr 23, 1983 · N719 · Destroyed > The pilot was using runway 17 for takeoff when he lost directional control. The acft went off the left side of the runway and over an embankment. - [NTSB CHI83LA176](https://openairdocs.org/ntsb/CHI83LA176.md): Cessna 182 · Madison, WI · Accident · No injuries · Limited investigation · Final report · Apr 23, 1983 · N1683M · Substantial damage > The aircraft groundlooped and rolled inverted during the takeoff roll. The student pilot stated that during the takeoff roll the sun broke through the clouds and blinded him. He reported, that this condition plus the crosswind interferred with his ability to… - [NTSB MIA83LA127](https://openairdocs.org/ntsb/MIA83LA127.md): Cessna 152 · Zellwood, FL · Accident · No injuries · Limited investigation · Final report · Apr 21, 1983 · N6333M · Substantial damage > The acft ran off the departure end of the runway and collided with a ditch during an aborted takeoff following a touch- and-go landing. The instructor stated that the student made the landing and prepared the acft for takeoff. Power was applied and at 45 KTS… - [NTSB SEA83LA082](https://openairdocs.org/ntsb/SEA83LA082.md): Stinson L-5 · Haines, OR · Accident · No injuries · Limited investigation · Final report · Apr 18, 1983 · N6430C · Substantial damage > The aircraft collided with a fence during a takeoff and nosed over. The runway was an alfalfa field approximately 1000 feet in length with high growth. The density altitude was 4000 feet. The aircraft did become airborne but settled back to the field, and… - [NTSB MKC83LA091](https://openairdocs.org/ntsb/MKC83LA091.md): Cessna 150M · Axtell, NE · Accident · No injuries · Limited investigation · Final report · Apr 18, 1983 · N714BP · Substantial damage > The plt reported that he began taking off on a 1310 ft rwy that was dry but spongy. The elevation was reported as 2210 ft, the wind was calm, and the temperature was 55 deg. The flaps were set at 10 deg. Reportedly, the acft lifted off, but settled back to… - [NTSB FTW83LA190](https://openairdocs.org/ntsb/FTW83LA190.md): Piper PA-28-161 · Breaux Bridge, LA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1983 · N3572Z · Substantial damage > According to the pilot he was attempting to takeoff at night from an unlit turf strip. Just before the attempted takeoff, two sets of vehicle headlights were directed down both sides of the rnwy to help the pilot in the takeoff. On both sides of the rnwy,… - [NTSB LAX83FUJ13](https://openairdocs.org/ntsb/LAX83FUJ13.md): Piper PA-28R-180 · Flagstaff, AZ · Accident · Serious injuries · Final report · Apr 16, 1983 · N4579J · Substantial damage > The plt reported he had a problem with the spark plugs loading up before he departed sacramento, CA on a x-country & ther magneto (mag) had been overhauled before he departed. He stated the eng ran well 'except for brief plug load (one cyl)cleared by leaning… - [NTSB ANC83IA069](https://openairdocs.org/ntsb/ANC83IA069.md): Cessna U-206 · Old Harbor, AK · Incident · No injuries · Incident investigation · Final report · Apr 11, 1983 · N732FN · Minor damage > The acft rt wing rose during the water takeoff & the left wing struck the water. After impact the aircraft sank. The pilot did not receive a weather briefing & a sigment for lowlevel turbulence was in effect. - [NTSB ATL83FU002](https://openairdocs.org/ntsb/ATL83FU002.md): Wizard J3 · Dovesville, SC · Accident · 1 fatal · Final report · Apr 7, 1983 · UNREG · Destroyed > Reportedly, the owner/plt had purchased the ultralight acft on 4/21/83. His instructor stated that he (the plt) had received aprx 1 1/2 hrs of supervised taxi time, but had not flown the vehicle prior to the accident flt. On the day of the accident, the plt… - [NTSB MIA83LA112](https://openairdocs.org/ntsb/MIA83LA112.md): Cessna 150 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 6, 1983 · N61113 · Substantial damage > The student pilot stated that during the takeoff portion of a touch and go landing power was applied, the acft went out of control and ran off the left side of the runway striking trees. - [NTSB ATL83LA151](https://openairdocs.org/ntsb/ATL83LA151.md): Piper PA-28-140 · Williamsburg, VA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1983 · N98362 · Substantial damage > The aircraft ran off the runway after an aborted takeoff. The pilot stated that he elected to abort the takeoff about half way down the runway after failing to obtain an airspeed indication sufficient for takeoff. After cutting the power and lowering the nose… - [NTSB LAX83LA172](https://openairdocs.org/ntsb/LAX83LA172.md): Grumman American G164-B · Near Madera, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1983 · N31184 · Substantial damage > The acft hit a chuck hole in high grass during takeoff roll from a field for an aerial application mission. The left landing gear separated from the acft. The weather was VMC and no flight plan was filed. The pilot sustained minor injuries. The flight was… - [NTSB ATL83LA149](https://openairdocs.org/ntsb/ATL83LA149.md): Cessna 172N · Jekyll Island, GA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1983 · CGYCY · Substantial damage > The instructor, a canadian CFI, reported that the canadian student was operating the rudder peddles while he, the CFI, was handling the remaining acft controls. A second student plt was also on board, observing from a rear seat. After traveling aprx 800 ft on… - [NTSB MIA83LA107](https://openairdocs.org/ntsb/MIA83LA107.md): Stinson 10A · Miami, FL · Accident · No injuries · Limited investigation · Final report · Mar 30, 1983 · N39431 · Destroyed > The owner of the acft said that the plt was negotiating to buy the acft but conducted this flt without proper authority in the acft that was not airworthy. The plt had landed the acft earlier in an emergency situation declaring a loss of oil pressure and RPM.… - [NTSB CHI83LA155](https://openairdocs.org/ntsb/CHI83LA155.md): Cessna 152 · Mansfield, OH · Accident · No injuries · Limited investigation · Final report · Mar 30, 1983 · N5545L · Substantial damage > The aircraft swerved off the runway during takeoff and nosed down in the dried grass. The student pilot was taking off on the return leg of a cross-country when he lost directional control at a speed of about 40 KTS. The wind was 90 degrees at 9 KTS. The acft… - [NTSB ATL83LA147](https://openairdocs.org/ntsb/ATL83LA147.md): Grumman G164 A · New Church, VA · Accident · No injuries · Limited investigation · Final report · Mar 30, 1983 · N8719H · Substantial damage > The acft swerved from a soft spot on the runway and left the runway. When the acft went into a plowed field the landing gear mired and the acft nosed over. The pilot could not see over the nose of the tailwheel acft to detect the soft spot in the runway. The… - [NTSB LAX83LA168](https://openairdocs.org/ntsb/LAX83LA168.md): Piper PA-28-161 · Glendale, AZ · Accident · No injuries · Limited investigation · Final report · Mar 29, 1983 · N81191 · Substantial damage > The pilot reported performing a normal preflight and run-up. No water was observed in the fuel during preflight. Full power was applied and the acft accelerated to 55 KTS. As the acft rotated and climb attitude established the engine sputtered. The pilot… - [NTSB SEA83LA066](https://openairdocs.org/ntsb/SEA83LA066.md): Cessna 172N · Telma, WA · Accident · No injuries · Limited investigation · Final report · Mar 20, 1983 · N738QA · Substantial damage > The aircraft collided with deep unplowed snow on the runway during takeoff and nosed over. The pilot stated that he had landed on frozen snow but when he returned to takeoff the snow was soft. He had a 1200 ft long portion of the runway cleared but it was… - [NTSB ATL83LA138](https://openairdocs.org/ntsb/ATL83LA138.md): Piper PA-28 · Stone Mountain, GA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1983 · N8593N · Destroyed > The aircraft overran the departure end of the runway and collided with an embankment during an aborted takeoff. The student pilot did not file a flight plan or check the weather for this flight. The weather was VMC but the pilot startedthe takeoff down wind.… - [NTSB ANC83IA058](https://openairdocs.org/ntsb/ANC83IA058.md): Piper PA34-200T · Palmer, AK · Incident · No injuries · Incident investigation · Final report · Mar 19, 1983 · N47895 · Minor damage > During touch go landing the student pilot placed the landinggear handle in the up polition while still on the ground, and immediately placed it in the down position. The gear collapsed. The instructor stated that the student appeared to be fatigued. - [NTSB DEN83LA081](https://openairdocs.org/ntsb/DEN83LA081.md): Cessna 421C · Gunnison, CO · Accident · No injuries · Limited investigation · Final report · Mar 18, 1983 · N67943 · Substantial damage > The plt began taking off on rwy 06 with a wind from 190 deg at 8 KTS. He stated that max power & RPM were obtained. He noted that he obtained 39 inches of manifold pressure & 2235 RPM at 100 KTS IAS. Reportedly, the acft rotated properly, but began to vibrate… - [NTSB LAX83LA146](https://openairdocs.org/ntsb/LAX83LA146.md): Rockwell S-2R · Corcoran, CA · Accident · No injuries · Limited investigation · Final report · Mar 17, 1983 · N4187X · Substantial damage > According to the plt, he was taking off in a x-wind condition & allowed the acft to drift off the duster strip. He stated that he decided to continue the takeoff because of soft ground. The acft lifted off, then settled & the gear struck a levee. The plane… - [NTSB FTW83LA157](https://openairdocs.org/ntsb/FTW83LA157.md): Gulfstream Commander 695 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Mar 16, 1983 · N999ST · Substantial damage > Shortly after beginning the takeoff roll, the acft's right main gear ran off the right edge of the runway into soft wet grass. The soft ground appeared to cause the airplane to continue right and off the runway with takeoff power still applied. The acft… Next page: https://openairdocs.org/ntsb-phases/300/cases.md?page=156 ## 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=155 --- 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.