# 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 388 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB NYC88LA127](https://openairdocs.org/ntsb/NYC88LA127.md): Piper PA-28-180 · Slatington, PA · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 1988 · N4893L · Destroyed > The pilot landed at Slatington, Pennsylvania during strong wind conditions. When the pilot applied brakes, a sudden gust of wind lifted the left wing and pushed the aircraft off the right side of the runway down an embankment, and into a tree stump. - [NTSB ATL88LA148](https://openairdocs.org/ntsb/ATL88LA148.md): Cessna 182Q · Lowell, OH · Accident · No injuries · Limited investigation · Final report · Apr 17, 1988 · N759BJ · Substantial damage > The plt rptd that he landed in a 12-14 kt, 90 degree x-wind. The initial portion of the ldg rollout was shielded from the wind by a row of trees bordering part of the upwind side of the rwy. Upon reaching a clearing in the trees, the airplane was exposed to… - [NTSB ANC88LA043](https://openairdocs.org/ntsb/ANC88LA043.md): Cessna 185 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Apr 17, 1988 · N5060R · Substantial damage > The pilot stated that he made a hard landing and at that time he lost directional control of the aircraft. The plt stated that the acft bounced and when he tried to correct the bounce the acft yawed left. The rt main gear collapsed and the acft groundlooped. - [NTSB SEA88LA079](https://openairdocs.org/ntsb/SEA88LA079.md): Mooney M20E · The Dalles, OR · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1988 · N7158V · Substantial damage > On arrival, plt found destination obscured by unforecast fog, held briefly, then diverted to an alternate airport. On arrival at alt in darkness, plt did not know freq (UNICOM) to activate rwy lights. Plt made low pass to acquire rwy environment as fuel state… - [NTSB NYC88LA126](https://openairdocs.org/ntsb/NYC88LA126.md): Cessna 150 · Windham, CT · Accident · Minor injuries · Limited investigation · Final report · Apr 16, 1988 · N7504G · Destroyed > The pilot took off and flew a short pattern around the airport. The pilot stated that on descent from 1200 feet strong winds started pushing the aircraft and he was losing control. The aircraft bounced and he decided to go around. However, on climb out the… - [NTSB MKC88LA078](https://openairdocs.org/ntsb/MKC88LA078.md): Piper PA-25 · Red Cloud, NE · Accident · No injuries · Limited investigation · Final report · Apr 16, 1988 · N7071Z · Substantial damage > After a first time familiarization flt, the pilot returned to the base field for ldg. During the landing attempt, the aircraft bounced, and on recovery, the pilot pitched the nose up too high. The aircraft stalled and then struck the runway damaging the… - [NTSB MIA88LA153](https://openairdocs.org/ntsb/MIA88LA153.md): Cessna 152 · Olive Branch, MS · Accident · No injuries · Limited investigation · Final report · Apr 16, 1988 · N4830B · Substantial damage > The plt stated that as he was rolling out on the runway, the right wing lifted, and in an attempt to correct the situation, the acft went off the right side of the runway, flipped over and came to rest inverted. - [NTSB CHI88LA100](https://openairdocs.org/ntsb/CHI88LA100.md): Cessna 182D · Mt. Vernon, IL · Accident · No injuries · Limited investigation · Final report · Apr 16, 1988 · N8891X · Substantial damage > After electing to go-around on his first approach, the student pilot ballooned the aircraft as he passed over the runway on the second approach. Remedial action was attempted, but the pilot overcontrolled and the aircraft struck the runway slightly nosewheel… - [NTSB MIA88IA150](https://openairdocs.org/ntsb/MIA88IA150.md): Beech 58 · Jacksonville, FL · Incident · No injuries · Incident investigation · Final report · Apr 15, 1988 · N796Q · Minor damage > The plt stated that while on landing rollout, the gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed evidence that would suggest that the gear was up and locked at the time the acft landed. - [NTSB MKC88LA076](https://openairdocs.org/ntsb/MKC88LA076.md): Cessna 182E · Clarksville, AR · Accident · No injuries · Limited investigation · Final report · Apr 14, 1988 · N9373X · Substantial damage > While attempting to land at night on a radio activated runway lighted airport, PIC was unable to activate the system. After several attempts to activate the runway lights, he elected to land on the unlighted runway. He aligned about 20 yards right of… - [NTSB LAX88LA160](https://openairdocs.org/ntsb/LAX88LA160.md): Bell 47D1 · Taft, CA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1988 · N917B · Substantial damage - [NTSB ATL88LA141](https://openairdocs.org/ntsb/ATL88LA141.md): Cessna 170A · Athens, GA · Accident · No injuries · Limited investigation · Final report · Apr 13, 1988 · N1213D · 2 aircraft · Substantial damage > The plt of a Cessna 170A had departed albany, GA VFR with no flt plan for Athens, GA. A Cessna R172K from the Athens airport was engaged in local flying. The 172 retd from doing airwork and was making a full stop ldg. During his landing roll the plt reptd… - [NTSB NYC88LA123](https://openairdocs.org/ntsb/NYC88LA123.md): Cessna 185 · Hopedale, MA · Accident · No injuries · Limited investigation · Final report · Apr 11, 1988 · N4695E · Substantial damage > The pilot said he flared too high and landed hard. The pilot stated that the prop contacted the ground, the right landing gear broke, and the rt wing contacted the ground and was bent rearward during the hard landing. The plt did not file an acc report. - [NTSB LAX88LA156](https://openairdocs.org/ntsb/LAX88LA156.md): Eiriavion PIK 20D · Saint Helena, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 11, 1988 · N1NZ · Minor damage > The flight departed vacaville gliderport on an aero tow. The plt intended to fly to calistoga, CA and return. After passing st. Helena, CA, the thermal activity began to decrease. The plt executed a 180 deg turn to return to vacaville. When the flt was over… - [NTSB MIA88FA142](https://openairdocs.org/ntsb/MIA88FA142.md): Cessna 172N · Vero Beach, FL · Accident · Serious injuries · Field investigation · Final report · Apr 10, 1988 · N6283F · Destroyed > The acft was observed to touch down on rwy 36 with full flaps on the grass strip bordered on both sides by citrus groves, surface winds in the area were 120 degs at 11 KTS. The acft was observed to drift to the left off the rwy toward the grove. The plt… - [NTSB MIA88LA145](https://openairdocs.org/ntsb/MIA88LA145.md): Cessna 140A · Lakeland, FL · Accident · No injuries · Limited investigation · Final report · Apr 9, 1988 · N84SC · Substantial damage > While on a personal flt during the landing roll after the plt applied the brakes, the acft nosed over & came to rest inverted. He stated that the left brake locked up & after the acft was removed from the rwy, he disassembled each brake assy in an effort to… - [NTSB CHI88IA096](https://openairdocs.org/ntsb/CHI88IA096.md): Swearingen SA-227AC · Fort Wayne, IN · Incident · No injuries · Incident investigation · Final report · Apr 8, 1988 · N448CA · Minor damage > Inadequate design of the strut for the intended service conditions in commuter air carrier operations. - [NTSB MKC88LA074](https://openairdocs.org/ntsb/MKC88LA074.md): Piper PA-23-250 · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Apr 5, 1988 · N62551 · Substantial damage > While attempting to land on a narrow runway, with approaching thunderstorms within 4 miles of the airport, directional control was lost by the plt during the rollout. Plt stated a sudden change in surface wind direction made it impossible for him to maintain… - [NTSB ATL88LA132](https://openairdocs.org/ntsb/ATL88LA132.md): Beech M35 · Mc Cullough, AL · Accident · No injuries · Limited investigation · Final report · Apr 4, 1988 · N2255K · Substantial damage > The plt stated that he was landing at his destination arpt when the accident occurred. The turf/grass was wet. The acft overran the end of the rwy and collided with the terrain, several trees, and bushes. There were no mechanical malfunctions reported. - [NTSB MIA88LA140](https://openairdocs.org/ntsb/MIA88LA140.md): Start & Flug H101 Salto · Winter Haven, FL · Accident · No injuries · Limited investigation · Final report · Apr 3, 1988 · N999WC · Substantial damage > The flt entered the downwind leg for landing when the plt observed a glider parked 600 ft from the planned touchdown point. He elected to land to the left of the glider & after turning base then final, observed individuals pushing it towards the planned… - [NTSB FTW88DRG08](https://openairdocs.org/ntsb/FTW88DRG08.md): Boeing Stearman E-75 · Fisher, TX · Accident · No injuries · Final report · Apr 3, 1988 · N75031 · Substantial damage > After touchdown, the pilot stated that he lost directional control and the right main gear ran off the right side of the runway. During attempted recovery, the airplane rolled off the left side of the runway, collided with a drainage ditch and nosed over to… - [NTSB BFO88LA033](https://openairdocs.org/ntsb/BFO88LA033.md): Cessna 150M · Chesterfield, VA · Accident · No injuries · Limited investigation · Final report · Apr 3, 1988 · N63632 · Substantial damage > The student pilot lost directional control of the acft during landing roll. The acft traveled off the left side of the rwy and contacted a ditch. The landing was being made on rwy 15. Winds were from 190 degrees at 7 knots. - [NTSB NYC88LA124](https://openairdocs.org/ntsb/NYC88LA124.md): Stinson 108-2 · Warwick, NY · Accident · No injuries · Limited investigation · Final report · Apr 2, 1988 · N9326K · Substantial damage > During takeoff and landing practice, the aircraft veered left off of the runway despite reported full right rudder application by the pilot. The aircraft continued to roll across the grass and came to rest after colliding with a construction ditch. - [NTSB FTW88DRA08](https://openairdocs.org/ntsb/FTW88DRA08.md): Grumman G-164 · Palacios, TX · Accident · No injuries · Final report · Apr 2, 1988 · N8150K · Substantial damage > The plt stated that following a normal landing, he applied too much brake, causing the wheels to lock up. This, in turn, caused dead grass and mud to accumulate in front of the wheels. The acft subsequently flipped over and slid to a stop inverted. - [NTSB FTW88DPA03](https://openairdocs.org/ntsb/FTW88DPA03.md): Air Tractor AT-502 · Olney, TX · Accident · No injuries · Final report · Apr 2, 1988 · N7315N · Substantial damage > The pilot was familiarizing himself with this type of aircraft and was making a full flap landing. He allowed the aircraft to drift left during the landing roll in a slight crosswind. He then attempted to abort the landing roll with the application of takeoff… - [NTSB ATL88LA129](https://openairdocs.org/ntsb/ATL88LA129.md): North American T-6G · Stockbridge, GA · Accident · No injuries · Limited investigation · Final report · Apr 2, 1988 · N9871C · Substantial damage > The airplane landed with the left wheel locked, and subsequently nosed over during the ldg roll. Post-crash exam revealed that the left wheel could not be rotated in the fwd direction by hand, and that it could be rotated aft by hand only with considerable… - [NTSB ATL88LA128](https://openairdocs.org/ntsb/ATL88LA128.md): Beech B19 · Albany, KY · Accident · No injuries · Limited investigation · Final report · Apr 1, 1988 · N6994R · Substantial damage > The plt reported that he touched down about midfield on the 1,800 ft usable portion of the rwy. A light rain was falling at the time, and the rwy was wet. Braking action was poor, and the airplane subsequently overran the runway. The airplane traveled down an… - [NTSB ATL88LA126](https://openairdocs.org/ntsb/ATL88LA126.md): Cessna 152 · Charleston, SC · Accident · No injuries · Limited investigation · Final report · Apr 1, 1988 · N68726 · Substantial damage > The student plt rptd that the airplane was low on final appch, and that he applied pwr to maintain altitude. After crossing the rwy threshold, he reduced the pwr to idle & lowered the nose to maintain airspeed. He initiated a flare prior to touchdown, but the… - [NTSB MIA88LA143](https://openairdocs.org/ntsb/MIA88LA143.md): Cessna 152 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Mar 31, 1988 · N89224 · Substantial damage > The student plt completed 5 touch & go's with his instructor before dropping her off for first supervised solo flight. On the first touch & go landing, the acft bounced after touchdown on the main landing gear. The student plt added power, lowered the nose… - [NTSB MIA88LA135](https://openairdocs.org/ntsb/MIA88LA135.md): Piper PA-32-301 · Captiva, FL · Accident · No injuries · Limited investigation · Final report · Mar 30, 1988 · N8076D · Substantial damage > The pilot allowed the aircraft to descend below the normal approach angle and failed to correct the situation timely. The aircraft struck a seawall severing first the nose gear and then the main gear. The aircraft slid to a stop. - [NTSB NYC88LA116](https://openairdocs.org/ntsb/NYC88LA116.md): Bell 206L · Allentown, PA · Accident · No injuries · Limited investigation · Final report · Mar 29, 1988 · N114FH · Substantial damage > During an FAA flight check an autorotational descent was made with a planned power recovery, the helicopter fell through the maneuver and collided with the ground. The main rotor blades flexed downward, striking the horizontal fin winglets and the tail boom. - [NTSB LAX88LA143](https://openairdocs.org/ntsb/LAX88LA143.md): Piper PA-22-150 · Payson, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 29, 1988 · N8524D · Substantial damage > The pilot reported that during the landing roll a dust devil (whirlwind) pushed the aircraft off the runway, colliding with the terrain resulting in substantial damage. The pilot reported that the wind velocity was 25 knots gusting to 30 as a quartering… - [NTSB BFO88FID02](https://openairdocs.org/ntsb/BFO88FID02.md): Rotorway RW-145 · Ridgeway, VA · Accident · No injuries · Final report · Mar 29, 1988 · N107LH · Destroyed > The student pilot was attempting to land from a 2 foot hover when the accident occurred. He reported that he overcontrolled the helicopter and a dynamic rollover resulted. A witness reported the helicopter was traveling downwind when it began to turn to the… - [NTSB ANC88LA080](https://openairdocs.org/ntsb/ANC88LA080.md): Champion 7EC · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Mar 28, 1988 · N9061B · Substantial damage > The private pilot lost directional control of the airplane during the landing roll. The aircraft groundlooped to the left, striking a fence. The pilot reported that he came in high and hurried his approach to fit in with the flow of air traffic at the… - [NTSB LAX88LA145](https://openairdocs.org/ntsb/LAX88LA145.md): Schweizer SGS 2-33A · Warner Springs, CA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1988 · N2655H · Substantial damage - [NTSB LAX88LA139](https://openairdocs.org/ntsb/LAX88LA139.md): Luscombe 8F · Lompoc, CA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1988 · N1374B · Substantial damage > During the landing roll with a crosswind of 15-20 knots, the pilot lost control of the aircraft, collided with the terrain and, approximately 200 yards off the runway, the aircraft nosed over. - [NTSB LAX88LA138](https://openairdocs.org/ntsb/LAX88LA138.md): Piper PA-34-200T · Columbia, CA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1988 · N47766 · Substantial damage > At the end of a cross country flt, on touchdown, the acft began to bounce. The pilot was unable to stop the acft before it ran off the end of the rwy, where it came to rest after the left main gear collapsed. A witness said that the acft landed half way down… - [NTSB CHI88LA084](https://openairdocs.org/ntsb/CHI88LA084.md): Cessna 152 · Salem, IL · Accident · No injuries · Limited investigation · Final report · Mar 26, 1988 · N96010 · Substantial damage > While attempting to land with a quartering tailwind, the student experienced a loss of directional control and elected to G0-around. On climbout he was unable to maintain the proper rate of climb, and once out of ground effect the aircraft started to descend.… - [NTSB CHI88LA083](https://openairdocs.org/ntsb/CHI88LA083.md): Cessna 172N · Madison, WI · Accident · No injuries · Limited investigation · Final report · Mar 26, 1988 · N73954 · Substantial damage > The pilot was landing on the 40 foot wide rnwy in a 10-12 knot x-wind. He stated he had little rnwy reference in the dark night due to a very faded rnwy centerline. The acft ran off the hard surface into the mud, ran into a depression in the soil and nosed… - [NTSB CHI88LA077](https://openairdocs.org/ntsb/CHI88LA077.md): Cessna 172 · Mendota, IL · Accident · No injuries · Limited investigation · Final report · Mar 26, 1988 · N35407 · Substantial damage > During the landing roll, in gusty, crosswind conditions the upwind wing of the aircraft lifted and the aircraft experienced a noseover. - [NTSB BFO88LA032](https://openairdocs.org/ntsb/BFO88LA032.md): Dreyer-Starduster SA-300 · Richlands, VA · Accident · No injuries · Limited investigation · Final report · Mar 26, 1988 · N3LD · Substantial damage > After touchdown, during the landing roll, the acft veered sharply to the left. The plt attempted to correct this action by applying right rudder and the acft veered 45 degrees to the right. The acft traveled off the right side of the rwy and came to rest on… - [NTSB NYC88LA105](https://openairdocs.org/ntsb/NYC88LA105.md): Bell 206B · Agawam, MA · Accident · Minor injuries · Limited investigation · Final report · Mar 24, 1988 · N352BT · Destroyed > The pilot was on approach to landing from the south at about 2,000 yards from his pad. Speed was about 65 knots and was about 500 feet from the ground when the pilot said he had a flashback and doesn't remember what happened, the helicopter rolled over while… - [NTSB BFO88LA030](https://openairdocs.org/ntsb/BFO88LA030.md): Cessna 172 · New Cumberland, WV · Accident · No injuries · Limited investigation · Final report · Mar 24, 1988 · N1807Y · Substantial damage > The plt said that during the landing roll the brakes did not operate despite his continued application of pressure on the pedals. As the acft neared the rwy end he tried to swerve the acft left toward a runup pad. However, at the same time the r brake… - [NTSB ANC88LA040](https://openairdocs.org/ntsb/ANC88LA040.md): Piper PA-22 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Mar 23, 1988 · N3100Z · Substantial damage > After touchdown on a frozen lake, the aircraft rolled approximately 100 feet and at that point the pilot lost directional control and the aircraft nosed over on its back. - [NTSB DEN88LA085](https://openairdocs.org/ntsb/DEN88LA085.md): Bellanca 7GCAA · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Mar 22, 1988 · N8929 · Substantial damage > The CFI rated plt and his CFI rated passenger were practicing touch and go landings. The plt reported that the winds were light and variable. The plt reported that the tail wheel chattered during the last touchdown, and the aircraft swerved to the left. The… - [NTSB BFO88LA029](https://openairdocs.org/ntsb/BFO88LA029.md): Cessna 150G · Ridgeway, VA · Accident · No injuries · Limited investigation · Final report · Mar 22, 1988 · N6360S · Substantial damage > During touchdown the acft bounced and the student plt applied power to level-off and reflare. The left wing then rose and the right wing contacted the rwy. The acft bounced back and the left wing contacted the rwy. The nose gear collapsed and the acft came to… - [NTSB BFO88LA028](https://openairdocs.org/ntsb/BFO88LA028.md): Piper PA-28-140 · Chatham, VA · Accident · No injuries · Limited investigation · Final report · Mar 22, 1988 · N6587W · Substantial damage > The student plt was practicing touch and go landings when the accident occurred. He stated the acft was a little high and fast on final apch. On touchdown the acft veered left and traveled off the rwy. The left wing contacted a tree and the acft spun around… - [NTSB BFO88LA027](https://openairdocs.org/ntsb/BFO88LA027.md): Cessna 150L · Fairmont, WV · Accident · No injuries · Limited investigation · Final report · Mar 21, 1988 · N6763G · Substantial damage > According to the student plt, the acft crabbed to the left just prior to touchdown. Upon touchdown, the acft veered left and traveled off the rwy into muddy grass. Despite the plt's use of brakes and right rudder the acft continued down an embankment where it… - [NTSB SEA88LA064](https://openairdocs.org/ntsb/SEA88LA064.md): Marlow Hilyard Executive · Elko, NV · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 1988 · N5045J · Destroyed > The pilot made a landing on sloping terrain. The gyrocopter rolled to the left with the main rotor striking sage brush. The engine was twisted from its mounts rupturing a fuel line. A fire resulted consuming the gyrocopter. The pilot did not hold a pilot or… - [NTSB NYC88LA110](https://openairdocs.org/ntsb/NYC88LA110.md): Cessna 182RG · Princeton, NJ · Accident · No injuries · Limited investigation · Final report · Mar 20, 1988 · N738QK · Substantial damage > During landing at Princeton, new jersey, the flight encountered turbulence in the last 500 feet before reaching the runway. The pilot initiated a go around and came in with 10 degree flaps. Aircraft touched down and rolled a few feet then lifted off again… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=389 ## 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=388 --- 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.