# NTSB investigations: Enroute 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 349 of 718 · 35,889 cases ## Cases, newest first - [NTSB DEN84FA298](https://openairdocs.org/ntsb/DEN84FA298.md): Cessna 182P · Glen Canyon, UT · Accident · 1 fatal · Field investigation · Final report · Sep 18, 1984 · N1939M · Destroyed > The acft crashed into the 10388 ft high navaho mountain at about the 9800 ft level. Reportedly there was no moon that evening. The plt had departed hayward, CA at 1351 MDT & was enroute to farmington, NM. The acft crashed at 2027 MDT. Investigation revealed… - [NTSB ANC84LA185](https://openairdocs.org/ntsb/ANC84LA185.md): Piper PA-12 · Dadina Lake, AK · Accident · 1 fatal · Limited investigation · Final report · Sep 18, 1984 · N3269M · Substantial damage > Prior to the accident the plt had been involved in moose hunting activities. On the morning of the occurrence he had made two successful flts hauling meat from a small unnamed lake to Dadina Lake, about 3 miles north. Shortly after the third takeoff from the… - [NTSB ANC84FA190](https://openairdocs.org/ntsb/ANC84FA190.md): Bellanca 8KCAB · Ouzinkie, AK · Accident · Serious injuries · Field investigation · Final report · Sep 17, 1984 · N8592 · Substantial damage > Plt completed 5 turn spin, cockpit began filling with smoke. Electrical equipment was turned off and plt was descending for precautionary landing when elevator control was lost. Acft settled into 75 ft tall trees. Source of fire which resulted in battery… - [NTSB SEA85FA016](https://openairdocs.org/ntsb/SEA85FA016.md): Cessna 172M · Aberdeen, WA · Accident · 1 fatal · Field investigation · Final report · Sep 16, 1984 · N1150T · Destroyed > Acft wreckage indicates impact was nose down inverted. No evidence was found of acft failure/malfunction. Plt departed on night cross-country after an evening out with friends. Wreckage found two months later, no toxicological tests possible. - [NTSB NYC84FGM07](https://openairdocs.org/ntsb/NYC84FGM07.md): Piper PA-28-140 · South Fork, PA · Accident · Serious injuries · Final report · Sep 16, 1984 · N8257N · Substantial damage > Upon departure the plt estimated 25 gal of fuel. The total power loss occurred 1 hr and 55 min later. After the forced ldg on unimproved terrain no evidence of fuel remained in the fuel system. There was no indication of any full spill from the ruptured left… - [NTSB SEA84LA229](https://openairdocs.org/ntsb/SEA84LA229.md): Piper PA-32-300 · Kelso, WA · Accident · No injuries · Limited investigation · Final report · Sep 15, 1984 · N1054Q · Destroyed > Climbing through 4,000 ft the engine failed. Emergency procedures resulted in a momentary restoration of power prior to the forced landing. During final approach the left wing struck a tree. The right main landing gear collapsed during the landing roll.… - [NTSB SEA84LA221](https://openairdocs.org/ntsb/SEA84LA221.md): Cessna T206 · Austin, NV · Accident · No injuries · Limited investigation · Final report · Sep 15, 1984 · N1949U · Substantial damage > Personnel employed by the operator stated that the pilot flew the acft for 1.8 hours the night before the accident. Without refueling, the plt flew for 3.6 hours when the engine failed due to fuel exhaustion. During the forced landing roll the acft traveled… - [NTSB NYC84FA313](https://openairdocs.org/ntsb/NYC84FA313.md): Piper PA-34-200T · Buffalo, NY · Accident · Serious injuries · Field investigation · Final report · Sep 15, 1984 · N4512E · Destroyed > The acft crashed on main street, Buffalo, NY, while executing a forced landing during an air taxi cargo operation. Investigation revealed that based on fuel consumption calculations the plt had not allowed for all contingencies during his orginal flt planning… - [NTSB LAX84FA481](https://openairdocs.org/ntsb/LAX84FA481.md): Piper PA-28-236 · Santa Paula, CA · Accident · Serious injuries · Field investigation · Final report · Sep 15, 1984 · N8279L · Destroyed > After departing rwy 22 at Santa Paula arpt, the acft flew sw along the Santa clara river + struck a telephone wire 2.6 sm from the rwy end. Witnesses saw acft fly level at about 8O ft AGL with normal power sounds prior to wire contact. Thewire strike caused… - [NTSB FTW84IA400](https://openairdocs.org/ntsb/FTW84IA400.md): McDonnell Douglas DC-10-10 · Dfw Airport, TX · Incident · No injuries · Incident investigation · Final report · Sep 15, 1984 · N124AA · Minor damage > The acft experienced sepn of the rgt wing #3 leading edge slat while descending for an apch. An investigation revealed that on 7/5/84, the company performed a 'c' check inspection of the acft. At this time a rgt wing #3 leading edge slat retract aluminum… - [NTSB CHI84LA391](https://openairdocs.org/ntsb/CHI84LA391.md): Cessna 182J · Medina, OH · Accident · Minor injuries · Limited investigation · Final report · Sep 15, 1984 · N3058F · Substantial damage > Acft had been fueled for aprx 4 hrs endurance. Two hrs into flt on IFR flt plan, plt descended to 3000 ft with intermittent visual ground contact. Shortly thereafter, with the acft about 10 mins from destination, the engine began to sputter. Plt stated he… - [NTSB SEA84FA228](https://openairdocs.org/ntsb/SEA84FA228.md): Piper PA-32-301T · Burley, ID · Accident · Serious injuries · Field investigation · Final report · Sep 14, 1984 · N8160B · Destroyed > While climbing after takeoff, the eng surged twice, then quit. The plt repositioned the fuel selector, checked that the electric fuel pump was 'on' & restarted the eng, then started to return to the departure arpt. However, about 1 min later, the eng lost… - [NTSB LAX84LA479](https://openairdocs.org/ntsb/LAX84LA479.md): Cessna 150M · Baker, CA · Accident · No injuries · Limited investigation · Final report · Sep 14, 1984 · N9177U · Destroyed > The acft was damaged in a forced landing after the engine quit. The acft made a stop during its x-country and fuel was added which did not fill the tanks. During the next days flt the plt noticed the fule gages indicated almost empty and headed for the arpt… - [NTSB FTW84LA395](https://openairdocs.org/ntsb/FTW84LA395.md): Cessna 172N · Mandeville, LA · Accident · Serious injuries · Limited investigation · Final report · Sep 14, 1984 · N737LD · Substantial damage > The acft made an emerg landing on the south lanes of the lake pontchatrane causeway bridge after encountering a loss of eng power. Examination of the acft fuel tanks revealed both tanks empty. Activation of the fuel tank drain valves & the fuel strainer… - [NTSB FTW84LA392](https://openairdocs.org/ntsb/FTW84LA392.md): Cessna 140 · Liverpool, TX · Accident · No injuries · Limited investigation · Final report · Sep 13, 1984 · N89318 · Destroyed > At aprx 900 ft AGL the eng lost power and the plt executed a forced landing in the unimproved terrain. At touchdown the acft struck trees and a dirt enbankment nosing over inverted. Investigation revealed water in the gascolator as well as the left fuel tank.… - [NTSB DEN84LA288](https://openairdocs.org/ntsb/DEN84LA288.md): Bell 206B · Vernal, UT · Accident · Minor injuries · Limited investigation · Final report · Sep 12, 1984 · N1086Y · Substantial damage > Plt stated that while on a heading of 050 degs (wind from 270 degs at 5 KTS) the acft began to shudder and veered to the right. Plt attempted remedial action but acft continued descending in a right spiral to ground contact. Examination of the helicopter did… - [NTSB MKC84LA276](https://openairdocs.org/ntsb/MKC84LA276.md): Balloon Works Firefly 7 · Cedar Rapids, IA · Accident · No injuries · Limited investigation · Final report · Sep 11, 1984 · N4066T · Substantial damage > The Balloon landed in a field and as wind drifted it, the envelope draped over a pwr line. The plt said his burner malfunctioned and caused the inaccurate landing. Another account was told later in which the plt switched to an empty propane tank for landing.… - [NTSB CHI84LA390](https://openairdocs.org/ntsb/CHI84LA390.md): Cessna 150F · Westfield, IN · Accident · Minor injuries · Limited investigation · Final report · Sep 11, 1984 · N6761F · Substantial damage > The acft collided with a powerline during landing. The plt said he 'found himself too low and gunned the engine to stay over the corn field but did not see the wires. Had never known they were there.' - [NTSB MKC84FA271](https://openairdocs.org/ntsb/MKC84FA271.md): Cessna R182 · Ottumwa, IA · Accident · Serious injuries · Field investigation · Final report · Sep 9, 1984 · N756TN · Substantial damage > The acft entered IMC weather, the plt became disoriented & cruised without ATC navigational assistance after failing to make radio contact or file a flt plan. The non-instrument rated private plt flew until acft power was lost due to fuel exhaustion. The… - [NTSB LAX84FA473](https://openairdocs.org/ntsb/LAX84FA473.md): Cessna R172K · Independence, CA · Accident · 3 fatal · Field investigation · Final report · Sep 9, 1984 · N736XF · Destroyed > The plt and two pax departed on a pleasure flt to look for a deer hunting area. Witnesses near the accident site stated that the saw the acft 'fly down the canyon on a northerly heading, reverse course and attempt to fly up the canyon.' They saw the acft… - [NTSB FTW84LA384](https://openairdocs.org/ntsb/FTW84LA384.md): Cessna 175 · Corsicana, TX · Accident · No injuries · Limited investigation · Final report · Sep 9, 1984 · N7483M · Substantial damage > The plt stated the acft lost eng power & he attempted an emerg landing in a field. During the landing roll the acft collided with a wire fence due to darkness. The exact amount of fuel remaining in the acft was not determined during removal of the acft from… - [NTSB CHI84FA383](https://openairdocs.org/ntsb/CHI84FA383.md): Cessna 172N · Lisle, IL · Accident · 2 fatal · Field investigation · Final report · Sep 9, 1984 · N5289D · Destroyed > At 0029 CDT the plt contacted a local ATCT stating that he was in IMC with 0 visibility requesting assistance and desiring to land at the closest arpt. The non-instrument rated plt was at 2,000 ft and was given a climb to 2,500 ft. the controller stated that… - [NTSB SEA84FA223](https://openairdocs.org/ntsb/SEA84FA223.md): Cessna T210M · Skamania, WA · Accident · 2 fatal · Field investigation · Final report · Sep 8, 1984 · N191WB · Destroyed > A witness, located 3 mi se of the accident site, reported hearing the acft 'rev up to a scream followed by a crash that sounded like a miniature sonic boom.' The acft contacted the terrain in an uncontrolledd descent at an elev of 2100 ft MSL. Inspection of… - [NTSB MIA84FA251](https://openairdocs.org/ntsb/MIA84FA251.md): Cessna 402C · Naples, FL · Accident · 1 fatal · Field investigation · Final report · Sep 8, 1984 · N89PB · Destroyed > Shortly after takeoff, both engs lost power & a wheels up landing was made in an open field. The acft was destroyed by impact & fire. An investigation revealed that the acft had been refuel with jet-a fuel rather than 100 low lead avgas. The lineman had… - [NTSB FTW84IA389](https://openairdocs.org/ntsb/FTW84IA389.md): Dassault/Sud FAN JET Falcon · Washington, DC · Incident · No injuries · Incident investigation · Final report · Sep 8, 1984 · N460MC · No damage > Aprx 1-1/2 hrs after take-off, the capt took sinus medication. Aprx 30 minutes later, he complained of a headache, took tylenol & alka seltzer & went to the cabin to lie down. The capt was incapacitated for the rest of the flt. The coplt & a plt rated pax… - [NTSB NYC84LA308](https://openairdocs.org/ntsb/NYC84LA308.md): Beech J35 · Hyannis, MA · Accident · No injuries · Limited investigation · Final report · Sep 7, 1984 · N12LH · Substantial damage > Aprx 30 min after departure, according to the plt, the eng began running rough and stopped about 1 min later. The gear down forced landing was made in salt water aprx 6 mins from the dest arpt. Exam of the wreckage by FAA personnel revealed that the electric… - [NTSB DEN84LA286](https://openairdocs.org/ntsb/DEN84LA286.md): Aerospatiale SA315B · Lyman, WY · Accident · Minor injuries · Limited investigation · Final report · Sep 7, 1984 · N62338 · Substantial damage > The plt stated that engine RPM began deteriorating during a climb to cruise flt. He returned to the landing site where the RPM decayed to flt idle, an autorotation was entered and a hard landing resulted. The engine ran for 1 hour in a test cell after the… - [NTSB DEN84IA281](https://openairdocs.org/ntsb/DEN84IA281.md): Mooney M20F · Saratoga, WY · Incident · No injuries · Incident investigation · Final report · Sep 5, 1984 · N9121V · Minor damage > While in level cruise flt at 10500 ft, the plt heard a high-pitched whine that lasted for about 5 seconds. The engine then seized and the plt made a forced landing in mountainous foothills. During the landing roll, the landing gearcollapsed. Examination of… - [NTSB NYC84FA295](https://openairdocs.org/ntsb/NYC84FA295.md): Aero Commander 680V · Bridgeport, CT · Accident · 1 fatal · Field investigation · Final report · Sep 4, 1984 · N100CT · Destroyed > The acft descended into the water six & 1/2 miles sw of Bridgeport, CT. The acft was on an ILS apch to rwy 06. The acft was in communication with NY TRACON arrvl radar and on his initial call had indicated a desire for a clearance direct tobridgeport. A brief… - [NTSB MIA84IA247](https://openairdocs.org/ntsb/MIA84IA247.md): Piper PA-28-161 · Dade Collier, FL · Incident · 1 fatal · Incident investigation · Final report · Sep 4, 1984 · N8330G · Minor damage > The non-rated passenger landed the acft after the plt suffered a heart attack & became totally incapacitated. During the landing, the nose gear collapsed. - [NTSB FTW84LA378](https://openairdocs.org/ntsb/FTW84LA378.md): Bell 206B · Houma, LA · Accident · Minor injuries · Limited investigation · Final report · Sep 4, 1984 · N4830 · Destroyed > The helicopter was on a cargo, non scheduled air taxi flight when the plt smelled smoke. A precautionary landing was made on a beach after which the acft was destroyed by fire. - [NTSB ANC84LA173](https://openairdocs.org/ntsb/ANC84LA173.md): Piper PA-18 · Nushagak River, AK · Accident · No injuries · Limited investigation · Final report · Sep 4, 1984 · N7690L · Substantial damage > The plt said he was flying along a River when the engine sputtered and quit. He located the nearest possible emergency landing site, switched tanks, applied carburetor heat, and pumped the throttle and primer. The engine did not restart. The wx was conducive… - [NTSB NYC84LA301](https://openairdocs.org/ntsb/NYC84LA301.md): Cessna 152II · Washington, PA · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N95035 · Substantial damage > Fuel exhaustion occurred 3.3 hrs into flt. Plt stated tanks appeared to be full on preflight but acft records showed 0.6 hrs flown on previous flight and acft not subsequently refueled. Aprx 1.5 gals found in tanks on post-mishap inspection. - [NTSB MIA84LA249](https://openairdocs.org/ntsb/MIA84LA249.md): Alon A2 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N5609F · Substantial damage > The acft collided with mail boxes during a forced landing after the engine failed. The plt said he lost all engine powerwhile climbing through 1800 ft AGL. Post crash inspection of the engine revealed that the gasket on the fuel transfer pump bowl had failed.… - [NTSB CHI84LA377](https://openairdocs.org/ntsb/CHI84LA377.md): Piper J3C-65 · Olney, IL · Accident · No injuries · Limited investigation · Final report · Sep 3, 1984 · N6620H · Substantial damage > The a/c was flown in an airshow by the owner. After he landed the acft was shut down and refueled. The refueling and the preflight were done rapidly to allow the owners son, a student plt, to leave the airport ahead of the crowd. About 3 minutes after takeoff… - [NTSB SEA84LA218](https://openairdocs.org/ntsb/SEA84LA218.md): Cessna 152 · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Sep 2, 1984 · N49141 · Destroyed > The instuctor pilot allowed the aircraft to approach mountainous terrain with insufficient altitude to counter wind conditions, reported at 35 mph. Downdrafts prevented climb to higher altitude before forcing a descent. On touchdown on a road, the left wing… - [NTSB DEN84LA276](https://openairdocs.org/ntsb/DEN84LA276.md): Molino PIK-20 · Calhan, CO · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 1984 · N858E · Substantial damage > The glider struck a barbed wire fence while landing in a pasture. The plt said he encountered a downwash at the edge of a storm that resulted in an 800 fpm rate of descent and forced landing. - [NTSB SEA84FA215](https://openairdocs.org/ntsb/SEA84FA215.md): Piper PA-28-180 · The Dalles, OR · Accident · 6 fatal · Field investigation · Final report · Sep 1, 1984 · N6499J · 2 aircraft · Destroyed > N6499J departed The Dalles municipal arpt shortly after 0930 PDT on a flt to vancouver, WA. N4622T departed chenoweth airfield ( aprx 4 NM west of The Dalles) at about 0930 PDT on a flt to The Dalles municipal arpt. A witness who observed both acft before the… - [NTSB FTW84LA377](https://openairdocs.org/ntsb/FTW84LA377.md): Cessna 177B · Texas City, TX · Accident · No injuries · Limited investigation · Final report · Sep 1, 1984 · N19953 · Substantial damage > According to the plt, during the pre-flt inspection the fuel tanks were checked by dipping his fingers into the tanks to determine how much fuel remained. Neither tank was full but the plt estimated that sufficient fuel remained for the flt. Above the fuel… - [NTSB ATL84FA277](https://openairdocs.org/ntsb/ATL84FA277.md): Bell 222 · Knoxville, TN · Accident · Serious injuries · Field investigation · Final report · Sep 1, 1984 · N22299 · Destroyed > The helicopter was in a hover when a rt pedal turn was initiated and a climb attempted. Plt stated, 'I was unable to climb, and the aircraft began to lose rotor RPM. I increased power to 100% mrtq. The acft was settling.' Unable to sustain flt, a landing was… - [NTSB ANC84LA158](https://openairdocs.org/ntsb/ANC84LA158.md): Cessna 185 · Kenai, AK · Accident · Minor injuries · Limited investigation · Final report · Sep 1, 1984 · N9712H · Substantial damage > The acft was damaged in an off arpt precautionary landing atter the engine began vibrating with the oil temperature in the red. The plt said he turned off the ELT to conserve the battery. - [NTSB ATL84FA275](https://openairdocs.org/ntsb/ATL84FA275.md): Cessna TR182 · Wilmington, NC · Accident · Serious injuries · Field investigation · Final report · Aug 31, 1984 · N5071R · Destroyed > The power loss occurred in cruise at 10,000 ft. at 0903 EDT the pilot notified Wilmington approach control that he had a 'rough engine' and requested vectors to Wilmington. Approach control responded with heading information for the back course approach and a… - [NTSB ANC84LA150](https://openairdocs.org/ntsb/ANC84LA150.md): Maule M-6 · Kiana, AK · Accident · No injuries · Limited investigation · Final report · Aug 31, 1984 · N56490 · Substantial damage > The acft made a forced landing in the kobuk sand dunes after the engine quit during cruise flt. The plt reported that the engine quit, sputtered once, picked up RPM and then quit completely. The prop windmilled until ground contact. In attempting to restart,… - [NTSB LAX84FJA02](https://openairdocs.org/ntsb/LAX84FJA02.md): Piper PA-28-140 · Wailuku Maui, HI · Accident · Serious injuries · Final report · Aug 30, 1984 · N835FC · Destroyed > The acft collided with rising terrain during a pleasure flt around Hawaii. The plt turned from the shorline inland to look at a waterfall. He started a climb from 500 ft to clear the 2000 ft level. The plt does not remember any of the accident sequence. - [NTSB LAX84FA504](https://openairdocs.org/ntsb/LAX84FA504.md): Piper PA-32R-301T · Tucson, AZ · Accident · 4 fatal · Field investigation · Final report · Aug 30, 1984 · N4575L · Destroyed > controlled flight into terrain that resulted from the pilot's failure to ensure a safe VFR altitude. The dark night, which restricted the pilot's view of terrain, was a factor in this accident. - [NTSB CHI84LA372](https://openairdocs.org/ntsb/CHI84LA372.md): Cessna 120 · Hopedale, IL · Accident · No injuries · Limited investigation · Final report · Aug 30, 1984 · N76490 · Substantial damage > The acft nosed over during a forced landing in a corn field after the engine quit. The plt said he was operating on the left tank and when the engine sputtered he realized what was wrong and even though he immediately switched tanks the engine quit and did… - [NTSB ATL84LA273](https://openairdocs.org/ntsb/ATL84LA273.md): Rockwell S2R · Shellman, GA · Accident · No injuries · Limited investigation · Final report · Aug 30, 1984 · N7771V · Destroyed > Plt was en route to airstrip after spray run when he smelled smoke. Shortly thereafter the engine surged and lost power. Plt executed a forced landing in a corn field as flames from engine area became visible. Acft damaged by post-landing fire. Investigation… - [NTSB MKC84FA264](https://openairdocs.org/ntsb/MKC84FA264.md): Cessna 177B · Bloomfield, MO · Accident · 2 fatal · Field investigation · Final report · Aug 29, 1984 · N30755 · Destroyed > N30755, collided with a radio tower guy wire and crashed three miles east of Bloomfield, MO, while on a business flight. Instrument meteorological conditons prevailed at the time of the accident. Witness stated that the low clouds obscured the top of the 80… - [NTSB CHI84LA371](https://openairdocs.org/ntsb/CHI84LA371.md): Cessna 210M · Howell, MI · Accident · No injuries · Limited investigation · Final report · Aug 29, 1984 · N732RJ · Destroyed > The plt stated that about 10 min after takeoff, the fuel flow fluctuated & slowly went to zero. He turned the aux fuel pump on, increased the mixture to rich & repositioned the fuel selector to another tank, but to no avail. The plt made a forced landing in a… - [NTSB ANC84LA147](https://openairdocs.org/ntsb/ANC84LA147.md): Cessna 207A · Sleetmute, AK · Accident · No injuries · Limited investigation · Final report · Aug 28, 1984 · N7325U · Substantial damage > While cruising at 1100 ft AGL the eng failed without warning. Efforts to restart were unsuccessful. A forced landing was made into wooded terrain and the acft nosed over during the roll. Eng exam revealed that the crankshaft was broken through the crank cheek… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=350 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=349 --- OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain, except the copies of manufacturers’ service documents, which belong to their rights holders.