# NTSB investigations: Standing 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 24 of 42 · 2,085 cases ## Cases, newest first - [NTSB FTW83LA418](https://openairdocs.org/ntsb/FTW83LA418.md): Piper PA-28-140 · Belen, NM · Accident · No injuries · Limited investigation · Final report · Sep 3, 1983 · N43340 · Destroyed > The student & instructor plt (CFI) had flown the acft from albuquerque to Belen, NM, & had shut down the eng. During an eng start to continue the flt about 20 min later, a fire started in the eng & the acft was destroyed by fire. The source of the fire was… - [NTSB MKC83FA196](https://openairdocs.org/ntsb/MKC83FA196.md): Bell 47G-3B · Paxton, NE · Accident · Serious injuries · Field investigation · Final report · Aug 18, 1983 · N73248 · Destroyed > The plt stated that after landing on a truck platform, he did not decrease rotor RPM & did not lower collective to flat pitch as he was attempting to recover a piece of paper that had fallen to the floor on the right side of the cockpit. As he released the… - [NTSB LAX83FA393](https://openairdocs.org/ntsb/LAX83FA393.md): Hughes 369HS · San Pedro, CA · Accident · 1 fatal · Field investigation · Final report · Aug 18, 1983 · N90958 · Substantial damage > The plt was on a mission to transport company personnel & had landed on a barge that was being used as a helipad. The barge was about 250 ft long & 75 ft wide. After arriving, the plt parked the helicopter with the tail boom as close to the edge of the barge… - [NTSB CHI83LA372](https://openairdocs.org/ntsb/CHI83LA372.md): Cessna 177B · Wheeling, IL · Accident · Serious injuries · Limited investigation · Final report · Aug 7, 1983 · N35083 · No damage > The plt was unable to start the eng using normal procedures. He obtained the use of an APU & still could not make an electrical start. He stated that he turned the magneto & master switches off & rotated the propeller (prop) backwards 1/2 turn (to check for… - [NTSB ATL83LKW02](https://openairdocs.org/ntsb/ATL83LKW02.md): Cessna 152 · Nashville, TN · Accident · Serious injuries · Final report · Jul 30, 1983 · N5270B · Minor damage > The acft propeller struck a deplaned female passenger as she proceeded to the front of the acft prior to engine shutdown. The plt stated that his attention was primarily on the fact that the idle RPM seemed high to him and he failed to note his passenger exit… - [NTSB LAX83FA349](https://openairdocs.org/ntsb/LAX83FA349.md): Beech C-45G · Kahalui, HI · Accident · Minor injuries · Field investigation · Final report · Jul 23, 1983 · N888M · 2 aircraft · Substantial damage > A Beech C-45G, N888M, call sign lani 8 and a Beech E185, N162SP, call sign lani 9 were part of a flt of 5 acft, with call signs of lani 6 thru 10, that where being used on an inter-island tour. The 1st act, lani 6, was cleared for takeoff & departed… - [NTSB NYC83FA171](https://openairdocs.org/ntsb/NYC83FA171.md): Stinson 108 · Farmingdale, NY · Accident · 2 fatal · Field investigation · Final report · Jul 11, 1983 · N90DD · Destroyed > The carburetor had been previously removed & reworked, then was reinstalled. After the installation, which included a leak check, the plt got into the left front seat & the passenger/mechanic got into the right front seat. The plt primed the eng, then made a… - [NTSB LAX83FUA04](https://openairdocs.org/ntsb/LAX83FUA04.md): Cessna 182 · Avalon Catalina, CA · Accident · Serious injuries · Final report · Jul 11, 1983 · N3602U · No damage > The acft propeller struck the arm of a lineman who was assisting the plt to start the acft the plt stated that the propeller was turning slowly and he asked for help. The lineman requested that all switches be turned off and proceed toturn the propeller which… - [NTSB SEA83LA148](https://openairdocs.org/ntsb/SEA83LA148.md): Cessna 150-J · Connell, WA · Accident · Serious injuries · Limited investigation · Final report · Jul 10, 1983 · N1053M · No damage > The plt stated he was preparing to shut down the engine when the passenger deplaned & inadvertently walked into the prop. - [NTSB NYC83LNA03](https://openairdocs.org/ntsb/NYC83LNA03.md): Cessna 150 · Stow, MA · Accident · Serious injuries · Final report · Jul 7, 1983 · N11196 · No damage > The acft propeller struck a passenger who was walking around the acft in preparation for boarding. The acft had been taxied in from landing and stopped near the coffee shop. The wife of the passenger on board the acft approached theacft prior to engine shut… - [NTSB FTW83FA303](https://openairdocs.org/ntsb/FTW83FA303.md): Grumman American AA-5A · Houston, TX · Accident · 2 fatal · Field investigation · Final report · Jun 29, 1983 · N9844U · 2 aircraft · Destroyed > The Grumman American AA-5A, N9844U, had just landed. While taxing, the aircrew stopped short of rwy 13R as Beechcraft. Hawker BH-125, N125E, was taking off. The rated student in N125E, who was on a training flt, was at the controls & beganthe takeoff. The… - [NTSB CHI83LA275](https://openairdocs.org/ntsb/CHI83LA275.md): Cessna 152 · Kalamazoo, MI · Accident · No injuries · Limited investigation · Final report · Jun 22, 1983 · N93407 · 2 aircraft · Substantial damage > The aircrew of a Cessna 152, N93407, landed on rwy 17 & turned off on taxiway e. they were instructed to hold short of rwy 23 & they complied. Shorly after the Cessna landed, the plt of a Boeing A75 stearman, N801RB, also landed on rwy 17 & turned off on the… - [NTSB CHI83IA269](https://openairdocs.org/ntsb/CHI83IA269.md): Boeing B-747 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jun 20, 1983 · N4717U · 2 aircraft · Minor damage > The united airlines B747 was standing in the run up area adjacent to the runway. A flying tigers B747 was passing to his left. The crew of the parked B747 opened their overhead escape hatch and indicated to the taxiing B747 with a thumbs up sign that there… - [NTSB MIA83FA159](https://openairdocs.org/ntsb/MIA83FA159.md): Boeing 727-200 · San Juan, PR · Accident · Serious injuries · Field investigation · Final report · Jun 11, 1983 · HI242 · No damage > As the acft was departing, the airline company received info concerning a bomb threat. The aircrew were instructed to return to the arpt & land. After landing, the acft was parked at an isolated area & portable stairs were positioned at the left forward door.… - [NTSB ATL83LA221](https://openairdocs.org/ntsb/ATL83LA221.md): Robinson R-22 · Jackson, KY · Accident · Serious injuries · Limited investigation · Final report · Jun 8, 1983 · N90672 · Substantial damage > The pilot reported that when he exited the helicopter for the purpose of retrieveing a map from below the plt's seat, the acft began to lift and move laterally. The acft then tipped over trapping his leg and hip beneath it. He stated that he had not fully… - [NTSB LAX83LA284](https://openairdocs.org/ntsb/LAX83LA284.md): Cessna 172A · Carmel Valley, CA · Accident · No injuries · Limited investigation · Final report · Jun 5, 1983 · N9854T · Substantial damage > According to the pilot there were no tiedowns, chocks or other restraining devices available so he ask a non certificated person to sit in the aircraft and apply the brakes while he rotated the prop by hand to start the engine. The engine started and the… - [NTSB SEA83IA116](https://openairdocs.org/ntsb/SEA83IA116.md): Boeing 727-200 · Portland, OR · Incident · No injuries · Incident investigation · Final report · Jun 4, 1983 · N296AS · No damage > A broken hydraulic line near the left main landing gear allowed hydraulic fluid to leak on to the APU exhaust. The resultant smoke then was picked up by the left airpack and was blown into the cabin. The crew then ordered an evacuationof the passengers. - [NTSB LAX83LA238](https://openairdocs.org/ntsb/LAX83LA238.md): Cessna 182 · Riverside, CA · Accident · No injuries · Limited investigation · Final report · May 20, 1983 · N5547B · Substantial damage > The acft collided with a hangar after being hand propped without a qualified person in the cockpit. The acft had been borrowed and was known to have a low battery. The pilot did a start by hand propping the acft with a non-pilot in the right front seat.… - [NTSB CHI83LA216](https://openairdocs.org/ntsb/CHI83LA216.md): Cessna 150 · Janesville, WI · Accident · No injuries · Limited investigation · Final report · May 16, 1983 · N8576J · 2 aircraft · Minor damage > N13364 had stopped short of the runway for a run-up check prior to takeoff. The pilot of N8576J continued his taxi while he was checking the field elevation and setting his altimeter he taxied into the empennage of N13364. - [NTSB SEA83LYK02](https://openairdocs.org/ntsb/SEA83LYK02.md): Cessna 210L · North Bend, OR · Accident · Serious injuries · Final report · Apr 17, 1983 · N30784 · Substantial damage > The aircraft collided with a parked fuel trailer after the engine started when the pilot turned the prop to loosen up the engine oil. The pilot received serious injuries when he was knocked down by the left horizontal stabilizer as he tried to reenter the… - [NTSB FTW83LA177](https://openairdocs.org/ntsb/FTW83LA177.md): de Havilland DHC-6 · Mckinney, TX · Accident · 1 fatal · Limited investigation · Final report · Apr 3, 1983 · N927BA · No damage > Three observers accompanied the aircrew & other passengers on a flt to transport skydivers aloft. Prior to the flt, all 3 of the observers were briefed not to exit the acft until the engines were secured. However, 1 of the 3 discussed the need to move a… - [NTSB MKC83FA072](https://openairdocs.org/ntsb/MKC83FA072.md): Swearingen SA 226TC · St. Louis, MO · Accident · Serious injuries · Field investigation · Final report · Feb 25, 1983 · N237AM · Minor damage > Rotating right prop struck a female child passenger who had run down the acft airstair to retrieve a doll she had dropped while climbing the airstair to board for the flt. A company attendant was stationed at the left (stopped) prop, but not on or near the… - [NTSB LAX83LA103](https://openairdocs.org/ntsb/LAX83LA103.md): Beech 95-55 · San Francisco, CA · Accident · No injuries · Limited investigation · Final report · Feb 15, 1983 · N704CC · Substantial damage > The pilot was preparing to taxi when he noticed a loose fuel cap on the acft's left wing. He set the parking brake, exited the acft with both engines operating, placed a chock on the right wheel and was securing the loose fuel cap when the acft started to… - [NTSB MKC83LA067](https://openairdocs.org/ntsb/MKC83LA067.md): Beech B23 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Feb 14, 1983 · N4013T · Substantial damage > The pilot was not totally familiar with the operation of this aircraft. The aircraft engine was started without setting the parking brake properly. The pilot did not have his feet on the brakes and could not reduce the throttle because of the throttle lock.… - [NTSB FTW83LA111](https://openairdocs.org/ntsb/FTW83LA111.md): Bellanca 14-19-3A · Plainview, TX · Accident · Serious injuries · Limited investigation · Final report · Feb 11, 1983 · N1264R · Substantial damage > The flt reported that the battery was too low to start the engine. A 72 yr old ex-pilot offered to hand prop the plane, but after trying, he then offered to hold the brakes. With the ex-pilot at the controls & holding the brakes, the plt began to hand prop… - [NTSB MKC83FA061](https://openairdocs.org/ntsb/MKC83FA061.md): Beech M35 · Cedar Rapids, IA · Accident · Serious injuries · Field investigation · Final report · Jan 31, 1983 · N9708R · No damage > The acft engine fired as the pilot hand-propped it and the propeller struck the pilot in the leg. The pilot had tried the starter but could not get a start. He turned the switches off and decided to pull the prop through by hand. He pulled it through… - [NTSB FTW83FA100](https://openairdocs.org/ntsb/FTW83FA100.md): Robinson R22 · Zapata, TX · Accident · No injuries · Field investigation · Final report · Jan 27, 1983 · N9021J · Destroyed > The helicopter was landed in an area of dry grass, 18 to 28 inches tall. The plt stated that within 30 sec after a normal approach & touchdown, the passenger noticed a fire as he was exiting the acft. The pilot then rolled the throttle on in an attempt to… - [NTSB LAX83FA076](https://openairdocs.org/ntsb/LAX83FA076.md): Beech C-99 · San Francisco, CA · Accident · 1 fatal · Field investigation · Final report · Jan 20, 1983 · N64002 · Minor damage > The acft propeller struck a station agent who was assisting in the parking of the acft. After signaling the acft to stopthe agent placed her lighted wanes on the ramp and moved toward the stationary acft to get the wheel chocks. As she approached the chocks… - [NTSB MKC83IA054](https://openairdocs.org/ntsb/MKC83IA054.md): Cessna 402B · St. Louis, MO · Incident · No injuries · Incident investigation · Final report · Jan 10, 1983 · N8200Q · Minor damage > The right engine of the acft started to burn while the acft was being started. The pilot noticed flames coming out of the top of the right engine after the left engine was started. The pilot initiated shut down of both engines and evacuation of the… - [NTSB FTW83LA049](https://openairdocs.org/ntsb/FTW83LA049.md): Cessna 150H · Addison, TX · Accident · No injuries · Limited investigation · Final report · Nov 30, 1982 · N6718S · Destroyed > Pilot hand propped engine with aircraft cockpit unattended. Aircraft started taxiing and collided with another unattended aircraft parked on the ramp. - [NTSB DEN83FA021](https://openairdocs.org/ntsb/DEN83FA021.md): Mcdonald Douglas DC-10 · Denver, CO · Accident · No injuries · Field investigation · Final report · Nov 19, 1982 · N68056 · Substantial damage > During the taxi for takeoff, the crew noted a hydraulic malfunction on the right main gear and returned to the gate for maintenance. The aircraft was shut down and turned over to the maintenance crew for repair. The passengers were not deplaned. During… - [NTSB MIA83LA029](https://openairdocs.org/ntsb/MIA83LA029.md): Aero Commander 680 · Belle Glade, FL · Accident · No injuries · Limited investigation · Final report · Nov 15, 1982 · N163KT · Destroyed > Acft had been object of an airborne pursuit by U.S. Customs at about 1830 in the vicinity of Belle Glade. During the pursuit the acft door & 15 bales of a controlled substance were observed being jettisoned from the acft. After landing the acft was set on… - [NTSB LAX83FA002](https://openairdocs.org/ntsb/LAX83FA002.md): Swearingen SA-226TC · Palm Springs, CA · Accident · Minor injuries · Field investigation · Final report · Oct 16, 1982 · N63SA · Substantial damage > While at the gate with the passengers seated & the engines running, the copilot attempted to turn up his panel lights with the rheostat located on the FAR right forward portion of the side electrical panel. At that instant smoke began to erupt at his right… - [NTSB FTW83LA013](https://openairdocs.org/ntsb/FTW83LA013.md): Piper PA-24-250 · Houston, TX · Accident · No injuries · Limited investigation · Final report · Oct 13, 1982 · N5697P · Substantial damage > The pilot had taxied onto taxiway lima and had stopped short of runway 13R/31L to hold for landing traffic. At about the same time, an airport employee was proceeding down the runway from northwest to southeast to check the runway lights. The ground… - [NTSB NYC82FA230](https://openairdocs.org/ntsb/NYC82FA230.md): Bell 222 · New York, NY · Accident · 1 fatal · Field investigation · Final report · Sep 22, 1982 · N2772H · Minor damage > The helicopter (hel) was being loaded with the engines running. The flt crew were at the ctls when the acdnt occurred. Initially, 4 paxs were escorted to the hel by a customer svc agent. As the 4 boarded, the agent retrieved their carry on baggage. Aft they… - [NTSB SEA82DA165](https://openairdocs.org/ntsb/SEA82DA165.md): Piper PA-28-180C · Renton, WA · Accident · 1 fatal · Final report · Sep 15, 1982 · N9613J · No damage > Pilot parked aircraft with engine running to discharge passenger. Passenger jumped off right wing into prop. - [NTSB SEA82DA154](https://openairdocs.org/ntsb/SEA82DA154.md): Cessna R172K · Brownsmead, OR · Accident · Minor injuries · Final report · Sep 4, 1982 · N758MY · Substantial damage > The pilot reported that about 30 minutes after takeoff, the engine sputtered and quit. The aircraft was damaged from a landing on rough terrain. During an investigation, only about two pints of fuel were found in the aircraft. - [NTSB SEA82DA150](https://openairdocs.org/ntsb/SEA82DA150.md): Piper PA-28-161 · Auburn, WA · Accident · No injuries · Final report · Aug 28, 1982 · N8316A · 2 aircraft · Substantial damage > N1338J experienced a brake line failure and taxied into Piper PA-28, N8316A, that was parked in the warm-up area. There were no injuries. - [NTSB FTW82DRA26](https://openairdocs.org/ntsb/FTW82DRA26.md): Cessna 150 · Friendswood, TX · Accident · Serious injuries · Final report · Aug 28, 1982 · N150WM · No damage > The pilot of N150WM was giving free rides to guests. He taxied to the active runway after a landing and discharged a passenger. A female passenger walked out to the airplane to get in but due to the fact she had previously rode, the pilot asked her to let… - [NTSB ATL82IA245](https://openairdocs.org/ntsb/ATL82IA245.md): Beech C23 · Duluth, GA · Incident · No injuries · Incident investigation · Final report · Aug 25, 1982 · N2163W · Minor damage > During preflight, the pilot found the right aileron front push-pull rod end broken. This defect would have precluded aileron control. Metallurgical examination of the fracture revealed that the part had failed due to reverse bending fatigue as a result of… - [NTSB DEN82DTK07](https://openairdocs.org/ntsb/DEN82DTK07.md): Raven RX-7 · Phillip, SD · Accident · Serious injuries · Final report · Aug 22, 1982 · N4010S · Minor damage > After the fourth landing, the balloon had been on the ground about 8 minutes when a whirl wind suddenly hit the envelope. The balloon lifted up about 2 to 3 ft and was blown into the side of a chase vehicle. One of the passengers was thrown out of the… - [NTSB ANC82DAG48](https://openairdocs.org/ntsb/ANC82DAG48.md): Maule M-5 · Nera Kenai, AK · Accident · 1 fatal · Final report · Aug 22, 1982 · N369X · Minor damage > The passenger was struck by the propeller while he was attempting to assist in beaching the float plane. The pilot stated that as he beached the aircraft and was shutting down the engine, the passenger (contrary to repeated instructions) exited the cabin.… - [NTSB FTW82FRA25](https://openairdocs.org/ntsb/FTW82FRA25.md): Cessna 177RG · Houston, TX · Accident · Serious injuries · Final report · Jul 4, 1982 · N53070 · No damage > After returning from a short cross-country, the pilot taxied to his parking spot. His car was park on one side of the aircraft's parking spot and another car was on the opposite side. The pilot's wife deplaned to move his car while the aircraft engine was… - [NTSB ANC82DA050](https://openairdocs.org/ntsb/ANC82DA050.md): Cessna 185F · Near Chinitna B, AK · Accident · 1 fatal · Final report · Jun 19, 1982 · N4212Q · Destroyed > The aircraft was chartered to salvage gear from a burned hovercraft that was beached about one mile south of Chinitna bay. The pilot reported that the two passengers got the gear ready to load while he held the plane off the beach by hand, trying to keep the… - [NTSB MKC82DA099](https://openairdocs.org/ntsb/MKC82DA099.md): Cessna 500 · Topeka, KS · Accident · Serious injuries · Final report · Jun 9, 1982 · N981EE · No damage > When a passenger was boarding the aircraft, she inadvertently released the latch that held the door open. The door swung toward the closed position, struck the back of the passenger's foot, and severed the tendon. There were thunderstorms in the area and the… - [NTSB LAX82DUG12](https://openairdocs.org/ntsb/LAX82DUG12.md): Swearingen SA226-TC · Palm Springs, CA · Accident · Serious injuries · Final report · May 29, 1982 · N1009R · Minor damage > After starting the engines at night, a signal was given to a line service employee to disconnect the APU. While attempting to disconnect the APU, the line service employee moved into the path of the right propeller and was seriously injured. - [NTSB DEN82DA094](https://openairdocs.org/ntsb/DEN82DA094.md): Cessna T210L · Salt Lake City, UT · Accident · No injuries · Final report · May 18, 1982 · N30796 · Substantial damage > One of the runways at the destination airport was out of service. After landing, the pilot was instructed to hold for air carrier aircraft. After about a five minute delay, he was cleared to the general aviation parking area. In the meantime, there was a… - [NTSB CHI82DA149](https://openairdocs.org/ntsb/CHI82DA149.md): Hughes 269C · Flint, MI · Accident · No injuries · Final report · May 3, 1982 · N8963F · Substantial damage > The aircrew were on an instructional flight to prepare the student, a rated pilot, for a flight instructor rating. After practicing several autorotation approaches, the helicopter was landed. The instructor pilot (ip) stated that after touchdown, he and the… - [NTSB NYC82FHJ04](https://openairdocs.org/ntsb/NYC82FHJ04.md): Bell 206L · New York, NY · Accident · Minor injuries · Final report · Apr 25, 1982 · N16696 · 2 aircraft · Substantial damage > The accident involved two Bell 206L helicopters that were parked beside one another, but headed in opposite directions. When the pilot of N49575 arrived, the other helicopter, N16696, was operating with the rotors at about 60% RPM (flight idle) while… - [NTSB LAX82DA147](https://openairdocs.org/ntsb/LAX82DA147.md): S.N.I.A.S. AS350 · Gold Strike, NV · Accident · 1 fatal · Final report · Apr 24, 1982 · N5768Z · Minor damage > The helicopter had just returned from a sightseeing tour of the grand canyon. The pilot reported that the passengers wanted to get out while the helicopter was undergoing its two-minute, cool-down period. The pilot escorted four of the passengers from the… Next page: https://openairdocs.org/ntsb-phases/150/cases.md?page=25 ## 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 = 150) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/150/cases?page=24 --- 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.