# NTSB investigations: Maneuvering 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 228 of 378 · 18,851 cases ## Cases, newest first - [NTSB DEN83LA006](https://openairdocs.org/ntsb/DEN83LA006.md): Bell 47G3B1 · Malta, MT · Accident · Minor injuries · Limited investigation · Final report · Oct 2, 1982 · N7928S · Substantial damage > The pilot stated that he "was spraying the alfalfa field west to east" and that "there were tall cottonwood trees on three sides. A very sudden wind "came up" and "pushed" him into a tree. - [NTSB ANC83FAA03](https://openairdocs.org/ntsb/ANC83FAA03.md): Piper PA-18 · 27 E Sagwon, AK · Accident · No injuries · Final report · Oct 1, 1982 · N13960 · Substantial damage > The plt was inspecting a landing site for possible use. A low pass was being made at approximately 3 ft when the acft encountered a downdraft & impacted a rocky ridge area short of the site. - [NTSB FTW82FA402](https://openairdocs.org/ntsb/FTW82FA402.md): Robinson R-22 · Paige, TX · Accident · 1 fatal · Field investigation · Final report · Sep 30, 1982 · N9063Z · Destroyed > Following completion of the helicopter's annual inspection, the aircraft mechanic/pilot departed clover field in houston for the R22'S home base in austin, TX. One witness observed the helicopter in cruise flight, then saw a large piece separate from the… - [NTSB SEA82FA175](https://openairdocs.org/ntsb/SEA82FA175.md): Cessna 305A · Belden, CA · Accident · 2 fatal · Field investigation · Final report · Sep 27, 1982 · N5196G · Destroyed > During a search mission, the subject aircraft was seen to turn, then apparently slow or pause and then disappear inverted into high trees at the 4600 foot level. Parts of the aircraft being searched for were only 300 feet from the crash of the subject… - [NTSB LAX82DA365](https://openairdocs.org/ntsb/LAX82DA365.md): Grumman G-164B · Delano, CA · Accident · No injuries · Final report · Sep 27, 1982 · N48482 · Destroyed > Aircraft collided with wires during spraying of grapes. No air or ground survey made which was a normal procedure. Work pressure created the deviation. - [NTSB LAX82FJA07](https://openairdocs.org/ntsb/LAX82FJA07.md): Bellanca 7KCAB · Makawao, HI · Accident · 2 fatal · Final report · Sep 25, 1982 · N8656V · Destroyed > For insurance purposes, the owner needed about 15 more hours in the tailwheel aircraft before he could fly solo without an instructor. On 9/24 and 9/25, the owner and instructor planned to fly the needed time. Maui tower controllers reported the plane… - [NTSB FTW82FPM16](https://openairdocs.org/ntsb/FTW82FPM16.md): Mustang II · Tahlequah, OK · Accident · 1 fatal · Final report · Sep 25, 1982 · N48342 · Destroyed > The amateur built Mustang ii crashed while attempting a roll during the annual tulsa fly-in at Tahlequah airport. The acft was observed making a hi-speed fly-by over runway 35 at approximately 50 ft AGL, and start a gradual climb & roll to the right to… - [NTSB FTW82DA393](https://openairdocs.org/ntsb/FTW82DA393.md): Bellanca 7GCBC · Bracketville, TX · Accident · Minor injuries · Final report · Sep 24, 1982 · N8744V · Destroyed > Pilot stated that while flying low over a ranch looking for lost cows, he flew into high powerlines. He also stated thathe was aware that the powerlines were in the area. - [NTSB SEA82DA172](https://openairdocs.org/ntsb/SEA82DA172.md): Cessna 188B · Lava Hot Spring, ID · Accident · No injuries · Final report · Sep 23, 1982 · N9251G · Substantial damage > Reportedly, the aircraft ran out of fuel during a swath run. During a forced landing, the aircraft struck a fence, then traveled about 400 ft and stopped with the nose down in a potatoe field. - [NTSB ATL82DA283](https://openairdocs.org/ntsb/ATL82DA283.md): Glasflugel Mosquito · Tazewell, VA · Accident · No injuries · Final report · Sep 23, 1982 · N12JR · Substantial damage > The glider pilot was participating in a cross-country contest. As he was passing one of the turn points, he maneuvered to photograph the position. During this time, he went too low and was forced into making an emergency landing. While maneuvering to land, he… - [NTSB MIA82DA187](https://openairdocs.org/ntsb/MIA82DA187.md): Piper PA-36 · N. Chipley, FL · Accident · No injuries · Final report · Sep 21, 1982 · N2327Y · Destroyed > Aircraft collided with a tree while spraying. Aircraft then landed hard in the bean field. - [NTSB LAX82FXQ14](https://openairdocs.org/ntsb/LAX82FXQ14.md): Piper PA-38 · Imlay, NV · Accident · 2 fatal · Final report · Sep 19, 1982 · N24641 · Destroyed > The pilot flew up a canyon in weather that obscured the ridges in low visibility and rain. Clouds also covered the terrain. A witness saw the aircraft disappear behind a hill and a storm obscured her vision and hearing. The aircraft was located in a box… - [NTSB LAX82DA349](https://openairdocs.org/ntsb/LAX82DA349.md): North American P-51D · Reno, NV · Accident · No injuries · Final report · Sep 18, 1982 · N151DM · Substantial damage > The engine failed & caught fire during the national championship air races. The plt stated he was pre-occupied trying toput out the engine fire & turned base too late. The acft landed short of the rwy on a poorly graded road & the plt lost control of the acft. - [NTSB CHI82FA357](https://openairdocs.org/ntsb/CHI82FA357.md): Flitecraft Senior Aero · Footville, WI · Accident · 2 fatal · Field investigation · Final report · Sep 18, 1982 · N119P · Destroyed > The home built aircraft was on a familiarization flight for the pilot in the right seat. One witness stated he saw the aircraft (at about 2000 ft AGL) enter a nose high (straight up) attitude followed by a nose low (straight down) attitude. A spin then… - [NTSB DEN82FTI18](https://openairdocs.org/ntsb/DEN82FTI18.md): Cessna 150 · Conrad, MT · Accident · Serious injuries · Final report · Sep 17, 1982 · N1299Q · Substantial damage > Pilot had engine lose power momentarily on a previous flight but did not concern himself about it. During this flight power was lost at 4100 feet. Pilot tried restart without success. During landing nose was lowered prior to touchdown and it caught on an… - [NTSB DEN82FA198](https://openairdocs.org/ntsb/DEN82FA198.md): Cessna 152 · Divide, MT · Accident · 1 fatal · Field investigation · Final report · Sep 16, 1982 · N49816 · Destroyed > The acft stalled & crashed on the side of a ridge. The plt was described as an avid outdoorsman, sportsman & hunter. According to local residents near the crash site, the area is well populated with large & small game. Density altitude was computed to be… - [NTSB SEA82FYM24](https://openairdocs.org/ntsb/SEA82FYM24.md): Cessna 172P · 3nm Se Scappoos, OR · Accident · 2 fatal · Final report · Sep 15, 1982 · N7335F · Destroyed > The acft struck & severed power lines strung between two 90-foot towers located about 1500 feet apart. The power lines were about 50 to 60 feet above the water at the lowest point of the line sag. - [NTSB FTW82DA380](https://openairdocs.org/ntsb/FTW82DA380.md): Cessna 172N · Hobbs, NM · Accident · No injuries · Final report · Sep 15, 1982 · N6553E · Substantial damage > Pilot collided with power line while on pipeline patrol. A sucessful landing was made at hobb, NM airport after accident. - [NTSB DEN82DA195](https://openairdocs.org/ntsb/DEN82DA195.md): Aerospatiale SA315B · Near Kemmerer, WY · Accident · Serious injuries · Final report · Sep 15, 1982 · N7915 · Substantial damage > While hovering with an external load a loud bang was heard and the helicopter started to yaw. The pilot dropped the external load, pulled collective, centered cyclic and started descent. The main rotors hit trees and the aircraft fell to the ground.… - [NTSB DEN82FA193](https://openairdocs.org/ntsb/DEN82FA193.md): Cessna R172K · Vernal, UT · Accident · 1 fatal · Field investigation · Final report · Sep 14, 1982 · N758JM · Destroyed > The aircraft collided with trees while low flying on a local flight. Two aircraft piloted by students from a nearby college had been seen flying low and close to each other around the local mountainous terrain. The students were enrolled in the college… - [NTSB MIA82DA181](https://openairdocs.org/ntsb/MIA82DA181.md): Bell 47G4 · Madison, FL · Accident · Minor injuries · Final report · Sep 13, 1982 · N1151W · Substantial damage > The eng did not respond when power was added beginning a swath run. The plt hit the dump button to jettison the load & collided with the ground. Eng teardown revealed no evidence of failure or malfunction prior to the accident. - [NTSB LAX82FUQ17](https://openairdocs.org/ntsb/LAX82FUQ17.md): Long-Ez Rutan · Canyon Country, CA · Accident · Serious injuries · Final report · Sep 13, 1982 · N7LZ · Destroyed > The eng quit as the acft was observed performing acrobatic maneuvers. The acft was not equipped with a fuel system that would sustain fuel flow through negative "g" maneuvers. The eng would stop with a 0.5 negative g load. - [NTSB LAX82DXQ13](https://openairdocs.org/ntsb/LAX82DXQ13.md): North American F-51D · Elko, NV · Accident · 2 fatal · Final report · Sep 11, 1982 · N51JW · Destroyed > The plt flew down the length of rwy 06 about 100 ft AGL, pulled up & did an 8-point roll while climbing. He then flew down rwy 12 & pulled up. After a brief climb the plt began a slow roll to the left. Just as the acft became inverted the roll stopped & the… - [NTSB ATL82DA269](https://openairdocs.org/ntsb/ATL82DA269.md): Piper PA 25-235 · Ray City, GA · Accident · No injuries · Final report · Sep 11, 1982 · N7687Z · Substantial damage > The pilot reported that while he was spraying crops, the engine began to skip and backfire. He decided to terminate the swath run and climb from the field. At that time, the engine quit and the pilot climbed as high as possible before gliding to a nearby… - [NTSB FTW82DA374](https://openairdocs.org/ntsb/FTW82DA374.md): Cessna 172 · Vain, OK · Accident · Minor injuries · Final report · Sep 9, 1982 · N7424A · Substantial damage > The pilot and his passenger took off on a local flight and flew over a runway that they were constructing in their pasture. The pilot stated that he was in slow flight over the runway. Both occupants received concussions in the accident and could not recall… - [NTSB FTW82DA372](https://openairdocs.org/ntsb/FTW82DA372.md): Air Tractor AT-400 · Muleshoe, TX · Accident · No injuries · Final report · Sep 9, 1982 · N2369N · Substantial damage > Pilot collided with a water spraying machine while making crop spray pass. Landing gear tore off. - [NTSB ATL82DA265](https://openairdocs.org/ntsb/ATL82DA265.md): Cessna 188B · Gibson, GA · Accident · No injuries · Final report · Sep 7, 1982 · N4877R · Substantial damage > The pilot began a swath run by approaching the field over tall trees. Just beyond the trees was a 7 ft rise in the terrain. The pilot stated that he did not flare soon enough. Reportedly, the plane struck the crop, the gear sheared off and the plane slid to a… - [NTSB SEA82FYP11](https://openairdocs.org/ntsb/SEA82FYP11.md): Hiller UH-12-SOLOY · Kellogg, ID · Accident · Serious injuries · Final report · Sep 6, 1982 · N9035H · Substantial damage > The plt stated he had just released a load of logs & started his transition into forward flt when the eng failed. No usable fuel was on board. The plt stated the fuel gauge registered 50 pounds of fuel when the eng failed. A leak test of the fuel suction… - [NTSB MKC82FCG19](https://openairdocs.org/ntsb/MKC82FCG19.md): Cessna 172N · Lake Of The Oza, MO · Accident · 2 fatal · Final report · Sep 6, 1982 · N6339F · Destroyed > Witnesses reported that the pilot made a low pass at a cove, then flew out over the water, turned and flew back at low altitude. During a second low pass, it struck electrical cables that crossed the cove. After hitting the cables, the aircraft crashed in a… - [NTSB LAX82DA335](https://openairdocs.org/ntsb/LAX82DA335.md): Schempp-Hirth Ventus · California City, CA · Accident · No injuries · Final report · Sep 5, 1982 · N214T · 2 aircraft · Destroyed > The accident occurred during a cross-country glider race involving 41 gliders. Seven or eight gliders were circling in right turns in a thermal at approximately the same altitude when the collision occurred. The plt of the ventus stated his glider became… - [NTSB LAX82DA332](https://openairdocs.org/ntsb/LAX82DA332.md): Varieze Hamlin · Susanville, CA · Accident · 2 fatal · Final report · Sep 4, 1982 · N777EJ · Destroyed > During a 2nd pass down the runway at about 50 feet AGL, the aircraft pulled up to about 200 feet and completed over halfof a roll, then spiraled into a lake and was destroyed. According to witnesses, the engine was running at all times until impact. - [NTSB DEN82DA185](https://openairdocs.org/ntsb/DEN82DA185.md): Piper J-3 C65 · Durango, CO · Accident · Serious injuries · Final report · Sep 4, 1982 · N98872 · Substantial damage > The pilot reported that he took off with the doors latched open, and after lift-off, the aircraft failed to exceed 42 mph. He reported that an altitude of about 150 ft was attained. Due to the lack of performance and fearful of obstructions ahead, the pilot… - [NTSB DEN82DA183](https://openairdocs.org/ntsb/DEN82DA183.md): American AA1 · Opheim, MT · Accident · 1 fatal · Final report · Sep 4, 1982 · N6130L · Destroyed > The pilot tookoff and made a pass over the airport. At about 500 feet the aircraft began to roll and spun to ground impact. Investigation revealed the pilot was apparently maneuvering and wing dipping for his friends on the ground when the stall occurred. - [NTSB LAX82DA330](https://openairdocs.org/ntsb/LAX82DA330.md): Bell 206-L · Lihue, HI · Accident · Serious injuries · Final report · Sep 3, 1982 · N59358 · Destroyed > During a sightseeing trip to the west side of kapalaoa ridge area near punham crater, the pilot experienced a downdraft and then a severe updraft that put him in IFR conditions in the clouds. The helicopter is not equipped for instrument flight and the pilot… - [NTSB CHI82DA336](https://openairdocs.org/ntsb/CHI82DA336.md): Bell 47G-5A · Waconia, MN · Accident · Serious injuries · Final report · Sep 3, 1982 · N58077 · Destroyed > Just prior to the flight, the helicopter had been released by the maintenance section after troubleshooting a squawk concerning a "binding collective." The student and instructor (CFI) departed on a local flight and flew about an hour practicing precision… - [NTSB MIA82AA177](https://openairdocs.org/ntsb/MIA82AA177.md): Piper PA-31-350 · Near Lakeland, FL · Accident · 2 fatal · Final report · Sep 2, 1982 · N62957 · Destroyed > The flt was conducting single-eng flt tests with the inboard gear doors removed & was being photographed by a chase acft. At the end of the tests the plt was unable to restart the left eng & returned for a single-eng landing. The plt overshot the landing… - [NTSB LAX82FA329](https://openairdocs.org/ntsb/LAX82FA329.md): Champion 7EC · Near Isleton, CA · Accident · 2 fatal · Field investigation · Final report · Sep 2, 1982 · N141A · Destroyed > The pilot and passenger were on a local flight to fly to the san joaquin river delta to observe and photograph a break in the river's level, as well as the passenger's boat. A consensus of the witnesses was that the aircraft was circling the area when it… - [NTSB ANC82DA093](https://openairdocs.org/ntsb/ANC82DA093.md): Piper PA-20 · Near Mcgrath, AK · Accident · No injuries · Final report · Sep 2, 1982 · N1510A · Substantial damage > Prior to departure, the pilot serviced the aircraft with fuel and verified the right wing tank was full. The pilot did not switch the fuel selector from the left fuel tank prior to departing. During a low pass over a wooded area, the engine quit. Due to the… - [NTSB LAX82DA326](https://openairdocs.org/ntsb/LAX82DA326.md): Cessna 172M · San Jose, CA · Accident · No injuries · Final report · Sep 1, 1982 · N80301 · Substantial damage > The aircraft was substantially damaged when a landing gear, damaged by a wire strike, collapsed during landing. Witnesses indicated that the aircraft had entered a narrow valley at treetop level. Broken power lines started a grass fire which was eventually… - [NTSB ATL82DA260](https://openairdocs.org/ntsb/ATL82DA260.md): Cessna A188 · Hillsboro, AL · Accident · Minor injuries · Final report · Sep 1, 1982 · N9759V · Destroyed > The pilot reported that while making a swath run to the west over uneven terrain, his right wing contacted the cotton crop that he was spraying. The aircraft crashed and began to burn after coming to rest inverted. The pilot escaped with minor injuries before… - [NTSB ANC82FA079](https://openairdocs.org/ntsb/ANC82FA079.md): Cessna A185F · Clarks Point, AK · Accident · 1 fatal · Field investigation · Final report · Aug 31, 1982 · N3357S · Destroyed > The aircraft was observed flying at low altitude near the shore line of the bay near Clarks Point. At one Point in the flight, which had been erratic since takeoff, the aircraft pulled up into a vertical climb stalled and spun to the water. The pilot was a… - [NTSB SEA82FYA10](https://openairdocs.org/ntsb/SEA82FYA10.md): Piper PA-18-150 · Homedale, ID · Accident · 1 fatal · Final report · Aug 30, 1982 · N54242 · Substantial damage > As the acft made a pass over a field the plt cut the power & slowed the acft into slow flight. The acft then made a steep turn & stalled. - [NTSB LAX82DVG31](https://openairdocs.org/ntsb/LAX82DVG31.md): Lindgren Evans VP-1 · Winters, CA · Accident · Serious injuries · Final report · Aug 30, 1982 · N64552 · Substantial damage > Acft ran out of fuel while plt was practicing stalls. - [NTSB FTW82DA357](https://openairdocs.org/ntsb/FTW82DA357.md): Cessna 152 · College Station, TX · Accident · No injuries · Final report · Aug 30, 1982 · N49452 · Destroyed > After the CFI cut power for a simulated forced landing, the student set up an approach to a road. When power was added at the bottom of the approach the engine accelerated to about 75% power & then decelerated back to idle. On touchdown on the road the left… - [NTSB ATL82DKQ18](https://openairdocs.org/ntsb/ATL82DKQ18.md): Air Tractor 301A · Marks, MS · Accident · Minor injuries · Final report · Aug 30, 1982 · N8823S · Destroyed > Aircraft collided with guy wire while spraying chemicals, aircraft went out of control and crashed. - [NTSB ATL82DA254](https://openairdocs.org/ntsb/ATL82DA254.md): Grumman G164B · Sampson, AL · Accident · No injuries · Final report · Aug 30, 1982 · N6795Q · Destroyed > The aircraft lost power during a swath run, the pilot attempted to lighten the load but the aircraft collided with a tree. When interviewed the pilot stated that the aircraft was sold for salvage. No examination of the engine was possible but he indicated… - [NTSB LAX82FA320](https://openairdocs.org/ntsb/LAX82FA320.md): Cessna 150M · Rancho Santa Fe, CA · Accident · No injuries · Field investigation · Final report · Aug 29, 1982 · N888GS · Substantial damage > As the student was recovering from a slip maneuver at about 1,500 ft power was applied. The eng initially produced about 2500 RPM, then decreased to about 2000 RPM. Application of carburetor heat did not have any effect of the eng RPM.RPM continued to… - [NTSB FTW82DA356](https://openairdocs.org/ntsb/FTW82DA356.md): Cessna T188C · Black, TX · Accident · No injuries · Final report · Aug 28, 1982 · N9646J · Substantial damage > While making a swath run the aircraft collided with an irrigation pipe which extended about 15 feet AGL. The pipe was near farm equipment and blended with the background. After the collision the aircraft made a forced landing in a cotton field. - [NTSB ATL82DA256](https://openairdocs.org/ntsb/ATL82DA256.md): Hughes 269B · Angier, NC · Accident · No injuries · Final report · Aug 28, 1982 · N9374F · Substantial damage > While spaying soy beans, the pilot observed 3 power lines bordering the field, but failed to see a fourth. While on a swath run, the helicopter struck the fourth line with the main and tail rotor blades which resulted in a forced landing. - [NTSB FTW82FRJ17](https://openairdocs.org/ntsb/FTW82FRJ17.md): Bell 206B · Jamestown, LA · Accident · Serious injuries · Final report · Aug 27, 1982 · N5754P · Destroyed > The pilot was conducting aerial burning operations over a wooded area when he heard a loud bang from the engine area of the helicopter. At that time, the helicopter was approximately 20 ft above the tallest tree in the area with the aerial torch burning. The… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=229 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=228 --- 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.