# NTSB investigations: Landing 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 401 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB LAX87LA193](https://openairdocs.org/ntsb/LAX87LA193.md): Cessna 180 · Fullerton, CA · Accident · No injuries · Limited investigation · Final report · Apr 26, 1987 · N2936C · Substantial damage > The pilot reported that a gust of wind turned the aircraft left just prior to touchdown on runway 24. He was unable to maintain directional control during the landing roll and the aircraft ran off the left side of the runway. The reported surface winds were… - [NTSB FTW87LA106](https://openairdocs.org/ntsb/FTW87LA106.md): Cessna 152 · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Apr 26, 1987 · N5100Q · Substantial damage > A student pilot on a solo flight in the local area, lost control of the aircraft while practicing touch and go landings. Substantial damage occurred when the aircraft slid off the rt side of the rwy into a ditch, causing the aircraft to nose over inverted. - [NTSB NYC87LA133](https://openairdocs.org/ntsb/NYC87LA133.md): Piper PA-28-180 · W.Mifflin, PA · Accident · No injuries · Limited investigation · Final report · Apr 25, 1987 · N7726W · Substantial damage > Pilot made a landing on runway 10 at the allegheny county airport, however during landing roll the pilot lost directional control of the aircraft. The acft swerved right and collided with a cast iron sewer that was raised about 6' above the ground. - [NTSB MIA87LA146](https://openairdocs.org/ntsb/MIA87LA146.md): Cessna 172P · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 25, 1987 · N129ER · Substantial damage > The plt stated that during the landing roll, after depressing both brakes evenly, the rt brake locked up causing the acft to leave the rwy. The arpt was Beach regional airport, Daytona Beach, Florida, the acft collided with a taxiway marker sign & came to… - [NTSB MIA87LA145](https://openairdocs.org/ntsb/MIA87LA145.md): Bell 47G-2 · Rolling Fork, MS · Accident · No injuries · Limited investigation · Final report · Apr 25, 1987 · N202CH · Substantial damage > While landing downwind, at an alt of aprx 20 feet, the helicopter began to settle with power. The pilot then attempted to stop the descent, however, because of insufficient alt & airspeed, was unable. The helicopter then landed hard, rolled over, after which,… - [NTSB ATL87LA144](https://openairdocs.org/ntsb/ATL87LA144.md): Spartan 7W · Sumter, SC · Accident · No injuries · Limited investigation · Final report · Apr 25, 1987 · N13PH · Substantial damage > The plt reported that the airplane began to turn to the left after ldg when the tailwheel touched down; subsequent efforts to counteract the turn were not successful. The airplane ran off the side of the rwy and hit a depression in the terrain, collapsing the… - [NTSB CHI87LA116](https://openairdocs.org/ntsb/CHI87LA116.md): Cessna 172XP · Superior, WI · Accident · No injuries · Limited investigation · Final report · Apr 24, 1987 · N5093V · Substantial damage > Upon landing on runway 13, pilot reports wind blowing aircraft towards the edge of runway. Aircraft went off right side, nose wheel stuck in mud and collapsed, and aircraft nosed over. Winds at duluth, MN, approx. 11 nmi northwest of accident site, were… - [NTSB ANC87LA062](https://openairdocs.org/ntsb/ANC87LA062.md): Champion 7ECA · Theodore River, AK · Accident · No injuries · Limited investigation · Final report · Apr 24, 1987 · N9597S · Substantial damage > The pilot stated that during the landing roll on the gravel bar he lost directional control of the aircraft causing the aircraft to nose over on its back. - [NTSB MKC87LA088](https://openairdocs.org/ntsb/MKC87LA088.md): Eagle DW-1 · Lincoln, KS · Accident · No injuries · Limited investigation · Final report · Apr 23, 1987 · N8802B · Substantial damage > The plt was spraying 2/4/D when one spray nozzle stuck open. Rather than kill alfalfa and trees during the turnarounds, the plt elected to land on a dirt road and repair the nozzle. He misjudged the width of the road and on touchdown, the right wing touched… - [NTSB MIA87LA144](https://openairdocs.org/ntsb/MIA87LA144.md): Cessna 152 · Arcadoa, FL · Accident · No injuries · Limited investigation · Final report · Apr 23, 1987 · N49832 · Substantial damage > During the landing roll the plt diverted his attention from taxiing the acft to raising the flaps and turning off the carb heat. The rt wing was then lifted by the cross wind, after which, the plt applied excessive rt rudder. The acft left the rwy, fell into… - [NTSB LAX87LA197](https://openairdocs.org/ntsb/LAX87LA197.md): Cessna 172P · Huntingtonbeach, CA · Accident · No injuries · Limited investigation · Final report · Apr 23, 1987 · N54978 · Substantial damage > On touchdown the plt reported that the acft bounced twice. The plt initiated a go-around by retracting the flaps and adding full power. The acft did not gain enough altitude before colliding with a quonset hut located 210 feet from the end of the runway. - [NTSB FTW87LA109](https://openairdocs.org/ntsb/FTW87LA109.md): Cessna 172G · Houston, TX · Accident · No injuries · Limited investigation · Final report · Apr 23, 1987 · N1107F · Substantial damage > A student pilot on a solo flight in the local area, landed long and ran off the end of the runway. The pilot stated that the accident occurred due to touchdown too FAR down the runway. He further related that the presence of high tension wires influenced his… - [NTSB ATL87DKG01](https://openairdocs.org/ntsb/ATL87DKG01.md): Air Tractor AT301 · Atmore, AL · Accident · Serious injuries · Final report · Apr 22, 1987 · N4346S · Minor damage > During landing the aircraft collided with a tractor mowing grass on the runway. The pilot stated that the sunglare on final prevented him from seeing the vehicle on the runway. The tractor's operator apparently did not hear the aircraft because he made no… - [NTSB NYC87LA132](https://openairdocs.org/ntsb/NYC87LA132.md): Dornier DO-228-201 · Manchester, NH · Accident · No injuries · Limited investigation · Final report · Apr 21, 1987 · N232RP · Substantial damage > Vibration was experienced shortly after touchdown caused by the failure of the propeller blade as a result of fatigue cracking which was initiated from a linear area in a defect free portion of the camber face of the blade. Propagation was through 60% of the… - [NTSB DEN87LA109](https://openairdocs.org/ntsb/DEN87LA109.md): Cessna 150J · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Apr 21, 1987 · N60282 · Substantial damage > A student plt was practicing landings on her second supervised solo training flt. On the first approach, she failed to flare properly and hit in a three point attitude. The nose gear collapsed and the propeller struck the rwy. The acft skidded about 25 feet… - [NTSB DEN87LA108](https://openairdocs.org/ntsb/DEN87LA108.md): Cessna 182C · Conde, SD · Accident · No injuries · Limited investigation · Final report · Apr 21, 1987 · N9069T · Substantial damage > The private plt was making a landing to a gravel road during a business flt. This same road landing area had been used frequently. The winds were estimated by the plt as 030 degrees at 17 knots, gusting to 24 knots. The approach and landing was to the west on… - [NTSB MKC87LA084](https://openairdocs.org/ntsb/MKC87LA084.md): Thorp T-18 · Bowling Green, MO · Accident · No injuries · Limited investigation · Final report · Apr 20, 1987 · N218HW · Substantial damage > The PIC rptdly encountered a gust of wind during the landing flare. The PIC lost control as one main landing gear impacted the ground abruptly and his head hit the side of the canopy. The acft veered off the side of the rwy into tall grass and soft terrain.… - [NTSB MKC87FA085](https://openairdocs.org/ntsb/MKC87FA085.md): Cessna 152 · Marion, IA · Accident · 2 fatal · Field investigation · Final report · Apr 20, 1987 · N67751 · Substantial damage > The CFI and stu were practicing approaches to the Marion, Iowa arpt. Several witnesses stated that the t & g lndgs were unusual which gained their attn. On the last appch the acft was observed to be slow during the unusually steep appch. Abt 15 to 20 ft AGL… - [NTSB LAX87LA210](https://openairdocs.org/ntsb/LAX87LA210.md): Cessna 172M · Hawthorne, CA · Accident · No injuries · Limited investigation · Final report · Apr 20, 1987 · N73614 · Substantial damage > During a solo instructional flight, the student pilot was practicing touch and go landings. He noticed as the flight progressed, that there was some gusting conditions aloft and that the wind direction was varying. On the last landing the aircraft touched… - [NTSB LAX87LA186](https://openairdocs.org/ntsb/LAX87LA186.md): Cessna 310Q · Lower Lake, CA · Accident · No injuries · Limited investigation · Final report · Apr 20, 1987 · N69628 · Substantial damage > A Cessna 310Q overran rwy 30 and collided with terrain off the departure end. A witness stated the acft landed at aprx mid-field on the 2,485 ft by 50 ft asphalt rwy and was unable to stop. Based on the witnesses' statement aprx 1,240 ft would be available… - [NTSB LAX87LA183](https://openairdocs.org/ntsb/LAX87LA183.md): Cessna 152 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Apr 19, 1987 · N25331 · Substantial damage > While making practice landings, the student pilot failed to maintain flying speed during the final stages of his second approach. The aircraft stalled inadvertently about 15 feet above the runway and landed hard on the nose wheel. - [NTSB LAX87DVG03](https://openairdocs.org/ntsb/LAX87DVG03.md): Grumman G-164B · Marysville, CA · Accident · No injuries · Final report · Apr 18, 1987 · N8412K · Substantial damage > At the end of an aerial application flt, the plt was aware of a cross wind from the right. The plt touched the acft down on the right main landing gear and held that attitude for aprx 300 ft down the rwy. When the left main gear contacted the rwy it folded… - [NTSB FTW87LA098](https://openairdocs.org/ntsb/FTW87LA098.md): Piper PA-28-161 · Waring, TX · Accident · No injuries · Limited investigation · Final report · Apr 18, 1987 · N2140D · Substantial damage > The newly certificated private pilot landed on runway 17 at a small privately owned airport at Waring, TX. There was a wire fence located 18 feet from the left edge of the landing runway. The pilot allowed the aircraft to drift left off the runway and collide… - [NTSB SEA87LA081](https://openairdocs.org/ntsb/SEA87LA081.md): Cessna 150L · Alderwood, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 1987 · N5437Q · Substantial damage > The student pilot took off and landed with a 15 knot tailwind. During his second attempt to land an overun occurred. The aircraft departed the runway to the left onto soft ground where it nosed over inverted. This was the student pilots second solo flight.… - [NTSB NYC87LA125](https://openairdocs.org/ntsb/NYC87LA125.md): Cessna 152 · Manchester, NH · Accident · No injuries · Limited investigation · Final report · Apr 15, 1987 · N24784 · Substantial damage > The Cessna 152 was making a touch and go on rwy 35 with the winds reported to be 170 degrees at 11 knots. The pilot lost control after touchdown and veered off the runway to the left. The aircraft struck a runway light and flipped over receiving substantial… - [NTSB DEN87LA099](https://openairdocs.org/ntsb/DEN87LA099.md): Maule M-5-180 · Erie, CO · Accident · No injuries · Limited investigation · Final report · Apr 15, 1987 · N84KG · Substantial damage > The private plt had completed a landing from a business flt. On landing roll a strong wind gust from the left caused the aircraft to turn left. The plt added full pwr and the acft departed the rwy to the left. The acft was turned back to the right and crossed… - [NTSB SEA87LA078](https://openairdocs.org/ntsb/SEA87LA078.md): Cessna 185 · Burnett Inlet, AK · Accident · No injuries · Limited investigation · Final report · Apr 13, 1987 · N1774R · Substantial damage > The plt left the landing gear in the down position after takeoff. During the water landing, with the gear in the down position, the acft nosed over. - [NTSB CHI87LA113](https://openairdocs.org/ntsb/CHI87LA113.md): Cessna 152 · Marine City, MI · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 1987 · N4857B · Substantial damage > During a solo training flight, the student pilot landed too fast. The aircraft porpoised, the nose wheel collapsed and the plane nosed over. - [NTSB NYC87LA122](https://openairdocs.org/ntsb/NYC87LA122.md): Robinson R22 · Pottstown, PA · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1987 · N85570 · Substantial damage > During landing approach to runway 28, ground fog was encountered and the pilot overshot his intended touchdown point. The pilot stated that he slowed the airspeed to zero mph and the acft started to shake and fall even though the motor and rotor were at 100%… - [NTSB ATL87LA113](https://openairdocs.org/ntsb/ATL87LA113.md): Cessna 172 M · Ridgeland, SC · Accident · No injuries · Limited investigation · Final report · Apr 12, 1987 · N9563V · Destroyed > The plt was practicing t/o & ldgs. During the 2nd ldg, the plt reptd retarding throttle to idle and eng dying during roll-out. A restart was accomplished and another t/o comp. Again during ldg. Eng stopped during roll out. This time, the restart attempt was… - [NTSB MKC87LA079](https://openairdocs.org/ntsb/MKC87LA079.md): Cessna 172 · Brewster, KS · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 1987 · N118FP · Substantial damage > The PIC rptd verring left and off the side of the sod strip where he was attempting a lndg. The PIC stated that the lndg gear began sinking into soft grnd off the side and the acft slowed rapidly. After slowing the nose wheel collapsed rearward flipping the… - [NTSB DEN87LA095](https://openairdocs.org/ntsb/DEN87LA095.md): Cessna 170A · Durango, CO · Accident · No injuries · Limited investigation · Final report · Apr 11, 1987 · N5579C · Substantial damage > The plt reports that he was landing to the s with a rt quartering headwind of about 20 KTS. He said that during his rollout the wind shifted to a rt quartering tailwind with a large gust. The gust raised the tail and rt wing and the acft departed the rt side… - [NTSB FTW87FA093](https://openairdocs.org/ntsb/FTW87FA093.md): Cessna 150G · Post, TX · Accident · No injuries · Field investigation · Final report · Apr 10, 1987 · N8550J · Substantial damage > Substantial damage occurred during an attemtped touch and go landing by a student pilot. The acft landed hard, collapsing the nose gear and empennage. After initial impact the acft became airborne for approximately 1000 ft before contacting the runway again… - [NTSB MKC87LA081](https://openairdocs.org/ntsb/MKC87LA081.md): Cessna 152 · Kirksville, MO · Accident · No injuries · Limited investigation · Final report · Apr 9, 1987 · N5515Q · Substantial damage > Drg a night landing, the plt did not get the acft flared before touchdown. Subsequently, it contacted the rwy with the nose wheel. Drg the occurrence, the nose gear, prop & eng fire wall were damaged. - [NTSB CHI87LA111](https://openairdocs.org/ntsb/CHI87LA111.md): Cessna 150M · Pontiac, IL · Accident · No injuries · Limited investigation · Final report · Apr 9, 1987 · N6039K · Substantial damage > The plt lost directional control, swerved off the rwy and struck an acft that was parked approx 80 ft from the rwy. There was no evidence of a system malfunction or failure. The wind as reported by the plt at the time of the accident was calm. - [NTSB BFO87LA029](https://openairdocs.org/ntsb/BFO87LA029.md): Cessna 205 · Midland, VA · Accident · Minor injuries · Limited investigation · Final report · Apr 9, 1987 · N8381Z · Substantial damage > The plt stated that this was the first time he had ever landed on rwy 32. During the lndg apch, about 15 secs before touchdown, his eyeglasses broke and fell off his face. He reached for his spare eyeglasses that were on top of the instrument panel; however,… - [NTSB ATL87LA107](https://openairdocs.org/ntsb/ATL87LA107.md): Cessna 172N · Vidalia, GA · Accident · No injuries · Limited investigation · Final report · Apr 9, 1987 · N75961 · Substantial damage > The plt reported that he apparently had his left foot too high on the left rudder pedal while making a x-wind ldg. The left wheel skidded on the touchdown and the acft ran off the left side of the rwy. The nose wheel subsequently broke off and the acft nosed… - [NTSB MKC87LA101](https://openairdocs.org/ntsb/MKC87LA101.md): Cessna 140 · Eldon, MO · Accident · No injuries · Limited investigation · Final report · Apr 8, 1987 · N2559N · Substantial damage > According to the pilot, winds were light prior to the final approach, but a gust of wind picked up the right wing and the aircraft ballooned during the flare, running out of airspeed while in a full-stall/three-point attitude. Upon impact, both main gears… - [NTSB FTW87LA119](https://openairdocs.org/ntsb/FTW87LA119.md): Piper PA-32R-301 · Lake Providence, LA · Accident · No injuries · Limited investigation · Final report · Apr 8, 1987 · N8248D · Substantial damage > The pilot, who reportedly was familiar with the 2200 x 90 foot sod strip, allowed the aircraft to drift left during the landing roll where the left main landing gear struck the end of a concrete culvert which did not extend quite to the extreme edge of the… - [NTSB MIA87IA131](https://openairdocs.org/ntsb/MIA87IA131.md): Cessna 310Q · Ft.Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · Apr 7, 1987 · N7665Q · Minor damage > During the landing roll the right main gear collapsed. Inspection of the acft by FAA personnel revealed that this was caused by a twisted torque tube which failed to fully extend the gear. - [NTSB LAX87LA170](https://openairdocs.org/ntsb/LAX87LA170.md): Piper PA-28R-200 · Calexico, CA · Accident · No injuries · Limited investigation · Final report · Apr 6, 1987 · N3085R · Substantial damage > At the end of a pleasure cross country flight, the plt reported that upon landing, the acft veered to the left, the plt corrected to the right. The acft veered to the left again and the plt corrected to the right. The acft then began to turn in a clockwise… - [NTSB DEN87LA085](https://openairdocs.org/ntsb/DEN87LA085.md): Aero Commander 100-180 · Cando, ND · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1987 · N4069X · Substantial damage > The acft attempted landing and on short final, the plt recognized a pickup truck obstructing the rwy near midfield. A go around was attempted resulting in an inadvertant stall. The left wing dipped, struck the rwy, and skidded into the vehicle. The acft and… - [NTSB CHI87DEE07](https://openairdocs.org/ntsb/CHI87DEE07.md): Cessna 172 · Lansing, IL · Accident · No injuries · Final report · Apr 6, 1987 · N80379 · Substantial damage > The pilot stated that due to an RPM fluctuation he had diverted to an alternate arpt. He attempted to land on rwy 27 when the wind was from 020 degrees 14 KTS gusting 30 knots. The flap operation was also erratic according to the plt. The acft ran off the… - [NTSB DEN87LA086](https://openairdocs.org/ntsb/DEN87LA086.md): Boeing A75L3 · Belgrade, MT · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N5084N · Substantial damage > The plt report that he was landing on a 9000 x 150 ft asphalt rwy. The wind was nearly down the rwy at 4 to 9 KTS. In a telephone interview 2 days after the accident the plt reported that he was making a 'wheels' landing. He said when the main gear was about… - [NTSB DEN87LA083](https://openairdocs.org/ntsb/DEN87LA083.md): Cessna 180B · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Apr 4, 1987 · N5207E · Substantial damage > The plt reports that he was landing with a lt x-wind at 10 to 15 KTS. He said that at or just after touchdown a gust of wind lifted the lt wing and the acft swerved to the lt off the rwy and nosed over. - [NTSB ATL87LA108](https://openairdocs.org/ntsb/ATL87LA108.md): Piper PA-28R-180 · Lebanon, TN · Accident · No injuries · Limited investigation · Final report · Apr 4, 1987 · N4974J · Substantial damage > The plt reported that he made a VFR pattern for landing on rwy 18 at his destination. The wind was 'hard' and 'straight down the rwy.' He reported that, 'all of a sudden it seemed as though the wind quit and the airplane started to fall.' The acft hit hard… - [NTSB MIA87LA127](https://openairdocs.org/ntsb/MIA87LA127.md): Cessna 180H · Frostproof, FL · Accident · No injuries · Limited investigation · Final report · Apr 3, 1987 · N9731G · Substantial damage > Upon touchdown the rt landing gear tire blew due to the side load placed upon it after the acft was blown sideways by the direct crosswind. The landing gear was then sheared off, after which, the acft slid off the rwy into the grass & came to rest. - [NTSB DEN87LA080](https://openairdocs.org/ntsb/DEN87LA080.md): Cessna 170B · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Apr 3, 1987 · N2323D · Substantial damage > An 85 hour private plt was flying for proficiency in his Cessna 170. At the last landing of the flt, an apparently normal touchdown was completed. During the landing roll, the acft swerved to the left and the plt corrected to the right. The acft continued to… - [NTSB DEN87LA079](https://openairdocs.org/ntsb/DEN87LA079.md): North American Navion · Los Alamos, NM · Accident · No injuries · Limited investigation · Final report · Apr 3, 1987 · N91735 · Substantial damage > The instructor plt was giving cross wind instruction to a pre-solo student plt. During a cross wind landing attempt, the acft touched down hard, breaking off the right main landing gear. The winds were observed at the time of touchdown to be 150 degrees at 12… - [NTSB SEA87LA072](https://openairdocs.org/ntsb/SEA87LA072.md): Piper PA 16 · Jean, NV · Accident · No injuries · Limited investigation · Final report · Apr 2, 1987 · N5916H · Substantial damage > The plt was landing his acft onto runway 02 with the wind from 230 degrees at 7 knots, which would be a left quartering tailwind. During the rollout the acft veered to the right of the runway onto soft terrain striking rocks. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=402 ## 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 = 550) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?page=401 --- 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.