# NTSB investigations: Landing 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 441 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB CHI84LA287](https://openairdocs.org/ntsb/CHI84LA287.md): Cessna 172P · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Jul 7, 1984 · N52701 · Substantial damage > Nose gear collapsed during hard, flat landing. - [NTSB LAX84LA383](https://openairdocs.org/ntsb/LAX84LA383.md): Aeronca 7AC · Marysville, CA · Accident · No injuries · Limited investigation · Final report · Jul 6, 1984 · N1419E · Substantial damage > Due to a rough running eng, which was remedied by applying carburetor heat, the plt elected to make a precautionary landing on a private airstrip. Directional control was lost during the landing roll and the acft ground looped, damaging the left landing gear… - [NTSB SEA84LA162](https://openairdocs.org/ntsb/SEA84LA162.md): Bell 47G-3B · Eagle Point, OR · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1984 · N73224 · Substantial damage > The acft main rotor struck the ground during landing. The commercial plt had taken 2 passengers for a sight seeing tour and during landing he said one of them grabbed his right arm at 4 ft AGL and he was unable to recover before ground contact. - [NTSB LAX84LA381](https://openairdocs.org/ntsb/LAX84LA381.md): Cessna 152 · Hayward, CA · Accident · No injuries · Limited investigation · Final report · Jul 5, 1984 · N67819 · Substantial damage > The acft was landed hard on the third landing of the student pilot's first solo. During the ensuing bounce the nose gear collapsed & the acft sustained substantial damage. - [NTSB ANC84LA112](https://openairdocs.org/ntsb/ANC84LA112.md): Piper PA-12 · Curry, AK · Accident · Minor injuries · Limited investigation · Final report · Jul 5, 1984 · N2875M · Substantial damage > The acft swerved on the over grown rwy and when the plt partially corrected the swerving the acft went off the rwys end and nosed over. The plt said he had checked the airstrip out on a solo flt and had no problems. When he returned to the unmaintained strip… - [NTSB SEA84LA163](https://openairdocs.org/ntsb/SEA84LA163.md): Bellanca 7ECA · Haines, AK · Accident · No injuries · Limited investigation · Final report · Jul 4, 1984 · N11697 · Substantial damage > The acft overran the rwy and nosed over in the tall grass. The plt said he deliberately landed long to avoid a long taxi. There also was a light tail wind. The plt recommended using all available rwy and taking time to obtain wind info. - [NTSB SEA84LA161](https://openairdocs.org/ntsb/SEA84LA161.md): Cessna 172 · Moscow, ID · Accident · No injuries · Limited investigation · Final report · Jul 4, 1984 · N7364A · Substantial damage > The acft ran off the rwy into tall wet weeds during a landing on a private agricultural airstrip. The plt said a x-wind caused the swerve. A weather reporting station 6 NM away reported the wind as 7 KTS with no gusts. The plt landed to thenorth and the… - [NTSB NYC84LA231](https://openairdocs.org/ntsb/NYC84LA231.md): Bell 206B · Somers, CT · Accident · No injuries · Limited investigation · Final report · Jul 4, 1984 · N5003X · Substantial damage > The acft made a hard touchdown with the left side low. One side of the rotor came off and the other hit the engine according to one of the passengers aboard the acft. The plt said that the approach was normal and he brought the acft toa hover. However… - [NTSB DEN84IA209](https://openairdocs.org/ntsb/DEN84IA209.md): Boeing 727-23 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Jul 4, 1984 · N1992 · Minor damage > The acft went off the rwy during landing. The excursion was to the left & was not corrected before the acft made an exit from the rwy. The captain, in a written statement, said that he was anticipating a right x-wind because he was landing on rwy 26L & the… - [NTSB ANC84LA111](https://openairdocs.org/ntsb/ANC84LA111.md): Luscombe 8E · Seldovia, AK · Accident · No injuries · Limited investigation · Final report · Jul 4, 1984 · N1795K · Substantial damage > The acft nosed over during landing on a 2600 ft gravel rwy nestled in the hills with variable winds. The plt had temporarily traded acft for this trip and had not flown this type of acft for the preceding 90 day period. He normally flew his Cessna 185. He was… - [NTSB NYC84FNC05](https://openairdocs.org/ntsb/NYC84FNC05.md): Raven RX 6 · North Lebannon, ME · Accident · Serious injuries · Final report · Jul 3, 1984 · N5568A · Destroyed > Student balloon pilot was on third supervised solo flt with his flt instructor acting as member of the chase crew. Plt was controlling descent with short bursts of propane burner. Ground contact was hard enough to cause the balloon skirt to continue downward… - [NTSB MKC84LA199](https://openairdocs.org/ntsb/MKC84LA199.md): Schweizer G-164B · Sherrill, AR · Accident · No injuries · Limited investigation · Final report · Jul 3, 1984 · N3629B · Substantial damage > The plt stated he was landing with a slight tailwind & the new brake system on the acft was sensitive. During touchdown,the acft nose over. - [NTSB DEN84LA208](https://openairdocs.org/ntsb/DEN84LA208.md): Piper PA-38-112 · Townsend, MT · Accident · No injuries · Limited investigation · Final report · Jul 2, 1984 · N9826T · Substantial damage > The acft weathervaned during landing in a crosswind and collided with a fence and irrigation pipe off the left side of the rwy. The student plt had thought the landing in a x-wind would be good practice so he continued the approach but at the last momemt… - [NTSB SEA84LA157](https://openairdocs.org/ntsb/SEA84LA157.md): Eagle DW-1 · Quincy, WA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N8804M · Substantial damage > The acft nosed over during landing. The plt said vibration caused the parking brake to be set in the 'on' position priorto landing. At about 20 mph he used the brakes and the acft nosed over. - [NTSB SEA84LA155](https://openairdocs.org/ntsb/SEA84LA155.md): Beech M35 · Lacenter, WA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N772AW · Substantial damage > The plt was on a flt to the Lacenter arpt which had a 1700 ft rwy. During arrival, he mistook a nearby, uncharted, private strip for the Lacenter arpt. After landing on the 1300 ft private strip, the plt realized he would be unable to stop on the rwy. He… - [NTSB MKC84LA233](https://openairdocs.org/ntsb/MKC84LA233.md): Piper PA-28-140 · No Little Rock, AR · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N44213 · Substantial damage > The pilot-in-command was hired by the student pilot/aircraft owner to perform the passenger flight. No experience or currency records are available on the PIC as he had not held an airman's medical certificate for the last four years. On landing at… - [NTSB MKC84LA194](https://openairdocs.org/ntsb/MKC84LA194.md): Cessna A152 · Washington, MO · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N761BK · Substantial damage > The student plt was doing a series of 3 supervised touch and go landings. The 1st landing and takeoff were completed successfully. During the 2nd approach the acft drifted toward the rwy lights according to the plt. When pwr was applied and the acft nose… - [NTSB FTW84LA298](https://openairdocs.org/ntsb/FTW84LA298.md): Cessna 172N · Blanco, TX · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N738RW · Substantial damage > Due to the tatum ranch private airstrip being incorrectly marked on the sectional chart the plt was using, he inadvertantly landed at the wrong arpt lost control of the acft & was unable to go around or stop. The acft continued off the end of the gravel… - [NTSB CHI84LA309](https://openairdocs.org/ntsb/CHI84LA309.md): Glasflugel Libelle · Osseo, MI · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N1106B · Substantial damage > The plt stated that the thermals dissipated & he had to make an off arpt landing. The landing was made in a field of tall grass & the left wing contacted the grass first resulting in a 90 deg ground loop. The aft fuselage section separated. - [NTSB CHI84LA275](https://openairdocs.org/ntsb/CHI84LA275.md): North American P-51 Mustang X · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Jul 1, 1984 · N21770 · Substantial damage > A bounced landing occured during which the left main gear collapsed followed by a ground loop. - [NTSB NYC84DNC04](https://openairdocs.org/ntsb/NYC84DNC04.md): Maule M-5-235C · Millinocket Lke, ME · Accident · No injuries · Final report · Jun 30, 1984 · N4468P · Destroyed > The acft was landed hard on the glassy smooth surface of a lake. The plt admitted that the landing was hard and that after the touchdown the left float split open and the acft sank in 40 ft of water. Witnesses stated that the lake surface was calm and smooth… - [NTSB MKC84LA191](https://openairdocs.org/ntsb/MKC84LA191.md): Cessna 182N · Beaver City, NE · Accident · No injuries · Limited investigation · Final report · Jun 30, 1984 · N92522 · Destroyed > The acft was landed on an uncontrolled arpt toward the nnw, & after touchdown, it did not slow down adequetely. According to the plt, he elected to ground loop the acft rather than to continue off the end of the rwy. During the attempted ground loop, the acft… - [NTSB LAX84LA376](https://openairdocs.org/ntsb/LAX84LA376.md): Cessna 206 · Marysville, CA · Accident · No injuries · Limited investigation · Final report · Jun 30, 1984 · N4666F · Substantial damage > The plt stated he lost control of the acft & it veered off the rwy. The left wing hit the ground & the plane was damaged. - [NTSB FTW84FA296](https://openairdocs.org/ntsb/FTW84FA296.md): Cessna 421B · El Paso, TX · Accident · No injuries · Field investigation · Final report · Jun 30, 1984 · N554 · Substantial damage > First evidence of landing gear tire marks were found aprx 4,000 ft down the rwy, right of centerline and continued until the acft rolled off the right side of the rwy. All 3 landing gear collapsed in the soft dirt and gravel. According to the plt, when the… - [NTSB CHI84LA273](https://openairdocs.org/ntsb/CHI84LA273.md): Waco UPF-7 · Hamilton, OH · Accident · No injuries · Limited investigation · Final report · Jun 30, 1984 · N39717 · Substantial damage > The plt stated he landed long and fast and during an attempted go-around collided with a parked acft near the end of the grass strip. - [NTSB ANC84LA107](https://openairdocs.org/ntsb/ANC84LA107.md): Maule M-5 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 30, 1984 · N5642M · Substantial damage > The plt reported that when he landed on campbell lake, the left float hit a submerged object. The acft then yawed to the left, banked to the right & went over on its top. Campbell lake was used as a private sea-plane base & was located within the city limits… - [NTSB MKC84LA196](https://openairdocs.org/ntsb/MKC84LA196.md): Champion 7ECA · Wynne, AR · Accident · No injuries · Limited investigation · Final report · Jun 29, 1984 · N5261X · Substantial damage > Shortly after landing on rwy 16 the pilot noticed an aerial application acft lined up to land on rwy 34. Heavy braking was applied. The acft struck a rwy light, nosed over and came to rest inverted. The aerial application acft did not have a radio. It… - [NTSB FTW84LA294](https://openairdocs.org/ntsb/FTW84LA294.md): Cessna 152 · Washington, OK · Accident · No injuries · Limited investigation · Final report · Jun 29, 1984 · N49483 · Substantial damage > The plt reported that after he had landed & decelerated almost to taxi speed, the nose gear dug into soft terrain as he was turning off the landing area. The acft then slowly nosed over. - [NTSB CHI84LA269](https://openairdocs.org/ntsb/CHI84LA269.md): Cessna 152 · Ft. Wayne, IN · Accident · No injuries · Limited investigation · Final report · Jun 29, 1984 · N94111 · Substantial damage > During a landing, the acft bounced & landed on the nose wheel, collapsing the nose gear. - [NTSB ANC84LA106](https://openairdocs.org/ntsb/ANC84LA106.md): Piper PA-18-150 · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 28, 1984 · N99PJ · Substantial damage > The plt made an off arpt landing in a soft field camouflaged by tall weeds & marsh grass. He thought the terrain was dry, but the soil was wet & soft, & after a very short roll, the acft nosed over. - [NTSB SEA84LA149](https://openairdocs.org/ntsb/SEA84LA149.md): Cessna 172 · Everett, WA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1984 · N733UH · Substantial damage > The plt reported that during a landing, the acft encountered a gust of wind & ballooned. The airspeed decreased to 40 KTS & the acft dropped to the rwy. The plt applied full power & reduced the flaps from 40 deg to full up. The acft became airborne, but… - [NTSB MKC84LA186](https://openairdocs.org/ntsb/MKC84LA186.md): Cessna 152 · St. Louis, MO · Accident · No injuries · Limited investigation · Final report · Jun 27, 1984 · N6134Q · Substantial damage > The acft bounced on landing and during the attempts to recover or go-around the acft stalled and veered off the rwy. Thenose gear collapsed and the acft nosed over. The student plt, just released for solo flt, said he never had control of the acft during… - [NTSB MIA84LA193](https://openairdocs.org/ntsb/MIA84LA193.md): Piper PA-28 · Cedar Key, FL · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1984 · N6208H · Substantial damage > The plt stated he touched down about 1/3 down the 2,400 ft rwy, was unable to stop the acft & ran off the end. - [NTSB LAX84LA372](https://openairdocs.org/ntsb/LAX84LA372.md): Cessna 152 · Paso Robles, CA · Accident · No injuries · Limited investigation · Final report · Jun 27, 1984 · N49419 · Substantial damage > The plt was landing on a 3000 ft strip that had been scraped out of the ground by using a 'blade'. During the construction, a 1 1/2 ft berm was left on each side of the strip. While on the landing roll, the plt kept the nose wheeloff the ground with a left… - [NTSB SEA84LA147](https://openairdocs.org/ntsb/SEA84LA147.md): Cessna 207A · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jun 26, 1984 · N6480H · Substantial damage > The acft went off the rwy during a landing and the plt attempted a go-around with full flaps. The acft collided with a ditch and an irrigation pipe between the rwy and the taxi-way. The plt did not file an accident report. The accident information was… - [NTSB SEA84LA146](https://openairdocs.org/ntsb/SEA84LA146.md): Cessna 172D · Reno, NV · Accident · No injuries · Limited investigation · Final report · Jun 26, 1984 · N2384U · Substantial damage > The acft was blown from over the rwy during flare in a x-wind. This was a night landing for a plt with limited total andalmost no night flying experience. Also the plt had flown over 12 hours in the last 24,with considerable turbulence and thunderstorms.… - [NTSB DEN84LA198](https://openairdocs.org/ntsb/DEN84LA198.md): Piper PA-28-180 · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Jun 26, 1984 · N44017 · Substantial damage > While en route, the acft's ELT suddenly activated. The plt made an unplanned landing at laguna, NM to correct the ELT problem, then he continued on to coronado arpt at Albuquerque, NM. He said this incident made him tense. After receiving radar vectors to the… - [NTSB CHI84IA264](https://openairdocs.org/ntsb/CHI84IA264.md): McDonnell Douglas DC-8-54 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jun 26, 1984 · N8048U · Minor damage > During the landing roll, the left main gear swivel link pin failed allowing the rear set of tires to become detached from the main strut and drag along the rwy. The left main gear bogie was last overhauled in 1981. At the time of failure, it had 4459 hours… - [NTSB NYC84LA221](https://openairdocs.org/ntsb/NYC84LA221.md): Cessna 206 · Montauk, NY · Accident · No injuries · Limited investigation · Final report · Jun 25, 1984 · N555HM · Substantial damage > The acft nosed over and sank during a water landing. The float plane had approached nose high and upon initial touchdownon the lake the acft skipped/bounced. According to a witness it appeared that the plt was trying to extend his touchdownpoint. When the… - [NTSB SEA84LA144](https://openairdocs.org/ntsb/SEA84LA144.md): Balloon Works Barnes AX-8 · Monroe, WA · Accident · Serious injuries · Limited investigation · Final report · Jun 24, 1984 · N1509H · No damage > During the ballon descent, the plt said he briefed the passengers to bend their knees & hold onto something inside the basket. According to the plt, the descent became more rapid due to a downdraft. The passengers were again warned to 'hang on' because it… - [NTSB DEN84LA193](https://openairdocs.org/ntsb/DEN84LA193.md): Cessna 188B · Albuquerque, NM · Accident · No injuries · Limited investigation · Final report · Jun 24, 1984 · N72052 · Substantial damage > The arpt had a UNICOM & 2 rwys, 17/35 & 10/28. The acft had an operable radio, but the plt did not call UNICOM. He elected to land on rwy 17 which had a x-wind from 100 degs at 20 KTS. During the apch, the plt compensated for the x-wind by lowering the left… - [NTSB CHI84LA259](https://openairdocs.org/ntsb/CHI84LA259.md): Beech S35 · Ottawa, IL · Accident · No injuries · Limited investigation · Final report · Jun 24, 1984 · N905T · Destroyed > The plt said he 'left word' for the Ottawa arpt lights to be left on until 0200 hrs on 6/24. When the flt arrived at Ottawa, the lights were not on. The plt said he 'attempted to make an approach, it failed.' The acft was landed in a nearby field. The arpt… - [NTSB FTW84LA292](https://openairdocs.org/ntsb/FTW84LA292.md): Cessna 152 · Giddings, TX · Accident · No injuries · Limited investigation · Final report · Jun 23, 1984 · N5215P · Substantial damage > The student plt on his first solo cross-country flight became lost. The plt landed to refuel but the facility was closed. He departed to refuel elsewhere and ran one fuel tank dry enroute. Upon reaching the second arpt, the plt performed a landing on rwy 35… - [NTSB FTW84LA284](https://openairdocs.org/ntsb/FTW84LA284.md): Griffin Trane Starduster TOO · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Jun 23, 1984 · N77BG · Substantial damage > Acft touched down hard after 4 unsuccessful landing attempts at stroud, OK. Plt added full pwr and returned to Oklahoma City suspecting gear damage. Visual check by another acft revealed no apparent gear damage. Upon touchdown at expressway airpark, the main… - [NTSB MIA84LA191](https://openairdocs.org/ntsb/MIA84LA191.md): Cessna 172N · Miami, FL · Accident · No injuries · Limited investigation · Final report · Jun 22, 1984 · N738VS · Substantial damage > The plt said he had 'cross channeled' his radios & was having communication problems. He decided to land at the opa-locka west arpt. The acft was landed downwind & after overrunning the end of the rwy, it collided with terrain & was damaged. - [NTSB LAX84LA362](https://openairdocs.org/ntsb/LAX84LA362.md): Piper PA-28-151 · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Jun 22, 1984 · N44190 · Substantial damage > The plt stated he landed a little long on the 2800 foot dirt road and was unable to stop. The acft traveled off the end of the road and collided with a river bank. - [NTSB ATL84LA206](https://openairdocs.org/ntsb/ATL84LA206.md): Piper PA-28-140 · Summerville, SC · Accident · No injuries · Limited investigation · Final report · Jun 22, 1984 · N7339J · Substantial damage > The acft touched down 1500 ft past the approach end of the 4000 ft wet sod rwy. 10 degrees of flaps were used. Brakes were applied but at 3000 ft down the rwy the plt realized he would be unable to stop the acft before it collided with a deep ditch at the end… - [NTSB ANC84LA104](https://openairdocs.org/ntsb/ANC84LA104.md): Raven S-55A · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Jun 22, 1984 · N5562L · Substantial damage > While apchg to land on a school ground, the balloon plt lowered a drop line for the ground crew, then looked forward & saw a power line. He told the ground crew not to touch the drop line. The drop line contacted & pulled one power line into another, causing… - [NTSB FTW84LA283](https://openairdocs.org/ntsb/FTW84LA283.md): Hughes 369HS · Oklahoma City, OK · Accident · No injuries · Limited investigation · Final report · Jun 21, 1984 · N9124F · Substantial damage > While performing a practice autorotation plt failed to bring in power in time to arrest the high rate of descent. The helicopter touched down hard and the main rotor blades flexed downward striking the tail boom and severing it. The plt stated his failure to… - [NTSB DEN84LA191](https://openairdocs.org/ntsb/DEN84LA191.md): Cessna 172 · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Jun 21, 1984 · N733LA · Substantial damage > The student plt stated that during a landing, the acft either ballooned or was caught in an updraft. She reacted by pushing forward on the control wheel. The nosewheel hit the rwy first, the acft bounced in the air & again landed on thenosewheel. The firewall… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=442 ## 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 = 550) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/550/cases?page=441 --- 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, except the copies of manufacturers’ service documents, which belong to their rights holders.