# 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 380 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB ATL89LA046](https://openairdocs.org/ntsb/ATL89LA046.md): North American T-6G · Hamilton, OH · Accident · No injuries · Limited investigation · Final report · Nov 25, 1988 · N45TC · Substantial damage > The pilot lost directional control while practicing crosswind landings. The winds were reported at 10 with gusts to 15 knots. The pilot did not report having an airplane system problem. - [NTSB LAX89LA056](https://openairdocs.org/ntsb/LAX89LA056.md): Bellanca 8KCAB · Twentynine Palm, CA · Accident · No injuries · Limited investigation · Final report · Nov 22, 1988 · N8695V · Substantial damage > The pilot stated that while landing, during the flare, a gust of wind raised the left wing. The pilot corrected just prior to touchdown. When the airplane touched down it ground looped to the right. The airplane ran off the runway and collided with a berm and… - [NTSB LAX89LA055](https://openairdocs.org/ntsb/LAX89LA055.md): Air & Space 18A · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · Nov 22, 1988 · N6113S · Substantial damage > The pilot stated that he lost directional control of the gyroplane during the landing roll, departed the rwy and nosed over. The gyroplane touched down normally on the main landing gear at an indicated airspeed of about 20 mph. As the gyroplane slowed… - [NTSB ATL89LA042](https://openairdocs.org/ntsb/ATL89LA042.md): Piper PA-31-350 · Union City, TN · Accident · No injuries · Limited investigation · Final report · Nov 20, 1988 · N27947 · Substantial damage > PIC made two sdf approaches. On the first approach he had difficulty seeing the rwy lights. The acft was aligned left of rwy and a missed approach was made. On the second approach the PIC said he had difficulty picking up any rwy lights. He landed with the… - [NTSB SEA89LA022](https://openairdocs.org/ntsb/SEA89LA022.md): Cessna 172 · Oregon City, OR · Accident · No injuries · Limited investigation · Final report · Nov 19, 1988 · N6408G · Substantial damage > The pilot was landing his aircraft on a very wet 1,170 foot grass runway. The pilot was not able to stop the aircraft before it collided with a fence at the end of the runway. According to the manufacturers performance figures, under the given temperature and… - [NTSB LAX89LA051](https://openairdocs.org/ntsb/LAX89LA051.md): Piper PA-20 · Chino, CA · Accident · No injuries · Limited investigation · Final report · Nov 19, 1988 · N1441C · Substantial damage > The plt lost directional control of the acft during the landing roll and ground looped. The flight instructor reported that this was the first landing of the day and that they were staying in the traffic pattern to practice touch and go landings on rwy 26.… - [NTSB ATL89LA041](https://openairdocs.org/ntsb/ATL89LA041.md): Cessna 150M · Toledo, OH · Accident · No injuries · Limited investigation · Final report · Nov 18, 1988 · N63212 · Destroyed > The airplane was found wrecked on an airport taxiway when airport personnel reported for duty in the morning. It had been stolen from the blue horizon flying club at the airport and, according to the hobbs meter, had been operated for about 0.4 hours since… - [NTSB SEA89LA020](https://openairdocs.org/ntsb/SEA89LA020.md): Gates Learjet 25B · Bend, OR · Accident · No injuries · Limited investigation · Final report · Nov 17, 1988 · N143CK · Substantial damage > The pilot visually inspected the runway while making a low pass. He reported afterward that he saw no evidence of ice or snow on the runway. The copilot called UNICOM but was told, while the aircraft was on short final, that the winds were calm and the… - [NTSB MIA89IA035](https://openairdocs.org/ntsb/MIA89IA035.md): Boeing 707-355C · Sanford, FL · Incident · No injuries · Incident investigation · Final report · Nov 16, 1988 · N707MB · Minor damage > The non-type rated FAA flight test engineer executed a visual approach and was observed to be erratic and flying at v-ref when he chopped the power at 50 ft AGL and the aircraft landed hard. The instructor pilot then took control of the aircraft and executed… - [NTSB FTW89LA019](https://openairdocs.org/ntsb/FTW89LA019.md): Luscombe 11A · Houston, TX · Accident · Minor injuries · Limited investigation · Final report · Nov 15, 1988 · N1639B · Substantial damage - [NTSB ANC89LA017](https://openairdocs.org/ntsb/ANC89LA017.md): Cessna A185F · Kasitsna Bay, AK · Accident · No injuries · Limited investigation · Final report · Nov 14, 1988 · N4759E · Substantial damage > The plt was landing on a beach to deliver mail. He rprtd that during touchdown, the acft skipped about 50 ft before settling to the ground, then it remained in contact with the ground & rolled straight ahead. During the landing roll, the acft nosed over. The… - [NTSB MKC89LA023](https://openairdocs.org/ntsb/MKC89LA023.md): Stearman B75N1 · Benton, AR · Accident · No injuries · Limited investigation · Final report · Nov 13, 1988 · N2158P · Substantial damage > The flt was uneventful until the landing at the saline county arpt, Benton, ark. The PIC stated he applied too much brake and applied it prematurely during the landing roll and the acft nosed over to the inverted posn. The resultant impact crushed the… - [NTSB MIA89IA032](https://openairdocs.org/ntsb/MIA89IA032.md): Piper PA-28R-200 · Melbourne, FL · Incident · No injuries · Incident investigation · Final report · Nov 13, 1988 · N32393 · Minor damage > The plt stated that while doing touch and go landings at Melbourne, he put the gear handle down but did not check to confirm that it was down. He continued the approach and landed gear up. Afterward, the pilot noticed that the gear pump circuit breaker had… - [NTSB NYC89LA026](https://openairdocs.org/ntsb/NYC89LA026.md): Cessna 177 · Pittstown, NJ · Accident · Serious injuries · Limited investigation · Final report · Nov 12, 1988 · N3208T · Substantial damage > Uncontrolled contact with trees after the pilot lost directional control of the aircraft during an attempted landing. - [NTSB MIA89LA029](https://openairdocs.org/ntsb/MIA89LA029.md): Piper PA-28-151 · Lajas, PR · Accident · No injuries · Limited investigation · Final report · Nov 11, 1988 · N4815F · Substantial damage > The plt filled the fuel tanks, made three touch-&-go landings, then departed on a x-country flt. After aprx 1.5 hrs of flt, he elected to reverse course & land at an alternate arpt since he had inadequate fuel to reach his destn. Realizing the fuel supply was… - [NTSB MIA89IA028](https://openairdocs.org/ntsb/MIA89IA028.md): Piper PA-38-112 · Vero Beach, FL · Incident · No injuries · Incident investigation · Final report · Nov 11, 1988 · N2391G · Minor damage > The plt stated that on landing rollout, the acft veered off the left side of the runway and as it was slowing down, hit a depression in the ground and the left main gear collapsed. The acft then spun around and came to rest. - [NTSB LAX89LA043](https://openairdocs.org/ntsb/LAX89LA043.md): Cessna 150L · Sacramento, CA · Accident · No injuries · Limited investigation · Final report · Nov 10, 1988 · N17293 · Substantial damage > The student plt was practicing touch-&-go landings on his 3rd instructional solo flt. Drg an apch to land, the acft was slightly to the right of the rwy. The student tried to correct the situation, then decided the acft was too close to the ground. He added… - [NTSB ANC89LA015](https://openairdocs.org/ntsb/ANC89LA015.md): Cessna 152 · Nenana, AK · Accident · No injuries · Limited investigation · Final report · Nov 8, 1988 · N48943 · Substantial damage > The instructor pilot was demonstrating a soft-field landing to his student pilot when he flared the airplane too high, and allowed the crosswind to carry the airplane off the left side of the runway where it hit a runway light and a snow berm, then nosed… - [NTSB SEA89LA017](https://openairdocs.org/ntsb/SEA89LA017.md): Cessna 210K · Anacortes, WA · Accident · No injuries · Limited investigation · Final report · Nov 7, 1988 · N9495M · Substantial damage > During a gusty crosswind landing, touchdown was accomplished about 500 feet past the runway threshold. The aircraft bounced at touchdown. The pilot stated that he thought he had a flat main tire. The pilot momentarily added power after touchdown to go-around… - [NTSB DEN89LA029](https://openairdocs.org/ntsb/DEN89LA029.md): Piper PA-18-150 · Baker, MT · Accident · No injuries · Limited investigation · Final report · Nov 7, 1988 · N4466Z · Substantial damage > The commercial plt was landing after a pipeline patrol flight. There were no pax. The plt made a wheels landing on rwy 30 with wind reported from 270 at 28 KTS. During landing roll, a wind gust from the left side, estimated by the plt as 50 KTS, lifted the… - [NTSB NYC89LA023](https://openairdocs.org/ntsb/NYC89LA023.md): Cessna 172RG · Robbinsville, NJ · Accident · No injuries · Limited investigation · Final report · Nov 6, 1988 · N9307D · Substantial damage > Failure of the pilot to adequately correct for the crosswind and maintain control of the aircraft during a crosswind landing. - [NTSB LAX89LA037](https://openairdocs.org/ntsb/LAX89LA037.md): Cessna 150 · Madera, CA · Accident · No injuries · Limited investigation · Final report · Nov 5, 1988 · N3730J · Substantial damage > The pilot stated that on the last landing, the airplane touched down hard. Subsequently, the nose gear collapsed & the airplane went off the left side of the runway. There were no reported mechanical failures or malfunctions with the airplane prior to the… - [NTSB DEN89LA027](https://openairdocs.org/ntsb/DEN89LA027.md): Cessna 210 · Monte Vista, CO · Accident · No injuries · Limited investigation · Final report · Nov 4, 1988 · N6240B · Substantial damage > The private plt was flying 2 friends to his farm. His dirt strip runs east and west, but prevailing winds were 320 deg at 40, gusting to 50 KTS. A cross wind landing to the west had to be aborted and the plt elected to land to the north, on an access road.… - [NTSB ATL89LA029](https://openairdocs.org/ntsb/ATL89LA029.md): Cessna 172N · Rogersville, TN · Accident · No injuries · Limited investigation · Final report · Nov 3, 1988 · N734ZM · Substantial damage > The plt reported that he was ferrying the airplane to obtain scheduled maintenance. Upon arrival over the arpt, he found that the only rwy was closed for maintenance. He then elected to land on a taxiway. He made a short-field ldg and applied the brakes… - [NTSB LAX89LA031](https://openairdocs.org/ntsb/LAX89LA031.md): Aeronca 7EC · Saint Helena, CA · Accident · No injuries · Limited investigation · Final report · Nov 2, 1988 · N4722E · Substantial damage > The pilot reported that after completing a three point landing, the airplane began to oscillate. He was unable to maintain directional control. Subsequently, the airplane went off the runway and nosed over in soft dirt. No mechanical failure or malfunction of… - [NTSB CHI89LA021](https://openairdocs.org/ntsb/CHI89LA021.md): Cessna 170A · Springfield, IL · Accident · No injuries · Limited investigation · Final report · Nov 2, 1988 · N5596C · Substantial damage > The conventional landing gear equipped airplane was substantially damaged when it nosed down after ground looping during a landing attempt. VMC prevailed and a 90 degree right crosswind, blowing at 12 knots, was present. The pilot relates in his statement… - [NTSB ATL89IA026](https://openairdocs.org/ntsb/ATL89IA026.md): Beech 58 · Georgetown, SC · Incident · No injuries · Incident investigation · Final report · Nov 2, 1988 · N958MC · Minor damage > The plt reported that the nose gear collapsed after a 'normal' ldg. An FAA inspector who examined the rwy after the mishap reported that he found tire marks which indicated that the nose tire had contacted the rwy several times after the main tires touched… - [NTSB MIA89LA021](https://openairdocs.org/ntsb/MIA89LA021.md): Cessna 182J · Okeechobee, FL · Accident · No injuries · Limited investigation · Final report · Oct 29, 1988 · N2911F · Substantial damage > The plt rprtd that while landing at night, the acft bounced twice. Subsequently, it went off the rwy & onto a grass area. During the occurrence, the nose gear collapsed. - [NTSB CHI89LA020](https://openairdocs.org/ntsb/CHI89LA020.md): Cessna 172B · Columbus, OH · Accident · Minor injuries · Limited investigation · Final report · Oct 29, 1988 · N7418X · Substantial damage > Student pilot's failure to maintain control of the airplane during landing flare. - [NTSB LAX89LA026](https://openairdocs.org/ntsb/LAX89LA026.md): Beech 23 · San Carlos, CA · Accident · No injuries · Limited investigation · Final report · Oct 28, 1988 · N2340Z · Substantial damage > During a telephone interview the pilot stated that he landed too FAR down runway 12. He said that when he considered going around, he was already committed to complete the landing. Winds at the time of the accident were reported to be from 360 degrees at 5… - [NTSB MKC89LA016](https://openairdocs.org/ntsb/MKC89LA016.md): Hiller UH-12C · Davenport, IA · Accident · No injuries · Limited investigation · Final report · Oct 26, 1988 · N57FD · Substantial damage > While demonstrating an autorotation touchdown, a tailboom strike was experienced. Damage was incurred to the tailboom, the tail rotor drive shaft, and one main rotor blade. The CFI said everthing felt normal during touchdown and believed the soft terrain… - [NTSB MKC89LA013](https://openairdocs.org/ntsb/MKC89LA013.md): Cessna 150 · Liberty, MO · Accident · No injuries · Limited investigation · Final report · Oct 24, 1988 · N60977 · Substantial damage > While flaring for a x-wind landing, the student plt saw a large brown animal running toward the rwy. He maneuvered to avoid the animal. He stated the left main gear struck the animal, then the acft went off the rwy, bounced & nosed over. - [NTSB DEN89LA023](https://openairdocs.org/ntsb/DEN89LA023.md): Cessna 152 · Billings, MT · Accident · No injuries · Limited investigation · Final report · Oct 24, 1988 · N757XV · Substantial damage > The student plt was practicing takeoffs and landings, with reported winds gusting to 14 KTS. During a landing the plt misjudged the flare and attempted to go around. He said the wind raised the right wing and that he overcorrected with aileron and pulled back… - [NTSB SEA89LA014](https://openairdocs.org/ntsb/SEA89LA014.md): Cessna 150G · Post Falls, ID · Accident · No injuries · Limited investigation · Final report · Oct 23, 1988 · N3691J · Substantial damage > The plt rprtd that due to the airstrip conds, he was making a low, flat apch. He was using carb heat. When power application became necessary, just before landing, the eng did not respond immediately. The plt maintained a nose high attitude to avoid obstacles… - [NTSB LAX89LA024](https://openairdocs.org/ntsb/LAX89LA024.md): Bellanca 8GCBC · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Oct 23, 1988 · N5504S · Substantial damage > During the landing roll, the airplane began to veer to the right. The pilot applied hard left rudder for a few seconds, then the left main tire came off the rim. Subsequently, the left gear collapsed and the airplane came to rest partly off the runway. - [NTSB ANC89LA013](https://openairdocs.org/ntsb/ANC89LA013.md): Piper PA-32-301 · Ivanof Bay, AK · Accident · No injuries · Limited investigation · Final report · Oct 23, 1988 · N8402S · Substantial damage > The pilot was attempting to land on a 30 foot wide, 1200 foot gravel strip in gusty wind conditions. He said just prior to touchdown, the airplane encountered a strong gust of wind resulting in a hard landing short of the runway. The left main landing gear… - [NTSB ANC89LA011](https://openairdocs.org/ntsb/ANC89LA011.md): Cessna 180 · Seldovia, AK · Accident · No injuries · Limited investigation · Final report · Oct 22, 1988 · N820AK · Substantial damage > The private pilot was attempting to land his Cessna 180 airplane on the beach near Seldovia, AK. The main landing gear encountered a soft spot during the landing roll, and the airplane nosed over. Afterward, the pilot elected to fly the airplane to its home… - [NTSB MKC89LA009](https://openairdocs.org/ntsb/MKC89LA009.md): Cessna 140 · Lawrence, KS · Accident · No injuries · Limited investigation · Final report · Oct 21, 1988 · N4190N · Substantial damage > The plt elected to terminate a local flt due to windy, turbulent conditions aloft. He initiated a landing in a slight crosswind that he rprtd was gusting to 20 knots. Drg the landing, he lost control & the acft touched down hard in a nose low attitude.… - [NTSB LAX89LA020](https://openairdocs.org/ntsb/LAX89LA020.md): Piper PA-28-161 · Petaluma, CA · Accident · No injuries · Limited investigation · Final report · Oct 19, 1988 · N6184H · Substantial damage > During a telephone interview, the pilot stated that she was attempting a touch and go landing when the airplane landed hard on its nosewheel. She lost directional control and the airplane collided with a hangar. There were no problems with the nosewheel… - [NTSB DEN89LA026](https://openairdocs.org/ntsb/DEN89LA026.md): Cessna 210D · Malta, MT · Accident · No injuries · Limited investigation · Final report · Oct 19, 1988 · N3811Y · Substantial damage > The private plt, alone in the aircraft, was performing a landing on a paved road at a hunting resort. During final approach the Cessna struck power lines and damaged the nose gear. The acft touched down on the road and the nose gear collapsed. A post accident… - [NTSB CHI89LA019](https://openairdocs.org/ntsb/CHI89LA019.md): Cessna 182 · Pekin, IL · Accident · No injuries · Limited investigation · Final report · Oct 19, 1988 · N5711B · Substantial damage > The pilot reported that he attempted to make a 'wheels' landing in the Cessna 182 (tricycle gear), and made a hard landing on the turf runway. The pilot aborted the landing, requested emergency equipment and circled the airport until the emergency equipment… - [NTSB LAX89LA017](https://openairdocs.org/ntsb/LAX89LA017.md): Cessna 150F · Goodyear, AZ · Accident · No injuries · Limited investigation · Final report · Oct 18, 1988 · N8194F · Substantial damage > The plt rprtd that drg the landing roll, the acft enctrd a gust of wind & veered off the dirt strip & onto a raised berm (edge of rwy). After enctrg the soft dirt & rough terrain, the nose gear collapsed & the plane nosed over. The plt had landed with 40 deg… - [NTSB MIA89IA012](https://openairdocs.org/ntsb/MIA89IA012.md): Boeing 727-200 · St. Thomas · Incident · No injuries · Incident investigation · Final report · Oct 17, 1988 · N706AA · Minor damage > The rt wing was dragged while ldg in a crosswind on rwy 10. The crew stated the aprch was normal & the touchdown was smooth on the rt gear with 3 degrees to 5 degrees of rt bank. The capt stated that immed after touchdown, the lt wing came up suddenly and he… - [NTSB CHI89DEC01](https://openairdocs.org/ntsb/CHI89DEC01.md): Experimental Barracuda · Ypsilanti, MI · Accident · No injuries · Final report · Oct 17, 1988 · N48DS · Substantial damage > Pilot's failure to maintain control of the aircraft during landing and inability to appropriately correct for the porpoise action of the aircraft. - [NTSB LAX89LA016](https://openairdocs.org/ntsb/LAX89LA016.md): Piper PA-38-112 · Van Nuys, CA · Accident · No injuries · Limited investigation · Final report · Oct 16, 1988 · N25619 · Destroyed > In both his oral and written statements, the student pilot stated that during the landing roll he lost directional control of the airplane. The student attempted to make a go-around, but before becoming airborne the airplane veered to the left of the runway… - [NTSB LAX89LA015](https://openairdocs.org/ntsb/LAX89LA015.md): Howard GFA-15P · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Oct 16, 1988 · N68119 · Substantial damage > During the landing roll the pilot lost control of the airplane. The airplane ground looped and the main gear collapsed. There were no mechanical problems reported prior to the accident and the weather was not a factor. - [NTSB ANC89LA010](https://openairdocs.org/ntsb/ANC89LA010.md): Piper PA-22 · Soldotna, AK · Accident · No injuries · Limited investigation · Final report · Oct 16, 1988 · N1208C · Substantial damage > During the landing roll the pilot lost directional control of the airplane. The airplane ground looped on the runway. - [NTSB MIA89LA010](https://openairdocs.org/ntsb/MIA89LA010.md): Raven S-60A · Tampa, FL · Accident · No injuries · Limited investigation · Final report · Oct 15, 1988 · N65523 · Substantial damage > Drg an apch to land, the plt saw some bushes & another balloon (which had already landed) in his intended landing area. He applied burner to soar over the obstacles, then pulled the envelope vent to quickly descend after the obstacles had been cleared. He… - [NTSB CHI89LA008](https://openairdocs.org/ntsb/CHI89LA008.md): Cessna 120 · St Peter, MN · Accident · Minor injuries · Limited investigation · Final report · Oct 12, 1988 · N2081V · Substantial damage > The plt had intended to make a touch-&-go landing on a grass strip, but stated that he came in 'somewhat high.' He rprtd the acft was still airborne about halfway down the rwy when he elected to go around. He attempted to add power, but the eng 'sputtered &… - [NTSB ANC89LA008](https://openairdocs.org/ntsb/ANC89LA008.md): de Havilland DHC-3 · Bonanza Hills, AK · Accident · No injuries · Limited investigation · Final report · Oct 12, 1988 · N90574 · Substantial damage > The commercial pilot was attempting to land on a private gravel airstrip in rural Alaska. During the landing roll, the left main landing gear encountered snow along the runway edge and veered sharply to the left and off the runway. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=381 ## 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=380 --- 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.