# NTSB investigations: Approach 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 211 of 420 · 20,992 cases ## Cases, newest first - [NTSB SEA83LA100](https://openairdocs.org/ntsb/SEA83LA100.md): Piper PA-18-150 · Grass Valley, OR · Accident · No injuries · Limited investigation · Final report · May 16, 1983 · N7173K · Substantial damage > The aircraft stalled while the pilot was attempting to land downwind on an uphill Grass strip. The wind was estimated at 15 gusting to 20 KTS. The pilot stated that on his approach, he was to the left of the center of the landing strip. He attempted to… - [NTSB LAX83LA231](https://openairdocs.org/ntsb/LAX83LA231.md): Cessna 150M · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · May 15, 1983 · N63404 · Substantial damage > The acft collided with a powerline while on final approach and nosed over in a open field one half mile short of the runway. The pilot had flown into this arpt the morning of the accident as a pax. She decided to do some takeoffs and landings, local pilots… - [NTSB CHI83LA215](https://openairdocs.org/ntsb/CHI83LA215.md): Cessna 120 · Grandville, MI · Accident · Minor injuries · Limited investigation · Final report · May 15, 1983 · N3019N · Substantial damage > Reportedly, the plt increased the bank angle during a turn to align the acft on final apch, then the plane lost speed & stalled. Subsequently, the acft impacted the ground aprx 480 ft southwest of the rwy threshold. Aprx 10 mi east at grand rapids, MI, the… - [NTSB FTW83LA233](https://openairdocs.org/ntsb/FTW83LA233.md): Cessna 170A · Prague, OK · Accident · No injuries · Limited investigation · Final report · May 14, 1983 · N170KM · Substantial damage > While turning to base leg for landing the eng quit. With insufficient altitude to reach the arpt, the plt selected another field, but landed short in rough terrain. A large quantity of water was found in the acft's fuel tanks which wastraced to a contaminated… - [NTSB NYC83LA111](https://openairdocs.org/ntsb/NYC83LA111.md): Cessna 150L · Monroeville, PA · Accident · No injuries · Limited investigation · Final report · May 13, 1983 · N10506 · Substantial damage > The acft crashed into trees during an aborted landing. The student pilot was not injured. The weather was VMC and no fltplan was filed for this student solo flt. The pilot had set 30 degrees of flaps for landing, the pilot attempted to correct his position… - [NTSB LAX83LA228](https://openairdocs.org/ntsb/LAX83LA228.md): Cessna 150F · Chico, CA · Accident · No injuries · Limited investigation · Final report · May 13, 1983 · N8674S · Substantial damage > The student plt was practicing takeoffs & landing on a 2280 ft rwy in calm wind conditions. He reported that while on a final apch to land, the acft was high & was aprx 10 mph too fast. Before touching down & with over half of the rwy behind, the student… - [NTSB ATL83FIG04](https://openairdocs.org/ntsb/ATL83FIG04.md): Piper PA-32-260 · Laurel, MD · Accident · No injuries · Final report · May 13, 1983 · N4823T · Substantial damage > The pilot started a go-around after the acft had progressed over half way down the runway in the air. When full power was applied the engine sputtered and quit. The pilot changed fuel tanks, lowered the nose and landed straight ahead in the tops of trees.… - [NTSB SEA83LA068](https://openairdocs.org/ntsb/SEA83LA068.md): Cessna 172H · Inchelium, WA · Accident · Minor injuries · Limited investigation · Final report · May 12, 1983 · N1498F · Substantial damage > The intended landing area was a dirt road aprx 1500 ft long. After making a low pass to check the area, the plt made an approach over trees to land, but was too high, so he went around. On the 3rd pass, he applied full flaps. The plt stated that the acft was… - [NTSB MKC83FA108](https://openairdocs.org/ntsb/MKC83FA108.md): Beech D55 · Gardner, KS · Accident · Serious injuries · Field investigation · Final report · May 12, 1983 · N725M · Substantial damage > The plt was cleared for an ILS rwy 35 approach & given the Kansas city downtown arpt (23 mi NE) wx as 900 ft broken & 6 mi visibility. The tower was closed & the control zone was not in effect raising minimums. The plt stated his ILS glide slope indication… - [NTSB ATL83FA185](https://openairdocs.org/ntsb/ATL83FA185.md): Cessna 150L · Cheraw, SC · Accident · 2 fatal · Field investigation · Final report · May 12, 1983 · N21991 · Destroyed > The student was on his 5th dual instructional flt & was practicing landings with his instructor. They had completed 3 or 4 landings & were in the traffic pattern for another when an intense thunderstorm cloud moved over the arpt. A plt/witness stated that a… - [NTSB CHI83LA208](https://openairdocs.org/ntsb/CHI83LA208.md): Ercoupe 415-C · Ceresco, MI · Accident · Serious injuries · Limited investigation · Final report · May 11, 1983 · N3355H · Substantial damage > The plt reported that the acft was normal until he was on final apch to land. The acft began to loose too much altitude, so he advanced the throttle, then the eng lost power. Subsequently, the acft hit the top of a tree short of the rwy, then crashed. An exam… - [NTSB ATL83FA182](https://openairdocs.org/ntsb/ATL83FA182.md): Cessna 172P · Gastonia, NC · Accident · Serious injuries · Field investigation · Final report · May 9, 1983 · N5324K · Substantial damage > The acft stalled into the ground just short of the rwy and collapsed the nose gear. The pilot was flying from the right seat so his female passenger could use the more adjustable left seat. The pilot stated that at 70 KTS on final approach for a landing the… - [NTSB MKC83LA105](https://openairdocs.org/ntsb/MKC83LA105.md): Cessna 182Q · Springfield, MO · Accident · No injuries · Limited investigation · Final report · May 8, 1983 · N4801N · Substantial damage > The acft went off the runway, collapsed the nose gear and nosed over during landing. The pilot was unable to extend the flaps and tried to land on a 3800 foot runway. There was a 7003 foot runway 8 NM west of the landing site. The pilot also had a tailwind of… - [NTSB LAX83LA259](https://openairdocs.org/ntsb/LAX83LA259.md): Cessna 421B · Buckeye, AZ · Accident · No injuries · Limited investigation · Final report · May 7, 1983 · N315CC · Substantial damage > The plt had made 3 night landings at the strip during the past 6 mths. The procedure that had been used for lighting thestrip was to place a vehicle at the west end with the headlights facing east down the centerline of the strip. However, on the night of the… - [NTSB LAX83LA224](https://openairdocs.org/ntsb/LAX83LA224.md): Goldwing Dragan · Gilbert, AZ · Accident · No injuries · Limited investigation · Final report · May 7, 1983 · N3225D · Substantial damage > The plt/owner had assembled the acft from a kit aprx 1 yr prior to the accident. He reported that the acft was not equipped with brakes. When he returned to land at the ultralight flt park, he decided to make a low, short final apch to decrease the stoppage… - [NTSB MKC83LA103](https://openairdocs.org/ntsb/MKC83LA103.md): Piper PA-31-350 · Clinton, MO · Accident · Minor injuries · Limited investigation · Final report · May 6, 1983 · N278MW · Substantial damage > While cruising at 8,500 ft the pax in the right seat noticed that the oil filler access door on top of the right eng wasopen & oil was leaking. The plt checked the eng instruments & the only abnormal reading was a low manifold pressure reading on the left… - [NTSB LAX83LA218](https://openairdocs.org/ntsb/LAX83LA218.md): Cessna 172E · Gila Bend, AZ · Accident · Serious injuries · Limited investigation · Final report · May 6, 1983 · N7795U · Substantial damage > The student plt departed livermore, CA at an undetermined time. He reported that his destination was tucson, AZ. En route stops were made at bakersfield & banning, CA. After refueling at banning, he departed on a unspecified & undetermined route. He stated… - [NTSB CHI83LA200](https://openairdocs.org/ntsb/CHI83LA200.md): Cessna U206 · Terre Haute, IN · Accident · No injuries · Limited investigation · Final report · May 6, 1983 · N2198F · Substantial damage > The acft made a forced landing off arpt after the engine lost power on the approach. The plt said he was using fuel fromthe right engine when the engine started to sputter. The plt switched to the left tank and tried to restart the engine to no avail. The… - [NTSB ATL83LA177](https://openairdocs.org/ntsb/ATL83LA177.md): Beech K35 · Fitzgerald, GA · Accident · No injuries · Limited investigation · Final report · May 6, 1983 · N9526R · Substantial damage > The acft made a forced landing in an open field off the airport after the engine quit at about 300 ft AGL during a go- around. The pilot who was being checked out in this acft by an instructor was trained in a C-172 which has differences in the fuel system.… - [NTSB FTW83FA221](https://openairdocs.org/ntsb/FTW83FA221.md): Beech E33 · San Angelo, TX · Accident · No injuries · Field investigation · Final report · May 5, 1983 · N8314N · Substantial damage > The eng failed in flt & the acft crashed 1 mi short of rwy 18 during an emergency landing into mathis arpt. The acft's fuselage was streaked with fresh oil. The rigid oil pressure line, extending from the eng to the firewall, failed due tofatigue cracking… - [NTSB LAX83FUG15](https://openairdocs.org/ntsb/LAX83FUG15.md): Boland Mong Sport · Murietta, CA · Accident · No injuries · Final report · May 3, 1983 · N32RJ · Substantial damage > The acft collided with a fence during a forced landing in a grass field. The plt stated that during pre-flight, he found about 7 gallons of fuel aboard the acft. His flight was to be only 20 minutes of air work. Some time was added in locating ground… - [NTSB SEA83FA094](https://openairdocs.org/ntsb/SEA83FA094.md): Cessna C-172N · Friday Harbor, WA · Accident · 1 fatal · Field investigation · Final report · May 1, 1983 · N3413E · Destroyed > The acft crashed during an attempted go-around. The acft flap switch was in the down mode and the flaps were in the fulldown(40 degree) position. A passenger said the acft was 'real close to the right side of the runway' just before go- around N3413E impacted… - [NTSB FTW83LA214](https://openairdocs.org/ntsb/FTW83LA214.md): Piper PA-38-112 · Krum, TX · Accident · No injuries · Limited investigation · Final report · May 1, 1983 · N2495K · Substantial damage > The acft collided with the ground during a simulated forced landing and go-around. The acft's left main landing gear wassheared and the left wing dragged during ground contact. The CFI had given the student a simulated forced landing during the approach and… - [NTSB FTW83LA212](https://openairdocs.org/ntsb/FTW83LA212.md): Quickie Q-2 · Fabens, TX · Accident · No injuries · Limited investigation · Final report · Apr 29, 1983 · N82JW · Substantial damage > The pilot said that he was flying a low aprch to the airport. When he added power to go around the engine failed. A forced landing was made in a field. The acft is equipped with a header tank which feeds the engine and a main tank which feeds the header tank.… - [NTSB FTW83LA352](https://openairdocs.org/ntsb/FTW83LA352.md): Cessna 172N · Morrilton, AR · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1983 · N54174 · Substantial damage > The acft collided with trees on the final approach to land at night. The plt had canceled his IFR clearance. During the approach the plt had the rwy in sight and asked memphis center how FAR he was from the arpt. When he was informed he WAS3 miles south he… - [NTSB DEN83AA105](https://openairdocs.org/ntsb/DEN83AA105.md): Cessna 340 · Rock Springs, WY · Accident · 3 fatal · Final report · Apr 26, 1983 · N5415M · 2 aircraft · Destroyed > The aircrew of a Cessna 340, N5415M, were scheduled for an air taxi check ride with an inspector at jackson, WY, later in the afternoon. They had planned to takeoff from Rock Springs, WY, practice a few instrucment apchs at Rock Springs, then proceed to… - [NTSB CHI83LA192](https://openairdocs.org/ntsb/CHI83LA192.md): Piper PA-28-181 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Apr 26, 1983 · N82717 · Substantial damage > After takeoff, the plt elected to practice touch-and-go landings. After about 5 landings, the eng lost power while the plt was turning on a base leg for rwy 17 at about 400 ft AGL. He tried to restart the eng. However, the left wing hit the tops of trees &… - [NTSB CHI83LA190](https://openairdocs.org/ntsb/CHI83LA190.md): Piper PA-28R · Havana, IL · Accident · No injuries · Limited investigation · Final report · Apr 26, 1983 · N7670J · Destroyed > The aircraft collided with the ground during an attempted go around when the pilot stated that he did not see but two ofthe landing gear lights on. The approach was to runway 9 in a crosswind from 170 degrees at 18 KTS with gusts to 24 KTS the pilot described… - [NTSB ANC83FA075](https://openairdocs.org/ntsb/ANC83FA075.md): Piper PA-18 · Soldotna, AK · Accident · Serious injuries · Field investigation · Final report · Apr 25, 1983 · N4396Z · Destroyed > Witnesses observed the acft maneuvering erratically near the arpt & anticipated the accident. The 1st approach to rwy 25WAS described as erratic with minimal apparent control which included an abrupt pull-up, stall, bounce, & go-around in aleft pattern at 300… - [NTSB DEN83LA101](https://openairdocs.org/ntsb/DEN83LA101.md): Piper J3C65 · Kalispell, MT · Accident · No injuries · Limited investigation · Final report · Apr 24, 1983 · N88075 · Substantial damage > While making an approach to a field on a ranch, the acft hit a power line on short final and crashed upright in the field. The pilot said he did not see the wire across the north approach to the field. - [NTSB CHI83LA181](https://openairdocs.org/ntsb/CHI83LA181.md): Cessna 172P · Mt. Pleasant, MI · Accident · No injuries · Limited investigation · Final report · Apr 24, 1983 · N6155K · Substantial damage > While on a local sight-seeing flt, the plt elected to land at mt Pleasant, MI for lunch. A low pass was made over rwy 09. The plt reported that while he was on a second approach to land, the acft encountered wind gusts and a loss of altitude. The plane's… - [NTSB FTW83LA197](https://openairdocs.org/ntsb/FTW83LA197.md): Beech 95-B55 · Gage, OK · Accident · No injuries · Limited investigation · Final report · Apr 20, 1983 · N599VK · Substantial damage > The acft made a forced landing off arpt after the engine quit. The weather was VMC and no flt plan was filed. This was across-country flt from los angeles, CA to bolivar, MO with a fuel stop at Gage, OK. The flt crashed 900 ft short of the rwy at Gage, OK.… - [NTSB NYC83LA108](https://openairdocs.org/ntsb/NYC83LA108.md): Bellanca 7GBC · Middleboro, MA · Accident · No injuries · Limited investigation · Final report · Apr 18, 1983 · N4163Y · Substantial damage > The acft landed short of the runway after experiencing a power loss on the approach. The pilot had carburetor heat on and when he experienced a downdraft on final he said he opened the throttle and the engine quit. The acft was landed in the bushes short of… - [NTSB FTW83LA198](https://openairdocs.org/ntsb/FTW83LA198.md): Cessna A188B · El Campo, TX · Accident · No injuries · Limited investigation · Final report · Apr 18, 1983 · N4876R · Substantial damage > The pilot said that as the acft was turning final flaps were extended to 20 degrees and the angle of bank was increased resulting in an increased rate of descent. He added power to correct his descent rate but the engine did not respond. Pumping the throttle… - [NTSB FTW83LA196](https://openairdocs.org/ntsb/FTW83LA196.md): Piper PA 24-180 · Socorro, NM · Accident · Minor injuries · Limited investigation · Final report · Apr 18, 1983 · N5064P · Destroyed > The acft was returning from a cross-country flt and crash landed about 1 mile from the arpt when the engine quit. The pilot said he added power to reach the rwy but the engine would not respond. The acft impacted the ground and slid to a stop. An FAA… - [NTSB NYC83LA099](https://openairdocs.org/ntsb/NYC83LA099.md): Schweizer SGS-2-33A · Erwinna, PA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1983 · N2706H · Substantial damage > The glider was on a dual instructional flight for landing practice. On the final approach to landing the glider lost lift after experiencing excessive sink and clipped the tops of trees. The glider landed short of the intended area and the wings and nose of… - [NTSB MIA83FA123](https://openairdocs.org/ntsb/MIA83FA123.md): Beech V35TC · Destin, FL · Accident · Serious injuries · Field investigation · Final report · Apr 17, 1983 · N265T · Destroyed > The acft collided with a powerline, crashed & burned after the engine lost power on the final approach. The acft was using fuel from a tank that was less than half full. The acft had made a go-around and during the pattern was observed to be oscillating from… - [NTSB LAX83FU002](https://openairdocs.org/ntsb/LAX83FU002.md): Rotec Rally 2B · Le Grand, CA · Accident · Serious injuries · Final report · Apr 17, 1983 · UNREG · Substantial damage > Reportedly, the plt took off & landed in a dairy pasture with no apparent difficulties. He then took off again on an easterly heading. After takeoff, he turned to a modified crosswind/downwind pattern & was proceeding in a northwesterly direction. Reportedly,… - [NTSB NYC83FA098](https://openairdocs.org/ntsb/NYC83FA098.md): Piper PA-28-181 · Blue Bell, PA · Accident · 1 fatal · Field investigation · Final report · Apr 16, 1983 · N8167K · Destroyed > The plt had been briefed on forecast strong winds & a SIGMET for moderate to severe turbulence. Witnesses observed the acft make a series of approaches to rwy 24. On the 1st approach the acft was almost over the threshold as the base turn was completed. The… - [NTSB ATL83FA163](https://openairdocs.org/ntsb/ATL83FA163.md): Beech V35B · Frisco, NC · Accident · 4 fatal · Field investigation · Final report · Apr 16, 1983 · N9394Q · Destroyed > The destination arpt was unlighted & was closed from 30 min after sunset until 30 min before sunrise. Prior to the flt, the plt made arrangements for someone to take his car to the destination arpt & park it with the headlights turned on at the apch end of… - [NTSB LAX83LA194](https://openairdocs.org/ntsb/LAX83LA194.md): Piper PA-28-140 · Oceana, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 1983 · N5985F · Substantial damage > The student plt, a mexican national, was on a solo x-country flt. He reported that he could not locate the destination arpt at san luis obispo, CA. After circling the area, he saw the Oceana arpt & started to land. While on final apch, the eng lost power.… - [NTSB FTW83LA192](https://openairdocs.org/ntsb/FTW83LA192.md): Cessna 210K · Austin, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 1983 · N8234M · Substantial damage > Before taking off (at 1740) on his return flt, the plt got a wx briefing & checked the NOTAMS, but did not refuel the acft. There were no NOTAMS for the san marcos arpt. During arrival at san marcos, TX, no rwy lights were visible. The plt circled for 15 to… - [NTSB CHI83FA166](https://openairdocs.org/ntsb/CHI83FA166.md): Piper PA24-260 · Middleton, WI · Accident · 1 fatal · Field investigation · Final report · Apr 15, 1983 · N9215P · Destroyed > During arrival at night, the plt was cleared for a vor-b apch to the morey arpt, an uncontrolled facility at an elevation of 928 ft MSL. Rwy 13/31 at the arpt had low intensity rwy lights which could be activated by keying the radio on 123.5 mhz. The circling… - [NTSB ATL83FIJ02](https://openairdocs.org/ntsb/ATL83FIJ02.md): Cessna 182P · Bluefield, WV · Accident · Serious injuries · Final report · Apr 15, 1983 · N7353S · Destroyed > The plt reported that he began an ILS approach to the mercer county arpt. He stated that he planned to descend to 3200 ft MSL, then execute a missed approach & return to abington, VA. The arpt elevation was 2857 ft MSL. He stated that he remembered glancing… - [NTSB FTW83LA186](https://openairdocs.org/ntsb/FTW83LA186.md): Cessna 182K · Weston, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 13, 1983 · N2437Q · Substantial damage > The plt was on a flt to obtain aerial photographs. He elected to land in a pasture to discuss a survey problem with personnel on the ground. He had previously checked the area by driving across it with a vehicle and felt it was satisfactory. After making a… - [NTSB ATL83LA160](https://openairdocs.org/ntsb/ATL83LA160.md): Bell 47G-4A · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Apr 13, 1983 · N4749R · Substantial damage > During an approach to land, the engine lost power at aprx 500 ft AGL. The plt reported that during an autorotative landing, he had to maneuver to avoid trees & a ridge in order to land in a suitable area. During this time, rotor RPM dropped & a crash landing… - [NTSB MIA83LA122](https://openairdocs.org/ntsb/MIA83LA122.md): Cessna 402B · Ft. Pierce, FL · Accident · No injuries · Limited investigation · Final report · Apr 12, 1983 · N13GM · Substantial damage > The acft was landed wheels up. The pilot stated that he never heard the landing gear warning horn operate. Post accidentinvestigation showed that the landing gear operated properly but that the warning horn was inoperative. The pilot of theaccident acft held… - [NTSB MIA83LA119](https://openairdocs.org/ntsb/MIA83LA119.md): Spencer Quickie Q2 · Tallahassee, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 12, 1983 · N212ES · Substantial damage > The acft was on its first test flt since being built. After about 40 min of flt, the acft returned to land. On final the plt added power to check the sink rate but there was no response. The acft landed short of the rwy tearing the gear off. The plt… - [NTSB MKC83LA089](https://openairdocs.org/ntsb/MKC83LA089.md): Varga 2150A · Moline, KS · Accident · No injuries · Limited investigation · Final report · Apr 10, 1983 · N8281J · Substantial damage > The aircraft collided with power lines on final approach but a landing was accomplished on the runway. The pilot stated that he had made 2 prior landings on the same runway and did not see the wires. During this approach he saw the wires and tried to fly… - [NTSB MKC83FA087](https://openairdocs.org/ntsb/MKC83FA087.md): Cessna 172 I · Paola, KS · Accident · No injuries · Field investigation · Final report · Apr 9, 1983 · N35722 · Substantial damage > The acrt crashed in a pasture after fuel exhaustion during an approach to johnson county industrial arpt. The acft had made a missed approach at his destination of Nevada MO. Enroute to a suggested alterate of butler arpt. The weather became worse and johnson… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=212 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=211 --- 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.