# 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 420 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB NYC86LA025](https://openairdocs.org/ntsb/NYC86LA025.md): Cessna 172N · Great Valley, NY · Accident · No injuries · Limited investigation · Final report · Oct 25, 1985 · N5486D · Substantial damage > Acft experienced windshear while landing at Great Valley, n.y. the plt attempted to make a go around, but was unsuccessful and landed in a corn field. The acft was substantially damaged, however, the private certificated plt was uninjured. - [NTSB NYC86FA017](https://openairdocs.org/ntsb/NYC86FA017.md): Schweizer SGS-1-35C · North Conway, NH · Accident · 1 fatal · Field investigation · Final report · Oct 25, 1985 · N2565H · Destroyed > During an off airport landing attempt in a cleared corn field, the glider was approaching a treeline at an altitude of 10 to 20 ft AGL. Witnesses observed the glider pull up and bank to the left before falling nose first into the ground. The pilot's log book… - [NTSB MKC86LA019](https://openairdocs.org/ntsb/MKC86LA019.md): Piper PA-28-161 · Weeping Water, NE · Accident · No injuries · Limited investigation · Final report · Oct 25, 1985 · N47734 · Substantial damage > The pilot stated that he was going too fast when he touched down on the short runway and should have made a go around. The airplane went off the end of the runway, went down a slope and impacted a piloe of rocks. - [NTSB MKC86LA016](https://openairdocs.org/ntsb/MKC86LA016.md): Bellanca 7AC · Ogallala, NE · Accident · No injuries · Limited investigation · Final report · Oct 25, 1985 · N467AC · Substantial damage > While practicing touch and go landings the plt rptd that during the landing roll the left brake locked. The plt applied opposite rudder, but the acft veered off the left side of the rwy until striking a ditch which collapsed the gear. Inspection of the gear… - [NTSB MIA86IA018](https://openairdocs.org/ntsb/MIA86IA018.md): Grumman American AA-5 · Live Oak, FL · Incident · No injuries · Incident investigation · Final report · Oct 25, 1985 · N9558L · Minor damage > The acft made a downwind landing touching down long on the rwy. The acft could not be stopped & ran off the end of the rwy. The plt stated that he misread the windsock. - [NTSB MIA86IA017](https://openairdocs.org/ntsb/MIA86IA017.md): Cessna 402C · Miami, FL · Incident · No injuries · Incident investigation · Final report · Oct 25, 1985 · N67876 · Minor damage > The plt stated that he made a normal apch to rwy 12 buy on landing rollout as the nose of the acft touched down the nose gear ass'y folded & the acft slid to a stop, post crash examination of the acft revealed that the green light for the nose gear remained… - [NTSB FTW86LPJ01](https://openairdocs.org/ntsb/FTW86LPJ01.md): Cessna 172 · Kremlin, OK · Accident · No injuries · Final report · Oct 25, 1985 · N6069E · Substantial damage > The acft landed in a wheat field adjacent to the sod rwy. The acft nosed over in a small ditch during rollout. The plt said he mistook the green winter wheat for the sod rwy which was now brown dormant grass from a frost and not green as it was when the plt… - [NTSB ATL86LA015](https://openairdocs.org/ntsb/ATL86LA015.md): Cessna 152 · Marietta, GA · Accident · No injuries · Limited investigation · Final report · Oct 25, 1985 · N757MC · Substantial damage > During an attempted touch and go landing the student plt lost directional control of the acft. The acft ballooned during touchdown, veered off the rwy and nosed over. - [NTSB NYC86LA018](https://openairdocs.org/ntsb/NYC86LA018.md): Beech BE-95-100 · Grove City, PA · Accident · No injuries · Limited investigation · Final report · Oct 24, 1985 · N3668P · Substantial damage > After turning on to final for rwy 270 transition/upgrade pilot observed he was high. Power was then reduced aircraft was then on short final a power adjustment was made causing aircraft to land 400/500 feet pass rwy threshold. On contact with rwy nose gear… - [NTSB FTW86MA018](https://openairdocs.org/ntsb/FTW86MA018.md): Bell 222UT · East Cameron · Accident · 2 fatal · Major investigation · Final report · Oct 24, 1985 · N3194M · Destroyed > Three pax rprtd that just prior to reaching the helipad, the helicopter's forward movement stopped and the helicopter wobbled or yawed from side to side. The pax's rprted that the pilot appeared to be trying to gain altitude and go forward when they heard a… - [NTSB CHI86LA016](https://openairdocs.org/ntsb/CHI86LA016.md): Beech A23.19 · Decatur, IN · Accident · Minor injuries · Limited investigation · Final report · Oct 24, 1985 · N5666S · Destroyed > The student pilot on an unauthorized xcountry flt was attempting to ld on a 2600'-115' sod strip. On his fifth approach the 90 deg xwind drifted him into a tree line on the downwind side of the strip. - [NTSB CHI86LA015](https://openairdocs.org/ntsb/CHI86LA015.md): Cessna 152 · Cahokia, IL · Accident · No injuries · Limited investigation · Final report · Oct 24, 1985 · N4965Q · Substantial damage > The student pilot was practicing touch and go landings in preparation for a solo cross country. The pilot was compensating for a crosswind when he landed the aircraft on its nose resulting in substantial damage to the aircraft. - [NTSB CHI86LA014](https://openairdocs.org/ntsb/CHI86LA014.md): Piper PA-22-150 · Toronto, OH · Accident · No injuries · Limited investigation · Final report · Oct 23, 1985 · N6859P · Substantial damage > The acft touched down hard and bounced during the student plts second solo landing of the day. Recovery was made by initiating a go around. The acft touched down hard and bounced again on the third landing. Directional control of the acft was lost and it… - [NTSB LAX86LA022](https://openairdocs.org/ntsb/LAX86LA022.md): Cessna 210M · Oakdale, CA · Accident · No injuries · Limited investigation · Final report · Oct 22, 1985 · N6047N · Substantial damage > The plt said that he made a 'fairly rapid descent' from a 10,500 ft MSL cruise alt to the airport pattern and experienced a 'painful pressure' in his ears. The plt said he was also wearing a headset. On entry into the pattern, theplt said he 'forgot to lower… - [NTSB FTW86LA021](https://openairdocs.org/ntsb/FTW86LA021.md): Piper PA-28-161 · Amite, LA · Accident · No injuries · Limited investigation · Final report · Oct 21, 1985 · N47558 · Substantial damage > The plt reported a loss of brake effectiveness while landing on a dew-covered sod strip. Unable to stop, the acft slid through a fence, damaging the wings. - [NTSB DEN86LA012](https://openairdocs.org/ntsb/DEN86LA012.md): Beech D50A · T/C, NM · Accident · No injuries · Limited investigation · Final report · Oct 20, 1985 · N332B · Substantial damage > A person identifying himself as leon taylor, notified the FAA in albuquerque, n.m., that the twin-bonanza acft he was piloting, overran the improvised airstrip where he was attemptting to land & crashed. Mr taylor was never heard from again. The n.m. state… - [NTSB FTW86FRD01](https://openairdocs.org/ntsb/FTW86FRD01.md): North American AT6G · Jennings, LA · Accident · No injuries · Final report · Oct 19, 1985 · N104DC · Substantial damage > The acft contacted a ditch and nosed down during an overrun landing. The acft was in a flt of 3 AT6'S landing at the arpt for a fly-in. N104DC touched down on the 2000 ft freshly mowed grass strip aprx 500 to 600 ft from the end. The plt stated the… - [NTSB DCA86AA001](https://openairdocs.org/ntsb/DCA86AA001.md): Vickers Viscount VC-810 · Bloomington, IN · Accident · Serious injuries · Final report · Oct 19, 1985 · N923RC · Destroyed > Drg an ILS to rwy 35, the apch was normal until the acft was aprx 100' abv the decision height, except there was condensation on the windshield. Touchdown was hard. A witness said the acft lndd aprx 1/3 of the way down the 5200' rwy. After lndg, with the… - [NTSB NYC86LA014](https://openairdocs.org/ntsb/NYC86LA014.md): Piper PA-28R-180 · Columbia, PA · Accident · No injuries · Limited investigation · Final report · Oct 18, 1985 · N4576J · Substantial damage > The acft collided with 6 ft high poles during an overrun landing. The plt stated he was making a landing and noted on short final that the airspeed was excessive. The rwy was grass was freshly cut, wet and slippery. The acft landed long and ran off the end of… - [NTSB MIA86FA014](https://openairdocs.org/ntsb/MIA86FA014.md): Cessna 421C · Ft.Lauderdale, FL · Accident · Minor injuries · Field investigation · Final report · Oct 18, 1985 · N657WM · Substantial damage > The acft crashed on the arpt during an on demand air taxi flt. The plt stated that on final apch he encountered turbulence and rain. As he broke out of the rain the glare from the sun interferred with his visual perception. A go around was attempted but the… - [NTSB MKC86LA012](https://openairdocs.org/ntsb/MKC86LA012.md): Piper PA-28R-200 · Gardner, KS · Accident · No injuries · Limited investigation · Final report · Oct 17, 1985 · N43429 · Substantial damage > The pilot stated that he was landing on runway 8 with a right crosswind and had the right wing down for wind correction. The right wheel impacted a lip on the approach end of the runway, 6 inches below the level of the runway. The right gear collapsed, the… - [NTSB CHI86FEX03](https://openairdocs.org/ntsb/CHI86FEX03.md): Bell H13G · Mccordsville, IN · Accident · No injuries · Final report · Oct 16, 1985 · N73550 · Substantial damage > The helicopter rolled over after the main rotor blades contacted the terrain during an attempt to land from a hover. The plt had a student plt airplane certificate at the time of the accident. - [NTSB ANC86LA005](https://openairdocs.org/ntsb/ANC86LA005.md): Cessna 170B · Tok, AK · Accident · No injuries · Limited investigation · Final report · Oct 16, 1985 · N2491D · Substantial damage > The plt elected to land on an airstrip next to the alaskan highway. He stated that there was brush along the edge of the strip which was 'grown in' & was higher than he had realized. During the landing, the acft bounced, then the left wing hit a small tree… - [NTSB SEA86LA015](https://openairdocs.org/ntsb/SEA86LA015.md): Grumman G21A · Long Island, AK · Accident · No injuries · Limited investigation · Final report · Oct 15, 1985 · N72PR · Substantial damage > While landing with three to four foot swells and when the aircraft was coming off the step, a wave struck the horizontal stabilizer and elevator causing substantial damage. - [NTSB SEA86LA010](https://openairdocs.org/ntsb/SEA86LA010.md): Cessna 182P · Bly, OR · Accident · No injuries · Limited investigation · Final report · Oct 15, 1985 · N5837J · Substantial damage > The airstrip was only 20 feet wide. The aircraft was landed slightly to the right of the center. The aircraft's right main gear went into the gravel and the aircraft veered right. The nose gear then struck rocks and collapsed. The aircraft then nosed over. - [NTSB DEN86LA010](https://openairdocs.org/ntsb/DEN86LA010.md): Raven S60A · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 14, 1985 · N4395C · Minor damage > During landing, while the basket of a Raven balloon was being pulled by the wind driven envelope, it struck a fence and a mobile home trailer. Of the four passengers aboard, one received minor injuries and one received serious injuries. The pilot stated that… - [NTSB CHI86LA011](https://openairdocs.org/ntsb/CHI86LA011.md): Maule M-4C · Blue Earth, MN · Accident · No injuries · Limited investigation · Final report · Oct 14, 1985 · N9845M · Substantial damage > The acft nosed over after departing the rwy following a loss of directional control during landing. The CFI stated that as the tailwheel touched the rwy the acft began veering to the right. He applied brakes and full left rudder causing theleft wheel rim to… - [NTSB ATL86LA006](https://openairdocs.org/ntsb/ATL86LA006.md): Schweizer 269C · Atlanta, GA · Accident · No injuries · Limited investigation · Final report · Oct 14, 1985 · N7503Q · Substantial damage > During a practice autorotation the acft experienced a hard ldg when the plt failed to arrest the sink rate prior to contacting the ground. - [NTSB SEA86LA009](https://openairdocs.org/ntsb/SEA86LA009.md): Mooney 231 · Ione, WA · Accident · Minor injuries · Limited investigation · Final report · Oct 13, 1985 · N1162Z · Destroyed > The aircraft touched down about 500 feet past the runway threshold of the 2550 foot runway. The aircraft floated and then began to porpoise. A go-around was initiated and while the pilot was attempting to clear trees an inadvertent departure stall occurred.… - [NTSB SEA86LA011](https://openairdocs.org/ntsb/SEA86LA011.md): Cessna 172 · Lebanon, OR · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N5790J · Substantial damage > A loss of directional control occurred during landing roll. The acft veered to the right, struck a ditch and then nosed over. A helicopter was hovering to the left of the landing rwy, probably causing enough wake turbulence to cause the loss of directional… - [NTSB NYC86LA009](https://openairdocs.org/ntsb/NYC86LA009.md): Maule MX 7-235 · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N5661N · Substantial damage > The acft groundlooped during lndg. The plt reported that a sudden gust of wind was the cause. The sind was reported as calm. - [NTSB MKC86LA009](https://openairdocs.org/ntsb/MKC86LA009.md): Cessna 140A · Pacific, MO · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N5382C · Substantial damage > The airplane had rolled for 100 feet when the left wheel hit a mound of dirt left by a pocked gopher. The wheelpant bracket contacted the tire and acted as a brake. Airplane nosed forward to the inverted position. - [NTSB MIA86LA010](https://openairdocs.org/ntsb/MIA86LA010.md): Cessna 152 · West Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N4802B · Substantial damage > The plt experienced nose wheel shimmy during the landing roll. He then applied back pressure and the acft ballooned back into the air. The acft landed on the nose wheel damaging the prop & nose gear. - [NTSB FTW86LA022](https://openairdocs.org/ntsb/FTW86LA022.md): Cessna 152 · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 1985 · N49958 · Substantial damage > The student was instructed to follow through with his left hand on the controls during the takeoff. After liftoff the CFI felt that the acft was climbting too steeply. He told the student to get off the controls, thinking that he was applying too much back… - [NTSB BFO86LA003](https://openairdocs.org/ntsb/BFO86LA003.md): Cessna 152 · Stevensville, MD · Accident · No injuries · Limited investigation · Final report · Oct 12, 1985 · N49396 · Substantial damage > According to the student plt, approximately one-third down the rwy he flared too high, and the acft bounced and became airborne again. The plt decided to not attempt a go-around, and the acft contacted the rwy again. On the final bounce, the nose gear… - [NTSB LAX86LA010](https://openairdocs.org/ntsb/LAX86LA010.md): Piper PA-32-260 · Paradise, CA · Accident · No injuries · Limited investigation · Final report · Oct 8, 1985 · N3643W · Substantial damage > The acft touched dwn tail first during lndging to the rt of the rwy. The plt indicated he was lndging in a gusting x-wind which drifted him during a nose high hard lndg. No mechanical difficulties were reported by the plt. - [NTSB ANC86LAG02](https://openairdocs.org/ntsb/ANC86LAG02.md): Maule M5-235C · King Salmon, AK · Accident · No injuries · Final report · Oct 8, 1985 · N6198M · Substantial damage > The plt stated he misjudged the x-wind and water current during landing. The acft floats dug into the water and the acft nosed over and sank. - [NTSB MIA86LA008](https://openairdocs.org/ntsb/MIA86LA008.md): Piper PA-31-310 · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Oct 7, 1985 · N9135Y · Substantial damage > The plt stated that on final apch after lowering the landing gear he got an unsafe gear light. He then flew by the twr & the controller stated that the gear appeared to be down. He then recycled the landing gear & received a normal gear down indication. Upon… - [NTSB FTW86LA006](https://openairdocs.org/ntsb/FTW86LA006.md): Fairchild F-27 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Oct 7, 1985 · N4302F · Substantial damage > Acft veered left off the runway shortly after touchdown, collapsing the nose gear. Winds at the time would have resulted in direct crosswind of 9 kns. The crew that was contracted to ferry the acft noted, when they picked it up, that there were several open… - [NTSB NYC86LA003](https://openairdocs.org/ntsb/NYC86LA003.md): Cessna C206 · West Dover, VT · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1985 · N9861Z · Substantial damage > Cessna aircraft, N9861Z overran runway 1, at West Dover, Vermont and landed on a golf course. The pilot stated that when the flight was about 50 feet above the runway and about 100 ft down the runway windshear was encountered, pulling the aircraft to the left… - [NTSB MIA86LA005](https://openairdocs.org/ntsb/MIA86LA005.md): Cessna 172 · St.Petersburg, FL · Accident · No injuries · Limited investigation · Final report · Oct 6, 1985 · N7602D · Substantial damage > The plt stated that while attempting a landing he realized his rate of descent was too high. He then applied power, the nose pitched up and the acft stalled, resulting in a hard landing. - [NTSB LAX86LA009](https://openairdocs.org/ntsb/LAX86LA009.md): Cessna 182N · Palm Springs, CA · Accident · No injuries · Limited investigation · Final report · Oct 6, 1985 · N92259 · Substantial damage > During arrival, the plt entered the traffic pattern behind other acft to land on rwy 12. At that time, a Boeing 727 was waiting to takeoff on the same rwy. At 1914:52, the plt (of N92259) was instructed to start a left turn to the base leg. At 1915:04, the… - [NTSB LAX86LA006](https://openairdocs.org/ntsb/LAX86LA006.md): Leslie Quickie II · Porterville, CA · Accident · No injuries · Limited investigation · Final report · Oct 6, 1985 · N23RL · Substantial damage > The acft received substantial damage during a landing at Porterville while on a local pleasure flt. According to the plt, he bounced the acft several times and it began to porpoise. During the porpoise motion, the propeller and left canard contacted the rwy.… - [NTSB CHI86LA008](https://openairdocs.org/ntsb/CHI86LA008.md): Piper PA-28-180 · Lake Geneva, WI · Accident · Serious injuries · Limited investigation · Final report · Oct 6, 1985 · N55785 · Substantial damage > After touchdown & about 600 ft from the approach end of runway 23 the aircraft collided with a moped crossing the runway. The 11 yr old operator of the moped was seriously injured. - [NTSB CHI86LA005](https://openairdocs.org/ntsb/CHI86LA005.md): Todd Pitts · Hartford, WI · Accident · No injuries · Limited investigation · Final report · Oct 6, 1985 · N14JK · 2 aircraft · Minor damage > N2032 had taken off, remained in the traffic pattern, & landed. N14JK had taken off, obtained a radio check at altitude,descended and entered the traffic pattern. Immediately afterlanding N14JK ran into N2032. N14JK reportedly made two radio calls in the… - [NTSB ATL86FKG02](https://openairdocs.org/ntsb/ATL86FKG02.md): Cessna 152 · Pell City, AL · Accident · No injuries · Final report · Oct 6, 1985 · N49446 · Substantial damage > The acft nosed over following a loss of control during a x-wind landing. The student plt stated he crabbed the acft intothe wind to compensate for the x-wind during the apch. The acft touched down still in the crabbed position and traveled off the right side… - [NTSB SEA86LA006](https://openairdocs.org/ntsb/SEA86LA006.md): Cessna 172 · Emmett, ID · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1985 · N2867Q · Substantial damage > While landing in calm wind conditions on a 2400 ft rwy, the left brake failed & the acft contd off the departure end, then hit a fence. An exam revealed the left brake pads were worn & the left actuator cylinder was losing fluid. The brake backing plate & the… - [NTSB MKC86LA007](https://openairdocs.org/ntsb/MKC86LA007.md): Bellanca 7GCBC · Dumas, AR · Accident · No injuries · Limited investigation · Final report · Oct 5, 1985 · N31272 · Substantial damage > On landing at a pvt sod strip near Dumas, the plt stated he encountered a strong crosswind. The crosswind forced his acft to veer off the side of the rwy. After veering off the rwy the right wing struck the ground sustaining substantial damage to the wing… - [NTSB MKC86LA003](https://openairdocs.org/ntsb/MKC86LA003.md): Cessna 172 · Guilford, MO · Accident · Minor injuries · Limited investigation · Final report · Oct 5, 1985 · N4016F · Substantial damage > The plt reports that he landed hard, bounced and came down on the nose gear. The nose gear broke and the acft went over on its back. - [NTSB FTW86LA005](https://openairdocs.org/ntsb/FTW86LA005.md): Beech K35 · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Oct 5, 1985 · N35JW · Substantial damage > The plt stated his straight-in landing final apch was smooth. The airspeed had decreased from 80 to 65 KTS & the acft's wheels were only inches above the rwy when the right wing suddenly lifted and caused the acft to veer left and touch down on the dirt… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=421 ## 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=420 --- 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.