# 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 217 of 420 · 20,992 cases ## Cases, newest first - [NTSB SEA82DA141](https://openairdocs.org/ntsb/SEA82DA141.md): Piper PA-28-161 · Olympia, WA · Accident · No injuries · Final report · Aug 13, 1982 · N8436B · Substantial damage > This was the student pilot's first night flight. The instructor pilot reported that on the second landing, the aircraft struck an elevated set of approach lights, short of the runway. - [NTSB MKC82IA143](https://openairdocs.org/ntsb/MKC82IA143.md): Boeing 737-291 · North Platte, NE · Incident · Minor injuries · Incident investigation · Final report · Aug 13, 1982 · N7345F · Minor damage > The pilot stated that the first officer was hand flying the aircraft on the IFR approach. Both flight crew members saw the approach and runway lights and confirmed the cloud ceiling was 300 ft and visibility was 3/4 mile. The approach was continued and the… - [NTSB MKC82DA142](https://openairdocs.org/ntsb/MKC82DA142.md): Cessna 210J · Lees Summit, MO · Accident · 2 fatal · Final report · Aug 13, 1982 · N3331S · Destroyed > The aircraft had been repainted at topeka, KS. On a return flight to Kansas city, MO, the pilot diverted to olathe, KS after finding clouds at the intended destination. He then departed on a night flight to Lees Summit, MO. After entering the traffic pattern… - [NTSB DEN82FTA11](https://openairdocs.org/ntsb/DEN82FTA11.md): Piper PA-18 · Hardin, MI · Accident · 2 fatal · Final report · Aug 13, 1982 · N83620 · Destroyed > The wreckage was found 3/4 mi west of the nw end of a farm rwy in the approximate position of where a right turn would occur from the downwind leg to the base leg of a right pattern to the se rwy. The wreckage showed evidence of a right rotational moment at… - [NTSB CHI82DA306](https://openairdocs.org/ntsb/CHI82DA306.md): Cessna 172 · Strongville, OH · Accident · No injuries · Final report · Aug 13, 1982 · N61775 · Substantial damage > During a touch-and-go landing, the nose gear collided with wires about 1/4 mile short of the runway and the aircraft nosed over into trees. No malfunctions in the equipment were reported. The pilot reported that prior to impact, he was aware of the wires and… - [NTSB NYC82DA195](https://openairdocs.org/ntsb/NYC82DA195.md): Champion 7ECA · Lawrence, MA · Accident · No injuries · Final report · Aug 12, 1982 · N2830G · Destroyed > The instructor pilot reported that there was a loss of power after the student had adjusted his pattern for another aircraft and turned on final approach. The instructor took control of the aircraft and landed on a street. During the landing the aircraft… - [NTSB ATL82DA234](https://openairdocs.org/ntsb/ATL82DA234.md): Grumman American AA-5A · Providence, KY · Accident · No injuries · Final report · Aug 12, 1982 · N9722U · Substantial damage > Dense ground fog developed before the plt returned to land. He made two approaches & go-arounds before the accident, & each time he had to fly very low to see the rwy lights. The plt stated that during the third approach he was looking for the arpt & not… - [NTSB LAX82DA293](https://openairdocs.org/ntsb/LAX82DA293.md): Beech E55 · Payson, AZ · Accident · Minor injuries · Final report · Aug 10, 1982 · N235J · Substantial damage > The aircraft crashed on the runway after the pilot completed a flight of about four hours. He reported that both engines lost power in the traffic pattern. An investigation revealed there was no fuel remaining. The aircraft had a total usable fuel supply of… - [NTSB NYC82FA188](https://openairdocs.org/ntsb/NYC82FA188.md): Cessna 310R · Danbury, CT · Accident · 1 fatal · Field investigation · Final report · Aug 9, 1982 · N98841 · Destroyed > Approaching the destination arpt, the plt was advised to plan a VOR rwy 24 approach & that he would be turned just inside the faf. At 0055, newark a/c identified the acft 3 mi north of the arpt still at 2,000 ft & asked the plt if he was able to execute the… - [NTSB LAX82FA291](https://openairdocs.org/ntsb/LAX82FA291.md): Cessna 152 · Weaverville, CA · Accident · 1 fatal · Field investigation · Final report · Aug 8, 1982 · N48754 · Destroyed > The student pilot was practicing takeoffs and landings at a unidirectional runway. The airport procedure was to takeoff downhill on runway 18 and to land uphill on runway 36. Pilots, who flew at the airport, stated that go-arounds were not made on runway 36… - [NTSB NYC82DA185](https://openairdocs.org/ntsb/NYC82DA185.md): Grumman AA-5A · Wiscasset, ME · Accident · No injuries · Final report · Aug 7, 1982 · N8476B · Substantial damage > The student pilot was making an approach and was low and slow. By the time the instructor took over the aircraft the recovery was slow and the aircraft touched down in rough terrain 500 feet short of the runway. The nose gear snapped offduring landing. - [NTSB NYC82DA184](https://openairdocs.org/ntsb/NYC82DA184.md): Aeronca 11BC · Long Lake, NY · Accident · Minor injuries · Final report · Aug 6, 1982 · N4011E · Substantial damage > The pilot was making a 360 degree turn to survey a lake landing area when he lost airspeed and stalled as he spotted a landing area. The aircraft sank in 15 feet of water. - [NTSB LAX82DA289](https://openairdocs.org/ntsb/LAX82DA289.md): Cessna 152 · Phoenix, AZ · Accident · No injuries · Final report · Aug 5, 1982 · N6349M · Substantial damage > During a dual instructional flight, the instructor pilot (ip) initiated a forced landing for a student by pulling the mixture control out. The forced landing was taken to an altitude of about 400 ft AGL, then the ip pushed the mixture control in and told the… - [NTSB FTW82DA313](https://openairdocs.org/ntsb/FTW82DA313.md): Bellanca 8KCAB · Alvin, TX · Accident · No injuries · Final report · Aug 5, 1982 · N5503K · Substantial damage > The pilot was making an approach to land in calm wind conditions. About 100 ft from the approach end of the runway, the aircraft stalled and crashed. - [NTSB NYC82FA181](https://openairdocs.org/ntsb/NYC82FA181.md): Piper PA-28-161 · Concord, NH · Accident · 2 fatal · Field investigation · Final report · Aug 4, 1982 · N81786 · Destroyed > The plt was advised during the 0028 & 0203 wx briefings that VFR flt was not recommended. At 0304 the plt called fss to activate his flt plan & was again advised VFR flt was not recommended. At 0403 the flt was given Concord wx & at 0406WAS cleared into the… - [NTSB CHI82DA302](https://openairdocs.org/ntsb/CHI82DA302.md): Sonerai II · Peru, IL · Accident · No injuries · Final report · Aug 3, 1982 · N52VM · Substantial damage > The pilot stated this was the first cross-country in the aircraft the fuel consumption calculations were based on an estimated 4 gallons per hour. When the pilot realized a low fuel condition he decided to land enroute. During the landing approach at Peru, IL… - [NTSB ATL82DA225](https://openairdocs.org/ntsb/ATL82DA225.md): Piper PA-38-112 · Keyser, WV · Accident · No injuries · Final report · Aug 1, 1982 · N2386K · Destroyed > Pilot was making a go-around over a 1700 foot runway. Full flaps were left down until end of runway and then raised to 21 degrees. Terrain was rising faster then aircraft was climbing. Aircraft struck trees and nosed down into the ground. Temperature was 85… - [NTSB SEA82DA132](https://openairdocs.org/ntsb/SEA82DA132.md): Cessna 172M · Donnelly, ID · Accident · Minor injuries · Final report · Jul 31, 1982 · N13359 · Substantial damage > The aircraft floated the entire length of the runway without touching down before a go-around was started. During the go-around, the left wing collided with a tree at near-stall speed. The aircraft yawed 180 degrees and impacted the ground going backwards. - [NTSB NYC82FNE04](https://openairdocs.org/ntsb/NYC82FNE04.md): Bellanca 7KCAB · Agawam, MA · Accident · Serious injuries · Final report · Jul 31, 1982 · N57507 · Destroyed > While setting up to land on rwy 23, the plt throttled back the eng & it quit. The acft crashed into a wooded area approximately 1/4 mi from the end of the rwy. During the post-accident eng run, the eng would not maintain 700 RPM at idle (manufacturers… - [NTSB MKC82DA136](https://openairdocs.org/ntsb/MKC82DA136.md): Cessna 210L · North Platte, NE · Accident · Minor injuries · Final report · Jul 31, 1982 · N22447 · Substantial damage > During the flight, the pilot had managed his fuel by switching tanks at one to two hour intervals. While arriving, he had been using fuel from his right tank and elected to continue using it. As he was aligning the aircraft with the runway, he made a sharp… - [NTSB FTW82FRG34](https://openairdocs.org/ntsb/FTW82FRG34.md): Beech C23 · Port Aransas, TX · Accident · 1 fatal · Final report · Jul 31, 1982 · N6631D · Substantial damage > Witnesses observed the acft on a high final approach to rwy 12 when a go-around was initiated over the rwy at approximately 150 to 200 ft AGL. The acft started a steep banked right turn to a downwind position. The bank continued and the acft descended rapidly… - [NTSB CHI82IA284](https://openairdocs.org/ntsb/CHI82IA284.md): Cessna 182P · Oshkosh, WI · Incident · No injuries · Incident investigation · Final report · Jul 31, 1982 · N21254 · Minor damage > The pilot entered traffic pattern downwind as number 3 for landing. Traffic pattern spacing required a three mile final approach over lake winnebago. The pilot stated that there were two slower aircraft preceeding him and that spacing between aircraft was… - [NTSB MKC82FCG18](https://openairdocs.org/ntsb/MKC82FCG18.md): Thorp T-18 · Neosho, MO · Accident · 2 fatal · Final report · Jul 30, 1982 · N75A · Substantial damage > The aircraft crashed after it entered the traffic pattern for a landing. A witness reported that he observed the aircraft close in on a base leg as the pilot began a turn to final approach. He estimated that the pilot was in a 60 deg turn at about 150 ft AGL,… - [NTSB SEA82DA131](https://openairdocs.org/ntsb/SEA82DA131.md): Cessna 172N · Roche Harbor, WA · Accident · No injuries · Final report · Jul 29, 1982 · N9528G · Substantial damage > The pilot flew to a private airstrip that was open to grazing animals. During arrival, he made a low pass to check that the runway was clear of animals and other obstructions. He then circled to land. During final approach, he noticed sheep coming onto the… - [NTSB NYC82IA170](https://openairdocs.org/ntsb/NYC82IA170.md): Boeing 727-231 · Flushing, NY · Incident · No injuries · Incident investigation · Final report · Jul 28, 1982 · N64323 · Minor damage > Twa flt 524, a Boeing 727-231, was executing an ILS rwy 22 apch to laguardia airport when it encountered low level windshear on final apch. The apch was conducted in IMC. The crew reported that they broke out and observed the rwy centerline lights at 100FT… - [NTSB DEN82DA147](https://openairdocs.org/ntsb/DEN82DA147.md): Bell UH1B · Bryce Canyon, UT · Accident · No injuries · Final report · Jul 28, 1982 · N88389 · Substantial damage > The pilot was making an approach to a 10,000 ft mountain, let the RPM decay and made a hard landing. The density altitude was 12,500 feet. There was about 500 or 600 pounds of cargo on the long line. - [NTSB CHI82DA278](https://openairdocs.org/ntsb/CHI82DA278.md): Piper PA-23 · Ladysmith, WI · Accident · No injuries · Final report · Jul 28, 1982 · N3092P · Substantial damage > A ferry permit was issued to fly the aircraft to the rusk county airport for an annual inspection. The previous annual inspection had been on 8/20/80. During the arrival at the destination, the approach was high, so the pilot elected to go around. At about… - [NTSB CHI82DA283](https://openairdocs.org/ntsb/CHI82DA283.md): Q-Berry Hawk · Noble, IL · Accident · No injuries · Final report · Jul 27, 1982 · N72HQ · Substantial damage > About 30 min after taking off on a local test flight, the pilot had entered the traffic pattern and was preparing to turn onto a crosswind leg, when the engine lost power. He attempted to restart the engine, but was unable. He attempted to glide to a runway,… - [NTSB LAX82FUJ44](https://openairdocs.org/ntsb/LAX82FUJ44.md): Hallquist Thunderbolt · Mesa, AZ · Accident · Serious injuries · Final report · Jul 25, 1982 · N125GH · Substantial damage > Formation flight came over the rwy upwind at 2,000 ft MSL. Plt was cleared #2 to land, peeled off & stalled during left turn to downwind. The plt recovered about 100 ft AGL but collided with a tall tree. - [NTSB LAX82DA276](https://openairdocs.org/ntsb/LAX82DA276.md): Morrisey 2150 · San Carlos, CA · Accident · No injuries · Final report · Jul 25, 1982 · N5107V · Substantial damage > The eng quit from fuel exhaustion & the acft made a forced landing 1/2 mi short of the destination arpt. - [NTSB DEN82DA142](https://openairdocs.org/ntsb/DEN82DA142.md): Beechcraft C-45H · Aurora, CO · Accident · No injuries · Final report · Jul 25, 1982 · N444Q · Substantial damage > The pilot reported that he was unable to extend the landing gear by using either the normal or emergency systems. After repeated attempts to extend the gear, he elected to land with it configured in a free-fall position. He shut down and feathered both… - [NTSB ATL82DA211](https://openairdocs.org/ntsb/ATL82DA211.md): Cessna 150 · Louisville, KY · Accident · No injuries · Final report · Jul 25, 1982 · N63379 · Substantial damage > The pilot took off on a local flight intending to make a touch and go landing. He reported that the engine operated normally at full power during takeoff, but when the power was reduced on downwind, the engine began to run rough, miss and would not hold a… - [NTSB CHI82DA269](https://openairdocs.org/ntsb/CHI82DA269.md): Cessna 172N · Isle, MN · Accident · No injuries · Final report · Jul 23, 1982 · N733CH · Substantial damage > The pilot was on a cross-country flight and began an approach to a private airstrip. He reported that the weather conditions were good with light turbulence. About 100 ft from the threshold, the aircraft began to settle and the pilot added power. However, the… - [NTSB SEA82DA120](https://openairdocs.org/ntsb/SEA82DA120.md): Hughes 369D · 35 W. Of Ketchi, AK · Accident · No injuries · Final report · Jul 21, 1982 · N58414 · Destroyed > The pilot was conducting a sling load operation with a 50 ft cable attached. After the last sling load was moved to a new drilling site, the pilot elected to leave the cable attached since there was no suitable landing area nearby. He stated that the cable… - [NTSB ATL82FLJ07](https://openairdocs.org/ntsb/ATL82FLJ07.md): Grumman American AA-1B · Gatesville, NC · Accident · Serious injuries · Final report · Jul 18, 1982 · N8870L · Substantial damage > While on final approach for landing, the pilot added 1/3 flaps and adjusted the throttle to clear obstacles. He reported that when he was on short final, he was distracted by several deer that were approaching the touchdown point. The pilot theorized that… - [NTSB SEA82FYM21](https://openairdocs.org/ntsb/SEA82FYM21.md): Cessna TU206G · Hood River, OR · Accident · No injuries · Final report · Jul 17, 1982 · N756XW · Substantial damage > The eng failed as the plt switched from the left to right tank while turning base. He turned on the boost pump but the eng did not start. He switched back to the left tank & turned on the high boost. The eng failed to start & the acft crashed into an apple… - [NTSB DEN82DA135](https://openairdocs.org/ntsb/DEN82DA135.md): Beech A23 · Oakes, ND · Accident · No injuries · Final report · Jul 16, 1982 · N8878M · Substantial damage > During a night landing, the aircraft touched down about 220 ft short of the approach end of the runway. Reportedly, the wheels struck a "washout" and the plane was substantially damaged. - [NTSB CHI82DA258](https://openairdocs.org/ntsb/CHI82DA258.md): Luscombe 8F · Belleville, MI · Accident · No injuries · Final report · Jul 16, 1982 · N5PL · Substantial damage > During the approach the acft stalled about 20 ft AGL. The plt added power but the acft touched down short of the rwy & collided with a ditch. - [NTSB ATL82FIG10](https://openairdocs.org/ntsb/ATL82FIG10.md): Windwagon · Frederick, MD · Accident · 1 fatal · Final report · Jul 16, 1982 · N8519F · Destroyed > This was the initial test flight for the experimental amateur built aircraft. Two gallons of fuel was added to the aircraft which did not completely fill the tank. After refueling, numerous high speed taxi runs and low altitude lift-offs and landings were… - [NTSB SEA82FA111](https://openairdocs.org/ntsb/SEA82FA111.md): Cessna 172F · Oxbow, OR · Accident · 4 fatal · Field investigation · Final report · Jul 15, 1982 · N8230U · Destroyed > During the final approach the aircraft was observed to descend to approximately 50 feet above the river and then execute a pullup and begin a left turn to either reenter a left downwind or reverse the direction of landing. The pilot lost control, the left… - [NTSB NYC82DA159](https://openairdocs.org/ntsb/NYC82DA159.md): Cessna R172E · Latham, NY · Accident · No injuries · Final report · Jul 15, 1982 · N26209 · Substantial damage > Pilot reduced power to idle on final approach and when he tried to add power there was no response. No reason for failure was found. - [NTSB LAX82FA256](https://openairdocs.org/ntsb/LAX82FA256.md): Cessna 195 · Carson City, NV · Accident · 1 fatal · Field investigation · Final report · Jul 14, 1982 · N301M · Destroyed > It was reported the plt was going to make some touch & go landings before starting out on the cross-country. On the third approach the acft was observed on final approach, about 300 yds from the rwy, making a left turn of about 360 deg at a low altitude. At… - [NTSB DEN82DA134](https://openairdocs.org/ntsb/DEN82DA134.md): Piper PA-28RT-201 · Englewood, CO · Accident · No injuries · Final report · Jul 13, 1982 · N8277D · Substantial damage > While practicing power off approaches the pilot undershot the runway and landed short. Power was added but not soon enough to prevent an accident. The aircraft contacted the ground, turned 90 degrees, slid 50 yards and stopped. - [NTSB CHI82DA323](https://openairdocs.org/ntsb/CHI82DA323.md): Piper PA-18 · Ranier, MI · Accident · No injuries · Final report · Jul 12, 1982 · N41039 · Substantial damage > Pilot stalled turning on final approach and crashed into water. No malfunctions found. - [NTSB SEA82DA108](https://openairdocs.org/ntsb/SEA82DA108.md): Grumman AA-5B · Corvallis, OR · Accident · No injuries · Final report · Jul 11, 1982 · N81382 · Substantial damage > The aircraft contacted the surface while the pilot was making a low pass over the private airport. Fresh cut hay was windrowed at the edge of the strip. The hay caught on the landing gear and blew up into the elevators and the aircraft was damaged when it… - [NTSB LAX82DA254](https://openairdocs.org/ntsb/LAX82DA254.md): Blanik L-13 · Murrieta, CA · Accident · No injuries · Final report · Jul 11, 1982 · N90639 · Substantial damage > Pilot landed short of runway in a glider and impacted the ground at high speed with high sink rate. He had released early from an aerotow and descended at high airspeed with dive brakes open which accelerated his rate of sink. He was not injured in the… - [NTSB CHI82DA244](https://openairdocs.org/ntsb/CHI82DA244.md): Fairchild 24R-46A · Franklin, WI · Accident · No injuries · Final report · Jul 11, 1982 · N77697 · Substantial damage > The pilot took off and remained in the traffic pattern to land on runway 27. He estimated that the wind was from 300 degrees at 10 knots. He reported that on final approach, he got too low; then about 200 ft short of the runway, his head wind was blocked by… - [NTSB FTW82DA275](https://openairdocs.org/ntsb/FTW82DA275.md): Cessna 402B · Austin, TX · Accident · Serious injuries · Final report · Jul 10, 1982 · N87280 · 2 aircraft · Substantial damage > Both acft were approaching from the ssw & flying assigned headings. Neither acft had been assigned an altitude. Just prior to impat, approach control (a/c) told the C-402B to fly 360 to follow traffic & asked what his altitude was. When the plt responded he… - [NTSB DEN82AA132](https://openairdocs.org/ntsb/DEN82AA132.md): Piper PA-24-250 · Billings, MT · Accident · 1 fatal · Final report · Jul 9, 1982 · N5356P · Substantial damage > Plt decided to land enroute due wx. At 0803 he contacted Billings fss & was advised Billings wx was 5,000 ft broken. At 0809 he called Billings approach control (a/c) & advised he was 20 mi for landing. Enroute to arpt he was unable to locate the arpt due wx… - [NTSB ANC82DAG34](https://openairdocs.org/ntsb/ANC82DAG34.md): Junior Ace D · Ninilchik, AK · Accident · Minor injuries · Final report · Jul 9, 1982 · N8537P · Substantial damage > The pilot reported that while he was maneuvering to land, the right rudder pedal became locked in the"full up position." This caused the aircraft to move through the air in uncoordinated flight. The pilot applied full power and banked the aircraft to the… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=218 ## 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=217 --- 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.