# NTSB investigations: Maneuvering 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 183 of 378 · 18,851 cases ## Cases, newest first - [NTSB ATL88DKG08](https://openairdocs.org/ntsb/ATL88DKG08.md): Sikorsky S-55B · Valdosta, GA · Accident · No injuries · Final report · Jun 16, 1988 · N6489 · Substantial damage - [NTSB DEN88DTM02](https://openairdocs.org/ntsb/DEN88DTM02.md): Eagle DW-1 · Enterprise, UT · Accident · No injuries · Final report · Jun 11, 1988 · N8807E · Destroyed > The plt reported that he had been going under a powerline that ran across the fld being treated. On the acdt pass he lost sight of the powerline and pulled up into the line. The visibility was unrestricted and the pass was being made north to south at mid… - [NTSB LAX88DUG04](https://openairdocs.org/ntsb/LAX88DUG04.md): Bushby Mustang II · Upland, CA · Accident · Serious injuries · Final report · Jun 10, 1988 · N1AZ · Minor damage > During a pleasure flight, while flying s turns and lazy eights, the canopy suddenly separated from the airplane. The airplane was landed without further incident. The canopy was not recovered. The reason for the separation was not determined. - [NTSB ATL88DLQ01](https://openairdocs.org/ntsb/ATL88DLQ01.md): Byron/Sorrell SNS-2 · Morehead, KY · Accident · No injuries · Final report · Jun 8, 1988 · N112CB · Substantial damage > Inflight separation of both propeller blades from the acft for undetermined reasons. - [NTSB NYC88FA158](https://openairdocs.org/ntsb/NYC88FA158.md): Piper PA-38-112 · Enon Valley, PA · Accident · 2 fatal · Field investigation · Final report · Jun 7, 1988 · N2317N · Destroyed > The aircraft was observed maneuvering at low altitude. The nose was observed to drop and a left rotation started. One witness said the rotation stopped before the aircraft disappeared behind a tree line. The aircraft caught fire within one minute of impact… - [NTSB MKC88LA107](https://openairdocs.org/ntsb/MKC88LA107.md): Grumman G-164B · Hazen, AR · Accident · No injuries · Limited investigation · Final report · Jun 7, 1988 · N8027K · Substantial damage > While performing an aerial application operation at dawn, the plt struck a levee. He attributed the acdt to low light intensity, a dirty windscreen and encountering his own wake turbulence. The main gear was sheared off, then the aircraft nosed down, slid for… - [NTSB DEN88DTE05](https://openairdocs.org/ntsb/DEN88DTE05.md): Piper PA-25-235 · Limon, CO · Accident · No injuries · Final report · Jun 7, 1988 · N8678L · Substantial damage > The plt reported that he was making his third swathrun when the eng quit. He attempted a forced landing but the acft nosed over. The plt said he had 15 gal of fuel on board at takeoff and had been airborne about 15 min. The FAA a/w insp who examined the… - [NTSB NYC88LA160](https://openairdocs.org/ntsb/NYC88LA160.md): Enstrom F-28C · Westerly, RI · Accident · No injuries · Limited investigation · Final report · Jun 5, 1988 · N580H · Substantial damage > The instructor pilot stated that after executing several straight-in and 180 degree autorotations they decided to attempt some hovering autorotations. After executing the first one successfully in a tailwind situation, the student initiated the second one,… - [NTSB LAX88DVM02](https://openairdocs.org/ntsb/LAX88DVM02.md): Bell 47G5 · Oceano, CA · Accident · Minor injuries · Final report · Jun 5, 1988 · N1316X · Substantial damage - [NTSB LAX88DVD04](https://openairdocs.org/ntsb/LAX88DVD04.md): Bellanca 8KCAB · Geyserville, CA · Accident · 1 fatal · Final report · Jun 5, 1988 · N5061W · Destroyed > During an aerobatic maneuver in front of family and friends the pilot entered an intentional spin starting at approximately 500 ft AGL. The aircraft collided with the ground in a nose low, wings level attitude. Witnesses stated that the aircraft did not… - [NTSB LAX88LA211](https://openairdocs.org/ntsb/LAX88LA211.md): Cessna 180 · Lakeport, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 4, 1988 · N9124C · Substantial damage > During a banner tow operation, the plt tried to release the banner. When the banner did not disconnect, the plt turned to see what the problem was. The airplane stalled and before the plt could regain control, it collided with the terrain. Inspection of the… - [NTSB DEN88DTK01](https://openairdocs.org/ntsb/DEN88DTK01.md): Eagle DW-1 · Ferney, SD · Accident · Serious injuries · Final report · Jun 4, 1988 · N8802Z · Destroyed > The ag plt reported that he encountered a 'dust devil' while in a climbing turn during a turnaround at the end of a swath run. He said he attempted to counter the turbulence enduced roll with appropriate flt control inputs but the acft did not recover and… - [NTSB DEN88FA119](https://openairdocs.org/ntsb/DEN88FA119.md): Gulfstream American AA-5A · Maljamar, NM · Accident · 2 fatal · Field investigation · Final report · Jun 2, 1988 · N1393R · Destroyed > While in slow flt at low level on a oil pipeline patrol demonstration flt, the acft entered a left turn and, according to witnesses, the nose suddenly dropped and the acft crashed in a vertical attitude. The acft was destroyed in the accident and both… - [NTSB ANC88FA065](https://openairdocs.org/ntsb/ANC88FA065.md): Cessna 172N · Hatcher Pass, AK · Accident · 3 fatal · Field investigation · Final report · Jun 2, 1988 · N3327E · Destroyed > The aircraft crashed at the 3100 foot level of a mountain Pass. The aircraft was destroyed by ground impact and fire, and the pilot and the two passengers were fatally injured. Witnesses near the crash site stated the aircraft was maneuvering very low above… - [NTSB MIA88LA186](https://openairdocs.org/ntsb/MIA88LA186.md): Continental Copters MK6B · Callahan, FL · Accident · No injuries · Limited investigation · Final report · Jun 1, 1988 · N9080T · Substantial damage > While maneuvering the helicopter during an aerial application flt the eng quit. During the autorotative landing the helicopter landed hard. Examination of the eng revealed the accessory drive gear, which is attached to the crankshaft by 6 AN-4A bolts with the… - [NTSB MIA88LA185](https://openairdocs.org/ntsb/MIA88LA185.md): Bost Pitts S-1C · Miami, FL · Accident · No injuries · Limited investigation · Final report · Jun 1, 1988 · N36GB · Substantial damage > The plt stated that he was performing a tail-slide maneuver when the eng suddenly quit. He attempted to restart eng. When eng would not restart, he elected to lnd a/c in a fld. During landing roll, the a/c nosed over. FAA stated that the carb was damaged… - [NTSB MIA88LA183](https://openairdocs.org/ntsb/MIA88LA183.md): Hiller UH-12E · Gretna, FL · Accident · No injuries · Limited investigation · Final report · Jun 1, 1988 · N4029R · Substantial damage > While on an aerial application flt, the plt stated he maneuvered the helicopter to release the remaining chemical. He then heard a loud 'screeching' noise followed by silence as the eng quit. The helicopter landed hard breaking the skids. It came to rest on… - [NTSB MKC88LA104](https://openairdocs.org/ntsb/MKC88LA104.md): Grumman G-164A · Hickory Ridge, AR · Accident · No injuries · Limited investigation · Final report · May 31, 1988 · N9653 · Destroyed > While executing a standard procedure aerial application turn around maneuver, the acft began to settle. The plt dumped his remaining chemical load, but acft continued to settle, and mushed into the trees. Post accident fire destroyed the acft, but the plt… - [NTSB CHI88FA120](https://openairdocs.org/ntsb/CHI88FA120.md): Bellanca 17-30A · Wautoma, WI · Accident · 1 fatal · Field investigation · Final report · May 31, 1988 · N28156 · Destroyed > Performance of an aerobatic maneuver with insufficient altitude for recovery. - [NTSB SEA88LA101](https://openairdocs.org/ntsb/SEA88LA101.md): Cessna 172M · Lester State, WA · Accident · Minor injuries · Limited investigation · Final report · May 30, 1988 · N20580 · Destroyed > The pilot inadvertently flew into a narrow valley with trees on both sides and steep rising terrain during climb to cruise. The aircraft was not able to outclimb the rising terrain, so the pilot slowed the aircraft to 40 m.p.h. and attempted a shallow… - [NTSB MKC88LA100](https://openairdocs.org/ntsb/MKC88LA100.md): Cessna 172K · Bismark, MO · Accident · Serious injuries · Limited investigation · Final report · May 29, 1988 · N8122V · Substantial damage > The accident aircraft was observed making several low passes over lake Bismark near Bismark, Missouri. Witnesses stated that, following the last pass, the aircraft contacted the water and sank. The pilot's blood alcohol content was analyzed as.14 percent… - [NTSB FTW88DQG05](https://openairdocs.org/ntsb/FTW88DQG05.md): Piper PA-25-260 · Stratford, TX · Accident · 1 fatal · Final report · May 29, 1988 · N8810L · Destroyed > While maneuvering during an aerial application flt, the pilot allowed the right wing to contact the ground. The aircraft was destroyed in the accident with fatal injuries to the pilot. - [NTSB FTW88DQA01](https://openairdocs.org/ntsb/FTW88DQA01.md): Aerotek Pitts S2S · El Paso, TX · Accident · 1 fatal · Final report · May 29, 1988 · N5333N · Destroyed > Pilot's failure to complete the aerobatic maneuver in a manner which insured adequate terrain clearance at the termination. - [NTSB SEA88LA106](https://openairdocs.org/ntsb/SEA88LA106.md): Hiller FH-1100 · Elgin, OR · Accident · No injuries · Limited investigation · Final report · May 28, 1988 · N370FH · Substantial damage > The purpose of the flight was for the pilot to practice for his aerial applicators certificate. Water was being used instead of chemical. The pilot reported that as the aircraft began to accelerate during takeoff it began to oscillate. As in prior… - [NTSB FTW88DRD05](https://openairdocs.org/ntsb/FTW88DRD05.md): Grumman G-164B · Bastrop, LA · Accident · No injuries · Final report · May 28, 1988 · N6676K · Substantial damage > The plt said he was spreading rice when he noticed the oil pressure was decreasing & the prop was beginning to feather. With no other place to go, he landed in a plowed field. Shortly after touchdown, the acft nosed over to an inverted position. An exam… - [NTSB DEN88FA115](https://openairdocs.org/ntsb/DEN88FA115.md): Mooney M20 · Jamestown, CO · Accident · 3 fatal · Field investigation · Final report · May 28, 1988 · N5279B · Destroyed > The plt told a friend that he was going to conduct a sightseeing flt in the local area. Residents of a small town 2 miles from the acdt site said the acft circled the town at low alt several times at about the time of the accident. There were no witnesses to… - [NTSB BFO88DIG03](https://openairdocs.org/ntsb/BFO88DIG03.md): Grumman G-164A · Sleepy Creek, MD · Accident · Serious injuries · Final report · May 26, 1988 · N4327 · Destroyed > During the aerial application flight the airplane struck and severed three power lines. The pilot stated he did not see the lines until it was too late. The airplane caught fire and continued on its flight path crossing a highway and a river. The airplane… - [NTSB MIA88FA178](https://openairdocs.org/ntsb/MIA88FA178.md): Rockwell A9B · Marianna, FL · Accident · Serious injuries · Field investigation · Final report · May 25, 1988 · N7787V · Substantial damage > The acft sustained a complete & sudden power loss while engaged in ag operations at low alt. The prop, fwd portion of the crankshaft, cyl head & other eng parts separated from the acft. The acft struck a row of 40 ft trees & crashed to the grnd. An exam of… - [NTSB CHI88DEC02](https://openairdocs.org/ntsb/CHI88DEC02.md): Chappel Ratsrepus 300 · Pontiac, MI · Accident · 1 fatal · Final report · May 25, 1988 · N889HC · Destroyed > Destructive wing/aileron flutter is suspected, but not sufficiently substantiated through research and calculations to be cited as the probable cause of this accident. - [NTSB ATL88MA184](https://openairdocs.org/ntsb/ATL88MA184.md): Learjet 35A · West Paterson, NJ · Accident · 4 fatal · Major investigation · Final report · May 24, 1988 · N500RW · Destroyed > Witnesses rpted a normal takeoff. Radar indicated the acft turned right as cleared and began cruise at 1900 ft, hdg nw at 235 KTS. 65 secs after calling clear of the control zone the acft's radar track ended. The acft was fragmented by theimpact with all flt… - [NTSB LAX88LA193](https://openairdocs.org/ntsb/LAX88LA193.md): Robinson R22 · Paso Robles, CA · Accident · No injuries · Limited investigation · Final report · May 21, 1988 · N32Y · Substantial damage > During a local introductory instructional flight, the student lost control of the helicopter. The flight instructor was unable to take control before the tail rotor contacted the ground. The helicopter collided with the terrain and rolled over. - [NTSB DEN88FA110](https://openairdocs.org/ntsb/DEN88FA110.md): Cessna 152 · Heber City, UT · Accident · 2 fatal · Field investigation · Final report · May 20, 1988 · N25934 · Destroyed > The CFI and student plt were on a round-robin cross-country flt. A witness near the accident site said he saw an airplane flying 'up a canyon quite slow and low'. The airplane was reported overdue and found the next day in a 'box canyon' at the 8,500 foot… - [NTSB MKC88LA092](https://openairdocs.org/ntsb/MKC88LA092.md): Bell 47G-2 · Mc Dougal, AR · Accident · No injuries · Limited investigation · Final report · May 19, 1988 · N4690 · Substantial damage > The pilot stated that he had just begun the spraying of a rice field when one of the spray nozzles malfunctioned. As he was attempting to set the helicopter down on the ground, to work on the nozzle, the main rotor blades struck a tree. The main rotor blades… - [NTSB LAX88FA190](https://openairdocs.org/ntsb/LAX88FA190.md): Piper PA-38-112 · Green Valley, AZ · Accident · 1 fatal · Field investigation · Final report · May 19, 1988 · N2326A · Destroyed > Failure of the student pilot to accomplish the proper stall recovery procedures allowing the stall to develop into a spin. Contributing to this accident was the lack of training in spin recovery. - [NTSB FTW88FA104](https://openairdocs.org/ntsb/FTW88FA104.md): Cessna 172P · Le Flore, OK · Accident · 2 fatal · Field investigation · Final report · May 18, 1988 · N212FR · Destroyed > The acft was being used to fly over a wooded area & spot cattle for psnl on the ground. After spotting cattle for about 2 hrs, the plt was flying at low alt when the acft suddenly rolled into a steep bank, then the nose dropped & the acft crashed in a steep… - [NTSB ATL88DMG06](https://openairdocs.org/ntsb/ATL88DMG06.md): Cessna 188 · Messic, NC · Accident · No injuries · Final report · May 18, 1988 · N8250G · Destroyed > During turnaround procedures, the airplane collided with trees and crashed. The pilot indicated that he had sprayed the field where the accident occurred many times during the past three years. - [NTSB FTW88DRD03](https://openairdocs.org/ntsb/FTW88DRD03.md): Cessna 188 · Winnsboro, LA · Accident · 1 fatal · Final report · May 15, 1988 · N78392 · Destroyed > The private pilot was practicing aerial application maneuvers with between 20 to 40 gallons of water in the spray tanks. A witness indicated that 'as the airplane started down for the pass it clearly went into a flat spin in which it made almost 2 full… - [NTSB SEA88LA094](https://openairdocs.org/ntsb/SEA88LA094.md): Bellanca 7GCAA · Sutcliffe, NV · Accident · 1 fatal · Limited investigation · Final report · May 14, 1988 · N57415 · Destroyed > The aircraft was observed to execute several low passes over witnesses along the shoreline of a lake. During one of the passes and while tracking northwest, the pilot dropped a package of life preservers from an estimated altitude of 75 feet AGL and while… - [NTSB LAX88FA180](https://openairdocs.org/ntsb/LAX88FA180.md): Curtiss-Wright Travel AIR 2000 · Fairfield, CA · Accident · 3 fatal · Field investigation · Final report · May 14, 1988 · N6130 · Destroyed > Pilot's failure to maintain an airspeed at which the aircraft is controllable and entering a stall. - [NTSB FTW88LA101](https://openairdocs.org/ntsb/FTW88LA101.md): Cessna 182P · Dalhart, TX · Accident · Serious injuries · Limited investigation · Final report · May 14, 1988 · N6069J · Destroyed > The local flight was circling at low altitude and reduced airspeed over farm equipment and level farmland while the passenger in the rear seat took photographs. The passenger in the right front seat said he heard the stall warning horn just prior to the… - [NTSB BFO88FA047](https://openairdocs.org/ntsb/BFO88FA047.md): Cessna 310L · New Cumberland, WV · Accident · Minor injuries · Field investigation · Final report · May 14, 1988 · N2220F · Destroyed > The plt was doing low passes down rwy 04 when according to the plt he struck a large bird after the second pass just when he was starting to climb about one-half mile from the rwy end. The plt said that the bird shattered the windscreen causing the plt facial… - [NTSB LAX88LA179](https://openairdocs.org/ntsb/LAX88LA179.md): McDonnell Douglas 369D · Waialua, HI · Accident · Serious injuries · Limited investigation · Final report · May 13, 1988 · N4943T · Destroyed > Failure to follow procedures established by the manufacture for uncommanded trim inputs and his decision to make a hover approach to landing. - [NTSB FTW88FA100](https://openairdocs.org/ntsb/FTW88FA100.md): Cessna 172F · Golden, TX · Accident · Serious injuries · Field investigation · Final report · May 13, 1988 · N5577R · Destroyed > Acft was operating on an aerial photography flt at 200 to 500' AGL and 70 to 80 mph. The commercial plt stated that as he was in a bank the acft seemed to be 'pushed' into the 60 to 80' trees over which he was flying and that it 'fell out of the air'. He also… - [NTSB MKC88DCJ01](https://openairdocs.org/ntsb/MKC88DCJ01.md): Cessna A188B · Dalton, NE · Accident · Serious injuries · Final report · May 11, 1988 · N70135 · Destroyed > The pilot was spraying a large field which had a power line along the north side. On the 1st couple of passes, the spray equipment had intermittent malfunctions. As the aircraft approached the field from north for the 4th pass, it struck the upper cable of… - [NTSB FTW88DRD02](https://openairdocs.org/ntsb/FTW88DRD02.md): Grumman G-164A · Jennings, LA · Accident · No injuries · Final report · May 11, 1988 · N4708 · Substantial damage > The ag airplane was spraying over a rice field and was making a turn-around when the airplane settled into small trees and bushes. No problems were found with the airplane or powerplant. - [NTSB SEA88LA090](https://openairdocs.org/ntsb/SEA88LA090.md): Ayres S2R Thrush · Lind, WA · Accident · No injuries · Limited investigation · Final report · May 10, 1988 · N5660X · Substantial damage > During an aerial application maneuver, a total loss of power occurred due to the number nine cylinder failing. A restart was attempted, but was unsuccessful. The pilot made a forced landing onto a very soft sandy field, where the aircraft nosed over inverted… - [NTSB MKC88FA086](https://openairdocs.org/ntsb/MKC88FA086.md): Cessna 150F · Mansfield, MO · Accident · 1 fatal · Field investigation · Final report · May 9, 1988 · N8605S · Substantial damage > A witness saw the acft flying at low alt as it passed in front of her car at dusk in a northeasterly drctn. She rprtd the acft contd down a valley toward power lines that spanned an open field. She saw the acft pull up rapidly, become entangled in the power… - [NTSB LAX88DVA05](https://openairdocs.org/ntsb/LAX88DVA05.md): Hiller 12E · Firebaugh, CA · Accident · No injuries · Final report · May 9, 1988 · N117HA · Substantial damage > During an aerial application, the helicopter collided with a guy wire and then a field. The pilot knew that the wire was there. He stated that he simply forgot that it was there and did not see it. There were no mechanical problems prior to the accident. - [NTSB MKC88DCQ02](https://openairdocs.org/ntsb/MKC88DCQ02.md): Piper PA-25-150 · Chase, KS · Accident · 1 fatal · Final report · May 7, 1988 · N6337Z · Substantial damage > Witnesses stated they saw the acft spraying a hayfield. They observed the acft strike a powerline as it was making a turn. The pilot stated that his wing clipped the powerline and that the acft went into a flat spin from which he couldn't recover. - [NTSB LAX88FA176](https://openairdocs.org/ntsb/LAX88FA176.md): Piper PA-28-140 · Guatay, CA · Accident · 2 fatal · Field investigation · Final report · May 7, 1988 · N4367J · Destroyed > Failure of the pilot to maintian VFR while flying in mountainous terrain. Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=184 ## 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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/cases?page=183 --- 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.