# 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 23 of 42 · 2,085 cases ## Cases, newest first - [NTSB MIA85LA033](https://openairdocs.org/ntsb/MIA85LA033.md): Cessna 172C · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Nov 16, 1984 · N1554Y · Destroyed > According to the plt, after he was unsuccessful in starting the acft eng he switched off the magnetos and master switch and exited the acft. Later, during the process of moving the propeller to a position to clear a hand toe bar, the acft started, taxied… - [NTSB ATL85LA031](https://openairdocs.org/ntsb/ATL85LA031.md): Hughes 369HS · Hogansville, GA · Accident · Serious injuries · Limited investigation · Final report · Nov 9, 1984 · N505WW · Minor damage > A deplaning passenger walked into the rotating tail rotor. The passenger had been walked away from the acft by the plts brother but she returned on her own and was struck by the tail rotor. - [NTSB MIA85LA013](https://openairdocs.org/ntsb/MIA85LA013.md): Piper PA-28-161 · West Palm Beach, FL · Accident · Serious injuries · Limited investigation · Final report · Oct 19, 1984 · N5926V · No damage > The plt stated that while standing on the ramp with the eng running in preparation for flt, they were having difficulty closing the acft door. A passenger got out to look for help but once out of the acft walked along the rt wing leading edge up to the eng… - [NTSB CHI85LA018](https://openairdocs.org/ntsb/CHI85LA018.md): Hughes 500 · Grosse Ile, MI · Accident · No injuries · Limited investigation · Final report · Oct 18, 1984 · N9034F · Substantial damage > Plt attempted to start helicopter with main rotor blades tied down. - [NTSB CHI84LA397](https://openairdocs.org/ntsb/CHI84LA397.md): Beech D 35 · Alexandria, MN · Accident · No injuries · Limited investigation · Final report · Sep 21, 1984 · N2930B · Substantial damage > The acft was started with the throttle open after refueling. The plt said the acft collided with a gas hose before he could get the throttle reduced. - [NTSB LAX84LA478](https://openairdocs.org/ntsb/LAX84LA478.md): Agusta A109 · Clifton, AZ · Accident · No injuries · Limited investigation · Final report · Sep 12, 1984 · N57BL · Substantial damage > The plt reported that he landed firmly on the ground at the main ramp & went into the 2 min cool down mode for eng shutdown. He stated that immediately after the power levers were retarded to idle, he felt a slight lateral movement of the controls which was… - [NTSB MIA84LA248](https://openairdocs.org/ntsb/MIA84LA248.md): Bell 206L-1 · West Palm Bch, FL · Accident · No injuries · Limited investigation · Final report · Sep 4, 1984 · N29GW · Substantial damage > The plt stated that he had flown the acft from one fixed base operator on the arpt to another to position the acft. He stated that he put friction on the cyclic control but not the collective control, reduced throttle to flt idle, and exited the acft. He was… - [NTSB BFO84IA005](https://openairdocs.org/ntsb/BFO84IA005.md): Boeing 727-22 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Sep 3, 1984 · N7078U · 2 aircraft · Minor damage > Mishap acft, new york air flight 306 (nya 306) followed a Boeing 727, united flight 827 (ual 827), to the run-up area and positioned in the #2 spot for takeoff, anticipating ual 827 would receive takeoff clearance first. Nya 306 was cleared first for takeoff… - [NTSB NYC84FNA03](https://openairdocs.org/ntsb/NYC84FNA03.md): Piper PA-28-181 · New Bedford, MA · Accident · Serious injuries · Final report · Sep 1, 1984 · N5399F · No damage > The rt front seat pass'g exited the acft via the rt door and went forward over the leading edge of the wing while the acft engine was idling at aprx 1200 RPM. The rotation prop struck and injuried the pass'g with serious chest, back and arm lacerations. The… - [NTSB FTW84LA369](https://openairdocs.org/ntsb/FTW84LA369.md): Robinson R-22 · Austin, TX · Accident · No injuries · Limited investigation · Final report · Aug 27, 1984 · N9067B · Substantial damage > After lndg the plt exited the acft to assist deplaning of the pax. The engine was still running. The plt heard a surge of engine power followed by the acft rotating and colliding with a parked car. Examination of the acft disclosed that the collective balance… - [NTSB CHI84LA361](https://openairdocs.org/ntsb/CHI84LA361.md): Beech V35B · Eden Prairie, MN · Accident · No injuries · Limited investigation · Final report · Aug 24, 1984 · N1QR · Substantial damage > Plt reported that after operating the fuel boost pump on pre-flt, he exited the acft to turn the prop by hand. During a telephone interview, he stated he could not recall removing the ignition key. After pulling the prop through 1/4 turn, the eng started and… - [NTSB MIA84LA235](https://openairdocs.org/ntsb/MIA84LA235.md): Cessna 152 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Aug 22, 1984 · N46271 · 2 aircraft · Substantial damage > The tailwheel equipped acft collided with a stopped Cessna while taxiing to takeoff. The Cessna was in the runup area. The Boeing A75 acft plt said he failed to see the parked acft. - [NTSB NYC84LA276](https://openairdocs.org/ntsb/NYC84LA276.md): Cessna 310II · Newark, NJ · Incident · No injuries · Limited investigation · Final report · Aug 15, 1984 · N5338C · No damage > An unemployed person was trying to help load an acft. In noticing that a bill of laden had been left off the cargo he ran toward the acft which had, by this time, started engines. The plt said he saw the running man and shoved the mixtures to cut off the… - [NTSB MKC84LA239](https://openairdocs.org/ntsb/MKC84LA239.md): Piper PA-28-140 · Mount Vernon, MO · Accident · Minor injuries · Limited investigation · Final report · Aug 4, 1984 · N57321 · Substantial damage > The acft rolled foward and collided with a metal hanger after the plt hand propped the acft to start it. The acft was tied at the tail and chocked with the plts oldest daughter on the foot brakes. In spite of these precautions the acft got away and hit the… - [NTSB CHI84LA327](https://openairdocs.org/ntsb/CHI84LA327.md): Gulfstream 690 · Detroit, MI · Accident · No injuries · Limited investigation · Final report · Aug 3, 1984 · N700CB · Substantial damage > On right engine start the right main landing gear collapsed. The gear handle was found in the down position after the accident. Functional and bench check of the actuating components revealed no discrepancies. - [NTSB CHI84FA292](https://openairdocs.org/ntsb/CHI84FA292.md): Cessna 182A · Henryville, IN · Accident · Serious injuries · Field investigation · Final report · Jul 13, 1984 · N6021B · Substantial damage > The aircraft's annual inspection was thirteen years overdue and the pilot had not logged any flight time inn almost one year. Twenty eight airworthiness directives had not been complied with. The engine quit shortly after take off, when the magneto coils… - [NTSB MIA84LA195](https://openairdocs.org/ntsb/MIA84LA195.md): Bell 206L-1 · Loiza, PR · Accident · Serious injuries · Limited investigation · Final report · Jun 27, 1984 · N5736K · Substantial damage > The plt had just landed at a shore site & the acft was parked with engine running when an unauthorized person walked into the tail rotor. The crew & passengers were still aboard the acft at the time of the accident. - [NTSB MKC84LA183](https://openairdocs.org/ntsb/MKC84LA183.md): Cessna 150H · Nebraska City, NE · Accident · No injuries · Limited investigation · Final report · Jun 24, 1984 · N22732 · Substantial damage > Unable to start the engine with the electrical starter the pilot elected to pull the propeller through by hand. With the magneto switch 'off' and a 2X6 inch board in front of one main landing gear tire the engine started when the propeller was rotated. The… - [NTSB ANC84FA092](https://openairdocs.org/ntsb/ANC84FA092.md): Maule M-5-235C · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Jun 17, 1984 · N6229M · Substantial damage > The acft traveled forward into a parked acft after the plt hand propped it to start the engine. A pax who had 'a few hours', according to the plt, was inside the acft to hold the foot brake pedals. The plt said the battery was too low tostart the acft engine… - [NTSB SEA84LA134](https://openairdocs.org/ntsb/SEA84LA134.md): Hughes 369D · Wrangell, AK · Accident · No injuries · Limited investigation · Final report · Jun 16, 1984 · N5133U · Substantial damage > The helicopter was parked with the eng running when it was struck by another acft, a Beech C-45G. Prior to the collision, the helicopter was at a low RPM; therefore, the plt was unable to move the helicopter out of the way. The Beech acft was being taxied… - [NTSB NYC84FHD04](https://openairdocs.org/ntsb/NYC84FHD04.md): Mooney M20 · Atlantic City, NJ · Accident · Serious injuries · Final report · Jun 11, 1984 · N9914S · No damage > The flt to Atlantic-city-bader field was uneventful, except the acft touched down hard during the landing. The plt taxied to the terminal & parked with the exit door facing the terminal. He elected not to shut down the eng since he intended to immediately… - [NTSB FTW84LA259](https://openairdocs.org/ntsb/FTW84LA259.md): Robinson R22 · Andrews, TX · Accident · Serious injuries · Limited investigation · Final report · May 31, 1984 · N9075Y · Substantial damage > The pilot stated that the helicopter was operating at 55 percent power on the gnd while awaiting the pax to board. The passenger walked into the tailrotor and received serious injuries. The plt stated that the company does not have safety procedures for… - [NTSB CHI84LA216](https://openairdocs.org/ntsb/CHI84LA216.md): Balloon Works Barnes Firefly 8-24 · Burnsville, MN · Accident · Serious injuries · Limited investigation · Final report · May 27, 1984 · N3679A · No damage > The Balloon landed without incident. According to the plt, the envelope was being deflated when a gust of wind tipped the basket. The plt said he saw a young boy with his leg under the basket. The plt lifted the edge of the basket by stepping out of it to… - [NTSB MIA84IA172](https://openairdocs.org/ntsb/MIA84IA172.md): Boeing 727-35 · Bahamas, Bahamas · Incident · No injuries · Incident investigation · Final report · May 24, 1984 · N4620 · No damage > While climbing thru FL 240, the aircrew noted that the #1 eng fire warning light illuminated. They secured the eng in accordance with the eng fire checklist procedure, then diverted for an unscheduled landing at miami, FL. An investigation revealed that the… - [NTSB ATL84LA170](https://openairdocs.org/ntsb/ATL84LA170.md): Cessna 172N · Nashville, TN · Accident · 1 fatal · Limited investigation · Final report · May 14, 1984 · N733GY · No damage > The plt reported that after he & his passengers were aboard the acft, the eng was running & ground control had cleared him to taxi when he discovered that the left main wheel was still chocked, preventing forward movement of the acft. He was setting his… - [NTSB NYC84FA159](https://openairdocs.org/ntsb/NYC84FA159.md): Piper PA-28-140 · North Andover, MA · Accident · No injuries · Field investigation · Final report · May 6, 1984 · N5385F · Destroyed > The plt stated to police that he was positioning the prop for a photo when the engine started and the airplane traveled 2500 ft unattended across the arpt before it became airborne and struck the rear of a commercial bldg that housed three businesses,… - [NTSB ANC84LA060](https://openairdocs.org/ntsb/ANC84LA060.md): Taylorcraft BC12-D · Talkeetna, AK · Accident · No injuries · Limited investigation · Final report · May 3, 1984 · N95120 · Substantial damage > The plt was repositioning the acft from a private strip near palmer, AK, to his property near Talkeetna, AK. After stopping at the Talkeetna arpt, he was hand propping the acft when the eng started & the acft began moving. The plt tried to turn off the mags,… - [NTSB MIA84LA141](https://openairdocs.org/ntsb/MIA84LA141.md): Cessna 152 · Vero Beach, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 17, 1984 · N89948 · Destroyed > A truck ran into an acft waitng to takeoff. The acft was on the runup pad and the vehicle driver was distracted by an acft taking off. The control tower was not in service. - [NTSB LAX84LA293](https://openairdocs.org/ntsb/LAX84LA293.md): Piper PA-28-236 · Concord, CA · Accident · No injuries · Limited investigation · Final report · Apr 2, 1984 · N81300 · Substantial damage > While the plt was waiting for a takeoff clearance, tower personnel notified him that the acft appeared to be on fire. The plt shut down the eng & exited the acft. The fire developed, but was mainly confined to the eng compartment. It was promptly extinguished… - [NTSB FTW84LA166](https://openairdocs.org/ntsb/FTW84LA166.md): Bell 206L-1 · W Camrn Blk 624 · Accident · 4 fatal · Limited investigation · Final report · Mar 12, 1984 · N1076N · Destroyed > The pilot and passengers boarded the helicopter in an attempt to fly off the rig before the passage of a squall line. The acft engine was being started when the acft was blown off the platform and into the water by a gust of wind. The acft impacted the sea… - [NTSB ATL84FA118](https://openairdocs.org/ntsb/ATL84FA118.md): Piper PA 31-350 · Atlanta, GA · Accident · No injuries · Field investigation · Final report · Mar 7, 1984 · N62849 · 2 aircraft · Substantial damage > The aircrews of a Piper PA-31, N62849, & a Piper PA-30, N7047Y, proceeded to taxi at dawn from a cargo ramp to rwy 26. Their taxi route was down a parallel taxiway. The PA-31 plt stopped at a glide slope hold line which was located near the end of the… - [NTSB NYC84FHM06](https://openairdocs.org/ntsb/NYC84FHM06.md): Cessna 210N · Millbrook, NY · Accident · Serious injuries · Final report · Jan 9, 1984 · N6512Y · No damage > Plt was injured while hand propping the acft. - [NTSB CHI84LA081](https://openairdocs.org/ntsb/CHI84LA081.md): Piper PA-28R-201T · East St. Louis, IL · Accident · Serious injuries · Limited investigation · Final report · Jan 9, 1984 · N6372C · No damage > The pilot was found lying on the ramp under the front of the aircraft, bleeding profusely from scalp wounds. Although he was unable to recall the circumstances preceding the accident, he noted that it would not have occurred had he not attempted to 'pull the… - [NTSB FTW84LA105](https://openairdocs.org/ntsb/FTW84LA105.md): Bell 206B III · Vermillion 255b · Accident · Serious injuries · Limited investigation · Final report · Dec 28, 1983 · N2145C · Minor damage > While waiting for passengers to board the helicopter the plt heard and felt something hit the tail rotor. The eng was immediately shut down and it was revealed that a passenger had walked into the tail rotor. The passenger was was well experienced in… - [NTSB MKC84FA046](https://openairdocs.org/ntsb/MKC84FA046.md): Cessna 182G · Olathe, KS · Accident · Serious injuries · Field investigation · Final report · Dec 26, 1983 · N2123R · No damage > The plt was struck on the leg by the acft propeller as he pulled the propeller through during preflight. The eng had been preheated in an enclosed hanger due to the frigid temperatures. The plt stated he primed the engine and put the keyin the ignition prior… - [NTSB LAX84LA122](https://openairdocs.org/ntsb/LAX84LA122.md): Boeing 737-200 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Dec 25, 1983 · N133AW · No damage > The acft was standing with engines running and a baggage handler was blown off his feet when he went behind the acft. The acft had been called back to the ramp because an access door was open. The baggage handler approaching the acft fromthe rear to close the… - [NTSB ATL84LA072](https://openairdocs.org/ntsb/ATL84LA072.md): Cessna 182B · Spartanburg, SC · Accident · Serious injuries · Limited investigation · Final report · Dec 21, 1983 · N2354G · No damage > The acft propeller struck a passenger approaching to board the acft. The plt had started the acft for warm-up prior to the boarding. The passenger stumbled approaching the acft and fell into the revolving propeller. - [NTSB MKC84FA036](https://openairdocs.org/ntsb/MKC84FA036.md): Beech A36 · Kansas City, MO · Accident · No injuries · Field investigation · Final report · Dec 12, 1983 · N6416N · 2 aircraft · Substantial damage > The BE-A36 was holding short of rwy 18. The C-310 was taxiing to also hold short & collided with the BE-A36. The position & strobe lights on the BE-A36 were illuminated. The plt of the C-310 indicated that he did not see the BE-A36 because of what he… - [NTSB DEN84LA034](https://openairdocs.org/ntsb/DEN84LA034.md): Cessna 172N · Helena, MT · Accident · Serious injuries · Limited investigation · Final report · Dec 2, 1983 · N4818D · Minor damage > The acft propeller struck a passenger who was attemping to sweep snow off the acft. The plt's and passenger's version of mishap vary. The plt stated he instructed the passenger to stay away from the acft. The passenger stated the plt toldhim to sweep the snow… - [NTSB LAX84LA093](https://openairdocs.org/ntsb/LAX84LA093.md): Beech C24R · Monterey, CA · Accident · No injuries · Limited investigation · Final report · Nov 26, 1983 · N3824R · Substantial damage > Fire erupted in the eng compartment during the eng run-up. Investigaiton revealed that 7 of the 8 nuts securing the exhaust manifold to the cylinders were missing. The only nut present was loose but retained the #1 cyl exhaust tube. The #2 cyl exhaust tube,… - [NTSB DEN84LA033](https://openairdocs.org/ntsb/DEN84LA033.md): Cessna 172 · Yankton, SD · Accident · Serious injuries · Limited investigation · Final report · Nov 17, 1983 · N52419 · No damage > The plt stated the eng wouldn't start & he suspected a dead spot on the starter. He then asked a mechanic to rotate the prop. All switches were off except the battery switch. When the mechanic moved the prop the eng started & the prop struck the mechanic.… - [NTSB DEN84LA050](https://openairdocs.org/ntsb/DEN84LA050.md): Mitsubishi MU-2B-60 · Richfield, UT · Accident · Serious injuries · Limited investigation · Final report · Nov 5, 1983 · N477MA · No damage > The acft propeller struck a 12 year old male passenger after he deplaned. The accident occurred on an unlighted ramp at about 1930 hours MST. The boy had walked forward along the fuselage to look into the cockpit when he was hit. His father was in the… - [NTSB NYC84LA021](https://openairdocs.org/ntsb/NYC84LA021.md): Piper PA-28-181 · New Milford, CT · Accident · No injuries · Limited investigation · Final report · Nov 4, 1983 · N2222R · Destroyed > The pilot reported that as he was starting the engine, fire broke out. He attempted to put out the fire with on-board extinguishers, but failed. The acft was destroyed by fire. - [NTSB LAX84LA044](https://openairdocs.org/ntsb/LAX84LA044.md): Cessna TU206G · Reno, NV · Accident · 1 fatal · Limited investigation · Final report · Nov 3, 1983 · N756DG · No damage > The pilot's body was found under the front of the acft by the propeller. All cockpit controls were in the start positionand the acft was not chocked or tied down. The payroll checks the pilot was to deliver were found in the acft. - [NTSB NYC84LA005](https://openairdocs.org/ntsb/NYC84LA005.md): Cessna 172M · Toughkenamon, PA · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 1983 · N4333R · Substantial damage > The plt had difficulty in starting the eng & got a mechanic to be at the controls while he hand propped the acft. He had tried several times to start the eng, then tried with the throttle open. On that attempt, the eng started and the acft began to move… - [NTSB LAX84LA009](https://openairdocs.org/ntsb/LAX84LA009.md): North American SNJ-2 · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Oct 9, 1983 · N61563 · 2 aircraft · Substantial damage > A flt of 5 North American SNJ-2 acft were on a flt from long beach to Fresno, CA. By prior arrangement, the lead plt in N61563 was to handle the radio communication with ATC facilities. During arrival at Fresno, the local controller inquired whether the group… - [NTSB LAX83LA459](https://openairdocs.org/ntsb/LAX83LA459.md): Cessna 152 · Hawthorne, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 25, 1983 · N47048 · No damage > After landing at night, the plt taxied to an unlighted parking area & stopped. He stated that while he was looking for a parking space, his friends came out of the waiting room & 1 of them approached the right side of the acft. The plt said he saw his friend… - [NTSB FTW83IA438](https://openairdocs.org/ntsb/FTW83IA438.md): Boeing 727-223B · Dallas/Ft Worth, TX · Incident · Minor injuries · Incident investigation · Final report · Sep 23, 1983 · N897AA · No damage > After landing & taxi to the ramp while standing with one engine & the APU running smoke filled the cabine. The captain ordered an emergency evacuation which was accomplished. The origin and cause of the smoke is undetermined. - [NTSB LAX83FA444](https://openairdocs.org/ntsb/LAX83FA444.md): Cessna T210M · Santa Ana, CA · Accident · 1 fatal · Field investigation · Final report · Sep 19, 1983 · N8052M · Minor damage > After landing at night, the plt taxied to a non-illuminated ramp area & stopped to deplane the passenger, who held a student plt certificate. The purpose of the passenger deplaning in that area was for her to obtain a vehicle & meet the plt at the acft's… - [NTSB MIA83LA229](https://openairdocs.org/ntsb/MIA83LA229.md): Cessna 172I · Miami, FL · Accident · 1 fatal · Limited investigation · Final report · Sep 12, 1983 · N8366L · Minor damage > The acft landed at aprx 0215 EDT. After arriving at the ramp, the plt's wife exited from the acft thru the right door. She then walked in front of the acft & was struck by the propeller. The plt's wife was fatally injured & he was taken to a hospital & was… Next page: https://openairdocs.org/ntsb-phases/150/cases.md?page=24 ## 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=23 --- 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.