# NTSB investigations: Initial climb 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 202 of 412 · 20,559 cases ## Cases, newest first - [NTSB CHI83FA350](https://openairdocs.org/ntsb/CHI83FA350.md): Monnett Moni · Omro, WI · Accident · Serious injuries · Field investigation · Final report · Aug 1, 1983 · N3919X · Substantial damage > According to witnesses, the wind was northwesterly at about 20 KTS & the rwy heading of the dirt strip was 030 deg. The plt made a low pass over the strip, then made a touch-&-go landing. On the 3rd apch, the acft touched down about 800 to 900 ft from the… - [NTSB LAX83LA367](https://openairdocs.org/ntsb/LAX83LA367.md): Cessna T210M · Eureka, NV · Accident · No injuries · Limited investigation · Final report · Jul 31, 1983 · N761NF · Substantial damage > The pilot had landed at this strip to attend a local rodeo. The airstrip was 2000 ft of loose gravel. The wind was calm,temperature 65 degrees, and the elevation was 5900 ft MSL, density alt was 7500 ft. the pilot used 10 degrees of flaps for takeoff. He said… - [NTSB LAX83FA366](https://openairdocs.org/ntsb/LAX83FA366.md): Bell 47G-3B-1 · S. Lake Tahoe, CA · Accident · Serious injuries · Field investigation · Final report · Jul 31, 1983 · N11102 · Destroyed > During takeoff over descending terrain in a mountainous area, the RPM began decaying when the helicopter had accelerated to 40 KTS & was about 75 ft AGL. The plt applied more throttle & increased the collective, then noted that the manifold pressure was… - [NTSB NYC83FGM04](https://openairdocs.org/ntsb/NYC83FGM04.md): Chamberlain KR-1 · Johnstown, PA · Accident · 1 fatal · Final report · Jul 30, 1983 · N80190 · Destroyed > The acft collided with the ground after takeoff. The weather was VMC and no flt plan was filed. The acft was an amateur/experimental KR-1 with a vw 2100 cc engine, maintained under a condition inspection program performed by the owner. Investigation at the… - [NTSB LAX83LA365](https://openairdocs.org/ntsb/LAX83LA365.md): Cessna 177 · Show Low, AZ · Accident · Serious injuries · Limited investigation · Final report · Jul 30, 1983 · N30236 · Substantial damage > The arpt elevation was 6411 ft MSL & the density altitude was aprx 9150 ft. during takeoff, the acft climbed to about 7300 ft MSL, then began to lose power. The plt was unable to return to the arpt. During an emergency landing, the wing of the acft hit a… - [NTSB CHI83LA340](https://openairdocs.org/ntsb/CHI83LA340.md): Cessna 150 · East St Louis, IL · Accident · No injuries · Limited investigation · Final report · Jul 30, 1983 · N6032K · Substantial damage > The CFI noticed the acft was not climbing & the airspeed was not increasing. He took control of the acft & landed in a bean field. He later stated that the flaps were not retracted by the student after takeoff. - [NTSB ANC83FA135](https://openairdocs.org/ntsb/ANC83FA135.md): Piper PA-28 · Healy, AK · Accident · No injuries · Field investigation · Final report · Jul 29, 1983 · N8553W · Substantial damage > The plt stated that after takeoff, at aprx 400 ft, the engine lost power. During a forced landing, the acft crashed in a river. No mechanical failure or malfunction was found. - [NTSB NYC83FA193](https://openairdocs.org/ntsb/NYC83FA193.md): North American Rockwell 680 · Bayport, NY · Accident · 2 fatal · Field investigation · Final report · Jul 28, 1983 · N6878S · Destroyed > At about 60 ft AGL black smoke was observed coming from the left eng. The acft continued a climb in a nose high attitude& the nose pitched down & the acft rolled inverted. Eng teardown revealed extensive damage to the supercharger assembly. The impeller shaft… - [NTSB MIA83LA192](https://openairdocs.org/ntsb/MIA83LA192.md): Piper PA-38 · Port Manatee, FL · Accident · No injuries · Limited investigation · Final report · Jul 28, 1983 · N25273 · Substantial damage > After overflying the strip to check the condition, the plt re-entered the pattern for a touch & go. After touchdown he applied full power & made a low pass down the strip. He began to pull up about midway down the strip & noticed a loss ofpower. The acft… - [NTSB CHI83LA338](https://openairdocs.org/ntsb/CHI83LA338.md): Kane Bush BY Mustang 2 · Winona, MN · Accident · No injuries · Limited investigation · Final report · Jul 28, 1983 · N4K · Substantial damage > The plt initiated a takeoff on a 2000 ft grass strip. He stated that the takeoff was normal until it became apparent that the acft would not climb out of ground effect. Since the go/no go decision point had been passed, he attempted to climb straight ahead.… - [NTSB CHI83FA336](https://openairdocs.org/ntsb/CHI83FA336.md): American Aerolights Eagle 2 · Valpariso, IN · Accident · 1 fatal · Field investigation · Final report · Jul 28, 1983 · N930AA · Destroyed > The person who sold the acft to the plt stated he had given the plt a training flt that evening, but since there was only 1 set of controls, the plt (involved in the accident) only observed. Since darkness was apchg, the previous owner did not want to… - [NTSB NYC83LA194](https://openairdocs.org/ntsb/NYC83LA194.md): Grumman AA-1C · Doylestown, PA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1983 · N9978U · Substantial damage > The student made 2 takeoffs & landings, then waited for traffic to clear the rwy before taking off again. While climbing to traffic pattern altitude on the 3rd takeoff, the eng lost power. An emergency checklist to restart the eng was not completed because of… - [NTSB MIA83LA191](https://openairdocs.org/ntsb/MIA83LA191.md): Piper PA-38-112 · St. Augustine, FL · Accident · No injuries · Limited investigation · Final report · Jul 27, 1983 · N9945T · Substantial damage > The instructor plt stated that just after lift-off, the eng began misfiring & lost power. At that point, there was insufficient rwy remaining to stop, so an attempt was made to continue the takeoff. The acft did not clear corn at the end of the 2000 ft strip.… - [NTSB LAX83LA360](https://openairdocs.org/ntsb/LAX83LA360.md): Hiller 12E · Los Banos, CA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1983 · N9770C · Destroyed > The plt had dropped off a flagman in an area to be sprayed, & had just departed & obtained translational lift when the eng lost power. The acft touched down in a freshly irrigated cotton field, rolled over inverted & burst into flames. The 'b' nut which… - [NTSB FTW83LA371](https://openairdocs.org/ntsb/FTW83LA371.md): Bell 206B · Venice, LA · Accident · No injuries · Limited investigation · Final report · Jul 27, 1983 · N2268X · Substantial damage > The acft landed hard during an autorotation landing. The plt said he could not control the engine RPM with RPM switch onthe collective or the manual throttle control. N2 tended to go over 100 percent. The plt notified his company and planned for an… - [NTSB ATL83FKG10](https://openairdocs.org/ntsb/ATL83FKG10.md): Cessna 177 · Greensboro, GA · Accident · Serious injuries · Final report · Jul 27, 1983 · N3493T · Destroyed > The plt-in-command reported that the acft was very low on fuel & he had 10 gallons added to each wing tank before departing madison, GA. From madison, he flew to Greensboro, GA for sales demonstrtion flts. During the 1st demonstration flt, the acft performed… - [NTSB LAX83FA351](https://openairdocs.org/ntsb/LAX83FA351.md): Piper PA32R-T301 · Bakersfield, CA · Accident · No injuries · Field investigation · Final report · Jul 25, 1983 · N8370L · Substantial damage > The acft landed hard, collided with a ditch and collapsed the landing gear during a forced landing after the engine quitat 75 ft AGL during takeoff. The engine was started after the accident and ran for over 7 minutes until it was cut off. - [NTSB ATL83LA291](https://openairdocs.org/ntsb/ATL83LA291.md): Bell 47G-2 · Cumberland, KY · Accident · Minor injuries · Limited investigation · Final report · Jul 25, 1983 · N9046A · Destroyed > The plt was conducting local sightseeing flts from a school parking lot. The lot was about 75 yds by 35 yds. On the sidenear a highway there is a six-foot chain link fence the plt had to clear during each takeoff. After boarding the pax theplt hovered… - [NTSB ANC83FA131](https://openairdocs.org/ntsb/ANC83FA131.md): Cessna U206 · Near Iliamna, AK · Accident · No injuries · Field investigation · Final report · Jul 25, 1983 · N4661Z · Substantial damage > The eng lost power just after a water takeoff. The acft landed straight ahead in muskeg & tundra collapsing the floats. Eng teardown revealed a metallic 'nugget' in the left intake manifold between the #4 & #6 ports. Numerous marks were found on the inside of… - [NTSB MIA83LA188](https://openairdocs.org/ntsb/MIA83LA188.md): Ercoupe 415-C · Melrose, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 24, 1983 · N99474 · Substantial damage > The plt took off on rwy 11 (elev 150 ft MSL) with a density alt of 1500 ft. he reported the wind was calm, but aprx 14 mi west at gainsville, FL, the 2052 EDT wind was from 250 deg at 9 KTS. During takeoff, the acft climbed aprx 75 ft, then settled into trees… - [NTSB NYC83FHA05](https://openairdocs.org/ntsb/NYC83FHA05.md): Dimaria BD-4D · Pittstown, NJ · Accident · Minor injuries · Final report · Jul 23, 1983 · N68020 · Substantial damage > Pre-takeoff run-up was normal. As the acft lifted off the rwy the eng quit. The acft ran off the rwy onto soft ground & flipped over. The only eng malfunction found was low compression in the #1 cylinder due to both valves being stuck partially open. All fuel… - [NTSB MIA83LA190](https://openairdocs.org/ntsb/MIA83LA190.md): Piper PA-22-150 · Merritt Island, FL · Accident · No injuries · Limited investigation · Final report · Jul 23, 1983 · N3936P · Substantial damage > The plt reported that during the preflt, he did not visually check the fuel tanks, but relied of the fuel gauges. They indicated there was 7 gal in the left tank & 4 gal in the right tank. The plt took off using fuel from the left tank to practice… - [NTSB DEN83LA173](https://openairdocs.org/ntsb/DEN83LA173.md): Mooney M20J · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Jul 23, 1983 · N43CA · Substantial damage > The arpt had one asphalt rwy that was closed & another dirt rwy that was muddy. Therefore, the plt elected to takeoff on the parking ramp which was oriented in a north/south direction & was 1700 ft long. The plt did not consult the takeoff charts in his… - [NTSB ATL83IA295](https://openairdocs.org/ntsb/ATL83IA295.md): Beech B200 · Winston Salem, NC · Incident · No injuries · Incident investigation · Final report · Jul 22, 1983 · N153GC · Minor damage > During gear retraction the pct noticed a cracking sound followed by smoke in the cabin which was allwviated by the rear vent blower. The emergency gear handle failed to engage & anemergency landing was made with gear partially extended. Theright gear door… - [NTSB SEA83LA155](https://openairdocs.org/ntsb/SEA83LA155.md): Cessna 150E · Issaquah, WA · Accident · Minor injuries · Limited investigation · Final report · Jul 21, 1983 · N6272T · Destroyed > During takeoff on a glider towing operation, the eng lost power at aprx 200 to 250 ft AGL. The glider plt disengaged from the tow plane & the tow plt commenced a power off descent to land on a road. There was conflicting traffic on the road. At about the same… - [NTSB NYC83LA185](https://openairdocs.org/ntsb/NYC83LA185.md): Lake LA 4-200 · Jaffrey, NH · Accident · No injuries · Limited investigation · Final report · Jul 20, 1983 · N3025P · Substantial damage > The acft collided with brush, trees and rocks off the end of the rwy during an aborted takeoff. According to the pilot rotation was initiated once flying speed was attained but the acft failed to respond properly. The pilot elected to abort the takeoff and… - [NTSB LAX83FU011](https://openairdocs.org/ntsb/LAX83FU011.md): Eipper MX · Ramona, CA · Accident · Serious injuries · Final report · Jul 20, 1983 · UNREG · Substantial damage > After receiving dual instruction in a 2 place, training vehicle, the plt took off on a solo flt from a 270 x 25 ft ultralight strip. He reported that after lift-off, the vehicle started drifting toward a tree. He initiated a turn to the right (away from the… - [NTSB ANC83FA127](https://openairdocs.org/ntsb/ANC83FA127.md): Taylorcraft BC12-D · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Jul 20, 1983 · N95261 · Substantial damage > According to the plt, he took off to the southeast into a wind of 10 gusting 15 KTS. After lift-off, he turned to avoid houses on the southeastern shoreline. After he was in a left climbing turn, the acft began descending toward the lake. To avoid stalling,… - [NTSB ANC83FA126](https://openairdocs.org/ntsb/ANC83FA126.md): Helio H395 · Fairbanks, AK · Accident · 1 fatal · Field investigation · Final report · Jul 20, 1983 · N4156D · Substantial damage > Takeoff was from a dirt driveway which had a usable length 0F 330 ft before it curved north. Before takeoff, the plt hadbent several small trees back away from the driveway & tied them down so they would not interfere with the takeoff. There are numerous… - [NTSB CHI83LA325](https://openairdocs.org/ntsb/CHI83LA325.md): E.R. Hutson EAA Biplane · Franklin, IN · Accident · No injuries · Limited investigation · Final report · Jul 19, 1983 · N81964 · Substantial damage > The acft nosed over during a forced landing after the engine quit during takeoff. The plt had taken off with seven gallons of fuel in the reserve tank and 4 gallons in the main tank. His initial takeoff was with the fuel selector on reserve. He flew on… - [NTSB FTW83LA334](https://openairdocs.org/ntsb/FTW83LA334.md): Cessna T182RG · Silver City, NM · Accident · No injuries · Limited investigation · Final report · Jul 18, 1983 · N4830S · Substantial damage > The acft made a forced landing shortly after takeoff when the engine failed. While climbing through 200 ft AGL the acft lost power. The plt made a gear up landing. The engine was examined after the accident and the magneto timing was found to be incorrect.… - [NTSB MIA83LA185](https://openairdocs.org/ntsb/MIA83LA185.md): Piper PA-28-180 · Brandon, FL · Accident · No injuries · Limited investigation · Final report · Jul 17, 1983 · N6596J · Substantial damage > The plt stated that he aborted the takeoff after lift-off from rwy 09. During the sequence, the main gear contacted a barbed wire fence, then the acft was landed in a field & subsequently nosed over in a pond. The plt reported that he was using soft field… - [NTSB LAX83LA339](https://openairdocs.org/ntsb/LAX83LA339.md): Cessna 172 · Payson, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 16, 1983 · N2799E · Destroyed > The pilot had taken a check out in the acft earlier and after that flt the fuel tanks registered less then 1/2 full. The pilot added 6 gallons to each tank prior to departure. After flying about 1 hour, 2 passengers became airsick so a landing was made at an… - [NTSB CHI83LA317](https://openairdocs.org/ntsb/CHI83LA317.md): Cessna 210L · Traverse City, MI · Accident · No injuries · Limited investigation · Final report · Jul 16, 1983 · N30606 · Substantial damage > The plt reported that when the landing gear handle was moved to the up position, the hydraulic pump continued to operate. Subsequently, the circuit breaker for the pump was pulled to keep the motor from overheating. Several attempts to lower the gear with the… - [NTSB ANC83FA125](https://openairdocs.org/ntsb/ANC83FA125.md): Piper J-3 · Soldotna, AK · Accident · No injuries · Field investigation · Final report · Jul 16, 1983 · N88327 · Substantial damage > The acft nosed over in soft dirt during a forced landing after an engine failure. This engine had just been overhauled and was on its first flight. The engine quit at 1200 ft, during takeoff climb. The prop stopped rotating and assumed a horizontal position.… - [NTSB CHI83LA312](https://openairdocs.org/ntsb/CHI83LA312.md): J. Roberts Pitts Special · Grand Haven, MI · Accident · Serious injuries · Limited investigation · Final report · Jul 15, 1983 · N3144 · Destroyed > After a touch-and-go landing, the acft was climbing thru aprx 100 ft AGL when the eng abruptly lost power. A straight ahead landing was not feasible. While the plt was maneuvering to land, the acft impacted in a right wing low, nose down attitude. An… - [NTSB NYC83LA177](https://openairdocs.org/ntsb/NYC83LA177.md): Cessna 152 · Poestenkill, NY · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N89206 · Substantial damage > Initially, the student plt departed falls river, ma on a solo x-country training flt to albany, NY. However, after opening his flt plan, he experienced radio difficulties. Rather than continue to his original destination, he elected to land at rensselaer… - [NTSB FTW83LA335](https://openairdocs.org/ntsb/FTW83LA335.md): Bell 206L-1 · Cameron, LA · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N406EH · Substantial damage > The helicopter rocked and severed the tail boom during an off arpt forced autorotation landing. This acft had a history of engine surges and tot fluctuations. Changes had been made to try to correct the problem. During this flt the engine quit entirely. The… - [NTSB ANC83LA123](https://openairdocs.org/ntsb/ANC83LA123.md): Champion 7ECA · Sterling, AK · Accident · No injuries · Limited investigation · Final report · Jul 14, 1983 · N2757Z · Substantial damage > The acft was taking off to the south and collided with trees alongside the runway. The pilot stated that as the acft lifted off he passed a clearing on the right and a crosswind drifted the acft left across the runway into trees. The left wing clipped a tree… - [NTSB SEA83LA147](https://openairdocs.org/ntsb/SEA83LA147.md): Bell 206B · John Day, OR · Accident · No injuries · Limited investigation · Final report · Jul 13, 1983 · N2202F · Substantial damage > The rotorcraft pitched up, yawed right, made 180 degree turnand landed hard after the pilot experienced sunglare during initial climb. The pilot stated that while departing the grass strip for aerial application, the sun burst from behind acloud & blinded him… - [NTSB LAX83LA332](https://openairdocs.org/ntsb/LAX83LA332.md): Grumman G-164A · Buckeye, AZ · Accident · Minor injuries · Limited investigation · Final report · Jul 13, 1983 · N9863 · Substantial damage > After takeoff the acft flew about 1/4 mile when the engine started running rough. The pilot jettisoned his load but could not maintain alt. The acft made a forced landing in a plowed field 3/4 mile from the service strip. An examinationof the engine revealed… - [NTSB MKC83LA154](https://openairdocs.org/ntsb/MKC83LA154.md): Piper PA-38-112 · Farragut, IA · Accident · No injuries · Limited investigation · Final report · Jul 12, 1983 · N2446L · Substantial damage > The acft stalled into an OAT field just past the departure end of the rwy during takeoff. The pilot stated that he took off on a hot day (temperature 86 degrees) from a 1500 ft grass strip. The acft would not fly out of ground effect and fell into an OAT… - [NTSB ANC83LA124](https://openairdocs.org/ntsb/ANC83LA124.md): Cessna 185 · Sleetmute, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 12, 1983 · N70059 · Substantial damage > During an upstream takeoff toward a fish weir, the acft did not attain enough altitude to clear the fish weir and collided with the top of the weir. The acft contacted the water in a nose low attitude and the acft nosed over onto its back. - [NTSB NYC83FA172](https://openairdocs.org/ntsb/NYC83FA172.md): Piper J3C-65S · Abbot Village, ME · Accident · 2 fatal · Field investigation · Final report · Jul 11, 1983 · N42847 · Destroyed > The acft was observed to depart a pond to the south & climb over trees when the eng lost power. The acft started a rightbank as if to return to the pond & stalled into the trees. One witness heard the eng restart just before the crash. The last annual… - [NTSB ANC83LA121](https://openairdocs.org/ntsb/ANC83LA121.md): Piper PA-18 · Ninilchik, AK · Accident · No injuries · Limited investigation · Final report · Jul 11, 1983 · N1423Z · Destroyed > The plt had selected a 1500 ft area of moist sand along a beach area for his takeoff. He stated that the wind had increased from 10 to 20 KTS during his 2 1/2 hrs on the ground. Reportedly, he took off into the wind with 1 notch (10 deg) of flaps & the acft… - [NTSB FTW83LA326](https://openairdocs.org/ntsb/FTW83LA326.md): Piper PA-38-112 · Manvel, TX · Accident · No injuries · Limited investigation · Final report · Jul 10, 1983 · N91306 · Substantial damage > The acft had a reported loss of power during takeoff at about 200 ft. the flt instructor (CFI) then turned aprx 30 deg right to avoid trees & landed on rough terrain along a pipe line right-of-way. An exam of the acft & eng revealed no reason for the loss of… - [NTSB ATL83FA263](https://openairdocs.org/ntsb/ATL83FA263.md): Cessna 152 · Roopville, GA · Accident · 1 fatal · Field investigation · Final report · Jul 10, 1983 · N6597H · Destroyed > According to a witness, just after takeoff the acft began a left turn which suddenly steepened. The acft returned to a wings level attitude and a power reduction was heard. The acft again rolled into a left turn and the witness heard an increase in power. The… - [NTSB CHI83LA303](https://openairdocs.org/ntsb/CHI83LA303.md): Cessna 152 · Peoria, IL · Accident · No injuries · Limited investigation · Final report · Jul 8, 1983 · N5510P · Substantial damage > The acft was damaged in a forced landing after a power loss during takeoff. This was a dual instructional flt. The CFI stated that the engine lost power at about 100 ft AGL & he made a forced landing straight ahead. The fixed base operatorstated that… - [NTSB MKC83LA147](https://openairdocs.org/ntsb/MKC83LA147.md): Steen Skybolt · Denver, IA · Accident · Minor injuries · Limited investigation · Final report · Jul 7, 1983 · N407L · Substantial damage > The pilot stated that on departure when the aircraft was 100 to 150 feet above the ground, the engine quit. He made a left turn toward more suitable terrain and the engine started up again. Before he could get set up for a more suitable field, the engine quit… - [NTSB SEA83LA140](https://openairdocs.org/ntsb/SEA83LA140.md): Bell 205-A1 · John Day, OR · Accident · No injuries · Limited investigation · Final report · Jul 6, 1983 · N1347N · Substantial damage > The plt stated that before starting his takeoff, he hovered for aprx 20 min to get the helicopter's weight to where the acft would hover out of ground effect. The takeoff was begun with a climb speed of 45 KTS; however, the helicopter collided with trees. The… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=203 ## 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 = 350) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/350/cases?page=202 --- 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.