# 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 389 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB MKC88LA066](https://openairdocs.org/ntsb/MKC88LA066.md): Beech 23 · Fulton, MO · Accident · No injuries · Limited investigation · Final report · Mar 20, 1988 · N4704J · Substantial damage > While attempting a crosswind landing, the acft began to porpoise and veered off the runway. The left ldg gear failed and the wheel struck the aft section of the fuselage, then the horizontal stabilator. The PIC then applied full power, became airborne and… - [NTSB CHI88LA078](https://openairdocs.org/ntsb/CHI88LA078.md): Cessna 172P · Sebewaing, MI · Accident · No injuries · Limited investigation · Final report · Mar 20, 1988 · N66717 · Substantial damage > The plt rprtd that when he landed, the acft bounced twice & went straight forward for about 200 ft. when he applied brakes, the acft veered to the left. Subsequently, the acft went off the runway & into a ditch where the nose gear collapsed. The plt believed… - [NTSB SEA88LA063](https://openairdocs.org/ntsb/SEA88LA063.md): Stinson 108-2 · Cashmere, WA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1988 · N9660K · Destroyed > The acft touched down near midfield while landing on an 1800 ft long downsloping runway. When the pilot rapidly applied throttle for go-around, the engine faltered. He applied hard braking to stop on the runway and the aircraft nosed over. - [NTSB SEA88LA061](https://openairdocs.org/ntsb/SEA88LA061.md): Bellanca 8KCAB · Blackfoot, ID · Accident · No injuries · Limited investigation · Final report · Mar 19, 1988 · N36352 · Substantial damage > The pilot lost directional control of the aircraft during gusting crosswinds. During landing rollout the aircraft veered from the centerline of the runway to the right striking a fence. The pilot had only 7 hours of flight time in this aircraft. - [NTSB MKC88LA065](https://openairdocs.org/ntsb/MKC88LA065.md): Cessna 150J · Searcy, AR · Accident · No injuries · Limited investigation · Final report · Mar 19, 1988 · N50672 · Substantial damage > While landing in direct crosswind, the PIC lost directional control during the roll out. The acft veered off the runway, damaging the right wing tip and empennage. The pilot stated he thought a gust of wind caused the loss of control. - [NTSB LAX88LA131](https://openairdocs.org/ntsb/LAX88LA131.md): Schweizer SGS 1-26A · Phelan, CA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1988 · N3829A · Substantial damage - [NTSB ATL88LA119](https://openairdocs.org/ntsb/ATL88LA119.md): Cessna 150J · Villa Rica, GA · Accident · No injuries · Limited investigation · Final report · Mar 19, 1988 · N60586 · Substantial damage > Acft was landed to the west on a 2500' dirt strip. Trees, about 25-30' high bounded the approach threshold. Wind was variable nw to w gusting 15-18 KTS. PIC said acft dropped out from under him and landed hard. After bouncing it landed on nose gear which… - [NTSB LAX88LA136](https://openairdocs.org/ntsb/LAX88LA136.md): Bell 206B · Honolulu, HI · Accident · No injuries · Limited investigation · Final report · Mar 18, 1988 · N2995W · Substantial damage > After touchdown the plt reduced the throttle and removed his left hand from the throttle/collective pitch control to retune the radio. His attention was directed to the frequency indicator during the procedure. The helicopter became airborne and moved to the… - [NTSB ATL88DMG04](https://openairdocs.org/ntsb/ATL88DMG04.md): Marrek Smyth Sidewinder · Honea Path, SC · Accident · Minor injuries · Final report · Mar 17, 1988 · N25150 · Substantial damage - [NTSB ATL88LA116](https://openairdocs.org/ntsb/ATL88LA116.md): Cessna 172F · Myrtle Beach, SC · Accident · No injuries · Limited investigation · Final report · Mar 16, 1988 · N5244F · Substantial damage > The pilot reported that the airplane began to sink rapidly about 100 ft above the rwy threshold. He added pwr and initiated a flare. Upon touchdown, the airplane pitched down and rolled rt. The airplane subseqeuntly skidded off of the rt side of the rwy and… - [NTSB MKC88LA063](https://openairdocs.org/ntsb/MKC88LA063.md): Beech C23 · Sullivan, MO · Accident · No injuries · Limited investigation · Final report · Mar 15, 1988 · N1986L · Substantial damage > When the PIC arrived at his destination, during a personal cross country flight, he circled the unfamiliar arpt three times, observing trees on both ends, and a crosswind of about 60 degrees to the active runway. After landing, and during the ldg roll out, he… - [NTSB LAX88LA132](https://openairdocs.org/ntsb/LAX88LA132.md): Cessna 172Q · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Mar 15, 1988 · N918ER · Substantial damage - [NTSB NYC88LA108](https://openairdocs.org/ntsb/NYC88LA108.md): Cessna 182 · Batavia, NY · Accident · No injuries · Limited investigation · Final report · Mar 14, 1988 · N759GJ · Substantial damage > The acft was returning to the airport for landing after an instructional flight with a student. The student was landing the aircraft but when snow showers were encountered while flying downwind, the instructor pilot took control. He stated that he was landing… - [NTSB LAX88LA127](https://openairdocs.org/ntsb/LAX88LA127.md): Beech C23 · Placerville, CA · Accident · No injuries · Limited investigation · Final report · Mar 14, 1988 · N6967R · Substantial damage > Just after touch-down, the pilot stated that a deer darted out in front of the aircraft. The pilot did not have time to avoid colliding with the animal. - [NTSB LAX88LA124](https://openairdocs.org/ntsb/LAX88LA124.md): Cessna 180 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Mar 13, 1988 · N2952A · Substantial damage > The plt was completing a personal flt. During the landing roll the airplane began to swerve to the left. The plt reptd the rudder was ineffective due to the airplane's slow speed and she applied the brakes. Before the airplane came to a stop the left landing… - [NTSB SEA88LA057](https://openairdocs.org/ntsb/SEA88LA057.md): Piper PA-28R-200 · Elma, WA · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 1988 · N8374C · Substantial damage > During landing roll the pilot applied toe brakes. The right brake pedal went to the floor. The aircraft then veered to the left of the centerline despite the pilots attempt to groundloop the aircraft. The aircraft then rolled over an embankment, collapsing… - [NTSB LAX88LA122](https://openairdocs.org/ntsb/LAX88LA122.md): Piper PA-34-200T · Lower Lake, CA · Accident · No injuries · Limited investigation · Final report · Mar 11, 1988 · N1555X · Substantial damage > Drg the lndg roll, the left main lndg gear collapsed & the acft veered off the rwy, further damaging the aircraft. An investigation revealed the left main landing gear trunnion had failed. It had failed diagonally aprx 5 inches from the bottom of the trunnion… - [NTSB ANC88LA036](https://openairdocs.org/ntsb/ANC88LA036.md): Cessna 152 · Big Lake, AK · Accident · No injuries · Limited investigation · Final report · Mar 8, 1988 · N68945 · Substantial damage > The newly certificated private pilot was attempting to perform a soft-field, touch-and-go landing at an unimproved, off-airport site in deep snow. The airplane's main landing gear became mired in the snow, the nose wheel pitched down and the airplane… - [NTSB NYC88LA104](https://openairdocs.org/ntsb/NYC88LA104.md): Cessna 152 · Morristown, NJ · Accident · No injuries · Limited investigation · Final report · Mar 7, 1988 · N48900 · Substantial damage > During a landing rollout, the flight encountered strong gusty crosswinds. The aircraft ran off the right side of the runway. The nose wheel dug into mud and the prop and left wing tip made contact with the ground. - [NTSB MIA88LA120](https://openairdocs.org/ntsb/MIA88LA120.md): Robinson R-22 · Hialeah, FL · Accident · No injuries · Limited investigation · Final report · Mar 7, 1988 · N90669 · Substantial damage > While attempting to land in a field the pilot misjudged the height of the grass. The front part of the skids became entangled in the 2 foot height grass and the aircraft nosed over. Instruction was not taking place, however, the second pilot had 75 hours in… - [NTSB NYC88LA103](https://openairdocs.org/ntsb/NYC88LA103.md): Cessna 140 · Schroon Lake, NY · Accident · No injuries · Limited investigation · Final report · Mar 6, 1988 · N89431 · Substantial damage > During landing roll on a frozen lake, the left landing gear dug into a soft spot. The aircraft nosed over and was substantially damaged. In his recommendation for prevention of this acc, the plt said 'by not lndg on ice.' - [NTSB NYC88LA102](https://openairdocs.org/ntsb/NYC88LA102.md): Cessna 172 · Newport, VT · Accident · No injuries · Limited investigation · Final report · Mar 6, 1988 · N8428L · Substantial damage > During landing roll out on a frozen lake. The nose wheel contacted a soft spot in the ice and flipped over. - [NTSB ANC88LA035](https://openairdocs.org/ntsb/ANC88LA035.md): Cessna 152 · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Mar 4, 1988 · N96082 · Substantial damage > The flight instructor was giving dual instruction to a student pilot on night landings. On the sixth touch-and-go landing, the instructor turned the landing light off for a no-light landing. The student landed the aircraft to the right of centerline, and… - [NTSB MIA88FA122](https://openairdocs.org/ntsb/MIA88FA122.md): Boeing 747-200 · Miami, FL · Accident · No injuries · Field investigation · Final report · Mar 3, 1988 · LVOOZ · Substantial damage > After landing the Boeing 747-200 airliner, the captain increased the pitch attitude to 11 degrees nose up by pulling the control column aft. The tail struck the ground causing substantial damage. The Boeing airplane flight manual prescribes that the… - [NTSB CHI88LA072](https://openairdocs.org/ntsb/CHI88LA072.md): Cessna P210 · Indianapolis, IN · Accident · No injuries · Limited investigation · Final report · Mar 3, 1988 · N4741K · Substantial damage > While landing on the ice-covered runway, the pilot failed to stop his aircraft before the end of the runway. The aircraft ran off the departure end of the runway, encountered soft terrain and nosed over. The pilot had received two partial weather briefings,… - [NTSB CHI88LA071](https://openairdocs.org/ntsb/CHI88LA071.md): Cessna 150M · Crane, IN · Accident · No injuries · Limited investigation · Final report · Mar 2, 1988 · N66452 · Substantial damage > N66452, collided with a street signpost at the Crane naval depot, Crane, IN, during landing roll after a precautionary emergency landing. The right wing of the aircraft was substantially damaged. The student was on the return leg of a two-leg solo cross… - [NTSB ATL88LA112](https://openairdocs.org/ntsb/ATL88LA112.md): Cessna 152 · Statesville, NC · Accident · No injuries · Limited investigation · Final report · Mar 2, 1988 · N25265 · Substantial damage > The airplane encountered a crosswind gust at touchdown and the student plt lost control. The airplane veered off of the side of the rwy and subsequently impacted an embankment. The student had about 8 hrs of total solo flt experience, about 6 of which was… - [NTSB MIA88IA119](https://openairdocs.org/ntsb/MIA88IA119.md): Cessna 210M · Orlando, FL · Incident · No injuries · Incident investigation · Final report · Mar 1, 1988 · N823AR · Minor damage > While on a positioning flt the acft landed gear up. The plt stated that he failed to follow the checklist & forgot to lower the landing gear. Examination of the landing gear assy by FAA personnel revealed no failure or malfunction. - [NTSB NYC88LA098](https://openairdocs.org/ntsb/NYC88LA098.md): Piper PA-28-160 · West Dover, VT · Accident · No injuries · Limited investigation · Final report · Feb 29, 1988 · N83459 · Substantial damage > The PA-28 landed short of the runway and struck a snowbank receiving substantial damage. The pilot when interviewed by the FAA said the engine did not miss and wasn't cutting out and that he would have to 'take the majority of the blame'. On NTSB form 6120.1,… - [NTSB DEN88LA081](https://openairdocs.org/ntsb/DEN88LA081.md): Raven S55A · Los Lunas, NM · Accident · Serious injuries · Limited investigation · Final report · Feb 28, 1988 · N81DS · Substantial damage - [NTSB ANC88LA033](https://openairdocs.org/ntsb/ANC88LA033.md): Cessna 310Q · Mekoryuk, AK · Accident · No injuries · Limited investigation · Final report · Feb 28, 1988 · N7745Q · Substantial damage > The pilot stated that during the touchdown the aircraft struck a snowbank on the approach end of the runway. The aircraft exited the right side of the runway approximately 500 feet from the approach end. - [NTSB SEA88LA053](https://openairdocs.org/ntsb/SEA88LA053.md): Champion 7ECA · Othello, WA · Accident · No injuries · Limited investigation · Final report · Feb 27, 1988 · N5135T · Substantial damage > The student pilot encountered gusting winds and lost control of the aircraft during landing roll. The aircraft veered to the right of the runway and struck a parked unoccupied aircraft. - [NTSB MKC88LA056](https://openairdocs.org/ntsb/MKC88LA056.md): Cessna 150 · Manhattan, KS · Accident · No injuries · Limited investigation · Final report · Feb 26, 1988 · N8850G · Substantial damage > While practicing short field ldgs at night, the pilot stated he felt he stalled on final about 15 to 20 feet above the runway. The aircraft bounced three times, striking each wing on the first two touchdowns and collapsing the nose gear assembly on the last… - [NTSB SEA88LA052](https://openairdocs.org/ntsb/SEA88LA052.md): Piper PA-22-135 · Yakima, WA · Accident · No injuries · Limited investigation · Final report · Feb 25, 1988 · N8919C · Substantial damage > The pilot had just purchased the aircraft and was practicing takeoffs and landings. On the first landing attempt, during the ground roll after touchdwn, the pilot lost directional control and the aircraft ground looped. - [NTSB CHI88LA069](https://openairdocs.org/ntsb/CHI88LA069.md): Piper PA-38-112 · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Feb 25, 1988 · N2359K · Substantial damage > Student pilot stated that airplane went off runway at 50 KIAS after losing control during landing rollout. Airplane sustained substantial damaged when nose gear collapsed. - [NTSB LAX88LA115](https://openairdocs.org/ntsb/LAX88LA115.md): Cessna 180A · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Feb 24, 1988 · N26AW · Substantial damage > During the dual primary cross country flight, the student was making the approach and landing at Prescott. The CFI said that the approach and touchdown were normal, however, the aircraft began drifting to the right in a gradual turn as the aircraft slowed.… - [NTSB CHI88LA086](https://openairdocs.org/ntsb/CHI88LA086.md): Mooney M-20C · Minneapolis, MN · Accident · No injuries · Limited investigation · Final report · Feb 24, 1988 · N6228U · Substantial damage > While executing touch and go landings the pilot's attention was diverted inside the aircraft while adjusting the interior lights to determine the position of the flaps. He lost control of the aircraft and it departed the runway striking a snow bank. - [NTSB BFO88LA020](https://openairdocs.org/ntsb/BFO88LA020.md): Maule MX7-180 · Lewisburg, WV · Accident · No injuries · Limited investigation · Final report · Feb 24, 1988 · N5662H · Substantial damage > The plt started landing flare on rwy 22 when he encountered wind gusts. The acft swung right and the left wing struck the rwy. The acft cartwheeled and came to a stop inverted. - [NTSB DEN88DQA02](https://openairdocs.org/ntsb/DEN88DQA02.md): Shiner Pitts S-1S · Los Lunas, NM · Accident · Minor injuries · Final report · Feb 23, 1988 · N79SS · Substantial damage > The plt reported that the tailwheel steering chain broke during the landing rollout. When the acft slowed to about 30 KTS the rudder was no longer effective and the plt was unable to control direction by use of the brakes. The acft turned to the lt and ran… - [NTSB NYC88LA089](https://openairdocs.org/ntsb/NYC88LA089.md): Cessna 172 · Rochester, NH · Accident · No injuries · Limited investigation · Final report · Feb 22, 1988 · N1061F · Substantial damage > During landing, the flight encountered a crosswind from the left and almost immediately the aircraft became airborne again. The pilot flared for landing, landed hard, bounced and at this time the pilot decided to abort and go around. The aircraft drifted to… - [NTSB LAX88LA111](https://openairdocs.org/ntsb/LAX88LA111.md): Cessna R182 · San Andreas, CA · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 1988 · N3178C · Destroyed > During a night flight the plt attempted to land on a 3600-FT-long rwy. He misjudged his altitude, touched down long & attempted to go-around. The acft became airborne & upon passing the airport's boundary it collided with a fence & crashed. The plt did not… - [NTSB DEN88LA079](https://openairdocs.org/ntsb/DEN88LA079.md): Piper PA-28RT-201T · Aurora, CO · Accident · Minor injuries · Limited investigation · Final report · Feb 21, 1988 · N2904C · Substantial damage - [NTSB DEN88LA076](https://openairdocs.org/ntsb/DEN88LA076.md): Mooney M20E · Miles City, MT · Accident · Serious injuries · Limited investigation · Final report · Feb 21, 1988 · N6693R · Substantial damage - [NTSB CHI88LA066](https://openairdocs.org/ntsb/CHI88LA066.md): Cessna 150L · Springfield, IL · Accident · No injuries · Limited investigation · Final report · Feb 21, 1988 · N18225 · Substantial damage > The aircraft experienced a hard landing followed by collapse of the nose gear. The student pilot stated that he bounced on his first attempt to land and the second touchdown was nose first which resulted in the collapse of the nose gear. - [NTSB ATL88IA096](https://openairdocs.org/ntsb/ATL88IA096.md): Piper PA-23-250 · Elyria, OH · Incident · No injuries · Incident investigation · Final report · Feb 21, 1988 · N5740Y · Minor damage - [NTSB NYC88LA086](https://openairdocs.org/ntsb/NYC88LA086.md): Cessna 152 · Concord, NH · Accident · No injuries · Limited investigation · Final report · Feb 18, 1988 · N6341H · Substantial damage > The student pilot was attempting a landing at Concord municipal airport. The aircraft touched down hard, bounced and at this time the pilot applied full throttle in an attempt to abort the landing and go around. However the aircraft veered left and struck… - [NTSB ATL88LA094](https://openairdocs.org/ntsb/ATL88LA094.md): Piper PA-22-150 · Galion, OH · Accident · Minor injuries · Limited investigation · Final report · Feb 18, 1988 · N4305A · Substantial damage > The airplane bounced during ldg, and subsequently ran off the side of the rwy into snow and nosed over. The wind conditions at the time were reportedly calm. The airplane was equipped with stc-approved conventional (taildragger) ldg gear. The plt stated he… - [NTSB BFO88LA021](https://openairdocs.org/ntsb/BFO88LA021.md): Cessna 140 · Orange, VA · Accident · Minor injuries · Limited investigation · Final report · Feb 17, 1988 · N2300N · Substantial damage > According to the plt, during the landing roll the acft drifted to the right and before he could take corrective action the acft ground looped. He had 3 hrs of total time in this make/model acft. The plt rptd he was late applying corrective rudder forces. He… - [NTSB NYC88LA082](https://openairdocs.org/ntsb/NYC88LA082.md): Gulfstream AA-5B · Bridgeport, CT · Accident · No injuries · Limited investigation · Final report · Feb 16, 1988 · N26834 · Destroyed > During a touch and go landing, the aircraft touched down on the main gear just past the numbers. Full right aileron and left rudder was used for directional control. During rollout, the right wing came up and the left wing made contact with the runway… - [NTSB BFO88LA019](https://openairdocs.org/ntsb/BFO88LA019.md): Beech C-23 · Roanoke, VA · Accident · No injuries · Limited investigation · Final report · Feb 15, 1988 · N6634R · Substantial damage > This was the stu plt fifth training session where he did solo touch & go landings. During this session he made ten landings without incident. Six landings were made with his instr aboard followed by four solo landings. According to the stu during the flare… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=390 ## 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=389 --- 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.