# 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 395 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB LAX87IA326](https://openairdocs.org/ntsb/LAX87IA326.md): Mooney M20C · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Sep 8, 1987 · N5826Q · Minor damage > The plt rprtd that before landing, he went thru the landing checklist, but the green gear light did not illuminate. He contd the landing, & subsequently, the acft touched down & came to rest with the gear retracted. There was evidence the gear was retracted… - [NTSB CHI87LA210](https://openairdocs.org/ntsb/CHI87LA210.md): Beech 100 · Batesville, IN · Accident · No injuries · Limited investigation · Final report · Sep 8, 1987 · N73KA · Substantial damage > The aircraft was approaching hillenbrand airport when the pilot noticed a thunderstorm cell moving in on the airport. The pilot elected to expedite into hillenbrand. During the approach the landing gear was never placed in the extended position. The pilot… - [NTSB NYC87LA247](https://openairdocs.org/ntsb/NYC87LA247.md): Cessna 172M · W. Mifflin, PA · Accident · No injuries · Limited investigation · Final report · Sep 7, 1987 · N80376 · Substantial damage > The non-certificated pilot took the aircraft without authorization. The aircraft crashed during an attempted landing on runway 10 at allegheny county airport and was substantially damaged. There were two passengers on board but they were not injured. The plt… - [NTSB LAX87LA329](https://openairdocs.org/ntsb/LAX87LA329.md): Cessna 150 · Franklin, CA · Accident · No injuries · Limited investigation · Final report · Sep 7, 1987 · N704XV · Substantial damage > The student pilot was on his first flight in the aircraft after it had been modified with a tail wheel conversion. During the landing, he lost control and the aircraft ground looped. No preimpact part failure or malfunction was evident. - [NTSB LAX87LA327](https://openairdocs.org/ntsb/LAX87LA327.md): Ryan ST3KR · Aguila, AZ · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1987 · N53190 · Substantial damage > The plt made a hard landing and bounced. The acft drifted right before touching down again. Directional control was lost when rt wheel went off the rwy. - [NTSB BFO87LA063](https://openairdocs.org/ntsb/BFO87LA063.md): Balloon Works Firefly 7 · Richmond, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 7, 1987 · N37526 · Minor damage > The Balloon was 10th to takeoff in a hound-&-hare competition. Drg flt, the plt noticed the wind had picked up & that the Balloon was drifting towards Richmond. He decided to land in a cemetery & briefed the passengers that the Balloon would touch down hard &… - [NTSB CHI87LA205](https://openairdocs.org/ntsb/CHI87LA205.md): Cessna 172N · Perham, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 6, 1987 · N734GF · Substantial damage > The pilot was landing on a farm field to the east. The nearest wx station was reporting wind from 220 at 5 KTS. The pilot said after touchdown his speed was too fast to stop so he elected to abort the landing. During climbout the acft struck trees and crashed. - [NTSB ATL87LA251](https://openairdocs.org/ntsb/ATL87LA251.md): Cessna 172E · Lebanon, OH · Accident · No injuries · Limited investigation · Final report · Sep 6, 1987 · N3970S · Substantial damage > A witness rprtd the acft was hi & fast on final apch. The plt stated he landed the acft long & fast & was unable to stop on the remaining rwy. Subsequently, the acft impacted a ditch beyond the dep end of the rwy & the nose gear collapsed. Before the acft… - [NTSB ATL87LA249](https://openairdocs.org/ntsb/ATL87LA249.md): Bell 47G3B1 · Enterprise, AL · Accident · No injuries · Limited investigation · Final report · Sep 6, 1987 · N38CD · Substantial damage > During a practice autorotation, the instructor pilot delayed in appling power to arrest the autorotative descent. The other pilot reported that the autorotation profile was was not the same as the previous successful autorotation. There were no reported… - [NTSB DEN87LA236](https://openairdocs.org/ntsb/DEN87LA236.md): Let L-13 · Buena Vista, CO · Accident · No injuries · Limited investigation · Final report · Sep 5, 1987 · N38924 · Substantial damage > The plt was ferrying the glider to Buena Vista, Colorado & had previously obtained permission to land on a closed rwy. After being towed to the Buena Vista area, he released the glider from the tow plane & flew in the local area for about 40 min. He then… - [NTSB DEN87LA233](https://openairdocs.org/ntsb/DEN87LA233.md): Piper PA-28RT-210 · Yuma, CO · Accident · No injuries · Limited investigation · Final report · Sep 5, 1987 · N2171P · Destroyed > The plt said that during his final approach for landing he thought his airspeed was too high for touchdown and he attempted to go around. During the go around his acft struck an arpt sign and a bldg. - [NTSB DEN87LA232](https://openairdocs.org/ntsb/DEN87LA232.md): National Balloon 858 · Colorado Spring, CO · Accident · No injuries · Limited investigation · Final report · Sep 5, 1987 · N32201 · Substantial damage > The commercial balloon plt was competing in a balloon race. While landing, with the basket on the ground, the balloon drifted into power lines. A large hole was burned in the envelope, and the basket was damaged. The plt and two passengers jumped from the… - [NTSB ANC87LA151](https://openairdocs.org/ntsb/ANC87LA151.md): Champion 7ECA · Salcha, AK · Accident · No injuries · Limited investigation · Final report · Sep 5, 1987 · N4183Y · Substantial damage > The private pilot was unable to maintain directional control of the acft when he encountered a quartering crosswind gust on final approach. The left wing collided with brush and small trees along side of the unattended airstrip. The pilot rptd the wind… - [NTSB MIA87LA240](https://openairdocs.org/ntsb/MIA87LA240.md): Bell 47G · New Port Richey, FL · Accident · No injuries · Limited investigation · Final report · Sep 4, 1987 · N73DB · Substantial damage > The plt was practicing an autorotative lndg for a planned CFI checkride. Drg the lndg, the helicopter touched down on the aft portion of the skids, then pitched forward. As it pitched forward, the plt applied full aft cyclic & the main rotor blades contacted… - [NTSB FTW87LA207](https://openairdocs.org/ntsb/FTW87LA207.md): Mooney M20 · Livingston, TX · Accident · Minor injuries · Limited investigation · Final report · Sep 3, 1987 · N894B · Substantial damage > Drg a practice touch-&-go lndg, the acft bounced. The plt applied power to abort the lndg, but lost directional control of the acft. It drifted left toward trees, so he initiated a climb to fly over the obstructions. However, the acft stalled & collided with… - [NTSB ANC87LA145](https://openairdocs.org/ntsb/ANC87LA145.md): Piper J3C-65 · Kahlitna Glac, AK · Accident · No injuries · Limited investigation · Final report · Sep 2, 1987 · N42128 · Substantial damage > The pilot stated after touchdown on the lake, he lost directional control of the aircraft causing the plane to nose over on its back and the aircraft sank in 20 to 25 feet of water. - [NTSB NYC87DNE05](https://openairdocs.org/ntsb/NYC87DNE05.md): Hall B-80M · Waterford, CT · Accident · Minor injuries · Final report · Sep 1, 1987 · N180RH · Substantial damage > The gyrocopter was observed to touch down and become airborne again. After becoming airborne it was observed to pitch down, with the main rotor blades striking the ground in front of the aircraft. The pilot said his right contact lens wasbothering him and he… - [NTSB ANC87LA132](https://openairdocs.org/ntsb/ANC87LA132.md): Cessna 175 · Yellow Jacket, AK · Accident · No injuries · Limited investigation · Final report · Sep 1, 1987 · N7571M · Substantial damage > The pilot stated he bounced hard on the gravel runway causing him to lose directional control and the airplane nosed over on its back. - [NTSB NYC87LA242](https://openairdocs.org/ntsb/NYC87LA242.md): Mooney M20B · Marlboro, NJ · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1987 · N77DL · Destroyed > During the plt's 1st apch to land, he noted a wind shift & made a go-around. He said the wind shifted back in favor of rwy 27, so he attempted another landing with a longer, lower apch to accommodate the winds. Also, he noted there were trees near the apch… - [NTSB NYC87LA232](https://openairdocs.org/ntsb/NYC87LA232.md): Piper PA-28-161 · Bridgeton, NJ · Accident · No injuries · Limited investigation · Final report · Aug 31, 1987 · N47993 · Substantial damage > The pilot made a landing with a tailwind of 8-10 knots. During landing roll the aircraft pulled to the left and power was added for a go around. The pilot reported, however, that the aircraft would not become airborne so he then decreased the power and the… - [NTSB LAX87LA315](https://openairdocs.org/ntsb/LAX87LA315.md): Cessna 172D · Fortuna, CA · Accident · No injuries · Limited investigation · Final report · Aug 31, 1987 · N246WB · Substantial damage > The pilot was attempting a precautionary landing because of deteriorating weather due to fog. He undershot the runway on his landing touchdown. He said he was blinded by the approach lights but elected to continue with the landing rather than attempting a… - [NTSB ANC87LA131](https://openairdocs.org/ntsb/ANC87LA131.md): Piper PA-12 · Kuskalana Pass, AK · Accident · No injuries · Limited investigation · Final report · Aug 31, 1987 · N4302M · Substantial damage > The pilot stated that during the landing roll on the tundra he applied wheel brakes too hard causing the aircraft to nose over on its back. - [NTSB DEN87LA229](https://openairdocs.org/ntsb/DEN87LA229.md): Taylorcraft BC12-D · Manila, UT · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1987 · N43424 · Substantial damage > The student plt was landing at an uncontrolled airport with an asphalt runway 5300 x 60 ft oriented 250 degrees. She said she made 3 passes over the airport to check for conditions and then executed a normal landing. Shortly after touchdown the aircraft… - [NTSB DEN87LA228](https://openairdocs.org/ntsb/DEN87LA228.md): Cessna 180 · Grassy Butte, ND · Accident · Minor injuries · Limited investigation · Final report · Aug 29, 1987 · N2413C · Substantial damage > N2413C, a Cessna 180, was landing in teddy roosevelt national park where the plt and his passengers intended to hunt deer. A flat, Grassy area on a ridge was selected for landing. The area was checked and marked off by friends of the plt before the landing… - [NTSB CHI87LA199](https://openairdocs.org/ntsb/CHI87LA199.md): Cessna 172P · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Aug 29, 1987 · N54452 · Substantial damage > According to the plt, the lndg was normal until after touchdown when the acft bgn to 'track' toward the rgt side of the rwy. The plt said he applied left rudder, but the acft contd off the rgt side, went into a drainage ditch with standing water & nosed over. - [NTSB LAX87LA319](https://openairdocs.org/ntsb/LAX87LA319.md): Cessna 180 · Glendale, AZ · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 1987 · N3164D · Substantial damage > During landing roll, in crosswind conditions, the aircraft left the runway and went into a ditch. During a telephone interview the pilot stated that he lost control of the aircraft. The pilot was landing on runway 01 and winds were reported to be from 090… - [NTSB SEA87LA184](https://openairdocs.org/ntsb/SEA87LA184.md): Beech C-23 · Bremerton, WA · Accident · No injuries · Limited investigation · Final report · Aug 27, 1987 · N18832 · Substantial damage > On the pilots third touch and go an undershoot occurred during landing onto runway 1. VASI lights are available for that runway. The plt was unable to explain why the undershoot occurred. - [NTSB LAX87LA317](https://openairdocs.org/ntsb/LAX87LA317.md): Beech B-60 · Bermuda Dunes, CA · Accident · No injuries · Limited investigation · Final report · Aug 27, 1987 · N6751D · Substantial damage > The right main landing gear hit the runway lip upon touchdown on runway 11 and collapsed. At the time of the accident the runway's overrun area was under construction and there was a nine inch lip at the runway end. The pilot was aware of the construction… - [NTSB FTW87DQG03](https://openairdocs.org/ntsb/FTW87DQG03.md): Schweizer G-164-A · Seminole, TX · Accident · Serious injuries · Final report · Aug 25, 1987 · N6888Q · Substantial damage > During the flare for landing on a county road the aircraft collided with a pickup truck traveling in same direction as the aircraft. The driver of the pickup sustained serious injuries. The pilot was not injured. The pilot stated he did not see the pickup… - [NTSB DEN87LA227](https://openairdocs.org/ntsb/DEN87LA227.md): Cessna 182Q · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Aug 25, 1987 · N735TJ · Substantial damage > The instructor took control of the acft to make the landing due to excessive crosswind. The ip stated that the apch speed was 70 to 75 KTS. The acft was landed on the first third of runway and brakes applied with half runway remaining. Ip reported that brake… - [NTSB DEN87DTE04](https://openairdocs.org/ntsb/DEN87DTE04.md): Cessna A188B · Stonington, CO · Accident · No injuries · Final report · Aug 25, 1987 · N731GG · Substantial damage > The plt reported that he had completed an aerial application flt and landed on a road to visit with a customer. He said that the left MLG tire blew out during landing and the acft ground looped. The left MLG collapsed during the ground loop and both wings… - [NTSB CHI87DEM12](https://openairdocs.org/ntsb/CHI87DEM12.md): Pitts S-1 · Charlevoix, MI · Accident · No injuries · Final report · Aug 25, 1987 · N76SC · Substantial damage > During landing on a short sod strip with a cross wind the pilot lost control when excessive brakes were applied. The aircraft nosed over. The plt stated that after landing he applied the brakes and the acft assumed about a 45 degree nose down attitude and the… - [NTSB ATL87FA240](https://openairdocs.org/ntsb/ATL87FA240.md): Lockheed L-1011-385-1 · Atlanta, GA · Accident · No injuries · Field investigation · Final report · Aug 25, 1987 · N720DA · Substantial damage > The acft was being flown manually for an ILS apch to rwy 8L at Atlanta. The apch was allowed to become unstable at about the middle marker and the vertical speed was increased to about 1290 feet per minute about five seconds before touchdown. The ioe capt in… - [NTSB ATL87LA238](https://openairdocs.org/ntsb/ATL87LA238.md): Cessna 172M · Marietta, GA · Accident · No injuries · Limited investigation · Final report · Aug 24, 1987 · N64191 · Substantial damage > The student plt was returning to his home airport after receiving a notice of disapproval for his pvt plt practical test. While on final apch to land, he noted a quartering x-wind & elected to use the crab method for controlling drift. Just before touchdown,… - [NTSB ANC87LA133](https://openairdocs.org/ntsb/ANC87LA133.md): Champion 7GC · Central, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1987 · N8507E · Substantial damage > The pilot stated that he was attempting to land in gusty, crosswind conditions and lost control of the airplane. He said the accident could have been avoided by choosing a different airport with less crosswind, or by initiating a go-around when he first… - [NTSB SEA87LA175](https://openairdocs.org/ntsb/SEA87LA175.md): Robinson R-22 · Tukwila, WA · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N8379Z · Substantial damage > While attempting to land in a field and at about 3 feet AGL, the pilot attempted to secure the right cabin door. Due to the distraction the pilot allowed the rear skids to contact the ground and a hard landing resulted. - [NTSB NYC87LA238](https://openairdocs.org/ntsb/NYC87LA238.md): Boeing B-17G · Beaver Falls, PA · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 1987 · N93012 · Substantial damage > Drg an apch in gusty winds, the plt noted a rgt x-wind. He stated that after touchdown, the roll-out was stabilized for a short distance, then the rgt wing began to lift. He applied full aileron & rudder to maint control, but was unable to stop on the… - [NTSB CHI87LA196](https://openairdocs.org/ntsb/CHI87LA196.md): Beech A23 · Longville, MN · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N8799M · Destroyed > The student plt rprtd that as he rounded out to land, the acft nosed down & impacted nosewheel first. Subsequently, the nose gear collapsed & the acft skidded to a stop. After coming to rest, a fire erupted, which spread & subsequently destroyed the acft. - [NTSB ATL87LA236](https://openairdocs.org/ntsb/ATL87LA236.md): Cessna A185F · Mt Airy, NC · Accident · No injuries · Limited investigation · Final report · Aug 23, 1987 · N3463Y · Substantial damage > After Cessna 185, N3462Y, entered the traffic pattern for rwy 18, the UNICOM operator warned the plt of another acft in the pattern. The other acft was a Mooney mite, N4129. The Cessna plt contd his apch, but didn't see the Mooney mite until after the Cessna… - [NTSB LAX87LA313](https://openairdocs.org/ntsb/LAX87LA313.md): Piper PA-38-112 · Buckeye, AZ · Accident · No injuries · Limited investigation · Final report · Aug 22, 1987 · N2483L · Substantial damage > A Piper PA-38-112 landed hard on the runway while on a VFR training flight. The certificated flight instructor (CFI) indicated that the student pilot made an abrupt aft yoke (up elevator) application during the landing flare. The aircraft ballooned… - [NTSB SEA87LA171](https://openairdocs.org/ntsb/SEA87LA171.md): Cessna 172 · Kelso, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 20, 1987 · CGHKY · Destroyed > The plt stated that during touchdown a hard bounced landing occurred. He then elected to execute a go-around and inadvertantly entered into a departure stall. The acft struck the ground in a right wing down, nose low attitude. - [NTSB NYC87MA236](https://openairdocs.org/ntsb/NYC87MA236.md): Mcdonnell Douglas DC-8-63 · Newburgh, NY · Accident · No injuries · Major investigation · Final report · Aug 20, 1987 · N951R · 2 aircraft · Substantial damage > The wx was deteriorating as airborne express flt 124 & rosenbalm flt 074 were on successive arrivals for an ILS rwy 9 apch. Flt 124 was clrd for the apch & lndd. After lndg, the LCL ctlr (l/c) instructed flt 124 to back taxi on the rwy & rprt when clr of the… - [NTSB FTW87LA205](https://openairdocs.org/ntsb/FTW87LA205.md): Beech RC-45J · Houston, TX · Accident · No injuries · Limited investigation · Final report · Aug 20, 1987 · N11249 · Substantial damage > The pilot was practicing landings, almost to a full stop, when the accident occurred. He had asked a commercial pilot to accompany him on this flight. The plt stated that on the fourth landing the left main gear went slightly off the left edge of the runway… - [NTSB DEN87LA223](https://openairdocs.org/ntsb/DEN87LA223.md): Piper PA-11 · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Aug 20, 1987 · N4700M · Substantial damage > The plt was attempting to land his rented acft on runway 29 at Longmont municipal airport when the acft touched down, bounced, veered off of the runway, struck a VASI light, and nosed over. - [NTSB SEA87LA170](https://openairdocs.org/ntsb/SEA87LA170.md): Cessna 182 · Boulder City, NV · Accident · No injuries · Limited investigation · Final report · Aug 19, 1987 · N5549B · Substantial damage > The pilot was attempting to land the aircraft with a 15 knot tailwind gusting to 20 knots. The density altitude was over 6,000 feet and the runway was an uphill runway with rising terrain ahead. The pilot stated that he decided to go-around but that shortly… - [NTSB LAX87LA308](https://openairdocs.org/ntsb/LAX87LA308.md): Piper PA-16 · Ehrenberg, AZ · Accident · No injuries · Limited investigation · Final report · Aug 19, 1987 · N5753H · Substantial damage > While on a x-country flt, the student plt elected to land on a road aprx 12 mi short of his destn to 'check on a job.' He said he was familiar with the road & decided to make a straight-in apch w/o first flying over it to look for obstructions. After making… - [NTSB FTW87LA204](https://openairdocs.org/ntsb/FTW87LA204.md): Beech F50 · Terlingua, TX · Accident · No injuries · Limited investigation · Final report · Aug 18, 1987 · N5629D · Substantial damage > The owner, who occupied the right front seat, stated that he retracted the landing gear during the landing roll inadvertently instead of the flaps. The PIC never responded in writing concerning the actions he took during the accident. - [NTSB ATL87LA237](https://openairdocs.org/ntsb/ATL87LA237.md): Cessna 172 · Jacksonville, AL · Accident · No injuries · Limited investigation · Final report · Aug 18, 1987 · N733DQ · Substantial damage > The plt departed Jacksonville in VFR conds without obtaining a wx briefing. While en route, she observed thunderstorm activity & elected to return to Jacksonville. By the time she returned, the wx had deteriorated & the wind had shifted to the south. The wind… - [NTSB ANC87LA125](https://openairdocs.org/ntsb/ANC87LA125.md): Piper PA-12 · Homer, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 1987 · N3580M · Substantial damage > The pilot stated after the landing rollout he lost directional control of the aircraft causing a groundloop on the runway. This landing was the first full stall landing of the flight. - [NTSB FTW87LA201](https://openairdocs.org/ntsb/FTW87LA201.md): Cessna 185 · San Marcos, TX · Accident · No injuries · Limited investigation · Final report · Aug 16, 1987 · N9930X · Substantial damage > The pilot stated that he landed long and downwind on his private strip. In an attempt to stop he applied heavy braking and at the end of the strip the aircraft nosed over and came to rest on a fence. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=396 ## 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=395 --- 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.