# 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 425 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB FTW85FA282](https://openairdocs.org/ntsb/FTW85FA282.md): Aerospatiale AS-350D · Matagorda Islng, LA · Accident · 1 fatal · Field investigation · Final report · Jul 11, 1985 · N3594N · No damage > The acft touched down hard during an attempted autorotation to an abandoned air base. Initial touchdown occurred on the stinger and the acft yawed to the left of rwy heading 30 to 40 degrees. The next touchdown was on the skids and the acft yawed further to… - [NTSB ANC85FA125](https://openairdocs.org/ntsb/ANC85FA125.md): Cessna 152 · Big Lake, AK · Accident · No injuries · Field investigation · Final report · Jul 11, 1985 · N93180 · Substantial damage > The glider plt was in training for a single eng land rating & was indorsed for solo flt. During her training, she & her instructor plt had landed at the Big Lake arpt. She thought that that was her approval to land there solo. However, there were sandy soft… - [NTSB CHI85LA281](https://openairdocs.org/ntsb/CHI85LA281.md): Cessna 152 · Rochester, MN · Accident · No injuries · Limited investigation · Final report · Jul 10, 1985 · N69037 · Substantial damage > The student pilot on first solo x-country was ld on the 7500 ft runway. Tower had cautioned on wake turbulance from departing DC-9. On flare sp said acft dropped in swerved left, cartwheeled and nosed down. - [NTSB CHI85LA273](https://openairdocs.org/ntsb/CHI85LA273.md): Cessna 152 · Almont, MI · Accident · No injuries · Limited investigation · Final report · Jul 10, 1985 · N66944 · Substantial damage > The student plt stated that during touchdown the acft bounced back into the air. On the second touchdown, the acft swerved to the left and departed the rwy. It then rolled until the left wing struck a small tree, causing substantial damage to that wing. The… - [NTSB ANC85LA122](https://openairdocs.org/ntsb/ANC85LA122.md): Taylorcraft DF-65 · Eklutna, AK · Accident · No injuries · Limited investigation · Final report · Jul 10, 1985 · N47757 · Substantial damage > Acft landed hard, collapsing both main landing gear after making a steep apch to a short area on a gravel road. Plt was landing to drain some acft fuel out in order to get better climb performance for a mountain sightseeing flight. - [NTSB SEA85LA159](https://openairdocs.org/ntsb/SEA85LA159.md): Cessna 150 · La Grande, OR · Accident · No injuries · Limited investigation · Final report · Jul 9, 1985 · N1749 · Substantial damage > This was the student pilot's second solo flight. He had a total time of less than 9 hours. A bounced landing occurred and the student was unable to make an adequate recovery. A witness who saw the accident stated that the aircraft started a climb out with… - [NTSB ATL85LA206](https://openairdocs.org/ntsb/ATL85LA206.md): Piper PA-24-250 · Peachtree City, GA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1985 · N7474P · Destroyed > According to the pilot, he forgot to extend the landing gear. He stated most of his flight time had been in fixed gear aircraft. On this flight he had been told by his instructor to work on smoothing his radio technique on the second landing of the flight he… - [NTSB FTW85LA279](https://openairdocs.org/ntsb/FTW85LA279.md): Cessna 150L · Killeen, TX · Accident · No injuries · Limited investigation · Final report · Jul 7, 1985 · N5321Q · Substantial damage > The student pilot failed to properly flare the aircraft and touched down hard on the nose gear. This caused the aircraft to start porpoising from which recovery was not made. Aircraft continued to bounce until the nose gear collapsed. It then slid to a stop,… - [NTSB FTW85LA277](https://openairdocs.org/ntsb/FTW85LA277.md): Cessna R182 · Midland, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1985 · N1739R · Substantial damage > The plt stated that on a pass over the pvt strip the wind sock as indicating the wind out of the north. In actuality, Midland regional arpt was reporting the winds from 110 degs at 13 KTS. Touchdown was made at a higher than normal airspeed. The acft landed… - [NTSB DEN85FQG01](https://openairdocs.org/ntsb/DEN85FQG01.md): Rolladen-Schneider LS-4 · Tatum, NM · Accident · Serious injuries · Final report · Jul 7, 1985 · N4203Y · Substantial damage > The plt stated that 7 miles sw of Tatum, NM, an area of 'sink' was encountered and insufficient alt remained to glide to the Tatum arpt. An apch was then made (into the sun) for a landing in a fld. During the landing flare, the plt noticed a row of fence… - [NTSB CHI85LA277](https://openairdocs.org/ntsb/CHI85LA277.md): Burch Pitts S-1 · Houghton Lake, MI · Accident · No injuries · Limited investigation · Final report · Jul 7, 1985 · N42RB · Substantial damage > The acft nosed down following a ground loop during a landing roll. The plt reported the tailwheel began to shimmy, directional control of the acft was lost and it ground looped to the right. The acft traveled aprx 10 ft off the rwy where the left wing dug… - [NTSB LAX85LA312](https://openairdocs.org/ntsb/LAX85LA312.md): Piper PA-34-200T · Saline Valley, CA · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N29461 · Substantial damage > During a pleasure flight the plt observed a slight lt eng fuel pressure fluctuation. Previously, a similar fluctuation to the rt eng revealed the presence of a leaking fuel line. Fearing fire because of a suspected fuel leak to the lt eng, the plt elected to… - [NTSB FTW85LA272](https://openairdocs.org/ntsb/FTW85LA272.md): Cessna T-210 · Knippa, TX · Accident · Minor injuries · Limited investigation · Final report · Jul 6, 1985 · N5473C · Substantial damage > The new owner was attempting takeoff from a dirt road obstructed by a mobile irrigation system. He pulled the acft off the ground after 1700 feet of takeoff roll. Unable to maintain flying speed, he landed in a soft fld and the acft nosed over when the nose… - [NTSB DEN85LQA02](https://openairdocs.org/ntsb/DEN85LQA02.md): Cessna 152 · Santa Teresa, NM · Accident · No injuries · Final report · Jul 6, 1985 · N5372B · Substantial damage > The helcopter plt was on a solo instructional flt in the Cessna 152 airplane. He had only 9 hrs flt time in fixed wing acft. While on a touch-&-go landing, the acft bounced as it touched down. It then bounced 2 more times with each bounce becoming… - [NTSB ANC85LA127](https://openairdocs.org/ntsb/ANC85LA127.md): Piper J-3 · Tyrone Creek, AK · Accident · No injuries · Limited investigation · Final report · Jul 6, 1985 · N38471 · Substantial damage > The plt delayed initiating an aborted landing, and the acft rolled into water at the end of the rwy where it nosed over. - [NTSB NYC85LA161](https://openairdocs.org/ntsb/NYC85LA161.md): Cessna 152II · Ebensburg, PA · Accident · No injuries · Limited investigation · Final report · Jul 5, 1985 · N45946 · Substantial damage > The student plt was practicing takeoffs and landings when the acft traveled off the left side of the rwy during the fourth landing. Once off the rwy, the acft traveled into a construction area where it nosed over. - [NTSB BFO85LA055](https://openairdocs.org/ntsb/BFO85LA055.md): Cessna 172M · Hagerstown, MD · Accident · No injuries · Limited investigation · Final report · Jul 5, 1985 · N12740 · Substantial damage > The recently certificated instructor was performing touch and go landings with a paraplegic student, who used a hand control for rudder operation. On the third landings the acft veered to the right and the CFI took control of the acft. The student pilot… - [NTSB MKC85LA149](https://openairdocs.org/ntsb/MKC85LA149.md): Cessna 210 · Eldon, MO · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N6939N · Substantial damage > The plt reported that during an apch to land, he forgot to extend the landing gear & landed with the gear retracted. He did not recall hearing the gear warning horn; however, a check of the landing gear sys did not reveal any malfunction. - [NTSB MKC85LA147](https://openairdocs.org/ntsb/MKC85LA147.md): Piper PA-32-300 · Point Lookout, MO · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N8654N · Substantial damage > While landing at dusk, the acft touched down hard & both main gear collapsed rearward. A wing fuel tank was punctured, but no fire erupted. - [NTSB LAX85LA306](https://openairdocs.org/ntsb/LAX85LA306.md): Cessna 421A · San Diego, CA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N222CF · Substantial damage > During landing roll out the right main gear collapsed in an outward direction. Exam of the rt gear revealed that the bolt which is associated with the upper & lower gear torque links was missing. An exam of the left gear assembly revealed that the required… - [NTSB FTW85LA301](https://openairdocs.org/ntsb/FTW85LA301.md): Cessna 182M · Tulia, TX · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N71846 · Substantial damage > The student plt, with 2 hrs total night experience, flared high on final and stalled the acft, which subsequently landed hard on the nose gear, during a night practice flt. The plt stated that the red instrument lights would not work when he turned them on.… - [NTSB FTW85LA275](https://openairdocs.org/ntsb/FTW85LA275.md): Luscombe T8F · Frederick, OK · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N1580B · Substantial damage > The plt stated his foot slipped off the right rudder pedal which allowed the acft to veer left off the rwy. The acft hit a ditch and flipped over. FAA coordinator confirmed initial notification of substantial damage to the acft. - [NTSB CHI85LA270](https://openairdocs.org/ntsb/CHI85LA270.md): Cessna 310D · Carbondale, IL · Accident · No injuries · Limited investigation · Final report · Jul 4, 1985 · N1729K · Substantial damage > The acft was landing at dest arpt after a two hr xcountry flt. At gear ext no green light. Pilot recycled gear but still no light. Emergency ext used and three green indicated. On ld roll nose gear collapsed. Uplock arm tube was broken on the nose gear. - [NTSB DEN85LA178](https://openairdocs.org/ntsb/DEN85LA178.md): Cessna R172K · Leadville, CO · Accident · No injuries · Limited investigation · Final report · Jul 3, 1985 · N736XN · Substantial damage > During the landing roll on rwy 34, a deer ran in front of the acft. The deer was struck and killed by the right wing strut. - [NTSB CHI85LA267](https://openairdocs.org/ntsb/CHI85LA267.md): Piper PA-28-200 · New Richmond, WI · Accident · Minor injuries · Limited investigation · Final report · Jul 3, 1985 · N33006 · Substantial damage > The acft veered to the rt & hit a rwy marker during the attempted go-around. The wind was from 210 degrees at 19 KTS gusting to 27 KTS. The plt said that if the marker had been 'break-away' plastic the damage would have been negliable. - [NTSB ATL85LA204](https://openairdocs.org/ntsb/ATL85LA204.md): Balloon Works Firefly 7 · Owensboro, KY · Accident · Serious injuries · Limited investigation · Final report · Jul 3, 1985 · N1534C · Substantial damage > Pilot launched Balloon from college campus with two pax. Flew for 35 minutes. During flight he radioed ground crew which was at landing site. During descent pilot saw utility wires previously unnoticed. Parachute was ventd to increase descent rate and avoid… - [NTSB MKC85LA158](https://openairdocs.org/ntsb/MKC85LA158.md): Cessna 152 · Corning, AR · Accident · No injuries · Limited investigation · Final report · Jul 2, 1985 · N96092 · Destroyed > The student plt became disoriented while on a solo cross country flt. When the acft became low on fuel the plt decided to land on a plowed fld. The fld was soft and the acft nosed over shortly after touchdown. - [NTSB LAX85LA302](https://openairdocs.org/ntsb/LAX85LA302.md): Meyers OTW · Winters, CA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1985 · N23799 · Substantial damage > The purpose of this flt was to check out a commercial plt in the acft. Dual flt controls & heel brakes were installed. The student was practicing landings & on his 4th or 5th landing roll, the acft began to turn to the right. The student applied left rudder &… - [NTSB LAX85LA298](https://openairdocs.org/ntsb/LAX85LA298.md): Beech 95-B55 · Thermal, CA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1985 · N18387 · Substantial damage > At the conclusion of a cross country business flt, the plt stated that after 'easing the nosewheel down onto the runway' he reached for the flap lever but put his hand 'on the gear lever instead.' As he 'pulled the lever out of the detent tripping it,' the… - [NTSB ATL85LA202](https://openairdocs.org/ntsb/ATL85LA202.md): Beech 95-B55 · Alma, GA · Incident · No injuries · Limited investigation · Final report · Jul 1, 1985 · N1793W · Minor damage > The acft was lndd with the gear retracted during, practice touch & go landings. The plt was a FAA flight test engineer. The plt stated that the gear collapsed on touchdown; however, examination of the landing gear system failed to reveal a system malfunction. - [NTSB NYC85LA142](https://openairdocs.org/ntsb/NYC85LA142.md): Cessna 152 · Hartford, CT · Accident · No injuries · Limited investigation · Final report · Jun 30, 1985 · N48251 · Substantial damage > The acft nosed over following a loss of control during landing. The student plt stated the acft bounced three times on touchdown. The propeller then contacted the rwy and the acft nosed over. - [NTSB LAX85LA300](https://openairdocs.org/ntsb/LAX85LA300.md): Helio H-250 · Imperial, CA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1985 · N55XV · Substantial damage > This plt executed a full flap 40 mph landing. After touchdown the left main landing gear lifted off the rwy, & the plt was not able to lower it using rudder, brakes, & aileron control. No attempt was made o use power to regain directinal control as the acft… - [NTSB FTW85LA268](https://openairdocs.org/ntsb/FTW85LA268.md): Sikorsky S-76 · Eugene Island · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1985 · N5404Y · Substantial damage > The plt had landed on the offshore heliport in the gulf of Mexico. The S76 helicopter rolled backward on the platform with the helicopter tilting to its right. The coplt exited the acft and found the right main gear wheel off the platform and into the deck… - [NTSB CHI85LA256](https://openairdocs.org/ntsb/CHI85LA256.md): Richard E. Rowland Cassutt III M · Kankakee, IL · Accident · Minor injuries · Limited investigation · Final report · Jun 28, 1985 · N32RR · Substantial damage > On landing the homebuilt tailwheel acft, the pilot lost directional control, struck a ditch and flipped over on the acft's back resulting in substantial damage to the acft. - [NTSB ANC85LA116](https://openairdocs.org/ntsb/ANC85LA116.md): Piper J-3/100 · Port Lions, AK · Accident · No injuries · Limited investigation · Final report · Jun 28, 1985 · N22AK · Substantial damage > The plt lost directional control of the acft during a touch and go landing. The acft veered off the rwy and contacted boulders. The plt reported to bystanders at the accident site that it had been a long time since he had flown an acft equipped with heel… - [NTSB ANC85LA110](https://openairdocs.org/ntsb/ANC85LA110.md): Piper PA-20 · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Jun 28, 1985 · N3459Z · Substantial damage > The plt reported that by the time he had returned to the arpt, the wind velocity had increased to 18 KTS. During the landing, he lost directional control & the acft ground looped & was damaged. - [NTSB ATL85LA192](https://openairdocs.org/ntsb/ATL85LA192.md): Grumman G-164 · Ashford, AL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1985 · N609U · Substantial damage > The plt was returning to the private ag strip after completing a spray run. During the landing the pilot found that the left brake was inop. In order to prevent running off end of the 1500 ft rwy, the plt elected to ground loop the aircraft. During the… - [NTSB MIA85LA200](https://openairdocs.org/ntsb/MIA85LA200.md): Piper PA-28-160 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Jun 26, 1985 · N5744W · Substantial damage > The student plt had been practicing touch and go landings. On his third landing, he permitted too steep an apch and the nose gear contacted the rwy prior to the main gear. A porpoising action then developed which was not arrested prior to failure of the nose… - [NTSB CHI85LA262](https://openairdocs.org/ntsb/CHI85LA262.md): Cessna 182A · Davison, MI · Accident · No injuries · Limited investigation · Final report · Jun 26, 1985 · N5970B · Substantial damage > Acft touched donw hard and became airborne. On the second ground contact the nose gear collapsed. Plt previously aborted two landings because of excessive airspeed. - [NTSB CHI85LA254](https://openairdocs.org/ntsb/CHI85LA254.md): Bell 47G-4 · Lakeville, MN · Accident · No injuries · Limited investigation · Final report · Jun 26, 1985 · N3094G · Substantial damage > The acft was being landed on a trailer for transportation. Upon touchdown the right skid hooked on the landing guides and the helicopter rolled to the right side. The main rotor blades struck the ground, the left fuel tank ruptured and an explosion and fire… - [NTSB MIA85LA199](https://openairdocs.org/ntsb/MIA85LA199.md): Piper PA-24-250 · Opa Locka, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1985 · N9165P · Substantial damage > The plt was landing after a x-country flt when the right wing & the prop contacted the rwy. The plt stated that the gear had collapsed during a go-around. However, the landing gear was intact, except for impact damage on the right main gear. No gear… - [NTSB LAX85LA291](https://openairdocs.org/ntsb/LAX85LA291.md): Cessna 180 · Murrieta, CA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1985 · N2451F · Substantial damage > At the conclusion of a personal cross country flight, the pilot stated he made a hard landing after which, the aircraft got away from him and ground looped. - [NTSB LAX85LA289](https://openairdocs.org/ntsb/LAX85LA289.md): Piper PA-24-250 · Lincoln, CA · Accident · No injuries · Limited investigation · Final report · Jun 24, 1985 · N5916P · Destroyed > During arrival at dusk, the plt attempted to lower the landing gear, but did not observe a gear dowm light indication. He recycled the gear several times, then utilized the emergency gear extention sys. He stated that when he used the extention sys, he… - [NTSB DEN85LA174](https://openairdocs.org/ntsb/DEN85LA174.md): Piper PA-22-150 · Glen Canyon, UT · Accident · No injuries · Limited investigation · Final report · Jun 24, 1985 · N4547A · Substantial damage > The plt became lost/disoriented near the end of a x-country flt from west jordan to blanding, Utah. When fuel quantity became low, the plt decided to make a precautionary landing on a dirt road. During the landing falre, a x-wind gust drifted the acft to the… - [NTSB DEN85LA171](https://openairdocs.org/ntsb/DEN85LA171.md): Cessna 172 · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Jun 24, 1985 · N65184 · Substantial damage > On June 23, 1985, a student plt flying a C-172 departed the side of the rwy whole landing at Gallup, NM. He said that the landing was made at too high an airspeed. Upon departing the rwy the acft proceeded into a ditch causing substantial damage. - [NTSB MKC85LA140](https://openairdocs.org/ntsb/MKC85LA140.md): Cessna 152 · St. Charles, MO · Accident · No injuries · Limited investigation · Final report · Jun 23, 1985 · N67509 · Substantial damage > The student plt was on her 1st solo flt. She said that during a landing, she flared too hi & the acft bounced. A porpoise developed & the nose gear failed. About 11 mi southeast at the lambert-st louis arpt, the 1048 CDT wind was from 240 deg at 12 KTS. - [NTSB MKC85LA139](https://openairdocs.org/ntsb/MKC85LA139.md): Piper PA-38-112 · Sheldon, IA · Accident · No injuries · Limited investigation · Final report · Jun 23, 1985 · N6209A · Substantial damage > The student plt was on a solo x-country flight. After the nose wheel touched down on landing, the acft veered left, went into a corn field & nosed over. The plt stated that he may have let the nose wheel contact the rwy before he neutralized the rudder… - [NTSB MKC85LA138](https://openairdocs.org/ntsb/MKC85LA138.md): Piper PA-30 · Manhattan, KS · Accident · No injuries · Limited investigation · Final report · Jun 23, 1985 · N7012Y · Substantial damage > The plt said he put the landing gear selector switch to the down position and thought that he observed a green, down andlocked indicator light; however, the acft landed with the gear retracted. Examination of the acft after the accident revealed that the… - [NTSB CHI85LA252](https://openairdocs.org/ntsb/CHI85LA252.md): Beech BE-19A · Appleton, WI · Accident · No injuries · Limited investigation · Final report · Jun 23, 1985 · N6056N · Substantial damage > The left main landing gear collapsed following a loss of directional control during landing. The landing was made on rwy 21 with winds from 240 degs at 18 KTS gusting to 30 KTS. The plt reported the acft drifted left during the landing and side loads on the… - [NTSB CHI85LA250](https://openairdocs.org/ntsb/CHI85LA250.md): Cessna 172P · Lancaster, OH · Accident · No injuries · Limited investigation · Final report · Jun 23, 1985 · N96570 · Substantial damage > The acft collided with a fence during landing the wind was from 230 degrees at 14 KTS and the landg was on rwy 28 the plt said that may be she would have had better control with less than full flaps. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=426 ## 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=425 --- 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.