# 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 212 of 420 · 20,992 cases ## Cases, newest first - [NTSB LAX83LA189](https://openairdocs.org/ntsb/LAX83LA189.md): Rockwell A-9B · Marana, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 9, 1983 · N7909V · Destroyed > The plt was on a flt from quanah, TX to chandler, AZ to deliver the acft for a sale. He had been on the ferry flt for 6 hrs when he landed at Marana, AZ. After refueling, raising the eng cowl, inspecting the eng & wiping off an accumulation of oil, he took… - [NTSB LAX83FU001](https://openairdocs.org/ntsb/LAX83FU001.md): Mitchell A-10 · Tulare, CA · Accident · 1 fatal · Final report · Apr 7, 1983 · UNREG · Destroyed > The ultralight was on a demonstration flt. Reportedly, the plt made a pass down the rwy, then had turned downwind at 400 to 500 ft, when witnesses heard a loud bang or crack & saw the wings of the vehicle fold. The ultralight then entered a spiral & crashed… - [NTSB CHI83FA160](https://openairdocs.org/ntsb/CHI83FA160.md): Gates Learjet 35A · Indianapolis, IN · Accident · No injuries · Field investigation · Final report · Apr 7, 1983 · N3794W · Substantial damage > The aircraft struck trees one mile from the runway during an ILS approach to Indianapolis intl airport after a flight from chicago. The pilot successfully executed a missed approach and diverted to hulman regional airport, terre haute, IN, for an emergency… - [NTSB SEA83LA076](https://openairdocs.org/ntsb/SEA83LA076.md): Cessna 150F · Anacortes, WA · Accident · No injuries · Limited investigation · Final report · Apr 6, 1983 · N6720F · Substantial damage > The uncertificated plt had made several attempts to land when he struck a tree in the approach path with the right wing. The acft then left the area for a short period of time, returned & made what was described as a bumpy landing. The acft use was… - [NTSB SEA83LA074](https://openairdocs.org/ntsb/SEA83LA074.md): Cessna 172G · Near Homedale, ID · Accident · No injuries · Limited investigation · Final report · Apr 5, 1983 · N3658L · Substantial damage > The flt originated before sunset, but the student plt practiced in the local area until the onset of darkness. While attempting to land on his private strip, he made 2 go-arounds. On the second go-around, the acft collided with an electrical wire, then flew… - [NTSB ATL83FA150](https://openairdocs.org/ntsb/ATL83FA150.md): Cessna 172 · Spartanburg, SC · Accident · Serious injuries · Field investigation · Final report · Apr 5, 1983 · N8253U · Substantial damage > According to the plt's son, who was a passenger, the plt had made a final approach lineup on the wrong set of lights. Realizing the mistake, the plt initiated a go-around at aprx 200 ft AGL. However, the eng lost power. During an emergency landing at night,… - [NTSB NYC83FA085](https://openairdocs.org/ntsb/NYC83FA085.md): Piper PA-28RT-201 · Captree Island, NY · Accident · 2 fatal · Field investigation · Final report · Apr 4, 1983 · N8219L · Destroyed > The plt contacted the islap west arrival controller with the intention of landing at islap, NY. However, islap was below mins, so the plt diverted toward farmingdale, NY & asked about the wx there. The islap controller coordinated the diversion with the… - [NTSB LAX83FA179](https://openairdocs.org/ntsb/LAX83FA179.md): Bell 206L-1 · Red Rock, AZ · Accident · No injuries · Field investigation · Final report · Apr 4, 1983 · N302PS · Substantial damage > Reportedly, the plt elected to land in a mountainous area in calm wind conditions. At an estimated distance of 350 ft & an alt of aprx 75 ft above the touchdown zone, the nose of the helicopter began a gradual left turn as the plt applied collective pitch. At… - [NTSB FTW83FA178](https://openairdocs.org/ntsb/FTW83FA178.md): Cessna T310R · Dalhart, TX · Accident · 1 fatal · Field investigation · Final report · Apr 4, 1983 · N6831T · Destroyed > As the plt was approaching Dalhart, TX, he was in radio & radar contact with albuquerque ARTCC (center). Aprx 15 mi from delhart, the plt asked center about the wx over Dalhart. He was advised that the fss there was shut down & no current wx for Dalhart was… - [NTSB LAX83FA173](https://openairdocs.org/ntsb/LAX83FA173.md): Piper PA-28-140 · Compton, CA · Accident · Serious injuries · Field investigation · Final report · Apr 2, 1983 · N1399H · Destroyed > The acft collided with a chain link fence and a brick wall during an attempted go-around after overshooting the runway during landing. The pilot was high and had about 25 percent of the runway left when he decided to go around. The landingwas attempted on… - [NTSB FTW83FA175](https://openairdocs.org/ntsb/FTW83FA175.md): Cessna 500 · Eagle Pass, TX · Accident · 4 fatal · Field investigation · Final report · Apr 2, 1983 · N700CW · Destroyed > The acft was on a flt to a private ranch landing strip at night. The strip had an unlighted windsock at midfield & portable rwy edge lights were in use. During arrival, the aircrew estimated the visibility was 3 to 4 mi & reported they would be able to land.… - [NTSB SEA83LA070](https://openairdocs.org/ntsb/SEA83LA070.md): Partenavia P68C/TC · Dixie, ID · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1983 · N2958W · Substantial damage > The acft stalled, dragged the left wing and collided with a fence during landing. A 2nd pilot with limited multi-engine experience was making the landing. When power was reduced about 10 feet above the threshold, the acft stalled. The left main gear and the… - [NTSB LAX83LA169](https://openairdocs.org/ntsb/LAX83LA169.md): Piper PA-24-260 · Hollister, CA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1983 · N9324P · Substantial damage > While on final apch to land at night, the right main gear of the acft struck a semi-trailer truck as the acft crossed over a highway. The centerline of the highway was located aprx 102 ft from the apch end of the rwy. The plt continued the landing & the right… - [NTSB MIA83LA105](https://openairdocs.org/ntsb/MIA83LA105.md): Piper PA-31-350 · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Mar 28, 1983 · N123WK · Substantial damage > The acft collided with the terrain while on a localizer 36 approach at Ocala, FL the weather was IMC and the flight was on an IFR clearance. The acft was damaged but the occupants were not injured. The pilot stated that while on the final segment of the… - [NTSB ATL83FA145](https://openairdocs.org/ntsb/ATL83FA145.md): Piper PA-34-200T · Roanoke, VA · Accident · 5 fatal · Field investigation · Final report · Mar 27, 1983 · N5885V · Destroyed > The acft was on a x-country from buffalo, NY to new port richey, FL. The plt made an en route stop at painsville, OH, then proceeded toward greensboro, NC. While en route, he elected to land at Roanoke, VA because his fuel would be low if he continued to… - [NTSB MIA83FA101](https://openairdocs.org/ntsb/MIA83FA101.md): Cessna C-337C · Silver Springs, FL · Accident · Serious injuries · Field investigation · Final report · Mar 26, 1983 · N2524S · Destroyed > The acft collided with trees during an attempted go-around during a night operation. The plt had just recently acquired the acft and he was accompanied by his wife at the time of the accident. The plt lacked certification in the acft. Witesses heard the… - [NTSB CHI83LA151](https://openairdocs.org/ntsb/CHI83LA151.md): Beech A-36 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Mar 26, 1983 · N7464N · Substantial damage > The aircraft landed in a field about 1 mile from the approach end of the runway after engine stoppage during final approach. No malfunction of the engine was found during examination. The pilot stated he had flown about 3 hrs and 20 minutes. The hobbs meter… - [NTSB NYC83LA082](https://openairdocs.org/ntsb/NYC83LA082.md): Cessna 172 · Syracuse, NY · Accident · No injuries · Limited investigation · Final report · Mar 25, 1983 · N2918E · Substantial damage > The aircraft made an emergency landing on a golf course after the engine quit on final approach to Syracuse, NY. The acft had departed van wert, oh at 1350 and stopped for about 20 minutes at columbus, oh to pick up a passenger at 1445. The pilot contacted… - [NTSB ATL83LA153](https://openairdocs.org/ntsb/ATL83LA153.md): Bellanca 17-30A · Shelbyville, TN · Accident · Minor injuries · Limited investigation · Final report · Mar 25, 1983 · N28190 · Destroyed > The acft collided with a power line during a forced landing after power loss due to fuel exhaustion. The acft was on thefinal approach. The pilot said he would be landing short of the rwy. When asked the nature of his emergency he said 'I think I am running… - [NTSB ATL83LA143](https://openairdocs.org/ntsb/ATL83LA143.md): Beech C24R · Waycross, GA · Accident · Minor injuries · Limited investigation · Final report · Mar 25, 1983 · N6009A · Destroyed > During flt, the plt encountered strong headwinds & decided to divert to Waycross, GA. While using fuel from the right tank, the engine quit due to fuel starvation. The plt stated that this surprised him since the right fuel gauge needle was only slightly… - [NTSB ATL83LA141](https://openairdocs.org/ntsb/ATL83LA141.md): Cessna 150L · Jacksonville, NC · Accident · Minor injuries · Limited investigation · Final report · Mar 23, 1983 · N7538G · Destroyed > The acft stalled, spun and collided with trees during an attempted go-around. The pilot had flown locally for about 1 hour doing stalls and touch and go landings. The accident occurred following a landing that was planned as a full stop landing. The landing… - [NTSB SEA83LA067](https://openairdocs.org/ntsb/SEA83LA067.md): Cessna 150G · Bremerton, WA · Accident · Serious injuries · Limited investigation · Final report · Mar 21, 1983 · N3355J · Destroyed > The aircraft collided with a tree stump during a forced landing after the engine quit during entry into the traffic pattern. When the engine stopped the pilot felt he could not make the airport and chose a field to land in to avoid trees on the final approach… - [NTSB MIA83LA095](https://openairdocs.org/ntsb/MIA83LA095.md): Molino PIK 20 · Highsprings, FL · Accident · No injuries · Limited investigation · Final report · Mar 19, 1983 · N1975S · Substantial damage > The acft crashed short of the runway during a pleasure flight. The pilot was not injured. The pilot stated that he descended below the tree line and encountered a wind shear. He traded altitude for airspeed and the acft encountered thetop wire of a fence. The… - [NTSB CHI83LA143](https://openairdocs.org/ntsb/CHI83LA143.md): Cessna A150M · Irwin, OH · Accident · Serious injuries · Limited investigation · Final report · Mar 17, 1983 · N9841J · Substantial damage > The plt circled the arpt to set up his landing pattern for rwy 14 with a left crosswind. On final at 60 KTS & full flapsthe stall warning horn came on with the acft drifting. The plt added power & removed carb heat. He also started to 'work' the flaps up 'a… - [NTSB ATL83FA176](https://openairdocs.org/ntsb/ATL83FA176.md): Bellanca 17-31A · Waverly, GA · Accident · 2 fatal · Field investigation · Final report · Mar 17, 1983 · N8855V · Destroyed > The acft crashed into trees during an instrument approach at night in stormy weather. Both the CFI, seated in the front left seat, & the new owner of the acft, were fatally injured. An IFR flt plan was filed & the CFI had obtained 2 wx briefings prior to… - [NTSB FTW83LA153](https://openairdocs.org/ntsb/FTW83LA153.md): Beech 23 · Athens, LA · Accident · Serious injuries · Limited investigation · Final report · Mar 14, 1983 · N2389Q · Substantial damage > Just prior to the flt, a mechanic performed some minor upkeep functions on the acft & knew of no mechanical problems. He was unaware that the owner was not a rated plt. The mechanic accompanied the owner on a local flt. Subsequently, the acft crashed on the… - [NTSB ATL83LA139](https://openairdocs.org/ntsb/ATL83LA139.md): Brown Sonera II L · Bowling Green, KY · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 1983 · N86BB · Substantial damage > The acft nosed over during a forced landing after the engine lost power on the base leg of the landing pattern. The weather was VMC and no flight plan was filed. The pilot stated that he had worked on the carburetor prior to this flightand had also moved the… - [NTSB NYC83LA076](https://openairdocs.org/ntsb/NYC83LA076.md): Burkhart Grob G10Z Astir CS · Buena Vista, PA · Accident · No injuries · Limited investigation · Final report · Mar 12, 1983 · N142SS · Substantial damage > Thinking that he might be lost in a wave above the clouds, the plt descended through an opening & decided to make an off-field landing. Severe wind gusts altered his glide path & he headed toward an apple orchard. The left wing contacted a branch about 10 ft… - [NTSB CHI83LA133](https://openairdocs.org/ntsb/CHI83LA133.md): Aeronca 7AC · Garden City, MN · Accident · No injuries · Limited investigation · Final report · Mar 12, 1983 · N1907E · Substantial damage > The pilot elected to land to the west on a blacktop road. After touchdown, he initiated a go-around. During the go-around, the aircraft collided with the top wire of a power line on the right side of the road and crashed. The pilot estimated that the wind was… - [NTSB DCA83AA019](https://openairdocs.org/ntsb/DCA83AA019.md): Piper PA-31-350-T1020 · Fort Belvoir, VA · Accident · Serious injuries · Final report · Mar 11, 1983 · N120AE · Substantial damage > On a flt from newark, NJ to richmond, VA, the departure time was delayed, and subsequently, the acft did not arrive at richmond until after the refueling facilities were closed. The plt decided there was sufficient fuel aboard to complete the next flt to the… - [NTSB ATL83LA134](https://openairdocs.org/ntsb/ATL83LA134.md): Cessna A188B · Wadley, GA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1983 · N8233G · Destroyed > The pilot had been using a paved road for a landing strip until someone complained. He then changed to a north- south dirt road with trees on the west side and utility wires and poles on the right side. While landing with a left crosswind at about 16 gusting… - [NTSB CHI83LA131](https://openairdocs.org/ntsb/CHI83LA131.md): Mooney M20C · Solon Springs, WI · Accident · No injuries · Limited investigation · Final report · Mar 10, 1983 · N5587Q · Substantial damage > The pilot reported that when he departed Solon Springs, WI at 2100 CST, the weather was windy, but the sky was clear. He landed at minneapolis, MN to pick up a passenger, then departed on a return flight to Solon. While returning, he encountered snow. The… - [NTSB FTW83LA141](https://openairdocs.org/ntsb/FTW83LA141.md): Bellanca 8KCAB · Roswell, NM · Accident · No injuries · Limited investigation · Final report · Mar 7, 1983 · N5042J · Substantial damage > During arrival, the engine began to lose power as the acft was on base leg for landing. The plt was unable to restore full power and made a forced landing in an umimproved area aprx 2 mi from the airport. During the landing roll-out, the right wing tip hit a… - [NTSB ATL83FA129](https://openairdocs.org/ntsb/ATL83FA129.md): Beech K35 · Birmingham, AL · Accident · 2 fatal · Field investigation · Final report · Mar 7, 1983 · N9543R · Destroyed > The acft collided with trees and terrain during a practice localizer approach at night to rwy 23 at Birmingham municipalarpt. The weather was VMC and the pilot was not instrument rated. On approaching Birmingham from tri-cities, NC the pilot asked for a… - [NTSB SEA83FA060](https://openairdocs.org/ntsb/SEA83FA060.md): Glasair SH-2 · 5 Nm E. Of Kent, WA · Accident · 1 fatal · Field investigation · Final report · Mar 6, 1983 · N46JS · Destroyed > The homebuilt acft collided with powerlines on final approach and crashed. The pilot was on a flight from one airport toanother to demonstrate his acrt to other builders of the acft. He was observed to enter the pattern and fly a low base leg and final… - [NTSB FTW83LA140](https://openairdocs.org/ntsb/FTW83LA140.md): Cessna 172N · Canton, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 6, 1983 · N5536E · Substantial damage > The plt reported that during arrival, he started to land with a right crosswind at 15 gusting 22 KTS. He stated that the acft was very low over the runway when a gust of wind blew it over a plowed area adjacent to the runway. He applied full power, raised the… - [NTSB MIA83LA085](https://openairdocs.org/ntsb/MIA83LA085.md): Piper PA-28-161 · Lehigh Acres, FL · Accident · No injuries · Limited investigation · Final report · Mar 2, 1983 · N8445G · Substantial damage > During a simulated, engine-out, emergency, the student elected to make an approach to a paved road. While turning to a final approach at about 300 ft AGL, the instructor pilot (CFI) observed power lines in their path. The CFI advised the student to go around.… - [NTSB FTW83IA131](https://openairdocs.org/ntsb/FTW83IA131.md): Aerospatiale AS-350D · E. Cameron · Incident · No injuries · Incident investigation · Final report · Mar 1, 1983 · N3593D · Minor damage > During an approach to an oil drilling rig platform, the engine decelerated as the pilot started to all power. With the acft below the landing area, he maneuvered to miss the platform & initiated an autorotative landing. He made a mayday call & tried to… - [NTSB NYC83LA073](https://openairdocs.org/ntsb/NYC83LA073.md): Piper PA-32R-300 · Quakertown, PA · Accident · No injuries · Limited investigation · Final report · Feb 28, 1983 · N38389 · Substantial damage > The acft touched down about 1 ft short of the rwy. The left gear & wing was damaged. - [NTSB DEN83LA069](https://openairdocs.org/ntsb/DEN83LA069.md): Piper PA-34-200 · Erie, CO · Accident · No injuries · Limited investigation · Final report · Feb 28, 1983 · N8295L · Substantial damage > The plt stated he encountered an unexpected downdraft or shear effect & landed approximately 102 ft short of the rwy. The acft then collided with a bar ditch located about 63 ft from the threshold folding back the main gear. The acft then slid down the… - [NTSB NYC83FNE02](https://openairdocs.org/ntsb/NYC83FNE02.md): Piper PA-28-140 · Oxford, MA · Accident · Serious injuries · Final report · Feb 27, 1983 · N33458 · Substantial damage > During a go-around, the eng began losing power, & subsequently, the plt elected to make a forced landing in an open field. However, before landing, the acft collided with an electric wire, then crashed. An investigation revealed some maintenance… - [NTSB CHI83FA123](https://openairdocs.org/ntsb/CHI83FA123.md): Piper PA-28-140 · Beloit, WI · Accident · 1 fatal · Field investigation · Final report · Feb 27, 1983 · N5769F · Destroyed > Reportedly, the plt had not flown for 2 or 3 months before his flts on 2/27/83. On that day, he took off & made 5 touch-and-go landings, then stopped for a cup of coffee. The plt then departed again on a 2nd flt. Aprx 1/2 hr later, smoke was observed from the… - [NTSB NYC83FA072](https://openairdocs.org/ntsb/NYC83FA072.md): Cessna 150J · Oxford, CT · Accident · Minor injuries · Field investigation · Final report · Feb 26, 1983 · N60619 · Substantial damage > The acft was last refueled on 11/28/82 & flown.2 hr to on arpt for an annual inspection. The annual was completed on 2/19/83. During the annual, an estimated.5 gal of fuel was drained from the acft & the eng was run about.2 hr. When the plt preflted the… - [NTSB NYC83FA071](https://openairdocs.org/ntsb/NYC83FA071.md): Cessna 172M · Mountville, PA · Accident · 2 fatal · Field investigation · Final report · Feb 26, 1983 · N12067 · Substantial damage > The acft collided with a power line and a tree before crashing to the ground during a go-around attemp. The acft had been crabbing in a cross-wind for a landing and drifting off to the right of the rwy. The pilot applied power for a go around but never… - [NTSB NYC83LA075](https://openairdocs.org/ntsb/NYC83LA075.md): Beech P35 · Beverly, MA · Accident · No injuries · Limited investigation · Final report · Feb 24, 1983 · N972Q · Substantial damage > The approach was made at 90 mph with full flaps in winds gusting to 25K. As the plt flared for landing the right gear contacted a pot hole at the approach lip of the rwy blowing the tire causing the rear strut to push a hole into the wing skin. - [NTSB FTW83FA128](https://openairdocs.org/ntsb/FTW83FA128.md): Cessna P-206C · Brookland, AR · Accident · 3 fatal · Field investigation · Final report · Feb 24, 1983 · N8637Z · Destroyed > The acft crashed in IMC weather after the pilot failed to complete a VOR approach to jonesboro. According to the owner of the accident acft, the plt was instrument rated and had filed an IFR flt plan but was not very proficient in instrument flying. During… - [NTSB ATL83LA120](https://openairdocs.org/ntsb/ATL83LA120.md): Cessna 421 · Dayton, TN · Accident · No injuries · Limited investigation · Final report · Feb 24, 1983 · N123SM · Substantial damage > The Cessna 421 collided with trees during the landing approach while on a corporate flight. The weather was IMC at the accident site and the acft was on an IFR flight plan. The acft was substantially damaged but the pilot was not injured. The acft contacted… - [NTSB FTW83FA126](https://openairdocs.org/ntsb/FTW83FA126.md): Cessna 172N · Pineville, LA · Accident · 2 fatal · Field investigation · Final report · Feb 23, 1983 · N4862G · Destroyed > The owner, an instructor plt (CFI), was in the right front seat & a private plt with no instrument rating was in the left front seat. During arrival, the aircrew had inquired about the wx at the esler regional arpt, however, the fss & the UNICOM had closed… - [NTSB FTW83LA125](https://openairdocs.org/ntsb/FTW83LA125.md): Piper PA-31P · Nacogdoches, TX · Accident · No injuries · Limited investigation · Final report · Feb 21, 1983 · N7334L · Substantial damage > During arrival, a landing was made at night IMC conditions with low ceilings, heavy rain & gusty winds. The plt reported that during the landing, there was a x-wind component, light turbulence & a wind shift. Reportedly the acft was landed aprx half way down… - [NTSB CHI83LA116](https://openairdocs.org/ntsb/CHI83LA116.md): Cessna 150 · Three Oaks, MI · Accident · Serious injuries · Limited investigation · Final report · Feb 21, 1983 · N704RX · Substantial damage > The instructor (CFI) & his student had started flying at aprx 1900 EST. The purpose was to give the student aprx 3 hrs of night instruction. A refueling stop was made at south bend, IN. According to the student, the CFI stayed in the acft during the… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=213 ## 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=212 --- 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.