# 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 429 of 1,075 · 53,704 cases ## Cases, newest first - [NTSB SEA85LA098](https://openairdocs.org/ntsb/SEA85LA098.md): Grumman G-164A · Kendrick, ID · Accident · No injuries · Limited investigation · Final report · Apr 26, 1985 · N5285 · Substantial damage > The plt stated that he had completed a spray application & was making a normal landing when the left main gear failed. Subsequently, the acft veered off the left side of the rwy & nosed over. AD 76-13-10, pertaining to a dye penetrant inspection of the main… - [NTSB ATL85LA149](https://openairdocs.org/ntsb/ATL85LA149.md): Maule M5-235C · Ravenswood, WV · Accident · No injuries · Limited investigation · Final report · Apr 26, 1985 · N29JD · Substantial damage > During ldg roll the std plt lost directional control of the acft & ran off of the side of the rwy while practicing touch & go ldg with CFI.the CFI stated that the std made a normal approach & upon touchdown the acft made a sharp turn to the right and went off… - [NTSB ATL85LA148](https://openairdocs.org/ntsb/ATL85LA148.md): Beech 58 · Hilton Head, SC · Accident · No injuries · Limited investigation · Final report · Apr 25, 1985 · N679BL · Destroyed > The plt stated that the landing gear selector was placed in the down position while on downwind for ldg & upon touchdown the landing gear collapsed. Post crash examination of the landing gear failed to disclose any mechanical failure or malfunction of the… - [NTSB MIA85IA156](https://openairdocs.org/ntsb/MIA85IA156.md): Rockwell AC-500 · Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Apr 24, 1985 · N3836C · Minor damage > On final apch, the acft was advised twice by the tower to go around because his landing gear was not extended, the acft did not respond & landed gear up on rwy 13. Examination of the landing gear system after the occurrence revealed the warning horn was… - [NTSB MIA85LA174](https://openairdocs.org/ntsb/MIA85LA174.md): Cessna 177 · Ocala, FL · Accident · No injuries · Limited investigation · Final report · Apr 22, 1985 · N2370Y · Substantial damage > The plt stated that during the landing flare, he stalled the acft & landed hard. - [NTSB FTW85LA192](https://openairdocs.org/ntsb/FTW85LA192.md): Cessna 150 · Abilene, TX · Accident · No injuries · Limited investigation · Final report · Apr 22, 1985 · N7930G · Substantial damage > The plt had little recent tail wheel experience. The accident occurred while landing in a x-wind that exceeded either or both the acft's and plt's capabilities. The acft ground looped. The left wheel dropped into mud beside the rwy and separated. The main… - [NTSB ANC85LA068](https://openairdocs.org/ntsb/ANC85LA068.md): Cessna A152AEROBAT · Whittier, AK · Accident · No injuries · Limited investigation · Final report · Apr 22, 1985 · N761UC · Substantial damage > The pilot in command failed to perform an adequate reconnaisance of the airport prior to landing and did not avail himself of all information concerning the runway conditions. - [NTSB LAX85LA212](https://openairdocs.org/ntsb/LAX85LA212.md): Cessna 172P · Boron, CA · Accident · Minor injuries · Limited investigation · Final report · Apr 21, 1985 · N55448 · Substantial damage > While on a cross country business flt, the plt said he became concerned about an indicated low fuel state and decided to make a precautionary landing. Two approaches had to be abandoned due to what the plt described as 'the most difficult x-wind conditions… - [NTSB ANC85LA067](https://openairdocs.org/ntsb/ANC85LA067.md): Cessna 150D · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Apr 21, 1985 · N5947T · Substantial damage > The primary cause of this accident was the airplane striking the soft spot on the runway. Underlying factors were the pilot in command's inability to distinguish the soft runway surface from surrounding runway surfaces, and the unusually warm temperatures for… - [NTSB SEA85LA093](https://openairdocs.org/ntsb/SEA85LA093.md): Lake Buccaneer · Dexter, OR · Accident · No injuries · Limited investigation · Final report · Apr 20, 1985 · N2582P · Substantial damage > The acft bounced during touchdown several times while attending to land on the water. The acft was too close to a dam to make a go-around. The acft then struck the dam head on. - [NTSB MIA85IA152](https://openairdocs.org/ntsb/MIA85IA152.md): Cessna 402C · West Palm Beach, FL · Incident · No injuries · Incident investigation · Final report · Apr 20, 1985 · N6879Y · Minor damage > The nose gear collapsed on touchdown. An exam of the nose gear actuating rod, the only positive down lock, revealed that it had been improperly adjusted. - [NTSB LAX85LA219](https://openairdocs.org/ntsb/LAX85LA219.md): Piper PA 38-112 · Prescott, AZ · Accident · No injuries · Limited investigation · Final report · Apr 20, 1985 · N2403N · Substantial damage > The acft departed rwy 21. The reported surface winds were 190 degs at 12 KTS gusting to 29 KTS. The acft was climbing at 200 fpm until reaching 800 ft AGL. The plt reported that he considered the climb rate as being too slow and elected to negotiate a… - [NTSB CHI85LA171](https://openairdocs.org/ntsb/CHI85LA171.md): Cessna 150D · Columbus, OH · Accident · No injuries · Limited investigation · Final report · Apr 20, 1985 · N4145U · Substantial damage > During the landing roll the acft traveled off the left side of the rwy where the nose gear collapsed. Skid marks were found on the rwy where the plt attempted remedial action by applying brakes. - [NTSB ATL85FLT05](https://openairdocs.org/ntsb/ATL85FLT05.md): Piper PA-28-180 · Arlington, TN · Accident · Minor injuries · Final report · Apr 20, 1985 · N7406W · Substantial damage > The acft overran the rwy during landing and contacted a ditch. A left quartering tailwind was present at the time of the landing. - [NTSB FTW85LQG01](https://openairdocs.org/ntsb/FTW85LQG01.md): Cessna 421B · Amarillo, TX · Accident · No injuries · Final report · Apr 19, 1985 · N3380Q · Substantial damage > The acft ground looped following a collapse of the left main gear after a landing roll of aprx 600 to 700 ft. post accident inspection of the gear revealed a bolt had backed out of the gear down lock arm where it locks overcenter. - [NTSB FTW85LA190](https://openairdocs.org/ntsb/FTW85LA190.md): Maule M-5-180C · Junction, TX · Accident · No injuries · Limited investigation · Final report · Apr 19, 1985 · N5655N · Substantial damage > After normal apch and landing the acft began vibrating when the tailwheel touched down. The acft became uncontrollable as the airspeed decreased below 30 KTS. Resulting in a ground loop and dragging of a wing tip. Investigation revealed that the tailwheel… - [NTSB ANC85FA065](https://openairdocs.org/ntsb/ANC85FA065.md): Bell BH-206-B · Valdez, AK · Accident · No injuries · Field investigation · Final report · Apr 19, 1985 · N385EH · Substantial damage > The pilot in command stated that he was on final approach and at 125 feet AGL, he heard the low RPM audio warning and he immediately entered an autorotation by lowering the collective to the full down position and closing the throttle to the flight idle… - [NTSB NYC85LA108](https://openairdocs.org/ntsb/NYC85LA108.md): Piper PA-23-250 · Clarion, PA · Accident · No injuries · Limited investigation · Final report · Apr 18, 1985 · N506AC · Substantial damage > The purpose of the flight was to position the aircraft at pittsburgh, PA. During the takeoff roll at buffalo, two to three short power surges in the no. 1 engine were experienced but the pilot decided not to abort and continued to destination. The aircraft… - [NTSB CHI85LA167](https://openairdocs.org/ntsb/CHI85LA167.md): Cessna 150M · Hutchinson, MN · Accident · No injuries · Limited investigation · Final report · Apr 18, 1985 · N66479 · Substantial damage > The student plt was on his 2nd solo flt after being endorsed for flt in the Cessna 150 acft. During a landing, he lost directional control in winds that he reported were from 080 degs at 7 KTS. The acft went off the right side of the rwy & went in a ditch… - [NTSB ATL85LA139](https://openairdocs.org/ntsb/ATL85LA139.md): Bellanca 8GCBC · Elizabethton, TN · Accident · No injuries · Limited investigation · Final report · Apr 18, 1985 · N86756 · Substantial damage > Pilot lost directional control during landing and skidded of the left side of runway. Pilot reported windshift. - [NTSB LAX85LA209](https://openairdocs.org/ntsb/LAX85LA209.md): Burkhart Grob G103 Twin Astir · Hemet, CA · Accident · No injuries · Limited investigation · Final report · Apr 17, 1985 · N20HS · Substantial damage > The plt attempted to land the glider near the rwy threshold in order to be ready for an immediate relaunch. He reported that he was aware of vegetation, located along the edge of the rwy, but said that he misjudged its height. The right wing contacted the… - [NTSB FTW85LA187](https://openairdocs.org/ntsb/FTW85LA187.md): Cessna 180H · Midland, TX · Accident · No injuries · Limited investigation · Final report · Apr 17, 1985 · N9054M · Substantial damage > The 108 hour pvt plt had been checked out in the taildragger on the day preceding the accident. Returning from a local flt, the plt reported, he lost control during the landing when he encountered a gusting x-wind. The wheel ass'y failed in the subsequent… - [NTSB LAX85LA207](https://openairdocs.org/ntsb/LAX85LA207.md): Cessna 177 · Chinle, AZ · Accident · No injuries · Limited investigation · Final report · Apr 16, 1985 · N1217M · Substantial damage > The aircraft landed on runway 17. The winds were form 220 degrees gusting to 30-35 knot. The pilot stated that, as he came by a quonset hangar, the aircraft was struck by a gust of wind from the right front quarter. The aircraft weather-vaned into the wind… - [NTSB DEN85LA116](https://openairdocs.org/ntsb/DEN85LA116.md): Beech 58TC · Gallup, NM · Accident · No injuries · Limited investigation · Final report · Apr 16, 1985 · N123BC · Substantial damage > The pilot stated that he inadvertently raised the landing gear during the landing roll. - [NTSB BFO85IA036](https://openairdocs.org/ntsb/BFO85IA036.md): Boeing 727-200 · Washington, DC · Incident · No injuries · Incident investigation · Final report · Apr 16, 1985 · N400DL · Minor damage > While on final for runway 36 at Washington national airport, Washington, d.c., the pilot was given a change of lndg rwys because of traffic on rwy 36. Drng the ensuing realignment the cpt took the ctls and lndg the acft, scraping the right wing on the runway.… - [NTSB FTW85LA183](https://openairdocs.org/ntsb/FTW85LA183.md): Mitsubishi MU2J · Patterson, LA · Accident · No injuries · Limited investigation · Final report · Apr 15, 1985 · N808W · Substantial damage > On visual final apch to the arpt at night the acft entered ground fog. Reflection of the landing lights in the fog was distracting. The acft landed in the adjacent seaplane landing area instead of on the hard surface rwy. A subsequent inspection of the aprt… - [NTSB LAX85LA205](https://openairdocs.org/ntsb/LAX85LA205.md): Cessna 150M · Concord, CA · Accident · No injuries · Limited investigation · Final report · Apr 14, 1985 · N8304U · Substantial damage > The student was practicing touch & go takeoffs and landings. On the fifth approach to a landing the student plt reported that the acft was a little high and he applied full flaps. The acft bounced on initial touch down. While attempting to recover from the… - [NTSB SEA85LA091](https://openairdocs.org/ntsb/SEA85LA091.md): Cessna 185 · Paulina, OR · Accident · No injuries · Limited investigation · Final report · Apr 13, 1985 · N4892E · Substantial damage > The plt reported that on 4/11/85, the left tire blew out during a landing at omak, WA, damaging the left wheel & braking sys. He said that repairs had been made, but the left brake felt spongy. The next flt (on 4/12/85) was to a private airstrip at Paulina,… - [NTSB NYC85LA105](https://openairdocs.org/ntsb/NYC85LA105.md): Swearingen SA-226TC · Utica, NY · Accident · No injuries · Limited investigation · Final report · Apr 13, 1985 · N101UR · Substantial damage > The accident occurred during a training flt for empire airlines. A left eng failure was simulated past the faf when aprx 300 ft above mda. The student completed the emerg checklist which included retracting the landing gear. The flt then continued visually to… - [NTSB CHI85LA162](https://openairdocs.org/ntsb/CHI85LA162.md): Cessna R182 · Chicago, IL · Accident · No injuries · Limited investigation · Final report · Apr 13, 1985 · N2299T · Substantial damage > While in the landing flare, the acft apparently touched down on the nose gear & began to porpoise. During the subsequent bounces, the nose gear collapsed & the acft nosed over as it departed the side of the rwy. The plt stated that he felt that a gust of wind… - [NTSB LAX85FA199](https://openairdocs.org/ntsb/LAX85FA199.md): Hiller UH12J3 · Klamath, CA · Accident · Serious injuries · Field investigation · Final report · Apr 12, 1985 · N545HA · Destroyed > The helicopter was returning to a private landing pad after a reconaisance flight prior to sprating. At about 10FT AGL after flaring and leveling the pilot could not control a drift and roll to the left. The rotor blades struck the ground within about one… - [NTSB ATL85LA133](https://openairdocs.org/ntsb/ATL85LA133.md): Cessna 195 · Lexington, KY · Accident · No injuries · Limited investigation · Final report · Apr 12, 1985 · N4408C · Substantial damage > During ldg roll-out the plt applied brake press in order to turn onto the taxiway & the rt brake grabbed causing the acft to ground loop. The left landing gear spring strut separated from the fuselage attachment point. - [NTSB ATL85LA131](https://openairdocs.org/ntsb/ATL85LA131.md): Mooney M20E · Gunthersville, AL · Accident · No injuries · Limited investigation · Final report · Apr 10, 1985 · N7153U · Substantial damage > The plt reported that he failed to extend the landing gear in the traffic pattern. Subsequently, the acft was damaged during a gear up landing. - [NTSB CHI85LA159](https://openairdocs.org/ntsb/CHI85LA159.md): Cessna 310B · Shelbyville, IN · Accident · No injuries · Limited investigation · Final report · Apr 8, 1985 · N5471A · Substantial damage > When the gear was extended during the apch, a down & locked indication was not obtained. The plt made several attempts to lock the gear down, using both the electrical & manual systems, but was unable. After touchdown, the right main gear collapsed. The acft… - [NTSB SEA85FA084](https://openairdocs.org/ntsb/SEA85FA084.md): Bellanca 17-31A · Yamhill, OR · Accident · 2 fatal · Field investigation · Final report · Apr 7, 1985 · N9705E · Destroyed > Witnesses observed the acft apch the airstrip with excessive speed. Touchdown on the rwy was beyond the halfway point & the acft bounced back into the air. Power was applied for an apparent go-around. The acft cleared tall trees at the end of the runway, but… - [NTSB MIA85FA143](https://openairdocs.org/ntsb/MIA85FA143.md): Balloon Works Firefly 7B · Orlando, FL · Accident · 1 fatal · Field investigation · Final report · Apr 7, 1985 · N36938 · Destroyed > The Balloon was destroyed by an explosion and subsequent fire during touchdown in an open fld. The plt and witnesses stated the gondola touched down with a 'jolt' and tilted in the direction of travel. Shortly thereafter, a popping noise was heard followed by… - [NTSB DEN85FA113](https://openairdocs.org/ntsb/DEN85FA113.md): Swearingen SA-227-AC · Williston, ND · Accident · No injuries · Field investigation · Final report · Apr 7, 1985 · N3005J · Substantial damage > The flt crew stated after the accident that the flt was uneventful from rap to ins. The first officer was flying the acft when the accident occurred. According to the flt crew all checklist items had been performed prior to the landing. The acft made gnd… - [NTSB SEA85LA089](https://openairdocs.org/ntsb/SEA85LA089.md): Raven R-7 · Mt. Vernon, WA · Accident · Serious injuries · Limited investigation · Final report · Apr 6, 1985 · N41964 · No damage > The plt discovered after a hard landing that his leg was broken. This was the students second solo in hot air balloons. - [NTSB LAX85LA237](https://openairdocs.org/ntsb/LAX85LA237.md): Cessna 195 · Tucson, AZ · Accident · No injuries · Limited investigation · Final report · Apr 6, 1985 · N4331N · Substantial damage > The student lost control & ground looped the acft during rollout from the fifth landing while practicing for his bfr. The CFI reported that the accident might have been prevented had he been more attentive and/or provided better supervision. - [NTSB LAX85LA195](https://openairdocs.org/ntsb/LAX85LA195.md): Cessna 210A · Quartzsite, AZ · Accident · No injuries · Limited investigation · Final report · Apr 6, 1985 · N66MG · Substantial damage > The owner of the airstrip reported that he observed the acft touchdown with its left wheel 2 to 3 ft left of the improved portion of the rwy. Thereafter the acft rolled aprx parallel to the rwy until its left wing hit the top of a 10 ft tree beside the rwy.… - [NTSB DEN85LA115](https://openairdocs.org/ntsb/DEN85LA115.md): Cessna 150M · Beulah, ND · Accident · No injuries · Limited investigation · Final report · Apr 6, 1985 · N66387 · Substantial damage > The pilot reported that he encountered turbulence and gusty winds on landing approach to runway 28. He said his speed was fast to compensate for these conditions but that he did not use a crosswind landing technique because the winds had calmed down. The… - [NTSB SEA85LA083](https://openairdocs.org/ntsb/SEA85LA083.md): Bellanca 8GCBC · Burns, OR · Accident · No injuries · Limited investigation · Final report · Apr 5, 1985 · N5051U · Substantial damage > The acft veered left and the plt overcorrected with right rudder and a ground loop then occurred. The plt said the brakes needed to be worked on prior to the accident. He said that they were not as effective as they should have been & that he was aware of the… - [NTSB LAX85LVM02](https://openairdocs.org/ntsb/LAX85LVM02.md): Cessna 152 · San Jose, CA · Accident · No injuries · Final report · Apr 5, 1985 · N6273Q · Substantial damage > The plt stated, 'on third approach, which followed 2 go-arounds; landing was made and gusty winds forced aircraft off north side of runway and into drainage ditch where aircraft struck brush & came to rest.' - [NTSB LAX85FUD01](https://openairdocs.org/ntsb/LAX85FUD01.md): Cessna 152 · Compton, CA · Accident · No injuries · Final report · Apr 5, 1985 · N6332M · Destroyed > The acft floated half way down the rwy at about 10 ft AGL during a no flap landing. At mid point of the rwy the student plt lowered full flaps and the acft began a series of bouncing touchdowns as it began to run out of rwy. At the overrun end of the rwy the… - [NTSB BFO85LA033](https://openairdocs.org/ntsb/BFO85LA033.md): Mooney M20E · Mitchellville, MD · Accident · No injuries · Limited investigation · Final report · Apr 5, 1985 · N2761W · Substantial damage > After experiencing a gusty crosswind on final approach to runway 18, the pilot employed standard crosswind landing technique. Once over the threshold, power was reduced to idle and the pilot commenced the flare. During the flare, a gust of wind blew the alft… - [NTSB SEA85LA106](https://openairdocs.org/ntsb/SEA85LA106.md): Piper PA-18 · Excursion Inlet, AK · Accident · No injuries · Limited investigation · Final report · Apr 4, 1985 · N27036 · Substantial damage > The plt elected to land on an airstrip in a narrow valley with mountains on either side. While landing in variable & gusty wind conditions, he lost directional control of the acft. The acft then veered off the right side of the rwy onto rough terrain where… - [NTSB FTW85LA174](https://openairdocs.org/ntsb/FTW85LA174.md): Cessna T337G · Big Spring, TX · Accident · No injuries · Limited investigation · Final report · Apr 4, 1985 · N189 · Substantial damage > Acft landed gear up. Plt stated he simply forgot to lower the landing gear. - [NTSB DEN85LA111](https://openairdocs.org/ntsb/DEN85LA111.md): Cessna 152 · West Jordan, UT · Accident · No injuries · Limited investigation · Final report · Apr 4, 1985 · N66952 · Substantial damage > The student plt was on his 1st solo flt. His instructor plt reported that the student made a high & fast apch. The acft touched down on its main gear, bounced, then came down on the nose gear which collapsed. After the nose gear collapsed, the acft skidded… - [NTSB ATL85LA129](https://openairdocs.org/ntsb/ATL85LA129.md): Piper PA-34-200 · Concord, NC · Accident · No injuries · Limited investigation · Final report · Apr 4, 1985 · N1071U · Substantial damage > The plt reported that the pvt arpt at the destination had a unidirectional strip with hi obstructions on both ends. Obstacles, rwy slope & noise abatement considerations required that rwy 4 be used for landings. At 1351 EST, the wind at charlotte, NC was from… - [NTSB FTW85LA173](https://openairdocs.org/ntsb/FTW85LA173.md): Piper PA-24-250 · Justin, TX · Accident · No injuries · Limited investigation · Final report · Apr 3, 1985 · N7137P · Substantial damage > Misinterpreting the windsock, the pilot landed downwind on a short gravel strip and collided with a tree at the end. Next page: https://openairdocs.org/ntsb-phases/550/cases.md?page=430 ## 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=429 --- 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.