# 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 399 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB FTW87LA145](https://openairdocs.org/ntsb/FTW87LA145.md): Cessna 172 · Yukon, OK · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N13618 · Substantial damage > On touchdown the aircraft started to drift to the left. The pilot applied right rudder and lost directional control of the aircraft. The aircraft's right wing contacted the runway and the aircraft nosed over. - [NTSB DEN87LA151](https://openairdocs.org/ntsb/DEN87LA151.md): Piper PA-22-160 · Los Lunas, NM · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N8924D · Substantial damage > The plt reported that after touchdown, the acft swerved to the right and went into a water filled irrigation ditch. The acft nosed over and came to rest inverted. A post accident inspection revealed a deflated tail wheel which appeared to have blown out. It… - [NTSB DEN87LA149](https://openairdocs.org/ntsb/DEN87LA149.md): Piper PA-36-285 · Driscoll, ND · Accident · No injuries · Limited investigation · Final report · Jun 14, 1987 · N57773 · Destroyed > The plt rprtd he lost directional control as he was lndg on a paved section of old highway to load chemicals. The acft swerved & went into a ditch. The left main gear collapsed & the acft came to rest back on the roadway, where it was destroyed by a… - [NTSB SEA87LA115](https://openairdocs.org/ntsb/SEA87LA115.md): Taylorcraft BC12-D · Ketchikan, AK · Accident · No injuries · Limited investigation · Final report · Jun 13, 1987 · N43944 · Destroyed > The plt made a hard landing while attempting to land on smooth, glassy water. The landing gear float rigging broke on impact which allowed the acft to enter the water. The acft filled with water and sank. - [NTSB FTW87LA141](https://openairdocs.org/ntsb/FTW87LA141.md): Cessna 152 · Arlington, TX · Accident · No injuries · Limited investigation · Final report · Jun 12, 1987 · N24258 · Substantial damage > The dual student pilot, while on his second flight, suddenly applied full right rudder during flare/touchdown and froze on the controls while in this position. The aircraft veered off the right side of the runway into deep and soft mud before the CFI could… - [NTSB CHI87LA144](https://openairdocs.org/ntsb/CHI87LA144.md): Cessna 182M · Lake Village, IN · Accident · No injuries · Limited investigation · Final report · Jun 12, 1987 · N91927 · Substantial damage > The aircraft bounced twice while landing on runway 36 and nosed over after the third bounce. Pilot reports being high on final with 20 degrees flaps so she applied full flaps and steepened glide angle. She also reports a northwest crosswind at 15 to 20 knots,… - [NTSB NYC87LA171](https://openairdocs.org/ntsb/NYC87LA171.md): Piper PA-24-180 · Middlesex, NY · Accident · No injuries · Limited investigation · Final report · Jun 10, 1987 · N5060P · Substantial damage > The pilot stated that a normal t/d was made at 75 mph abt 1/3RD of the way down the rwy. During rollout, the acft went through a dip and became airborne again. After touching down again, brakes were applied but the aircraft did not stop on the wet, freshly… - [NTSB MIA87LA178](https://openairdocs.org/ntsb/MIA87LA178.md): Piper PA-24-250 · Kissimmee, FL · Accident · No injuries · Limited investigation · Final report · Jun 10, 1987 · N6529P · Substantial damage > The plt failed to lower the landing gear prior to touchdown. Insp of the acft revealed that the landing gear warning horn & gear down & locked light were inoperative. - [NTSB MIA87LA175](https://openairdocs.org/ntsb/MIA87LA175.md): Greco Bruno Dolphin 1 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Jun 10, 1987 · N51PJ · Substantial damage > The pilot stated that the acft stalled during the flare to touchdown, landed hard, & collapsed the rt main landing gear. - [NTSB FTW87LA138](https://openairdocs.org/ntsb/FTW87LA138.md): Piper PA-28-160 · Norman, OK · Accident · No injuries · Limited investigation · Final report · Jun 9, 1987 · N5552W · Substantial damage > While performing a touch and go landing, the aircraft landed hard causing a vibration in the engine area, and some loss of rudder control. The pilot flew by the tower and the tower indicated everything looked ok. On landing roll the nose gear failed causing… - [NTSB ATL87IA163](https://openairdocs.org/ntsb/ATL87IA163.md): Piper PA-34-200 · Birmingham, AL · Incident · No injuries · Incident investigation · Final report · Jun 9, 1987 · N56657 · Minor damage > The pilot reported that during a landing, he forgot to extend the landing gear. He was wearing a 'dave clark' headset with earplugs & did not hear the landing gear warning horn. During a subsequent check of the landing gear, it operated normally. - [NTSB ANC87DAG02](https://openairdocs.org/ntsb/ANC87DAG02.md): de Havilland Beaver U-6A · Sparrevohn, AK · Accident · No injuries · Final report · Jun 9, 1987 · N123PG · Substantial damage > The pilot stated that just prior to touchdown he encountered a wind shear. The acft stalled and crashed on the gravel bar. - [NTSB ATL87LA165](https://openairdocs.org/ntsb/ATL87LA165.md): Cessna 172G · Steubenville, OH · Accident · No injuries · Limited investigation · Final report · Jun 8, 1987 · N3644L · Substantial damage > PIC rpted he flew over airport and noted wind direction as 290-300 degrees on wind indicator. He entered downwind for rwy 31 at uncontrolled field. Normal approach flown with full flaps on final with left crosswind correction. About 30-40 feet above rwy, acft… - [NTSB MKC87LA123](https://openairdocs.org/ntsb/MKC87LA123.md): Beech C35 · Spencer, IA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N1931D · Substantial damage > During ldg, PIC failed to maintain directional control and swerved off the rwy. Ldg gear collapsed and acft was substantially damaged. Witnesses said plt and pax were behaving irrationally prior to lvf departure apt. PIC left the scene of accident and two… - [NTSB LAX87LA232](https://openairdocs.org/ntsb/LAX87LA232.md): Bellanca 14-13-2 · Rancho Calif, CA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N86789 · Substantial damage > The plt elected to make a precautionary landing due to deteriorating wx along his route of flt. He stated that there was a x-wind from the left when he landed on rwy 30. Drg the landing, the acft drifted off the rwy & one of the main landing gear mired in… - [NTSB LAX87LA228](https://openairdocs.org/ntsb/LAX87LA228.md): Cessna 120 · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N76546 · Substantial damage > A Cessna 120 landed left of the runway on a rough dirt area and nosed over. The pilot indicated that the airport is not lighted. The runway is equipped with white reflectors and the taxiways are equipped with amber reflectors. The pilot stated he was unable… - [NTSB DEN87LA154](https://openairdocs.org/ntsb/DEN87LA154.md): Mooney M20E · Harwood, ND · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N6933U · Substantial damage > The plt was landing his Mooney M20E on a private grass airstrip. He said he lowered the manual landing gear and thought he felt the thumblock snap into place. Upon touchdown the landing gear folded up and the acft slid to a stop, resulting in substantial… - [NTSB CHI87LA141](https://openairdocs.org/ntsb/CHI87LA141.md): Luscombe 8E · Dodgeville, WI · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1987 · N1402B · Substantial damage > While landing on runway 30, the pilot reported that the wind shifted from a crosswind to a tailwind. During an attempted go-around the pilot lost directional control and struck a metal utility shed prior to impacting the ground. - [NTSB CHI87FA140](https://openairdocs.org/ntsb/CHI87FA140.md): Grumman American AA-5 · Middleton, WI · Accident · 4 fatal · Field investigation · Final report · Jun 7, 1987 · N1358R · Destroyed > The pilot had communicated with other pilots concerning the difficulties he was having with the winds. He had already attempted approaches to two other runways but had failed to complete a landing. He asked the pilot of a recent arrival for the wind… - [NTSB BFO87DIG05](https://openairdocs.org/ntsb/BFO87DIG05.md): Cessna 152 · Baltimore, MD · Accident · No injuries · Final report · Jun 7, 1987 · N48935 · Substantial damage > The student pilot, who had approximately 47 hours in the aircraft and approximately 8 hours as pilot-in-command, stated that after touchdown on runway 33R the aircraft veered to the right and departed the runway and collided with a ditch. The wind was… - [NTSB ANC87LA076](https://openairdocs.org/ntsb/ANC87LA076.md): Maule M-6 · Kenai, AK · Accident · No injuries · Limited investigation · Final report · Jun 7, 1987 · N5645D · Substantial damage > The pilot effected a go-around during an approach to runway 01 in gusty surface wind conditions. During the second approach he landed and lost control at or near the demonstrated crosswind component limit for this airplane. The airplane ground looped and… - [NTSB SEA87LA113](https://openairdocs.org/ntsb/SEA87LA113.md): Cessna 172P · Snohomish, WA · Accident · No injuries · Limited investigation · Final report · Jun 6, 1987 · N65994 · Substantial damage > The pilot initiated a landing on a 2650 ft long runway in a 11-18 knot quartering tailwind condition. He flew the final approach too fast and flared prematurely. The acft floated down the rwy, landed hard and bounced twice. The plt lost control and the acft… - [NTSB NYC87IA167](https://openairdocs.org/ntsb/NYC87IA167.md): Nihon YS-11 · Hyannis, MA · Incident · No injuries · Incident investigation · Final report · Jun 6, 1987 · N187P · Minor damage > The YS-11 was landing with a right crosswind. The pilot said he touched down on the right main landing gear first and upon touchdown, the right main landing gear collapsed. The aircraft stayed on the runway and received minor damage. The cockpit crew of 2, 2… - [NTSB MIA87LA172](https://openairdocs.org/ntsb/MIA87LA172.md): Bushby Mustang II · Cocoa, FL · Accident · No injuries · Limited investigation · Final report · Jun 6, 1987 · N84HM · Substantial damage > During the landing roll the plt lost control of the acft. It then departed the rwy, collided with a taxiway marker sign & came to rest. - [NTSB FTW87LA140](https://openairdocs.org/ntsb/FTW87LA140.md): Cessna 150G · College Station, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1987 · N8612J · Substantial damage > The pilot stated that upon touchdown the aircraft began to shake so violently that he could not see the panel or control the aircraft. During landing roll it veered off the left side of the runway. The nose and right main gear wheels dug into the soft ground… - [NTSB CHI87LA107](https://openairdocs.org/ntsb/CHI87LA107.md): Cessna 172N · Marion, IN · Accident · No injuries · Limited investigation · Final report · Jun 6, 1987 · N5240E · Substantial damage > The plt stated that on final aprx he did not flare soon enough and the nosewheel 'hit the rwy hard.: he further stated that the acft 'ballooned up' and he attempted to 'flare out again without success. ' according to the plt, the acft bounced up and down an… - [NTSB NYC87LA158](https://openairdocs.org/ntsb/NYC87LA158.md): Beech 58TC · Oxford, CT · Accident · No injuries · Limited investigation · Final report · Jun 5, 1987 · N6058U · Substantial damage > The flight was making an ILS approach to runway 36 in IMC. The aircraft touched down about 2,000 feet down the 5,000 foot runway and to the left of the runway centerline. The aircraft hydroplaned on standing water on the runway and skidded off the end coming… - [NTSB SEA87LA109](https://openairdocs.org/ntsb/SEA87LA109.md): Hughes 269C · Vancouver, WA · Accident · Minor injuries · Limited investigation · Final report · Jun 3, 1987 · N9606F · Destroyed > During a practice run-on landing the aircraft started to vibrate violently and an almost simultaneous fire occurred. Both pilots and an eyewitness stated that the run on landing was very smooth. Both pilots stated that something mechanical let loose during… - [NTSB SEA87LA108](https://openairdocs.org/ntsb/SEA87LA108.md): Cessna T210L · Dayton, WA · Accident · No injuries · Limited investigation · Final report · Jun 3, 1987 · N2222S · Substantial damage > During landing the aircraft floated. The pilot elected to make a go-around but had used up more than one half the runway. Shortly after applying full power the pilot reduced power to idle for landing on a barley field at the departure end of the runway.… - [NTSB MIA87LA169](https://openairdocs.org/ntsb/MIA87LA169.md): Cessna 421B · Miami, FL · Accident · No injuries · Limited investigation · Final report · Jun 3, 1987 · N137JR · Substantial damage > During the landing roll the lt main landing gear collapsed. The acft then slid to a stop. Insp of the lt landing gear revealed that the upper & lower torque links which maintains parallel alignment of the tire to the fuselage separated. This occurred as a… - [NTSB MIA87IA170](https://openairdocs.org/ntsb/MIA87IA170.md): Piper PA-44-180 · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Jun 3, 1987 · N180PA · Minor damage > During the landing roll the rt main landing gear collapsed. Examination of the landing gear revealed that the strut housing (trunnion) failed due to overload which was precipitated by fatigue and caused by a stress riser located on a manufacturing seam. - [NTSB MIA87LA199](https://openairdocs.org/ntsb/MIA87LA199.md): Let L-13 · Plymouth, FL · Accident · No injuries · Limited investigation · Final report · May 31, 1987 · N99946 · Substantial damage > The plt misread the altimeter by 1000 ft when the flt entered the initial point of the traffic pattern. He then began circling to dissipate alt & realized that the acft was low. He then proceeded downwind, turned base then final & landed hard buckling the… - [NTSB ANC87LA074](https://openairdocs.org/ntsb/ANC87LA074.md): Cessna 185 · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · May 30, 1987 · N177BM · Substantial damage > The pilot landed on an asphalt surfaced runway with a Cessna 185 airplane that had been modified to accept extremely large 'tundra' tires, which are intended primarily for off-airport and gravel runway landings. The pilot lost directional control during the… - [NTSB NYC87DGT01](https://openairdocs.org/ntsb/NYC87DGT01.md): Schleicher ASW-20L · Mt Holley Sprgs, PA · Accident · Minor injuries · Final report · May 29, 1987 · N705X · Substantial damage > Just before touchdown, during an off-arpt landing, the plt tried to extend the flaps from a 30 deg position to full down (55 deg). He said that due to his short stature & seat position, he had difficulty positioning his left arm to do this. As he tried to… - [NTSB CHI87LA134](https://openairdocs.org/ntsb/CHI87LA134.md): Cessna U206C · Grand Rapids, MN · Accident · No injuries · Limited investigation · Final report · May 29, 1987 · N3970G · Substantial damage > The plt rprtd that drg a water lndg, the left float dug in & caused the left wing to strike the water. Subsequently, the acft nosed over. The plt did not rprt any abnormal wind or water condition. - [NTSB ANC87LA073](https://openairdocs.org/ntsb/ANC87LA073.md): Cessna 180 · Naknek, AK · Accident · No injuries · Limited investigation · Final report · May 29, 1987 · N2940C · Substantial damage > The private pilot elected to land at an abandoned arpt on an unmaintained dirt taxiway adjoining the gravel rwy inorder to reduce the crosswind component. The acft hit a soft spot during the landing roll and nosed over. The U.S. Dept of commerce's Alaska… - [NTSB FTW87LA131](https://openairdocs.org/ntsb/FTW87LA131.md): Piper PA-34-200 · Grand Prairie, TX · Accident · No injuries · Limited investigation · Final report · May 27, 1987 · N41788 · Substantial damage > During landing roll the right main landing gear tire failed causing a loss of directional control. The acft departed the right side of the rwy, and the right main landing gear collapsed. - [NTSB MIA87LA163](https://openairdocs.org/ntsb/MIA87LA163.md): Piper PA-28-180D · Astatula, FL · Accident · No injuries · Limited investigation · Final report · May 26, 1987 · N6406J · Substantial damage > The plt became disoriented and performed a precautionary landing. During the landing roll, the pilot taxied into a ditchand the nose gear collapsed. - [NTSB ATL87LA150](https://openairdocs.org/ntsb/ATL87LA150.md): Piper PA-28-200 · Maxwell Afb, AL · Accident · No injuries · Limited investigation · Final report · May 26, 1987 · N6857J · Substantial damage > During the landing roll, the pilot lost directional control of the acft. The right main and nose gears collapsed. Inspection of the acft failed to reveal any system malfunction/failure. - [NTSB MKC87LA108](https://openairdocs.org/ntsb/MKC87LA108.md): Cessna 150L · Harrison, AR · Accident · No injuries · Limited investigation · Final report · May 25, 1987 · N1418Q · Substantial damage > The pilot said he was landing into the wind and when he was 20 feet above the runway, the wind seemed to shift to a tail wind. The airplane stalled, hit the runway hard and bounced. The pilot said he pushed the control wheel forward and the nose wheel hit the… - [NTSB SEA87LA101](https://openairdocs.org/ntsb/SEA87LA101.md): Aero Commander AC-100 · Alderwood Manor, WA · Accident · Minor injuries · Limited investigation · Final report · May 24, 1987 · N3768X · Substantial damage > During takeoff on a short 1700 foot airstrip under no wind conditions, close to gross weight, the aircraft was not able to clear trees at the departure end of the runway. The pilot recognized this and reduced power for a precautionary landing onto an adjacent… - [NTSB NYC87LA155](https://openairdocs.org/ntsb/NYC87LA155.md): North American SNJ-2 · Farmingdale, NY · Accident · No injuries · Limited investigation · Final report · May 24, 1987 · N65370 · Substantial damage > The plt was performing touch-&-go landings. On the 3rd landing, the main gear collapsed & the acft received substantial damage. No pre-acdnt part failure or malfunction was reported. - [NTSB FTW87LA127](https://openairdocs.org/ntsb/FTW87LA127.md): Cessna 140 · Waco, TX · Accident · No injuries · Limited investigation · Final report · May 24, 1987 · N111NZ · Substantial damage > The pilot stated that brakes were applied during the landing roll prior to the tailwheel making ground contact causing the aircraft to nose over and come to rest inverted. The aircraft was substantially damaged. - [NTSB NYC87LA153](https://openairdocs.org/ntsb/NYC87LA153.md): Cessna 182 · Ellington, CT · Accident · No injuries · Limited investigation · Final report · May 23, 1987 · N9192G · Substantial damage > The pilot stated that while making a standard left traffic pattern, the wind at the north end of the airport shifted from the southeast to the northwest. The acft touched down with excessive ground speed, ran off the end of the rwy and came to rest on a… - [NTSB MIA87LA162](https://openairdocs.org/ntsb/MIA87LA162.md): North American AT-6D · Fernandina Bch, FL · Accident · No injuries · Limited investigation · Final report · May 23, 1987 · N2996Q · Substantial damage > Tail wheel strut was found to be over serviced causing it to be extended higher than normal. This would cause the aircraft to be harder to steer. On landing in a cross wind the pilot experienced vibration of the tail wheel followed by failure due to torsional… - [NTSB FTW87DPA01](https://openairdocs.org/ntsb/FTW87DPA01.md): North American SNJ-5 · Mckinney, TX · Accident · Serious injuries · Final report · May 23, 1987 · N777HL · Substantial damage > The pilot reportedly made a normal touchdown in a calm wind condition. During the landing rollout,however, he applied excessive braking. This caused the tail wheel equipped aircraft to nose over into an inverted attitude. - [NTSB FTW87LA122](https://openairdocs.org/ntsb/FTW87LA122.md): Cessna 152 · Mckinney, TX · Accident · No injuries · Limited investigation · Final report · May 21, 1987 · N5215P · Substantial damage > The student plt rprtd that drg a lndg, the wind shifted from a headwind to a left crosswind. Subsequently, the acft veered off the left side of the rwy & enctrd soft mud, then the nose gear collapsed & the acft nosed over. - [NTSB DEN87LA128](https://openairdocs.org/ntsb/DEN87LA128.md): Cessna 172I · Taos, NM · Accident · No injuries · Limited investigation · Final report · May 20, 1987 · N46231 · Substantial damage > The private plt and his CFI rated pax were practicing touch and go landings at the local arpt. During landing a wind gust pushed the acft off the runway centerline to the right. The runway shoulder was soft, a go-around attempt was unsuccessful and the acft… - [NTSB CHI87DET04](https://openairdocs.org/ntsb/CHI87DET04.md): Cessna 172P · Peru, IN · Accident · Minor injuries · Final report · May 18, 1987 · N62629 · Substantial damage > The pilot was attempting a cross country VFR flight and was making a second precautionary landing to avoid severe weather. On landing the pilot landed hard, collapsed the nose gear, exited the runway and nosed over in soft terrain. - [NTSB NYC87LA152](https://openairdocs.org/ntsb/NYC87LA152.md): Piper PA-28 · Reading, PA · Accident · No injuries · Limited investigation · Final report · May 17, 1987 · N4387X · Substantial damage > According to the plt, the acft touched down (drg lndg) about 10 ft rgt of the rwy centerline. He stated that after the acft rolled about 50 yds, he heard a 'bump' & the acft veered rgt. However, the tower controller stated that the acft touched down in the… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=400 ## 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=399 --- 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.