# 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 365 of 718 · 35,889 cases ## Cases, newest first - [NTSB ANC83FAA07](https://openairdocs.org/ntsb/ANC83FAA07.md): Lowther Volmer VJ-22 · North Pole, AK · Accident · Serious injuries · Final report · Aug 13, 1983 · N830PM · Destroyed > The pilot was approaching the arpt when the engine quit and he turned toward an open field as he did not believe they could make the rwy. He remembers the acft stalling and spinning. The acft crashed in an area of scrub trees and brush about 1 1/2 miles from… - [NTSB NYC83FA207](https://openairdocs.org/ntsb/NYC83FA207.md): Cessna 310Q · Scranton, PA · Accident · 1 fatal · Field investigation · Final report · Aug 12, 1983 · N69JM · Destroyed > Shortly after takeoff the acft ws observed on radar making a left 360 deg turn. The plt did not respond to a call from the controller. A witness heard the plane 'sputtering' & observed it in erratic maneuvers prior to it hitting a house. Post exam revealed… - [NTSB NYC83AA208](https://openairdocs.org/ntsb/NYC83AA208.md): Piper PA-24-180 · Pomona, NJ · Accident · 4 fatal · Final report · Aug 12, 1983 · N7554P · Destroyed > During his wx briefing, the plt was advised of an area of rain showers & scattered thunderstorms along his route of flt, as well as flt precautions for occasional moderate turbulence below 8000 ft which was forcast. He departed norfolk at 1500. At about 1630,… - [NTSB MKC83LA187](https://openairdocs.org/ntsb/MKC83LA187.md): Hughes 269C · Dodge City, KS · Accident · No injuries · Limited investigation · Final report · Aug 12, 1983 · N7412F · Substantial damage > After dispensing a load of chemicals, the plt was returning to land when he felt a vibration in the tail boom. This was followed by a loud noise & the helicopter began turning. The plt lowered the collective & the power. Subsequently, the helicopter landed… - [NTSB FTW83FA373](https://openairdocs.org/ntsb/FTW83FA373.md): Piper PA-28-181 · Ville Platte, LA · Accident · 2 fatal · Field investigation · Final report · Aug 12, 1983 · N21537 · Destroyed > Prior to takeoff the plt had received a wx briefing & was advised that VFR flt was not recommended. He was given convective SIGMET 13C which called for thunderstorms with tops above 45,000 ft throughout his route of flt. About 25 minafter takeoff four… - [NTSB LAX83FA382](https://openairdocs.org/ntsb/LAX83FA382.md): Stinson 108-3 · Temecula, CA · Accident · No injuries · Field investigation · Final report · Aug 11, 1983 · N12HK · 2 aircraft · Substantial damage > A Stinson 108-3, N12HK, piloted by a private plt, & a Cessna 152, N46757, piloted by a student plt, collided while both acft were ruising at 5500 ft MSL. The private plt (of N12HK) reported he was on a magnetic heading 130 deg & was indicating 92 mph (about… - [NTSB DEN83FA203](https://openairdocs.org/ntsb/DEN83FA203.md): Cessna 140A · Sevier, UT · Accident · 2 fatal · Field investigation · Final report · Aug 11, 1983 · N5301C · Destroyed > The flt was returning to san jose,CA after an extended x-country flt to oshkosh,WI which began in the latter part of July. Earlier on the day of the accident, at 0645, the plt received a wx briefing at miles city,MT. He requested the general outlook to the… - [NTSB LAX83LA381](https://openairdocs.org/ntsb/LAX83LA381.md): Grumman American AA1 · Bishop, CA · Accident · No injuries · Limited investigation · Final report · Aug 10, 1983 · N6105L · Substantial damage > The acft landed hard during a forced landing and collapsed the landing gear pilot reported that 10-15 minutes after takeoff he experienced pitch control problems. He was unable to turn the acft and made a forced landing straight ahead. The pilot stated that… - [NTSB MIA83LA200](https://openairdocs.org/ntsb/MIA83LA200.md): Aerostar 600 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Aug 9, 1983 · N7447S · Substantial damage > The acft departed ft. pierce, FL on a VFR flight to key west, FL, and ditched in lake okeechobee. While climbing THROUGH5000 ft the left engine lost power and started surging, the oil temperature gauge failed and smoke came from under the instrument panel.… - [NTSB CHI83LA375](https://openairdocs.org/ntsb/CHI83LA375.md): Quickie Q2 · Decatur, IL · Accident · No injuries · Limited investigation · Final report · Aug 9, 1983 · N7QA · Substantial damage > The acft made a hard landing and broke the front canard after bouncing on touchdown and dragging the left wing. The pilot had been informed by the tower that black smoke was coming out of the engine. This turned out to be from an excessively rich mixture. The… - [NTSB CHI83LA374](https://openairdocs.org/ntsb/CHI83LA374.md): Cessna 150 · Springfield, IL · Accident · No injuries · Limited investigation · Final report · Aug 9, 1983 · N3400V · Substantial damage > The acft made a forced landing in a corn field and nosed down after the engine stopped during flt. During pre-flt the pilot had looked in the tanks and measured the amount of fuel with the tie cap chain. He thought he had enough fuel for the flt even though… - [NTSB DEN83LA191](https://openairdocs.org/ntsb/DEN83LA191.md): Piper PA-25C-235 · Upham, ND · Accident · No injuries · Limited investigation · Final report · Aug 8, 1983 · N4394Y · Substantial damage > The pilot said he departed souris with aprx 17 gallons of fuel on board and flew for 1 hour at 500 feet to mandan, ND. He departed mandan without refueling and fuel exhaustion occurred about 1 hour later. He had flown for about 2 hours at 500 feet AGL with… - [NTSB DEN83LA187](https://openairdocs.org/ntsb/DEN83LA187.md): Piper PA-11 · Wagner, SD · Accident · No injuries · Limited investigation · Final report · Aug 8, 1983 · N4573M · Substantial damage > The plt reported that the eng began loosing power as he approached his destination. He elected to make an emergency landing on a road to investigate the problem. He stated that he made a stalled landing that caused the tailwheel to unlock & allowed the acft… - [NTSB ATL83LA322](https://openairdocs.org/ntsb/ATL83LA322.md): Eiriavion PIK-20B · Cordele, GA · Accident · No injuries · Limited investigation · Final report · Aug 8, 1983 · N20PE · Substantial damage > The plt was competing in a regional soaring contest. While en route from the 1st turn point he encounter rain & elected to land in a pasture. During the landing roll, the tail skid struck a hole which cracked the fuselage, immediately forward of the empennage. - [NTSB SEA83FA168](https://openairdocs.org/ntsb/SEA83FA168.md): Pietonpol-Imrie Aircamper · Shelton, WA · Accident · 1 fatal · Field investigation · Final report · Aug 7, 1983 · CFACV · Destroyed > The home built acft was manufactured in 1975 & was built in Canada from the 1930 pietenpol aircamper design. The plt had flown the canadian registered acft to an antique fly-in. Traffic at the arpt required that only rwy 35 could be used. The plt waited from… - [NTSB NYC83LA201](https://openairdocs.org/ntsb/NYC83LA201.md): Piper PA-28-180G · Linden, PA · Accident · No injuries · Limited investigation · Final report · Aug 7, 1983 · N4525T · Substantial damage > The acft collided with powerlines during a night forced landing after fuel exhaustion. - [NTSB NYC83LA200](https://openairdocs.org/ntsb/NYC83LA200.md): Cessna 150M · St. Clair, PA · Accident · No injuries · Limited investigation · Final report · Aug 7, 1983 · N707CF · Substantial damage > The student plt was on a x-country flt when he encountered reduced visibility with fog & haze. He tried to locate an arpt by flying time & distance off of a VOR station. He circled in the vicinity of where he thought the arpt was at, then elected to land… - [NTSB LAX83LA375](https://openairdocs.org/ntsb/LAX83LA375.md): Cessna 150M · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Aug 7, 1983 · N714QA · Substantial damage > The acft nosed over in a marsh during a forced landing after an engine failure. This was a solo instructional flt. The plt said he was descending for a landing at Palo Alto when the engine began to 'lose power and run rough.' Carburetor heat did not work and… - [NTSB FTW83LA368](https://openairdocs.org/ntsb/FTW83LA368.md): Cessna 152 · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Aug 7, 1983 · N67452 · Substantial damage > The acft collided with a fence and a powerline during takeoff climb. The student pilot was visiting a small field with A1300 ft rwy of sod for practice. The C-152 uses 1340 ft to clear a 50 ft obstabcle for a standard day on a surfaced rwy this day was above… - [NTSB ATL83LA314](https://openairdocs.org/ntsb/ATL83LA314.md): Piper PA-28-180 · Normantown, WV · Accident · No injuries · Limited investigation · Final report · Aug 7, 1983 · N7272W · Substantial damage > The plt noticed smoke in the cockpit, & soon thereafter observed the oil press gage reading zero. The plt was given radar vectors to the nearest arpt but he was unable to reach it. The acft collided with trees & a powerline during the forced landing.… - [NTSB NYC83FU009](https://openairdocs.org/ntsb/NYC83FU009.md): American Aerolights Eagle XL · Mayville, NY · Accident · 1 fatal · Final report · Aug 6, 1983 · UNREG · Destroyed > According to witnesses, the ultralight was in level flt at aprx 150 to 200 ft AGL when they heard a loud bang. Shortly thereafter, the eng noise ceased & the vehicle entered a spiraling descent & crashed. A rip in the wing center section was seen prior to… - [NTSB NYC83FNC10](https://openairdocs.org/ntsb/NYC83FNC10.md): Piper PA 28 181 · Baxter State Pk, ME · Accident · Serious injuries · Final report · Aug 6, 1983 · CGPJX · Destroyed > The pilot does not recall any details of the flight after departing montreal. The wreckage was not recovered nor examined. - [NTSB LAX83FA377](https://openairdocs.org/ntsb/LAX83FA377.md): Cessna 172 · San Simeon, CA · Accident · 4 fatal · Field investigation · Final report · Aug 6, 1983 · N64196 · Destroyed > The acft collided with the terrain while on a pleasure flight for the purpose of sightseeing. The wreckage was found in a box canyon at 3500 ft MSL. Examination of the accident site revealed that the acft impacted on a heading of approx 085 degrees. The… - [NTSB LAX83FA373](https://openairdocs.org/ntsb/LAX83FA373.md): Cessna 152 · Fullerton, CA · Accident · No injuries · Field investigation · Final report · Aug 6, 1983 · N6539L · 2 aircraft · Substantial damage > N6539L, a Cessna 152, and N1172H a Piper PA-32R-300 collided with each other approx 2 mi west of the Fullerton municipal arpt, at an alt of approx 1200 ft AGL. Both plts rept clear skies, a bright night, and no restrictions to vis. Both plts stated they made… - [NTSB MKC83LA176](https://openairdocs.org/ntsb/MKC83LA176.md): Piper PA-24-235 · Alliance, NE · Accident · No injuries · Limited investigation · Final report · Aug 5, 1983 · N777EE · Substantial damage > The pilot stated that he departed oshrosh for scottsbluff with an estimated 80 gallons of fuel on board the air craft his ete was 4 hours 30 minutes and fuel consumption at 15 gph. Aprx 37 NM short of scotts bluff he noticed the right fuel gauge indicating… - [NTSB MIA83LA205](https://openairdocs.org/ntsb/MIA83LA205.md): Pitts S-1C · Kissimmee, FL · Accident · No injuries · Limited investigation · Final report · Aug 5, 1983 · N77R · Substantial damage > While cruising at 2000 ft MSL the eng lost pwr. The plt restarted the eng 3 times but was forced to lnd when it would not develop pwr. During lndg roll in a cow pasture the acft collided with a fence post, ground looped, and turned our on its back. The fuel… - [NTSB LAX83LA372](https://openairdocs.org/ntsb/LAX83LA372.md): Cessna 152 · Weaverville, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 5, 1983 · N757TE · Destroyed > The acft crash landed in mountainous terrain after the engine lost power. At 2040 PDT a mayday call was heard from the accident acft by the redding tower. The acft was advised to squawk code 7700 and to transmit on several other frequencies. No further… - [NTSB ATL83FIG05](https://openairdocs.org/ntsb/ATL83FIG05.md): Rockwell S2R · Massey, MD · Accident · Minor injuries · Final report · Aug 5, 1983 · N8484V · Substantial damage > While en route to a customer's field, at aprx 350 ft AGL over a wooded area, the engine lost power. The plt released the load, and subsequently, he landed the acft in the tree tops. During the landing, the acft sheared off a large tree, knocked another tree… - [NTSB ANC83LA138](https://openairdocs.org/ntsb/ANC83LA138.md): Hughes 369D · Mcgrath, AK · Accident · No injuries · Limited investigation · Final report · Aug 5, 1983 · N1106Z · Substantial damage > The plt stated that he was flying straight & level at aprx 700 ft AGL, when the eng-out light illuminated. He began an autorotation to a ridgeline. During the landing, the main rotor blades contacted the tail boom & severed it from the main fuselage. An… - [NTSB MIA83LA199](https://openairdocs.org/ntsb/MIA83LA199.md): Bell 206B · Stuart, FL · Accident · No injuries · Limited investigation · Final report · Aug 4, 1983 · N51DC · Substantial damage > While in cruise flt at aprx 600 ft AGL, a catastrophic failure of the engine's 3rd stage turbine occurred. The plt related that he observed an engine chip detector light, which was followed almost immediately by fire in the engine. He made a successful… - [NTSB CHI83FA334](https://openairdocs.org/ntsb/CHI83FA334.md): Piper PA-28-181 · Dwight, IL · Accident · 2 fatal · Field investigation · Final report · Aug 4, 1983 · N2876X · Destroyed > The acft crashed in a corn field during a heavy rainstorm while on a cross country flight. The pilot had logged 4 hour of simulated instrument time and was not instrument rated. - [NTSB ATL83LA309](https://openairdocs.org/ntsb/ATL83LA309.md): Cessna 172N · Birmingham, AL · Accident · No injuries · Limited investigation · Final report · Aug 3, 1983 · N738NV · Substantial damage > The instructor (CFI) reported the eng began missing when power was applied after practicing stalls. A decision was made to return to the arpt. Carburetor heat was applied & the throttle was retarded to descend. The mixture was in full rich. After a couple of… - [NTSB MIA83LA195](https://openairdocs.org/ntsb/MIA83LA195.md): Piper PA-28-151 · Lantana, FL · Accident · No injuries · Limited investigation · Final report · Aug 2, 1983 · N42787 · Substantial damage > During flt the eng started vibrating & the CFI noted zero oil pressure. The eng failed. The acft sustained substantial damage during the forced landing. Exam of the oil line, P/N63901-49, revealed that it was frayed & broken allowing oil to be pumped from the… - [NTSB CHI83LA349](https://openairdocs.org/ntsb/CHI83LA349.md): Beech A24R · Verona, WI · Accident · No injuries · Limited investigation · Final report · Aug 2, 1983 · N8016R · Substantial damage > The acft lost power during cruise and was damaged in an off arpt forced landing. During the landing roll in a field, acft contacted a fence and collapsed the nose gear. Examination of the bendix fuel injector SN30479, model RSA-5AD1 revealed that the fuel… - [NTSB MKC83LA174](https://openairdocs.org/ntsb/MKC83LA174.md): Cessna 152 · Sidney, NE · Accident · No injuries · Limited investigation · Final report · Aug 1, 1983 · N67585 · Substantial damage > The student plt was on a solo x-country flt. As he approached Sidney, NE, he was unable to contact anyone on the radio & continued to the arpt at cruise alt. He descended while circling the arpt. Before reaching traffic pattern alt, he applied power, but the… - [NTSB CHI83LA345](https://openairdocs.org/ntsb/CHI83LA345.md): Cessna 172 · Naubinway, MI · Accident · No injuries · Limited investigation · Final report · Aug 1, 1983 · CGQNM · Substantial damage > The acft struck a stop sign and nosed over while attempting to make an emergency landing following fuel exhaustion. - [NTSB ATL83AA305](https://openairdocs.org/ntsb/ATL83AA305.md): Beech F35 · Elkin, NC · Accident · 3 fatal · Final report · Aug 1, 1983 · CGGHP · Destroyed > During his 1010 wx briefing for the proposed route of flt, the plt was advised that showers were expected in west Virginia & that it might not be possible to maintain VFR below clouds along the mountainous route. The briefer suggestedan alternate route… - [NTSB CHI83LA341](https://openairdocs.org/ntsb/CHI83LA341.md): Snow 600-S2C · Plainfield, WI · Accident · No injuries · Limited investigation · Final report · Jul 30, 1983 · N1678S · Destroyed > The acft caught fire in the air after a power loss. A forced landing was accomplished and the pilot escaped without injury but the acft was destroyed by the fire. It was reported that the fire was so intense that all evidence of cause was destroyed. The acft… - [NTSB ATL83LA298](https://openairdocs.org/ntsb/ATL83LA298.md): Enstrom F-28A · Brunswick, GA · Accident · No injuries · Limited investigation · Final report · Jul 30, 1983 · N9078 · Substantial damage > The plt reported that the helicopter was 'topped off' with fuel before takeoff. About 1 hr & 10 min after takeoff, there reportedly was a loud 'bang' which was followed by sputtering from the eng & a decay in the eng RPM. An autorotation was made into a small… - [NTSB MKC83FA167](https://openairdocs.org/ntsb/MKC83FA167.md): Pietenpal AIR Camper · Saint Ansgar, IA · Accident · Serious injuries · Field investigation · Final report · Jul 29, 1983 · N12938 · Substantial damage > The acft crashed following tkof from an enroute stop during a x-country flt. The plt's friend witnessed the takeoff. The witness said the plt waved after takeoff and then the acft made a sharp left bank with wings waggling. The acft rolled level and entered… - [NTSB CHI83LA339](https://openairdocs.org/ntsb/CHI83LA339.md): Cessna 182 · Rochester, MN · Accident · No injuries · Limited investigation · Final report · Jul 29, 1983 · N4985D · Substantial damage > While en route, the engine lost power & the plt was unable to restart it. During a forced landing on a road at dusk, the vertical stabilizer struck a wire. Aprx 16 inches was cut off the top of the stabilizer & the rudder was torn loose from the hinges.… - [NTSB MKC83LA169](https://openairdocs.org/ntsb/MKC83LA169.md): Piper PA-38 · North Platte, NE · Accident · No injuries · Limited investigation · Final report · Jul 28, 1983 · N25087 · Substantial damage > The pilot had been flying for about 1 hour in the local area and was returning from the practice area at 1100 feet AGL. In preparation for landing he advanced the mixture to full rich and the engine lost power. He tried emerg procedures but the engine did not… - [NTSB MKC83LA166](https://openairdocs.org/ntsb/MKC83LA166.md): Schippers BD-4 · Danbury, IA · Accident · No injuries · Limited investigation · Final report · Jul 28, 1983 · N412JS · Substantial damage > While en route, the propeller separated from the home built acft. Subsequently, the nose gear failed & the main gear were damaged during a landing on rolling terrain. An examination revealed that the mounting bolts for a propeller spacer had failed. The… - [NTSB SEA83LA160](https://openairdocs.org/ntsb/SEA83LA160.md): Cessna 150E · Ellensburg, WA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1983 · N4098U · Substantial damage > The acft landing gear collapsed during a forced landing on a rough road. The acft engine had quit while climbing THROUGH4500 ft after takeoff. The pilot tried leaning and pitot heat. Since the engine would not start the pilot picked a dirt road for landing.… - [NTSB ATL83FA293](https://openairdocs.org/ntsb/ATL83FA293.md): Piper PA-31-350 · Richmond, VA · Accident · Minor injuries · Field investigation · Final report · Jul 27, 1983 · N63737 · Substantial damage > The plt made a forced landing following a power loss on an approach to Richmond, Virginia. The flt had been operating 4 hours, including 7 takeoffs, since refueling. After the accident both propellers were found in the feathered position. The right wing fuel… - [NTSB MKC83LA163](https://openairdocs.org/ntsb/MKC83LA163.md): Cessna 152 · Holton, KS · Accident · No injuries · Limited investigation · Final report · Jul 26, 1983 · N89876 · Substantial damage > The pilot stated that he looked in the fuel tanks prior to takeoff and they appeared to be about half full and he thought this was about three hours fuel. About one hour after takeoff the engine quit and a forced landing was attempted in a pasture. The pilot… - [NTSB LAX83LA357](https://openairdocs.org/ntsb/LAX83LA357.md): Cessna 152 · Arvin, CA · Accident · Serious injuries · Limited investigation · Final report · Jul 26, 1983 · N6445Q · Destroyed > The acft experienced a rough engine prior to the power loss. The pilot reduced power and applied carburetor heat during the descent which ended in a forced landing in a plowed field. The acft was landed perpendicular to the furrows & nosed over. The… - [NTSB FTW83LA349](https://openairdocs.org/ntsb/FTW83LA349.md): Piper PA-24-250 · Stillwater, OK · Accident · No injuries · Limited investigation · Final report · Jul 26, 1983 · N6196P · Substantial damage > While on a solo x-country flt, the eng lost power & the student plt landed on a highway. During the emergency landing, the right wing hit a road sign & the acft went off the right side of the highway & hit other structures. The fuel selector was found… - [NTSB ATL83LA289](https://openairdocs.org/ntsb/ATL83LA289.md): Cessna 182G · Simpsonville, KY · Accident · No injuries · Limited investigation · Final report · Jul 25, 1983 · N3414S · Substantial damage > Shortly after beginning the initial descent for a landing at the destination, the eng lost power, but continued to run intermittently. The plt was unable to restore full power & made an emergency landing on a highway. During the landing roll, the left wing… - [NTSB ATL83FA290](https://openairdocs.org/ntsb/ATL83FA290.md): Cessna TR 182 · Seneca Rocks, WV · Accident · No injuries · Field investigation · Final report · Jul 25, 1983 · N737JA · Substantial damage > The acft collided with trees and the ground following a reported loss of power. The acft had completed a descent of 2000-3000 ft to observe rock formations and had commenced a climb when power loss occurred. The plt said the mixture wasleft in lean position… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=366 ## 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=365 --- 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.