# 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 422 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB LAX85LA390](https://openairdocs.org/ntsb/LAX85LA390.md): Rockwell S-2R · Coalinga, CA · Accident · No injuries · Limited investigation · Final report · Sep 11, 1985 · N4853X · Substantial damage > The pilot stated that he turned onto the final approach for landing on rwy 36 as the sun set on his unlighted ag strip. He said that he lost sight of the strip during the landing flare, and driftd of the right side of the runway into high vegetation. The drag… - [NTSB DEN85LA239](https://openairdocs.org/ntsb/DEN85LA239.md): Cessna T210L · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Sep 11, 1985 · N399KM · Substantial damage > The student plt was returning from a solo x-country flt. Prior to landing, he called the fss & was advised that the wind was from 190 deg & was gusty. As he landed on rwy 6, the acft veered to the left, went off the rwy, hit a rwy light & was damaged. - [NTSB ATL85LA274](https://openairdocs.org/ntsb/ATL85LA274.md): Cessna 150G · Dalton, GA · Accident · No injuries · Limited investigation · Final report · Sep 11, 1985 · N2906J · Substantial damage > During arrival, the student plt elected to land on a taxiway since the rwy was closed for constuction. He stated that he made a normal pattern, but was a little high on final apch. He reported that he flared about 20 ft above the taxiway, then the acft landed… - [NTSB ANC85LAA05](https://openairdocs.org/ntsb/ANC85LAA05.md): de Havilland DHC-3 · Cape Douglas, AK · Accident · No injuries · Final report · Sep 11, 1985 · N11250 · Substantial damage > The acft nosed over during a forced landing on a tundra following a loss of pwr. The plt reported he made a low pass over a downed acft on a beach and as he advanced the throttle, a rapid decrease in pwr occurred. The acft and eng were not recovered from the… - [NTSB LAX85LA388](https://openairdocs.org/ntsb/LAX85LA388.md): Cessna 152 · Modesto, CA · Accident · No injuries · Limited investigation · Final report · Sep 10, 1985 · N5477B · Substantial damage > The student plt reptd the final approach angle was too shallow. He added power and as the acft arrived over the threshold he reduced the power. The acft landed hard and bounced. When the acft became airborne the plt added power to execute a go-around. The… - [NTSB MKC85LA223](https://openairdocs.org/ntsb/MKC85LA223.md): Beech 58 · Greenfield, MO · Accident · No injuries · Limited investigation · Final report · Sep 9, 1985 · N755DD · Substantial damage > The plt reports that he extended the landing gear and wing flaps at the same time and the landing gear circuit breaker tripped. The plt was not aware that the gear had not extended and the acft landed with the gear retracted. - [NTSB MKC85LA219](https://openairdocs.org/ntsb/MKC85LA219.md): Cessna A185F · Lincoln, NE · Accident · No injuries · Limited investigation · Final report · Sep 8, 1985 · N1756R · Substantial damage > Shortly after takeoff in an acft with amphibious landing gear. The plt cancelled his flt plan and had the twr check the landing gear. He then made a precautionary landing in a lake with the wheels retracted. One wheel was not fully retracted at touchdown and… - [NTSB CHI85LA371](https://openairdocs.org/ntsb/CHI85LA371.md): Cessna 172P · Ann Arbor, MI · Accident · No injuries · Limited investigation · Final report · Sep 7, 1985 · N54452 · Substantial damage > The right main tire blew and the left main landing gear was damaged during a hard landing. Aprx 1 foot of the lower half of the firewall was wrinkled. - [NTSB ATL85LMG07](https://openairdocs.org/ntsb/ATL85LMG07.md): Cessna 172N · Anderson, SC · Accident · No injuries · Final report · Sep 7, 1985 · N737LH · Substantial damage > The plt reported that the acft encountered a gust of wind as he was landing & the nose went up. Subsequently, the acft landed hard & was damaged. - [NTSB ATL85LA271](https://openairdocs.org/ntsb/ATL85LA271.md): Cessna 305A · Star, NC · Accident · No injuries · Limited investigation · Final report · Sep 7, 1985 · N19JK · Substantial damage > During landing roll the aircraft ground looped and the rightlanding gear separated from the aircraft. The pilot stated that the right brake locked causing the aircraft to veer to the right. No evidence of brake malfunction was found. - [NTSB DEN85FTE08](https://openairdocs.org/ntsb/DEN85FTE08.md): Cessna 182N · Alamosa, CO · Accident · Minor injuries · Final report · Sep 6, 1985 · N92240 · Substantial damage > The acft contacted trees, a fence and a ditch during a precautionary landing on a dirt road. The plt stated that when approaching his destination, the eng began running rough and he was unable to correct the problem. He then decided to land on the road and… - [NTSB ATL85LA270](https://openairdocs.org/ntsb/ATL85LA270.md): Swearingen SA-26AT · Columbia, SC · Accident · No injuries · Limited investigation · Final report · Sep 6, 1985 · N18SE · Substantial damage > The pilot stated that during landing roll, after slowing the aircraft to approx 40 KTS the aircraft swerved off of the runway following activation of the nose wheel steering. The pilot related that the nose wheel steering system malfunctioned on two previous… - [NTSB LAX85LA382](https://openairdocs.org/ntsb/LAX85LA382.md): Cessna 180B · Placerville, CA · Accident · Minor injuries · Limited investigation · Final report · Sep 5, 1985 · N1895X · Substantial damage > Acft ran off the rwy after landing. Plt reported acft veered to the left off the rwy and was able to correct back after application of power. Winds were variable at 7 KTS gusting to 12 KTS. - [NTSB DEN85FTE09](https://openairdocs.org/ntsb/DEN85FTE09.md): Conover'S Steen Skybolt · Strasburg, CO · Accident · Minor injuries · Final report · Sep 5, 1985 · N200FC · Substantial damage > The acft was observed during landing by a witness who said that the acft bounced once before nosing over to an inverted position on the rt side of the rwy. Investigation revealed that the rt landing gear was wrapped tight with weeds that bordered the side.… - [NTSB NYC85LA232](https://openairdocs.org/ntsb/NYC85LA232.md): Cessna 152A · Post Mills, VT · Accident · Serious injuries · Limited investigation · Final report · Sep 4, 1985 · N4976A · Substantial damage > After reviewing air maneuvers, a normal apch was made to land on rwy 22. The acft landed on all 3 wheels & bounced into the air, then it went to the left of the rwy. While the plt was turning right to avoid trees & to recover from the bounced landing, the… - [NTSB LAX85LA381](https://openairdocs.org/ntsb/LAX85LA381.md): Cessna 402A · San Jose, CA · Accident · No injuries · Limited investigation · Final report · Sep 4, 1985 · N4597Q · Substantial damage > The aircraft landed gear up. The pilot reported no malfunction and said he forget to lower the landing gear. - [NTSB BFO85FA073](https://openairdocs.org/ntsb/BFO85FA073.md): Piper PA-31-350 · Norfolk, VA · Accident · No injuries · Field investigation · Final report · Sep 4, 1985 · N27902 · Substantial damage > The acft experienced a complete gear collapse after contacting a rwy light and a taxiway sign during a landing roll. Theflt departed la guardia arpt 230 lbs over the 7000 pld max gross weight of the acft and at least 1 inch aft of the center of gravity limit.… - [NTSB MIA85LA245](https://openairdocs.org/ntsb/MIA85LA245.md): Aeronca 7AC · New Smyrna Bch, FL · Accident · No injuries · Limited investigation · Final report · Sep 3, 1985 · N84046 · Substantial damage > The aircraft swerved to the left on landing as the tailwheelcontacted the runway. The aircraft left the runway and collided with an embankment shearing the right main landing gear. A post accident examination of the tailwheel steering entering assembly… - [NTSB LAX85LA395](https://openairdocs.org/ntsb/LAX85LA395.md): Piccard AX6 · Pilot Hill, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 1985 · N2484Z · No damage > During inflation of the balloon prior to flt, the plt said he noticed a 5 kt gust of wind. Plt then sent a small balloon aloft to test the wind and said it 'showed a slowing of the wind' at 60 to 80 ft AGL & acceptable flt conditions. After launch the wind… - [NTSB ATL85LA265](https://openairdocs.org/ntsb/ATL85LA265.md): Bellanca Champion 7GCAA · Alabaster, AL · Accident · No injuries · Limited investigation · Final report · Sep 1, 1985 · N7559F · Substantial damage > The plt lost directional control of the acft during a landing. The acft nosed over coming to rest inverted. The plt related that a gust of wind caused the loss of control. - [NTSB ATL85LA264](https://openairdocs.org/ntsb/ATL85LA264.md): Piper PA-18 105 · Hendersonville, NC · Accident · No injuries · Limited investigation · Final report · Sep 1, 1985 · N323T · Substantial damage > During the takeoff phase of a touch & go landing, the CFR and private pilot lost directional control and ran off the side of the runway. - [NTSB MKC85LA200](https://openairdocs.org/ntsb/MKC85LA200.md): Piper PA-32-301 · Fredericktown, MO · Accident · No injuries · Limited investigation · Final report · Aug 31, 1985 · N8385S · Substantial damage > The plt reports that he lost directional control during the landing roll. The acft swerved off the side of the rwy, down an embankment and collided with a fence. The landing and brake system were examined by a mechanic after the accident and no evidence of a… - [NTSB ANC85LA165](https://openairdocs.org/ntsb/ANC85LA165.md): Cessna A188B · Gold King Creek, AK · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1985 · N53286 · Substantial damage > The plt stated that when he landed, the acft was rolling out on its main gear in a tail low attitude, when he applied braking action. A moment later, the acft began to pitch nose down. He compensated with full up elevator, but the acft nosed over. - [NTSB LAX85LA375](https://openairdocs.org/ntsb/LAX85LA375.md): Cessna T210 · Bishop, CA · Accident · No injuries · Limited investigation · Final report · Aug 30, 1985 · N2251R · Substantial damage > The plt reptd the landing gear collapsed during the landing roll and that the lnd gear down light was illuminated while on final approach. Examination of the aircraft disclosed the lnd gear doors were damaged by the side loads and that both main lnd gears… - [NTSB DEN85LQA05](https://openairdocs.org/ntsb/DEN85LQA05.md): Cessna 150M · Santa Fe, NM · Accident · No injuries · Final report · Aug 30, 1985 · N63258 · Substantial damage > The plt experienced a hard landing while on a solo x-country flt. The plt reported the flt had been delayed until mid-afternoon because of mechanical problems at by that time the winds had picked up. The student plt also reported having little dual experience… - [NTSB NYC85LA228](https://openairdocs.org/ntsb/NYC85LA228.md): Cessna 182L · Blairstown, NJ · Accident · No injuries · Limited investigation · Final report · Aug 29, 1985 · N3380R · Substantial damage > During a normal night landing, a deer darted onto the runway and struck the tail section of the aircraft causing major structural damage. The deer was not located. - [NTSB MKC85LA197](https://openairdocs.org/ntsb/MKC85LA197.md): Cessna 310 · Cotton Plant, AR · Accident · No injuries · Limited investigation · Final report · Aug 29, 1985 · CGYSM · Substantial damage > During the landing roll at an airstrip, the plt allowed the acft to drift. The drift continued until the acft struck a ditch bordering the rwy. The ensuing impact with the ditch substantially damaged the acft. The pilot stated the wind conditions were light &… - [NTSB CHI85IA359](https://openairdocs.org/ntsb/CHI85IA359.md): British Aerospace BAC 1-11-201AC · Green Bay, WI · Incident · No injuries · Incident investigation · Final report · Aug 29, 1985 · N101EX · No damage > The airplane landed & touched down in the first 1/3 of the runway. It veered to the left, then back to the center & went off the end the runway showed signs of steam cleaning where the tires were & the tires showed signs of rubber inversion. The pilot elected… - [NTSB FTW85LA338](https://openairdocs.org/ntsb/FTW85LA338.md): Cessna 150J · Crystal Beach, TX · Accident · No injuries · Limited investigation · Final report · Aug 28, 1985 · N5573G · Substantial damage > The plt reportedly was delivering the acft to Crystal Beach, TX, from its home base at orange county airport, TX. The pilot reportedly call the owner and told him he had bent the acft upon landing at Crystal Beach. He was told by the owner to wait at the acft… - [NTSB ATL85LA262](https://openairdocs.org/ntsb/ATL85LA262.md): Cessna 404 · Huntington, WV · Accident · No injuries · Limited investigation · Final report · Aug 28, 1985 · N255CS · Substantial damage > Several men who were in a building at the airport reported that they could hear the aircraft on the approach and then a loud noise. They could not see the runway or the aircraft due to the fog. They got in the fire and rescue vehicles and had a hard time… - [NTSB MKC85LA194](https://openairdocs.org/ntsb/MKC85LA194.md): Cessna 182RG · Mountain Home, AR · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1985 · N756AU · Substantial damage > The acft hard landed on a soft sod rwy separating the nose wheel from the nose gear strut. The acft bounced back into the air and descended with the nose strut digging into the runway. The acft flipped inverted sustaining substantial damage. The plt stated… - [NTSB LAX85LVA04](https://openairdocs.org/ntsb/LAX85LVA04.md): Bell 204-B · East Clovis, CA · Accident · Minor injuries · Final report · Aug 27, 1985 · N204RH · Substantial damage > The acft was being flown for a maintenance ck. While climbing at about 50 ft AGL a bang was heard and eng RPM decreased. Plt initiated autorotation and attempted a flare at about 20 ft AGL. The tail rotor hit and the acft became airborne after hitting on the… - [NTSB SEA85LA202](https://openairdocs.org/ntsb/SEA85LA202.md): Cessna 182R · Reno, NV · Accident · No injuries · Limited investigation · Final report · Aug 26, 1985 · N5545N · Substantial damage > The student pilot had only 1.9 hours of flt time in the Cessna 182R and a ttl PIC time of 6.6 hrs. After practicing turns around a point at 800 ft AGL a climb was initiated. The acft was unable to clear the rising terrain due to a density alt of aprx 8200 ft.… - [NTSB NYC85LA221](https://openairdocs.org/ntsb/NYC85LA221.md): Robinson R22 · Ronkonkoma, NY · Accident · No injuries · Limited investigation · Final report · Aug 24, 1985 · N90773 · Substantial damage > During a local training flight the student was attempting a lift off and began to drift to the left. The students control input was to the left aggravating the situation. The instructor took control of the aircraft however the roll over had progressed to an… - [NTSB NYC85LA220](https://openairdocs.org/ntsb/NYC85LA220.md): Cessna 170B · Morrisville, VT · Accident · No injuries · Limited investigation · Final report · Aug 24, 1985 · N3568C · Substantial damage > According to the plt, a post maintenance test flt was performed about 45 mins before the landing occurred. The plt stated that he allowed the right seat passenger a student plt and owner of the Cessna 170, to fly and land the acft. Upon landing the plt… - [NTSB FTW85LA334](https://openairdocs.org/ntsb/FTW85LA334.md): Cessna 172B · Ada, OK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1985 · N8301X · Substantial damage > The student plt, who had been executing touch and go landings, stated that the acft bounced on touchdown and began porpoising. The student over-corrected and the acft subsequently impacted the runway in a nose low attitude damaging the prop, nose gear and the… - [NTSB ANC85LA162](https://openairdocs.org/ntsb/ANC85LA162.md): Cessna 185 · Ancorage, AK · Accident · No injuries · Limited investigation · Final report · Aug 24, 1985 · N7558H · Substantial damage > The aircraft nosed over during the landing roll. The pilot stated during the landing he lost directional control of the his aircraft causing the aircraft to nosed over on its back. - [NTSB SEA85LA201](https://openairdocs.org/ntsb/SEA85LA201.md): Cessna 182P · Snohomish, WA · Accident · No injuries · Limited investigation · Final report · Aug 23, 1985 · N7380S · Substantial damage > The acft nosed down during the landing flare. Rwy contact was hard on the main landing gear. The acft bounced and the plt added pwr and re-flared the acft. - [NTSB NYC85FHD03](https://openairdocs.org/ntsb/NYC85FHD03.md): Cessna 172 M · Lumberton, NJ · Accident · Serious injuries · Final report · Aug 22, 1985 · N13480 · Substantial damage > The plt landed hard after a long and fast approach to a night landing at a strange and his total night experience was about 5 hours of dual. When the acft bounced during the landing the plt decided to try a go-around. During the attempt the acft stalled nose… - [NTSB ATL85FMG06](https://openairdocs.org/ntsb/ATL85FMG06.md): Let L-13 · Chester, SC · Accident · No injuries · Final report · Aug 20, 1985 · N96AS · Substantial damage > The glider landed about 150 ft short of the rwy on the plts 1st solo in this acft. He said he noticed a rapid drop in alt at 55 mph on final approach and began to change spoiler position to compensate. He complained that the stiffness of the operation of the… - [NTSB SEA85LA199](https://openairdocs.org/ntsb/SEA85LA199.md): Cessna 172P · Preston, ID · Accident · No injuries · Limited investigation · Final report · Aug 19, 1985 · N54016 · Destroyed > The acft landed at Preston, ID, for fuel in a x-wind of 15-20 KTS, gusting to 30 KTS. A gust at touchdown veered the acft to the rt. The plt attempted a go-around with full flaps. Flaps were reduced as a stall occurred. The acft hit the ground and bounced… - [NTSB MKC85LA195](https://openairdocs.org/ntsb/MKC85LA195.md): Beech 95-B55 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Aug 19, 1985 · N386T · Substantial damage > The plt stated he touched down with what appeared to be a soft landing but the acft started to porpoise. A go-around was performed and another landing accomplished without incident, however, the acft was substantially damaged during the first landing. - [NTSB LAX85LA358](https://openairdocs.org/ntsb/LAX85LA358.md): Piper PA-28-180 · Bakersfield, CA · Accident · No injuries · Limited investigation · Final report · Aug 19, 1985 · N9653J · Substantial damage > The pilot stated that, as he was on the landing roll, two dogs chased a horse across the runway, and that he was unable to avoid striking the horse with the aircraft's left wing. - [NTSB ANC85LA156](https://openairdocs.org/ntsb/ANC85LA156.md): Cessna 210 · Northway, AK · Accident · No injuries · Limited investigation · Final report · Aug 19, 1985 · CFTFS · Substantial damage > The right main gear collapsed during landing. Post accident examination of the landing gear disclosed the rear door actuator rod failed and the gear door was bent. The right hand main gear downlock failed in an area which appeared to have been previously… - [NTSB SEA85LA200](https://openairdocs.org/ntsb/SEA85LA200.md): Cessna 180A · Buxton, OR · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N9607B · Substantial damage > The pilot misjudged his touchdown point on the 1,000 foot airstrip and had an excess of airspeed. And overrun occurred and the aircraft went down an embankment. At the time of touchdown, there was only about 4 KTS of headwind available. - [NTSB NYC85FFA03](https://openairdocs.org/ntsb/NYC85FFA03.md): Cessna 172L · Parishville, NY · Accident · Minor injuries · Final report · Aug 18, 1985 · N7549G · Substantial damage > The pilot was attempting a landing in a Cessna 172L on a 1250 ft grass runway. He misjudged his touch down point and landed approximately 1/2 way down the runway. The aircraft was unable to stop on the remaining runway and ran off the departure end of the… - [NTSB ANC85LA155](https://openairdocs.org/ntsb/ANC85LA155.md): Champion 7GCBC · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Aug 18, 1985 · N1868G · Substantial damage > During landing the plt applied hard braking to avoid an airplane and rolled over. - [NTSB DEN85LTG09](https://openairdocs.org/ntsb/DEN85LTG09.md): Piper PA-30/A · Bowman, ND · Accident · No injuries · Final report · Aug 17, 1985 · N7126Y · Substantial damage > The acft was landed gear up. The plt was aware of the condition at one point in the traffic pattern. A check by retarding the throttle(s) on final produced no warning horn so the plt assumed that the gear was down. After the gear up landing, the circuit… - [NTSB DEN85LA223](https://openairdocs.org/ntsb/DEN85LA223.md): Cessna 120 · Erie, CO · Accident · No injuries · Limited investigation · Final report · Aug 17, 1985 · N4113N · Substantial damage > The plt stated after the accident that she had landed and the acft rolled aprx 600 ft when she attempted to turn off onto the taxiway while the acft was traveling at a moderate speed. A witness stated that he saw the trees 'lock up' as the acft approached the… - [NTSB ATL85IA251](https://openairdocs.org/ntsb/ATL85IA251.md): Cessna 441 · Hilton Head, SC · Incident · No injuries · Incident investigation · Final report · Aug 16, 1985 · N2624D · Substantial damage > The pilot reported that the approach sequence and profile were normal, and there were no apparent aircraft problems. After touch down the pilot applied reverse thrust. During the landing roll out, the aircraft veered off the left side of the runway, collided… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=423 ## 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=422 --- 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.