# 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 200 of 412 · 20,559 cases ## Cases, newest first - [NTSB CHI83LA434](https://openairdocs.org/ntsb/CHI83LA434.md): Cessna 188A · Green Springs, OH · Accident · No injuries · Limited investigation · Final report · Sep 19, 1983 · N9969G · Substantial damage > Takeoff was on rwy 36. The reported winds at findlay, OH (32MI away) were 220 deg at 12 KTS gusting 19 KTS, with an OAT of 88 deg f. the plt stated that the acft rotated normally, cleared the trees, then kept settling & wouldn't climb any more. The plt made a… - [NTSB NYC83LA246](https://openairdocs.org/ntsb/NYC83LA246.md): Cessna C175A · Succasunna, NJ · Accident · No injuries · Limited investigation · Final report · Sep 18, 1983 · N8014T · Substantial damage > The plt was planning to fly to blythville, AK, however, he made a decision to return to his original departure point due to deteriorating weather. Enroute home he decided to make a stop at easton, pa but realized during the approach he was at the wrong arpt.… - [NTSB MKC83LA219](https://openairdocs.org/ntsb/MKC83LA219.md): Mooney M20F · Benton, KS · Accident · Minor injuries · Limited investigation · Final report · Sep 18, 1983 · N7413V · Destroyed > The pilot was using rwy 34 with the winds 190 degrees at 14 KTS gusting 20 KTS. The acft lifted off to about 10 ft and mushed back to the ground. The acft crossed a ditch and a rood and contacted a 2nd ditch which knocked off its right main landing gear. - [NTSB MIA83FA233](https://openairdocs.org/ntsb/MIA83FA233.md): Beech A36 · Dog Island, FL · Accident · 1 fatal · Field investigation · Final report · Sep 18, 1983 · N6024P · Destroyed > After the plt arrived at the arpt, a person (who later witnessed the accident) drove the plt down the strip to examine the rwy. The witness asked the plt not to take off because the strip was too wet. The plt, who was a surgeon, told the witness that he had 3… - [NTSB NYC83FA245](https://openairdocs.org/ntsb/NYC83FA245.md): Beech 19A · New Cumberland, PA · Accident · 4 fatal · Field investigation · Final report · Sep 17, 1983 · N2330U · Destroyed > An operations manager stated that 3 persons came to buy a sight-seeing. Pleasure ride & the plt selected the Beech 19A. During its takeoff, witnesses observed the acft over the end of the rwy in a nose high attitude, but with very little climb rate. According… - [NTSB CHI83LU013](https://openairdocs.org/ntsb/CHI83LU013.md): Kruer Pterodactyl · Wayland, MI · Accident · Serious injuries · Final report · Sep 17, 1983 · UNREG · Substantial damage > The plt reported that during takeoff, the eng backfired & quit when the ultralight vehicle was aprx 100 ft AGL. He made a right turn to land back on the rwy. However, he stated that a slipping turn was made which 'resulted in a steep angle of attack on… - [NTSB ATL83LA372](https://openairdocs.org/ntsb/ATL83LA372.md): Piper PA-22-150 · Jonesboro, GA · Accident · No injuries · Limited investigation · Final report · Sep 17, 1983 · N7829D · Substantial damage > The acft crashed during a forced landing after the engine quit. The pilot said he had been flying in the local area and came in to practice touch and go landings. During the 2nd takeoff the engine missed. He landed and did a magneto check then another takeoff… - [NTSB DEN83LA216](https://openairdocs.org/ntsb/DEN83LA216.md): Grumman G-164A · Yuma, CO · Accident · No injuries · Limited investigation · Final report · Sep 16, 1983 · N620U · Substantial damage > The acft was observed to turn shortly after lift-off at a very low altitude. It then maneuvered to a climb attitude, but as the acft pitched nose up the eng noise was heard to get louder. The acft settled in a nose high attitude, struck powerlines & fell to… - [NTSB ANC83LA186](https://openairdocs.org/ntsb/ANC83LA186.md): Piper PA-18 · Aniak, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 16, 1983 · N1363A · Substantial damage > The acft crashed from about 5 ft AGL after the control stick came out of its mounting during takeoff. The owner of the acft stated that the retaining pin at the base of the control stick came out, which resulted in the stick dislodging from its mount. The pin… - [NTSB ANC83FA171](https://openairdocs.org/ntsb/ANC83FA171.md): Beech C-23 · Northway, AK · Accident · No injuries · Field investigation · Final report · Sep 15, 1983 · N9365S · Substantial damage > The acft nose gear collapsed during a forced landing after the engine quit at 300 ft AGL during takeoff. The plt stated the engine quit suddenly with and warning at 300 ft AGL. Witnesses on the arpt said they heard the engine misfiring and backfiring so badly… - [NTSB DEN83FTM07](https://openairdocs.org/ntsb/DEN83FTM07.md): Wormley Wizard/T-38 · Spanish Fork, UT · Accident · Minor injuries · Final report · Sep 14, 1983 · N4415V · Substantial damage > The acft collided with the ground after a stall at about 75 ft afl during takeoff. The pilot stated that he took off on runway 30 after a ground roll of about 200 ft, started to climb, and at about 75 ft noticed he was flying too slow, he felt a buffet and… - [NTSB ANC83LA185](https://openairdocs.org/ntsb/ANC83LA185.md): Cessna 185A · Aniak, AK · Accident · No injuries · Limited investigation · Final report · Sep 14, 1983 · N1688Z · Substantial damage > The plt was taking off from a strip near a camp site. Reportedly, the strip was located on a hill (level bench area) & was oriented generally in a north/south direction. The plt reported that the wind was from 080 deg at about 15 gusting 18 KTS. The acft was… - [NTSB CHI83IA425](https://openairdocs.org/ntsb/CHI83IA425.md): Fairchild FH-227 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Sep 13, 1983 · N377NE · Minor damage > After taking off, the landing gear handle remained latched 'down' when the nosewheel did not center. The flightcrew thenused the nose gear steering override sw & turned the nosewheel until the 'off center light' extinguished. The override sw was placed 'off'… - [NTSB LAX83FA434](https://openairdocs.org/ntsb/LAX83FA434.md): Piper PA-28-140 · Big Bear, CA · Accident · 1 fatal · Field investigation · Final report · Sep 11, 1983 · N56513 · Substantial damage > According to the plt, after a runup, during which the mixture was 'leaned', the acft departed rwy 25 at Big Bear airport. He stated that the nose of the acft was lowered to 'gain 80 KTS IAS,' and that the acft 'climbed to approximately 150 to 200 ft above the… - [NTSB ANC83LA168](https://openairdocs.org/ntsb/ANC83LA168.md): Cessna 207 · Umiat, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 1983 · N1619U · Substantial damage > The acft collided with the ground after the pilot lost control of it during takeoff. The flt started as an air taxi operation but when the pilot was unsuccessful in 2 takeoff attempts he off loaded his passengers unto another acft. This stol modified acft… - [NTSB NYC83LA239](https://openairdocs.org/ntsb/NYC83LA239.md): Beech A23 · Manchester, NH · Accident · No injuries · Limited investigation · Final report · Sep 10, 1983 · N3501R · Substantial damage > The acft collided with VASI lights during an emergency landing. The pilot was making touch & go landings. On the 4th takeoff the engine lost power at 150 ft. the pilot switched the fuel selector to left tank and the engine regained power. In maneuvering at… - [NTSB MIA83FA226](https://openairdocs.org/ntsb/MIA83FA226.md): Cessna C-114A · Ft. Lauderdale, FL · Accident · Serious injuries · Field investigation · Final report · Sep 10, 1983 · N256EL · Destroyed > The acft crashed while maneuvering at low airspeed and altitude right after takeoff. The plt said the left engine started losing power intermittently at 90 KTS. The plt had rotated the acft and tried to continue the takeoff. He was cleared to land on any rwy… - [NTSB LAX83LA432](https://openairdocs.org/ntsb/LAX83LA432.md): Piper PA23-150 · San Diego, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 10, 1983 · N2180P · Substantial damage > The student & instructor (CFI) were practicing touch & go landings. During takeoff from the 4th touch & go, the left eng lost power while climbing thru about 200 ft AGL. The CFI took control of the acft. At about the same time, the student saw oil coming from… - [NTSB LAX83FUJ16](https://openairdocs.org/ntsb/LAX83FUJ16.md): Semco Challenger · Tucson, AZ · Accident · Serious injuries · Final report · Sep 10, 1983 · N8554N · No damage > The pilot was outside the basket when the balloon took off. He grabbed the deflation handle and the balloon carried him aloft. He fell from about 40 ft AGL onto his head and was seriously injured. The pilot reportedly was going to tether the balloon. During… - [NTSB ANC83FA167](https://openairdocs.org/ntsb/ANC83FA167.md): Piper PA-18 · Kotzebue, AK · Accident · 1 fatal · Field investigation · Final report · Sep 10, 1983 · N3421P · Destroyed > The plt & his wife had flown to an area where she had seen a caribou that she wanted to shoot. After landing on a gravel bar, she shot the caribou, but then complained of a bad headache & vision problems. The plt reported that they loaded the meat & horns in… - [NTSB NYC83FHD05](https://openairdocs.org/ntsb/NYC83FHD05.md): Hughes 269C · Philadelphia, PA · Accident · Minor injuries · Final report · Sep 9, 1983 · N1103K · Substantial damage > The helicopter collided with a steel drainage culvert hidden in the grass and rolled over during a simulated high alt running takeoff. This was an instructional flt. The skid hit the culvert which extended about 3-4 inches AGL, 3 ft of the skid broke off and… - [NTSB ANC83LA166](https://openairdocs.org/ntsb/ANC83LA166.md): de Havilland DHC-2 · Port Alsworth, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1983 · N30ST · Substantial damage > The acft collided with a mud bank and crashed. The weather was VMC and a VFR flt plan was filed. The float acft was damaged in the accident but the seven occupants escaped injury. The pilot stated that shortly after takeoff he struck anembankment lost… - [NTSB ANC83LA165](https://openairdocs.org/ntsb/ANC83LA165.md): Cessna 185 · Kaktovik, AK · Accident · No injuries · Limited investigation · Final report · Sep 9, 1983 · N93282 · Substantial damage > The plt stated that the acft was loaded with 3 hunters & their gear for a flt from caribou pass to the barter island dew station arpt. Reportedly, he had operated in & out of the area on previous occasions with similar loads & conditions. He stated that he… - [NTSB LAX83LA427](https://openairdocs.org/ntsb/LAX83LA427.md): Beech H18S · Kailua-Kona, HI · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 1983 · N2990F · Destroyed > About 1 min after takeoff, between 400-500 ft MSL & during the first power reduction, the right eng backfired. Followingsome more violent backfires the RPM went to zero. The right eng was restarted but the same result occurred. The plt attempted to feather… - [NTSB ATL83FKG13](https://openairdocs.org/ntsb/ATL83FKG13.md): Cessna 188B · Luddwici, GA · Accident · No injuries · Final report · Sep 8, 1983 · N73113 · Destroyed > The acft crashed into trees and burned during a takeoff attempt on a country road with 120 gallons of aerial spray on board. This was the 1st takeoff after lunch and the plt said the acft seemed'glued to the road'. Seeing that he was going to impact wires he… - [NTSB CHI83FA419](https://openairdocs.org/ntsb/CHI83FA419.md): Warren Moneri S · Lapeer, MI · Accident · 1 fatal · Field investigation · Final report · Sep 7, 1983 · N275HW · Destroyed > The glider collided with the ground after an unscheduled tow release at about 150 ft AGL.this was the plts first flt in this acft after having the engine removed and the acft recertified as a glider. Ground personnel observed the glider and tow pilot release… - [NTSB ATL83LA354](https://openairdocs.org/ntsb/ATL83LA354.md): Bell 47G · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Sep 7, 1983 · N88754 · Substantial damage > The helicopter settled after takeoff and rolled over after touching down on sloping terrain. One of the two pilots aboard was being transported to receive a private rating in helicopters. He had been endorsed for solo in the Bell 47 and had flown the Bell 47… - [NTSB MIA83LA222](https://openairdocs.org/ntsb/MIA83LA222.md): Bucker Flugzeugbau Casa 1-131E · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Sep 6, 1983 · N2305Z · Substantial damage > Shortly after tkof the eng lost pwr and the pilot was forced to execute an emerg lndg. The main landing gear collapsed during touchdown on a highway. During the subsequent engine teardown the magneto timing was found to be retarded 24 degrees on the left… - [NTSB MIA83LA221](https://openairdocs.org/ntsb/MIA83LA221.md): Piper PA-25-260 · Quebradillas, PR · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1983 · N8576L · Destroyed > On 9/4/83, the plt took off from arecibo, PR on a flt of aprx 26 mi to aguadilla, PR. While en route, the eng lost power from fuel exhaustion & the plt made a successful forced landing on a farm at Quebradillas, PR. The acft was refueled, but during takeoff… - [NTSB ATL83LA349](https://openairdocs.org/ntsb/ATL83LA349.md): Johnston Long E-Z · Pell City, AL · Accident · Serious injuries · Limited investigation · Final report · Sep 5, 1983 · N82CJ · Substantial damage > The acft crashed while attempting a downwind takeoff in high winds and heavy rain. The pilot said he was trying to take off before the heavy rain so he picked a rwy pointing into clear weather but with a tailwind. The tailwind increased during the takeoff… - [NTSB NYC83LA236](https://openairdocs.org/ntsb/NYC83LA236.md): Republic RC-3 · Gilderland, NY · Accident · No injuries · Limited investigation · Final report · Sep 4, 1983 · N6191K · Substantial damage > On the day before the accident, an emergency landing was made in a hay field after the eng lost power. An exam of the acft revealed a defective fuel line. The fuel line was repaired. During a ground run-up, the eng produced full power & the magneto check was… - [NTSB LAX83FA422](https://openairdocs.org/ntsb/LAX83FA422.md): Piper PA-28R-200 · Calexico, CA · Accident · No injuries · Field investigation · Final report · Sep 4, 1983 · N56283 · Substantial damage > The plt reported that during takeoff, the eng began to miss at aprx 300 ft AGL & he felt a definite loss of power. He tried to raise the gear, but the airspeed was below the automatic gear extenstion speed, so the gear did not retract. He repositioned the… - [NTSB FTW83FA416](https://openairdocs.org/ntsb/FTW83FA416.md): Cessna 421C · Altus, OK · Accident · 8 fatal · Field investigation · Final report · Sep 4, 1983 · N111FN · Destroyed > The plt initiated a takeoff on a hot afternoon with 7 passengers on board. Shortly after left-off, 2 witnesses observed what they described as a puff of black smoke from the right eng. According to witnesses, the acft rurned to the left before crossing the… - [NTSB ANC83LA163](https://openairdocs.org/ntsb/ANC83LA163.md): Aeronca 7AC Champ · Seldovia, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 1983 · N3124E · Substantial damage > The acft overturned on takeoff due to turbulent wind conditions. The pilot reported the wind was from 243 degrees at 16 KTS. No gusts. He stated also that severe turbulence existed and contributed to the accident. The arpt manager said thatthe acft took off… - [NTSB FTW83LA414](https://openairdocs.org/ntsb/FTW83LA414.md): Grumman G-164A · Morse, LA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1983 · N7699 · Substantial damage > During a climbing turn after takeoff, the eng lost power & started smoking lightly. The plt dumped his chemical load & was able to clear a set of power lines. He then made a forced landing in a flooded rice field where the acft nosed over. An investigation… - [NTSB CHI83LA412](https://openairdocs.org/ntsb/CHI83LA412.md): Piper PA-15 · Houghton Hts., MI · Accident · No injuries · Limited investigation · Final report · Sep 3, 1983 · N4142H · Destroyed > During takeoff, the acft entered a steep right turn & subsequently, the right wing struck a tree & the plane crashed. The acft was being flown by the owner, who did not possess an FAA plt or medical certificate. According to him, the acft entered a 'downdraft… - [NTSB NYC83LA233](https://openairdocs.org/ntsb/NYC83LA233.md): Cessna 140 · Windham, NH · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1983 · N77022 · Substantial damage > The eng quit during takeoff & the acft crashed into trees. The plt admitted having used 87 octane automotive no-lead gasoline in the acft. - [NTSB FTW83LA412](https://openairdocs.org/ntsb/FTW83LA412.md): Cessna 421C · Port Lavaca, TX · Accident · No injuries · Limited investigation · Final report · Sep 2, 1983 · N87546 · Substantial damage > The acft collided with a fence and bushes during takeoff. The rwy was shell and turf construction 2300 ft long. The plt figured the takeoff distance from a chart using dry hard surfaced level rwy. The acceleration seemed slow according to a witness and the… - [NTSB ANC83LA164](https://openairdocs.org/ntsb/ANC83LA164.md): Piper J-3 · Aleknagik, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1983 · N98172 · Substantial damage > According to the pilot, during takeoff the right wing struck some tall brush. The pilot held no certificates or ratings but said he had about 50 or 60 hours of flight time. - [NTSB MKC83FA209](https://openairdocs.org/ntsb/MKC83FA209.md): Piper PA-36-375 · Unionville, MO · Accident · 1 fatal · Field investigation · Final report · Sep 1, 1983 · N3819E · Destroyed > The acft was observed to turn 45 deg to the left after takeoff and when a short distance past the south end of the runway initiated a turn right as if to land on runway 35. As the acft became aligned with runway 35, the right wing dropped, the acft entered a… - [NTSB FTW83FA409](https://openairdocs.org/ntsb/FTW83FA409.md): Beech 95-A55 · Houston, TX · Accident · 2 fatal · Field investigation · Final report · Sep 1, 1983 · N1599S · Destroyed > Immediately after takeoff the acft lost power on the right eng & the acft pulled up steeply, rolled to the right & impacted in an inverted position. Teardown of the right eng did not reveal any preimpact failure or malfunction. The l & r eng fuel selectors… - [NTSB CHI83LA406](https://openairdocs.org/ntsb/CHI83LA406.md): Edwards Mitchell P-38 · Sheridan, MI · Accident · Serious injuries · Limited investigation · Final report · Sep 1, 1983 · N81TE · Substantial damage > The acft nosed down in a crop of corn during a forced landing after the engine lost power at 200 ft AGL during takeoff climb. During the turn back to the airstrip the left wing stalled. The pilot said he recovered about 10 ft AGL but the corn stalks slowed… - [NTSB FTW83LA405](https://openairdocs.org/ntsb/FTW83LA405.md): Grumman G-164B · East Bernard, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 31, 1983 · N48687 · Substantial damage > During takeoff, the eng had a partial loss of power after the acft lifted off. The plt reported that he dumped his load of defoliant, but the acft would not climb. Subsequently, it settled & collided with brush & trees. The plt attributed the power loss to a… - [NTSB FTW83LA404](https://openairdocs.org/ntsb/FTW83LA404.md): Aero Commander S2R · Katy, TX · Accident · No injuries · Limited investigation · Final report · Aug 30, 1983 · N3696X · Substantial damage > The acft was damaged in a forced landing following engine failure after takeoff. The plt stated that a supercharger bearing failure caused the engine to fail. During the landing in a flooded rice field the landing gear collapsed. - [NTSB MKC83LA204](https://openairdocs.org/ntsb/MKC83LA204.md): Grumman American AA-B · Bucklin, KS · Accident · No injuries · Limited investigation · Final report · Aug 29, 1983 · N9620L · Substantial damage > The plt took off with a near full load of fuel. An adult passenger was in the right seat & a child was seated in the baggage compartment, which was not an approved seat. The density altitude at the arpt was aprx 4100 ft. the plt indicated that he rotated for… - [NTSB MKC83LA206](https://openairdocs.org/ntsb/MKC83LA206.md): Prell Quickie · Waldron, MO · Accident · No injuries · Limited investigation · Final report · Aug 28, 1983 · N69KP · Substantial damage > The acft collided with the ground during an attempted takeoff. The pilot stated he had installed a new propeller that was expected to improve takeoff and climb performance. He said the acft got airborne, but would not climb. By the time he decided that the… - [NTSB FTW83LA423](https://openairdocs.org/ntsb/FTW83LA423.md): Cessna 152 · Opelousas, LA · Accident · Minor injuries · Limited investigation · Final report · Aug 28, 1983 · N89575 · Destroyed > After aborting 3 tkofs from a short grass strip the plt decided the grass was too long. Aft mowing the grass and an additional area to extend the length of the strip the plt took off alone to see if the length was suitable for takof. The plt then lndd and… - [NTSB FTW83FU004](https://openairdocs.org/ntsb/FTW83FU004.md): Pterodactyl Ascender II+ · Haskell, OK · Accident · 1 fatal · Final report · Aug 27, 1983 · UNREG · Substantial damage > The plt & his instructor were departing the airport in separate ultralight vehicles to proceed on a x-country flt for a fly-in. The instructor saw the plt takeoff, but lost sight of him moments later & did not see the accident. However, an eye witness stated… - [NTSB ATL83LA342](https://openairdocs.org/ntsb/ATL83LA342.md): Air & Space 18-A · Murray, KY · Accident · No injuries · Limited investigation · Final report · Aug 27, 1983 · N6155S · Substantial damage > Aprx 400 ft AGL, while executing a jump takeoff and a right turn, the aircraft began to settle. It then struck trees and then the ground. The temperature was 100 degrees f. the pilot stated that more attention should have been paid to ambient conditions. - [NTSB SEA83LA185](https://openairdocs.org/ntsb/SEA83LA185.md): Cessna 140 · College Place, WA · Accident · Serious injuries · Limited investigation · Final report · Aug 26, 1983 · N90037 · Destroyed > The acft collided with power line poles during an emergency landing. The pilot reported a power loss during takeoff and witnesses reported that the engine was sputtering during takeoff and quit during climb out. Post accident investigation showed the acft… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=201 ## 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=200 --- 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.