# 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 215 of 420 · 20,992 cases ## Cases, newest first - [NTSB ANC83IA010](https://openairdocs.org/ntsb/ANC83IA010.md): Short Bros. SC7 Series 3 · Barrow, AK · Incident · Minor injuries · Incident investigation · Final report · Nov 1, 1982 · N50DA · Minor damage > The aircraft was on a round trip flight from Barrow, AK to point hope, AK and return. After landing at point hope, there was a 20 min delay while waiting for the ground crew. The pilot stated that he ran the engines for some 10 min or so due to the high winds… - [NTSB SEA83LA014](https://openairdocs.org/ntsb/SEA83LA014.md): Piper PA-24-180 · Cascade Locks, OR · Accident · No injuries · Limited investigation · Final report · Oct 31, 1982 · N6936P · Substantial damage > Plt was making a precautionary landing after encountering fog enroute. Two approaches to rwy 24 were aborted due to gusting winds. A downwind approach was then made to rwy 06. When the acft descended below the height of surrounding trees the prevailing… - [NTSB ANC83LA008](https://openairdocs.org/ntsb/ANC83LA008.md): Arctic S1B2 · Shishmaref, AK · Accident · No injuries · Limited investigation · Final report · Oct 30, 1982 · N63AT · Substantial damage > This pilot flew into the ground short of the runway, the pilot has visual deficiencies especially at twilight or in darkness. This accident took place at twilight. The pilot was hauling reindeer meat and stated the elevator jammed during final approach. An… - [NTSB NYC83LA015](https://openairdocs.org/ntsb/NYC83LA015.md): Cessna 150L · Watertown, NY · Accident · No injuries · Limited investigation · Final report · Oct 29, 1982 · N1277Q · Substantial damage > The pilot reported that he made two touch-and-go landings at the Watertown, new york intl airport. He then returned to his private airstrip in the local area. While executing a night approach to the private strip he got too low. The pilot stated that he added… - [NTSB FTW83LA025](https://openairdocs.org/ntsb/FTW83LA025.md): Piper PA-28-161 · Mcallen, TX · Accident · No injuries · Limited investigation · Final report · Oct 28, 1982 · N47916 · Substantial damage > While on approach the pilot encountered wind shear and downdrafts and subsequently struck the number 2 approach light stanchion. The gear assembly sheared off and the aircraft touched down on the runway and veered to the right. - [NTSB FTW83AA024](https://openairdocs.org/ntsb/FTW83AA024.md): Piper PA-31P · Carrollton, TX · Accident · 4 fatal · Final report · Oct 27, 1982 · N100FD · 2 aircraft · Destroyed > A PA-31, N100FD, was being vectored by dfw approach control (apch ctl) for a landing on rwy 13L at dallas-love fld. The plt's last received & acknowledged instructions were to descend & maintain 2000' & turn left to 190 deg. Simultaneously,a Cessna 337,… - [NTSB DEN83FTE01](https://openairdocs.org/ntsb/DEN83FTE01.md): J.A.Mullan Dragonfly · Erie, CO · Accident · Serious injuries · Final report · Oct 26, 1982 · N21SH · Destroyed > The pilot was on a flight to accumulate flight time on a home built aircraft. A mayday call was received on the UNICOM. Several witnesses indicated that the pilot was trying to land on the runway when the plane entered a left bank. And suddenly crashed.… - [NTSB MIA83LA020](https://openairdocs.org/ntsb/MIA83LA020.md): Cessna 172 · Ft. Myers, FL · Accident · Minor injuries · Limited investigation · Final report · Oct 24, 1982 · N739WY · Substantial damage > The plt stated that during his solo x-country the throttle became stuck several times enroute. While approaching Ft. Myers he retarded the throttle but was unable to advance it again. Unable to maintain altitude, the plt made a forced landing. Post… - [NTSB FTW83LA021](https://openairdocs.org/ntsb/FTW83LA021.md): Cessna 310C · Bastrop, LA · Accident · Minor injuries · Limited investigation · Final report · Oct 24, 1982 · N1739H · Destroyed > The pilot was preparing for an enroute landing when he got an unsafe gear light. While trouble-shooting, the left engine stopped. He feathered the left engine and almost immediately the right engine quit. The pilot failed to reach therunway during the power… - [NTSB LAX83FUJ02](https://openairdocs.org/ntsb/LAX83FUJ02.md): Hobbs B8M · Eloy, AZ · Accident · 1 fatal · Final report · Oct 23, 1982 · N1335G · Substantial damage > The gyrocopter crashed approximately 125 ft short of & 30-45 ft to the right of the rwy threshold during proficiency flying. - [NTSB CHI83FA024](https://openairdocs.org/ntsb/CHI83FA024.md): C. EFF VARI-EZE · Seymour, IN · Accident · 1 fatal · Field investigation · Final report · Oct 23, 1982 · N122EF · Destroyed > Aircraft was being taxi tested when it became airborne and flew a fast, low tentative pattern. Turning final the turn was very steep and aircraft descended to ground impacting a tree prior to ground impact. The pilot had no recorded flight time in this… - [NTSB ATL83FA014](https://openairdocs.org/ntsb/ATL83FA014.md): Piper PA-28-181 · Athens, TN · Accident · 1 fatal · Field investigation · Final report · Oct 22, 1982 · N21678 · Substantial damage > The plt had not flown for a couple of years. On 10/15/82 he received dual instruction in a C-172 & on the day of the accident was checked out in the PA-28. His certificate was not valid for night flight. At 1716 the plt activated a VFR flt plan. At… - [NTSB LAX83FUJ01](https://openairdocs.org/ntsb/LAX83FUJ01.md): Grumman American AA-1B · New River, AZ · Accident · 1 fatal · Final report · Oct 19, 1982 · N9897L · Substantial damage > After entering the traffic pattern, the aircraft was observed in a steep descending turn from downwind to final approach. A witness reported that the pilot kept increasing the bank, while turning to final, as if to keep from overshooting the final approach… - [NTSB LAX83LA014](https://openairdocs.org/ntsb/LAX83LA014.md): Piper PA28-180 · Reno, NV · Accident · Serious injuries · Limited investigation · Final report · Oct 18, 1982 · N8176W · Destroyed > Aircraft impacted on a hillside at 5200 feet level while on approach to cannon international airport Reno, NV at night. The weather was VMC. No malfunctions in equipment were found the pilot said the aircraft "fell from under me". He saw the terrain, pulled… - [NTSB MKC83FCQ02](https://openairdocs.org/ntsb/MKC83FCQ02.md): Piper PA-22-108 · Baxter Springs, KS · Accident · Serious injuries · Final report · Oct 17, 1982 · N4581Z · Substantial damage > A witness observed the acft's nose pitch up when the acft was on a right base turning final. The acft started turning left & hit the ground. - [NTSB CHI83LA017](https://openairdocs.org/ntsb/CHI83LA017.md): Cessna 206 · Cleveland, OH · Accident · No injuries · Limited investigation · Final report · Oct 17, 1982 · N5379U · Substantial damage > Before taking off on a night flight, water was drained from the fuel sumps. When the pilots were satisfied that all of the water was drained from the tanks, they departed. The flight was routine until the aircraft was on final approach for landing. About 1… - [NTSB MKC83FCQ01](https://openairdocs.org/ntsb/MKC83FCQ01.md): Mooney M20A · Halstead, KS · Accident · Serious injuries · Final report · Oct 12, 1982 · N8311E · Substantial damage > During arrival, the pilot noted that the wind was from the northwest. He estimate it was from 330 deg at 20, gusting 35 KTS. On final approach, the aircraft was reportedly unstable due to gusty winds and turbulence. The pilot observed and was aware of the… - [NTSB NYC83LA007](https://openairdocs.org/ntsb/NYC83LA007.md): Globe Swift GC-1B · Elmira, NY · Accident · No injuries · Limited investigation · Final report · Oct 10, 1982 · N50BS · Substantial damage > During takeoff, the right side of the canopy separated from the aircraft as it was climbing through about 150 to 200 ft AGL. The pilot notified the tower of the situation and clearance was obtained to land on any runway. According to the pilot, he turned… - [NTSB LAX83LVD01](https://openairdocs.org/ntsb/LAX83LVD01.md): Boeing A75 · Ft. Bragg, CA · Accident · Minor injuries · Final report · Oct 10, 1982 · N56772 · Destroyed > The pilot reported that he was long and fast on his landing approach, so he decided to go around. Due to a noise sensitivity problem in the area, he elected not to use full throttle. Subsequently, the aircraft hit the tops of trees at the end of the runway.… - [NTSB LAX83FUM01](https://openairdocs.org/ntsb/LAX83FUM01.md): Beech A35 · Oceanside, CA · Accident · 4 fatal · Final report · Oct 10, 1982 · N696B · Substantial damage > During arrival, the aircraft entered downwind for a right traffic pattern to runay 24. At that time, a witness (a well qualified pilot) noted that the wind was from the northeast at about 8 KTS. Another pilot-witness stated that the wind was from the… - [NTSB FTW83FQA02](https://openairdocs.org/ntsb/FTW83FQA02.md): Raven Industries S-66A · Albuquerque, NM · Accident · Serious injuries · Final report · Oct 10, 1982 · N1980M · Substantial damage > The pilot was landing the balloon in strong gusty winds when he saw power lines approaching and told everyone to jump. Those jumping, except the pilot, were injured. One passenger stayed in the basket and was unharmed. - [NTSB FTW83LA011](https://openairdocs.org/ntsb/FTW83LA011.md): Raven AX-7 · Albuquerque, NM · Accident · Serious injuries · Limited investigation · Final report · Oct 7, 1982 · N40222 · No damage > The balloonist attempted to abort a landing due to wind conditions and believes he encountered a downdraft. The balloon descended and landed on a fence and became airborne again. The wind had picked up to about 15 or 20 knots so the balloonwas traveling… - [NTSB MIA83FA006](https://openairdocs.org/ntsb/MIA83FA006.md): Piper PA-23-250 · Lake Placid, FL · Accident · 2 fatal · Field investigation · Final report · Oct 6, 1982 · N13785 · Substantial damage > Aircraft was transporting marijuana and during an attempted road landing at Lake Placid collided with wires which damagethe landing assembly. Aircraft continued on to north about 4 miles and ditched in a lake. The aircraft sank with both occupants and cargo. - [NTSB NYC83LA002](https://openairdocs.org/ntsb/NYC83LA002.md): Piper PA-12 · Bernville, PA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1982 · N3849M · Substantial damage > The pilot reported that the plane crashed after the right wing tip hit the top of a tree during landing. He reported that he had flown only 2 hrs in the last 90 days. He noted that this was only a 13 minute flight. He thought that he would have been more… - [NTSB MKC83LA003](https://openairdocs.org/ntsb/MKC83LA003.md): Cessna 152 · Mcpherson, KS · Accident · No injuries · Limited investigation · Final report · Oct 3, 1982 · N757PF · Substantial damage > The pilot estimated there was about 10 gallons of fuel on board before he took off. After making three takeoffs and landings, he picked up a passenger and flew in the local area. After flying about one hour and 17 minutes, the engine lost power. While landing… - [NTSB ATL83FA001](https://openairdocs.org/ntsb/ATL83FA001.md): Eagle C-7 · Piedmont, SC · Accident · 3 fatal · Field investigation · Final report · Oct 3, 1982 · N70014 · Destroyed > Balloon was inflated with difficulty because of gusty winds. Balloon did not have a skirt. During the flight which ended in the accident the balloon seemed to have trouble and during the final moments it was in a descent which ended with the envelope as a… - [NTSB DEN83FA001](https://openairdocs.org/ntsb/DEN83FA001.md): Piper PA-28-181 · Wolsey, SD · Accident · 1 fatal · Field investigation · Final report · Oct 1, 1982 · N6553C · Destroyed > The pilot had been issued an instrument rating on 8/6/82 and had logged 5.6 hrs since that time. The pilot's instructor believed this would have been his first low approach in actual instrument conditions since he completed his check flight. A witness stated… - [NTSB ANC82IA103](https://openairdocs.org/ntsb/ANC82IA103.md): Piper PA31-350 · Kenai, AK · Incident · No injuries · Incident investigation · Final report · Sep 30, 1982 · N61366 · Minor damage > The commuter flight departed Kenai, destined for anchorage AK. The pilot stated that while on approach he could not obtain a positive gear down and locked indication on the nose gear. The pilot elected to return to Kenai airport due to weather at anchorage.… - [NTSB FTW82DA400](https://openairdocs.org/ntsb/FTW82DA400.md): Cessna 152 · Dumas, TX · Accident · No injuries · Final report · Sep 27, 1982 · N24313 · Substantial damage > During the student's first solo takeoff & landing, she was not lined up with the runway & elected to go around. Power was applied & the flaps were fully retracted. The acft immediately dropped to the ground left of the runway. - [NTSB ANC82DA101](https://openairdocs.org/ntsb/ANC82DA101.md): Fairchild C-82A · Karluk, AK · Accident · No injuries · Final report · Sep 27, 1982 · N9701F · Substantial damage > The pilot reported that during arrival, the approach to landing seemed normal until just before touchdown. The aircraft touched down short of the runway threshold marks on relatively steep terrain in the safety zone. The pilot estimated that the touchdown… - [NTSB SEA82DA174](https://openairdocs.org/ntsb/SEA82DA174.md): Tanke Goldwing · Harrington, WA · Accident · No injuries · Final report · Sep 26, 1982 · N123DT · Destroyed > After a local pleasure flight, the pilot returned to a farm strip for landing. Due to a windshift, the pilot attempted a landing 90 degrees from that of the takeoff. The aircraft struck powerlines while on the approach. - [NTSB DEN82DA204](https://openairdocs.org/ntsb/DEN82DA204.md): Cessna 172 · Rock Springs, WY · Accident · No injuries · Final report · Sep 26, 1982 · N55404 · Substantial damage > According to the pilot, a strong gust of wind lifted the aircraft during the landing and power was applied for a go-around. Another gust of wind forced the aircraft off the runway into the dirt next to the runway. When the aircraft departed the runway, the… - [NTSB CHI82FA366](https://openairdocs.org/ntsb/CHI82FA366.md): Cessna 340A · Sugargrove, IL · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1982 · N2676A · Destroyed > Aircraft collided with terrain after a missed approach in a descending turn left wing hit the ground first. Aircraft broke up and caught fire. No malfunctions found. - [NTSB FTW82FPM17](https://openairdocs.org/ntsb/FTW82FPM17.md): Cessna 421B · Afton, OK · Accident · 1 fatal · Final report · Sep 25, 1982 · N8019Q · Destroyed > At about 1930 CDT, the aircraft departed yukon, OK on a direct flight to alton, IL. It landed at alton at about 2200 CDT, and about 10 minutes later, it departed on a return flight to yukon. Before departing alton, the pilot stated that he would refuel at… - [NTSB FTW82DA395](https://openairdocs.org/ntsb/FTW82DA395.md): Cessna 182B · Albuquerque, NM · Accident · Minor injuries · Final report · Sep 25, 1982 · N2389G · Substantial damage > The pilot undershot the runway following an engine failure on final approach. The pilot had been flying 4.7 hours on a cross-country flight when engine quit. The aircraft was out of fuel. The optimum endurance is 4.6 hours. The pilot had figured on 7 gallon… - [NTSB CHI82FA365](https://openairdocs.org/ntsb/CHI82FA365.md): Piper PA-28-181 · Mankato, MN · Accident · 2 fatal · Field investigation · Final report · Sep 25, 1982 · N82717 · Destroyed > At about 1530 CDT, the aircraft departed mattoon, IL on a flight to Mankato, MN. However, the pilot landed at albert lea, MN where he refueled and topped the tanks with 45.5 gal of fuel. The aircraft's usable supply was 48 gal. While refueling, he reportedly… - [NTSB LAX82DA353](https://openairdocs.org/ntsb/LAX82DA353.md): Grumman G-164A · Magma, AZ · Accident · No injuries · Final report · Sep 23, 1982 · N6602 · Substantial damage > Shortly after takeoff the eng became rough & losing power. The plt observed long streaks of red flame pouring from the exhaust. The pesticide was jettisoned & an attempt was made to return to the strip. The eng continued to lose power & quit completely just… - [NTSB LAX82DA352](https://openairdocs.org/ntsb/LAX82DA352.md): Bellanca 14-13-2 · San Jose, CA · Accident · No injuries · Final report · Sep 22, 1982 · N74440 · Substantial damage > The acft landed short of the rwy. The plt stated he was demonstrating a 3-point landing & his attention was diverted by answering a question. - [NTSB FTW82DA386](https://openairdocs.org/ntsb/FTW82DA386.md): Grumman AA-5A · Tulsa, OK · Accident · No injuries · Final report · Sep 22, 1982 · N26171 · Substantial damage > The student pilot stated that he made several touch-and-go landings without incident, when the engine started "cutting out" on final approach. He reported that carburetor heat was not applied until after the power loss began. He was unable to restore power… - [NTSB LAX82DA351](https://openairdocs.org/ntsb/LAX82DA351.md): Piper PA-28181 · Visalia, CA · Accident · No injuries · Final report · Sep 20, 1982 · N5889V · Substantial damage > The aircraft crashed short of the runway during final approach. The pilot reported a loss of power which could not be duplicated by FAA maintenance. No engine malfunction was found. - [NTSB FTW82DA385](https://openairdocs.org/ntsb/FTW82DA385.md): Cessna 501SP · Crystal City, TX · Accident · No injuries · Final report · Sep 20, 1982 · N50US · Substantial damage > The aircraft touched down 10 feet short of the runway. The right main gear failed when it contacted the raised lip of the runway threshold. After the gear failure, directional control was lost and the aircraft collided with fence posts. The six occupants were… - [NTSB LAX82DA348](https://openairdocs.org/ntsb/LAX82DA348.md): Piper PA-28R-200 · Prescott, AZ · Accident · No injuries · Final report · Sep 19, 1982 · N7675C · Substantial damage > According to the pilot, he planned a fuel stop at needles, CA, but was unaware that services were not available until after arrival. He departed needles with low fuel in both tanks and attempted to reach Prescott, AZ before dark. However, darkness occurred… - [NTSB ATL82FID13](https://openairdocs.org/ntsb/ATL82FID13.md): Beech B-19 · Franklin, VA · Accident · No injuries · Final report · Sep 19, 1982 · N7698R · Substantial damage > N7698R crashed while on final approach, approximately one half mile east of Franklin airport. The father of the pilot stated that the aircraft had been taken without permission. The pilot holds an expired student pilot certificate. In addition, the pilot was… - [NTSB NYC82DA226](https://openairdocs.org/ntsb/NYC82DA226.md): Piper PA-24 · Erie, PA · Accident · No injuries · Final report · Sep 18, 1982 · N6253P · Substantial damage > The aircraft was on final approach for landing when the engine lost power. The power loss occurred when the plane was about 40 to 50 ft AGL and 1/4 mile from the runway. The plane touched down short of the runway and collided with approach lights. After… - [NTSB SEA82FA163](https://openairdocs.org/ntsb/SEA82FA163.md): de Havilland DHC-II · Mahoney Creek, ID · Accident · 2 fatal · Field investigation · Final report · Sep 14, 1982 · N5157G · Destroyed > The acft was observed flying over the strip in what appeared to be a normal downwind pattern. It crashed about 300 ft below windy ridge on the northwest face. The autopsy report indicated the plt had a "patchy healed myocardial infarct" prior to the accident.… - [NTSB SEA82DA161](https://openairdocs.org/ntsb/SEA82DA161.md): Piper PA-38-112 · Corvallis, OR · Accident · Minor injuries · Final report · Sep 12, 1982 · N2535P · Destroyed > The flight instructor stated that while on a low final approach, a sudden downdraft of windshear occurred causing the aircraft to drop and the right wing to hit the top of a tree. Upon impact the aircraft spun out of control and impacted the ground. - [NTSB FTW82DA379](https://openairdocs.org/ntsb/FTW82DA379.md): Cessna 172 · Corpus Christi, TX · Accident · Minor injuries · Final report · Sep 12, 1982 · N8233U · Substantial damage > Aircraft landed short after engine quit on final approach. The fuel was down to minimum usable quantity. - [NTSB LAX82FA341](https://openairdocs.org/ntsb/LAX82FA341.md): Bell 47G-2 · San Diego, CA · Accident · Minor injuries · Field investigation · Final report · Sep 11, 1982 · N4242A · Destroyed > The plt was in the local pattern practicing maneuvers. After completing a quick stop maneuver & hovering, another takeoff was initiated. The plt stated that it seemed to take an unusual amount of forward cyclic to initiate forward flt. During the final… - [NTSB LAX82DA340](https://openairdocs.org/ntsb/LAX82DA340.md): Beech C23 · Bear Valley, CA · Accident · Serious injuries · Final report · Sep 11, 1982 · N4357W · Destroyed > The pilot landed long and fast on the runway. He was using runway 19 and the wind was from the north at 15-20 KTS. He landed and while still rolling at 65 KTS initiated a go-around. He did not climb high enough to clear small tree and after colliding with… - [NTSB FTW82DA375](https://openairdocs.org/ntsb/FTW82DA375.md): Cessna 172N · Katy, TX · Accident · No injuries · Final report · Sep 11, 1982 · N73922 · Substantial damage > During a biennial flight review, the pilot/owner began a simulated emergency landing. Reportedly, the engine was not cleared during a long power-off descent from 900 ft. when it became apparent that the field would not be reached, the flight instructor took… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=216 ## 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=215 --- 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.