# NTSB investigations: Approach NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 210 of 420 · 20,992 cases ## Cases, newest first - [NTSB CHI83LA271](https://openairdocs.org/ntsb/CHI83LA271.md): Beech E18S · Youngstown, OH · Accident · No injuries · Limited investigation · Final report · Jun 19, 1983 · N995H · Substantial damage > The plt had not obtained a wx briefing, but had gotten info from another company plt who had flown into the destination arpt earlier. During arrival, he could see the rotating beacon & rwy lights thru some fog & elected to make a visual apch. At aprx 75 ft… - [NTSB DEN83LA144](https://openairdocs.org/ntsb/DEN83LA144.md): Piper PA-22-160 · Brighton, CO · Accident · No injuries · Limited investigation · Final report · Jun 18, 1983 · N2801Z · Substantial damage > After entering the landing pattern, the plt noted binding of the aileron control system. Reportedly the aileron controls seemed to lock, so he used the rudders for directional control & landed in a plowed field. During the landing, the acft nosed over. An… - [NTSB SEA83FA127](https://openairdocs.org/ntsb/SEA83FA127.md): Piper PA-24-250 · Stehekin, WA · Accident · 2 fatal · Field investigation · Final report · Jun 16, 1983 · N47RR · Destroyed > The acft crashed into trees at the departure end of the rwy during a go-around. The pilot had attempted a landing on RWY34 with full flaps. Power was cut on final over the trees at 75 mph. When touchdown had not been accomplished about halfway down the rwy… - [NTSB MIA83LA157](https://openairdocs.org/ntsb/MIA83LA157.md): Burkhart Grob G102 · Chuluota, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 12, 1983 · N155SS · Substantial damage > The plt reported that after he was airborne for 40 min, he was forced to terminate the flt due to the apch of a severe rain shower. He stated that when the acft was on a final apch to rwy 11, a sink rate developed that he could not arrest. Subsequently, the… - [NTSB MIA83LA156](https://openairdocs.org/ntsb/MIA83LA156.md): Cessna 210L · Alva, FL · Accident · No injuries · Limited investigation · Final report · Jun 12, 1983 · N2188S · Substantial damage > On departure the pilot stated that the landing gear would not retract fully and the engine did not seem to be producing full power so he elected to return to the airport. During the turn from base to final approach, flaps were extended to the full position.… - [NTSB FTW83FA271](https://openairdocs.org/ntsb/FTW83FA271.md): Cessna TU206F · Pampa, TX · Accident · 3 fatal · Field investigation · Final report · Jun 12, 1983 · N35925 · Destroyed > During arrival on a dark night, the acft collided with level ground aprx 1 mi northeast of the arpt. It touched down on a west northwesterly heading in aprx a 45 deg, left bank, slightly nose down, attitude. An exam of the wreckage was made, but no evidence… - [NTSB NYC83FHD02](https://openairdocs.org/ntsb/NYC83FHD02.md): Piper PA-32-260 · Trenton, NJ · Accident · Serious injuries · Final report · Jun 11, 1983 · N15SB · Destroyed > The acft collided with a railroad bridge overpass during a forced landing after fuel exhaustion. The flt departed NC fornj with an enroute stop to drop off a passenger. The pilot was unable to refuel at this stop as planned and departed andoverflew other… - [NTSB MKC83LA123](https://openairdocs.org/ntsb/MKC83LA123.md): Cessna 150H · Salem, MO · Accident · No injuries · Limited investigation · Final report · Jun 10, 1983 · N6732S · Substantial damage > The flt instructor (CFI) initiated a simulated forced landing at about 500 ft AGL as the acft was climbing during takeoff at night. The student elected to turn downwind for a landing on the departure rwy. When the CFI determined that the student would not be… - [NTSB ATL83LA226](https://openairdocs.org/ntsb/ATL83LA226.md): Let L-13 · Warrenton, VA · Accident · No injuries · Limited investigation · Final report · Jun 10, 1983 · N90626 · Substantial damage > The pilot stated that this was his third flt of the day and his first in this particular acft. He misjudged his glide path and landed about 100 feet short of the runway. The glider rolled into the creek and the nose impacted about 2 feet below the top of the… - [NTSB CHI83LA247](https://openairdocs.org/ntsb/CHI83LA247.md): Cessna 177RG · Lansing, MI · Accident · No injuries · Limited investigation · Final report · Jun 9, 1983 · N53060 · Substantial damage > The acft made a forced landing when the engine quit during the turn to final approach. Just prior to engine failure the pilot stated that he changed the fuel selector to what he believed to be the both tanks position but he actually turned it to the off… - [NTSB ATL83FA224](https://openairdocs.org/ntsb/ATL83FA224.md): Cessna 172 · Mocksville, NC · Accident · Serious injuries · Field investigation · Final report · Jun 8, 1983 · N5722T · 2 aircraft · Substantial damage > N5722T, a Cessna 172, and N3452J, a Cessna 150, collided over the approach end of runway 09 while both acft were on short final approach. Both acft impacted the runway and came to rest about 280 ft east of runway 09 threshold. - [NTSB LAX83LA273](https://openairdocs.org/ntsb/LAX83LA273.md): I.C.A. Brasov IS-29D2 · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jun 7, 1983 · N46045 · Substantial damage > According to the plt, he received an aerial tow to 2500 ft AGL, and after releasing, the glider encountered sinking wx conditions. He proceeded back to the arpt. After entering a downwind for landing, the glider reportedly encountered an area of extreme sink.… - [NTSB ANC83FA092](https://openairdocs.org/ntsb/ANC83FA092.md): Bell B47G-2 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jun 7, 1983 · N6140C · Substantial damage > The helicopter experienced a tail rotor strike during a hard landing with a door open. According to the student pilot who is a commercial pilot working on an add-on helicopter rating, the left cockpit door unlatched and partially opened on the downwind leg… - [NTSB MKC83FA122](https://openairdocs.org/ntsb/MKC83FA122.md): Cessna 320E · Minden, NE · Accident · Serious injuries · Field investigation · Final report · Jun 6, 1983 · N26972 · Substantial damage > The acft stalled and crashed on the final approach to land. The acft had called for landing information and entered the pattern and was seen established in a low final approach when it suddenly turned right and descended to the ground. The acft impacted about… - [NTSB ATL83LA217](https://openairdocs.org/ntsb/ATL83LA217.md): Aeronca 7AC · Shinnston, WV · Accident · Minor injuries · Limited investigation · Final report · Jun 6, 1983 · N3511E · Substantial damage > The instructor (CFI) was providing takeoff & landing instructions to his son, a student plt. After making a takeoff & landing, they took off again on rwy 22. At lift-off, the CFI noticed a Cessna 180 being taxied for takeoff. At aprx 300 ft AGL, they made a… - [NTSB SEA83FU003](https://openairdocs.org/ntsb/SEA83FU003.md): Sunburst Ultralight · Independence, OR · Accident · Serious injuries · Final report · Jun 5, 1983 · UNREG · Destroyed > The pilot stated that he was trying to teach himself to fly his ultrlight. After several takeoffs from a friends field, a rather severe crosswind started which complicated landing. After numerous passes at the small strip, the pilot said he decided to land… - [NTSB NYC83LA154](https://openairdocs.org/ntsb/NYC83LA154.md): Schweizer 2-33 · Freeport, PA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N65859 · Substantial damage > The glider collided with a fence during landing. The glider had experienced loss of lift shortly after a release from tow at 2500 ft AGL. Heavy sink and alt loss was encountered and continued. The pilot started a long straight in final approach to land but it… - [NTSB NYC83LA134](https://openairdocs.org/ntsb/NYC83LA134.md): Beech 77 · W. Mifflin, PA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N66982 · Substantial damage > The acft landed about 20 ft short of the runway shearing the nose gear and damaging the prop. The student pilot said he encountered a 'small' windshear and he over reacted on the controls causing the acft to contact the ground short of the runway surface. - [NTSB LAX83LA286](https://openairdocs.org/ntsb/LAX83LA286.md): Johnson VARI-EZE · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N36RJ · Substantial damage > The pilot stated that in an attempt to improve his landings and reduce the landing roll, the airspeed on final was 10 mph less than normally used. He was also attempting to touchdown on the numbers at the threshold. The acft's landing gear struck a small dike… - [NTSB CHI83LA248](https://openairdocs.org/ntsb/CHI83LA248.md): Helio H-391B · Croton, MI · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N4119D · Substantial damage > The acft collided with wires on an approach to a lake. - [NTSB CHI83LA244](https://openairdocs.org/ntsb/CHI83LA244.md): Monerai Sailplane · Montpelier, OH · Accident · Serious injuries · Limited investigation · Final report · Jun 5, 1983 · N13HT · Substantial damage > The glider dragged a wing and carlwheeled during a low turn maneuver by the pilot. The pilot stated that he apparently had failed to lock the flap handle in the proper position and the acft had picked up excess airspeed. In trying to stay in the rwy… - [NTSB CHI83FA239](https://openairdocs.org/ntsb/CHI83FA239.md): Beech 35 · Auburn, OH · Accident · 1 fatal · Field investigation · Final report · Jun 5, 1983 · N3939N · Destroyed > The acft approached the 1800 ft grass strip from the west. Local residents reported the wind as from the wse at 28-30 mph. There was no wind sock at the landing strip. According to witnesses the acft traveled 3/4 of the rwy without touching the ground. At… - [NTSB ATL83LA212](https://openairdocs.org/ntsb/ATL83LA212.md): Cessna 150L · Raeford, NC · Accident · Minor injuries · Limited investigation · Final report · Jun 5, 1983 · N5386Q · Destroyed > The pilot stated that he wanted to practice night landings. He made on successful touch and go landing. On the second attempt he went low on final and struck the top of trees short of the runway. A VASI was in place on the landing runway. The pilot had flown… - [NTSB LAX83LA269](https://openairdocs.org/ntsb/LAX83LA269.md): Cessna T337H · Redding, CA · Accident · No injuries · Limited investigation · Final report · Jun 4, 1983 · N1497S · Substantial damage > During the landing sequence at a private airstrip the plt attempted to lower the landing gear but found it would not lock. The acft was returned to the departure arpt and after circling for two and one half hours with darkness approaching was landed with the… - [NTSB CHI83LA241](https://openairdocs.org/ntsb/CHI83LA241.md): Piper PA-28-140 · Big Lake, MN · Accident · No injuries · Limited investigation · Final report · Jun 4, 1983 · N55270 · Substantial damage > The acft collided with a railroad sign during approach to a private airstrip. The weather was VMC but there was a cross-wind of about 15 KTS and a low sun creating sunglare. The acft drifted to the south side of the rwy due to wind and collided with the sign.… - [NTSB ATL83FA211](https://openairdocs.org/ntsb/ATL83FA211.md): Piper PA-28-140 · Lexington, NC · Accident · Serious injuries · Field investigation · Final report · Jun 3, 1983 · N7571R · Substantial damage > The acft crashed short of the approach end of the intended landing rwy. The weather was VMC. The landing rwy was 26 and the pilot said he realized he was low on the final approach. During the approach the acft was blown off the approach path. Although the… - [NTSB NYC83FNC06](https://openairdocs.org/ntsb/NYC83FNC06.md): Grumman AA-5A · Warren, VT · Accident · No injuries · Final report · Jun 2, 1983 · CGAEX · Substantial damage > The plt reported that during a landing on rwy 4, he encountered wind shear which forced the acft to lose alt & touch down short of the rwy. The acft then veered left & collided with a hangar. The plt reported the wind was from 300 deg at 12 gusting 18 KTS.… - [NTSB ATL83LA207](https://openairdocs.org/ntsb/ATL83LA207.md): Rand KR-2 · Dayton, TN · Accident · No injuries · Limited investigation · Final report · Jun 1, 1983 · N83UT · Substantial damage > The acft had been airborne for over 1 hr & was descending onto base leg when the eng quit running as the plt went to add power. A forced landing was made in a grassy area near the rwy. After the acft touched down, it hit a ditch during the roll-out, then… - [NTSB NYC83FA128](https://openairdocs.org/ntsb/NYC83FA128.md): Cessna 172RG · Plattsburgh, NY · Accident · No injuries · Field investigation · Final report · May 31, 1983 · N6207R · Substantial damage > During an IFR arrival, aprx 1 mi from the outer marker (om), the plt asked for a descent from 3300 ft MSL & was cleared for the localizer, rwy 1 apch. The published min alt at the om was 2100 ft. the plt reported at the om, and 11 seconds later, the… - [NTSB LAX83FA256](https://openairdocs.org/ntsb/LAX83FA256.md): Beech H35 · Antioch, CA · Accident · 4 fatal · Field investigation · Final report · May 31, 1983 · N391B · Destroyed > The acft collided with the ground in a nose low attitude during flt in the traffic pattern to land. Witnesses described the pattern as being close in, slow and low compared to normal traffic. The attitude of the acft was described as nose high. As the acft… - [NTSB NYC83FA126](https://openairdocs.org/ntsb/NYC83FA126.md): Beech B36TC · Farmingdale, NY · Accident · 4 fatal · Field investigation · Final report · May 30, 1983 · N837E · Destroyed > The acft collided with a powerline static wire during an instrument landing approach. The private plt was instrument rated and had received a weather briefing and filed an IFR flt plan. He commented to the briefer that 'it doesn't sound too good' and that he… - [NTSB LAX83FU007](https://openairdocs.org/ntsb/LAX83FU007.md): Ultralight Engineering Astra HS · Bakersfield, CA · Accident · 1 fatal · Final report · May 30, 1983 · UNREG · Substantial damage > The plt was on a familiarization flt in preparation to fly the Ultralight vehicle on a x-country to evaluate it for a magazine article. The eng quit on the 1st flt & a successful forced landing was made. Reportedly, the vehicle required only minor repairs & a… - [NTSB LAX83FU006](https://openairdocs.org/ntsb/LAX83FU006.md): Eipper Weight Shift · Bakersfield, CA · Accident · 1 fatal · Final report · May 30, 1983 · UNREG · Substantial damage > Reportedly, the plt was lining up on final apch to land when the ultralight vehicle collided with a power line at aprx 30 ft AGL. According to the county coroner, the plt died from accidental electrocution on 5/31/83. - [NTSB FTW83FA253](https://openairdocs.org/ntsb/FTW83FA253.md): Piper PA28R200 · Decatur, TX · Accident · 1 fatal · Field investigation · Final report · May 30, 1983 · N41761 · Destroyed > After landing due to poor wx the pilot obtained a wx briefing during which he was told of a long line of thunderstorms 150 miles wide covering the area in which he was located. The pilot departed & then attempted to land at an airport 15 miles away in gusty… - [NTSB FTW83FA252](https://openairdocs.org/ntsb/FTW83FA252.md): Piper PA-60 · New Orleans, LA · Accident · 1 fatal · Field investigation · Final report · May 30, 1983 · N52AC · Destroyed > Witnesses reported that when the acft was stabilized on final apch, it pitched up slightly & yawed, then rolled left to an inverted attitude & crashed in a canal. Several witnesses stated that the left prop was windmilling. One stated the left prop had… - [NTSB SEA83LA114](https://openairdocs.org/ntsb/SEA83LA114.md): Stinson 108 · Grants Pass, OR · Accident · No injuries · Limited investigation · Final report · May 29, 1983 · N6202M · Substantial damage > The acft ran off the runway and collided with bushes during an aborted go-around. According to the pilot a crosswind caught the acft as he was landing, in spite of his attempts to keep it straight the acft started to veer to the left and he decided to… - [NTSB ATL83LA204](https://openairdocs.org/ntsb/ATL83LA204.md): Mooney M20K · Mitchellville, MD · Accident · No injuries · Limited investigation · Final report · May 29, 1983 · N9872Q · Substantial damage > The acft collided with a chain link fence and a dirt bank on the final approach just prior to touchdown. The fence was about a foot and a half higher than the dirt and the dirt bank was aprx an equal height above the runway. The plt had flown through rain… - [NTSB CHI83LA233](https://openairdocs.org/ntsb/CHI83LA233.md): Piper PA-34-200T · Woodruff, WI · Accident · No injuries · Limited investigation · Final report · May 28, 1983 · N2164X · Substantial damage > The plt was briefed on the wx before departing waukegan, IL. At the destination, Woodruff, WI, the wx was forecasted to be VFR, except for light rain & the chance of scattered thunderstorms. While en route, the plt checked on the wx & spoke with another plt… - [NTSB CHI83LA231](https://openairdocs.org/ntsb/CHI83LA231.md): Cessna 152 · Steubenville, OH · Accident · No injuries · Limited investigation · Final report · May 27, 1983 · N757TV · Substantial damage > The student plt & an instructor (CFI) were practicing touch-and-go landings. On about the 5th pattern, the CFI moved the mixture control to the off position to simulate an engine failure. He stated that he had been taught to do this by his instructor. When… - [NTSB FTW83LA249](https://openairdocs.org/ntsb/FTW83LA249.md): Cessna 150M · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · May 26, 1983 · N66245 · Substantial damage > The Certified Flight Instructor's delayed remedial action which resulted in the dual student stalling the airplane. - [NTSB ATL83LA202](https://openairdocs.org/ntsb/ATL83LA202.md): Cessna 195 · Florence, SC · Accident · No injuries · Limited investigation · Final report · May 26, 1983 · N4395V · Substantial damage > According to the plt, the eng lost power about 3 mi from the arpt after he switched from the right to the left fuel tank. He reported that he switched the boost pump to the 'high' position, but was unable to restart the eng. He estimated there was 5 to 7 gal… - [NTSB DEN83FA120](https://openairdocs.org/ntsb/DEN83FA120.md): Piper PA-38-112 · Canon City, CO · Accident · 2 fatal · Field investigation · Final report · May 25, 1983 · N2433L · Destroyed > During base turn the acft stalled, rolled over & spun to the ground. - [NTSB CHI83LA227](https://openairdocs.org/ntsb/CHI83LA227.md): Piper PA28-151 · Elgin, IL · Accident · No injuries · Limited investigation · Final report · May 25, 1983 · N6758F · Substantial damage > The acft collided with the roof of a trailer truck during an approach to land over a toll road. The collision separated the left main gear from the acft and damaged the other two landing gear. The impact left two depressions about 2 inches deep in the edge of… - [NTSB MIA83FA145](https://openairdocs.org/ntsb/MIA83FA145.md): Piper PA-22 · Pompano Beach, FL · Accident · 1 fatal · Field investigation · Final report · May 23, 1983 · N8983C · Destroyed > The surviving pax stated that about 1 mi from the rwy their alt was 1,000 ft & 'lots of speed.' The plt was cleared to land on rwy 13. The plt then reported 'we go around again...' He was advised by the tower to make left traffic. He was then observed… - [NTSB ANC83LA084](https://openairdocs.org/ntsb/ANC83LA084.md): Piper PA-28-151 · Big Lake, AK · Accident · Minor injuries · Limited investigation · Final report · May 23, 1983 · N43598 · Substantial damage > The acft collided with trees and stalled into the ground during a go-around. The plt stated that the acft was using up a lot of rwy during the landing so he initiated a go-around. He added full power but was unable to gain enough altitude to clear the trees.… - [NTSB MKC83FA113](https://openairdocs.org/ntsb/MKC83FA113.md): Bensen B-8M · Herington, KS · Accident · 1 fatal · Field investigation · Final report · May 22, 1983 · UNREG · Substantial damage > The builder/plt purchased the basic airframe & rotor kit from Bensen, but purchased the eng from another source. The eng was not modified iaw Bensen instructions. Reportedly, the plt was only going to conduct taxi & ground runs when he started at aprx 1100… - [NTSB CHI83FA224](https://openairdocs.org/ntsb/CHI83FA224.md): Cessna 172P · Joliet, IL · Accident · Minor injuries · Field investigation · Final report · May 22, 1983 · N53700 · Substantial damage > The acft made a hard landing and nosed over during a forced landing after engine failure on the base leg. The flt was onthe base leg with power at idle and carburetor heat on when the engine lost power. The pilot was unable to restart the engine. The pilot… - [NTSB DEN83LU001](https://openairdocs.org/ntsb/DEN83LU001.md): Intl Ultralight Banshee · St. George, UT · Accident · 1 fatal · Final report · May 21, 1983 · UNREG · Destroyed > Reportedly, the ultralight vehicle was assembled at an abandoned arpt, then was test flown by an international ultralight company salesman. The non-rated plt, who was planning to buy the ultralight, then flew the vehicle to familiarize himself with its flt… - [NTSB ATL83LA193](https://openairdocs.org/ntsb/ATL83LA193.md): Cessna 182P · Nashville, TN · Accident · Minor injuries · Limited investigation · Final report · May 21, 1983 · N8074M · Substantial damage > The acft collided with a powerline while on an ILS approach. The weather was VMC but scattered clouds and a dark night necessitated the instrument approach. The pilot stated that he became distracted while re-setting his directional gyro and descended below… - [NTSB ATL83LA192](https://openairdocs.org/ntsb/ATL83LA192.md): Beech A36 · Stanton, KY · Accident · Minor injuries · Limited investigation · Final report · May 20, 1983 · N3828N · Substantial damage > While on final apch to land, the eng lost power when the acft was at aprx 300 ft AGL. The plt stated that he switched fuel tanks & retracted the landing gear & flaps in an effort to reach the rwy. When he saw that he could not glide to the rwy, he turned to… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=211 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')), crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')), current_codes AS ( SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code, row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*' AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982")) ), phases AS ( SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main FROM current_codes WHERE n = 1 UNION ALL SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode" WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes) ), case_phases AS ( SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1 WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names) ) SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=210 --- 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.