# 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 21 of 42 · 2,085 cases ## Cases, newest first - [NTSB LAX87DUJ05](https://openairdocs.org/ntsb/LAX87DUJ05.md): Hiller UH-12E · Tolleson, AZ · Accident · No injuries · Final report · May 19, 1987 · N4034T · Destroyed > The plt stated that he landed the acft on a platform on top of a chemical tank truck. The truck was parked on a slight slope with its left side six inches lower than the right. The plt reduced power to idle and the loader began to load the helicopter with… - [NTSB ATL87LA143](https://openairdocs.org/ntsb/ATL87LA143.md): Beech B100 · Birmingham, AL · Accident · 1 fatal · Limited investigation · Final report · May 19, 1987 · N753D · Minor damage > The lineman walked into the prop arc of the operating rt engine and was fatally injured after disconnecting a ground power unit (gpu) cable from the rt engine nacelle. The lineman initially approached the nacelle from the rear, but walked forward into the… - [NTSB NYC87LA151](https://openairdocs.org/ntsb/NYC87LA151.md): Aeronca 11AC · Jeanette, PA · Accident · No injuries · Limited investigation · Final report · May 17, 1987 · N3886E · Substantial damage > The plt put small chocks under the wheels, then began to hand prop the eng with no one at the controls. The eng started, & before the plt could reach the cockpit, the acft made svrl 360 deg turns & subsequently rolled into trees. - [NTSB SEA87LA090](https://openairdocs.org/ntsb/SEA87LA090.md): Rutan VARI-EZE · Renton, WA · Accident · Minor injuries · Limited investigation · Final report · May 8, 1987 · N29Z · Substantial damage > While being hand propped the aircraft began to move. The pilot then attempted to climb inside the aircraft but the canopy had closed. The pilot held onto the aircraft and was dragged across the end of the runway. The aircraft struck a parked, unoccupied… - [NTSB FTW87FA116](https://openairdocs.org/ntsb/FTW87FA116.md): Beech V35-B · Terrell, TX · Accident · No injuries · Field investigation · Final report · May 8, 1987 · N1861W · Destroyed > While attempting to start the aircraft the starter solenoid wiring caught fire. The heat from the fire caused an overstressed brake line to fall, allowing brake fluid to drain onto the lip of the nose gear door. The fire then burned through the floor of the… - [NTSB NYC87LA168](https://openairdocs.org/ntsb/NYC87LA168.md): Taylorcraft DCO-65 · Sanford, ME · Accident · No injuries · Limited investigation · Final report · Apr 22, 1987 · N58032 · Substantial damage > The acft was being hand propped from behind the prop on the rgt side when the eng started. The plane jumped the chock, knocked the plt to the ground, turned to the rgt & collided with a parked acft in the tie-down area. The acft was not tied down & only the… - [NTSB LAX87LA185](https://openairdocs.org/ntsb/LAX87LA185.md): Cessna P210N II · Tucson, AZ · Accident · Minor injuries · Limited investigation · Final report · Apr 20, 1987 · N6509P · 2 aircraft · Minor damage > A C-172 collided with a C-210N while txg. The C-172 was txg along a 75 ft wide parallel twy after landing. The C-210N was txg from a ramp area to his dep rwy. The C-210N route intersected the C-172 route at the parallel twy where the collision occurred. Plts… - [NTSB LAX87LA171](https://openairdocs.org/ntsb/LAX87LA171.md): Mooney M20J · Fullerton, CA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1987 · N5690N · 2 aircraft · Minor damage > While holding short of the runway behind a Cessna 182R, the pilot of a Mooney M20J, reached over to tighten his four year old sons seatbelt. The pilots foot came off the toe brake and the aircraft rolled forward and collided with the Cessna. - [NTSB CHI87IA110](https://openairdocs.org/ntsb/CHI87IA110.md): Cessna 172L · Plainfield, IL · Incident · 1 fatal · Incident investigation · Final report · Mar 29, 1987 · N4211Q · No damage > The pilot decided the weather was not good enough to fly, but he would run the engine and turn the tires. He was discovered in the plane by other pilots and later pronounced dead, from carbon monoxide asphyxiation. The muffler had a 12 inch crack which a… - [NTSB ANC87LA042](https://openairdocs.org/ntsb/ANC87LA042.md): Cessna 185F · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Mar 1, 1987 · N2449J · Substantial damage > The pilot was unable to start his airplane due to a weak battery and elected to start the unsecured acft's engine by hand-propping. The engine started and the airplane accelerated away from its tie-down area and into a building before the pilot could reenter… - [NTSB NYC87LA090](https://openairdocs.org/ntsb/NYC87LA090.md): Cessna 150C · Manville, NJ · Accident · No injuries · Limited investigation · Final report · Feb 17, 1987 · N63218 · Substantial damage > After making a rest stop, the plt attempted to restart the eng, using a normal start procedure, but the starter would not engage. He tried to turn off the ignition switch, but said that 'possibly due to the fact that I was wearing heavy gloves, I failed to… - [NTSB CHI87FA081](https://openairdocs.org/ntsb/CHI87FA081.md): Boeing 747-122 · Detroit, MI · Accident · Serious injuries · Field investigation · Final report · Feb 12, 1987 · N4718U · No damage > Drg flt, united flt 108 recd info of a bomb threat. Due to a short time limit, specified in the threat, the flt divertedto Detroit & the slides were used to evacuate the acft; 8 of 10 slides deployed nmly & were used. The slide at door 4R didn't inflate &… - [NTSB LAX87LA111](https://openairdocs.org/ntsb/LAX87LA111.md): Cessna T210L · El Cajon, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 8, 1987 · N5275V · No damage > The plt indicated that he and his wife were planning to fly together, but at the last minute his wife changed her mind. She exited the acft and departed the area to the rear of the plane. The plt was taxiing from his parking spot when his wife suddenly… - [NTSB CHI87DEE04](https://openairdocs.org/ntsb/CHI87DEE04.md): Cessna 172 · Plainfield, IL · Accident · 1 fatal · Final report · Feb 2, 1987 · N2968U · No damage > While taxiing for takeoff, the aircraft became stuck in a snowbank. The pilot and passenger got out of the aircraft to free it. The passenger walked into the propeller of the running engine and received fatal injuries. - [NTSB CHI87DER02](https://openairdocs.org/ntsb/CHI87DER02.md): Cessna 150M · Lakeville, MN · Accident · Serious injuries · Final report · Jan 31, 1987 · N714QW · Minor damage > The student & instructor (CFI) were preflighting the acft to fly on a cold morning. To facilitate better eng starting, the CFI elected to turn the prop while the student 'pushed the primer in.' He told the student to check that the mag & master sws were off &… - [NTSB CHI87DEP01](https://openairdocs.org/ntsb/CHI87DEP01.md): Champion 7ECA · La Crosse, WI · Accident · Minor injuries · Final report · Jan 18, 1987 · N9999Y · Substantial damage > After the third try at an engine start the eng started and ran at full throttle. The plt could not reduce RPM. To avoid striking two parked acft the plt struck a hangar. Post accident investigation revealed that the throttle cable was not operating properly.… - [NTSB MIA87LA063](https://openairdocs.org/ntsb/MIA87LA063.md): Fokker F28 MK4000 · West Palm Bch, FL · Accident · Serious injuries · Limited investigation · Final report · Dec 30, 1986 · N510 · Minor damage > During passenger boarding at tallahassee it was discovered that the left handrail on the airstair was collapsed. The failure was at the soldered joint at the handrail locking mechanism. The station manager used metal glue for a temporary repair of the joint.… - [NTSB NYC87LA041](https://openairdocs.org/ntsb/NYC87LA041.md): Cessna 441 · Erie, PA · Accident · No injuries · Limited investigation · Final report · Nov 30, 1986 · N117EA · Substantial damage > Reason for the Cessna to veer in a semi-circle and collide with another aircraft is undetermined. Examination of the start lock assemblies could not be completed due to the extensive impact and fire damage. The acft was being prepared for a flt. During a… - [NTSB SEA87LA030](https://openairdocs.org/ntsb/SEA87LA030.md): Cessna 180J · Juneau, AK · Accident · 1 fatal · Limited investigation · Final report · Nov 24, 1986 · N9907N · No damage > The passenger deplaned while the plt shut down the aircrafts engine. Although the plt noticed that the passenger was near the wing strut and attempted to yell at him, the passenger inadvertently walked into the wind milling propeller which struck him in the… - [NTSB BFO87LA011](https://openairdocs.org/ntsb/BFO87LA011.md): Cessna 182K · Baltimore, MD · Accident · Serious injuries · Limited investigation · Final report · Nov 22, 1986 · N2733Q · Substantial damage > The acft traveled out of control after the plt hand-prop started the engine. The acft collided with a parked fuel trucks. There was no fire. The sole occupant in the acft was a non-pilot passenger. - [NTSB CHI87LA033](https://openairdocs.org/ntsb/CHI87LA033.md): Cessna 182F · Sandwich, IL · Accident · Serious injuries · Limited investigation · Final report · Nov 15, 1986 · N3289U · Minor damage > The pilot was attempting to hand prop the aircraft due to a low battery. The engine started and the plane began moving. The aircraft struck the pilot and then traveled into a hangar door. - [NTSB NYC87LA032](https://openairdocs.org/ntsb/NYC87LA032.md): Piper PA-28-181 · Philadelphia, PA · Accident · Minor injuries · Limited investigation · Final report · Nov 14, 1986 · N82089 · Destroyed > During hand propping, the aircraft began to move and rolled across a field crashing through a fence when fire erupted destroying the aircraft. The plt stated that after setting brakes to full pressure he atmptd to had prop acft. The eng started and while the… - [NTSB LAX87LA038](https://openairdocs.org/ntsb/LAX87LA038.md): Piper PA-28-150 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Nov 12, 1986 · N5153W · Substantial damage > The acft went through a fence and collided with trees after a 'hand-propped' start. The student plt had exhausted the acft battery power during previous starting attempts. He then tied the acft down at both wings and the tail. He primed the eng with the… - [NTSB FTW87LA015](https://openairdocs.org/ntsb/FTW87LA015.md): Houk Pitts S1-S · La Porte, TX · Accident · Serious injuries · Limited investigation · Final report · Nov 9, 1986 · N35DH · No damage > A mechanic was attempting to pull the prop through one revolution prior to starting the engine on a pitts S1-S. Due to a bad p-lead on the magneto's the engine fired, causing the prop to strike the right leg of the mechanic. The mechanics leg was amputated… - [NTSB SEA87LA024](https://openairdocs.org/ntsb/SEA87LA024.md): Cessna 182B · Bellingham, WA · Accident · No injuries · Limited investigation · Final report · Nov 8, 1986 · N2654G · Substantial damage > Drg an attempted start, the eng backfired & an induction fire started. However, the plt did not continue cranking the eng. Strong surface winds inhibited the effectiveness of the acft's portable fire extinguisher. The plt then attempted to use an extinguisher… - [NTSB LAX87DUG01](https://openairdocs.org/ntsb/LAX87DUG01.md): Aero Commander 520 · Lucerne Valley, CA · Accident · No injuries · Final report · Nov 2, 1986 · N70FM · Destroyed > During a pleasure flt, the plt reported that the right engine caught on fire. The plt made a landing on dry lake bed and disembarked from the plane examination of the wreckage revealed that the path of the landing roll showed no signs of melted metal or… - [NTSB LAX87DJA01](https://openairdocs.org/ntsb/LAX87DJA01.md): Murrayair MA-1 · Hilo, HI · Accident · No injuries · Final report · Oct 28, 1986 · N306MA · Destroyed > After returning from a spraying flt, the acft was refueled. After refueling, the plt used fuel to wash oil from the side of the acft & the wing step. When the eng was restarted about 2 min later, fuel fumes ignited & fire spread to the fuel truck. Both the… - [NTSB CHI87LA007](https://openairdocs.org/ntsb/CHI87LA007.md): Beech BE-23 · Lake Village, IN · Accident · No injuries · Limited investigation · Final report · Oct 21, 1986 · N6997Q · Substantial damage > The plt stated that the acft would not start so he applied the acft hand brake and proceeded to hand prop the acft with no one aboard. While hand propping the acft, the engine fired and the hand brake did not hold. As the plt walked around the right wing, the… - [NTSB LAX87LA020](https://openairdocs.org/ntsb/LAX87LA020.md): Cessna 150L · Pacoima, CA · Accident · Minor injuries · Limited investigation · Final report · Oct 18, 1986 · N18737 · Substantial damage > The plt refueled the acft, but was unable to restart the eng by using the battery. He hand propped the eng which started immediately. The acft began to move unattended & the plt clung to the left wing strut, but relinquished his grip after the acft moved aprx… - [NTSB NYC87LA010](https://openairdocs.org/ntsb/NYC87LA010.md): Lockheed L188A · Boston, MA · Accident · Serious injuries · Limited investigation · Final report · Oct 9, 1986 · N342HA · No damage > During engine start number 4 engine was started. The signal was given to the ground crewman to disconnect the air start unit. The engineer thought he heard 'start number 3'. Engine number 4 was shifted up, it stabilized, and engine number 3 was started. After… - [NTSB SEA87IA003](https://openairdocs.org/ntsb/SEA87IA003.md): Mcdonnell Douglas DC-10-10 · Seattle, WA · Incident · No injuries · Incident investigation · Final report · Oct 5, 1986 · N1843U · Minor damage > During attempt to apply ground power to acft, internal feeder cables shorted and melted down. Investigation revealed poor workmanship by contracted maintenance personnel in modification installation. - [NTSB MKC86LA199](https://openairdocs.org/ntsb/MKC86LA199.md): Bell 206A · Texarkana, AR · Accident · No injuries · Limited investigation · Final report · Sep 26, 1986 · N206DW · Substantial damage > The pilot stated that the left front passenger raised the collective pitch control by mistake while trying to open the cabin door. According to the pilot, the rotor system was between 65-70 n 1, and the throttle at flight idle. When the helicopter achieved… - [NTSB LAX86LA355](https://openairdocs.org/ntsb/LAX86LA355.md): Aero Commander 112A · El Monte, CA · Accident · No injuries · Limited investigation · Final report · Sep 17, 1986 · N1455J · Substantial damage > The pilot stated that the engine would not start so he secured the left wing and hand propped the engine. When the engine started, the aircraft began moving in a circular path to the left and collided with a parked aircraft. - [NTSB MKC86LA169](https://openairdocs.org/ntsb/MKC86LA169.md): David Gordon Whitman Tailwind · Valley Center, KS · Accident · No injuries · Limited investigation · Final report · Aug 11, 1986 · N3064 · Substantial damage > The acft rolled forward unrestrained after the PIC had started the eng. The acft was not moored before the PIC attempted the hand start. The acft rolled a short distance where it impacted the edge of a building and sustained substantial damage. Multiple… - [NTSB DCA86IA037](https://openairdocs.org/ntsb/DCA86IA037.md): Mcdonnell Douglas DC-10-40 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Aug 10, 1986 · N184AT · Destroyed > A charter flt arrived & deplaned without incident & with no indication of smoke, fumes or heat. Company maint psnl had placed damaged passenger seatbacks (incorporating solid-state chemical oxygen generators) in the fwd cargo compartment with seat covers &… - [NTSB MIA86LA219](https://openairdocs.org/ntsb/MIA86LA219.md): Cessna 172M · Fort Myers, FL · Accident · No injuries · Limited investigation · Final report · Jul 26, 1986 · N13351 · Substantial damage > The plt stated that his non-rated wife was onboard the acft while he was pulling the propeller through, priming the engine. While doing so, the engine started due to the mag switch being left on. The acft then taxied uncontrolled, colliding with a parked… - [NTSB SEA86LA176](https://openairdocs.org/ntsb/SEA86LA176.md): Bell 47G-3B1 · Burbank, WA · Accident · 1 fatal · Limited investigation · Final report · Jul 23, 1986 · N1197W · Minor damage > The helicopter had landed for reloading and was stationary with rotors idling. A ground loader person approached the helicopter over a small sandy knoll and was struck by the main rotor, sustaining fatal injury. - [NTSB ATL86IA190](https://openairdocs.org/ntsb/ATL86IA190.md): Swearingen SA-26AT · Waycross, GA · Incident · Minor injuries · Incident investigation · Final report · Jul 4, 1986 · N20EF · No damage > The pax had received instructions by the plt on how to open the cabin door. The acft was shut down on the ramp and the pax attempted to open the cabin door. The latch was turned; the door began to fall open and the pax caught the door step channel at a hinge… - [NTSB ATL86FEI07](https://openairdocs.org/ntsb/ATL86FEI07.md): Bell 47G2 · Lisbon, OH · Accident · 1 fatal · Final report · Jun 26, 1986 · N984B · Minor damage > The aerial application helicopter was being serviced by a chemical truck that was parked adjacent to the acft. The acft engine was at high idle with the main rotor turning at 250 RPM. The ground crewman jumped off the side of the chemical truck into the main… - [NTSB ATL86LA169](https://openairdocs.org/ntsb/ATL86LA169.md): Cessna 172 · Pelion, SC · Accident · No injuries · Limited investigation · Final report · Jun 14, 1986 · N30265 · Destroyed > The private plt and student plt returned to the acft after pausing from landing practice for a soft drink. An engine start was attempted and a back fire occurred that started and induction fire. The intensity of the fire grew and the occupant exited the acft… - [NTSB MIA86LA176](https://openairdocs.org/ntsb/MIA86LA176.md): Cessna 411 · Tallahassee, FL · Accident · No injuries · Limited investigation · Final report · Jun 11, 1986 · N4959T · Substantial damage > The plt observed a fuel spill on the ground as a result of refueling overflow. He attempted to start the engines & an explosion & fire resulted. - [NTSB LAX86LA227](https://openairdocs.org/ntsb/LAX86LA227.md): Bellanca 7ACA · Lompoc, CA · Accident · Minor injuries · Limited investigation · Final report · May 21, 1986 · N9158L · Substantial damage > The bellance champion went out of control an collided with two other parked acft after a hand propped start. The plt indicated that the acft was tied down with two chains attached to each of the wings at one end and to a cable that stretched across the ramp… - [NTSB DEN86LA132](https://openairdocs.org/ntsb/DEN86LA132.md): Cessna 152 · Salt Lake City, UT · Accident · No injuries · Limited investigation · Final report · May 11, 1986 · N53345 · Destroyed > Acft carburetor had been removed for maintenance and sign posted in acft to this effect. Student plt called to schedule acft and was put in another acft. Scheduler said plt was told acft was out of service but plt claimed he did not hear this. Plt met flt… - [NTSB FTW86IA078](https://openairdocs.org/ntsb/FTW86IA078.md): Mcdonnell Douglas DC-10-10 · Dallas/Ftw Apt, TX · Incident · Minor injuries · Incident investigation · Final report · May 7, 1986 · N109AA · No damage > The crew stated that during an attempted start the no. 1 eng failed to gain ignition during the prescribed 25 sec limit and that they aborted the start. Shortly thereafter, grnd pers reported that the eng had developed a tail pipe fire. Following emerg… - [NTSB MIA86LA147](https://openairdocs.org/ntsb/MIA86LA147.md): Hughes 269C · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · May 4, 1986 · N8993F · Substantial damage > The plt stated that as he was landing on a dolly, the helicopter experienced ground resonance & began to shake violently. It then rolled over on its side, causing the main rotor blades to strike the tail boom & the ground. - [NTSB FTW86FA066](https://openairdocs.org/ntsb/FTW86FA066.md): Grumman G164A · Hankamer, TX · Accident · 2 fatal · Field investigation · Final report · Apr 15, 1986 · N8751H · 2 aircraft · Destroyed > Two Grumman ag cats operated by the same air service collided in mid air. The accident occurred as one was departing and the other was returning to a temporary air strip adjacent to the fields they were fertilizing. Witnesses indicated that both pilot… - [NTSB CHI86LA109](https://openairdocs.org/ntsb/CHI86LA109.md): Cessna 152 · Wonder Lake, IL · Accident · No injuries · Limited investigation · Final report · Mar 21, 1986 · N49421 · Substantial damage > The starter would not engage, so the plt tied down the tail & hand propped the acft to start the eng, but did not use chocks. After the eng started, the acft rolled forward, slipped loose from the rear tie-down & ran into a pile of i-beams. A post acdnt exam… - [NTSB FTW86LRA10](https://openairdocs.org/ntsb/FTW86LRA10.md): Cessna 150L · Houston, TX · Accident · Serious injuries · Final report · Mar 1, 1986 · N19271 · No damage > The acft failed to start so the CFI got out to turn the prop. The mag switch was left on and the eng fired as the CFI moved the prop blade. The CFI was struck by the blade and serously injured. - [NTSB CHI86LA093](https://openairdocs.org/ntsb/CHI86LA093.md): Beech C23 · Elkhart, IN · Accident · No injuries · Limited investigation · Final report · Feb 27, 1986 · N5150M · Destroyed > The plt was unable to start the acft eng and got out to pull the prop through by hand. The magneto switch had been left in the both position and the eng started as the passenger primed the eng while the plt pulled the prop through. The plt was unable to stop… - [NTSB MIA86IA072](https://openairdocs.org/ntsb/MIA86IA072.md): Boeing 727-225 · New York, NY · Incident · No injuries · Incident investigation · Final report · Feb 5, 1986 · N812EA · Minor damage > While on walk around inspection the flight crew noticed a burned through area on the number one engine outboard cowling. The engine was removed from service and disassembled and examined. The fan duct and the engine combustion outer liner were also burned… Next page: https://openairdocs.org/ntsb-phases/150/cases.md?page=22 ## 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=21 --- 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.