# 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 442 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB DEN84LA190](https://openairdocs.org/ntsb/DEN84LA190.md): Cessna 180 · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Jun 21, 1984 · N153M · Substantial damage > During the landing roll, the right gear collapsed & the acft veered off the rwy. An exam revealed that the right wheel ass'y had separated from the gear leg. There was evidence that the 2 lower bolts had been stripped prior to the wheel failure, either by… - [NTSB CHI84LA253](https://openairdocs.org/ntsb/CHI84LA253.md): Beech B-19 · Oshkosh, WI · Accident · No injuries · Limited investigation · Final report · Jun 21, 1984 · N5204M · Substantial damage > The student pilot stated that he rounded out a little high, while landing on rwy 09, stalled & contacted the runway in a crabbed position. A hard landing resulted which substantially damaged the aircraft. - [NTSB SEA84LA138](https://openairdocs.org/ntsb/SEA84LA138.md): Cessna 170A · La Grande, OR · Accident · No injuries · Limited investigation · Final report · Jun 20, 1984 · N9231A · Substantial damage > During the landing roll, the acft veered to the right. The plt applied left rudder, but this did not help. Subsequently, the acft went off the rwy & the left main gear sank into soft ground & collapsed. An exam of the acft was made, but no reason was found… - [NTSB FTW84LA278](https://openairdocs.org/ntsb/FTW84LA278.md): Bellanca 8GCBC · Spiro, OK · Accident · No injuries · Limited investigation · Final report · Jun 20, 1984 · N5060K · Substantial damage > The plt stated that while landing in an alfalfa field, he made the approach at a higher than normal speed. Subsequently, the acft overran the alfalfa field & went into a plowed field where it nosed over. - [NTSB DEN84LA189](https://openairdocs.org/ntsb/DEN84LA189.md): Cessna 182K · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Jun 20, 1984 · N3039Q · Substantial damage > During landing the acft ballooned, stalled and contacted the rwy hard enough to break off the nose gear. The plt added pwr and aborted the landing. Acft was then landed in a sandy area along the left side of the rwy where it nosed over. - [NTSB LAX84LA359](https://openairdocs.org/ntsb/LAX84LA359.md): Cessna 152 · Eureka, CA · Accident · No injuries · Limited investigation · Final report · Jun 19, 1984 · N67329 · Substantial damage > The student plt was on his 5th landing when he encountered unfavorable wind & bounced hard. He stated that the wind got under the upwind wing & subsequently the acft pivoted nose down to the ground & was damaged. The student reported that the wind was from… - [NTSB CHI84LA251](https://openairdocs.org/ntsb/CHI84LA251.md): Halfpap Varieze · Quincy, IL · Accident · No injuries · Limited investigation · Final report · Jun 19, 1984 · N8477T · Substantial damage > The acft experienced a collapse of the main landing gear after a hard landing. The plt reported initially that he made ahard landing and stated that when he applied the brakes the landing gear collapsed. The plt was given two NTSB 6120.1 forms by the FAA.… - [NTSB CHI84LA248](https://openairdocs.org/ntsb/CHI84LA248.md): Cessna 172RG · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Jun 19, 1984 · N4608V · Substantial damage > The acft was observed by witnesses to slow and appear to stall and fall to the rwy as a burst of power was heard. The acft went off the rwy and collided with a parked C-310. The plt said a gust of wind ballooned the acft and he attempted to go-around but the… - [NTSB NYC84LA213](https://openairdocs.org/ntsb/NYC84LA213.md): Piper PA-34-200 · Monongahela, PA · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N55697 · Substantial damage > The certified flt instructor (CFI) stated that he was giving multiengine instruction. All basic single and multi- engine maneuvers had been completed. The CFI reduced the pwr on one engine to simulate a single engine landing. The CFI stated that a normal… - [NTSB MKC84LA178](https://openairdocs.org/ntsb/MKC84LA178.md): Snow AT400 · Portland, AR · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N501PR · 2 aircraft · Substantial damage > Both acft were about to touch down. N501PR was above N501JS. The pilot of N501PR stated that just before touchdown the collision occurred and resulted in severing of the tail section of N501PR. The pilot of 501JS stated N501PR flared out to land directly in… - [NTSB LAX84LA356](https://openairdocs.org/ntsb/LAX84LA356.md): Piper PA-28R-180 · Fair Oaks, CA · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N4634J · Substantial damage > Acft touched down beyond the threshold at a normal airspeed. Plt raised the flaps and applied brakes but the left brake bottomed out with no resistance. An intentional ground loop was performed to stop the acft. Inspection revealed that allthe brake pads were… - [NTSB FTW84LA275](https://openairdocs.org/ntsb/FTW84LA275.md): Cessna A185F · New Iberia, LA · Accident · No injuries · Limited investigation · Final report · Jun 18, 1984 · N4942E · Substantial damage > While decelerating after landing one of the floats contacted a submerged object. Directional control was lost, acft veered to left and collided with a tree on the bank. - [NTSB CHI84LA245](https://openairdocs.org/ntsb/CHI84LA245.md): Bell 47-G2 · Nimrod, MN · Accident · Serious injuries · Limited investigation · Final report · Jun 18, 1984 · N18JM · Destroyed > While landing in an area of tall grass a skid collided with a sand ridge causing a roll over. - [NTSB CHI84IA246](https://openairdocs.org/ntsb/CHI84IA246.md): Mcdonnell Douglas DC-8-73 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jun 18, 1984 · N4867T · Minor damage > During descent, flt engineer noticed the hydraulic fluid level was low. Acft landed with locked brakes on all 4 wheels of the rt main gear and all 4 tires were blown out. Two hydraulic line fittings on the rudder hydraulic booster package were found to be the… - [NTSB FTW84LA279](https://openairdocs.org/ntsb/FTW84LA279.md): Piper PA-22-135 · Cleburne, TX · Accident · No injuries · Limited investigation · Final report · Jun 17, 1984 · N3491N · Substantial damage > Landing apch too high. Plt flared too high above ground resulting in an excessive sink rate on initial touchdown. Acft bounced back into air in a nose high attitude and 'a very low rate of speed.' Plt lost control of acft as rt quartering headwind blew acft… - [NTSB DEN84FA184](https://openairdocs.org/ntsb/DEN84FA184.md): Cessna 182L · Rosebud, NM · Accident · Serious injuries · Field investigation · Final report · Jun 17, 1984 · N42489 · Substantial damage > The acft ran off the gravel road used for a rwy during landing and collided with a ditch. A relative of the plt who was a witness said the acft floated 'a long time' and seemed to be flying 'too fast.' The plt also said it took longer to land than he expected… - [NTSB FTW84LA276](https://openairdocs.org/ntsb/FTW84LA276.md): Cessna 152 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Jun 16, 1984 · N4702P · Substantial damage > Shortly after touchdown during a touch and go landing directional control was lost. Acft veered off left side of rwy and came to rest in a waterway used by seaplanes that is adjacent and parallel to rwy 17L. - [NTSB DEN84LA183](https://openairdocs.org/ntsb/DEN84LA183.md): Scheibe Flugzeugbau Zugvogel Iiib · Taos, NM · Accident · No injuries · Limited investigation · Final report · Jun 16, 1984 · N30118 · Destroyed > According to the plt, the winds increased during a flt in a mountainous area & the thermal updrafts 'broke up.' While gliding back to the arpt, he encountered sinking air & was forced to make an emergency landing on rough, sage brush covered, terrain. This… - [NTSB DEN84LA182](https://openairdocs.org/ntsb/DEN84LA182.md): Cessna 180C · Lustre, MT · Accident · No injuries · Limited investigation · Final report · Jun 16, 1984 · N9311T · Substantial damage > Due to strong crosswind conditions at the prepared landing strip, the pilot elected to land in an open field. On touchdown, the right main landing gear encountered a hole, breaking the mounting structure and collapsing the gear. A ground loop ensued. The… - [NTSB CHI84LU004](https://openairdocs.org/ntsb/CHI84LU004.md): Ultralight Flight Phantom · St. Joseph, IL · Accident · Serious injuries · Final report · Jun 16, 1984 · UNREG · No damage > The plt was practicing power-off landings, during which he reportedly cut-off the engine at about 50 ft AGL. During the 5th landing of this type, the Ultralight lost speed, then entered a descent & touched down hard in a nose low attitude. - [NTSB CHI84LA244](https://openairdocs.org/ntsb/CHI84LA244.md): Barnes AX-7B · Lake Orion, MI · Accident · Serious injuries · Limited investigation · Final report · Jun 16, 1984 · N37643 · No damage > A 74 year old passenger in a balloon lost her footing during landing and fell on her arm. Later examination revealed that her arm was broken. The plt and another passenger were not injured. The plt reported that the passengers had been briefed on landing and… - [NTSB CHI84FA239](https://openairdocs.org/ntsb/CHI84FA239.md): Mooney M20C · Middlefield, OH · Accident · 2 fatal · Field investigation · Final report · Jun 16, 1984 · N6262U · Destroyed > The acft props touched the rwy during a wheels-up approach and the plt initiated a go-around with bent props. The acft climbed to about 100 ft AGL with less than full power. The wings began to rock,the left wing dropped and the acft fell straight down to the… - [NTSB ATL84LA204](https://openairdocs.org/ntsb/ATL84LA204.md): Schweizer SGS 1-26A · Manning, SC · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1984 · N2754R · Substantial damage > The plt entered a steep turn at the end of a 2nd field that she had selected for a landing. While maneuvering to land, the right wing contacted the ground & the left wing hit a power line. This was the plt's 1st tow & release in this model. - [NTSB NYC84LA215](https://openairdocs.org/ntsb/NYC84LA215.md): Cessna C172 · Patton, PA · Accident · No injuries · Limited investigation · Final report · Jun 14, 1984 · N738CN · Substantial damage > The plt landed fast and long and before running off the end of the 1750 ft rwy he turned right toward the ramp. A gust of wind caught the acft and the acft collided with a ditch beside the ramp. - [NTSB NYC84LA210](https://openairdocs.org/ntsb/NYC84LA210.md): Bellanca 8KCAB · Mahaffey, PA · Accident · No injuries · Limited investigation · Final report · Jun 14, 1984 · N9178L · Substantial damage > The acft veered off the prepared landing area in tall weeds and rocks where it nosed over. The plt had changed from a gravel rwy to the dirt one because of downdrafts. The 1st landing on the dirt rwy was made on the wheels and when the tail lowered the plt… - [NTSB MIA84LA185](https://openairdocs.org/ntsb/MIA84LA185.md): Lake 250 · Ket Largo, FL · Accident · No injuries · Limited investigation · Final report · Jun 14, 1984 · N1400X · Destroyed > As the plt was approaching to land in the open ocean near key Largo, FL, a big wave appeared. The plt pulled the nose of the acft up & added power. However, the acft impacted the wave crest & was catipulted upward in a nose high attitude. It then came down on… - [NTSB ANC84LA090](https://openairdocs.org/ntsb/ANC84LA090.md): Champion 7GCBC · Healy, AK · Accident · No injuries · Limited investigation · Final report · Jun 14, 1984 · N8380V · Substantial damage > The plt landed at a remote strip used by hunters and left in as poor a state as possible by them to make this choice game area relativley inaccessable. This area has many accidents as a result. The rwy is 1200 ft MSL. There are no wind direction indicators.… - [NTSB SEA84LA129](https://openairdocs.org/ntsb/SEA84LA129.md): Cessna 150L · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jun 12, 1984 · N21939 · Substantial damage > As the student plt was flaring to land, the acft ballooned & subsequently entered a porpoise. He attempted to make a go-around, but the acft struck the ground when it lost altitude after the student retracted the flaps. - [NTSB LAX84LA352](https://openairdocs.org/ntsb/LAX84LA352.md): Cessna T210 · California City, CA · Accident · No injuries · Limited investigation · Final report · Jun 11, 1984 · N4850C · Substantial damage > The plt felt a vibration as he circled a lake bed, so he decided to make a precautionary landing. During the landing, the nose gear dug into a soft spot and the acft nosed over. - [NTSB CHI84LA234](https://openairdocs.org/ntsb/CHI84LA234.md): Cessna 152 · Marine City, MI · Accident · No injuries · Limited investigation · Final report · Jun 11, 1984 · N4857B · Substantial damage > The student plt reached down to adjust the trim after touchdown & the acft became airborne again. The acft then bounced hard, 2 times, & the student made a go-around. He did not realize the extent of the nose gear damage until after the next landing. During… - [NTSB NYC84LA191](https://openairdocs.org/ntsb/NYC84LA191.md): Cessna 182R II · Fulton, NY · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N9845H · Substantial damage > When the acft bounced into the air on a hard landing at night, the plt applied back pressure on the yoke. Acft stalled back to the runway, damaging nose gear/firewall structure and left wing tip. Plt stated most of his experience was in acft configured with… - [NTSB MKC84LA169](https://openairdocs.org/ntsb/MKC84LA169.md): Cessna 172E · Waterloo, IA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N5614T · Substantial damage > There was heavy traffic at the arpt & the winds were from 280 deg at 16 KTS gusting to 25 KTS. Rather than waiting for the primary rwy (24), the plt elected to land on rwy 18. During the landing, a gust of wind lifted the right wing & the left wing dragged on… - [NTSB LAX84LA347](https://openairdocs.org/ntsb/LAX84LA347.md): Cessna R172E · Payson, AZ · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N42FG · Substantial damage > The purpose of the flight was to give the pvt plt a recurrency checkride as required by the civil air patrol. The commercial rated check plt is not a CFI. According to the check plt the pvt plt was attempting a touch and go landing. The pvt plt flared too… - [NTSB LAX84LA345](https://openairdocs.org/ntsb/LAX84LA345.md): Beech 35 · Concord, CA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N9481Y · Substantial damage > The plt stated he landed in a x-wind & wanted to raise the flaps but raised the gear instead. - [NTSB FTW84FU007](https://openairdocs.org/ntsb/FTW84FU007.md): Weedhopper B · Spencer, OK · Accident · Serious injuries · Final report · Jun 10, 1984 · UNREG · Destroyed > The airman took off on a windy day and began to have difficulty controling his vehicle. This vehicle had a 34 ft soaring wing with no ailerons. The pilot decided to land and wait for better flying conditions. During the landing, a wing dropped and before the… - [NTSB CHI84LA236](https://openairdocs.org/ntsb/CHI84LA236.md): Maule M-4 · Middletown, OH · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N540JC · Substantial damage > Plt was attempting to make a 3 point stall landing when a gust of wind was encountered, resulting in a hard landing. Plt reported the wind was gusting to 20 KTS. - [NTSB CHI84LA228](https://openairdocs.org/ntsb/CHI84LA228.md): Grumman AA-1C · Madison, IN · Accident · No injuries · Limited investigation · Final report · Jun 10, 1984 · N8055W · Substantial damage > The student plt was practicing touch-&-go landings with an Aeronca in the traffic pattern ahead of him. He stated that when he touched down, the Aeronca was still on the rwy, so he decided to abort the landing to avoid the other acft. The plt stated he had… - [NTSB SEA84LA131](https://openairdocs.org/ntsb/SEA84LA131.md): Cessna 172D · Toledo, WA · Accident · No injuries · Limited investigation · Final report · Jun 9, 1984 · N2132Y · Substantial damage > During a hard landing the acft bounced and the nose gear collapsed. - [NTSB LAX84LA342](https://openairdocs.org/ntsb/LAX84LA342.md): Lee Thorpe T-18 · Lee Vining, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 9, 1984 · N147DS · Substantial damage > The plt reported that during a landing in calm air, the acft began veering right when he applied the brakes. He corrected with left rudder & brake, then the acft veered left. Subsequently, it veered off the left side of the rwy, went down a grade & nosed… - [NTSB FTW84LA268](https://openairdocs.org/ntsb/FTW84LA268.md): Boeing A75N1 · Friendswood, TX · Accident · No injuries · Limited investigation · Final report · Jun 9, 1984 · N44WR · Substantial damage > Plt lost directional control of acft during landing roll. Acft traveled off the side of the 24 foot wide rwy where it contacted a parked acft, a fence and a ditch before stopping. - [NTSB CHI84IA224](https://openairdocs.org/ntsb/CHI84IA224.md): Beech 99 · Chicago, IL · Incident · Minor injuries · Incident investigation · Final report · Jun 9, 1984 · N320BA · Minor damage > Landing gear extended but not locked. Crew could not rectify situation by using normal and emergency gear extension procedures. Gear collapsed on touchdown. Investigation disclosed a fatigue crack in rt main gear hydraulic actuator allowing a loss of… - [NTSB ATL84LA196](https://openairdocs.org/ntsb/ATL84LA196.md): Mooney M20E · Seale, AL · Accident · No injuries · Limited investigation · Final report · Jun 9, 1984 · N3494X · Substantial damage > The plt approached downwind at 80 mph with full flaps. At touchdown the acft bounced and floated about 600 ft before a 2nd touchdown. When the acft could not be stopped on the short grass rwy, it was groundlooped to stay on the arpt. During the groundloop the… - [NTSB ATL84LA195](https://openairdocs.org/ntsb/ATL84LA195.md): Cessna 152 · Leesburg, VA · Accident · No injuries · Limited investigation · Final report · Jun 9, 1984 · N5342M · Substantial damage > The plt practiced several landings, then made a soft field apch with 20 deg of flaps. During the 1st part of the landing roll, he held the nosewheel off the rwy, then lowered the nose & applied the brakes. At that time, the acft veered right, went off the rwy… - [NTSB MKC84LA167](https://openairdocs.org/ntsb/MKC84LA167.md): Cessna 172P · Fremont, NE · Accident · No injuries · Limited investigation · Final report · Jun 8, 1984 · N97163 · Substantial damage > The pilot selected a downwind rwy for landing. Touchdown was nose gear first, followed by a porpoise and a go-around. On the second approach to the same runway, touchdown was again nose first and the aircraft porpoised twice before landing was completed. The… - [NTSB ATL84LA210](https://openairdocs.org/ntsb/ATL84LA210.md): Johnson Skyote · Portsmouth, VA · Accident · Minor injuries · Limited investigation · Final report · Jun 8, 1984 · N64SK · Substantial damage > The acft was a recently manufactured, home built plane that was equipped with brakes that were designed for a much larger (Piper PA-23) acft. The plt stated that the brakes were too sensitive for his acft, a skyote. Also, he equipped it with a high quality… - [NTSB ANC84LA087](https://openairdocs.org/ntsb/ANC84LA087.md): Cessna A188B · Kantishna, AK · Accident · No injuries · Limited investigation · Final report · Jun 8, 1984 · N6532G · Substantial damage > The acft encountered uneven terrain during landing & rolled over. There were no acft malfunctions according to the plt. The plt to date has not filed an accident report. In a telephonic interview he said he encountered the uneven terrain during landing… - [NTSB NYC84LA207](https://openairdocs.org/ntsb/NYC84LA207.md): Helio 295 · So. Burlington, VT · Accident · No injuries · Limited investigation · Final report · Jun 7, 1984 · N6485V · Substantial damage > The left main gear collapsed during landing roll-out. The plt/owner had been practicing touch and go landings. - [NTSB DEN84LA170](https://openairdocs.org/ntsb/DEN84LA170.md): Weatherly 201B · Platteville, CO · Accident · Minor injuries · Limited investigation · Final report · Jun 7, 1984 · N1275W · Substantial damage > The ag plt was returning for his 3rd load. He said that after a wheel landing, he pulled back on the stick to lower the tailwheel & the acft ballooned back into the air. The plt said that he applied power to go around, but the acft settled & he lost… - [NTSB LAX84LA346](https://openairdocs.org/ntsb/LAX84LA346.md): Grumman American AA-1B · Bermuda Dunes, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1984 · N8874L · Substantial damage > The acft drifted to the left during landing and collided with a parked Cessna 172 and a fence. The acft then nosed over and came to rest inverted. According to the operator, winds were less than 10 KTS when the solo student departed 50 minutes earlier.… - [NTSB CHI84LA221](https://openairdocs.org/ntsb/CHI84LA221.md): Beech 58 · Iron Mountain, MI · Accident · No injuries · Limited investigation · Final report · Jun 6, 1984 · N1557W · Substantial damage > The plt reported that after he made a normal landing, he retracted the gear instead of the flaps. However, there were indicates that the gear was not fully extended during touchdown. The landing gear circuit breaker was found popped. The landing gear safety… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=443 ## 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=442 --- 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.