# 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 367 of 718 · 35,889 cases ## Cases, newest first - [NTSB CHI83LA294](https://openairdocs.org/ntsb/CHI83LA294.md): Cessna 172 · Sauk Centre, MN · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N5010A · Substantial damage > The acft nosed over during a precautionary landing because of weather. During the landing roll the nose gear struck a rut and the acft nosed over. The weather was IMC. The pilot did recieve a weather briefing and the weather information was accurate. The… - [NTSB ANC83LA116](https://openairdocs.org/ntsb/ANC83LA116.md): Piper PA-12 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N2368M · Substantial damage > The acft was damaged while making a forced landing after the engine stopped. The pilot said he was at 1200 feet near point mackenzie when the engine started running rough. The engine stopped operating a few seconds later. The pilot said he had trouble… - [NTSB MIA83FA175](https://openairdocs.org/ntsb/MIA83FA175.md): Long EZE · Near Captiva, FL · Accident · 2 fatal · Field investigation · Final report · Jul 3, 1983 · N812EZ · Destroyed > A witness observed the aircraft flying in a northerly direction about 1/2 mile away at an altitude of about 100 feet. It appeared to be travelling in excess of 80 KTS and the engine sounded normal. Another witness observed the aircraft strike the water in a… - [NTSB LAX83LA317](https://openairdocs.org/ntsb/LAX83LA317.md): Cessna 152 · Sunnyvale, CA · Accident · No injuries · Limited investigation · Final report · Jul 3, 1983 · N6301M · Substantial damage > The plt was cruising at about 3000 ft when the eng lost power. An emergency landing was made on a football field, but the acft was damaged. Only about 1 cup of fuel was found in the fuel tanks & no fuel was found in the fuel lines. The gascolator was broken,… - [NTSB FTW83FA311](https://openairdocs.org/ntsb/FTW83FA311.md): Bell 47G-2 · Bethany, OK · Accident · Minor injuries · Field investigation · Final report · Jul 3, 1983 · N2495B · Destroyed > The helicopter collided with trees and rolled over during a forced landing after engine failure. The plt had been takingpassengers up for sight-seeing for several hours. After the last flt he and his wife had departed the city park to fly back to the acft… - [NTSB MKC83LA142](https://openairdocs.org/ntsb/MKC83LA142.md): Piper PA-25-235 · Corning, IA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N4838Y · Substantial damage > The acft crashed in a swamp during a forced landing after the engine seized. The pilot noted a lack of oil pressure and rising oil temperature. He dumped his load and began to return to land. The engine began to run rough and soon seized. Post accident… - [NTSB LAX83LA319](https://openairdocs.org/ntsb/LAX83LA319.md): Cessna 177B · Grand Canyon, AZ · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N20391 · Substantial damage > The acft collided with trees during a forced landing after the engine quit. The pilot stated that while cruising at 9500FT the engine lost power. He declared an emergency and was cleared to land on any rwy at Grand Canyon arpt. He was unable to reach the arpt… - [NTSB LAX83FUG18](https://openairdocs.org/ntsb/LAX83FUG18.md): Miller RA1 · Adelanto, CA · Accident · 1 fatal · Final report · Jul 2, 1983 · N37849 · Destroyed > Witnesses observed that shortly after takeoff the gyrocopter porpoised. The main rotor blades separated in flight and the acft crashed. - [NTSB ATL83LA253](https://openairdocs.org/ntsb/ATL83LA253.md): Homebuilt EAA Biplane · Petersburg, VA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N3140B · Substantial damage > The plt took off, circled the field, then started to depart at aprx 1000 ft. a short time later, the eng lost power & could not be restarted. The plt elected to land on a road. While on a short final to land, the acft collided with a power line. Reportedly,… - [NTSB ATL83FU003](https://openairdocs.org/ntsb/ATL83FU003.md): Airmass Sunburst Model B · Ernul, NC · Accident · 1 fatal · Final report · Jul 2, 1983 · UNREG · Destroyed > The plt was en route from ayden, NC, where he purchased the ultralight, to his home in havelock, NC. While en route, he had landed at Ernul, NC to refuel. After refueling, he took off, circled back over the field, then added power & began to climb. At about… - [NTSB NYC83LA161](https://openairdocs.org/ntsb/NYC83LA161.md): Cessna 172P · Redding, CT · Accident · No injuries · Limited investigation · Final report · Jul 1, 1983 · N62511 · Substantial damage > The flight originated at ramapo, NY. During a preflight check, the plt noted that the fuel gauges indicated full. When he visually checked the fuel tanks, he estimated that the fuel level in each tank was about 1 inch from being full. The fuel capacity of… - [NTSB LAX83LA313](https://openairdocs.org/ntsb/LAX83LA313.md): Smith, Ted Aerostar Aerostar 601B · Elko, NV · Accident · No injuries · Limited investigation · Final report · Jul 1, 1983 · N601MM · Substantial damage > Enroute at 14,000 ft MSL the plt observed the right eng oil press gage decrease to zero. The plt shut down the right eng& received radar vectors to Elko muni arpt. At 6,000 ft the plt attempted to level-off the acft but the acft would not maintain altitude.… - [NTSB LAX83FA314](https://openairdocs.org/ntsb/LAX83FA314.md): Grumman American AA-5A · Livermore, CA · Accident · Serious injuries · Field investigation · Final report · Jul 1, 1983 · N9945U · Destroyed > The acft collided with rising terrain during a cross-country in IMC weather. No flt plan was filed for the flt. No weather briefing was obtained by the pilot before takeoff. The distance to be flown was 72 miles and the pilot flew this route about 3 times a… - [NTSB FTW83LA318](https://openairdocs.org/ntsb/FTW83LA318.md): Cessna 152 · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Jul 1, 1983 · N6386Q · Substantial damage > During flt, the eng began to lose power & the plt was unable to maintain altitude. He tried various things to restore power which included changing positions of the magneto switch. Subsequently, the acft was ditched in a lake. The magneto switch was found… - [NTSB ATL83LA246](https://openairdocs.org/ntsb/ATL83LA246.md): Hughes 269A · Gastonia, NC · Accident · No injuries · Limited investigation · Final report · Jun 30, 1983 · N8835F · Substantial damage > While en route at 500 ft AGL, the eng suddenly lost power & went to idle RPM. During an autorotation to the side of a highway, the acft was maneuvered over a power line, then under another line. After touchdown, the helicopter slid into some bushes & a small… - [NTSB ATL83FA247](https://openairdocs.org/ntsb/ATL83FA247.md): Beech G18S · Keyser, WV · Accident · 1 fatal · Field investigation · Final report · Jun 30, 1983 · N215W · Destroyed > The manager of blackhawk airways had cleared the flt for a 1000 EDT departure, but the actual takeoff time was not established. No record of a preflt wx briefing was found. However, during a telephone conversation prior to the flt, the plt indicated to his… - [NTSB SEA83FA135](https://openairdocs.org/ntsb/SEA83FA135.md): Enstrom 280C · Kent, WA · Accident · Minor injuries · Field investigation · Final report · Jun 28, 1983 · N652H · Substantial damage > During a traffic reporting flt for a radio station, the plt noted the onset of a severe vibration which he felt through the antitorque pedals. He stated that within seconds, the helicopter lost directional control & began a rapid, uncontrolled spin to the… - [NTSB NYC83FA160](https://openairdocs.org/ntsb/NYC83FA160.md): Cessna 172N · Jaffrey, NH · Accident · 1 fatal · Field investigation · Final report · Jun 28, 1983 · N738SF · Destroyed > At 0555 EDT, the non-instrument rated plt obtained a wx briefing for a flt from limington, me to pawling, NY. At that time, he stated he was unsure when he would depart, the decision depended on the wx. The briefer advised that at that time, VFR flt was not… - [NTSB MKC83FA136](https://openairdocs.org/ntsb/MKC83FA136.md): Cessna 152 · Neligh, NE · Accident · 2 fatal · Field investigation · Final report · Jun 28, 1983 · N46832 · Destroyed > At aprx 1920 CDT, the plt entered the NWS station at norfolk, NE & request a wx briefing for a flt from bloomfield, NE back to norfolk, to arrive before sunset. He was advised of marginal wx conditions due to thunderstorm activity. The forecast called for… - [NTSB SEA83FYM07](https://openairdocs.org/ntsb/SEA83FYM07.md): Maule M-5-235C · Silverton, OR · Accident · Serious injuries · Final report · Jun 27, 1983 · N6205M · Substantial damage > The acft landing gear collapsed during a forced landing after an engine failure. The acft had climbed to 1000 ft AGL after takeoff when the pilot switched the fuel selector to the right fuel tank. Immediately the engine quit and switching back to the left… - [NTSB MKC83LA137](https://openairdocs.org/ntsb/MKC83LA137.md): Cessna T188C · Marshall, MO · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1983 · N9639J · Destroyed > The eng failed while enroute to spray. The acft was observed to jettison its load prior to impacting trees in a wooded pasture. Metallurgical examination revealed that the crankshaft, P/N631716, had fractured from fatigue progression through the forward cheek… - [NTSB MIA83LA167](https://openairdocs.org/ntsb/MIA83LA167.md): Lake LA-4 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Jun 27, 1983 · N2019L · Substantial damage > The acft collided with a tree and landed gear up on floats after an engine failure. The pilot was cruising at 1000 ft MSL when the oil pressure dropped to zero and the engine seized. The acft collided with the tops of pine trees while approaching a nearby… - [NTSB FTW83LA297](https://openairdocs.org/ntsb/FTW83LA297.md): Bell 206L-1 · Lafayette, LA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1983 · N3904L · Substantial damage > The helicopter made a hard precautionary landing after the plt noted the rotor RPM and N2 would bleed off when collective pitch was increased to 80 percent torque. The plt returned to the arpt and elected to autorotate instead of landing with power available.… - [NTSB FTW83LA294](https://openairdocs.org/ntsb/FTW83LA294.md): Ryan NAVION-A · Kenedy, TX · Accident · No injuries · Limited investigation · Final report · Jun 27, 1983 · N5040K · Substantial damage > After taking off, the eng began to lose power. The plt said it quit & restarted several times while he was trying to return to the arpt. During an emergency landing, about 3 mi from the arpt, the plt elected to land with the gear retracted since there were… - [NTSB LAX83LA347](https://openairdocs.org/ntsb/LAX83LA347.md): Schweizer SGS 1-26B · Phelan, CA · Accident · No injuries · Limited investigation · Final report · Jun 26, 1983 · N5743S · Substantial damage > While on a local flt, thermal activity decreased, so the glider plt headed back to the arpt. On the way back, he encounted an area of sinking air & lost 1500 to 2000 ft of alt. He elected to land on a road. During the roll-out, the left wing hit a dirt… - [NTSB FTW83LA296](https://openairdocs.org/ntsb/FTW83LA296.md): Cessna 182B · Lufkin, TX · Accident · No injuries · Limited investigation · Final report · Jun 26, 1983 · N2550G · Substantial damage > While en route, the eng began surging. All instruments had normal indications, except the manifold pressure & tachometer were varying as the eng surged. The acft began losing alt, so the plt elected to land on a highway. He landed in front of several cars,… - [NTSB ATL83LA244](https://openairdocs.org/ntsb/ATL83LA244.md): Piper PA-28R-200 · Russell, KY · Accident · No injuries · Limited investigation · Final report · Jun 26, 1983 · N6982J · Substantial damage > Aprx 3 hrs & 19 min after takeoff, the plt made a radio transmission, stating that he had run out of fuel. Reportedly, he had taken off with 43 gal of fuel on board. During an emergency landing, the acft was substantially damaged. After landing, the plt… - [NTSB SEA83LA145](https://openairdocs.org/ntsb/SEA83LA145.md): Piper PA-18-125 · Fort Hall, ID · Accident · No injuries · Limited investigation · Final report · Jun 25, 1983 · N1144A · Substantial damage > The acft nosed over during a forced landing after a power loss. The pilot stated that during a descent to an arpt the engine suddenly lost power. Emergency start procedures failed and a forced landing was made in a grain field. During roll out the acft nosed… - [NTSB LAX83LA309](https://openairdocs.org/ntsb/LAX83LA309.md): Smith-Poston BI-PLANE · Banning, CA · Accident · No injuries · Limited investigation · Final report · Jun 25, 1983 · N1860 · Substantial damage > The acft collided with a ditch during a forced landing after the engine quit. The plt said he ran out of gas. He said the fuel gauges were inoperative but he was told the acft would operate 2 and 1/2 hours on a tank of fuel. The acft engine stopped after 1… - [NTSB LAX83LA304](https://openairdocs.org/ntsb/LAX83LA304.md): Rutan LONG-EZ-B · Corning, CA · Accident · No injuries · Limited investigation · Final report · Jun 25, 1983 · N1695H · Substantial damage > The plt & passenger were participating in the cafe 400 efficiency race. Shortly after passing a check point, a portion of 1 propeller blade separated & the plt shut down the eng. He elected to land on an interstate highway by merging into traffic. However, he… - [NTSB FTW83LA292](https://openairdocs.org/ntsb/FTW83LA292.md): Cessna T188C · Eudora, AR · Accident · No injuries · Limited investigation · Final report · Jun 25, 1983 · N9934J · Destroyed > During the return trip to the arpt, the eng lost power & the plt landed in an open field with soft terrain. Shortly after touchdown, the right main gear dug into the soft soil & collapsed. A fire started after the acft came to rest & it was destroyed. The… - [NTSB ANC83FA103](https://openairdocs.org/ntsb/ANC83FA103.md): Douglas DC-3 · Fort Yukon, AK · Accident · No injuries · Field investigation · Final report · Jun 25, 1983 · N95460 · Substantial damage > The acft had an in-flt fire in the accessory section of the lt eng. According to the passenger there was a long delay between outbreak of fire and corrective action by the crew. The passengers also commented on the lack of communication from the cockpit to… - [NTSB ANC83LA104](https://openairdocs.org/ntsb/ANC83LA104.md): Piper PA-18 · Palmer, AK · Accident · No injuries · Limited investigation · Final report · Jun 24, 1983 · N2568J · Substantial damage > The acft had been on a sight seeing flt when the engine began to lose power and run rough. The pilot decided to make a precautionary landing on the glacier. He was attempting to takeoff without pax and excess fuel due to slushy ice. The engine was developing… - [NTSB SEA83LA132](https://openairdocs.org/ntsb/SEA83LA132.md): Hiller UH-12B · Jerome, ID · Accident · No injuries · Limited investigation · Final report · Jun 23, 1983 · N245C · Substantial damage > The acft was destroyed by fire after a forced landing due to pwr loss. The pilot stated that he was en route home after an aerial application mission when the engine lost power. He made an auto-rotation downwind and after exiting the acft noticed an engine… - [NTSB LAX83LA296](https://openairdocs.org/ntsb/LAX83LA296.md): Hiller UH12E · San Diego, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 1983 · N4036A · Substantial damage > The helicopter rolled over during an autorotative forced landing after a power loss. Prior to departure on the day of the accident the plt said he checked the fuel quantity on the acft. Takeoff was at about 1222 PDT. At 1256 PDT the plt arrived at destination… - [NTSB ATL83AA235](https://openairdocs.org/ntsb/ATL83AA235.md): Cessna 421A · Atmore, AL · Accident · 8 fatal · Final report · Jun 22, 1983 · N2960Q · Destroyed > About 20 mins after takeoff the plt reported the right eng had lost power & the acft would not maintain alt. Vectors were provided for an emergency landing, but the acft crashed in a wooded area about 3 mi from the arpt. There was evidence that the gear &… - [NTSB FTW83LA291](https://openairdocs.org/ntsb/FTW83LA291.md): Piper PA-28R-200 · Leggett, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1983 · N44294 · Substantial damage > The acft was damaged in a forced landing after the engine failed while cruising at 2500 ft. the acft was landed in an open field. Post accident investigation disclosed a missing oil drain plug. 2 pistons failed from lack of oil. The acft had a 100 hour… - [NTSB SEA83LA130](https://openairdocs.org/ntsb/SEA83LA130.md): Cessna 337B · Dayton, OR · Accident · Serious injuries · Limited investigation · Final report · Jun 20, 1983 · N5479S · Substantial damage > The pilot stated he was demonstrating a 'steep letdown' to his passenger from about 3200 MSL. The descent was with full flaps, landing gear extended and power off on both engines. At about 1200 MSL the pilot leveled off and added power and had none on the… - [NTSB SEA83FA131](https://openairdocs.org/ntsb/SEA83FA131.md): Piper PA-32-300 · Glacier Peak, WA · Accident · 5 fatal · Field investigation · Final report · Jun 19, 1983 · N4013R · Destroyed > The acft collided with a side of Glacier Peak at about 10000 ft MSL while in level flt. The exact weather conditions at the accident site at the time of the accident are unknown but several mountain climbers at 6000 ft about 2 miles away atabout the same time… - [NTSB MKC83LA131](https://openairdocs.org/ntsb/MKC83LA131.md): Boeing A75N1 · Benkelman, NE · Accident · Minor injuries · Limited investigation · Final report · Jun 19, 1983 · N54582 · Substantial damage > The plt stated he was flying at a low altitude along a river when the eng failed. - [NTSB MIA83LA163](https://openairdocs.org/ntsb/MIA83LA163.md): Beech BE-35 · Miami Beach, FL · Accident · No injuries · Limited investigation · Final report · Jun 18, 1983 · N3364V · Destroyed > The pilot stated that while cruising with another aircraft at an unknown altitude the oil pressure began to decrease. Shortly after this, the engine failed. The oil temp, cylinder temp, and exhaust gas temp remained in the normal range the engine stopped… - [NTSB ANC83LA099](https://openairdocs.org/ntsb/ANC83LA099.md): Cessna 185 · (N) Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Jun 18, 1983 · N3991Q · Substantial damage > The acft was ground looped intentionally to prevent a collision with people or boats. The pilot said he had no braking action during landing. He believes someone loosened the plugs in the bottom of both brake cylinders and these plugs dropped out in flight.… - [NTSB FTW83LA287](https://openairdocs.org/ntsb/FTW83LA287.md): Enstrom 280C · Frisco, TX · Accident · No injuries · Limited investigation · Final report · Jun 17, 1983 · N51738 · Substantial damage > The plt reported that during flt, the low pressure fuel light illuminated & the nose of the helicopter yawed to the left as if the eng had lost power. He made a precautionary landing in a soft, plowed field with a forward speed of about 10 to 15 mph. During… - [NTSB DEN83LA151](https://openairdocs.org/ntsb/DEN83LA151.md): Cessna 172 · Ellicott, CO · Accident · No injuries · Limited investigation · Final report · Jun 17, 1983 · N75958 · Substantial damage > The acft collided with a fence during a forced landing after the engine quit. The plt was descending from airwork at 10800 ft MSL to return to the arpt. The engine was reduced to idle and the carburetor heat was on but the engine would not respond when the… - [NTSB SEA83LA128](https://openairdocs.org/ntsb/SEA83LA128.md): Cessna 152 · Cascade Locks, OR · Accident · No injuries · Limited investigation · Final report · Jun 16, 1983 · N757WT · Substantial damage > The acft collided with a guard rail after making a forced landing on a highway during a student solo cross-country flight. The flight had originated at vancouver WA, and the student pilot had been instructed to refuel at pendleton, OR.a landing was made at… - [NTSB SEA83LA126](https://openairdocs.org/ntsb/SEA83LA126.md): Cessna 182H · Petersburg, AK · Accident · No injuries · Limited investigation · Final report · Jun 16, 1983 · N1820X · Destroyed > The student plt was on a night flt from whitehorse to prince rupert, Canada via skagway & juneau, AK. According to him, when passing the five fingers NDB to enter the strait, he encountered southeast winds of aprx 25 KTS. On attempting to return to juneau, he… - [NTSB NYC83FA144](https://openairdocs.org/ntsb/NYC83FA144.md): Beech 76 · Moultonboro, NH · Accident · 1 fatal · Field investigation · Final report · Jun 16, 1983 · N794Y · Destroyed > After making an instrument acph to laconia, NH, the plt landed, phoned his wife & advised her of his intention to fly to Moultonboro, NH. After taking off, he advised Moultonboro UNICOM that he had departed laconia & was over a nearby lake, but was having a… - [NTSB DEN83LA143](https://openairdocs.org/ntsb/DEN83LA143.md): Cessna U206 · Billings, MT · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1983 · N2187F · Substantial damage > The acft nosed over during a forced landing after the engine quit during descent for approach to land. The pilot stated that very shortly after the beginning of descent to land the engine quit at 5000 ft while he was accomplishing the checklist. The plt said… - [NTSB DEN83LA142](https://openairdocs.org/ntsb/DEN83LA142.md): Cessna 182Q · Hysham, MT · Accident · No injuries · Limited investigation · Final report · Jun 16, 1983 · N7506S · Substantial damage > The plt reported that he aborted his x-country flt due to IMC ahead. While returning to billings, MT, oil & smoke started coming from the eng compartment & oil covered his windshield. The eng began losing power, so he shut it down. While making an emergency… - [NTSB CHI83IA263](https://openairdocs.org/ntsb/CHI83IA263.md): Boeing 737-201 · Charlotte, NC · Incident · No injuries · Incident investigation · Final report · Jun 16, 1983 · N782N · Minor damage > During climb to cruise the acft encountered unforcast hail. The flight continued to destination and landed without further incident. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=368 ## 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=367 --- 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.