# 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 203 of 420 · 20,992 cases ## Cases, newest first - [NTSB LAX84LA262](https://openairdocs.org/ntsb/LAX84LA262.md): Molino PIK-20B · El Mirage, CA · Accident · No injuries · Limited investigation · Final report · Apr 15, 1984 · N222PK · Substantial damage > The plt reported that when he was 1/2 mi from the rwy at 835 ft AGL, his airspeed was 70 KTS. While descending through 400 ft AGL, his airspeed flickered 3 times to zero. The 3rd time, it stayed at zero & the glider dropped to the ground. The reported wind 11… - [NTSB LAX84LA257](https://openairdocs.org/ntsb/LAX84LA257.md): Raven S-55A-707 · Glendale, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 15, 1984 · N5717H · No damage > During a sight-seeing flt, the winds, outside air temp & propane gas burner temp began increasing, so the plt elected to land. He notified the chase crew, started a descent & anticipated making a 'drop line' landing. As the balloon began crossing over a dry… - [NTSB FTW84LA196](https://openairdocs.org/ntsb/FTW84LA196.md): Beech A23-19 · Guthrie, OK · Accident · No injuries · Limited investigation · Final report · Apr 15, 1984 · N2385W · Substantial damage > While on final approach the acft descended below the desired glidepath. When the plt added pwr, the engine did not respond. The acft touched down hard and short of the rwy after which the left wing contacted a tree. The plt stated he did not use carb heat… - [NTSB SEA84LA083](https://openairdocs.org/ntsb/SEA84LA083.md): Hughes 369D · Kent, WA · Accident · Minor injuries · Limited investigation · Final report · Apr 14, 1984 · N1092L · Substantial damage > The plt requested clearance to transit the seattle tca for a landing at Boeing field. He was advised of a DC-10 departing the seattle-tacoma intl arpt & was cautioned about possible wake turbulence. The DC-10 passed the helicopter with about 1 1/2 mi lateral… - [NTSB SEA84LA082](https://openairdocs.org/ntsb/SEA84LA082.md): Cessna 172N · Harrisburg, OR · Accident · No injuries · Limited investigation · Final report · Apr 14, 1984 · N734JW · Substantial damage > The plt reported that after the sun had set, a haze formed near the ground. He used visual references to align the acft with the private rwy at dusk. As he approached, he saw what he thought was hedge on the edge of the arpt & then made a soft field landing.… - [NTSB NYC84FNC01](https://openairdocs.org/ntsb/NYC84FNC01.md): Evans VP-2 · Mechanic Falls, ME · Accident · No injuries · Final report · Apr 14, 1984 · N38217 · Destroyed > According to the pilot the acft became airborne inadvertently while high speed taxi testing the engine. On final apch back to the arpt control was lost and the acft flew into trees parallel to the rwy. No mechanical malfunction was found by investigators. - [NTSB DEN84FU003](https://openairdocs.org/ntsb/DEN84FU003.md): American Falcon · Salt Lake City, UT · Accident · Serious injuries · Final report · Apr 14, 1984 · UNREG · Destroyed > Reportedly, the plt made an apch to rwy 18, then initiated a go-around due to traffic on the rwy. He reported that traffic to the left necessitated a right pattern. There were power lines located aprx 500 ft west of the grass strip, about 40 to 50 ft AGL.… - [NTSB ATL84LA144](https://openairdocs.org/ntsb/ATL84LA144.md): Brown, R. M. JR. Monnett Moni · Kill Devil Hill, NC · Accident · 1 fatal · Limited investigation · Final report · Apr 14, 1984 · N92RB · Substantial damage > The acft was the 4th acft to take off of 7 scheduled to make a formation fly-by of the wright brothers national memorial. As the acft took off to join up for the flt, a thick low fog bank rolled in. The other acft departed the area, but the plt attempted to… - [NTSB NYC84FGM03](https://openairdocs.org/ntsb/NYC84FGM03.md): Bliss Corbin Baby ACE CM-1 · Emporium, PA · Accident · Minor injuries · Final report · Apr 12, 1984 · N6392T · Substantial damage > On final approach the acft struck several trees, the pilot lost control of the acft. The acft then struck telephone wires & a pole and crashed. - [NTSB MIA84LA133](https://openairdocs.org/ntsb/MIA84LA133.md): Cessna 172M · Tallahassee, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 1984 · N30217 · Substantial damage > The acft experienced complete loss of eng power while making an ILS app to rwy 36. A forced land was made into the treesfive mi south of the airport. Post crash investigation revealed no fuel in either fuel tank or any of he fuel drains. A subsequent eng test… - [NTSB LAX84LA250](https://openairdocs.org/ntsb/LAX84LA250.md): Piper PA-38-112 · Lake Mathews, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 10, 1984 · N2314P · Substantial damage > The acft was making a go-around from about 100 AGL and collided with rising terrain. According to the plt the engine failed to respond properly. According to the passenger the engine response was normal. The investigation revealed that the acft was overweight… - [NTSB NYC84LA136](https://openairdocs.org/ntsb/NYC84LA136.md): Cessna 180 · Leonardtown, MD · Accident · No injuries · Limited investigation · Final report · Apr 9, 1984 · N3859C · Substantial damage > The acft made a forced landing about 1 mile sw of an added stopping point. The plt noted a lower than planned gs and thought he should add a stop for fuel. During the flt he had encountered icing and because of climbs and descents to avoid wx for about an… - [NTSB CHI84LA150](https://openairdocs.org/ntsb/CHI84LA150.md): Piper PA-28R-200 · Lafayette, IN · Accident · No injuries · Limited investigation · Final report · Apr 8, 1984 · N56738 · Destroyed > The pilot was practicing accuracy landings when he noticed that the acft had blown away from the rwy. When he attempted to increase the throttle setting there was no response. In an attempt to land on a highway on-ramp the acft struck an electric wire, a… - [NTSB NYC84LA133](https://openairdocs.org/ntsb/NYC84LA133.md): Cessna T303 · Binghamton, NY · Accident · No injuries · Limited investigation · Final report · Apr 6, 1984 · N511SC · Substantial damage > Prior to the approach, the plt was advised of a thunderstorm sse of the arpt. The plt stated that the weather was deteriorating rapidly with turbulence, heavy rain, near-blinding lighting & windshear. During the approach, due to the adverse wx conditions &… - [NTSB LAX84LA241](https://openairdocs.org/ntsb/LAX84LA241.md): de Havilland DH 114 · Scottsdale, AZ · Accident · No injuries · Limited investigation · Final report · Apr 6, 1984 · N81962 · Substantial damage > For undetermined reasons the plt experienced a power loss on both left engines while turning from left base to final for ldg. The plt was unable to maintain directional control and elected to reduce power on the right engines. During the forced ldg roll the… - [NTSB FTW84LA191](https://openairdocs.org/ntsb/FTW84LA191.md): Beech B35 · Nocona, TX · Accident · Minor injuries · Limited investigation · Final report · Apr 5, 1984 · N8843A · Substantial damage > The plt was flying the acft after it had been parked for about 8 months. The eng had been cutting out due to water in the tanks, but he thought that problem had been corrected. While on final apch to land, the eng began missing & lost power. The plt turned on… - [NTSB MKC84FA116](https://openairdocs.org/ntsb/MKC84FA116.md): Cessna 310I · Fayetteville, AR · Accident · 2 fatal · Field investigation · Final report · Apr 4, 1984 · N8156M · Destroyed > When the plt received a wx briefing at 1012 CST, he was advised that the wx at his destination (Fayetteville, AR) was an estimated 600' overcast, vis 4 mi with light drizzle & fog, but the wx was forcast to begin to improve in about 1 hr. He took off & during… - [NTSB CHI84FA148](https://openairdocs.org/ntsb/CHI84FA148.md): Piper Aerostar 600 · Pontiac, MI · Accident · No injuries · Field investigation · Final report · Apr 4, 1984 · N3645T · Substantial damage > During an ILS apch, the acft collided with treetops while it was slightly left of the apch course near the middle marker. The plt continued to fly the acft to the rwy & the plane touched down about 1000 ft beyond the threshold. At touchdown, the acft veered… - [NTSB ATL84LA140](https://openairdocs.org/ntsb/ATL84LA140.md): Cessna 172N · Winnsboro, SC · Accident · No injuries · Limited investigation · Final report · Apr 4, 1984 · N733KM · Substantial damage > The acft was making a precautionary landing because the fuel guages were indicating 'empty'. Following touchdown the pltsaw a barbed wire fence and attempted a go-around & struck the fence. After making ground contact a second time the acftcontinued through… - [NTSB NYC84LA130](https://openairdocs.org/ntsb/NYC84LA130.md): Cessna 150K · Colts Neck, NJ · Accident · Minor injuries · Limited investigation · Final report · Apr 3, 1984 · N5746G · Substantial damage > During an apch to the destination arpt, the eng lost power. The plt stated 'short base leg used at 800 ft, too close to airport, so I tried skids to slow down.' Witnesses reported seeing the acft in 's' turns along the rwy as the plt attempted to lose… - [NTSB NYC84LA126](https://openairdocs.org/ntsb/NYC84LA126.md): Cessna 172H · Hagerstown, MD · Accident · Serious injuries · Limited investigation · Final report · Apr 1, 1984 · N2477L · Substantial damage > The plt initiated a 5 mi straight-in approach. When the acft was within 2 mi of the arpt, the plt reduced power, appliedcarb heat & slowed the acft. When it appeared he was going to land short, he added power, but the eng would not respond. The acft was… - [NTSB CHI84LA146](https://openairdocs.org/ntsb/CHI84LA146.md): Bellanca 17-30 · Delavan, WI · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1984 · N7389V · Substantial damage > The plt reported that when he was descending from 3500 ft MSL to traffic pattern alt (2000 ft MSL), he switched the fuel selector from the left fuel tank to the right tank. Upon entering the traffic pattern, he made his prelanding checks. When he advanced the… - [NTSB DEN84FA121](https://openairdocs.org/ntsb/DEN84FA121.md): Aero Commander 500-B · Miles City, MT · Accident · Serious injuries · Field investigation · Final report · Mar 31, 1984 · N743W · Destroyed > The plt said that when he called on the radio prior to the approach for an altimeter setting the reply was '30.11 or 30.12, something like that.' The acft altimeter was found after the accident set at 30.22 inches of mercury. The visibility was described as 1… - [NTSB FTW84LA184](https://openairdocs.org/ntsb/FTW84LA184.md): Cessna 402B · El Paso, TX · Accident · No injuries · Limited investigation · Final report · Mar 30, 1984 · N5039Q · Substantial damage > During gear extension in preparation for landing the nose gear failed to extend fully even though emergency gear extension proceedures were performed. The plt steered the acft off to the right of the rwy shortly after touchdown. Acftinspection revealed a… - [NTSB NYC84LA115](https://openairdocs.org/ntsb/NYC84LA115.md): Piper PA-28R-200 · Mount Holly, NJ · Accident · No injuries · Limited investigation · Final report · Mar 23, 1984 · N41724 · Substantial damage > According to the plt, a windshear was encountered during the final approach at approximately 100 ft AGL. The acft descended rapidly and bounced at the approach end of the rwy, ascended approximately 30 ft into the air, landed again striking the left wing on… - [NTSB CHI84IA141](https://openairdocs.org/ntsb/CHI84IA141.md): Short Brothers SD3-30 · Moline, IL · Incident · No injuries · Incident investigation · Final report · Mar 21, 1984 · N333MV · No damage > During an apch, the right eng lost power, but an uneventful landing was made. An exam revealed the aft fuel tank, consisting of the #3 & #4 fuel cells, were empty, although the fuel quantity gage indicated 500 lbs of fuel remaining. The erroneous reading was… - [NTSB LAX84LA225](https://openairdocs.org/ntsb/LAX84LA225.md): Piper PA-24-180 · Tucson, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 20, 1984 · N65DB · Substantial damage > Shortly after passing watson intersection inbound to tuscon, AZ the outboard tip of one propeller blade separated. The plt turned the magneto switch off and slowed the acft until the propeller stopped rotating. He then executed an emergency landing short of… - [NTSB MIA84LA117](https://openairdocs.org/ntsb/MIA84LA117.md): Cessna C-177B · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Mar 19, 1984 · N20433 · Substantial damage > At 0052, shortly after departing big cypress, FL, the plt called west palm beach tower & requested advisories to Pahokee arpt. The controller requested the flt's position, but the plt was not sure of his location. The tower controller contacted miami artc for… - [NTSB DEN84LA111](https://openairdocs.org/ntsb/DEN84LA111.md): Piper PA-12-115 · Riverton, WY · Accident · No injuries · Limited investigation · Final report · Mar 19, 1984 · N4378M · Substantial damage > The plt stated that a convair 580 had landed before him. The plt flew a normal glide slope & planned to land on the approach end of the rwy. On short final at 50 ft AGL, the acft suddenly banked 'over 90 degrees' to the left out of control. The acft then hit… - [NTSB ATL84LA123](https://openairdocs.org/ntsb/ATL84LA123.md): Beech BE-23 · Rome, GA · Accident · No injuries · Limited investigation · Final report · Mar 18, 1984 · N2387L · Substantial damage > The acft lost power in the traffic pattern and forced landed off the arpt. The weather was conducive to carburetor icing. The plt said he applied carburetor heat after reducing power. - [NTSB NYC84LA111](https://openairdocs.org/ntsb/NYC84LA111.md): Cessna 340 · Norwood, MA · Accident · No injuries · Limited investigation · Final report · Mar 17, 1984 · N8482N · Substantial damage > The plt reported that during an instrument apch, he descended to the mda with the radar altimeter set to 415 ft. the passenger in the right front seat, who was a plt, advised that he saw the apch lights & 1 or 2 seconds later, the radar altimeter sounded. The… - [NTSB NYC84FA110](https://openairdocs.org/ntsb/NYC84FA110.md): Lockheed 18-56 · Oneonta, NY · Accident · 2 fatal · Field investigation · Final report · Mar 17, 1984 · N77777 · Destroyed > At aprx 2330 EST, witnesses near the crash site heard an acft, & shortly thereafter, they saw a flash. One of them, who was driving a car, went back to the area the next day & found the acft wreckage. The acft had crashed & burned about 1 mi from the apch end… - [NTSB FTW84FA170](https://openairdocs.org/ntsb/FTW84FA170.md): Piper PA-28-180 · Bristow, OK · Accident · 2 fatal · Field investigation · Final report · Mar 17, 1984 · N7386W · Destroyed > Just prior to the accident, the acft was observed to make a low pass down rwy 35 in slow flt. The acft then entered a steep climb at the end of the rwy to an alt of 200 to 300 ft AGL. It then turned left onto a crosswind leg of the pattern, the left wing… - [NTSB DEN84LA109](https://openairdocs.org/ntsb/DEN84LA109.md): Mooney M20E · Las Vegas, NM · Accident · No injuries · Limited investigation · Final report · Mar 16, 1984 · N7134U · Substantial damage > While enroute, the plt elected to land at Las Vegas, NM & check on his destination wx. He called the fss when the acft was about 30 mi south of Las Vegas & was advised that the wind at Las Vegas was from 230 deg at 20 KTS. He said he experienced severe… - [NTSB NYC84LA147](https://openairdocs.org/ntsb/NYC84LA147.md): Cessna 152 · Fitchburg, MA · Accident · No injuries · Limited investigation · Final report · Mar 15, 1984 · N45945 · 2 aircraft · No damage > The plt of N45945 stated that upon entering downwind for rwy 32 she reported her position on UNICOM, but did not receivea reply. She continued her approach failing to report base and final positions. At aprx 500 ft on final apch she felt the acft buffet and… - [NTSB NYC84FA108](https://openairdocs.org/ntsb/NYC84FA108.md): Piper PA-28R-200 · Groton, CT · Accident · 1 fatal · Field investigation · Final report · Mar 14, 1984 · N5022S · Destroyed > The plt received 2 wx briefings prior to departing & both called for low ceilings. During arrival at the destination, the plt requested & was cleared for an ILS apch to rwy 5. While on the apch, the acft collided with a small tree & crashed. The wreckage came… - [NTSB MIA84LA109](https://openairdocs.org/ntsb/MIA84LA109.md): Piper PA-23-150 · Kissimmee, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 1984 · N2070P · Substantial damage > Earlier in the day, the plt had flown from orlando to lakeland, FL. Before that flt, he had not visually checked the fuel, but had relied on estimates & his fuel gages. On the return flt, he again took off without visually checking the fuel. While en route,… - [NTSB DEN84FA107](https://openairdocs.org/ntsb/DEN84FA107.md): Mooney M20K · Craig, CO · Accident · 1 fatal · Field investigation · Final report · Mar 10, 1984 · N231F · Destroyed > Witnesses observed & heard the plt making an apch & subsequent go-around or pass over the ground at the arpt. Heavy fog conditions existed which were below IFR minimums. The plt failed to realize higher terrain exsisted north of the arpt. The acft collided… - [NTSB LAX84LA209](https://openairdocs.org/ntsb/LAX84LA209.md): Cessna TU-206G · Auburn, CA · Accident · No injuries · Limited investigation · Final report · Mar 8, 1984 · N206GA · Substantial damage > The plt came in for her 3rd landing and after flaring high'cut'the throttle and said she hoped for a'soft'landing with trim back and 40 degrees of flaps. A plt on the ground near the rwy said his attention was drawn to the acft because of a large increase in… - [NTSB LAX84LA210](https://openairdocs.org/ntsb/LAX84LA210.md): Maule M6235 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Mar 7, 1984 · N56463 · Substantial damage > The acft dragged a wing and nosed down into the ground collapsing the landing gear and sliding to a stop on a taxi-way during an attempted go-around after an alignment with rwy problem. The CFI said that the student plt used excessive rudder and 'froze' on… - [NTSB LAX84LA208](https://openairdocs.org/ntsb/LAX84LA208.md): Air Tractor AT-300 · Delano, CA · Accident · No injuries · Limited investigation · Final report · Mar 7, 1984 · N4336S · Substantial damage > The plt was making a tight, 180 degree, right turn from downwind to final when he felt a buffet. He then applied power and lowered the nose. He stated he remained in the turn to avoid power lines. The power lines were located along the left side of the rwy.… - [NTSB ATL84MA114](https://openairdocs.org/ntsb/ATL84MA114.md): Cessna 421B · Cullman, AL · Accident · 6 fatal · Major investigation · Final report · Mar 6, 1984 · N3291Q · Destroyed > Plt cleared for night NDB rwy 19 apch to folwom field. Erratic radar track drg procedure turn and inbd intercept. Witnesses described 200 ft ceiling and reduced vis in fog at airport. Other witnesses observed acft on northbound course,followed by turn to west… - [NTSB ATL84FA116](https://openairdocs.org/ntsb/ATL84FA116.md): Piper PA-24-260 · Manassas, VA · Accident · 3 fatal · Field investigation · Final report · Mar 6, 1984 · N9011P · Destroyed > The accident occurred on missed approach at night in weather conditions below the destination minimums after aprx 5 hours and 25 minutes of flight. Performance computations indicated the accident occurred at or near the time of projected fuel exhaustion.… - [NTSB NYC84MA102](https://openairdocs.org/ntsb/NYC84MA102.md): Piper PA-31 · Cumberland, MD · Accident · 3 fatal · Major investigation · Final report · Mar 5, 1984 · N6629L · Destroyed > Approx 16 min prior to the accident the plt was cleared for the localizer DME approach. The acft collided with the mountainous terrain on a hdg of about 220 degrees at approx 8.5 DME on a bearing of 051 degrees from the arpt. As indicated on the loc/dme rwy… - [NTSB LAX84LA207](https://openairdocs.org/ntsb/LAX84LA207.md): Cessna 172M · San Luis Obispo, CA · Accident · No injuries · Limited investigation · Final report · Mar 5, 1984 · N1485V · Destroyed > The acft spiraled down and collided with the ground while turning from base leg to final in the traffic pattern. The pltsaid he tried to correct the situation but the sprial continued. No evidence was found to support the plts claim that the acft crashed… - [NTSB LAX84LA205](https://openairdocs.org/ntsb/LAX84LA205.md): Beech BE-24 · La Verne, CA · Accident · No injuries · Limited investigation · Final report · Mar 4, 1984 · N60031 · Substantial damage > The acft collided with the ground short of the rwy during an ILS approach. The plt said he took his eyes off the panel to look outside and got off the glide slope. The plt also said the weather was below approach minimums. The ILS was checked by FAA after the… - [NTSB DEN84FU002](https://openairdocs.org/ntsb/DEN84FU002.md): Eipper Quicksilver MX · Libby, MT · Accident · 1 fatal · Final report · Mar 4, 1984 · UNREG · Substantial damage > According to witnesses, the ultralight vehicle was on an apch to the arpt when it entered a left descending turn & continued the turn until impacting a tree. One witness said the plt was bent over forward. Reportedly, the plt made no movements with his hands… - [NTSB NYC84LA099](https://openairdocs.org/ntsb/NYC84LA099.md): Cessna 402B · Penn Yan, NY · Accident · No injuries · Limited investigation · Final report · Mar 3, 1984 · N3374Q · Substantial damage > The acft entered a high sink rate during the final approach and collided with the ground. The plt managed to get the acft onto the rwy but the right main landing gear collapsed during the landing roll. A culvert is located near the approach end of rwy 28. - [NTSB LAX84IA204](https://openairdocs.org/ntsb/LAX84IA204.md): Cessna 402C · Kalaupapa, HI · Incident · No injuries · Incident investigation · Final report · Feb 28, 1984 · N206RH · Minor damage > While on final to rwy 23, a 20 ft wave ricocheted off the rwy embankment, striking the acft's rt flap. The plt executed a go-around & landed on rwy 05 without incident. Investigation revealed that the rt flap cable had broken. - [NTSB ANC84FA038](https://openairdocs.org/ntsb/ANC84FA038.md): Cessna 150L · Talkeetna, AK · Accident · Minor injuries · Field investigation · Final report · Feb 28, 1984 · N10719 · Substantial damage > On downwind for a touch and go, the student pilot noticed a strange engine noise. She elected to do another touch & go, & during a turn from crosswind to downwind, a total loss of power occurred. A forced landing was attempted onto a road. Children were… Next page: https://openairdocs.org/ntsb-phases/500/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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/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.