# 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 20 of 42 · 2,085 cases ## Cases, newest first - [NTSB CHI88LA089](https://openairdocs.org/ntsb/CHI88LA089.md): Piper PA-22-150 · Muncie, IN · Accident · Minor injuries · Limited investigation · Final report · Mar 27, 1988 · N7725D · Substantial damage > When the pilot found that the battery would not start the aircraft, he elected to hand start it. His wife, a non-pilot passenger, was in the aircraft when it started. She attempted to close the throttle, however opened it and the aircraft began to move… - [NTSB FTW88LA082](https://openairdocs.org/ntsb/FTW88LA082.md): Sikorsky S-76A · Offshore Oil · Accident · Serious injuries · Limited investigation · Final report · Mar 24, 1988 · N1547N · No damage > After landing on the platform, the copilot moved the power levers to flight idle and set the main rotor blade tip path plane to the height normally used. When an enplanning passenger came up the stairs onto the platform, he was struck on the head by the main… - [NTSB NYC88LA111](https://openairdocs.org/ntsb/NYC88LA111.md): Beech 23 · Rutland, VT · Accident · Minor injuries · Limited investigation · Final report · Mar 20, 1988 · N8722M · Substantial damage > Prior to leaving the aircraft to hand prop the engine, the pilot checked the throttle setting and set the brakes. He told his passenger (his wife) to pull back on the throttle when the engine started, however she was unable to do so and the aircraft began… - [NTSB ATL88IA113](https://openairdocs.org/ntsb/ATL88IA113.md): Cessna 172B · Elizabethton, TN · Incident · No injuries · Incident investigation · Final report · Mar 14, 1988 · N7609X · Minor damage > Due to a low charge in the battery, the plt elected to start the eng by hand propping, so he could program the loran for a later flt. He began hand propping with the tail & left wing tied down. After the eng started, the tiedown for the tail pulled loose &… - [NTSB SEA88LA075](https://openairdocs.org/ntsb/SEA88LA075.md): Piper J-3 · Newberg, OR · Accident · No injuries · Limited investigation · Final report · Mar 7, 1988 · N98028 · Destroyed > The pilot had not flown for over five years and was doing multiple touch and goes in order to prepare for his biennial flight review. While on a landing rollout the engine ceased operating. The pilot exited the aircraft and began hand propping the engine. The… - [NTSB MIA88LA123](https://openairdocs.org/ntsb/MIA88LA123.md): Hawker Siddeley HS-748 · St Thomas · Accident · No injuries · Limited investigation · Final report · Mar 3, 1988 · VPLVN · Substantial damage > The captain of air bvi flight BL-222 stated as they were waiting for clearance to taxi, they encountered the jet blast from American airlines flight 626 as it taxied from its gate. The rudder of the HS-748 was dmgd. The American airlines aircraft was unaware… - [NTSB MKC88LA057](https://openairdocs.org/ntsb/MKC88LA057.md): Morane-Saulnier F1-156C · Pine Bluff, AR · Accident · No injuries · Limited investigation · Final report · Feb 27, 1988 · N44FS · Substantial damage > The pilot, while hand-propping the acft for a personal flt, started the engine. The cockpit was unattended. He was assisted by two ground crewmembers that were holding onto the wing struts. After starting, the engine progressively developed more power, and… - [NTSB MKC88LA050](https://openairdocs.org/ntsb/MKC88LA050.md): Cessna 182RG · Texarkana, AR · Accident · No injuries · Limited investigation · Final report · Feb 9, 1988 · N756FF · Substantial damage > The PIC claimed he was unable to start the aircraft normally. He said he couldn't remember if he properly secured the acft before attempting to prop start. As he pulled the propeller through, the acft eng revved up to a high RPM. The PIC claimed there was a… - [NTSB BFO88LA017](https://openairdocs.org/ntsb/BFO88LA017.md): Cessna 177 · Petersburg, VA · Accident · Minor injuries · Limited investigation · Final report · Feb 6, 1988 · N313AC · Substantial damage > The plt hand-propped the engine when he was unable to start it using the starter. The acft had just been refueled and it was standing next to the fuel pumps. The plt pushed the acft away from the pumps before he tried to hand-prop it. After the third… - [NTSB NYC88LA065](https://openairdocs.org/ntsb/NYC88LA065.md): Bell 206 · Holmdel, NJ · Accident · Serious injuries · Limited investigation · Final report · Jan 14, 1988 · N3NJ · Minor damage > The pilot had just landed the helicopter from a speed survey of garden state parkway and was in idle. The passenger/police officer deplaned and walked to the rear of the aircraft and was struck by the tail rotor blade receiving serious injuries. - [NTSB CHI88LA052](https://openairdocs.org/ntsb/CHI88LA052.md): Piper PA-28-181 · Mankato, MN · Accident · No injuries · Limited investigation · Final report · Jan 14, 1988 · N713LS · Substantial damage - [NTSB FTW88LA050](https://openairdocs.org/ntsb/FTW88LA050.md): Mcdonnell Douglas DC-10 · Dfw Airport, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 1988 · N142AA · No damage > Unexpected opening of the IL door, which caught the passenger between it and the bulkhead as the door moved inward and upward. A secondary cause was the failure of the flight attendants to follow company procedures requiring them to guard all entry doors… - [NTSB CHI88LA042](https://openairdocs.org/ntsb/CHI88LA042.md): Cessna 172K · Converse, IN · Accident · Serious injuries · Limited investigation · Final report · Jan 10, 1988 · N46701 · No damage > The plt had flown one closed circuit pattern of the local arpt and landed to pick up two additional passengers. Purpose of the local flight was for sightseeing. The acft was parked with engine at idle. One boarding passenger approached the acft from the left… - [NTSB DEN88LA045](https://openairdocs.org/ntsb/DEN88LA045.md): Raven Rally RX7 · Dona Ana, NM · Accident · No injuries · Limited investigation · Final report · Dec 30, 1987 · N40364 · Substantial damage > The commerical plt was conducting a sightseeing flight in his balloon. After a one and one half hour flight, he landed beside a paved road. The envelope collapsed over a power line. The ground crewman somehow contacted the balloon and was electrically… - [NTSB LAX88LA074](https://openairdocs.org/ntsb/LAX88LA074.md): Piper PA-32R-300 · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Dec 22, 1987 · N75397 · 2 aircraft · Substantial damage > While taxiing after landing, N911E was instructed to taxi to a position and hold, en route to that position, the acft collided with N75397 that was also holding in the same position. The plt of N911E stated that he did not see the acft due to moisture that… - [NTSB NYC88LA058](https://openairdocs.org/ntsb/NYC88LA058.md): Cessna 182 · Hammonton, NJ · Accident · No injuries · Limited investigation · Final report · Dec 19, 1987 · N3041Y · Destroyed > The aircraft had taxied to the runup area and during this process of engine runup, the pilot stated that the engine was running rough on one magneto but smooth on the other. The carburetor mixture was leaned but the engine quit. When an attempt to restart was… - [NTSB MKC88LA029](https://openairdocs.org/ntsb/MKC88LA029.md): Piper PA-28-140 · Osceola, AR · Accident · No injuries · Limited investigation · Final report · Dec 16, 1987 · N1595J · Destroyed > The airplane was being jump-started from an automobile. The flight instructor left for some equipment when the student called him back and said there was smoke in the cabin. The airplane started to burn and was demolished. The student stated there was a… - [NTSB MKC88FA028](https://openairdocs.org/ntsb/MKC88FA028.md): Aero Commander 680FL · Kansas City, MO · Accident · No injuries · Field investigation · Final report · Dec 16, 1987 · N6509V · 2 aircraft · Substantial damage > At 2108:57 ea flt 275(EA275) a Boeing 727, was cleared to takeoff on runway 19 and at 2110:24 N6509V, an Aero Commander,was cleared to taxi into position and hold. N6509V entered runway 19 near mid-field at taxiway A-3 without advising the tower of his intent… - [NTSB ATL88LA065](https://openairdocs.org/ntsb/ATL88LA065.md): Grumman American AA-5 · Elizabethtown, KY · Accident · No injuries · Limited investigation · Final report · Dec 16, 1987 · N7151L · Substantial damage > After a short stop btn flts, the battery was too weak to crank the eng. The plt elected to hand-prop the eng while his non-rated pax held the brakes. He briefed the pax on the proper procedure. He had previously allowed the pax to operate the brakes while… - [NTSB MKC88LA024](https://openairdocs.org/ntsb/MKC88LA024.md): Cessna 182Q · Coffeyville, KS · Accident · Minor injuries · Limited investigation · Final report · Dec 11, 1987 · N735SV · Substantial damage > While trying to start the acft with a low battery, PIC exited the acft and pulled the propeller one quarter of a turn to get it past the compression cycle. Engine started with pax aboard and proceeded to taxi. PIC was unable to stop the acft, and pax, after… - [NTSB MKC88IA025](https://openairdocs.org/ntsb/MKC88IA025.md): Bell 206L-3 · Little Rock, AR · Incident · Minor injuries · Incident investigation · Final report · Dec 10, 1987 · N86CH · Destroyed > An EMS helo was consumed in a fire while parked at a hospital heliport. The helo had recently returned fm a medevac flt and the on-board patient oxygen pressure was low. Two respiratory therapists participated in refilling the system after the flt. The system… - [NTSB DEN88LA034](https://openairdocs.org/ntsb/DEN88LA034.md): Cessna 177RG · Great Falls, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 6, 1987 · N8035G · Minor damage > The private plt was preparing for departure on an IFR flight plan. After finding that the starter would not operate properly, the plt tried to manually repositon the propeller. The ignition was still on and the engine fired. The propeller struck the plt's… - [NTSB SEA88LA027](https://openairdocs.org/ntsb/SEA88LA027.md): Cessna 172M · Tacoma, WA · Accident · No injuries · Limited investigation · Final report · Nov 27, 1987 · N9134H · 2 aircraft · Substantial damage > The Cessna was at the runup area for runway 35 preparing to do his runup. Three pitts aircraft were taxiing abreast of each other, when one of the pitts's propeller struck the right wingtip of the Cessna causing substantial damage to the Cessna and minor… - [NTSB LAX88FA057](https://openairdocs.org/ntsb/LAX88FA057.md): Boeing 737-387 · Los Angeles, CA · Accident · Serious injuries · Field investigation · Final report · Nov 25, 1987 · N383AU · No damage > The Boeing 737-387, N383AU, operating as usair flt 20, a regularly scheduled domestic flight, returned to lax shortly after takeoff, when the capt was advised of a bomb threat. After landing on rwy 24L, the capt parked the airplane on the west end of the rwy.… - [NTSB FTW88LA031](https://openairdocs.org/ntsb/FTW88LA031.md): Cessna 150 · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Nov 24, 1987 · N6463F · Substantial damage > The pilot was attempting to start the unsecured aircraft by hand-propping it. The aircraft started and rolled forward striking a fuel truck, damaging the left wing, fuselage, and propeller. - [NTSB MIA88LA037](https://openairdocs.org/ntsb/MIA88LA037.md): Mandley Steen Skybolt · Placida, FL · Accident · No injuries · Limited investigation · Final report · Nov 16, 1987 · N44JM · Destroyed > When attempting to start the eng the plt heard it backfire & then observed smoke coming from under the eng cowling. He then immediately exited the acft & left the scene to summon the fire department. He later returned to find the aircraft consumed by fire.… - [NTSB ATL88IA036](https://openairdocs.org/ntsb/ATL88IA036.md): Lockheed L-188C · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Nov 14, 1987 · N861U · Minor damage > After two aborted takeoffs for a RPM fluctation problem at takeoff pwr, the crew retd to the cargo ramp. They parked the acft, with engines running, adjacent to the gnd pwr cart used for starting the engines. The pwr cart had been left unattended with the… - [NTSB NYC88LA056](https://openairdocs.org/ntsb/NYC88LA056.md): Piper PA-28R-201 · Beaver Falls, PA · Accident · Serious injuries · Limited investigation · Final report · Nov 11, 1987 · N8364N · No damage > During hand-propping of Piper PA-28R, the passenger slipped and fell into the turning prop. He received a serious head injury. - [NTSB MIA88LA033](https://openairdocs.org/ntsb/MIA88LA033.md): Piper PA-23-250 · Miami, FL · Accident · No injuries · Limited investigation · Final report · Nov 10, 1987 · N5086Y · Destroyed > Plt stated that shortly after starting the left engine he heard an explosion and saw flame spreading from the accessory area of the left engine toward the left wing tip and the cabin. He shut down the engine by turning off the magnetos and he and his… - [NTSB CHI88LA021](https://openairdocs.org/ntsb/CHI88LA021.md): Piper PA-28-161 · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Nov 7, 1987 · N8253E · 2 aircraft · Substantial damage > The plt of north American P-51D, N6341T, was southbound on twy alpha as the plt of Piper PA-28 cherokee, N8253E, taxied from the run-up area to the hold line for rwy 33, which was near the intxn of twys alpha & india. The plt of the tail- wheel equipped P-51… - [NTSB LAX88DUQ01](https://openairdocs.org/ntsb/LAX88DUQ01.md): Stits Elkins 85 · Camarillo, CA · Accident · 1 fatal · Final report · Oct 25, 1987 · N72P · Substantial damage > During the starting procedures for a local flight, the pilot had chocked the wheels and was hand-propping the engine. After several tries, the engine started. The airplane jumped the chocks and the pilot moved to the right wing, attempting to stop the… - [NTSB LAX88LA035](https://openairdocs.org/ntsb/LAX88LA035.md): Piper PA-22-160 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Oct 18, 1987 · N8779D · Substantial damage > The pilot reported that the engine would not start by pressing the starter so he decided to hand prop the engine. After several attempts the engine finally started. The engine immediately increased power and the aircraft jumped the chocks. The non-pilot… - [NTSB MIA88LA010](https://openairdocs.org/ntsb/MIA88LA010.md): Beech A-90 · Ft Lauderdale, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 12, 1987 · N601TA · Substantial damage > After the plt placed the master switch on to start the engines the landing gear collapsed. He stated that the passenger, in the co-plt seat, bumped the landing gear handle into the up position. The passenger stated that he did not. Insp of the acft revealed… - [NTSB MIA87LA265](https://openairdocs.org/ntsb/MIA87LA265.md): CASA 212-200 · San Juan, PR · Accident · Serious injuries · Limited investigation · Final report · Sep 30, 1987 · N436CA · No damage > The co-plt was helping the passengers de-plane while the plt remained in the acft with the engines winding down after shutdown. The plt stated that he observed a commotion outside the acft and shortly thereafter exited it. He then realized that an individual,… - [NTSB NYC87LA266](https://openairdocs.org/ntsb/NYC87LA266.md): Cessna 152 · Bridgeport, CT · Accident · No injuries · Limited investigation · Final report · Sep 29, 1987 · N93193 · Substantial damage > The plt of Cessna 152, N93193, taxied for takeoff with the intentions of using rwy 24. At about the same time, a navy H-53 (Sikorsky) helicopter entered a pattern to land on rwy 24. With the heavy helicopter apchg to land, the Cessna plt accepted an offer to… - [NTSB NYC87LA271](https://openairdocs.org/ntsb/NYC87LA271.md): Piper PA-28-180 · Waynesburg, PA · Accident · No injuries · Limited investigation · Final report · Sep 26, 1987 · N9122J · Substantial damage > The pilot said he flooded the engine of the Piper PA-28-180 and decided to pull the prop through a couple of times by hand. He said he thought he had turned the mags off, pulled the mixture to idle cut-off, and set the parking brake. When he had pulled the… - [NTSB ATL87LA254](https://openairdocs.org/ntsb/ATL87LA254.md): Aerostar 600 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Sep 11, 1987 · N8073J · 2 aircraft · Substantial damage > The scheduled domestic all cargo flt was taxiing from the ramp to the rwy behind another company acft when the plt suddenly realized that the lead acft was not moving. The plts attempts to stop the acft were not successful. The stopped acft was substantially… - [NTSB NYC87LA256](https://openairdocs.org/ntsb/NYC87LA256.md): Cessna 310N · Williamsport, PA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1987 · N4166Q · Substantial damage > After landing, the cargo was unloaded & the acft was prepared for departure. The plt stated the preflight was normal & satisfactory. He rprtd that when the left eng was started, he heard a loud 'pop' & observed 'flame traces and smoke.' He immediately shut… - [NTSB ATL87LA252](https://openairdocs.org/ntsb/ATL87LA252.md): Bell 47G-2A · Mc Intosh, AL · Accident · Serious injuries · Limited investigation · Final report · Sep 8, 1987 · N1200W · Destroyed > The helicopter was being used to set fires to burn off underbrush in a commercial forest prior to cutting of trees. The plt landed the helicopter on a mobile transport trailer at the completion of the day's work. The helicopter engine had been shut off and… - [NTSB CHI87IA201](https://openairdocs.org/ntsb/CHI87IA201.md): Mcdonnell Douglas DC-8-71 · Chicago, IL · Incident · Minor injuries · Incident investigation · Final report · Sep 3, 1987 · N8078U · No damage > Smoke detected in the cabin resulted in an evacuation of the aircraft just after being pushed back from the jet-way. Subsequent investigation established that a malfunctioning pack valve had caused the air-conditioning system to overheat causing the smoke.… - [NTSB SEA87LA167](https://openairdocs.org/ntsb/SEA87LA167.md): Luscombe 8A · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Aug 17, 1987 · N2507K · Substantial damage > Due to a low battery charge, the plt elected to hand prop the acft to start the eng. He rprtd the eng became flooded, so he shut off the mags & opened the throttle, to clear the eng while hand turning the prop. He then turned on the master sw & mags, but… - [NTSB BFO87FA053](https://openairdocs.org/ntsb/BFO87FA053.md): Boeing 747-200B · Washington, DC · Accident · 1 fatal · Field investigation · Final report · Aug 11, 1987 · JA182 · No damage > A flight attendant fell from the acft during opening of the L5 door. The f/a was helping a company ground person, who was outside on the boarding step. The boarding step was not against the acft but about 1 ft away from it. When the door was opened, the f/a… - [NTSB CHI87FA185](https://openairdocs.org/ntsb/CHI87FA185.md): Cessna 120 · Oshkosh, WI · Accident · Serious injuries · Field investigation · Final report · Aug 5, 1987 · N76249 · No damage > The plt was taxiing out of the antique/classic camping area at Oshkosh with the assistance of wing walkers when he stopped to permit the pax (his wife) to perform an errand. The pax deplaned & went under the outer 1/3 of the wing strut, then walked back into… - [NTSB LAX87LA288](https://openairdocs.org/ntsb/LAX87LA288.md): Luscombe 8A · Selma, CA · Accident · No injuries · Limited investigation · Final report · Jul 31, 1987 · N1017K · Substantial damage > A Luscombe 8A collided with two parked airplanes after a hand propped start. The student pilot started the aircraft engine without the brakes set, with no chocks, and with no one in the cockpit. Once the engine started, the aircraft subsequently collided with… - [NTSB DEN87LA189](https://openairdocs.org/ntsb/DEN87LA189.md): Aerospatiale SA316B · Red Lodge, MT · Accident · No injuries · Limited investigation · Final report · Jul 19, 1987 · N48184 · Substantial damage > The plt said he was getting ready to take off from a 9400-FT MSL landing zone a top a mountain 7 mi ssw of Red Lodge, MT. The plat said the helicopter was positioned on a slight north-south slope and pointed towards the west. The wind was from the south… - [NTSB MIA87LA202](https://openairdocs.org/ntsb/MIA87LA202.md): Piper PA-28 · Miami, FL · Accident · Minor injuries · Limited investigation · Final report · Jul 9, 1987 · N6852J · Substantial damage > A us customs blackhawk helicopter intercepted the acft after mistakenly identifing it as a suspected drug smuggling acft. After the acft landed at a gliderport on the edge of the everglades, the helicopter swooped down in the vicinity of the acft & blew it… - [NTSB LAX87FA257](https://openairdocs.org/ntsb/LAX87FA257.md): Beech A60 · Santa Rosa, CA · Accident · 2 fatal · Field investigation · Final report · Jul 7, 1987 · N7485D · Destroyed > Pilot's failure to maintain adequate airspeed on final approach which resulted inthe aircraft stalling. - [NTSB BFO87LA045](https://openairdocs.org/ntsb/BFO87LA045.md): Beech A23-19 · Cambridge, MD · Accident · No injuries · Limited investigation · Final report · Jul 6, 1987 · N5775V · Substantial damage > When the aircraft failed to start the pilot set the throttle, insured the aircraft was tied down and attempted to start the aircraft by hand propping. The aircraft started immediately, broke both tie-down ropes, traveled across the field into a ditch and… - [NTSB SEA87IA127](https://openairdocs.org/ntsb/SEA87IA127.md): British Aerospace BAE-146-100 · Las Vegas, NV · Incident · Minor injuries · Incident investigation · Final report · Jun 28, 1987 · N146AP · Minor damage > During pushback and while starting the #4 engine the auxiliary power unit which provides electrical power to the engine starter tripped off the line. The loss of electrical power to the engine starter resulted in a hung start at approximately 25% N2 RPM.… - [NTSB LAX87LA243](https://openairdocs.org/ntsb/LAX87LA243.md): Boeing 737-277 · Los Angeles, CA · Accident · No injuries · Limited investigation · Final report · Jun 23, 1987 · N184AW · 2 aircraft · Substantial damage > Failure of the qualified mechanic to insure the operation of the aircraft brakes prior to taxiing and his failure to utilize the emergency brake system to prevent the collision. Contributing to this accident was the decision of airline maintence supervisors… Next page: https://openairdocs.org/ntsb-phases/150/cases.md?page=21 ## 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=20 --- 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.