# 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 393 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB DEN88LA018](https://openairdocs.org/ntsb/DEN88LA018.md): Cessna 210 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Oct 24, 1987 · N6551X · Substantial damage > The CFI was instructing the private rated plt in simulated forced landings. The plt reported that after a full stop landing, the aircraft would not turn properly to the right, and she suspected brake system failure. The CFI took control and attempted to taxi… - [NTSB ATL88LA026](https://openairdocs.org/ntsb/ATL88LA026.md): Pitts S2A · Ramseur, NC · Accident · No injuries · Limited investigation · Final report · Oct 24, 1987 · N44LH · Substantial damage > The pilot lost directional control while making a normal landing. The pilot did not report a mechanical problem. The ground loop cause substantial damage to the aircraft's undercarriage. - [NTSB ATL88LA022](https://openairdocs.org/ntsb/ATL88LA022.md): Cessna 150C · Wartburg, TN · Accident · Serious injuries · Limited investigation · Final report · Oct 23, 1987 · N3585J · Substantial damage > The aircraft touched down hard on the 1300 foot grass strip and began to porpoise. The pilot attempted to go-around but was unable to gain sufficient altitude to avoid striking a power line. The plt did not file an acc report. - [NTSB MIA88LA017](https://openairdocs.org/ntsb/MIA88LA017.md): Maule M-5-180C · Madison, MS · Accident · No injuries · Limited investigation · Final report · Oct 22, 1987 · N56583 · Substantial damage > The plt stated that during the landing roll the acft began to veer off towards the left side of the rwy. Full rt rudder would not correct this. The acft then left the rwy, ground looped, & as a result the rt main gear collapsed & the tailwheel separated from… - [NTSB FTW88LA010](https://openairdocs.org/ntsb/FTW88LA010.md): Cessna 150L · Lancaster, TX · Accident · No injuries · Limited investigation · Final report · Oct 22, 1987 · N17176 · Substantial damage > While rtrng fm a x-country, the student bcm disoriented & reqd assistance. Redbird twr ctlr adzd dallas-ft worth TRACON that the plt was lost & needed a beacon identification. A few min later, the acft's location was determined & the ctlr at redbird relayed a… - [NTSB DEN88LA013](https://openairdocs.org/ntsb/DEN88LA013.md): Beech C45G · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · Oct 22, 1987 · N781A · Substantial damage > While conducting the last landing at the completion of a revenue freight hauling flt the acft departed the side of the runway separating the left main landing gear and damaging the left wing and number one engine. The plt stated that the landing lights would… - [NTSB MKC88LA014](https://openairdocs.org/ntsb/MKC88LA014.md): National Balloon 752 · Ankeny, IA · Accident · Serious injuries · Limited investigation · Final report · Oct 21, 1987 · N72711 · No damage > During a promotional balloon flt, the plt stated that on an approach to lnd the basket drifted into a large hay bale. The basket tipped and the plts ankle was broken when caught between the basket and a propane tank. - [NTSB ATL88LA023](https://openairdocs.org/ntsb/ATL88LA023.md): Cessna 152 · Conway, SC · Accident · No injuries · Limited investigation · Final report · Oct 21, 1987 · N94126 · Substantial damage > The student plt was performing a normal landing with a crosswind from the left. The acft was drifting to the right at touchdown and was partially off the rwy to the right. The plt attempted to use the brakes and keep the acft's ground track parallel with the… - [NTSB LAX88LA019](https://openairdocs.org/ntsb/LAX88LA019.md): Cessna 195A · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Oct 19, 1987 · N4372N · Substantial damage > The pilot stated that during the end of the landing roll on runway 28L, the aircraft started turning to the right and he could not correct it and the aircraft ground looped. There were no mechanical problems reported prior to the accident. The pilot reported… - [NTSB NYC88LA009](https://openairdocs.org/ntsb/NYC88LA009.md): Cessna 140 · New Milford, CT · Accident · No injuries · Limited investigation · Final report · Oct 18, 1987 · N2841N · Substantial damage > The flight en route was uneventful; however, during the landing at New Milford, CT, the aircraft's propeller struck the surface of the runway & the plane nosed over. The plt stated that he applied the brakes too harshly. - [NTSB MKC88LA009](https://openairdocs.org/ntsb/MKC88LA009.md): Grumman American AA5B · Branson, MO · Accident · No injuries · Limited investigation · Final report · Oct 18, 1987 · N499GT · Substantial damage > During a lndg on a 3600 ft strip, the acft touched down long. The acft ran off the departure end of the rwy and collided with the terrain causing substantial damage to the acft. Witnesses said they could not find any skid marks along the path taken by the… - [NTSB SEA88LA008](https://openairdocs.org/ntsb/SEA88LA008.md): Cessna T210N · Walla Walla, WA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N7231N · Substantial damage > The pilot landed short and the aircraft's main landing gear struck the edge of a plateau at the approach end of the private strip. The aircraft swerved off the grass runway, the nose gear collapsed, and the aircraft nosed over. - [NTSB MKC88LA020](https://openairdocs.org/ntsb/MKC88LA020.md): Cessna 177 · Warrensburg, MO · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N2969X · Substantial damage > PIC stated she had misjudged ldg, resulting in an uncontrolled porpoise, damaging nose wheel and stabilator. She aborted ldg attempt and returned to departure airport. Considerable difficulty controlling the acft was encountered, but with outside radio… - [NTSB ATL88LA014](https://openairdocs.org/ntsb/ATL88LA014.md): Cessna 152 · Murfreesboro, NC · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N757AD · Substantial damage > The student plt became lost on the return leg of his 1st solo cross-country flt. He elected to make a precautionary ldg in a plowed field after observing the acft fuel gauges indicating near empty. The acft nosewheel sank into soft dirt during rollout and the… - [NTSB ATL88LA013](https://openairdocs.org/ntsb/ATL88LA013.md): Piper PA-38-112 · Hampton, GA · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N91461 · Substantial damage > The CFI rptd that the student flared the airplane about 50 ft abv the rwy and stalled it; the airplane dropped to the rwy and bounced. He assumed control of the airplane from the student and attempted to prevent a crosswind from blowing the airplane to the… - [NTSB ANC88LA008](https://openairdocs.org/ntsb/ANC88LA008.md): Cessna 207A · Sheldon Point, AK · Accident · No injuries · Limited investigation · Final report · Oct 17, 1987 · N1472M · Substantial damage > The air taxi pilot attempted to land on a short narrow gravel air strip in crosswind conditions. He ran off the end of the runway and the airplane was substantially damaged. The wind was in excess of recommendations for the type acft. A witness reported that… - [NTSB SEA88LA007](https://openairdocs.org/ntsb/SEA88LA007.md): Cessna 180K · Petersburg, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1987 · N63071 · Destroyed > The plt of the floatplane rprtd that after the acft touched down drg a water lndg & was on the 'roll-out,' she pushed the carb heat in & leaned forward to raise the flaps. At about that time, the floatplane bgn to swerve. She attempted to regain control;… - [NTSB BFO88DHD02](https://openairdocs.org/ntsb/BFO88DHD02.md): Boeing A75N1 · Milton, DE · Accident · No injuries · Final report · Oct 16, 1987 · N53488 · Substantial damage > The pilot's improper brake application during a 'wheel' landing, which resulted in the aircraft nosing over. The slight downslope of the airstrip, a quartering tailwind, inadequate supervision on the part of the check pilot, and the pilot's lack of… - [NTSB ANC88LA009](https://openairdocs.org/ntsb/ANC88LA009.md): Cessna A150K · Whittier, AK · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1987 · N8477M · Substantial damage > The PIC got lost while flying above an overcast. When he finally found an opening and descended below the clouds he was low on fuel. He located some buildings on a narrow beach and attempted to land. He overshot the beach and struck stacks of building… - [NTSB CHI88FA005](https://openairdocs.org/ntsb/CHI88FA005.md): Cessna TU-206G · Lansing, MI · Accident · No injuries · Field investigation · Final report · Oct 15, 1987 · N9359Z · Substantial damage > Immediately after takeoff the plt noted strong pressure on the right rudder. He trimmed out the rudder pressure and continued to fly in the local area. Approach flare and touchdown were normal. When the nose wheel contacted the runway the airplane veered… - [NTSB ATL88LA019](https://openairdocs.org/ntsb/ATL88LA019.md): Piper PA-28R-180 · Lexington, KY · Accident · No injuries · Limited investigation · Final report · Oct 14, 1987 · N4639J · Substantial damage > During a dual instructional flight the student leveled the acft abv the rwy during the landing flare. The CFI told the FAA inspector that he was verbally coaching the student and did not assume the flt controls. The acft landed hard and the student applied… - [NTSB ATL88LA011](https://openairdocs.org/ntsb/ATL88LA011.md): Cessna 152 · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Oct 14, 1987 · N5117B · Substantial damage > The student pilot was flying solo for the first time. Two landings had been completed successfully. The pilot misjudged the final approach and touched down short of the runway. The aircraft landed hard causing the nose gear to collapse. - [NTSB DEN88LA009](https://openairdocs.org/ntsb/DEN88LA009.md): Cessna A185F · Glasgow, MT · Accident · No injuries · Limited investigation · Final report · Oct 12, 1987 · N2525S · Substantial damage > The plt reported that he was landing on rwy 12 with the winds, as reported by UNICOM, 100 deg at 10 KTS. He said that shortly after touchdown the acft was hit by a strong gust from the rt. The rt wing lifted, the lt wing hit the ground, and the acft nosed… - [NTSB FTW88DQG01](https://openairdocs.org/ntsb/FTW88DQG01.md): Boeing A75N1 · Fort Stockton, TX · Accident · No injuries · Final report · Oct 11, 1987 · N54279 · Substantial damage > The pilot stated that during the flare for a full stall landing in the tail wheel equipped aircraft, a whirlwind was encountered. He said he applied full power & full left aileron & rudder, but could not recover. Subsequently, the aircraft struck an… - [NTSB DEN88LA007](https://openairdocs.org/ntsb/DEN88LA007.md): Aerostar S-66A · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 11, 1987 · N64547 · No damage > Upon landing, the balloon touched down on a gravel road and bounced over a small depression. The basket struck a small mound and threw three of the six passengers against the rail of the basket. The other passengers fell against them and the three were… - [NTSB CHI88LA004](https://openairdocs.org/ntsb/CHI88LA004.md): Cessna 150H · Elroy, WI · Accident · No injuries · Limited investigation · Final report · Oct 11, 1987 · N50124 · Substantial damage > Upon attempting his tenth touch and go the student pilot noticed, prior to touchdown, that the aircraft was to the right of the runway. In an attempt to realign himself with the runway the pilot stated he 'lowered' the left wing. The left wing then struck the… - [NTSB ATL88DKG05](https://openairdocs.org/ntsb/ATL88DKG05.md): American Falcon XP · Palmetto, GA · Accident · No injuries · Final report · Oct 11, 1987 · N377AA · Substantial damage > The pilot failed to properly flare the aircraft during a normal landing which resulted in a hard landing. The nose gear assembly failed from overload, and the pilot was not able to control the aircraft as it slid over the ground. The aircraft collided with a… - [NTSB FTW88DRG01](https://openairdocs.org/ntsb/FTW88DRG01.md): North American P82-B · Harlingen, TX · Accident · No injuries · Final report · Oct 10, 1987 · N12102 · Substantial damage > The aircraft was engaged in a demonstration flight with the confederate air force at rio grande valley international airport. During the approach to runway 17L the pilot flared the aircraft too high resulting in a stall and an excessive rate of descent. At… - [NTSB BFO88DIG01](https://openairdocs.org/ntsb/BFO88DIG01.md): Cessna 177A · Stevensville, MD · Accident · Minor injuries · Final report · Oct 10, 1987 · N30590 · Substantial damage > While practicing touch-and-go landings, the student plt made an approach at a higher than normal airspeed. Subsequently,the acft bounced three times on the runway before the plt elected to go around. The student stated that control was lost on the go-around… - [NTSB ATL88LA009](https://openairdocs.org/ntsb/ATL88LA009.md): Cessna 150L · Cumming, GA · Accident · No injuries · Limited investigation · Final report · Oct 10, 1987 · N18167 · Substantial damage > The student pilot was attempting to land on the 1550 foot runway. The aircraft touched down hard and bounced. The pilot pushed forward on the control column and the aircraft came down on the nose gear which collapsed. - [NTSB ANC88LA005](https://openairdocs.org/ntsb/ANC88LA005.md): Piper PA-12 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Oct 10, 1987 · N3651N · Substantial damage > The acft collided with a tree stump during a short field landing. The plt stated that the stump was hidden by tall grass. No official information is published abt the johnson airstrip. - [NTSB MKC88LA006](https://openairdocs.org/ntsb/MKC88LA006.md): Boeing A-75 · Creve Coeur, MO · Accident · No injuries · Limited investigation · Final report · Oct 9, 1987 · N1754M · Substantial damage > While practicing stop and go ldgs, plt lost control during rollout. Acft swerved and entered an inadvertent ground loop. The right main landing gear failed and the right lower wing contacted the ground. - [NTSB LAX88LA010](https://openairdocs.org/ntsb/LAX88LA010.md): Piper PA-18-150 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1987 · N4085E · Substantial damage > The pilot stated that during the landing roll he was distracted and looked downward. He said that when he looked back up the ground loop had started and it was too late to correct it. He did not report any mechanical problems prior to the accident. - [NTSB DEN88LA006](https://openairdocs.org/ntsb/DEN88LA006.md): Cessna 182P · Monument Valley, UT · Accident · No injuries · Limited investigation · Final report · Oct 9, 1987 · N7746G · Substantial damage > The private pilot was landing on a dirt runway and at touchdown a crosswind weathervaned the aircraft to the right. The pilot added full power to try to go around but the aircraft settled back to the ground left of the runway. The aircraft came to rest 300… - [NTSB SEA88LA004](https://openairdocs.org/ntsb/SEA88LA004.md): Cessna 180C · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Oct 8, 1987 · N9705Z · Substantial damage > While landing onto a soft, sandy beach area the aircraft nosed over inverted. The plt failed to file an accident report. - [NTSB MKC88LA011](https://openairdocs.org/ntsb/MKC88LA011.md): Champion 7GCB · Warrensburg, MO · Accident · No injuries · Limited investigation · Final report · Oct 8, 1987 · N9967Y · Substantial damage > The plt indicated that on final app, when ovr the rwy threshold, he leveled the acft off at abt 10 ft and it dropped in. Subsequent inspection revealed that all four wing spars had longitudinal cracks. The plt had recently purchased the acft and had abt 14… - [NTSB FTW88LA003](https://openairdocs.org/ntsb/FTW88LA003.md): Grumman GA7 · Covington, LA · Accident · No injuries · Limited investigation · Final report · Oct 8, 1987 · N718GA · Substantial damage > The pilot touched down with excessive speed, and due to the poor mechanical condition of the aircraft's brakes, was unable to stop before over-running the departure end of the runway. The aircraft's annual inspection was two months overdue. The pilot's… - [NTSB DEN88LA005](https://openairdocs.org/ntsb/DEN88LA005.md): Rockwell 690B · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 8, 1987 · N711TT · Destroyed > Acft was landing on rwy 17 at coronado airport, 9 NM n of Albuquerque, NM intl arpt. Plt said he brought props into reverse and acft went off right side of rwy. Plt brought props out of reverse, realigned acft on rwy, and reversed props again. Acft went off… - [NTSB ATL88LA005](https://openairdocs.org/ntsb/ATL88LA005.md): Piper PA-24-180 · Collegedale, TN · Accident · No injuries · Limited investigation · Final report · Oct 8, 1987 · N5988P · Substantial damage > The airplane touched down while the ldg gear were extending. A witness reported that the acft began the ldg flare with the gear completely retracted, and that the gear began to extend when the airplane was 3-4 ft above the rwy. The main ldg gear contacted the… - [NTSB SEA88LA001](https://openairdocs.org/ntsb/SEA88LA001.md): British Aerospace BA-3101 · Kennewick, WA · Accident · No injuries · Limited investigation · Final report · Oct 7, 1987 · N406UE · Substantial damage > While on a flight to pasco, WA. The pilot inadvertently landed at the Kennewick, WA. Vista airport, landed long, and overran the runway. The aircraft departed the end of the runway and impacted terrain. - [NTSB MKC88LA001](https://openairdocs.org/ntsb/MKC88LA001.md): Bellanca 17-31ATC · Wamego, KS · Accident · No injuries · Limited investigation · Final report · Oct 6, 1987 · N8786V · Substantial damage > During a night ldg the plt aligned the acft with the white tops of a fence that was parallel to the runway. Not all of the rwy lights were illuminated. Both wings and the lower fuselage were substantially damaged during the lndg on the fence. - [NTSB DEN88LA003](https://openairdocs.org/ntsb/DEN88LA003.md): Cessna 152 · Tremonton, UT · Accident · No injuries · Limited investigation · Final report · Oct 6, 1987 · N7572B · Substantial damage > The student plt flew to the first stop on his cross country training flight. He misread the windsock and landed downwind on runway 17. After touchdown the pilot lost control of the aircraft and taxied off the left side of the runway, hit a fence and a tree… - [NTSB LAX88FA006](https://openairdocs.org/ntsb/LAX88FA006.md): Boeing 767-201 · Los Angeles, CA · Accident · No injuries · Field investigation · Final report · Oct 5, 1987 · N604P · Substantial damage > The captain sensed the aircraft ballooning during the flare. He increased the pitch angle to 11.8 degrees to arrest the descent during touchdown. Flight attendants sitting in the aft cabin crew seats heard a scraping sound just prior to main landing gear… - [NTSB DEN88LA004](https://openairdocs.org/ntsb/DEN88LA004.md): Balloon Works Firefly 7-B · Rio Rancho, NM · Accident · No injuries · Limited investigation · Final report · Oct 5, 1987 · N15260 · Substantial damage > The plt rptd that she had vented the Balloon to land. She said it takes both of her hands to open the vent and hold it open. 'When the Balloon hit the ground the burner went on by itself, wide open. The envelope was swinging from the contact of the basket… - [NTSB CHI88LA002](https://openairdocs.org/ntsb/CHI88LA002.md): Cessna 177 · Verona, WI · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1987 · N3226T · Destroyed > During a VFR landing abort full power was applied and flaps selected to the full up position. The aircraft began to settle and a turn to the left was initiated. The left wing dropped abruptly, the nose pitched down and a left hand rotation began. This… - [NTSB LAX88LA004](https://openairdocs.org/ntsb/LAX88LA004.md): Republic RC-3 · Clearlake, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 4, 1987 · N87583 · Substantial damage > The aircraft nosed over when the pilot made a water landing with the wheels extended. The pilot failed to use the landing checklist. - [NTSB LAX88LA003](https://openairdocs.org/ntsb/LAX88LA003.md): Grumman AA-5A · Big Bear City, CA · Accident · No injuries · Limited investigation · Final report · Oct 4, 1987 · N7368L · Substantial damage > The student pilot bounced during landing and collided with runway lights and a taxiway sign. He landed on runway 25 with winds reported 040 degrees at 8 knots. He said he could not receive wind information because he had inadvertantly turned off his radio. - [NTSB LAX88FA001](https://openairdocs.org/ntsb/LAX88FA001.md): Cessna 172RG · Calistoga, CA · Accident · 1 fatal · Field investigation · Final report · Oct 4, 1987 · N5234U · Destroyed > Upon arriving over the destination arpt the plt used an incorrect CTAF frequency to contact the arpt and he used a right hand traffic pattern approaching the 2600 foot-long rwy. Because a residential area lay west of the arpt & open fields lay to the east,… - [NTSB ATL88LA003](https://openairdocs.org/ntsb/ATL88LA003.md): Cessna 172N · Thomson, GA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1987 · N5266E · Substantial damage > During the ldg roll on rwy 28, a crosswind gust caused the airplane to become airborne again. The plt added full pwr and attempted to abort the ldg. The airplane subsequently drifted to the downwind side of the runway and impacted rising terrain. The plt… - [NTSB ATL88LA001](https://openairdocs.org/ntsb/ATL88LA001.md): Cessna 172P · Hilton Head, SC · Accident · No injuries · Limited investigation · Final report · Oct 3, 1987 · N66090 · Destroyed > The student plt was performing a crosswind landing which resulted in a hard landing. The acft drifted to the side of the rwy and one wheel was off the paved surface upon the next touchdown. The student plt attempted to hold the acft straight in the direction… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=394 ## 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=393 --- 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.