# 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 219 of 420 · 20,992 cases ## Cases, newest first - [NTSB MKC82DA102](https://openairdocs.org/ntsb/MKC82DA102.md): Balloon Works Firefly 6 · Hudson, IA · Accident · No injuries · Final report · Jun 13, 1982 · N2067F · Substantial damage > The Balloon was in a descent and was approaching the landing area when the burner pilot-light went out. Without the burner, the pilot was forced to land short of his selected field. He spilled the air from the Balloon and touched down just short of an 8000… - [NTSB FTW82DA225](https://openairdocs.org/ntsb/FTW82DA225.md): Cessna 175 · Fort Worth, TX · Accident · Minor injuries · Final report · Jun 13, 1982 · N9419B · Substantial damage > During a go-around the aircraft's engine quit. The pilot attempted an off-airport emergency landing; however, collided with bushes and nosed over. Investigation revealed there was a minimum amount of fuel onboard. - [NTSB MKC82DA100](https://openairdocs.org/ntsb/MKC82DA100.md): Cessna 182B · Milford, IA · Accident · No injuries · Final report · Jun 12, 1982 · N5392B · Substantial damage > The pilot reported that he was low on fuel and was flying over the airstrip before landing to drop a banner that he was towing. Shortly after the banner was released, the aircraft encountered turbulence causing the aircraft to go into a steep bank. At about… - [NTSB SEA82DA084](https://openairdocs.org/ntsb/SEA82DA084.md): Beech B19 · Quincy, WA · Accident · No injuries · Final report · Jun 11, 1982 · N2048A · Substantial damage > During a simulated forced landing, the student pilot initially turned the wrong direction, then turned correctly toward the runway. He was lower then normal at his initial and downwind points but after being prompted by the instructor (ip), the student angled… - [NTSB NYC82FHD15](https://openairdocs.org/ntsb/NYC82FHD15.md): Gregg KR-2 · Middletown, DE · Accident · Minor injuries · Final report · Jun 11, 1982 · N38DR · Substantial damage > The eng failed on the downwind leg after the plt applied carb heat. The plt attempted a power-off approach to the rwy but encountered turbulence from another acft passing below him on final causing him to lose control & enter a spin. After recovery the acft… - [NTSB FTW82DA218](https://openairdocs.org/ntsb/FTW82DA218.md): Beech 35 · Terrell, TX · Accident · No injuries · Final report · Jun 8, 1982 · N3803N · Substantial damage > While en route, the cabin door of the aircraft popped open, approximately 10 miles from the destination. The pilot reported that he was distracted by the open door and lost airspeed while on final approach. The aircraft touched down hard just short of the… - [NTSB ATL82FKG14](https://openairdocs.org/ntsb/ATL82FKG14.md): Fokker DR-1 · Hampton, GA · Accident · Minor injuries · Final report · Jun 7, 1982 · N1387B · Substantial damage > The pilot was also the owner of the fixed tri-wing, amateur-built aircraft. After returning from a local flight, he entered the traffic pattern. He flew a large pattern to maintain spacing behind a Cessna 150. After making a low approach, he positioned… - [NTSB CHI82FA200](https://openairdocs.org/ntsb/CHI82FA200.md): Piper PA-38 · Niles, MI · Accident · 2 fatal · Field investigation · Final report · Jun 6, 1982 · N2588K · Destroyed > At about 1300 EDT, the aircraft took off on a local training flight with a student and a certified flight instructor on board. Later at about 1325, the plane crashed in a wooded area about 1 mi northeast of the approach end of runway 21. One witness reported… - [NTSB ATL82FA155](https://openairdocs.org/ntsb/ATL82FA155.md): Piper PA-30 · Snow Hill, MD · Accident · 2 fatal · Field investigation · Final report · Jun 5, 1982 · N8193Y · Destroyed > The pilot/owner and another occupant with a commercial certificate and an instrument rating took off on a IFR flight plan. The weather at the departure point and destination was characterized by low ceilings and reduced visibilities in fog and rain.… - [NTSB ATL82DA156](https://openairdocs.org/ntsb/ATL82DA156.md): Piper PA-23-250 · Auburn, AL · Accident · No injuries · Final report · Jun 5, 1982 · N1AU · Substantial damage > While on a downwind for a landing in multi-engine training, the nose gear would not extend. All efforts to extend the nose gear, including a bounced landing, were unsuccessful. The aircrew intended to land on the main gear and then hold the nose off until the… - [NTSB NYC82FA116](https://openairdocs.org/ntsb/NYC82FA116.md): Cessna 152 · Elma, NY · Accident · 1 fatal · Field investigation · Final report · Jun 4, 1982 · N757GY · Destroyed > The pilot was performing a flight exam for a private pilot certificate. An approach was made to a field bordered by high tension lines. During the approach the aircraft collided with wires and descended nose first to the ground. - [NTSB LAX82DA207](https://openairdocs.org/ntsb/LAX82DA207.md): Pitts S-1 (Bartoe/Skyote) · Santa Cruz, CA · Accident · No injuries · Final report · Jun 2, 1982 · N25PB · 2 aircraft · No damage > The pilot of the Piper PA-28 reported that he was on final approach at approximately 50 ft AGL when his aircraft was struck from behind and below by a Pitts/skyote S-1, N25PB. He continued the landing, but during the landing roll, the Piper PA-28 veered off… - [NTSB LAX82FXQ09](https://openairdocs.org/ntsb/LAX82FXQ09.md): Cessna 182 · Truckee, CA · Accident · 1 fatal · Final report · May 31, 1982 · N5056D · Destroyed > The pilot had returned to the airport after a glider towing operation of about 10 minutes. Runway 19 was in use. Reportedly, the terrain to the north of runway 19 was about 100 ft lower than the airport elevation. A witness reported that he heard the sound of… - [NTSB LAX82DA204](https://openairdocs.org/ntsb/LAX82DA204.md): Beech C-24R · Big Bear, CA · Accident · No injuries · Final report · May 31, 1982 · N6716T · Substantial damage > A witness observed the aircraft to pitch and roll while on final approach. At about 30-40 feet above the ground the nose pitched downward and the aircraft collided with the runway. Moderate turbulence and gusty winds were reported on final approach. - [NTSB MKC82DA094](https://openairdocs.org/ntsb/MKC82DA094.md): Continental Mk5a Bell 47 · Neligh, NE · Accident · No injuries · Final report · May 30, 1982 · N9008T · Substantial damage > The pilot departed the airport helipad with 12 gallons of fuel. After landing in the loading area, he left the engine and spray pumps running to mix the solution in his spray tanks. After spraying the field, he ran out of fuel about one mile from his planned… - [NTSB LAX82DA200](https://openairdocs.org/ntsb/LAX82DA200.md): Cessna TP206A · Sedona, AZ · Accident · No injuries · Final report · May 29, 1982 · N4637F · Substantial damage > During touchdown the aircraft started to porpoise. The pilot elected to go-around and added power however the aircraft departed the left side of the runway and came to rest nose down in the dirt. - [NTSB FTW82FRG33](https://openairdocs.org/ntsb/FTW82FRG33.md): Cessna R182 · Bergheim, TX · Accident · 4 fatal · Final report · May 29, 1982 · N737RK · Destroyed > At 0010 the plt contacted san antonio tower approximately 10 mi north of san antonio intl arpt. He stated he was at 3100 ft in the clouds. The controller instructed the plt to turn left heading 030, maintain 3,000, & asked the plt if hewanted an IFR… - [NTSB CHI82DA191](https://openairdocs.org/ntsb/CHI82DA191.md): Convair 240 · Detroit, MI · Accident · No injuries · Final report · May 29, 1982 · N153PA · Substantial damage > The captain stated that during an ILS approach, he saw the approach lights about 3 miles from the touchdown point. Reportedly, the plane was on the glide slope and localizer as he continued on final approach. After passing minumums, the aircraft went into a… - [NTSB ATL82FA145](https://openairdocs.org/ntsb/ATL82FA145.md): Cessna U206G · Norfolk, VA · Accident · Serious injuries · Field investigation · Final report · May 29, 1982 · N777HD · Substantial damage > The eng quit during final approach. The acft had a history of problems with water in fuel system leading to engine problems. On 2/8/82 significant quantities of water was found in the fuel system. Post crash examination revealed water in the fuel system.… - [NTSB ANC82DA043](https://openairdocs.org/ntsb/ANC82DA043.md): Arctic S1B2 · Near Big Lake, AK · Accident · No injuries · Final report · May 29, 1982 · N65AT · Substantial damage > The purpose of the flight was to provide dual instruction to a rated single-engine-land pilot in basic float plane training. After practicing a number of landings, the instructor (ip) simulated an engine-out by reducing the power to 1000-1200 RPM. At this… - [NTSB DCA82AA023](https://openairdocs.org/ntsb/DCA82AA023.md): Beech D95A · Columbia, MD · Accident · 5 fatal · Final report · May 28, 1982 · N187Q · Destroyed > The acft was vectored to intercept the localizer course for an ILS approach to rwy 10 at balt-wash-intl arpt. It was then observed to fly through & to the north of the localizer course. The acft was then directed to turn left to a heading of 360 for… - [NTSB ANC82DA042](https://openairdocs.org/ntsb/ANC82DA042.md): Cessna U206 · Ouzinkie, AK · Accident · No injuries · Final report · May 27, 1982 · N4877X · Substantial damage > During arrival, the pilot made his landing approach over the village so as to land the float plane on the bay and into a 30 knot head wind. While on final approach, the aircraft's rate of descent increased. The pilot added full power and started to raise the… - [NTSB ATL82DA143](https://openairdocs.org/ntsb/ATL82DA143.md): Cessna 172P · Jonesboro, GA · Accident · No injuries · Final report · May 25, 1982 · N54527 · Substantial damage > The pilot stated that after applying brakes on landing roll the aircraft began to hydroplane on water that was on the runway. He elected to raise the flaps and apply full power in a attempt to go-around but was unable to clear trees off the end of the runway. - [NTSB LAX82DA189](https://openairdocs.org/ntsb/LAX82DA189.md): Piper PA-44-180 · Chandler, AZ · Accident · Minor injuries · Final report · May 23, 1982 · N2091K · Destroyed > The pilot departed Chandler, AZ with the fuel gauges indicating 40 plus gallons in each tank. After a 1.2 hr flight to lake havasu city, AZ, the gauges indicated 20 plus gallons in each tank. During the return trip to Chandler at night, both engines lost… - [NTSB NYC82DA102](https://openairdocs.org/ntsb/NYC82DA102.md): Piper PA-22-150 · Seneca Falls, NY · Accident · Minor injuries · Final report · May 21, 1982 · N6086D · Substantial damage > While trying to roll out of a left turn on downwind the pilot experienced a jammed rudder control. Full aileron control was not available because of the aileron-rudder interconnect system and a considerable buffet was induced during an attempt to level the… - [NTSB SEA82FYM16](https://openairdocs.org/ntsb/SEA82FYM16.md): Hughes 369D · Birkenfeld, OR · Accident · Minor injuries · Final report · May 19, 1982 · N1096L · Substantial damage > The pilot stated that the fuel gauge indicated 150 lbs of fuel remaining when he began the flight. Since the drop point was within 2 to 3 minutes of the departure point, he elected to proceed without refueling. While hovering and being guided into the drop… - [NTSB CHI82DA173](https://openairdocs.org/ntsb/CHI82DA173.md): Cessna 210 · Loganville, WI · Accident · No injuries · Final report · May 18, 1982 · N9698T · Substantial damage > During landing approach the engine lost power and the pilot attempted to land in an open field. The aircraft failed to clear a terrace and the nose gear separated from the airplane. The pilot stated, "while concentrating on the various aspects of operation in… - [NTSB MKC82DA089](https://openairdocs.org/ntsb/MKC82DA089.md): Piper PA-38-112 · Scottsbluff, NE · Accident · No injuries · Final report · May 17, 1982 · N25718 · Substantial damage > The pilot stated that during an approach for a touch and go landing, at an altitude of about 50 feet above the runway the aircraft began to drop. He applied throttle and the engine hesitated, failing to accelerate until just before impact with the runway. The… - [NTSB ATL82FKM04](https://openairdocs.org/ntsb/ATL82FKM04.md): Cessna 172G · Worthville, NC · Accident · Serious injuries · Final report · May 17, 1982 · N5884R · Destroyed > During arrival, the pilot entered a left downwind for runway 11 and proceeded to make a low pass over the strip to chase off cows. At approximately midfield, he initiated a climb and according to the passenger, when power was applied, the engine did not… - [NTSB DCA82AA022](https://openairdocs.org/ntsb/DCA82AA022.md): de Havilland DHC-6-200 · Hooper Bay, AK · Accident · Serious injuries · Final report · May 16, 1982 · N103AQ · Destroyed > At 0833 adt, the acft departed bethel, AK on a scheduled pax/cargo commuter flt to chevak, scammon bay & Hooper Bay, AK. The operator's commuter flts had not landed at scammon bay for svrl days since the rwy was soft & muddy from meltingsnow. Bfr departing… - [NTSB CHI82DA169](https://openairdocs.org/ntsb/CHI82DA169.md): Schweizer SGU 2 22E · Belden, OH · Accident · Serious injuries · Final report · May 16, 1982 · N2732Z · Destroyed > During dual flight in a glider practicing stalls the pilot recovered at a low altitude and collided with wires. - [NTSB ATL82DA134](https://openairdocs.org/ntsb/ATL82DA134.md): Cessna 150M · Hagerstown, MO · Accident · No injuries · Final report · May 16, 1982 · N3167V · Substantial damage > On final approach the student pilot felt the aircraft sink and realized she was not going to make the runway. Simultaneously power was applied and the nose of the aircraft was pulled up in an attempt to reach the runway. The aircraft stalled and nosed over… - [NTSB DEN82DA087](https://openairdocs.org/ntsb/DEN82DA087.md): Cessna 185A · Marion, MT · Accident · No injuries · Final report · May 15, 1982 · N4175Y · Substantial damage > The pilot reported that when he was on final approach, he lost all control, while at an airspeed of about 74 mph, and the aircraft struck the ground in a nose low attitude. He reported that the wind was variable at 10 gusting 20 KTS. About 35 miles away at… - [NTSB NYC82FA091](https://openairdocs.org/ntsb/NYC82FA091.md): Cessna 172P · Sanford, ME · Accident · Serious injuries · Field investigation · Final report · May 12, 1982 · N53442 · 2 aircraft · Substantial damage > A Piper PA-28, N81029, and a Cessna 172P, N53442, were approaching to land on runway 14, when they collided about 1000 ft from the threshold. The pilot of the Piper stated that he had entered the traffic pattern and began to explain the mechanics of the… - [NTSB LAX82FA170](https://openairdocs.org/ntsb/LAX82FA170.md): Cessna 172K · Huntington Beac, CA · Accident · Minor injuries · Field investigation · Final report · May 12, 1982 · N7394G · Substantial damage > The pilot reported that while he was on final approach to runway 19, he applied full flaps near the airport boundary and the aircraft veered to the right. He said that the aircraft did not respond to aileron control inputs. The aircraft continued to the… - [NTSB MKC82DA074](https://openairdocs.org/ntsb/MKC82DA074.md): Bellanca 8KCAB · Hayitt, MO · Accident · No injuries · Final report · May 9, 1982 · N5067K · Substantial damage > The pilot stated that he came in slightly low on final to avoid crossing a road that ran through the center of the airstrip. The wheat field at the south end of the strip blended in with the colors and texture of the runway. The landing gear caught the tall… - [NTSB ATL82DA128](https://openairdocs.org/ntsb/ATL82DA128.md): Cessna A150L · Greensboro, NC · Accident · No injuries · Final report · May 9, 1982 · N5938J · Substantial damage > While landing the pilot reported his misjudgement caused him to undershoot and touchdown short of the runway. The pilot stated he touched down hard on the left main gear and suggested that the nose gear failed to the right, possibly prior to contact with a… - [NTSB LAX82FA164](https://openairdocs.org/ntsb/LAX82FA164.md): Cessna 172 · Upper Lake, CA · Accident · 4 fatal · Field investigation · Final report · May 8, 1982 · N8313E · Destroyed > Witnesses observed the acft rolling right & left during the final approach. The acft drifted to the right & power was applied prior to the collision with the trees. Nw winds in excess of 25K prevailed. A CFI witness stated that it appeared the plt was not… - [NTSB LAX82FA162](https://openairdocs.org/ntsb/LAX82FA162.md): Bellanca 17-30 · Santa Barbara, CA · Accident · 2 fatal · Field investigation · Final report · May 8, 1982 · N4907V · Destroyed > The pilot visited fresno fss for a weather briefing on route to Santa Barbara. He was advised of weather and told VFR flight was not recommended. The pilot then said he would go VFR and make an instrument approach at Santa Barbara if weather was as bad as… - [NTSB SEA82DA066](https://openairdocs.org/ntsb/SEA82DA066.md): Cessna 150F · Grande Ronde, OR · Accident · No injuries · Final report · May 6, 1982 · N6701F · Substantial damage > The student pilot stated that on landing approach the sun was in his eyes. The landing occurred about 50 feet short of the runway threshold when the tail collided with a fence post and the nose wheel contacted a ditch. - [NTSB LAX82DA158](https://openairdocs.org/ntsb/LAX82DA158.md): Piper PA-28-161 · North Las Vegas, NV · Accident · No injuries · Final report · May 4, 1982 · N29500 · Substantial damage > During an instructional flight the instructor was demonstrating a short field landing using the minimum length of the runway. On final the aircraft hit a dirt bank separating the right main landing gear. The instructor stated there were no markings on the… - [NTSB CHI82DA152](https://openairdocs.org/ntsb/CHI82DA152.md): Piper PA-12 · Quincy, IN · Accident · Minor injuries · Final report · May 3, 1982 · N7606H · Substantial damage > During a pleasure flight, the pilot elected to make an approach to a new runway that he was building. His approach was made from west to east; the wind was reported to be from the north at 7 KTS. The pilot stated that he throttled the engine back to a normal… - [NTSB LAX82FVG22](https://openairdocs.org/ntsb/LAX82FVG22.md): Osprey 2 · Lakeport, CA · Accident · Minor injuries · Final report · May 2, 1982 · N58ED · Substantial damage > The pilot reported that after takeoff, he made a few turns and then headed downwind for a landing when he lost the control of an aileron. He reported that he encountered a bad vibration, so he cut the power and brought the plane into a small field by crossing… - [NTSB MKC82DA067](https://openairdocs.org/ntsb/MKC82DA067.md): Cessna 150 · Nevada, IA · Accident · No injuries · Final report · May 1, 1982 · N11894 · Substantial damage > After returning from a cross-country flight, the pilot made one go-around when he thought he was too fast. Just beyond the end of the runway at about 200 ft AGL, the engine stopped running due to fuel exhaustion. The pilot attempted to turn and land on the… - [NTSB LAX82FA156](https://openairdocs.org/ntsb/LAX82FA156.md): Beech A24R · Camarillo, CA · Accident · Minor injuries · Field investigation · Final report · May 1, 1982 · N24584 · 2 aircraft · Substantial damage > The pilot took off from the Camarillo airport on a local flight to practice touch and go landings. He had made two touch and go patterns and was on his third and final landing when the collision occurred. He had transmitted his position on downwind and base… - [NTSB DEN82FA075](https://openairdocs.org/ntsb/DEN82FA075.md): Piper PA-24-250 · Wheatland, WY · Accident · 1 fatal · Field investigation · Final report · May 1, 1982 · N6695P · Destroyed > The acft struck a tree approximately 1/2 mi from the approach end of rwy 08. No fuel was on board the acft. The gear were down & the flaps were in the 10 deg position. - [NTSB CHI82DA147](https://openairdocs.org/ntsb/CHI82DA147.md): Mong Sport MS-1 · Pendleton, IN · Accident · Serious injuries · Final report · May 1, 1982 · N98L · Destroyed > When the pilot arrived at anderson, Indiana, he was unable to find the ace airport. He saw huntzinger airport, a private strip, and decided to land to find out exactly where ace airport was located. During an approach to the sod runway, the aircraft collided… - [NTSB ATL82DA118](https://openairdocs.org/ntsb/ATL82DA118.md): Piper PA-18A · Timmonsville, SC · Accident · No injuries · Final report · May 1, 1982 · N3192Z · Substantial damage > The pilot reported that he reduced power at 1000 ft and applied carburetor heat for an extended glide to the sod strip. While on final approach over a wheat field, the airspeed bled off and he moved the throttle to add power. However, he reported that the… - [NTSB DEN82FTM11](https://openairdocs.org/ntsb/DEN82FTM11.md): Bell 47G-3B-1 · Vermal, UT · Accident · Serious injuries · Final report · Apr 28, 1982 · N48217 · Substantial damage > The pilot stated that he experienced a partial loss of engine power during landing at an elevation of about 5280 ft MSL. The temperature was about 50 degrees fahrenheit. He applied full throttle, but the RPM decayed and the plane crash landed. A partial… - [NTSB NYC82DA079](https://openairdocs.org/ntsb/NYC82DA079.md): Piper 601P · New Castle, PA · Accident · No injuries · Final report · Apr 27, 1982 · N31EH · Substantial damage > A witness who observed the accident stated that he saw N31EH on a very close right base at 150-200 ft above the ground. The aircraft was moving at a rapid rate of speed and was in a very steep right turn. As the aircraft got closer to the runway it became… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=220 ## 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=219 --- 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.