# NTSB investigations: Enroute 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 378 of 718 · 35,889 cases ## Cases, newest first - [NTSB MKC82DA173](https://openairdocs.org/ntsb/MKC82DA173.md): Cessna U206F · Baton Rouge, LA · Accident · Minor injuries · Final report · Sep 20, 1982 · N9530G · Substantial damage > The pilot changed the fuel selector from right to left while descending through 2200 ft MSL. The engine failed immediately after the fuel selector was moved. Repeated attempts to restart the engine by changing fuel selector position was unsuccessful. The… - [NTSB MIA82FLD20](https://openairdocs.org/ntsb/MIA82FLD20.md): Cessna 152 · Ft. Myers, FL · Accident · Serious injuries · Final report · Sep 20, 1982 · N49863 · Destroyed > The aircraft crashed after the engine lost power. The pilot stated he did not visually check the fuel on the day of the flight. The aircraft was checked after the accident and it contained a negligible amount of fuel. The wings and fuel tanks were not damaged… - [NTSB ATL82DA280](https://openairdocs.org/ntsb/ATL82DA280.md): Grumman G-164 · Greenville, KY · Accident · No injuries · Final report · Sep 20, 1982 · N143W · Destroyed > According to the caretaker of muhlenburg airport, N143W was having carburetor problems when it arrived to refuel prior to the accident flight. The caretaker stated that the pilot left the engine running while he refueled because the pilot said it wouldn't… - [NTSB LAX82FA346](https://openairdocs.org/ntsb/LAX82FA346.md): Cessna 182P · Beldon, CA · Accident · 4 fatal · Field investigation · Final report · Sep 18, 1982 · N20726 · Destroyed > Portions of the acft's right wing were located north of highway 70 in remote rugged mountainous terrain near belden, CA.the remainder of the wreckage was located about 2 mi south of the highway on the east side of fern creek canyon at an elevation of about… - [NTSB CHI82DA356](https://openairdocs.org/ntsb/CHI82DA356.md): Cessna 172M · Brimfield, IL · Accident · Minor injuries · Final report · Sep 18, 1982 · N9871Q · Substantial damage > The pilot reported that about 30 minutes after takeoff, a partial loss of power was experienced and was accompanied by the sounds of metal-to-metal contact. He headed toward an airport about 12 miles away, but shortly thereafter, total engine failure… - [NTSB SEA82DA166](https://openairdocs.org/ntsb/SEA82DA166.md): Beech C23 · Yakima, WA · Accident · No injuries · Final report · Sep 17, 1982 · N9218S · Substantial damage > The aircraft was on the last leg of a flight from California to Yakima, Washington. It had not been refueled during a stop at goldendale, Washington. While descending toward Yakima, the pilot reported to the tower that he was out of fuel. During a forced… - [NTSB LAX82FA345](https://openairdocs.org/ntsb/LAX82FA345.md): Beech 200 · Huntington Beac, CA · Accident · 2 fatal · Field investigation · Final report · Sep 17, 1982 · N9FQ · 2 aircraft · Substantial damage > N9FQ, a Beech 200, had taken off from rwy 19R at john wayne arpt at santa ana, departed the traffic pattern on a right crosswind leg, & proceeded nw toward burbank. N732BP, a C-210L, was on a local training flt out of santa ana & had just completed practice… - [NTSB LAX82DUJ47](https://openairdocs.org/ntsb/LAX82DUJ47.md): Cessna 150 · Carrizo, AZ · Accident · No injuries · Final report · Sep 17, 1982 · N45540 · Substantial damage > The student pilot was on his "long" cross-country flight. He reported that the first leg of the flight was from libby air field, AZ to silver city, NM with an en route time of about 1.3 hrs. On the next leg of the flight to globe, AZ, he became disoriented… - [NTSB FTW82FA382](https://openairdocs.org/ntsb/FTW82FA382.md): Piper PA-24-260 · Paris, TX · Accident · 3 fatal · Field investigation · Final report · Sep 16, 1982 · N300AH · 2 aircraft · Destroyed > The PA-24 had departed rwy 17 at cox field & was climbing at the time of the collision. The plt had reported his intended departure on UNICOM. The AA5B had reported 5 mi sw of the arpt descending through 5,000 ft. for landing. The head-on collision occurred… - [NTSB ATL82DA275](https://openairdocs.org/ntsb/ATL82DA275.md): Cessna 172F · Millry, AL · Accident · Minor injuries · Final report · Sep 15, 1982 · N8423U · Substantial damage > The pilot experienced a partial loss of power during a ferry flight and was forced to make an emergency landing in a field. He stated that he noted 4 vibrations followed by a missing in the engine. The RPM dropped to 1200 and he could not maintain altitude.… - [NTSB LAX82FA344](https://openairdocs.org/ntsb/LAX82FA344.md): Cessna 402 · Grand Canyon, AZ · Accident · Serious injuries · Field investigation · Final report · Sep 14, 1982 · N59SA · Substantial damage > This was the 3rd flt of the day. The plt completed a service order for 32 gals of fuel & laid it on top of a bench located just inside open hangar doors. The acft was not refueled & the order was later found on the hangar floor away from the bench. While over… - [NTSB DEN82DA190](https://openairdocs.org/ntsb/DEN82DA190.md): Cessna 310P · Wendover, UT · Accident · Minor injuries · Final report · Sep 13, 1982 · N5836M · Substantial damage > The pilot stated he became disoriented while flying from salt lake city to Wendover. He descended to 8000 ft to keep clear of ice and hail and could not receive a navigational signal from the Wendover or bonneville navigational facility. While attempting to… - [NTSB ATL82DA273](https://openairdocs.org/ntsb/ATL82DA273.md): Piper PA-25 · Red Level, AL · Accident · No injuries · Final report · Sep 13, 1982 · N9728P · Substantial damage > While returning to the airport after spraying crops, the pilot noted a change in the engine sound and noticed a loss of oil pressure. Anticipating an imminent engine failure, the pilot landed on a portion of an old highway that was clear of motor vehicles.… - [NTSB ATL82DA272](https://openairdocs.org/ntsb/ATL82DA272.md): Cessna 172RG · Prospect, KY · Accident · No injuries · Final report · Sep 13, 1982 · N5115U · Substantial damage > The plt was returning to his departure point due to encountering rough wx. While descending to 4,000 ft for an ILS approach the plt experienced a total electrical failure. The plt elected to descend to VFR conditions & broke out about 100 ft AGL. The plt… - [NTSB FTW82DA377](https://openairdocs.org/ntsb/FTW82DA377.md): Cessna P210N · Gage, NM · Accident · No injuries · Final report · Sep 12, 1982 · N5237W · Substantial damage > While on a VFR cross-country flight from tucson, AZ to roswell, NM, the engine failed and the pilot made an emergency landing in the desert. The engine teardown revealed that the oil passage which feeds the number 2 and 3 main bearing journals had not been… - [NTSB ATL82FA267](https://openairdocs.org/ntsb/ATL82FA267.md): Piper PA-28R-180 · Itta Bena, MS · Accident · 4 fatal · Field investigation · Final report · Sep 11, 1982 · N3833T · Destroyed > At 2329 while enroute the plt was advised of wx conditions along his route. He was advised of previous low VFR conditions in the greenwood area. The fss specialist stated that there had been "low conditions right around greenwood for about a hour and a half… - [NTSB ATL82DA268](https://openairdocs.org/ntsb/ATL82DA268.md): Cessna 188 · Nashville, GA · Accident · No injuries · Final report · Sep 11, 1982 · N9184R · Substantial damage > The engine failed while the acft was enroute to spray a soybean crop. Deposits of dirt & sediment were found in the fuel control assembly body screen. - [NTSB LAX82FVG33](https://openairdocs.org/ntsb/LAX82FVG33.md): Schweizer 232 · Calistoga, CA · Accident · 1 fatal · Final report · Sep 10, 1982 · N2450W · Destroyed > The acft crashed approximately 3 mi sw of the Calistoga arpt while returning from a local flt. The plt stated to a calif hwy patrol officer at the scene that he lost rudder control & had gone into a spin as a result in air change. The rudder cables were found… - [NTSB ATL82FA278](https://openairdocs.org/ntsb/ATL82FA278.md): Piper PA-28R-201 · Alma, GA · Accident · 2 fatal · Field investigation · Final report · Sep 10, 1982 · N39685 · Destroyed > During his wx briefing at 0731 the plt was advised that VFR flt was not recommended. The acft crashed in a cornfield after an inflight separation of the stabilators & wings. Local residents recalled that the rain showers were rather heavy at times on the day… - [NTSB MIA82DA179](https://openairdocs.org/ntsb/MIA82DA179.md): Cessna T210N · Near St. Peters, FL · Accident · Minor injuries · Final report · Sep 9, 1982 · N9421Y · Destroyed > The pilot reported that the flight was uneventful until it was about 5 miles northwest of st petersburg, FL. At about that point, the pilot contacted the tower for landing and advised that the plane was low on fuel. Shortly thereafter, the engine lost power.… - [NTSB DEN82DA199](https://openairdocs.org/ntsb/DEN82DA199.md): Cessna 175 · Hulett, WY · Accident · No injuries · Final report · Sep 9, 1982 · N9410B · Substantial damage > The pilot reported that during flight the engine began to run rough. He diverted toward a nearby airstrip, but while en route, there was a "bang" and smoke began entering the cabin. At that point, he shut off the fuel, magnetos and master switch, then lost… - [NTSB CHI82DA349](https://openairdocs.org/ntsb/CHI82DA349.md): Bensen BM8 · Zilwauker, MI · Accident · No injuries · Final report · Sep 9, 1982 · N9463A · Destroyed > During flight at about 1500 ft AGL, the aircraft engine lost power. The pilot made a steep approach to land in a small field surrounded by power lines. He stated that during an extreme flare to stop the forward flight, the main rotor blades hit the ground and… - [NTSB CHI82DA348](https://openairdocs.org/ntsb/CHI82DA348.md): Cessna 172M · Cheboygan, MI · Accident · No injuries · Final report · Sep 9, 1982 · N2AZ · Substantial damage > The flight was being conducted over the waters of lake huron when engine stoppage occurred. Unable to glide to the airport the pilot ditched the aircraft on the shoreline in the water. The post-accident investigation revealed that the foam rubber from the air… - [NTSB NYC82DA219](https://openairdocs.org/ntsb/NYC82DA219.md): Beech 35 · Topsham, VT · Accident · No injuries · Final report · Sep 8, 1982 · N4454S · Substantial damage > Engine quit and pilot made forced landing in open field. Fuel selector was found on right tank which was empty. Left tank was full. Fuel lines were dry. - [NTSB MKC82IA169](https://openairdocs.org/ntsb/MKC82IA169.md): Cessna 421C · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Sep 7, 1982 · N6868D · Minor damage > Pilot reported, the flight encountered icing conditions near St. Louis and the propeller de-ice system was activated. When de-ice system was turned on, flames shot out from the lower right corner of the pilot's instument panel where the de-ice ammeter is… - [NTSB MKC82FCD10](https://openairdocs.org/ntsb/MKC82FCD10.md): Piper 28-236 · Liscomb, IA · Accident · 2 fatal · Final report · Sep 7, 1982 · N2157A · Substantial damage > N2157A departed on a VFR flight to marshalltown, IA. There is no record of a pilot weather briefing prior to departure. The reported weather at waterloo airport at the approximate time of the accident was: measured ceiling 600 foot overcast, visibility one… - [NTSB SEA82AA155](https://openairdocs.org/ntsb/SEA82AA155.md): Piper PA-32-300 · 23 Mi Ene Toutl, WA · Accident · 2 fatal · Final report · Sep 6, 1982 · N48915 · Destroyed > While on a sightseeing flt in the Mt. St.helens national volcanic monument area the acft crashed on the mud flats of the north fork of the toutle river in a relatively flat & open area. There were indications of a massive oil leak from the eng area in flight.… - [NTSB MKC82FCQ14](https://openairdocs.org/ntsb/MKC82FCQ14.md): Cessna TRI82 · Bunker Hill, KS · Accident · 2 fatal · Final report · Sep 6, 1982 · N756KD · Destroyed > The non-instrument rated pilot departed great bend, KS sometime after 2000 CDT on 9/6/83 on a flight to lucas, KS. On 9/9/83, the aircraft was found where it had crashed between great bend and lucas. No preimpact, mechanical failures were evident. The 2256… - [NTSB FTW82DA367](https://openairdocs.org/ntsb/FTW82DA367.md): Cessna 172M · Houston, TX · Accident · No injuries · Final report · Sep 6, 1982 · N73562 · Substantial damage > After making a cruise descent from 1800 to 1500 ft AGL, the pilot adjusted his throttle to maintain his airspeed and altitude. However, there was no response. The throttle could be pushed in and pulled out with no increase in power. A crosswind landing was… - [NTSB CHI82DA341](https://openairdocs.org/ntsb/CHI82DA341.md): Aero Commander 681 · Pontiac, MI · Accident · No injuries · Final report · Sep 6, 1982 · N10TN · Substantial damage > During cruise flight the pilot observed the hydraulic system pressure fluctuating. The pilot immediately went into a hold pattern and attempted to ascertain the problem. After repeated attempts the pilot was able to lower the nose gear and the right main… - [NTSB MKC82DA165](https://openairdocs.org/ntsb/MKC82DA165.md): Cessna 172M · Warrensburg, MO · Accident · No injuries · Final report · Sep 5, 1982 · N13592 · Substantial damage > The pilot was on a flight from tulsa, ok to gravois mills, MO. At gravois mills, he made two approaches to the wulff harbor airport, but it was dark and he was not familiar with the airfield. So he diverted to Kansas city, MO. While en route to Kansas city,… - [NTSB ANC82DAG53](https://openairdocs.org/ntsb/ANC82DAG53.md): Piper PA-20 · Kenai, AK · Accident · 2 fatal · Final report · Sep 5, 1982 · N6957K · Destroyed > At 0837 the plt called Kenai tower & reported 8 mi west inbound for landing. At 0845 he reported that he would be landing on the beach. At 0847 he reported that he would not make the beach & would be going into the water. The acft & occupants were not… - [NTSB ANC82DA083](https://openairdocs.org/ntsb/ANC82DA083.md): Cessna 207A · Near Kipnuk, AK · Accident · No injuries · Final report · Sep 5, 1982 · N76078 · Substantial damage > The pilot reported that the aircraft lost oil pressure while he was in normal cruise. Shortly thereafter, the engine began running rough. The engine failed completely while he was on an approach for a forced landing. Shortly after touching down on uneven,… - [NTSB FTW82DA364](https://openairdocs.org/ntsb/FTW82DA364.md): Cessna 182A · Farmington, NM · Accident · No injuries · Final report · Sep 4, 1982 · N6088B · Substantial damage > The aircraft collided with trees during a forced landing off airport. The pilot declared an emergency after the engine stopped. He was able to restart the engine once. It ran for about 2 minutes and stopped again. Examination of the aircraft revealed the fuel… - [NTSB DEN82FA182](https://openairdocs.org/ntsb/DEN82FA182.md): Bell 206B · Billings, MT · Accident · 1 fatal · Field investigation · Final report · Sep 4, 1982 · N49593 · Destroyed > The acft departed laramie at approximately 1600 with a full load of fuel. At 1840 the plt contacted Billings tower & stated he had a low fuel warning light. Several minutes later he radioed that he was going down. A witness observed the acft coming down "real… - [NTSB DEN82DA184](https://openairdocs.org/ntsb/DEN82DA184.md): Cessna 177 · Castlerock, CO · Accident · Minor injuries · Final report · Sep 4, 1982 · N3286T · Substantial damage > During a flight to englewood, CO, the aircraft's engine stopped running and the pilot made a forced landing on the northbound lane of interstate 25 at castle rock. Investigation revealed there was no fuel in the aircraft's fuel tanks. - [NTSB CHI82DA343](https://openairdocs.org/ntsb/CHI82DA343.md): Cessna 310A · Wheeling, IL · Accident · No injuries · Final report · Sep 4, 1982 · N301DG · Substantial damage > The pilot could not get the gear down green light to come on. Several checks made including a fly-by and a advisory that the gear appeared down. During the landing roll the right gear collapsed. Examination of the landing gear system revealed a bent righthand… - [NTSB ATL82FA263](https://openairdocs.org/ntsb/ATL82FA263.md): Cessna 170A · Brunswick, GA · Accident · 3 fatal · Field investigation · Final report · Sep 4, 1982 · N9263A · Destroyed > The non-instrument rated pilot was on a flight from ironton, oh to daytona beach, FL with an en route stop at columbia, SC. He obtained a weather briefing prior to departing ironton, but did not update it after landing at columbia. The aircraft crashed on the… - [NTSB DCA82IA031](https://openairdocs.org/ntsb/DCA82IA031.md): Boeing 727 · Washington, DC · Incident · Serious injuries · Incident investigation · Final report · Sep 3, 1982 · N288WA · No damage > The announcement of the possibility of turbulence during the descent and approach was made. During the lulls in the turbulence the cabin attendants were attending their duties and were hurt when intermittent jolts of rough air were encountered while two of… - [NTSB ATL82DA264](https://openairdocs.org/ntsb/ATL82DA264.md): Piper PA-28R · Sewanee, TN · Accident · No injuries · Final report · Sep 3, 1982 · N4976S · Substantial damage > Enroute the oil pressure dropped to zero & shortly thereafter the prop seized due to oil starvation. Post exam revealed a crack in the prop governor oil line, P/N76157, at the bend about 1 inch away from the "b" nut attaching the line to the elbow fitting at… - [NTSB SEA82DA153](https://openairdocs.org/ntsb/SEA82DA153.md): American AA-1A · Paulsbo, WA · Accident · Minor injuries · Final report · Sep 2, 1982 · N9410L · Destroyed > After demonstrating a practice forced landing approach, a climb was started. Short thereafter, the engine lost power and an actual forced landing was made in a wooded area. The aircraft was damaged beyond economical repair when it struck trees during the… - [NTSB ATL82FA261](https://openairdocs.org/ntsb/ATL82FA261.md): Cessna 170B · Lawrenceville, GA · Accident · 1 fatal · Field investigation · Final report · Sep 2, 1982 · N3247A · Destroyed > During the return flt to stone mountain arpt, the plt contacted approach control & requested vectors to the gwinnett county arpt at Lawrenceville, GA. The plt reported that he had been going around thunderstorms & it was turning dark. Several minutes later… - [NTSB MKC82DA163](https://openairdocs.org/ntsb/MKC82DA163.md): Cessna 140 · Eldora, IA · Accident · No injuries · Final report · Sep 1, 1982 · N72470 · Substantial damage > The oil pressure dropped to zero & the plt shut down the engine, & the acft landed in a bean field. All of the oil had blown out of the oil filler opening via a loose fitting oil filter cap. The plt stated he had changed the oil prior to flt. - [NTSB ATL82DA258](https://openairdocs.org/ntsb/ATL82DA258.md): Hughes 269C · Louisville, KY · Accident · Minor injuries · Final report · Sep 1, 1982 · N8982F · Substantial damage > The pilot received a weather briefing before taking off on an aerial traffic patrol for a local radio station. He was issued a special VFR clearance to follow a pre-established route. However, after departing, he encountered thunderstorm activity. He returned… - [NTSB ANC82FA081](https://openairdocs.org/ntsb/ANC82FA081.md): de Havilland DHC-3 · Near Skwentna, AK · Accident · No injuries · Field investigation · Final report · Sep 1, 1982 · N41755 · Substantial damage > The acft experienced a power loss & a forced landing was made on a sandbar. During the landing roll the acft struck a log, folding the main gear. Eng teardown revealed a failed no.4 articulating rod. The rod separated just above the knuckle pin area. - [NTSB MIA82DA176](https://openairdocs.org/ntsb/MIA82DA176.md): Boeing A75N1 · Madison, FL · Accident · No injuries · Final report · Aug 31, 1982 · N59998 · Substantial damage > While returning to the airport, the engine lost power. The pilot landed long in a pasture to avoid cows, and then was unable to stop before hitting a fence. The pilot reported that the mixture linkage became disconnected. After the accident, the linkage was… - [NTSB MKC82FA161](https://openairdocs.org/ntsb/MKC82FA161.md): Piper PA-28R-200 · Mediapolis, IA · Accident · 4 fatal · Field investigation · Final report · Aug 30, 1982 · N56373 · Destroyed > During the 1725 CDT wx briefing the plt was informed that the Kansas city area would be 1600 ft broken, occassional 800 ft broken, 3/4 mi visibility with thunderstorms & moderate rain with strong surface winds about 35K. The forecast was valid to 2200 CDT.… - [NTSB ATL82FLG14](https://openairdocs.org/ntsb/ATL82FLG14.md): Cessna 182B · Charleston, SC · Accident · Serious injuries · Final report · Aug 29, 1982 · N99CB · Destroyed > The flight departed conway, Arkansas for a non-stop flt to Charleston. Approximately 4 to 5 miles from the airport at Charleston, with the runway in sight, the engine quit. The acft struck trees drg a forced landing on a power line right-of-way 2 miles short… - [NTSB ATL82FA251](https://openairdocs.org/ntsb/ATL82FA251.md): Piper PA-28R-201T · State Road, NC · Accident · 1 fatal · Field investigation · Final report · Aug 29, 1982 · N38231 · Destroyed > The plt reported his engine had quit. ARTCC advised the plt that the nearest arpt was elking at 12 mi. Several minutes later he reported that he didn't think he could make the arpt & was going to look for a field. Witnesses observed the landing gear down… - [NTSB MKC82DA159](https://openairdocs.org/ntsb/MKC82DA159.md): Bell 47G-2 · Palo, IA · Accident · No injuries · Final report · Aug 27, 1982 · N12412 · Substantial damage > The pilot reported that during flight at about 300 ft AGL, the engine sputtered and lost power. He entered an autorotation, turned into the wind, and landed in a bean field. As the aircraft descended into the beans, the spray boom became entangled in the… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=379 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=378 --- 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.