# 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 411 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB MIA86IA211](https://openairdocs.org/ntsb/MIA86IA211.md): Beech D18S · Ft. Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · Jul 17, 1986 · N76Q · Minor damage > Flight experienced collapse of the right main landing gear during landing roll when the bolt which attaches the upper end of the drag leg failed in fatigue. Company maintenance personnel did not remove this bolt regularly for inspection. Beech aircraft… - [NTSB DEN86LA201](https://openairdocs.org/ntsb/DEN86LA201.md): Goertz Bushby Musting II · Ruidoso, NM · Accident · No injuries · Limited investigation · Final report · Jul 17, 1986 · N976J · Substantial damage > N976J landed on rwy 18, which is 5,500 ft long and 75 wide and has a concrete surface. The wind was from 210 deg at 10 with gusts to 20 KTS. The plt reports that the crosswind caused a swerve to the right and the acft ran off the right side of the rwy. The… - [NTSB LAX86FA293](https://openairdocs.org/ntsb/LAX86FA293.md): Burkhart Grob A103 Twin II · Sun City, AZ · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1986 · N5448E · Substantial damage > The newly certificate sailplaned pilot had taken a friend for a sightseeing flight. On the return the pilot made a normal approach and landing, then veered off the left side of the runway and struck a large saguaro cactus. The cactus toppled and fell across… - [NTSB NYC86LA181](https://openairdocs.org/ntsb/NYC86LA181.md): Cessna 172L · Westerly, RI · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 1986 · N4301Q · Substantial damage > The plt rprtd he landed in winds which were gusting to 20 KTS. As the acft touched down, it ballooned & the plt applied some power to maintain control. As he contd the landing, the acft began to drift to the left. The plt attempted a go-around, but he was… - [NTSB NYC86LA180](https://openairdocs.org/ntsb/NYC86LA180.md): Cessna 172 · Kingston, NY · Accident · Minor injuries · Limited investigation · Final report · Jul 14, 1986 · N54946 · Destroyed > The student plt was on his 1st solo flt. After a go-around, his next apch was good until the acft encountered a gust of wind just before touchdown. Subsequently, the acft landed hard (hit on rear section), veered off the rwy & nosed over. - [NTSB CHI86LA175](https://openairdocs.org/ntsb/CHI86LA175.md): Piper PA-28R-201 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Jul 14, 1986 · N31588 · Substantial damage > The pilot was unable to get a down and locked indication for the left main gear and upon touchdown the left gear collapsed. Inspection revealed an internal failure of the left main actuator. The fluid had leaked past the o-rings and prevented the gear from… - [NTSB ANC86LA106](https://openairdocs.org/ntsb/ANC86LA106.md): Cessna 207 · Ekuk, AK · Accident · No injuries · Limited investigation · Final report · Jul 14, 1986 · N1704U · Substantial damage > The pilot stated that during the approach to landing, the aircraft struck a tree stump short of the approach end of the runway. - [NTSB SEA86LA169](https://openairdocs.org/ntsb/SEA86LA169.md): Cessna 170B · Roche Harbor, WA · Accident · No injuries · Limited investigation · Final report · Jul 13, 1986 · CFILT · Substantial damage > The plt lost directional control of the aircraft during landing rollout with a crosswind. The aircraft drifted to the left of the runway at which time the plt applied full aft elevator, full right rudder and full right aileron. The plt reported the acft made… - [NTSB LAX86LA291](https://openairdocs.org/ntsb/LAX86LA291.md): Enstrom EN-280-C · Los Altos, CA · Accident · No injuries · Limited investigation · Final report · Jul 13, 1986 · N5692P · Substantial damage > The instructor stated that during a practice auto rotative landing the helicopter lost rotor RPM and a hard landing followed. On ground contact, the main rotor blades struck the tail cone, resulting in substantial damage. The instructor further stated that… - [NTSB DEN86LA196](https://openairdocs.org/ntsb/DEN86LA196.md): Beech 95-B55 · Fargo, ND · Accident · No injuries · Limited investigation · Final report · Jul 13, 1986 · N67297 · Substantial damage > The plt said that he activated the landing gear retraction switch during the landing roll. The gear retracted causing the acft to settle on the rwy. - [NTSB MIA86LA207](https://openairdocs.org/ntsb/MIA86LA207.md): Cessna 150E · Wakulla Springs, FL · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N6234T · Substantial damage > The plt stated that while on final approach, the airspeed was too fast. When the acft touched down it began to porpoise, he lost control and the acft flipped over and came to rest inverted. - [NTSB MIA86LA206](https://openairdocs.org/ntsb/MIA86LA206.md): Cessna 195A · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N2187C · Substantial damage > The plt stated that the left main gear collapsed while he was trying to recover from a 45 degree swerve to the right during lanidng. - [NTSB MIA86LA205](https://openairdocs.org/ntsb/MIA86LA205.md): Cessna R182 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N9119C · Substantial damage > After the plt applied carb heat during the approach sequence, he became concerned about roughness in the eng. At about that same time, the tower cleared him to land behind another acft; however, at 1st, he did not have the other acft in sight & spent several… - [NTSB DEN86LA185](https://openairdocs.org/ntsb/DEN86LA185.md): Cessna 182P · New Castle, CO · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1986 · N78764 · Substantial damage > Plt attempted to abort landing while on short final with 40 degrees of flaps. Plt decided that he would not clear trees at the FAR end of meadow so he executed a precautionary landing during which the acft struck a ditch and nosed over. The density altitude… - [NTSB ANC86LA107](https://openairdocs.org/ntsb/ANC86LA107.md): Piper PA-18-150 · Port Moller, AK · Accident · No injuries · Limited investigation · Final report · Jul 12, 1986 · N90945 · Substantial damage > The aircraft nosed over on landing rollout after landing on a beach. - [NTSB MKC86LA148](https://openairdocs.org/ntsb/MKC86LA148.md): Piper PA-32-301T · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Jul 11, 1986 · N8305Y · Substantial damage > The PIC had mistakenly attempted a landing at another airport 8 miles west of his intended destination. The PIC realized his mistake and diverted to his final destination. The PIC landed at the correct airport, but veered sharply to the right on landing on… - [NTSB ANC86LA110](https://openairdocs.org/ntsb/ANC86LA110.md): Cessna 180 · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Jul 11, 1986 · N6455X · Substantial damage > The plt stated that he landed in the water with the landing gear on the floats in the down and locked position. The acft nosed over in the water on touchdown. The plt stated he failed to use a before landing checklist. - [NTSB SEA86LA164](https://openairdocs.org/ntsb/SEA86LA164.md): Maule M-4-220C · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Jul 9, 1986 · N40646 · Substantial damage > The acft veered left and ground looped during landing roll. The right main gear strut collapsed during the landing. The plt had 5 hours total flt time in this acft and stated the toe brakes seemed 'touchy' during the landing. - [NTSB CHI86LA202](https://openairdocs.org/ntsb/CHI86LA202.md): Piper PA-16 · Effingham, IL · Accident · No injuries · Limited investigation · Final report · Jul 9, 1986 · N5214H · Substantial damage > Acft ground looped during landing roll. Plt reported the right seat left brake did not stop wheel from turning. Inspection of right seat brakes revealed corroded aluminum shuttle valve between the co-pilot and pilot brake lines which prevented transfer of… - [NTSB CHI86LA168](https://openairdocs.org/ntsb/CHI86LA168.md): Beech BE-58 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jul 9, 1986 · N9069Q · Substantial damage > The aircraft landed gear up at Indianapolis international airport. Pilot and witness report that gear was down. However, FAA inspectors and mechanics who inspected the aircraft state that the left main and nose gear were found in the wheels wells and the… - [NTSB SEA86LA170](https://openairdocs.org/ntsb/SEA86LA170.md): Piper PA-28R-200 · Royal City, WA · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N15270 · Substantial damage > The plt was landing the acft on rwy 27, toward the sun. With the sun in her eyes, she did not see a 300 lb calf on the rwy. The acft struck & killed the calf & was substantially damaged. - [NTSB NYC86IA215](https://openairdocs.org/ntsb/NYC86IA215.md): Boeing 737-200 · Pittsburgh, PA · Incident · No injuries · Incident investigation · Final report · Jul 7, 1986 · N319US · No damage > Co-plt was flying acft on short final approach/landing. Capt observed co-plt having difficulty maintaining glideslope and airspeeds. Co-plt stopped flying the acft. Capt took control at 50' AGL and landed safely. Medical help requested and received from cabin… - [NTSB LAX86LA299](https://openairdocs.org/ntsb/LAX86LA299.md): Boeing N25-3 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N5106N · Substantial damage > A Boeing N2S-3 nosed over on landing while on a local VFR flight. The pilot indicated that he had logged a total of 2.4 hours in this make and model aircraft all within the previous ninety days. The pilot stated that on his last approach, the speed was too… - [NTSB FTW86LA122](https://openairdocs.org/ntsb/FTW86LA122.md): Piper PA-24-260 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Jul 7, 1986 · N9165P · Substantial damage > The pilot was cleared to land on runway 12L when he encountered wind gusts on touchdown causing the aircraft to veer off the runway into a grassy area. - [NTSB LAX86LA280](https://openairdocs.org/ntsb/LAX86LA280.md): Piper PA-28-161 · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Jul 6, 1986 · N8075X · Substantial damage > The student plt indicated that after his third approach, while flying solo, the acft veered to the right and went off the rwy during the landing roll. He attempted to correct the situation, but the acft collided with a 5 ft ditch, located aprx 38 ft from the… - [NTSB ATL86LA200](https://openairdocs.org/ntsb/ATL86LA200.md): Balloon Works FF-7 · Pandora, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 6, 1986 · N4065K · No damage > Following a early morning Balloon flight, the pilot attempted a landing in a cleared area with winds at about 14 knots. The pilot realized that the first attempt he would encounter powerlines and trees. The pilot climbed out and attempted another approach to… - [NTSB SEA86LA157](https://openairdocs.org/ntsb/SEA86LA157.md): Cessna 172 · Glenn'S Ferry, ID · Accident · No injuries · Limited investigation · Final report · Jul 5, 1986 · N1641F · Substantial damage > The student pilot had to be vectored during a night x-country. During cruise, 35 miles from his destination, he became concerned about his low fuel state. He then diverted, with ATC assistance to an unlit airstrip for landing. The acft touched down short of… - [NTSB DEN86LA191](https://openairdocs.org/ntsb/DEN86LA191.md): Piper PA-60-601P · Provo, UT · Accident · No injuries · Limited investigation · Final report · Jul 5, 1986 · N8253J · Substantial damage > Plt and three pax flew from el paso, TX to Provo, UT en route to Alaska vacation. Left main tire blew after acft touched down. Acft veered to left and went off rwy. Examination of tire revealed large hole but with good tread remaining. Acft damage was… - [NTSB DEN86LA189](https://openairdocs.org/ntsb/DEN86LA189.md): Balloon Works Firefly 7 · Hurley, NM · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 1986 · N37486 · No damage > During landing, one of the paxs in the Balloon basket suffered a broken ankle. Plt says landing was a normal rip out landing. Neither he nor pax knows how injury occurred. - [NTSB ANC86LA101](https://openairdocs.org/ntsb/ANC86LA101.md): Stinson 108 · Hope, AK · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 1986 · N936C · Destroyed > The plt stalled the acft during final apch to a small gravel airstrip. The plt had not received training as a student plt nor did he hold any FAA plt or medical certificate. - [NTSB LAX86LA285](https://openairdocs.org/ntsb/LAX86LA285.md): Piper PA-38 · Lincoln, CA · Accident · No injuries · Limited investigation · Final report · Jul 4, 1986 · N91360 · Substantial damage > The student pilot indicated that this was his first solo flight. He had accumulated a total of 6.8 hours of flight time prior to this flight and he had flown earlier in the day with his flight instructor. After two landings with the flight instructor, the… - [NTSB CHI86FEC04](https://openairdocs.org/ntsb/CHI86FEC04.md): Cameron 77 · Hamburg, MI · Accident · Serious injuries · Final report · Jul 4, 1986 · N340CB · No damage > Plt made a precautionary landing reportedly due to high winds. Upon touchdown the basket tipped and one of the pax received a fractured left leg. - [NTSB ATL86LA192](https://openairdocs.org/ntsb/ATL86LA192.md): Piper PA-22-160 · Van Wert, OH · Accident · No injuries · Limited investigation · Final report · Jul 4, 1986 · N9835D · Substantial damage > The plt reported that his airspeed was too high on ldg and that the acft brakes failed to function when he tried to stop the acft. The plt turned the acft off the rwy into a soft grassy area as the acft neared the rwy end. Another plt who witnessed the… - [NTSB ANC86LA098](https://openairdocs.org/ntsb/ANC86LA098.md): Cessna 180H · Fairbanks, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 4, 1986 · N7935V · Substantial damage > After touchdown on the runway, the pilot lost directional control of the aircraft which ground looped to the right. The right main gear was sheared off at the gear box during the ground loop. - [NTSB MIA86LA197](https://openairdocs.org/ntsb/MIA86LA197.md): Cessna T210H · Cedar Key, FL · Accident · No injuries · Limited investigation · Final report · Jul 3, 1986 · N2228R · Substantial damage > The student plt stated that he overflew the arpt to observe the direction of the wind as indicated by the wind sock. When he was unable to locate it, a landing was made on rwy 5 with a left quartering tailwind. Unable to stop, the acft left the rwy struck a… - [NTSB DEN86LA184](https://openairdocs.org/ntsb/DEN86LA184.md): Cessna 172N · Tooele, UT · Accident · No injuries · Limited investigation · Final report · Jul 3, 1986 · N5552E · Substantial damage > After successive aircraft bounces during a touchdown phase of landing, the pilot lost control. The aircraft departed the side of the runway into an area of soft terrain. The landing gear nose wheel sank into the ground and the aircraft nosed over into an… - [NTSB MKC86LA140](https://openairdocs.org/ntsb/MKC86LA140.md): Cessna 152 · Oxford, IA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1986 · N64998 · Substantial damage > The student PIC was practicing touch and go landings at a pvt strip when on landing the PIC stated he lost directional control and veered off the left side of runway 33. The ensuing departure substantially damaged the acft. Rptd winds were 290 degrees at 10… - [NTSB NYC86LA167](https://openairdocs.org/ntsb/NYC86LA167.md): Champion 7GCAA · Lakewood, NJ · Accident · No injuries · Limited investigation · Final report · Jul 1, 1986 · N5186X · Substantial damage > After returning to the airport, the pilot lost directional control during the landing and the aircraft veered off the runway. Subsequently, the aircraft struck a runway light and the left main wheel & left wing were damaged. - [NTSB NYC86LA166](https://openairdocs.org/ntsb/NYC86LA166.md): Piper PA-38-112 · Lincoln, RI · Accident · No injuries · Limited investigation · Final report · Jul 1, 1986 · N2428P · Substantial damage > The plt intended to practice a short field landing & extended full flaps. Initially, his apch was higher & faster than normal. However, before landing, a high sink rate developed. The acft touched down hard, the right wing dropped & the acft started to turn… - [NTSB MKC86LA136](https://openairdocs.org/ntsb/MKC86LA136.md): Fairchild SA-227 · Lincoln, NE · Accident · No injuries · Limited investigation · Final report · Jul 1, 1986 · N243DH · Substantial damage > Flare for touchdown ended short of the active rwy at Lincoln, Nebraska. The PIC rptd windshear on final but wind conditions were rptd as being 340 degrees at 15 KTS, a headwind for this landing. No mechanical control pblm was reportedly experienced during… - [NTSB ANC86LA096](https://openairdocs.org/ntsb/ANC86LA096.md): Cessna 170B · Alexander Creek, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 1986 · N2806C · Substantial damage > While landing on a river bar, the acft drifted to the left of the normal touchdown zone. Subsequently, the wheels entered soft sand and the airplane turned over. - [NTSB NYC86LA162](https://openairdocs.org/ntsb/NYC86LA162.md): Piper PA-28-140 · Wellsboro, PA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1986 · N8299N · Substantial damage > Drg arrival, the plt was advised the winds were 5 to 7 KTS, favoring rwy 28. However, when he crossed over the arpt for a downwind entry, he noted that the wind sock had changed to indicate an upwind for rwy 10, so he elected to land on that rwy. On final… - [NTSB ANC86LA094](https://openairdocs.org/ntsb/ANC86LA094.md): Cessna 180H · Eureka, AK · Accident · No injuries · Limited investigation · Final report · Jun 30, 1986 · N9001M · Substantial damage > The airplane approached the short and high elevation airstrip too high and fast. It bounced on the rough surface and ran off the end before nosing over. - [NTSB NYC86LA169](https://openairdocs.org/ntsb/NYC86LA169.md): Piper PA-28-140 · Endicott, NY · Accident · No injuries · Limited investigation · Final report · Jun 29, 1986 · N55149 · Substantial damage > During roll out after landing, the acft encountered a strong gust of wind & subsequently went off the side of the rwy. Before stopping, the acft went over an embankment & the nose gear collapsed. - [NTSB MIA86LA259](https://openairdocs.org/ntsb/MIA86LA259.md): Mooney M20A · Titusville, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1986 · N6561B · Substantial damage > The plt stated that the wind changed from a crosswind to a tailwind on final apch. He continued the apch, landed, & during the landing roll, realized 'the brakes were not working properly,' & that he would be unable to stop the acft on the rwy. He then… - [NTSB MIA86LA232](https://openairdocs.org/ntsb/MIA86LA232.md): Mooney M20C · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Jun 29, 1986 · N6824V · Substantial damage > The plt stated that he put the gear handle down, continued his apch and landed without realizing the gear was still up. Post crash examination of the landing gear retract system revealed that the fuse for the landing gear motor had blown during the extension… - [NTSB MIA86LA196](https://openairdocs.org/ntsb/MIA86LA196.md): Piper J5C · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Jun 29, 1986 · N62074 · Substantial damage > The plt stated that he overflew the arpt to observe the wind direction as indicated by the wind sock. Upon landing on rwy 23, he lost control of the acft due to a left quartering tailwind. The acft then went through a chain link fence & came to rest in a… - [NTSB MIA86LA195](https://openairdocs.org/ntsb/MIA86LA195.md): Beech C23 · Pompano Beach, FL · Accident · No injuries · Limited investigation · Final report · Jun 29, 1986 · N5021M · Substantial damage > The plt stated that on approach he noted that he had no left rudder control and during landing roll, the aircraft veered off the left side of the runway collapsing the nose gear. Post crash examination of the nose gear revealed that the nose wheel steering… - [NTSB LAX86LA301](https://openairdocs.org/ntsb/LAX86LA301.md): Piper J3C-65 · Pleasant Grove, CA · Accident · No injuries · Limited investigation · Final report · Jun 29, 1986 · N3627K · Substantial damage > The pilot said the aircraft had new brakes installed prior to the flight. After touchdown at the conclusion of a local flight, the pilot said he 'applied too much pressure to the pedals and could not release the pressure in time to prevent the aircraft from… - [NTSB LAX86LA271](https://openairdocs.org/ntsb/LAX86LA271.md): Piper PA-23-160 · Upland, CA · Accident · No injuries · Limited investigation · Final report · Jun 29, 1986 · N17278 · Substantial damage > The plt stated that he was practicing single engine procedures and he forgot to lower the landing gear. Another plt alerted him on the radio and he attempted to lower the gear but landed with the gear only partially extended. The plt stated that he chose to… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=412 ## 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=411 --- 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.