# 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 405 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB LAX87LA089](https://openairdocs.org/ntsb/LAX87LA089.md): Maule M-4-220C · Paradise, CA · Accident · No injuries · Limited investigation · Final report · Jan 18, 1987 · N40349 · Substantial damage > While practicing touch and goes, the pilot stated that on his last approach a considerable amount of crabbing to the right was required on final approach to runway 35. Upon touchdown the right wing lifted, the pilot turned the control wheel to the right and… - [NTSB NYC87LA060](https://openairdocs.org/ntsb/NYC87LA060.md): Piper PA-38-112 · Randolph, NH · Accident · Serious injuries · Limited investigation · Final report · Jan 17, 1987 · N2430G · Destroyed > Student pilot on a cross country instructional flight became disoriented, decided to return to departure airport. However seeing that he was running low on fuel looked for an airport to land to refuel and find out his location. He decided to make a… - [NTSB BFO87LA015](https://openairdocs.org/ntsb/BFO87LA015.md): Rockwell 500S · Lynchburg, VA · Accident · No injuries · Limited investigation · Final report · Jan 17, 1987 · N717AM · Substantial damage > After leaving clouds about 4500 feet MSL, the PIC made a visual approach to runway 03 at Lynchburg municipal. On short final the copilot stated that he noticed what seemed to be a gradual increase in pitch attitude while the aircraft was still too high off… - [NTSB SEA87LA047](https://openairdocs.org/ntsb/SEA87LA047.md): Cessna 150L · Deer Park, WA · Accident · Minor injuries · Limited investigation · Final report · Jan 15, 1987 · N10780 · Substantial damage > The plt reported the acft veered to the left during roll out on the snow covered runway. The acft contacted a frozen snow bank and flipped inverted. - [NTSB ATL87LA060](https://openairdocs.org/ntsb/ATL87LA060.md): Grumman AA-5A · Stockbridge, GA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1987 · N26900 · Substantial damage > During an attempted landing, the pilot lost directional control and veered off the right side of runway 29 and collided with a tree. The pilot reported that a gust of wind from the left resulted in the left wing rising about 7 feet. The pilot applied power… - [NTSB LAX87LA081](https://openairdocs.org/ntsb/LAX87LA081.md): Cessna T182 · Big Bear City, CA · Accident · No injuries · Limited investigation · Final report · Jan 11, 1987 · N6216N · Substantial damage > The plt rprtd that when the nose wheel touched down during the landing, a severe vibration began & the acft veered to the left. She said she pulled the yoke aft, but this had no response. Also, she said she applied brakes, but could not stop the acft or make… - [NTSB LAX87LA086](https://openairdocs.org/ntsb/LAX87LA086.md): Swearingen SA227-AC · Yuma, AZ · Accident · No injuries · Limited investigation · Final report · Jan 10, 1987 · N165SW · Substantial damage > The left main landing gear retracted after a normal landing and the aircraft swerved off the left side of the runway into the dirt. Crewmembers stated that they observed three green landing gear position lights prior to touch down and that, after the aircraft… - [NTSB MKC87LA038](https://openairdocs.org/ntsb/MKC87LA038.md): Cessna 152 · Forrest City, AR · Accident · No injuries · Limited investigation · Final report · Jan 8, 1987 · N68792 · Substantial damage > The student pilot was landing after one leg of a solo cross-country flight. The airplane ran off the right side of the runway and into a small drainage ditch. - [NTSB MIA87FA067](https://openairdocs.org/ntsb/MIA87FA067.md): Beech V-35 · Palm City, FL · Accident · 1 fatal · Field investigation · Final report · Jan 6, 1987 · N78BL · Destroyed > The acft was attempting to land on the southbound lane of a closed portion of interstate 95 & struck a large tree with the right wing, hit the ground, flipped over, came to rest inverted & was consumed by post crash fire. The police officers at the accident… - [NTSB SEA87LA043](https://openairdocs.org/ntsb/SEA87LA043.md): Champion Aeronca 7FC · Athol, ID · Accident · No injuries · Limited investigation · Final report · Jan 4, 1987 · N7547E · Substantial damage > The pilot lost control of the aircraft during landing with the aircraft veering to the left of the runway centerline. The plt then elected to go-around and on the go-around the aircrafts main gear caught on a snow berm causing a loss of control in flight. The… - [NTSB NYC87IA087](https://openairdocs.org/ntsb/NYC87IA087.md): Boeing 737-200 · Newark, NJ · Incident · Minor injuries · Incident investigation · Final report · Jan 4, 1987 · N409PE · No damage > During descent prior to the approach to Newark, NJ the B737 crew attempted to start the APU. The APU failed to start. During lndg roll another attempt to start the APU resulted in a fire warning light. The fire bottle was discharged but the fire warning… - [NTSB MIA87FA066](https://openairdocs.org/ntsb/MIA87FA066.md): Cessna 310-D · Lantana, FL · Accident · No injuries · Field investigation · Final report · Jan 4, 1987 · N656R · Substantial damage > The pilot flying in marginal weather requested radar assistance in landing at his destination. He was given a radar vector to a position on downwind and saw an uncontrolled airport under him. He landed on a closed runway that was marked closed due to… - [NTSB ATL87LA054](https://openairdocs.org/ntsb/ATL87LA054.md): Cessna 172M · Hartsville, SC · Accident · No injuries · Limited investigation · Final report · Jan 4, 1987 · N70493 · Destroyed > The student plt made two go-arounds before starting his third landing attempt with a variable wind. After touchdown the acft veered to the right and departed the rwy. The plt applied power in an attempt to take-off but the nose wheel hit a hole and the acft… - [NTSB NYC87LA053](https://openairdocs.org/ntsb/NYC87LA053.md): Cessna 180 · Goffstown, NH · Accident · Serious injuries · Limited investigation · Final report · Jan 1, 1987 · N9388C · Substantial damage > The Cessna 180 made a touch and go on a 2100 ft long runway. The touchdown was described as past the first third of the runway. There were two rated pilots and a passenger in the aircraft. The co-pilot thought the aircraft would be unable to clear powerlines… - [NTSB MIA87LA065](https://openairdocs.org/ntsb/MIA87LA065.md): Cessna 150H · Tchula, MS · Accident · No injuries · Limited investigation · Final report · Jan 1, 1987 · N22684 · Substantial damage > The plt stated that while attempting to land at a crop dusting strip he inadvertently landed off to the side of the runway in a plowed field, flipped over and came to rest inverted. - [NTSB SEA87LA040](https://openairdocs.org/ntsb/SEA87LA040.md): Piper PA-32-300 · Gates, OR · Accident · Minor injuries · Limited investigation · Final report · Dec 31, 1986 · N4116R · Destroyed > The plt was attempting to land the aircraft at night on an unlit grass airstrip. Prior to reaching the airstrip the plt collided with an apple tree. Both wings were severed from the aircraft and it went inverted before striking the ground in a slightly nose… - [NTSB CHI87LA059](https://openairdocs.org/ntsb/CHI87LA059.md): Cessna 172H · Mosinee, WI · Accident · No injuries · Limited investigation · Final report · Dec 30, 1986 · N3220L · Substantial damage > The CFI stated that while in the landing configuration, over the apch end of the rwy, the student excessively flared the acft and it stalled with the right wing contacting the rwy. According to the CFI, power was added but it was too late to 'save the… - [NTSB DEN87FA038](https://openairdocs.org/ntsb/DEN87FA038.md): Cessna 172N · Central, UT · Accident · Serious injuries · Field investigation · Final report · Dec 29, 1986 · N5153K · Substantial damage > The plt and 3 passengers were on a local sightseeing flt over the pine valley mountain range. The plt stated that he made three 360 deg turns to gain alt from 7500 ft to 9500 ft. he also stated that upon leveling at 9500 ft the eng began to lose pwr. Attempts… - [NTSB FTW87DRD02](https://openairdocs.org/ntsb/FTW87DRD02.md): Cessna A-188-B · Ft.Polk, LA · Accident · No injuries · Final report · Dec 28, 1986 · N49220 · Substantial damage > Examination revealed the tail wheel assembly was badly worn and its spacers were missing, causing the swivel mechanism to lock in the off center position. The aircraft landed on a narrow road. It veered slightly upon tail wheel contact and went off the… - [NTSB ATL87LA050](https://openairdocs.org/ntsb/ATL87LA050.md): Piper PA-28-181 · High Point, NC · Accident · No injuries · Limited investigation · Final report · Dec 27, 1986 · N8389C · Substantial damage > The plt landed on the wet turf/gravel rwy with a slight quartering tail wind. Rprtdly, the acft touched down about 1/3 of the way down the rwy with an airspeed of 4 to 9 KTS above the recommended speed. The plt was unable to stop on the remaining rwy &… - [NTSB MIA87LA059](https://openairdocs.org/ntsb/MIA87LA059.md): Piper PA-44 · Key West, FL · Accident · No injuries · Limited investigation · Final report · Dec 26, 1986 · N2197X · Substantial damage > Shortly after takeoff on an IFR flt, the flt lost all electrical power while in VFR conditions. The flt returned to the arpt and the plt completed the pre-landing checklist placing the gear handle in the down position. The gear, being electrically operated,… - [NTSB CHI87LA056](https://openairdocs.org/ntsb/CHI87LA056.md): Piper PA-38-112 · Madison, WI · Accident · No injuries · Limited investigation · Final report · Dec 26, 1986 · N4325E · Substantial damage > While practicing touch & go landings, the student plt reports, the acft 'suddenly dropped' resulting in a hard landing. The acft then porpoised separating the nose gear and skidding to a stop off the rwy. - [NTSB FTW87LA039](https://openairdocs.org/ntsb/FTW87LA039.md): Cessna 172M · Lindale, TX · Accident · No injuries · Limited investigation · Final report · Dec 25, 1986 · N12525 · Substantial damage > A private pilot substantially damaged his aircraft while attempting a landing on a grass strip in Lindale, TX. The pilot overshot the airstrip, and crashed in a field off the end of the runway. - [NTSB MIA87LA058](https://openairdocs.org/ntsb/MIA87LA058.md): Cessna 152 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Dec 24, 1986 · N65484 · Substantial damage > The acft skidded off the end of the wet grassy runway after touching down about midway down the rwy. The plt stated that in the future, all available rwy should be used. The plt received his private certificate just prior to the accident. - [NTSB DEN87LA033](https://openairdocs.org/ntsb/DEN87LA033.md): Cessna 172N · Nathrop, CO · Accident · Serious injuries · Limited investigation · Final report · Dec 23, 1986 · CGYDG · Substantial damage > The canadian registered acft, with a pvt plt and instructor rated pax and two paxs aboard, took off from canon city, CO, enroute to gunnison, CO, to refuel. This was a cross-country flt to allow the plt to build necessary flt time towards a commercial… - [NTSB MIA87LA055](https://openairdocs.org/ntsb/MIA87LA055.md): Maule M-7-235 · Ocala, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 22, 1986 · N151CD · Destroyed > The acft dragged a wing during lndg according to the plts statement. The acft came to rest beside the rwy. The plt said he lost control of the acft due to a fuel imbalance. After the accident the left wing tip tank was found full of fuel. According to the… - [NTSB MIA87LA053](https://openairdocs.org/ntsb/MIA87LA053.md): Cessna 150F · Tunica, MS · Accident · No injuries · Limited investigation · Final report · Dec 22, 1986 · N6907F · Substantial damage > The plt stated that during landing roll he lost control of the acft and it swerved off the right side of the rwy. The acft traveled into a plowed field and the nose gear collapsed. - [NTSB ANC87LA022](https://openairdocs.org/ntsb/ANC87LA022.md): Cessna 206 · Ruby, AK · Accident · No injuries · Limited investigation · Final report · Dec 22, 1986 · N734WE · Substantial damage > The pilot stated that during the landing roll on the frozen river, he lost control of the aircraft causing the aircraft to ground loop. - [NTSB NYC87DHA01](https://openairdocs.org/ntsb/NYC87DHA01.md): Piper PA-28-180 · Lehighton, PA · Accident · No injuries · Final report · Dec 21, 1986 · N54482 · Substantial damage > Student pilot with a certified flight instructor while on the landing roll encountered a crosswind. Directional control was lost the aircraft departed the runway causing substantial damage due coming to final rest in a ditch. - [NTSB CHI87DET01](https://openairdocs.org/ntsb/CHI87DET01.md): Pitts S1S · Warsaw, IN · Accident · No injuries · Final report · Dec 21, 1986 · N39XP · Substantial damage > According to the pilot after touchdown the right brake seemed to lock up with a 'skidding' noise as the aircraft left the runway. The pilot stated he was having difficulty keeping his toes off the brakes as he was attempting to maintain directional control.… - [NTSB SEA87LA038](https://openairdocs.org/ntsb/SEA87LA038.md): Cessna 172 · Yamhill, OR · Accident · No injuries · Limited investigation · Final report · Dec 20, 1986 · N739LH · Substantial damage > The plt was landing on a one way short narrow airstrip. He stated a gust of wind occurred just prior to touchdown. The aircraft then bounced and the plt added power. The aircraft then bounced several times and the nose gear collapsed. The aircraft then nosed… - [NTSB FTW87LA036](https://openairdocs.org/ntsb/FTW87LA036.md): Piper PA-34-220T · Lubbock, TX · Accident · No injuries · Limited investigation · Final report · Dec 20, 1986 · N8456X · Substantial damage > The plt stated that after a normal apch, he made a hard landing on the main gear and the acft bounced. He further stated that the second contact was hard on the main gear and that the nose gear collapsed when it touched down the 2nd time. Damage sustained by… - [NTSB FTW87LA034](https://openairdocs.org/ntsb/FTW87LA034.md): Cessna 150 · Arlington, TX · Accident · Minor injuries · Limited investigation · Final report · Dec 20, 1986 · N714LL · Substantial damage > A student pilot on solo flight in the local area of Arlington airport (F54) TX. Substantially damaged a Cessna 150 during a hard landing, breaking the nose gear and nosing over inverted. The pilot received minor injuries. - [NTSB DEN87IA031](https://openairdocs.org/ntsb/DEN87IA031.md): Beech C-99 · Albuquerque, NM · Incident · No injuries · Incident investigation · Final report · Dec 18, 1986 · N7212P · Minor damage > Mesa airline flt 114 was on a scheduled flt from Albuquerque to clovis, NM. Upon touchdown at clovis, the left landing gear began to collapse and a go-around was successful. The crew elected to return to Albuquerque where emerg equipment could stand by. After… - [NTSB MIA87LA049](https://openairdocs.org/ntsb/MIA87LA049.md): Christen Industries Pitts S-2B · Gulfport, MS · Accident · No injuries · Limited investigation · Final report · Dec 14, 1986 · N117CL · Substantial damage > The acft touched down at a high rate of speed with a left quartering tailwind at the halfway point on the 2700 ft rwy. The acft ran off of the right side of the rwy and the plt regained control getting the acft back onto the rwy. The acft then overran the end… - [NTSB DEN87LA028](https://openairdocs.org/ntsb/DEN87LA028.md): Cessna 152 · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Dec 14, 1986 · N4597L · Substantial damage > During landing, directional control was not maintained. The acft veered left, the landing gear entered a snowbank, and the acft nosed over. - [NTSB ATL87LA043](https://openairdocs.org/ntsb/ATL87LA043.md): Luscombe 8A · Morganton, NC · Accident · No injuries · Limited investigation · Final report · Dec 12, 1986 · N71966 · Substantial damage > Plt reptd doing LCL flying for about one hr after dept from pvt grass strip. Made apch and ldg at Morganton-lenoir apt. On touchdown plt reptd bouncing, and being unable to recover before lt main gear collapsed and lt wing dragged. Plt stated that he felt… - [NTSB MKC87LA031](https://openairdocs.org/ntsb/MKC87LA031.md): Cessna 180 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Dec 11, 1986 · N26DL · Substantial damage > During landing airplane ballooned due to wind gust. After touchdown. Airplane veered left and duirng pilot's correction, the left main landing gear leg broke off. Metallurgical evaluation revealed a previous fatigue failure in the fracture surface. - [NTSB LAX87LA060](https://openairdocs.org/ntsb/LAX87LA060.md): Mooney M20C · Michigan Bar, CA · Accident · No injuries · Limited investigation · Final report · Dec 9, 1986 · N5808Q · Substantial damage > During the flare, just prior to touchdown, a deer ran across the runway from the right and subsequently collided with the left wing of the aircraft. The pilot reported there was no time to avoid an impact. - [NTSB NYC87LA048](https://openairdocs.org/ntsb/NYC87LA048.md): Cessna 150 · Poestenkill, NY · Accident · No injuries · Limited investigation · Final report · Dec 6, 1986 · N50714 · Substantial damage > The pilot touched down hard, added power for a go around. Sluggish engine did not have enough power to clear trees at the end of the runway. Aircraft collided with trees. The plt after the acc said that after cutting off the carb head the eng seemed sluggish.… - [NTSB LAX87LA061](https://openairdocs.org/ntsb/LAX87LA061.md): Cessna 182Q · San Rafael, CA · Accident · No injuries · Limited investigation · Final report · Dec 6, 1986 · N759DH · Substantial damage > During an instructional flight, the student pilot was not aligned properly with the runway. The flight instructor (CFI) took control of the aircraft on final, but he stated that it did not respond when he applied rudder control. After touchdown, the aircraft… - [NTSB CHI87LA043](https://openairdocs.org/ntsb/CHI87LA043.md): Piper PA28-151 · Marquette, MI · Accident · No injuries · Limited investigation · Final report · Dec 6, 1986 · N41765 · Substantial damage > While on landing rollout the student pilot skidded off the left side of the runway and collided with a snowbank. The student stated he was holding excessive left rudder and brake pressure. - [NTSB NYC87DNC03](https://openairdocs.org/ntsb/NYC87DNC03.md): Aero Commander 680 · Barre, VT · Accident · No injuries · Final report · Dec 3, 1986 · N6375U · Substantial damage > Witness observed the acft touchdown about 2000 feet down 5001 foot rwy. The rwy was reported wet and icy in spots at the north end only. The acft overran the rwys end and went down into a ravine about 25 ft below rwy level. There was no indication of… - [NTSB ANC87LA017](https://openairdocs.org/ntsb/ANC87LA017.md): Cessna 185 · Skwentna, AK · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 1986 · N6992N · Substantial damage > The pilot lost directional control of the aircraft on touchdown. Examination of the brake system revealed the left brake was frozen. - [NTSB DEN87LA027](https://openairdocs.org/ntsb/DEN87LA027.md): Cessna 152A · Great Falls, MT · Accident · No injuries · Limited investigation · Final report · Dec 2, 1986 · N4784A · Substantial damage > The student plt was cleared to make a touch-&-go landing on rwy 21. As he was lndg, he noticed the arresting barrier (cable) was raised. He added full pwr & pulled back on the yoke to avoid hitting the cable. The acft lifted off, but its tail hit the cable.… - [NTSB CHI87IA039](https://openairdocs.org/ntsb/CHI87IA039.md): Douglas DC-9-51 · Madison, WI · Incident · No injuries · Incident investigation · Final report · Dec 2, 1986 · N786NC · Minor damage > Aircraft slid off the right side the runway during the rollout from a cross wind landing and struck 6 runway edge lights causing minor damage to the inboard trailing edge of the right flap. At the time of the incident there was 1/2 inch of snow on the runway… - [NTSB NYC87DFA02](https://openairdocs.org/ntsb/NYC87DFA02.md): Schweizer SGS 2-33A · Wurtsboro, NY · Accident · No injuries · Final report · Nov 30, 1986 · N1222S · Substantial damage > The pilot was landing a Schweizer SGS-233 when he started to get into a pilot induced oscillation. The oscillations increased and the aircraft impacted in a nose low attitude. The pilot said the accident could have been prevented with less control input,… - [NTSB LAX87LA056](https://openairdocs.org/ntsb/LAX87LA056.md): Pitts Special S1-D · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Nov 29, 1986 · N365A · Substantial damage > At the end of a local pleasure flight, the aircraft ground looped while the pilot was turning off of runway 7R onto a high speed taxiway. The pilot reported that near the end of the landing roll, he tapped the brakes lightly in preparation to turn when the… - [NTSB DEN87LA026](https://openairdocs.org/ntsb/DEN87LA026.md): Beech A23-24 · Vernal, UT · Accident · No injuries · Limited investigation · Final report · Nov 29, 1986 · N5996S · Substantial damage > The plt attempted to land on a dirt road near two oil rigs. He said he made several low passes to view the road surface. During the landing roll, the wheels of the acft dug into the soft surface. A loss of control occurred which resulted in the acft traveling… - [NTSB CHI87DER01](https://openairdocs.org/ntsb/CHI87DER01.md): Cessna 185D · St. Paul, MN · Accident · No injuries · Final report · Nov 29, 1986 · N1502F · Substantial damage > During landing after the skis had touched down the acft began to swerve. As the acft left the rwy the plt attemtped a go-around, however, one ski dug into the ground and the acft flipped over onto it's back. Post accident exam revealed the right ski had… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=406 ## 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=405 --- 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.