# 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 406 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB NYC87DFA03](https://openairdocs.org/ntsb/NYC87DFA03.md): Cessna 150M · Guilderland Cnt, NY · Accident · No injuries · Final report · Nov 28, 1986 · N704EK · Substantial damage > The student pilot, on a solo 30 NM x-country training flt, became lost while using VOR navigation. A precautionary landing was made in an industrial park. The acft collided with a stack of slate during the landing roll. - [NTSB FTW87FA022](https://openairdocs.org/ntsb/FTW87FA022.md): Cessna 172C · Amarillo, TX · Accident · Minor injuries · Field investigation · Final report · Nov 27, 1986 · N7709U · 2 aircraft · Destroyed > The certificated stu plt of the citabria was making touch and go landings at the uncontrolled arpt when the accident occurred. He took off to the south flying a left hand traffic pattern. The base to final turn was made aprx 1/4 mile from the rwy in front of… - [NTSB LAX87LA050](https://openairdocs.org/ntsb/LAX87LA050.md): Piper PA-18-150 · Half Moon Bay, CA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1986 · N76EV · Substantial damage > The airplane departed modesto airport (mod), modesto, California, on a v.f.r. pleasure flight to Half Moon Bay airport (haf), Half Moon Bay, CA. The flt to haf was uneventful. The plt negotiated a traffic pattern to runway 30. During the landing roll-out the… - [NTSB CHI87DEX02](https://openairdocs.org/ntsb/CHI87DEX02.md): Rohdecap/Thorp T-18 · Elwood, IN · Accident · Minor injuries · Final report · Nov 22, 1986 · N2433 · Substantial damage > The plt departed anderson, Indiana to check farm fields for standing water, then elected to land at the Elwood arpt at Elwood, Indiana. The sod rwy at the arpt had an uneven gradient & was soft from recent rains. While landing on the soft,uneven rwy, the acft… - [NTSB BFO87LA012](https://openairdocs.org/ntsb/BFO87LA012.md): Piper PA-28-140 · Easton, MD · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1986 · N7538R · Substantial damage > The student plt stated that the landing approach was normal until the acft was over the rwy threshold; at a height of 35 ft, he encountered moderate to strong turbulence and afterwards the acft pitched up ten degrees and entered into a moderately steep left… - [NTSB ATL87LA025](https://openairdocs.org/ntsb/ATL87LA025.md): Piper PA-28-140 · Brownsboro, AL · Accident · Minor injuries · Limited investigation · Final report · Nov 22, 1986 · N3869K · Substantial damage > The student pilot was making her first supervised solo flight in the PA28-140 model aircraft. The student reported that wind and low airspeed prevented her from reaching the runway prior to landing touchdown. - [NTSB SEA87LA028](https://openairdocs.org/ntsb/SEA87LA028.md): Cessna T-206 · Warren, ID · Accident · No injuries · Limited investigation · Final report · Nov 20, 1986 · N756WZ · Substantial damage > The pilot was attempting to land on a snow covered us forrest service airstrip at dawn. The aircrafts right main gear caught on uneven terrain to the side of the airstrip, veered to the right, and then nosed over inverted. - [NTSB FTW87LA020](https://openairdocs.org/ntsb/FTW87LA020.md): Barnes Firefly 7 · Holden, LA · Accident · No injuries · Limited investigation · Final report · Nov 19, 1986 · N1245F · Substantial damage > A commercially rated pilot on an instructional flight was attempting a touch and go landing in the median of hiway I-12 1 mile east of Holden, LA. The pilot failed to see and avoid some power lines substantially damaging the balloon. The pilot and student… - [NTSB FTW87FA017](https://openairdocs.org/ntsb/FTW87FA017.md): Cessna 152II · Grandview, TX · Accident · Serious injuries · Field investigation · Final report · Nov 18, 1986 · N68328 · Destroyed > A student plt, while on a solo VFR navigational training flt, became lost. After 3.5 hours of flt, the plt thinking she was almost out of fuel elected to make a downwind landing on a country road near Grandview, TX. The acft contacted trees and subsequently… - [NTSB CHI87LA027](https://openairdocs.org/ntsb/CHI87LA027.md): Cessna T210N · Kankakee, IL · Accident · No injuries · Limited investigation · Final report · Nov 18, 1986 · N9843Y · Substantial damage > The plt overran rwy 22 after landing downwind during intrument weather conditions. Fss had advised the plt of a NOTAM that rwy 4 ILS was out of service due to construction. However, another acft which landed on rwy 4 about 15 minutes prior to the accident… - [NTSB ATL87LA022](https://openairdocs.org/ntsb/ATL87LA022.md): Cessna 402C · Fremont, OH · Accident · No injuries · Limited investigation · Final report · Nov 18, 1986 · N6786P · Substantial damage > The plt reported that he was about five feet above the rwy when he encountered a gust of wind. The acft rocked from side to side during the apch and touched down hard. - [NTSB LAX87LA041](https://openairdocs.org/ntsb/LAX87LA041.md): Piper PA-18-150 · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Nov 17, 1986 · N4101E · Substantial damage > At the end of a local pleasure flight, the pilot attempted a downwind landing by following other traffic in the pattern. During touchdown, the left wing lifted. The pilot corrected by moving the control stick to the left. At that time, the aircraft became… - [NTSB CHI87LA036](https://openairdocs.org/ntsb/CHI87LA036.md): Piper PA-38-112 · Gaylord, MI · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 1986 · N2357E · Substantial damage > The plt landed on a closed rwy and the acft collided with a snowbank. A NOTAM had been issued three days prior, closing the rwy, however, the plt stated that he had not checked notoms prior to departing traverse city. A plt of another acft, who reported being… - [NTSB CHI87LA030](https://openairdocs.org/ntsb/CHI87LA030.md): Piper PA-22 · Rockford, IL · Accident · Minor injuries · Limited investigation · Final report · Nov 16, 1986 · N1457A · Destroyed > During landing roll, plt applied brakes too hard at high speed and nosed over. - [NTSB BFO87IA008](https://openairdocs.org/ntsb/BFO87IA008.md): Boeing 727-231 · Norfolk, VA · Incident · Minor injuries · Incident investigation · Final report · Nov 16, 1986 · N64323 · Minor damage > During the landing roll the r main gear collapsed. A flight attendant received minor injuries during evacuation of the acft. Examination of the acft disclosed that the shock strut cylinder fractured circumferentially; about 10 inches below the top of the… - [NTSB NYC87LA035](https://openairdocs.org/ntsb/NYC87LA035.md): Cessna 185F · Ithaca, NY · Accident · No injuries · Limited investigation · Final report · Nov 15, 1986 · N9680H · Substantial damage > The pilot of the landing Cessna 185 swerved to avoid hitting a deer that was crossing the runway at night. The left wing tip and elevator contacted the runway as the aircraft ground looped. The aircraft received substantial damage, however, it was able to… - [NTSB MKC87LA018](https://openairdocs.org/ntsb/MKC87LA018.md): Cessna 150H · Flippin, AR · Accident · No injuries · Limited investigation · Final report · Nov 15, 1986 · N22037 · Substantial damage > While the student pilot was practicing touch-and-go landings, the airplane ran off the side of the runway, hit a ditch and flipped forward to the inverted position. The pilot stated he thought one of the brakes had locked. There was no signs of excessive… - [NTSB LAX87LA063](https://openairdocs.org/ntsb/LAX87LA063.md): Cessna 310K · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Nov 15, 1986 · N6953L · Substantial damage > The acft was landed hard while on a pleasure flt. The plt indicated that while en route to his destination it was discovered that the door was not properly shut. He diverted to Phoenix to shut the door. The acft was observed descending vertically from aprx 40… - [NTSB MIA87LA032](https://openairdocs.org/ntsb/MIA87LA032.md): Piper PA-32R · Cedar Key, FL · Accident · No injuries · Limited investigation · Final report · Nov 14, 1986 · N20816 · Substantial damage > The plt stated that he was not able to see the lighted wind sock from 1000 ft as he was unfamiliar with its location. The acft landed downwind on the rwy & was unable to stop before running off the end. A 15 to 20 kt tailwind was present at the time. The plt… - [NTSB DCA87MA012](https://openairdocs.org/ntsb/DCA87MA012.md): Lockheed L1011 · Newark, NJ · Accident · No injuries · Major investigation · Final report · Nov 13, 1986 · N714DA · Substantial damage > On November 13, 1986, the rear main spar of the right wing failed as delta flt 194 touched down on rwy 29 at Newark airport. The pilots stated that there was moderate turbulence on final approach and initial touchdown was on the right main gear first. The… - [NTSB CHI87LA024](https://openairdocs.org/ntsb/CHI87LA024.md): Piper PA-30 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Nov 13, 1986 · N7668Y · Substantial damage > The pilot flew for an hour trying to get the gear extended, but was unable. After making a gear up landing, an exam revealed the centering cam on the left side of the nose gear was bent and broken. This could have caused the gear to jam and not extend. - [NTSB NYC87LA031](https://openairdocs.org/ntsb/NYC87LA031.md): Beech BE18H · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1986 · N925J · Substantial damage > The aircraft suffered a right landing gear leg breakage due to a fracture in the area where the fork assembly separated during landing roll. - [NTSB LAX87LA037](https://openairdocs.org/ntsb/LAX87LA037.md): Cessna T210N · Buckeye, AZ · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1986 · N1625U · Substantial damage > A Cessna T210N crashed when the pilot attempted to underfly wires during a go-around. The pilot misjudged the surface winds and made his final approach with a tail wind. When he passed the midpoint on the 2,600 ft airstrip and still was not on the ground he… - [NTSB DEN87LA019](https://openairdocs.org/ntsb/DEN87LA019.md): Bell 47G-3B-1 · Goshen, UT · Accident · No injuries · Limited investigation · Final report · Nov 10, 1986 · N47042 · Substantial damage > The plt was practicing power recovery autorotations then attempted one power off, full stop. The plt allowed the main rotor RPM to decay during approach and took no corrective action. The acft landed hard with slight forward motion and the plt applied aft… - [NTSB SEA87LA053](https://openairdocs.org/ntsb/SEA87LA053.md): Piper PA-46-310-P · Bremerton, WA · Accident · No injuries · Limited investigation · Final report · Nov 9, 1986 · N4323N · Substantial damage > The nose gear did not turn the full 90 degrees prior to locking for landing. When the aircraft's nose was lowered during landing roll this caused the aircraft to veer to the side of the runway. The nose gear had become stiff due to the fact that the… - [NTSB SEA87LA022](https://openairdocs.org/ntsb/SEA87LA022.md): Cessna 182G · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Nov 9, 1986 · N2038R · Substantial damage > According to the plt, he 'greased' the acft on the rwy, but the cast alluminum yoke on the nose gear failed & the nosewheel left the airplane. The strut then failed & the acft was further damaged. - [NTSB CHI87DEV01](https://openairdocs.org/ntsb/CHI87DEV01.md): Piper PA-34-200T · Bloomington, IL · Accident · No injuries · Final report · Nov 8, 1986 · N8156C · Substantial damage > According to the plt, the acft bounced upon touchdown. She attempted to reflare the acft, however, it bounced again and a go-around was performed. The acft was then landed without further incident. Following the landing it was determined the acft had received… - [NTSB LAX87LA034](https://openairdocs.org/ntsb/LAX87LA034.md): Cessna 172M · Shingle Springs, CA · Accident · No injuries · Limited investigation · Final report · Nov 6, 1986 · N9674Q · Destroyed > The plt indicated that after landing the eng quit while turning the acft around on the rwy. He attempted to restart the eng several times but was unable. The plt then exited the acft and pushed it to the rwy shoulder. A local mechanic who was also a plt,… - [NTSB MIA87LA024](https://openairdocs.org/ntsb/MIA87LA024.md): Piper PA-31-350 · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Nov 5, 1986 · N27418 · Substantial damage > The plt stated that he thought he had put the gear handle down but on touchdown the gear was up and the aircraft slid to a stop on the runway. Post crash examination of the landing gear system revealed that the landing gear was up when it contacted the runway… - [NTSB CHI87DEE03](https://openairdocs.org/ntsb/CHI87DEE03.md): Quicksilver MX II · Aurora, IL · Accident · Serious injuries · Final report · Nov 5, 1986 · N4481P · Substantial damage > The pilot was making a precautionary landing in the ultralight, when during the landing flare he stalled the aircraft and subsequently collided with the terrain. - [NTSB MKC87LA013](https://openairdocs.org/ntsb/MKC87LA013.md): Mooney M20D · Johnson, AR · Accident · No injuries · Limited investigation · Final report · Nov 4, 1986 · N5988Q · Substantial damage > The plt had attempted a localizer apch to fayetteville, AK, and stated that his VOR indicator would not hold course. The plt then elected to abort the apch and land at a pvt strip near the fayetteville VOR. The plt was able to land at the strip but according… - [NTSB MIA87LA030](https://openairdocs.org/ntsb/MIA87LA030.md): Balloon Works Firefly 8-24 · Brandon, FL · Accident · Serious injuries · Limited investigation · Final report · Nov 4, 1986 · N37171 · No damage > A high sink rate was not arrested prior to the hard ldg. The plt stated that he briefed the pax on ldg procedures which included a tight grip in the event of an emerg ldg. The pax statements differed from those of the Balloon crew concerning the content of… - [NTSB MKC87LA014](https://openairdocs.org/ntsb/MKC87LA014.md): Cessna 170B · Hyannis, NE · Accident · No injuries · Limited investigation · Final report · Nov 3, 1986 · N8173A · Substantial damage > The pilot stated that he was servicing customers while on this business trip. On his next call, the pilot further stated, he was to land in a hay field that he had previously used but, due to water in the area, he elected to land on higher grounds. Upon… - [NTSB CHI87LA034](https://openairdocs.org/ntsb/CHI87LA034.md): Raven S-66A · Baldwin, WI · Accident · Serious injuries · Limited investigation · Final report · Nov 2, 1986 · N4196N · No damage > While landing, the passengers were instructed to stay to the side of the basket and hold on. However, one passenger moved toward the center of the basket and hit a video camera with her leg. During the occurrence, her leg was fractured between the knee and… - [NTSB ATL87LA015](https://openairdocs.org/ntsb/ATL87LA015.md): Stinson 108-2 · Ada, OH · Accident · No injuries · Limited investigation · Final report · Nov 2, 1986 · N996D · Substantial damage > Plt stated that elevator control was lost during the landing roll. Acft nosed over inverted and received substantial damage. Investigation revealed that the lower cable to elevator bellcrank forward turnbuckle was fractured. Bellcrank was badly corroded. Last… - [NTSB NYC87LA029](https://openairdocs.org/ntsb/NYC87LA029.md): Beech 19 · Selkirk, NY · Accident · No injuries · Limited investigation · Final report · Nov 1, 1986 · N6552R · Destroyed > Pilot attempted a landing without left aileron control. The aircraft turned right then went into an uncontrollable slow spiral to the ground. The failed control rod end bearings showed evidence during post acc invest that they had not been lubricated for a… - [NTSB ATL87LA014](https://openairdocs.org/ntsb/ATL87LA014.md): Boeing B-75-N1 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Nov 1, 1986 · N220SS · Substantial damage > During a landing attempt on asphalt surfaced runway 23, the pilot reported that the aircraft swerved to the left upon touchdown. Right alleron and rudder was applied to stop the turn. Wheel brakes were applied and the aircraft nosed over on the side of the… - [NTSB MIA87LA018](https://openairdocs.org/ntsb/MIA87LA018.md): Piper PA-28-181 · Ft. Pierce, FL · Accident · No injuries · Limited investigation · Final report · Oct 31, 1986 · N8969C · Substantial damage > A USCG helicopter had landed on rwy 4 moments before the accident and had cleared the rwy. The helicopter had advised the acft on UNICOM frequency of his intent to land. The acft advised the helicopter that he had him in sight and would follow him in. The… - [NTSB LAX87FA028](https://openairdocs.org/ntsb/LAX87FA028.md): Fairchild Swearingen SA-226TC · Santa Barbara, CA · Accident · Serious injuries · Field investigation · Final report · Oct 31, 1986 · N137WW · Substantial damage > On a dark night, in cavu weather, the captain directed the first officer (who was flying) to disarm the landing gear warning horn system by pulling its circuit breaker. The f/o complied & did not challenge the captain. On final approach the f/o failed to… - [NTSB CHI87LA013](https://openairdocs.org/ntsb/CHI87LA013.md): Piper PA-28-236 · Harrisburg, IL · Accident · No injuries · Limited investigation · Final report · Oct 31, 1986 · N3066T · Substantial damage > According to the plt, the winds at the destination arpt were variable and gusty. During an approach to land, the acft was high. Reportedly, the wind shifted to a tail wind as the plt was landing & the acft continued off the end of the rwy & went thru a fence. - [NTSB MIA87LA017](https://openairdocs.org/ntsb/MIA87LA017.md): Cessna 152 · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Oct 30, 1986 · N93588 · Substantial damage > The plt stated that he was about to conduct his first touch-&-go ldg after a local solo training flt. On the first ldg, he said he made a 'slight bounce' & he leveled the acft & set up for another flare. He said the acft touched down again on the mains but… - [NTSB MIA87LA016](https://openairdocs.org/ntsb/MIA87LA016.md): Piper PA-28 · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Oct 30, 1986 · N242FT · Substantial damage > The plt was making her 1st solo ldg when the acft began to balloon & porpoise. The acft hit the rwy on the nose & prop then came to rest beside the rwy. A witness stated that the acft had 'got away from her'. The plt stated the accident could have been… - [NTSB FTW87LA013](https://openairdocs.org/ntsb/FTW87LA013.md): Cessna 182J · England Afb, LA · Accident · No injuries · Limited investigation · Final report · Oct 29, 1986 · N2602F · Substantial damage > The plt was on an apch into England Afb, LA, behind a flt of 4 jet fighters. He stated that at aprx 200 ft past the threshold, while at about 3 ft AGL & 80 mph, the acft suddenly fell & touched down on the main gear. It then porpoised btn the main & nose gear… - [NTSB MIA87LA014](https://openairdocs.org/ntsb/MIA87LA014.md): Cessna 172P · Pompano Beach, FL · Accident · No injuries · Limited investigation · Final report · Oct 28, 1986 · N63328 · Substantial damage > The plt stated that during touch-&-go landing practice on his final landing, he landed hard, the nose gear collapsed and the acft slid to a stop on the runway. - [NTSB FTW87LA009](https://openairdocs.org/ntsb/FTW87LA009.md): Piper PA-28-140 · Pollok, TX · Accident · No injuries · Limited investigation · Final report · Oct 28, 1986 · N1325T · Substantial damage > The dual student was receiving emergency landing training. Power was reduced while on approach which resulted in a loss of airspeed and a high sink rate. Corrective action was initiated too late and the aircraft touched down a few feet short. The landing gear… - [NTSB SEA87LA015](https://openairdocs.org/ntsb/SEA87LA015.md): Mooney M20D · Hillsboro, OR · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 1986 · N6625U · Destroyed > The pilot elected to land with a 12 to 15 knot tailwind. An excessive ground speed resulted with an overshoot. The pilot elected to go-around too late and once the go-around was attempted the aircraft struck trees at the departure end of the runway at about… - [NTSB MKC87LA010](https://openairdocs.org/ntsb/MKC87LA010.md): Cessna 185 · Oakley, KS · Accident · No injuries · Limited investigation · Final report · Oct 27, 1986 · N5195H · Substantial damage > The plt stated his landing apch was too fast and the acft touched down long. He then applied brakes and the acft nosed down resulting in the propeller striking the rwy. The acft then proceeded to flip over onto it's back. The plt stated he should not have… - [NTSB DCA87AA006](https://openairdocs.org/ntsb/DCA87AA006.md): Boeing 737-222 · Charlotte, NC · Accident · Serious injuries · Final report · Oct 26, 1986 · N752N · Destroyed > Drg arr, piedmont flt 467 was vectored for an ILS rwy 36R apch. At 2001 CDT (aprx 7 min bfr lndg), all arrg flts were adzd the wx was (in part): 400' ovc, vis 2 mi with lgt rain & fog, wnd fm 090 at 8 KTS. Rwy 5/32 was out-of-svc at that time. Flt 467 was… - [NTSB NYC87DFA01](https://openairdocs.org/ntsb/NYC87DFA01.md): Cessna 150M · Oriskany, NY · Accident · No injuries · Final report · Oct 25, 1986 · N3030V · Substantial damage > The student & instructor plt (CFI) were making a night, touch-&-go landing, when the acft struck a deer on the rwy. They were unable to see the deer in time to avoid a collision. - [NTSB CHI87LA014](https://openairdocs.org/ntsb/CHI87LA014.md): Beech V35A · La Pointe, WI · Accident · No injuries · Limited investigation · Final report · Oct 24, 1986 · N8360N · Substantial damage > The acft struck a deer during the landing flare. The plt was able to maintain control of the acft and complete the landing even though the acft sustained substantial damage to the right wing and its associated structure. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=407 ## 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=406 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.