# 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 387 of 718 · 35,889 cases ## Cases, newest first - [NTSB MIA82FA079](https://openairdocs.org/ntsb/MIA82FA079.md): Benson B-8M · Minneola, FL · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1982 · N25PH · Destroyed > Witnesses heard an engine sputter and looked up to see the gyrocopter descending vertically into a nearby wooded area while the nose of the aircraft was pointed almost straight down. Investigation revealed that the pilot did not possess any aeronautical… - [NTSB LAX82FVG17](https://openairdocs.org/ntsb/LAX82FVG17.md): Cessna 182 · Folsom, CA · Accident · Serious injuries · Final report · Mar 20, 1982 · N3910D · Destroyed > The pilot visually checked the fuel before takeoff and was aware that the tanks were not full. He reported that he would only use 80/87 octane fuel because the engine was not equipped with valves that would accept 100 octane fuel. During the flight, he… - [NTSB LAX82DVG16](https://openairdocs.org/ntsb/LAX82DVG16.md): Piper PA-38 · Fall River Mill, CA · Accident · Minor injuries · Final report · Mar 20, 1982 · N2374P · Destroyed > The pilot elected to return to his departure airport when the aircraft would not climb. The aircraft continued to loose altitude after a 180 degree turn, the aircraft crashed into trees. Examination of the aircraft engine did not reveal any preimpact failure… - [NTSB FTW82DA099](https://openairdocs.org/ntsb/FTW82DA099.md): Airmate HP-10 · El Paso, TX · Accident · Minor injuries · Final report · Mar 20, 1982 · N6511D · Substantial damage > On the first flight since purchase of the aircraft, the pilot stated that he was released from the tow at 1700 ft AGL and climbed in a thermal to 2000 ft AGL where he allowed the aircraft to stall and spin. The pilot stated that he had difficulty in… - [NTSB ATL82FA080](https://openairdocs.org/ntsb/ATL82FA080.md): Cessna 172N · Francisco, NC · Accident · 1 fatal · Field investigation · Final report · Mar 20, 1982 · N738QS · Destroyed > The non-instrument rated pilot received a partial weather briefing by telephone, but hung up when he obtained the information that he requested. FBO personnel stated that he looked and acted tired before taking off at 0022 EST. Subsequently, the plane was… - [NTSB ATL82DA078](https://openairdocs.org/ntsb/ATL82DA078.md): Mooney M20E · Alexandria, KY · Accident · Minor injuries · Final report · Mar 20, 1982 · N5526Q · Substantial damage > The pilot reported that he had monitored the refueling operation, but did not actually uncap and check the fuel himself. He calculated that he had five hours of fuel on board. However, he ran out of fuel after using the right fuel tank for two hours and 30… - [NTSB LAX82FA111](https://openairdocs.org/ntsb/LAX82FA111.md): Cessna 401 · Sunflower, AZ · Accident · 5 fatal · Field investigation · Final report · Mar 18, 1982 · N499W · Destroyed > At 1027 the plt received a wx briefing for holbrook, AZ. The plt was told of forecasts for "at least moderate icing in clouds or in precipitation above the freezing level" & the briefer stated "I guarantee you moderate to severe turbulence..." For a route… - [NTSB LAX82FA110](https://openairdocs.org/ntsb/LAX82FA110.md): Mooney M20K · Alpine, CA · Accident · 1 fatal · Field investigation · Final report · Mar 18, 1982 · N231AM · Destroyed > After being cleared from 8000 feet down to 6000 feet the air traffic controller realized that the aircraft was in trouble when the mode c altitude indicated 3600 feet. He received no understandable response from the pilot when asked about altitude or heading.… - [NTSB NYC82DA057](https://openairdocs.org/ntsb/NYC82DA057.md): Piper PA-28RT-201 · Avoca, PA · Accident · No injuries · Final report · Mar 17, 1982 · N2962W · Substantial damage > The pilot encountered icing conditions while descending from 5000 to 4000 ft near his destination. He was cleared for an immediate ILS approach. He maintained 110 knots on final approach until inside the middle marker. At that point, he applied one notch of… - [NTSB LAX82FA109](https://openairdocs.org/ntsb/LAX82FA109.md): Cessna 340A · 12 N.E. Burbank, CA · Accident · 3 fatal · Field investigation · Final report · Mar 17, 1982 · N98546 · Destroyed > After takeoff, the pilot was cleared to proceed on an IFR flight plan. After being cleared to 15,000 ft MSL, he reported having trouble maintaining his airspeed and subsequently declared an emergency. Shortly after that, radar contact was lost. The aircraft… - [NTSB FTW82FPJ14](https://openairdocs.org/ntsb/FTW82FPJ14.md): Cessna 172N · Hulen, OK · Accident · 1 fatal · Final report · Mar 17, 1982 · N5608J · Destroyed > The pilot departed lawton, Oklahoma at 0902 local time on a flight to inspect mineral property. At about 0931, the pilot contacted ft. sill approach control and requested vectors to lawton. He was instructed to fly a heading of 320 degrees. After flying that… - [NTSB FTW82DA096](https://openairdocs.org/ntsb/FTW82DA096.md): Piper PA-38-112 · Farmington, NM · Accident · Minor injuries · Final report · Mar 17, 1982 · N91317 · Substantial damage > The aircraft lost power during a cross country flight. During the subsequent forced landing on a dirt road the aircraft collided with a ditch and nosed over. - [NTSB ATL82FA072](https://openairdocs.org/ntsb/ATL82FA072.md): Cessna 150 · Tilghman Island, MD · Accident · 1 fatal · Field investigation · Final report · Mar 17, 1982 · N10914 · Destroyed > The student pilot/owner of the aircraft was endorsed to fly the plane and would fly it from his farm on Tilghman Island to easton, MD for dual instruction. Several days before the accident, he had asked his instructor (ip) to schedule some time for an early… - [NTSB MIA82DA074](https://openairdocs.org/ntsb/MIA82DA074.md): Cessna T210M · Miami, FL · Accident · No injuries · Final report · Mar 16, 1982 · N761NJ · Substantial damage > The pilot experienced a loss of electrical power on a VFR flight. Upon arrival in the Miami area he was unable to extend the main gear and landed gear up. - [NTSB LAX82FUJ32](https://openairdocs.org/ntsb/LAX82FUJ32.md): Beech 58 · Tucson, AZ · Accident · 1 fatal · Final report · Mar 16, 1982 · N184VB · Destroyed > The plt departed phoenix at 0045 for the third leg of a six leg bank run between phoenix & Tucson intl arpt. He was in contact with the phoenix TRACON during departure & was released at the toltec intersection (V16) at 5,500 ft. there was no further radio… - [NTSB ANC82DA027](https://openairdocs.org/ntsb/ANC82DA027.md): Bell 206 L-1 · Delta Junction, AK · Accident · Minor injuries · Final report · Mar 16, 1982 · N1069S · Substantial damage > While flying at approximately 300 feet AGL in windy turbulent conditions over snow covered terrain,the helicopter impacted the frozen river. At the time of the accident the pilot was changing radio frequencies when impact occurred. - [NTSB LAX82FXQ06](https://openairdocs.org/ntsb/LAX82FXQ06.md): Cessna 182 · Lake Tahoe, CA · Accident · 2 fatal · Final report · Mar 15, 1982 · N5298N · Destroyed > A pilot who landed prior to the departure of N5298N stated that his aircraft had accumulated 1/4 inch of airframe ice while over the lta VOR. An employee of Lake Tahoe aviation fueling service informed the pilot of N5298N of these weather conditions and ice… - [NTSB FTW82DA093](https://openairdocs.org/ntsb/FTW82DA093.md): Beech C-45H · Mcallen, TX · Accident · 1 fatal · Final report · Mar 15, 1982 · N9846Z · Destroyed > About 18 minutes after takeoff, the pilot radioed that the no. 2 engine had lost power and that he was returning to land at Mcallen, TX. While approaching to land, the aircraft crashed in an open field about 400 yards short of the runway and 115 feet right of… - [NTSB DEN82DA044](https://openairdocs.org/ntsb/DEN82DA044.md): Piper PA-31P · Gunnison, CO · Accident · No injuries · Final report · Mar 15, 1982 · N12JP · Substantial damage > While enroute to addison, TX, the pilot noticed a fluctuation in the engine exhaust gas temperature gauge, followed by the tachometer dropping to zero. The pilot also observed smoke emanating from the engine nacelle and proceeded to secure the engine and… - [NTSB CHI82DA090](https://openairdocs.org/ntsb/CHI82DA090.md): Cessna 182 · Bremen Township, MN · Accident · No injuries · Final report · Mar 15, 1982 · N5643B · Substantial damage > During a VFR flight, the pilot encountered deteriorating weather and elected to make a precautionary landing on a snow covered, cultivated field. The pilot reported that during a soft field approach for landing, the aircraft flipped over when it contacted the… - [NTSB LAX82FXQ05](https://openairdocs.org/ntsb/LAX82FXQ05.md): Piper PA-28R-201 · Elko, NV · Accident · Minor injuries · Final report · Mar 14, 1982 · N2105M · Destroyed > The pilot stated that the engine quit producing power and the plane crashed in mountainous terrain. A teardown of the engine revealed no preimpact failure. The initial impact occurred with a tree at an elevation of about 7000 ft MSL. A piece of the right wing… - [NTSB ATL82DA070](https://openairdocs.org/ntsb/ATL82DA070.md): Cessna 152 · Lusby, MD · Accident · Minor injuries · Final report · Mar 14, 1982 · N159TC · Substantial damage > The student was on a cross-country flight from leonardtown, MD to cumberland, MD to lancaster, pa and then return to leonardtown. Before takeoff, the student was instructed to refuel at cumberland or lancaster before continuing. The student stated that he had… - [NTSB MIA82FLD17](https://openairdocs.org/ntsb/MIA82FLD17.md): Crook M-1 · Tarpon Springs, FL · Accident · Serious injuries · Final report · Mar 13, 1982 · N8534Y · Destroyed > The pilot reported that when he first tried to start the engine before takeoff, there was a lack of ignition and it would not start. He found moisture in the distributor cap, dried it out, cleaned the points, and then the engine started normally. Before… - [NTSB LAX82FUG08](https://openairdocs.org/ntsb/LAX82FUG08.md): Cessna 210G · Etiwanda, CA · Accident · 2 fatal · Final report · Mar 13, 1982 · N5870F · Destroyed > The aircraft struck a ridge at an elevation of about 2000 ft MSL. At the impact point, the terrain sloped upward at an angle of about 35 degrees. The aircraft impacted in a near level flight attitude. The weather at the crash site was not determined. However,… - [NTSB LAX82FUG07](https://openairdocs.org/ntsb/LAX82FUG07.md): Cessna 182 · Blythe, CA · Accident · Minor injuries · Final report · Mar 13, 1982 · N21409 · Substantial damage > The engine lost power at night while the aircraft was en route at about 18,000 ft MSL. The pilot was unable to restart the engine. While trying to start the engine, he noted that the carburetor heat would not go full on or full off. The pilot asked for… - [NTSB CHI82DA084](https://openairdocs.org/ntsb/CHI82DA084.md): Piper PA-28 · Cambridge, MN · Accident · Serious injuries · Final report · Mar 13, 1982 · N9697J · Substantial damage > The pilot had expected that strong headwinds would decrease during flight; however, they continued. The pilot made an enroute stop for fuel, but after landing, he found that the airport was deserted. He stated that he recalculated the elapsed time, etc, and… - [NTSB ATL82DA068](https://openairdocs.org/ntsb/ATL82DA068.md): Cessna 172N · Chamblee, GA · Accident · No injuries · Final report · Mar 13, 1982 · N44ER · Substantial damage > The engine lost power as the aircraft approached the destination airport. The pilot was unable to start the engine or glide to the airport. While attempting to land on a road, the pilot was able to avoid electrical wires; however, the right wing struck a pole… - [NTSB NYC82IA051](https://openairdocs.org/ntsb/NYC82IA051.md): Nord 262A-12 · Flushing, NY · Incident · No injuries · Incident investigation · Final report · Mar 11, 1982 · N26210 · Minor damage > While climbing through 7000 ft, the aircraft began to shake violently. The first officer confirmed that the source of vibration was the right engine. An unsuccessful attempt was made to feather the prop after the rt engine was shut down. The aircraft… - [NTSB FTW82FPM11](https://openairdocs.org/ntsb/FTW82FPM11.md): Cessna 172 · Heavener, OK · Accident · 2 fatal · Final report · Mar 10, 1982 · N739MG · Destroyed > The aircraft crashed at night on rising terrain about 300 ft below the crest of a hill. The nearest weather reporting station was at mcalester, OK. The weather at mcalester was 1200 ft overcast, visibility 7 miles, ceiling ragged. The mcalester field… - [NTSB CHI82DA080](https://openairdocs.org/ntsb/CHI82DA080.md): Cessna 150 · Charlestown, IN · Accident · No injuries · Final report · Mar 9, 1982 · N66252 · Substantial damage > The pilot reported that he ran out of fuel on a cross-country flight. He made an emergency landing in an open field at night. During the landing, the plane flipped over on its back. - [NTSB ATL82FKG09](https://openairdocs.org/ntsb/ATL82FKG09.md): Cessna 210D · Near Commerce, GA · Accident · 1 fatal · Final report · Mar 9, 1982 · N3909Y · Substantial damage > The owner had flown a PA-23 from charlotte to jackson county,FL with another plt following him in N3909Y. The owner stated the other plt was very meticulous & always drained fuel prior to flt. After the 1 hr flt to jackson county, they both looked over the… - [NTSB NYC82DA046](https://openairdocs.org/ntsb/NYC82DA046.md): Cessna T188C · Block Island, RI · Accident · No injuries · Final report · Mar 8, 1982 · N9374J · Destroyed > While on a ferry flight approaching the nantucket VOR the pilot stated that the engine began to run rough. The aircraft was turned back towards Block Island at which time the fuel pressure began to fluctuate and decrease along with the manifold pressure. The… - [NTSB MIA82IA066](https://openairdocs.org/ntsb/MIA82IA066.md): Piper PA-28-140 · Near Melbourne, FL · Incident · No injuries · Incident investigation · Final report · Mar 8, 1982 · N3505Q · Minor damage > The aircraft had been in the practice area southwest of Melbourne, FL doing commercial flight check maneuvers for about 1 hour. According to the pilot, after completing his maneuvers he circled a lake once at 1000' AGL and then headed toward Melbourne. As he… - [NTSB LAX82FUQ10](https://openairdocs.org/ntsb/LAX82FUQ10.md): Piper PA-28R-180 · Captinteria, CA · Accident · Serious injuries · Final report · Mar 8, 1982 · N7497J · Destroyed > The pilot reported that he had some head congestion and had experienced ear discomfort on the first leg of the flight. He elected to fly the second leg of the flight in a canyon that he thought would allow passage through the mountains at low altitude.… - [NTSB DEN82FTI11](https://openairdocs.org/ntsb/DEN82FTI11.md): Cessna TR182 · Livingstone, MT · Accident · 1 fatal · Final report · Mar 8, 1982 · N4681T · Destroyed > The plane crashed about six miles west of livingston, Montana. It was found to have struck about 50 ft below a 5300 ft ridge, while in a 20 degree climb attitude. The weather at livingston was: 900 ft broken, 2500 ft overcast, visibility 10 miles, wind… - [NTSB LAX82DA099](https://openairdocs.org/ntsb/LAX82DA099.md): Cessna 182 · Woodland, CA · Accident · No injuries · Final report · Mar 7, 1982 · N3427U · Substantial damage > A climb was made to 10,000 ft on a skydiving flight. The pilot reported that after descending to 2000 ft, the engine began to lose power and run rough. He elected to make an off-airport landing in a field. Near the end of the landing roll, the nose gear sank… - [NTSB LAX82DA095](https://openairdocs.org/ntsb/LAX82DA095.md): Cessna 172N · Mammoth, AZ · Accident · No injuries · Final report · Mar 7, 1982 · N734GH · Substantial damage > The pilot was on a solo cross-country flight in preparation for his commercial pilot certificate. He had begun a descent from 10,500 ft for landing at his destination airport when the engine quit. Attempts to restart the engine were unsuccessful and a forced… - [NTSB DEN82FTE17](https://openairdocs.org/ntsb/DEN82FTE17.md): Cessna 172 · Boulder, CO · Accident · Serious injuries · Final report · Mar 7, 1982 · N4899F · Destroyed > The engine lost power while the aircraft was cruising at 7500 ft MSL at night. During a forced landing, the aircraft touched down on steep, rocky soil. The aircraft bounced and then nosed over after a second touchdown. During an interview about two hours… - [NTSB ATL82FKW05](https://openairdocs.org/ntsb/ATL82FKW05.md): Cessna 177RG · Kingston, TN · Accident · Serious injuries · Final report · Mar 7, 1982 · N2150Q · Substantial damage > During cruise flight a gear tooth from the aluminum idler gear in the engine oil pump failed. This locked the oil pump causing failure of the main drive gear. The aircraft landed in rough terrain with gulleys. - [NTSB FTW82FRJ09](https://openairdocs.org/ntsb/FTW82FRJ09.md): Cessna 182L · Farmerville, LA · Accident · Serious injuries · Final report · Mar 5, 1982 · N70541 · Destroyed > The pilot reported that his takeoff and climb to 2200 ft MSL were normal. After the plane was in cruise configuration, he heard an abnormal noise and decided to return to the airport. The noise level increased and the engine began to vibrate. The pilot… - [NTSB DEN82FA038](https://openairdocs.org/ntsb/DEN82FA038.md): Cessna 172 · 3nm East Of Mar, UT · Accident · 3 fatal · Field investigation · Final report · Mar 5, 1982 · N3963F · Destroyed > Witnesses in the vicinity of the accident at the approximate time of the accident stated that blizzard like weather conditions existed, that the snow fall was dense & the wind was variable & gusting. The wreckage was located atop a mountain at approximately… - [NTSB DEN82FA039](https://openairdocs.org/ntsb/DEN82FA039.md): Mooney M20E · Aspen, CO · Accident · 1 fatal · Field investigation · Final report · Mar 4, 1982 · N5755Q · Substantial damage > The aircraft collided with a tree on top of a 12,000 foot mountain after it had departed Aspen, en route to denver. The aircraft should have climbed over the mountain without problems. The pilot only remembers the airspeed decaying and lowering full flaps… - [NTSB NYC82DFJ11](https://openairdocs.org/ntsb/NYC82DFJ11.md): Hughes 500 · Little Valley, NY · Accident · No injuries · Final report · Mar 2, 1982 · N8690F · Substantial damage > About 10 minutes after takeoff in heavy, wet, blowing snow, the engine lost power. At that time, the helicopter was at about 100 ft AGL. At the first indication of a power loss, the pilot initiated and completed an autorotative landing in an open field.… - [NTSB LAX82FUA12](https://openairdocs.org/ntsb/LAX82FUA12.md): Beech 35-B33 · Corona Del Mar, CA · Accident · Minor injuries · Final report · Mar 2, 1982 · N1418G · Substantial damage > While climbing through 4000 feet the pilot heard a grinding noise emanating from the engine. Almost immediately thereafter the windshield was covered with oil. The aircraft was force landed in a high school baseball field with the gear up. It slid across the… - [NTSB ATL82DA064](https://openairdocs.org/ntsb/ATL82DA064.md): Mooney M20F · Belton, KY · Accident · No injuries · Final report · Mar 2, 1982 · N6318Q · Substantial damage > After leveling at 2500 ft, oil fumes were noted, but no abnormal indications were noted on the engine gauges. The pilot suspected oil had been spilled during a repair before takeoff. A short time later, the engine RPM began to increase & was adjusted by the… - [NTSB LAX82FA088](https://openairdocs.org/ntsb/LAX82FA088.md): Cessna T21OL · Verdi, NV · Accident · 6 fatal · Field investigation · Final report · Mar 1, 1982 · N93338 · Destroyed > Prior to the acft's departure from truckee-tahoe arpt, an inbound plt recommended via radio that the flt not go because he had just flown thru the donner pass & the wx was terrible. He reported the wind 25-35K, gusting 40-45K. The flt received a wx briefing… - [NTSB FTW82DA079](https://openairdocs.org/ntsb/FTW82DA079.md): Cessna U206 · Noack, TX · Accident · No injuries · Final report · Mar 1, 1982 · N5131U · Substantial damage > The pilot stated that he was on a one hour flight for aerial survey to giddings, Texas and return. The right fuel tank ran dry and he switched to the left tank which indicated nearly 1/4 full. Approximately 20 minutes later, the engine stopped operating. A… - [NTSB DEN82DA037](https://openairdocs.org/ntsb/DEN82DA037.md): Bell 206B III · Alma, CO · Accident · No injuries · Final report · Mar 1, 1982 · N580P · Substantial damage > The pilot reported that before the accident, the flight had been uneventful and all instruments were reading normal except the tot gauge. Reportedly, it was indicating 750 degrees, which was about 100 degrees higher than normal for his power setting of 70%… - [NTSB MIA82DA061](https://openairdocs.org/ntsb/MIA82DA061.md): Cessna 172L · Lake City, FL · Accident · No injuries · Final report · Feb 28, 1982 · N1026M · Substantial damage > While enroute, the pilot encountered an area with restricted visibility and with an estimated ceiling of 300 ft. after reversing course, he saw a forest road and elected to land. He reported that during the landing roll, a gust of wind was encountered causing… - [NTSB MIA82DA058](https://openairdocs.org/ntsb/MIA82DA058.md): Cessna 152 · Miami Beach, FL · Accident · No injuries · Final report · Feb 27, 1982 · N24542 · Destroyed > The pilot stated that while flying approximately 10 miles southeast of the airport over the ocean the engine started to vibrate. The pilot elected to return to the airport however. A few minutes later the engine oil pressure dropped to zero and the aircraft… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=388 ## 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=387 --- 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.