# 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 366 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC83FA192](https://openairdocs.org/ntsb/NYC83FA192.md): Beech V35A · Acra, NY · Accident · 1 fatal · Field investigation · Final report · Jul 24, 1983 · N2617A · Destroyed > The pilot stated that he was looking for VMC even though he was on an IFR flight. While inbound to albany he said he was circling down from 4000 feet in a VFR spot to get under the clouds. He subsequently cancelled his IFR flt plan and said he was going to… - [NTSB MKC83LA162](https://openairdocs.org/ntsb/MKC83LA162.md): Grumman G-164A · Minden, NE · Accident · Minor injuries · Limited investigation · Final report · Jul 23, 1983 · N5319 · Destroyed > Aprx 5 min after takeoff, the eng quit & the plt made a forced landing in a nearby field. He did not dump his load of chemicals. Reportedly, the acft landed hard & was destroyed. The plt was exposed to the chemicals during the crash landing. An exam revealed… - [NTSB FTW83LA346](https://openairdocs.org/ntsb/FTW83LA346.md): Cessna 150L · Uvalde, TX · Accident · No injuries · Limited investigation · Final report · Jul 23, 1983 · N1639Q · Substantial damage > While the student was on a cross-country flt, the eng lost power after the acft had been flying 3.6 hrs. She made an emergency landing on a ranch road; however, during the roll-out, the right wing struck a telephone pole. The acft had a usable fuel supply of… - [NTSB SEA83LA157](https://openairdocs.org/ntsb/SEA83LA157.md): Breezy Rlu 1 · Ellensburg, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 22, 1983 · N6G · Substantial damage > The plt was flying very low over a ridge at about 4,700 ft MSL & got caught in a downdraft. He was unable to fly out of the downdraft & struck the ground. - [NTSB NYC83FA189](https://openairdocs.org/ntsb/NYC83FA189.md): Robinson R22 · Canton, PA · Accident · 2 fatal · Field investigation · Final report · Jul 22, 1983 · N9066P · Destroyed > While the helicopter was on a power line patrol flt, one of the main rotor blades separated & the acft crashed & burned. Numerous persons saw the helicopter while the plt was patrolling at low alt. Several reported seeing the acft maneuver abruptly over… - [NTSB NYC83FA187](https://openairdocs.org/ntsb/NYC83FA187.md): Piper PA-28-181 · Fairton, NJ · Accident · 4 fatal · Field investigation · Final report · Jul 22, 1983 · N8398T · Destroyed > Prior to departure the plt received a wx briefing which was concluded with a severe wx warning. The plt stated he would try anyway & if the wx got too bad he would return. About 16 min later the plt requested updated wx conditions. He was advised of a… - [NTSB LAX83FA348](https://openairdocs.org/ntsb/LAX83FA348.md): Cessna T210N · Watsonville, CA · Accident · 2 fatal · Field investigation · Final report · Jul 22, 1983 · N5517C · Destroyed > The plt, who was a contractor, was scheduled to attend a heavy equip't auction in sacramento to begin a 1000. Witnesses heard normal eng sounds as the acft departed rwy 19 & turned to a left downwind departure turn. The acft was observed proceeding on a NE… - [NTSB DEN83LA175](https://openairdocs.org/ntsb/DEN83LA175.md): Cessna U206E · Bryce Canyon, UT · Accident · No injuries · Limited investigation · Final report · Jul 22, 1983 · N9403G · Substantial damage > The pilot said that while enroute to albuquerque from las vegas he encountered deteriorating weather that he could not get around he tried to climb over it but was unable. Once clear of cloud he descended trying to get back to Bryce Canyon. As the ceiling… - [NTSB ATL83LA287](https://openairdocs.org/ntsb/ATL83LA287.md): Cessna 150 · Johnston, SC · Accident · No injuries · Limited investigation · Final report · Jul 21, 1983 · N18188 · Substantial damage > The plt reported that before taking off, he preflighted the acft & estimated that 6 gal of fuel was on board. According to him, the engine lost power aprx 30 min after takeoff & he was unable to restart it. During a forced landing, he intentionally ground… - [NTSB ATL83AA285](https://openairdocs.org/ntsb/ATL83AA285.md): Piper PA-31P · Lost Creek, WV · Accident · 4 fatal · Final report · Jul 20, 1983 · N234LC · Destroyed > The acft took off with 4 occupants & an estimated 596 lbs of cargo on board. After it took off, the ATC controller noted that it was climbing slower than expected. After climbing to about 4200 ft MSL, the aircrew reported a problem with the left eng & said… - [NTSB CHI83FA324](https://openairdocs.org/ntsb/CHI83FA324.md): Piper PA-23-250 · Youngstown, OH · Accident · No injuries · Field investigation · Final report · Jul 19, 1983 · N54072 · Substantial damage > During an IFR flt, the acft was leveled at 13,000 ft & the power was set at 18 inches manifold pressure & 2300 RPM. Aprx 5 min later, the right eng began to surge to 3000 RPM & almost 'pegged.' The plt attempted to control the right propeller. Finally, the… - [NTSB SEA83LA152](https://openairdocs.org/ntsb/SEA83LA152.md): Cessna 120 · Tenakee Springs, AK · Accident · No injuries · Limited investigation · Final report · Jul 18, 1983 · N76239 · Substantial damage > The acft nosed over during a forced landing on a rocky beach at night. The pilot did not use carburetor heat during the engine restart attempts. - [NTSB MIA83LA186](https://openairdocs.org/ntsb/MIA83LA186.md): Bellanca 7ACA · Homestead, FL · Accident · No injuries · Limited investigation · Final report · Jul 18, 1983 · N68556 · Substantial damage > The plt reported that he 'topped off' his fuel tank with 12 gal of fuel at Homestead, FL. He then flew to the port largo arpt at key largo, FL and to the marathon arpt, marathon, FL, but did not report obtaining additional fuel. While en route back to… - [NTSB DEN83LA168](https://openairdocs.org/ntsb/DEN83LA168.md): Cessna 172 · Salida, CO · Accident · No injuries · Limited investigation · Final report · Jul 18, 1983 · N37ER · Substantial damage > According to the plt, he crossed ruby mountain at 9900 ft mcl. After crossing, he reportedly encountered light rain & 500 ft/min downdrafts. He stated that he flew into rotor winds & had difficultly keeping the wings level. Reportedly, there was insufficient… - [NTSB CHI83LA332](https://openairdocs.org/ntsb/CHI83LA332.md): Cessna 188B · Crookston, MN · Accident · No injuries · Limited investigation · Final report · Jul 18, 1983 · N92037 · Substantial damage > The acft collided with a barley crop during a forced landing on a narrow dirt road. The acft had lost power after takeoff for a calibration spray run. The pilot stated he took off with about 10 gallons of fuel (1/8 tank) and did not visually check the fuel… - [NTSB ATL83LA280](https://openairdocs.org/ntsb/ATL83LA280.md): Piper PA-28-140 · Viola, TN · Accident · Minor injuries · Limited investigation · Final report · Jul 17, 1983 · N7511R · Substantial damage > The acft was damaged in a collision with farm equipment during an emergency landing on a grass strip. The student pilot had received a weather briefing by telephone but had inadvertantly encountered a rain shower. Because of the rain the student elected to… - [NTSB ATL83LA279](https://openairdocs.org/ntsb/ATL83LA279.md): Piper PA-28-140 · Asheville, NC · Accident · No injuries · Limited investigation · Final report · Jul 17, 1983 · N55703 · Substantial damage > The plt departed on a x-country flt without obtaining a wx briefing. He indicated that during the flt, he was flying over a broken sky condition & reported that the VOR went bad. After flying about 5 hrs, he became unsure of his location. With the fuel… - [NTSB MKC83LA157](https://openairdocs.org/ntsb/MKC83LA157.md): Gyaki Skybolt · St. Charles, MO · Accident · No injuries · Limited investigation · Final report · Jul 16, 1983 · N710T · Substantial damage > The home-built acft was on a local pleasure flt near the arpt when the engine quit and a forced landing was made in a wheatfield. Investigation of the engine and fuel system by an FAA inspector revealed that the vent in the fuel cap was soldered shut and the… - [NTSB SEA83LA149](https://openairdocs.org/ntsb/SEA83LA149.md): Cessna 170 · Mullan, ID · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N406OV · Substantial damage > The acft collided with a telephone line during maneuvering to stay VFR and clear of ground obstructions. The pilot said he was approaching lookout pass at about 500-800 ft AGL and was following interstate 90 westbound. He inadvertently entered IFR conditions… - [NTSB DEN83LA165](https://openairdocs.org/ntsb/DEN83LA165.md): Bell 47J-2A · Interior, SD · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N8545F · Substantial damage > While on a sight-seeing flt over a park, the plt heard a loud noise & the helicopter shuddered & lost power. At that time, the acft was over a canyon, so the plt looked for the flatest area to land & began an autorotation. During the landing, the helicopter… - [NTSB ATL83LA275](https://openairdocs.org/ntsb/ATL83LA275.md): Enstrom F28C · Brandywine, MD · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N582H · Substantial damage > In level cruise flt the plt experienced a severe vibration followed by uncontrollable rotation to the right. The plt wasunable to regain directional control & crashed into trees. Investigation revealed that the rear t/r drive coupling, PN28-13609, had failed… - [NTSB MIA83LA182](https://openairdocs.org/ntsb/MIA83LA182.md): Piper PA-32 · Jupiter, FL · Accident · No injuries · Limited investigation · Final report · Jul 13, 1983 · N3719W · Substantial damage > The plt reported that he was returning from the Bahamas when he experienced a loss of eng power & landed in a vacant field. The power loss occurred following fuel starvation. The plt stated that the acft was recently purchased & the fuel gauges were… - [NTSB LAX83IA331](https://openairdocs.org/ntsb/LAX83IA331.md): Convair 440 · Point Mugu, CA · Incident · No injuries · Incident investigation · Final report · Jul 13, 1983 · N827AA · Minor damage > An engine fire erupted during the climb to cruise. Following an emergency landing it was determined that there was a loose primer line fitting at the carburetor in the area of the greatest fire damage. - [NTSB LAX83FA333](https://openairdocs.org/ntsb/LAX83FA333.md): Rolladen-Schneider LS3-A · Bishop, CA · Accident · 1 fatal · Field investigation · Final report · Jul 13, 1983 · N56TM · Destroyed > The glider plt was participating in a soaring contest which involved a quadrangle course. While enroute to the 1st turn point with 2 other sailplanes, the plt was observed to depart from the general flt path of the other 2 gliders & fly on the leeward side of… - [NTSB CHI83LA310](https://openairdocs.org/ntsb/CHI83LA310.md): Balloon Works Firefly 8-24 · Hamel, MN · Accident · Serious injuries · Limited investigation · Final report · Jul 13, 1983 · N1509W · Substantial damage > During flt, the plt used fuel from 2 of 4 propane tanks, then switched to the 2nd 2 tanks & started a descent. At aprx 300 ft AGL, he tried to start the burner, but could not get a light because the pilot light was out. He attempted to manually relight the… - [NTSB ATL83FA270](https://openairdocs.org/ntsb/ATL83FA270.md): Piper PA-32R-300 · Cynthiana, KY · Accident · Serious injuries · Field investigation · Final report · Jul 12, 1983 · N6866J · Substantial damage > The acft crashed during a forced landing after an engine failure. The acft was cruising at 6000 ft MSL when the engine quit. The pilots set up a glide for Cynthiana/harrison arpt while trying to restart the engine. When it became apparent that they could not… - [NTSB ANC83FA122](https://openairdocs.org/ntsb/ANC83FA122.md): Aerospatiale AS-350D · Dutch Harbor, AK · Accident · Serious injuries · Field investigation · Final report · Jul 12, 1983 · N141EH · Destroyed > Aprx 2 min after takeoff, the plt & passengers heard a loud muffled boom from behind the firewall, then the rotor RPM began to decay. The plt entered an autorotation & selected a landing area. He noted that the eng was not driving the rotor sys, so he shut it… - [NTSB SEA83LA146](https://openairdocs.org/ntsb/SEA83LA146.md): Piper PA-38-112 · Dixie, WA · Accident · No injuries · Limited investigation · Final report · Jul 11, 1983 · N4461E · Substantial damage > About an hour after departure the engine began to run rough. The pilot did a magneto check and noted a drop of 300 RPM. A precautionary landing was made into a field of tall wheat. During landing roll the left main landing gear struck a hole. Examination of… - [NTSB MIA83FA180](https://openairdocs.org/ntsb/MIA83FA180.md): Piper PA-32R-300 · Islamorada, FL · Accident · Serious injuries · Field investigation · Final report · Jul 11, 1983 · N6207J · Destroyed > The acft was ditched in the Florida bay after the engine malfunctioned. According to the plt, the eng started to run rough and he ditched the acft at about 0600 EDT. However, the acft clock was stopped at 0345 and a commercial fisherman said he saw a low… - [NTSB CHI83LA308](https://openairdocs.org/ntsb/CHI83LA308.md): Piper PA 28-180 · Chandlerville, IL · Accident · No injuries · Limited investigation · Final report · Jul 10, 1983 · N6952J · Substantial damage > The acft made a forced landing after losing power at 1500 ft the pilot said the engine ran rough, oil pressure went to zero and the engine stopped. This pilot had been forced to land the same acft 3 days earlier when the engine lost power during takeoff.… - [NTSB MKC83LA150](https://openairdocs.org/ntsb/MKC83LA150.md): Bellanca 17-31A · Greensburg, KS · Accident · No injuries · Limited investigation · Final report · Jul 9, 1983 · N6575V · Substantial damage > The pilot stated that the auxiliary tank ran dry and the engine quit. He switched the tank selector to the right main fuel tank which had ample fuel but he was unable to restart the engine. He made a forced landing on a highway and after touchdown the left… - [NTSB LAX83LA327](https://openairdocs.org/ntsb/LAX83LA327.md): Cessna 150G · Roosevelt, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1983 · N8378J · Substantial damage > The acft collided with rising terrain during climb to cruise. According to the pilot the flt departed from an arpt wherethe elevation is 2361 ft. the flt proceeded toward nearby mountains whose elevation is about 5000 ft MSL. The acft rate of climb was about… - [NTSB CHI83FAMS1](https://openairdocs.org/ntsb/CHI83FAMS1.md): Grumman AA-1 · Manitowoc, WI · Accident · 1 fatal · Missing aircraft · Final report · Jul 9, 1983 · N6214L · Destroyed > The acft disappeared from radar contact while over lake Michigan. This acft had departed baltimore MD at 1142 CDT to flyto Manitowoc, WI. The last enroute stop for fuel was at muskegon mi at 2040 CDT. The weather was VMC but the night was dark. No flt plan… - [NTSB ATL83LA286](https://openairdocs.org/ntsb/ATL83LA286.md): Cessna P206B · Suffolk, VA · Accident · No injuries · Limited investigation · Final report · Jul 9, 1983 · N8601Z · Substantial damage > The parachute of one of the jumpers deployed prematurely. The shroud lines entangled in the right horizontal stabilizer & elevator. As the parachute inflated, the stabilizer was bent downward, & the elevator partially ripped from the trailing edge of the… - [NTSB ATL83LA265](https://openairdocs.org/ntsb/ATL83LA265.md): Cessna 152 · Chattanooga, TN · Accident · No injuries · Limited investigation · Final report · Jul 9, 1983 · N65436 · Substantial damage > The acft was damaged in an off airport forced landing during a cross-country after the engine failed from fuel exhaustion. The student pilot had departed for the cross-coutry with 24.5 usable gallons on board. He departed at 1240 hrs EDT and at 1620 he made a… - [NTSB ATL83FA262](https://openairdocs.org/ntsb/ATL83FA262.md): Beech N35 · Mccomb, MS · Accident · 2 fatal · Field investigation · Final report · Jul 9, 1983 · N1317Z · Destroyed > The acft crashed in a nose low attitude and was destroyed. The two plts aboard had been practicing instrument approachesat Mccomb and suddenly without notifing fss the practice was discontinued to return to baton rouge. Fss found out about the change by… - [NTSB ATL83FA261](https://openairdocs.org/ntsb/ATL83FA261.md): Hiller UH-12B · Huntsville, AL · Accident · No injuries · Field investigation · Final report · Jul 9, 1983 · N922TE · Substantial damage > The helicopter was damaged in a forced autorotative landing after the engine quit at 1200 ft MSL in cruise flt. The acftlanded in a mowed wheat field and the right skid dug into the soft ground. The plt and passengers declared no injureis. The plt said the… - [NTSB LAX83LUQ04](https://openairdocs.org/ntsb/LAX83LUQ04.md): Hiller UH 12-E · Lancaster, CA · Accident · No injuries · Final report · Jul 8, 1983 · N64861 · Substantial damage > According to the pilot, after spraying an onion field he was departing for the next job when he noted an increase in engine RPM and a decrease in rotor RPM. Unable to maintain altitude, he made an emergency landing aprx 200 feet AGL. Prior to landing, the… - [NTSB CHI83LA301](https://openairdocs.org/ntsb/CHI83LA301.md): Piper PA-32RT-300T · Columbus, OH · Accident · Serious injuries · Limited investigation · Final report · Jul 8, 1983 · N39487 · Destroyed > About 1 1/2 min after taking off, the acft was climbing thru aprx 1400 ft AGL when the eng lost most of its power, sputtered, and shortly thereafter quit running altogether. The plt switched fuel tank & tried to restart the eng but was unable. The plt was… - [NTSB NYC83FA168](https://openairdocs.org/ntsb/NYC83FA168.md): Grumman AA-5B · Old Bridge, NJ · Accident · Minor injuries · Field investigation · Final report · Jul 7, 1983 · N31ER · Substantial damage > The plt stated that takeoff and climb to 600 ft were routine. When he started a left turn the eng 'began to lose power.'the plt continued the left turn back toward the arpt but the eng did not restart and the acft stuck trees about 1 mi short. Investigation… - [NTSB MIA83FA181](https://openairdocs.org/ntsb/MIA83FA181.md): Bell 47G-2 · Lake Worth, FL · Accident · Serious injuries · Field investigation · Final report · Jul 7, 1983 · N366DJ · Substantial damage > At 2037 EDT, the plt called palm beach tower & reported that he was east of lantana arpt at 500 ft, inbound for a landing at the palm beach arpt. Aprx a min later, there was another call from helicopter stating that it was going down, out of fuel. During an… - [NTSB DEN83LA162](https://openairdocs.org/ntsb/DEN83LA162.md): Cessna 150 · Heber City, UT · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1983 · N19348 · Substantial damage > The acft collided with a pole during an off airport precautionary landing in IMC weather. The non instrument rated student pilot took off for a 150 mile cross country with less than full fuel tanks because no 87 octane was available. He also failed to get a… - [NTSB FTW83FA319](https://openairdocs.org/ntsb/FTW83FA319.md): Grumman AA-1B · Newport, AR · Accident · 2 fatal · Field investigation · Final report · Jul 6, 1983 · N1480R · Destroyed > The acft remained low after takeoff and after a turn continued north out of sight of witnesses and did not reappear. It collided with the bottom two strands of a powerline which were severed by the propeller. The acft fuselage came to rest 162 ft beyond the… - [NTSB FTW83LA321](https://openairdocs.org/ntsb/FTW83LA321.md): Piper PA28-151 · Mandeville, LA · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1983 · N40990 · Substantial damage > On a cross country flight in normal cruise at 2000 ft AGL the engine quit. The pilot made a forced landing to a road. During landing roll the left wing struck a vehicle. The acft then slid into a ditch. Post accident investigation revealed that an oil line… - [NTSB FTW83LA316](https://openairdocs.org/ntsb/FTW83LA316.md): Cessna 150K · Arcadia, OK · Accident · No injuries · Limited investigation · Final report · Jul 5, 1983 · N6056G · Substantial damage > The acft was damaged in a forced landing after the engine quit from fuel exhaustion. The plt had made an unscheduled stop for oil during the x-country flt. According to the plt the engine began to run rough while cruising and then quit completely even though… - [NTSB CHI83LA292](https://openairdocs.org/ntsb/CHI83LA292.md): Bell 47G-4A · Wheeler, IL · Accident · No injuries · Limited investigation · Final report · Jul 5, 1983 · N7069J · Substantial damage > The plt reported that while he was returning for another load of chemicals, the eng missed a couple of times, then smoothed out for about 1 min. After that, the eng missed again, then quit while the helicopter was at aprx 150 ft AGL. The plt chose to clear… - [NTSB MIA83FA174](https://openairdocs.org/ntsb/MIA83FA174.md): Cessna 150L · Islamorada, FL · Accident · Serious injuries · Field investigation · Final report · Jul 4, 1983 · N11539 · Destroyed > The eng quit at about 1,000 ft AGL. Eng restart was unsuccessful & the acft ditched. Tests indicated that the fuel was regular automotive leaded fuel with a motor octane number of 87.3. The logbooks showed that the STC for use of automotive fuel had not been… - [NTSB FTW83LA325](https://openairdocs.org/ntsb/FTW83LA325.md): Cessna 337A · Oxford, AR · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N6302F · Substantial damage > Prior to starting on a round trip from manhattan, KS, the owner informed the plt that the fuel selector for the rear eng was inop & precluded selection of the aux fuel tank. For that reason, the plt did not use either aux fuel tank. After about 2.8 hrs on the… - [NTSB FTW83LA320](https://openairdocs.org/ntsb/FTW83LA320.md): Grumman G-164A · Dayton, TX · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N48374 · Substantial damage > The agricultural acft crashed 100 ft short of the rwy after the engine failed. The plt said the engine lost power and RPM so he decided to return to the airstrip after dumping his chemical load. The engine failed completely short of the rwy. The acft hit a… - [NTSB DEN83LA158](https://openairdocs.org/ntsb/DEN83LA158.md): Cessna T21OL · Saratoga, WY · Accident · No injuries · Limited investigation · Final report · Jul 4, 1983 · N2317S · Substantial damage > During a sight-seeing flt at aprx 7000 ft MSL (500 ft AGL), the engine lost power about 15 min after the plt switched from the left to the right main tank & descended from a higher altitude. Subsequently, the plane was damaged during a wheels up landing on… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=367 ## 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=366 --- 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.