# 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 203 of 412 · 20,559 cases ## Cases, newest first - [NTSB CHI83LA297](https://openairdocs.org/ntsb/CHI83LA297.md): Hiller UH-12E · Brooten, MN · Accident · No injuries · Limited investigation · Final report · Jul 5, 1983 · N4028K · Substantial damage > The helicopter had just lifted off of the flatbed of a truck when it started to spin. The plt lowered the collective, reduced the power & landed beside the truck. During touchdown, the main rotor blades struck the truck. An investigation revealed that the… - [NTSB CHI83LA296](https://openairdocs.org/ntsb/CHI83LA296.md): Piper PA-28-150 · Kelleys Island, OH · Accident · No injuries · Limited investigation · Final report · Jul 5, 1983 · N5782W · Substantial damage > The acft lost power on takeoff and collided with trees about 1/4 mile off the end of the rwy. The pilot said he prefltedand removed about 1/2 ounce of water from each tank, none from the gascolator. Inspection after the accident revealed water in the… - [NTSB CHI83IA299](https://openairdocs.org/ntsb/CHI83IA299.md): Douglas DC-8 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jul 5, 1983 · N8091U · No damage > Shortly after takeoff during initial climb the no 1 engine failed and an engine fire erupted. The crew discharged 2 firebottles and extinguished the fire. The acft returned to the field and landed without further incident. The no 1 engine 1st stage compressor… - [NTSB LAX83FUM08](https://openairdocs.org/ntsb/LAX83FUM08.md): Clark Super Q2 · San Diego, CA · Accident · 1 fatal · Final report · Jul 4, 1983 · N401JC · Destroyed > The hoem built acft was constructed using the basic design of the Q2, a 2 palce plane with a canard. However, it was built with signigicant design changes. These included a 2nd elevator which created at-tail. The 2nd elevator was operated by a handle which… - [NTSB ATL83LA254](https://openairdocs.org/ntsb/ATL83LA254.md): Taylorcraft BL-65 · Angier, NC · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1983 · N23626 · Substantial damage > The acft collided with the ground in a nose low attitude just off the end of the rwy after a touch and go landing. Ground witnesses saw the acft make a touch and go landing, pull up, and saw a wing drop as the acft nosed down to the ground. The plt-owner was… - [NTSB FTW83LA317](https://openairdocs.org/ntsb/FTW83LA317.md): Grumman AA-1B · Jefferson, TX · Accident · No injuries · Limited investigation · Final report · Jul 3, 1983 · N9857L · Substantial damage > The acft collided with small trees and two fences during takeoff and nosed down into the ground. A witness noticed the acft wobbling in the air at low alt before the collision with the trees. The density alt was 2800 ft. there were no mechanical malfunctions. - [NTSB CHI83FA291](https://openairdocs.org/ntsb/CHI83FA291.md): Piper PA-22 · Rogers, OH · Accident · 2 fatal · Field investigation · Final report · Jul 3, 1983 · N8914C · Destroyed > The acft collided with trees immediately after takeoff. The acft was 20 lbs under max gross weight. Density alt was 2,500 ft. - [NTSB MKC83LA141](https://openairdocs.org/ntsb/MKC83LA141.md): Piper PA-36 · St. Paul, NE · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N57748 · Substantial damage > The plt stated that when he was unable to get takeoff speed he dumped his load, then hit a fence & fence posts. The acftwas estimated to be within the CG & gross weight limits. Two inspections of the eng revealed no malfunctions. - [NTSB MKC83LA140](https://openairdocs.org/ntsb/MKC83LA140.md): Balloon Works Fire FLY 7 · Ellsworth, KS · Accident · Serious injuries · Limited investigation · Final report · Jul 2, 1983 · N1531N · Substantial damage > The Balloon collided with a radio tower during takeoff. The wind was reported to be from 180 degrees at 12-18 KTS. There is no evidence that this plt received weather briefing. This Balloon was launched closer to the tower than any of the other balloons… - [NTSB MIA83LA193](https://openairdocs.org/ntsb/MIA83LA193.md): Lake LA-4 · Gainesville, FL · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N1FQ · Substantial damage > The plt stated that during takeoff, the eng appeared to lose power at about 200 ft AGL, but the gauges showed no malfunction. The acft began to settle, so he elected to land on the rwy overrun area. Reportedly, the acft was landed successfully, however, while… - [NTSB ATL83LA257](https://openairdocs.org/ntsb/ATL83LA257.md): Cessna A188B · Prattville, AL · Accident · No injuries · Limited investigation · Final report · Jul 2, 1983 · N9381G · Substantial damage > The acft collided with a cow during takeoff for an aerial application flt. The collision broke off the right main landing gear and killed the cow. The pilot stated that the cow got through the fence and wandered onto the strip. The airstrip has a small rise… - [NTSB FTW83LA314](https://openairdocs.org/ntsb/FTW83LA314.md): I.C.A. Brasov IS-2902 · Katy, TX · Accident · No injuries · Limited investigation · Final report · Jun 30, 1983 · N4999K · Substantial damage > The glider collided with a ditch during a forced landing after the tow rope disconnected shortly after takeoff. The plt was not able to avoid the ditch during landing due to a strong sink rate. The tow hook assembly was examined after the accident and no… - [NTSB NYC83LA158](https://openairdocs.org/ntsb/NYC83LA158.md): Piper PA-23-250 · Pittsfield, MA · Accident · No injuries · Limited investigation · Final report · Jun 29, 1983 · N6638Y · Substantial damage > On the 1st takeoff, the CFI demonstrated an aborted takeoff by placing the rt selector gasoline valve in the off position and had the student pull the eng back, making a landing on the rwy. The flt then taxied back for another takeoff, again the CFI shut off… - [NTSB ANC83LA117](https://openairdocs.org/ntsb/ANC83LA117.md): Stinson 108-1 · Nenana, AK · Accident · No injuries · Limited investigation · Final report · Jun 29, 1983 · N8205K · Substantial damage > The acft nose gear failed during a forced landing after the engine lost power during climbout. The plt rptd the engine began to run intermittently then quit completely. The acft had just been serviced with 36 gallons of 80/87 octane fuel. The student pilot… - [NTSB FTW83LA304](https://openairdocs.org/ntsb/FTW83LA304.md): Piper PA-22 · Langley, OK · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1983 · UNREG · Destroyed > The non-rated plt stated that the eng lost power after he took off & he was unable to restart the eng. During a forced landing, he was unable to clear over wires. He said the nosewheel hit the ground & the acft tumbled as he was attempting to glide under the… - [NTSB ANC83FA107](https://openairdocs.org/ntsb/ANC83FA107.md): Rotec Engineering 3A · Fairbanks, AK · Accident · No injuries · Field investigation · Final report · Jun 27, 1983 · N397RE · Substantial damage > The plt & a passenger were on a sales demonstration flt in the two-place, home built, ultralight acft. During takeoff, the acft mushed into power lines after attaining an altitude of aprx 30 ft. according to the plt, there was a loss of power during takeoff.… - [NTSB FTW83LA293](https://openairdocs.org/ntsb/FTW83LA293.md): Globe GC-1B · Marion, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 26, 1983 · N7BL · Substantial damage > The acft collided with fences during a forced landing after an engine fuel fire. The left exhaust pipe failed and the misdirected heat burned through a fuel line. The fuel ignited filling the cockpit with smoke. The engine quit due to fuel starvation and the… - [NTSB DEN83FA152](https://openairdocs.org/ntsb/DEN83FA152.md): Cessna U206 · Cortez, CO · Accident · 2 fatal · Field investigation · Final report · Jun 25, 1983 · N5413X · Destroyed > The plt filed a company VFR flt plan & took off at aprx 0930 MDT on a return flt to farmington, NM. According to a surviving passenger, after departing blanding, the acft entered low clouds. Reportedly, the plt flew in the clouds for a period of time until he… - [NTSB ANC83LA128](https://openairdocs.org/ntsb/ANC83LA128.md): Piper PA-11 · Kasilof, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 25, 1983 · N4523M · Substantial damage > The acft collided with trees and crashed during takeoff. The plt stated he made several attempts to get airborne in bothdirections from the strip and when he finally got airborne he struck a tree and crashed. The plt statements varied during several… - [NTSB MIA83LA166](https://openairdocs.org/ntsb/MIA83LA166.md): Ercoupe 415-C · Yulee, FL · Accident · No injuries · Limited investigation · Final report · Jun 24, 1983 · N2045H · Substantial damage > The plt stated that during takeoff, the acft entered a 'right turn' after it had climbed appx 25 ft above the rwy. Reportedly, full control inputs to the left failed to correct the right bank. When the plt saw the acft heading for trees to the right, he… - [NTSB DEN83LTE11](https://openairdocs.org/ntsb/DEN83LTE11.md): Eipper Formance MX-2 · Granby, CO · Accident · Minor injuries · Final report · Jun 24, 1983 · N3133L · Substantial damage > The ultralight nosed down during an emergency landing after the engine lost power at about 100' AGL after takeoff. The pilot attempted a landing on the remaining rwy after the power loss, but the acft could not be flared and ended up on the rwy partially… - [NTSB CHI83LA278](https://openairdocs.org/ntsb/CHI83LA278.md): Cessna 150H · Germantown, OH · Accident · Minor injuries · Limited investigation · Final report · Jun 24, 1983 · N22521 · Destroyed > The acft struck a fence during takeoff. The plt said he rotated too soon and was unable to remain airborne. When the acft collided with the fence it cartwheeled, resulting in engine separation and near separation of the empennage. The wind was reported as… - [NTSB NYC83LA150](https://openairdocs.org/ntsb/NYC83LA150.md): MBB BO-105 · Nantucket, MA · Accident · Minor injuries · Limited investigation · Final report · Jun 23, 1983 · N2908U · Substantial damage > The helicopter made a hard landing during an aborted takeoff following a medical evacuation demonstration at Nantucket. After the presentation the acft was changed from a 2 litter configuration. The pilot noted that the cyclic retention cap was on the cyclic… - [NTSB DEN83FA150](https://openairdocs.org/ntsb/DEN83FA150.md): Lake LA-4-200 · Gillette, WY · Accident · 1 fatal · Field investigation · Final report · Jun 23, 1983 · N6029V · Destroyed > The plt had recently purchased the acft. While on a x-country trip, he landed at an arpt with an elevation of 4363 ft & refueled. When he was taking off, the density alt was aprx 7089 ft & the acft was near its max gross wt limit. Shortly after lift-off, the… - [NTSB CHI83LA277](https://openairdocs.org/ntsb/CHI83LA277.md): Cessna 188B · Campbell Hill, IL · Accident · No injuries · Limited investigation · Final report · Jun 23, 1983 · N731KY · Substantial damage > After taking off from a haul road, which was being used as an airstrip, the acft began climbing. At about 100 ft AGL, the plt noted a loss of power (thrust) as the eng began to overspeed. The plt lowered the nose to gain airspeed & dumped his load, but was… - [NTSB NYC83FA148](https://openairdocs.org/ntsb/NYC83FA148.md): Cessna 177 · Great Bend, PA · Accident · 2 fatal · Field investigation · Final report · Jun 22, 1983 · N2293Y · Destroyed > The owner of the acft reported the flight was unauthorized. He stated that during takeoff the eng quit and the plt made a right turn back to the field. Before the turn was completed, the acft stalled and plunged to the ground. Examination revealed that the… - [NTSB NYC83LA147](https://openairdocs.org/ntsb/NYC83LA147.md): Beech BE-23 · Shelburne, VT · Accident · Minor injuries · Limited investigation · Final report · Jun 21, 1983 · N2389Z · Substantial damage > The acft crashed into a ditch during an emergency landing after a power loss. The dual instructional flight was climbingat about 200 feet when the power dropped 700-800 RPM. The pilot applied carb heat switched fuel tanks and turned to avoid a housing area.… - [NTSB DEN83FA149](https://openairdocs.org/ntsb/DEN83FA149.md): Cessna T210M · Englewood, CO · Accident · No injuries · Field investigation · Final report · Jun 21, 1983 · N761AU · Substantial damage > The acft made a forced landing after the engine lost power during takeoff climb. The pilot had leaned the mixture prior to takeoff. The checklist calls for full rich. When the pilot reduced power after takeoff the engine started detonating and lost power.… - [NTSB MKC83FA130](https://openairdocs.org/ntsb/MKC83FA130.md): Cessna 172N · South Fork, MO · Accident · 1 fatal · Field investigation · Final report · Jun 19, 1983 · N1298F · Destroyed > Takeoff was from a farm strip 1,600 ft long with grass 8 to 10 inches high. There are trees about 800 ft south of the south end of the strip. The acft took off to the south & made a left turn. After turning about 135 deg the bank abruptlysteepened, the nose… - [NTSB ATL83FA232](https://openairdocs.org/ntsb/ATL83FA232.md): Stinson 108-2 · Laytonsville, MD · Accident · Minor injuries · Field investigation · Final report · Jun 19, 1983 · N9673K · Substantial damage > The acft lost power at about 200 ft AGL during takeoff. The pilot had just aborted a takeoff because the power went to idle with throttle open. After a run-up of 30 seconds he decided to try again. The power loss occurred at about 200 ft AGL and the pilot… - [NTSB DEN83LA147](https://openairdocs.org/ntsb/DEN83LA147.md): Cessna 150 · Red Owl, SD · Accident · No injuries · Limited investigation · Final report · Jun 18, 1983 · N6418F · Substantial damage > Before the flt the student pilot had checked the fuel by the gages only and had not drained the fuel sumps. He thought he had enough fuel to fly from the ranch to the training school arpt to refuel. The engine quit at 100 ft AGL after takeoff. About 1-1/2… - [NTSB CHI83LA273](https://openairdocs.org/ntsb/CHI83LA273.md): Cessna 172 · Fraser, MI · Accident · Minor injuries · Limited investigation · Final report · Jun 18, 1983 · N8430E · Destroyed > The eng lost power on takeoff & the acft struck trees as the plt was attempting to return to the aprt. The center electrodes of the spark plugs were worn & covered with carbon. None of the plugs would fire above 55 PSI when put in a champion fire testor.… - [NTSB DEN83FTM05](https://openairdocs.org/ntsb/DEN83FTM05.md): Bensen B-8M · Wendover, UT · Accident · Serious injuries · Final report · Jun 17, 1983 · N67037 · Substantial damage > The gyrocopter collided with a powerline at 29 ft AGL. The pilot took off from a road and in proceeding along the road collided with the wires. The pilot was seriously injured. His student pilot certificate had expired in dec. 1979. Due tohis injuries no… - [NTSB CHI83LA264](https://openairdocs.org/ntsb/CHI83LA264.md): Bell 47-G3B · Litchfield, MN · Accident · No injuries · Limited investigation · Final report · Jun 17, 1983 · N8471E · Substantial damage > The helicopter rolled over while attempting a takeoff after servicing from a truck platform for a spraying operation. The hose used to put the chemical spray into the hopper was not removed. When takeoff was attempted the acft was tethered to the ground rig… - [NTSB FTW83LA290](https://openairdocs.org/ntsb/FTW83LA290.md): Cessna 152 · Arlington, TX · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1983 · N25838 · Substantial damage > The student was departing on a solo x-country flt. He reported that immediately after becoming airborne, directional control was lost & the acft swerved to the left. Full right rudder was applied, but directional control was not regained. As the plt reduced… - [NTSB FTW83LA281](https://openairdocs.org/ntsb/FTW83LA281.md): Cessna 172I · Forrest City, AR · Accident · Minor injuries · Limited investigation · Final report · Jun 16, 1983 · N35520 · Destroyed > The acft experienced power failure from about 20 feet AGL during takeoff from a private grass strip. A witness heard theengine spit and pop during the takeoff roll. He said it sounded just like his old pickup when it runs out of gas. After the accident the… - [NTSB LAX83LA288](https://openairdocs.org/ntsb/LAX83LA288.md): Air Tractor AT 301 · Yuma, AZ · Accident · No injuries · Limited investigation · Final report · Jun 15, 1983 · N4337S · Substantial damage > The plt reported that he landed on a farm road to inspect the alternator & associated wiring before starting aerial application. Following the inspection, during which nothing was found wrong, he commenced taking off. As the acft was accelerating for takeoff,… - [NTSB ATL83LA229](https://openairdocs.org/ntsb/ATL83LA229.md): Ayres S-2R · Arlington, GA · Accident · No injuries · Limited investigation · Final report · Jun 15, 1983 · N30878 · Destroyed > During the takeoff roll, the acft had nearly reached its lift-off speed when the eng backfired. The plt shut down the eng, dumped the chemicals & stopped on the rwy. He then exited the acft. As he walked around the acft, he smelled a strong odor of fuel. He… - [NTSB ANC83LA098](https://openairdocs.org/ntsb/ANC83LA098.md): Cessna 185 · Kenai, AK · Accident · Minor injuries · Limited investigation · Final report · Jun 14, 1983 · N2565Z · Substantial damage > The acft had an external load of plywood attached to its floats. The pilot stated that the acft lost power after takeoff. He made a right turn back toward the lake and the acft stalled. The pilot was recovering from the spin when the floats hit the water.… - [NTSB CHI83LA255](https://openairdocs.org/ntsb/CHI83LA255.md): Grumman G-164A · Crookston, MN · Accident · No injuries · Limited investigation · Final report · Jun 13, 1983 · N8595H · Destroyed > The acft collided with the ground after takeoff. The pilot said the acft lost power and felt sloppy at about 350 ft AGL.he added power but maximum obtainable was 2000 RPM as opposed to 2300. The pilot said he tried to drop the load but the load remained with… - [NTSB ANC83LA097](https://openairdocs.org/ntsb/ANC83LA097.md): Piper PA-32-300 · Quinhagak, AK · Accident · No injuries · Limited investigation · Final report · Jun 13, 1983 · N15400 · Substantial damage > At about 50-70 ft AGL the eng quit. The acft landed about 1,500 ft off the end of the rwy. The plt stated the acft had been refueled from 50 gal drums immediately prior to the flt. The fuel in the right tip tank contained enough water to have caused eng… - [NTSB NYC83FA142](https://openairdocs.org/ntsb/NYC83FA142.md): Piper PA-18A-150 · Collegeville, PA · Accident · 2 fatal · Field investigation · Final report · Jun 12, 1983 · N783L · Destroyed > During takeoff, the acft was observed to enter a steep climb after making a short takeoff roll. One witness estimated that the takeoff roll was about 400 ft & then the acft entered a climb at aprx a 35 deg angle. After reaching an altitude of about 200 to 300… - [NTSB NYC83FGM03](https://openairdocs.org/ntsb/NYC83FGM03.md): Piper J3C · Greenville, PA · Accident · Serious injuries · Final report · Jun 11, 1983 · N13DK · Destroyed > According to the plt, a cert A&P mechanic, he had flown the acft 1 hr since last inspection & everything operated normally. On the day of the accident, his wife, also a plt, departed their private arpt at mercer, PA on a local flt butlanded at Greenville 15… - [NTSB NYC83FA141](https://openairdocs.org/ntsb/NYC83FA141.md): Beech K35 · Ridgefield, CT · Accident · 4 fatal · Field investigation · Final report · Jun 11, 1983 · N9554R · Destroyed > Shortly after takeoff, several witnesses heard unusual sounds from the acft. One stated that he heard a sputtering noise & the eng stopped, then it restarted, but was not smooth. The other 2 witnesses heard a backfiring or sputtering noise. Subsequently, the… - [NTSB ATL83LA227](https://openairdocs.org/ntsb/ATL83LA227.md): Aero Commander Callair A-9 · Florala, AL · Accident · No injuries · Limited investigation · Final report · Jun 11, 1983 · N7284V · Substantial damage > The plt reported that during takeoff, the eng began to lose power at the edge of the arpt. He noted that fuel pressure was lost & reported that he was unable to regain the pressure with the electric fuel pump. He switched the fuel selector to the fullest… - [NTSB ANC83FA095](https://openairdocs.org/ntsb/ANC83FA095.md): Cessna C-188 · Noatak, AK · Accident · No injuries · Field investigation · Final report · Jun 11, 1983 · N731CN · Substantial damage > The acft collided with the runway at the mid-point in a 30 degree nose low attitude during takeoff. According to the pilot the takeoff was started at the north end of the 5000 foot runway and after 500 feet the acft lifted off normally. The pilot then relaxed… - [NTSB FTW83LA278](https://openairdocs.org/ntsb/FTW83LA278.md): Cessna 188 · Tucker, AR · Accident · No injuries · Limited investigation · Final report · Jun 10, 1983 · N731VF · Substantial damage > This was the first loaded departure from the short, rutted strip which had power lines across each end. During takeoff the plt realized he was going to clear the power line & started to dump the load. However, the fertilizer would not dumpfast enough. The plt… - [NTSB ANC83FA096](https://openairdocs.org/ntsb/ANC83FA096.md): Cessna 180 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jun 10, 1983 · N2483F · Substantial damage > The plt of the float plane reported that he initiated his takeoff from lake hood toward the southeast with a 'canal option.' He stated that during the takeoff, he pulled the acft into the air before reaching the canal, then started a left turn toward the… - [NTSB SEA83FA121](https://openairdocs.org/ntsb/SEA83FA121.md): Learjet 35 · Seattle, WA · Accident · No injuries · Field investigation · Final report · Jun 9, 1983 · N1976L · Substantial damage > The acft dragged the right wing tip tank and ruptured it after the passenger door opened during takeoff. During the aborted takeoff the acft oscillated right, left and right before making ground contact on the right wing. The highest alt attained was about… - [NTSB NYC83LA138](https://openairdocs.org/ntsb/NYC83LA138.md): Grumman American AA-1 · Mechanicsburg, PA · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 1983 · N5962L · Substantial damage > The acft crashed during takeoff and was destroyed when it slid over logs in the roll-out area. The pilot had 3 hours in the make and model of acft. Takeoff was from a private grass airstrip which was rough and uphill in the direction of takeoff. When a crash… Next page: https://openairdocs.org/ntsb-phases/350/cases.md?page=204 ## 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=203 --- 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.