# 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 383 of 718 · 35,889 cases ## Cases, newest first - [NTSB NYC82FFJ15](https://openairdocs.org/ntsb/NYC82FFJ15.md): Na 64 · Cambria, NY · Accident · Serious injuries · Final report · Jun 13, 1982 · N64BT · Destroyed > The pilot reported that after he made a photo fly-by, he began to climb. At about 400 ft AGL, the engine failed and he began a forced landing. During the approach, the tail wheel caught on two electrical wires and the aircraft pancaked onto a paved road, then… - [NTSB LAX82FA219](https://openairdocs.org/ntsb/LAX82FA219.md): Piper PA-28-161 · Yorba Linda, CA · Accident · 4 fatal · Field investigation · Final report · Jun 13, 1982 · N8311Z · Destroyed > Witnesses observed the acft flying low over the riverside freeway with a high RPM eng sound & in a right turn. The acft continued to roll & turn to the right & crashed. - [NTSB ATL82DA162](https://openairdocs.org/ntsb/ATL82DA162.md): Piper PA-28-181 · Savannah, GA · Accident · Serious injuries · Final report · Jun 13, 1982 · N80SA · Destroyed > The pilot obtained a weather briefing and filed a VFR flight plan before takeoff. He was advised that the weather was 6000 ft scattered, 6 miles visibility, possible storms gathering at palatka, FL. After takeoff, he was unable to contact the flight service… - [NTSB ANC82DA046](https://openairdocs.org/ntsb/ANC82DA046.md): Cessna 180 · Seldovia, AK · Accident · Minor injuries · Final report · Jun 13, 1982 · N2949C · Substantial damage > During flight, the pilot noted that oil began to collect on the windscreen. He continued the flight to the destination and landed on runway 16 with an oil covered windscreen and in what he described as "squirrelly winds." The wind was estimated to be from 150… - [NTSB NYC82DA123](https://openairdocs.org/ntsb/NYC82DA123.md): Cessna 172N · Schellsburg, PA · Accident · Minor injuries · Final report · Jun 12, 1982 · N5017E · Destroyed > During a cross-country flight the pilot encountered lowering ceilings and rain. The pilot descended to 2200 feet; however, the weather continued to deteriorate and the pilot elected to climb. The aircraft collided with trees and was destroyed. - [NTSB LAX82DA217](https://openairdocs.org/ntsb/LAX82DA217.md): Luscombe 8A · Delano, CA · Accident · Serious injuries · Final report · Jun 12, 1982 · N2013B · Destroyed > The pilot and his daughter were on a cross-country flight when the engine lost power. During a forced landing approach to a highway, the pilot noticed some powerlines which he went under. He avoided the powerlines, but hit a truck. The crash site was located… - [NTSB NYC82DA122](https://openairdocs.org/ntsb/NYC82DA122.md): Cessna 172 · Monongahela, PA · Accident · No injuries · Final report · Jun 11, 1982 · N608DL · Substantial damage > The pilot was on a flight from rostraver, PA to deerfield, oh and return. Before taking off from rostraver, he estimated there was 25 gal of fuel on board. At deerfield, he estimated there was 15 gallons remaining (12 gal usable). But that he would need only… - [NTSB FTW82DA221](https://openairdocs.org/ntsb/FTW82DA221.md): Cessna 206-5 · Somerville, TX · Accident · No injuries · Final report · Jun 11, 1982 · N40416 · Destroyed > During a cross country flight the pilot switched fuel tanks and the engine quit. The pilot switched back to original setting but could not restart the engine. During the forced landing the aircraft collided with a steel fence. Maintenance personnel stated the… - [NTSB ANC82FAG30](https://openairdocs.org/ntsb/ANC82FAG30.md): Piper PA-18 · Near Dillingham, AK · Accident · 2 fatal · Final report · Jun 8, 1982 · N278T · Destroyed > The acft impacted a side of a mountain Near horseshoe pass at an elevation of 250 ft above sea level. The accident occurred during the hours of daylight with VMC prevailing. - [NTSB SEA82FYM18](https://openairdocs.org/ntsb/SEA82FYM18.md): Mccall KR-2 · Union, OR · Accident · 2 fatal · Final report · Jun 6, 1982 · N54622 · Destroyed > Reportedly, the aircraft departed la grande, OR with 12 gallons of fuel on board and was flown to baker, OR. Later, the pilot departed baker on a return flight to la grande without refueling. Subsequently, the plane was reported as missing. The next day it… - [NTSB CHI82FA211](https://openairdocs.org/ntsb/CHI82FA211.md): Piper PA-30 · Vandalia, OH · Accident · No injuries · Field investigation · Final report · Jun 6, 1982 · N7254Y · Substantial damage > During descent at 215 mph the acft entered violent buffeting. Recovery was initiated by reducing power & the acft landed without any further incident. Examination revealed the horizontal stabilator was permanently bent downward on both sides. The acft was… - [NTSB FTW82DA212](https://openairdocs.org/ntsb/FTW82DA212.md): Cessna 210L · Wichita Falls, TX · Accident · Minor injuries · Final report · Jun 5, 1982 · N5280V · Substantial damage > After climbing to 2500 ft the engine suddenly lost power and quit. The pilot lowered the landing gear and shut down all switches but did not extend the flaps. During the ensuing emergency landing the aircraft nosed over in a wheat field. Engine examination… - [NTSB CHI82DA199](https://openairdocs.org/ntsb/CHI82DA199.md): Enstrom 280 · Rayland, OH · Accident · Serious injuries · Final report · Jun 5, 1982 · N239Q · Destroyed > About three minutes after takeoff, the engine lost power and the helicopter crashed in a wooded area. No preimpact failures of the aircraft or engine were found. - [NTSB LAX82FA208](https://openairdocs.org/ntsb/LAX82FA208.md): Cessna T210N · Humphreys Peak, AZ · Accident · 3 fatal · Field investigation · Final report · Jun 4, 1982 · N4777Y · Destroyed > Te acft impacted Humphreys Peak at 10,200 ft MSL. The last wx observation at grand canyon was at 1745. The reported wwx was a clear sky & 50 mi visibility. - [NTSB ATL82DA152](https://openairdocs.org/ntsb/ATL82DA152.md): Cessna 150 · Red Oak, VA · Accident · Minor injuries · Final report · Jun 4, 1982 · N9373U · Substantial damage > The pilot reported that he was on a local flight when the weather began to deteriorate. He decided to make a precautionary landing in a large bean field. While on a landing approach, the aircraft struck a utility line, wrapping the wire around the propeller… - [NTSB NYC82FFA06](https://openairdocs.org/ntsb/NYC82FFA06.md): Cessna A188B · White Lake, NY · Accident · No injuries · Final report · Jun 3, 1982 · N731BG · Substantial damage > While returning from a spraying operation, the engine began running rough, and within seconds, it lost power. The pilot was unable to restart the engine, and subsequently, ditched the aircraft in a reservior. An engine teardown revealed that the crankshaft… - [NTSB MIA82DA131](https://openairdocs.org/ntsb/MIA82DA131.md): Cessna 182K · Arecibo, PR · Accident · No injuries · Final report · Jun 3, 1982 · N2575Q · Substantial damage > The pilot stated that he had 8 gallons of fuel on board before takeoff. At 0700, he departed on a flight from san juan to aguadilla, PR with an intermediate stop at Arecibo, PR for refueling. At about 0725, the aircraft ran out of fuel, about 3 miles from… - [NTSB FTW82DA211](https://openairdocs.org/ntsb/FTW82DA211.md): Beech D18S · Beeville, TX · Accident · No injuries · Final report · Jun 3, 1982 · N7510 · Substantial damage > The pilot and three passengers departed on a pleasure flight. The pilot stated that after climbing several hundred feet and while at 110 mph, the right propeller went into high pitch following a propeller governor failure. This resulted in a loss of engine… - [NTSB ATL82IA159](https://openairdocs.org/ntsb/ATL82IA159.md): Piper PA-31-325 · Asheboro, NC · Incident · No injuries · Incident investigation · Final report · Jun 2, 1982 · N59749 · Minor damage > During cruise at 5000 ft the pilot smelled electrical fumes and noticed smoke filling the flap indicator gauge. He pulled the wing flap circuit breaker but moments later volumes of smoke arose from under the instrument panel, with flames observed behind the… - [NTSB FTW82DA207](https://openairdocs.org/ntsb/FTW82DA207.md): Cessna 152 · Clarksville, AR · Accident · No injuries · Final report · Jun 1, 1982 · N67650 · Substantial damage > The pilot reported that after landing at ozark, AR, no fuel was available. Therefore, he proceeded to obtain fuel at Clarksville, AR, a distance of about 15 miles. After takeoff, he encountered moderate turbulence, leveled at about 600 ft, and reduced power… - [NTSB CHI82DA198](https://openairdocs.org/ntsb/CHI82DA198.md): Bell 47G-5A · New Philadelphi, OH · Accident · Minor injuries · Final report · Jun 1, 1982 · N2988W · Destroyed > While patrolling a powerline, the pilot heard a loud noise, similar to a gunshot, which seemed to come from directly behind the firewall. Immediately after that, the helicopter started to pitch up and roll to the right. He reported that the helicopter reached… - [NTSB FTW82FA204](https://openairdocs.org/ntsb/FTW82FA204.md): Bell 206B · Fairfield, TX · Accident · 2 fatal · Field investigation · Final report · May 31, 1982 · N1482W · Destroyed > Witnesses observed the helicopter flying northbound while traveling parallel and just east of a north-south highway. Reportedly, it enter an autorotative landing approach, crossed over the highway and impacted in an open field on a westerly heading after… - [NTSB ANC82DAG29](https://openairdocs.org/ntsb/ANC82DAG29.md): Stinson 181 · Talkeetna, AK · Accident · Serious injuries · Final report · May 31, 1982 · N108TM · Substantial damage > The pilot made a forced landing after a spark plug blew out of the engine. During the landing the aircraft collided with a tree. - [NTSB ATL82DA148](https://openairdocs.org/ntsb/ATL82DA148.md): Piper PA-22-150 · Williamston, NC · Accident · No injuries · Final report · May 30, 1982 · N1615P · Destroyed > The pilot stated that while cruising at 11,000 ft the engine started missing and losing power. After repeated attempts to restore power the pilot landed in a field. During roll out the nose wheel became lodged in soft sand and the aircraft turned over. Engine… - [NTSB NYC82FA110](https://openairdocs.org/ntsb/NYC82FA110.md): Douglas DC8-52 · Atlantic Ocean (Atlantic Ocean) · Accident · Serious injuries · Field investigation · Final report · May 29, 1982 · N801EV · No damage > The flt had been airborne about 25 min with the seat belt sign on because of the possibility of turbulence. Two flight attendants were preparing the beverage cart when turbulence was encountered. The acft suddenly dropped downward causing the two attendants… - [NTSB LAX82FA202](https://openairdocs.org/ntsb/LAX82FA202.md): Kaman K600-3 · Lodi, CA · Accident · No injuries · Field investigation · Final report · May 29, 1982 · N87842 · Destroyed > The helicopter started vibrating in flight, and when the pilot was unable to control the aircraft for a normal approach to the airport, he elected to land in a cornfield. The aircraft rolled to the right at touchdown. The right blade flap assembly had… - [NTSB ATL82DA150](https://openairdocs.org/ntsb/ATL82DA150.md): Bell 47D1 · Blountville, TN · Accident · No injuries · Final report · May 29, 1982 · N10065 · Substantial damage > The aircraft lost power at 100 feet above ground level. An autorotation was attempted to a highway. The hard landing resulted in the main rotor severing the tail. - [NTSB ATL82DA146](https://openairdocs.org/ntsb/ATL82DA146.md): Piper PA-38 · Pell City, AL · Accident · No injuries · Final report · May 29, 1982 · N9956T · Substantial damage > The aircraft was being used to return with another pilot after the other pilot had ferried his aircraft from bessember, AL to knoxville,TN. The pilot estimated that he had sufficient fuel to return, and since the FBO was busy, he elected to depart without… - [NTSB LAX82DA198](https://openairdocs.org/ntsb/LAX82DA198.md): Piper PA-24-250 · Apple Valley, CA · Accident · No injuries · Final report · May 28, 1982 · N6503P · Substantial damage > During a flight from saint george, ut to imperial, GA, the pilot encountered fog as he approached el cajon pass, south of Apple Valley, CA. He attempted to go under the fog but was unable. He reversed course and headed back toward Apple Valley. As he was… - [NTSB FTW82IA209](https://openairdocs.org/ntsb/FTW82IA209.md): Piper PA-31P-135 · Lake Charles, LA · Incident · No injuries · Incident investigation · Final report · May 28, 1982 · N222SA · Minor damage > While cruising at FL200 in VMC conditions, the pilot smelled and then observed smoke coming from the windshield defrosters and under the instrument panel. He advised houston center of his situation, then turned off all electrical equipment and made an… - [NTSB CHI82DA189](https://openairdocs.org/ntsb/CHI82DA189.md): Cessna 172 · Evansville, IN · Accident · No injuries · Final report · May 28, 1982 · N2986U · 2 aircraft · Substantial damage > The pilots of two Cessna 172 aircraft, N73616 and N2986U, were flying in formation while on a cross-country flight. N73616 contacted Evansville approach and was cleared to intercept the 030 degree radial, outbound from Evansville, IN. As a turn was made to… - [NTSB FTW82DA194](https://openairdocs.org/ntsb/FTW82DA194.md): Piper PA-28-236 · Clayton, NM · Accident · No injuries · Final report · May 27, 1982 · N8088T · Substantial damage > The pilot reported that during flight, the engine lost power. He tried to land on a nearby airport. However, unexpectedly strong winds were encountered and he made a forced landing in a pastured when he saw he could not reach the airport. During the landing,… - [NTSB DEN82IA098](https://openairdocs.org/ntsb/DEN82IA098.md): Douglas DC-8-61 · Near Goshen, IN · Incident · Minor injuries · Incident investigation · Final report · May 27, 1982 · N8088U · No damage > This aircraft encountered unforecast severe clear air turbulance (cat) while in cruise flight at FL350 Near Goshen, IN. As a result of the encounter, the aircraft entered an uncontrolled descent which was arrested at 31,500 feet. A total of seventeen… - [NTSB ATL82FIG07](https://openairdocs.org/ntsb/ATL82FIG07.md): Grumman G-164A · Frederick, MD · Accident · 1 fatal · Final report · May 27, 1982 · N6620Q · Substantial damage > The pilot reported that 1 to 2 ounces of water was drained from the low point fuel sump, but no water was detected from the other sumps. He stated that he drained the sump until no water was detected. During the flight, the engine surged twice, then lost… - [NTSB ATL82FA144](https://openairdocs.org/ntsb/ATL82FA144.md): Bell 206B · Oakwood, VA · Accident · 3 fatal · Field investigation · Final report · May 27, 1982 · N9986K · Destroyed > The plt was flying railroad officials to inspect rail lines that had been covered by mud slides caused by recent heavy rains. A witness heard the helicopter coming up the valley & then heard two popping sounds. He saw the helicopter falling to the ground near… - [NTSB FTW82DA193](https://openairdocs.org/ntsb/FTW82DA193.md): Pitts Special S-1S · Huntsville, TX · Accident · No injuries · Final report · May 26, 1982 · N166S · Destroyed > The pilot reported that during flight at 1500 ft AGL, there was a violent explosive failure of the engine and black smoke entered the cockpit. He elected to land between cars on an interstate highway. He cleared over one car, but the driver of the next car… - [NTSB CHI82DA187](https://openairdocs.org/ntsb/CHI82DA187.md): Cessna 182 · Cedarville, OH · Accident · No injuries · Final report · May 26, 1982 · N2414G · Substantial damage > The pilot stated that the engine failed while enroute and an emergency landing was made in a corn field. He also reported that the loss of power was due to carburetor icing. The aircraft was substantially damaged and there were no injuries. - [NTSB CHI82DA185](https://openairdocs.org/ntsb/CHI82DA185.md): Hughes 369D · Fairbury, IL · Accident · No injuries · Final report · May 26, 1982 · N8348F · Substantial damage > During flight, the N2 and nr suddenly accelerated to 110 percent. The pilot eventually shut down the engine and made an autorotation. An open field was selected for a landing site; however, it was muddy with standing water. The pilot decided on a full stop… - [NTSB SEA82DA078](https://openairdocs.org/ntsb/SEA82DA078.md): Cessna 140 · Buena Vista, OR · Accident · Minor injuries · Final report · May 23, 1982 · N73056 · Substantial damage > The pilot stated that while looking out the left side window something impacted the windshield causing broken plexiglass to enter the cabin and injure both the pilot and the passenger. He then noticed that the airspeed was low and proceeded to lower the nose… - [NTSB MIA82DA121](https://openairdocs.org/ntsb/MIA82DA121.md): Piper PA-22-108 · Tampa, FL · Accident · No injuries · Final report · May 23, 1982 · N4607Z · Substantial damage > While circling over the area where the pilot resided, a complete loss of power occurred. During the emergency landing the pilot stalled the aircraft while attempting to avoid a collision with an autombile. Both the aircraft and the automobile were… - [NTSB NYC82FA103](https://openairdocs.org/ntsb/NYC82FA103.md): Cessna 150F · Delano, PA · Accident · 2 fatal · Field investigation · Final report · May 22, 1982 · N8244S · Destroyed > The plt received wx briefings at 1111 & 1530 from the detroit, mi fss for a flt to new jersey. The plt was advised during the 1530 briefing that VFR flt was not recommended. The plt departed gross ile, mi at approximately 1700 & landedat williamsport, PA at… - [NTSB FTW82FQG18](https://openairdocs.org/ntsb/FTW82FQG18.md): Cessna T337B · San Angelo, TX · Accident · 1 fatal · Final report · May 22, 1982 · N2349S · Destroyed > At apprx 2015 CDT, the plt called the San Angelo tower and expressed concern that his acft might be damaged by hail from the wx that was bldg in the area, tower psnl relayed available wx info & provided phone numbers for the wx bureau & a local fss. A tornado… - [NTSB FTW82DRD12](https://openairdocs.org/ntsb/FTW82DRD12.md): Grumman 164 · Reeves, LA · Accident · Serious injuries · Final report · May 22, 1982 · N8548H · Destroyed > The aircraft was returning to base after an aerial application of liquid chemical. He stated that there was an odor of chemical and he looked down to check the hopper. When he looked up he was descending into the trees. - [NTSB FTW82DA190](https://openairdocs.org/ntsb/FTW82DA190.md): Bellanca 7GCBC · Mt. Pleasant, TX · Accident · No injuries · Final report · May 22, 1982 · N5045G · Substantial damage > After takeoff from runway 17, the pilot departed the traffic pattern and was about 1.5 miles north of the airport when the engine coughed. He immediately turned back toward the airport, but shortly thereafter, the engine lost all power. He decided to land on… - [NTSB CHI82FA181](https://openairdocs.org/ntsb/CHI82FA181.md): Beech A23 · Northville, MI · Accident · 3 fatal · Field investigation · Final report · May 22, 1982 · N1405L · Destroyed > At 1701 EDT on 5/21/82, the non-instrument rated pilot called a flight service station and requested an IFR weather briefing. The briefing was for a flight from lapeer, Michigan to frankfort, Kentucky. The plane departed the next day at about 1200 EDT with no… - [NTSB ATL82DA142](https://openairdocs.org/ntsb/ATL82DA142.md): Douglas DC-9-15F · Memphis, TN · Accident · Serious injuries · Final report · May 22, 1982 · N9356 · No damage > Before takeoff, the aircrew received weather data that included a forecast for a severe thunderstorm watch. While en route, the captain elected to leave the seat belt sign on for the entire flight. The flight was routine until a descent was started into the… - [NTSB LAX82DA190](https://openairdocs.org/ntsb/LAX82DA190.md): Cessna 172XP · Hilo, HI · Accident · Minor injuries · Final report · May 21, 1982 · N7320K · Substantial damage > The pilot stated that he requested 30 gallons of fuel for an estimated flight time of 3.5 hours. During the flight the engine ran rough and the right tank went to empty. The pilot then switched tanks and about 2 minutes later the pilot stated that the left… - [NTSB CHI82DA180](https://openairdocs.org/ntsb/CHI82DA180.md): Piper PA-28 · Harrisburg, IL · Accident · No injuries · Final report · May 21, 1982 · N2314F · Substantial damage > During a weather briefing, the pilot was advised that there were thunderstorms in the area of his destination at about 1415 CDT, he departed for a two hour flight. After flying over weather most of the way and overflying an airport (hulman regional), he… - [NTSB ATL82FA140](https://openairdocs.org/ntsb/ATL82FA140.md): Cessna T210M · Holly Springs, SC · Accident · 2 fatal · Field investigation · Final report · May 21, 1982 · N761UR · Destroyed > Prior to departing new bern at 1837 the plt called his office & stated he had received a wx report for scattered thunderstorms along his route of flt. At 2020 & 2052 he contacted atl flt watch for wx advisories. He was advised that the wx radar was out of… - [NTSB CHI82DA177](https://openairdocs.org/ntsb/CHI82DA177.md): Blanik L-13 · Warren, MN · Accident · Minor injuries · Final report · May 20, 1982 · N99805 · Substantial damage > The pilot was having difficulty controlling the glider during the tow and released prematurely. The destination was 12 to 14 miles away with 10-15 kt headwinds. When the pilot decided the destination could not be made a road was selected for a forced landing… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=384 ## 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=383 --- 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.