# 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 421 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB DEN86FTE01](https://openairdocs.org/ntsb/DEN86FTE01.md): Skurich FOCKE-WULF 190 · Falcon, CO · Accident · Minor injuries · Final report · Oct 5, 1985 · N190FK · Substantial damage > The acft groundlooped to the rt during an attempted go-around after landing. The plt was landing at a arpt with watch he was unfamilar. He thought he saw wires at the approach end of the rwy so he landed long and then attempted a go-around. The acft… - [NTSB MIA86LA003](https://openairdocs.org/ntsb/MIA86LA003.md): Cessna 414 · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Oct 4, 1985 · N24ET · Substantial damage > The plt stated that his right main gear would not extend, so he circled the arpt for about 1/2 hour to burn off excess fuel, retracted the remaining gear & intentionally landed gear up on rwy 32. Examination of the right main landing it to extend beyond it's… - [NTSB CHI86LA004](https://openairdocs.org/ntsb/CHI86LA004.md): Piper PA-30 · Troy, MI · Accident · Minor injuries · Limited investigation · Final report · Oct 4, 1985 · N505PC · Destroyed > The plt landed on rwy 27 with winds from 185 degs at 20 KTS gusting to 30 KTS. The acft ballooned on short final. The plt added pwr but the right wing dropped and hit the rwy. The acft cartwheeled. - [NTSB BFO86LA001](https://openairdocs.org/ntsb/BFO86LA001.md): Cessna 172N · Annapolis, MD · Accident · No injuries · Limited investigation · Final report · Oct 4, 1985 · N4691G · Substantial damage > The plt crossed mid-field, and entered a left down wind for rwy 30. He then checked wind direction, completed a base leg, and entered final apch. After reducing his airspeed, the acft 'floated' prior to touching down aprx 600 ft short of mid-fld. The plt… - [NTSB FTW86LA003](https://openairdocs.org/ntsb/FTW86LA003.md): Cessna 182N · Odessa, TX · Accident · No injuries · Limited investigation · Final report · Oct 3, 1985 · N92755 · Substantial damage > During touch-&-go landing practice on her second solo training flight, the student plt made a hard landing. The nose gear strut was driven upward through the firewall and the prop was damaged. The acft bounced/porpoised three times & came to rest off the left… - [NTSB CHI86LA003](https://openairdocs.org/ntsb/CHI86LA003.md): Cessna 172F · Canton, OH · Accident · No injuries · Limited investigation · Final report · Oct 3, 1985 · N8347U · Substantial damage > The acft overran the rwy and collided with wires and a pole during landing. The student plt stated that he was too fast and landed long during the calm wind landing. He also stated he should have used more flaps. - [NTSB CHI86LA002](https://openairdocs.org/ntsb/CHI86LA002.md): Cessna 172 · Crivitz, WI · Accident · No injuries · Limited investigation · Final report · Oct 2, 1985 · N52142 · Substantial damage > The plt lost directional control of the acft during the landing roll in x-wind conditions. As the acft veered to the left side of the rwy it struck a rwy light. The arpt owner stated the acft touched down in a crabbed position and the local winds were from… - [NTSB LAX85LA404](https://openairdocs.org/ntsb/LAX85LA404.md): Mooney M20K · Huntington Bch, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 30, 1985 · N231GW · Substantial damage > The plt acknowledged that on short final approach to the 2330 ft-long rwy, the acft's speed was 'a little hot', & during ldg flare the acft 'floated in ground effect'. After the acft bounced 3 times the plt decided to go around & he applied full pwr. The plt… - [NTSB NYC85LA255](https://openairdocs.org/ntsb/NYC85LA255.md): Cessna 152 · Dansville, NY · Accident · No injuries · Limited investigation · Final report · Sep 29, 1985 · N6135P · Destroyed > Cessna 152,N6135P,on flight plan batavia, new york, landed hard at Dansville county airport and collapsed the nose gear. The aircraft was destroyed by fire, the pilot and one passenger were unjured. - [NTSB NYC85LA252](https://openairdocs.org/ntsb/NYC85LA252.md): Beech C35 · Wexford, PA · Accident · No injuries · Limited investigation · Final report · Sep 29, 1985 · N1886D · Destroyed > Aircraft was landing on private grass strip and during landing roll struck a deer with the right wing tip. The grass was wet and the pilot lost directional control. The aircraft impacted trees that bordered the airstrip and was destroyed. - [NTSB CHI85LA388](https://openairdocs.org/ntsb/CHI85LA388.md): Cessna 152 · Delta, OH · Accident · No injuries · Limited investigation · Final report · Sep 29, 1985 · N24278 · Substantial damage > The plt was performing a soft fld landing. When the nose wheel settled onto the airstrip it dug into the soft terrain, collapsed and the acft nosed over. - [NTSB ANC85LA185](https://openairdocs.org/ntsb/ANC85LA185.md): Cessna 180A · Glennallen, AK · Accident · No injuries · Limited investigation · Final report · Sep 29, 1985 · N5353D · Substantial damage > The pilot stated the aircraft left wing was raised by a gust of wind. The aircraft accelerated rapidly in a si deways attitude to the right. The wind gust encountered and the fact the landing roll was almost completed CA used a situation that was beyond the… - [NTSB CHI85LA387](https://openairdocs.org/ntsb/CHI85LA387.md): Cessna 150 · Hastings, MI · Accident · No injuries · Limited investigation · Final report · Sep 28, 1985 · N3025S · Substantial damage > The pilot was competing in a spot landing contest. The aircraft was reportedly observed about 4 to 5 feet AGL and slow just before it contacted the grass runway. The nosegear failed, dug into the ground, resulting in a nose over. - [NTSB FTW85FA358](https://openairdocs.org/ntsb/FTW85FA358.md): Cessna 177RG · Ennis, TX · Accident · No injuries · Field investigation · Final report · Sep 27, 1985 · N2637V · Substantial damage > The plt could not lower the landing gear through use of the normal gear extension system. He was able to partially lower it through the use of the emergency extension system. Next he made an emergency landing at the departure airport during the hours of… - [NTSB NYC85LA257](https://openairdocs.org/ntsb/NYC85LA257.md): Cessna 172P · Canada Falls Lk, ME · Accident · No injuries · Limited investigation · Final report · Sep 25, 1985 · N54103 · Substantial damage > Cessna 172, a floatplane encountered a wind gust while landing on water. In an attempt to compensate for the wind. One of the wings contacted the water surface. - [NTSB MIA85LA263](https://openairdocs.org/ntsb/MIA85LA263.md): Cessna 150M · Pahokee, FL · Accident · Minor injuries · Limited investigation · Final report · Sep 24, 1985 · N63200 · Substantial damage > The plt stated that he was flaring for landing when a gust of wind raised the acft causing it to crash into the rwy. - [NTSB LAX85LA401](https://openairdocs.org/ntsb/LAX85LA401.md): Beech P60 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Sep 24, 1985 · N973T · Substantial damage > During the landing roll, the acft veered off the right side of the rnwy and made contact with a taxiway marker which was then thrown against the acft, puncturing the pressure bulkhead compartment. Examination of the left brake assembly revealed evidence of… - [NTSB FTW85LA357](https://openairdocs.org/ntsb/FTW85LA357.md): Piper PA-32RT-300 · Ruston, LA · Accident · No injuries · Limited investigation · Final report · Sep 24, 1985 · N31919 · Substantial damage > This 110 hour private pilot lost directional control of the aircraft while landing in a 90 degree cross wind and veered into a pickup truck spraying herbicide on the runway edge lights. Two city employees saw the aircraft coming towards them and escaped… - [NTSB NYC85LA247](https://openairdocs.org/ntsb/NYC85LA247.md): Cessna P210N · Marlboro, NJ · Accident · No injuries · Limited investigation · Final report · Sep 23, 1985 · N210AG · Substantial damage > The plt made a VOR apch to the arpt and circled to land while simultaneously determining wind condition. It was raining at the time. A landing was made on rwy 27. On touchdown, the plt stated, his brakes were ineffective. He described the rwy as wet. Since it… - [NTSB CHI85FA385](https://openairdocs.org/ntsb/CHI85FA385.md): Dassault-Breguet 10 · West Chicago, IL · Accident · No injuries · Field investigation · Final report · Sep 23, 1985 · N700DK · Substantial damage > The falcon 10 touched down long and fst on a wet runway, experienced hydroplanning and went off the end of the runway,struck a drainage ditch and collapsed the landing gear. The nose gear came back and bent the throttle quadrant bracket, pulled the fuel… - [NTSB ANC85LA182](https://openairdocs.org/ntsb/ANC85LA182.md): Piper PA-20 · Feather River, AK · Accident · No injuries · Limited investigation · Final report · Sep 23, 1985 · N7440K · Substantial damage > While landing in gusty surface wind conditions the pilot lost control of he airplane and turned over. - [NTSB SEA85LA222](https://openairdocs.org/ntsb/SEA85LA222.md): Cessna 180 · Klamath Falls, OR · Accident · No injuries · Limited investigation · Final report · Sep 22, 1985 · N8062V · Substantial damage > The plt lost directional control of the acft following a bounced landing. The acft veered off the right side of the rwy where it contacted an area of tall grass and nosed over. - [NTSB SEA85LA219](https://openairdocs.org/ntsb/SEA85LA219.md): Aeronca 7AC · Ridgefield, WA · Accident · No injuries · Limited investigation · Final report · Sep 22, 1985 · N84844 · Substantial damage > The acft stalled at an alt of aprx 15 AGL and contacted the terrain hard during a landing at a pvt airstrip. The acft does not have a stall warning system. The plt stated that he should have maintained a proper airspeed. - [NTSB ATL85FKG12](https://openairdocs.org/ntsb/ATL85FKG12.md): Cessna 172P · Birmingham, AL · Accident · No injuries · Final report · Sep 22, 1985 · N5227K · Substantial damage > During arrival, the plt noted that the wind was from about 150 degs. Due to the terrain & obstructions near the northeast end of the rwy, he elected to land on rwy 4. During the landing, the acft floated before touching about 1/3 to 1/2 of the way down the… - [NTSB MKC85LA222](https://openairdocs.org/ntsb/MKC85LA222.md): Cessna 172I · Cameron, MO · Accident · Minor injuries · Limited investigation · Final report · Sep 21, 1985 · N46175 · Substantial damage > The pilot stated that he was aware of the IFR conditions enroute but was not expecting them so soon. When he was within four minutes of his landing airport, the weather turned very bad but he decided to continue. Visibility was so bad that he had to turn to… - [NTSB FTW85LA355](https://openairdocs.org/ntsb/FTW85LA355.md): Cessna 172RG · Mineral Wells, TX · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N6290R · Substantial damage > The main landing gear colapsed during a touch and go landing. The landing gear warning circuit breaker had popped, and the instructor pilot received no warning that the gear was not fully extended. - [NTSB CHI85LA384](https://openairdocs.org/ntsb/CHI85LA384.md): Cessna 150H · Racine, WI · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N50433 · Substantial damage > The pilot reported a gust of wind resulted in a nose high left turn just prior to touchdown. Power was added & the left wing contacted the runway. The aircraft went off the left side of the runway and hit a ditch. - [NTSB ATL85LA281](https://openairdocs.org/ntsb/ATL85LA281.md): Cessna A188B · Baxley, GA · Accident · No injuries · Limited investigation · Final report · Sep 21, 1985 · N84284 · Substantial damage > Plt attempted ldg in cultivated field after sowing load of rye grass seed. Grnd was soft and wheel dug in and acft nosed over. Plt was not injured. - [NTSB SEA85LA218](https://openairdocs.org/ntsb/SEA85LA218.md): Waco UIC · Boise, ID · Accident · No injuries · Limited investigation · Final report · Sep 20, 1985 · N13572 · Substantial damage > The plt reported that when he landed, the acft began drifting to the left. Since there was a high speed turn-off ahead, he did not make an immediate correction for the drift. When a correction was applied, the acft did not respond & it continued into a ground… - [NTSB CHI85LA382](https://openairdocs.org/ntsb/CHI85LA382.md): Navion 61G · Greenwood, IN · Accident · No injuries · Limited investigation · Final report · Sep 20, 1985 · N2359T · Substantial damage > The plt landed long on the 4000 ft asphalt rwy. He stated he was applying heavy braking when his foot slipped causing him to strike and advance the throttle. The acft rolled off the end of the rwy into a corn field. - [NTSB DEN85LA244](https://openairdocs.org/ntsb/DEN85LA244.md): Cessna 425 · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Sep 19, 1985 · N1222B · Substantial damage > The plt said he made a normal ldg. During ldg roll the left brake would not respond to pedal application. The plt errored by incorrectly feathering both props. The a/c went off the eng of r/w and struck a fence. Examination of the brake system revealed a… - [NTSB BFO85LA078](https://openairdocs.org/ntsb/BFO85LA078.md): Schleicher ASW-20 · New Castle, VA · Accident · Serious injuries · Limited investigation · Final report · Sep 19, 1985 · N39DG · Substantial damage > According to the plt, after experiencing a loss of lift, he flew over the open field, observed electrical wires, and continued to fly parallel with the wires. As he turned westward to land in the field, the plt lost sight of the power lines in the sunset.… - [NTSB ANC85LA181](https://openairdocs.org/ntsb/ANC85LA181.md): Cessna 172 · Shirleyville, AK · Accident · No injuries · Limited investigation · Final report · Sep 19, 1985 · N6951A · Substantial damage > The acft nosed over following a loss on control while landing on a gravel road. The plt reported that after a 100 ft landing roll, the right wing caught brush along the side of the road. The acft veered right and the right main gear contacted a log resulting… - [NTSB ATL85LKG13](https://openairdocs.org/ntsb/ATL85LKG13.md): Cessna 182N · Panala, AL · Accident · No injuries · Final report · Sep 18, 1985 · N92746 · Substantial damage > The acft collided with a tree during lndg which pulled it to the left off the road chosen for landing. The plt applied pwr to clear a ditch and the acft came to rest in a row of small trees. The plt had said the eng had started missing after takeoff from the… - [NTSB MIA85LA258](https://openairdocs.org/ntsb/MIA85LA258.md): Cessna 177RG · Ormond Beach, FL · Accident · No injuries · Limited investigation · Final report · Sep 17, 1985 · N52637 · Substantial damage > The plt stated that he forgot to extend the landing gear prior to touchdown while on a test flight after maintainence work was performed on the acft. - [NTSB DEN85LA243](https://openairdocs.org/ntsb/DEN85LA243.md): Piper PA-28-181 · Holyoke, CO · Accident · No injuries · Limited investigation · Final report · Sep 17, 1985 · N3562G · Substantial damage > The plt landed her a/c in a right xwind and was unable to prevent the a/c from veering off the r/w. the a/c struck a wind t and came to rest in a corn field. The plt was not injured. - [NTSB CHI85LA381](https://openairdocs.org/ntsb/CHI85LA381.md): Cessna 182Q · West Lafayette, IN · Accident · No injuries · Limited investigation · Final report · Sep 17, 1985 · N97855 · Substantial damage > The plt reported the acft bounced twice on touchdown. The final touchdown was hard and the nose wheel separated. The nose gear strut dug into sod resulting in substantial damage to the acft. - [NTSB ANC85LAA04](https://openairdocs.org/ntsb/ANC85LAA04.md): Piper PA-22-160 · Fairbanks, AK · Accident · No injuries · Final report · Sep 16, 1985 · N8525D · Substantial damage > The left wing tip contacted the rwy and the left horizontal stabilizer contacted a sign following a loss on control during lanidng. The plt reported being aware of the right quartering x-wind but the acft bounced during the initial touchdown. The left wing… - [NTSB NYC85LA236](https://openairdocs.org/ntsb/NYC85LA236.md): Beech BE-55 · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N6429S · Substantial damage > The plt stated that on touchdown the left main gear collapsed followed by the right main gear and nose gear. The acft slid aprx 600 to 700 ft before stopping. According to the plt he confirmed the gear was down and locked while on base. A gear cycle test… - [NTSB NYC85IA238](https://openairdocs.org/ntsb/NYC85IA238.md): Boeing 747-130 · Jamaica, NY · Incident · No injuries · Incident investigation · Final report · Sep 15, 1985 · N780T · Minor damage > The acft was making a visual app to rwy 31R at Jamaica NY waen the bottom of the aft 60 ft of the fuselage made ground contact. The left outflow valve was scraped and the rear drain mast was separated. Part of the apr access door and several stringers &… - [NTSB MKC85LA216](https://openairdocs.org/ntsb/MKC85LA216.md): Cessna 172M · Emporia, KS · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N61624 · Substantial damage > Two plts were on board. The lt seat plt was making the landing when a gust of wind caused the acft to become misaligned with the rwy. The rt seat plt took control of the acft and attempted a go-around. The rt seat plt said he aimed for a clear spot btw trees… - [NTSB MIA85LA255](https://openairdocs.org/ntsb/MIA85LA255.md): Cessna 172P · Wesley Chapel, FL · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N89989 · Substantial damage > The rated private plt was received a check out in the acft by a CFI. The plt was having difficulty on the rwy as the winds were reported as 070 degs at 13 knts. The rwy being used was rwy 32. A 20 deg right x-wind tailwind condition existed. On the 4th touch… - [NTSB BFO85LA076](https://openairdocs.org/ntsb/BFO85LA076.md): Cessna 401 · Cheswold, DE · Accident · No injuries · Limited investigation · Final report · Sep 15, 1985 · N3298Q · Substantial damage > After landing on runway 27, the pilot slowed the aircraft to approximately 30 mph. The aircraft had rolled out about 1000 feet when the gear horn sounded and all three landing gear collapsed. The pilot reached for the gear switch, which was in the up… - [NTSB SEA85LA214](https://openairdocs.org/ntsb/SEA85LA214.md): Bell 206BII · Atlanta, ID · Accident · Minor injuries · Limited investigation · Final report · Sep 14, 1985 · N58012 · Destroyed > A loss of pwr occurred shortly before touchdown. The left skid struck a rock during touchdown causing the acft to roll onto its right side. Twenty-five flt hrs prior to this flt an identical situation occurred and a loose air line to the fuel control was… - [NTSB LAX85LA392](https://openairdocs.org/ntsb/LAX85LA392.md): North American P-51D · Reno, NV · Accident · No injuries · Limited investigation · Final report · Sep 14, 1985 · N10607 · Substantial damage > The plt had completed a heat race as a participant in the Reno national championship air races and was landing in a gusty x-wind when the acft's left wing was lifted by the wind and the acft cartwheeled, resulting in substantial damage to the wings and to the… - [NTSB FTW85LRG02](https://openairdocs.org/ntsb/FTW85LRG02.md): Homebuilt Tiger Bird · Kerrville, TX · Accident · No injuries · Final report · Sep 14, 1985 · N5MF · Substantial damage > The acft nosed over on landing following a loss of directional control. The plt reported touchdown was made on the first 100 ft of the rwy and as the acft slowed to aprx 10 mph directional control was lost. The acft traveled off the left side of the airstrip… - [NTSB CHI85LA380](https://openairdocs.org/ntsb/CHI85LA380.md): Maule M-5-235C · Bloomington, IN · Accident · No injuries · Limited investigation · Final report · Sep 14, 1985 · N56349 · Substantial damage > The piloted landed with an 80' left crosswind at 8 knots. During landing roll the wind picked up the left wing. The acft weathervaned into the wind & the right gear collapsed. The right wing was also damaged during the swerve. - [NTSB BFO85LA075](https://openairdocs.org/ntsb/BFO85LA075.md): Piper PA-32-300 · Williamsburg, VA · Accident · Minor injuries · Limited investigation · Final report · Sep 14, 1985 · N2821Y · Substantial damage > The plt contacted the field on UNICOM frequency of 122.8 and was informed that the active rwy was 31, with wind from 040 degrees at 13 knots. The final approach was made with crab and power, but just prior to touchdown, the right wing lifted and the acft… - [NTSB CHI85LA376](https://openairdocs.org/ntsb/CHI85LA376.md): Cessna 170 · Eden Prairie, MN · Accident · Minor injuries · Limited investigation · Final report · Sep 13, 1985 · N1290D · Substantial damage > The student landed on rwy 9R with tower winds reported from 150 degrees at 15 knots. During the landing roll in the tailwheel equipped acft, control was lost and the acft tipped up on its left wing and nose. - [NTSB MKC85LA214](https://openairdocs.org/ntsb/MKC85LA214.md): Cessna 152 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Sep 12, 1985 · N5269Q · Substantial damage > The student plt lost directional control of the acft while practicing touch & go landings. Winds in the local area were reported by fss as being from 110 degs at 12 KTS, gusting to 17 KTS. The plt lost control of the acft during a landing roll, ran off the… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=422 ## 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=421 --- 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.