# 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 386 of 718 · 35,889 cases ## Cases, newest first - [NTSB LAX82FA134](https://openairdocs.org/ntsb/LAX82FA134.md): Cessna 182M · Lake Hughes, CA · Accident · 3 fatal · Field investigation · Final report · Apr 11, 1982 · N70939 · Destroyed > The pilot requested the en route weather conditions at 1545, 1625, 1732 and 2150 PST from the bakersfield fss. The pilot was informed, on each occasion, that VFR flight was not recommended; however, at 2213 the pilot departed bakersfield. No flight plan was… - [NTSB ANC82FA036](https://openairdocs.org/ntsb/ANC82FA036.md): Hughes 369D · Near Tanana, AK · Accident · 3 fatal · Field investigation · Final report · Apr 11, 1982 · N11058 · Destroyed > The aircraft crashed on a snow covered mountain slope while in a steep left bank/nose low turn. The 1754 ast weather at Tanana, AK (19 NM sse) was, in part: 1800 ft broken, 3500 ft overcast, visibility 7 mi with light snow, wind 320 deg at 18 KTS. Flight… - [NTSB LAX82DA132](https://openairdocs.org/ntsb/LAX82DA132.md): Cessna 150 · Tuscon, AZ · Accident · No injuries · Final report · Apr 10, 1982 · N6497S · Substantial damage > The pilot stated that he filled the fuel tanks with 22 gallons of fuel. Three hours and 15 minutes after takeoff, he ran out of fuel. He made a forced landing about 1.5 miles from the intended destination and encountered desert shrubbery. - [NTSB SEA82DA049](https://openairdocs.org/ntsb/SEA82DA049.md): Piper PA-28-181 · Spokane, WA · Accident · No injuries · Final report · Apr 9, 1982 · N80769 · Substantial damage > Student pilot/copilot reset the aircraft clock in anticipation of the time zone change that would occur in flight. This caused the pilot to think he had another hour of flight time. In addition the fuel gage was found to show fuel in the right tank when all… - [NTSB SEA82DA048](https://openairdocs.org/ntsb/SEA82DA048.md): Piper PA-25-235 · Basin City, WA · Accident · No injuries · Final report · Apr 9, 1982 · N9546P · Substantial damage > During a return trip to the landing area from a dusting run the engine stopped. The main landing gear caught wires during an attempted landing to a field and the aircraft turned over before colliding with the ground. The fuel tanks were found empty and the… - [NTSB FTW82DA124](https://openairdocs.org/ntsb/FTW82DA124.md): Cessna 152 · Lafayette, LA · Accident · No injuries · Final report · Apr 9, 1982 · N5361M · Substantial damage > En route to Lafayette, LA on a cross country the engine quit. A forced landing in a soft plowed field caused the landing gear to separate and the aircraft to nose over. - [NTSB FTW82DA119](https://openairdocs.org/ntsb/FTW82DA119.md): Cessna 150 · Santa Fe, NM · Accident · Minor injuries · Final report · Apr 9, 1982 · N5870E · Substantial damage > One blade of the propeller failed in cruise. Power was reduced due to vibration and a forced landing was made. During the hard landing on upslope rangeland the landing gear failed. - [NTSB FTW82DA117](https://openairdocs.org/ntsb/FTW82DA117.md): Beech C-18S · Hereford, TX · Accident · No injuries · Final report · Apr 9, 1982 · N64463 · Substantial damage > The pilot experienced total electrical failure during flight. Before landing he allowed the gear to free fall and attempted to crank it into the fully extended and locked position. When the crank would not turn he assumed the gear was in the locked down… - [NTSB ANC82DA033](https://openairdocs.org/ntsb/ANC82DA033.md): Cessna 206 · Near Nightmute, AK · Accident · Minor injuries · Final report · Apr 9, 1982 · N9938M · Substantial damage > The pilot stated that during flight the aircraft inadvertently drifted north of his intended flight path into an area of higher terrain. When the aircraft encountered a whiteout condition the pilot elected to turn to the right toward what he observed as… - [NTSB ATL82DA097](https://openairdocs.org/ntsb/ATL82DA097.md): Cessna 172 · Brook Haven, MS · Accident · No injuries · Final report · Apr 8, 1982 · N6444B · Substantial damage > The pilot visually checked the fuel level before takeoff and estimated that he had 15 to 16 gallons remaining. Since the flight was planned for 30 to 45 minutes, no fuel was added. However, after flying for 30 to 35 minutes, the engine lost power. The pilot… - [NTSB DEN82FA056](https://openairdocs.org/ntsb/DEN82FA056.md): Cessna 320F · Missoula, MT · Accident · 3 fatal · Field investigation · Final report · Apr 7, 1982 · N999LS · Destroyed > During arrival for an ILS-2 approach to runway 11, the pilot was advised to hold at the kona NDB while snowplows finished clearing the runway. At that time, the Missoula weather was 1200 ft obscured, 2 mi visibility with light snow and fog, temperature and… - [NTSB SEA82FA046](https://openairdocs.org/ntsb/SEA82FA046.md): Cessna 177RG · 10 East Of Till, OR · Accident · Serious injuries · Field investigation · Final report · Apr 6, 1982 · N2114Q · Substantial damage > During flight at 13,000 ft MSL, the engine began losing power. The aircraft was vectored toward the prospect airport near tiller, Oregon. However, about two minutes later, all engine power was lost. During a forced landing, the aircraft struck a dead… - [NTSB NYC82FGM10](https://openairdocs.org/ntsb/NYC82FGM10.md): Beech E55 · Scandia, PA · Accident · 2 fatal · Final report · Apr 6, 1982 · N4375A · Destroyed > At 0834 EST, the pilot departed bradford airport on an IFR flight to alton, IL. About 4 minutes later, he advised that he was having difficulty with his flight instruments while in IFR conditions. He attempted to return to the departure airport by using d.f.… - [NTSB DEN82FA057](https://openairdocs.org/ntsb/DEN82FA057.md): Mooney M20B · Near Salida, CO · Accident · 2 fatal · Field investigation · Final report · Apr 6, 1982 · N74734 · Destroyed > After departing Salida at approximately 0820 the plt radioed over UNICOM that the clouds in the local area had bases of 12,500 ft MSL & tops at 16,500 ft MSL. About 15 min later the acft impacted a mountain at the 13,500 ft level. There were flt precautions… - [NTSB ATL82DA095](https://openairdocs.org/ntsb/ATL82DA095.md): Piper PA-24-250 · Tazewell, VA · Accident · No injuries · Final report · Apr 6, 1982 · N7841P · Substantial damage > The pilot stated that the engine failed at 8000 ft in clear air and level flight. He immediately attempted to switch the fuel selector to one of the two remaining full fuel tanks but the selector would not move. After repeated attempts to switch tanks using a… - [NTSB ATL82FA092](https://openairdocs.org/ntsb/ATL82FA092.md): Piper PA-31-350 · Baconton, GA · Accident · Serious injuries · Field investigation · Final report · Apr 5, 1982 · N123CB · Destroyed > As the pilot was descending from 7000 to 5000 ft, he heard a loud bang, followed by a temporary vibration and a violent swerve to the right. He looked out the right window and thought the right engine had fallen off since all he could see was the tops of the… - [NTSB MIA82DA093](https://openairdocs.org/ntsb/MIA82DA093.md): Cessna 182 · Quincy, FL · Accident · No injuries · Final report · Apr 4, 1982 · N4049D · Substantial damage > After completing the drop on a skydiving flight, the engine lost power during a power-off descent. The pilot reported that the carburetor heat was not used during the descent prior to the loss of power. However, the probability of weather conditions for… - [NTSB NYC82DA068](https://openairdocs.org/ntsb/NYC82DA068.md): Cessna 150M · Washington, CT · Accident · No injuries · Final report · Apr 3, 1982 · N7652U · Substantial damage > While practicing power on stalls and gliding turns the pilot stated that the engine would not respond with half throttle. A forced landing was made after passing up two rough fields for a more distant one at a higher altitude. The pilot stated he should have… - [NTSB MIA82IA110](https://openairdocs.org/ntsb/MIA82IA110.md): Piper PA-31-350 · Tallahassee, FL · Incident · No injuries · Incident investigation · Final report · Apr 3, 1982 · N41045 · Minor damage > While cruising at 8000 feet, the right alternator light came on and the pilot accomplished the required procedures for an alternator failure. Shortly thereafter, he noticed an area of discoloration on the inboard nacelle of the right engine and saw flames… - [NTSB MIA82DA127](https://openairdocs.org/ntsb/MIA82DA127.md): Piper PA-18 · Hollywood, FL · Accident · No injuries · Final report · Apr 3, 1982 · N294T · Destroyed > The pilot was towing a banner along a beach when the engine failed. He landed in the water just offshore and escaped without injury. The aircraft was subsequently destroyed by the surf. An examination of the engine revealed that the no. 3 cylinder had… - [NTSB LAX82DA125](https://openairdocs.org/ntsb/LAX82DA125.md): Cessna 150 · Death Valley, CA · Accident · No injuries · Final report · Apr 3, 1982 · N5682E · Substantial damage > The pilot reported that during a cross-country flight, the engine began running rough and decreasing thrust resulted in a forced landing. While landing on a soft, dry lake bed, the plane crossed a small wash where the nose gear collapsed and the aircraft… - [NTSB FTW82DQG17](https://openairdocs.org/ntsb/FTW82DQG17.md): Balloon Works 7-B · Masterson, TX · Accident · Serious injuries · Final report · Apr 3, 1982 · N1524U · Minor damage > After making weather observations and obtaining a weather briefing, the instructor pilot (ip) briefed the chase crew of the expected northerly track. The ip and student took off at 0705 CST and ascended to 1200 to 15000 ft AGL and began tracking… - [NTSB ATL82FKG10](https://openairdocs.org/ntsb/ATL82FKG10.md): Beech A36 · Darien, GA · Accident · 2 fatal · Final report · Apr 3, 1982 · N4382W · Destroyed > The pilot filed a VFR flight plan, but did not activate it after takeoff. While en route, he encountered deteriorating weather and obtained an IFR clearance. As he continued, he entered an area of thunderstorms, turbulence, and heavy rain. As the pilot was… - [NTSB SEA82DA044](https://openairdocs.org/ntsb/SEA82DA044.md): Hiller UH-12E · Near Toutle, WA · Accident · No injuries · Final report · Apr 2, 1982 · N9060F · Substantial damage > About 1 1/2 minutes after takeoff, the pilot heard a loud "bang" which was followed by a vertical and lateral vibration. The helicopter began to descend, pitch forward, and roll right as the vibration increased. The pilot elected to make an autorotative… - [NTSB MIA82FKT09](https://openairdocs.org/ntsb/MIA82FKT09.md): Piper PA-36 · Delray Beach, FL · Accident · Minor injuries · Final report · Apr 2, 1982 · N57750 · Substantial damage > While climbing after takeoff, the pilot noted a partial loss of power. He thought he could smell smoke and turned the master and alternator switches off. The engine continued to lose power and the pilot dumped the load. He elected to land in a canal. As he… - [NTSB DEN82FA054](https://openairdocs.org/ntsb/DEN82FA054.md): Beech M35 · Lamar, CO · Accident · 4 fatal · Field investigation · Final report · Apr 2, 1982 · N9733R · Destroyed > During the wx briefing the plt was advised that the wx along his proposed route of flt would be generally good VFR with the exception of possible turbulence & that blowing dust would be the big problem. There were pireps of 65K winds at 3,000 ft over Oklahoma… - [NTSB CHI82FA110](https://openairdocs.org/ntsb/CHI82FA110.md): Cessna 210N · Wadsworth, OH · Accident · Minor injuries · Field investigation · Final report · Apr 2, 1982 · N7599P · Substantial damage > While descending through about 4500 ft MSL, the pilot heard a rattling sound in the engine and noticed a loss of power. He declared an emergency and was provided vectors to the Wadsworth municipal airport. However, he was unable to reach the airfield. The… - [NTSB ATL82IA103](https://openairdocs.org/ntsb/ATL82IA103.md): Piper PA-31P · Savannah, GA · Incident · No injuries · Incident investigation · Final report · Apr 2, 1982 · N25MA · Minor damage > During flight, electrical fumes, smoke and sparks began emitting from the circuit breaker panel immediately left of the pilot's seat. The pilot was forced to move to the right seat. He tried to suppress the sparks with a chemical fire extinguisher and tried… - [NTSB LAX82DA126](https://openairdocs.org/ntsb/LAX82DA126.md): Cessna 206-F · Winters, CA · Accident · No injuries · Final report · Apr 1, 1982 · N35919 · Substantial damage > After takeoff as the aircraft climbed through 550 feet AGL the engine lost power. The pilot attempted to turn the aircraft around and land on a taxiway but landed in a soft area near it. The nose gear collapsed and the aircraft slid across the taxiway and… - [NTSB FTW82FA109](https://openairdocs.org/ntsb/FTW82FA109.md): Beech B35 · Dulce, NM · Accident · 2 fatal · Field investigation · Final report · Mar 30, 1982 · N5237C · Destroyed > Approximately 30 min after departure the acft returned to the arpt trailing smoke & occassional flame from an area near the cowl flaps & nose gear doors. The plt did not make a straight in approach but appeared to be in a normal traffic pattern. The acft… - [NTSB DEN82DA052](https://openairdocs.org/ntsb/DEN82DA052.md): Cessna 180K · Montrose, CO · Accident · Minor injuries · Final report · Mar 30, 1982 · N2809K · Destroyed > During flight over mountainous terrain, the pilot encountered "horizontal snow squalls." He reported that he flew through the snow squall for about 25 miles while maintaining ground contact. He approached a cloud layer, but was able to fly over it at 16,500… - [NTSB NYC82FNA12](https://openairdocs.org/ntsb/NYC82FNA12.md): Piper PA-32R · Rochester, MA · Accident · Serious injuries · Final report · Mar 29, 1982 · N1104Q · Substantial damage > The pilot reported that while he was en route, a power loss occurred and he was unable to restart the engine. He selected a clearing for a forced landing, but was unable to reach it. A crash landing, but was made in an area of trees and brush. An… - [NTSB MIA82FA088](https://openairdocs.org/ntsb/MIA82FA088.md): Mooney M2OJ · Ormond Beach, FL · Accident · 2 fatal · Field investigation · Final report · Mar 29, 1982 · N1118R · Destroyed > The non-instrument rated pilot had filed for an IFR climb to vfr-on-top. He took off after receiving a clearance to the bulli intersection with instructions to maintain 9000 ft, if not vfr-on-top by that altitude. At 1720 EST, the pilot transmitted that he… - [NTSB FTW82DA105](https://openairdocs.org/ntsb/FTW82DA105.md): Piper PA-28-180 · Norman, OK · Accident · No injuries · Final report · Mar 29, 1982 · N2153T · Substantial damage > The aircraft's engine quit 15 minutes short of the destination on a cross country flight. The aircraft had 36 gallons of fuel on departure at 1600 CST and the accident occurred at 1915. A forced landing was made on a street in Norman, Oklahoma. - [NTSB ATL82DA088](https://openairdocs.org/ntsb/ATL82DA088.md): Piper PA-24-250 · Macon, GA · Accident · No injuries · Final report · Mar 29, 1982 · N9LT · Substantial damage > The non-instrument rated pilot reported departing ft lauderdale, FL with 4 hrs of fuel on board on a 40 minute flight to okeechobee, FL. The next day, he departed okeechobee without refueling on a flight to Macon, GA. He reported that he had to climb to… - [NTSB FTW82DA104](https://openairdocs.org/ntsb/FTW82DA104.md): Cessna T210N · Pampa, TX · Accident · No injuries · Final report · Mar 27, 1982 · N6220C · Substantial damage > While en route, the pilot encountered icing conditions as he got near his destination and was unable to maintain altitude. Subsequently, he made an off airport landing and the plane was damaged. - [NTSB ATL82FA086](https://openairdocs.org/ntsb/ATL82FA086.md): Mooney M20F · Mchenry, MD · Accident · 3 fatal · Field investigation · Final report · Mar 27, 1982 · N6896V · Destroyed > At 0635 the plt received a wx briefing which included forecasted icing conditions along his route of flt. At 1215 received an updated briefing & was informed that IMC existed along his route of flt & VFR flt was not recommended. At 1536 he called & received… - [NTSB NYC82DA065](https://openairdocs.org/ntsb/NYC82DA065.md): Piper PA-28R-180 · Perry Warsaw, NY · Accident · No injuries · Final report · Mar 26, 1982 · N4909J · Substantial damage > The pilot elected to takeoff at night with low visibility, rain, and fog. Soon after takeoff visual ground contact was lost due to what the pilot stated as quickly lowering ceilings and visibility. The pilot then decided to make a precautionary landing in a… - [NTSB NYC82DA063](https://openairdocs.org/ntsb/NYC82DA063.md): Cessna 152 · East Aurora, NY · Accident · No injuries · Final report · Mar 26, 1982 · N757HZ · Substantial damage > During a local flight in marginal weather conditions with light snow, there was a gradual loss of power. At first, the instructor thought the student had throttled back and told him to increase the power. When the instructor realized the problem, he took the… - [NTSB FTW82FA103](https://openairdocs.org/ntsb/FTW82FA103.md): Beech 58 · Magdalena, NM · Accident · 6 fatal · Field investigation · Final report · Mar 26, 1982 · N36969 · Destroyed > The plt was advised of the icing conditions to be expected three different times during his wx briefing. At 1524 while enroute at 14,000 ft, the plt was advised of a PIREP of light to moderate icing between 14,O00 & 22,000 ft. the plt replied that was about… - [NTSB MKC82FCJ02](https://openairdocs.org/ntsb/MKC82FCJ02.md): Piper PA-28-140 · Davenport, NE · Accident · 1 fatal · Final report · Mar 25, 1982 · N32329 · Destroyed > At 1242 CST, the pilot received a weather briefing including a forecast of marginal VFR conditions at the destination. Between 1649 and 1848 CST, there were three weather reports from the destination of ceilings between 300 and 500 ft, visibilities between… - [NTSB MIA82DA085](https://openairdocs.org/ntsb/MIA82DA085.md): Piper PA-38-112 · Jasper, FL · Accident · No injuries · Final report · Mar 25, 1982 · N2558C · Substantial damage > While on a cable inspection mission at 500 ft MSL, the engine began to lose power after the pilot had made an erratic maneuver to avoid birds. He initiated emergency procedures to restore power, but was unable. The nose gear failed and the aircraft flipped… - [NTSB CHI82DA101](https://openairdocs.org/ntsb/CHI82DA101.md): Cessna 150 · West Chicago, IL · Accident · Minor injuries · Final report · Mar 25, 1982 · N9239U · Substantial damage > The student and an instructor had previously flown this aircraft to recertify the student for solo flight. After the dual flight, the student had some problem with obtaining fuel and took off without refueling. While flying at night, the student became lost.… - [NTSB MIA82DA084](https://openairdocs.org/ntsb/MIA82DA084.md): Rockwell Commander AC-100 · Chipley, FL · Accident · No injuries · Final report · Mar 24, 1982 · N3870X · Substantial damage > The student pilot/mechanic was attempting to fly the aircraft from where the owner kept the aircraft to the maintainance facility approximately 4 miles away. The pilot stated that just after level off the engine quit. A road was selected to land on but at the… - [NTSB CHI82DA097](https://openairdocs.org/ntsb/CHI82DA097.md): Cessna 150 · Wheeling, IL · Accident · No injuries · Final report · Mar 24, 1982 · N714KR · Substantial damage > The student pilot departed Wheeling, IL on a cross-country flight to dubuque, IA; oshkosh, WI and return. The pilot refueled with 17.7 gallons of 100 octane low-lead gasoline at dubuque, but did not refuel at oshkosh. Near milwaukee, he noted that the right… - [NTSB LAX82FA117](https://openairdocs.org/ntsb/LAX82FA117.md): Aerospatiale SA316B · Near Brideport, CA · Accident · Serious injuries · Field investigation · Final report · Mar 22, 1982 · N9829C · Destroyed > After taking off in a mountainous area, the pilot began climbing in up-currents on the side of a canyon. While following a ridge at about 100 ft AGL (11,000 ft MSL), he heard a loud noise that was followed by a shudder and vibrations. The helicopter began… - [NTSB FTW82DA101](https://openairdocs.org/ntsb/FTW82DA101.md): Snow AT-301 · Spearman, TX · Accident · No injuries · Final report · Mar 22, 1982 · N2326S · Substantial damage > When the aircraft lost power after spraying crops the pilot executed a forced landing in a field. During the landing the aircraft nosed over. Investigation revealed that an induction hose had failed and blocked the carburetor. A service letter relating to… - [NTSB NYC82FA060](https://openairdocs.org/ntsb/NYC82FA060.md): Cessna U206G · Stratford, NH · Accident · 2 fatal · Field investigation · Final report · Mar 21, 1982 · N734KJ · Destroyed > Before takeoff, the pilot received a partial weather briefing by telephone. He was advised of reported icing conditions and was told that snow and rain showers were moving through the area causing marginal VFR conditions. Before terminating the conversation,… - [NTSB LAX82DA114](https://openairdocs.org/ntsb/LAX82DA114.md): Cessna 150 · Delano, CA · Accident · No injuries · Final report · Mar 21, 1982 · N63335 · Destroyed > The student made a scheduled stop at lompoc, California, but was unable to obtain 80 octane fuel. He then flew to santa maria, California, which was not a part of his planned flight. He was also unable to get 80 octane fuel at santa maria. From there, he… - [NTSB MKC82DA046](https://openairdocs.org/ntsb/MKC82DA046.md): Enstrom F-28A · Parsons, KS · Accident · No injuries · Final report · Mar 20, 1982 · N101AE · Substantial damage > The pilot was rated in fixed wing aircraft, but he was a student pilot in helicopters. He had only 40 hours in rotorcraft. During a cross-country in his own helicopter, he ran out of fuel and struck trees during an auto-rotative landing. The pilot stated that… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=387 ## 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=386 --- 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.