# 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 372 of 718 · 35,889 cases ## Cases, newest first - [NTSB CHI83LA130](https://openairdocs.org/ntsb/CHI83LA130.md): Cessna T-210L · Farmington, MN · Accident · No injuries · Limited investigation · Final report · Mar 7, 1983 · N732CJ · Substantial damage > During an IFR flight, the engine lost power at 4000 ft MSL and the pilot was unable to restart the engine. He broke out of the clouds at a low altitude in the vicinity of a lake that was covered with ice. The pilot did not know the condition of the ice, so he… - [NTSB DEN83FA072](https://openairdocs.org/ntsb/DEN83FA072.md): Piper PA-28-181 · Evanston, WY · Accident · 1 fatal · Field investigation · Final report · Mar 6, 1983 · N8406F · Substantial damage > When en route, the acft collided with power lines where they crossed over a highway about 39 ft AGL. Two witnesses near this location reported that the acft was flying low & was following the highway on a westerly heading when the acft struck the wires. The… - [NTSB DEN83FA071](https://openairdocs.org/ntsb/DEN83FA071.md): Cessna 182Q · Lake Powell, UT · Accident · 1 fatal · Field investigation · Final report · Mar 6, 1983 · N96460 · Destroyed > The acft was seen to fly erratically before plunging into the lake during an landing attempt. Investigation revealed a history of pre-existing medical problems that could lead to 'a convulsive episode with accompanied loss of consciousness.' An examination of… - [NTSB DEN83FA070](https://openairdocs.org/ntsb/DEN83FA070.md): Cessna 172 · Limon, CO · Accident · 1 fatal · Field investigation · Final report · Mar 6, 1983 · N84822 · Destroyed > The acft crashed in a snow covered field during IMC weather. Witnesses heard and saw an acft flying low in the area of the accident just before the crash. There are no known witnesses to the actual crash. The acft was discovered several hours later by a snow… - [NTSB ATL83FA128](https://openairdocs.org/ntsb/ATL83FA128.md): Cessna 310 · Hopkinsville, KY · Accident · 3 fatal · Field investigation · Final report · Mar 6, 1983 · N923CA · Destroyed > The plt obtained a wx briefing & filed a flt plan from lexington to paducah,KY with a 15 min en route stop at bowling green, KY. While inbound to bowling green, he reported that the cloud base was at aprx 6000 ft & that there was lightning to the west. After… - [NTSB ANC83IA053](https://openairdocs.org/ntsb/ANC83IA053.md): Cessna 401 · Bethel, AK · Incident · No injuries · Incident investigation · Final report · Mar 6, 1983 · N7864F · Minor damage > The acft right engine started emitting sparks from the cowling during normal cruise. The pilot noted a drop in manifold pressure so he reduced power on that engine and the sparks stopped. The acft was landed at Bethel. The fire dept. Used a fire extinguishing… - [NTSB FTW83LA139](https://openairdocs.org/ntsb/FTW83LA139.md): Beckner FW-3 · Victoria, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 5, 1983 · N2762J · Substantial damage > The plt was on a test flt in his home built experimental acft. While he was returning to the airport about 45 min after takeoff, the engine lost power. A forced landing was made in a muddy field where the acft nosed over. After the accident, about 1/2 gal of… - [NTSB FTW83FA142](https://openairdocs.org/ntsb/FTW83FA142.md): Cessna 210-5 · Orange Grove, TX · Accident · 1 fatal · Field investigation · Final report · Mar 4, 1983 · N8270Z · Destroyed > The plt was believed to have departed hebbronville muni arpt at about 0500 CST. When the acft failed to arrive at its destination, a search was initiated. The wreckage was found where it crashed in an area of mesquite trees & brush, about halfway between the… - [NTSB SEA83FA058](https://openairdocs.org/ntsb/SEA83FA058.md): Cessna 140 · Moses Lake, WA · Accident · 1 fatal · Field investigation · Final report · Mar 3, 1983 · N89050 · Destroyed > The flight originated at the pilots private farm strip. The pilot stated that during the flight the engine 'sputtered and died'. During a power off landing attempt the passenger grabbed the controls according to the pilot. The pilot said he fought for control… - [NTSB MKC83LA074](https://openairdocs.org/ntsb/MKC83LA074.md): Cessna 182G · Chadron, NE · Accident · No injuries · Limited investigation · Final report · Mar 3, 1983 · N2445R · Substantial damage > The engine stopped when the acft was within 10 miles from the destination airport. The pilot stated that he had the fuel valve to the 'both position' when the engine sputtered and stopped. He says he pulled on carburetor heat, switched fuel tanks, then… - [NTSB FTW83LA061](https://openairdocs.org/ntsb/FTW83LA061.md): Cessna 152 · Killeen, TX · Accident · No injuries · Limited investigation · Final report · Mar 3, 1983 · N6396Q · Substantial damage > The acft was on the return leg of an out-and-back, night, cross-country flt. The acft had 26 gal of fuel on board when it departed Killeen, TX. Reportedly, there was 18 gal on board when it took off from dallas, TX. The flt was initially conducted in VFR… - [NTSB MIA83LA086](https://openairdocs.org/ntsb/MIA83LA086.md): Cessna 150 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · Mar 2, 1983 · N60913 · Substantial damage > The acft was ditched in a lake near San Juan following engine failure due to fuel exhaustion. The pilot had rented the acft for a round trip to st. thomas. The accident occurred on the return flt to San Juan. It was reported that only residual fuel was found… - [NTSB FTW83LA138](https://openairdocs.org/ntsb/FTW83LA138.md): Piper PA-38-112 · Shiro, TX · Accident · No injuries · Limited investigation · Final report · Mar 2, 1983 · N2381K · Substantial damage > While on a solo cross-country, the student plt became disoriented on the 3rd leg of the flt. He reoriented himself, but the eng lost power before he reached his intended destination. During an emergency landing, the acft encountered soft terrain & was damaged… - [NTSB FTW83LA136](https://openairdocs.org/ntsb/FTW83LA136.md): Bellanca 7FC · Lake City, AR · Accident · No injuries · Limited investigation · Final report · Mar 2, 1983 · N7535B · Substantial damage > The plt reported that during level flt, the eng lost power. He tried to land in an open field, but the acft struck a tree top aprx 35 to 40 ft AGL, then crashed on the ground, right wing first. The plt suspected possible carburetor ice. The temp & den point… - [NTSB MIA83FA082](https://openairdocs.org/ntsb/MIA83FA082.md): Piper PA-32-301 · Brooksville, FL · Accident · 2 fatal · Field investigation · Final report · Feb 28, 1983 · N28216 · Destroyed > The acft disappeared from radar during descent from 4000 ft MSL to 2000 ft MSL. Investigation revealed SIGMET bravo 3 in effect in the area of the accident at the time of the crash. The transcript of radio communications with the flt shows no in-flt weather… - [NTSB LAX83FA320](https://openairdocs.org/ntsb/LAX83FA320.md): Beech E55 · Bridgeport, CA · Accident · 2 fatal · Field investigation · Final report · Feb 28, 1983 · N17993 · Destroyed > The recorded transcript between the plt and the reno fss specialist reveals that the plt was aware of moderate icing conditions below 18000 feet and reported moderate to severe turbulence along his proposed route of flt. The plt reported icing conditions and… - [NTSB ANC83LA049](https://openairdocs.org/ntsb/ANC83LA049.md): Raven RX-7 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Feb 28, 1983 · N4195L · 2 aircraft · Substantial damage > The two balloons collided in mid air. One (N4195L) suffered a rip in the envelope which negated its lift, with burner full on. It descended at 500 RPM and made a hard landing. The hole in the envelope extended across 5 gore panels. The 2 balloons departed the… - [NTSB ANC83IA056](https://openairdocs.org/ntsb/ANC83IA056.md): Cessna 172M · Wasilla, AK · Incident · No injuries · Incident investigation · Final report · Feb 28, 1983 · N786JH · Minor damage > Acft experienced failure of the left flap during climbout due to worn parts which were not observed on the preflight inspection. - [NTSB DEN83LA067](https://openairdocs.org/ntsb/DEN83LA067.md): Cessna 150M · Emerado, ND · Accident · No injuries · Limited investigation · Final report · Feb 27, 1983 · N704HP · Substantial damage > The acft made a forced landing due to weather which included icing and low ceilings. According to the plt. The acft would no longer hold level flt due to icing and after the acft broke out at 300-350 ft AGL he landed and the gear collapsed. The plt had… - [NTSB CHI83LA124](https://openairdocs.org/ntsb/CHI83LA124.md): Piper PA-32-260 · Madeira, OH · Accident · Minor injuries · Limited investigation · Final report · Feb 27, 1983 · N6809J · Destroyed > The acft crashed into trees during a forced landing after the engine stopped operating while approaching an arpt. The acft was on a cross country flt from dayton to cincinnati in VMC weather. The acft was inspected at the scene and the engine was removed and… - [NTSB MIA83LA083](https://openairdocs.org/ntsb/MIA83LA083.md): Cessna 210H · Near Labelle, FL · Accident · No injuries · Limited investigation · Final report · Feb 25, 1983 · N5980F · Destroyed > The acft collided with a tree during a forced landing and cartwheeled about 150 feet into a palmetto grove. The pilot stated that during the descent to Labelle the engine backfired, lost power and the windshield became covered with oil. The pilot elected to… - [NTSB CHI83LA121](https://openairdocs.org/ntsb/CHI83LA121.md): Cessna 172 · Galesburg, IL · Accident · No injuries · Limited investigation · Final report · Feb 25, 1983 · N738HH · Substantial damage > The plt stated that during cruise, the engine started to run rough. He applied carburetor heat & initiated emergency procedure, and then engine power was restored. However, a short time later, power was lost again. During a forced landing in an open field,… - [NTSB CHI83LA120](https://openairdocs.org/ntsb/CHI83LA120.md): Piper PA-32R-300 · Ely, MN · Accident · No injuries · Limited investigation · Final report · Feb 25, 1983 · N38855 · Substantial damage > About 2 min after takeoff, at about 1,000 ft AGL, the eng siezed. The plt then glided onto a frozen lake. The acft did not have a current annual inspection. The last oil change recorded was during the annual on 7/15/81. Engine teardown revealed severe… - [NTSB ATL83FA121](https://openairdocs.org/ntsb/ATL83FA121.md): Mooney M20F · Anniston, AL · Accident · Minor injuries · Field investigation · Final report · Feb 25, 1983 · N43NC · Destroyed > Just prior to departure, the fuel tanks were filled. The plt stated that he drained both tanks after refueling by using the strainer pull handle in the cockpit with the selector positioned to each tank. However, he did not drain the individual tank sumps.… - [NTSB LAX83FUM04](https://openairdocs.org/ntsb/LAX83FUM04.md): Cessna 180J · Descanso, CA · Accident · 1 fatal · Final report · Feb 24, 1983 · N3687C · Destroyed > The non-instrument rated plt was on a flt from farmington, NM to el cajon, CA, but made a stop at borrego springs, CA where a passenger deplaned. Before departing farmington, he obtainend a wx briefing for the trip, but only filed a flt plan for the 1st leg… - [NTSB ATL83LA119](https://openairdocs.org/ntsb/ATL83LA119.md): Cessna 210 · Folkston, GA · Accident · No injuries · Limited investigation · Final report · Feb 24, 1983 · N7379E · Substantial damage > Shortly after departure, the pilot observed fuel coming from the fuel tank vent and elected to make a precautionary landing. He touched down in the first 1/3 of runway 17 at a speed of about 80 mph. The pilot stated that the brakes failed during the roll-out… - [NTSB ATL83LA118](https://openairdocs.org/ntsb/ATL83LA118.md): Piper PA-34-200T · Ahoskie, NC · Accident · No injuries · Limited investigation · Final report · Feb 23, 1983 · N6075H · Substantial damage > The acft was struck by lightning while cruising at 9000 ft MSL. At that time, the plt observed a blue flash off the nose & heard a loud boom. All radios and navigational & electrical equipment became inop. The plt circled down thru a hole in the clouds &… - [NTSB ATL83LA115](https://openairdocs.org/ntsb/ATL83LA115.md): Piper PA-28-180 · Pulaski, VA · Accident · Minor injuries · Limited investigation · Final report · Feb 22, 1983 · N9264J · Substantial damage > The aircraft collided with trees during a forced landing after fuel exhaustion on the final leg of a cross-country. The pilot made 5 enroute stops and no refueling was performed at any point during those stops. Departing the last stop the pilot estimated 45… - [NTSB ATL83FA117](https://openairdocs.org/ntsb/ATL83FA117.md): Piper PA-24-180 · Hendersonville, NC · Accident · 3 fatal · Field investigation · Final report · Feb 22, 1983 · N6313P · Destroyed > After reporting level at 7,000 ft in rain, the plt reported that altitude could not be maintained due to a power loss. He stated that '...we're down to about fourteen inches and we just broke out and I got the lights.' At 1849, after a discussion with ATC… - [NTSB ATL83FA116](https://openairdocs.org/ntsb/ATL83FA116.md): Cessna 172P · Red Bank, TN · Accident · Serious injuries · Field investigation · Final report · Feb 22, 1983 · N54498 · Substantial damage > At aprx 2200 EST, the acft departed lansing, IL on a flt to columbus, GA. A passenger stated that a refueling stop had been planned for either bowling green or nashville. However, a stop was not made. The passenger indicated that the pilots were unsure of the… - [NTSB NYC83LA068](https://openairdocs.org/ntsb/NYC83LA068.md): Cessna 177 · Reading, PA · Accident · No injuries · Limited investigation · Final report · Feb 21, 1983 · N2227Y · Substantial damage > The flt departed belfast at 1100. After passing Reading the plt noticed the right tank gauge rise from 1/2 to full. Approximately 3 mi from Reading a 180 deg turn was made to return to Reading. About 1 mi from the arpt the eng surged. A call was made to the… - [NTSB MKC83FA069](https://openairdocs.org/ntsb/MKC83FA069.md): Cessna 150L · Ellsworth, KS · Accident · 1 fatal · Field investigation · Final report · Feb 21, 1983 · N18204 · Destroyed > The pilot departed red cloud, NE for a VFR, no-flight-plan flight to kingman, KS. Witnesses reported an aircraft flying in flight conditions that appeared to deteriorate from a weather stand standpoint in the direction of flight. One witness stated that he… - [NTSB MIA83LA079](https://openairdocs.org/ntsb/MIA83LA079.md): Hughes 500-369HS · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Feb 21, 1983 · N2254X · Substantial damage > The plt reported the flt experienced a total eng power loss & the acft was ditched in the intracoastal waterway. All examinations & tests conducted during the investigation revealed no evidence of a preimpact failure or malfunction of the airframe or eng. - [NTSB LAX83FA350](https://openairdocs.org/ntsb/LAX83FA350.md): Beech N35 · Mount Shasta, CA · Accident · 5 fatal · Field investigation · Final report · Feb 21, 1983 · N9350Y · Destroyed > The acft flew into mt reddy at about 9000 ft level. The clouds were as low as 5000 and the mountain tops were obscured. The plts in flt wx briefing contained the advice that VFR flt along his route was not recommended because the mt tops were obscured in… - [NTSB MIA83LA080](https://openairdocs.org/ntsb/MIA83LA080.md): Cessna C-152 · Yeehaw Junction, FL · Accident · No injuries · Limited investigation · Final report · Feb 19, 1983 · N49132 · Substantial damage > According to the student pilot the aircraft was fueled to maximum capacity prior to departure on a cross country flight. Approximately 3.2 hours later the engine quit and the pilot was forced to make an emergency landing in a wooded area. Subsequent engine… - [NTSB MIA83FLD01](https://openairdocs.org/ntsb/MIA83FLD01.md): Pitts Special S-1C · St. Petersburg, FL · Accident · Serious injuries · Final report · Feb 19, 1983 · N507LS · Substantial damage > This was the plt's 2nd flt in his home built acft. During his preflight, he checked the sight gauge for fuel, but did not visually check the fuel tank. The gauge indicated that there was about 17 gal of fuel remaining. During flight, the engine lost power and… - [NTSB LAX83LA110](https://openairdocs.org/ntsb/LAX83LA110.md): Cessna 172G · Antioch, CA · Accident · No injuries · Limited investigation · Final report · Feb 19, 1983 · N4611L · Substantial damage > According to the left seat pilot the engine sputtered at 2200 RPM and quit. There were wires obstructing the field selected for landing. The acft went under most of them but clipped one service electric line. The acft landed & rolled about 75 feet before… - [NTSB ATL83LA113](https://openairdocs.org/ntsb/ATL83LA113.md): Piper PA-22-150 · Stafford, VA · Accident · Minor injuries · Limited investigation · Final report · Feb 19, 1983 · N3750P · Substantial damage > The acft collided with a ditch during a forced landing. The plt was cruising at 3000 ft MSL when he heard a 'loud pop'. The engine started running rough and missing. The plt shut the engine down by pulling the mixture control and throttle. When he shut down… - [NTSB ATL83LA110](https://openairdocs.org/ntsb/ATL83LA110.md): Cessna 150 · Columbus, MS · Accident · No injuries · Limited investigation · Final report · Feb 19, 1983 · N1327Q · Substantial damage > The acft collided with a tree during a forced landing. The acft was descending returning from a fire patrol when the engine quit. The right fuel gauge was on empty and the left tank showed 1/4 of a tank. Attempts to restart the engine were unsuccessful and… - [NTSB MIA83LA077](https://openairdocs.org/ntsb/MIA83LA077.md): Cessna C-182P · Bahia Honda, FL · Accident · No injuries · Limited investigation · Final report · Feb 18, 1983 · N9912M · Substantial damage > The acrft was ditched in the bay of Florida after the engine failed at 1000 ft MSL. The pilot and passenger swam to shore without injury. Examination revealed that the #1 cyl exhaust valve rocker shaft housing failed. Lab exam of the housing showed high cycle… - [NTSB LAX83LA105](https://openairdocs.org/ntsb/LAX83LA105.md): Cessna 170 · Pleasonton, CA · Accident · No injuries · Limited investigation · Final report · Feb 18, 1983 · N2565V · Substantial damage > The acft collided with a street curb during an off airport forced landing. The pilot stated that during climb-out at 3000 feet the engine RPM began to decrease. He used carburetor heat as the engine lost power to 1000 RPM. He also switched tanks from both to… - [NTSB DEN83FA062](https://openairdocs.org/ntsb/DEN83FA062.md): Piper PA-23F-250 · Moab, UT · Accident · 2 fatal · Field investigation · Final report · Feb 16, 1983 · N63808 · Destroyed > The acft crashed into the top of a mesa at the 5500 ft level (MSL). The acft then cartwheeled about 300 ft on a heading of 360 degrees. Sheriffs deputies discovered at the accident site that the acft was loaded with marijuana weighing ABOUT798 lbs. An… - [NTSB ATL83LA104](https://openairdocs.org/ntsb/ATL83LA104.md): Piper PA-34-220T · Pickens, SC · Accident · No injuries · Limited investigation · Final report · Feb 16, 1983 · N8472E · Substantial damage > The acft collided with two birds while cruising at 6000 ft MSL. The weather was VFR but the acft was on IFR flt plan. The acfts left wing was damaged but there were no injuries. The plt stated that although he heard a thud on the left side of the acft he was… - [NTSB DEN83FA059](https://openairdocs.org/ntsb/DEN83FA059.md): Cessna 340A · Aspen, CO · Accident · 4 fatal · Field investigation · Final report · Feb 15, 1983 · N33340 · Destroyed > Prior to departure the flt was given an IFR clearance which began at herls intersection (16 mi nne) & to cross herls at or above 16,000 ft MSL. Departure arpt field elev is 7,793 ft. flts are required to proceed VFR to the initial fix of the IFR clearance.… - [NTSB ATL83LA103](https://openairdocs.org/ntsb/ATL83LA103.md): Hughes 369HS · Paducah, KY · Accident · No injuries · Limited investigation · Final report · Feb 15, 1983 · N3280K · Substantial damage > The acft was damaged during an autorotation into an open field after a chip detector light illuminated. The chip light is used for detecting metal in the transmission, engine and tail rotor gear box. Examination of the transmission revealed metal particles on… - [NTSB LAX83FA099](https://openairdocs.org/ntsb/LAX83FA099.md): Cessna 150J · Nogales, AZ · Accident · No injuries · Field investigation · Final report · Feb 13, 1983 · N50586 · Substantial damage > The acft nosed over during a forced landing after the engine failed during an instruction flt. The landing was accomplished off arpt about 30 minutes after initial takeoff. The engine had begun to run rough followed by a loss of oil pressure. Then the engine… - [NTSB CHI83LA113](https://openairdocs.org/ntsb/CHI83LA113.md): Piper PA-28R · Jackson, MI · Accident · No injuries · Limited investigation · Final report · Feb 13, 1983 · N47875 · Substantial damage > Complete electrical failure occurred at 8,000 ft. the plt diverted to Jackson & the acft landed wheels-up. The plt laterstated that he thought he was familiar with the emergency gear extension procedures in the flt manual but that he might not have put the… - [NTSB SEA83LA055](https://openairdocs.org/ntsb/SEA83LA055.md): Cessna 152 · Near Kent, WA · Accident · No injuries · Limited investigation · Final report · Feb 12, 1983 · N25320 · Substantial damage > The instructor and student encountered extreme turbulence during a climb to 2000 feet so the took the controls and the retarded power to lower speed and lose altitude. Descent was made from 1800 feet to 1300 feet before the throttle was advanced and when it… - [NTSB FTW83LA112](https://openairdocs.org/ntsb/FTW83LA112.md): Pratt-Read PRG-1 · Littlefield, TX · Accident · No injuries · Limited investigation · Final report · Feb 12, 1983 · N14Y · Substantial damage > The glider was being operated by a boy scout explorer post. The 15 year-old scout was one of the first boys to solo the 40 year-old glider. While returning from a 50 min soaring flt, the glider spun to the ground after entering a strong thermal. According to… - [NTSB CHI83LA111](https://openairdocs.org/ntsb/CHI83LA111.md): Cessna 150 · Worthington, MN · Accident · No injuries · Limited investigation · Final report · Feb 12, 1983 · N50567 · Substantial damage > The plt reported that he was able to maintain visual ground contact after he left blue earth, MN. However, as he was following an interstate highway near Worthington, MN, the visibility decreased. He attempted to get to the arpt at Worthington, but saw a… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=373 ## 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=372 --- 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.