# 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 391 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB DEN88LA049](https://openairdocs.org/ntsb/DEN88LA049.md): Bellanca 8GCBC · Clovis, NM · Accident · Serious injuries · Limited investigation · Final report · Jan 12, 1988 · N5063J · Substantial damage - [NTSB ATL88LA077](https://openairdocs.org/ntsb/ATL88LA077.md): Cessna 152 · Greensboro, NC · Accident · No injuries · Limited investigation · Final report · Jan 12, 1988 · N757AS · Substantial damage > The student plt rptd that he attempted to land long to avoid snow and ice on the rwy. The airplane touched down earlier than he intended however, and contacted the snow and ice. The airplane subsequently veered off of the runway, impacted a snowbank, and… - [NTSB SEA88LA036](https://openairdocs.org/ntsb/SEA88LA036.md): Piper PA-28-140 · Juneau, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 10, 1988 · N7221F · Substantial damage > The aircraft was ballooning during the approach to the ice-covered lake. The pilot momentarily added power to go-around, but elected to reduce the power in order to land. During the landing roll directional control was lost with the aircraft sliding into an… - [NTSB NYC88LA080](https://openairdocs.org/ntsb/NYC88LA080.md): Piper PA-28R-200 · Old Bridge, NJ · Accident · No injuries · Limited investigation · Final report · Jan 10, 1988 · N9317N · Substantial damage > The flight made a normal approach and touched down on runway 24. As the pilot applied pwr for takeoff due to the hazardous runway conditions, the pilot lost directional control and the left main landing gear impacted plowed snow at the edge of the runway. - [NTSB MKC88LA038](https://openairdocs.org/ntsb/MKC88LA038.md): Cessna 177 · St. Charles, MO · Accident · No injuries · Limited investigation · Final report · Jan 10, 1988 · N35284 · Substantial damage > While practicing touch and go ldgs, PIC noted a significant increase in sink rate. Additional power failed to arrest the descent, and the acft struck the terrain short of the rwy causing substantial damage to the acft, and no injuries to plt and pax. - [NTSB DEN88LA052](https://openairdocs.org/ntsb/DEN88LA052.md): Cessna 305A · Littleton, CO · Accident · No injuries · Limited investigation · Final report · Jan 10, 1988 · N5245G · Substantial damage - [NTSB DEN88LA047](https://openairdocs.org/ntsb/DEN88LA047.md): Cessna 182G · Aurora, CO · Accident · No injuries · Limited investigation · Final report · Jan 10, 1988 · N3406S · Substantial damage > N3406S was landing on rwy 32, an asphalt rwy 5,000 ft long and 40 ft wide. The rwy was clear and dry, but the terrain surrounding the rwy was covered by 12 to 15 inches of snow. The wind at an arpt 5 mi sw was from 160 deg at 5 KTS. In his rpt of the acdt the… - [NTSB ATL88LA076](https://openairdocs.org/ntsb/ATL88LA076.md): Cessna 182G · Lancaster, OH · Accident · No injuries · Limited investigation · Final report · Jan 10, 1988 · N2006R · Substantial damage > The plt rptd that the airplane began to veer left almost immediately after touchdown. The airplane subsequently swerved off of the rwy. Traveled across a snow-covered grassy area, and impacted a taxiway embankment. The nose gear was found to be collapsed… - [NTSB MKC88FA037](https://openairdocs.org/ntsb/MKC88FA037.md): Beech 58 · Dewitt, AR · Accident · No injuries · Field investigation · Final report · Jan 9, 1988 · N4613S · Substantial damage > The pilot of N4613S was making a VFR approach into the de witt, Arkansas municipal airport. Snow had been removed from the runway and piled up on the approach end of runway 35. The nose gear of the aircraft contacted the piled up snow/ice at touchdown,… - [NTSB DEN88LA051](https://openairdocs.org/ntsb/DEN88LA051.md): Raven RX-7 · Rio Rancho, NM · Accident · No injuries · Limited investigation · Final report · Jan 9, 1988 · N2797L · Substantial damage > During the landing the plt reported a wind shift which drifted the balloon into pwr lines before the landing could be accomplished. The plt reported she could not see the pwr lines due to the balloon restricting visibility and the pax pointed the lines out to… - [NTSB ANC88DAG02](https://openairdocs.org/ntsb/ANC88DAG02.md): Cessna 172 · Willow, AK · Accident · No injuries · Final report · Jan 9, 1988 · N8439X · Substantial damage > The pilot stated that immediately upon touchdown, the airplane started sinking in (two feet) deep snow, and came to a stop in about 50 feet. The left wing and propeller struck the ground. The plt had overflown the arpt and saw the snow removal equipment about… - [NTSB NYC88LA064](https://openairdocs.org/ntsb/NYC88LA064.md): Piper PA-23-250 · Atlantic City, NJ · Accident · Minor injuries · Limited investigation · Final report · Jan 8, 1988 · N62554 · Substantial damage > The Piper PA-23-250 made an instrument approach to the airport. The pilot said he lowered the landing gear prior to touchdown, however, both propellers struck the runway. The pilot tried to make a go-around and the aircraft started to veer to the left. The… - [NTSB ANC88LA023](https://openairdocs.org/ntsb/ANC88LA023.md): Cessna 207 · Akiachak, AK · Accident · No injuries · Limited investigation · Final report · Jan 4, 1988 · N73036 · Substantial damage > The pilot stated that during the landing roll on the ice covered runway, he lost control causing the plane to exit the departure end of the runway into a snow bank. - [NTSB MKC88LA036](https://openairdocs.org/ntsb/MKC88LA036.md): Cessna 414 · Fayetteville, AR · Accident · No injuries · Limited investigation · Final report · Jan 1, 1988 · N30ML · Substantial damage > During an instructional flt, the CFI and student plt heard a loud pop while attempting to lower the gear in preparation for landing. Several flybys past the control tower were made to confirm an unsafe nose gear configuration. They flew the aircraft an… - [NTSB LAX88LA079](https://openairdocs.org/ntsb/LAX88LA079.md): Balloon Works Firefly 8-24 · Phoenix, AZ · Accident · Serious injuries · Limited investigation · Final report · Jan 1, 1988 · N74169 · Substantial damage - [NTSB NYC88LA061](https://openairdocs.org/ntsb/NYC88LA061.md): Cessna 172 · Concord, NH · Accident · No injuries · Limited investigation · Final report · Dec 31, 1987 · N5383R · Substantial damage > The aircraft was landing at Concord municipal airport, and during landing roll, the aircraft veered to the left leaving the runway surface and nosed over in the field between the taxiway and runway 35. - [NTSB CHI88LA038](https://openairdocs.org/ntsb/CHI88LA038.md): Cessna 210-5 · East Lansing, MI · Accident · No injuries · Limited investigation · Final report · Dec 31, 1987 · N1802Z · Substantial damage > The aircraft was landed at night on runway 9 which is 2530' in length with a 600' displaced threshold. This runway was ice covered and winds were recorded 25 minutes before the accident at a reporting facility 5 nautical miles west of the accident site as 160… - [NTSB DEN88FA044](https://openairdocs.org/ntsb/DEN88FA044.md): Swearingen SA-26AT · Telluride, CO · Accident · Serious injuries · Field investigation · Final report · Dec 30, 1987 · N4468M · Substantial damage > During a visual apch, the plt said he encountered 2000 fpm downdrafts. The plt stated he added power and executed a normal apch at 120 KTS, compensating for downdrafts/crosswinds. After touchdown, the plt said he did not get a beta light on the right eng. He… - [NTSB SEA88LA033](https://openairdocs.org/ntsb/SEA88LA033.md): Cessna 182C · Las Vegas, NV · Accident · 1 fatal · Limited investigation · Final report · Dec 29, 1987 · N8819T · Destroyed > The aircraft bounced on landing touchdown, swerved off the side of the runway and impacted a concrete culvert in a drainage ditch. Witnesses observed the acft bounce and stated that no application of power for recovery was heard nor any apparent attempt to… - [NTSB LAX88LA081](https://openairdocs.org/ntsb/LAX88LA081.md): Cessna 172M · Banning, CA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1987 · N12943 · Substantial damage > During a pleasure flight while on final approach, aprx 10 ft above the rwy, the acft suddenly dropped and bounced on the rwy. After a nearby rain storm passed over the area, the acft was flown to the home base. Several days later, the operator discovered… - [NTSB FTW88LA043](https://openairdocs.org/ntsb/FTW88LA043.md): Cessna 150 · Woodworth, LA · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1987 · N5719G · Substantial damage > The plt stated that during landing roll the aircraft veered left due to a strong wind gust. The aircraft fell into a ravine, coming to rest 180 degrees from the runway heading, damaging both wing spars at the fuselage attach points and collapsing the nose… - [NTSB MIA88NA070](https://openairdocs.org/ntsb/MIA88NA070.md): McDonnell Douglas DC-9-31 · Pensacola, FL · Accident · Minor injuries · Final report · Dec 28, 1987 · N8948E · Substantial damage - [NTSB DEN88IA043](https://openairdocs.org/ntsb/DEN88IA043.md): Mcdonnell Douglas MD-80 · Denver, CO · Incident · No injuries · Incident investigation · Final report · Dec 27, 1987 · N72830 · Minor damage > During landing roll the acft struck a taxiway marker. Visibility was reported by RVR to be 2200. Actual visibility was near zero due to blowing snow. Plt stated he did not lose cntrl but finite cntrl not possible due to lack of visibility and cross winds of… - [NTSB MKC88LA034](https://openairdocs.org/ntsb/MKC88LA034.md): Luscombe 8-A · Chillicothe, MO · Accident · No injuries · Limited investigation · Final report · Dec 26, 1987 · N71288 · Substantial damage > During a ldg attempt, acft touched down and swerved abruptly. Loss of control was experienced by PIC, and acft made a 180 degree turn on the runway. PIC stated the brakes may have been frozen, as he had taxied thru standing water during departure. - [NTSB CHI88LA036](https://openairdocs.org/ntsb/CHI88LA036.md): Cessna 150M · Redwood Falls, MN · Accident · No injuries · Limited investigation · Final report · Dec 26, 1987 · N704XX · Substantial damage > Wind was 210 degrees at 13 knots when the student pilot attempted a landing on snow compacted runway 12. The student stated that a gust of wind pushed the aircraft sideways and it struck a snowbank when it exited the runway to the left. - [NTSB CHI88LA034](https://openairdocs.org/ntsb/CHI88LA034.md): Cessna 172K · Staunton, IL · Accident · No injuries · Limited investigation · Final report · Dec 22, 1987 · N78705 · Substantial damage > During the flare for landing the aircraft drifted to the right and the right wingtip contacted the rudders of two aircraft parked with their tails 21' and 23' from the centerline of the runway. The wingspan of the accident aircraft is 35'9'. Had the pilot… - [NTSB MKC88LA031](https://openairdocs.org/ntsb/MKC88LA031.md): Sonerai 2L · St. Louis, MO · Accident · No injuries · Limited investigation · Final report · Dec 21, 1987 · N502WM · Substantial damage > While practicing take offs and ldgs, PIC lost directional control during rollout. He added power and struck a snowbank just after becoming airborne during running takeoff. - [NTSB FTW88FA039](https://openairdocs.org/ntsb/FTW88FA039.md): Aerospatiale SA-330J · Eugene Island · Accident · 15 fatal · Field investigation · Final report · Dec 21, 1987 · N3596N · Destroyed > The helicopter, with 2 plts & 13 passengers, was on an IFR flt to a psn in the gulf of Mexico. From that psn, they proceeded under VFR to an off-shore oil drilling rig (EI-190). As the helicopter was arriving from the se, there was a strong wind from the NE.… - [NTSB DEN88LA039](https://openairdocs.org/ntsb/DEN88LA039.md): Piper PA-38-112 · Las Cruces, NM · Accident · No injuries · Limited investigation · Final report · Dec 19, 1987 · N23497 · Substantial damage > While practicing crosswind landings the instructor stated that the student touched down normally with aprx 5 knot crosswind. Upon touch down, the right main landing gear separated from the acft causing substantial damage. There were no injuries and no fire.… - [NTSB MIA88LA066](https://openairdocs.org/ntsb/MIA88LA066.md): Cessna A188B · South Bay, FL · Accident · No injuries · Limited investigation · Final report · Dec 18, 1987 · N731LS · Substantial damage > The plt attempted a landing on a narrow runway, on an embankment. The airplane swerved to the left, into a crosswind, and left the rwy. The right main ldg gear collided with a boulder; the airplane nosed over and came to rest in the water. - [NTSB MIA88LA064](https://openairdocs.org/ntsb/MIA88LA064.md): Beech 95-C55 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Dec 15, 1987 · N707CC · Substantial damage > While on a personal flt after the plt lowered the landing gear for landing, the left main landing gear did not extend. The plt continued the apch, & after touchdown, the acft veered off the rwy, collided with trees, then came to rest. According to FAA… - [NTSB ATL88LA064](https://openairdocs.org/ntsb/ATL88LA064.md): Cessna 150G · Grantham, NC · Accident · No injuries · Limited investigation · Final report · Dec 13, 1987 · N6258S · Substantial damage > The airplane touched down initially on the nose wheel, and the nose landing gear collapsed. The airplane subsequently nosed over. The student plt reportedly had about 2 hrs total PIC (solo) flt time. - [NTSB MIA88LA061](https://openairdocs.org/ntsb/MIA88LA061.md): Piper PA-18-150 · Fellsmere, FL · Accident · No injuries · Limited investigation · Final report · Dec 12, 1987 · N80BJ · Substantial damage > While on a business flt over the company's property the plt elected to land the acft on a 40 foot wide dirt road. After touchdown the acft drifted off the left side of the road, due in part, to a crosswind. The left wing collided with a tree. - [NTSB ATL88LA063](https://openairdocs.org/ntsb/ATL88LA063.md): Cessna 150K · Portland, TN · Accident · No injuries · Limited investigation · Final report · Dec 12, 1987 · N5995G · Substantial damage > The student plt rptd that the airplane veered off the rt side of the rwy into a ditch while ldg in x-wind conditions. The student plt estimated that the wind velocity was 10 KTS with gusts to 20 KTS. The student rptdly had about 32 hrs total flt experience,… - [NTSB ATL88LA062](https://openairdocs.org/ntsb/ATL88LA062.md): Cessna 172P · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Dec 11, 1987 · N52701 · Substantial damage > At 1343 EST, the student plt contacted apch ctl & asked for lndg info. He was adzd to continue VFR for rwy 31. When he contacted the tower at 1347, the wind was fm 200 deg at 13 KTS. Tower psnl gave him the choice of rwy 31 or 28L; he elected to lnd on rwy… - [NTSB SEA88LA082](https://openairdocs.org/ntsb/SEA88LA082.md): Cessna TU206G · Silverdale, WA · Accident · No injuries · Limited investigation · Final report · Dec 10, 1987 · N4953Z · Substantial damage > While on the lndg roll with a qtrg hdwnd, the acft enctrd a gust which pushed it to the left. The plt said he applied full rgt aileron, but it had no effect. As the acft was 'being blown' toward trees, the plt applied full rgt brake. He said the left wing tip… - [NTSB MIA88FA058](https://openairdocs.org/ntsb/MIA88FA058.md): Embraer EMB 120 · Columbus, MS · Accident · No injuries · Field investigation · Final report · Dec 10, 1987 · N232AS · Substantial damage > The acft landed gear up while on a training flight, the crew stated that they had completed 2 hours of training when the first officer requested a single engine no flap approach demonstration. Both pilots stated that during this demonstration they neglected… - [NTSB ATL88LA058](https://openairdocs.org/ntsb/ATL88LA058.md): Ercoupe 415-C · Marlboro, OH · Accident · No injuries · Limited investigation · Final report · Dec 10, 1987 · N87102 · Substantial damage > The student plt rptd that he flew a flat final apch to remain clear of trees. The airspeed began to drop, and the airplane subsequently landed hard after clearing the trees. - [NTSB NYC88LA055](https://openairdocs.org/ntsb/NYC88LA055.md): Mitsubishi MU-2B-20 · White Plains, NY · Accident · No injuries · Limited investigation · Final report · Dec 7, 1987 · N866Q · Substantial damage > The cross country business flight was uneventful from concord, new hampshire to White Plains, new york under clear sky. During final approach, the pilot extended the gear but did not notice that the circuit breaker had opened and the gear was not lowered. The… - [NTSB CHI88LA033](https://openairdocs.org/ntsb/CHI88LA033.md): Cessna 152 · Lincoln, IL · Accident · No injuries · Limited investigation · Final report · Dec 6, 1987 · N757KW · Substantial damage > The plt returned to the arpt after dark & noted there was an excessive x-wind for the active rwy. He elected to land on the unlighted grass rwy (rwy 14) which was aligned more favorably with the wind. He thought that on final apch, he had aligned the acft… - [NTSB ANC88DAG01](https://openairdocs.org/ntsb/ANC88DAG01.md): Cessna 207A · Atmautluak, AK · Accident · No injuries · Final report · Dec 6, 1987 · N73503 · Substantial damage > The aircraft was on final approach when a vehicle appeared to be on the runway coming at the aircraft. The pilot pulled the aircraft up over the snow machine but settled back to the ground alongside the runway. - [NTSB MIA88LA054](https://openairdocs.org/ntsb/MIA88LA054.md): Cessna 310F · Opa Locka, FL · Accident · No injuries · Limited investigation · Final report · Dec 5, 1987 · N317L · Substantial damage > The plt stated that he had made three touch & go landings & on the fourth landing, while on rollout, the left main gear collapsed & the acft slid to a stop on the runway. Post crash examination of the landing gear revealed that the left main gear downlock rod… - [NTSB MIA88LA053](https://openairdocs.org/ntsb/MIA88LA053.md): Beech C-45H · Miami, FL · Accident · No injuries · Limited investigation · Final report · Dec 4, 1987 · N4209V · Substantial damage > While practicing short field landings the plt flared the acft for landing after which it stalled, descended right wing low, then crashed onto the rwy. The acft then touched down on the nose landing gear causing it to collapse, & slid off the rwy. - [NTSB MIA88IA052](https://openairdocs.org/ntsb/MIA88IA052.md): Beech 58 · Vicksburg, MS · Incident · No injuries · Incident investigation · Final report · Dec 3, 1987 · N3012W · Minor damage > While on a part 135 on-demand domestic passenger flt, the acft landed gear up. The plt stated that he forgot to lower the landing gear. There was no mechanical failure or malfunction. - [NTSB ATL88LA051](https://openairdocs.org/ntsb/ATL88LA051.md): Cessna 172F · Eden, NC · Accident · No injuries · Limited investigation · Final report · Dec 2, 1987 · N8674U · Substantial damage > The student plt attempted to land in a farm pasture adjacent to his brother's farm. The airplane ldg gear 'dug in' on ldg, and the airplane nosed over. The student plt described the terrain as 'wet & soggy'. The student did not have an instructor's… - [NTSB MIA88LA048](https://openairdocs.org/ntsb/MIA88LA048.md): Cessna 172K · Pensacola, FL · Accident · No injuries · Limited investigation · Final report · Nov 29, 1987 · N84613 · Substantial damage > The pvt plt flying the acft for the first time from the rt seat landed it aprx 170 ft short of the runway on soft grass. The acft rolled 6-10 ft, after which the nose gear sank & the acft then nosed over & came to rest inverted. - [NTSB MIA88LA047](https://openairdocs.org/ntsb/MIA88LA047.md): Cessna 210 · Quincy, FL · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 1987 · N9492T · Substantial damage > The plt stated that he performed a prelanding check on final apch but failed to lower the landing gear. He continued the apch, & just prior to touchdown, was advised that the gear was not down. The apch to landing was continued & the acft slid to a stop. He… - [NTSB DEN88LA032](https://openairdocs.org/ntsb/DEN88LA032.md): Cessna 180 · Telluride, CO · Accident · No injuries · Limited investigation · Final report · Nov 28, 1987 · N6547A · Substantial damage > During a downwind landing, the plt experienced difficulty in controlling his acft. Approximately 2,500 feet from the west end of the rwy the acft ground looped into some rocks and was substantially damaged. The plt stated that he was landing downwind and… - [NTSB MIA88LA045](https://openairdocs.org/ntsb/MIA88LA045.md): Mooney M-22 · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Nov 26, 1987 · N7739M · Substantial damage > Plt stated that on landing roll at approximately 30 to 35 knots the nose landing gear began to shimmy and turn to the left. Full right brake and rudder could not correct the left turning tendency of the aircraft. The aircraft ran off the left side of the… - [NTSB LAX88LA056](https://openairdocs.org/ntsb/LAX88LA056.md): Cessna 172N · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Nov 25, 1987 · N75825 · Substantial damage > A Cessna 172N veered off runway 30. The pilot reported that a gust of wind lifted the left wing resulting in the right wing scraping the runway surface. The airplane subsequently ground looped to the right and departed the runway. The winds were reported to… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=392 ## 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=391 --- 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.