# 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 376 of 718 · 35,889 cases ## Cases, newest first - [NTSB FTW83FPG02](https://openairdocs.org/ntsb/FTW83FPG02.md): Cessna R172K · Near Paris, AR · Accident · 2 fatal · Final report · Nov 12, 1982 · N736QD · Destroyed > The plt & pax were on a flt from amarillo, TX to little rock, AR. An enroute stop was made at haskell, ok at appr 1900 to refuel. The owner of the afpt at haskell stated that the plane arrived in a fairly heavy rainstorm. At that time, a winter type cold… - [NTSB ATL83AA029](https://openairdocs.org/ntsb/ATL83AA029.md): Piper PA-31-350 · Brevard, NC · Accident · 1 fatal · Final report · Nov 12, 1982 · N59771 · Destroyed > After a missed approach at asheville the flt was cleared to the greenville-spartanburg arpt at greer,SC. Enroute to greer radar contact was lost. In response to a query from atlanta ARTCC the plt verified his position as being on the 235 deg radial of… - [NTSB MIA83FA027](https://openairdocs.org/ntsb/MIA83FA027.md): Boeing 707-300 · Miami, FL · Accident · 1 fatal · Field investigation · Final report · Nov 11, 1982 · N707GB · No damage > During climbout from Miami, a cabin pressurization problem was encountered. All crew members donned their oxygen masks & the cabin altitude stabilized at 20,000 ft as the acft was leveled at 33,000 ft. about 40 minutes from destination the flight engineer… - [NTSB LAX83FA033](https://openairdocs.org/ntsb/LAX83FA033.md): Piper PA-28R-201T · Coaling, CA · Accident · No injuries · Field investigation · Final report · Nov 11, 1982 · N3035M · Destroyed > The pilot reported that during flight, the engine started missing, then lost 10 inches of manifold pressure. He immediately positioned the mixture to full rich, switched fuel tanks and started the fuel boost pump, but the engine continued to worsen. Shortly… - [NTSB FTW83FPM04](https://openairdocs.org/ntsb/FTW83FPM04.md): Piper PA23-250 · 8 Miles Se Bris, OK · Accident · 2 fatal · Final report · Nov 11, 1982 · N6145Y · Destroyed > The acft departed at 2220 with a planned enroute stop at holdenville, OK. 55 minutes later the acft crashed approximately 8.5 miles from its original departure point. Witnesses describe the wx as very bad due to heavy rain & fog. - [NTSB ATL83IA028](https://openairdocs.org/ntsb/ATL83IA028.md): Convair 340 · Greenboro, NC · Incident · No injuries · Incident investigation · Final report · Nov 11, 1982 · N4814C · Minor damage > The pilot stated that while at cruise at 4000 feet that there was a sharp jolt in the airframe and on further investigation discovered that the left engine was on fire. The propeller stopped turning shortly thereafter. Immediately the pilot pulled the… - [NTSB SEA83FYK01](https://openairdocs.org/ntsb/SEA83FYK01.md): Piper PA-32-300 · 27ne Rogue Rive, OR · Accident · Serious injuries · Final report · Nov 10, 1982 · N656ZM · Destroyed > At 9,500 ft the eng failed. The acft impacted a large tree while maneuvering to land on a rural road in heavily forested mountains. Eng examination revealed that the top of the case had a large hole on the rear portion. Pushrod housings were missing from #5 &… - [NTSB MKC83LA018](https://openairdocs.org/ntsb/MKC83LA018.md): Air Tractor AT-301A · Anthony, KS · Accident · No injuries · Limited investigation · Final report · Nov 10, 1982 · N23539 · Substantial damage > While returning from a spraying operation the aircraft ran out of fuel and the pilot made an emergency landing. In a field. The pilot stated that after rolling for about 300 feet during the landing, he observed a terrace ahead and applied heavy braking. The… - [NTSB FTW83LA035](https://openairdocs.org/ntsb/FTW83LA035.md): Cessna T210L · Midland, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 9, 1982 · N1767X · Substantial damage > The pilot advised Midland approach control that he was out of fuel over the west side of Midland, TX at 4800 feet. The aircraft was observed to disappear from the radar approximately 1/4 to 1/2 mile north of the airport. The pilot stated he ran the tanks dry. - [NTSB FTW83LA034](https://openairdocs.org/ntsb/FTW83LA034.md): Piper PA-24-260 · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Nov 9, 1982 · N8705P · Substantial damage > While on a business cross country flight the fuel pressure began dropping with a subsequent drop in power. The pilot attempted to reduce manifold pressure to keep the engine running. Approximately 3-5 miles from El Paso airport the pilot landed on the desert.… - [NTSB SEA83LA017](https://openairdocs.org/ntsb/SEA83LA017.md): Froehlich M-II · Everett, WA · Accident · No injuries · Limited investigation · Final report · Nov 8, 1982 · N33RF · Destroyed > Pilot acting as safety pilot for a friend in formation under the hood in another aircraft. He noticed his fuel was low, called his friend and headed for home. When his engine quit 2 miles from paine field he ditched. The aircraft sank and was not recovered. - [NTSB SEA83FAD01](https://openairdocs.org/ntsb/SEA83FAD01.md): Aerospatiale S350D · Starfish, AK · Accident · 2 fatal · Final report · Nov 8, 1982 · N3597Q · Substantial damage > When the flt arrived at anita bay there were areas of ground fog moving in & out over the logging camp landing sight. The helicopter was observed to fly over the camp & back out across the bay. Shortly after the helicopter was out of sight a noise sounding… - [NTSB MIA83LA026](https://openairdocs.org/ntsb/MIA83LA026.md): Piper J-3 · Near Melbourne, FL · Accident · No injuries · Limited investigation · Final report · Nov 8, 1982 · N6875H · Substantial damage > Pilot made forced landing off airport due to power loss. Landing gear collapsed. No malfunctions found. - [NTSB DEN83FA133](https://openairdocs.org/ntsb/DEN83FA133.md): Cessna 182A · Orderville, UT · Accident · 1 fatal · Field investigation · Final report · Nov 8, 1982 · N5149D · Destroyed > The acft crashed in mountainous terrain on a x-country in bad weather. The plt had received a weather briefing which hadincluded the caution that VFR flt was not recommended. Also the acft had no radio so the plt told the briefer to assume him off at 1330… - [NTSB ATL83LA027](https://openairdocs.org/ntsb/ATL83LA027.md): Cessna 172H · Birmingham, AL · Accident · Serious injuries · Limited investigation · Final report · Nov 8, 1982 · N2633L · Substantial damage > Pilot made a hard off airport landing after loss of power. He had used a prolonged slip to lose altitude and the engine stopped. Then he could not reach the runway. The fuel selector was found on left tank. Left tank had less than two gallons of fuel. - [NTSB MKC83LA014](https://openairdocs.org/ntsb/MKC83LA014.md): Beech C23 · Des Moines, IA · Accident · No injuries · Limited investigation · Final report · Nov 7, 1982 · N6012J · Substantial damage > The pilot executed a forced landing after the engine stopped. The pilot successfully landed the aircraft on a highway, the left wing struck a pole and the aircraft came to rest in a ditch. - [NTSB LAX83DA031](https://openairdocs.org/ntsb/LAX83DA031.md): Cessna 152 · Marana, AZ · Accident · No injuries · Final report · Nov 7, 1982 · N69199 · Substantial damage > During cruise the aircraft ran out of fuel prior to reaching the pilot's intended point of landing. The pilot attempted a forced landing in the desert. Records indicated the aircraft had flown about 5.3 hours since it was last refueled. - [NTSB DEN83LA014](https://openairdocs.org/ntsb/DEN83LA014.md): Grumman AA1 · Bicknell, UT · Accident · Minor injuries · Limited investigation · Final report · Nov 7, 1982 · N555AW · Destroyed > The pilot stated that shortly after departing the Bicknell airport, a strong downdraft forced the aircraft into the ground while approaching the lee side of a ridge line. He indicated the aircraft was at about 100 mph indicated airspeed when ground contact… - [NTSB ATL83FA025](https://openairdocs.org/ntsb/ATL83FA025.md): Gates Learjet 25 · Elizabeth City, NC · Accident · No injuries · Field investigation · Final report · Nov 6, 1982 · N47MJ · 2 aircraft · Minor damage > After the two acft were established at 14,000 ft during a target towing operation, N13MJ(lead acft) maintained straight & level flt on autopilot while N47MJ(chase) came up along the left side to observe the target on the left wing. While moving forward &… - [NTSB MIA83LA024](https://openairdocs.org/ntsb/MIA83LA024.md): Cessna 210 · Near Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 5, 1982 · N6545X · Substantial damage > About 15 minutes after takeoff the aircraft engine quit. All attempts to restart the engine were unsuccessful and the pilot landed in the everglades swamp. Examination of the aircraft revealed that the fuel manifold valve, PN-631427-A15 was stuck in the… - [NTSB MIA83FA022](https://openairdocs.org/ntsb/MIA83FA022.md): Cessna 172P · Near Myakka Cit, FL · Accident · 6 fatal · Field investigation · Final report · Nov 5, 1982 · N63836 · Destroyed > The plt was wx briefed four times prior to departure & again one minute after takeoff at 1821 when he activated his flt plan. He was advised that a cold front was moving se along st. petersburg & tampa, & the area was IMC at the time. At 1916 the plt called… - [NTSB LAX83LA025](https://openairdocs.org/ntsb/LAX83LA025.md): Cessna 150B · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Nov 3, 1982 · N7280X · Substantial damage > According to the pilot, the aircraft departed on a cross-country flight with partially filled fuel tanks. Enroute, over the santa monica mountains the engine quit from fuel exhaustion. After hitting a highway sign during the approach, the aircraft landed on… - [NTSB FTW83FA298](https://openairdocs.org/ntsb/FTW83FA298.md): Piper PA-34-200T · Canjilon, NM · Accident · 4 fatal · Field investigation · Final report · Nov 3, 1982 · N8096D · Destroyed > Prior to departing helena, mt at 1209, the plt received a wx briefing from the great falls fss. The dfw 021240Z area forecast, valid until 0700Z on 11/3/82, was not available. The fss briefer made this deficiency known to the plt & recommended that he receive… - [NTSB ATL83FA024](https://openairdocs.org/ntsb/ATL83FA024.md): Cessna 210E · Chattanooga, TN · Accident · No injuries · Field investigation · Final report · Nov 3, 1982 · N4958U · Substantial damage > The eng lost power passing 4,000 ft during climbout. The plt immediately reversed course & attempted to reach lovell field. He was unable to reach the rwy & landed in a shopping center parking lot 1 mi short of the rwy. The right wing struck a signpost & the… - [NTSB FTW83LA033](https://openairdocs.org/ntsb/FTW83LA033.md): Boeing 737-200 · Austin, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 2, 1982 · N55SW · No damage > The pilot penetrated the top of a cumulus cloud while climbing from 18000 to 20000 feet. A sharp jolt was felt and turbulence continued for 3-4 seconds. A stewardess fell and broke her ankle. - [NTSB FTW83FA031](https://openairdocs.org/ntsb/FTW83FA031.md): Cessna P210N · Normangee, TX · Accident · 4 fatal · Field investigation · Final report · Nov 2, 1982 · N612J · Destroyed > A company plt received two wx briefings from the san antonio fss, one was at about 1700 the day before the accident & the other on 11/2. After each wx briefing the company plt briefed the plt of the accident acft. The acft departed at about 0835. At 0953 the… - [NTSB ATL83LA023](https://openairdocs.org/ntsb/ATL83LA023.md): Stinson 108-3 · Exmore, VA · Accident · No injuries · Limited investigation · Final report · Nov 1, 1982 · N981C · Substantial damage > During flight, the pilot noticed a decrease in oil pressure and elected to land at an alternate airport. While en route, a complete loss of oil pressure occurred and the pilot executed an emergency landing in an open field. While on the landing roll, the… - [NTSB NYC83FNE01](https://openairdocs.org/ntsb/NYC83FNE01.md): Fairchild M-62A-3 · Durham, CT · Accident · Serious injuries · Final report · Oct 31, 1982 · N3983A · Substantial damage > During a climb to a higher altitude the engine failed. The plt attempted a 180 deg turn to land at an arpt but was unable to make it to the arpt. The acft touched down approximately 15 ft before impacting a barn. - [NTSB DEN83FTA02](https://openairdocs.org/ntsb/DEN83FTA02.md): Cessna 177 · Hardin, MT · Accident · Serious injuries · Final report · Oct 31, 1982 · N2824X · Destroyed > The aircraft had been fully serviced with fuel (48 gal usable supply) and had been flown 1.8 hrs prior to this flight. Reportedly, the pilot had relied on his fuel log and fuel gauges, and did not visually check the fuel quantity during the preflight. While… - [NTSB LAX83LA023](https://openairdocs.org/ntsb/LAX83LA023.md): Cessna 177 · Morgan Hill, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 30, 1982 · N2947X · Substantial damage > The purpose of the flight was to perform a biennial flight review. During the preflight, about 1 pint of fuel was drained from the wings/sumps and about 1/2 teaspoon of water was found. After taking off, the power was reduced to about 2500 RPM and 25 inches… - [NTSB LAX83FA024](https://openairdocs.org/ntsb/LAX83FA024.md): Cessna 172N · Panoche, CA · Accident · 3 fatal · Field investigation · Final report · Oct 30, 1982 · N5223J · Destroyed > At 1615 on 10/29 the plt obtained a fss wx briefing & filed a VFR flt plan to taft. The plt was advised his trip would be in VFR conditions to taft, but the wx would deteriorate tnto thunderstorms along his route as the evening progressed. The acft arrived in… - [NTSB FTW83LA028](https://openairdocs.org/ntsb/FTW83LA028.md): Piper PA-28RT-201 · Ardmore, OK · Accident · Minor injuries · Limited investigation · Final report · Oct 30, 1982 · N29632 · Destroyed > Pilot tookoff with prop governor inoperative. While cruising 21 miles south of Ardmore, he began to loose oil pressure and turned toward Ardmore. Engine quit 4 miles from airport. Pilot declared an emergency and descended through the clouds. He went through… - [NTSB ATL83LA020](https://openairdocs.org/ntsb/ATL83LA020.md): Piper PA-28-140 · Corinth, MS · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 1982 · N5537U · Destroyed > During a VMC cross country flight the pilot encountered low ceilings and rain. The pilot stated that the engine also started running rough and was losing power. At this point he executed a forced landing into trees. The investigation disclosed that serious… - [NTSB LAX83FVD03](https://openairdocs.org/ntsb/LAX83FVD03.md): Beech B35 · Linden, CA · Accident · Serious injuries · Final report · Oct 27, 1982 · N5236C · Destroyed > The aircraft engine lost power during a night cross-country. The pilot was forced to land in a grove of young walnut trees. The aircraft hit with one wing low and spun around. All motion stopped in a very short distance. An examination revealed that both fuel… - [NTSB DEN83FTE02](https://openairdocs.org/ntsb/DEN83FTE02.md): Cessna 172G · Mack, CO · Accident · 1 fatal · Final report · Oct 27, 1982 · N5803R · Destroyed > While on a flt from evanston, WY to glenwood, CO, the plt encountered "cloud to ground" conditins & diverted toward grand junction, CO. He stated that due to a nav problem, he radioed grand junction tower to verify his position. Grand junction had no radar &… - [NTSB LAX83FA020](https://openairdocs.org/ntsb/LAX83FA020.md): Piper PA-28-181 · Vallejo, CA · Accident · 4 fatal · Field investigation · Final report · Oct 25, 1982 · N4583F · Destroyed > At 1830, the plt received a wx briefing for a flt from fair oaks to san jose, CA with a passenger pickup stop at sacramento, CA. During the briefing, he was told that he ought to be able to make it if he traveled below 4000 ft MSL & left within the next hr.… - [NTSB CHI83LA025](https://openairdocs.org/ntsb/CHI83LA025.md): Cessna 172 · Lansing, IL · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1982 · N23388 · Substantial damage > The acft had a complete electrical failure & the plt made an emergency landing at Lansing. The plt was unable to lower the flap, & after encountering ground fog landed long, bounced, & ground looped to avoid running off the end of the rwy. Invest of the elect… - [NTSB ATL83LA016](https://openairdocs.org/ntsb/ATL83LA016.md): Cessna 172N · Indian Mound, IN · Accident · Minor injuries · Limited investigation · Final report · Oct 25, 1982 · N739RJ · Destroyed > Approximately 10 minutes after departure the pilot of N739RJ reported "engine problems." The pilot stated that he tried various power settings and fuel selections without success. He advised fort campbell approach control that he was landing into trees.… - [NTSB NYC83FA012](https://openairdocs.org/ntsb/NYC83FA012.md): Piper PA-32-300 · Dexter, NY · Accident · Serious injuries · Field investigation · Final report · Oct 24, 1982 · N4031W · Substantial damage > The aircraft made a forced landing going upslope on a river bank following an engine failure. The landing was made just short of an open field. The engine failure occurred at 1404 feet. The power loss was due to failure of crankshaft gear indexing dowel pin. - [NTSB DEN83FA010](https://openairdocs.org/ntsb/DEN83FA010.md): Cessna 320E · Kemmerer, WY · Accident · 2 fatal · Field investigation · Final report · Oct 24, 1982 · N3460Q · Destroyed > The flt departed big piney at approximately 2200 & was observed to climb straight out from rwy 31 to an estimated 7,800 ft MSL. The acft then turned to a southwesterly heading toward Kemmerer. Shortly thereafter a witness at big pineyheard the plt attempt to… - [NTSB FTW83LA019](https://openairdocs.org/ntsb/FTW83LA019.md): North American F-51D · Piedmont, OK · Accident · No injuries · Limited investigation · Final report · Oct 23, 1982 · N11T · Substantial damage > The eng failed at 5,500 ft MSL. During an emergency landing at a 5,000 ft dirt strip (under construction for paving), gear extension was delayed to increase glide. The right gear did not have time to lock down & retracted during landing. Initial exam of the… - [NTSB MIA83LA018](https://openairdocs.org/ntsb/MIA83LA018.md): Piper PA-39 · N. Ft. Lauderda, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 22, 1982 · N8856Y · Destroyed > Pilot says he refueled at nassau with 20 gals in aux. Tanks. Estimated 10 gals each main tank. 45 minutes after departure #1 eng. Failed. 5 minutes later #2 failed. Aircraft sank. - [NTSB CHI83FA022](https://openairdocs.org/ntsb/CHI83FA022.md): Cessna R182 · Lemont, IL · Accident · 1 fatal · Field investigation · Final report · Oct 20, 1982 · N736NA · Destroyed > The pilot took off at 0642 CDT, and at 0645, he reported level at 4000 ft MSL. At 0659:08, he preported that he was encountering icing conditions and requested a climb to 6000 ft. at 0700:16, after changing from TRACON to center frequency, he was cleared as… - [NTSB SEA83LA008](https://openairdocs.org/ntsb/SEA83LA008.md): Cessna T210M · Ashton, ID · Accident · No injuries · Limited investigation · Final report · Oct 18, 1982 · N1982M · Substantial damage > During a flight from el paso, TX to three forks, MT, the pilot noted clouds below his cruising altitude while crossing the Montana border. When he arrived at his destination, he was above a solid overcast, so he diverted to west yellowstone, MT. During… - [NTSB FTW83FA017](https://openairdocs.org/ntsb/FTW83FA017.md): Bell 206B · Gulf Of Mexico · Accident · 3 fatal · Field investigation · Final report · Oct 18, 1982 · N55AL · 2 aircraft · Destroyed > N55AL had departed vermillion block 84 at about 0956 enroute to vermillion block 39 with an ETA of 1010. The plt called at about 1011 stating he would be landing in about 1 minute. N9914K had departed vermillion block 64 at about 1010 enroute to vermillion… - [NTSB CHI83LA018](https://openairdocs.org/ntsb/CHI83LA018.md): Mooney M20E · Sault Ste Marie, MI · Accident · 2 fatal · Limited investigation · Final report · Oct 17, 1982 · N9192V · Destroyed > The pilot was on a VMC flight plainwell, MI. To Sault st Marie, MI. Prior to and during the flight the pilot obtained weather briefings on conditions relative to his intended route of flight. A witness near the crash site stated the aircraft passed over her… - [NTSB FTW83LA016](https://openairdocs.org/ntsb/FTW83LA016.md): Volksplane VP-2 · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Oct 16, 1982 · N3SW · Substantial damage > After taking off, the pilot flew back by the airport and then began to climb again. While climbing through about 700 ft, the engine lost power. The pilot was unable to reach the airport. During a landing, he cleared over an area with trees but struck a power… - [NTSB MKC83LA008](https://openairdocs.org/ntsb/MKC83LA008.md): Cessna 152 · Topeka, KS · Accident · No injuries · Limited investigation · Final report · Oct 15, 1982 · N757JT · Substantial damage > On a flight from poplar bluff, MO to Topeka, KS, the pilot encountered headwinds. About 4 to 5 miles from his destination airport, the engine lost power. The aircraft was damaged during a forced landing in a plowed field between 2 north-south power lines.… - [NTSB CHI83FA014](https://openairdocs.org/ntsb/CHI83FA014.md): Beech A24R · Lansing, MI · Accident · 1 fatal · Field investigation · Final report · Oct 11, 1982 · N24639 · Destroyed > Witnesses observed the acft flying in an easterly direction, level but in a slightly descending flight path. No smoke, flame or parts falling from the acft were observed. The eng sound was steady & loud. The descent continued at a shallow angle until impact.… - [NTSB SEA83FYM01](https://openairdocs.org/ntsb/SEA83FYM01.md): Bellanca 7GCBC · 1/4nm S. Of Peo, OR · Accident · 1 fatal · Final report · Oct 10, 1982 · N57457 · Substantial damage > The pilot and passenger were on a pleasure flight over the willamette river. The passenger stated that after following the river the aircraft began to climb and turn east. There was a sudden jolt and the plane began to spin and impacted the water. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=377 ## 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=376 --- 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.