# 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 416 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB MIA86LA107](https://openairdocs.org/ntsb/MIA86LA107.md): Bellanca 17-30A · Ft. Lauderdale, FL · Accident · No injuries · Limited investigation · Final report · Mar 29, 1986 · N28007 · Substantial damage > The non-certificated student plt was making an unauthorized night solo x-country flt. He attempted a landing at his destination with a left 60 deg, 12 kt x-wind. During the landing roll the acft veered to the right and the plt correctedby applying 'extreme'… - [NTSB CHI86LA110](https://openairdocs.org/ntsb/CHI86LA110.md): Cessna 172MM · Middleton, WI · Accident · No injuries · Limited investigation · Final report · Mar 28, 1986 · N20866 · Substantial damage > The 94 hour private pilot was attempting a landing with a crosswind component of 90 degrees and a wind velocity of 15 to 18 KTS gusting to 22 KTS when he touched down with the right main gear & 2 feet off the right side of the runway. The right main gear came… - [NTSB CHI86LA112](https://openairdocs.org/ntsb/CHI86LA112.md): Cessna 177 · Lacon, IL · Accident · No injuries · Limited investigation · Final report · Mar 27, 1986 · N3187T · Substantial damage > The pilot stated he was maintaining a steep approach angle to clear trees at the approach end of the 2200 ft. runway. He flared late, landing hard and damaging the firewall. - [NTSB MKC86LA075](https://openairdocs.org/ntsb/MKC86LA075.md): Piper PA-34-200T · Salem, AR · Accident · No injuries · Limited investigation · Final report · Mar 26, 1986 · N2889M · Substantial damage > The acft was landing on a 2,050 by 100 ft asphalt rwy. The plt said the touchdown was not hard but not smooth. The acft traveled about 300 ft after touchdown before the r MLG collapsed. The broken parts which were removed from the landing gear assembly were… - [NTSB MKC86LA074](https://openairdocs.org/ntsb/MKC86LA074.md): Beech G18S · Cedar Rapids, IA · Accident · No injuries · Limited investigation · Final report · Mar 25, 1986 · N528 · Substantial damage > The pilot was aware that he would have a strong crosswind on landing. He was landing on runway 13 with winds from 180 degrees at 20 knots, gusting to 30 knots. The pilot stated that while the airplane was rolling down the runway, the right wing was lifted by… - [NTSB MIA86LA105](https://openairdocs.org/ntsb/MIA86LA105.md): Cessna 150L · St. Thomas · Accident · No injuries · Limited investigation · Final report · Mar 25, 1986 · N11505 · Substantial damage > The student plt was on a supervised solo flt practicing to & ldgs. On the last ldg, the wind caught the acft & the plt attempted to recover without adding power. Control of the acft was lost & the plt attempted to force the acft back onto the rwy. The acft… - [NTSB LAX86LA153](https://openairdocs.org/ntsb/LAX86LA153.md): Cessna 172N · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · Mar 25, 1986 · N4863F · Substantial damage > Witnesses reported that they observed the plt make 2 approaches and landings prior to the accident. On the landing just before the accident, they observed an 'extremely hard landing on the nose gear.' They reported that the plt then taxied back to takeoff… - [NTSB DEN86LA104](https://openairdocs.org/ntsb/DEN86LA104.md): Champion 7GCAA · Falcon, CO · Accident · No injuries · Limited investigation · Final report · Mar 25, 1986 · N9614S · Substantial damage > According to the plt, when the acft slowed after landing, it turned 'sharply to the right.' The plt stated he experienced 'extreme tailwheel shudder' prior to this during the landing roll. During the investigation, it was ascertained that the tailwheel spring… - [NTSB ATL86LLT08](https://openairdocs.org/ntsb/ATL86LLT08.md): Piper PA-34 · Smithville, TN · Incident · No injuries · Final report · Mar 25, 1986 · N3951X · Minor damage > The acft ran off the departure end of the rwy during landing. The acft reportedly landed 1/2 way down the 3400 ft rwy. The plt stated in a post acc interview that he was 'too high too fast and too long.' - [NTSB ATL86LA101](https://openairdocs.org/ntsb/ATL86LA101.md): Cessna 172N · Advance, NC · Accident · No injuries · Limited investigation · Final report · Mar 25, 1986 · N737DR · Substantial damage > While on final apch to rwy 27,plts vision restricted by sun glare. Plt indicated that he was high & fast and landed too long to allow go around. Overran runway, nose gear mired and acft nosed over. - [NTSB LAX86LA152](https://openairdocs.org/ntsb/LAX86LA152.md): Cessna C-152T · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Mar 24, 1986 · N49420 · Substantial damage > A Cessna 152 collided with terrain after running off rwy 29L. The plt indicated he made a go-around on first approach due to difficulty maintaining rwy heading. On second approach he was aligned a little left of centerline and elected to land. The acft… - [NTSB ANC86LA041](https://openairdocs.org/ntsb/ANC86LA041.md): Piper PA-18 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Mar 24, 1986 · N7145K · Substantial damage > The flight instructor stated that he was demonstrating a stall landing to the student pilot. After touchdown and rollout the aircraft struck a snow drift on the runway causing the aircraft to nose over on its back. - [NTSB NYC86LA089](https://openairdocs.org/ntsb/NYC86LA089.md): Piper PA-28-161 · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Mar 23, 1986 · N80021 · Substantial damage > Pilot touched down long on 3135 foot runway, exceeding the braking action of the aircraft, ran off end of runway into a ditch causing substantial damage to the aircraft. The pilot, the sole occupant received no injuries. - [NTSB MIA86LA102](https://openairdocs.org/ntsb/MIA86LA102.md): Piper PA-18-150 · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Mar 23, 1986 · N9169T · Substantial damage > The plt stated that while flaring to land, a gust of wind picked up his right wing & before he could recover he lost control & the acft ground looped. - [NTSB FTW86LPA16](https://openairdocs.org/ntsb/FTW86LPA16.md): Cessna 188 · Atlanta, TX · Accident · No injuries · Final report · Mar 22, 1986 · N6009G · Substantial damage > The pilot lost directional control of the aircraft during the landing roll. It then departed the runway and ran into a drainage ditch which collapsed the main landing gear. - [NTSB ANC86LA040](https://openairdocs.org/ntsb/ANC86LA040.md): Cessna 170-B · Whittier, AK · Accident · No injuries · Limited investigation · Final report · Mar 22, 1986 · N1999C · Substantial damage > The pilot stated that after touchdown he realized that the snow was soft. The aircraft nosed over on its back. - [NTSB MKC86LA072](https://openairdocs.org/ntsb/MKC86LA072.md): Jim Elliott VP-2 · Scott City, KS · Accident · No injuries · Limited investigation · Final report · Mar 21, 1986 · N32JE · Substantial damage > The plt was making his first flt in the acft which is powered by a volkswagon, 1,834 cc eng. The acft became airborne from a hard surface rwy and climbed to about 100 ft AGL. The plt said the controls felt mushy and when he attempted to climb the airspeed… - [NTSB DEN86FA101](https://openairdocs.org/ntsb/DEN86FA101.md): Piper PA-32R-300 · Albuquerque, NM · Accident · Serious injuries · Field investigation · Final report · Mar 21, 1986 · N555EB · Destroyed > The acft crashed on the second aborted takeoff attempt. The plt said that the acft was not accelerating properly on the first attempt and that the eng lost power on the second attempt. Ground witnesses said that the air conditioner condenser door was open and… - [NTSB NYC86IA109](https://openairdocs.org/ntsb/NYC86IA109.md): Sikorsky S-76 · Atlantic City, NJ · Incident · No injuries · Incident investigation · Final report · Mar 20, 1986 · N38 · Minor damage > During a preflight examination of a Sikorsky S76 the instructor and student discovered a hole in the leading edge of the pylon above the intermediate gear box and scuff mark on the main rotor blade caps. The instructor and student had just completed a 2.1 hr… - [NTSB LAX86LA148](https://openairdocs.org/ntsb/LAX86LA148.md): Cessna 140 · Rio Linda, CA · Accident · No injuries · Limited investigation · Final report · Mar 20, 1986 · N89698 · Substantial damage > On March 20, 1986, a Cessna 140 nosed over in mud after running off runway 17. VMC prevailed at the time. The aircraft was substantially damaged and the pilot and his passenger were not injured. The pilot stated he was too fast on his approach and ran off the… - [NTSB ANC86LA036](https://openairdocs.org/ntsb/ANC86LA036.md): Piper PA-18 · Kotzebue, AK · Accident · No injuries · Limited investigation · Final report · Mar 20, 1986 · N3935Z · Substantial damage > The student pilot lost control of the aircraft on landing at a winter ice landing strip. - [NTSB MKC86LA070](https://openairdocs.org/ntsb/MKC86LA070.md): Cessna 182 · Mulvane, KS · Accident · Minor injuries · Limited investigation · Final report · Mar 19, 1986 · N3379F · Substantial damage > The PIC of the acft landed his Cessna 182 to the north on a farm pasture he owns which doubles as a landing strip. The PIC stated he approached too high and too fast, landing about midway of the field. A fence which borders the field was fast approaching with… - [NTSB LAX86LA146](https://openairdocs.org/ntsb/LAX86LA146.md): Cessna 172P · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1986 · N52628 · Substantial damage > A Cessna 172P collided with a rwy light after veering off rwy 28. The winds at the time off the accident were reported from 350 deg at 6 KTS. The right main landing gear collapsed when it struck a rwy light damaging the right wing and tail section. - [NTSB MKC86LA069](https://openairdocs.org/ntsb/MKC86LA069.md): Cessna 172N · Warren, AR · Accident · No injuries · Limited investigation · Final report · Mar 18, 1986 · N1530E · Destroyed > The plt reports that a deer ran in front of the acft during the flare for a night landing. The prop hit and killed the deer and the nose gear and bottom of the eng compartment were damaged. After the collision the plt said he smelled fuel fumes and when the… - [NTSB FTW86LA045](https://openairdocs.org/ntsb/FTW86LA045.md): Cessna TU206F · Goliad, TX · Accident · 1 fatal · Limited investigation · Final report · Mar 17, 1986 · N6633T · Destroyed > The pilot apparently failed to properly recover from a bounced landing and broke a landing gear wheel. The aircraft hit and fatally injured a person on the ground. Local authorities believe the persons body was then transported about four miles and thrown… - [NTSB ATL86LA095](https://openairdocs.org/ntsb/ATL86LA095.md): Cessna 150 · Lafayette, TN · Accident · No injuries · Limited investigation · Final report · Mar 17, 1986 · N2618J · Substantial damage > The pilot stated that he had completed a touchdown and was on rollout when he noticed a deer on the runway. He increased the power enough to avoid colliding with the deer, but stalled the aircraft and collided with the runway surface failing the nose gear.… - [NTSB CHI86LA103](https://openairdocs.org/ntsb/CHI86LA103.md): Cessna 152 · Brooklyn Park, MN · Accident · No injuries · Limited investigation · Final report · Mar 16, 1986 · N4633B · Substantial damage > Upon initial touchdown the acft bounced. In the process of 're-flaring' the acft it drifted to the egde of the rwy. The solo student plt applied full power to go-around, however, during this maneuver the left wheel hit a snowbank along the edge of the rwy.… - [NTSB NYC86LA085](https://openairdocs.org/ntsb/NYC86LA085.md): Rockwell 680FL · Houlton, ME · Accident · Minor injuries · Limited investigation · Final report · Mar 15, 1986 · N287B · Substantial damage > The pilot-in-command landed on runway 5 which had approximately 1 inch of fresh snow. He reported that he encountered whiteout conditions during the landing & lost reference to the runway centerline. The aircraft touched down on the left side of the runway,… - [NTSB MKC86LA068](https://openairdocs.org/ntsb/MKC86LA068.md): Aeronca 7FC · Lake City, AR · Accident · No injuries · Limited investigation · Final report · Mar 15, 1986 · N9848Y · Substantial damage > The flight instructor and his student touched down on the newly constructed private dirt strip in the airplane and rolled for 610 feet before the main gear bogged down. The nosewheel then cocked sideways and the airplane rolled forward to the inverted… - [NTSB SEA86LA101](https://openairdocs.org/ntsb/SEA86LA101.md): Beech 76 · Troutdale, OR · Accident · No injuries · Limited investigation · Final report · Mar 14, 1986 · N5095M · Substantial damage > The acft was substantially damaged during a hard landing performed by the multi-enging student during a dual instructional flt. - [NTSB MIA86LA096](https://openairdocs.org/ntsb/MIA86LA096.md): Beech C23 · Lake Wales, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 1986 · N9790L · Substantial damage > The plt stated that he landed long and was unable to stop. The acft ran off the end of the runway into a lake. - [NTSB MIA86FA095](https://openairdocs.org/ntsb/MIA86FA095.md): Piper PA-31-350 · Florida City, FL · Accident · 1 fatal · Field investigation · Final report · Mar 14, 1986 · N49984 · Destroyed > The acft touched down on the top of a flood control dike approx 12 ft wide. The acft continued for about 1336 ft before the left wheel slid off the dike where the dike makes a slight curve to the right. The left gear was torn from the acft as it left the… - [NTSB DEN86LA100](https://openairdocs.org/ntsb/DEN86LA100.md): Cessna A185F · Bozeman, MT · Accident · No injuries · Limited investigation · Final report · Mar 14, 1986 · N4984Q · Substantial damage > According to the plt, shortly after touchdown, the right wing came up and the acft seemed to be pushed to the left. The plt said before he regained control, the left wing and horizontal stabilizer contacted the ground. The plt later learned that a Boeing 767… - [NTSB ATL86IA093](https://openairdocs.org/ntsb/ATL86IA093.md): McDonnell Douglas DC-9-31 · Charleston, SC · Incident · No injuries · Incident investigation · Final report · Mar 14, 1986 · N8924E · Minor damage > The acft landed on rwy 15 at 2357 EST. The rwy was wet from heavy rain & thunderstorms. Braking was ineffective and the acft failed to stop. The capt steered rt into the mud to the rt side of the overrun. Post accident review of the flt data recorder showed… - [NTSB BFO86LA019](https://openairdocs.org/ntsb/BFO86LA019.md): Cessna 150M · Orange, VA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1986 · N6143K · Substantial damage > At about 1245 EST, the plt took off on his second flt of the day and flew in the local area about 30 minutes. Upon returning to Orange county arpt, the plt observed the tetrahedron during the left downwind leg for rwy 25, and noted that the wind had changed… - [NTSB ATL86FMG05](https://openairdocs.org/ntsb/ATL86FMG05.md): Cessna 150 · Yadkinville, NC · Accident · No injuries · Final report · Mar 11, 1986 · N4752X · Substantial damage > The acft was landed improperly and after bouncing two of three times the nose gear separated. The acft then nosed over and suffered further damage to the prop, wings and tail. - [NTSB SEA86LA077](https://openairdocs.org/ntsb/SEA86LA077.md): Aeronca 7AC · East Sound, WA · Accident · No injuries · Limited investigation · Final report · Mar 10, 1986 · N84842 · Substantial damage > Upon rollout, a loss of directional control occurred during a wind gust. The pilot elected to go-around. Shortly after lift off, the main gear of the aircraft struck VASI lights. The aircraft then struck the ground. - [NTSB DEN86LA097](https://openairdocs.org/ntsb/DEN86LA097.md): Mooney M20F · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Mar 10, 1986 · N3280F · Substantial damage > According to the plt, during the flare to touchdown, the acft stalled and the left wing contacted the ground along with four runway lights. The plt said the accident could have been prevented by maintaining a higher airspeed on apch. - [NTSB BFO86FID04](https://openairdocs.org/ntsb/BFO86FID04.md): Cessna 210N · Blacksburg, VA · Accident · No injuries · Final report · Mar 10, 1986 · N6502C · Substantial damage > While landing at Blacksburg airport in Blacksburg, Virginia, the landing gear failed to extend. The aircraft collided with a runway light and served off the runway onto a grass area causing substantial damage to the left stabilizer and elevator. The pilot… - [NTSB ATL86LA088](https://openairdocs.org/ntsb/ATL86LA088.md): Cessna 152 · Mocksville, NC · Accident · No injuries · Limited investigation · Final report · Mar 9, 1986 · N5276M · Substantial damage > During landing the student pilot failed to correct for the crosswind. The aircraft drifted off the runway and collided with sock support post. - [NTSB ATL86LA091](https://openairdocs.org/ntsb/ATL86LA091.md): Luscombe 8A · Hampton, GA · Accident · No injuries · Limited investigation · Final report · Mar 8, 1986 · N71633 · Substantial damage > During landing roll the pilot was unable to keep the tailwheel on the ground and the aircraft nosed over. Post crash examination of the wreckage disclosed that the brake pads were worn down to the rivets. - [NTSB LAX86FVA03](https://openairdocs.org/ntsb/LAX86FVA03.md): Schweizer G164A · Wasco, CA · Accident · Minor injuries · Final report · Mar 7, 1986 · N946X · Substantial damage > The acft went off the left side of rwy during a downwind landing. The ag plts made a practice of landing downwind to speed up turn-around time. They relied on their brakes to maintain control. The acc acfts brake pads were worn and the rt brake was fluid… - [NTSB ATL86LA086](https://openairdocs.org/ntsb/ATL86LA086.md): Grumman American AA5A · Fayetteville, NC · Accident · No injuries · Limited investigation · Final report · Mar 6, 1986 · N26171 · Substantial damage > During landing roll the pilot lost directional control of the aircraft. The aircraft ground looped and swerved off the runway. The pilot stated that he should have been more diligent in correcting for the crosswind condition. - [NTSB FTW86FRG16](https://openairdocs.org/ntsb/FTW86FRG16.md): Cessna U206F · Mcallen, TX · Accident · Minor injuries · Final report · Mar 5, 1986 · N8502Q · Destroyed > On 03-05-86 at 0854 CST a Cessna U206F, N8502Q, was substantially damaged on landing rollout at miller international airport in Mcallen, Texas. There was no fire and the pilot received minor injuries when the electronics cargo fell upon him as the aircraft… - [NTSB LAX86LA133](https://openairdocs.org/ntsb/LAX86LA133.md): Cessna 152 · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Mar 4, 1986 · N49429 · Substantial damage > On March 4, 1986 a Cessna 152 collided with the runway surface after the nose wheel collapsed. The student pilot was on his third consecutive solo flight since his solo endorsement. On his third approach the aircraft bounced on landing and became airborne… - [NTSB SEA86LA072](https://openairdocs.org/ntsb/SEA86LA072.md): Patrick Henry Fokker DR. 1 · Gold Hill, OR · Accident · No injuries · Limited investigation · Final report · Mar 3, 1986 · N35PH · Substantial damage > Plt attempted spur of the moment landing in open field. Acft wheels sank into soft terrain after touchdown and acft nosed over. - [NTSB DEN86LA090](https://openairdocs.org/ntsb/DEN86LA090.md): Cessna 180J · Casper, WY · Accident · No injuries · Limited investigation · Final report · Mar 3, 1986 · N9923N · Substantial damage > According to the flt instructor, during the touch and go landing, directional control was lost when brakes were applied and the acft ground looped. During the investigation, it was ascertained that an 'o' ring on the right wheel had dislodged, resulting in… - [NTSB MKC86LA065](https://openairdocs.org/ntsb/MKC86LA065.md): Cessna 172 · Grain Valley, MO · Accident · No injuries · Limited investigation · Final report · Mar 2, 1986 · N3979L · Substantial damage > The PIC was making a roundtrip flt to numerous airports across Kansas and Missouri. The owner of the aircraft was aboard for the trip which was for pleasure. The PIC had obtained weather info and was apprised of the wind conditions for his route of flt. Upon… - [NTSB FTW86LRD08](https://openairdocs.org/ntsb/FTW86LRD08.md): Cessna 172P · Many, LA · Accident · No injuries · Final report · Mar 2, 1986 · N5234K · Substantial damage > The acft drifted off the rt side of the rwy into the soft shoulder during landing in a 10-12 kt x-wind. When the nose gear contacted the soft dirt it collapsed, which resulted in a nose over. - [NTSB NYC86FHA01](https://openairdocs.org/ntsb/NYC86FHA01.md): Piper PA-28-140 · Doylestown, PA · Accident · No injuries · Final report · Mar 1, 1986 · N2270Q · Substantial damage > The Piper PA-28-140 was landing on rwy 23. The winds were reported to be from 320' - 330' with a velocity of 20 KTS and gusts to 30 KTS. The student pilot lost control on landing and veared off the right side of runway. The aircraft received substantial… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=417 ## 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=416 --- 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.