# 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 403 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB CHI87DET02](https://openairdocs.org/ntsb/CHI87DET02.md): Cessna 170B · Angola, IN · Accident · No injuries · Final report · Mar 10, 1987 · N3135A · Substantial damage > Pilot performed full stall landing in moderate right crosswind. Attempts to control weathercocking with full left rudder and aileron were ineffective. Left brake was ineffective. Aircraft received substantial damage in resultant ground loop. - [NTSB NYC87LA103](https://openairdocs.org/ntsb/NYC87LA103.md): Cessna 150M · Poestenkill, NY · Accident · No injuries · Limited investigation · Final report · Mar 8, 1987 · N714CD · Substantial damage > The aircraft came in high and fast, bounced on the centerline and veered left of the centerline on the second bounce. Pilot attempted to correct with right rudder and aileron but the aircraft continued to roll off of the runway and into snow where it nosed… - [NTSB ATL87LA080](https://openairdocs.org/ntsb/ATL87LA080.md): Cessna 172M · Lexington, NC · Accident · No injuries · Limited investigation · Final report · Mar 7, 1987 · N61639 · Substantial damage > The plt reported that he had transitioned to a visual approach, following a simulated radar approach to the rwy using vectors and descent info supplied by an instrument-rated safety plt in the rt seat. The safety plt was the plt's former instructor. The plt… - [NTSB NYC87LA107](https://openairdocs.org/ntsb/NYC87LA107.md): Cessna 152 · Robbinsville, NJ · Accident · No injuries · Limited investigation · Final report · Mar 6, 1987 · N94902 · Substantial damage > When the student plt was lndg after a LCL flt, the acft touched down nose wheel 1st, then ballooned & lndd hard. Drg the occurrence, the nose gear collapsed & the acft slid along the rwy for about 100 yds bfr coming to rest. After the acdnt, the student said… - [NTSB MKC87LA056](https://openairdocs.org/ntsb/MKC87LA056.md): Piper PA-24-250 · Kimball, NE · Accident · No injuries · Limited investigation · Final report · Mar 6, 1987 · N5553P · Substantial damage > The PIC rptd landing rwy 10 with a wnd fm 080 at 7 KTS. The acft began veering left and ran through a snow bank which bordered the rwy. The left main landing gear collapsed and the acft spun around 180 deg stopping tail first. Insp of the landing gear noted… - [NTSB MIA87LA099](https://openairdocs.org/ntsb/MIA87LA099.md): Piper PA-32RT-300T · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · Mar 6, 1987 · N39588 · Substantial damage > Control of the acft was lost due to a strong wind gust created by the tree line next to the rwy & the acft crashed next to the rwy. A plt who had landed just prior to that time stated that he had sustained a momentary lost of acft control during the flare due… - [NTSB NYC87LA102](https://openairdocs.org/ntsb/NYC87LA102.md): Cessna 172N · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Mar 5, 1987 · N5277E · Substantial damage > Student pilot lost directonal control on landing and the aircraft veered to the left of the runway and collided with a snowbank. - [NTSB BFO87FA026](https://openairdocs.org/ntsb/BFO87FA026.md): Cessna 210M · Charleston, WV · Accident · 4 fatal · Field investigation · Final report · Mar 5, 1987 · N1230M · Destroyed > The aircraft bounced after landing touchdown. Witnesses observed the aircraft assume a nose high attitude and heard some power applied to the engine as the aircraft veered to the right. It was not determined whether the pilot was attempting to abort the… - [NTSB MIA87FA098](https://openairdocs.org/ntsb/MIA87FA098.md): Piper PA-34-200 · Miami, FL · Accident · No injuries · Field investigation · Final report · Mar 4, 1987 · N41531 · Substantial damage > The plt stated that he was on final approach & cleared to land long, when a 737 was cleared for an immediate takeoff and he was told to make s turns or whatever necessary. He slowed to land and when he was approximately 10 to 20 ft. in the air he encountered… - [NTSB LAX87LA130](https://openairdocs.org/ntsb/LAX87LA130.md): Grumman AA-1B · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Mar 2, 1987 · N1474R · Substantial damage > During a local solo instructional flight, the pilot reported that on landing, the aircraft touched-down on the nosewheel first and bounced. The aircraft swerved to the right and the pilot added power to initiate a go-around, however, the aircraft did not… - [NTSB BFO87LA025](https://openairdocs.org/ntsb/BFO87LA025.md): Cessna 172N · Charlottesville, VA · Accident · No injuries · Limited investigation · Final report · Mar 2, 1987 · N734ZD · Substantial damage > After climbing to cruise altitude and noting that the winds were stronger than expected, the pilot elected to divert to Charlottesville. Upon entering the traffic pattern, the pilot noted that he would be landing with a crosswind from the right. The aircraft… - [NTSB ATL87LA078](https://openairdocs.org/ntsb/ATL87LA078.md): Beech 23 · Augusta, GA · Accident · Serious injuries · Limited investigation · Final report · Mar 2, 1987 · N2355Z · Substantial damage > The acft was flown from a pvt strip to a nrby arpt at statesboro, GA for refueling. After the acft was refueled, the englost pwr as the student plt was taxiing to takeoff. Water was fnd in the sumps, & rprtdly, 4 to 6 samples were required to drain water from… - [NTSB ATL87LA077](https://openairdocs.org/ntsb/ATL87LA077.md): Maule M-5-235C · Dothan, AL · Accident · No injuries · Limited investigation · Final report · Mar 1, 1987 · N9257E · Substantial damage > The plt reported that the acft nosed over when he applied the brakes during ldg roll-out. He estimated his groundspeed to be about 15-20 mph at the time. - [NTSB MIA87LA096](https://openairdocs.org/ntsb/MIA87LA096.md): Great Lakes 2T-1A-2 · St.Augustine, FL · Accident · No injuries · Limited investigation · Final report · Feb 28, 1987 · N3707F · Substantial damage > The private pilot stated that while attempting a landing the conventional gear aircraft bounced. He initiated a go around and when he added power the aircraft swerved left, ground looped and flipped over. The pilot stated that when he added power he relaxed… - [NTSB LAX87LA154](https://openairdocs.org/ntsb/LAX87LA154.md): Cessna 190 · Chino, CA · Accident · No injuries · Limited investigation · Final report · Feb 28, 1987 · N4498C · Substantial damage > Prior to takeoff the pilot observed an asymmetrical deflection of the rudder/brake pedals. Upon landing he executed a right turn to depart the runway. The pilot stated that he was unable to stop the right turn and the aircraft ground looped damaging the left… - [NTSB LAX87LA131](https://openairdocs.org/ntsb/LAX87LA131.md): Cessna 180 · Oatman, AZ · Accident · No injuries · Limited investigation · Final report · Feb 28, 1987 · N4786B · Substantial damage > At the end of a cross-country flight, the pilot reported that while on final approach, the aircraft encountered moderate turbulence. The pilot set up for a full stall to land in a three point attitude. During the flare, a gust of wind from the right rear blew… - [NTSB ANC87LA041](https://openairdocs.org/ntsb/ANC87LA041.md): Cessna 180B · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Feb 28, 1987 · N9141T · Substantial damage > The pilot lost directional control while landing his tail wheel airplane in a crosswind. The pilot stated that a gust of wind lifted the right wing and he was unable to prevent the left wing from contacting the runway. The airplane eventually came to rest on… - [NTSB NYC87LA100](https://openairdocs.org/ntsb/NYC87LA100.md): Cessna 172 · Cross Keys, NJ · Accident · No injuries · Limited investigation · Final report · Feb 27, 1987 · N9821J · Substantial damage > The plt rprtd that drg the lndg roll, he glanced down at the airspeed indcr, & at the same time, must have relaxed control of the acft. At about that time, the acft drifted to the left side of the rwy, the left main gear struck a snowbank & the acft nosed… - [NTSB LAX87LA129](https://openairdocs.org/ntsb/LAX87LA129.md): Cessna 182Q · Springerville, AZ · Accident · No injuries · Limited investigation · Final report · Feb 27, 1987 · N735PQ · Substantial damage > A Cessna 182 collided with a snow bank after veering off runway 3. The pilot indicated that after touchdown the aircraft began to drift right and he was unable to correct it by applying left pedal. The aircraft suddenly veered left and the pilot applied right… - [NTSB LAX87LA127](https://openairdocs.org/ntsb/LAX87LA127.md): Champion 7KCAB · Roosevelt, AZ · Accident · Minor injuries · Limited investigation · Final report · Feb 27, 1987 · N7572F · Substantial damage > At the end of a pleasure cross-country flight, the pilot reported that during the landing roll, the passenger was moving around in the back seat and accidentally pressed on the right brake. Before the pilot could get the aircraft under control, the aircraft… - [NTSB MIA87LA094](https://openairdocs.org/ntsb/MIA87LA094.md): Cessna A185E · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Feb 26, 1987 · N2287T · Substantial damage > The student plt inadvertently lowered the landing gear on the downwind leg in preparation for a water landing. The flt then turned base to final, &, upon touchdown, the acft nosed over & came to rest inverted in the lake. Investigation revealed that the… - [NTSB DEN87IA059](https://openairdocs.org/ntsb/DEN87IA059.md): Boeing 737-2A6 · Durango, CO · Incident · No injuries · Incident investigation · Final report · Feb 26, 1987 · N145AW · No damage > America west airlines flt 166, a Boeing 737, departed phoenix, AZ, en route to Durango, CO. During the ILS apch to Durango's rwy 02 in IMC, the captain used a 10-15 degree crab angle to maintain the localizer course. Upon touchdown aprx 1000-1300 ft from rwy… - [NTSB CHI87FA087](https://openairdocs.org/ntsb/CHI87FA087.md): Rockwell NA265-65 · East Alton, IL · Accident · No injuries · Field investigation · Final report · Feb 26, 1987 · N465LC · Substantial damage > After landing pilot lost directional control of the aircraft during rollout. Aircraft struck taxiway edge and taxiway marker sign causing substantial damage to aircraft. Post accident testing of the anti-skid system did not reveal any functional defects. - [NTSB MIA87LA093](https://openairdocs.org/ntsb/MIA87LA093.md): Cessna 152 · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · Feb 25, 1987 · N89126 · Substantial damage > The student plt failed to flare the aircraft, landed hard, bounced 2-3 times, then landed on the nose gear causing it to collapse. - [NTSB ATL87LA076](https://openairdocs.org/ntsb/ATL87LA076.md): Piper PA-28-180 · Hampton, GA · Accident · No injuries · Limited investigation · Final report · Feb 23, 1987 · N7681W · Substantial damage > The plt reported that a gusting x-wind existed during the approach to land. When he reduced pwr for touchdown, the acft pitched nose down, began a rapid sink and landed hard. The plt noted that he had the yoke full back but was unable to arrest the sink rate.… - [NTSB NYC87LA094](https://openairdocs.org/ntsb/NYC87LA094.md): Piper PA-28-180 · Colebrook, NH · Accident · Minor injuries · Limited investigation · Final report · Feb 22, 1987 · N3967R · Substantial damage > The plt rprtd that after arriving, the wind shifted to the NE, but he elected to land on rwy 21 'because of a frost heave.' Subsequently, he landed long to avoid the frost heave, but was unable to stop on the icy rwy. The acft contd off the departure end &… - [NTSB NYC87LA096](https://openairdocs.org/ntsb/NYC87LA096.md): Cessna 172 · Poughkeepsie, NY · Accident · No injuries · Limited investigation · Final report · Feb 21, 1987 · N7509G · Substantial damage > During landing roll out, the pilot lost directional control as the aircraft veered to the right side of the runway and collided with a snowbank. - [NTSB LAX87LA124](https://openairdocs.org/ntsb/LAX87LA124.md): Piper PA-28-140 · Petaluma, CA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1987 · N56887 · Substantial damage > At the end of a pleasure cross-country flt, the plt reported he was downwind to rwy 29 and noted the wind was light from 110 degs. On final apch the plt was following another acft and noted that the acft had a slight crab to the right. The plt observed that… - [NTSB BFO87FA024](https://openairdocs.org/ntsb/BFO87FA024.md): Cessna R-182 · Martinsburg, WV · Accident · No injuries · Field investigation · Final report · Feb 21, 1987 · N756KZ · Substantial damage > The plt stated that he forgot to make a final before lndg check because he was concentrating on traffic and the short lndg he had been requested to make. Twr personnel violated USAF procedures when they requested that the acft hold short of the east-west rwy… - [NTSB ATL87LA075](https://openairdocs.org/ntsb/ATL87LA075.md): Piper PA-28-140 · Hixson, TN · Accident · Minor injuries · Limited investigation · Final report · Feb 21, 1987 · N6767W · Substantial damage > During ldg roll on solo instructional flt, stu plt stated that he applied hand brakes and acft swerved to the left. Skid marks found at the site led from near the rwy centerline to a parked C-172 struck during the sequence. Subsequent inspection of the brake… - [NTSB ANC87LA038](https://openairdocs.org/ntsb/ANC87LA038.md): Piper PA-14 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Feb 21, 1987 · N5135H · Substantial damage > The student pilot was practicing touch and go landings on a runway partially covered with snow and ice when he lost control of the aircraft and struck a runway perimeter snow berm. And nosed over. - [NTSB NYC87LA097](https://openairdocs.org/ntsb/NYC87LA097.md): Piper PA-24 · Marlboro, NJ · Accident · No injuries · Limited investigation · Final report · Feb 20, 1987 · N8656P · Substantial damage > While lndg on rwy 27, just bfr sunset, the acft was rprtd to be high & fast on the apch. Subsequently, it contd off the end of the rwy & collided with trees. The plt rprtd he was under stress due to recent death of his parents & the necessity to move the acft… - [NTSB MIA87LA089](https://openairdocs.org/ntsb/MIA87LA089.md): Hughes 269A · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Feb 20, 1987 · N90270 · Substantial damage > The instructor plt was demonstrating a hovering autorotation landing with forward movement, when, after the throttle was closed, the helicopter hung in the air. Forward cyclic was then applied when he realized that the rotor RPM began to deteriorate. The… - [NTSB LAX87LA123](https://openairdocs.org/ntsb/LAX87LA123.md): Cessna 182G · Vallecito, CA · Accident · No injuries · Limited investigation · Final report · Feb 20, 1987 · N3683U · Substantial damage > A Cessna 182G collided with the rwy surface after the nose gear collapsed at a private airstrip. The pilot indicated that the nose gear turned 90 degrees during the landing roll then collapsed. Pilot examined the nose gear after the accident and discovered… - [NTSB DEN87FA057](https://openairdocs.org/ntsb/DEN87FA057.md): Cessna T210N · West Fargo, ND · Accident · Serious injuries · Field investigation · Final report · Feb 20, 1987 · N9499Y · Substantial damage > The acft was observed flying low and slow on final approach to West Fargo arpt. The acft continued flt to the ground, hit hard, bounced and then flew close to the ground in a large sweeping arc until the left wing tip touched the ground. The acft subsequently… - [NTSB ANC87LA037](https://openairdocs.org/ntsb/ANC87LA037.md): Cessna A152 · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Feb 20, 1987 · N761UC · Substantial damage > The student pilot was practicing touch and go landings on a snow covered runway when the pilot lost control of the aircraft, struck a runway perimeter snow berm and nosed over. - [NTSB FTW87LA067](https://openairdocs.org/ntsb/FTW87LA067.md): Cessna 152 · Plano, TX · Accident · No injuries · Limited investigation · Final report · Feb 19, 1987 · N49054 · Substantial damage > According to the pilot, the aircraft was substantially damaged when he lost control of the aircraft on touch down. - [NTSB MKC87LA052](https://openairdocs.org/ntsb/MKC87LA052.md): Beech B-35 · Butler, MO · Accident · No injuries · Limited investigation · Final report · Feb 18, 1987 · N8827M · Substantial damage > The PIC flew a traffic pattern that placed him landing long to the rwy at Butler, MO. The PIC perceived an eng failure prior to attempting a go-around and activated the fuel boost pump and advanced the throttle. The PIC rptd the eng faultered and quit. The… - [NTSB NYC87LA091](https://openairdocs.org/ntsb/NYC87LA091.md): Cessna 172-M · Endicott, NY · Accident · No injuries · Limited investigation · Final report · Feb 17, 1987 · N80583 · Substantial damage > The Cessna 172 was making a landing on runway 21 when it veered off the runway to the right and struck a snow bank. The aircraft received substantial damage and the sole occupant, the pilot, was uninjured. The winds were reported to be from 330' at less than… - [NTSB NYC87LA089](https://openairdocs.org/ntsb/NYC87LA089.md): Cessna 152 · Albion, NY · Accident · No injuries · Limited investigation · Final report · Feb 17, 1987 · N757DD · Substantial damage > The student pilot in a Cessna 152 was making a supervised solo and had completed 4 full stop landing without problem when on the fifth landing, the pilot lost control on the ground and hit a snow bank, flipping over. The pilot reported turbulent wind just as… - [NTSB LAX87LA133](https://openairdocs.org/ntsb/LAX87LA133.md): Cessna 310G · Sedona, AZ · Accident · No injuries · Limited investigation · Final report · Feb 17, 1987 · N161A · Substantial damage > The acft landed hard on rwy 3 while on a night VFR pleasure flight. The plt indicated that it was a dark night and he elected to fly the nda-a iap to insure terrain clearance while looking for the rwy. While on final apch he activated the mirl on the traffic… - [NTSB MIA87LA085](https://openairdocs.org/ntsb/MIA87LA085.md): Cessna 172I · Pelahatchie, MS · Accident · Serious injuries · Limited investigation · Final report · Feb 14, 1987 · N8474L · Substantial damage > The plt stated that he was practicing emerg power-off landings, when, on final apch, realized he wouldn't clear the trees located west of the rwy. He then cleared them by adding power thought the acft then descended in a flare attitude until contact with the… - [NTSB CHI87LA084](https://openairdocs.org/ntsb/CHI87LA084.md): Cessna 172 · Charlevoix, MI · Accident · No injuries · Limited investigation · Final report · Feb 14, 1987 · N8896B · Substantial damage > Upon landing the nose wheel buckled after striking a snowbank and the aircraft flipped over. Pilot reported there was a problem with the nose wheel although inspection of the nose wheel after the accident did not reveal any malfunction. - [NTSB ATL87LA072](https://openairdocs.org/ntsb/ATL87LA072.md): Cessna 182R · Mobile, AL · Accident · No injuries · Limited investigation · Final report · Feb 13, 1987 · N5448N · Substantial damage > The student plt was making a second attempt to land after a hard ldg, bounce, and subsequent go-around. On the first attempt, the acft touched down hard on all three wheels and swerved to the rt. The student plt reportedly pulled the nose up and the acft… - [NTSB MIA87LA083](https://openairdocs.org/ntsb/MIA87LA083.md): Cessna 152 · Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Feb 12, 1987 · N4613P · Substantial damage > The acft ballooned during the student plt's first touch & go landing. She then lowered the nose of the acft, after which, it began to porpoise. The acft then touched down, bounced, stalled, & landed hard collapsing the landing gear. - [NTSB NYC87LA084](https://openairdocs.org/ntsb/NYC87LA084.md): Piper PA-18 · Oxford, MA · Accident · No injuries · Limited investigation · Final report · Feb 11, 1987 · N7182B · Substantial damage > The plt rprtd that drg a lndg, the acft enctrd a gust of wind & veered into a ground loop before he could correct the situation. The acft then hit a snowbank at the side of the rwy & was damaged. The plt rprtd the wind was from 300 deg at 12 gusting 15 KTS. - [NTSB NYC87FA085](https://openairdocs.org/ntsb/NYC87FA085.md): Beech 99 · Oneonta, NY · Accident · No injuries · Field investigation · Final report · Feb 11, 1987 · N699CA · Substantial damage > The flight was uneventful until its arrival at Oneonta municipal airport. The aircraft landed 10 feet short of runway 24IN one foot of snow. The left main landing gear collapsed, the propeller struck the runway and the aircraft veered off the left side of the… - [NTSB DEN87LA054](https://openairdocs.org/ntsb/DEN87LA054.md): Balloon Works Firefly 7 · Colo. Springs, CO · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1987 · N40458 · No damage > The Balloon attempted a normal landing. The instructor plt diverted his attention while the student plt allowed the envelope to cool excessively. This gave a high rate of descent and the Balloon made a hard landing. - [NTSB BFO87LA021](https://openairdocs.org/ntsb/BFO87LA021.md): Cessna 310Q · Moundsville, WV · Accident · No injuries · Limited investigation · Final report · Feb 11, 1987 · N918MC · Substantial damage > On touchdown the pilot realized that he was long but decided it was too late to go-around. He intentionally ground looped the aircraft to the right. Both ends of the runway drop off into a valley. - [NTSB LAX87LA115](https://openairdocs.org/ntsb/LAX87LA115.md): Piper PA-28R-180 · Tulare, CA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1987 · N7498J · Substantial damage > The pilot attempted to land while the runway and VASI approach lights were off. The night was dark and he inadvertently landed on a roadway parallel to the runway. The aircraft collided with a fence when the road came to a dead end adjacent to the near… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=404 ## 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=403 --- 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.