# 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 387 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB NYC88LA140](https://openairdocs.org/ntsb/NYC88LA140.md): Luscombe 8E · Rochester, NY · Accident · No injuries · Limited investigation · Final report · May 15, 1988 · N2047K · Substantial damage > The Luscombe 8E experienced a failure of the right main landing gear axle during a bounced landing. The failure occurred at the weld where the axle attaches to the landing gear strut. Examination of the fracture revealed a pre-existing crack that was not… - [NTSB MIA88LA170](https://openairdocs.org/ntsb/MIA88LA170.md): Piper PA-20 · Ocean Springs, MS · Accident · No injuries · Limited investigation · Final report · May 15, 1988 · N7682K · Substantial damage > The instructor stated that they were on their third touch and go and had made a wheel landing, and just as she started to retract the flaps, the aircraft made an aprx 30 degree turn off the right side of the runway. She then stated that no matter how much… - [NTSB DEN88LA108](https://openairdocs.org/ntsb/DEN88LA108.md): Cessna 210L · St. George, UT · Accident · No injuries · Limited investigation · Final report · May 15, 1988 · N732BR · Substantial damage - [NTSB ATL88LA175](https://openairdocs.org/ntsb/ATL88LA175.md): Piper PA-28-181 · Columbus, OH · Accident · No injuries · Limited investigation · Final report · May 15, 1988 · N8261L · Substantial damage > The plt landed the airplane long at an excessive airspeed. The airplane overran the rwy end, traveled across a grassy area onto a ramp area, and collided with a parked airplane. The plt had 2 hrs of flt experience in this make and model airplane, which was… - [NTSB NYC88LA139](https://openairdocs.org/ntsb/NYC88LA139.md): Cessna 172RG · West Chester, PA · Accident · No injuries · Limited investigation · Final report · May 14, 1988 · N9638B · Substantial damage > The pilot was performing a touch and go landing at brandwyine airport and lost directional control during landing. He said he touched down, applied full power then remembered to put the flaps up. When the acft started to veer off the rwy the plt applied… - [NTSB NYC88FA143](https://openairdocs.org/ntsb/NYC88FA143.md): Bell 206B · Farmingdale, NY · Accident · Minor injuries · Field investigation · Final report · May 12, 1988 · N39071 · Substantial damage > The Bell 206B was being flown on a helicopter rating ride with the PIC in the right seat and an FAA inspector in the left seat. The oral was satisfactory and the flight check progressed to autorotations. The first one was long, the second short. On the third… - [NTSB SEA88LA091](https://openairdocs.org/ntsb/SEA88LA091.md): Cessna 150K · Yamhill, OR · Accident · No injuries · Limited investigation · Final report · May 11, 1988 · N6251G · Substantial damage > On short final for landing onto a 2100 foot airstrip at about 12 feet AGL, the aircraft encountered adverse winds and struck the ground in a three point attitude breaking off the nose gear. The aircraft then nosed over inverted striking a barbed wire fence.… - [NTSB LAX88LA178](https://openairdocs.org/ntsb/LAX88LA178.md): Boeing A75N1 · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · May 11, 1988 · N747JR · Substantial damage - [NTSB LAX88LA177](https://openairdocs.org/ntsb/LAX88LA177.md): Stinson 108-2 · Temecula, CA · Accident · No injuries · Limited investigation · Final report · May 11, 1988 · N9570K · Substantial damage > During the landing roll in a direct crosswind, the aircraft began to weather vane. The pilot was unable to maintain control of the aircraft which veered off the runway where it collided with the terrain and nosed over. There were no reported mechanical… - [NTSB SEA88LA092](https://openairdocs.org/ntsb/SEA88LA092.md): Cessna 185 · Mercer Island, WA · Accident · No injuries · Limited investigation · Final report · May 10, 1988 · N1701R · Substantial damage > The pilot stated that the aircraft struck a log while landing on the water. The aircraft then nosed over inverted and sank. - [NTSB ATL88LA170](https://openairdocs.org/ntsb/ATL88LA170.md): Bellanca 8GCBC · Elizabethton, TN · Accident · No injuries · Limited investigation · Final report · May 10, 1988 · N8641V · Substantial damage > The flt was being accomplished to refamiliarize the commercial plt with the airplane prior to completing the remainder of the training curriculum. One takeoff and ldg had been completed without incident. During the second approach to landing, it was related… - [NTSB SEA88LA089](https://openairdocs.org/ntsb/SEA88LA089.md): Cessna 172 · Kennewick, WA · Accident · No injuries · Limited investigation · Final report · May 9, 1988 · N7090A · Substantial damage > During landing roll the aircraft's nose gear began to shudder, with the nose gear turning 90 degrees to the left. The aircraft then nosed down onto the nose and right wing. Visual examination of the aircraft's shimmy dampener arm assembly revealed a previous… - [NTSB CHI88LA109](https://openairdocs.org/ntsb/CHI88LA109.md): Piper PA-38-112 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · May 8, 1988 · N43DR · Substantial damage - [NTSB ATL88LA167](https://openairdocs.org/ntsb/ATL88LA167.md): Cessna 172P · Bowling Green, OH · Accident · No injuries · Limited investigation · Final report · May 7, 1988 · N5495K · Substantial damage > The plt reported that he reduced the pwr to idle while on final appch after determining that the airplane was too high. He then lowered the nose to 'accelerate the descent'. The airplane touched down long on the rwy at about 90 KTS, and began to porpoise. He… - [NTSB ANC88LA054](https://openairdocs.org/ntsb/ANC88LA054.md): Cessna 185F · Hunter Creek, AK · Accident · Minor injuries · Limited investigation · Final report · May 6, 1988 · N22901 · Substantial damage > After landing at a mining camp airstrip, the right landing gear failed causing the aircraft to ground loop. Examination of the broken gear part revealed the original fracture to be a fatigue fracture. The initial crack in the gear leg ran parallel to the gear… - [NTSB LAX88LA175](https://openairdocs.org/ntsb/LAX88LA175.md): Cessna 152 · Upland, CA · Accident · No injuries · Limited investigation · Final report · May 5, 1988 · N25294 · Substantial damage > The student pilot's flt purpose was to practice takeoffs & landings at a different arpt. When he departed, the winds were the same as the dest arpt. The CFI felt that a weather briefing was not required. The student touched down on rwy 24 & the acft began… - [NTSB CHI88LA107](https://openairdocs.org/ntsb/CHI88LA107.md): Piper PA-28-140 · Lake Village, IN · Accident · No injuries · Limited investigation · Final report · May 5, 1988 · N55552 · Substantial damage > The pilot had landed long and, realizing he would not stop before running off the runway, attempted a go-around. The pilot stated he had one notch of flaps down, approximately 10 degrees, and after adding full power attempted to lift-off. The aircraft ran off… - [NTSB ATL88LA165](https://openairdocs.org/ntsb/ATL88LA165.md): Piper PA-28-161 · Lawrenceville, GA · Accident · No injuries · Limited investigation · Final report · May 5, 1988 · N8205 · Destroyed > The student plt returned to the departure arpt and attempted a landing with a cross wind gusting to an estimated 20 KTS. After landing, a gust of wind was encountered. The aircraft became airborne. The student pilot held the aircraft's controls rigid. The… - [NTSB CHI88LA106](https://openairdocs.org/ntsb/CHI88LA106.md): North American AT-6D · Eden Prairie, MN · Accident · No injuries · Limited investigation · Final report · May 3, 1988 · N29935 · Substantial damage > While on an aircraft familiarization for purpose of check out, the pilot encountered a gusty crosswind on landing and failed to maintain aircraft control. The instructor pilot took over the controls, but was unable to regain directional control, and the… - [NTSB ATL88LA164](https://openairdocs.org/ntsb/ATL88LA164.md): Piper PA-31-325 · Wilkesboro, NC · Accident · No injuries · Limited investigation · Final report · May 3, 1988 · N34GK · Substantial damage > After a normal approach and landing, the left main gear slowly collapsed during the roll out. The aircraft veered to the left, struck a sign off the runway edge and collided with a ditch. The left main gear was found unlocked during postaccident… - [NTSB LAX88DVA04](https://openairdocs.org/ntsb/LAX88DVA04.md): Schumann KR-2 · Merced, CA · Accident · 1 fatal · Final report · May 2, 1988 · N127AS · Destroyed > The pilot was flight testing a new airplane that he had constructed. He had completed two touch and go landings. During a third approach, witnesses observed the airplane approaching the runway at a very high airspeed. The airplane touched down on the runway… - [NTSB LAX88LA171](https://openairdocs.org/ntsb/LAX88LA171.md): Cessna 180B · Quincy, CA · Accident · No injuries · Limited investigation · Final report · May 1, 1988 · N5104E · Substantial damage > At the end of a pleasure flight, while in the traffic pattern, the pilot noted that the winds were light and variable. While on final approach, a correction for drift was made. During the landing roll, in gusting conditions, the pilot lost control of the… - [NTSB DEN88LA104](https://openairdocs.org/ntsb/DEN88LA104.md): Beech H35 · Ruidoso, NM · Accident · No injuries · Limited investigation · Final report · May 1, 1988 · N618T · Substantial damage - [NTSB BFO88LA043](https://openairdocs.org/ntsb/BFO88LA043.md): Beech C23 · Manassas, VA · Accident · No injuries · Limited investigation · Final report · May 1, 1988 · N9358S · Substantial damage > The plt said that earlier he attempted to land at carlisle, pa and during the lndg roll he encountered a wind gust and lost directional control of the acft. The r wing raised and the acft went off the side of the rwy. The plt said he heard a loud bump as the… - [NTSB ATL88LA160](https://openairdocs.org/ntsb/ATL88LA160.md): Cessna 172N · Gilbert, SC · Accident · No injuries · Limited investigation · Final report · May 1, 1988 · N5085K · Substantial damage > The airplane overran rwy 23 during ldg and nosed over. The plt reported that he attempted to abort the ldg after initially landing long on the rwy. As the airplane began to climb however, he realized that it would not clear obstacles located past the end of… - [NTSB NYC88LA135](https://openairdocs.org/ntsb/NYC88LA135.md): Grumman AA5B · Morristown, NJ · Accident · No injuries · Limited investigation · Final report · Apr 30, 1988 · N4557Q · Substantial damage > A loss of control due to improper technique after a bounced landing. Contributing was the second pilot also attempting to correct the situation. - [NTSB LAX88LA173](https://openairdocs.org/ntsb/LAX88LA173.md): Champion 7CCM · Cameron Park, CA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1988 · N6712C · Substantial damage > While practicing touch and go landings, the pilot reported that a wind from behind caught the tail of the aircraft. The pilot overcorrected and ground looped the aircraft. The aircraft veered off the runway and nosed over. The pilot reported that there were… - [NTSB DEN88LA105](https://openairdocs.org/ntsb/DEN88LA105.md): Cessna 185F · Erie, CO · Accident · No injuries · Limited investigation · Final report · Apr 30, 1988 · N8389Q · Substantial damage > The commercial plt was practicing touch and go landings during a local flight. During landing roll on the last landing, the pilot reached down to retract landing flaps and opened the cowl flaps. He then became aware that the aircraft was turning right. Left… - [NTSB CHI88LA105](https://openairdocs.org/ntsb/CHI88LA105.md): Piper PA-28-140D · Whittemore, MI · Accident · No injuries · Limited investigation · Final report · Apr 30, 1988 · N6433R · Substantial damage > While landing on a farmer's strip, the pilot failed to maintain directional control of the aircraft. The aircraft swerved off the left side of the strip, into a plowed field where it struck a rock. - [NTSB CHI88LA103](https://openairdocs.org/ntsb/CHI88LA103.md): Piper PA28-140D · Flushing, MI · Accident · Minor injuries · Limited investigation · Final report · Apr 30, 1988 · N5965U · Substantial damage > While on final approach for landing on a short, grass strip, the pilot said she encountered sunglare which restricted her visibility such that she was unable to judge the landing. Touchdown occurred with insufficient runway remaining to stop the aircraft. The… - [NTSB BFO88LA037](https://openairdocs.org/ntsb/BFO88LA037.md): Piper PA-28-180 · Wise, VA · Accident · No injuries · Limited investigation · Final report · Apr 30, 1988 · N7947N · Substantial damage > The student plt was on his first solo flight and attempting his second solo landing when he was unable to maintain directional control in a left crosswind. The acft drifted right and the plt attempted to do a go-around to avoid going off the side of the rwy.… - [NTSB MKC88LA093](https://openairdocs.org/ntsb/MKC88LA093.md): Beech 95 · Shell Knob, MO · Accident · No injuries · Limited investigation · Final report · Apr 29, 1988 · N635B · Substantial damage > The pilot of the accident aircraft failed to maintain directional control during the landing roll. The left wing of the aircraft struck trees along the left side of the runway. Aircraft control was lost resulting in the right main landing gear collapsing. - [NTSB MKC88LA084](https://openairdocs.org/ntsb/MKC88LA084.md): Raven S-55 · Burlington, IA · Accident · Serious injuries · Limited investigation · Final report · Apr 29, 1988 · N6436U · Substantial damage > While attempting to land the balloon during a commercial operation, a dust devil was encountered. The balloon and gondola twisted and pitched violently. During a hard landing, the PIC was thrown from the aircraft, and the aircraft continued to bounce along… - [NTSB MKC88LA080](https://openairdocs.org/ntsb/MKC88LA080.md): Beech F17D · Perryville, MO · Accident · No injuries · Limited investigation · Final report · Apr 29, 1988 · N385 · Destroyed > During the landing phase of operation, the propeller struck the runway several times prior to the acft making a gear up ldg. After the acft came to a stop, a post flight fire erupted destroying the acft. Evidence of gear up landing was confirmed after post… - [NTSB BFO88LA038](https://openairdocs.org/ntsb/BFO88LA038.md): Cessna 172M · Fayetteville, WV · Accident · No injuries · Limited investigation · Final report · Apr 29, 1988 · N13261 · Substantial damage > The pilot landed long and with excessive airspeed, which resulted in an overrun of the runway. Inadequate inflight planning is a contributing factor. - [NTSB SEA88LA086](https://openairdocs.org/ntsb/SEA88LA086.md): Cessna 180 · Elko, NV · Accident · No injuries · Limited investigation · Final report · Apr 28, 1988 · N2952C · Substantial damage > During landing roll the pilot lost directional control of the aircraft with a groundloop resulting. The pilot had a total time of 17 hours in this type of aircraft and 152 hours total flight time. - [NTSB SEA88LA085](https://openairdocs.org/ntsb/SEA88LA085.md): Beech 35 · Pasco, WA · Accident · No injuries · Limited investigation · Final report · Apr 28, 1988 · N2839V · Substantial damage > During lndg roll, NLG and rmlg collapsed. During tow in from rwy, lndg gear cb was noted to be tripped. Cause of cb activation unk. - [NTSB FTW88LA094](https://openairdocs.org/ntsb/FTW88LA094.md): Cessna 182J · Lamont, OK · Accident · No injuries · Limited investigation · Final report · Apr 28, 1988 · N2645F · Substantial damage > The pilot lost directional control while landing on an asphalt roadway near his residence. The nose wheel dug into adjacent soft terrain and the aircraft tipped over. The road was not in use by auto traffic because a bridge was out of service. It was… - [NTSB FTW88DQG04](https://openairdocs.org/ntsb/FTW88DQG04.md): Piper PA-28-201T · Shallowater, TX · Accident · No injuries · Final report · Apr 28, 1988 · N30273 · Substantial damage > The pilot lost directional control during the landing roll with a strong left crosswind on a narrow runway. A go-around was attempted but the aircraft drifted right and received substantial damage when it touched down in soft terrain. - [NTSB DEN88LA101](https://openairdocs.org/ntsb/DEN88LA101.md): Cessna 172Q · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Apr 28, 1988 · N96299 · Substantial damage - [NTSB NYC88LA129](https://openairdocs.org/ntsb/NYC88LA129.md): Champion 7KCAB · Dracut, MA · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1988 · N9712N · Substantial damage > The pilot said that while making a normal approach for a 'glassy water' landing on a lake, he flared high and stalled the airplane. The right wing dropped off and the airplane crashed into the water. - [NTSB LAX88LA174](https://openairdocs.org/ntsb/LAX88LA174.md): Piper PA-24-180 · Chico, CA · Accident · No injuries · Limited investigation · Final report · Apr 27, 1988 · N6601P · Substantial damage - [NTSB DEN88LA102](https://openairdocs.org/ntsb/DEN88LA102.md): Cessna 182P · Great Falls, MT · Accident · Minor injuries · Limited investigation · Final report · Apr 27, 1988 · N79P · Destroyed > The private plt was returning home from a personal transportation flight with one pax, another private plt. Both men reported that while on final for rnwy 25, the sun was in their eyes and hindered their vision. The plt in command stated that he cannot… - [NTSB ATL88LA157](https://openairdocs.org/ntsb/ATL88LA157.md): Cessna 180A · Danville, KY · Accident · No injuries · Limited investigation · Final report · Apr 26, 1988 · N9712B · Substantial damage > The plt performed a wheel landing and attempted to hold the tailwheel off the runway surface with nose down elevator. The right wing began to lift and the acft veered to the right. Remedial control inputs were made and the left main landing gear axle… - [NTSB ANC88LA050](https://openairdocs.org/ntsb/ANC88LA050.md): Cessna 180 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Apr 25, 1988 · N91290 · Substantial damage > The pilot returned to Fairbanks int'l airport from an intended cross-country flight due to deteriorating weather. During the flight the airplane felt out of trim, and she elected to land on the longest runway available (10,300). During the landing roll she… - [NTSB MIA88LA159](https://openairdocs.org/ntsb/MIA88LA159.md): Cessna 150J · Kissimmee, FL · Accident · Minor injuries · Limited investigation · Final report · Apr 24, 1988 · N61027 · Substantial damage > While landing on runway 24 in strong gusty crosswind conditions the student plt lost control of the aircraft. While making a go-around the aircraft drifted to the left side of the runway striking the VASI lights. The aircraft then continued on to the left… - [NTSB ATL88LA152](https://openairdocs.org/ntsb/ATL88LA152.md): Cessna 172F · Walland, TN · Accident · No injuries · Limited investigation · Final report · Apr 22, 1988 · N1414U · Substantial damage > The pilot attempted to abort a takeoff after experiencing a sudden gust of wind at liftoff. The aircraft collided with a fence and ditch which caused substantial airframe damage. The pilot reported the winds gusting to 15 knots. There was no reported aircraft… - [NTSB MIA88LA158](https://openairdocs.org/ntsb/MIA88LA158.md): Beech E55 · Pahokee, FL · Accident · No injuries · Limited investigation · Final report · Apr 21, 1988 · N81893 · Substantial damage > While on an instructional flt practicing short & soft field landings, the acft was landed gear up. The instructor plt stated there was no failure or malfunction of the landing gear warning horn and that when the throttle was retarded fully the horn sounded. - [NTSB NYC88LA115](https://openairdocs.org/ntsb/NYC88LA115.md): Maule M-6-235 · Walton, NY · Accident · No injuries · Limited investigation · Final report · Apr 20, 1988 · N366X · Substantial damage > The pilot decided to land on a sod strip. He bounced once, then lowered the nose to keep it on the ground. The prop dug into the ground and the aircraft flipped over. The pilot reported that he was practicing manuevers and wanted to practice a sod landing. - [NTSB MIA88LA154](https://openairdocs.org/ntsb/MIA88LA154.md): Aerostar S-60A · Orlando, FL · Accident · Serious injuries · Limited investigation · Final report · Apr 18, 1988 · N6583C · Minor damage > The plt stated that the winds started to pick up & he decided to land. During the apch just before touchdown, the gondola struck a tree, causing the occupants to fall against each other, breaking one of the passengers legs. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=388 ## 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=387 --- 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.