# 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 379 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB FTW89IA038](https://openairdocs.org/ntsb/FTW89IA038.md): Mcdonnell Douglas DC9-30 · Baton Rouge, LA · Incident · Minor injuries · Incident investigation · Final report · Jan 9, 1989 · N542TX · No damage > The proper touchdown point was not attained by the flight crew. (Copilot was flying and the PIC was supervising). - [NTSB MIA89LA062](https://openairdocs.org/ntsb/MIA89LA062.md): Cessna 210L · Greenwood, MS · Accident · No injuries · Limited investigation · Final report · Jan 7, 1989 · N590GC · Substantial damage > Failure of the pilot to maintain directional control, which resulted in an inadvertent ground swerve. - [NTSB LAX89LA080](https://openairdocs.org/ntsb/LAX89LA080.md): Cessna 172 · Alturas, CA · Accident · No injuries · Limited investigation · Final report · Jan 7, 1989 · N3857Q · Destroyed > The failure of the instructor pilot to maintain directional control of the airplane on the snow-covered runway, resulting in a nose-over when the airplane continued off the runway into deeper snow. - [NTSB LAX89LA079](https://openairdocs.org/ntsb/LAX89LA079.md): Maule M-5-210C · Calexico, CA · Accident · No injuries · Limited investigation · Final report · Jan 6, 1989 · N9039E · Substantial damage > A binding brake system torque plate. Factors related to the accident were: inadequate maintenance by other maintenance personnel, and operation of the airplane with a known efficiency by the pilot. - [NTSB CHI89LA043](https://openairdocs.org/ntsb/CHI89LA043.md): Cessna T303 · Romeo, MI · Accident · No injuries · Limited investigation · Final report · Jan 6, 1989 · N9890C · Substantial damage > The failure of the left main landing gear assembly due to stress corrosion. - [NTSB ATL89LA069](https://openairdocs.org/ntsb/ATL89LA069.md): Boeing E75 · Salisbury, NC · Accident · No injuries · Limited investigation · Final report · Jan 5, 1989 · N52124 · Substantial damage > Improper use of carburetor heat by the pilot, which resulted in carburetor ice. Factors related to the accident were: carburetor icing conditions and obstruction(s)/utility pole near the departure end of the runway. - [NTSB LAX89LA077](https://openairdocs.org/ntsb/LAX89LA077.md): Cessna 152 · Long Beach, CA · Accident · No injuries · Limited investigation · Final report · Jan 4, 1989 · N93114 · Substantial damage > The excessive speed which the pilot was maintaining and his improper operation of the brake system. Contributing to the accident was the inexperience of the student pilot. - [NTSB DEN89LA055](https://openairdocs.org/ntsb/DEN89LA055.md): Cessna 172 · Longmont, CO · Accident · No injuries · Limited investigation · Final report · Jan 4, 1989 · N96319 · Substantial damage > Failure of the student pilot to maintain proper runway alignment during the landing roll. Factors related to the accident were: snow on the edges of the runway, the student's lack of total experience, and the snowbank. - [NTSB DEN89LA052](https://openairdocs.org/ntsb/DEN89LA052.md): Beech 19 · Santa Fe, NM · Accident · No injuries · Limited investigation · Final report · Jan 2, 1989 · N9739L · Substantial damage > The pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing. - [NTSB ANC89LA030](https://openairdocs.org/ntsb/ANC89LA030.md): Champion 7GCBC · Cantwell, AK · Accident · No injuries · Limited investigation · Final report · Jan 2, 1989 · N5134T · Substantial damage > The pilot's selection of unsuitable terrain for landing. Contributing factors were the pilot's lack of total experience, and the snow covered runway. - [NTSB CHI89LA042](https://openairdocs.org/ntsb/CHI89LA042.md): Piper PA-28-181 · Plainfield, IL · Accident · No injuries · Limited investigation · Final report · Dec 30, 1988 · N8369Y · Substantial damage - [NTSB ANC89FA028](https://openairdocs.org/ntsb/ANC89FA028.md): Cessna 172 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · Dec 30, 1988 · N3752F · Substantial damage > The 103 hour private pilot was in the process of demonstrating his Cessna 172 conventional gear airplane (tail-dragger) to a prospective purchaser, when he lost directional control during landing and nosed-over. The pilot reported that he had just touched… - [NTSB LAX89LA075](https://openairdocs.org/ntsb/LAX89LA075.md): Piper PA-28-161 · Avalon, CA · Accident · Minor injuries · Limited investigation · Final report · Dec 29, 1988 · N28843 · Substantial damage > The pilot lost control of the airplane during landing roll at catalina airport. The airplane departed the end of runway 22, went down a steep slope and collided with the ground. The pilot reported that his first approach had been too high, so he made a… - [NTSB LAX89LA072](https://openairdocs.org/ntsb/LAX89LA072.md): Beech A24R · Grass Valley, CA · Accident · No injuries · Limited investigation · Final report · Dec 29, 1988 · N8018R · Substantial damage > At the end of a cross country flight, during the landing roll, the airplane began to slide to the left. The pilot was unable to regain control due to the patchy snow and ice on the runway. The airplane exited the runway and collided with a snow bank. There… - [NTSB ANC89LA027](https://openairdocs.org/ntsb/ANC89LA027.md): Piper PA-22 · Girdwood, AK · Accident · No injuries · Limited investigation · Final report · Dec 29, 1988 · N2447P · Substantial damage > The private pilot escaped injury when his airplane collided with snow removal vehicles while landing at the Girdwood airport, Girdwood, AK. The pilot reported that he flew over the airstrip, in his ski-equipped airplane, saw the equipment on the runway, and… - [NTSB NYC89LA055](https://openairdocs.org/ntsb/NYC89LA055.md): Cessna 172 · Wiscasset, ME · Accident · No injuries · Limited investigation · Final report · Dec 26, 1988 · N3736S · Substantial damage > The plt lost control during an attempted go-around, and collided with trees off the side of the runway. The pilot said that a gust of wind turned the acft 45 degrees to the runway on landing roll, and during the attempted go-around he hit tree tops off to the… - [NTSB LAX89LA070](https://openairdocs.org/ntsb/LAX89LA070.md): Cessna 140 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Dec 26, 1988 · N89891 · Substantial damage > The aircraft was found abandoned at the airport. A witness reported that the aircraft had flipped over on runway 25. The sole occupant, a male, was not injured. The aircraft was moved by the occupant and several other unidentified people to a tiedown area on… - [NTSB MKC89LA044](https://openairdocs.org/ntsb/MKC89LA044.md): Maule M-7 · Harrisonville, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 25, 1988 · N132HL · Substantial damage > During a crosswind landing the pilot lost directional control of the aircraft. The pilot elected to abort the landing by applying takeoff power and becoming airborne. The pilot attempted a turn at low airspeed and low altitude to avoid trees in his flight… - [NTSB SEA89LA031](https://openairdocs.org/ntsb/SEA89LA031.md): Beech 99A · Spokane, WA · Accident · No injuries · Limited investigation · Final report · Dec 24, 1988 · N4954W · Substantial damage > Acft was left overnight in heavy precip. Plt failed to ensure fuselage drains were clear and water accumulation drained before departing into below freezing flight temps. On lndg at dest, plt unable to achieve flare, resulting in hard lndg. Investigation… - [NTSB MIA89LA057](https://openairdocs.org/ntsb/MIA89LA057.md): Sikorsky S-58B · Kissimmee, FL · Accident · No injuries · Limited investigation · Final report · Dec 23, 1988 · N45726 · Substantial damage > The plt stated that he was repositioning the acft for fuel, and during a practice autorotation attempt the engine hydro-mechanical clutch failed. It did not re-engage upon the application of power and the acft was landed hard. - [NTSB ATL89LA062](https://openairdocs.org/ntsb/ATL89LA062.md): Piper PA-18A · Sandusky, OH · Accident · No injuries · Limited investigation · Final report · Dec 23, 1988 · N1176D · Substantial damage > The plt landed the acft on rwy 27 in winds that he estimated were from 240 deg at 10 to 15 KTS with gusts to 25 KTS. He stated that when the groundspeed had slowed to about 20 KTS, the left wing started to raise. He applied full power & the acft lifted off… - [NTSB NYC89LA054](https://openairdocs.org/ntsb/NYC89LA054.md): Cessna 152 · Hyannis, MA · Accident · No injuries · Limited investigation · Final report · Dec 22, 1988 · N5465P · Substantial damage > The acft ran off the runway and hit a landing light and terrain as the pilot attempted to make a crosswind landing, at barnstable airport, Hyannis, MA. - [NTSB ANC89LA025](https://openairdocs.org/ntsb/ANC89LA025.md): Cessna 207 · Kotzebue, AK · Accident · No injuries · Limited investigation · Final report · Dec 21, 1988 · N9948M · Substantial damage > The air taxi pilot stated that he had encountered freezing drizzle and other icing conditions prior to landing, accumulating approximately 3/8' of ice on the airplane. He said that as he began his landing flare, the airplane stalled, and he was unable to… - [NTSB NYC89LA052](https://openairdocs.org/ntsb/NYC89LA052.md): Cessna 152 · Pedricktown, NJ · Accident · No injuries · Limited investigation · Final report · Dec 20, 1988 · N24824 · Destroyed > During landing the pilot lost directional control of the aircraft and ran off the left side of the runway, hit a dirt bank and flipped over. - [NTSB MKC89LA042](https://openairdocs.org/ntsb/MKC89LA042.md): Beech 58 · Elkhart, KS · Accident · No injuries · Limited investigation · Final report · Dec 19, 1988 · N18434 · Substantial damage > While attempting to land in strong crosswind conditions, the plt lost directional control. The acft veered off the runway and was substantially damaged. The winds were gusting over 40 knots, with occasional gusts of 60 knots. - [NTSB MKC89LA040](https://openairdocs.org/ntsb/MKC89LA040.md): Cessna 152 · Creve Coeur, MO · Accident · No injuries · Limited investigation · Final report · Dec 18, 1988 · N757YE · Substantial damage > The student pilot said that after practicing locally and returning to the base airport, he discovered the winds to be greater than anticipated. On his third attempt to land, he bounced twice, then lost control and hit nose first on the runway. An eighty… - [NTSB LAX89LA065](https://openairdocs.org/ntsb/LAX89LA065.md): Bellanca 7KCAB · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · Dec 18, 1988 · N36627 · Substantial damage > The pilot lost control during the landing roll and collided with a fence. He reported that he was completing his landing roll on runway 25L, when the aircraft was blown sideways by a gust of wind. He stated that he then applied power to avoid a ground loop.… - [NTSB DEN89LA043](https://openairdocs.org/ntsb/DEN89LA043.md): Piper PA-24-250 · Peyton, CO · Accident · No injuries · Limited investigation · Final report · Dec 18, 1988 · N6843P · Substantial damage > The student plt was practicing a touch and go landing. During a turn to final, the plt heard an acft report final for a straight in. He said he became distracted and failed to extend the landing gear. The acft landed with the gear up and slid 500 feet, coming… - [NTSB MIA89IA052](https://openairdocs.org/ntsb/MIA89IA052.md): Cessna 150 · Naples, FL · Incident · Minor injuries · Incident investigation · Final report · Dec 16, 1988 · N8484U · Minor damage > Tower personnel observed the acft on a high fast final apch. They stated that it appeared the acft was forced on the rwy, where it hit on the nosewheel & bounced back into the air. On the 2nd contact with the rwy, the nosewheel fork split & the nosewheel… - [NTSB SEA89LA025](https://openairdocs.org/ntsb/SEA89LA025.md): Cessna 177RG · Monroe, WA · Accident · No injuries · Limited investigation · Final report · Dec 15, 1988 · N51386 · Substantial damage > Plt was lndg on unlit strip (center reflectors) at night and allowed acft to drift left on lndg roll. Acft contacted dirt mound adjacent to runway. - [NTSB SEA89FA027](https://openairdocs.org/ntsb/SEA89FA027.md): de Havilland DHC-2 · Kasaan, AK · Accident · 1 fatal · Field investigation · Final report · Dec 14, 1988 · N89U · Destroyed > The plt planned to land at a seaplane base that was located in a bowl-shaped cove. Drg the landing, the acft touched down long on water swells & the plt elected to go around. Witnesses rprtd that drg the go-around, the plt initiated a steep turn while still… - [NTSB NYC89LA046](https://openairdocs.org/ntsb/NYC89LA046.md): Beech 24R · Oxford, MA · Accident · No injuries · Limited investigation · Final report · Dec 11, 1988 · N9233S · Substantial damage > Failure of the pilot to stop the aircraft on the available runway due to a long landing. - [NTSB MKC89FA038](https://openairdocs.org/ntsb/MKC89FA038.md): Cessna 650 · Hutchinson, KS · Accident · No injuries · Field investigation · Final report · Dec 10, 1988 · N61BE · Substantial damage > Purpose of flight was to prepare the left-seat pilot for a type rating, and this was his first landing since completing ground school. There was another student in the jump seat, and two more in the back of the airplane. The airplane was landing on runway 31;… - [NTSB ANC89FA022](https://openairdocs.org/ntsb/ANC89FA022.md): Cessna 172I · Chugiak, AK · Accident · No injuries · Field investigation · Final report · Dec 10, 1988 · N8319L · Substantial damage > The pilot lost control, skidded off the left side of the wet icy runway, and nosed over in a snowbank during the landing phase of an attempted touch and go landing. He stated that while on downwind, he saw the wind sock indicate a change of wind direction,… - [NTSB ATL89LA052](https://openairdocs.org/ntsb/ATL89LA052.md): Cessna 150M · Walbridge, OH · Accident · No injuries · Limited investigation · Final report · Dec 9, 1988 · N714MK · Substantial damage > Drg a dual instructional flt, the student plt made an apch to rwy 22 on a dark night using the VASI. According to the instructor (CFI), the student leveled the acft aprx 8 to 10 ft above the rwy & allowed the airspeed to decay. The CFI warned the student &… - [NTSB FTW89LA030](https://openairdocs.org/ntsb/FTW89LA030.md): Cessna A185H · San Antonio, TX · Accident · No injuries · Limited investigation · Final report · Dec 7, 1988 · N7392H · Substantial damage > During the landing roll, the left wheel brake cylinder failed and the airplane groundlooped. The plt did not file an accident report. - [NTSB MIA89LA047](https://openairdocs.org/ntsb/MIA89LA047.md): Aeronca 11AC · Tampa, FL · Accident · Minor injuries · Limited investigation · Final report · Dec 6, 1988 · N86073 · Substantial damage > The plt stated that he failed to maintain directional control during landing in a crosswind. He further stated that he aggravated the loss of control by over-application of the controls and adding full throttle which led to the aircraft departing the rwy and… - [NTSB DEN89LA040](https://openairdocs.org/ntsb/DEN89LA040.md): Cessna 172 · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Dec 6, 1988 · N6356D · Substantial damage > The CFI and her student were practicing landings on rwy 10 with winds reported as 090 deg at 5 KTS. The student was on the controls, flared too high, and the acft bounced at touchdown. The CFI told him to add power to recover from the bounced landing. The… - [NTSB LAX89DVG02](https://openairdocs.org/ntsb/LAX89DVG02.md): Knowles Thorp T-18 · Lincoln, CA · Accident · Minor injuries · Final report · Dec 4, 1988 · N77KK · Substantial damage > The pilot stated that he was practicing takeoffs and landings on a local flight. During one of those landings he indicated that the right wheel locked up and caused the aircraft to veer to the right. He stated that he subsequently lost control of the aircraft… - [NTSB DEN89LA039](https://openairdocs.org/ntsb/DEN89LA039.md): Cessna 152 · Watkins, CO · Accident · No injuries · Limited investigation · Final report · Dec 4, 1988 · N4782B · Substantial damage > The student plt was practicing touch and go landings during an unsupervised solo flight. Runway 26 was in use, with winds reported as 320 deg at 5 KTS. At the first landing, the acft touched down nose first, thirty feet left of the center line. The acft… - [NTSB NYC89LA043](https://openairdocs.org/ntsb/NYC89LA043.md): Cessna 185 · Hanson, MA · Accident · No injuries · Limited investigation · Final report · Dec 3, 1988 · N6387 · Substantial damage > The pilot reported that he had just landed when the left brake failed. In order to avoid hitting trucks parked near the runway the pilot elected to ground loop the aircraft. The side loading on the left landing gear during the ground loop caused it to… - [NTSB MKC89LA036](https://openairdocs.org/ntsb/MKC89LA036.md): Piper PA-28 · Lakeview, AR · Accident · No injuries · Limited investigation · Final report · Dec 3, 1988 · N4344F · Substantial damage > During a personal cross country flight, the newly certificated private pilot said he was attempting to land on a 3200 foot grass strip with an existing gusting crosswind. He lost directional control during the landing, hit a runway light, tearing off the left… - [NTSB LAX89LA059](https://openairdocs.org/ntsb/LAX89LA059.md): Cessna 152 · Scottsdale, AZ · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 1988 · N47220 · Substantial damage > During the first solo flight, the student pilot reported that while on final approach, the airplane was high. The student reduced power and extended full flaps. During the landing roll, the student was intending to exit the runway on a right taxiway, however,… - [NTSB FTW89DPA03](https://openairdocs.org/ntsb/FTW89DPA03.md): Bell 47-D1 · Allen, TX · Accident · Serious injuries · Final report · Dec 2, 1988 · N74124 · Substantial damage > Unqualified pilot's poor judgement in leveling the helicopter during the flare and contributing to this was his lack of total experience in this type aircraft. - [NTSB ATL89FA051](https://openairdocs.org/ntsb/ATL89FA051.md): Bell 206B · Pinson, AL · Accident · No injuries · Field investigation · Final report · Dec 2, 1988 · N3TV · Substantial damage > Two FAA inspectors were conducting currency training when the helicopter landed hard during a practice power recovery autorotation. The pilot had delayed in applying power and collective pitch. Upon contact with the ground, all engine instruments indicated… - [NTSB BFO89LA013](https://openairdocs.org/ntsb/BFO89LA013.md): Swearingen SA-226T · Washington, DC · Accident · No injuries · Limited investigation · Final report · Nov 30, 1988 · N263CM · Substantial damage > Pilots failure to maintain control of the airplane during a touch and go landing. - [NTSB ATL89LA048](https://openairdocs.org/ntsb/ATL89LA048.md): Cessna 152 · Salisbury, NC · Accident · No injuries · Limited investigation · Final report · Nov 30, 1988 · N68001 · Substantial damage > The accident occurred during the student pilot's first supervised-solo flight. The student reported that she pushed the acft's nose down while on final appch after realizing she was too high, which led to an increase in airspeed. The student's instructor… - [NTSB NYC89LA041](https://openairdocs.org/ntsb/NYC89LA041.md): Robinson R22 · Sharon, MA · Accident · Minor injuries · Limited investigation · Final report · Nov 29, 1988 · N9035U · Substantial damage > Engine power loss while landing due to fuel exhaustion. - [NTSB MIA89LA042](https://openairdocs.org/ntsb/MIA89LA042.md): Piper PA-60-601P · Fort Pierce, FL · Accident · No injuries · Limited investigation · Final report · Nov 27, 1988 · N45MA · Substantial damage > Air traffic controllers stated that while the aircraft was on short final they noticed that the gear on the aircraft was not extended. They attempted to contact the pilot but he never responded. The pilot stated that he failed to extend the landing gear prior… - [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. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=380 ## 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=379 --- 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.