# 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 437 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB LAX84FA483](https://openairdocs.org/ntsb/LAX84FA483.md): Bell 206B · Long Beach, CA · Accident · Minor injuries · Field investigation · Final report · Sep 17, 1984 · N7111J · Substantial damage > The acft experienced a power loss during flare for landing. The plt pulled collective to soften the touchdown from 30 ftagl but the landing was hard. Post accident examination of the engine showed a failure of the #1 turbine disc. Lab exam of the disc showed… - [NTSB ANC84LA179](https://openairdocs.org/ntsb/ANC84LA179.md): Cessna 140 · Middle River, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1984 · N90170 · Substantial damage > Plt stated right brake pressure was lost during landing roll. Acft veered off left side of rwy and contacted trees. Post accident testing revealed no evidence of a right brake failure or malfunction. - [NTSB ANC84FA182](https://openairdocs.org/ntsb/ANC84FA182.md): Cessna 152 II · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Sep 17, 1984 · N94491 · Substantial damage > The student plt was performing touch-and-go lndg practice. On the second lndg touchdown, the left wing dipped. The plt applied right aileron and the acft continued toward taxi lights. Plt applied left rudder to avoid taxi lights and acft headed toward another… - [NTSB MKC84FCD03](https://openairdocs.org/ntsb/MKC84FCD03.md): Schweizer SGU2-22E · Ames, IA · Accident · Serious injuries · Final report · Sep 16, 1984 · N9920J · Minor damage > The glider plt who had only about 1 hour flt time in this make of glider and less than a hour total glider time misjudged the wind and after drifting downwind was unable to make it back to the arpt. A forced landing was made off arpt in a farm field. - [NTSB CHI84LA392](https://openairdocs.org/ntsb/CHI84LA392.md): Piper PA-28-140 · Grand Rapids, MI · Accident · No injuries · Limited investigation · Final report · Sep 16, 1984 · N98017 · Substantial damage > In an effort to land at the threshold the acft collided with a fence and landed short of the prepared surface. Runway edge lights were operating but runway end identifier lights were not installed. - [NTSB ATL84LA281](https://openairdocs.org/ntsb/ATL84LA281.md): Piper PA-23-250 · Cheraw, SC · Accident · No injuries · Limited investigation · Final report · Sep 16, 1984 · N14217 · Substantial damage > According to the plt, after 100 to 150 ft of landing roll the right main landing gear collapsed. - [NTSB NYC84LA315](https://openairdocs.org/ntsb/NYC84LA315.md): Cessna 182Q · Laurel, MD · Accident · No injuries · Limited investigation · Final report · Sep 15, 1984 · N759RP · Substantial damage > With the northerly wind gusting to 22 KTS the acft landed aprx 4/10 the way down the rwy and bounced 3 times. An abort was initiated with power but the acft rolled off the end of the strip across a grass field and into a growth of small trees, nosing over… - [NTSB MKC84LA279](https://openairdocs.org/ntsb/MKC84LA279.md): Cessna 182D · Rolla, MO · Accident · No injuries · Limited investigation · Final report · Sep 15, 1984 · N9161X · Substantial damage > The plt tried to 'balloon' over a pack of dogs on the rwy and stalled the acft. The resulting hard landing failed the nose gear and damaged the firewall. - [NTSB MIA84LA254](https://openairdocs.org/ntsb/MIA84LA254.md): Cessna 152 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Sep 15, 1984 · N5348B · Substantial damage > The pilot stated to the chief of the FAA control tower at Key West int'l arpt after the accident that she 'porpoised' on landing, striking the nose gear and causing it to collapse. - [NTSB ANC84LA174](https://openairdocs.org/ntsb/ANC84LA174.md): Cessna T-207 · Daniels Creek, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1984 · N1540U · Substantial damage > Pilot stated that after landing 100 feet past the runway threshold, the aircraft appeared not to be stopping when brakes were applied. A go-around was initiated, but the aircraft failed to get airborne and ran off the departure end ofthe strip colliding with… - [NTSB LAX84LA480](https://openairdocs.org/ntsb/LAX84LA480.md): Focke-Wulf 44J Stieglitz · Hollister, CA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1984 · N638 · Substantial damage > The two commercial rated pilots were flying together for the purpose of gaining proficiency so that one of the plt's could pass his bfr. The one plt who was not current performed tree takeoffs and landings from the front seat. The plts then switched seats and… - [NTSB FTW84LA396](https://openairdocs.org/ntsb/FTW84LA396.md): Cessna 152 · Laporte, TX · Accident · No injuries · Limited investigation · Final report · Sep 14, 1984 · N24865 · Substantial damage > During the ldg flare the acft drifted left and touched down near the edge of the rwy. The plt did not correct the drift and the acft drifted off the left side of the rwy. After colliding with a ditch the acft nosed over coming to rest inverted. - [NTSB FTW84LA394](https://openairdocs.org/ntsb/FTW84LA394.md): Cessna 150 · Spicewood, TX · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1984 · N7709E · Destroyed > Despite the existence of an airstrip across the street from his home, the plt elected to takeoff & land on the street. During the landing, the acft hit several trees & a pump house. Local law enforcement officers reported that the plt was drunk and drinking… - [NTSB NYC84LA311](https://openairdocs.org/ntsb/NYC84LA311.md): Cessna 172P · White Plaines, NY · Accident · No injuries · Limited investigation · Final report · Sep 13, 1984 · N65719 · Substantial damage > The solo student plt stated that she was up set by a request from the tower to do a 360 deg turn on downwind and another acft in the pattern transmitting that the turn would put the 2 acft on a collision course. The turn was not completed and the plt… - [NTSB SEA84LA226](https://openairdocs.org/ntsb/SEA84LA226.md): Maule M6 · Driggs, ID · Accident · No injuries · Limited investigation · Final report · Sep 12, 1984 · N56526 · Substantial damage > After landing long and fast brakes were applied, directional control was lost and the acft ground looped off of the rwy. The acft collided with and came to rest in a ditch. - [NTSB FTW84LA390](https://openairdocs.org/ntsb/FTW84LA390.md): Fairchild M-62A (PT-19) · Melville, LA · Accident · No injuries · Limited investigation · Final report · Sep 12, 1984 · N46395 · Substantial damage > The student plt stated that the acft touched down long and bounced. He applied power to go-around and lost directional control colliding with a fence on the left side of the rwy. The wind was clam. - [NTSB NYC84LA309](https://openairdocs.org/ntsb/NYC84LA309.md): Cessna 172N · Gaithersburg, MD · Accident · No injuries · Limited investigation · Final report · Sep 11, 1984 · N5258E · Destroyed > Due to a left drifting tendency the solo student plt aborted the first landing. On touchdown for the second apch, the acft again veered left and continued off of the rwy colliding with a ditch. There were no mechanical malfunctons reported or discovered. - [NTSB MKC84LA274](https://openairdocs.org/ntsb/MKC84LA274.md): Gates Learjet LR-24D · Chesterfield, MO · Accident · No injuries · Limited investigation · Final report · Sep 11, 1984 · N45AJ · Substantial damage > The acft was landed in a thunderstorm with a 16 kt left quartering tailwind. The plt was aware of an area on the rwy which tended to collect water but due to heavy precipitation this area could not be viewed from the cockpit. The left main gear hydroplaned as… - [NTSB FTW84LA386](https://openairdocs.org/ntsb/FTW84LA386.md): Beech 95-B55 · Altus, OK · Accident · No injuries · Limited investigation · Final report · Sep 11, 1984 · N20148 · Substantial damage > According to the plt, with full flaps extended the acft encountered a windshear during the flare causing an excessive rate of descent on touchdown. Rwy contact collapsed the left main landing gear allowing the left wing to scrape on the rwy. Shortly before… - [NTSB SEA84LA224](https://openairdocs.org/ntsb/SEA84LA224.md): Cessna 182P · Deeth, NV · Accident · No injuries · Limited investigation · Final report · Sep 9, 1984 · N9893M · Substantial damage > When the aircraft descended below tree top height on final approach, the headwind vector was lost and the aircraft settled to a hard landing. During bounce recovery, the pilot added power but raised the flaps. The aircraft stalled and impacted the ground nose… - [NTSB FTW84LA410](https://openairdocs.org/ntsb/FTW84LA410.md): Piper PA-24 · Kerrville, TX · Accident · No injuries · Limited investigation · Final report · Sep 9, 1984 · N9128P · Substantial damage > Plt stated that after failing to get a 'gear down' light, he cycled gear with no success in obtaining a light and received no response to call on UNICOM frequency for visual check from ground. Plt stated he elected to land anyway and that nose gear collapsed… - [NTSB NYC84LA312](https://openairdocs.org/ntsb/NYC84LA312.md): Piper PA-38-112 · Ellendale, DE · Accident · No injuries · Limited investigation · Final report · Sep 8, 1984 · N2414L · Substantial damage > Due to high oil temp the solo student plt elected to make a precautionary landing. During the rollout a x-wind from the right resulted in the acft drifting left off the rwy. The left wing struck soy bean plants causing the acft to spin to the right collapsing… - [NTSB LAX84LA475](https://openairdocs.org/ntsb/LAX84LA475.md): Piper PA-28-140 · Show Low, AZ · Accident · Minor injuries · Limited investigation · Final report · Sep 8, 1984 · N6907W · Substantial damage > The acft porpoised during landing after the plt pushed the nose down as noted by a witness. The student plt was making alanding 1/2 way down the rwy after a go-around maneuver and pushed the nose down until the prop struck the rwy and the acft bounced. The… - [NTSB ATL84LA283](https://openairdocs.org/ntsb/ATL84LA283.md): Cessna 182B · Kannapolis, NC · Accident · No injuries · Limited investigation · Final report · Sep 8, 1984 · N7198E · Substantial damage > The plt reported that because of grnd fog in wilkersboro, NC, he diverted to Kannapolis, NC. Upon arriving over enochuille airport, he observed that grnd fog was present on the lake which is located adjacent to the arpt. Due to the fog, the plt elected to… - [NTSB MKC84LA278](https://openairdocs.org/ntsb/MKC84LA278.md): Cessna C-150M · Council Bluffs, IA · Accident · No injuries · Limited investigation · Final report · Sep 7, 1984 · N9282U · Substantial damage > Student plt departed on supervised solo flt. Later, instructor noted wind conditions at the airport had become unfavorable & advised plt by radio to divert to a specific alternate where winds conditions were favorable. Plt disregarded advice, proceeded to… - [NTSB MKC84LA270](https://openairdocs.org/ntsb/MKC84LA270.md): Piper PA-28-181 · Grain Valley, MO · Accident · No injuries · Limited investigation · Final report · Sep 6, 1984 · N21489 · Substantial damage > The landing gsar collapsed as a result of a hard landing in gusty wind conditions. Although the airport wind sock was tattered, sufficient wind information was available from fss and UNICOM to alert the pilot to the need for compensation on approach. The… - [NTSB MIA84LA250](https://openairdocs.org/ntsb/MIA84LA250.md): Piper PA-31-350 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Sep 6, 1984 · N4499B · Substantial damage > The coast guard was alerted to a ditched acft in the atlantic ocean near Marathon, FL. The CG found the wreckage of a PA-31 and 27 bales of marijuana in and around the wreckage. Two men in a life raft, whose cover was still in the acft, were arrested.… - [NTSB NYC84LA328](https://openairdocs.org/ntsb/NYC84LA328.md): Piper PA-32-300 · Providence, RI · Accident · No injuries · Limited investigation · Final report · Sep 5, 1984 · N15805 · Substantial damage > The acft landed hard. A 6120.1 plt/oper report was not filed by the plt. The plt was not injured in this accident but was fatally injured in an accident later the same month 09/84. - [NTSB NYC84LA304](https://openairdocs.org/ntsb/NYC84LA304.md): Piper PA-28R-200 · Monticello, NY · Accident · No injuries · Limited investigation · Final report · Sep 5, 1984 · N4363T · Substantial damage > According to the plt, he was flying instrument approaches to touch and go landings and neglected to extend the landing gear. The automatic gear extension system extended the left main gear before the acft landed. - [NTSB DEN84LA277](https://openairdocs.org/ntsb/DEN84LA277.md): Cessna 180 · West Jordan, UT · Accident · No injuries · Limited investigation · Final report · Sep 5, 1984 · N926OC · Substantial damage > According to the plt, at midfield during the landing roll a gust of wind from the west caught the right wing. The acft ground looped collapsing the left main landing gear and damaging the left wing. While the nearest wx observation facility reported wind from… - [NTSB CHI84LA382](https://openairdocs.org/ntsb/CHI84LA382.md): Grumman AA-5 · New Carlisle, OH · Accident · No injuries · Limited investigation · Final report · Sep 5, 1984 · N9596L · Substantial damage > The acft collided with trees after overrunning a 2000 ft wet sod airstrip. The plt reported that braking action was poorthe acft went into an evergreen tree nursery before stopping. - [NTSB ATL84LA280](https://openairdocs.org/ntsb/ATL84LA280.md): Piper PA-28-140 · Somerset, KY · Accident · No injuries · Limited investigation · Final report · Sep 5, 1984 · N4825T · Substantial damage > During a x-wind landing the acft veered off the left side of the rwy contacting a wind sock tower with the left wing. The plt reported the airspeed on final was excessive and an over compensation was made for the x-wind during the landing. The plt reported… - [NTSB ANC84LA155](https://openairdocs.org/ntsb/ANC84LA155.md): Piper PA-20 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Sep 5, 1984 · N3500A · Substantial damage > The acft ran off the rwy during landing. The plt said he lost control of the acft and went on the grass for about 40 ft. the rear seat had been removed for cargo. A 6 year old boy in the back of the acft was seated on top of rope and cans ofgas at the time of… - [NTSB SEA84LA219](https://openairdocs.org/ntsb/SEA84LA219.md): Bell 206 · Boulder City, NV · Accident · No injuries · Limited investigation · Final report · Sep 4, 1984 · N13ML · Substantial damage > The plt was landing at a helipad that was surrounded by a wire fence. He reported that as he was about to land, he misjudged his apch & the tail rotor struck the fence. Subsequently, the helicopter hit the ground while turning right & the gear collapsed. - [NTSB LAX84LA468](https://openairdocs.org/ntsb/LAX84LA468.md): Great Lakes 2T-1A-2 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Sep 4, 1984 · N3673L · Substantial damage > During the third touch & go landing the certificated plt receiving dual instruction was at the controls when directional control was temporarily lost. The CFI in the front cockpit regained control. Shortly thereafter the plt under instruction applied heavy… - [NTSB ATL84LA279](https://openairdocs.org/ntsb/ATL84LA279.md): Beech 58 · Laurens, SC · Accident · No injuries · Limited investigation · Final report · Sep 4, 1984 · N2047L · Substantial damage > The acft ran off the end of the rwy during landing. The plt reported that he started using brakes to stop the acft but it veered to the right. Examination by maintenance revealed that the left brake disc, p/n 164-06100, had failed at the mount flange. - [NTSB ANC84LA165](https://openairdocs.org/ntsb/ANC84LA165.md): Maule M-4-210C · Tok, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 1984 · N9820M · Substantial damage > The acft landed on an unimproved airstrip and the landing gear collapsed during the landing roll. The plt indicated he should have avoided the rough airstrip. - [NTSB NYC84LA298](https://openairdocs.org/ntsb/NYC84LA298.md): Beech A23-24 · Eagle Crest, DE · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N62AC · Substantial damage > After landing the plt used power to continue taxiing to the end of the wet grass rwy. Stopping distance was misjudged when braking began and the acft overran the rwy colliding with a small ditch. One main gear and the nose gear collapsed. - [NTSB MIA84LA246](https://openairdocs.org/ntsb/MIA84LA246.md): Rockwell 100-180 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N3639X · Substantial damage > Student plt stated that during landing roll, left brake failed and acft swerved into a ditch. Brakes had functioned satisfactorally during pre-takeoff taxi and run up. Investigation showed brake reservoir 1/2 full and left brake inoperative for undetermined… - [NTSB FTW84LA375](https://openairdocs.org/ntsb/FTW84LA375.md): Piper PA-38 · Midland, TX · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N2324A · Substantial damage > Both plts were practicing 180 degree power off 'spot' landings after hiatus from flying activity. Plt in left seat was at controls, undershot slightly and acft bounced on touchdown. Plt applied power for recovery from the bounced lndg but right seat plt also… - [NTSB CHI84LA381](https://openairdocs.org/ntsb/CHI84LA381.md): Ungerecht Q-2 · Appleton, WI · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N683SC · Substantial damage > After takeoff on the third flight of the new homebuilt aircraft the pilot smelled 'something hot' and noted a high cylinder head temp. During the subsequent precautionary landing the plt flared the acft 3-4 ft above the rwy resulting in a hard landing and… - [NTSB ANC84LA154](https://openairdocs.org/ntsb/ANC84LA154.md): Piper PA-18 · Kashwitna River, AK · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N7224K · Substantial damage > The plt said he was flying in a 'draw' doing some scouting for hunting when the terrain seemed to be rising faster than the acft was climbing. Without room to reverse course he elected to land on a River bank. Upon touchdown directional control was lost and… - [NTSB NYC84LA305](https://openairdocs.org/ntsb/NYC84LA305.md): Cessna 152 · Mitchellville, MD · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1984 · N757DZ · Substantial damage > The acft drifted right and collided with the terrain during the landing flare. A left x-wind gusting to 25 KTS was present at the time. - [NTSB MKC84LA268](https://openairdocs.org/ntsb/MKC84LA268.md): Cessna 172 M · Heber Springs, AR · Accident · No injuries · Limited investigation · Final report · Sep 2, 1984 · N80332 · Substantial damage > The acft ran off the side of the rwy into some brush and a ditch. The plt said the landing seemed normal until she applied the brakes and the acft veered to the right. The lift wheel brake was found to be worn after the accident. - [NTSB LAX84FUJ05](https://openairdocs.org/ntsb/LAX84FUJ05.md): Grumman American AA1 · Mesa, AZ · Accident · No injuries · Final report · Sep 2, 1984 · N6233L · Substantial damage > The acft went off the rwy during a landing in a 15-25 kt wind. The plt said a gust of wind swerved the acft off the rwy. The plt attempted a go-around but realized he could not make it in the dirt so he cut the throttle. The acft rolled intoa ditch and nosed… - [NTSB CHI84LA379](https://openairdocs.org/ntsb/CHI84LA379.md): Piper PA-28-161 · New Point, IN · Accident · No injuries · Limited investigation · Final report · Sep 2, 1984 · N82926 · Substantial damage > Following a crosswind landing on a narrow runway bordered by a corn crop on both sides, the acft rolled into an area where the x-wind was blocked by the corn. The plt failed to maintain directional control, caught a wing tip in the high corn and verred off… - [NTSB NYC84LA300](https://openairdocs.org/ntsb/NYC84LA300.md): Piper PA-24-260C · Montauk, NY · Accident · No injuries · Limited investigation · Final report · Sep 1, 1984 · N9485P · Substantial damage > According to the plt, after clearing sand dunes short of the rwy power was reduced for landing. The acft decelerated and descended, landing hard on the rwy. As the co-plt initiated an abort, the acft veered off the rwy to the right and collided with a tree.… - [NTSB MIA84LA244](https://openairdocs.org/ntsb/MIA84LA244.md): Mooney M20J · Key Largo, FL · Accident · No injuries · Limited investigation · Final report · Sep 1, 1984 · N1143Z · Substantial damage > Acft was landed downwind and touched down aprx half way down the rwy. The plt in an attempt to avoid an overrun intentionally ground looped the acft resulting in a left main gear collapse. - [NTSB ATL84LA278](https://openairdocs.org/ntsb/ATL84LA278.md): Head Balloons AX7-77 · Austell, GA · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1984 · N2484S · Destroyed > While flying at a low alt looking for a suitable landing area the plt noticed power lines at a higher alt. Plt initiallyapplied heat to the envelope to try and climb above the wires, but did not immediately realize the height of the wires. Plt then advised… - [NTSB ANC84LA161](https://openairdocs.org/ntsb/ANC84LA161.md): Piper PA-18-150 · Slana, AK · Accident · No injuries · Limited investigation · Final report · Sep 1, 1984 · N57617 · Substantial damage > The acft ran off of a narrow public road during landing. The plt said a gust of crosswind caught his right wing and turned the acft off the road into the bushes. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=438 ## 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=437 --- 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.