# 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 221 of 420 · 20,992 cases ## Cases, newest first - [NTSB LAX82AA106](https://openairdocs.org/ntsb/LAX82AA106.md): Boeing KC-135A · Glendale, AZ · Accident · 6 fatal · Final report · Mar 13, 1982 · KC135 · 2 aircraft · Destroyed > The USAF KC-135 was on an IFR flt plan & executing a tacan 3L apch to luke afb. The AA-1 had departed sky harbour arpt &had been released by phoenix trsa. The AA-1 was heading westerly in airspace designated as a special traffic area & was required to have… - [NTSB ANC82DA026](https://openairdocs.org/ntsb/ANC82DA026.md): Taylorcraft BC12-D · Willow, AK · Accident · Minor injuries · Final report · Mar 13, 1982 · N5621M · Substantial damage > The owner of the aircraft was a student pilot. She asked a private pilot to accompany her after she had skis installed on the aircraft. She had been indorsed for solo flight in the aircraft, but had no qualified instruction on ski operations. The private… - [NTSB NYC82FFJ12](https://openairdocs.org/ntsb/NYC82FFJ12.md): Piper PA-32 · Syracuse, NY · Accident · Minor injuries · Final report · Mar 12, 1982 · N260BB · Substantial damage > The pilot took off on a VFR flight plan with a litter patient and 3 other passengers onboard. The right main fuel tank was used for about the first 30 minutes of flight, then the pilot switched to the left main tank. While en route, an IFR flight plan was… - [NTSB DEN82DA042](https://openairdocs.org/ntsb/DEN82DA042.md): Beech A36TC · Boulder, CO · Accident · No injuries · Final report · Mar 12, 1982 · N3738J · Substantial damage > The pilot reported that during a normal approach, he encountered a severe downdraft in winds gusting about 40 to 60 knots. He started to abort the landing by raising the gear and applying full power. The pilot stated that he turned right to avoid a hill, but… - [NTSB NYC82FA050](https://openairdocs.org/ntsb/NYC82FA050.md): Cessna T337C · Bloomfield, CT · Accident · 1 fatal · Field investigation · Final report · Mar 11, 1982 · N7721X · Destroyed > At 0630 & 0800 the plt received wx briefing for an IFR flt to bridgeport, CT & was advised of flt precautions for icing, low ceilings & visibilities. The flt departed at 0907. At 1118 the plt diverted to windsor locks for landing at bradley intl arpt because… - [NTSB CHI82DA081](https://openairdocs.org/ntsb/CHI82DA081.md): Piper PA-23 250 · Grand Marais, MN · Accident · No injuries · Final report · Mar 8, 1982 · N6625Y · Substantial damage > After clearing trees located approximately 1000 feet from the end of the runway the pilot reduced power and added flaps in an attempt to land close to the approach end. The aircraft struck a snowbank on short final for the snow covered runway 27. - [NTSB ATL82DA067](https://openairdocs.org/ntsb/ATL82DA067.md): Piper PA-28-181 · Murfreesboro, TN · Accident · No injuries · Final report · Mar 8, 1982 · N75029 · Substantial damage > The pilot estimated his fuel consumption to be 10 gal/hr. The actual consumption was about 12 gal/hr. Approximately 20 miles from his destination, he decided to make an enroute stop for fuel. While turning to final approach for landing, the engine quit. From… - [NTSB CHI82DA078](https://openairdocs.org/ntsb/CHI82DA078.md): Piper PA-30 · Valparaiso, IN · Accident · No injuries · Final report · Mar 5, 1982 · N34EE · Substantial damage > The pilot reported encountering severe icing conditions after he had canceled his IFR flight plan and had the airport in sight. At that point, he felt that the safest alternative was to continue the approach. The approach was flown at 120 mph with no flaps.… - [NTSB LAX82DA092](https://openairdocs.org/ntsb/LAX82DA092.md): Piper J3F-65 · Chandler, AZ · Accident · Minor injuries · Final report · Mar 2, 1982 · N38857 · Substantial damage > While on a downwind leg of the traffic pattern, the pilot noticed a very loud grinding noise as if the engine was coming apart. He stated that the engine RPM became very high. He attempted to maneuver for a landing on the runway but entered a high sink rate.… - [NTSB FTW82DA075](https://openairdocs.org/ntsb/FTW82DA075.md): Bell 206B · High Island Blk · Accident · 2 fatal · Final report · Mar 2, 1982 · N63AL · Destroyed > The aircraft was low on the approach and during the flare, the vertical fin and tail boom contacted the safety netting extending beyond the boundaries of the platform landing area. The aircraft then settled back off the platform with one main rotor blade… - [NTSB ATL82DA063](https://openairdocs.org/ntsb/ATL82DA063.md): Smith Mini · Brownsboro, AL · Accident · Minor injuries · Final report · Mar 2, 1982 · N37WS · Substantial damage > The pilot took off with a malfunctioning fuel quantity guage. Before takeoff, he visually checked the fuel and estimated that the tank was about 1/2 full. After returning from a local flight, the engine lost power during a turn to final approach for landing.… - [NTSB LAX82FVA13](https://openairdocs.org/ntsb/LAX82FVA13.md): Beech T-34B · Lemoore, CA · Accident · 1 fatal · Final report · Feb 28, 1982 · N1410Z · Destroyed > The T-34 pilot entered a downwind behind a Cessna 150 aircraft. When the T-34 pilot was abeam the approach end of runway 32R, he was cleared for a touch and go. By this time, the Cessna 150 was on the runway. The Cessna pilot requested a 180 degree turn to… - [NTSB LAX82DA087](https://openairdocs.org/ntsb/LAX82DA087.md): Piper J3-F65 · Yerington, NV · Accident · Minor injuries · Final report · Feb 28, 1982 · N23209 · Substantial damage > During final approach for a hard dirt field the pilot reported that the bottom fell out and he hit short resulting in substantial damage to the aircraft. - [NTSB NYC82FA041](https://openairdocs.org/ntsb/NYC82FA041.md): Cessna 150G · Erwinna, PA · Accident · Serious injuries · Field investigation · Final report · Feb 27, 1982 · N3318J · Substantial damage > This was the student's first solo in powered aircraft. He held a private pilot certificate with a glider rating. His takeoff and traffic pattern appeared normal until the last part of his final approach for landing. About 600 ft short of the runway, the… - [NTSB MIA82DA059](https://openairdocs.org/ntsb/MIA82DA059.md): Hughes 269C · Ft. Myers, FL · Accident · No injuries · Final report · Feb 27, 1982 · N1100W · Substantial damage > During flight engine rpm's dropped and pilot immediately landed on a road. The pilot stated he attempted to check the engine power by bringing the helicopter to a hover and moving it approximately 30 feet three times. The power appeared normal so he elected… - [NTSB LAX82FUJ29](https://openairdocs.org/ntsb/LAX82FUJ29.md): Cessna 182C · Eloy, AZ · Accident · Minor injuries · Final report · Feb 27, 1982 · N8588T · Substantial damage > The aircraft crashed near the end of a runway on a dark night. The pilot stated to the police that he had run out of fuel. The police found weapons, drugs, and liquor in the pilot's possession. An estimated 3 gallons of fuel was found in each tank. According… - [NTSB CHI82DA074](https://openairdocs.org/ntsb/CHI82DA074.md): Cessna 152 · Williamsburg, MI · Accident · No injuries · Final report · Feb 27, 1982 · N47559 · Substantial damage > During a VFR approach the pilot stated he was concentrating on not landing long. The aircraft touched down in snow about 50 feet short of the landing area and slid, nose down, for approximately 50 feet. The pilot had flown a total of 3.2 hours in the last 90… - [NTSB FTW82FPA11](https://openairdocs.org/ntsb/FTW82FPA11.md): Beech D18S · Dallas, TX · Accident · No injuries · Final report · Feb 26, 1982 · N8517Z · Substantial damage > During a night, ILS approach, the plane struck a powerline about two miles short of the runway after the pilot was provided a low altitude alert. The left engine lost power and was feathered. The pilot feared possible gear damage and left it extended. Unable… - [NTSB LAX82DA082](https://openairdocs.org/ntsb/LAX82DA082.md): Cessna 172L · Gustine, CA · Accident · 1 fatal · Final report · Feb 21, 1982 · N4307Q · Destroyed > The pilot was familiar with the airport and the 35 ft power lines near the approach end of runway 36. During a night landing approach, the plane got low and the left wing struck a power line pole. - [NTSB CHI82DA067](https://openairdocs.org/ntsb/CHI82DA067.md): Piper PA-28-140 · Lakerville, MN · Accident · No injuries · Final report · Feb 21, 1982 · N1GF · Substantial damage > While on downwind, the pilot moved the fuel selector to what he believed was the left tank position. He also moved the throttle to idle to simulate an engine failure. He extended his pattern to allow time for another pilot to back-taxi down the runway to the… - [NTSB CHI82DA061](https://openairdocs.org/ntsb/CHI82DA061.md): Cessna 150 · Franklin, WI · Accident · No injuries · Final report · Feb 20, 1982 · N63213 · Substantial damage > While practicing a no-flap landing, the student allowed the aircraft to descend below the normal glide path. The instructor told the student that they were going to be low and to add power. Power was added, but soon thereafter, the aircraft touched down short… - [NTSB CHI82DA058](https://openairdocs.org/ntsb/CHI82DA058.md): Beech 58 · St. Charles, IL · Accident · No injuries · Final report · Feb 19, 1982 · N1847X · Substantial damage > During an IFR approach the pilot stated he picked up about 1/2 to 1 inch of ice on the leading edge of the wings after activating all icing equipment. After breaking out of the clouds the pilot descended with full flaps at 110 to 115 knots. He began to flare… - [NTSB NYC82DA037](https://openairdocs.org/ntsb/NYC82DA037.md): Cessna T210N · Scotia, NY · Accident · No injuries · Final report · Feb 18, 1982 · N510PE · Substantial damage > While on final approach, the engine lost power as the pilot pushed the prop control to high RPM. The pilot initiated emergency procedures but was unable to restart the engine. All switches were turned off and the aircraft was pulled up to a full stall and… - [NTSB DEN82FA034](https://openairdocs.org/ntsb/DEN82FA034.md): Piper PA-23 · Mitchell, SD · Accident · No injuries · Field investigation · Final report · Feb 18, 1982 · N5799Y · Substantial damage > As the pilot approached sioux falls he received information that it was below minimums, so he started to divert. As he passed over sioux falls he could see Mitchell, SD, which appeared to be clear, therefore, he elected to land there. It continued to look… - [NTSB FTW82DA060](https://openairdocs.org/ntsb/FTW82DA060.md): Bellanca 7ECA · Henderson, TX · Accident · No injuries · Final report · Feb 17, 1982 · N53769 · Substantial damage > After reducing power to idle, gliding for some distance, and then applying carburetor heat he realized that additional power would be needed to reach the runway. Power was added with no results and the aircraft was set down in a rough field approximately 1/4… - [NTSB DEN82DA032](https://openairdocs.org/ntsb/DEN82DA032.md): Cessna 210 · Blanding, UT · Accident · Minor injuries · Final report · Feb 17, 1982 · N4814K · Substantial damage > The pilot reported that the visibility was five miles when he landed. However, according to the airport manager, it was less than one mile with ground fog. During the landing, the left wing struck the ground when the plane touched down short of the runway… - [NTSB ATL82FA055](https://openairdocs.org/ntsb/ATL82FA055.md): Piper PA-31T2 · Springfield, KY · Accident · 8 fatal · Field investigation · Final report · Feb 17, 1982 · N2517X · Destroyed > The flt was cleared to maintain 3,000 ft MSL until over the arpt, then cruise. The plt had previously stated that he could see the lights on the ground & that he was 15 mi from the arpt. At 2013 the plt stated "we oughta be able to cancel here." The acft… - [NTSB LAX82IA075](https://openairdocs.org/ntsb/LAX82IA075.md): Boeing B737-2H4 · Ontario, CA · Incident · No injuries · Incident investigation · Final report · Feb 16, 1982 · N73717 · Minor damage > Because the glide slope had been removed from service, air cal flight 754 was vectored by the Ontario TRACON 'n' controller for a localizer only approach to runway 26L. The first officer stated he descended to 1,200 ft after passing the faf/om. The captain… - [NTSB DCA82AA015](https://openairdocs.org/ntsb/DCA82AA015.md): Nihon YS-11A · King Salmon, AK · Accident · Minor injuries · Final report · Feb 16, 1982 · N169RV · Substantial damage > The acft was on a scheduled flt from anchorage to cold bay, AK with intermediate stops at King Salmon & dutch harbor, AK. En route between anchorage & King Salmon, the air temps at cruise altitude were between -36 & -40 deg fahrenheit. While entering donwnd… - [NTSB ATL82DLJ05](https://openairdocs.org/ntsb/ATL82DLJ05.md): Cessna 150M · Fayetteville, NC · Accident · Minor injuries · Final report · Feb 16, 1982 · N63536 · Substantial damage > While attempting a night landing to an airport runway marked only with reflectors, the aircraft contacted an embankment to the left of the runway. - [NTSB MIA82DA047](https://openairdocs.org/ntsb/MIA82DA047.md): Cessna 172 · San Juan, PR · Accident · No injuries · Final report · Feb 15, 1982 · N21732 · Substantial damage > On final approach the tower controller told the flight that other aircraft had reported wind shear below 800 feet. The pilot landed the aircraft and ran off the right side of the runway. The pilot reported wind gusts to 21 knots. - [NTSB CHI82DA047](https://openairdocs.org/ntsb/CHI82DA047.md): Beech 35 · Ottawa, OH · Accident · No injuries · Final report · Feb 15, 1982 · N3859B · Substantial damage > The aircraft contacted a 4-foot snowberm located between the approach lights and the end of the pavement during the approach. The pilot was aware of the snow berm by the published NOTAM. - [NTSB NYC82DA034](https://openairdocs.org/ntsb/NYC82DA034.md): Bellanca 17-30A · Factoryville, PA · Accident · No injuries · Final report · Feb 14, 1982 · N14908 · Substantial damage > During the previous flight, there was a landing gear malfunction. A mechanic checked the gear and a decision was made to fly the plane with the gear down to another airport for maintenance. During the subsequent flight, the "gear down" speed was not exceeded.… - [NTSB CHI82DA055](https://openairdocs.org/ntsb/CHI82DA055.md): Piper PA-38-112 · Lebanon, IN · Accident · No injuries · Final report · Feb 14, 1982 · N24007 · Substantial damage > While the instructor was demonstrating recovery procedures from a low approach, the main gear struck snow on a small rise about 400 feet short of the runway. Subsequently, the pilot was forced to land in about 18 inches of snow and the gear failed. The… - [NTSB NYC82DA032](https://openairdocs.org/ntsb/NYC82DA032.md): Cessna 172K · Plymouth, MA · Accident · No injuries · Final report · Feb 10, 1982 · N84330 · Substantial damage > After entering the traffic pattern, the pilot completed his prelanding checklist while opposite of the numbers on downwind. After turning to final approach, there was a loss of engine power. He stated that he reached down and switched the fuel selector… - [NTSB MIA82FLD16](https://openairdocs.org/ntsb/MIA82FLD16.md): Cessna 310 · Lake Wales, FL · Accident · Serious injuries · Final report · Feb 10, 1982 · N5207J · Destroyed > The flt encountered bad wx over the Lake Wales arpt. The plt put the gear down & was maneuvering for an approach. The pax stated that acft then crashed. The fuel tanks had approximately one pint of fuel remaining. - [NTSB ATL82FID06](https://openairdocs.org/ntsb/ATL82FID06.md): Cessna 402B · Newport News, VA · Accident · No injuries · Final report · Feb 9, 1982 · N5218J · Substantial damage > The pilot stated that during his first ILS approach, the localizer needle fluctuated to the left. He made corrective turns to the left. When he broke out of the clouds at the decision height (dh), he observed the runway to the right and made a missed… - [NTSB ATL82FKW04](https://openairdocs.org/ntsb/ATL82FKW04.md): Cessna 182P · Nashville, TN · Accident · Minor injuries · Final report · Feb 8, 1982 · N9479M · Substantial damage > After entering a long final approach for landing, the engine lost power. While attempting to restart the engine, the pilot noted that he had not previously turned on the carburetor heat. He was unable to start the engine and maneuvered the plane to land in a… - [NTSB CHI82DA037](https://openairdocs.org/ntsb/CHI82DA037.md): Ercoupe 415-C · Brownsburg, IN · Accident · No injuries · Final report · Feb 6, 1982 · N93607 · Substantial damage > The pilot reported that during his visual approach for landing, he used full carburetor heat and cleared his engine during the base turn. While entering his final approach, he was too high and reduced his power below 1000 RPM for about 10 to 20 seconds. He… - [NTSB NYC82FHD06](https://openairdocs.org/ntsb/NYC82FHD06.md): Ted Smith Aerostar 600 · Toms River, NJ · Accident · No injuries · Final report · Feb 3, 1982 · N9759Q · Substantial damage > The pilot stated that during a VOR approach, he broke out at 600 ft and got the runway in sight. He reported that the visibility dropped frequently, but he was able to keep the runway in sight until he was about 200 yards from the runway. He stated that the… - [NTSB NYC82FA029](https://openairdocs.org/ntsb/NYC82FA029.md): Piper PA-23-250 · Newburgh, NY · Accident · 1 fatal · Field investigation · Final report · Feb 3, 1982 · N62481 · Destroyed > At 2234 the plt was issued a vector to the initial approach fix for the ILS rwy 9 apch. He was also issued the followingwx "...stewart weather thirty minutes ago is estimated one thousand overcast six miles in light rain and haze." At 2238 the plt was advised… - [NTSB NYC82AA028](https://openairdocs.org/ntsb/NYC82AA028.md): Beech 99 · Groton, CT · Accident · Serious injuries · Final report · Feb 1, 1982 · N451C · Destroyed > After crossing the mondi intersection inbound for an ILS rwy 5 apch, the captain felt that a proper descent was not possible due to a strong tailwind & their present altitude. They turned & proceeded outbound to loose altitude. The crewthen established… - [NTSB NYC82DA017](https://openairdocs.org/ntsb/NYC82DA017.md): Cessna 150L · Caldwell, NJ · Accident · No injuries · Final report · Jan 31, 1982 · N17065 · Substantial damage > The student pilot was at the controls during a landing on runway 04. The wind was from 330 degrees at 15 knots. The instructor reported that the plane was slipped to the left on short final, and shortly thereafter, the right wheel struck a snowbank. The… - [NTSB MIA82DA039](https://openairdocs.org/ntsb/MIA82DA039.md): Piper PA-28-161 · Deland, FL · Accident · No injuries · Final report · Jan 31, 1982 · N21481 · Substantial damage > While practicing normal approaches and landings the student allowed the aircraft to get too low on final approach. The instructor took the controls but was unable to prevent a touchdown short of the runway threshold. - [NTSB MKC82DA022](https://openairdocs.org/ntsb/MKC82DA022.md): Cessna 172H · Wentzville, MO · Accident · No injuries · Final report · Jan 29, 1982 · N5333T · Substantial damage > During a cross-country flight, the pilot switched the fuel selector from both tanks to the right tank to balance the fuel. After the tanks were balanced, he failed to switch the selector back to both. During a night, final approach at his destination, the… - [NTSB ATL82FID05](https://openairdocs.org/ntsb/ATL82FID05.md): Piper PA-38-112 · Charlottesville, VA · Accident · No injuries · Final report · Jan 28, 1982 · N2466B · Substantial damage > After performing four successful night approaches the pilot attempted a short field approach with the landing light off. On final he stated it appeared he was getting too low so he turned the landing light on and continued the approach. The aircraft struck a… - [NTSB ATL82DA043](https://openairdocs.org/ntsb/ATL82DA043.md): Piper PA-32-260 · Louisville, KY · Accident · No injuries · Final report · Jan 28, 1982 · N3654W · Substantial damage > At 600FT AGL while on a 3 mile straight in visual approach,the engine quit. The pilot stated he had insufficient time to attempt a restart and commenced a 180 degree turn toward a golf course. Upon landing the aircraft struck a tree. Investigation revealed no… - [NTSB SEA82FYK07](https://openairdocs.org/ntsb/SEA82FYK07.md): Cessna 172 · Lapine, OR · Accident · 1 fatal · Final report · Jan 24, 1982 · N8172B · Destroyed > When the pilot landed at lakeview,OR,he checked the weather but reported to his passenger that although the weather was bad he did not want to stay in lakeview. The aircraft departed lakeview, following a highway, when the weather conditions continued to… - [NTSB NYC82FNA10](https://openairdocs.org/ntsb/NYC82FNA10.md): Cessna 172 · Taunton, MA · Accident · Minor injuries · Final report · Jan 24, 1982 · N80420 · Substantial damage > The student pilot took off at night on an unsupervised pleasure flight. His passenger did not hold any type of pilot certificate. After takeoff, the pilot encountered fog. He used the nbd for orientation and was able to return to the airport. He reported… - [NTSB FTW82AA046](https://openairdocs.org/ntsb/FTW82AA046.md): Robertson C-402B · Laredo, TX · Accident · 7 fatal · Final report · Jan 24, 1982 · N4244Z · Destroyed > The acft was observed to be extremely slow throughout the approach & that the plt appeared to be having some difficulty with over-controlling the acft. It then leveled out at 50-80 ft AGL on final over the threshold, entered a nose-high attitude & then… Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=222 ## 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=221 --- 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.