# 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 397 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB DEN87LA198](https://openairdocs.org/ntsb/DEN87LA198.md): Cessna 152 · Watkins, CO · Accident · No injuries · Limited investigation · Final report · Jul 25, 1987 · N52MA · Substantial damage > The plt was practicing touch-and-go landings on rwy 26. He estimated the wind to be 180 deg at 8 KTS. The plt said that on the third landing attempt, a 15 kt gust of wind caused the acft to drift to the right. He attempted to correct with left aileron and… - [NTSB LAX87LA278](https://openairdocs.org/ntsb/LAX87LA278.md): Cessna 182A · Strathmore, CA · Accident · No injuries · Limited investigation · Final report · Jul 24, 1987 · N3884D · Substantial damage > During a cross country flight, upon landing, the aircraft touched-down approx 500 ft from the approach end of the rwy. The plt lost directional control of the acft when he stated that the brakes failed to respond. The runway on which the acft landed is approx… - [NTSB FTW87FA174](https://openairdocs.org/ntsb/FTW87FA174.md): Cessna 421C · Crystal City, TX · Accident · 1 fatal · Field investigation · Final report · Jul 24, 1987 · N448 · Destroyed > The pilot landed downwind on his private strip. The exact amount of the tailwind could not be determined. A thunderstorm was located just to the east of the runway and could have readily given N448 a strong tailwind. The aircraft touched down 390 feet beyond… - [NTSB NYC87LA208](https://openairdocs.org/ntsb/NYC87LA208.md): Hughes 369D · Bedford, MA · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1987 · N8384F · Substantial damage > During a practice autorotation with power recovery, the rotor RPM bled off. Directional control was lost and the helicopter turned several times before hitting the ground. The helicopter rolled to the left and came to rest on its side. - [NTSB MKC87LA146](https://openairdocs.org/ntsb/MKC87LA146.md): Cessna 152 · Columbia, MO · Accident · No injuries · Limited investigation · Final report · Jul 22, 1987 · N47354 · Substantial damage > The instructor and the student were making a landing on a short grass runway. The instructor stated they landed fast and were not able to stop. He considered a go-around but decided sufficient runway did not remain to perform the go-around. The airplane… - [NTSB LAX87LA277](https://openairdocs.org/ntsb/LAX87LA277.md): Cessna A185F · Chandler, AZ · Accident · No injuries · Limited investigation · Final report · Jul 22, 1987 · N252W · Substantial damage > The CFI indicated that the tailwheel began to shimmy during rollout. As forward control yoke pressure was applied the shimmy went away, however, as the acft began to slow down, the tailwheel was lowered and began to shimmy again. As the acft continued to slow… - [NTSB CHI87LA179](https://openairdocs.org/ntsb/CHI87LA179.md): Cessna 152 · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Jul 22, 1987 · N757JG · Substantial damage > On touchdown the aircraft ballooned and bounced up about 5-7 feet off the runway. The aircraft then landed on the nose wheel and the prop struck the ground. - [NTSB ATL87LA221](https://openairdocs.org/ntsb/ATL87LA221.md): Cessna 150M · Edmund, SC · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1987 · N45648 · Substantial damage > The CFI stated that he was having the pre solo student make a crosswind ldg after an hours practice at another apt. The student was using the slip method to correct for the crosswind. Touchdown was with a side load on the gear and the acft bounced. The CFI… - [NTSB ATL87LA220](https://openairdocs.org/ntsb/ATL87LA220.md): Aeronca 7AC · Columbus, OH · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1987 · N443WB · Substantial damage > The plt experienced a loss of directional control on ldg as the tailwheel touched down, and he executed a go-around. On the 2nd ldg attempt, the airplane veered off the rwy, traveled across a grassy area, and impacted a parked C-172. Post-crash exam of the… - [NTSB CHI87DEP09](https://openairdocs.org/ntsb/CHI87DEP09.md): Ayres 600S-2D · Bancroft, WI · Accident · No injuries · Final report · Jul 20, 1987 · N4436F · Substantial damage > On landing the aircraft veered to the right. Application of left brake and rudder did not arrest the turn. The aircraft impacted a fence post rendering substantial damage to the aircraft. Subsequent investigation revealed an axle spacer on the right wheel was… - [NTSB FTW87LA172](https://openairdocs.org/ntsb/FTW87LA172.md): Cessna 172K · Brenham, TX · Accident · No injuries · Limited investigation · Final report · Jul 19, 1987 · N84861 · Substantial damage > The student pilot lost directional control during the landing roll. The aircraft veered off the runway and nosed over to the inverted position when the nose gear dropped into a hole hidden by tall grass. - [NTSB BFO87LA052](https://openairdocs.org/ntsb/BFO87LA052.md): Mooney M-20C · Basye, VA · Accident · No injuries · Limited investigation · Final report · Jul 19, 1987 · N6769U · Substantial damage > When the pilot applied brakes during the landing roll the acft swerved left. He applied the right brake to straighten the acft and the acft swerved right. The pilot attempted to correct with left brake and the right main gear collapsed. No malfunctions were… - [NTSB ATL87LA218](https://openairdocs.org/ntsb/ATL87LA218.md): Piper PA-28-140 · Foley, AL · Accident · Minor injuries · Limited investigation · Final report · Jul 19, 1987 · N4808T · Substantial damage > The student plt failed to maintain directional control during a crosswind ldg on rwy 36. The airplane drifted to the left of the runway and subsequently impacted trees. The student plt was on his second unsupervised solo flight. He reported that he did not… - [NTSB LAX87LA274](https://openairdocs.org/ntsb/LAX87LA274.md): Cessna 182Q · Upper Lake, CA · Accident · No injuries · Limited investigation · Final report · Jul 18, 1987 · N97061 · Substantial damage - [NTSB LAX87DVA08](https://openairdocs.org/ntsb/LAX87DVA08.md): Hastings Thorp T18 · Patterson, CA · Accident · No injuries · Final report · Jul 18, 1987 · N50RH · Substantial damage > At the end of a pleasure flight, the aircraft was landing with a 90 degree crosswind with a velocity of approximately 20 mph. During the landing roll, the aircraft ground looped, ran off the runway and nosed over. There were no reported mechanical failures or… - [NTSB DEN87LA187](https://openairdocs.org/ntsb/DEN87LA187.md): Beech 58 · Pagosa Springs, CO · Accident · No injuries · Limited investigation · Final report · Jul 18, 1987 · N1879L · Substantial damage > The plt attempted to land his acft at night at an airport with inoperative runway lights and using a ground vehicle's headlights to aid him in landing. He stated that he touched down his aircraft to the left of the center of the runway and the left landing… - [NTSB DEN87LA185](https://openairdocs.org/ntsb/DEN87LA185.md): Piper PA-30 · Grandforks, ND · Accident · No injuries · Limited investigation · Final report · Jul 17, 1987 · N7722Y · Substantial damage > The commercial plt was flying cross country on a personal flight. After takeoff during gear retraction, a loud noise was heard in the cockpit. Upon reaching the first destination, the plt attempted gear down but gear did not extend. Manual extension was… - [NTSB CHI87LA171](https://openairdocs.org/ntsb/CHI87LA171.md): Beech 23 · Danville, IL · Accident · No injuries · Limited investigation · Final report · Jul 17, 1987 · N6562T · Substantial damage > The plt landed long and downwind on a sod farm strip. The acft ran off the departure end of the fld and struck trees. - [NTSB NYC87LA243](https://openairdocs.org/ntsb/NYC87LA243.md): Beech C24R · Danbury, CT · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N1997L · Substantial damage > During a landing at late dusk, the aircraft collided with a deer that darted onto the runway. The pilot said there was no time to take evasive action before the collision. The left wing and left gear door were damaged and the left fuel tank was ruptured. - [NTSB NYC87LA207](https://openairdocs.org/ntsb/NYC87LA207.md): Piper PA-11 · Andover, NJ · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1987 · N6346 · Destroyed > The pilot lost directional control during landing roll. As the aircraft drifted left of the runway, power was added for a go-around but the aircraft was left of the rwy. The left wing strut hit the wing of a Cessna 150 in an attempt to avoid colliding with… - [NTSB NYC87DNC09](https://openairdocs.org/ntsb/NYC87DNC09.md): Dubois Beta Bird · Biddeford, ME · Accident · No injuries · Final report · Jul 16, 1987 · N3954D · Substantial damage > The pilot was practicing takeoffs and landings in his homebuilt aircraft. Directional control of the aircraft was lost after it touched down during a landing. Subsequently, it swerved off the side of the runway, went in an area of tall grass & hit a ditch,… - [NTSB DEN87LA184](https://openairdocs.org/ntsb/DEN87LA184.md): Champion 7ECA · Devils Lake, ND · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N11024 · Substantial damage > The pvt plt, an A&P mechanic, was commuting home from the local airport in his aircraft. Upon landing, the main gear sank into soft soil and the acft nosed over. - [NTSB CHI87LA168](https://openairdocs.org/ntsb/CHI87LA168.md): Cessna 152 · Savoy, IL · Accident · No injuries · Limited investigation · Final report · Jul 16, 1987 · N4967B · Substantial damage > A student pilot was on his initial solo flight and had been instructed to do touch and go landings. On his second landing he did not achieve a proper flare attitude, the aircraft touched down flat and fast and began to porpoise. After approximately three… - [NTSB ATL87DEI10](https://openairdocs.org/ntsb/ATL87DEI10.md): Cessna 152 · Kent, OH · Accident · No injuries · Final report · Jul 16, 1987 · N95469 · Substantial damage > The student plt was on his third solo flight. As he was flaring to land, the aircraft ballooned twice and he initiated a recovery by adding power. However, the airplane settled and contacted the runway with the nosewheel first, damaging an engine mount &… - [NTSB MKC87LA140](https://openairdocs.org/ntsb/MKC87LA140.md): Piper PA-28-181 · Adams, NE · Accident · No injuries · Limited investigation · Final report · Jul 15, 1987 · N8097S · Substantial damage > After a normal approach and landing on a private sod strip, the pilot stated the aircraft swerved to the left of the runway to an adjoining plowed field. The aircraft struck a large hay bale followed by a large mound of dirt. Post accident investigation… - [NTSB BFO87LA047](https://openairdocs.org/ntsb/BFO87LA047.md): Hiller FH-1100 · Capron, VA · Accident · Minor injuries · Limited investigation · Final report · Jul 15, 1987 · N590FH · Substantial damage > The plt made a 60 mph power descent landing apch. When the helicopter descended to a height of about 10 ft AGL, the plt raised collective and applied left rudder pressure. The helicopter abruptly turned right. According to the plt, the helicopter did not… - [NTSB ATL87LA214](https://openairdocs.org/ntsb/ATL87LA214.md): Cessna 150J · Higginsport, OH · Accident · No injuries · Limited investigation · Final report · Jul 15, 1987 · N61107 · Substantial damage > The pilot reported that the aircraft skidded off the runway into a piece of parked farm equipment. The sod runway surface was wet. The pilot further reported that the right wing rose and the a/c veered off the runway. The pilot was unable to maintain… - [NTSB DEN87LA181](https://openairdocs.org/ntsb/DEN87LA181.md): Piper PA-18-150 · Worland, WY · Accident · No injuries · Limited investigation · Final report · Jul 14, 1987 · N4237Z · Substantial damage > The plt said the acft bounced during landing and he lost control. The acft ran off the rwy and when the plt applied the brakes too hard, the acft nosed over. - [NTSB CHI87LA169](https://openairdocs.org/ntsb/CHI87LA169.md): Cessna 172 · Madison, WI · Accident · No injuries · Limited investigation · Final report · Jul 14, 1987 · N2501L · Substantial damage > The instructor (CFI) & pvt plt (student) were on a renter's check-out flt to familiarize the student with a Cessna 172. While practicing landings, tower psnl provided a windshear alert. Drg an apch to land, the acft went into a high sink rate over the apch… - [NTSB NYC87LA203](https://openairdocs.org/ntsb/NYC87LA203.md): Piper PA-28-160 · Mattituck, NY · Accident · No injuries · Limited investigation · Final report · Jul 13, 1987 · N36509 · Substantial damage > Drg arrival, the plt tried to contact UNICOM, but was unable. He said he circled the 2200 ft rwy, but was unable to see the windsock due to reduced visibility with haze. He elected to land on rwy 19. The acft touched down about 500' from the departure end.… - [NTSB LAX87DUG05](https://openairdocs.org/ntsb/LAX87DUG05.md): Eipper Quicksilver MX II · Corona, CA · Accident · Serious injuries · Final report · Jul 13, 1987 · N4628G · Substantial damage > While attempting to land on runway 25 at the Corona airport, Corona, California, in gusting wind conditions, the aircraft stalled and collided with the terrain. The pilot said that the 'extreme gusty wind conditions' combined with a very light and stable… - [NTSB SEA87LA156](https://openairdocs.org/ntsb/SEA87LA156.md): Boeing IB75A · Spokane, WA · Accident · No injuries · Limited investigation · Final report · Jul 12, 1987 · N400JT · Substantial damage > The plt rprtd that when he landed, the wind was from 190 deg at 6 gusting 12 KTS. Drg the landing roll, after slowing to an estimated 15 KTS, the acft encountered a gust of wind which caused 'the right wing to dip.' Subsequently, the acft 'rotated' about 60… - [NTSB CHI87LA166](https://openairdocs.org/ntsb/CHI87LA166.md): Piper PA-28RT-201 · Chelsea, MI · Accident · No injuries · Limited investigation · Final report · Jul 12, 1987 · N2904A · Substantial damage > The pilot and three passengers attempted a takeoff from a 1800 foot sod, upsloping runway with tall, wet grass. Density altitude was 2700 feet. As the aircraft climbed out of ground effect the pilot said the engine sounded 'funny' and aborted the takeoff. The… - [NTSB LAX87LA270](https://openairdocs.org/ntsb/LAX87LA270.md): Cessna 172P · Grass Valley, CA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1987 · N5259K · Substantial damage > During a pleasure flight, while attempting to land at the airport, the pilot made a go around because he was too high. On the second approach, the pilot noted that he may have been a little high and fast. During the landing the aircraft bounced three times… - [NTSB ANC87LA094](https://openairdocs.org/ntsb/ANC87LA094.md): Cessna 185 · Aleknagik, AK · Accident · No injuries · Limited investigation · Final report · Jul 11, 1987 · N5430R · Substantial damage > The commercial pilot and his three passengers were on a fishing trip to a remote stream in southwest Alaska. The pilot attempted to land on a beach area near the stream and nosed the airplane over. The airplane was equipped with large 'tundra' tires that the… - [NTSB MKC87LA135](https://openairdocs.org/ntsb/MKC87LA135.md): Piper PA-28-140 · Waldron, AR · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 1987 · N5921U · Substantial damage > The plt said he was on a x-country for his commerical cert. He checked enroute wx for the return trip and was told VMC prevailed. However he rptd that he encountered haze & clouds. He let down to VMC but after he got in the clear all he could see was… - [NTSB MKC87LA134](https://openairdocs.org/ntsb/MKC87LA134.md): Beech BE-58 · Benton, AR · Accident · No injuries · Limited investigation · Final report · Jul 10, 1987 · N4JD · Substantial damage > During a positioning flt to pick up revenue passengers, PIC neglected to lower ldg gear for ldg. Acft was substantially damaged. PIC stated he forgot to lower gear and no warning horn had activated. - [NTSB FTW87DRA05](https://openairdocs.org/ntsb/FTW87DRA05.md): Cessna A188B · El Campo, TX · Accident · No injuries · Final report · Jul 10, 1987 · N731LP · Substantial damage > While attempting to land, the aircraft's left wing contacted the edge of a corn field. The aircraft veered to the left and impacted the ground causing substantial damage. - [NTSB LAX87LA259](https://openairdocs.org/ntsb/LAX87LA259.md): Cessna 150M · Cameron Park, CA · Accident · No injuries · Limited investigation · Final report · Jul 9, 1987 · N3811V · Substantial damage > During a pleasure flt, the non certificated plt landed the acft short of the rwy when he mistook a road for the rwy. The plt stated that the sun was in his eyes and by the time he realized that he was not landing on the rwy the acft was too low and slow to go… - [NTSB DEN87LA176](https://openairdocs.org/ntsb/DEN87LA176.md): Aeronca 7BCM · Bountiful, UT · Accident · No injuries · Limited investigation · Final report · Jul 9, 1987 · N8362H · Destroyed > The private pilot was practicing touch and go landing. The pilot reported the third landing was a wheel landing. Just after touchdown, adjacent to large petroleum tanks, the aircraft weather cocked to the right. The aircraft swerved right and departed the… - [NTSB ATL87LA207](https://openairdocs.org/ntsb/ATL87LA207.md): Aerostar RX-7 · Crestwood, KY · Accident · Serious injuries · Limited investigation · Final report · Jul 9, 1987 · N2897H · Substantial damage > The balloon contacted power lines as it was beginning to climb after an aborted ldg attempt. Electrical arcing ignited the propane fuel supply on board. The sole-occupant student plt jumped from the burning balloon and fell approx 40 ft onto a fence. The… - [NTSB ATL87LA206](https://openairdocs.org/ntsb/ATL87LA206.md): Cessna 172I · Goodway, AL · Accident · No injuries · Limited investigation · Final report · Jul 9, 1987 · N46233 · Substantial damage > The plt rprtd that he lndd long on a 2500 ft grass strip which was wet due to hvy dew. Drg the apch, he had an airspeed of 75 to 80 KTS with 30 deg of flaps. Subsequently, the acft slid off the departure end & struck a pecan tree. The recommended final apch… - [NTSB SEA87LA136](https://openairdocs.org/ntsb/SEA87LA136.md): Aeronca 7AC · Lester, WA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1987 · N85591 · Substantial damage > During landing roll onto the closed runway the aircrafts right wingtip struck a post. The airport was notamed closed but no x's had been marked on the runway. - [NTSB LAX87LA262](https://openairdocs.org/ntsb/LAX87LA262.md): Piper PA-31T2 · Novato, CA · Accident · No injuries · Limited investigation · Final report · Jul 8, 1987 · N38WA · Substantial damage > At the end of a cross country flt, the plt reported that he had extended the landing gear aprx 5 miles from the arpt and lowered partial flaps. Aprx 2 miles from the arpt the plt made shallow s turns for spacing and extended the rest of the flaps. The plt… - [NTSB LAX87IA260](https://openairdocs.org/ntsb/LAX87IA260.md): MBB BK117A-3 · Cupertino, CA · Incident · No injuries · Incident investigation · Final report · Jul 8, 1987 · N160BK · Minor damage > A Mbb BK117A-3 helicopter collided with wires while on final approach to an asphalt road in close proximity to a traffic accident. Night VMC prevailed at the time. The pilot indicated that he did not see the wires and was unaware of the collision until he was… - [NTSB DEN87LA183](https://openairdocs.org/ntsb/DEN87LA183.md): Cessna T188C · Winnett, MT · Accident · No injuries · Limited investigation · Final report · Jul 8, 1987 · N2058J · Substantial damage > During landing on a roadway used by the crop-duster for re-loading chemicals for spraying, the left spray boom contacted vegetation and slewed the acft sideways. The right wing was bent and the propeller was damaged. - [NTSB SEA87LA133](https://openairdocs.org/ntsb/SEA87LA133.md): Mooney M-20 · Spokane, WA · Accident · No injuries · Limited investigation · Final report · Jul 6, 1987 · N5265B · Substantial damage > At touchdown a prop strike occurred. The pilot immediatley added full power to go around. Since the prop strike was severe full power was not available. The pilot made a shallow 180 degree turn back to the rwy and landed on the grass. During the landing… - [NTSB SEA87LA132](https://openairdocs.org/ntsb/SEA87LA132.md): Piper PA-12 · Sun Valley, ID · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1987 · N3438M · Substantial damage > After landing touchdown, plt encountered swirling winds. Acft drifted left and into airport boundary (cyclone-type) fence. - [NTSB FTW87LA159](https://openairdocs.org/ntsb/FTW87LA159.md): Mooney M20J · Dallas, TX · Accident · Serious injuries · Limited investigation · Final report · Jul 5, 1987 · N56420 · Substantial damage > During flare/touchdown on runway 15, the aircraft's right wing came up sharply, due to a gusting cross wind, causing the left wing to strike the runway. The aircraft then cartwheeled, left wing, nose, right wing, causing substantial damage. Reported winds at… - [NTSB CHI87LA161](https://openairdocs.org/ntsb/CHI87LA161.md): Piper PA-28 · Duluth, MN · Accident · No injuries · Limited investigation · Final report · Jul 5, 1987 · N56808 · Substantial damage > Rprtdly, the winds were prevailing from the northeast & were variable & gusty. The plt entered the traffic pattern to land on rwy 14, but aborted his 1st attempt. During the 2nd apch, he used a notch of flaps & corrected for the x-wind by slipping the acft… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=398 ## 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=397 --- 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.