# NTSB investigations: Enroute 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 377 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC83FA005](https://openairdocs.org/ntsb/NYC83FA005.md): Piper PA-28-161 · Sanbornton, NH · Accident · 4 fatal · Field investigation · Final report · Oct 9, 1982 · N9535C · Destroyed > The plt was advised during his wx briefing that VFR flt was not recommended for his proposed route of flt and destination. The plt, whose business concern was in the glens falls area, commuted almost daily to his home in gilford, NH. The wreckage was located… - [NTSB ANC83LA004](https://openairdocs.org/ntsb/ANC83LA004.md): Piper PA-23-250 · Anchorage, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 1982 · N6843A · No damage > Shortly after departure the flt received radar vectors placing it near a VFR reporting point located 4 mi past the departure end of rwy 32 & 2 mi east of the rwy centerline. Traffic advisories were issued by approach control indicating a beoing 747 climbing… - [NTSB DEN83FTC01](https://openairdocs.org/ntsb/DEN83FTC01.md): Grumman American AA-5B · Albin, WY · Accident · 2 fatal · Final report · Oct 8, 1982 · N81262 · Destroyed > The pilot was on personal cross-country. There was no record of a pre-flight or in-flight weather briefing. The weather at the accident site was near blizzard condition. The aircraft was heard circling, but it was not seen due to snow. The winds approached 50… - [NTSB ATL83FID01](https://openairdocs.org/ntsb/ATL83FID01.md): Cessna 172G · Boones Mill, VA · Accident · 1 fatal · Final report · Oct 8, 1982 · N3957L · Substantial damage > The pilot was trying to approach roanoke in weather that obscured the mountain tops. He crashed into a mountain slope at the 2900 foot level. He had contacted roanoke radio but radar contact had not been established. During his weather briefing VFR flight had… - [NTSB ATL83FA009](https://openairdocs.org/ntsb/ATL83FA009.md): Beech 58 · Allendale, SC · Accident · No injuries · Field investigation · Final report · Oct 8, 1982 · N958MC · Substantial damage > About 30 min after departure, electrical equipment began to fail. The plt turned off the alternator & reset with no change. He then switched to the #1 regulator which did not correct the problem. While turning on downwind the gear handle was placed down & all… - [NTSB LAX83FUA01](https://openairdocs.org/ntsb/LAX83FUA01.md): Robinson R22 · Santa Ana, CA · Accident · 1 fatal · Final report · Oct 6, 1982 · N8358B · Destroyed > The commercial plt was rated in fixed wing acft, but in the helicopter, had student privileges only. He had obtained aprx 37 hrs of dual instruction & 3 hrs of solo time in the Robinson R22 helicopter; however, 1.3 hrs of his solo time was limited to hover… - [NTSB FTW83FA009](https://openairdocs.org/ntsb/FTW83FA009.md): Cessna 210L · Hebbronville, TX · Accident · 4 fatal · Field investigation · Final report · Oct 6, 1982 · N732KH · Destroyed > The crew were advised that the acft's vacuum pump system was inoperative due to a sheared pump driveshaft. The copilot had stated that fss had forecast 25,000 ft broken & he did not feel he would need the pump. At 1735 the plt contacted center & requested… - [NTSB ATL83LA005](https://openairdocs.org/ntsb/ATL83LA005.md): Cessna 172N · Albany, GA · Accident · No injuries · Limited investigation · Final report · Oct 6, 1982 · N737LJ · Substantial damage > The pilot of N737LJ departed on a cross-country business trip with less than full fuel tanks. After flying about 2 hours the aircraft engine quit and the pilot made an emergency landing in an open field. The aircraft collided with trees at the edge of the… - [NTSB CHI83LA010](https://openairdocs.org/ntsb/CHI83LA010.md): Benson B8M · Sandwich, IL · Accident · No injuries · Limited investigation · Final report · Oct 5, 1982 · N26063 · Destroyed > The aircraft was being flown by a person with no pilot rating and no student or medical certificate. After takeoff, he circled the airport and flew over the edge of a lake. Reportedly, the engine suddenly lost power while he was about 300 ft above the… - [NTSB ATL83FA003](https://openairdocs.org/ntsb/ATL83FA003.md): Piper PA-31-310 · Dyersburg, TN · Accident · Minor injuries · Field investigation · Final report · Oct 4, 1982 · N1ET · Substantial damage > At 30 mi north of the destination, the inboard side of the right eng cowl popped loose & began vibrating severely, the plt was concerned that the cowling would break loose & strike the vert of horiz stabilizer so he feathered the r eng. Atthis point, the arpt… - [NTSB LAX83LA005](https://openairdocs.org/ntsb/LAX83LA005.md): Beech A36 · Rialto, CA · Accident · No injuries · Limited investigation · Final report · Oct 3, 1982 · N4603A · Substantial damage > While cruising at 9500 ft MSL, the engine began running rough. The pilot diverted to Rialto municipal airport for a precautionary landing. While on base leg, the engine quit completely. From that position, the pilot was unable to reach the runway. The… - [NTSB DEN83LTI01](https://openairdocs.org/ntsb/DEN83LTI01.md): Scorpion 133 · Manhattan, MT · Accident · No injuries · Final report · Oct 3, 1982 · N133RW · Substantial damage > Battery failed because it had not been charged. No on board charging provision. Electric pump could not operate without electricity. No fuel to engine. During an autorotative landing, the tail rotor was damaged. With no tail rotor control, the helicopter slid… - [NTSB CHI83LA004](https://openairdocs.org/ntsb/CHI83LA004.md): Cessna 182 · Shenandoah, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 3, 1982 · N5445B · Substantial damage > Jumper's parachute open prematurely pulling jumper into tail section bending horizontal stabilizer which in turn jammed the rudder. Plt could not flare acft during subsequent landing collapsing the main gear. - [NTSB ATL83LA002](https://openairdocs.org/ntsb/ATL83LA002.md): Grumman AA-5B · Denver, NC · Accident · No injuries · Limited investigation · Final report · Oct 3, 1982 · N28820 · Substantial damage > While cruising at 3500 ft MSL, the pilot heard a loud noise (like an explosion) and saw the engine cowling come open. Simultaneously, the engine lost power and would not respond to throttle movement. During a forced landing in a pasture, the aircraft collided… - [NTSB MIA83LA008](https://openairdocs.org/ntsb/MIA83LA008.md): Beech B24R · Near Great Inag, Bahamas · Accident · Serious injuries · Limited investigation · Final report · Oct 1, 1982 · N300RF · Destroyed > The pilot reported that the engine lost power on a flight from montego bay, jamaica to Great inagua, Bahamas. He ditched in the atlantic ocean and was seriously injured. The aircraft sank in the water and was not recovered. - [NTSB FTW82DA404](https://openairdocs.org/ntsb/FTW82DA404.md): Cessna 182A · New Braunfels, TX · Accident · No injuries · Final report · Oct 1, 1982 · N3755D · Destroyed > The plt rerouted due to deteriorating wx & when in the vicinity of san antonio elected to land at san antonio. The plt contacted approach control at 2252 & reported 18 mi east for landing. The acft struck trees 5 mi nw of New Braunfels. - [NTSB MIA82DA189](https://openairdocs.org/ntsb/MIA82DA189.md): Piper PA-28-140 · Miami, FL · Accident · Minor injuries · Final report · Sep 30, 1982 · N921C · Substantial damage > Engine quit while cruising and a forced landing was made in a swamp. #3 cyl exhaust valve head failed. A section of the failed valve head travelled through the induction system into the #2 cylinder damaging both spark plugs rendering the cylinder inoperative. - [NTSB LAX82DA363](https://openairdocs.org/ntsb/LAX82DA363.md): Beech 76 · Big Sur, CA · Accident · No injuries · Final report · Sep 30, 1982 · N6718X · Substantial damage > Reportedly, a small flock of birds were encountered while cruising at 8000 ft MSL. One or more of the birds struck the cowling and windshield which resulted in a hole in the top right side of the windshield. The pilot diverted and landed at monterey, CA… - [NTSB FTW82IA401](https://openairdocs.org/ntsb/FTW82IA401.md): Bell 214ST · Intracoastal Ci, LA · Incident · No injuries · Incident investigation · Final report · Sep 30, 1982 · N2091E · Minor damage > During cruise flight, the crew heard a loud "bang" and felt a vibration in the aircraft. The flight was continued to its destination which was about 20 miles away and terminated without further incident. Investigation revealed that the left upper longeron… - [NTSB FTW82FQA27](https://openairdocs.org/ntsb/FTW82FQA27.md): Cessna 177B · Guadalupita, NM · Accident · 2 fatal · Final report · Sep 30, 1982 · N1477C · Destroyed > Pilot on cross-country impacted the side of a 11,055 foot mountain at the 10,800 foot level. The mountains were obscured at the time. - [NTSB FTW82DA403](https://openairdocs.org/ntsb/FTW82DA403.md): Cessna T210N · Midland, TX · Accident · No injuries · Final report · Sep 30, 1982 · N4774Y · Substantial damage > Pilot landed gear up on airport after engine quit due to failure to position fuel tank selector. Right fuel tank was empty. Left fuel tank had fuel. - [NTSB ANC82DAA21](https://openairdocs.org/ntsb/ANC82DAA21.md): Bellanca 17-30 · Tok, AK · Accident · No injuries · Final report · Sep 30, 1982 · N4037B · Substantial damage > The aircraft was on a low altitude VFR flight to nortway, AK. The pilot had just reversed course due to adverse weather when his auxiliary fuel tank ran dry. He switched to a main fuel tank which had fuel and turned the boost pump on, but the engine failed to… - [NTSB FTW82DA399](https://openairdocs.org/ntsb/FTW82DA399.md): Cessna 150K · Tomball, TX · Accident · No injuries · Final report · Sep 29, 1982 · N6229G · Substantial damage > A student pilot preparing to land pulled the mixture control instead of the carburetor heat control. The engine quit and the pilot started to land on a road. But had to take evasive action to avoid collision with a car. The right wing collided with a bush and… - [NTSB ANC82FA102](https://openairdocs.org/ntsb/ANC82FA102.md): Cessna 172 · Near Kotzebue, AK · Accident · Minor injuries · Field investigation · Final report · Sep 29, 1982 · N7650G · Substantial damage > The aircraft was landed in the tundra following a power loss returning from a search mission. The lost person was a friend of the pilot of this accident aircraft. Possibly because of this the pilot searched longer than necessary and ran out of fuel on the way… - [NTSB LAX82FVW04](https://openairdocs.org/ntsb/LAX82FVW04.md): Piper PA-23-250 · Panaca, NV · Accident · Serious injuries · Final report · Sep 27, 1982 · N14168 · Substantial damage > The plt encountered thunderstorm activity at 1900. The left fuel gauge was inop & he had no communication equipment. There was only one nav receiver operative, no instrument lights or slaved dg available. As it became darker he was unable to see the… - [NTSB LAX82FA364](https://openairdocs.org/ntsb/LAX82FA364.md): Mooney M-20K · Mammoth Lakes, CA · Accident · 1 fatal · Field investigation · Final report · Sep 27, 1982 · N4024H · Destroyed > The plt called Mammoth UNICOM & advised he was 10 mi out for landing. He was advised that he should use rwy 27. The acftcrashed into a lake about 6 mi east of the arpt. Toxicological tests revealed a cocaine level of 40.0 mcg/ml in the plt's urine. - [NTSB CHI82DA367](https://openairdocs.org/ntsb/CHI82DA367.md): Cessna 207 · Bedford Park, IL · Accident · No injuries · Final report · Sep 27, 1982 · N1728U · Substantial damage > Pilot made forced landing at night in railroad yard. Engine had loose fuel line. - [NTSB ATL82FLG15](https://openairdocs.org/ntsb/ATL82FLG15.md): Piper PA-28-140 · Near Lockhart, SC · Accident · Serious injuries · Final report · Sep 27, 1982 · N95451 · Substantial damage > The aircraft was flown from charlotte, NC to daytona beach, FL, to sanford, FL without en route refueling. The pilot had previously planned to get fuel at sanford, but after landing there, he thought there sufficient fuel to return to charlotte. However, as… - [NTSB ANC82DA100](https://openairdocs.org/ntsb/ANC82DA100.md): Beech C45H · Near Deering, AK · Accident · No injuries · Final report · Sep 27, 1982 · N3120G > The aircraft slid wheels up into a lake during a one-engine forced landing. The aircraft sank and was not recovered but all the occupants were able to reach shore uninjured. The pilot said the left engine lost power during cruise and he elected to shut it… - [NTSB ANC82DA099](https://openairdocs.org/ntsb/ANC82DA099.md): Piper PA-12 · Nr. White Mount, AK · Accident · No injuries · Final report · Sep 27, 1982 · N7765H · Substantial damage > The aircraft collided with the tundra during a forced landing in marginal weather. The pilot said the engine continued to lose engine RPM even though he used carburetor heat. The carburetor heat hose was found to be badly deteriorated during post accident… - [NTSB NYC82FA237](https://openairdocs.org/ntsb/NYC82FA237.md): Piper PA-32-R-300 · Berkeley Spring, WV · Accident · 5 fatal · Field investigation · Final report · Sep 26, 1982 · N8690E · Destroyed > While en route, the aircraft collided with the side of a mountain during level flight at about 2000 ft MSL. The impact occurred where the terrain sloped upward at about a 45 deg angle. Prior to takeoff, the pilot was advised of marginal VFR conditions and… - [NTSB NYC82FA236](https://openairdocs.org/ntsb/NYC82FA236.md): Cessna 172H · Normalville, PA · Accident · 4 fatal · Field investigation · Final report · Sep 26, 1982 · N8285L · Destroyed > During the wx briefing the plt was advised of marginal VMC with high overcasts but reduced visibilities in light rain & fog, with radar depiciting an area of showers moving into the pittsburg area from the carolinas. Witnesses near the crash site stated the… - [NTSB MIA82FLA07](https://openairdocs.org/ntsb/MIA82FLA07.md): Cessna 172N · Oak Hill, FL · Accident · Serious injuries · Final report · Sep 26, 1982 · N8091E · Destroyed > The aircraft collided with trees while flying in fog and rain on a dark night. This occurred shortly after the non-instrument rated pilot canceled his VFR flight plan. Neither the pilot nor the passenger could remember the details of the crash. The pilot… - [NTSB LAX82FVG34](https://openairdocs.org/ntsb/LAX82FVG34.md): Cessna 210 · Placerville, CA · Accident · Serious injuries · Final report · Sep 26, 1982 · N9620T · Substantial damage > Pilot states he was descending from 10,000 feet to 8,000 feet when engine quit. Further stated fuel was above red arc-no steep or sharp maneuvers. No mention of rate of descent or deck angle in descent. Forced landing was made circling to right-useable fuel… - [NTSB LAX82FA361](https://openairdocs.org/ntsb/LAX82FA361.md): Great Lakes 2T-1A-2 · Arcata, CA · Accident · 1 fatal · Field investigation · Final report · Sep 26, 1982 · N353GL · Destroyed > The plt & pax were on a cross-country from somewhere in the klamath, CA area to hayward, CA. Witnesses observed it flying southbound at 50 to 100 ft over the ocean's shore line. Reportedly, the acft made a sharp left turn toward land, then crashed on a… - [NTSB LAX82FA357](https://openairdocs.org/ntsb/LAX82FA357.md): Aero Commander 520 · Agoura, CA · Accident · 3 fatal · Field investigation · Final report · Sep 26, 1982 · N2622B · Destroyed > During departure, the pilot climbed in IFR conditions to 600O ft. after leveling, a frequency change was made and he was cleared to 8000 ft, which he acknowledged. About 2 min later, the controller radioed to the pilot that he was about 4 mi north of the… - [NTSB FTW82DA397](https://openairdocs.org/ntsb/FTW82DA397.md): Saville Hummer Falcon AA-1A · Los Lunas, NM · Accident · No injuries · Final report · Sep 26, 1982 · N33FN · Substantial damage > The student pilot was flying a home built, ultralight aircraft which had been issued an airworthiness certificate. The aircraft was about 1100 ft AGL when the engine lost power. During a forced landing, the aircraft struck a fence and flipped over. An… - [NTSB ATL82FA285](https://openairdocs.org/ntsb/ATL82FA285.md): Robinson R-22 · Nashville, TN · Accident · 2 fatal · Field investigation · Final report · Sep 25, 1982 · N9072V · Destroyed > Witnesses reported that the helicopter was in cruise flight between 100 and 500 feet AGL at a high speed when slapping and cracking sounds were heard, followed by the in-flight breakup of the helicopter. The wreckage was scattered over 700 ft with the… - [NTSB MKC82DA175](https://openairdocs.org/ntsb/MKC82DA175.md): Pitts SC 1 · Topeka, KS · Accident · Minor injuries · Final report · Sep 24, 1982 · N1021K · Substantial damage > The aircraft engine quit near the airport, but a forced landing was made in a grassy field. The fuel system was empty. - [NTSB FTW82DA396](https://openairdocs.org/ntsb/FTW82DA396.md): Cessna 152II · Palacios, TX · Accident · No injuries · Final report · Sep 24, 1982 · N47973 · Substantial damage > The aircraft collided with a large black bird (species unknown) while flying at 300 to 500 feet MSL. Impact occurred near the outboard end of the right wing. Immediately after the collision the pilot made a successful precautionary landing. - [NTSB LAX82FUG17](https://openairdocs.org/ntsb/LAX82FUG17.md): Piper PA-32R-301T · San Gorgonio, CA · Accident · 1 fatal · Final report · Sep 23, 1982 · N8214L · Destroyed > The acft crashed into the south face of mount San Gorgonio at approximately 8,300 ft MSL. It appeared the acft was in level flt & at a high speed at impact. Witnesses in the area reported the weather was VFR. - [NTSB ATL82DA284](https://openairdocs.org/ntsb/ATL82DA284.md): Piper PA-31 · London, KY · Accident · No injuries · Final report · Sep 23, 1982 · N30MW · Substantial damage > The aircraft was on a flight from palm beach, FL to London, KY. Five miles short of runway 23 at London, both engines quit and the aircraft made a forced landing. Post crash examination revealed less than one gallon of fuel on board. - [NTSB SEA82IA170](https://openairdocs.org/ntsb/SEA82IA170.md): Cessna 177RG · Cashmere, WA · Incident · No injuries · Incident investigation · Final report · Sep 22, 1982 · N52716 · No damage > While descending through 7500 ft the pilot observed smoke entering the cockpit from the instrument panel area. An attempt was made to isolate the source by shutting off various electrical components. The smoke continued to appear intermittently before the… - [NTSB FTW82DA392](https://openairdocs.org/ntsb/FTW82DA392.md): Cessna 152 · Parks, LA · Accident · No injuries · Final report · Sep 22, 1982 · N212GS · Substantial damage > The pilot stated that the aircraft ran out of fuel. The fuel gauges were still registering 1/4 full on both tanks when the engine quit. In addition the pilot stated, "if I had dipped the tanks on preflight I would have known exactly how much fuel was in the… - [NTSB ANC82DAA20](https://openairdocs.org/ntsb/ANC82DAA20.md): Piper J3 · Near Nome, AK · Accident · 1 fatal · Final report · Sep 22, 1982 · N3257N · Destroyed > The pilot was flying home from a hunting trip. The weather was low ceiling and visibility was marginal in some of the valleys. The aircraft impacted at the 1300 foot level on a 30 degree incline of a rocky slope. The aircraft bounced backfour feet on impact… - [NTSB SEA82DA169](https://openairdocs.org/ntsb/SEA82DA169.md): Mooney M20E · Government Camp, OR · Accident · Minor injuries · Final report · Sep 21, 1982 · N9605V · Substantial damage > The pilot stated that the engine power became intermittent during cruise flight. A force landing was attempted on a highway. Upon touchdown, the aircraft skidded off the road and over an embankment. The state police arrived at the accident site shortly after… - [NTSB LAX82FA347](https://openairdocs.org/ntsb/LAX82FA347.md): Piper PA-28RT-201T · Malibu, CA · Accident · No injuries · Field investigation · Final report · Sep 21, 1982 · N8094F · Substantial damage > The eng seized approximately 3500 ft & the acft was ditched off the beach. The right mag distributor block showed evidence of carbon tracking & cross firing. Neither end of the right mag had breather plugs installed. All spark plugs were excessively fouled &… - [NTSB DEN82FTM17](https://openairdocs.org/ntsb/DEN82FTM17.md): Cessna 182 · Salina, UT · Accident · 2 fatal · Final report · Sep 21, 1982 · N21322 · Destroyed > One of the survivors stated they were flying across the face of a mountain & started a left turn up the mountain. As they made the turn they realized they were too low. When they started their turn to fly over the hill they were expecting the terrain to be… - [NTSB ANC82IA095](https://openairdocs.org/ntsb/ANC82IA095.md): Cessna C-207 · Near Dillingham, AK · Incident · No injuries · Incident investigation · Final report · Sep 21, 1982 · N7394U · Minor damage > Shortly after takeoff, the aircraft experienced a power failure. The pilot stated that when the power loss occurred he switched the fuel selector from the left tank to the right tank and selected "max hi-on" on the fuel boost pump. His attempts to restart the… - [NTSB ANC82FA094](https://openairdocs.org/ntsb/ANC82FA094.md): Cessna U206 G · Near Kotzebue, AK · Accident · 4 fatal · Field investigation · Final report · Sep 21, 1982 · N5331X > Aircraft engine lost power over water of hotham inlet on an air taxi flight. Due to low altitude pilot had to ditch the aircraft. Aircraft sank almost immediately. Because of pilot's radio call two passengers were rescued. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=378 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=377 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.