# 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 402 of 1,075 · 53,703 cases ## Cases, newest first - [NTSB NYC87LA110](https://openairdocs.org/ntsb/NYC87LA110.md): Piper PA-28 · Bridgeport, NJ · Accident · No injuries · Limited investigation · Final report · Apr 2, 1987 · N75336 · Substantial damage > The pilot was making a night landing to Bridgeport airport when he lost directional control of the aircraft and it veered to the left. The airplane continued to roll off the end of the runway and collided with trees. - [NTSB MKC87LA074](https://openairdocs.org/ntsb/MKC87LA074.md): Cessna A185F · Topeka, KS · Accident · No injuries · Limited investigation · Final report · Apr 2, 1987 · N1467F · Substantial damage > The tower stated the aircraft made a hard bounce and when it touched down again, the right gear collapsed. The airplane landed on runway 3 with winds from 350 degrees at 17 knots, gusts to 32 knots. Runway 3 was the best runway to use at the time. - [NTSB MIA87LA130](https://openairdocs.org/ntsb/MIA87LA130.md): Cessna 310D · Miami, FL · Accident · No injuries · Limited investigation · Final report · Apr 2, 1987 · N6880T · Substantial damage > The plt stalled the acft prior to touchdown resulting in a hard landing. According to FAA personnel at Oklahoma city, the plt holds a private plt certificate with a single eng land rating and was not rated in the Cessna 310D aircraft. - [NTSB MKC87LA073](https://openairdocs.org/ntsb/MKC87LA073.md): Cessna 172 · Halstead, KS · Accident · Minor injuries · Limited investigation · Final report · Apr 1, 1987 · N733PX · Substantial damage > The PIC rptd lndg long on a 2600 ft sod rwy. During the lndg roll, the PIC rptd encountering a tailwind. The closest fss at wichita, 20 mi fm the accident arpt, rptd no significant wind chg during this period, the PIC, knowing that he had landed long and… - [NTSB MIA87LA122](https://openairdocs.org/ntsb/MIA87LA122.md): Cessna 152 · Orlando, FL · Accident · No injuries · Limited investigation · Final report · Apr 1, 1987 · N95904 · Substantial damage > The nose gear collapsed following a hard landing due to the student plts failure to adequately flare the acft. - [NTSB FTW87LA089](https://openairdocs.org/ntsb/FTW87LA089.md): Piper PA-32RT-300 · Laverne, OK · Accident · No injuries · Limited investigation · Final report · Apr 1, 1987 · N31681 · Substantial damage > During a downwind landing, the aircraft ran off the end of the runway contacting a barbed wire fence and subsequently a muddy field, substantially damaging the aircraft by shearing the landing gear off and tearing the wings on the top and bottom surfaces. - [NTSB DEN87LA078](https://openairdocs.org/ntsb/DEN87LA078.md): Ercoupe 415C · Englewood, CO · Accident · No injuries · Limited investigation · Final report · Apr 1, 1987 · N114PA · Substantial damage > The student plt said the acft ballooned during the flare and he applied forward stick. The acft touched down nose wheel first and the nose gear collapsed. The acft then settled hard on main gear resulting in additional damage. - [NTSB LAX87LA164](https://openairdocs.org/ntsb/LAX87LA164.md): Beech S35 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Mar 31, 1987 · N13W · Substantial damage > The aircraft door came open during the initial climb after takeoff because it was not properly closed and locked. The pilot raised the landing gear. Thereafter, because of slow acceleration, he elected to land on the remaining runway. He moved the landing… - [NTSB LAX87LA162](https://openairdocs.org/ntsb/LAX87LA162.md): Cessna 172P · Santa Paula, CA · Accident · Minor injuries · Limited investigation · Final report · Mar 30, 1987 · N6339K · Substantial damage > At the end of a pleasure cross country flt the plt prior to entering the pattern noted the wind direction and speed as 060 degs at aprx 16 KTS. The plt then entered the pattern for rwy 4. On final apch the plt had to slip the acft to keep alligned with the… - [NTSB LAX87LA159](https://openairdocs.org/ntsb/LAX87LA159.md): Jones Pitts Special S1A · Franklin, CA · Accident · No injuries · Limited investigation · Final report · Mar 29, 1987 · N9GD · Substantial damage > During the landing roll, the pilot was unable to maintain directional control when a gust of wind from the right pushed the aircraft off the left side of the runway. The aircraft collided with the terrain and nosed over. There was no mechanical failure or… - [NTSB SEA87LA070](https://openairdocs.org/ntsb/SEA87LA070.md): Piper PA-28-140 · Newberg, OR · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N4298T · Substantial damage > Seated at the controls in the left front seat was a plt who had not flown in ten years. Seated in the right front seat was the owner/student plt. The purpose of the flt according to the plt, was to familiarize the plt with the acft so that the plt could… - [NTSB MKC87LA068](https://openairdocs.org/ntsb/MKC87LA068.md): Cessna 150F · Fremont, MO · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N6978F · Substantial damage > The student pilot got off course on the first leg of his solo cross-country flight. He landed at an airport for fuel and directions, but the airport was deserted. When he departed for a nearby airport, he could not find that airport. After the student pilot… - [NTSB MIA87LA121](https://openairdocs.org/ntsb/MIA87LA121.md): Cessna 310L · Venice, FL · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N3304X · Substantial damage > The left main landing gear collapsed during the landing roll after the plt inadvertently retracted the landing gear instead of the flaps. The pilot left the scene of the accident and his identity is unknown. - [NTSB LAX87LA166](https://openairdocs.org/ntsb/LAX87LA166.md): Cessna 310 · Agua Dulce, CA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N223H · Substantial damage > The non-multiengine rated pilot attempted to land his multiengine airplane on a 4600 foot runway. The aircraft touched down approximately half way down the runway and slid off the departure end. The aircraft impacted trees after departing the runway. - [NTSB FTW87LA085](https://openairdocs.org/ntsb/FTW87LA085.md): Cessna 150H · Palestine, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 28, 1987 · N22064 · Substantial damage > During flare/touchdown the pilot lost control of the aircraft due to a crosswind. The pilot attempted a go-around but contacted some trees off the right side of the runway causing substantial damage to the wings, tail and landing gear. - [NTSB FTW87LA084](https://openairdocs.org/ntsb/FTW87LA084.md): Piper PA-32-300 · Many, LA · Accident · No injuries · Limited investigation · Final report · Mar 28, 1987 · N2946Y · Substantial damage > Acft received substantial damage when it ran off the end of a 3,300' pvt airstrip into a lake during an attempted go around. The winds were calm. The plt reported that he landed long and fast over trees at the threshold and delayed initiating a go around… - [NTSB DEN87LA076](https://openairdocs.org/ntsb/DEN87LA076.md): Cessna 150M · Cavalier, ND · Accident · Minor injuries · Limited investigation · Final report · Mar 28, 1987 · N2848V · Substantial damage > The pilot was landing with a cross wind. The aircraft bounced and drifted into snow bank along the right edge of the runway. The nose gear was broken off in the collision with the snow bank and the engine was pushed into the firewall. - [NTSB MIA87LA120](https://openairdocs.org/ntsb/MIA87LA120.md): Cessna 210C · Ponch, PR · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N3643Y · Substantial damage > The acft was found abandoned in a sugar beet field with the landing gear collapsed. Information pertaining to the occupant(s), history of flt, and facts pertaining to the accident could not be determined. Injury index presumed. - [NTSB DEN87LA073](https://openairdocs.org/ntsb/DEN87LA073.md): Mooney M20C · Wahpeton, ND · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N6550U · Substantial damage > A CFI and a dual student were making practice landings. On the sixth landing, the student failed to lower the landing gear. The CFI did not notice that the acft did not have landing gear extended. The acft landed with gear fully retracted. - [NTSB ATL87LA097](https://openairdocs.org/ntsb/ATL87LA097.md): Piper PA-32-300 · Toccoa, GA · Accident · No injuries · Limited investigation · Final report · Mar 27, 1987 · N3042U · Substantial damage > The pilot overshot runway 20 and skidded off the departure end which caused substantial damage to the aircraft. The pilot stated that he should have descended to the normal visual traffic pattern altitude before attempting a landing. There were no reported… - [NTSB DEN87LA072](https://openairdocs.org/ntsb/DEN87LA072.md): Bellanca 17-30A · Greeley, CO · Accident · No injuries · Limited investigation · Final report · Mar 26, 1987 · N8793V · Substantial damage > During landing roll, after a normal pattern, an unusual noise was heard by the pilot. He described it as a 'thud' or a loud 'pop' noise. The pilot lost directional control and departed the runway to the left. The landing gear was severely damaged. No prempact… - [NTSB ATL87LA096](https://openairdocs.org/ntsb/ATL87LA096.md): Cessna 152 · Owensboro, KY · Accident · No injuries · Limited investigation · Final report · Mar 26, 1987 · N757LM · Substantial damage > During a solo practice flight, the 16 hour student pilot touched down on rwy 23 at 70 KIAS and allowed the aircraft to bounce out of control and land hard on the nose landing gear. After the third bounce, the nose gear collapsed and the acft skidded to a… - [NTSB MKC87LA065](https://openairdocs.org/ntsb/MKC87LA065.md): Beech BE-58 · Houston, MO · Accident · No injuries · Limited investigation · Final report · Mar 24, 1987 · N38077 · Substantial damage > The airplane was on an IFR flight plan and five miles from the airport, the airplane broke out of the clouds and proceeded VFR to the airport. It was a dark night and light rain was falling. The pilot stated he flew over the airport twice looking for a wind… - [NTSB BFO87DID02](https://openairdocs.org/ntsb/BFO87DID02.md): Eagle Balloons C-7 · Montvale, VA · Accident · Serious injuries · Final report · Mar 22, 1987 · N60765 · Minor damage > The balloon plt selected a downsloping field with powerlines at the apch end and woods at the upwind end in which to land. On touchdown, the basket tipped over and the plt was pulled from the basket by his grip on the crown valve line. The balloon began to… - [NTSB ATL87LA091](https://openairdocs.org/ntsb/ATL87LA091.md): Champion 7FC · Bellefontaine, OH · Accident · No injuries · Limited investigation · Final report · Mar 22, 1987 · N90398 · Substantial damage > The acft was landed on rwy 04 with the wind from the east at eight KTS. The flight was the first solo in a tail wheel equipped acft for the plt. He had obtained no formal instruction in a tail wheel acft but had flown with a friend. On landing the acft… - [NTSB NYC87LA112](https://openairdocs.org/ntsb/NYC87LA112.md): Piper PA-34-200T · Rutland, VT · Accident · No injuries · Limited investigation · Final report · Mar 21, 1987 · N2083K · Destroyed > Drg arrival, the plt was cleared for an lda/ndb apch to rwy 19. When she 'went visual' on the apch, a check of the VASI showed she was hi, so she slipped the acft to lose alt. The winds were rprtd as light & variable, but plt rprtd that drgthe lndg, there was… - [NTSB NYC87LA111](https://openairdocs.org/ntsb/NYC87LA111.md): Cessna 152 · Du Bois, PA · Accident · No injuries · Limited investigation · Final report · Mar 21, 1987 · N67911 · Substantial damage > The student plt initiated a touch-&-go landing on rwy 7 with a left, quartering headwind. He rprtd that when the acft was at about 10 ft AGL with the left wing 'dipped' into the wind, the left wing & nose dropped & the plane impacted the rwy. The acft then… - [NTSB FTW87GA083](https://openairdocs.org/ntsb/FTW87GA083.md): Bell 47G-3B-1 · Odessa, TX · Accident · No injuries · Final report · Mar 21, 1987 · N62462 · Substantial damage > Investigation reveals the helicopter touched down on the heel of its skids, left skid first, and at a slightly low rotor RPM. The tail boom then moved upward while the main rotor blades flexed downward. The main rotor blades contacted and severed the tail… - [NTSB ATL87LA092](https://openairdocs.org/ntsb/ATL87LA092.md): Mooney M20 · Frankfort, KY · Accident · No injuries · Limited investigation · Final report · Mar 20, 1987 · N5251B · Destroyed > During the final phase of the approach procedure, the pilot failed to extend the landing gear. The aircraft touched down, skidded along the runway surface until it finally came to rest. The pilot reported that the fuel strainer failed and a fire started and… - [NTSB SEA87LA065](https://openairdocs.org/ntsb/SEA87LA065.md): Cessna 150 · Las Vegas, NV · Accident · No injuries · Limited investigation · Final report · Mar 18, 1987 · N457AF · Substantial damage > During landing a gust of wind occurred from the right. The student pilot was not able to correct for the wind and lost control of the aircraft. The aircraft veered to the left of the runway onto rough terrain and then nosed over inverted. - [NTSB MIA87LA112](https://openairdocs.org/ntsb/MIA87LA112.md): Cessna 182C · Branford, FL · Accident · No injuries · Limited investigation · Final report · Mar 18, 1987 · N8698T · Substantial damage > The plt was unable to locate his postion, & with wx conditions deteriorating & darkness approaching, elected to land in a field. Upon touchdown, the nose gear broke off, the acft nosed over & came to rest inverted. - [NTSB SEA87FA064](https://openairdocs.org/ntsb/SEA87FA064.md): Cessna 402A · Walla Walla, WA · Accident · No injuries · Field investigation · Final report · Mar 17, 1987 · N4549Q · Substantial damage > During lndg roll the rt main lndg gear of the Cessna 402A collapsed. Visual inspection of the bell crank assembly revealed fracture surfaces similar to those of instantaneous overload. - [NTSB CHI87LA098](https://openairdocs.org/ntsb/CHI87LA098.md): Hughes 269B · South Bend, IN · Accident · No injuries · Limited investigation · Final report · Mar 17, 1987 · N9522F · Substantial damage > According to the plt, after departure from aurora municipal airport, he landed at an airfield west of elgin, Illinois and picked up the two passengers. The plt stated that he then departed for elkhart, Indiana. According to an Indiana state police aircraft… - [NTSB ANC87LA052](https://openairdocs.org/ntsb/ANC87LA052.md): Piper PA-22-20 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · Mar 17, 1987 · N3008Z · Substantial damage > The student pilot lost control of the acft which ground looped during a stop and go landing roll. Inspection revealed the right brake master cylinder actuator rod failed. - [NTSB MIA87LA111](https://openairdocs.org/ntsb/MIA87LA111.md): Cessna 152 · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Mar 16, 1987 · N218JA · Substantial damage > The plt stated that upon landing on runway 22, as he added power to takeoff again the acft started to veer to the left and no matter how much right rudder he used, the acft still veered left and went off the side of the runway into the grass, spun around and… - [NTSB CHI87LA096](https://openairdocs.org/ntsb/CHI87LA096.md): Cessna 172E · Muncie, IN · Accident · No injuries · Limited investigation · Final report · Mar 16, 1987 · N7757U · Substantial damage > According to the plt, he contacted the mie tower about 20 miles north of Muncie, Indiana and received a weather briefing with a choice of rwy 14 or 02. The plt stated that the winds were reported as 12 knots from 080, and he chose to land on rwy 14. According… - [NTSB MIA87LA110](https://openairdocs.org/ntsb/MIA87LA110.md): Cessna 170A · Brandon, FL · Accident · No injuries · Limited investigation · Final report · Mar 15, 1987 · N1352D · Substantial damage > Upon touchdown the right landing gear separated from the acft due to a hard landing. - [NTSB MIA87LA109](https://openairdocs.org/ntsb/MIA87LA109.md): Beech A23 · Palatka, FL · Accident · No injuries · Limited investigation · Final report · Mar 15, 1987 · N8883M · Substantial damage > The pilot stated that he 'had to make downwind landing due to traffic & direction from UNICOM operator. Landing was fast due to downwind, but not hard. Nose wheel collapsed during rollout with stall warning blowing. Plane gently nosed over & stopped at the… - [NTSB MIA87LA108](https://openairdocs.org/ntsb/MIA87LA108.md): Let L-13 · Brooksville, FL · Accident · No injuries · Limited investigation · Final report · Mar 14, 1987 · N68PE · Substantial damage > On final apch, with full flaps extended, the glider began to float down the rwy. The plt then retracted them, after which, it descended, collided with a fence, & came to rest in a field. - [NTSB LAX87LA144](https://openairdocs.org/ntsb/LAX87LA144.md): Cessna 414A · Chinle, AZ · Accident · Minor injuries · Limited investigation · Final report · Mar 14, 1987 · N26864 · Substantial damage > The plt rprtd the rwy lights on one side of the rwy were inop & that he made an apch to the wrong side of the lights. When he realized the acft was not aligned with the rwy, he initiated a go-around. However, as he started to go-around, the acft hit a fence… - [NTSB FTW87LA076](https://openairdocs.org/ntsb/FTW87LA076.md): Cessna 172P · Roanoke, TX · Accident · No injuries · Limited investigation · Final report · Mar 13, 1987 · N64943 · Substantial damage > Aircraft ballooned twice after touchdown followed by hard landing on nosegear resulting in substantial damage. - [NTSB BFO87LA030](https://openairdocs.org/ntsb/BFO87LA030.md): North American SNJ-5 · Norfolk, VA · Accident · No injuries · Limited investigation · Final report · Mar 13, 1987 · N8218E · Substantial damage > The tower cleared the aircraft to land on runway 35 at Norfolk international airport with winds from 010 degrees at 20 to 25 knots. The pilot stated that all other traffic was using runway 05. During landing roll the aircraft started to drift to the right,… - [NTSB ATL87LA085](https://openairdocs.org/ntsb/ATL87LA085.md): Cessna 152 · Bolivar, TN · Accident · No injuries · Limited investigation · Final report · Mar 13, 1987 · N25503 · Substantial damage > The student plt reported that he flared excessively during touchdown while practicing a touch & go landing, causing the airplane to balloon. The airplane subsequently touched down again and headed toward the left side of the rwy. The student plt stated that… - [NTSB MIA87LA106](https://openairdocs.org/ntsb/MIA87LA106.md): Hughes 364HS · Opa Locka, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 12, 1987 · N4507C · Substantial damage > The pilot of the helicopter was executing a normal approach to the ground when as he neared the ground the ventral fin struck the ground. The tail rotor driveshaft re-centered and the pilot thought the accompanying shudder was a tail rotor failure, and landed… - [NTSB CHI87LA095](https://openairdocs.org/ntsb/CHI87LA095.md): Beech C24R · Manitowoc, WI · Accident · No injuries · Limited investigation · Final report · Mar 12, 1987 · N1824P · Substantial damage > Pilot flared too high on landing. Aircraft landed hard and nose wheel broke off. - [NTSB ANC87LA048](https://openairdocs.org/ntsb/ANC87LA048.md): Cessna 180 · Cordova, AK · Accident · No injuries · Limited investigation · Final report · Mar 12, 1987 · N61537 · Substantial damage > The pilot stated that after touchdown and about 150 feet of the roll, the pilot lost directional control causing the aircraft to exit the gravel runway and striking two parked aircraft. - [NTSB ANC87LA047](https://openairdocs.org/ntsb/ANC87LA047.md): Cessna 150D · Anchorage, AK · Accident · No injuries · Limited investigation · Final report · Mar 12, 1987 · N5972T · Substantial damage > The pilot-in-command was a certificated flight instructor with prior experience in tail wheel airplanes, but had not flown a Cessna 150 tail wheel conversion and wished to familarize himself with the airplane by a series of touch and go landings. The pilot… - [NTSB MIA87LA105](https://openairdocs.org/ntsb/MIA87LA105.md): Cessna A152 · Cocoa, FL · Accident · No injuries · Limited investigation · Final report · Mar 11, 1987 · N4649A · Substantial damage > The plt stated that after touchdown the acft was blown off the left side of the rwy, after which, it collided with trees & came to rest. According to the plt's operating handbook the max demonstrated crosswind velocity is 12 KTS. At the time of the accident… - [NTSB NYC87LA104](https://openairdocs.org/ntsb/NYC87LA104.md): Swearingen SA-226AT · Jamaica, NY · Accident · No injuries · Limited investigation · Final report · Mar 10, 1987 · CGJWW · Substantial damage > The flight landed at kennedy international airport with the landing gears retracted due to a failure of the right main landing gear extension system. - [NTSB MKC87LA059](https://openairdocs.org/ntsb/MKC87LA059.md): Cessna 320E · Point Lookout, MO · Accident · Minor injuries · Limited investigation · Final report · Mar 10, 1987 · N712SF · Substantial damage > The student plt landed the acft and allowed it to slow before applying brakes. The student stated, the acft then began veering to the right side of the rwy. Attempts by the student and CFI to correct the situation were ineffective and the acft departed the… Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=403 ## 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=402 --- 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.