# 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 385 of 718 · 35,889 cases ## Cases, newest first - [NTSB ATL82DA126](https://openairdocs.org/ntsb/ATL82DA126.md): Piper PA-28R-180 · Front Royal, VA · Accident · Serious injuries · Final report · May 6, 1982 · N4903J · Substantial damage > During flight the aircraft engine developed a noise which the pilot described as a hissing. The pilot declared an emergency, was vectored to the nearest airport, and proceeded to shut off the engine at 5000 feet when over the airport. During the forced… - [NTSB FTW82AA167](https://openairdocs.org/ntsb/FTW82AA167.md): Beech B90 · Charlotte, TX · Accident · 7 fatal · Final report · May 5, 1982 · N98949 · Destroyed > The plt & 6 pax were returning home after fishing in Mexico. After clrg customs at laredo, TX, they departed on the next leg of the flt. The plt was clrd to 11000 ft, but got off course. He commented that an instrument had popped, he then requested 7000 ft,… - [NTSB FTW82DPG10](https://openairdocs.org/ntsb/FTW82DPG10.md): Cessna 188B · Glenwood, AR · Accident · Serious injuries · Final report · May 4, 1982 · N4458Q · Substantial damage > The pilot became disoriented while on a ferry flight. He spotted a water tower in the town of Glenwood, AR and determined that he was about 35 miles southeast of his destination. He reported that the fuel gauge indicated between 1/4 and 1/2 full after he… - [NTSB FTW82DA161](https://openairdocs.org/ntsb/FTW82DA161.md): Boeing E75 · Sterling City, TX · Accident · Minor injuries · Final report · May 3, 1982 · N5374N · Substantial damage > The pilot stated that he was flying the aircraft from devine, TX to Montana for the owner. He received about a half-hour of dual instruction in the aircraft and then departed. Several en route stops were made. The pilot stated that he checked the fuel… - [NTSB NYC82DA087](https://openairdocs.org/ntsb/NYC82DA087.md): Hiller UH-12A · New Paltz, NY · Accident · No injuries · Final report · May 2, 1982 · N116S · Substantial damage > While cruising at 400 ft AGL, the pilot noticed a decay in the main rotor RPM; however, the engine RPM was reported to have remained constant. The pilot suspected a mechanical failure and elected to make a precautionary landing in an apple orchard. During the… - [NTSB MKC82IA070](https://openairdocs.org/ntsb/MKC82IA070.md): Beech M35 · Ava, MO · Incident · No injuries · Incident investigation · Final report · May 2, 1982 · N9783R · Minor damage > During a night cross-country from pryor, ok to Ava, MO, the aircraft experienced a total electrical failure as a result of a loose alternator belt and a depleted battery. On arrival at his destination, the pilot selected gear down with the normal extension… - [NTSB MKC82DA068](https://openairdocs.org/ntsb/MKC82DA068.md): Beech M35 · Ottumwa, IA · Accident · Minor injuries · Final report · May 2, 1982 · N313Z · Substantial damage > During flight, the engine RPM exceeded its maximum limit. The pilot attempted to reduce the RPM by using the propeller control, but this had no effect. The pilot was in the process of shutting down the engine when engine oil sprayed out the cowling and onto… - [NTSB MIA82FA115](https://openairdocs.org/ntsb/MIA82FA115.md): Robinson R-22 · Ft. Pierce, FL · Accident · No injuries · Field investigation · Final report · May 1, 1982 · N90249 · Substantial damage > The student pilot was performing autorotations with 180 degree turns terminating with power recoveries. At about 200 feet, after completion of the turn, the instructor heard a rattling noise followed by a medium frequency vibration. The instructor took the… - [NTSB LAX82DA154](https://openairdocs.org/ntsb/LAX82DA154.md): Hughes 269B · North Las Vegas, NV · Accident · Minor injuries · Final report · May 1, 1982 · N9336F · Destroyed > The pilot ran out of fuel and autorotated to a hard landing. He stated the low fuel warning light never came on. He was going to use this as a signal to refuel. This would give about 15 minutes of cruise flight. The low level warning switch wiring was found… - [NTSB CHI82DA148](https://openairdocs.org/ntsb/CHI82DA148.md): Beech C35 · Dillsboro, IN · Accident · No injuries · Final report · May 1, 1982 · N8940A · Substantial damage > The aircraft operated normally during taxi, run-up, takeoff, and climb to 3500 ft MSL. About 17 miles from the departureairport, the engine stopped running. During a forced landing in a dirt field, one of the main gear failed. The propellerseparated and the… - [NTSB LAX82DA152](https://openairdocs.org/ntsb/LAX82DA152.md): Cessna 175A · Lathrop Wells, NV · Accident · Serious injuries · Final report · Apr 30, 1982 · N7058E · Substantial damage > The aircraft's engine quit while on approach to Lathrop Wells. During the emergency landing the aircraft stalled and dropped from about 15 feet AGL and came to rest inverted. Fuel was present at the accident site and the fuel selector was found midway between… - [NTSB LAX82DA151](https://openairdocs.org/ntsb/LAX82DA151.md): Beech V35B · Terminal Island, CA · Accident · No injuries · Final report · Apr 30, 1982 · N1573W · Substantial damage > The pilot and a mechanic were on a flight to test the aircraft after changing the magnetos, spark plugs, and ignition harness. During the flight, the engine began running rough, but smoothed out after the boost pump was switched on. A short time later, the… - [NTSB FTW82DA159](https://openairdocs.org/ntsb/FTW82DA159.md): Piper PA-18 · Victoria, TX · Accident · Minor injuries · Final report · Apr 30, 1982 · N186T · Substantial damage > The pilot tookoff at about 1535 to fly in the local area and then to proceed to his home at edna, TX. He flew to a ball field to observe some friends playing ball. After circling the field 3 times, he applied power and began a climb. He stated that about 30… - [NTSB DEN82DA076](https://openairdocs.org/ntsb/DEN82DA076.md): Funk B75L · Laramie, WY · Accident · No injuries · Final report · Apr 30, 1982 · N24166 · Substantial damage > According to the pilot, when the aircraft was in a mountain pass about 10 mi from the departure point, it was caught by a downdraft. Reportedly, he was forced to land on a dirt trail. During the landing, the aircraft was substantially damaged. - [NTSB ATL82DA117](https://openairdocs.org/ntsb/ATL82DA117.md): Cessna 152 · White Sulphur S, WV · Accident · Minor injuries · Final report · Apr 30, 1982 · N49924 · Destroyed > The pilot took off on runway 26 with a full load of fuel, one passenger, and luggage. The aircraft was at or near its maximum gross weight limit. The temperature was 60 degrees. The airport elevation was 1801 ft MSL and two ridge lines ran parallel to the… - [NTSB NYC82FA083](https://openairdocs.org/ntsb/NYC82FA083.md): Bell 206L · New York City, NY · Accident · No injuries · Field investigation · Final report · Apr 29, 1982 · N16959 · Substantial damage > The flt departed the 34th street heliport on a local sightseeing flt to the statue of liberty & return. As the flt crossed lower manhattan, about 1/4 mi from the east river, the plt heard the low RPM audio signal. He lowered the collective & rotor RPM… - [NTSB FTW82FA156](https://openairdocs.org/ntsb/FTW82FA156.md): Smith Aerostar 600 · Portland, TX · Accident · Minor injuries · Field investigation · Final report · Apr 29, 1982 · N133TS · Destroyed > While descending near the destination, the left engine stopped running. The pilot attempted 2 airstarts which were unsuccessful. He feathered and secured the left engine and requested radar vectors to the nearest airport. A visual approach was made to the… - [NTSB DEN82FA074](https://openairdocs.org/ntsb/DEN82FA074.md): Beech E18S · Hakalau, HI · Accident · 2 fatal · Field investigation · Final report · Apr 29, 1982 · N6911 · Destroyed > The aircraft departed hilo on the last leg of a 3 flight. A few minutes after takeoff, the pilot called the tower to askfor return and indicated he had a difficulty. No further transmission was made. Witnesses heard intermittent engine sputtering and then the… - [NTSB NYC82FA080](https://openairdocs.org/ntsb/NYC82FA080.md): MBB BO-105C · New Ringgold, PA · Accident · 4 fatal · Field investigation · Final report · Apr 28, 1982 · N1022H · Destroyed > The helicopter was leased by the allentown sacred heart hospital. At 2236 EDT, the pilot, who was standing by for duty, obtained a weather briefing. Later, at 2312, there was a request for a med-evac helicopter to respond to a car accident. The helicopter… - [NTSB LAX82FUJ40](https://openairdocs.org/ntsb/LAX82FUJ40.md): Hughes 369D · Teec Nos Pos, AZ · Accident · Serious injuries · Final report · Apr 28, 1982 · N1089S · Substantial damage > The acft lost eng power & crashed while attempting an autorotation. Eng teardown revealed that the #2 bearing failed as a result of some of the ball retainers being broken & cracked between the ball pockets. This condition allowed the impeller assembly to… - [NTSB CHI82DA140](https://openairdocs.org/ntsb/CHI82DA140.md): Beech BE-19 · Ridgeville, WI · Accident · No injuries · Final report · Apr 28, 1982 · N5204M · Substantial damage > The student pilot departed oshkosh, WI on a round robin cross country flight. The flight was destined for rockford, IL, lacrosse, WI and oshkosh. The aircraft departed oshkosh with full fuel tanks and was not refueled en route. The total duration of the… - [NTSB SEA82DYE06](https://openairdocs.org/ntsb/SEA82DYE06.md): Beech 23 · Greenwater, WA · Accident · 1 fatal · Final report · Apr 25, 1982 · N6079N · Destroyed > At about 1620 local time on 4/24/82, the aircraft departed burley, id and proceeded on a VFR flight plan to tacoma, WA. The mountains east of seattle were obscured by an overcast ceiling beginning at 3500 ft. during a descent from 10,500 ft into the seattle… - [NTSB ATL82DA115](https://openairdocs.org/ntsb/ATL82DA115.md): Piper PA-23 · Louisville, KY · Accident · No injuries · Final report · Apr 25, 1982 · N1227P · Substantial damage > The pilot stated that during level flight at 9000 ft, he noticed smoke coming from under the instrument panel, followed by a vibration for 15 to 20 seconds. He diverted and landed at Louisville, KY without further incident. An examination revealed that the… - [NTSB ATL82DA114](https://openairdocs.org/ntsb/ATL82DA114.md): Cessna 172E · Society Hill, SC · Accident · No injuries · Final report · Apr 25, 1982 · N3971S · Substantial damage > The engine quit at 4000 feet and the pilot elected to land in trees rather than a road with traffic. The aircraft ended up on small gravel road with the gear collapsed. No fuel was found in the aircraft. - [NTSB FTW82FQD10](https://openairdocs.org/ntsb/FTW82FQD10.md): Mooney M20K · Van Horn, TX · Accident · 4 fatal · Final report · Apr 23, 1982 · N99996 · Destroyed > N99996 departed riverside, CA on a flight to nacogdoches, TX the aircraft made a refueling stop in deming, NM, the last known en route position. The left seat pilot held a pvt certificate, the right seat pilot was a former FAA designated pilot examiner.… - [NTSB FTW82DA143](https://openairdocs.org/ntsb/FTW82DA143.md): Beech A60 · Garland, TX · Accident · No injuries · Final report · Apr 23, 1982 · N7RA · Substantial damage > The plane had been involved in a bankrupcy settlement and had not been flown for about 3 1/2 mths. The pilot had been sent to ferry the plane. During a run-up before takeoff, the propellers moved toward a feather position without pilot input. The pilot had a… - [NTSB CHI82DA130](https://openairdocs.org/ntsb/CHI82DA130.md): Cessna 150 · Gary, IN · Accident · No injuries · Final report · Apr 23, 1982 · N50759 · Substantial damage > The aircraft engine quit on final approach to landing at Gary municipal. A forced landing was made on a street and the aircraft collided with a street sign before nosing over into a ditch. The aircraft operator examined the aircraft at thescene and said the… - [NTSB MIA82DA106](https://openairdocs.org/ntsb/MIA82DA106.md): Piper J5A · Tampa, FL · Accident · No injuries · Final report · Apr 22, 1982 · N41141 · Substantial damage > The pilot reported that the engine malfunctioned while he was on a VFR flight. He stated that he applied carburetor heat as well as other measures to restore power. The malfunction persisted, and the plane was substantially damaged during a forced landing… - [NTSB FTW82FA145](https://openairdocs.org/ntsb/FTW82FA145.md): Bell 212 · Intracoastal Ci, LA · Accident · 2 fatal · Field investigation · Final report · Apr 22, 1982 · N5752W · Destroyed > The helicopter was in cruise flight when a sudden and severe right yaw occurred. Subsequently, it was autorotated to a ditching in rough water. Touchdown was made on top of a wave, then the helicopter rolled over. The survivors did not get the raft out.… - [NTSB FTW82DA144](https://openairdocs.org/ntsb/FTW82DA144.md): Bell 206L-1 · Cameron, LA · Accident · No injuries · Final report · Apr 22, 1982 · N2138Y · Substantial damage > N2138Y departed Cameron, LA after refueling en route to an offshore rig. Shortly after departure, while over water, the aircraft began to yaw and vibrate severely. The pilot stated that the tail rotor pedals "kicked" hard when additional power was applied.… - [NTSB MKC82FA057](https://openairdocs.org/ntsb/MKC82FA057.md): Cessna 177RG · Ste. Genevieve, MO · Accident · 2 fatal · Field investigation · Final report · Apr 20, 1982 · N1929Q · Destroyed > During the day of the accident, the pilot received 7 weather briefings which described marginal VFR conditions for his route of flight. At about 1730 CST, he departed Kansas city on a VFR flight plan to farmington, MO. During the flight, he encountered… - [NTSB LAX82DA144](https://openairdocs.org/ntsb/LAX82DA144.md): Cessna 150K · 9 Sw Santa Barb, CA · Accident · No injuries · Final report · Apr 20, 1982 · N5847G · Destroyed > The engine lost power while the pilot was spotting fish at night. He was unable to restart the engine or glide back to the shore. The plane was ditched about 3 1/2 miles from the shore and was not recovered. - [NTSB ATL82FA110](https://openairdocs.org/ntsb/ATL82FA110.md): Mitsubishi MU-2B-30 · Lafayette, GA · Accident · 6 fatal · Field investigation · Final report · Apr 20, 1982 · N165MA · Destroyed > Drg the wx briefing the plt was advised that VFR flt was not recommended due to low ceilings & poor visibility. The plt responded he had to go to ft. payne VFR because they have no instrument approach. A jeppesen us (lo)29 low alt enroute chart was found at… - [NTSB MIA82DA111](https://openairdocs.org/ntsb/MIA82DA111.md): Cessna 172N · Near Westbay, FL · Accident · 3 fatal · Final report · Apr 18, 1982 · N5186D · Destroyed > During the wx briefing the plt was advised that VFR flt was not recommended due to low ceilings & visbilities just east of panama city & along the gulf coast. At 2015, approximately 28 mi se of destin, the plt contacted eglin approach control(a/c) & was… - [NTSB LAX82DA140](https://openairdocs.org/ntsb/LAX82DA140.md): Hughes 369HS · 8 S. Of Page, AZ · Accident · 3 fatal · Final report · Apr 18, 1982 · N4EE · Destroyed > The aircraft was number two in a trail of three helicopters flying up the Colorado river at marble canyon to page, AZ when it struck an aerial cableway stretching across the river, 22 ft above the water. Witnesses stated that after the collision the… - [NTSB FTW82DA136](https://openairdocs.org/ntsb/FTW82DA136.md): Cessna 182P · Kendalia, TX · Accident · Minor injuries · Final report · Apr 18, 1982 · N79885 · Destroyed > The pilot stated that the weather conditions along his route of flight deteriorated rapidly. He decided to make a precautionary landing on a short plowed field. During final approach, the aircraft struck a tree top and crashed. - [NTSB SEA82FYP07](https://openairdocs.org/ntsb/SEA82FYP07.md): Beech 77 · Richland, WA · Accident · Serious injuries · Final report · Apr 17, 1982 · N1814B · Substantial damage > While flying over a government reservation at night, the aircraft struck the side of a mountain about 1000 ft below the mountain top. A seat belt "d-ring" failed and the pilot went through the windshield when the aircraft struck a slope of about 60 degrees.… - [NTSB LAX82DA139](https://openairdocs.org/ntsb/LAX82DA139.md): Cessna 210D · N. South Lake T, CA · Accident · No injuries · Final report · Apr 17, 1982 · N3972Y · Destroyed > After takeoff, the pilot made a normal climb to about 8500 ft. he then noticed indications of higher than normal EGT and fuel pressure and a lower than normal fuel flow. The pilot reported that he had leveled off and throttled back when the engine began to… - [NTSB ATL82DA105](https://openairdocs.org/ntsb/ATL82DA105.md): Ayres S2R-600 · Evergreen, AL · Accident · Minor injuries · Final report · Apr 17, 1982 · N4008H · Destroyed > The pilot stated that about 5 minutes after takeoff the engine skipped once, popped, then quit completely with no other warning. The aircraft was over a wooded area and was forced to land in the trees. It was determined that the aircraft was approximately 740… - [NTSB FTW82FA132](https://openairdocs.org/ntsb/FTW82FA132.md): Bell 222 · Hinton, OK · Accident · 3 fatal · Field investigation · Final report · Apr 16, 1982 · N2152J · Destroyed > Helicopter broke up in flight and fell in pieces in an open field. Weather was VMC and it was daylight. All 3 occupants were fatally injured. The breakup occurred while aircraft was in cruise flight. - [NTSB CHI82FA123](https://openairdocs.org/ntsb/CHI82FA123.md): Mooney M20J · Bird Island, MN · Accident · 3 fatal · Field investigation · Final report · Apr 16, 1982 · N3201P · Destroyed > The aircraft departed thief rivers, MN and proceeded en route to new ulm, MN. One witness near the accident site heard a noise that sounded to him like an explosion. He and other witnesses in the vicinity saw the aircraft descending out of control in a roll… - [NTSB LAX82FA136](https://openairdocs.org/ntsb/LAX82FA136.md): Schleicher ASW-20 · Tulare, CA · Accident · 1 fatal · Field investigation · Final report · Apr 15, 1982 · N6KS · 2 aircraft · Substantial damage > The glider pilot entered a thermal with three other sailplanes and began to climb. Two of the sailplanes were about 1000 ft below him and the other plane was about 500 ft above. As the pilot was climbing to about 4000 ft MSL, he lost sight to the sailplane… - [NTSB LAX82DA159](https://openairdocs.org/ntsb/LAX82DA159.md): Grumman AA-5B · Paulden, AZ · Accident · No injuries · Final report · Apr 15, 1982 · N34ER · Substantial damage > During a simulated forced landing after following the prescribed restart procedures the student, under the supervision of the instructor, executed her securing procedures. It was the instructor's policy to let the student actually move the proper control then… - [NTSB DEN82DA068](https://openairdocs.org/ntsb/DEN82DA068.md): Cessna 182A · 20mn Of Jackson, WY · Accident · No injuries · Final report · Apr 15, 1982 · N3748D · Substantial damage > The pilot reported that he became involved in a deteriorating weather condition while maneuvering in a mountainous area. He attempted to return to the departure airport, but the weather conditions (snowshowers) became worse. He elected to make a precautionary… - [NTSB DEN82DA060](https://openairdocs.org/ntsb/DEN82DA060.md): Cessna 170B · Worden, MT · Accident · No injuries · Final report · Apr 15, 1982 · N3415D · Substantial damage > The pilot reported that the carburetor heat control became inoperative while on a cross-country flight. The weather conditions were conducive to the formation of carburetor ice. A decision was made to land in an alfalfa field while the engine was still… - [NTSB ANC82FA035](https://openairdocs.org/ntsb/ANC82FA035.md): Sud SA 318C · Near Savoonga, AK · Accident · 2 fatal · Field investigation · Final report · Apr 15, 1982 · N9367 · Substantial damage > At 0746 LCL time, the plt activated his VFR flt plan for a round robin flt from nome, AK to Savoonga, NE cape, Savoonga, se cape, Savoonga & back to nome. After arriving at Savoonga, the helicopter was refueled. According to svrl villagers, the wx at that… - [NTSB FTW82DA130](https://openairdocs.org/ntsb/FTW82DA130.md): Goodyear FGID(F4U) · Forney, TX · Accident · No injuries · Final report · Apr 14, 1982 · N9964Z · Substantial damage > Following the last aerobatic manuever, a loop, and while in straight and level flight, the low oil pressure light illuminated. The oil pressure decreased to zero and shortly thereafter propeller control was lost. Due to a rough running engine an emergency… - [NTSB NYC82FHM05](https://openairdocs.org/ntsb/NYC82FHM05.md): Piper Aerostar 602P · Tetersboro, NJ · Accident · Minor injuries · Final report · Apr 13, 1982 · N6896T · Substantial damage > While approaching the teterboro airport, the pilot encountered a bird strike which broke the windscreen. The pilot reported that he was partially blinded with blood and feathers. He regained his sight and landed the aircraft at teterboro. - [NTSB MIA82DA096](https://openairdocs.org/ntsb/MIA82DA096.md): Hughes 269B · Near Kissimmee, FL · Accident · Minor injuries · Final report · Apr 12, 1982 · N9393F · Substantial damage > The engine lost power while the pilot was on a low altitude aerial observation flight over trees. He attempted to land on a nearby road. While approaching the road at 10 to 15 ft AGL, he ran out of RPM. He hit the ground flat, but did not roll over. - [NTSB MKC82FCA08](https://openairdocs.org/ntsb/MKC82FCA08.md): Bell 47G-4 · St Genevieve, MO · Accident · Serious injuries · Final report · Apr 11, 1982 · N87623 · Substantial damage > The pilot reported that about 40 minutes after takeoff, there was a drop in oil pressure followed almost immediately by an engine failure. The engine failure occurred over a wooded area. The pilot attempted an emergency landing in a small clearing, but the… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=386 ## 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=385 --- 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.