# NTSB investigations: Approach NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports. Page 220 of 420 · 20,992 cases ## Cases, newest first - [NTSB NYC82FHD09](https://openairdocs.org/ntsb/NYC82FHD09.md): Luscombe 8F · Essington, PA · Accident · Minor injuries · Final report · Apr 25, 1982 · N1552B · Destroyed > The float equipped Luscombe stalled during fanal approach to a water landing near a dock. There was considerable rotorcraft activity near the seaplane base due to the presence of the queen elizabeth ii ocean liner. - [NTSB NYC82DNC08](https://openairdocs.org/ntsb/NYC82DNC08.md): Schleicher ASW-19 · Moultonboro, NH · Accident · Serious injuries · Final report · Apr 25, 1982 · N79RC · Destroyed > Several witnesses saw the glider circle over the airport before it crashed. One of the witnesses reported that the glider was about 50 to 100 ft high and was coming in normally when it suddenly nose-dived and headed almost vertically toward the ground. The… - [NTSB LAX82FVD14](https://openairdocs.org/ntsb/LAX82FVD14.md): Cessna 172N · Hayward, CA · Accident · Minor injuries · Final report · Apr 25, 1982 · N21551 · Substantial damage > While on final approach for a simulated short field landing, the engine lost power. The pilots were unable to restart the engine, and the aircraft struck a fence and nosed over during the landing. Conditions were favorable for carburetor ice, but the… - [NTSB CHI82DA139](https://openairdocs.org/ntsb/CHI82DA139.md): Cessna 150M · Cortland, OH · Accident · No injuries · Final report · Apr 25, 1982 · N45476 · Substantial damage > The pilot stated that he was on final approach with flaps at 40 degrees and with an airspeed of 60 mph. The tail of the aircraft collided with a high tension wire forcing the nose down into a rail airport fence. The weather information for denman field was… - [NTSB CHI82DA137](https://openairdocs.org/ntsb/CHI82DA137.md): Cessna 150 · Blaine, MN · Accident · No injuries · Final report · Apr 24, 1982 · N5729E · Substantial damage > While on final approach the pilot stated that the engine lost power. The aircraft landed about 700 feet short of the runway in rough terrain. Investigation disclosed at least 1 1/2 pints of water in the left fuel tank, water in the carburetor bowl, and the… - [NTSB CHI82DA131](https://openairdocs.org/ntsb/CHI82DA131.md): Hartman KR-II · Columbus, OH · Accident · No injuries · Final report · Apr 24, 1982 · N58RH · Substantial damage > On final approach the aircraft settled and collided with trees that were located approximately 75 ft from the approach end of the runway. The pilot stated that he allowed his airspeed to become too slow and that he applied power but the right wing caught a… - [NTSB ATL82FKG11](https://openairdocs.org/ntsb/ATL82FKG11.md): Cessna 210 · Lexington, GA · Accident · 2 fatal · Final report · Apr 24, 1982 · N4614Q · Destroyed > In the early morning hours on 4/23/82, the aircraft departed covington, GA and proceeded on an undetermined route. At about 2300 PST that night, residents near the accident site heard the sounds of a crash. The wreckage was found the next morning about 1000… - [NTSB NYC82DA077](https://openairdocs.org/ntsb/NYC82DA077.md): Cessna 172D · Endicott, NY · Accident · No injuries · Final report · Apr 22, 1982 · N2456Y · Substantial damage > While en route from poughkeepsie to utica, NY, the pilot became disoriented and obtained radar vectors. He elected to land at the tri-cities airport, Endicott, NY when the plane was getting low on fuel. Gusty winds were encountered during the approach. The… - [NTSB LAX82DA146](https://openairdocs.org/ntsb/LAX82DA146.md): Piper PA-38-112 · Apple Valley, CA · Accident · 1 fatal · Final report · Apr 22, 1982 · N24082 · Destroyed > Witnesses observed the aircraft to be gliding on final approach with the engine at idle when it abruptly pitched nose down and struck the ground. The engine and both leading edges of the wings contacted the ground at the same time with no turning movement.… - [NTSB MKC82IA059](https://openairdocs.org/ntsb/MKC82IA059.md): Rockwell NA-265-65 · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Apr 20, 1982 · N2N · Minor damage > While enroute from grand island, NE to nashville, TN, the pilot noticed that the aircraft would not trim nose down, but that it would trim nose up normally. The pilot reduced speed and altitude and diverted to St. Louis, MO in order to have the problem… - [NTSB NYC82DA073](https://openairdocs.org/ntsb/NYC82DA073.md): Fairchild PT-19 · Butler, PA · Accident · No injuries · Final report · Apr 18, 1982 · N49942 · Substantial damage > The instructor pilot was flying with the owner of the aircraft to help him get acquainted with his plane. While on final approach, the owner let the aircraft get low. He corrected by adding power, but reportedly raised the nose beyond the stall angle. The… - [NTSB FTW82DA134](https://openairdocs.org/ntsb/FTW82DA134.md): Maule M-5-210C · Kirbyville, TX · Accident · No injuries · Final report · Apr 18, 1982 · N62003 · Substantial damage > On 4/17/82, N62003 departed woodville, TX under visual meteorological conditions on a flight to Kirbyville, TX. The pilot stated that the attitude gyro had always been slow to erect and was still showing 10 degrees right bank when he arrived at Kirbyville. He… - [NTSB CHI82FA127](https://openairdocs.org/ntsb/CHI82FA127.md): Cessna 411 · Middlefield, OH · Accident · 5 fatal · Field investigation · Final report · Apr 18, 1982 · N3228R · Destroyed > The purpose of the flt was to prepare for a FAA part 135 air taxi check ride which was scheduled later that week. The acft was observed during the approach with one eng shut down. During the turn to final the acft crashed 1/2 mi from rwy 28. - [NTSB CHI82DA124](https://openairdocs.org/ntsb/CHI82DA124.md): Cessna 172 · Salem, OH · Accident · No injuries · Final report · Apr 18, 1982 · N13226 · Substantial damage > After returning from a local flight, the engine lost power before landing. The plane crashed about 35 ft from the approach end of runway 27. Two telephone poles were damaged. The wind was gusting to 35 knots. An examination of the engine revealed a… - [NTSB ATL82DA108](https://openairdocs.org/ntsb/ATL82DA108.md): Beech C23-180 · Greensboro, NC · Accident · No injuries · Final report · Apr 18, 1982 · N2229L · Substantial damage > The pilot stated that he experienced a failure of the right brake system preventing him from maintaining directional control during ground roll after landing on runway 09. The mechanic who removed the aircraft from the accident scene reported that tire tracks… - [NTSB MKC82DA066](https://openairdocs.org/ntsb/MKC82DA066.md): Beech B-19 · West Union, IA · Accident · No injuries · Final report · Apr 17, 1982 · N24582 · Substantial damage > The pilot was flying his newly purchased aircraft from cedar rapids, Iowa to West Union, Iowa. He had purchased the aircraft on the previous day and had received a checkout from the seller. The pilot reported that when he was on final approach, the aircraft… - [NTSB LAX82DUJ35](https://openairdocs.org/ntsb/LAX82DUJ35.md): Schweizer SGS 1-126E · Near Tucson, AZ · Accident · Serious injuries · Final report · Apr 17, 1982 · N65937 · Destroyed > The pilot was on a triangular round-robin course. On the third leg of the flight, he encounter unfavorable lift conditions and elected to land on a dirt road. He started a 270 deg turn to final approach. Reportedly, a strong, turbulent, wind shear condition… - [NTSB DEN82DA064](https://openairdocs.org/ntsb/DEN82DA064.md): Schweizer SGS-2-33A · Colorado Spring, CO · Accident · No injuries · Final report · Apr 17, 1982 · N2045T · Substantial damage > The student pilot reported that he came over the airport at about 1200 ft AGL to enter a downwind for landing. He stated that he encountered a moderate to strong sink and strong southerly winds. He estimated that the wind velocity was 45 to 50 mph at 1000 ft… - [NTSB SEA82DA054](https://openairdocs.org/ntsb/SEA82DA054.md): Evans VP2 · Athol, ID · Accident · Minor injuries · Final report · Apr 16, 1982 · N13809 · Substantial damage > During the initial flight test of a homebuilt aircraft the engine quit just as the aircraft was entering downwind. The pilot selected a field and executed a forced landing during which the gear collapsed. The pilot stated that he felt the nose of the aircraft… - [NTSB MIA82DA097](https://openairdocs.org/ntsb/MIA82DA097.md): Cessna 182G · Lake Wales, FL · Accident · No injuries · Final report · Apr 16, 1982 · N3212S · Substantial damage > The pilot stated that while on short final the engine would not respond to power increases and remained at idle speed. The pilot swerved around a building and dove the aircraft under wires finally coming to rest in a ditch. Examination of the fuel system… - [NTSB ATL82FA104](https://openairdocs.org/ntsb/ATL82FA104.md): Cessna 210-5 · Hendersonville, NC · Accident · 4 fatal · Field investigation · Final report · Apr 16, 1982 · N8113Z · Destroyed > The aircraft crashed on tree covered/rising terrain after the pilot was cleared for a night ILS approach to runway 34 at the asheville regional airport. The crash occurred about 1 to 2 mi south of the final approach fix while the aircraft was on an outbound… - [NTSB FTW82DA131](https://openairdocs.org/ntsb/FTW82DA131.md): Cessna 150G · Lamesa, TX · Accident · Minor injuries · Final report · Apr 14, 1982 · N3645J · Substantial damage > The pilot was circling the airport at night when the engine began losing power. He applied carburetor heat, but power could not be regained. The propeller was windmilling when he landed in a flat, plowed field and nosed over. The pilot had suspected… - [NTSB CHI82DA120](https://openairdocs.org/ntsb/CHI82DA120.md): Piper PA-34 · Gaylord, MI · Accident · No injuries · Final report · Apr 14, 1982 · N8691E · Substantial damage > During a night visual approach the aircraft landed about 90 ft short of the runway. The aircraft slid across the ground onto the runway pavement and swerved to the right striking a runway light and ending up on a snowbank. - [NTSB ATL82DA100](https://openairdocs.org/ntsb/ATL82DA100.md): S.N.I.A.S. AS350D Astar · Alcoa, TN · Accident · Minor injuries · Final report · Apr 12, 1982 · N3605B · Substantial damage > While preparing to land, the pilot experienced a tail rotor drive failure at a speed of less than 60 knots. At that speed, he was unable to make the necessary right turn from his position to land on the runway. Instead, he climbed about 50 ft in a left turn… - [NTSB MKC82FA055](https://openairdocs.org/ntsb/MKC82FA055.md): Martin-Pitts S1S · Grain Valley, MO · Accident · Serious injuries · Field investigation · Final report · Apr 11, 1982 · N61RM · Substantial damage > The plt estimated the fuel gauge indicated about 10 gals during preflight. The fuel gauge is a clear tube extending from the bottom of the tank up the right side of the cockpit. A dipstick was not available. The plt flew to liberty, MO made two landings &… - [NTSB FTW82DA121](https://openairdocs.org/ntsb/FTW82DA121.md): Cessna 172P · Albuquerque, NM · Accident · Minor injuries · Final report · Apr 11, 1982 · N62619 · Substantial damage > The aircraft with a full load at a high density altitude (7800 feet) failed to climb. Upon turning downwind at low altitude the aircraft appeared to stall and collide with the ground. - [NTSB NYC82DA071](https://openairdocs.org/ntsb/NYC82DA071.md): Piper PA-28-181 · Allentown, PA · Accident · No injuries · Final report · Apr 10, 1982 · N2531U · Substantial damage > During final approach the landing gear collided with a snowbank and the aircraft skidded on its nose and main landing gear, coming to rest approximately 30-50 yards from the approach end of the runway. - [NTSB MIA82FA092](https://openairdocs.org/ntsb/MIA82FA092.md): Cessna 421B · Ft. Lauderdale, FL · Accident · Minor injuries · Field investigation · Final report · Apr 6, 1982 · Y207P · Substantial damage > Reportedly, the left engine quit during an approach to land while the aircraft was at about 500 ft AGL with the gear and flaps down. The pilot stated that he immediately checked the fuel selector handles to be sure they were both in the indent, which they… - [NTSB ATL82FA093](https://openairdocs.org/ntsb/ATL82FA093.md): Piper PA-28-180 · Bostic, NC · Accident · 1 fatal · Field investigation · Final report · Apr 6, 1982 · N9610J · Destroyed > The aircraft crashed in a steep nose down attitude about 5 mi east of the destination airport. When the airport operator went home at about 1830 EST, he noted that a 350 ft mountain peak near his home was obscured by clouds. At about that same time, he… - [NTSB ANC82DA031](https://openairdocs.org/ntsb/ANC82DA031.md): Cessna A185E · Juneau, AK · Accident · Minor injuries · Final report · Apr 6, 1982 · N4745Q · Substantial damage > During an approach to land, the pilot of the amphibious aircraft extended the gear and performed his prelanding checks. He stated that while he was descending, he noticed an excessive loss of altitude and began to add power. However, the engine did not… - [NTSB CHI82IA113](https://openairdocs.org/ntsb/CHI82IA113.md): Cessna 402B · Waukegan, IL · Incident · No injuries · Incident investigation · Final report · Apr 5, 1982 · N69341 · Minor damage > Pilot reported an oil leak in the right engine to controller while on an instrument approach to Waukegan airport. Several minutes later, pilot reported that he had lost sight of the airport and due to loss of power in the right engine, elected to land in a… - [NTSB CHI82DA114](https://openairdocs.org/ntsb/CHI82DA114.md): Cessna T210L · Detroit, MI · Accident · Minor injuries · Final report · Apr 5, 1982 · N210LV · Substantial damage > The pilot elected to land at an alternate airport when he encountered poor visibility and icing conditions. While receiving vectors to Detroit metro the pilot reported he was low on fuel and needed to land. During the approach the engine quit. The aircraft… - [NTSB SEA82DA042](https://openairdocs.org/ntsb/SEA82DA042.md): Cessna 150H · Camas, WA · Accident · No injuries · Final report · Mar 30, 1982 · N22609 · Substantial damage > During the pilot's sixth touch and go landing the aircraft struck a tree on short final. The pilot maintained control of the aircraft and completed his landing. - [NTSB ANC82DA029](https://openairdocs.org/ntsb/ANC82DA029.md): Curtiss-Wright C-46A · Wulik River Str, AK · Accident · No injuries · Final report · Mar 28, 1982 · N9852F · Substantial damage > During arrival, the pilot noted that there was a cargo plane being unloaded at the end of a 4100 ft, snow covered runway. He elected to land from the opposite end within the first 4000 ft. the wind was calm. During the landing flare, the right main gear… - [NTSB CHI82IA102](https://openairdocs.org/ntsb/CHI82IA102.md): Beech 65-88 · Kalamazo, MI · Incident · No injuries · Incident investigation · Final report · Mar 26, 1982 · N20HR · Minor damage > Prior to landing the pilot could not extend the right main landing gear. He attempted to extend the gear by recycling the system and by using the manual extension, but to no avail. Subsequently, the aircraft was landed on a paved runway with the gear… - [NTSB DEN82IA049](https://openairdocs.org/ntsb/DEN82IA049.md): Gulfstream G159-C · Denver, CO · Incident · No injuries · Incident investigation · Final report · Mar 25, 1982 · N857H · No damage > On final approach after a normal flight, the copilot became incapacitated while reading the final approach checklist. The captain continued the approach and made an uneventful landing. After the passengers had deplaned, the copilot suffered a seizure while he… - [NTSB FTW82DA114](https://openairdocs.org/ntsb/FTW82DA114.md): Rockwell 690A · Conroe, TX · Accident · No injuries · Final report · Mar 24, 1982 · N9101F · Substantial damage > The pilot was too high on an IFR approach and elected to circle and land. During the turn he collided with trees but continued the approach and landed. The left wing and stabilizer were damaged. - [NTSB MIA82DA080](https://openairdocs.org/ntsb/MIA82DA080.md): Piper PA-38-112 · Near Opalocka, FL · Accident · No injuries · Final report · Mar 23, 1982 · N2463F · Substantial damage > The pilot stated that he was practicing forced landings in a soft field environment. The passenger added that the landing area was a levee bordered by water, trees, and vegetation. He further stated that the aircraft bounced hard and to the left off the… - [NTSB LAX82FUQ12](https://openairdocs.org/ntsb/LAX82FUQ12.md): Cessna 150M · Oxnard, CA · Accident · 1 fatal · Final report · Mar 23, 1982 · N63331 · Destroyed > The student pilot departed hawthorne, CA at approximately 1000 PST on a solo cross-country flight to porterville, CA and return. During the flight the pilot became lost and landed at visalia, CA. While there he obtained fuel and directions to porterville and… - [NTSB ATL82FA083](https://openairdocs.org/ntsb/ATL82FA083.md): Bellanca 8KCAB · Carrollton, GA · Accident · Serious injuries · Field investigation · Final report · Mar 23, 1982 · N50468 · Destroyed > The student completed a touch & go & was climbing out when the instructor took control. He told the student that he was going to show him what to do if the eng quit shortly after takeoff. At 150-180 ft above the rwy near the upwind numbers the instructor cut… - [NTSB LAX82DA115](https://openairdocs.org/ntsb/LAX82DA115.md): Cessna 152 · Winslow, AZ · Accident · No injuries · Final report · Mar 22, 1982 · N25782 · Substantial damage > The pilot stated that he did a touch and go on runway 29, then pulled the power off at approximately 300 ft AGL over the intersection of runways 29 and 22. He reported that from there, he attempted to land on runway 22 with no power, failed to maintain… - [NTSB FTW82DA100](https://openairdocs.org/ntsb/FTW82DA100.md): Cessna 310B · West Memphis, AR · Accident · No injuries · Final report · Mar 22, 1982 · N5417A · Substantial damage > During a dual instruction engine out in a two engine aircraft a go around was attempted by the student pilot because of conflicting traffic in the pattern. The aircraft developed a high sink rate and the CFI landed the aircraft wheels up. The student raised… - [NTSB ATL82DA082](https://openairdocs.org/ntsb/ATL82DA082.md): Cessna 177 · Jefferson, GA · Accident · Minor injuries · Final report · Mar 22, 1982 · N30569 · Substantial damage > During arrival, the wind shifted favoring runway 27. The pilot reported that he started his final approach at 80 mph and then slowed to 60 mph as he approached the threshold. Just as the aircraft crossed over a treeline, the aircraft suddenly dropped and hit… - [NTSB NYC82FA059](https://openairdocs.org/ntsb/NYC82FA059.md): Cessna T210M · Williamsport, PA · Accident · 5 fatal · Field investigation · Final report · Mar 21, 1982 · N761MZ · Destroyed > The acft impacted a mountain about 5 mi sw of the arpt at an elevation of approximately 1,400 ft while executing a missed approach from an ILS approach to rwy 27. The published missed approach procedure requires a climbing right turn to 3,700 ft via a heading… - [NTSB CHI82FA091](https://openairdocs.org/ntsb/CHI82FA091.md): Cessna 421 · Richmond, IN · Accident · 1 fatal · Field investigation · Final report · Mar 18, 1982 · N33KC · Destroyed > During a VOR approach to runway 05 when 3 miles away from the airport at minimums ground contact was not made. The pilot stated that she elected to perform a missed approach but before power was applied the copilot raised the flaps. She further stated that… - [NTSB ATL82FLJ06](https://openairdocs.org/ntsb/ATL82FLJ06.md): Bede BD-4 · Knightdale, NC · Accident · 2 fatal · Final report · Mar 18, 1982 · N223LW · Destroyed > Two witnesses observed the aircraft on a low final approach for runway 19. They reported that the aircraft then turned to an easterly heading. One witness reported that the left turn appeared to be coordinated. The other witness heard the pilot add power… - [NTSB SEA82DA038](https://openairdocs.org/ntsb/SEA82DA038.md): Cessna 340 · Idaho Falls, ID · Accident · No injuries · Final report · Mar 17, 1982 · N340RA · Substantial damage > The pilot reported that during an ILS approach, he broke out at about 500 ft AGL. He stated that he did not properly arrest the sink rate and struck the runway. He also stated that there probably was some ice under the wings that had accumulated during… - [NTSB DEN82DA046](https://openairdocs.org/ntsb/DEN82DA046.md): Bell 206B · Marble, CO · Accident · No injuries · Final report · Mar 16, 1982 · N2169X · Substantial damage > The purpose of the flight was to transport ski guides to the top of a 13,000 ft mountain ridge. After climbing in moderate to high winds, the pilot approached the intended landing area from the lee side at an angle of about 45 degrees to the ridgeline. He… - [NTSB SEA82DA037](https://openairdocs.org/ntsb/SEA82DA037.md): Piper PA-18-135 · Richland, WA · Accident · Minor injuries · Final report · Mar 14, 1982 · N1578P · Substantial damage > The pilot was practicing short field landings. On this approach, he added power to arrest a high sink rate, but felt that the engine did not respond adequately. A hard landing occurred. The engine was examined, and during a test run, it operated… - [NTSB NYC82FNC05](https://openairdocs.org/ntsb/NYC82FNC05.md): Cessna 210 · Carrabassett, ME · Accident · Serious injuries · Final report · Mar 14, 1982 · N3942Y · Substantial damage > During a straight-in approach to runway 35, the aircraft touched down short of the threshold. It decelerated rapidly in deep packed snow, slid over a snow bank, and came to rest on the paved runway. The nosewheel collapsed and the pilot suffered serious head… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=221 ## The whole list in SQL Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS: ```sql WITH phase_names(main, name) AS (VALUES (100, 'Prior to flight'), (150, 'Standing'), (200, 'Pushback/towing'), (250, 'Taxi'), (300, 'Takeoff'), (350, 'Initial climb'), (400, 'Enroute'), (450, 'Maneuvering'), (500, 'Approach'), (550, 'Landing'), (600, 'Emergency descent'), (650, 'Uncontrolled descent'), (700, 'Post-impact'), (750, 'After landing'), (800, 'Other'), (990, 'Unknown')), crosswalk(code, main, name) AS (VALUES (500, 150, 'Standing'), (501, 150, 'Standing - pre-flight'), (502, 150, 'Standing - starting engine(s)'), (503, 150, 'Standing - engine(s) operating'), (504, 150, 'Standing - engine(s) not operating'), (505, 150, 'Standing - idling rotors'), (510, 250, 'Taxi'), (511, 200, 'Taxi - pushback/tow'), (512, 250, 'Taxi - to takeoff'), (513, 250, 'Taxi - from landing'), (514, 250, 'Taxi - aerial'), (520, 300, 'Takeoff'), (521, 300, 'Takeoff - roll/run'), (522, 350, 'Takeoff - initial climb'), (523, 300, 'Takeoff - aborted'), (530, 400, 'Climb'), (531, 400, 'Climb - to cruise'), (540, 400, 'Cruise'), (541, 400, 'Cruise - normal'), (542, 400, 'Maneuvering - holding (IFR)'), (550, 400, 'Descent'), (551, 400, 'Descent - normal'), (552, 600, 'Descent - emergency'), (553, 650, 'Descent - uncontrolled'), (560, 500, 'Approach'), (561, 500, 'Approach - VFR pattern - downwind'), (562, 500, 'Approach - VFR pattern - base turn'), (563, 500, 'Approach - VFR pattern - base leg/base to final'), (564, 500, 'Approach - VFR pattern - final approach'), (565, 500, 'Go-around (VFR)'), (566, 500, 'Approach - IAF to FAF/outer marker (IFR)'), (567, 500, 'Approach - FAF/outer marker to threshold (IFR)'), (568, 500, 'Circling (IFR)'), (569, 500, 'Missed approach (IFR)'), (570, 550, 'Landing'), (571, 550, 'Landing - flare/touchdown'), (572, 550, 'Landing - roll'), (573, 550, 'Landing - aborted'), (574, 550, 'Emergency landing'), (575, 550, 'Emergency landing after takeoff'), (576, 600, 'Emergency descent/landing'), (580, 450, 'Maneuvering'), (581, 450, 'Maneuvering - aerial application'), (582, 450, 'Maneuvering - turn to reverse direction'), (583, 450, 'Maneuvering - turn to landing area (emergency)'), (590, 450, 'Hover'), (591, 450, 'Hover - in ground effect'), (592, 450, 'Hover - out of ground effect'), (600, 800, 'Other'), (610, 990, 'Unknown')), current_codes AS ( SELECT e.case_mkey, TRY_CAST(e."tier1Number" AS INTEGER) AS code, row_number() OVER (PARTITION BY e.case_mkey ORDER BY coalesce(e."isDefiningEvent", false) DESC, e.position) AS n FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.aircrafts_position = 1 AND e."tier1Number" GLOB '[1-9][0-9]*' AND (e."isDefiningEvent" OR e.case_mkey IN (SELECT "mKey" FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' WHERE "isPre1982")) ), phases AS ( SELECT case_mkey, 'current' AS scheme, code, CASE WHEN code >= 990 THEN 990 ELSE code // 50 * 50 END AS main FROM current_codes WHERE n = 1 UNION ALL SELECT o.case_mkey, 'older', o."phaseOfFlightCode", w.main FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o JOIN crosswalk w ON w.code = o."phaseOfFlightCode" WHERE o.aircrafts_position = 1 AND o."occurrenceNumber" = 1 AND o.case_mkey NOT IN (SELECT case_mkey FROM current_codes) ), case_phases AS ( SELECT p.*, c."eventDate", c."highestInjuryLevel" = 'Fatal' AS fatal, a.aircraft_model_code FROM phases p JOIN 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c ON c."mKey" = p.case_mkey LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = p.case_mkey AND a.position = 1 WHERE c."eventDate" >= DATE '1962-01-01' AND p.main IN (SELECT main FROM phase_names) ) SELECT c."ntsbNumber", c."eventDate", c."eventType", c."eventCity", c."eventStateOrRegion", a.n_number, a."aircraftMake", a."aircraftModel", c."highestInjuryLevel", c."totalFatal", c."completionStatus", c.report_url FROM 'https://openairdocs.org/data/latest/ntsb_case_detail.parquet' c LEFT JOIN 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' a ON a.case_mkey = c."mKey" AND a.position = 1 WHERE c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=220 --- 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.