# 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 180 of 378 · 18,851 cases ## Cases, newest first - [NTSB NYC88DFJ04](https://openairdocs.org/ntsb/NYC88DFJ04.md): Callair A-9 · Churchville, NY · Accident · Serious injuries · Final report · Sep 29, 1988 · N8402V · Substantial damage > The pilot was engaged in aerial application activities. When he started a turn at low altitude to align himself for another spray run the aircraft stalled and struck the terrain. - [NTSB ATL88FA256](https://openairdocs.org/ntsb/ATL88FA256.md): Bellanca 14-19-3 · Oak Grove, AL · Accident · 2 fatal · Field investigation · Final report · Sep 28, 1988 · N7637E · Destroyed - [NTSB LAX88DVM04](https://openairdocs.org/ntsb/LAX88DVM04.md): Weatherly 201B · Soledad, CA · Accident · No injuries · Final report · Sep 27, 1988 · N1265W · Destroyed > The pilot stated that after detecting smoke in the cockpit he turned off all electrical switches and made one more spray pass. After the pass, smoke became visible from the engine and part of the cowl separated. The engine lost power and the pilot executed a… - [NTSB BFO88LA084](https://openairdocs.org/ntsb/BFO88LA084.md): Piper PA-25-235 · Princess Anne, MD · Accident · No injuries · Limited investigation · Final report · Sep 23, 1988 · N7781Z · Substantial damage > The pilot reported that he had sprayed aprx 1/2 of the soybean field when smoke started to fill the cockpit. He shut off the spray, turned off the electrical system and opened the fresh air vents. He then looked back at the tail section of the airplane and… - [NTSB LAX88DVA15](https://openairdocs.org/ntsb/LAX88DVA15.md): Schweizer G-164A · Laton, CA · Accident · No injuries · Final report · Sep 22, 1988 · N9946 · Substantial damage - [NTSB CHI88FA240](https://openairdocs.org/ntsb/CHI88FA240.md): Bellanca 8KCAB · Oswego, IL · Accident · 1 fatal · Field investigation · Final report · Sep 20, 1988 · N50702 · Destroyed > Inadequate design inthe manufacture of the pilot's seat which failed during intentional aerobatic maneuvers for which the aircraft including the seat were intended. - [NTSB FTW88DRD21](https://openairdocs.org/ntsb/FTW88DRD21.md): Air Tractor AT301 · Ferriday, LA · Accident · No injuries · Final report · Sep 19, 1988 · N31646 · Substantial damage > The agricultural airplane was on a swath run when the engine malfunctioned. The pilot released the load of chemicals and made a forced landing in a bean field. There was very little damage to the beans but there was substantial damage to the airplane.… - [NTSB NYC88LA237](https://openairdocs.org/ntsb/NYC88LA237.md): Robinson R-22 · W.Kingston, RI · Accident · No injuries · Limited investigation · Final report · Sep 17, 1988 · N47CS · Substantial damage > The plt said it was a clear, calm night. When he got to his helicopter he found the windshield covered with a heavy dew. He cleaned the windshield but during takeoff the dew reformed on the windshield and he lost all visual references outside the helicopter.… - [NTSB LAX88FA319](https://openairdocs.org/ntsb/LAX88FA319.md): Piper PA-24-250 · Springville, CA · Accident · 2 fatal · Field investigation · Final report · Sep 17, 1988 · N604MM · Destroyed > Pilot used poor judgement in executing the second low pass and failed to follow normal v.f.r. go-around procedures. Contributing to this accident was the pilot's failure to maintain flying speed during the rapid pitch-up maneuver. - [NTSB FTW88DPJ12](https://openairdocs.org/ntsb/FTW88DPJ12.md): Snyder Stolp SA-300 · Oklahoma City, OK · Accident · 1 fatal · Final report · Sep 17, 1988 · N57DH · Destroyed > Total failure of the rudder control due to failure of the metal welds on the cable attachment to the rudder pedal, due to improper welding by the manufacturer. - [NTSB SEA88LA180](https://openairdocs.org/ntsb/SEA88LA180.md): Eagle DW-1 · Wenatchee, WA · Accident · No injuries · Limited investigation · Final report · Sep 16, 1988 · N8815C · Substantial damage > After takeoff, plt noted wind increasing. Plt then made downwind 300 ft AGL survey run of field to be sprayed abutting columbia river. In procedure turn over river at completion of run, acft encountered 'sinkhole' wihch plt could not counter with full power… - [NTSB DEN88LA205](https://openairdocs.org/ntsb/DEN88LA205.md): Piper PA-25-235 · Lund, UT · Accident · No injuries · Limited investigation · Final report · Sep 15, 1988 · N9764 · Substantial damage > The private plt was spraying crops during an aerial application flight. During a right turn at the end of a spray run, he said he diverted his attention into the cockpit to check the metering rate, and may have inadvertently pushed the control stick forward.… - [NTSB ATL88LA251](https://openairdocs.org/ntsb/ATL88LA251.md): Piper PA-28R-200 · Gray, GA · Accident · No injuries · Limited investigation · Final report · Sep 15, 1988 · N32105 · Substantial damage > Instructor said that after completing a stall series the engine began to backfire continously & power was lost so that he could not maintain altitude. An off airport landing was made and a fence was hit during the landing roll. Eng had been overhauled &… - [NTSB LAX88LA310](https://openairdocs.org/ntsb/LAX88LA310.md): Cessna 172F · Fairfield, CA · Accident · No injuries · Limited investigation · Final report · Sep 11, 1988 · N5149F · Substantial damage > The pilot performed a soft field takeoff on a grass strip in winds gusting to 34 KTS. The airplane would not accelerate in ground effect, nor would it climb. Feeling that he could not out-climb objects in his path, the pilot turned to the right. As he turned… - [NTSB FTW88DPA07](https://openairdocs.org/ntsb/FTW88DPA07.md): Bölkow BO-105C · Dallas, TX · Accident · No injuries · Final report · Sep 7, 1988 · N210BB · Substantial damage > The helicopter made its approach to an open area on the westside of the airport to go to a refueling area on the south side of the airport. The pilot changed his mind and decided to go to the northeast side of the airport. He received tower approval but was… - [NTSB SEA88LA172](https://openairdocs.org/ntsb/SEA88LA172.md): Young-Owens Cassutt 3M · Caldwell, ID · Accident · No injuries · Limited investigation · Final report · Sep 6, 1988 · N67Y · Destroyed > On test flt in preparation for reno air races, plt entered power dive at 10000 ft to 230 KTS and experienced vibrations. He reduced power and entered a steep nose high climb allowing the aircraft to decelerate to near stall speed. The vibration continued. At… - [NTSB SEA88FA169](https://openairdocs.org/ntsb/SEA88FA169.md): Cessna 172E · Petersburg, AK · Accident · 4 fatal · Field investigation · Final report · Sep 5, 1988 · N3841S · Destroyed > Plt was briefed for marginal VFR conditions. Witnesses on departure noted fog bank offshore from airport. Witnesses near accident site, 10 mi from departure point, heard acft and sounds of impact. They reported fog on the water and glassy water conditions. - [NTSB SEA88FA167](https://openairdocs.org/ntsb/SEA88FA167.md): Britten-Norman BN-2A · Sitka, AK · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1988 · N111VA · Destroyed > The pilot encountered low ceilings, rain and fog while attempting to fly through a narrow mountain pass and successfully reversed course. He then flew into a small canyon off the main pass that terminated in a small glacier-covered bowl surrounded by steep… - [NTSB CHI88FA203](https://openairdocs.org/ntsb/CHI88FA203.md): Piper PA-20 · Claypool, IN · Accident · 2 fatal · Field investigation · Final report · Sep 5, 1988 · N7791K · Destroyed > Pilot-in-command's failure to maintain a sufficient visual lookout and perform a pull up in time to avoid collision with a tree. - [NTSB CHI88DER14](https://openairdocs.org/ntsb/CHI88DER14.md): Homebuilt Woodstock · Mankato, MN · Accident · 1 fatal · Final report · Sep 5, 1988 · N369DK · Destroyed > Aircraft structural failure due to overload induced by pilot in the performance of unauthorized maneuvers. - [NTSB CHI88FA231](https://openairdocs.org/ntsb/CHI88FA231.md): Cessna 172P · Boyne City, MI · Accident · 1 fatal · Field investigation · Final report · Sep 4, 1988 · N52601 · Destroyed > The pilot and his passenger were flying low over a sailboat regatta to photograph sailboats. As the pilot maneuvered for a photograph, he throttled back and banked the aircraft in a steep bank. Subsequently, the aircraft stalled and there was insufficient… - [NTSB FTW88FA160](https://openairdocs.org/ntsb/FTW88FA160.md): Cessna 170A · El Paso, TX · Accident · 4 fatal · Field investigation · Final report · Sep 3, 1988 · N9101A · Destroyed > Pilot's impairment due to the influence of alcohol. - [NTSB LAX88DVA14](https://openairdocs.org/ntsb/LAX88DVA14.md): Ayres S2R-T34 · Five Points, CA · Accident · Minor injuries · Final report · Sep 2, 1988 · N4009M · Substantial damage > Plt was engaged in aerial application and had been overflying power lines. On last pass, plt elected to fly beneath power lines, struck bracing wire between poles with vertical fin, disabling elevator. The acft crashed nose down in a field in an uncontrolled… - [NTSB BFO88LA081](https://openairdocs.org/ntsb/BFO88LA081.md): Arthur Acrosport 1 · Danville, VA · Accident · No injuries · Limited investigation · Final report · Aug 31, 1988 · N47TA · Substantial damage > The acft was on a performance test flight when a power loss occurred at 1100 ft MSL. The plt unsuccessfully tried to restart the engine and made a forced landing in an open field. Examination of the acft revealed the rubber hose vent line was obstructed with… - [NTSB MIA88FA262](https://openairdocs.org/ntsb/MIA88FA262.md): Commens Midget Mustang I · Davie, FL · Accident · 1 fatal · Field investigation · Final report · Aug 30, 1988 · N35LC · Destroyed > The private pilot flying the homebuilt aircraft crashed into a swamp, and there were no witnesses. The aircraft was located 4 days later. Friends of the pilot recalled that in the 3 weeks prior to the accident the pilot had bragged to them about the high 'g'… - [NTSB LAX88DVA13](https://openairdocs.org/ntsb/LAX88DVA13.md): Ayres 600-S2D · Los Banos, CA · Accident · No injuries · Final report · Aug 30, 1988 · N1779S · Substantial damage > Plt was engaged in aerial application when no 9 cyl head cracked. Plt returned for precautionary lndg. On approach, oil obscured windshield. Plt missed landing area; landed in cultivated field beside landing area. Acft nosed over. - [NTSB ATL88DKG15](https://openairdocs.org/ntsb/ATL88DKG15.md): Rockwell S2R · Pelham, GA · Accident · Minor injuries · Final report · Aug 30, 1988 · N4887X · Destroyed > The crop duster had completed the third swath run of the morning when the engine began to lose power. The plt released the contents of the hopper and made a forced landing in a soybean field. During the landing roll, the airplane nosed over and a ground fire… - [NTSB MKC88FA166](https://openairdocs.org/ntsb/MKC88FA166.md): Cessna 150 · Reed Springs, MO · Accident · Serious injuries · Field investigation · Final report · Aug 29, 1988 · N3475V · Substantial damage > The accident aircraft was observed performing high speed passes at extremely low altitude over the lake. Witnesses estimated the altitude of the aircraft from 30 to 75 feet above the water. The aircraft struck 72,000 volt power lines at a point approximately… - [NTSB DEN88LA195](https://openairdocs.org/ntsb/DEN88LA195.md): Piper PA-28-140 · Rawlins, WY · Accident · Serious injuries · Limited investigation · Final report · Aug 29, 1988 · N5873U · Substantial damage > Plt and pax were on a flight from milwaukee, WI, to las vegas, NV. The plt made an unscheduled stop at Rawlins due to poor vis and low fuel. The airplane was loaded with suit cases, camping gear, coolers and full fuel. The pilot and pax combined weight was… - [NTSB CHI88LA221](https://openairdocs.org/ntsb/CHI88LA221.md): Cessna 150J · Burnsville, MN · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1988 · N5561G · Substantial damage > During a local pleasure/aerial photography flight, the pilot failed to handle the aircraft properly. Subsequently the pilot was unable to maintain sufficient airspeed and/or altitude to remain clear of obstacles. The aircraft was configured for slow flight as… - [NTSB BFO88LA076](https://openairdocs.org/ntsb/BFO88LA076.md): Robinson R22A · Gaithersburg, MD · Accident · No injuries · Limited investigation · Final report · Aug 27, 1988 · N8559A · Substantial damage > The flt was initiated with the student plt bringing the helicopter up to a hover with some forward speed. The student rapidly and forcefully applied aft cyclic. The CFI was unable to compensate in time, even though he was on the controls with the student. The… - [NTSB BFO88DID04](https://openairdocs.org/ntsb/BFO88DID04.md): Piper PA-25-250 · Waverly, VA · Accident · 1 fatal · Final report · Aug 25, 1988 · N8668L · Destroyed > The acft contacted pwr lines, crashed and burned during an aerial appliation flt. Witnesses reported that it looked as if the plt descended to fly under the lines when it suddenly pulled up and contacted them. - [NTSB SEA88FA160](https://openairdocs.org/ntsb/SEA88FA160.md): Aero Commander 100-180 · John Day, OR · Accident · 3 fatal · Field investigation · Final report · Aug 24, 1988 · N4175X · Destroyed > While elk spotting in mountainous terrain, the aircraft collided with trees in a nose low turn similar to the intermediate stages of a stall. A severe post impact fire erupted. The density altitude at the accident site elevation was approximately 10,100 feet.… - [NTSB ATL88LA235](https://openairdocs.org/ntsb/ATL88LA235.md): Cessna 150G · Rock Hill, SC · Accident · Serious injuries · Limited investigation · Final report · Aug 23, 1988 · N3105J · Substantial damage > The plt reported that the engine began to run rough & lose pwr while he was circling some property he owned. He subsequently attempted to land at a nearby ultralight airstrip. He stated that he didn't remember anything after that. The airstrip owner reported… - [NTSB LAX88DVA11](https://openairdocs.org/ntsb/LAX88DVA11.md): Tedford VARI-EZE · Mariposa, CA · Accident · 1 fatal · Final report · Aug 22, 1988 · N707LT · Destroyed > Acft observed to dive into grnd. Investigation revealed inflt breakup and separation of canards. Exam of canards revealed modification to increase chord improperly done, adding excess weight aft of CG and making components subject to flutter. One mounting… - [NTSB ATL88DMG08](https://openairdocs.org/ntsb/ATL88DMG08.md): Piper PA-25-235 · La Grange, NC · Accident · No injuries · Final report · Aug 22, 1988 · N8819L · Substantial damage > The pilot reported that the spray boom collided with a tree, resulting in the left aileron being jammed in an uncontrollable position. The acft impacted in a field. - [NTSB ATL88DLT02](https://openairdocs.org/ntsb/ATL88DLT02.md): Grumman G-164B · Dancyville, TN · Accident · No injuries · Final report · Aug 22, 1988 · N6783K · Destroyed - [NTSB LAX88DVA12](https://openairdocs.org/ntsb/LAX88DVA12.md): Ayres S2R · Kerman, CA · Accident · No injuries · Final report · Aug 20, 1988 · N8930Q · Substantial damage > Drg an aerial application flt, the eng lost power & a fire started in the eng compartment when a fuel line failed, just forward of the fire wall. The plt made a successful landing in an open field, but the acft was substantially damaged due to the fire. - [NTSB FTW88DRD19](https://openairdocs.org/ntsb/FTW88DRD19.md): Schweizer G-164B · Catahoula, LA · Accident · No injuries · Final report · Aug 20, 1988 · N6685Q · Destroyed > The ag airplane was being utilized to scare birds away from the rice fields. It was 15 feet AGL when the engine backfired and quit. The airplane collided with the terrain and burned. The engine and engine accessories were so destroyed by fire that nothing… - [NTSB MKC88LA160](https://openairdocs.org/ntsb/MKC88LA160.md): Grumman G-164A · Hebron, NE · Accident · No injuries · Limited investigation · Final report · Aug 19, 1988 · N5329 · Destroyed > While making a aerial application swath run, the pilot was checking his spray booms because of some malfunctioning nozzles. Exiting the field between two groups of trees on the border he failed to see power line poles. He struck the wires, then the terrain,… - [NTSB LAX88LA290](https://openairdocs.org/ntsb/LAX88LA290.md): Cessna T210N · Santa Paula, CA · Accident · No injuries · Limited investigation · Final report · Aug 19, 1988 · N1199U · Substantial damage > During a cross country flight, the pilot diverted to a closer airport due to a low fuel state. The pilot was unable to land the airplane on the first attempt. During the second attempt, the engine quit. The pilot made an emergency landing where during the… - [NTSB SEA88LA155](https://openairdocs.org/ntsb/SEA88LA155.md): Mace R-2 · Reno, NV · Accident · 1 fatal · Limited investigation · Final report · Aug 18, 1988 · N711HM · Destroyed > Acft had been fitted with new outer wing panels of elliptical design and was on sixth test flight for racing certification, exploring g envelope. Investigation revealed right outer panel separated in flight during maneuvering. Failure occurred in center… - [NTSB SEA88FA156](https://openairdocs.org/ntsb/SEA88FA156.md): de Havilland DHC-2 Mark 1 · Sitka, AK · Accident · 1 fatal · Field investigation · Final report · Aug 18, 1988 · N64398 · Destroyed > While on a flight from Sitka to rowan bay, Alaska, the pilot flew up a valley intending to cross a pass whose elevation was 2745 feet MSL. Upon approaching the pass the pilot encountered clouds which prevented his transit. The pilot then executed a 180 degree… - [NTSB ANC88LA115](https://openairdocs.org/ntsb/ANC88LA115.md): Piper PA-12 · King Mountain, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 1988 · N5461Y · Substantial damage > The pilot-in-command was maneuvering through a valley for the second time. During the second pass the engine lost power. Mixture was full rich, and the pilot applied carburetor heat and when nothing happened he turned the carburetor heat off. He attempted a… - [NTSB LAX88DUG06](https://openairdocs.org/ntsb/LAX88DUG06.md): Hiller UH-12E · Thermal, CA · Accident · Minor injuries · Final report · Aug 17, 1988 · N65120 · Substantial damage > Shortly after refueling the helicopter & reloading the hopper, the plt took off & was starting to spray a field when the eng suddenly lost power. The plt said the helicopter was dscndg from about 30 ft when the power loss occurred; thus, he barely had time to… - [NTSB CHI88DEP11](https://openairdocs.org/ntsb/CHI88DEP11.md): Grumman-Schweizer G-164A · Plover, WI · Accident · No injuries · Final report · Aug 17, 1988 · N8495 · Substantial damage > The aircraft collided with a farm machinery shed during an aerial application maneuver. The pilot stated that there was no powerplant or control malfunction. The temperature at the accident site was 87 degrees (f), with a calculated density altitude of 2944… - [NTSB ATL88DMG07](https://openairdocs.org/ntsb/ATL88DMG07.md): Cessna A188B · Oak City, NC · Accident · No injuries · Final report · Aug 16, 1988 · N8284G · Substantial damage - [NTSB SEA88LA153](https://openairdocs.org/ntsb/SEA88LA153.md): Champion 7GCB · Oreana, ID · Accident · No injuries · Limited investigation · Final report · Aug 15, 1988 · N9806Y · Substantial damage > Plt was circling a friend's ranch at low alt when acft began an uncommanded left roll. Plt was able to level wings before ground contact in rough terrain. Investigation revealed aileron attach bolt missing. Aileron had just undergone repair. - [NTSB NYC88FA218](https://openairdocs.org/ntsb/NYC88FA218.md): Cessna 172K · Island Falls, ME · Accident · 1 fatal · Field investigation · Final report · Aug 15, 1988 · N1183M · Destroyed > Pilot's poor in-inflight decisions and planning and failed to follow ATC directives to maintain VFR. The pilot continued VFR into IFR conditions and collided with hilly terrain. - [NTSB LAX88DVA10](https://openairdocs.org/ntsb/LAX88DVA10.md): Ayres S2R-T34 · Huron, CA · Accident · No injuries · Final report · Aug 14, 1988 · N40071 · Substantial damage > During an aerial application flight at night, the airplane's vertical stabilizer collided with a transmission wire. Subsequently, the vertical stabilizer & rudder were dislocated & directional control was lost. Realizing he had lost directional control, the… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=181 ## 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=180 --- 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.