# 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 390 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB DEN88LA070](https://openairdocs.org/ntsb/DEN88LA070.md): Piper J3C-65 · Circle, MT · Accident · No injuries · Limited investigation · Final report · Feb 14, 1988 · N55PA · Substantial damage > Plt and passenger were hunting coyotes from the air. Upon landing to pick up a coyote they had shot, the acft encountered deep snow and nosed over. - [NTSB CHI88LA062](https://openairdocs.org/ntsb/CHI88LA062.md): Cessna 172 · Ft. Wayne, IN · Accident · No injuries · Limited investigation · Final report · Feb 14, 1988 · N5499K · Substantial damage > Airplane nosed over in soft snow during a crosswind landing attempt. The PIC tried to recover from a loss of directional control by attempting to roll out on snow covered sod after hopping over a snowbank that was next to the runway landing surface. - [NTSB LAX88LA109](https://openairdocs.org/ntsb/LAX88LA109.md): Cessna 185E · Redding, CA · Accident · No injuries · Limited investigation · Final report · Feb 13, 1988 · CFCTO · Substantial damage > The canadian plt attempted to land the conventional gear acft on runway 34 with the reported local wind from 330 deg at 16 KTS. The acft touched down about 2400 ft beyond the threshold of the 7003-foot-long rwy. After a bounced landing, directional control… - [NTSB ANC88LA029](https://openairdocs.org/ntsb/ANC88LA029.md): Cessna 180 · 70 Nw Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Feb 13, 1988 · N674M · Substantial damage > The pilot stated that during the landing roll on the frozen lake he lost directional control of the aircraft due to the snow on the lake. The aircraft then nosed over on its back. - [NTSB NYC88LA085](https://openairdocs.org/ntsb/NYC88LA085.md): Mitsubishi MU-2B-35 · Philadelphia, PA · Accident · No injuries · Limited investigation · Final report · Feb 12, 1988 · N339MA · Substantial damage > The Mitsubishi MU-2B-35 landed and damage was observed on the underside of the left wing midway between the engine and tip tank and outboard to the tip tank. Further examination of the wing showed a broken lower front wing spar and a bent rear lower wing… - [NTSB NYC88LA081](https://openairdocs.org/ntsb/NYC88LA081.md): Piper PA-24-260 · Chatham, MA · Accident · No injuries · Limited investigation · Final report · Feb 12, 1988 · N9281P · Substantial damage > After aborting two landings on runway 24 at Chatham, Massachusetts, the pilot was advised by radio to use runway 6. While attempting a landing on runway 6, the airplane touched down short of the runway and the landing gear was sheared off when it struck a… - [NTSB MKC88LA052](https://openairdocs.org/ntsb/MKC88LA052.md): Cessna 172 · Kimball, NE · Accident · No injuries · Limited investigation · Final report · Feb 11, 1988 · N12600 · Substantial damage > The pilot said that he was using outdated charts for his destination apt. He failed to notice a new runway. He also failed to notice the yellow x's, signifying closure of the old runway. It was almost parallel to the runway, within ten degrees of heading. Ldg… - [NTSB CHI88LA065](https://openairdocs.org/ntsb/CHI88LA065.md): Cessna 172F · Brighton, MI · Accident · No injuries · Limited investigation · Final report · Feb 11, 1988 · N8863U · Substantial damage - [NTSB CHI88IA061](https://openairdocs.org/ntsb/CHI88IA061.md): Douglas DC-10 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Feb 11, 1988 · N123AA · No damage > Judgemental error on the part of the local controller for clearing vehicles across the active runway tiwh insufficient separation from arriving aircraft, which was further compromised by a mechanical malfunction in the equipment crossing the runway. - [NTSB LAX88LA107](https://openairdocs.org/ntsb/LAX88LA107.md): Piper PA-38-112 · Van Nuys, CA · Accident · Minor injuries · Limited investigation · Final report · Feb 10, 1988 · N25732 · Substantial damage > The student pilot was on his second supervised solo and had executed a go-around on his first attempted touch & go maneuver. The plt reentered the traffic pattern and landed on runway 34L. The airplane exited to the left of the runway onto the grass. With the… - [NTSB FTW88FA060](https://openairdocs.org/ntsb/FTW88FA060.md): Piper PA-32RT-300T · Oklahoma City, OK · Accident · No injuries · Field investigation · Final report · Feb 10, 1988 · N2186K · Substantial damage > The airplane was equipped for IFR but not equipped to fly into icing cond. At 4000 feet MSL, the OAT was above freezing. At 3000 feet MSL the airplane was in clouds with OAT of 32 degrees f. the plt elected to attempt downwind ILS approach and landing. Plt… - [NTSB DEN88LA067](https://openairdocs.org/ntsb/DEN88LA067.md): Cessna 180 · Roundup, MT · Accident · No injuries · Limited investigation · Final report · Feb 10, 1988 · N7661A · Substantial damage > The private plt rancher was completing a work flt. During the flt, the plt made 5 off arpt landings in snow 5 to 6 inches deep. The landing on which the accident occurred was made at a local arpt on a snow covered rwy. During the landing, the acft sank into… - [NTSB DEN88LA066](https://openairdocs.org/ntsb/DEN88LA066.md): Piper J3C · Cody, WY · Accident · No injuries · Limited investigation · Final report · Feb 10, 1988 · N7468 · Substantial damage > During an attempted landing at a private airstrip which was covered by 5-6 inches of dry powdered snow, the acft touched down. It pitched forward and nosed over. After the acft came to rest, the pilot got out of the acft, examined the landing gear, and… - [NTSB MKC88LA048](https://openairdocs.org/ntsb/MKC88LA048.md): Cessna T-188C · Goodland, KS · Accident · No injuries · Limited investigation · Final report · Feb 9, 1988 · N4509J · Substantial damage > While flying a certificated experimental ag acft, for purpose of compliance with FAR regulations, the employee of the federal aviation administration lost control during landing rollout. The wind conditions, relative to the runway, were about a 80 degree… - [NTSB MIA88LA102](https://openairdocs.org/ntsb/MIA88LA102.md): Hess QUICKIE-2 · Orlando, FL · Accident · Minor injuries · Limited investigation · Final report · Feb 9, 1988 · N3241K · Substantial damage > The plt stated that on the landing rollout, the acft began to veer left. While he was attempting correction to the right, the acft hit a bump off the runway, flipped over & came to rest inverted. - [NTSB CHI88LA059](https://openairdocs.org/ntsb/CHI88LA059.md): Piper PA-28R-180 · Wis. Rapids, WI · Accident · No injuries · Limited investigation · Final report · Feb 9, 1988 · N3790T · Substantial damage > Airplane drifted left into a snowbank while rolling out from a landing on a snow and ice covered runway. Landing winds as reported by the pilot were from 60 degrees to the right of the nose at 5 to 8 knots. - [NTSB LAX88LA106](https://openairdocs.org/ntsb/LAX88LA106.md): Cessna TR182 · Truckee, CA · Accident · No injuries · Limited investigation · Final report · Feb 7, 1988 · N5533S · Substantial damage - [NTSB SEA88LA044](https://openairdocs.org/ntsb/SEA88LA044.md): Cessna 172N · Henderson, NV · Accident · No injuries · Limited investigation · Final report · Feb 5, 1988 · N2249E · Substantial damage > During ground landing roll on a touch and go practice session, the solo student pilot allowed the aircraft to drift off the side of the runway and overcorrected in the opposite direction. After applying full power to abort the landing, she realized the flaps… - [NTSB MIA88LA100](https://openairdocs.org/ntsb/MIA88LA100.md): Beech V-35 · Fernandina Bch, FL · Accident · No injuries · Limited investigation · Final report · Feb 5, 1988 · N7987M · Substantial damage > While on a personal flt, the acft landed gear up. The plt stated that he lowered it. He also stated that the gear warning horn was inoperative. Operational check of the landing gear revealed no discrepancies except for an improperly adjusted warning horn &… - [NTSB CHI88LA058](https://openairdocs.org/ntsb/CHI88LA058.md): Beech A36 · Pontiac, MI · Accident · No injuries · Limited investigation · Final report · Feb 4, 1988 · N383SP · Substantial damage - [NTSB NYC88LA091](https://openairdocs.org/ntsb/NYC88LA091.md): Cessna 303 · Hyannis, MA · Accident · No injuries · Limited investigation · Final report · Feb 3, 1988 · N5461V · Substantial damage > The Cessna 303 broke out of the clouds and made a long landing on a 5567 ft runway. Tire marks showed that the aircraft touched down with less than 2000 ft of runway remaining. The landing runway was 24 and the winds were from 360 degrees at 8 KTS. The runway… - [NTSB MKC88LA051](https://openairdocs.org/ntsb/MKC88LA051.md): Piper PA-34-200T · Texarkana, AR · Accident · No injuries · Limited investigation · Final report · Feb 3, 1988 · N2824M · Substantial damage > Following the completion of the ILS approach and landing on runway 22 at the Texarkana, Arkansas airport the nose gear of the aircraft collapsed during the landing roll. The aircraft collided with the runway causing substantial damage to the aircraft. The… - [NTSB DEN88FA061](https://openairdocs.org/ntsb/DEN88FA061.md): Convair 580 · Durango, CO · Accident · Minor injuries · Field investigation · Final report · Feb 3, 1988 · N5808 · Substantial damage > After making an IFR approach, the pilot made a go-around because he was blinded by the reflection of the landing/taxi lights against the falling snow. The pilot landed the aircraft after the second approach. The pilot said he sensed the aircraft drifting to… - [NTSB CHI88LA057](https://openairdocs.org/ntsb/CHI88LA057.md): Cessna 421A · Wheeling, IL · Accident · No injuries · Limited investigation · Final report · Feb 3, 1988 · N421Q · Substantial damage - [NTSB NYC88LA075](https://openairdocs.org/ntsb/NYC88LA075.md): Cessna 402C · Provincetown, MA · Accident · No injuries · Limited investigation · Final report · Feb 2, 1988 · N29PB · Substantial damage > The Cessna 402C was being positioned for a scheduled commuter flight with only a pilot on board. The pilot made an ILS approach to runway 7 with winds from 220 degrees at 14 knots, the runway wet and light rain falling. The aircraft slid off the end of the… - [NTSB MKC88IA046](https://openairdocs.org/ntsb/MKC88IA046.md): Saab-Fairchild SF-340A · Fayetteville, AR · Incident · Minor injuries · Incident investigation · Final report · Feb 2, 1988 · N322PX · Minor damage > The capt rprtd that drg the lndg roll, there was a loud noise from the left eng followed by hvy smoke & an eng fire warning bell. He stopped the acft on a twy & ordered an evacuation. The flt attendant had difficulty opening the floor-level emerg exit. No… - [NTSB BFO88LA016](https://openairdocs.org/ntsb/BFO88LA016.md): Dassault DA-20 · Wheeling, WV · Accident · No injuries · Limited investigation · Final report · Feb 1, 1988 · N287W · Substantial damage > The acft landed after an ILS apch to rwy 03. According to the plt shortly after touchdown he saw deer ahead on the rwy. Before he could take evasive action the acft struck two deer. Afterwards brake pressure was lost. The plt steered the acft onto grass off… - [NTSB NYC88LA070](https://openairdocs.org/ntsb/NYC88LA070.md): Cessna 195 · Meriden, CT · Accident · No injuries · Limited investigation · Final report · Jan 31, 1988 · N1077D · Substantial damage > After performing several touch and go landings, the student pilot made a landing right of the center line. The aircraft drifted to the right, struck a snowbank, sheared off the left main landing gear, then groundlooped. The aircraft came to rest on the grass… - [NTSB MIA88LA098](https://openairdocs.org/ntsb/MIA88LA098.md): Grumman AA-5B · Clearwater, FL · Accident · No injuries · Limited investigation · Final report · Jan 31, 1988 · N28571 · Substantial damage > Plt stated acft stalled during landing flare resulting in a hard landing. After the hard landing the acft bounced into the air and veered to the left. Before a go-around could be completed the acft collided with a dirt mound between the runway and taxiway… - [NTSB MIA88LA096](https://openairdocs.org/ntsb/MIA88LA096.md): Cessna 150 · Titusville, FL · Accident · No injuries · Limited investigation · Final report · Jan 31, 1988 · N9260U · Substantial damage > Student pilot lost directional control while landing with right quartering wind. The acft departed the left side of the runway and the nose gear bogged down in sand. The nose gear then failed aft and the acft came to rest on the nose and left wing tip. - [NTSB LAX88LA104](https://openairdocs.org/ntsb/LAX88LA104.md): Bellanca 7ECA · Sonoma, CA · Accident · No injuries · Limited investigation · Final report · Jan 31, 1988 · N5058K · Substantial damage > At the end of a local pleasure flight, during the landing roll, the pilot lost control of the aircraft and ground looped. There were no reported mechanical failures or malfunctions of the aircraft. - [NTSB DEN88LA059](https://openairdocs.org/ntsb/DEN88LA059.md): Piper PA-18-150 · Peyton, CO · Accident · No injuries · Limited investigation · Final report · Jan 30, 1988 · N62491 · Substantial damage - [NTSB LAX88IA102](https://openairdocs.org/ntsb/LAX88IA102.md): Fairchild SA227AC · S. Lake Tahoe, CA · Incident · No injuries · Incident investigation · Final report · Jan 29, 1988 · N368AE · No damage > Captain's failure to follow flight manual procedures in the operation of the anti-ice/de-ice systems. - [NTSB MKC88LA047](https://openairdocs.org/ntsb/MKC88LA047.md): Cessna 152 · Ottawa, KS · Accident · No injuries · Limited investigation · Final report · Jan 28, 1988 · N4717A · Substantial damage > The student pilot was on a solo cross country flight. During the landing, the aircraft began to porpoise. The pilot performed remedial action, however, the aircraft had already sustained substantial damage. - [NTSB DEN88LA058](https://openairdocs.org/ntsb/DEN88LA058.md): Piper PA-32-260 · Colorado Spring, CO · Accident · No injuries · Limited investigation · Final report · Jan 28, 1988 · N1246T · Substantial damage > The private plt and two passengers were conducting a personal night flight. During landing, the aircraft drifted left and the left main gear struck a snow drift. The plt elected to go around and on the second approach at touchdown, the aircraft skidded left… - [NTSB SEA88LA041](https://openairdocs.org/ntsb/SEA88LA041.md): Cessna 172M · St. Anthony, ID · Accident · Minor injuries · Limited investigation · Final report · Jan 27, 1988 · N2320E · Substantial damage > During landing onto the 50 foot wide snow covered runway, directional control was lost with the aircraft drifting to the left of the runway, striking a snow berm, and then nosing over inverted. - [NTSB CHI88LA051](https://openairdocs.org/ntsb/CHI88LA051.md): Cessna 172N · Fond Du Lac, WI · Accident · No injuries · Limited investigation · Final report · Jan 24, 1988 · N75716 · Substantial damage - [NTSB SEA88LA037](https://openairdocs.org/ntsb/SEA88LA037.md): Cessna 172P · Vashon Island, WA · Accident · No injuries · Limited investigation · Final report · Jan 20, 1988 · N5328K · Substantial damage > During landing roll the pilot made an intentional groundloop to avoid trees at the end of the short, wet, S0D runway. The pilot reported that the use of brakes was ineffective. He stated that he made the landing using 30 degs of flaps at an airspeed of 60… - [NTSB MKC88LA044](https://openairdocs.org/ntsb/MKC88LA044.md): Cessna 206 · Wichita, KS · Accident · No injuries · Limited investigation · Final report · Jan 20, 1988 · N4978C · Substantial damage > During a night ldg with strong gusty x-winds, the PIC lost control during the roll out and careened off the runway substantialy damaging the acft. The PIC stated the windshield was partially coated with ice making forward visibility difficult. - [NTSB MIA88LA091](https://openairdocs.org/ntsb/MIA88LA091.md): Air Tractor AT-301 · Port Saint Joe, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 20, 1988 · N36534 · Substantial damage > While on a business flt, unable to locate the landing site with darkness approaching & low supply of fuel, the plt performed a precautionary landing on a soft dirt road. During the landing roll the acft nosed over & came to rest. The plt did not file an acc… - [NTSB LAX88LA092](https://openairdocs.org/ntsb/LAX88LA092.md): Aeronca 11AC · Lakeport, CA · Accident · No injuries · Limited investigation · Final report · Jan 20, 1988 · N9416E · Substantial damage > During ldg rollout the acft veered off the rwy, went into a ditch & collided with terrain causing substantial damage. The surface winds were estimated at only 5 KTS. The plt acknowledged that the accident might have been prevented if he had been less… - [NTSB FTW88LA075](https://openairdocs.org/ntsb/FTW88LA075.md): Aerospatiale AS-355-F1 · Grand Prairie, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 20, 1988 · N5800F · Substantial damage > The acdt occurred on the 2nd flt of transition trng for an experienced helicopter plt. The trng on this flt included sim tail rotor failure run-on landings. The CFI demonstrated 2 landings and the trainee took the controls for the 3rd. The landings were being… - [NTSB DEN88LA056](https://openairdocs.org/ntsb/DEN88LA056.md): Cessna 150M · Delta, UT · Accident · No injuries · Limited investigation · Final report · Jan 20, 1988 · N6372K · Substantial damage > During the landing roll, the acft swerved to the right into a snowbank and nosed over. The plt said he found snow packed between the landing gear wheel and wheel pants restricting the wheel from rotating. In his recommendation for prevention, the plt stated… - [NTSB LAX88LA096](https://openairdocs.org/ntsb/LAX88LA096.md): Cessna 402C · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Jan 18, 1988 · N6842Q · Substantial damage - [NTSB FTW88LA167](https://openairdocs.org/ntsb/FTW88LA167.md): Adams A-60 · Austin, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 18, 1988 · N9811N · No damage > The balloon was deflated by the passenger when he pulled the crown line. Contributing to this was the pilot's poor judgement in relinquishing the line to the passenger. - [NTSB MIA88LA087](https://openairdocs.org/ntsb/MIA88LA087.md): Cessna 182Q · Tampa, FL · Accident · Minor injuries · Limited investigation · Final report · Jan 16, 1988 · N5244N · Substantial damage > During the landing roll the acft veered off the rwy, travelled through a retention pond, nosed over & came to rest. According to a plt who landed shortly after the accident, he had his hands full landing on the same rwy due to a 'stiff crosswind'. The pilot… - [NTSB CHI88LA049](https://openairdocs.org/ntsb/CHI88LA049.md): Cessna 172L · Buffalo, MN · Accident · No injuries · Limited investigation · Final report · Jan 16, 1988 · N7895G · Substantial damage - [NTSB LAX88LA086](https://openairdocs.org/ntsb/LAX88LA086.md): Cessna 195 · Sonoma, CA · Accident · No injuries · Limited investigation · Final report · Jan 14, 1988 · CGADA · Substantial damage > During a local pilot check flight, upon touchdown, a loud bang was heard. The acft gradually veered to the right then ground looped. A local mechanic was unable to identify a failure. The plt reported that the brakes were operating normally prior to and… - [NTSB LAX88LA084](https://openairdocs.org/ntsb/LAX88LA084.md): Cessna T210L · Blythe, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 13, 1988 · N2516S · Substantial damage > A Cessna T210L was found abandoned with the landing gear collapsed. Skid marks were noted on the ground where the aircraft had touched down on the rough terrain. The pilot was never identified and traces of illegal contraband were found in the aircraft. - [NTSB ANC88LA024](https://openairdocs.org/ntsb/ANC88LA024.md): Cessna 150D · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · Jan 13, 1988 · N4379U · Substantial damage > The flight instructor stated the student landed back on the runway after a practice engine failure; at that point the flight instructor realized how slick the runway was and the aircraft exited the departure end of the runway into a snow bank. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=391 ## 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=390 --- 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.