# 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 202 of 420 · 20,992 cases ## Cases, newest first - [NTSB ATL84FU004](https://openairdocs.org/ntsb/ATL84FU004.md): Ultraflight Lazair II · Blichton, GA · Accident · 1 fatal · Final report · May 26, 1984 · UNREG · Substantial damage > The ultralight was low and flat during an approach to land. The acft was aligned with a tree, and according to witnesses, there was no evasive maneuver to avoid the obstruction. The vehicle collided with the tree about 40 ft alg and fell to the ground. No… - [NTSB MIA84LA171](https://openairdocs.org/ntsb/MIA84LA171.md): Cessna 182 · San Juan, PR · Accident · No injuries · Limited investigation · Final report · May 25, 1984 · N3838D · Destroyed > While the plt was in the traffic pattern (on base) to land at isla grande arpt, the eng lost power. Subsequently, the acft was ditched & sank in about 40 ft of water. The acft was not recovered, so the eng could not be examined. - [NTSB DEN84IA157](https://openairdocs.org/ntsb/DEN84IA157.md): Swearingen SA226TC · Albuquerque, NM · Incident · No injuries · Incident investigation · Final report · May 24, 1984 · N237AM · Minor damage > When gear was lowered for landing rt main gear would not extend although persons on the ground stated the gear doors appeared open. Remedial action by the flt crew did not rectify the situation and a gear up landing was performed. When acft was raised from… - [NTSB DEN84FA159](https://openairdocs.org/ntsb/DEN84FA159.md): Grumman American AA-1C · Rapid City, SD · Accident · Serious injuries · Field investigation · Final report · May 23, 1984 · N9803U · Substantial damage > The acft collided with rolling terrain while on a dual training flt. The CFI stated that the student plt was in the process of doing a simulated engine out forced landing when he raised the nose too high. The CFI and student were discussing the terrain when… - [NTSB SEA84LA114](https://openairdocs.org/ntsb/SEA84LA114.md): Morrisey 2150 · Enumclaw, WA · Accident · No injuries · Limited investigation · Final report · May 21, 1984 · N5601B · Substantial damage > The plt was on a local test flt to check the flt controls that had just been adjusted. Before taking off, he visually inspected the fuel tanks, but could not see fuel since anything less than 1/2 tank was not visible. He said the fuel gages indicated both… - [NTSB LAX84LA305](https://openairdocs.org/ntsb/LAX84LA305.md): Bellanca 7GCAA · Waipahu,Oahu, HI · Accident · Serious injuries · Limited investigation · Final report · May 20, 1984 · N4166Y · Substantial damage > The CFI gave the student a simulated forced landing and the student spiraled down to 400 ft AGL. When the CFI said 'i'vegot the airplane' the acft nose came up and the acft started to settle. The CFI stated he applied power but the acft continued to settle,… - [NTSB LAX84LA302](https://openairdocs.org/ntsb/LAX84LA302.md): Grumman AA-5B · Ruth, CA · Accident · Serious injuries · Limited investigation · Final report · May 20, 1984 · N74848 · Substantial damage > While attempting to land on rwy 31, the plt elected to go-around. He made a low pass down the rwy, pulled up at the end of the rwy for a downwind entry & began to mush. The acft hit a tall tree & impacted the ground. - [NTSB LAX84FA304](https://openairdocs.org/ntsb/LAX84FA304.md): Brubaker Q-2 · Corona, CA · Accident · 1 fatal · Field investigation · Final report · May 20, 1984 · N82QQ · Destroyed > The plt of a quickie Q-2 had returned to the arpt & made 2 low passes, then began a normal apch to rwy 25. When the Q-2 was on a low final, the plt of a Mooney acft turned onto the rwy & began taking off. At about that time, a ground witness heard the… - [NTSB CHI84LA200](https://openairdocs.org/ntsb/CHI84LA200.md): Grumman AA-1B · Millstadt, IL · Accident · Minor injuries · Limited investigation · Final report · May 20, 1984 · N8973L · Substantial damage > The acft was stalled during the landing approach over trees to an 1800 ft strip. After clearing the trees the plt reduced the power to idle while aprx 30 ft AGL. The acft stalled, contacted the soft plowed soil and nosed over about 150 ft short of the rwy. - [NTSB ATL84LA181](https://openairdocs.org/ntsb/ATL84LA181.md): Cessna 150 · Jessup, GA · Accident · Minor injuries · Limited investigation · Final report · May 20, 1984 · N22815 · Substantial damage > The acft landed off the rwy during a forced landing following a power loss. Wx conditions were conducive to carburetor icing. - [NTSB ATL84LA179](https://openairdocs.org/ntsb/ATL84LA179.md): Condor III · Kennesaw, GA · Accident · No injuries · Limited investigation · Final report · May 20, 1984 · N4443M · Substantial damage > The two place ultralight actt crashed 30FT short of the rwy due to fuel exhaustion. The acft had been flying into a headwind of 13 knots at an indicated airspeed of 40 knots. The acft impacted in some underbrush. - [NTSB ATL84LA177](https://openairdocs.org/ntsb/ATL84LA177.md): Grumman American AA-1B · Tallassee, AL · Accident · Minor injuries · Limited investigation · Final report · May 20, 1984 · N9907L · Substantial damage > The plt stated he departed fulton county arpt with aprx 12 gals of fuel on board. About 20 mins later, the left fuel tank ran dry & the plt selected the right tank & continued the flt with the intention of refueling at either tuskegee ortallassee. Upon… - [NTSB CHI84LA202](https://openairdocs.org/ntsb/CHI84LA202.md): Luscombe 8E · Ortonville, MI · Accident · No injuries · Limited investigation · Final report · May 19, 1984 · N455C · Substantial damage > The acft landed hard short of the rwy, bounced, & both landing gear collapsed. - [NTSB DEN84FTE01](https://openairdocs.org/ntsb/DEN84FTE01.md): Harper/Cricri MK-12 · Longmont, CO · Accident · 1 fatal · Final report · May 18, 1984 · N42JH · Destroyed > The homebuilt acft was on downwind leg of the traffic pattern, after initial takeoff, when it went into a dive & collided with the ground. A witness said he heard a power reduction before the dive & power added again as it started down. The plt's son said his… - [NTSB CHI84LA198](https://openairdocs.org/ntsb/CHI84LA198.md): Cessna 150 · Sardinia, OH · Accident · Serious injuries · Limited investigation · Final report · May 18, 1984 · N64676 · Destroyed > The acft collided with trees during the landing approach. Witnesses said the wind was gusty but no gusts were officiallyreported. No malfunctions of equipment were reported. Due to a head injury the student plt has no recall of the accident. - [NTSB LAX84LA291](https://openairdocs.org/ntsb/LAX84LA291.md): Taylorcraft F21 · Payson, AZ · Accident · No injuries · Limited investigation · Final report · May 13, 1984 · N2005U · Substantial damage > The acft was landed 200 ft short of the rwy in bushes after the engine hesitated during the plts application of throttle in an attempt to reach the rwy. An FAA inspector found the magneto timing set to 23 plus degrees rather than the prescribed 20 degrees. - [NTSB FTW84LA232](https://openairdocs.org/ntsb/FTW84LA232.md): Cessna 170 · Victoria, TX · Accident · No injuries · Limited investigation · Final report · May 13, 1984 · N2539V · Substantial damage > The pilot stated that while on a long final approach power was reduced for descent. Shortly thereafter the throttle was applied but the engine failed to respond. The aircraft landed 100 yards short of rwy 17. The pilot stated after the accident that he… - [NTSB NYC84LA168](https://openairdocs.org/ntsb/NYC84LA168.md): Piper PA-28-180 · Montrose, PA · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N33339 · Substantial damage > Pilot attempted to land on a 2200 foot grass runway. The plt overshot the runway and attempted to go-around. The aircraft collided with trees at the end of the runway. - [NTSB LAX84LA289](https://openairdocs.org/ntsb/LAX84LA289.md): Cessna 172 · Montague, CA · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N5654A · Substantial damage > An improper ldg flare by the dual student plt caused the acft to balloon to 15 to 20 ft AGL. The CFI called for power, but the student delayed adding power & raised the nose. At the sound of the stall warning horn, a go-around was called for by the CFI &… - [NTSB FTW84LA231](https://openairdocs.org/ntsb/FTW84LA231.md): Starduster SA-300 · El Paso, TX · Accident · Minor injuries · Limited investigation · Final report · May 12, 1984 · N3168 · Substantial damage > While in the arpt traffic pattern for landing, the plt experienced an engine failure and landed short of the rwy. The acft collided with a sand dune. The plt stated that he had experienced a loss of fuel pressure on previous flts but had not corrected the… - [NTSB CHI84LA187](https://openairdocs.org/ntsb/CHI84LA187.md): Cessna 152 · Mcarthur, OH · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N94702 · Substantial damage > The plt stated that during final approach at about 5 ft above the ground the acft was struck by a gust of wind that lifted the acft about 20 to 30 ft up and to the left of the runway. He stated tha a downdraft placed the acft in a position where 'maximum… - [NTSB CHI84LA185](https://openairdocs.org/ntsb/CHI84LA185.md): Cessna R172K · Minneapolis, MN · Accident · Minor injuries · Limited investigation · Final report · May 12, 1984 · N758CC · Destroyed > The plt was in the process of buying the Cessna 172. He took off on a local flt and after doing some airwork, he returned to the arpt. On final apch to rwy 27L, the acft was observed at a low alt. It continued descending and collided with microwave landing… - [NTSB LAX84LA286](https://openairdocs.org/ntsb/LAX84LA286.md): Enstrom F-28C · Hayward, CA · Accident · No injuries · Limited investigation · Final report · May 11, 1984 · N589H · Destroyed > According to a plt/operator statement, the private plt (PIC) was on an instruction flt. The other occupant, was a person whose commercial plt certificate had been suspendended. The PIC reported that the helicopter had just received an annual inspection & had… - [NTSB NYC84FA163](https://openairdocs.org/ntsb/NYC84FA163.md): Cessna 310K · New Cumberland, PA · Accident · 2 fatal · Field investigation · Final report · May 8, 1984 · N6907L · Destroyed > The plt departed VFR without a formal wx briefing or filing a flt plan. The wx at dest was VFR when the plt departed. The forecast indicated that ceilings would lower. The wx did, in fact, deteriorate while the flt was enroute and the plt obtained an IFR… - [NTSB MIA84FA163](https://openairdocs.org/ntsb/MIA84FA163.md): Beech 65-80 · Opa Locka, FL · Accident · Serious injuries · Field investigation · Final report · May 8, 1984 · N741H · Substantial damage > The plt stated that he did not check the acft fuel visually prior to departure. About 10 minutes after takeoff, while using auxiliary fuel tanks, the right eng lost power. The plt selected crossfeed & the eng restarted. He then turned off the right fuel… - [NTSB NYC84LA161](https://openairdocs.org/ntsb/NYC84LA161.md): Cessna 152 · No.Stonington, CT · Accident · No injuries · Limited investigation · Final report · May 7, 1984 · N25369 · Substantial damage > While on a x-country flt, the student plt became lost & his fuel supply became low. He had difficulty contacting a ground station, but finally did so after receiving assistance from other plts. He was requested to squawk 7700 on his transponder, but the… - [NTSB MIA84FA162](https://openairdocs.org/ntsb/MIA84FA162.md): Piper PA-31-325 · Eglin Afb, FL · Accident · No injuries · Field investigation · Final report · May 7, 1984 · N3586W · Substantial damage > After arriving at Eglin Afb, the plt determined he would need more fuel to complete the next leg of the flt. However, there was no avgas refueling available at Eglin. The plt disembarked the pax & flew IFR to ft walton beach to refuel. A missed approach was… - [NTSB ATL84LA167](https://openairdocs.org/ntsb/ATL84LA167.md): Cessna 188B · Paxville, SC · Accident · No injuries · Limited investigation · Final report · May 7, 1984 · N21672 · Substantial damage > The acft nosed over short of the rwy after the engine failed to respond to the plts attempt to add power to reach the rwy. It was found after the accident that the carb heat control door brackets were worn which allowed the butterfly valve door to separate… - [NTSB SEA84FA102](https://openairdocs.org/ntsb/SEA84FA102.md): Cessna 140 · Lovelock, NV · Accident · 2 fatal · Field investigation · Final report · May 5, 1984 · N1978N · Destroyed > The plt had originally requested a wx briefing at 0444 for a flt from cheyenne,WY to loverlock,NV. Prior to departing cheyenne at 0630, the FBO told the plt that the Lovelock arpt was flooded. The plt replied he would land at a strip in town. Fuel receipts… - [NTSB MIA84FA161](https://openairdocs.org/ntsb/MIA84FA161.md): Beech 35 · Sanford, FL · Accident · Serious injuries · Field investigation · Final report · May 5, 1984 · N2830V · Destroyed > The eng lost power when the acft was on final apch to land. The plt stated that he then switched fuel tanks, activated the electric fuel boost pump & worked the related wobble pump as fast as he could, but was unable to restore eng power. Subsequently, the… - [NTSB LAX84LA282](https://openairdocs.org/ntsb/LAX84LA282.md): Piper PA-24-250 · Visalia, CA · Accident · No injuries · Limited investigation · Final report · May 5, 1984 · N5597P · Substantial damage > When the plt arrived at his destination, he was unable to fully extend the gear. He diverted to Visalia, CA. After reducing the fuel load, he made an intentional, power-off, wheels-up landing. An exam revealed that nose gear bellcrank assy had caught on the… - [NTSB MKC84LA133](https://openairdocs.org/ntsb/MKC84LA133.md): Beech V35B · Lee'S Summit, MO · Accident · No injuries · Limited investigation · Final report · May 4, 1984 · N3138W · Substantial damage > The plt reported that the acft landed hard, bounced and landed hard again breaking the nose gear off the acft. The pilot stated he encountered a strong downdraft on approach. - [NTSB FTW84LA221](https://openairdocs.org/ntsb/FTW84LA221.md): Champion 7KCAB · Putnam, OK · Accident · Minor injuries · Limited investigation · Final report · May 4, 1984 · N5194X · Substantial damage > The acft bounced during landing and the plt attempted to abort the landing. A truck was parked near the end of the field. The acft collided with the truck which it failed to clear in an attempt to fly over it. There were no reported malfunctions of equipment. - [NTSB DEN84FU004](https://openairdocs.org/ntsb/DEN84FU004.md): Eipper Quicksilver MX · Berthoud, CO · Accident · Serious injuries · Final report · May 4, 1984 · UNREG · Destroyed > The ultralights were flying in loose formation on a short x-country. During the flt, the wind shifted to the east and created some turbulence and downdrafts near the end of the journey on final approach. The lead vehicle landed without knowledge that his… - [NTSB LAX84FA277](https://openairdocs.org/ntsb/LAX84FA277.md): Piper PA-23-250 · Ukiah, CA · Accident · 3 fatal · Field investigation · Final report · May 1, 1984 · N63813 · Destroyed > During arrival, the plt was cleared for a loc/dme rwy 15 apch to the Ukiah arpt. At 1307 PDT, he began the apch at the tucci intersection, 15.5 mi north of the rwy. At 1311:04 the last radar contact showed that the acft was about 5 mi north of the arpt. At… - [NTSB LAX84LA279](https://openairdocs.org/ntsb/LAX84LA279.md): Cessna 150J · Fort Ord, CA · Accident · No injuries · Limited investigation · Final report · Apr 29, 1984 · N5559G · Substantial damage > Before taking off, the plt noted that the left fuel gage indicated a little less than 1/2 full & the right gage showed aprx 1/2 full. He stated that a 'visual inspection showed about the same, as much as I could see.' The flt was uneventful until the eng… - [NTSB NYC84LA154](https://openairdocs.org/ntsb/NYC84LA154.md): Bryan RS-15 · Colts Neck, NJ · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 1984 · N24876 · Destroyed > During arrival to land, the plt circled over the arpt while gliders were being removed from the active rwy. He then made a tight downwind leg & started a 180 deg apch from 200 ft at 55 KTS. He stated that the 'roll rate (to the left) was rapid and by the time… - [NTSB LAX84LA270](https://openairdocs.org/ntsb/LAX84LA270.md): Piper PA-28 · Fair Oaks, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1984 · N81784 · Destroyed > Before departing on a x-country flt, the plt was warned to refuel midway on his route. He recalculated his fuel while en route & thought sufficient fuel was remaining. During arrival, the plt activated the rwy lights, but did not see them until he was nearly… - [NTSB FTW84FA214](https://openairdocs.org/ntsb/FTW84FA214.md): Cessna 310Q · Mckinney, TX · Accident · 3 fatal · Field investigation · Final report · Apr 28, 1984 · N69789 · Destroyed > Plt entered the landing pattern behind a slower acft (stearman) and reduced speed to maintain a proper interval. The nominal approach speed differential between the two acft makes is 26 mph. A right hand traffic pattern was in use and a right crosswind… - [NTSB ATL84LA155](https://openairdocs.org/ntsb/ATL84LA155.md): Cessna 210D · Shaw, MS · Accident · Minor injuries · Limited investigation · Final report · Apr 28, 1984 · N3882Y · Substantial damage > The acft was landed gear up in a precautionary landing after a control difficulty in flt. On base leg a loud bang was heard and the acft started to roll right. Control forces were heavy so the other plt in the front seat tried to help on the controls. They… - [NTSB ANC84FA059](https://openairdocs.org/ntsb/ANC84FA059.md): Cessna 152 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Apr 25, 1984 · N45928 · 2 aircraft · Substantial damage > A student plt in a Cessna 152, N45928, was inbound to land on rwy 33 at merrill field at the same time that another student plt in Cessna 152, N6479L, was departing from rwt 15. The student in N6479L was cleared for a 'city high' departure. After taking off,… - [NTSB DEN84LA133](https://openairdocs.org/ntsb/DEN84LA133.md): Cessna 150M · Boulder, CO · Accident · No injuries · Limited investigation · Final report · Apr 24, 1984 · N714ED · Substantial damage > During final approach the acft encountered a downdraft & impacted the ground about 50 ft short of the rwy. The possibility of downdrafts at the approach end of rwy 26 was well known to local plts including the instructor plt (CFI).the CFI reported the wind… - [NTSB NYC84FIG01](https://openairdocs.org/ntsb/NYC84FIG01.md): Piper PA-28-161 · Gathersburg, MD · Accident · Minor injuries · Final report · Apr 23, 1984 · N84400 · Substantial damage > While on a second attempt to intercept the LOC on the ILS 23 apch at frederick, MD, the plt reported a low fuel condition to baltimore ATC. At this time ATC suggested the plt fly to either baltimore (34 miles se) or to dulles (25 miles sw) for an apch. A… - [NTSB ATL84MA148](https://openairdocs.org/ntsb/ATL84MA148.md): Piper PA-34-220T · Mt Airy, GA · Accident · 6 fatal · Major investigation · Final report · Apr 23, 1984 · N8443H · Destroyed > Drg arrival, the plt reqd & rcvd clnc to fly drct to the unctld arpt, altho the arpt had no terminal nav fac & the acft had no RNAV type equip. Nrby at athens, the 0745 spl wx OBS was in part: indef cig, sky obscd, vsby 1/4 mi with fog. At 0801, atl ctr clrd… - [NTSB NYC84LA146](https://openairdocs.org/ntsb/NYC84LA146.md): Piper PA-28-151 · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Apr 22, 1984 · N7634F · Substantial damage > On final approach to runway 32, the aircraft contacted trees located approximately 600 yard short of the approach end of the runway. The passenger stated after the accident that as the aircraft approached the runway, he noticed the acft was 'a bit too close… - [NTSB DEN84LA135](https://openairdocs.org/ntsb/DEN84LA135.md): Stinson 108-3 · Mcville, ND · Accident · Serious injuries · Limited investigation · Final report · Apr 22, 1984 · N631C · Substantial damage > The acft collided with the ground, left wing 1st, during an apch to land. The plt stated that the acft apparently stalled. A patrolman noted an odor of alcohol in the plt's breath. A blood/alcohol test showed an alcohol level of 0.19%. The plt's last medical… - [NTSB ATL84FA147](https://openairdocs.org/ntsb/ATL84FA147.md): Piper PA-28-180 · Athens, GA · Accident · Serious injuries · Field investigation · Final report · Apr 22, 1984 · N5009T · Destroyed > Before starting an apch, the plt was advised the wx was: 300 ft obscured, visibility 3/4 mi with light rain & fog. The minimums for a straight-in VOR apch to rwy 2 were 400 ft mda & 1 mi visibility; for a circling apch, the minimums were 433 ft & 1 mi. The… - [NTSB FTW84LA207](https://openairdocs.org/ntsb/FTW84LA207.md): Mooney M-18C · Lockhart, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 21, 1984 · N4083 · Substantial damage > The plt related that the acft was not performing well from the initial takeoff roll. Since he had only previously flown the acft in winter months & the temp was quite warm, he thought the lack of performance was due to the temp. He stayed in the traffic… - [NTSB NYC84FA143](https://openairdocs.org/ntsb/NYC84FA143.md): Piper PA-28R-200 · Concord, MA · Accident · 1 fatal · Field investigation · Final report · Apr 19, 1984 · N4467X · Destroyed > The acft crashed into a house while on an ILS approach to rwy 11 at hanscom field. Shortly before the acft had reached the outer marker (and after the hand off from boston approach control to hanscom tower) an altitude alert on N4467X was received by the… - [NTSB NYC84FA138](https://openairdocs.org/ntsb/NYC84FA138.md): Beech 35-C33 · Toms River, NJ · Accident · Serious injuries · Field investigation · Final report · Apr 16, 1984 · N15VP · Destroyed > Plt stated that when using his bifocal corrective lenses, he had to tilt his head back to include the altimeter in his instrument scan. In the final phase of the approach, he failed to note the altimeter and collided with the terrain. Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=203 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')), crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')), current_codes AS ( SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code, row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*' AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982")) ), phases AS ( SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main FROM current_codes WHERE n = 1 UNION ALL SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode" WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes) ), case_phases AS ( SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1 WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names) ) SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=202 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.