# 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 358 of 718 · 35,889 cases ## Cases, newest first - [NTSB MIA84LA079](https://openairdocs.org/ntsb/MIA84LA079.md): Harvey Condor 3+2 · Lake Placid, FL · Accident · No injuries · Limited investigation · Final report · Feb 15, 1984 · N44816 · Substantial damage > The acft was damaged in a forced landing after the engine lost power. The plt reported that a parachute line contacted the engine on/off switch and shut off the engine. - [NTSB LAX84FA221](https://openairdocs.org/ntsb/LAX84FA221.md): Taylorcraft BC12D-85 · Edwards Afb, CA · Accident · 1 fatal · Field investigation · Final report · Feb 15, 1984 · N5603M · Destroyed > The acft collided with the ground and rolled inverted in the desert near Edwards Afb. Examination of the wreckage gave no evidence of a failure or malfunction of equipment. The coroner reported that the plt died of a gunshot wound to the head before the acft… - [NTSB FTW84LA133](https://openairdocs.org/ntsb/FTW84LA133.md): Piper PA-31P · Presidio, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 15, 1984 · N3PN · Destroyed > During a x-country flt the plt could not locate a refueling stop and landed 100 miles away. No refueling was accomplished and he decided to go on to his destination with the fuel remaining. Enroute his right engine coughed and herealized he was running out of… - [NTSB ANC84IA035](https://openairdocs.org/ntsb/ANC84IA035.md): Bell 47G-2A · Anchorage, AK · Incident · No injuries · Incident investigation · Final report · Feb 15, 1984 · N8495E · Minor damage > The acft tail rotor struck snow during an autorotative landing following an eng failure. The snow depth varied between 32 & 45 inches. Examination of the eng revealed that the rt hand mag was firing intermittently on two of the six distributor contacts which… - [NTSB LAX84LA179](https://openairdocs.org/ntsb/LAX84LA179.md): Cessna 150M · Vacaville, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 14, 1984 · N704JP · Substantial damage > The eng failed & the acft collided with power lines during a night forced landing. An eng exam revealed fuel in both the fuel lines & carburetor. The 0005 wx observation at travis afb, about 7 mi south of the accident site, reporteda temp of 47 deg & a… - [NTSB MIA84FA075](https://openairdocs.org/ntsb/MIA84FA075.md): Piper PA-28-140 · Pinellas Park, FL · Accident · Serious injuries · Field investigation · Final report · Feb 13, 1984 · N4501T · Destroyed > The acft crashed during a forced landing after the engine quit. After the crash no fuel was found in the fuel tanks. The plt stated that he encountered strong x-winds and deviated from planned course. When he realized fuel was low he 'declared emergency' but… - [NTSB LAX84FA178](https://openairdocs.org/ntsb/LAX84FA178.md): Beech A-36 · Coyote, CA · Accident · 1 fatal · Field investigation · Final report · Feb 13, 1984 · N67426 · Destroyed > The acft crashed in mountainous terrain during a night x-country in marginal weather. The plt made an approach to san jose, cancelled his IFR flt plan and advised he was proceeding to hollister. A common practice in the area is to fly the valley, following… - [NTSB MKC84LA072](https://openairdocs.org/ntsb/MKC84LA072.md): Cessna 150H · Conway Springs, KS · Accident · No injuries · Limited investigation · Final report · Feb 12, 1984 · N22055 · Substantial damage > When the oil access cover opened in flt, the plt made a precautionary landing on a road. During the landing roll the pltlooked down to push in the carburetor heat control and the right wing hit a pole. The acft nosed over. - [NTSB LAX84FA176](https://openairdocs.org/ntsb/LAX84FA176.md): Piper PA-28-181 · Oakland, CA · Accident · 1 fatal · Field investigation · Final report · Feb 12, 1984 · N4304K · Destroyed > The plt left the traffic pattern where the weather was VMC and proceeded northbound into IMC weather. The plt had just checked out in this acft. The field elevation of departure is 47 ft MSL. Thirteen miles north the terrain was mountainous and the acft… - [NTSB DEN84LA091](https://openairdocs.org/ntsb/DEN84LA091.md): Piper PA-24-260 · Crested Butte, CO · Accident · Minor injuries · Limited investigation · Final report · Feb 12, 1984 · N8984P · Substantial damage > The acft was damaged during a forced landing on snow covered terrain after the engine failed during climb. An investigaiton revealed that the acft had 50 weight oil in it and the temperature was about 15 degrees f. the engine had been, pre-heated from the top… - [NTSB ATL84FA095](https://openairdocs.org/ntsb/ATL84FA095.md): Cessna 172RG · Chesapeake, VA · Accident · 1 fatal · Field investigation · Final report · Feb 12, 1984 · N5299U · Destroyed > Prior to departure, the plt was twice advised that the destination wx was below most users minimums. The non-instrument rated plt then departed dulles arpt on an IFR flt plan in IMC. After departure, he did not follow assigned headings, & for a period of… - [NTSB CHI84FA107](https://openairdocs.org/ntsb/CHI84FA107.md): Cessna 150D · Wanatah, IN · Accident · 1 fatal · Field investigation · Final report · Feb 11, 1984 · N4361U · Substantial damage > At about 1716 CST, the non-instrument rated plt contacted a fss, reported he was in the clouds with about 1 hr of fuel on board & requested 'vector me someplace.' He was told that indianapolis was VFR, but the plt stated that he could not reach indianapolis &… - [NTSB MKC84FA071](https://openairdocs.org/ntsb/MKC84FA071.md): Cessna 150M · Lincoln, KS · Accident · 2 fatal · Field investigation · Final report · Feb 10, 1984 · N714GT · Destroyed > The non-instrument rated plt departed the russell control zone at night in IFR conditions by obtaining a special VFR clearance. After he reported clear of the control zone, there was no further radio contact with ATC facilities. At 0235 CST, the acft was… - [NTSB MIA84IA077](https://openairdocs.org/ntsb/MIA84IA077.md): Grumman G-73 · West Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Feb 10, 1984 · N2969 · No damage > The acft experienced an elevator trim loss, encountered extreme 'shaking and vibration' of control column and tail section fluttering while on descent to Palm Beach int'l arpt. Investigation revealed that the end of the actuator shaft failed at a rivet hole… - [NTSB LAX84LA174](https://openairdocs.org/ntsb/LAX84LA174.md): Cessna T210N · Scottsdale, AZ · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 1984 · N9423Y · Substantial damage > The acft landed in the desert 2 miles short of the rwy after a power loss during a day x-country. Investigation revealedthat the plt had instructed the refueler not to fill the tanks to the top but to leave them 1/2 to 3/4 inch below full. Inspection of the… - [NTSB FTW84LA131](https://openairdocs.org/ntsb/FTW84LA131.md): Cessna 172N · Thibodaux, LA · Accident · No injuries · Limited investigation · Final report · Feb 9, 1984 · N2103E · Substantial damage > The acft nosed over during a forced landing after the engine quit. A FBO visually inspected the wreckage acft and found little gas and a lack of fuel odor around the acft. Later the engine was refueled and ran normally. The 3 acft fuel tanks were found empty… - [NTSB CHI84LA105](https://openairdocs.org/ntsb/CHI84LA105.md): Cessna 172 · Crown Point, IN · Accident · No injuries · Limited investigation · Final report · Feb 9, 1984 · N8544U · Substantial damage > The acft nosed over during an off arpt forced landing after the engine lost power. The plt said the engine began runningrough while cruising at 5000 ft MSL before a total loss of power. The engine was examined after the accident and nothingwas wrong… - [NTSB SEA84LA050](https://openairdocs.org/ntsb/SEA84LA050.md): Hughes 269B · Las Vegas, NV · Accident · Minor injuries · Limited investigation · Final report · Feb 8, 1984 · N9509F · Substantial damage > The plt was on the return portion of a round trip from Las Vegas to mesquite, NV. & back. While cruising at about 500 ft AGL, the eng lost power & he initiated an autorotative landing on downsloping terrain. At about 50 ft AGL, he flared, then the helicopter… - [NTSB LAX84FA170](https://openairdocs.org/ntsb/LAX84FA170.md): Piper PA-31T · Riviera, AZ · Accident · Serious injuries · Field investigation · Final report · Feb 8, 1984 · N36CA · Substantial damage > Acft lost pwr on the left eng during climb to cruise aprx 8 minutes after takeoff. Arpt mgr heard UNICOM transmission from N36CA, 'we lost an eng, we're coming back.' A warning horn (possibly gear warning or stall horn) was heard in the background of the… - [NTSB LAX84LA167](https://openairdocs.org/ntsb/LAX84LA167.md): Grumman American AA-5B · Lake Havasu Cit, AZ · Accident · No injuries · Limited investigation · Final report · Feb 6, 1984 · N81317 · Substantial damage > In cruise at 8,500 ft MSL the propeller ass'y forward of the mounting flange separated from the acft. During the forced landing rollout the acft struck a tree. Airworthiness directive 82-27-01 called for inspection of the prop hub and mounting bolt hole areas… - [NTSB LAX84LA163](https://openairdocs.org/ntsb/LAX84LA163.md): Hughes 500C (369HS) · San Diego, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 5, 1984 · N8319F · Substantial damage > The plt reported a partial power loss. During the forced landing tahe right skid collapsed & the t/r severed the tail boom. During a subsequent eng test, the eng would produce no more than 20 PSI torque at 100% N2. The fuel control & fuel nozzle were found to… - [NTSB ATL84FA092](https://openairdocs.org/ntsb/ATL84FA092.md): Cessna 210 · Newport News, VA · Accident · 1 fatal · Field investigation · Final report · Feb 5, 1984 · N8437Z · Destroyed > The flight had been airborne for aprx 38 mins when the pilot began experiencing communication problems. Nine minutes later the pilot reported 'instrument problems' and began to receive radar vectors to a landing. 15 minutes later she declared an emergency and… - [NTSB NYC84FA081](https://openairdocs.org/ntsb/NYC84FA081.md): Cessna 402 · Jaffrey, NH · Accident · 2 fatal · Field investigation · Final report · Feb 3, 1984 · N6814G · Destroyed > The plt had filed an IFR flt plan; however, he took off in VFR conditions & did not activate the flt plan. Radar data showed that the latter part of the flt was flown at 6300 ft, then at 1712:39 EST, a descent was begun. One minute later, the flt was last… - [NTSB FTW84FA125](https://openairdocs.org/ntsb/FTW84FA125.md): Cessna 152 · College Station, TX · Accident · 1 fatal · Field investigation · Final report · Feb 3, 1984 · N93401 · Destroyed > The plt had received a telephone wx briefing at 1610 & an in-person wx briefing at 1932, about 45 min before takeoff. The local wx deteriorated considerably between the last briefing & the time of the accident. The acft departed at 2016, & at 2024 the acft… - [NTSB DEN84FA085](https://openairdocs.org/ntsb/DEN84FA085.md): Cessna TR182 · Tappen, ND · Accident · 1 fatal · Field investigation · Final report · Feb 3, 1984 · N737QE · Destroyed > The private non-instrument rated plt received two weather briefings before the flight. During the last briefing at 1350 MST, he was informed that VFR flt was not recommended. At 1554 MST, the acft departed crystal arpt in a westerly direction. Several… - [NTSB NYC84FHJ01](https://openairdocs.org/ntsb/NYC84FHJ01.md): Gordon Teenie TWO · Hauppauge, NY · Accident · No injuries · Final report · Feb 2, 1984 · N199MG · Substantial damage > The acft engine failed internally and oil spraying on the windshield reduced the plts visibility during the forced landing. During the rollout on a road the acft collided with a stop sign. An exam revealed there was no compression in the left rear cylinder.… - [NTSB CHI84LA099](https://openairdocs.org/ntsb/CHI84LA099.md): Cessna 150M · New Paris, OH · Accident · No injuries · Limited investigation · Final report · Feb 2, 1984 · N63452 · Substantial damage > The acft collided with a power line while practicing an emergency approach to a field. The plt stated he struck the top wire of two wires strung about 30 ft AGL. - [NTSB ATL84FA090](https://openairdocs.org/ntsb/ATL84FA090.md): Beech 23 · Loris, SC · Accident · 4 fatal · Field investigation · Final report · Feb 2, 1984 · N6141N · Destroyed > The estimated time of takeoff was about 1930 EST. The route of flt before 2000 EST was not known. At aprx 2005, the plt reported that he was unsure of his position. Shortly after that, the acft was identified over a military firing range. The plt was vectored… - [NTSB DEN84LA079](https://openairdocs.org/ntsb/DEN84LA079.md): Bell 47G-3B-1 · Ogden, UT · Accident · No injuries · Limited investigation · Final report · Jan 31, 1984 · N90769 · Substantial damage > The plt took off from a mountainous work site to return to salt lake city, UT. The wx was clear at the work site (elevation 6700 ft), but there was fog below. After encountering the fog, the plt hovered with a slow forward speed over snow covered terrain. A… - [NTSB NYC84FA078](https://openairdocs.org/ntsb/NYC84FA078.md): Dassault Falcon 10 · Trenton, NJ · Accident · No injuries · Field investigation · Final report · Jan 30, 1984 · N10AH · Substantial damage > Distracted by an interruption in taxi and departure routines, the pilot reset his altitude alert controller to two hundred feet instead of two thousand feet, his ammended clearance altitude. Taking off on instruments in the dense morning fog, the alert system… - [NTSB ATL84LA089](https://openairdocs.org/ntsb/ATL84LA089.md): Bach CGS Hawk · Newton, NC · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 1984 · N585WB · Substantial damage > Reportedly, the eng of the registered ultralight acft lost power in flt & the student plt began a forced landing however, before landing, the ultralight collided with utility wires, then it struck the ground. The plt reported that the acft had an unexpectedly… - [NTSB SEA84LA046](https://openairdocs.org/ntsb/SEA84LA046.md): Lark IS28B2 · Issaquqh, WA · Accident · No injuries · Limited investigation · Final report · Jan 29, 1984 · N4014B · Substantial damage > The CFI stated that while returnsing to the airport he encountered turbulence. When it became obvious that reaching the intended airport would be marginal another landing field was chosen. During turn to final, the left wing tip struck a power pole and the… - [NTSB LAX84LA158](https://openairdocs.org/ntsb/LAX84LA158.md): Beech J35 · Coalinga, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 29, 1984 · N8299D · Destroyed > While cruising at 8,500 ft MSL,the plt noticed a loss of all oil pressure. He secured the eng, lowered the landing gear & wing flaps, & declared an emergency stating he would attempt an eng out landing at harris ranch arpt. While descendingthrough 1,000 ft… - [NTSB CHI84LA097](https://openairdocs.org/ntsb/CHI84LA097.md): Cessna 150M · Faribault, MN · Accident · Minor injuries · Limited investigation · Final report · Jan 29, 1984 · N9205U · Substantial damage > The acft landed in a snow covered field following a partial power loss. The plt stated that he performed a preflight which included checking the fuel for contamination. Post accident investigation revealed water in the gascolator and icein the fuel lines near… - [NTSB LAX84LA161](https://openairdocs.org/ntsb/LAX84LA161.md): Cessna 401A · San Francisco, CA · Accident · No injuries · Limited investigation · Final report · Jan 28, 1984 · N7KF · Substantial damage > The acft was landed gear up after attempts to lower the gear were unsuccessful. The system malfunctioned because the nose gear jammed the main gear during retraction. The jamming occurred because the nose strut did not extend due to lackof air pressure. The… - [NTSB DEN84LA077](https://openairdocs.org/ntsb/DEN84LA077.md): Cessna 172E · Erie, CO · Accident · Minor injuries · Limited investigation · Final report · Jan 28, 1984 · N5376T · Destroyed > This acft had not had an annual inspection in more than 13 years and had not been flown in 8 years. During the accident flt the acft engine quit after 25 minutes of flt. After the forced landing a mechanic found the carburetor bowl dry and the fuel line vent… - [NTSB DEN84FA076](https://openairdocs.org/ntsb/DEN84FA076.md): Beech A36 · Columbus, NM · Accident · 2 fatal · Field investigation · Final report · Jan 28, 1984 · N719K · Destroyed > The plt took off at night in the company of plts flying 2 other acft, a Cessna 150 & a Piper PA-22. N719K, a Beech A36 bonanza, was flying ahead of the other 2 acft. The plt of 1 of the other acft stated that the bonanza plt would usually fly at a slower… - [NTSB ATL84FIJ01](https://openairdocs.org/ntsb/ATL84FIJ01.md): Cessna 150J · Elizabeth, WV · Accident · No injuries · Final report · Jan 28, 1984 · N61289 · Substantial damage > The plt reported that he departed steubenville, oh for welch, WV, to pick up a passenger and continue to parkersburg, WV. He stated that he departed steubenville with full fuel tanks and cruised at an alt of 7500 MSL. He began an enroute descent and as the… - [NTSB SEA84LA047](https://openairdocs.org/ntsb/SEA84LA047.md): Piper PA-20 · Imnaha, OR · Accident · No injuries · Limited investigation · Final report · Jan 27, 1984 · N7771K · Substantial damage > The acft nosed over during a forced landing on a snow covered field. The plt reported that the acft began to lose power at about 6500 ft MSL. An inspection of the eng did not reveal any mechanical malfunction or discrepancy. - [NTSB SEA84LA045](https://openairdocs.org/ntsb/SEA84LA045.md): Cessna 150G · Burley, ID · Accident · Minor injuries · Limited investigation · Final report · Jan 27, 1984 · N51123 · Substantial damage > The plt stated the engine lost power because of fuel exhaustion. A forced landing was performed in a field during which the acft contacted a ditch. The acft was flown 4.1 hrs since it had last been refueled. - [NTSB MIA84FA067](https://openairdocs.org/ntsb/MIA84FA067.md): Bell 206B · Stuart, FL · Accident · 1 fatal · Field investigation · Final report · Jan 27, 1984 · N51DC · Destroyed > Witnesses observed the helicopter flying at 100 to 150 ft above the water & about 100 yds offshore. They observed & heard nothing unusual, except they said the helicopter began descending until it impacted the water. The rear doors had been removed for the… - [NTSB DEN84LA099](https://openairdocs.org/ntsb/DEN84LA099.md): Champion 7EC · Wall, SD · Accident · No injuries · Limited investigation · Final report · Jan 27, 1984 · N7406B · Substantial damage > The acft crashed during a flight for the purpose of observing the plt's cattle. The plt stated he was 'making a steep left turn at about 75 feet and the bottom (left) wing flew into a wind shear on the downward side of a hill. The airplane slid to the left… - [NTSB LAX84LA155](https://openairdocs.org/ntsb/LAX84LA155.md): Beech 60 · Lake Casitas, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 26, 1984 · N300SF · Substantial damage > The plt was told by his company to deliver the recently sold acft to its new owner. During the flt, an intermediate stopwas made, but no fuel was added because the plt believed he had enough fuel. Fuel exhaustion occurred about 20 minutes after departure.… - [NTSB SEA84LA044](https://openairdocs.org/ntsb/SEA84LA044.md): Cessna T21OL · Bend, OR · Accident · No injuries · Limited investigation · Final report · Jan 25, 1984 · N2223S · Substantial damage > The plt reported that he departed boulder city, NV with 92 gal of fuel on board. About 4 hrs & 10 min later, he was forced to land when the eng lost power from fuel exhaustion. According to him, the fuel gages had been indicating normal with an indication of… - [NTSB FTW84LA118](https://openairdocs.org/ntsb/FTW84LA118.md): Bell 206L-1 · Venice, LA · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 1984 · N5745M · Substantial damage > About 10 min after departing an offshore platform, the plt encountered an area of fog. He descended to aprx 200 ft, slowed to 40 KTS & started turning back. As he was turning, he was looking to the right to locate a petroleum production facility to use as a… - [NTSB ANC84LA033](https://openairdocs.org/ntsb/ANC84LA033.md): Piper PA-18A · Anchorage, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 24, 1984 · N7286D · Substantial damage > The plt stated that just prior to the eng failure, the left fuel tank 'was empty' and the right tank contained approximately 1/8 of a tank of fuel. The plt suspected fuel starvation. - [NTSB FTW84FA121](https://openairdocs.org/ntsb/FTW84FA121.md): Piper PA-32RT-300 · New Orleans, LA · Accident · 1 fatal · Field investigation · Final report · Jan 23, 1984 · N2115D · Substantial damage > The eng quit as the acft was descending for an approach into moisant arpt & the acft was ditched in lake pontchartrain. Examination revealed that the magneto distributor block was severely cracked & both sets of breaker points were displaced away from the… - [NTSB NYC84FA072](https://openairdocs.org/ntsb/NYC84FA072.md): Cessna 152 · Barre, MA · Accident · 1 fatal · Field investigation · Final report · Jan 22, 1984 · N5536L · Destroyed > The acft was landed off the arpt tailing fire and smoke shortly after takeoff. It was a cold day and the CFI and student had trouble starting the acft even after pre-heat was used. Witnesses saw the acft after takeoff descending withsmoke and flames trailing… - [NTSB MKC84LA062](https://openairdocs.org/ntsb/MKC84LA062.md): Aero Commander 690A · Liberty, MO · Accident · No injuries · Limited investigation · Final report · Jan 21, 1984 · N83MC · Substantial damage > The plt stated that approximately 15 min from his destination the low fuel light illuminated in the cockpit. The acft was flown for approx 10 min when the engines sputtered and quit. The plt stated he 'came in too hot and bounced off the rwy, pulled the gear… - [NTSB MIA84IA064](https://openairdocs.org/ntsb/MIA84IA064.md): Douglas DC-9-51 · Tampa, FL · Incident · No injuries · Incident investigation · Final report · Jan 21, 1984 · N401EA · Minor damage > While climbing after takeoff thru about 3000 ft, the crew noted that the #2 epr had dropped about.08, from aprx 1.82 to 1.74 epr. Shortly after that, the 1st officer noted that the avm on the #2 eng was at the max indication. At about 4000 ft, there was a… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=359 ## 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=358 --- 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.