# NTSB investigations: Approach 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 218 of 420 · 20,992 cases ## Cases, newest first - [NTSB DEN82DA130](https://openairdocs.org/ntsb/DEN82DA130.md): Aerospatiale SA316B · Meeteetse, WY · Accident · Serious injuries · Final report · Jul 8, 1982 · N67081 · Destroyed > Prior to this flight, a long line had been attached to the helicopter for an external load operation. However, there wasa change in the schedule and the pilot was instructed to return to the base camp with six passengers. When the pilot took off, he was… - [NTSB MKC82DA119](https://openairdocs.org/ntsb/MKC82DA119.md): Gulfstream AA-5B · Mankato, KS · Accident · No injuries · Final report · Jul 5, 1982 · N74023 · Substantial damage > During a flight from des moines, Iowa to lamar, Colorado, the pilot elected to land at Mankato, Kansas for fuel. Reportedly, the pilot landed on runway 17 with the wind from 190 at 18 gusting 24 knots. The pilot stated that he established a steep, no flap,… - [NTSB DEN82AA127](https://openairdocs.org/ntsb/DEN82AA127.md): Cessna 310I · Denver, CO · Accident · 2 fatal · Final report · Jul 5, 1982 · N8818N · Destroyed > Upon arriving in the Denver area, the plt had penetrated 15 mi into the tca before being radar identified. He was instructed by the apch ctlr to contact tower by telfon after landing. After switching to tower freq he had to modify hisright base to rwy 8L to a… - [NTSB NYC82DA145](https://openairdocs.org/ntsb/NYC82DA145.md): Piper PA-23-250 · Ludlow, VT · Accident · No injuries · Final report · Jul 4, 1982 · N5343Y · Substantial damage > The pilot stated that during the landing, he encountered wind shear and the aircraft touched down about two feet short of the runway. He reported a 30 degree slope at the lip of the runway. All of the landing gear failed. The aircraft slid off the runway and… - [NTSB CHI82FA234](https://openairdocs.org/ntsb/CHI82FA234.md): Goans G-5 · Kankakee, IL · Accident · 1 fatal · Field investigation · Final report · Jul 4, 1982 · N59CG · Destroyed > The pilot was making his first flight since a special airworthiness certificate was issued. This aircraft was unique in that the rotor controls were cable instead of push-pull rods. The aircraft after takeoff started pitching up and down. This pitching… - [NTSB CHI82DA232](https://openairdocs.org/ntsb/CHI82DA232.md): Cessna 152 · Harlan, IN · Accident · No injuries · Final report · Jul 3, 1982 · N65609 · Substantial damage > Reportedly, the pilot was demonstrating a forced landing to the passenger by moving the mixture to cut-off. He stated that another aircraft interferred with his approach and he was unable to restart the engine to go around. Subsequently, the aircraft nosed… - [NTSB MKC82DA112](https://openairdocs.org/ntsb/MKC82DA112.md): Piper PA-24-250 · Oberlin, KS · Accident · Minor injuries · Final report · Jul 2, 1982 · N5540P · Destroyed > The pilots aborted a landing because of suspected landing gear problems. On the subsequent approach the engine stopped when the fuel selector was correctly changed by one pilot and reset incorrectly by the other pilot. During the forced landing the aircraft… - [NTSB LAX82FUQ15](https://openairdocs.org/ntsb/LAX82FUQ15.md): Quickie QAC-1 · Mojave, CA · Accident · 1 fatal · Final report · Jul 2, 1982 · N82X · Destroyed > The acft was built as a one-time only acft for record breaking distance flying, presumably for an around-the-world flight without refueling. Immediately after takeoff, the plt radioed the chase plane that he had some minor problem & was going to land. After… - [NTSB NYC82DA135](https://openairdocs.org/ntsb/NYC82DA135.md): Piper PA-28-140 · Ambler, PA · Accident · No injuries · Final report · Jul 1, 1982 · N75286 · Substantial damage > The student pilot stated that during the landing approach, she experienced windshear resulting in the aircraft landing short of the intended touchdown point. The nose gear and the left main gear were sheared off after the aircraft collided with a dirt… - [NTSB MKC82DA111](https://openairdocs.org/ntsb/MKC82DA111.md): Grumman AA1C · St. Louis, MO · Accident · No injuries · Final report · Jul 1, 1982 · N9565U · Substantial damage > During a dual training flight the aircraft was allowed to descend into a corn crop short of the runway. The aircraft continued to the runway but landed hard and collapsed the landing gear. - [NTSB DEN82DA122](https://openairdocs.org/ntsb/DEN82DA122.md): Cessna 340 · Las Animas, CO · Accident · No injuries · Final report · Jun 30, 1982 · N2745B · Substantial damage > The aircraft collided with a four foot high irrigation ditch 50 feet from the approach end of runway 8 during short final. The pilot stated that he had planned the touch down point close to the end of the runway because the runway was only 3800 feet long.… - [NTSB NYC82FA134](https://openairdocs.org/ntsb/NYC82FA134.md): Piper PA-31 · Bennington, VT · Accident · No injuries · Field investigation · Final report · Jun 28, 1982 · N620WF · Substantial damage > While on approach to land, the pilot noticed the aircraft's gear warning lights were out and the circuit breakers were tripped. The pilot advised operations and started a fly-by when he noticed a fire in the left engine. The pilot feathered the left engine… - [NTSB MIA82DA144](https://openairdocs.org/ntsb/MIA82DA144.md): Cessna 210N · Pensacola, FL · Accident · No injuries · Final report · Jun 28, 1982 · N6392Y · Substantial damage > The pilot stated that the engine stopped running while on final approach to runway 18, at an altitude of about 250 to 300 feet. Unable to restore power the pilot elected to land wheels-up in an open field about 1/4 mile north of the approach end of the… - [NTSB SEA82DA097](https://openairdocs.org/ntsb/SEA82DA097.md): Mooney M20A · Twin Falls, ID · Accident · Minor injuries · Final report · Jun 27, 1982 · N8380E · Substantial damage > During his preflight inspection, the pilot noted that the right fuel tank was partially full, but the left tank was nearly empty. The left tank was serviced with 12 gallons of fuel, but the pilot reported that the fuel selector was inadvertently left in the… - [NTSB NYC82FNA18](https://openairdocs.org/ntsb/NYC82FNA18.md): Callair A-9 · Salisbury, MA · Accident · Serious injuries · Final report · Jun 27, 1982 · N3590G · Destroyed > After taking off, the pilot began an approach to pick up an advertising banner. A witness observed the plane circling to the right. He reported that as the plane turned right, it suddenly plunged straight to the ground. The aircraft crashed in a marshland. - [NTSB NYC82DA132](https://openairdocs.org/ntsb/NYC82DA132.md): Piper PA-28-180 · Presque Isle, ME · Accident · Minor injuries · Final report · Jun 27, 1982 · N9592J · Substantial damage > During a cross-country flight the pilot made two stops to avoid a slow moving front, the pilot stated he reached the destination later than planned and departed with less fuel on board than planned. The engine quit during the return flight. A forced landing… - [NTSB MKC82FCJ03](https://openairdocs.org/ntsb/MKC82FCJ03.md): Cessna 177 · Near Qgallala, NE · Accident · Serious injuries · Final report · Jun 27, 1982 · N29397 · Destroyed > The pilot reported that during the preflight, there was about 4 inches of fuel in one tank and about 3 inches in the other tank. However, he did not remember the accident or what happended for about a week thereafter. Witnesses reported that the engine quit… - [NTSB MIA82DA143](https://openairdocs.org/ntsb/MIA82DA143.md): Cessna 150 · Hollywood, FL · Accident · Minor injuries · Final report · Jun 27, 1982 · N6064G · Destroyed > While on final approach for landing, the pilot noticed a loss of power at about 500 ft AGL. He verified that his carburetor heat was on and pushed the throttle forward. Power was restored for a second, but once again, it was lost. While landing on hospital… - [NTSB FTW82DA290](https://openairdocs.org/ntsb/FTW82DA290.md): Ryan Aeronautics ST3KR (PT 21) · Friendswood, TX · Accident · Minor injuries · Final report · Jun 27, 1982 · N53999 · Substantial damage > The student pilot took off with a passenger to practice landings. On the second landing, the aircraft collided with a ditch short of the runway and flipped inverted. - [NTSB FTW82DA255](https://openairdocs.org/ntsb/FTW82DA255.md): Cessna 172XP · Kennedale, TX · Accident · No injuries · Final report · Jun 27, 1982 · N7319K · Substantial damage > The aircraft collided with light unmarked aluminum wires during an approach to land at a private airport. These wires were not noticed when an overflight was made prior to landing. The aircraft was landed ok after the collision. The instructor was flying the… - [NTSB ATL82DA177](https://openairdocs.org/ntsb/ATL82DA177.md): Piper PA-22-150 · Hixson, TN · Accident · Minor injuries · Final report · Jun 27, 1982 · N2604P · Substantial damage > The pilot elected to takeoff on a dark night without runway lights. He stated that the runway lights were not available at the time since the operator was out of town. According to the pilot and other witnesses, at least part of the airport environment was… - [NTSB NYC82DA133](https://openairdocs.org/ntsb/NYC82DA133.md): Grumman AA-5A · Lincoln Park, NJ · Accident · No injuries · Final report · Jun 26, 1982 · N26870 · Substantial damage > On final approach the aircraft seemed to sink and full power was applied. The aircraft collided with a fence at the approach end of runway 19 resulting in substantial damage. There was no preimpact malfunction or failure of the aircraft engine determined. - [NTSB LAX82AA235](https://openairdocs.org/ntsb/LAX82AA235.md): Cessna 320B · San Jose, CA · Accident · 3 fatal · Final report · Jun 26, 1982 · N510BC · 2 aircraft · Destroyed > The C-172M had departed reid-hillview arpt (6 mi east) & improperly entered a right downwind for rwy 30R at San Jose. The C-320B had executed a go-around from rwy 30R due to other traffic & was in a climbing turn also entering downwind for rwy 30R. The C-320B… - [NTSB FTW82DA254](https://openairdocs.org/ntsb/FTW82DA254.md): Downer Aircraft Industries Republic RC-3 · Llano, TX · Accident · No injuries · Final report · Jun 26, 1982 · N6441K · Substantial damage > The pilot was on a test flight to check the engine in the amphibious aircraft. As the landing gear was being lowered to land at the airport, a "pop" was heard. Reportedly, the noise occurred when the clevis on the rod end of the retract/extend cylinder… - [NTSB DEN82DA117](https://openairdocs.org/ntsb/DEN82DA117.md): Cessna 188 · 25nm Sw Santa R, MT · Accident · No injuries · Final report · Jun 25, 1982 · N2066J · Substantial damage > After dispensing his second load, the pilot returned to the airport where he circled to wait for traffic to clear the runway. About 1/2 way through the circle, the engine lost power and the pilot observed that the fuel gauges indicated empty. He landed on a… - [NTSB SEA82DA094](https://openairdocs.org/ntsb/SEA82DA094.md): Piper PA-28-180 · Toledo, WA · Accident · No injuries · Final report · Jun 24, 1982 · N9544J · Substantial damage > The pilot reported that before landing, he turned the fuel boost "on", applied carburetor heat, and set the power at roughly 1500 RPM. He reported that the mixture had been in the full rich position during the entire flight. He encountered a crosswind on… - [NTSB CHI82FER22](https://openairdocs.org/ntsb/CHI82FER22.md): Aeronca 7AC · Maple Plain, MN · Accident · Serious injuries · Final report · Jun 24, 1982 · N84554 · Substantial damage > The pilot reported that he circled the farm area several times to find a suitable landing site. He decided on a portion of the farmer's field next to the house and made a final pass to inspect the area. During the pass, he saw some trees and reportedly… - [NTSB ANC82DA052](https://openairdocs.org/ntsb/ANC82DA052.md): Cessna 182 · Kenai, AK · Accident · Minor injuries · Final report · Jun 24, 1982 · N6347A · Substantial damage > While on a flight from mckinley park to Kenai, AK, the pilot flew around the east side of anchorage, so a passenger could take pictures. About half way through the flight, the pilot became concerned about his fuel supply but believed he could reach his… - [NTSB FTW82DA241](https://openairdocs.org/ntsb/FTW82DA241.md): Piper PA-38-112 · French Settleme, LA · Accident · Serious injuries · Final report · Jun 22, 1982 · N2495N · Destroyed > The pilot departed shreveport, LA at 1400 CDT on the return part of a cross-country to jackson, MS. A VFR flight plan had been filed listing 3 1/2 hrs of fuel on board. At about 1706 CDT, the plane crashed near French settlement, LA, about 140 miles south… - [NTSB LAX82FA230](https://openairdocs.org/ntsb/LAX82FA230.md): Cessna P210N · Jamul, CA · Accident · 1 fatal · Field investigation · Final report · Jun 21, 1982 · N6690P · Destroyed > The plt was being vectored for another approach after executing a missed approach. At 1642 the plt was cleared for 5,000 ft. at 1643 the plt was given a heading of 090, vector for the final approach course. At 1647 the plt was given a heading of 340. The… - [NTSB DEN82FTE19](https://openairdocs.org/ntsb/DEN82FTE19.md): Cessna 182 · Loma, CO · Accident · Serious injuries · Final report · Jun 21, 1982 · N9886 · Destroyed > The pilot while attempting to straighten the aircraft and go around collided with small trees and nosed over. The pilot stated that probably the indecision of trying to stop or abort the landing slowed the aircraft during the attempted go around. - [NTSB MKC82DA109](https://openairdocs.org/ntsb/MKC82DA109.md): Balloon Works Firfly 7 · Ballwin, MO · Accident · No injuries · Final report · Jun 20, 1982 · N1506A · Substantial damage > The student pilot was demonstrating his ability to make 3 landings to meet the flight requirements for a private pilot rating. The first 2 landing were without incident. After the third takeoff, an increase in the wind velocity was encountered. For the third… - [NTSB LAX82DA227](https://openairdocs.org/ntsb/LAX82DA227.md): Cessna 172 · Fremont, CA · Accident · No injuries · Final report · Jun 20, 1982 · N1846V · Destroyed > The pilot reported that while on a final approach for landing, a sudden loss of altitude occurred when he was at about 150 ft AGL and the landing gear collided with powerlines near the approach end of the runway. Airspeed was lost after hitting the powerlines… - [NTSB CHI82DA218](https://openairdocs.org/ntsb/CHI82DA218.md): Mooney M20J · Duluth, MN · Accident · Serious injuries · Final report · Jun 20, 1982 · N201EC · Destroyed > Plt wx briefed at 2148 by kenora fss, ontario, Canada. Area & terminal forecasts indicated VFR conds to exist at Duluth. Subsequently, at 2151, Duluth arpt notamed closed, all rwy & approach lites out. The ILS rwy 9 g/s later went out of service, but not… - [NTSB ATL82IA170](https://openairdocs.org/ntsb/ATL82IA170.md): Mooney M20J · Dauphin Island, AL · Incident · No injuries · Incident investigation · Final report · Jun 20, 1982 · N201WX · Minor damage > After a normal flight from birmingham, AL, the pilot executed a visual full circuit approach to runway 12 at Dauphin Island, AL. The pilot stated that he stabilized on final at 72 knots with full flaps and that he had a 5-10 knot crosswind from the south. The… - [NTSB NYC82FNA20](https://openairdocs.org/ntsb/NYC82FNA20.md): Smith Aerostar 601 · Martha'S Vineyard, MA · Accident · No injuries · Final report · Jun 19, 1982 · N71MA · Substantial damage > During an ILS with the autopilot coupler on, a high sink rate developed toward the end of the approach. The pilot uncoupled the autopilot and began a missed approach, but the aircraft hit the top of a tree. He diverted and landed at providence, RI without… - [NTSB NYC82DA130](https://openairdocs.org/ntsb/NYC82DA130.md): Stinson 180-2 · Richland, NY · Accident · No injuries · Final report · Jun 19, 1982 · N9513K · Substantial damage > While on a local flight, the pilot observed a front moving in, so he decided to return to the airport and land. He reported that there was no turbulence while he was on downwind or base and the wind sock was favoring runway 16. However, on final approach,… - [NTSB FTW82DA234](https://openairdocs.org/ntsb/FTW82DA234.md): Beech 77 · Jackson, LA · Accident · No injuries · Final report · Jun 19, 1982 · N3726Z · Substantial damage > While in the vicinity of Jackson, LA, the instructor pilot (ip) had the student make a simulated forced landing. The landing was to be to a full stop on the Jackson airport. According to the initial modification, the student allowed the aircraft to drift left… - [NTSB DEN82DA107](https://openairdocs.org/ntsb/DEN82DA107.md): Piper PA-28-151 · Jackson, MT · Accident · No injuries · Final report · Jun 19, 1982 · N4346F · Substantial damage > The pilot stated that he overshot the runway by being too high and that it was his intention to go around for a second pass. He further stated that his airspeed was too low and that he was behind the power curve and was not able to climb out of the valley at… - [NTSB CHI82FER21](https://openairdocs.org/ntsb/CHI82FER21.md): Barrett BG-5 · Maple Plain, MN · Accident · Serious injuries · Final report · Jun 19, 1982 · N8066B · Destroyed > During landing approach the gyrocopter collided with a powerline. The student pilot lost control and crashed beyond the powerlines. The pilot was attempting to land in a farm field adjacent to a relative's house. - [NTSB SEA82DA090](https://openairdocs.org/ntsb/SEA82DA090.md): Hughes 269B · Mt St Helens, WA · Accident · Minor injuries · Final report · Jun 18, 1982 · N9352F · Destroyed > The pilot intended to proceed to Mt St Helens to land near spirit lake. The winds in the vicinity of the desired landing point were too strong for a safe landing. Therefore, an alternate spot was selected below the ridge line and presumably sheltered from the… - [NTSB ATL82FIG09](https://openairdocs.org/ntsb/ATL82FIG09.md): Bellanca 7GCBC · Woodbine, MD · Accident · 2 fatal · Final report · Jun 18, 1982 · N5153X · Destroyed > After taking off from runway 21, the pilot made a left turn-out then reentered a downwind for runway 03. At about the same time, a Cessna 150 was departing from runway 21 and a glider entered the pattern to land on runway 03. Two witnesses observed the… - [NTSB NYC82AA125](https://openairdocs.org/ntsb/NYC82AA125.md): Piper PA-28RT-201 · Dunkirk, NY · Accident · 4 fatal · Final report · Jun 17, 1982 · N8192A · Destroyed > The flt was cleared for a VOR rwy 24 apch. At 2226 the plt reported the arpt in sight. At 2228 the acft crashed 4,000 ftsouth of the departure end of rwy 24 on a heading of 115 deg. The jamestown,NY 2250 wx observation was partial obscuration, estimated 200… - [NTSB SEA82DA107](https://openairdocs.org/ntsb/SEA82DA107.md): Cessna U206 · Dry Bay, AK · Accident · No injuries · Final report · Jun 16, 1982 · N1952U · Substantial damage > The pilot reported that he arrived in marginal VFR weather conditions with rain and variable winds gusting to 12 knots. He stated that the windsock favored a landing to the east, downhill, to a wet grass runway. He reported that during a short field approach,… - [NTSB ATL82DA166](https://openairdocs.org/ntsb/ATL82DA166.md): Piper 22-160 · Lynchburg, VA · Accident · Minor injuries · Final report · Jun 16, 1982 · N9843D · Substantial damage > The pilot took off from newport news, VA on a VFR flight to south boston, VA. Later at dusk, he contacted the roanoke fss and asked for an "accurate fix" of his position. At that time, the pilot indicated that he was low on fuel. Fss personnel reported that… - [NTSB LAX82DA221](https://openairdocs.org/ntsb/LAX82DA221.md): Weatherly 201B · Greenfield, CA · Accident · Minor injuries · Final report · Jun 15, 1982 · N1280W · Destroyed > The pilot took off with 1150 lbs of sulfur dust and a full load of fuel. When he arrived at the field to be dusted, he was unable to dispense his load due to the presence of laborers in an adjacent field. When the pilot returned to the airport with his load,… - [NTSB CHI82FA209](https://openairdocs.org/ntsb/CHI82FA209.md): Cessna 421 · Racine, WI · Accident · No injuries · Field investigation · Final report · Jun 15, 1982 · N421CB · Substantial damage > The plt stated he experienced moderate to severe turbulence enroute. A coupled ILS approach was flown without problems, but the plt stated he had to work hard. The flt broke out at about 1,000 ft MSL & at this time he acquired visual contact with the rwy. He… - [NTSB LAX82DA220](https://openairdocs.org/ntsb/LAX82DA220.md): Cessna 172 · Lancaster, CA · Accident · No injuries · Final report · Jun 14, 1982 · N1580Y · Substantial damage > During flight, the pilot landed at an airport to refuel. However, the fuel trucks were locked up and no one was at the UNICOM office, even though, the airport directory indicated the field was attended and fuel should have been available. The pilot… - [NTSB FTW82FPG15](https://openairdocs.org/ntsb/FTW82FPG15.md): Piper PA-28-140 · Gould, AR · Accident · Serious injuries · Final report · Jun 14, 1982 · N4531X · Destroyed > The student pilot stated that he was making a landing over wires when he stalled and the aircraft nosed into the ground. - [NTSB MKC82FCQ10](https://openairdocs.org/ntsb/MKC82FCQ10.md): Beech A35 · Bird City, KS · Accident · Serious injuries · Final report · Jun 13, 1982 · N5200A · Substantial damage > The pilot entered traffic to land on runway 26 at a private airport with no UNICOM and no usable windsock. He stated that on final approach, the aircraft encountered a gust of wind and rolled to the right. He was unable to recover. The right wing hit the… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=219 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=218 --- 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.