# 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 426 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB LAX85LA295](https://openairdocs.org/ntsb/LAX85LA295.md): Great Lakes 2T-1A-2 · Angwin, CA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1985 · N3800F · Substantial damage > During a VFR cross country flt, wx conditions along the route induced the plt to divert to the Angwin arpt. After an overflt to obtain wind information from the wind sock, the plt said he entered the pattern and completed a normal approach and touchdown.… - [NTSB LAX85LA292](https://openairdocs.org/ntsb/LAX85LA292.md): Cessna 172P · Glendale, AZ · Accident · Minor injuries · Limited investigation · Final report · Jun 22, 1985 · N52789 · Substantial damage > When the plt realized he was low during final apch to a landing, he erroneously decided not to use full flaps instead of adding power, vref was high and the landing was 3/4 of the way down the 2400 ft rwy. Believing he had sufficient room to takeoff again,… - [NTSB CHI85LA245](https://openairdocs.org/ntsb/CHI85LA245.md): Cessna 150L · Griffith, IN · Accident · No injuries · Limited investigation · Final report · Jun 22, 1985 · N10239 · Substantial damage > On the student's third approach, he was observed to flare the acft too high. The acft drifted off to the side of the rwy and nosed down until it collided with the ground. - [NTSB ANC85LA104](https://openairdocs.org/ntsb/ANC85LA104.md): de Havilland DHC-2 · Ungalikthluk Rv, AK · Accident · No injuries · Limited investigation · Final report · Jun 22, 1985 · N10395 · Substantial damage > The plt reported that when he was landing the float plane on a river, an extreme gust of wind cocked the acft causing loss of control. Subsequently, the acft struck a river bank & was damaged. The plt noticed that after the landing, the winds had changed,… - [NTSB MKC85LA136](https://openairdocs.org/ntsb/MKC85LA136.md): Piper PA-28-180 · Belgrade, NE · Accident · No injuries · Limited investigation · Final report · Jun 21, 1985 · N8336W · Substantial damage > Flight instructor giving private pilot a bfr. Bfr was nearly completed when ip gave pilot a simulated forced landing over his own farm strip. Pilot was making an excellent approach until the landing gear hit the barbed wire hidden in the high grass. - [NTSB ATL85LA194](https://openairdocs.org/ntsb/ATL85LA194.md): Cessna 152 · Lexington, NC · Accident · No injuries · Limited investigation · Final report · Jun 21, 1985 · N49214 · Substantial damage > During landing on a private turf airstrip, the nose wheel struck a 'pot' hole. The nose wheel separated from the acft and the acft skidded to a stop resulting in substantial damage. - [NTSB ANC85LA103](https://openairdocs.org/ntsb/ANC85LA103.md): Piper PA-20 · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Jun 21, 1985 · N45PC · Substantial damage > The aircraft swervd on the runway and ground looped, the pilot stated he lost control of the acft due to the wind condition. - [NTSB NYC85LA066](https://openairdocs.org/ntsb/NYC85LA066.md): Cessna 182RG · Norfolk, MA · Accident · Minor injuries · Limited investigation · Final report · Jun 20, 1985 · N2306C · Substantial damage > The acft was unintentionally landed with the gear retracted. A CFI and a pvt plt were on board at the time of the accident. The pvt plt in the left seat was flying the acft and on the third landing failed to extend the gear. The CFI in the right seat was… - [NTSB CHI85LA241](https://openairdocs.org/ntsb/CHI85LA241.md): Cessna 172M · Mosinee, WI · Accident · No injuries · Limited investigation · Final report · Jun 20, 1985 · N12997 · Substantial damage > The plt stated that he failed to flare properly following a 'fast and flat' final approach. The acft landed on its nosewheel resulting in substantial damage to the acft. - [NTSB ANC85LA098](https://openairdocs.org/ntsb/ANC85LA098.md): Cessna 180 · Northway, AK · Accident · No injuries · Limited investigation · Final report · Jun 20, 1985 · N5159E · Substantial damage > During arrival, the plt landed the tail wheel equipped acft on rwy 22 with a x-wind from 290 deg at 8 KTS. After touchdown, the acft entered a ground loop & was damaged. A check of the plt's blood showed an alcohol level of 0.249%. - [NTSB ANC85FA102](https://openairdocs.org/ntsb/ANC85FA102.md): Grumman G-44 · Dillingham, AK · Accident · Minor injuries · Field investigation · Final report · Jun 20, 1985 · N176MS · Substantial damage > The amphibious acft crashed as the plt was landing on glassy water at the inlet of nerka lake. Subsequently, it sank & came to rest inverted in clear water on the bottom of wood river with the gear retracted & the flaps extended. Moderate rain was falling… - [NTSB MIA85IA197](https://openairdocs.org/ntsb/MIA85IA197.md): Piper PA-28R-200 · Ft. Pierce, FL · Incident · No injuries · Incident investigation · Final report · Jun 19, 1985 · N5033T · Minor damage > The landing check list was not properly followed and both pilots neglected to extend the landing gear in preparation for landing - [NTSB ANC85LA097](https://openairdocs.org/ntsb/ANC85LA097.md): Cessna 170B · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Jun 19, 1985 · N4570C · Substantial damage > Plt lost control on landing and ground looped. Wx and field conditions not a factor. - [NTSB MIA85IA195](https://openairdocs.org/ntsb/MIA85IA195.md): Piper PA-38-112 · Miami, FL · Incident · No injuries · Incident investigation · Final report · Jun 18, 1985 · N25701 · Minor damage > The acft wing dropped to the rwy after lndg. The CFI said that the lndg was smooth with the student plt at the controls. When the wing started dropping the CFI said he took the controls but could not keep the wing up. Post acc invest showed that the left main… - [NTSB DEN85LA168](https://openairdocs.org/ntsb/DEN85LA168.md): Hughes 269C · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Jun 18, 1985 · N5203V · Destroyed > On June 18, 1985, a student plt and his instructor were on alocal tng flt. Prior to completing the mission, the instructor had his student execute a 180 degree autorotation. During the maneuver, the main rotor RPM was allowed to decay into the critical range… - [NTSB CHI85LA236](https://openairdocs.org/ntsb/CHI85LA236.md): Cessna 172 · Jenison, MI · Accident · No injuries · Limited investigation · Final report · Jun 18, 1985 · N5267R · Substantial damage > The plt leveled the wings during the landing flare in a x-wind but failed to remove rudder input. The acft drifted to the right of the rwy and touched down in a grass area where it contacted a gully and nosed over. - [NTSB SEA85LA141](https://openairdocs.org/ntsb/SEA85LA141.md): Great Lakes 2T-1A-2 · North Plains, OR · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N44SJ · Substantial damage > An overrun occurred due to excess speed and touching down 1/4 of the way down the 2100 foot glider strip. The aircraft rolled onto two foot high alfalfa where it then nosed over. The pilot previously landed gliders on the gliderport but never an engine… - [NTSB NYC85LA149](https://openairdocs.org/ntsb/NYC85LA149.md): Piper PA-22-108 · Champlain, NY · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N5621Z · Substantial damage > During the landing in a pasture with tall grass, the main wheels contacted the grass, the acft slowed rapidly and nosed over. - [NTSB NYC85LA148](https://openairdocs.org/ntsb/NYC85LA148.md): Taylorcraft BC-12D · Peru, NY · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N44250 · Substantial damage > The acft nosed over while landing on a private sod airstrip. The plt reported touchdown was made on an unmowed portion of the airstrip. The acft slowed quickly and nosed over just prior to coming to a stop. - [NTSB LAX85LA277](https://openairdocs.org/ntsb/LAX85LA277.md): Cessna 172M · Healdsburg, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1985 · N6721H · Substantial damage > The plt stated his apch was normal but when reaching the rwy threshold, the descent seemed to stop. There was a reportedheadwind of 30 KTS. He then applied full flaps. Seconds lat er lift was lost and the plt applied full pwr for a go around. The acft touched… - [NTSB CHI85LA243](https://openairdocs.org/ntsb/CHI85LA243.md): Cessna 172 M · Decatur, IN · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N8954V · Substantial damage > The pilot landing rnwy 36 winds were 210 degrees, 12 knots gusts 18 knots stalled out high onthe wet on the wet sod runway the nose wheel dug in and then broke off the acft then nosed over inverted. - [NTSB ANC85LA094](https://openairdocs.org/ntsb/ANC85LA094.md): Cessna 180 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 16, 1985 · N9282T · Substantial damage > The acft dragged the left wing tip during lndg in a x-wind. The plt stated that he knew the wind was gusty before his takeoff but he felt certain that he could handle it. He stated after the accident that during the landing he had the acft in a crabbed… - [NTSB SEA85LA139](https://openairdocs.org/ntsb/SEA85LA139.md): Maule M-5-180C · Ontario, OR · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N5652W · Substantial damage > The plt reported that when he landed, the wind was gusting to 25 KTS. He stated that when the acft touched down, it encountered a whirlwind that lifted the tail. Subsequently, the acft nosed over & was damaged. According to the 1700 PDT wx observation at… - [NTSB NYC85LA150](https://openairdocs.org/ntsb/NYC85LA150.md): Piper PA-28-140 · Red Hook, NY · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N55490 · Substantial damage > The acft contacted trees following a loss of directional control during a landing roll on rwy 19. - [NTSB MKC85LA132](https://openairdocs.org/ntsb/MKC85LA132.md): Beech C23 · Pratt, KS · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N6723C · Substantial damage > Student pilot was on his second cross-country flight to this airport. He stated that after touchdown, he reached to raise the flaps and the airplane started to drift. He overcorrected and went off left side of the runway and nosed over when he went through a… - [NTSB DEN85LA156](https://openairdocs.org/ntsb/DEN85LA156.md): Cessna 170B · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N3475D · Substantial damage > On June 15, 1985, a Cessna 170B ground looped during a touch and go landing at contennial arpt, Englewood, CO. The plt said a gust of wing caught him by surprise. The acft departed the runway and flipped over on its back. The plt was not injured. - [NTSB ATL85LA186](https://openairdocs.org/ntsb/ATL85LA186.md): Cessna 152 · Abbeville, SC · Accident · No injuries · Limited investigation · Final report · Jun 15, 1985 · N47071 · Substantial damage > While practicing touch & go landings the student plt lost directional control of the acft & ran off the side of the rwy. The acft flipped to an inverted attitude when the nose wheel dug into the soft soil. The student was on his second solo flight. - [NTSB CHI85LA240](https://openairdocs.org/ntsb/CHI85LA240.md): Haney Polliwagon · Lambertville, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 14, 1985 · N8FT · Substantial damage > The plt was unable to flare the acft with full up elevator and the nose gear contacted the rwy during landing. The acft bounced and contacted the rwy again resulting in a gear collapse. The plt stated that the elevator did not provide the same amount of up… - [NTSB ATL85LA190](https://openairdocs.org/ntsb/ATL85LA190.md): Beech C-23 · Wilmington, NC · Accident · No injuries · Limited investigation · Final report · Jun 14, 1985 · N6020U · Substantial damage > The student plt was making a landing at the second arpt of a x-country flt when a controller in the tower observed the acft bounce and spotted the nose gear lying on the rwy. An ELT signal was also received at that time. The student plt made a go-around and… - [NTSB ANC85LA095](https://openairdocs.org/ntsb/ANC85LA095.md): Cessna 185 · Kantishna, AK · Accident · No injuries · Limited investigation · Final report · Jun 14, 1985 · N75LE · Substantial damage > The plt was on a flt from fairbanks to Kantishna, AK; however, the rwy at Kantishna was muddy, so he elected to return to fairbanks. While returning, he elected to land at an abandoned mine strip for a comfort stop. During the landing, a hydraulic line to the… - [NTSB SEA85LA136](https://openairdocs.org/ntsb/SEA85LA136.md): Cessna R-172-K · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Jun 13, 1985 · N736TX · Substantial damage > During landing rollout on runway 19R directional control was lost with the aircraft verring to the right of the runway. Correction was made to the left, but the aircraft veered off the runway to the left. The wind was from 160 at 9. The density altitude was… - [NTSB FTW85FA254](https://openairdocs.org/ntsb/FTW85FA254.md): Robinson R-22 · Dallas, TX · Accident · No injuries · Field investigation · Final report · Jun 13, 1985 · N9075Y · Destroyed > The student plt allowed the main rotor blades to drop to a slow speed well below the green arc. The student plt and the instructor plt attempted to do a power recovery from the aborted autorotation maneuver but the eng could not accelerate the main rotor… - [NTSB DEN85LA164](https://openairdocs.org/ntsb/DEN85LA164.md): Cessna T210J · Moab, UT · Accident · Serious injuries · Limited investigation · Final report · Jun 13, 1985 · N2282R · Destroyed > The plt & a passenger made a low level pass over the Colorado river to drop a package to friends, who were rafting on the river. The river was in a canyon with walls aprx 500 to 700 ft high. The plt said the eng lost power when the acft was in the canyon, so… - [NTSB DEN85LA162](https://openairdocs.org/ntsb/DEN85LA162.md): Piper PA-28-180N · Delta, UT · Accident · No injuries · Limited investigation · Final report · Jun 13, 1985 · N4760L · Substantial damage > The acft was flown by a student plt and his instructor on a local tng flt. During landing the sutdent plt did not flair the acft in time, hit hard and bounced. The instructor took control, made a soft landing followed by the main landing gear collapsing. The… - [NTSB NYC85LA146](https://openairdocs.org/ntsb/NYC85LA146.md): Piper PA-18-150 · Old Town, ME · Accident · No injuries · Limited investigation · Final report · Jun 12, 1985 · N82126 · Substantial damage > During a pwr off landing, the instructor noticed that the airspeed was low. The instructor applied full pwr; however, the acft stalled and the plt was unable to recover the acft prior to coming in contact with the water. - [NTSB LAX85LA271](https://openairdocs.org/ntsb/LAX85LA271.md): Cessna 172RG · Upland, CA · Accident · No injuries · Limited investigation · Final report · Jun 12, 1985 · N6225R · Substantial damage > The plt stated that on the flt prior to the accident he felt a slight pull to the right as he applied brakes. On the next flt he touched down normally, lowered the nose and lightly applied brakes. The pull to the right was more severe this time. He applied… - [NTSB MKC85LA128](https://openairdocs.org/ntsb/MKC85LA128.md): Grumman G-164A · Swifton, AR · Accident · No injuries · Limited investigation · Final report · Jun 11, 1985 · N8836H · Substantial damage > The ag pilot was landing the airplane too fast and when he couldn't stop on the wet grass, he attempted a go-around. By the time the engine accelerated, there was not enough airspeed or runway and the airplane went through a fence and stopped against a… - [NTSB LAX85FA269](https://openairdocs.org/ntsb/LAX85FA269.md): Aero Commander 1121 · Van Nuys, CA · Accident · Minor injuries · Field investigation · Final report · Jun 11, 1985 · N69GT · Substantial damage > The plt, executing and ILS apch, observed a primary hydraulic pressure drop and declared his intent to land without the use of flaps, speed brakes, reversers or nose wheel steering. The acft ran off the end of the rwy during landing, traveled aprx 1300 ft and… - [NTSB SEA85LA133](https://openairdocs.org/ntsb/SEA85LA133.md): Piper PA-38-112 · Las Vegas, NV · Accident · Serious injuries · Limited investigation · Final report · Jun 10, 1985 · N6456A · Destroyed > During a local instructional flight a bounced landing was made. The acft bounced nose high to about 20 ft AGL. The acft then veered left of the rwy after full power had been added and flaps reduced from 40 degrees to 25 degrees for an attempted go-around at… - [NTSB SEA85LA129](https://openairdocs.org/ntsb/SEA85LA129.md): Robinson R22 · Port Orchard, WA · Accident · No injuries · Limited investigation · Final report · Jun 9, 1985 · N8490D · Substantial damage > The instructor plt (CFI) with only 358 hrs total flt time was demonstrating an autorotation with a power recovery. During the recovery, the CFI failed to fully regain RPM & the helicopter settled to the surface. With a low rotor RPM, there was a loss of tail… - [NTSB ATL85LA195](https://openairdocs.org/ntsb/ATL85LA195.md): Hughes 269C · Wingate, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1985 · N9588F · Substantial damage > The plt & passenger consumed several beers shortly before boarding the helicopter for a flt in the local area. The flt lasted aprx 15 min. The passenger reported that during a landing, the skid on the right side contacted the ground causing the helicopter to… - [NTSB ANC85LA091](https://openairdocs.org/ntsb/ANC85LA091.md): Cessna 180 · Kenai Lake, AK · Accident · No injuries · Limited investigation · Final report · Jun 9, 1985 · N180SL · Substantial damage > The plt stated that the float struck the water during landing resulting in the acft nosing over and sinking in 25 ft of water. - [NTSB ANC85FA090](https://openairdocs.org/ntsb/ANC85FA090.md): Aeronca 7AC · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jun 9, 1985 · N83995 · Substantial damage > The acft collided with a parked helicopter during landing. The acft had left the rwy at midfield & collided with the parked acft. The plt stated that he lost directional control after lndg. A rwy light on the left side of the rwy aprx 900 ft from the approach… - [NTSB MKC85LA127](https://openairdocs.org/ntsb/MKC85LA127.md): Cessna 172 · Curtis, NE · Accident · No injuries · Limited investigation · Final report · Jun 8, 1985 · N2267E · Substantial damage > The plt stated he misread the windsock and made a downwind landing resulted. The acft overran the end of the grass rwy and nosed over when the nose gear contacted a plowed fld. The arpt operator reported the winds were from 180 degs at 18 KTS when the landing… - [NTSB MIA85LA185](https://openairdocs.org/ntsb/MIA85LA185.md): Hughes 269C · St.Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Jun 8, 1985 · N8657F · Substantial damage > The helicopter was landing after a training flight with an instructor pilot and a non-rated-non-certificated student pilot on board. As the helicopter touched down a severe resonant vibration started. The instructor stated that he attempted to lift off the… - [NTSB DEN85LA158](https://openairdocs.org/ntsb/DEN85LA158.md): Mooney M20K · Lafayette, CO · Accident · No injuries · Limited investigation · Final report · Jun 8, 1985 · N5764N · Substantial damage > On June 8, 1985, a Mooney M20K, impacted the ground off the rwy while landing at alexander dawson arpt, Lafayette, o. the plt said he was attempting to make a short field apchto the plt, the apch was high and fast. The acft landed, porpoised, and departed the… - [NTSB DEN85LA157](https://openairdocs.org/ntsb/DEN85LA157.md): Luscombe 8E · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Jun 8, 1985 · N2669K · Substantial damage > The plt reported that during a normal landing, the right main gear folded back, followed by collapse of the left main gear. An exam revealed evidence of fatigue failure of a clevis bolt in the threaded area. - [NTSB CHI85LA230](https://openairdocs.org/ntsb/CHI85LA230.md): Piper PA-28-180 · Blair, WI · Accident · No injuries · Limited investigation · Final report · Jun 8, 1985 · N55956 · Substantial damage > The plt attempted to land the acft in a farm field but was unable to stop before reaching the end of the field. The acft ran through a fence & a ditch before coming to rest. The plt stated that he overshot the rwy, landed long, & was unable to stop the acft… - [NTSB MKC85LA122](https://openairdocs.org/ntsb/MKC85LA122.md): Piper PA-28-181 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Jun 7, 1985 · N3502M · Substantial damage > During a full stop landing the plt applied brakes to arrest the landing roll and upon application of the brakes, the acft veered slowly to the left without slowing down. The check plt applied his brakes to assist the plt, but without any effect. The acft… - [NTSB FTW85FA247](https://openairdocs.org/ntsb/FTW85FA247.md): Piper PA-28RT-201T · Pineville, LA · Accident · 2 fatal · Field investigation · Final report · Jun 7, 1985 · N4507V · Destroyed > The aircraft landed long and fast on the relatively short, sloping runway. After bouncing four times, the pilot rapidly added throttle on the turbocharger-equipped aircraft and attempted to climb. Witnesses observed smoke from the exhaust, and described high… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=427 ## 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=426 --- 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.