# 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 404 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB LAX87LA115](https://openairdocs.org/ntsb/LAX87LA115.md): Piper PA-28R-180 · Tulare, CA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1987 · N7498J · Substantial damage > The pilot attempted to land while the runway and VASI approach lights were off. The night was dark and he inadvertently landed on a roadway parallel to the runway. The aircraft collided with a fence when the road came to a dead end adjacent to the near… - [NTSB LAX87LA114](https://openairdocs.org/ntsb/LAX87LA114.md): Cessna 152 · El Monte, CA · Accident · No injuries · Limited investigation · Final report · Feb 10, 1987 · N25884 · Substantial damage > During a local instructional flight, the pilot reported that while on the base leg to runway 19 the aircraft was a bit high but was corrected while on final approach. Upon landing the aircraft touched-down in a three point attitude and ballooned up. On the… - [NTSB SEA87LA055](https://openairdocs.org/ntsb/SEA87LA055.md): Cessna 150E · Joseph, OR · Accident · No injuries · Limited investigation · Final report · Feb 8, 1987 · N3079J · Substantial damage > Plt was on first flight of season. After two hours flying, landing was attempted on dry hard-surface runway in slight tailwind. During roll-out, left drift developed. Use of right brake caused tail of acft to lift. Plt applied both brakes and acft nosed over… - [NTSB SEA87LA054](https://openairdocs.org/ntsb/SEA87LA054.md): Robinson R22 · Brinnon, WA · Accident · No injuries · Limited investigation · Final report · Feb 8, 1987 · N9076Y · Substantial damage > When psgr became nauseous in flt, plt attempted downwind lndg onto pinnacle in rough terrain. Acft contacted slope short of intended point of lndg, main rotor flexed downward, severing tail boom. - [NTSB FTW87LA063](https://openairdocs.org/ntsb/FTW87LA063.md): Cessna 172N · Bay City, TX · Accident · No injuries · Limited investigation · Final report · Feb 8, 1987 · N6129D · Substantial damage > According to the pilot, during flare/touchdown the aircraft was substantially damaged when he lost control of the aircraft due to a cross wind. - [NTSB NYC87LA083](https://openairdocs.org/ntsb/NYC87LA083.md): Cessna 172 · Caldwell, NJ · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N4792D · Substantial damage > The student plt was on his 1st supervised solo flt. He stated that drg a touch-&-go lndg, he cleaned up the acft & applied power, but as the speed increased, the nosewheel began to shimmy & the acft veered to the left. The student said he shut-off the power &… - [NTSB NYC87LA080](https://openairdocs.org/ntsb/NYC87LA080.md): Cessna 172 · Livingston, NY · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N62429 · Substantial damage > During landing roll, the aircraft encountered patchy ice on the runway surface causing the aircraft to skid out of control and impact a snowbank. - [NTSB NYC87LA079](https://openairdocs.org/ntsb/NYC87LA079.md): Grumman American AA-5A · Beverly, MA · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N472EH · Substantial damage > Student pilot became lost and disoriented during enroute flight to the manchester area and landed at Beverly airport instead. During landing roll, the aircraft drifted to the left of the runway and collided with a snowbank, breaking off the nose gear and… - [NTSB MIA87LA082](https://openairdocs.org/ntsb/MIA87LA082.md): Cessna 152 · Venice, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 7, 1987 · N6237M · Substantial damage > Full flap x-wind take off & landings were being conducted on rwy 13 with the winds at 210 to 220 degs at 10 KTS, or a right x-wind component of 80 to 90 degs. The student plt permitted the acft to get too slow while about 10 ft above the ground. A high sink… - [NTSB FTW87LA056](https://openairdocs.org/ntsb/FTW87LA056.md): Cessna T210L · Borger, TX · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N6969R · Substantial damage > According to the pilot, during flare/touchdown the aircraft was substantially damaged when the right brake jammed causing the aircraft to veer off the rt side of the runway and into a gulley. However witnesses stated that the aircraft came in fast and landed… - [NTSB DEN87LA051](https://openairdocs.org/ntsb/DEN87LA051.md): Cessna 172 M · Air Force Acade, CO · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N9582V · Substantial damage > While making a landing, the acft landed hard and began to porpoise. After the third bounce, the nose gear collapsed. - [NTSB CHI87LA079](https://openairdocs.org/ntsb/CHI87LA079.md): Cessna 150K · Clear Lake, MN · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N5884G · Substantial damage > The plt stated that near the touchdown point a gust 'jarred' the acft and the throttle in the forward position. According to the plt, the acft 'took a steep left' and he leveled the wings, however there was not time to avoid trees which were about 100-150… - [NTSB BFO87LA019](https://openairdocs.org/ntsb/BFO87LA019.md): Cessna 152II · Clinton, MD · Accident · No injuries · Limited investigation · Final report · Feb 7, 1987 · N94197 · Substantial damage > The plt stated he made a normal approach and touchdown. On roll-out, after the flaps were retracted, a pulling was noted to the left. The acft swerved off the left side of the rwy, collided with a snowbank, and flipped over. A witness located in the run-up… - [NTSB NYC87LA082](https://openairdocs.org/ntsb/NYC87LA082.md): Piper PA-28R-200 · Marlboro, MA · Accident · No injuries · Limited investigation · Final report · Feb 6, 1987 · N1486X · Substantial damage > The pilot allowed the aircraft to stall and touch down hard causing substantial damage. The pilot was unfamiliar with the short field at this airport. - [NTSB ATL87LA070](https://openairdocs.org/ntsb/ATL87LA070.md): Swearingen SA-226TC · Florence, SC · Accident · No injuries · Limited investigation · Final report · Feb 6, 1987 · N1013G · Substantial damage > During the final leg of a domestic scheduled commuter airline flight the aircraft landed with the landing gear in the retracted position. The captain could not recall placing the gear selector handle in the down position and the co-pilot could not remember… - [NTSB NYC87LA077](https://openairdocs.org/ntsb/NYC87LA077.md): Stinson 108 · Wildwood, NJ · Accident · No injuries · Limited investigation · Final report · Feb 5, 1987 · N97202 · Substantial damage > The plt rprtd that prior to takeoff, he taxied thru svrl puddles of water from melting snow. The temp at that time was rprtd as 25 deg. He rprtd that when he landed at Wildwood, the wind was from 290 deg at 15 gusting 20 KTS & the temp was 30 deg. He said… - [NTSB CHI87LA074](https://openairdocs.org/ntsb/CHI87LA074.md): Cessna 172P · Huntington, IN · Accident · No injuries · Limited investigation · Final report · Feb 4, 1987 · N62503 · Substantial damage > While executing a touch & go landing, the plt reports that during the takeoff phase she was slightly left and tried to correct to the right when the left wheel caught in snow and the acft pulled off the rwy to the left. The acft flipped over and came to rest… - [NTSB ANC87FA031](https://openairdocs.org/ntsb/ANC87FA031.md): Champion 7EC · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Feb 4, 1987 · N7539B · Substantial damage > The pilot-in-command accomplished unauthorized repairs to his airplane after an incident four days earlier. He repaired the right main landing gear by using a common door hinge to attach it to the fuselage. Upon landing, the door hinge failed and control of… - [NTSB FTW87LA062](https://openairdocs.org/ntsb/FTW87LA062.md): Cessna 210 · Bonham, TX · Accident · No injuries · Limited investigation · Final report · Feb 3, 1987 · N61BC · Substantial damage > According to the pilot, the aircraft made a normal landing, but was substantially damaged when the aircraft contacted a ditch cut across the airstrip, causing the aircraft to nose over inverted. - [NTSB FTW87LA053](https://openairdocs.org/ntsb/FTW87LA053.md): Bellanca Scout · Boyd, TX · Accident · No injuries · Limited investigation · Final report · Feb 3, 1987 · N7670S · Substantial damage > A private pilot landed on his private strip made of soft sandy soil, the aircraft ground looped breaking the left main gear 'u' bolt and center bolt. The aircraft's left wing contacted the ground causing substantial damage when the aircraft rolled over on its… - [NTSB MKC87LA045](https://openairdocs.org/ntsb/MKC87LA045.md): Piper PA-34-200 · Flippin, AR · Accident · No injuries · Limited investigation · Final report · Feb 2, 1987 · N22470 · Substantial damage > The pilot stated that immediately upon touchdown, the nose slowly descended to the runway. The airplane slid for 450 feet before it stopped. A support bracket and an angle was found broken. It has not been determined if the parts were broken before or after… - [NTSB BFO87LA018](https://openairdocs.org/ntsb/BFO87LA018.md): Piper PA-28R-200R · West Point, VA · Accident · No injuries · Limited investigation · Final report · Feb 2, 1987 · N33399 · Substantial damage > After making a low pass over the uncontrolled airport the CFI decided to let the student pilot make a touch and go landing on runway 27 at West Point municipal airport. West Point, Virginia. The maneuver was successfully completed and the aircraft came around… - [NTSB NYC87LA073](https://openairdocs.org/ntsb/NYC87LA073.md): Piper PA-28-235 · Shelburne, VT · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N8820W · Substantial damage > Pilot misjudged height of snowbank at the approach end of the runway and allowed the aircraft to descend too low. The main gear collided with the snowbank causing substantial damage. - [NTSB NYC87LA071](https://openairdocs.org/ntsb/NYC87LA071.md): Bellanca 8GCBC · Rockaway, NJ · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N7653S · Substantial damage > Student pilot experienced a rough running engine during cruise flight and decided to make a precautionary landing on a frozen reservior. During landing roll out, the aircraft hit a slushy spot on the ice and nosed over causing substantial damage. - [NTSB LAX87LA107](https://openairdocs.org/ntsb/LAX87LA107.md): Luscombe 8A · Riverside, CA · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N1130B · Substantial damage > A Luscombe 8A ground looped on landing roll. The pilot indicated that during the landing roll after his third landing he heard a 'pop' sound. The aircraft veered right, collapsing the left main landing gear and damaging the left wing. After the accident the… - [NTSB FTW87LA065](https://openairdocs.org/ntsb/FTW87LA065.md): Burkhart Grob 103A · Midlothian, TX · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N228BG · Substantial damage > The acft was substantially damaged when the left wing struck a 4 inch diameter post on landing. The plt stated that he decided that due to a crosswind, he would land diagonally across the north/south rwy that was mowed in the middle of a large open field… - [NTSB BFO87LA023](https://openairdocs.org/ntsb/BFO87LA023.md): Cessna 152 · Woodbridge, VA · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N6558L · Substantial damage > The student was attempting the last of 3 full stop landings. The landing was made at minimum airspeed. The acft touched down left of the rwy centerline where afterwards the l main gear hit a snowbank alongside the rwy. A loss of directional control occurred… - [NTSB ATL87LA069](https://openairdocs.org/ntsb/ATL87LA069.md): Cessna 152 · Fuquay Varina, NC · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N64823 · Substantial damage > The student plt reported that the lt main wheel rolled off the rwy into mud during ldg rollout. This pulled the acft off the rwy and down an embankment into a ditch. The nose gear subsequently sank into the mud and the acft nosed down. The acft came to rest… - [NTSB ANC87LA029](https://openairdocs.org/ntsb/ANC87LA029.md): Cessna 172 · Beluga, AK · Accident · No injuries · Limited investigation · Final report · Feb 1, 1987 · N79416 · Substantial damage > The pilot stated that during the landing roll on a snow covered road the pilot lost control of the aircraft causing the aircraft to nose over on its back. - [NTSB MIA87IA081](https://openairdocs.org/ntsb/MIA87IA081.md): Enstrom F28C · Boca Raton, FL · Incident · No injuries · Incident investigation · Final report · Jan 31, 1987 · N8627H · Minor damage > The helicopter spun uncontrollably on the ground after the right anti-torque pedal cable was severed while landing. Examination of the helicopter revealed that the teter stop failed to limit the travel of the tail rotor spindle assy thereby reducing the… - [NTSB ANC87FA030](https://openairdocs.org/ntsb/ANC87FA030.md): Cessna C-180-H · Delta Junction, AK · Accident · No injuries · Field investigation · Final report · Jan 31, 1987 · N7990V · Substantial damage > The pilot attempted a glacier landing in daylight conditions and was unable to maintain surface reference. He flew onto the ice and lost control in varying surface winds. - [NTSB NYC87LA066](https://openairdocs.org/ntsb/NYC87LA066.md): Cessna 152 · Taunton, MA · Accident · No injuries · Limited investigation · Final report · Jan 29, 1987 · N49769 · Substantial damage > A student pilot allowed the aircraft to drift to the left side of the runway during landing roll. The left main gear caught a snowbank, causing the airplane to pivot counterclockwise into the snow and was substantially damaged. - [NTSB BFO87LA017](https://openairdocs.org/ntsb/BFO87LA017.md): Cessna T210N · West Point, VA · Accident · No injuries · Limited investigation · Final report · Jan 29, 1987 · N244MB · Substantial damage > The plt stated that the left main gear collided with a snowbank when the acft touched down on the rwy about 100 ft from the apch end and 10 ft left of the rwy centerline. Afterwards the left main gear folded into the wheel well. - [NTSB LAX87LA100](https://openairdocs.org/ntsb/LAX87LA100.md): Cessna 152 · Mesa, AZ · Accident · No injuries · Limited investigation · Final report · Jan 28, 1987 · N95529 · Substantial damage > During a local solo instructional flight, the pilot was practicing pattern work. On final approach the pilot reported that no correction for a cross wind was required. During the flare the pilot stated the aircraft drifted to the left. Upon touch down on the… - [NTSB NYC87LA068](https://openairdocs.org/ntsb/NYC87LA068.md): Cessna 152 · Princeton, NJ · Accident · No injuries · Limited investigation · Final report · Jan 25, 1987 · N4837P · Substantial damage > The student pilot leveled off at a higher than normal altitude during landing. He attempted to slow the descent rate by adding power. The aircraft drifted to the left and the pilot contemplated aborting the landing. Before he could initiate adding power,… - [NTSB CHI87LA071](https://openairdocs.org/ntsb/CHI87LA071.md): Cessna 152II · West Middleton, IN · Accident · No injuries · Limited investigation · Final report · Jan 25, 1987 · N6179Q · Substantial damage > During the landing roll the left main gear struck a snowbank. The nose wheel then got caught in snow and the acft tipped up on the prop and left wing. - [NTSB CHI87LA065](https://openairdocs.org/ntsb/CHI87LA065.md): Cessna 152 · Lansing, IL · Accident · No injuries · Limited investigation · Final report · Jan 25, 1987 · N4805B · Substantial damage > During second touch & go landing, plt encountered a crosswind. While attempting a go-around, after bouncing three times,the acft drifted to the left. The acft collided with a snowbank and nosed over. - [NTSB ATL87LA065](https://openairdocs.org/ntsb/ATL87LA065.md): Cessna 150M · Delaware, OH · Accident · No injuries · Limited investigation · Final report · Jan 25, 1987 · N7992U · Substantial damage > The student plt reported that he lost control of the acft while landing on rwy 28 in croswind conditions, after a solo x-c flt. The acft landed hard, veered off the rwy, and nosed over. According to the plt, the wind was from 360 at 10 KTS, gusting to 20 KTS.… - [NTSB NYC87LA064](https://openairdocs.org/ntsb/NYC87LA064.md): Cessna 152 · Simsbury, CT · Accident · No injuries · Limited investigation · Final report · Jan 23, 1987 · N48918 · Substantial damage > The aircraft was landing on runway 21 at Simsbury, Connecticut when the pilot lost directional control and the left main wheel contacted the snow bank, which in turn caused the airplane to lean over to the right striking the wing on the runway surface. - [NTSB MKC87IA043](https://openairdocs.org/ntsb/MKC87IA043.md): Embraer EMB-120 · Springfield, MO · Incident · No injuries · Incident investigation · Final report · Jan 23, 1987 · N120AM · Minor damage > The PIC of this air midwest flt 4408 said that, while on initial climb, power (np) on the left engine decayed to 60% and would not recover. The engine was feathered by condition lever but the torque rose to 140% while returning for a landing, according to the… - [NTSB CHI87LA066](https://openairdocs.org/ntsb/CHI87LA066.md): Cessna 152 · Lincoln, IL · Accident · No injuries · Limited investigation · Final report · Jan 23, 1987 · N48241 · Substantial damage > According to the plt, after landing on rwy 03 at logan county airport, the acft encountered ice on the rwy and the left main gear struck snow that had drifted onto the rwy. The plt stated that the acft then collided with a snowbank and flipped over. The acft… - [NTSB ANC87FA025](https://openairdocs.org/ntsb/ANC87FA025.md): Cessna 152 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Jan 23, 1987 · N25063 · Substantial damage > The pilot stated that on the third touch and go he raised the flaps and applied power for takeoff when the aircraft started to skid to the left. He cut power, then lost directional control of the airplane causing the aircraft to strike the snow bank. - [NTSB MKC87LA042](https://openairdocs.org/ntsb/MKC87LA042.md): Cessna 152 · Coffeyville, KS · Accident · No injuries · Limited investigation · Final report · Jan 22, 1987 · N4924H · Substantial damage > The student pilot flew from tulsa, ok to Coffeyville, KS to take his private pilot flight test. Student did not check weather or NOTAMS and relied on information from the flight instructor and was not aware of the NOTAM that there was a 50-foot wide strip… - [NTSB NYC87LA062](https://openairdocs.org/ntsb/NYC87LA062.md): Cessna 152 · Orange, MA · Accident · No injuries · Limited investigation · Final report · Jan 21, 1987 · N5171B · Substantial damage > Pilot was landing after a cross country solo flight. The aircraft hit a patch of ice and the pilot lost directional control causing the aircraft to collide nose first with a snow bank. The aircraft then swung the right wing around into the snow, causing… - [NTSB FTW87LA046](https://openairdocs.org/ntsb/FTW87LA046.md): Cessna 172N · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Jan 21, 1987 · N4901G · Substantial damage > The nose gear strut depressed more than normal following what the student plt thought was a normal touchdown and the acft veered off the rwy. As control was lost, the nose gear tire blew and the acft subsequently struck a VASI light collapsing the nose gear.… - [NTSB BFO87LA016](https://openairdocs.org/ntsb/BFO87LA016.md): Piper PA-22-150 · Pungo, VA · Accident · No injuries · Limited investigation · Final report · Jan 21, 1987 · N7720D · Substantial damage > The student made 3 full stop landings alone before the instructor boarded the acft. Another full stop landing was made and during the landing roll the instr noticed that the last half of the grass rwy was wetter than the first half. The instr elected to… - [NTSB MKC87LA041](https://openairdocs.org/ntsb/MKC87LA041.md): Beech BE-77 · Arkadelphia, AR · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 1987 · N6636H · Substantial damage > The student pilot was landing at the home airport after her solo cross-country flight when the airplane went off the left side of the runway. It rolled across a grassy area and then went into a large water/mudhole. The nose gear collapsed when it impacted the… - [NTSB CHI87LA063](https://openairdocs.org/ntsb/CHI87LA063.md): Cessna 152 · Evansville, IN · Accident · No injuries · Limited investigation · Final report · Jan 20, 1987 · N93078 · Substantial damage > Nose gear collapsed after student pilot failed to recover from a bounced landing. The student plt was on the second landing (touch and go) of a supervised solo flight. He stated that he thought that the accident could have been avoided if he had been given… - [NTSB LAX87LA092](https://openairdocs.org/ntsb/LAX87LA092.md): Cessna 172M · Oakdale, CA · Accident · No injuries · Limited investigation · Final report · Jan 19, 1987 · N12551 · Substantial damage > During a solo instructional flight the student pilot was practicing touch and go landings. Upon take-off on runway 28, the wind was light from 100 degrees. On the first landing the wind had changed to a right cross wind from the north. The pilot compensated… - [NTSB ANC87LA024](https://openairdocs.org/ntsb/ANC87LA024.md): Cessna 172 · Chena Hot Sprgs, AK · Accident · No injuries · Limited investigation · Final report · Jan 19, 1987 · N97811 · Substantial damage > The pilot stated that after touchdown on the snow covered airstrip he lost directional control of the aircraft causing the plane to groundloop. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=405 ## 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=404 --- 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.