# 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 447 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB ANC84LA048](https://openairdocs.org/ntsb/ANC84LA048.md): Cessna 170B · Skwentna, AK · Accident · No injuries · Limited investigation · Final report · Mar 22, 1984 · N4672C · Substantial damage > The plt elected to land on a snow covered strip that had a frozen snow crust & was rutted. He stated that during the touchdown, the acft bounced, then he elected to go around. However, the acft touched down again & broke thru the frozen crust, then nosed over. - [NTSB CHI84LA136](https://openairdocs.org/ntsb/CHI84LA136.md): Cessna 402C · Kenosha, WI · Accident · No injuries · Limited investigation · Final report · Mar 21, 1984 · N2663G · Substantial damage > The acft ran off the rwys end after the plt landed downwind to avoid flying through a 'wall of precipation'. During the rollout in slush the brakes froze. The nose gear settled in mud and collapsed. - [NTSB CHI84LA135](https://openairdocs.org/ntsb/CHI84LA135.md): Cessna 421C · Joliet, IL · Accident · No injuries · Limited investigation · Final report · Mar 21, 1984 · N260RA · Substantial damage > The acft picked up moderate to severe icing which the pilot thought he had shaken off as he cycled the deice boots. He saw the ice come off of the wings but could not see the horizontal stabilizer. On short final at 100 KTS the control yoke began vibrating.… - [NTSB DEN84LA113](https://openairdocs.org/ntsb/DEN84LA113.md): Cessna 150L · Springfield, CO · Accident · No injuries · Limited investigation · Final report · Mar 20, 1984 · N11315 · Substantial damage > According to the plt he landed too FAR on the right side of the rwy & the right wheel hit a chunk of ice. The acft veered right into a snowbank collapsing the nose gear. - [NTSB MKC84LA107](https://openairdocs.org/ntsb/MKC84LA107.md): Cessna 340 · Olathe, KS · Accident · No injuries · Limited investigation · Final report · Mar 19, 1984 · N6320X · Substantial damage > The acft skidded off the rwy into slush covered terrain alongside the rwy, dragging the left gear in the mud. As the acft continued its fwd roll the main gear struck the edge of a taxiway & collapsed backwards. The rwy was covered with slush at the time of… - [NTSB MKC84LA104](https://openairdocs.org/ntsb/MKC84LA104.md): Cessna 182 · Lincoln, NE · Accident · No injuries · Limited investigation · Final report · Mar 19, 1984 · N9996H · Substantial damage > During landing roll on the runway with crosswind conditions and restricted visibility due to ice on the windshield the acft slid left on the ice and collided with a snow bank, damaging the propeller and the right wing tip. - [NTSB MIA84LA125](https://openairdocs.org/ntsb/MIA84LA125.md): Cessna 310R · Palm Beach, FL · Accident · No injuries · Limited investigation · Final report · Mar 19, 1984 · N1UB · Substantial damage > The acft landed hard, blew the left main tire and ran off the runway. A witness stated 'the pilot came in high on final, chopped power off and landed hard.' - [NTSB MIA84LA120](https://openairdocs.org/ntsb/MIA84LA120.md): Schweizer SGU-22 · Williston, FL · Accident · No injuries · Limited investigation · Final report · Mar 18, 1984 · N50RE · Substantial damage > The acft collided with the wind tetrahedron during landing. The plt stated he landed on the grass parrllel to rwy 22 and a combination of landing long and ground effect caused him to hit the telrahedron. - [NTSB ANC84LA047](https://openairdocs.org/ntsb/ANC84LA047.md): Cessna 170B · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Mar 18, 1984 · N3927V · Substantial damage > The plt landed on hard packed snow on a glacier. Some of the crusted snow gave in and the acft swerved to the left whilenosing over. - [NTSB SEA84LA072](https://openairdocs.org/ntsb/SEA84LA072.md): Cessna A185F · Kennewick, WA · Accident · No injuries · Limited investigation · Final report · Mar 17, 1984 · N9328N · Substantial damage > The plt was performing touch and go landings when he lost control of the acft and groundlooped. The wind was gusting to 15 KTS. - [NTSB LAX84LA224](https://openairdocs.org/ntsb/LAX84LA224.md): Beech 55 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Mar 17, 1984 · N131TW · Substantial damage > The acft veered off the rwy into soft dirt collapsing the right main landing gear. The left brake was found - [NTSB ANC84LA046](https://openairdocs.org/ntsb/ANC84LA046.md): Cessna 180H · Soldotna, AK · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 1984 · N9762G · Substantial damage > The plt stated that the left wing of the acft struck small spruce trees during landing. He stated that the acft touched down 'off balance and pointed at two parked planes.' He applied power flew over the parked acft but could not avoid a large tree. - [NTSB MIA84LA113](https://openairdocs.org/ntsb/MIA84LA113.md): Cessna 172M · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Mar 16, 1984 · N1242U · Substantial damage > The aircrew were practicing touch & go landings when a loss of power occurred. Subsequently, the acft was damaged during an emergency landing in a field. An investigation revealed that the throttle linkage had become disconnected at the carburetor support… - [NTSB ATL84LA122](https://openairdocs.org/ntsb/ATL84LA122.md): Cessna 172G · Newberry, SC · Accident · Minor injuries · Limited investigation · Final report · Mar 16, 1984 · N3674L · Destroyed > The plt had executed a go-around from an approach to rwy 4 due to a crosswind & gusty wind conditions. While on downwindhe observed that the wind was favoring rwy 10. He overshot the approach end of rwy 10 & executed another go-around. Upon observing that he… - [NTSB NYC84LA109](https://openairdocs.org/ntsb/NYC84LA109.md): Beech 77 · West Mifflin, PA · Accident · Minor injuries · Limited investigation · Final report · Mar 15, 1984 · N38675 · Substantial damage > The acft landed short of the rwy and nosed over. According to the plt he felt that the acft was low on final approach and he added power. At this time the nose pitched down and the acft contacted the ground and came to rest upside down on the paved rwy. - [NTSB CHI84LA130](https://openairdocs.org/ntsb/CHI84LA130.md): Cessna 401 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Mar 15, 1984 · N777CS · Substantial damage > The acfts left main gear collapsed during the landing roll. Investigation revealed that the bolt on the top portion of the LH bellcrank assembly was sheared off. One of the tangs at the bottom of the bellcrank was also broken. When examined under a 10 power… - [NTSB MKC84LA099](https://openairdocs.org/ntsb/MKC84LA099.md): Cessna 182J · Minden, NE · Accident · No injuries · Limited investigation · Final report · Mar 14, 1984 · N2832F · Substantial damage > The plt had returned from dropping skydivers & was landing on rwy 29 at sunset. He reported that during the flare to land, he was temporarily blinded by the sun. The acft landed hard & bounced back into the air. It then settled, veered off the rwy, hit piles… - [NTSB FTW84LA169](https://openairdocs.org/ntsb/FTW84LA169.md): Cessna 172D · Belle Chasse, LA · Accident · No injuries · Limited investigation · Final report · Mar 14, 1984 · N2882U · Substantial damage > The acfts nose gear dug into mud during landing rollout. The acft then nosed over. - [NTSB ATL84LA120](https://openairdocs.org/ntsb/ATL84LA120.md): Beech 99 · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Mar 14, 1984 · N7994R · Substantial damage > The acft was landed with the landing gear up. The plt said that the sun was shining on the instrument panel and he thought he saw 3 green lights. After the acft stopped on the rwy the red light in the gear handle was on and the warninghorn was sounding. He… - [NTSB MIA84LA108](https://openairdocs.org/ntsb/MIA84LA108.md): Cessna 310N · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Mar 13, 1984 · N4197Q · Substantial damage > The plt reported that after arrival, he was cleared to land & made a landing check, but 'apparently made gear-up landing.' During an investigation, the gear operated normally. A witness stated that he saw the acft with the gear retracted. - [NTSB FTW84LA165](https://openairdocs.org/ntsb/FTW84LA165.md): Cessna 172N · Stamford, TX · Accident · No injuries · Limited investigation · Final report · Mar 12, 1984 · N6794E · Substantial damage > The acft touched down nose wheel 1st on the 3200 ft x 60 ft asphalt rwy. As the plt attempted to hold the acft on the surface, directional control was lost & the acft went off the right side of the rwy, rolling into a muddy field. The nose wheel dug into the… - [NTSB ANC84FA044](https://openairdocs.org/ntsb/ANC84FA044.md): Champion 7EC · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Mar 12, 1984 · N4374C · Substantial damage > The acft swerved and collided with a snowbank during landing. The wind was calm and the rwy dry. After the collision the right landing gear collapsed. - [NTSB NYC84LA106](https://openairdocs.org/ntsb/NYC84LA106.md): Cessna C172 · Fairfield, NJ · Accident · No injuries · Limited investigation · Final report · Mar 10, 1984 · N64493 · Substantial damage > The acft hit a snowdrift during landing roll and veered left into a snowbank. The acft nosed down, striking the right wing tip and propellers. - [NTSB MIA84LA103](https://openairdocs.org/ntsb/MIA84LA103.md): Maule M4-220 · Boca Raton, FL · Accident · No injuries · Limited investigation · Final report · Mar 10, 1984 · N40330 · Destroyed > The plt stated that while practicing touch & go's he lost directional control & the left landing gear collapsed. - [NTSB LAX84LA212](https://openairdocs.org/ntsb/LAX84LA212.md): Cessna 172P · Pacoima, CA · Accident · No injuries · Limited investigation · Final report · Mar 10, 1984 · N52702 · Substantial damage > During the overflight of the uncontrolled field, both plts noticed that the wind tee indicated rwy 12 as the landing direction. During landing, the acft floated & touched down about 2/3 down the rwy. The acft struck a fence & trees at the end of the rwy.… - [NTSB LAX84LA211](https://openairdocs.org/ntsb/LAX84LA211.md): Grumman AA-5B · Carlsbad, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1984 · N74862 · Substantial damage > The plt reported that when the acft was about 10 ft AGL & he was beginning to flare for a landing on rwy 24, a slight gust of wind caused the plane to drift to the edge of the rwy. The plt began correcting for the drift, but the passenger grabbed the yoke &… - [NTSB FTW84LA164](https://openairdocs.org/ntsb/FTW84LA164.md): Eagle Balloons Eagle C-7 · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1984 · N6081L · Substantial damage > The plt stated that the wx at the accident site was scattered clouds between 150-650 ft AGL with a definite ceiling at 650 ft (broken). Visibility was 1 mi with rapidly forming fog layer. The plt descended with the intention of landing as soon as possible. He… - [NTSB CHI84LA212](https://openairdocs.org/ntsb/CHI84LA212.md): Piper PA-28R-200 · Stow, OH · Accident · No injuries · Limited investigation · Final report · Mar 10, 1984 · N9111K · Substantial damage > The acft ran off the rwy & collided with a snowbank during landing. The acft had been subjected to previous damage whichhad not been fully repaired when a mechanic released it for further flt. A bolt (slightly worn, according to the mechanic) was reused in… - [NTSB CHI84LA128](https://openairdocs.org/ntsb/CHI84LA128.md): Cessna 421B · Madison, WI · Accident · No injuries · Limited investigation · Final report · Mar 10, 1984 · N41022 · Substantial damage > The acft went off the rwy to the left during landing. There was a crosswind of 15-28 KTS at the time. The plt said the acft veered left and could not be controlled. After the accident the was 464P-26 bolt and 5133-4032 spacer were sheared off both the left… - [NTSB ATL84LA131](https://openairdocs.org/ntsb/ATL84LA131.md): Pitts Special S2A · Apex, NC · Accident · No injuries · Limited investigation · Final report · Mar 10, 1984 · N83798 · Substantial damage > The acft made a hard landing and damaged a brake. During the second landing the brakes were found to be malfunctioning and as the rudder became ineffectual the acft left the rwy and collided with a hanger. The owner of the acft was improperly acting as an… - [NTSB ANC84FA045](https://openairdocs.org/ntsb/ANC84FA045.md): Cessna 152 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Mar 9, 1984 · N68291 · Substantial damage > The acft had previously been involved in an accident in which the airframe was substantially damaged. It was then rebuilt & put back into service. Since then, it had been flown about 24 hrs using a snow covered rwy for takes & landing. During the 1st… - [NTSB FTW84LA186](https://openairdocs.org/ntsb/FTW84LA186.md): Lockheed VEGA-1 · Yukon, OK · Accident · No injuries · Limited investigation · Final report · Mar 8, 1984 · N12288 · Substantial damage > The plt was practicing touch-&-go landings & lost control of the acft. It swerved to the left onto soft terrain & went over on its nose. At 1st, the plt made comments about improper strut inflation. However, later, he reported that wx was not a problem & that… - [NTSB FTW84IA163](https://openairdocs.org/ntsb/FTW84IA163.md): Beech BE-200 · Fort Worth, TX · Incident · No injuries · Incident investigation · Final report · Mar 8, 1984 · N888B · Minor damage > Acft veered rt on touchdown. Heavy braking and differential pwr used to maintain directional control. Both rt side tires and the left outboard tire blew during rollout. Plt stated left main gear unsafe light illuminated during rollout. After engines were… - [NTSB CHI84IA127](https://openairdocs.org/ntsb/CHI84IA127.md): Boeing 737-200 · Erlanger, KY · Incident · No injuries · Incident investigation · Final report · Mar 8, 1984 · N794N · No damage > While the acft was about 15 mi sw of the arpt being vectored for a rwy 36 cat ii approach, the local controller gave theground controller permission to clear snow removal equipment to proceed north on rwy 36 & to exit rwy 36 at the intersection of rwy 27L.… - [NTSB ATL84FA115](https://openairdocs.org/ntsb/ATL84FA115.md): Sikorsky S-76A · Spartanburg, SC · Accident · Serious injuries · Field investigation · Final report · Mar 6, 1984 · N15479 · Substantial damage > The acft collided with trees during a landing at a company helipad. The weather was IMC with low ceilings and fog. The acft had been cleared for a VOR approach monitored by radar. The co-plt spotted the pad and called it out to the plt who started a steep… - [NTSB LAX84LA206](https://openairdocs.org/ntsb/LAX84LA206.md): Cessna 170B · Fullerton, CA · Accident · No injuries · Limited investigation · Final report · Mar 5, 1984 · N4630C · Substantial damage > The acft ran off the rwy during landing. The plt said the'right brake was not functioning properly.' The acft collided with a rwy light and collapsed the right main gear. - [NTSB ATL84FKG05](https://openairdocs.org/ntsb/ATL84FKG05.md): Piper PA-34-220T · Madison, GA · Accident · 1 fatal · Final report · Mar 5, 1984 · N2912X · Substantial damage > The acft collided with a car while landing on an airstrip at night. The car had been parked on the strip & an occupant in the car was fatally injured. An illicit substance was found aboard the acft & it was confiscated by law enforcement officials. Rain & fog… - [NTSB NYC84LA101](https://openairdocs.org/ntsb/NYC84LA101.md): Piper PA-38-112 · Norwood, MA · Accident · No injuries · Limited investigation · Final report · Mar 4, 1984 · N9175A · Substantial damage > The student plt was practicing touch and go landings. The plt reported that the acft encountered a strong gust of wind about 5 ft AGL during the 2nd landing. The touchdown was made on the right main gear as the acft skidded and bounced. The next landing was… - [NTSB NYC84LA098](https://openairdocs.org/ntsb/NYC84LA098.md): Luscombe 8E · Bedford, MA · Accident · No injuries · Limited investigation · Final report · Mar 4, 1984 · N2843K · Substantial damage > The acft was decelerating at about 35 mph during roll when a gust of wind picked up the right wing and the acft veered to the right. Full power was applied to regain control and during acceleration the right main gear collapsed and the acft pivoted right and… - [NTSB CHI84LA125](https://openairdocs.org/ntsb/CHI84LA125.md): Cessna 152 · Strongsville, OH · Accident · No injuries · Limited investigation · Final report · Mar 4, 1984 · N48898 · Substantial damage > The CFI stated that on the second landing, during the flare, the acft veered off the left side of the rwy due to the rt crosswind. He stated that he attempted to take control of the acft but it was already off the rwy in a two to three ft deep snowbank. The… - [NTSB ATL84LID01](https://openairdocs.org/ntsb/ATL84LID01.md): Champion S-150 · Ft. Eustis, VA · Accident · No injuries · Final report · Mar 4, 1984 · N5046N · Substantial damage > The plt reported that he made a smooth landing using full flaps. He stated that suddenly with no warning, the left wing came up and the right wing hit the runway. The acft went off the left side of the runway and the rt main gear collapsed. Investigation… - [NTSB NYC84LA303](https://openairdocs.org/ntsb/NYC84LA303.md): Cessna R182 · Boston, MA · Accident · No injuries · Limited investigation · Final report · Mar 3, 1984 · N9159C · Substantial damage > According to the plt, due to landing traffic he was requested by ATC to keep his airspeed as fast as possible. A hard landing resulted at 110 KTS. - [NTSB DEN84LA104](https://openairdocs.org/ntsb/DEN84LA104.md): Gates Learjet 25D · Denver, CO · Accident · No injuries · Limited investigation · Final report · Mar 3, 1984 · XALAP · Substantial damage > About 1 mi from the arpt while established on the glide slope, the plt was advised by the controller to go around due totraffic on the ground. Just after the plt advanced the throttles & retracted the landing gear, the controller again cleared the plt for… - [NTSB CHI84LA129](https://openairdocs.org/ntsb/CHI84LA129.md): Cessna 150M · Hagerstown, IN · Accident · No injuries · Limited investigation · Final report · Mar 3, 1984 · N714MC · Substantial damage > During the rollout after a normal landing the acft collided with a snowdrift on the sod rwy. The collision collapsed theacft nose gear and damaged the propeller and firewall of the acft. - [NTSB CHI84LA124](https://openairdocs.org/ntsb/CHI84LA124.md): Cessna 152 · Taylorville, IL · Accident · No injuries · Limited investigation · Final report · Mar 3, 1984 · N67919 · Substantial damage > The acft collided with a snowbank and nosed over during landing. The student plt said a nose wheel shimmy developed during landing roll and he was unable to keep the acft on the 6O ft wide rwy. - [NTSB ATL84IA117](https://openairdocs.org/ntsb/ATL84IA117.md): Beech 19A Sport III · Atlanta, GA · Incident · No injuries · Incident investigation · Final report · Mar 3, 1984 · N6968Q · Minor damage > The student plt landed hard & the nose gear collapsed while on a supervised solo flt. The acft slid off the rwy but remained upright. - [NTSB CHI84LA122](https://openairdocs.org/ntsb/CHI84LA122.md): Cessna R172K · Marion, OH · Accident · No injuries · Limited investigation · Final report · Mar 1, 1984 · N736JT · Substantial damage > The plt lost directional control of the acft during landing on an icy rwy in a gusty crosswind. The acft skidded to the left and contacted a snowbank, after which it nosed over. - [NTSB ATL85LA048](https://openairdocs.org/ntsb/ATL85LA048.md): Aero Commander 1121 · Salisbury, NC · Accident · No injuries · Limited investigation · Final report · Mar 1, 1984 · N454SR · Substantial damage > In March, 1984, N454SR reportedly sustained substantial damage during a hard landing. The accident was reported by a former FAA inspector on 11/29/84. - [NTSB MKC84LA088](https://openairdocs.org/ntsb/MKC84LA088.md): Piper PA-18 · Point Lookout, MO · Accident · No injuries · Limited investigation · Final report · Feb 29, 1984 · N74WB · Substantial damage > The plt angled in on the final approach at low alt. And the right landing gear hit a snowbank. The collision pulled the acft into the snow and it nosed over. - [NTSB NYC84LA094](https://openairdocs.org/ntsb/NYC84LA094.md): Cessna 500 · Fitchburg, MA · Accident · No injuries · Limited investigation · Final report · Feb 28, 1984 · N712US · Substantial damage > The plt landed on a slushy rwy. He was unable to stop on the rwy and angled off the end into marshy ground. The stoppingdistance on a dry rwy was figured at 2355 ft. on a slushy rwy the stopping distance was about 4004 ft. the landing rwy was 4500 ft long.… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=448 ## 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=447 --- 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.