# 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 446 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB SEA84LA084](https://openairdocs.org/ntsb/SEA84LA084.md): Cessna C-172M · West Sound, WA · Accident · No injuries · Limited investigation · Final report · Apr 14, 1984 · N12811 · Substantial damage > The acft nosed over during landing after the occupants had misidentified the landing area in a farmers field. During roll-out in the soft soil the landing gear bogged down and the acft flipped over. - [NTSB SEA84LA081](https://openairdocs.org/ntsb/SEA84LA081.md): Cessna 150 · Challis, ID · Accident · No injuries · Limited investigation · Final report · Apr 14, 1984 · N3907J · Destroyed > The student plt on a supervised solo flt made a hard landing and during the bouncing the acft hit nose gear first. The nose gear collapsed and the acft slid to a stop in a nose down attitude. - [NTSB FTW84LA199](https://openairdocs.org/ntsb/FTW84LA199.md): Cessna 152 · Tulsa, OK · Accident · No injuries · Limited investigation · Final report · Apr 14, 1984 · N24708 · Substantial damage > The student was on his 3rd solo flt, practicing touch-&-go landings. According to witnesses, the acft initially touched down short of the rwy, then bounced onto the prepared surface. The acft porpoised several times. The plt made no attempt to go around. - [NTSB ATL84FLT08](https://openairdocs.org/ntsb/ATL84FLT08.md): Cessna 172 · Walls, MS · Accident · No injuries · Final report · Apr 13, 1984 · N8008X · Substantial damage > The plt stated that he stalled the acft about 15 ft AGL. When the acft hit the rwy it flipped over. - [NTSB SEA84LA086](https://openairdocs.org/ntsb/SEA84LA086.md): Cessna 182Q · Neah Bay, WA · Accident · No injuries · Limited investigation · Final report · Apr 11, 1984 · N4725N · Substantial damage > The plt landed long on the 1200 ft rwy and after overruning the end the acft collided with a ditch. The Washington state pilot's guide denotes the airport as 'closed-for emergency use only', and 'watch for livestock'. According to witnesses there were horses… - [NTSB FTW84LA200](https://openairdocs.org/ntsb/FTW84LA200.md): Maule M-6-235 · New Orleans, LA · Accident · No injuries · Limited investigation · Final report · Apr 11, 1984 · N71MS · Substantial damage > Shortly after touchdown on a x-wind landing, the tailwheel equipped acft began to weathervaned to the left into the wind. The plt lost directional control & the acft ground looped to the left. The right gear collapsed & the right wing dragged on the ground.… - [NTSB ANC84LA055](https://openairdocs.org/ntsb/ANC84LA055.md): Champion 7GCBC · Bettles, AK · Accident · No injuries · Limited investigation · Final report · Apr 11, 1984 · N7527F · Substantial damage > The acft groundlooped during landing. The plt said he lost control of the acft. During the swerve one of the gear legs failed and the acft skidded on the fuselage. - [NTSB CHI84LA151](https://openairdocs.org/ntsb/CHI84LA151.md): Cessna 172P · Cincinnati, OH · Accident · Minor injuries · Limited investigation · Final report · Apr 10, 1984 · N62164 · Substantial damage > The student pilot, with an instructor pilot, were practicing touch & go landings. On the approach, the student allowed the speed to decrease, the acft stalled and landed hard and bounced back in the air. The student pilot added power to go around but did not… - [NTSB ANC84LA054](https://openairdocs.org/ntsb/ANC84LA054.md): Cessna 180 · Kodiak, AK · Accident · No injuries · Limited investigation · Final report · Apr 10, 1984 · N4929A · Substantial damage > The acft was landed in winds reported as 35 to 42 KTS. According to the plt control was lost during the landing roll andthe acft ground looped to the right. The plt stated that there were no mechanical irregularities with the acft. - [NTSB ANC84FA052](https://openairdocs.org/ntsb/ANC84FA052.md): Bellanca 7GCBC · Anchorage, AK · Accident · Minor injuries · Field investigation · Final report · Apr 9, 1984 · N68578 · Substantial damage > The student plt reported that when he was on final apch to land, the acft encountered turbulence at about 40 ft AGL, then bounced on the rwy. He applied power to go around, but lost directional control. The acft yawed left, veered off the rwy, knocked over a… - [NTSB MIA84LA132](https://openairdocs.org/ntsb/MIA84LA132.md): Cessna 182 · Ormond Beach, FL · Accident · No injuries · Limited investigation · Final report · Apr 8, 1984 · N92147 · Substantial damage > During a hard landing, the prop, nose gear, eng mounts & firewall were damaged. The winds were gusting to 21 KTS. - [NTSB LAX84LA246](https://openairdocs.org/ntsb/LAX84LA246.md): Balloon Works Fire FLY 6B · Prescott Valley, AZ · Accident · Serious injuries · Limited investigation · Final report · Apr 8, 1984 · N2014F · No damage > When the Balloon took off, the winds were virtually calm. However, during the last 30 minutes of flt, the surface winds increased to an estimated 15 KTS which necessitated a high wind landing. The gondola tipped over during the landing & one of the passengers… - [NTSB CHI84LA149](https://openairdocs.org/ntsb/CHI84LA149.md): Grumman G-164B · Leesburg, OH · Accident · No injuries · Limited investigation · Final report · Apr 8, 1984 · N48546 · Substantial damage > The plt decided to land in a hay field to talk to the farmer about the aerial seeding operation he was conducting. During the landing the plt said the acft hit a soft spot in the field and nosed over. - [NTSB MKC84LA121](https://openairdocs.org/ntsb/MKC84LA121.md): Piper PA-38 · St. Joseph, MO · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N25731 · Substantial damage > The acft was landed in a gusty crosswind. The acft ballooned and landed hard which collapsed the nose gear. - [NTSB MIA84LA131](https://openairdocs.org/ntsb/MIA84LA131.md): Piper PA-23-250 · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N6890Y · Substantial damage > The plt could not get the left main gear extended for landing and then could not get the right main and nose gear to retract for a'belly'landing. The acft was landed on the sod beside the rwy with the left main retracted. The nose gear collapsed during the… - [NTSB ATL84LA142](https://openairdocs.org/ntsb/ATL84LA142.md): Aero Commander 560F · Hilton, SC · Accident · No injuries · Limited investigation · Final report · Apr 7, 1984 · N6368U · Substantial damage > The acft was landed with the gear retracted. The nose gear light indicating down remained'on' at all itmes but had no bearing on the landing gear extension/retraction system. The plt did not report using a checklist or lowering the landing gear. The landing… - [NTSB DEN84LA125](https://openairdocs.org/ntsb/DEN84LA125.md): Piper PA-18 · Barnard, SD · Accident · No injuries · Limited investigation · Final report · Apr 6, 1984 · N7594K · Substantial damage > During a landing in a soy bean field the acft encountered a soft muddy spot which caused the acft to nose over. - [NTSB MKC84LA118](https://openairdocs.org/ntsb/MKC84LA118.md): Cessna 402 · Gardner, KS · Accident · No injuries · Limited investigation · Final report · Apr 5, 1984 · N3950C · Substantial damage > While landing on rwy 26 the left gear struck an open upheaval of dirt & asphalt, collasping the left main gear. A go-around was executed, & the plt landed on runway 35 with the right main gear and nose gear retracted. - [NTSB MKC84LA117](https://openairdocs.org/ntsb/MKC84LA117.md): Cessna 401 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Apr 5, 1984 · N101SB · Substantial damage > The plt reported that 3-4 secs after he made a smooth landing, the right main landing gear collapsed. The acft then went off the side of the rwy & struck a sign. Post-accident inspection indicated that the right gear had been down & locked before the gear had… - [NTSB SEA84LA077](https://openairdocs.org/ntsb/SEA84LA077.md): Cessna 180-A · Garfield, WA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1984 · N88666 · Substantial damage > The acft was landed in a soft stubble field. The landing gear mired and the acft ground looped breaking the right main landing gear. - [NTSB NYC84LA132](https://openairdocs.org/ntsb/NYC84LA132.md): Cessna 140 · Jeanette, PA · Accident · No injuries · Limited investigation · Final report · Apr 4, 1984 · N3BQ · Substantial damage > One of the aircrew members was buying the acft & was receiving dual instruction before flying solo. After several landings, he flared for a 3-point landing. During the landing roll, the acft began drifting left & the student correctedback to the right. The… - [NTSB LAX84LA240](https://openairdocs.org/ntsb/LAX84LA240.md): Beech 95-B55 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Apr 4, 1984 · N5802S · Substantial damage > The gear was inadvertently retracted at about 50 mph by the pilot in command during landing roll. - [NTSB SEA84LA076](https://openairdocs.org/ntsb/SEA84LA076.md): Lake LA-4 · Alderwood Manor, WA · Accident · No injuries · Limited investigation · Final report · Apr 3, 1984 · N6665L · Substantial damage > According to a witness, he observed the acft from taxi to takeoff, then from base throughout the landing. He observed the acft with the gear down on base leg & said the plt flew a low & short final apch. He stated the plt cut power short of the rwy & the acft… - [NTSB NYC84LA131](https://openairdocs.org/ntsb/NYC84LA131.md): Piper PA-38-112 · Forty Fort, PA · Accident · No injuries · Limited investigation · Final report · Apr 3, 1984 · N23217 · Substantial damage > During a supervised solo flt, the student plt had difficulty with directional control on his 6th landing. Subsequently, the acft swerved & the landing gear and wing were damaged. - [NTSB NYC84LA128](https://openairdocs.org/ntsb/NYC84LA128.md): Piper PA-22-150 · Factoryville, PA · Accident · No injuries · Limited investigation · Final report · Apr 2, 1984 · N6869B · Substantial damage > Plt stated that he inadvertently allowed the acft to drift left during the landing roll when he reached for the hand brake. The left main and nose gears contacted a snow bank and the acft nosed over. - [NTSB MKC84FA114](https://openairdocs.org/ntsb/MKC84FA114.md): Canadair CL-600 Challenger · Little Rock, AR · Accident · No injuries · Field investigation · Final report · Apr 2, 1984 · N800CC · Substantial damage > The acft was on an FAA certification flt (experimental). During the recovery phase, a non-type rated FAA plt was in the l seat & the PIC was in the r seat. While descending, a duct fail lgt & a leading edge overheat lgt came on. The PIC took corrective… - [NTSB NYC84LA127](https://openairdocs.org/ntsb/NYC84LA127.md): Cessna 152 · Hopedale, MA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1984 · N46837 · Substantial damage > During the sixth landing on the dual instructional flt, the acft veered to the left. The instructor took over the controls and applied right rudder but the acft contacted a snow bank and nosed over. - [NTSB NYC84LA125](https://openairdocs.org/ntsb/NYC84LA125.md): Piper J3C-65 · Stow, MA · Accident · No injuries · Limited investigation · Final report · Apr 1, 1984 · N1141V · Substantial damage > During the landing roll, the acft began drifting to the left & the student plt overcontrolled with the rudder. Subsequently, the acft departed the rwy, collided with a snowbank & nosed over. The instructor (CFI) took control of theacft as the veer was taking… - [NTSB NYC84LA124](https://openairdocs.org/ntsb/NYC84LA124.md): Beech B19 · Simsbury, CT · Accident · No injuries · Limited investigation · Final report · Apr 1, 1984 · N18871 · Substantial damage > During an instructional flt, a landing was made during which control of the acft was lost and the acft collided with a snow bank hard enough to shear off one of the main landing gear. The other main gear collapsed but the nose gear did not. The instructor… - [NTSB FTW84LA181](https://openairdocs.org/ntsb/FTW84LA181.md): Aeronca 7BCM · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Apr 1, 1984 · N26336 · Substantial damage > The plt lost directional control of the acft during landing roll & collided with 2 parked acft. The pilot stated that immediately upon runway contact the acft veered to the right toward the parked acft. He applied half throttle & full left rudder. Directional… - [NTSB CHI84LA144](https://openairdocs.org/ntsb/CHI84LA144.md): Cessna 150 · Delaware, OH · Accident · No injuries · Limited investigation · Final report · Mar 31, 1984 · N11347 · Substantial damage > The student plt made a hard landing and during the resulting bounces made incorrect control inputs according to the CFI who was aboard the acft. By the time the CFI took corrective action the acft stalled and dragged a wing. - [NTSB MIA84LA130](https://openairdocs.org/ntsb/MIA84LA130.md): Beech N-35 · Daytona Beach, FL · Accident · No injuries · Limited investigation · Final report · Mar 30, 1984 · N12353 · Substantial damage > The acft landing gear collapsed during landing. The plt said he did a 'gump' checklist prior to landing and believed he was in a landing configuration. He also stated that he did'not know weather or not he raised the gear during the landingflare'. - [NTSB LAX84LA238](https://openairdocs.org/ntsb/LAX84LA238.md): Cessna A185E · Tulelake, CA · Accident · No injuries · Limited investigation · Final report · Mar 30, 1984 · N70060 · Substantial damage > The plt stated that a gusty left x-wind existed. After touchdown, the acft ground looped, went off the left side of the rwy & nosed over. He estimated that the wind was from 200 deg at 15 KTS. - [NTSB MIA84LA123](https://openairdocs.org/ntsb/MIA84LA123.md): Cessna 210M · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Mar 29, 1984 · N761PF · Substantial damage > The plt reported that while he was landing in gusty x-wind conditions, the acft landed hard on its nose gear & the nose gear collapsed. He reported that the wind was from 300 deg gusting to 32 KTS. About 40 mi wsw at key west, FL, the wind was from 310 deg at… - [NTSB LAX84LA234](https://openairdocs.org/ntsb/LAX84LA234.md): Cessna 210 · Novato, CA · Accident · No injuries · Limited investigation · Final report · Mar 29, 1984 · N9614Y · Substantial damage > The acft landed hard and bounced. After several bounces directional control was lost and the acft colided with a ditch alongside the rwy. - [NTSB LAX84LA235](https://openairdocs.org/ntsb/LAX84LA235.md): Bellanca 14-19-3 · Temple Bar, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 28, 1984 · N8801R · Substantial damage > According to the plt, he lost directional control during the landing & the acft zig-sagged down the rwy. He did not use brakes for fear of a nose over. On the last 30% of the rwy, he attempted a go-around; however, the acft veered off the rwy & crashed in… - [NTSB DEN84LA118](https://openairdocs.org/ntsb/DEN84LA118.md): Cessna A188B · Hardin, MT · Accident · No injuries · Limited investigation · Final report · Mar 28, 1984 · N92593 · Substantial damage > The plt returned to the arpt with about a 100 gal load of spray solution on board when the flagger would not work. During the landing, the acft swerved to the left & the right gear collapsed. No mechanical malfunction or failure of the gear or brakes was… - [NTSB CHI84LA143](https://openairdocs.org/ntsb/CHI84LA143.md): Cessna P210N · West Chicago, IL · Accident · No injuries · Limited investigation · Final report · Mar 28, 1984 · N4715A · Substantial damage > The plt stated that a normal landing was made. After landing during the rollout the acft weathervaned and the plt said he heard a'chattering'noise. The acft skipped sideways off the rwy into the mud. Winds were gusting 32 KTS. The plt stated he was over… - [NTSB MKC84LA112](https://openairdocs.org/ntsb/MKC84LA112.md): Cessna A188B · Mcgehee, AR · Accident · No injuries · Limited investigation · Final report · Mar 26, 1984 · N4841Q · Destroyed > The plt stated that he made a wheel landing in an ag strip. As the forward speed decresaed, the tail was lowered to the ground. The acft was nearly stopped when the tail started up & the acft nosed over. The plt stated that before the accident, the winds were… - [NTSB FTW84LA176](https://openairdocs.org/ntsb/FTW84LA176.md): Cessna 188 · Clayton, LA · Accident · No injuries · Limited investigation · Final report · Mar 26, 1984 · N8197V · Substantial damage > During the last landing of the day in a gusty crosswind, the acft went off the side of the rwy and nosed down in a plowed field. This was the plts 26th landing for this day, all on the same rwy. The wind was gusting to 20 KTS. - [NTSB FTW84LA175](https://openairdocs.org/ntsb/FTW84LA175.md): Cessna 182J · Weatherford, TX · Accident · No injuries · Limited investigation · Final report · Mar 26, 1984 · N2689F · Substantial damage > The acft landed long & fast with a 10 kt tailwind. The pilot was unable to stop the acft on the remaining rwy & ran of of the end. The left brake was found inop due to a lack of brake fluid. The acft was observed to veer to the right of the rwy prior to… - [NTSB NYC84LA122](https://openairdocs.org/ntsb/NYC84LA122.md): Cessna 172M · Fitchburg, MA · Accident · No injuries · Limited investigation · Final report · Mar 25, 1984 · N1474U · Substantial damage > During a touch-&-go landing, the student plt lost directional control. The acft landed slightly sideways on the right main gear & the right wing tip hit the ground. The right wing, prop, eng mount & nose gear were damaged. - [NTSB NYC84LA120](https://openairdocs.org/ntsb/NYC84LA120.md): Piper PA-22-108 · Lawrence, MA · Accident · No injuries · Limited investigation · Final report · Mar 25, 1984 · N4641Z · Substantial damage > The plt reported that the acft ballooned on landing, & on the 2nd touchdown, it veered left towards a snowbank. He maneuvered to avoid the snowbank, but the nose wheel collapsed in soft mud. - [NTSB NYC84LA119](https://openairdocs.org/ntsb/NYC84LA119.md): Cessna C172 · Corry, PA · Accident · No injuries · Limited investigation · Final report · Mar 25, 1984 · N52538 · Substantial damage > The pilot stated that he landing on runway 32 and on initial touchdown the nosewheel contacted the runway after the right main gear, causing the aircraft to ascend back into the air. The aircraft 'porpoised', the left wing tip dipped and collided with a… - [NTSB MKC84LA111](https://openairdocs.org/ntsb/MKC84LA111.md): Piper PA-23-150 · Oelwein, IA · Accident · No injuries · Limited investigation · Final report · Mar 25, 1984 · N2128P · Substantial damage > The acft landed gear up. The pilot said he was distracted by the call of another acft on unicum & began looking for thatacft in or near the traffic pattern. - [NTSB LAX84LA231](https://openairdocs.org/ntsb/LAX84LA231.md): Balloon Works Fire FLY 8-24 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Mar 24, 1984 · N36104 · Minor damage > The plt took off on a sight-seeing Balloon flt with 5 passengers whose ages were reportedly from 65 to 83 yrs old. About 1 hr & 15 mins later, he landed on desert terrain in winds that he estimated were aprx 10 KTS gusting to 15 KTS. During touchdown, the… - [NTSB CHI84LA139](https://openairdocs.org/ntsb/CHI84LA139.md): Cessna 150M · White Cottage, OH · Accident · No injuries · Limited investigation · Final report · Mar 24, 1984 · N704CG · Substantial damage > The student plt became lost during his first solo x-country. He stated that he noticed that the fuel tanks were near empty so he decided to make a precautionary landing. The acft landed in a rough field & struck a plowed furrow. The plt's CFI stated that… - [NTSB ATL84LA132](https://openairdocs.org/ntsb/ATL84LA132.md): Mitsubishi MU-2B-20 · Charlotte, NC · Accident · No injuries · Limited investigation · Final report · Mar 23, 1984 · N5HE · Substantial damage > Upon landing the nose landing gear sheared off the acft. Exam of the nose gear revealed that two fatigue cracks had propogated to the point of total failure. The gear was the subject of an airworthiness directive that required inspection of the gear… - [NTSB DEN84IA116](https://openairdocs.org/ntsb/DEN84IA116.md): Boeing 727-224 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Mar 22, 1984 · N88709 · No damage > Prior to taxiing at chicago, the plt had the ramp agent(r/a) check the rear airstair as the aft airstair light on the second officer's panel was 'on'. The r/a recycled the airstair & reported that it appeared closed. The light remained onso the plt referred… - [NTSB ATL84LA127](https://openairdocs.org/ntsb/ATL84LA127.md): Cessna 172 · Parchman, MS · Accident · No injuries · Limited investigation · Final report · Mar 22, 1984 · N84809 · Substantial damage > The plt reported that during the visual approach to runway 27, he misaligned the acft with the unlighted runway and touched down left of the landing area. The acft collided with a ditch and nosed over. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=447 ## 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=446 --- 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.