# NTSB investigations: Maneuvering 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 233 of 378 · 18,851 cases ## Cases, newest first - [NTSB FTW82DA172](https://openairdocs.org/ntsb/FTW82DA172.md): Grumman G164B · Marvell, AR · Accident · No injuries · Final report · May 11, 1982 · N6625K · Destroyed > During an aerial application process the pilot allowed the aircraft to collide with a rice levy. The aircraft was destroyed and there were no injuries to the pilot. - [NTSB ATL82FLT04](https://openairdocs.org/ntsb/ATL82FLT04.md): Piper PA-32R-300 · Iuka, MS · Accident · 3 fatal · Final report · May 11, 1982 · N444ME · Destroyed > The aircraft crashed during a pass across the airport. A witness was parked, facing east, in the runup area for runway 18. According to him, the the aircraft took off about 6 minutes earlier, made a traffic pattern, and crashed behind and to his right. The… - [NTSB ANC82DAG21](https://openairdocs.org/ntsb/ANC82DAG21.md): Piper J3C-75 · Soldotna, AK · Accident · No injuries · Final report · May 11, 1982 · N27006 · Substantial damage > While executing departure stalls the elevator locked in the full up position. After several attempts to regain control, it was found that partial control was possible in a power off descending turn. This attitude was maintained until just prior to ground… - [NTSB NYC82DA089](https://openairdocs.org/ntsb/NYC82DA089.md): Bell 47g-3b (Soloy Conversion) · New Hope, PA · Accident · No injuries · Final report · May 10, 1982 · N5449C · Substantial damage > While making a cleanup swath around the bottom of a hill, the helicopter collided with wires. The pilot reported that he did not see the wires while holding his head in such a manner as to reduce the effect of sun-glare. After hitting the wires, the pilot… - [NTSB LAX82FVD16](https://openairdocs.org/ntsb/LAX82FVD16.md): Scorpion 133 · Fremont, CA · Accident · No injuries · Final report · May 8, 1982 · N19NS · Substantial damage > The student pilot, builder of the helicopter was on a dual instructional flight with an instructor pilot (ip). The student had about 71 hours in this make and model while the ip had 18 hours. After making two landings, a descending turn was made to a downwind… - [NTSB SEA82FYA07](https://openairdocs.org/ntsb/SEA82FYA07.md): Hughes 369HS · Gooding, ID · Accident · Serious injuries · Final report · May 6, 1982 · N9184F · Destroyed > While making a turn at the end of a swath run, the pilot heard a bang and then noticed a loss of engine power. He entered an autorotative landing from a low altitude at low airspeed. Subsequently, the helicopter landed hard and rolled over on its right side.… - [NTSB FTW82FRJ10](https://openairdocs.org/ntsb/FTW82FRJ10.md): Continental Tomcat MK6C · Cottonport, LA · Accident · 1 fatal · Final report · May 5, 1982 · N9098T · Destroyed > The plt was familiarizing himself with the acft & the local area. The plt's log book showed only one hour of flt time logged between 9/23/81 & the date of the accident. Witnesses observed the acft flying for some time over the city at 300-400 ft AGL making… - [NTSB FTW82FRD10](https://openairdocs.org/ntsb/FTW82FRD10.md): Cessna 207 · Franklinton, LA · Accident · 1 fatal · Final report · May 5, 1982 · N73013 · Substantial damage > The passenger stated that after sharp turns at low altitude over a farm house they did a roll & were too low to recover prior to striking trees. The acft came to rest inverted in a 4-5 ft deep farm pond. The autopsy report shows the plt's death by asphyxia… - [NTSB CHI82DA150](https://openairdocs.org/ntsb/CHI82DA150.md): Sikorsky S-55B · Otsego, OH · Accident · No injuries · Final report · May 4, 1982 · N16861 · Substantial damage > The pilot was spreading fertilizer by using external buckets. As he was unhooking a bucket, the engine lost power. He did a hovering autorotation, but the helicopter settled on a bucket, tipped over and allowed the main rotor blades to hit the ground. An… - [NTSB FTW82FRA20](https://openairdocs.org/ntsb/FTW82FRA20.md): Rockwell Intl S-2R · Alvin, TX · Accident · Serious injuries · Final report · May 3, 1982 · N8456V · Destroyed > The pilot's father reported that he and his son were en route in separate aircraft to apply fertilizer to a rice field. He noticed his son dive from 500 ft to about 100 ft where the aircraft struck the top ground wires of a transmission line. The plane… - [NTSB ATL82DA122](https://openairdocs.org/ntsb/ATL82DA122.md): Piper PA-25-235 · Greenwood, MS · Accident · No injuries · Final report · May 3, 1982 · N8617L · Substantial damage > The pilot smelled an odor similar to burning rubber followed by a loss of oil pressure. During the attempted forced landing the right wing contacted a fence causing substantial damage. Examination of the engine logbook reflected installation of new pistons,… - [NTSB FTW82FRJ11](https://openairdocs.org/ntsb/FTW82FRJ11.md): Cessna 170B · Plain Dealing, LA · Accident · Serious injuries · Final report · May 2, 1982 · N1960C · Destroyed > The aircraft was observed over a river at low altitude when it struck a powerline. The pilot was unable to recall anything about the flight after the takeoff. The passenger reported that they had flown to springhill to obtain 80 octane fuel, and while… - [NTSB FTW82FQD11](https://openairdocs.org/ntsb/FTW82FQD11.md): Piper PA-28-140 · Mescalero, NM · Accident · 2 fatal · Final report · May 2, 1982 · N1884J · Destroyed > Two witnesses observed the aircraft flying eastbound at low altitude along a highway, then begin a climbing turn over sharply rising terrain. After completing about 90 degrees of turn, the aircraft struck the tops of trees about 30 ft AGL. About 12 paces… - [NTSB ATL82FKM03](https://openairdocs.org/ntsb/ATL82FKM03.md): Hudson 2-2-2E · Statesville, NC · Accident · 1 fatal · Final report · May 2, 1982 · N1035G · Substantial damage > Witnesses observed the pilot make a low pass parallel to runway 26, then pull-up sharply in a left climbing turn. The witnesses reported that after the pull-up, the left wing dropped and the aircraft entered a spin. The aircraft crashed about 1000 ft south of… - [NTSB ATL82FKG13](https://openairdocs.org/ntsb/ATL82FKG13.md): Great Lakes 2T-1A-2 · Thomson, GA · Accident · 2 fatal · Final report · May 2, 1982 · N3559L · Destroyed > Prior to the accident, witnesses observed the aircraft while aerobatics were being performed. One witness estimated that the maneuvers were being flown between 100 and 300 yards AGL. Reportedly, the aircraft had been performing rolls, loops and spins for… - [NTSB NYC82DHD11](https://openairdocs.org/ntsb/NYC82DHD11.md): Bell 47G · New Egypt, NJ · Accident · Minor injuries · Final report · May 1, 1982 · N1002P · Destroyed > The pilot stated that he was about to finish spraying the field and had only two passes remaining when the accident occurred. Passes were made to the north and south with the wind from the west at 5 to 10 knots. After completing a pass to the south, he pulled… - [NTSB FTW82DA174](https://openairdocs.org/ntsb/FTW82DA174.md): Boeing E75 · Erick, OK · Accident · No injuries · Final report · May 1, 1982 · N5186N · Destroyed > The pilot was pulling up from the swath run and collided with wires. The aircraft nosed over during the forced landing. - [NTSB FTW82DA157](https://openairdocs.org/ntsb/FTW82DA157.md): Cessna 150M · Harrison, AR · Accident · No injuries · Final report · May 1, 1982 · N704EY · Substantial damage > The pilot was performing a low, slow pass to make a bean bag drop on a taxiway target when he lost control, collided with a ditch and nosed over. The aircraft flipped inverted. The stall warning horn was sounding during the maneuver. - [NTSB CHI82FA141](https://openairdocs.org/ntsb/CHI82FA141.md): Cessna 152 · Kenosha, WI · Accident · 2 fatal · Field investigation · Final report · Apr 29, 1982 · N48732 · Destroyed > The aircraft crashed in a steep nosed down attitude while the pilot and one passenger were on a local flight. Prior to the accident, witnesses observed the pilot practicing stalls below 1000 ft. no precrash failures were found. The last entry in the pilot's… - [NTSB FTW82FRA19](https://openairdocs.org/ntsb/FTW82FRA19.md): Boeing A75 · Chapell Hill, TX · Accident · 1 fatal · Final report · Apr 27, 1982 · N1774B · Destroyed > During a pull-up from a swath run, the right wing of the aircraft struck the top of a 45 ft pecan tree. The lower right wing tip separated, and the aircraft rolled inverted and crashed. - [NTSB DEN82DA073](https://openairdocs.org/ntsb/DEN82DA073.md): Hughes 369D (500D) · Coalville, UT · Accident · Minor injuries · Final report · Apr 27, 1982 · N8684F · Substantial damage > The helicopter made a hard landing after the pilot experienced a power train failure while flying low and slow. The weather was VMC and a VFR flight plan was filed. The crew was searching for lost mining equipment in a low slow search pattern. The pilot heard… - [NTSB ATL82FKQ12](https://openairdocs.org/ntsb/ATL82FKQ12.md): Bell/Soloy 47G-3B · Magee, MS · Accident · 1 fatal · Final report · Apr 27, 1982 · N8469E · Destroyed > The Bell 47G-3B with a Soloy conversion was being used to demonstrate an aerial application spraying technique for use along powerline right-of-ways. For about 15 to 20 minutes after takeoff, routine spray runs were made over several different powerlines… - [NTSB MKC82FCD07](https://openairdocs.org/ntsb/MKC82FCD07.md): Bellanca 8KCAB · Fairfield, IA · Accident · 1 fatal · Final report · Apr 26, 1982 · N5035N · Substantial damage > The pilot stated that he intended to fly down the runway to have a photographer take pictures to be used in publicity for airshows. After several passes (one inverted), the pilot landed to talk with the photographer. The photographer stated they agreed that a… - [NTSB SEA82DA058](https://openairdocs.org/ntsb/SEA82DA058.md): Grumman G-164A · S. Of Echo, OR · Accident · No injuries · Final report · Apr 25, 1982 · N4897 · Substantial damage > During a spray run the pilot experienced a power loss. After pulling up to 100 feet AGL and turning 90 degrees the engine ceased to operate. The pilot completed a forced landing in a nearby soft wheat field and after rolling approximately 300 feet the… - [NTSB NYC82FHM06](https://openairdocs.org/ntsb/NYC82FHM06.md): Spezio Sport DAL-1 · Lagrange, NY · Accident · 1 fatal · Final report · Apr 25, 1982 · N1796 · Destroyed > The owner/pilot of the aircraft was a photographer with an amputation above his left wrist. His class iii medical certificate stated that he must wear an artifical limb while flying. The pilot had been asked to photograph a building in an industrial park.… - [NTSB CHI82FA135](https://openairdocs.org/ntsb/CHI82FA135.md): Dauntless D52 · Sebring, OH · Accident · 2 fatal · Field investigation · Final report · Apr 25, 1982 · N1422D · Destroyed > Both wings separated during an experimental test flight of the motorized glider. The plt had indicated the tests would include climbing to a safe altitude & doing a few power-off shallow glides to see if there was any indication of flutter at perhaps max… - [NTSB MIA82FKJ04](https://openairdocs.org/ntsb/MIA82FKJ04.md): Grumman G-164 · Malone, FL · Accident · 1 fatal · Final report · Apr 23, 1982 · N6521K · Destroyed > After completing a spray run the aircraft was observed to pull up in a tight left turn striking a water tower approximately 5 feet from the top. The aircraft spiraled down and crashed approximately 135 feet from the base of the tower. - [NTSB DEN82DA065](https://openairdocs.org/ntsb/DEN82DA065.md): Piper PA-18-180 · Savage, MT · Accident · No injuries · Final report · Apr 22, 1982 · N55WP · Substantial damage > The pilot reported that after takeoff, he remained at about 100 ft AGL and proceeded toward Savage, MT. He said he intended to fly over his partner's farm near Savage. Nearly 20 minutes after takeoff, a loss of engine RPM was noted as the pilot approached his… - [NTSB MKC82FA058](https://openairdocs.org/ntsb/MKC82FA058.md): Beech B95 · Climax Springs, MO · Accident · 1 fatal · Field investigation · Final report · Apr 21, 1982 · N9639R · Destroyed > Approximately 8 min after takeoff the acft was observed at a very low altitude. It started a right turn that gradually steepened until the wings were almost vertical. After almost two turns the wings leveled for an instant, then the right wing & nose dropped… - [NTSB MIA82FLD18](https://openairdocs.org/ntsb/MIA82FLD18.md): Sikorsky H-19A · Croom, FL · Accident · Minor injuries · Final report · Apr 21, 1982 · N15185 · Substantial damage > The pilot reported that he was spraying about 15 ft over a lake when the engine lost power. He entered an autorotation and ditched the helicopter in the lake. After recovery from the lake, a check of the engine revealed no precrash failures. - [NTSB MIA82DA105](https://openairdocs.org/ntsb/MIA82DA105.md): Robinson R-22 · Vero Beach, FL · Accident · Minor injuries · Final report · Apr 21, 1982 · N9033B · Substantial damage > The helicopter was air taxied to the fuel pump for refueling. The aircrew remained in the helicopter while the lineman serviced the fuel tank. After refueling and starting the engine, the instructor was at the controls while in close proximity of the pumps.… - [NTSB CHI82DA128](https://openairdocs.org/ntsb/CHI82DA128.md): Piper PA-32 · Brookfield, OH · Accident · Serious injuries · Final report · Apr 21, 1982 · N2477U · Destroyed > Witnesses observed the aircraft performing turns and rolls at an altitude of approximately 300 feet AGL. A decrease and subsequently an increase in engine power was heard. The aircraft was observed crashing into trees. Investigation revealed that the pilot… - [NTSB DEN82FTC03](https://openairdocs.org/ntsb/DEN82FTC03.md): Aerospatiale SA315B · Big Piney, WY · Accident · Serious injuries · Final report · Apr 20, 1982 · N9007N · Destroyed > The acft was engaged in seismic activity supplying explosives by long line. The eng failed at about 400-500 ft AGL. The load was released & an open field was selected. At about 150 ft AGL the plt was unable to maintain rotor RPM & the acft impacted the ground… - [NTSB LAX82FVG20](https://openairdocs.org/ntsb/LAX82FVG20.md): Smith Miniplane DSA-1 · Chicago Park, CA · Accident · 1 fatal · Final report · Apr 18, 1982 · N103L · Destroyed > The aircraft crashed while the pilot was performing aerobatic maneuvers at low altitude. The impact occurred just below the top of a ridge at the edge of a valley as the pilot was completing a loop. He was performing the loop perpendicular to the ridge, and… - [NTSB LAX82FUQ13](https://openairdocs.org/ntsb/LAX82FUQ13.md): Cessna 150 · Santa Barbara, CA · Accident · 1 fatal · Final report · Apr 18, 1982 · N66631 · Destroyed > The aircraft crashed in a wooded canyon area beneath the cold spring canyon arch bridge in los padres national forest. The plane impacted about 250 yards north of the bridge while on a northerly heading. Broken tree tops and branches were found over an area… - [NTSB LAX82FXQ07](https://openairdocs.org/ntsb/LAX82FXQ07.md): Cessna 150 · Wadsworth, NV · Accident · 1 fatal · Final report · Apr 17, 1982 · N7820F · Destroyed > While flying over the truckee river on a local flight, the left wing of the aircraft struck a group of five powerlines. The aircraft then impacted the water in a nose down attitude. It was carried downstream about 100 yards by the current before coming to… - [NTSB LAX82DA137](https://openairdocs.org/ntsb/LAX82DA137.md): Avres S-2R · Kettleman City, CA · Accident · No injuries · Final report · Apr 16, 1982 · N5672X · Substantial damage > The pilot stated that the fuel gauge was faulty so he flew by time. On the day of the accident the battery on the pilot's electric watch ran down. The pilot reported that the aircraft ran out of fuel and crashed in an open field with his watch still showing… - [NTSB LAX82DVA14](https://openairdocs.org/ntsb/LAX82DVA14.md): Hiller UH-12E · Chowchilla, CA · Accident · Serious injuries · Final report · Apr 15, 1982 · N67156 · Destroyed > The pilot was conducting an aerial dusting operation over a grape vineyard. While on a swath run, he gradually converged on a powerline that crossed the field at a slight angle from his flight path. As he proceeded on his swath run, the helicopter got closer… - [NTSB DEN82DA088](https://openairdocs.org/ntsb/DEN82DA088.md): Aerospatiale SA315B · Thayne, WY · Accident · Minor injuries · Final report · Apr 15, 1982 · N48089 · Substantial damage > The helicopter was hovering to pick up a sling load when a loud bang was heard and the aircraft began to spin counter clockwise. Investigation revealed that the tail rotor drive shaft had broken. "Examination of the shaft break disclosed a small fracture… - [NTSB FTW82DA128](https://openairdocs.org/ntsb/FTW82DA128.md): Grumman G-164A · Victoria, AR · Accident · No injuries · Final report · Apr 13, 1982 · N9963 · Destroyed > The pilot reported taking off with full tanks and about 1600 lbs of fertilizer. After takeoff, he flew a short distance to the field that was being worked and made one swath run. During a procedure turn close to trees, the aircraft stalled and crashed. - [NTSB NYC82FGT13](https://openairdocs.org/ntsb/NYC82FGT13.md): Cessna 182 · Catawissa, PA · Accident · 1 fatal · Final report · Apr 11, 1982 · N9227X · Destroyed > Reportedly, the pilot departed the airport to accumulate time on a overhauled engine. The airport manager stated that shortly after takeoff, the pilot called on the UNICOM frequency that the engine and aircraft worked like new and he was completely satisfied… - [NTSB LAX82DA133](https://openairdocs.org/ntsb/LAX82DA133.md): Robinson R-22 · Mesa, AZ · Accident · No injuries · Final report · Apr 10, 1982 · N90736 · Substantial damage > After landing in a practice area the instructor told the student to pick the helicopter up to a hover. The aircraft lifted off the ground to approximately 5 feet and yawed to the right 45 degrees. As the instructor applied left pedal and lowered collective… - [NTSB FTW82FA111](https://openairdocs.org/ntsb/FTW82FA111.md): Piper PA-23-150 · Newark, TX · Accident · No injuries · Field investigation · Final report · Apr 7, 1982 · N1196P · Destroyed > The plt reported a loud bang was heard and he observed the left eng cowl raised to a vertical position & the eng drooped downward. The excessive amount of drag caused the acft to be uncontrollable. The plt was able to gain control of the acft by feathering… - [NTSB SEA82DA045](https://openairdocs.org/ntsb/SEA82DA045.md): Rockwell Intl. S-2R · Eureka, WA · Accident · No injuries · Final report · Apr 5, 1982 · N8471V · Substantial damage > After spraying most of his load, the pilot made a dry pass and dropped a smoke flare. The flare was dropped to check the drift of the air relative to a susceptible crop east of the field being sprayed. After dropping the flare, the pilot made a 180 degree… - [NTSB NYC82FNC06](https://openairdocs.org/ntsb/NYC82FNC06.md): Cessna 172 · Hampstead, NH · Accident · 1 fatal · Final report · Apr 2, 1982 · N21869 · Destroyed > Several witnesses observed the plane circling at low altitude before it crashed. A friend of the pilot reported that thepilot waved, gunned his engine a couple of times and waggled his tail. Witnesses stated that after making several circles at an altitude of… - [NTSB FTW82FA110](https://openairdocs.org/ntsb/FTW82FA110.md): Mbb-Bolkow BO-105CBS · Mckinney, TX · Accident · 3 fatal · Field investigation · Final report · Apr 2, 1982 · N112CF · Destroyed > The acft accelerated over the runway after a 10 sec hover. After acceleration, the acft went into a nose high, steep, right climbing turn. The angle of bank was described as 45 to 90 deg. The pitch varied from 15 deg up to 30 deg down just prior to impact.… - [NTSB LAX82DA121](https://openairdocs.org/ntsb/LAX82DA121.md): Cessna 150G · Tucson, AZ · Accident · No injuries · Final report · Mar 28, 1982 · N4816X · Substantial damage > During flight, the student pilot heard a loud noise from the engine and landed at a nearby airport. He reported that during the landing, a gust of wind was encountered, the left wing came up and the nose veered left. At that time, the right spindle attachment… - [NTSB DEN82DA050](https://openairdocs.org/ntsb/DEN82DA050.md): Piper PA-11 · Devils Lake, ND · Accident · Serious injuries · Final report · Mar 28, 1982 · N4709H · Substantial damage > The pilot and passenger/pilot were making low, slow passes over fisherman on the ice. The pilot reversed directions and the aircraft stalled. The pilot stated he was looking at the ground and became distracted. - [NTSB LAX82FVM13](https://openairdocs.org/ntsb/LAX82FVM13.md): Stinson 108-2 · Morgan Hill, CA · Accident · 4 fatal · Final report · Mar 27, 1982 · N9455K · Destroyed > The pilot was observed making repeated low passes in the vicinity of the crash site. This was also close to the home of one of the passengers. The final pass was made in a westerly direction over a dam at about 50 ft AGL. Just beyond the dam, the pilot made a… - [NTSB LAX82FUG09](https://openairdocs.org/ntsb/LAX82FUG09.md): Fournier RF4D · Rialto, CA · Accident · Serious injuries · Final report · Mar 27, 1982 · N7719 · Substantial damage > The pilot reported that when the accident occurred, he was soaring his "motor-glider" in updrafts of "thermal, slope-wind, and wave" origin. He reported that thermals and a weak southwest wind were producing lift along ridges with walls that were facing west,… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=234 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=233 --- 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.