# 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 445 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB MKC84FU003](https://openairdocs.org/ntsb/MKC84FU003.md): American Aerolights Eagle XL · Millard, NE · Accident · Serious injuries · Final report · May 5, 1984 · UNREG · Substantial damage > The plt of the ultralight vehicle was flying as #2 in a flt of 2. The plt of the lead acft stated that they observed rain showers south of Millard & elected to return to the arpt ahead of the precipitation. After arriving, they landed on a 40 ft wide taxiway… - [NTSB FTW84LA229](https://openairdocs.org/ntsb/FTW84LA229.md): Cessna 150L · Seymour, TX · Accident · Minor injuries · Limited investigation · Final report · May 5, 1984 · N5457Q · Destroyed > The 27 hour student plt aborted his landing when the acft began to balloon. The plt retracted the flaps and the acft settled hard onto the rwy and bounced back into the air. The plt reacted by pulling back on the yoke and inadvertently applied left aileron… - [NTSB CHI84LA321](https://openairdocs.org/ntsb/CHI84LA321.md): Cessna 177 · Hobart, IN · Accident · No injuries · Limited investigation · Final report · May 5, 1984 · N2959X · Substantial damage > The plt figured he was high and hot during landing so he said he just pushed the nose over and forced the acft onto the rwy. The acft hit hard on the nose gear and bounced. After recovery the plt found the nose gear tire flat and taxiied off the rwy into the… - [NTSB ATL84LA162](https://openairdocs.org/ntsb/ATL84LA162.md): Cessna 152 · Greensboro, NC · Accident · No injuries · Limited investigation · Final report · May 5, 1984 · N757AS · Substantial damage > The student reported that he flared too high & the acft bounced about 4 times after which it left the rwy. The nose gear collapsed as it contacted mud beside the rwy. - [NTSB ATL84LA161](https://openairdocs.org/ntsb/ATL84LA161.md): Waco RNF · Thomaston, GA · Accident · No injuries · Limited investigation · Final report · May 5, 1984 · N11256 · Substantial damage > During the landing roll the acft drifted to the side of the sod strip where a wheel encountered a surface deviation. The acft turned & nosed over. - [NTSB SEA84LA099](https://openairdocs.org/ntsb/SEA84LA099.md): Bellanca 7GCBC · Sherwood, OR · Accident · No injuries · Limited investigation · Final report · May 2, 1984 · N222WY · Substantial damage > During landing the acft swerved off the rwy. The plt stated that the recommended procedure at this arpt is to land uphill. Investigation revealed that the landing was made with a 9 kt quartering tailwind. - [NTSB NYC84LA156](https://openairdocs.org/ntsb/NYC84LA156.md): Consolidated Aeronautics Vultee L-13A · Dummerston, VT · Accident · No injuries · Limited investigation · Final report · May 2, 1984 · N90426 · Substantial damage > During arrival, the plt landed to the south on a turf rwy. He stated that after a normal apch & touchdown, the acft encountered a gust of wind, presumably from the northwest & the acft nosed over. Also, in an accident report, he reported the wind was from the… - [NTSB CHI84LA173](https://openairdocs.org/ntsb/CHI84LA173.md): Beech A36 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · May 2, 1984 · N3735Y · Substantial damage > The acft touched down hard during the landing. The nose gear collapsed and the acft slid to a stop. The plt said he was not able to arrest the sink rate of the acft with power during the landing flare. - [NTSB LAX84LA276](https://openairdocs.org/ntsb/LAX84LA276.md): Schweizer SGS 1-26D · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1984 · N7562 · Substantial damage > The student, glider plt stated that he encountered a loss of lift while on the downwind side of a hill. Subsequently, he selected a field for an off-arpt landing. On final apch, the plt noticed a fence in the middle of the field & was unable to avoid it. He… - [NTSB LAX84LA310](https://openairdocs.org/ntsb/LAX84LA310.md): Globe GC-1B · Death Valley, CA · Accident · No injuries · Limited investigation · Final report · Apr 29, 1984 · N80762 · Substantial damage > According to the plt, the approach to rwy 33 was in a 'no-wind condition until about 30-40 ft AGL when a strong tail wind came up.' He stated that it appeared that there was sufficient rwy remaining and when he realized it was too late to stop or go around he… - [NTSB LAX84LA274](https://openairdocs.org/ntsb/LAX84LA274.md): Hall-Cavalier SA-102.5 · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Apr 29, 1984 · N491HC · Destroyed > During a landing, the acft bounced & porpoised several times and the nose gear failed. Subsequently, the acft skidded to a stop on the rwy & a fire erupted in the eng compartment. The occupant exited the plane, but moments later, it was consumed by the fire. - [NTSB NYC84LA150](https://openairdocs.org/ntsb/NYC84LA150.md): Cessna 152 · Laconia, NH · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · N5171B · Substantial damage > The acft ballooned during landing and came down hard on the nose gear which collapsed. The plt said a gust of wind had made the acft ascend about 20-50 ft after which it fell to the rwy. He reported the prevailing wind was variable from 270 to 290 deg a 12… - [NTSB MKC84LA130](https://openairdocs.org/ntsb/MKC84LA130.md): Cessna 152 · N.Carlisle, AR · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · N4823L · Substantial damage > The acft nosed over after swerving off the rwy into soft sod during landing. The student plt was on his 2nd solo flt andpracticing touch and go landings. This was the plts 1st landing at carlisle arpt where the wind was of more velocity and greater angle than… - [NTSB LAX84LA272](https://openairdocs.org/ntsb/LAX84LA272.md): Douglas DC-6A · San Manuel, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1984 · N92860 · Destroyed > The acft skidded off the departure end of the rwy collapsing the landing gear in a ditch as it caught on fire. This acftwas on a ferry flt and had several mechanical problems. Among these was the prop reversers which failed on landing. The anti-ice/de-ice… - [NTSB LAX84LA271](https://openairdocs.org/ntsb/LAX84LA271.md): Maule M-4-220C · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · N40329 · Substantial damage > The flight was conducted for a sales demonstration. Both occupants were pilots. Two landings were performed by the acft owner. The third landing was performed by the prospective buyer and during touchdown the acft bounced. The owner applied power to recover.… - [NTSB CHI84LA170](https://openairdocs.org/ntsb/CHI84LA170.md): Luscombe 8A · Shelbyville, IL · Accident · No injuries · Limited investigation · Final report · Apr 28, 1984 · N1955B · Substantial damage > After a normal 3-point, full stall landing, the tailwheel equipped acft rolled a short distance, then veered to the left. The plt stated that he applied right rudder & both brakes, but the acft continued to the left. He reported that as the plane went off the… - [NTSB NYC84LA153](https://openairdocs.org/ntsb/NYC84LA153.md): Beech B24R · Clinton, MD · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1984 · N6605R · Destroyed > The main rwy at the arpt was closed due to resurfacing. The plt was attempting a landing on rwy 31 knowing it would be a deliberate downwind landing. According to the operator of the arpt, plts were discouraged from using rwy 13 because the traffic directly… - [NTSB NYC84FA149](https://openairdocs.org/ntsb/NYC84FA149.md): Cessna 170B · Turner, ME · Accident · 1 fatal · Field investigation · Final report · Apr 26, 1984 · N3112A · Destroyed > Witnesses observed the acft approach, flaps down, for lndg. A flare was made near the approach end of the runway, then the acft ballooned to about 20 ft AGL and once more descended to the runway surface. On touchdown, the right wing tip appeared to contact… - [NTSB MIA84LA152](https://openairdocs.org/ntsb/MIA84LA152.md): Piper PA-24-180 · Valdosta, GA · Accident · No injuries · Limited investigation · Final report · Apr 26, 1984 · N7059P · Substantial damage > The instructor plt (CFI) stated that he was giving a private plt a biennial flt review & that the private plt was the plt-in-command (PIC). While in the traffic pattern for their 2nd landing, they heard another acft entering the pattern, but they were not… - [NTSB CHI84LA162](https://openairdocs.org/ntsb/CHI84LA162.md): Taylorcraft DCO-65 · Palmyra, WI · Accident · Minor injuries · Limited investigation · Final report · Apr 26, 1984 · N47583 · Substantial damage > The pilot lost control of the acft on the landing flare & collided with a tree. The acft was blown to the left of the rwy & before he could execute a go-around the propeller struck some high brush alongside the rwy. The plt pulled power off, landed in rough… - [NTSB SEA84LA095](https://openairdocs.org/ntsb/SEA84LA095.md): Piper PA-22-150 · Davenport, WA · Accident · No injuries · Limited investigation · Final report · Apr 25, 1984 · N6002D · Substantial damage > During the landing roll the brakes were applied with no effect. The acft went off the end of the rwy into a ditch and nosed over. Examination of the acft showed the brake system low on fluid and the master cylinder diaphragm ruptured. - [NTSB MIA84LA151](https://openairdocs.org/ntsb/MIA84LA151.md): Cessna 172M · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Apr 25, 1984 · N4657Q · Substantial damage > During a landing, the plt lost directional control & the acft veered off the left side of the rwy. The nose gear struck a concrete drainage conduit & was substantially damaged. The plt reported the wind was from 090 deg at 8 KTS. - [NTSB CHI84LA171](https://openairdocs.org/ntsb/CHI84LA171.md): Piper PA-32-260 · Marion, IN · Accident · No injuries · Limited investigation · Final report · Apr 25, 1984 · N3874W · Substantial damage > The student plt reported that during a landing, he reduced the power too soon & flared the acft too high, then the acft bounced about 8 to 10 ft in the air. The hard landing resulted in spar damage to the right wing. - [NTSB CHI84LA159](https://openairdocs.org/ntsb/CHI84LA159.md): Cessna 152 · Stow, OH · Accident · No injuries · Limited investigation · Final report · Apr 25, 1984 · N94213 · Substantial damage > The student plt was landing on rwy 1 with a gusty x-wind condition. On final apch, he crabbed to compensate for the x-wind. He stated that at about 10 ft AGL, the acft encountered a gust of wind & stalled onto the rwy. It then bounced, touched down nosewheel… - [NTSB ATL84LA152](https://openairdocs.org/ntsb/ATL84LA152.md): Beech E55 · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Apr 25, 1984 · N85052 · Substantial damage > After the landing the acft landing gear retracted during a period of maximum braking to avoid an arresting cable. During the examination of the landing gear door damage it was determined that the landing gear was retracted during the landing roll. - [NTSB SEA84LA094](https://openairdocs.org/ntsb/SEA84LA094.md): Piper PA-28-140 · Boulder City, NV · Accident · No injuries · Limited investigation · Final report · Apr 24, 1984 · N95434 · Substantial damage > The acft nosed over after a loss of control following a bounced landing. - [NTSB MIA84LA173](https://openairdocs.org/ntsb/MIA84LA173.md): Piper PA-32R-300 · Venice, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 1984 · N1931H · Destroyed > The acft was ditched in the gulf of Mexico after being followed by U.S. Customs. The plt was picked up, but would not state his departure point or destination, nor did he submit a plt/operational acft accident report as requested by the NTSB. - [NTSB FTW84LA210](https://openairdocs.org/ntsb/FTW84LA210.md): Bellanca 17-31ATC · Rocksprings, TX · Accident · No injuries · Limited investigation · Final report · Apr 24, 1984 · N39815 · Substantial damage > The plt stated that the cabin door opened in-flight. While making a landing at Rocksprings in order to shut the door, the plt failed to use the checklist and landed the acft with the gear up. The acft was equipped with an auto gear extender, but because of… - [NTSB LAX84LA268](https://openairdocs.org/ntsb/LAX84LA268.md): Cessna 182L · San Carlos, CA · Accident · No injuries · Limited investigation · Final report · Apr 23, 1984 · N3162R · Substantial damage > The plt made four unsuccessful landing attempts followed each time by a go-around. The first attempt the acft bounced onlanding. The second attempt the acft bounced several times. The third attempt the plt stated that the wind pushed the acft from over the… - [NTSB LAX84LA266](https://openairdocs.org/ntsb/LAX84LA266.md): Cessna 185 · Nogales, AZ · Accident · No injuries · Limited investigation · Final report · Apr 23, 1984 · N9953N · Substantial damage > The acft landed hard bounced and swerved on and off the rwy. When the acft stopped the left main gear had collapsed. Theplt reported that the wind blew him but the manager of the arpt said the plt flared too high. - [NTSB DEN84LA136](https://openairdocs.org/ntsb/DEN84LA136.md): Balloon Works Firefly 7B · Fargo, ND · Accident · Serious injuries · Limited investigation · Final report · Apr 23, 1984 · N3604U · No damage > During a Balloon landing which the plt described as normal, a pax banged her knee & broke her knee cap. - [NTSB LAX84LA264](https://openairdocs.org/ntsb/LAX84LA264.md): Cessna 152 · Palo Alto, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 22, 1984 · N48201 · Substantial damage > The student plt made a hard bouncing landing which broke the nose gear. The FAA inspector said neither the flying club nor the student's instructor had authorized the flt. The student said he received a slight concussion & could not recall the accident. - [NTSB NYC84LA144](https://openairdocs.org/ntsb/NYC84LA144.md): Cessna 152 · Pittsburgh, PA · Accident · No injuries · Limited investigation · Final report · Apr 21, 1984 · N89880 · Substantial damage > The acft ballooned during the flare for landing & ended up in a nose down condition. The plt said he decided to stall the acft only a few ft off the ground as he estimated 2/3 of the rwy remained & a go-around was not necessary. The acft came to a stop on its… - [NTSB MKC84LA127](https://openairdocs.org/ntsb/MKC84LA127.md): Beech C23 · Bloomfield, IA · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 1984 · N6715W · Substantial damage > According to FAA records, the student plt recieved a wx briefing at 1000 CST. At that time, the latest wx observation at ottumua, IA, (closest wx station to broomfield, IA) showed the wind was from 110 degs at 11 KTS. About 25 mins after the briefing, the… - [NTSB ATL84LA146](https://openairdocs.org/ntsb/ATL84LA146.md): Beech C-24R · Bedford, VA · Accident · No injuries · Limited investigation · Final report · Apr 20, 1984 · N1827Z · Substantial damage > The straight-in approach was high over the trees on the approach end of the rwy. The plt waited until he was 1/2 way down the 3000 ft rwy to reduce eng power to idle. The acft floated before dropping to the rwy & bouncing back into the air. Power was applied… - [NTSB SEA84LA092](https://openairdocs.org/ntsb/SEA84LA092.md): Cessna 180H · Seattle, WA · Accident · No injuries · Limited investigation · Final report · Apr 19, 1984 · N91381 · Substantial damage > The acft nosed over during the landing roll. The plt reported he used excessive braking. - [NTSB LAX84LA263](https://openairdocs.org/ntsb/LAX84LA263.md): Grumman G-164B · Arbuckle, CA · Accident · No injuries · Limited investigation · Final report · Apr 19, 1984 · N6651Q · Substantial damage > The ldg was made on an ag airstrip with a right quartering tailwind. Upon touchdown, the plt 'felt what appeared to be either a dragging left brake and/or the rough surface' of the landing strip. The landing was aborted. On the next landing, the acft nosed… - [NTSB DEN84LA131](https://openairdocs.org/ntsb/DEN84LA131.md): Cessna 140 · Miller, SD · Accident · No injuries · Limited investigation · Final report · Apr 19, 1984 · N89740 · Substantial damage > The acft ground-looped during the plt's first solo landing & the right main landing gear sheared off. The CFI said the student had made between 30 to 40 landings prior to the solo flt. - [NTSB ATL84LA145](https://openairdocs.org/ntsb/ATL84LA145.md): Grumman G164A · Huger, SC · Accident · No injuries · Limited investigation · Final report · Apr 19, 1984 · N7856 · Substantial damage > The aerial application acft was using a gravel surfaced dirt road as a temporary landing strip. During the landing roll the acft drifted to the left & hit a soft spot, a tree, & nosed over in a ditch. - [NTSB MKC84LA126](https://openairdocs.org/ntsb/MKC84LA126.md): Piper PA28-180 · Holdrege, NE · Accident · No injuries · Limited investigation · Final report · Apr 18, 1984 · N1961T · Substantial damage > The student plt was on a solo x-country flt. His 1st en route stop was at Holdrege, NE. He aborted his 1st attempt to land & made a 2nd apch. In the meantime, the plt of another acft landed & experenced turbulent winds. When the student landed (after the 2nd… - [NTSB LAX84LA260](https://openairdocs.org/ntsb/LAX84LA260.md): Hughes 269 · Mesa, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 1984 · N8773F · Substantial damage > The acft landed hard during an autorotation demonstration by a CFI. During landing the rotor blades severed the tail andthe acft went into ground resonance. The CFI said he thought the acft lost transitional lift. He recommended not practicing autorotations… - [NTSB FTW84LA202](https://openairdocs.org/ntsb/FTW84LA202.md): Cessna 500 · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Apr 17, 1984 · N92FA · Substantial damage > During a proficiency flt check, the aircrew was making a N0-flap landing. After completing the landing checklist down to the landing gear, power was reduced causing the landing gear audible warning to sound. The horn silence switch was depressed & the apch… - [NTSB DEN84LA130](https://openairdocs.org/ntsb/DEN84LA130.md): Piper PA-34-200T · Ruidoso, NM · Accident · No injuries · Limited investigation · Final report · Apr 17, 1984 · N6174H · Substantial damage > The plt stated that a combination of high ground speed, turbulence and a downdraft caused the aircraft the rwy. The plt said he thought it better to land as he did than to attempt a go-around because of high terrain to the north. - [NTSB MKC84LA124](https://openairdocs.org/ntsb/MKC84LA124.md): Piper PA-22-135 · Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Apr 16, 1984 · N3300A · Substantial damage > The acft swerved during landing in a x-wind and the right main gear collapsed. The plt said he slipped the acft to lose altitude to land and did not get a 'feel' for the wind direction as a result. - [NTSB SEA84LA085](https://openairdocs.org/ntsb/SEA84LA085.md): Grumman American AA-5B · Driggs, ID · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 1984 · N28291 · Destroyed > During a landing, the plt encountered a porpoise which increased in severity. He added full power, raised the nose & initiated a go-around, during which, the stall warning horn sounded. The plt reported that he left the carburetor heat on & left the flaps in… - [NTSB NYC84LA140](https://openairdocs.org/ntsb/NYC84LA140.md): Cessna 172L · Mayville, NY · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 1984 · N3977Q · Substantial damage > On an apch to land, after a go-around, the acft crossed over wires & touched down on the 1st half of the rwy. The plt applied brakes on the wet grass rwy, but noted a lack of braking action. He applied power to go around, but decided the acft would not clear… - [NTSB FTW84LA197](https://openairdocs.org/ntsb/FTW84LA197.md): Beech 95-B55 · Granbury, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 15, 1984 · N3050 · Substantial damage > During a x-country flt, the plt landed at stephenville, TX, for fuel, but was unable to purchase any. Therefore, he proceeded to Granbury, TX, for fuel before continuing to chattanooga, TN. A witness heard the acft, then observed it porpoising down the last… - [NTSB DEN84LA129](https://openairdocs.org/ntsb/DEN84LA129.md): Cessna 140 · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Apr 15, 1984 · N89984 · Substantial damage > According to the plt, the acft suddenly ground looped during the landing & departed the rwy. An investigation revealed that the left gear leg had collapsed at some time during the accident sequence. The left gear leg pin, which was found sheared, had a dark… - [NTSB CHI84LA154](https://openairdocs.org/ntsb/CHI84LA154.md): Piper PA-24-260 · Kenosha, WI · Accident · No injuries · Limited investigation · Final report · Apr 15, 1984 · N8667P · Substantial damage > The plt stated he mistook the ATIS reported winds of 020 deg at 21 KTS as 210 deg at 20 KTS. After executing the VOR rwy 14 apch, he continued to land on rwy 14. There was standing water on the rwy. While landing with a tail wind, the acft hydroplaned & ran… - [NTSB SEA84LA089](https://openairdocs.org/ntsb/SEA84LA089.md): Fornaire F-1 · Everett, WA · Accident · No injuries · Limited investigation · Final report · Apr 14, 1984 · N7535C · Substantial damage > The acft made a hard landing and bounced. The plt said he thinks he hit a downdraft. The acft went off the rwy into the grass and damaged the nose gear and the fuselage. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=446 ## 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=445 --- 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.