# 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 444 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB NYC84LA181](https://openairdocs.org/ntsb/NYC84LA181.md): Cessna 177B · Spring Valley, NY · Accident · No injuries · Limited investigation · Final report · May 22, 1984 · N34370 · Destroyed > Sufficient alt was not obtained to clear trees located aprx 100 ft off the departure end of the rwy during an aborted landing to avoid an overrun. - [NTSB DEN84LA160](https://openairdocs.org/ntsb/DEN84LA160.md): Piper PA-34-220T · Englewood, CO · Accident · No injuries · Limited investigation · Final report · May 22, 1984 · N42984 · Substantial damage > According to the plt, the acft touched down during a landing, then became airborne again in unfavorable wind conditions. He reported that the plane then slammed back onto the rwy & was damaged. - [NTSB LAX84LA312](https://openairdocs.org/ntsb/LAX84LA312.md): Cessna 172N · Hayward, CA · Accident · No injuries · Limited investigation · Final report · May 21, 1984 · N734TH · Substantial damage > The acft landed hard and porpoised down the rwy. The plt made a go-around and reported to the tower that he had control problems. He performed a tower fly-by and no damage was apparent to the controllers. The plt was cleared for landing anddid so without… - [NTSB NYC84FHD02](https://openairdocs.org/ntsb/NYC84FHD02.md): Cessna 337 · Coatsville, PA · Accident · 1 fatal · Final report · May 20, 1984 · N213DL · Destroyed > After touchdown about 2,000 ft down the 4,600 x 100 ft rwy the acft bounced back into the air. Witnesses observed the acft rt wing drop causing it to veer to the rt toward a line of parked acft. 900 ft from initial touchdown the acft impacted rt wing first in… - [NTSB LAX84LA306](https://openairdocs.org/ntsb/LAX84LA306.md): Piper PA-32-301 · San Jose, CA · Accident · No injuries · Limited investigation · Final report · May 20, 1984 · N82009 · Substantial damage > The acft nose gear collapsed during landing. Witnesses described the bounced landing as a 'porpoise'. - [NTSB LAX84LA301](https://openairdocs.org/ntsb/LAX84LA301.md): Grumman F-6F5 · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · May 20, 1984 · NX496W · Substantial damage > The plt stated that he made a normal landing, but 'upon touching brakes, left brake appeared to lock.' He stated he was unable to correct with right rudder & brake. The acft swerved off the left side of the rwy, went into a ditch & nosed over. Witnesses… - [NTSB ATL84LA178](https://openairdocs.org/ntsb/ATL84LA178.md): Cessna 152 · Lacey Springs, AL · Accident · No injuries · Limited investigation · Final report · May 20, 1984 · N6231B · Substantial damage > When the plt was arriving at the uncontrolled arpt, no UNICOM was available, since the office was closed. The plt elected to land on rwy 24 after seeing another acft depart. The 1st apch was aborted due to gusty winds. After the 2nd apch, the acft touched… - [NTSB ATL84LA180](https://openairdocs.org/ntsb/ATL84LA180.md): Cessna 140 · Harrisonburg, VA · Accident · No injuries · Limited investigation · Final report · May 19, 1984 · N72115 · Substantial damage > The acft's left main landing gear strut failed during a landg. A mechanic, who examined the acft, stated that the strut had a previously existing crack prior to the accident. The strut failed at a hole where the step was attached. - [NTSB LAX84LA297](https://openairdocs.org/ntsb/LAX84LA297.md): Let L-13 · El Mirage, AZ · Accident · No injuries · Limited investigation · Final report · May 18, 1984 · N3204F · Substantial damage > The glider plt reported that after a release from the tow line, he had difficulty finding lift. He concentrated on finding lift so much that he became disoriented with respect to the rwy. When he elected to return to the arpt, he inadvertently selected a… - [NTSB FTW84LA248](https://openairdocs.org/ntsb/FTW84LA248.md): Piper PA-28-181 · New Roads, LA · Accident · No injuries · Limited investigation · Final report · May 18, 1984 · N2130J · Substantial damage > The flt instructor stated that the 17 hr student plt was on a supervised solo flt when the accident occurred. The student was landing on rwy 18 with a wind from 220 degrees at 6 KTS. The student was unable to maintain directional control and the acft traveled… - [NTSB ANC84LA079](https://openairdocs.org/ntsb/ANC84LA079.md): Piper PA-18-150 · Sand Point, AK · Accident · No injuries · Limited investigation · Final report · May 18, 1984 · N4065E · Substantial damage > The plt stated that at the end of the landing roll, a strong gusty crosswind blew the acft to the left side breaking the left landing gear & wing. - [NTSB CHI84LA193](https://openairdocs.org/ntsb/CHI84LA193.md): Cessna 172M · West Lafayette, OH · Accident · No injuries · Limited investigation · Final report · May 16, 1984 · N8890V · Substantial damage > The acrt swerved off the rwy into soft plowed terrain and nosed over. The plt said that the wind had changed direction and velocity since his takeoff 2 hours before. - [NTSB CHI84IA195](https://openairdocs.org/ntsb/CHI84IA195.md): Cessna 152 · Mansfield, OH · Incident · No injuries · Incident investigation · Final report · May 16, 1984 · N5243Q · Minor damage > The plt stated that he made a normal cross wind landing and after a 5-10 ft ground roll, was blown off the rt side of the rwy. - [NTSB SEA84LA107](https://openairdocs.org/ntsb/SEA84LA107.md): Cessna 180H · Bellingham, WA · Accident · No injuries · Limited investigation · Final report · May 15, 1984 · N7999V · Substantial damage > During the landing roll with a cross-wind, directional control was lost & the acft ground-looped to the left collapsing the right main landing. - [NTSB NYC84LA197](https://openairdocs.org/ntsb/NYC84LA197.md): Cessna C172 · Mansfield, MA · Accident · No injuries · Limited investigation · Final report · May 15, 1984 · N9654Q · Substantial damage > Student plt on first solo landed hard due to late flare. The acft touched down on the nose gear resulting in substantialdamage. A go-around was accomplished followed by an uneventful landing. - [NTSB NYC84LA173](https://openairdocs.org/ntsb/NYC84LA173.md): Beech B19 · Danbury, CT · Accident · No injuries · Limited investigation · Final report · May 15, 1984 · N6539R · Substantial damage > The plt stated while performing the last landing of the day a gust of wind blew the left wing up as the acft was being flared. The acft landed hard and bounced back into the air. A go-around was initiated but when another taxing acft was viewed in the… - [NTSB MKC84LA141](https://openairdocs.org/ntsb/MKC84LA141.md): Cessna 120 · Larchwood, IA · Accident · No injuries · Limited investigation · Final report · May 15, 1984 · N76450 · Substantial damage > The acft nosed over after bouncing off the rwy during landing. The plt said he landed long and fast and was feeling apprehensive; when the acft bounced he released back pressure on the stick which caused a greater bounce and an excursion off the rwy. The plt… - [NTSB MKC84LA139](https://openairdocs.org/ntsb/MKC84LA139.md): Cessna 152 · No.Little Rock, AR · Accident · No injuries · Limited investigation · Final report · May 15, 1984 · N757KD · Substantial damage > The acft collided with a rwy light and nosed over during landing in a x-wind. The wind was reported to the student as from 040 degrees at 9 KTS at takeoff and 070 degrees at 11 KTS when she returned to land. These winds converted to a 90 degree x-wind of 6.5… - [NTSB DEN84LA149](https://openairdocs.org/ntsb/DEN84LA149.md): Cessna 172N · Kindred, ND · Accident · No injuries · Limited investigation · Final report · May 14, 1984 · N738FA · Substantial damage > The pilot stated that he made a normal landing approach to runway 15. During touchdown a gust of wind hit the airplane. The pilot said he was caught off guard and before he could regain control, the airplane went off the right side of the runway, struck a… - [NTSB CHI84LA190](https://openairdocs.org/ntsb/CHI84LA190.md): Beech V35B · West Chicago, IL · Accident · No injuries · Limited investigation · Final report · May 14, 1984 · N6660T · Substantial damage > The acft bounced during landing and lost the nose gear in the process. The plt stated he touched down on all three gear, ballooning back into the air nose high. He stated he pushed the nose down to gain airspeed when the nose hit the runway breaking off the… - [NTSB MKC84LA137](https://openairdocs.org/ntsb/MKC84LA137.md): Beech BE95A55 · Springfield, MO · Accident · No injuries · Limited investigation · Final report · May 13, 1984 · N323E · Substantial damage > The acft landing gear collapsed during landing. The plt said he was following a metroliner & put the gear handle 'down' but does not remember the gear indicators. He reduced the throttles to about 11 inches of manifold pressure & does not remember hearing a… - [NTSB SEA84LA105](https://openairdocs.org/ntsb/SEA84LA105.md): Helio H-700-SP · Meridian, ID · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N708JS · Substantial damage > The plt stated that while landing onto his own field the left main gear caught in a deep furrow. The acft then veered to the right striking a woven wire & barbed wire fence, & a railroad tie. - [NTSB NYC84LA174](https://openairdocs.org/ntsb/NYC84LA174.md): Beech Bonanza F33A · Tarentum, PA · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N4463S · Substantial damage > Plt made lndg apch to rwy 02 at 95 mph, flaps one-third down and rt wing down for wind compensation. Plt stated winds were at 090 deg. At 30 ft above the rwy the acft encountered a sudden gust of wind from 270 deg. The acft drifted to thert side of the rwy… - [NTSB NYC84FNC02](https://openairdocs.org/ntsb/NYC84FNC02.md): Piper PA-31S 2 · Rockland, ME · Accident · Serious injuries · Final report · May 12, 1984 · N700D · Substantial damage > Following the rwy 03 LOC apch plt decided to land straight in with a tailwind rather than circling because of low clouds surrounding the arpt. Acft touched down with aprx 2000 ft of wet rwy remaining. Acft traveled off end of rwy until it contacted an… - [NTSB LAX84LA307](https://openairdocs.org/ntsb/LAX84LA307.md): De Havilland DHC 6-300 · Tau, Manu'A, HI · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N28SP · Substantial damage > According to the pilot, upon arrival in the vicinity of the arpt it was determined that the windsock indicated southeasterly winds at 15 to 20 KTS. This, plus light to moderate turbulence encountered in the traffic pattern led the crew to fly a slightly… - [NTSB LAX84LA290](https://openairdocs.org/ntsb/LAX84LA290.md): Piper PA-22-150 · Phoenix, AZ · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N3634P · Substantial damage > The plt had just purchased the acft & had flown it only 3 hrs. The purpose of this flt was to ferry it to deer valley for a paint job. He reported that when he landed, the wind was from 150 deg at 6 gusting 12 KTS. During the landing, the nose wheel touched… - [NTSB CHI84LA192](https://openairdocs.org/ntsb/CHI84LA192.md): Beech 23 · Put-In-Bay, OH · Accident · No injuries · Limited investigation · Final report · May 12, 1984 · N4017T · Substantial damage > During the landing roll, about 950 ft down the rwy, the acft hit a dip in the rwy & became airborne again. The plt stated that due to the gusty wind condition, the acft was blown over a grass field on the left side of the rwy. He considered going around, but… - [NTSB ANC84IA066](https://openairdocs.org/ntsb/ANC84IA066.md): British Aerospace BAE-146 · Unalaska, AK · Incident · No injuries · Incident investigation · Final report · May 12, 1984 · N146AP · Minor damage > A 'no brake condition' was experienced while the plt was using the yellow brake sys during a landing. The normal landing procedure calls for using the green sys. During the roll-out, the plt selected the emergency yellow sys & subsequently locked the brakes.… - [NTSB NYC84LA171](https://openairdocs.org/ntsb/NYC84LA171.md): Enstrom F-28A · Spencer, MA · Accident · No injuries · Limited investigation · Final report · May 11, 1984 · N9220 · Substantial damage > According to the plt, the purpose of the flt was to practice autorotations. During practice, the acft touched down hard & was substantially damaged. - [NTSB LAX84LA292](https://openairdocs.org/ntsb/LAX84LA292.md): Cessna 182RG · Palo Alto, CA · Accident · No injuries · Limited investigation · Final report · May 11, 1984 · N2375C · Substantial damage > Acft touched down on the nose gear, porpoised and finally impacted the rwy on the nose gear. - [NTSB ANC84FA063](https://openairdocs.org/ntsb/ANC84FA063.md): Maule M-6-235 · Anchorage, AK · Accident · No injuries · Field investigation · Final report · May 11, 1984 · N235AK · Substantial damage > The acft bounced and the plt gave it full throttle to recover. The acft nose came up, the left wing dropped, and the acft veered off the rwy into two tied down acft. The acft had just had large tires put on to replace wheel skis. The plthad made only 4 wheel… - [NTSB SEA84LA104](https://openairdocs.org/ntsb/SEA84LA104.md): Cessna 182 · Gerlach, NV · Accident · No injuries · Limited investigation · Final report · May 10, 1984 · N5663J · Substantial damage > The acft went off the 1500 ft rwy during a x-wind landing and nosed over. The plt said a gust of wind 'blew the plane too FAR down the runway, applied power, lost altitude, landed off the runway and the plane flipped upside down.' - [NTSB NYC84LA167](https://openairdocs.org/ntsb/NYC84LA167.md): Cessna 150 · Hampton, NH · Accident · No injuries · Limited investigation · Final report · May 10, 1984 · N11953 · Substantial damage > Pilot stated that while landing, the aircraft bounced once possibly two times. On final touch down, the nose landing gear collapsed and the aircraft nosed over onto its back. - [NTSB NYC84LA166](https://openairdocs.org/ntsb/NYC84LA166.md): Cessna C188 · Seneca Falls, NY · Accident · No injuries · Limited investigation · Final report · May 10, 1984 · N8113V · Substantial damage > Pilot attempted to compensate for gusty wnd cond by lnding the acft tail high. The acft began to wx vane and in an effort to correct, the plt used excessive rt brake. The braking action combined with the gusty wnd exceeded the elevator authority and the acft… - [NTSB LAX84LA287](https://openairdocs.org/ntsb/LAX84LA287.md): Cessna 152 · Hawthorne, CA · Accident · No injuries · Limited investigation · Final report · May 10, 1984 · N67522 · Substantial damage > During the first ground supervised solo flight, the tower controller noticed a tone change in the student pilot's voice while on down wind leg of the traffic pattern. On base leg the student did not extend the second increment of flaps as routinely… - [NTSB DEN84LA146](https://openairdocs.org/ntsb/DEN84LA146.md): Maule M-4-220C · Winner, SD · Accident · No injuries · Limited investigation · Final report · May 10, 1984 · N40352 · Substantial damage > The plt reported that a gust of wind was encountered during the landing roll. The acft swerved to the right & left rudder did not correct the situation. The acft left the rwy & collided with a ditch. The plt said that he examined the tailwheel after the… - [NTSB DEN84LA145](https://openairdocs.org/ntsb/DEN84LA145.md): Cessna T210M · Canon City, CO · Accident · Minor injuries · Limited investigation · Final report · May 10, 1984 · N761UK · Substantial damage > The acft went off the side of the rwy into a ditch during landing. The plt said he was only using 20 degrees of flaps due to the wind and after touching down the acft was blown off the rwy. While in the dirt the plt added power 'to try and get lift to either… - [NTSB ANC84LA064](https://openairdocs.org/ntsb/ANC84LA064.md): Piper PA-18-150 · Gakona, AK · Accident · No injuries · Limited investigation · Final report · May 10, 1984 · N5963Z · Substantial damage > The acft broke the ice on fox lake during landing and nosed over. The plt refused to file an accident report and is not reachable by telephone. No flt plan was filed so departure point is unknown as are the details of the occurrence. - [NTSB ANC84LA061](https://openairdocs.org/ntsb/ANC84LA061.md): Piper PA-18-150 · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · May 10, 1984 · N7569D · Substantial damage > The plt lost directional during landing roll with two pax in the rear seats. He stated that the right brake failed after touchdown. - [NTSB ATL84LA171](https://openairdocs.org/ntsb/ATL84LA171.md): Grumman G-164B · Rosedale, MS · Accident · No injuries · Limited investigation · Final report · May 9, 1984 · N6793K · Substantial damage > The plt was transporting the acft to a newly constructed, private ag strip to begin aerial application. During the landing roll, one of the main landing gear rolled into a soft spot & sank into the ground, then the acft nosed over. - [NTSB ATL84LA166](https://openairdocs.org/ntsb/ATL84LA166.md): Cessna 172N · Buckingham, VA · Accident · No injuries · Limited investigation · Final report · May 9, 1984 · N73787 · Substantial damage > The acft bounced and drifted during the landing flare. The plt added power to go-around and was unable to clear the trees near the rwy. - [NTSB ANC84LA070](https://openairdocs.org/ntsb/ANC84LA070.md): Cessna 152 · Chugiak, AK · Accident · No injuries · Limited investigation · Final report · May 9, 1984 · N93952 · Substantial damage > The student plt was observed to land nose wheel first, bounce to a considerable altitude, nose over and contact the runway on the nose wheel. - [NTSB FTW84LA227](https://openairdocs.org/ntsb/FTW84LA227.md): Piper PA-28-140 · Haskell, TX · Accident · No injuries · Limited investigation · Final report · May 8, 1984 · N6664J · Substantial damage > Plt lost directional control of the acft during the landing roll and acft veered off the rwy striking a dirt bank. The nose gear collapsed upon impact with the bank. The plt reported only 145 hours of flt time in the 18 years she has had had her private… - [NTSB ATL84LA165](https://openairdocs.org/ntsb/ATL84LA165.md): Grumman AA-5B · Smithfield, NC · Accident · No injuries · Limited investigation · Final report · May 8, 1984 · N28239 · Substantial damage > The plt had only 1 hr of night experience & was practicing night landings to maintain currency. During a landing, the acft bounced & the plt added power to recover. As power was applied, the acft went off the left side of the rwy & subsequently collided with… - [NTSB ANC84LA062](https://openairdocs.org/ntsb/ANC84LA062.md): Piper PA-20 · Ester, AK · Accident · No injuries · Limited investigation · Final report · May 8, 1984 · N7763K · Substantial damage > The plt maded an off-arpt landing on a frozen river with an 'overflow.' During the rollout, the acft hit a 12 inch deep pocket of slush & nosed over. - [NTSB SEA84LA112](https://openairdocs.org/ntsb/SEA84LA112.md): Cessna 188B · Shedd, OR · Accident · No injuries · Limited investigation · Final report · May 7, 1984 · N731SW · Substantial damage > While landing on a 1600 ft ag strip, the plt realized he had too much speed. However, there were power lines at the departure end of the strip, so he elected not to attempt a go-around. He intentionally ground looped the acft to avoid a ditch & road at the… - [NTSB NYC84IA164](https://openairdocs.org/ntsb/NYC84IA164.md): Barnes Firefly 7 · Gorham, ME · Incident · Minor injuries · Incident investigation · Final report · May 7, 1984 · N3613D · No damage > During touch and go landings the balloon encountered increased winds. The balloon touched down hard tilting the basket onto its side. A passengers arm became caught between the basket and the ground. - [NTSB NYC84LA160](https://openairdocs.org/ntsb/NYC84LA160.md): Stinson 108-3 · Newburyport, MA · Accident · No injuries · Limited investigation · Final report · May 6, 1984 · N6499M · Substantial damage > While landing on rwy 28, the acft encountered a gust of wind. The plt reported that the wind caught the tail of the acft & caused it to drift. He stated that he continued the landing, but applied the brakes too fast & the acft nosed over. He reported the wind… - [NTSB CHI84LA178](https://openairdocs.org/ntsb/CHI84LA178.md): Piper PA-28-180 · La Porte, IN · Accident · No injuries · Limited investigation · Final report · May 6, 1984 · N7575W · Substantial damage > The pilot stated that he initiated the landing flare 'too late,' and the acft landed hard. There was subst damage to theto the landing gear and left wing. - [NTSB CHI84LA175](https://openairdocs.org/ntsb/CHI84LA175.md): Cessna 152 · Traverse City, MI · Accident · No injuries · Limited investigation · Final report · May 6, 1984 · N94222 · Substantial damage > The student pilot landed with excess airspeed & bounced. The second landing was harder than the first & collapsed the nose wheel. The acft nose over as it slid off the right side of the rwy. Investigation revealed that the tower had advised the plt to hold… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=445 ## 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=444 --- 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.