# 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 369 of 718 · 35,889 cases ## Cases, newest first - [NTSB MIA83FA146](https://openairdocs.org/ntsb/MIA83FA146.md): Cessna 210N · Avon Park, FL · Accident · Serious injuries · Field investigation · Final report · May 26, 1983 · N6190N · Destroyed > About 40 min after takeoff the plt reported he was having eng problems & requested radar vectors to the nearest arpt. He was given a 215 deg vector to Avon Park arpt, located about 11 mi sw. The plt stated he had the arpt in sight. Duringthe approach the acft… - [NTSB CHI83IA228](https://openairdocs.org/ntsb/CHI83IA228.md): Mcdonnell Douglas DC-10-40 · Clarion, PA · Incident · No injuries · Incident investigation · Final report · May 26, 1983 · N154US · No damage > During descent in turbulence the crew noted all 3 engines were overtempting and experiencing compressor stalls. Attemptsto reduce throttles did not reduce the temperatures. No 183 engines were shut down. During diversion to a close airport the engines were… - [NTSB SEA83LA107](https://openairdocs.org/ntsb/SEA83LA107.md): Beech V35-TC · Wendling, OR · Accident · No injuries · Limited investigation · Final report · May 25, 1983 · N7980M · Destroyed > The acft collided with trees and dense brush during an off airport forced landing in IMC weather. According to the pilothe was about 10 minutes into a cross country flight at 4000 feet MSL when fuel pressure dropped and he lost engine power. The pilot… - [NTSB LAX83LA248](https://openairdocs.org/ntsb/LAX83LA248.md): Enstrom 280C · Goshen, CA · Accident · Minor injuries · Limited investigation · Final report · May 24, 1983 · N51763 · Substantial damage > About 5 min after taking off, the plt noticed a sudden loss of power to the tail rotor. He made an emergency landing in an alfalfa field. He reported that during an autorotative landing, he had insufficient collective to flare properly. Subsequently, the main… - [NTSB LAX83FA242](https://openairdocs.org/ntsb/LAX83FA242.md): Schempp-Hirth Standard Cirrus · Bridgeport, CA · Accident · 1 fatal · Field investigation · Final report · May 22, 1983 · N184N · 2 aircraft · Substantial damage > Two Schempp-Hirth gliders, N184N & N6482, were being flown in a x-country contest along a triangular course. The course started at minden, NV & went to schurz, NV & Bridgeport, CA, then back to minden. The plts of both gliders had participated in contests for… - [NTSB DEN83FA116](https://openairdocs.org/ntsb/DEN83FA116.md): Cessna 172P · Lander, WY · Accident · 2 fatal · Field investigation · Final report · May 22, 1983 · N54609 · Destroyed > At noon on 5/21/83, the plt departed riverton, WY on a flt to ogden, ut to transport a minister back to riverton for a wedding. After arriving at ogden, he obtained a wx briefing for the return flt. He was warned of possible thunderstormactivity, turbulence,… - [NTSB ATL83FA198](https://openairdocs.org/ntsb/ATL83FA198.md): Beech V35B · Chesson, AL · Accident · 4 fatal · Field investigation · Final report · May 22, 1983 · N313ZM · Destroyed > While the acft was on a x-country flt at 4000 ft MSL, radio & radar contact were lost soon after a turn was initiated. Wreckage of the aircraft was found scattered over a distance of 2193 ft. an exam of the wreckage revealed that the stabilizers/ruddervators,… - [NTSB ANC83FA080](https://openairdocs.org/ntsb/ANC83FA080.md): Curtiss-Wright C-46F · King Salmon, AK · Accident · No injuries · Field investigation · Final report · May 21, 1983 · N1822M · Substantial damage > The coplt reported that the acft had been in level cruise flt aprx 1 min when they felt a vibration, followed by a loud bang. The aircrew saw fire & smoke coming from the left eng, so they shut down the eng & feathered the propeller. The plt also activated… - [NTSB NYC83LA123](https://openairdocs.org/ntsb/NYC83LA123.md): Cessna 180H · Greenville, ME · Accident · No injuries · Limited investigation · Final report · May 20, 1983 · N9052M · Substantial damage > The wx was estimated at 2,000 to 2,500 ft overcast when the flt departed Greenville at 1820. Horseshoe pond is 1,500 ft MSL & surrounded by 2,700 ft mountains. As the acft approached the pass the pond was visible. However a south wind prevailed & fog had… - [NTSB NYC83FA122](https://openairdocs.org/ntsb/NYC83FA122.md): Cessna 172N · N. Stonington, CT · Accident · Serious injuries · Field investigation · Final report · May 20, 1983 · N4980G · Destroyed > The acft collided with a tree during a go-around at night following a downwind precautionary landing. During the flt the plt had noted the fuel gauges at low readings and said he suspected a 'fuel leak'. He made radio calls to try to go to an arpt before fuel… - [NTSB NYC83FA121](https://openairdocs.org/ntsb/NYC83FA121.md): Mooney M-20K · Old Lyme, CT · Accident · 1 fatal · Field investigation · Final report · May 20, 1983 · N231HT · Destroyed > The acft collided with the ground in IMC after the plt reported he lost his vacuum instruments. The flt originated at mattituck, NY with a destination of lebanon, NH. After departure the plt was cleared to climb to 7000 ft. the instrumentrated pilot was on an… - [NTSB FTW83LA242](https://openairdocs.org/ntsb/FTW83LA242.md): Cessna 150 · Covington, TX · Accident · No injuries · Limited investigation · Final report · May 19, 1983 · N10069 · Substantial damage > At about 400 ft AGL after takeoff the eng quit. The acft collided with the ground avoiding power lines. The plt attributed the eng failure to water in fuel. - [NTSB FTW83FA238](https://openairdocs.org/ntsb/FTW83FA238.md): Aerospatiale AS-350D · Venice, LA · Accident · 1 fatal · Field investigation · Final report · May 18, 1983 · N36062 · Destroyed > The acft crashed into a swamp with low rotor RPM after a failure of the accessory gearbox power output gear. The pilot radioed an emergency call saying he was experiencing severe vibrations and was landing. A few seconds later, he radioed that he was… - [NTSB CHI83LA221](https://openairdocs.org/ntsb/CHI83LA221.md): Cessna 152 · Detroit, MI · Accident · No injuries · Limited investigation · Final report · May 18, 1983 · N67880 · Substantial damage > The acft made a forced landing off airport and collapsed the rt main landing gear during a landing on a street after theengine quit. Investigation revealed that the acft was filled with fuel for 2 afternoon flights and not refueled afterwards. During the… - [NTSB MIA83FA143](https://openairdocs.org/ntsb/MIA83FA143.md): Piper PA-28-140 · Near South Bay, FL · Accident · 1 fatal · Field investigation · Final report · May 17, 1983 · N8235N · Destroyed > The plt had recently purchased the acft & was using it to commute on a weekly basis between his residence in hialeah & la belle where he worked as an acft mechanic. The wreckage was found completely submerged in a canal after a Florida fish & game official… - [NTSB DEN83FA114](https://openairdocs.org/ntsb/DEN83FA114.md): Piper PA-28R · Burns, WY · Accident · 1 fatal · Field investigation · Final report · May 17, 1983 · N33066 · Destroyed > Before departing, the plt received a wx briefing & was advised that VFR flt was not recommended thru western Nebraska & eastern Wyoming. A frontal wx sys was forcasted to produce thunderstorm activity with associated turbulence & rain. Reportedly, the plt was… - [NTSB NYC83FA115](https://openairdocs.org/ntsb/NYC83FA115.md): Beech BE60 · Robbinsville, NJ · Accident · No injuries · Field investigation · Final report · May 16, 1983 · N821BE · Substantial damage > The acft was structurally damaged during recovery from a descending right spiral that occurred as the flt passed thru flt level 190. As the plt recvd from the descending spiral the inboard and outboard aileron hinge rivets were sheared. The altitude deviation… - [NTSB LAX83LJA07](https://openairdocs.org/ntsb/LAX83LJA07.md): Grumman AA-1C · Kauai, HI · Accident · No injuries · Final report · May 15, 1983 · N39019 · Destroyed > The acft descended at a flat angle under power into trees after the engine lost power. The pilot took off at 1010 for a sightseeing flight. The temperature was 78 and the dew point was 65 degrees f. after about 30 minutes of flight the pilot turned to avoid… - [NTSB LAX83FU004](https://openairdocs.org/ntsb/LAX83FU004.md): Eipper Quicksilver MX · Lakeside, CA · Accident · Serious injuries · Final report · May 15, 1983 · UNREG · Destroyed > After takeoff, the plt encountered clouds in a mountainous area. She elected to fly above the clouds, but had difficulty finding an opening for a descent. After eventually finding an opening, she descended below the clouds, but found she was in an unfamiliar… - [NTSB SEA83LA097](https://openairdocs.org/ntsb/SEA83LA097.md): Piper PA-25-235B · La Grande, OR · Accident · No injuries · Limited investigation · Final report · May 14, 1983 · N7757Z · Destroyed > The acft stalled about 30 feet AGL during a forced landing after the engine quit from fuel exhaustion. The pilot took the acft for a ferry flight without refueling. It had been flown about 1 hour & 15 minutes. It holds about 36 gallons and burns about 14… - [NTSB NYC83IA113](https://openairdocs.org/ntsb/NYC83IA113.md): Cessna 402C · Boston, MA · Incident · No injuries · Incident investigation · Final report · May 14, 1983 · N6791Y · No damage > While in level flight a Cessna 402 passed behind an Airbus A-300 in descent for landing. The Cessna 402 rolled inverted. The pilot regained control and landed without further incident at his destination. Both acft were on instrument flight plans, in… - [NTSB LAX83LA229](https://openairdocs.org/ntsb/LAX83LA229.md): Cessna 182R · Duckwater, NV · Accident · Minor injuries · Limited investigation · Final report · May 14, 1983 · N9951H · Substantial damage > The acft collided with the terrain after descending to 600 ft AGL and encountering a weather phenomenon which prompted an airspeed decay and uncommanded loss of altitude. Two other acft in the flt of 3 experienced the same phenomenon to a lesser degree… - [NTSB FTW83LA234](https://openairdocs.org/ntsb/FTW83LA234.md): Beech TC-45G · Abilene, TX · Accident · No injuries · Limited investigation · Final report · May 14, 1983 · N63310 · Substantial damage > About 30 mi east of Abilene there was a partial loss of power on the left eng. The plt feathered the prop & made an emergency approach into Abilene. Unable to hold initial approach altitude, the plt restarted the left eng, but could obtain only partial power.… - [NTSB NYC83FA110](https://openairdocs.org/ntsb/NYC83FA110.md): Grumman American AA5B · Bedminster, NJ · Accident · Serious injuries · Field investigation · Final report · May 13, 1983 · N28426 · Substantial damage > The acft crashed into trees during a forced landing after a loss of power while enroute from white plains. The engine started to shake and the rpms decreased. The plt initiated emergency procedures but the engine continued to run roughly.a decision was made… - [NTSB DEN83FA111](https://openairdocs.org/ntsb/DEN83FA111.md): Piper PA28R-201T · Aurora, CO · Accident · No injuries · Field investigation · Final report · May 13, 1983 · N2943Z · Substantial damage > The plt received a jump start because the battery failed to start the eng. After departure & leveling of at 10,000 ft, he was concerned with the 1 inch of rime ice he had picked up & got an updated wx briefing from flt watch. He asked for & received a… - [NTSB CHI83FA213](https://openairdocs.org/ntsb/CHI83FA213.md): Mooney M-20-J-201 · Bloomington, IL · Accident · 1 fatal · Field investigation · Final report · May 13, 1983 · N201GG · Destroyed > Prior to the accident, a witness heard the acft, then saw it for a short time thru an opening in the clouds. In his opinion, it was heading directly into a thunderstorm, which concerned him. He said that rain was falling, and about 10 min later, the… - [NTSB MKC83IA109](https://openairdocs.org/ntsb/MKC83IA109.md): Cessna 441 · Arkansas City, KS · Incident · No injuries · Incident investigation · Final report · May 12, 1983 · N36962 · Minor damage > The pilot experienced elevator control problems and made an emergency landing on an abandoned airstrip. The elevator trim cable had come off of the electric trim servo drum and was tangled in the auto pilot. An unrelated fire destroyed the aircraft. Post fire… - [NTSB ATL83AA184](https://openairdocs.org/ntsb/ATL83AA184.md): Aero Commander 680 · Titusville, FL · Accident · 3 fatal · Final report · May 12, 1983 · N6880S · Destroyed > Witnesses saw the acft briefly before it crashed. One witness saw the acft flying toward a dark cloud at an unknown alt, but too high to fly under it. Shortly thereafter, he heard the eng noise increase & decrease, then increase until it was loud. He then… - [NTSB NYC83FNA02](https://openairdocs.org/ntsb/NYC83FNA02.md): Rogers Long EZ · Fall River, MA · Accident · No injuries · Final report · May 11, 1983 · N245R · Substantial damage > The plt reported that during flt, the eng lost power. He moved the carburetor heat control to apply carb heat & tried to start the eng, but was unable. He then tried to land on a road, but crashed in a wooded area before reaching the roadway. An investigation… - [NTSB FTW83FU001](https://openairdocs.org/ntsb/FTW83FU001.md): Rotec Rally 2B · Manvel, TX · Accident · 1 fatal · Final report · May 8, 1983 · UNREG · Destroyed > The plt had flown the ultralight vehicle to his employer's house & landed in the back yard. During the landing, the vehicle sustained damage which included a bent main landing gear axle, a sheared kingpin bolt & a cracked tail boom to tailmount sleeve. A… - [NTSB ATL83FA179](https://openairdocs.org/ntsb/ATL83FA179.md): Cessna C-150H · Fort Valley, GA · Accident · 2 fatal · Field investigation · Final report · May 7, 1983 · N7146S · Destroyed > After a touch-and-go landing, the aircraft was observed to turn after takeoff, enter a steep climp, then go into a steep nose down descent & crash. Witnesses reported hearing the eng operating until just prior to impact. An exam of the acft & eng revealed no… - [NTSB LAX83LA221](https://openairdocs.org/ntsb/LAX83LA221.md): Cessna 152 · Mohave County, AZ · Accident · Minor injuries · Limited investigation · Final report · May 6, 1983 · N714VK · Substantial damage > After flying at an altitude of 300-500 feet for about 45 minutes the pilot intentional landed on a dirt road and inquired about directions to their intended destination. The person the pilot spoke to said she saw the acft become airborne but it was flying… - [NTSB LAX83LA220](https://openairdocs.org/ntsb/LAX83LA220.md): Cessna 182Q · Parker, AZ · Accident · Minor injuries · Limited investigation · Final report · May 6, 1983 · N94762 · Destroyed > The acft collided with a tree during an off arpt precautionary landing after the engine 'started running rough.' The pilot described a surging condition and utilized the term 'sputtering' to characterize the engine sound. During the investigation about 1 1/2… - [NTSB DEN83LA109](https://openairdocs.org/ntsb/DEN83LA109.md): Beech C-50 · Nephi, UT · Accident · Minor injuries · Limited investigation · Final report · May 6, 1983 · N322V · Substantial damage > The acft collided with rocks and sagebrush during a forced landing after the engine lost power. The acft encountered induction and airframe icing during cruise. The pilots weather briefing forecast the icing which he encountered. The briefing took place about… - [NTSB CHI83IA209](https://openairdocs.org/ntsb/CHI83IA209.md): Aero Commander 500B · Youngstown, OH · Incident · No injuries · Incident investigation · Final report · May 6, 1983 · N6178X · Minor damage > While cruising at 5000 ft MSL, the plt heard a 'very loud bang' & noted 'very much vibration from the left eng.' He shut down & feathered the left eng & prop. When the eng stopped turning, he noted 1 prop blade was missing. The acft was landed without further… - [NTSB ATL83LA180](https://openairdocs.org/ntsb/ATL83LA180.md): Eippen MX-2 · Raleigh, NC · Accident · No injuries · Limited investigation · Final report · May 6, 1983 · N242KH · Substantial damage > The acft nosed over during a forced landing after the engine failed. Examination of the engine after the accident revealed that the #2 cyl piston was badly scored. The cyl. Head temperature gauge read 100 deg lower than the actual temperature. Epoxy sealant… - [NTSB MIA83AA136](https://openairdocs.org/ntsb/MIA83AA136.md): Lockheed L-1011 · Miami, FL · Incident · No injuries · Final report · May 5, 1983 · N334EA · No damage > The Safety Board's full report on this investigation is provided as Aviation Accident Report number AAR-84/04. To obtain a copy of this report, or to view the executive summary online, please see the Web site at http://www.ntsb.gov/publictn/publictn.htm… - [NTSB CHI83LA196](https://openairdocs.org/ntsb/CHI83LA196.md): Cessna A185F · Logansport, IN · Accident · Minor injuries · Limited investigation · Final report · May 5, 1983 · N533H · Destroyed > The plt had recently purchased the amphibious acft, had received 6.7 hrs dual instruction & was indorsed for solo flt. During a x-country from elizabethton, TN, he landed at richmond, KY & purchased 23. 8 gal of fuel. On the next leg to lafayette, IN, he made… - [NTSB MKC83LA100](https://openairdocs.org/ntsb/MKC83LA100.md): Cessna 172N · Cape Girardeau, MO · Accident · Minor injuries · Limited investigation · Final report · May 4, 1983 · N1996E · Substantial damage > The pilots were participating in a grand prix air race. After a normal preflight, they took off & crossed over the arpt for race timing purposes. A climb was begun on course, and a short time later, the engine began loosing power. The aircrew turned back… - [NTSB LAX83LA217](https://openairdocs.org/ntsb/LAX83LA217.md): Maule M4-210 · Hesperia, CA · Accident · Minor injuries · Limited investigation · Final report · May 4, 1983 · N4624T · Substantial damage > The acft made a hard landing off the runway on an airport during a forced landing. According to the pilot the acft had just come out of annual inspection and it was noted that the fuel selector valve handle was broken. A new valve was ordered and a temporary… - [NTSB LAX83LA212](https://openairdocs.org/ntsb/LAX83LA212.md): Piper PA-28-151 · Milpitas, CA · Accident · No injuries · Limited investigation · Final report · May 3, 1983 · N40755 · Substantial damage > While descending thru 4300 ft, the eng lost power. The plt made an emergency landing on a gulf course, but during the landing roll, the right wing of the acft impacted a pole & was damaged. An exam revealed that the 5/16 inch bolt, pn STD-847, that secured… - [NTSB DEN83FA108](https://openairdocs.org/ntsb/DEN83FA108.md): Piper 28-180 · Alpine, WY · Accident · 1 fatal · Field investigation · Final report · May 3, 1983 · N7295W · Destroyed > The acft collided with mountainous terrain in IMC weather. The pilot had been briefed on the weather. Part of the observation called for mountain obscuration by clouds or precipitation. A person who resides in Alpine, WY said the mountain tops were obscured… - [NTSB FTW83LA215](https://openairdocs.org/ntsb/FTW83LA215.md): Cessna 177B · Port Aransas, TX · Accident · 2 fatal · Limited investigation · Final report · May 2, 1983 · N34581 · Destroyed > During a wx briefing, the non-instrument rated plt was told to expect no significant en route wx, but was advised of lower ceilings along the coastline, later that night. There were no records of en route wx briefings. When the acft was about 40 mi northwest… - [NTSB ATL83FA174](https://openairdocs.org/ntsb/ATL83FA174.md): Piper PA 32RT-300T · Murfreesboro, TN · Accident · 2 fatal · Field investigation · Final report · May 2, 1983 · N22011 · Destroyed > The acft crashed in an open field after an in-flt fire. The fire started while the acft was cruising. No emergency callswere made and the engine which was the fire source was not shut down. A rear seat passenger said he tried to open a reardoor to let out… - [NTSB MKC83FA098](https://openairdocs.org/ntsb/MKC83FA098.md): Piper PA-34-200T · Stover, MO · Accident · 4 fatal · Field investigation · Final report · May 1, 1983 · N1091X · Destroyed > The acft crashed into a wooded area in a high speed descent on a dark and stormy night. The pilot had telephoned the st. louis fss on 04/30/83 and requested Kansas city weather. The weather briefer advised the pilot that the area was in a tornado watch. The… - [NTSB LAX83LA210](https://openairdocs.org/ntsb/LAX83LA210.md): Beech 77 · Linden, CA · Accident · Minor injuries · Limited investigation · Final report · May 1, 1983 · N36986 · Destroyed > The pilot was cruising at 3000 feet beneath an overcast sky with intermittent rain. The carb heat was off. After about 20 minutes of flight the RPM began to slowly decrease. The pilot briefly applied carb heat but as the RPM only fluctuated and power was not… - [NTSB FTW83LA227](https://openairdocs.org/ntsb/FTW83LA227.md): Cessna 182P · Lonoke, AR · Accident · No injuries · Limited investigation · Final report · May 1, 1983 · N7044Q · Substantial damage > The eng quit after takeoff. The acft crashed in a wheat field while returning to the arpt. The carb was found full of water. The acft salvage operator reported finding a large quantity of water in the bladder-type fuel cells. - [NTSB NYC83FFJ02](https://openairdocs.org/ntsb/NYC83FFJ02.md): Grumman G-164A · Clarkson, NY · Accident · No injuries · Final report · Apr 30, 1983 · N5309 · Substantial damage > The pilot was diverting from the arpt of departure to an alternate arpt because of the severe weather. The turbulence encountered was so severe, according to the pilot's statement, that he lost control of the acft. Partial control was regained but too late to… - [NTSB LAX83FA211](https://openairdocs.org/ntsb/LAX83FA211.md): Piper PA-28-181 · Redlands, CA · Accident · 4 fatal · Field investigation · Final report · Apr 30, 1983 · N9233K · Destroyed > Before flying, the plt told the FBO that he would stay in the local Redlands/riverside, CA area. However, after taking off, he flew to las vegas, NV. He departed las vegas at 1636 PDT. When he did not return to Redlands, a search was initiated. The wreckage… - [NTSB ATL83LA173](https://openairdocs.org/ntsb/ATL83LA173.md): Piper PA-28-140C · Lynchburg, VA · Accident · Minor injuries · Limited investigation · Final report · Apr 30, 1983 · N5286S · Substantial damage > Shortly after midnight on the morning of 4/30/83, the flt originated at blacksburg, VA. Neither the time en route nor the arrival time at gaithersburg, MD was reported. According to the plt, he departed from gaithersburg at 1050 EDT. The flt was normal until… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=370 ## 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=369 --- 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.