# NTSB investigations: Approach 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 169 of 420 · 20,996 cases ## Cases, newest first - [NTSB MKC88FA183](https://openairdocs.org/ntsb/MKC88FA183.md): Beech D55 · N. Little Rock, AR · Accident · 3 fatal · Field investigation · Final report · Oct 1, 1988 · N7826R · Destroyed > The pilot had been executing a vor/dme rwy 35 instrument approach to north Little Rock muni (1M1). The PIC called 'missed approach' a short time aft having been clrd to execute the instrument apprch. Apprch control attmptd to provide instructions to the PIC… - [NTSB NYC88LA251](https://openairdocs.org/ntsb/NYC88LA251.md): Cessna 210 · Kirkwood, NY · Accident · No injuries · Limited investigation · Final report · Sep 30, 1988 · N7457E · Substantial damage > The plt attempted to land at a private airport at night on an unlit rwy. A go-around was initiated and during the go-around the eng lost pwr. A gear up landing was made beyond the rwy. The investigation revealed water in the fuel system. The eng was run up… - [NTSB LAX88FA330](https://openairdocs.org/ntsb/LAX88FA330.md): Bell 206L-1 · Santa Barbara, CA · Accident · No injuries · Field investigation · Final report · Sep 29, 1988 · N2246Q · Substantial damage > Failure of the #1 turbine wheel. Contributing to this accident was the unreported over temperature cycles of the engine. Also contributing was the unsuitability of the landing surface from the presence of the 1/4 inch steel sheeting. - [NTSB FTW88LA166](https://openairdocs.org/ntsb/FTW88LA166.md): Piper PA-28-140 · Fort Worth, TX · Accident · No injuries · Limited investigation · Final report · Sep 29, 1988 · N4683R · Substantial damage > The pvt plt (PIC) was flying with an instructor (CFI), who had an expired medical certificate. The CFI stated he was flying as a safety plt only. The PIC extended his downwind leg & subsequently was low & slow on a long final apch. He raised the nose of the… - [NTSB NYC88DGM02](https://openairdocs.org/ntsb/NYC88DGM02.md): Barker Quickie Q2 · Martinsburg, PA · Accident · Serious injuries · Final report · Sep 28, 1988 · N244GB · Substantial damage > The pilot reported he was practicing takeoffs and landings, and that he was 'determined to hold the approach speed to 80 and rate of descent to 500 feet per minute...' The approach was flown at dusk as light was beginning to fail. The pilot stated, 'I… - [NTSB NYC88LA243](https://openairdocs.org/ntsb/NYC88LA243.md): Piper PA-28-181 · Keene, NH · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 1988 · N8289T · Destroyed > The plt received a head inj and was not able to relate the details of the acdt. The acft crashed into trees about 3 mi short of the landing rwy at the conclusion of a cross country flt. An FAA insp examined the wreckage and reported that the fuel selector was… - [NTSB NYC88DHM02](https://openairdocs.org/ntsb/NYC88DHM02.md): Air Command 532 · Stormville, NY · Accident · Serious injuries · Final report · Sep 26, 1988 · UNREG · Destroyed > The acdnt occurred as the non-certificated plt was operating the non-registered gyroplane in the traffic pattern. Witnesses heard a 'loud crack.' They then observed the gyroplane descending in an apparent unusual attitude. The gyroplane collided with trees,… - [NTSB NYC88LA241](https://openairdocs.org/ntsb/NYC88LA241.md): Cessna 152 · Millbrook, NY · Accident · Minor injuries · Limited investigation · Final report · Sep 25, 1988 · N94228 · Destroyed > The private plt-in-command was seated in the right seat and his commercial plt-pax was seated in the left seat. The plt in command was at the controls. The acft was on final apch. The plt said the wind was from 170 deg. He did not give the wind velocity. He… - [NTSB MKC88LA177](https://openairdocs.org/ntsb/MKC88LA177.md): Aerospatiale TB-20 · Omaha, NE · Accident · No injuries · Limited investigation · Final report · Sep 25, 1988 · N31TB · Substantial damage > The plt rprtd that when the acft was at aprx 150' to 200' AGL on final apch, the eng lost pwr & would not restart. Unable to rch the rwy, he lndd about 50' short on soft trrn, where the gear collapsed & the acft was dmgd. Only about 12 ounces of fuel was… - [NTSB LAX88LA328](https://openairdocs.org/ntsb/LAX88LA328.md): Centrair 101 · Vacaville, CA · Accident · No injuries · Limited investigation · Final report · Sep 25, 1988 · N101LV · Substantial damage > The pilot flew over a field at 700 ft. a.g.l. to see if it was safe for landing. He turned the glider to establish a downwind leg. He then turned to the base leg. While turning onto final approach at a low altitude, the glider pitched up and rolled to the… - [NTSB NYC88LA240](https://openairdocs.org/ntsb/NYC88LA240.md): Cessna 150 · Burlington, CT · Accident · Minor injuries · Limited investigation · Final report · Sep 24, 1988 · N3099X · Substantial damage > The plt was attempting to land at the mountain arpt. Patwas indicated the winds were from the north at 15 KTS. Gusts were not reported. The plt made her apch at 70 mph IAS and with 20 deg of flaps deployed. As she flared the acft, she encountered a gust of… - [NTSB CHI88LA247](https://openairdocs.org/ntsb/CHI88LA247.md): Piper PA-28-181 · Orleans, IN · Accident · No injuries · Limited investigation · Final report · Sep 24, 1988 · N21985 · Substantial damage > The pilot failed to maintain an adequate visual lookout and to maintain adequate clearance from the utility pole and transmission wire. Contributing to the cause were the pilot's total lack of experience, task overload, and anxiety, stemming from a partial… - [NTSB SEA88LA184](https://openairdocs.org/ntsb/SEA88LA184.md): Piper PA-31T-620 · Eugene, OR · Accident · No injuries · Limited investigation · Final report · Sep 23, 1988 · N234K · Substantial damage > Plt had IFR clrnc and was on ILS approach in VMC above thin fog layer at night. Plt had visual contact with runway environment but collided with 10 foot tall ILS middle marker antenna/building 1/2 mile from runway threshold, separating left main lndg gear and… - [NTSB FTW88IA165](https://openairdocs.org/ntsb/FTW88IA165.md): Boeing 727-200 · Dfw Airport, TX · Incident · Minor injuries · Incident investigation · Final report · Sep 22, 1988 · N710AA · Minor damage > Fatigue failure of the left main landing gear door actuator pivot trunnion shaft which subsequently became lodged in the actuator clevis preventing the door unlock mechanism from actuating during gear extension. - [NTSB MIA88LA270](https://openairdocs.org/ntsb/MIA88LA270.md): Cessna 172 · Panacea, FL · Accident · No injuries · Limited investigation · Final report · Sep 21, 1988 · N7048A · Destroyed > The pilot stated that while attempting a go-around he inadvertently selected all flaps up and the aircraft crashed into the trees at the end of the runway. - [NTSB CHI88LA238](https://openairdocs.org/ntsb/CHI88LA238.md): Piper PA-28-151 · Kenosha, WI · Accident · No injuries · Limited investigation · Final report · Sep 18, 1988 · N6252J · Substantial damage > While on a VFR approach to the airport, at night, the pilot misidentified the street lights in a mobile home park as the runway lights and descended into wires. Afterward the pilot was able to continue to the intended runway and made a successful landing.… - [NTSB ANC88LA143](https://openairdocs.org/ntsb/ANC88LA143.md): Maule M-4 · Cordova, AK · Accident · No injuries · Limited investigation · Final report · Sep 18, 1988 · N2044U · Substantial damage > While on base leg to the airport, the engine stopped producing power forcing the pilot to land the airplane on the tundra short of the runway. Upon landing the airplane nosed over. Subsequent examination of the engine showed water in the carburetor. The water… - [NTSB LAX88LA325](https://openairdocs.org/ntsb/LAX88LA325.md): Bell 206L · Lihue, HI · Accident · No injuries · Limited investigation · Final report · Sep 17, 1988 · N278KA · Substantial damage > During a local sightseeing flight, the pilot reported that while on final approach for landing, the audio and light for low RPM sounded and illuminated. The helicopter was autorotated. It initially bounced when it touched down, then landed hard. The engine… - [NTSB ANC88LA142](https://openairdocs.org/ntsb/ANC88LA142.md): Piper PA-12 · Figure 8 Lake, AK · Accident · No injuries · Limited investigation · Final report · Sep 17, 1988 · N64CW · Substantial damage > The pilot-in-command was landing in one foot tall grass near a duck hunting shack and struck a log. He landed the airplane after striking the log and during the landing roll, the main landing gear collapsed. The plt stated that he overflew the lndg area and… - [NTSB ATL88LA250](https://openairdocs.org/ntsb/ATL88LA250.md): Taylorcraft BC12-D · Surf City, NC · Accident · No injuries · Limited investigation · Final report · Sep 13, 1988 · N96522 · Substantial damage > A landing was attempted at a private turf strip in gusty wind conditions. At level off for a 3-point landing on rwy 24, the right wing was lifted sharply by a wind gust. Right aileron and rudder were applied and power was added to go-around. As the airplane… - [NTSB SEA88LA178](https://openairdocs.org/ntsb/SEA88LA178.md): Cessna 172P · Shelton, WA · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 1988 · N54867 · Destroyed > About 10 mins after t/o, the plt noted the engine running rough and elected to return to the point of departure for precautionary lndg. Approach was high and fast, leading to balked lndg. On throttle application, eng quit. Acft collided with trees beyond… - [NTSB FTW88DRG09](https://openairdocs.org/ntsb/FTW88DRG09.md): Schempp-Hirth Standard Cirrus · Briggs, TX · Accident · Serious injuries · Final report · Sep 10, 1988 · N8083 · Substantial damage > Pilot's failure to maintin sufficient airspeed as he maneuvered to re-align the glider during final approach for landing. This resulted in 45-60 degree bank angle at very low altitudes, which culminated in the less of control and collision with the fence. - [NTSB SEA88LA174](https://openairdocs.org/ntsb/SEA88LA174.md): Piper PA-24-400 · Gasquet, CA · Accident · No injuries · Limited investigation · Final report · Sep 9, 1988 · N8541P · Substantial damage > The pilot stated that as he turned final approach, intense sunglare was encountered. The plt executed a go-around 'in the blind,' and collided with trees in approach path. The acft remained flyable and the pilot diverted to medford, Oregon. - [NTSB NYC88FA235](https://openairdocs.org/ntsb/NYC88FA235.md): Cessna 182RG · Greenville, ME · Accident · 3 fatal · Field investigation · Final report · Sep 9, 1988 · N6064C · Destroyed > The non-instrument rated pilot apparently could not locate the destination airport because of low ceilings and ground fog. Before the pilot started his trip he was advised by the fss that VFR flight to his destination was not recommended. It appears that the… - [NTSB LAX88LA313](https://openairdocs.org/ntsb/LAX88LA313.md): Cessna 172K · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Sep 8, 1988 · N79226 · Substantial damage > The pilot stated that he had mistakenly lined up for final approach on taxiway rather than runway 29L as instructed. When he was on short final the control tower informed him of his mistake. While maneuvering to line up on runway 29L, the pilot lost control… - [NTSB LAX88FA314](https://openairdocs.org/ntsb/LAX88FA314.md): Cessna 177RG · San Luis Obispo, CA · Accident · 1 fatal · Field investigation · Final report · Sep 8, 1988 · N33283 · Destroyed > Pilots erroneous interpretation of his missed approach clearance, and, his performance of the published missed approach procedure for the santa maria ILS instead of the San Luis Obispo localizer. - [NTSB MIA88LA266](https://openairdocs.org/ntsb/MIA88LA266.md): Piper PA-24-260 · Punta Gorda, FL · Accident · Serious injuries · Limited investigation · Final report · Sep 6, 1988 · N8670P · Substantial damage > The plt was returning from VFR xc flt during which many climbs, descents & detours were made to avoid adverse wx & maintain VFR. He stated the strong headwinds considerably reduced his grndspeed. At his 1st intended ldg arpt, strong gusty x-winds made the… - [NTSB FTW88FA162](https://openairdocs.org/ntsb/FTW88FA162.md): Cessna 172P · Marietta, OK · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1988 · N99144 · Destroyed > The plt elected to land on rwy 17 with wind from 300 degrees at 6 knots. During the second go-around the airplane's left wing struck a tree at a point 30 feet above the ground and the aircraft ended up inverted in a parking lot. Plt stated he had landed at… - [NTSB DEN88FA199](https://openairdocs.org/ntsb/DEN88FA199.md): Glasflugel H-301 · Salida, CO · Accident · 1 fatal · Field investigation · Final report · Sep 5, 1988 · N71949 · Destroyed > Witnesses said the acft was aprx 200 ft AGL on the downwind leg, but close in to the rwy as it returned to the arpt for landing. Acft entered a 60 deg right bank to base leg. Nose rose slightly and acft rolled inverted. Acft made one-half to three-quarters… - [NTSB CHI88DER13](https://openairdocs.org/ntsb/CHI88DER13.md): Piper PA-22-150 · Cohasset, MN · Accident · No injuries · Final report · Sep 5, 1988 · N7222D · Substantial damage > Failure of the PIC to maintain a proper glide path in order to clear obstructions along the flight path of his final approach. - [NTSB FTW88FA161](https://openairdocs.org/ntsb/FTW88FA161.md): Piper PA-34-220T · Carthage, TX · Accident · 5 fatal · Field investigation · Final report · Sep 4, 1988 · N83874 · Destroyed > Drg a night arrival, the plt rprtd he could make a visual apch. At 2341:37 CDT, the ARTCC controller informed him the destn arpt was straight ahead at 12 mi & requested that he rprt when the arpt was in sight. At 2343:30, he rprtd the rwyin sight & the… - [NTSB SEA88LA168](https://openairdocs.org/ntsb/SEA88LA168.md): Cessna 180B · Dixie, ID · Accident · Serious injuries · Limited investigation · Final report · Sep 3, 1988 · N5085E · Substantial damage > While on final apch to land at the high alt arpt, the plt elected to go around & land at a slower speed. He rprtd that as he neared the rwy on the 2nd apch, the acft enctrd a sudden wind shear, which caused it to drop & bank to the left. Subsequently, the… - [NTSB DEN88LA197](https://openairdocs.org/ntsb/DEN88LA197.md): Piper PA-24-260C · Hamilton, MT · Accident · Serious injuries · Limited investigation · Final report · Sep 2, 1988 · N9436P · Substantial damage > The private plt was descending to the destination arpt at the conclusion of a 3.5 hr x-country flight. The plt said he selected the right main fuel tank and flew until the 'fuel was low to the point of exhaustion.' During a right turn, with the gear extended,… - [NTSB CHI88LA229](https://openairdocs.org/ntsb/CHI88LA229.md): Grumman AA-5B · Schaumburg, IL · Accident · No injuries · Limited investigation · Final report · Sep 2, 1988 · N28774 · Substantial damage > During an attempted night landing at an airport with inoperative pilot-controlled runway lights, the pilot made a series of low passes (approximately 6 passes) before trying to land. The aircraft collided with the top of a tree located slightly to the left of… - [NTSB FTW88DPJ11](https://openairdocs.org/ntsb/FTW88DPJ11.md): Cessna 150F · Oklahoma City, OK · Accident · No injuries · Final report · Aug 31, 1988 · N6474F · Substantial damage > The student pilot had just returned to flying after an extended time. During the approach he failed to add carburetor heat and the engine failed when power was added. Automotive fuel was being used in the aircraft but the STC had not been complied with. - [NTSB BFO88LA080](https://openairdocs.org/ntsb/BFO88LA080.md): Piper PA-28R-200 · Charleston, WV · Accident · No injuries · Limited investigation · Final report · Aug 31, 1988 · N15948 · Substantial damage > The plt was executing the ILS rwy 5 apch when he entered fog about 350 ft above the dh. According to the plt, upon reaching the dh he sighted the rwy and continued the apch. Afterward the plt said he deviated left of the localizer centerline and as he was… - [NTSB ATL88IA242](https://openairdocs.org/ntsb/ATL88IA242.md): Beech 23 · Frankfort, KY · Incident · No injuries · Incident investigation · Final report · Aug 31, 1988 · N2341J · Minor damage > Engine quit during go-around from simulated engine failure. During completion of emergency procedure the fuel selector position was changed to opposite wing fuel tank. Later exam of the acft revealed that when the fuel selector valve handle indicated right… - [NTSB CHI88FA226](https://openairdocs.org/ntsb/CHI88FA226.md): Piper PA-23-160 · Toledo, OH · Accident · Serious injuries · Field investigation · Final report · Aug 30, 1988 · N4049P · Destroyed > Fatigue fracture, for reasons undetermined, which lead to the loss of a propeller blade from the right engine. This in turn lead to the marginal controllability of the aircraft. - [NTSB LAX88DUQ05](https://openairdocs.org/ntsb/LAX88DUQ05.md): Schleicher ASW-20BL · Red Mountain, CA · Accident · Serious injuries · Final report · Aug 29, 1988 · N300Y · Substantial damage - [NTSB FTW88LA157](https://openairdocs.org/ntsb/FTW88LA157.md): Cessna 150M · Killeen, TX · Accident · No injuries · Limited investigation · Final report · Aug 29, 1988 · N704SB · Destroyed > According to the pilot/operator aircraft accident report, the private pilot had not flown in the previous 90 days. The pilot was practicing landings on a dark night and collided with power lines 1000 feet short of the runway. After colliding with the wires,… - [NTSB SEA88LA165](https://openairdocs.org/ntsb/SEA88LA165.md): Latham Alco Coupe · Bremerton, WA · Accident · No injuries · Limited investigation · Final report · Aug 28, 1988 · N2936 · Substantial damage > Plt had about 4 hrs exp in make and model and 116 hrs total pilot time. Flew 'about 2 hrs' on 15 gals fuel and was making touch and go lndgs when power was lost. Acft nosed over during forced lndg in soft terrain. There was no evidence of fuel on board. - [NTSB MKC88DCA03](https://openairdocs.org/ntsb/MKC88DCA03.md): Luscombe 8A · Painton, MO · Accident · Serious injuries · Final report · Aug 28, 1988 · N1404K · Destroyed > Pilot did not maintian the proper decent rate on the final approach to the airport. - [NTSB LAX88LA299](https://openairdocs.org/ntsb/LAX88LA299.md): Cessna 152 · Chino, CA · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1988 · N67649 · Substantial damage > While on final approach, the instructor noticed the airspeed fall below 55 knots. He took control of the airplane from the student. The instructor pushed forward on the yoke and added full power to regain airspeed. He lost control of the airplane and it… - [NTSB FTW88LA156](https://openairdocs.org/ntsb/FTW88LA156.md): Cessna 172E · Katy, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1988 · N7746U · Substantial damage > Fuel exhaustion induced power loss, which necessitated the forced landing. Contributing to this accident was the pilot's decision to attempt to continue the flight without being able to refuel, and becoming lost during that effort. - [NTSB CHI88LA225](https://openairdocs.org/ntsb/CHI88LA225.md): Beech B-95 · Alma, MI · Accident · Minor injuries · Limited investigation · Final report · Aug 27, 1988 · N9673R · Substantial damage > During approach to landing the pilot entered a steep (45 degree bank) left turn from base to final. The pilot stated that he did not realize it at the time, but this action unported the fuel line to the left engine, causing the engine to fail due to fuel… - [NTSB CHI88LA222](https://openairdocs.org/ntsb/CHI88LA222.md): Piper J-3 · Youngstown, OH · Accident · Serious injuries · Limited investigation · Final report · Aug 27, 1988 · N38346 · Substantial damage > The aircraft experienced a total loss of engine power due to fuel exhaustion while on final approach to the runway. The aircraft sustained substantial damage, and the pilot was seriously injured when the aircraft impacted the ground approximately 25' short of… - [NTSB CHI88FA223](https://openairdocs.org/ntsb/CHI88FA223.md): Boeing 727-31 · Chicago, IL · Accident · Minor injuries · Field investigation · Final report · Aug 27, 1988 · N852TW · Substantial damage > Improper procedural checklist in which a critical step was not listed. - [NTSB FTW88LA150](https://openairdocs.org/ntsb/FTW88LA150.md): Aeronca 65-TL · Texarkana, TX · Accident · Minor injuries · Limited investigation · Final report · Aug 21, 1988 · N18460 · Destroyed > The airport operator stated he saw the airplane turn in to land. He said it appeared to stall and then make a quick turn to the left, into a tree. - [NTSB ANC88LA113](https://openairdocs.org/ntsb/ANC88LA113.md): Luscombe 8E · Dillingham, AK · Accident · No injuries · Limited investigation · Final report · Aug 20, 1988 · N2542K · Substantial damage > The pilot-in-command was beginning his descent for landing at Dillingham, Alaska and did not apply carburetor heat until his engine began to sputter. The engine stopped producing power and the pilot was unable to restart the engine. He landed on the tundra… - [NTSB CHI88IA217](https://openairdocs.org/ntsb/CHI88IA217.md): Bell 206L · Indianapolis, IN · Incident · No injuries · Incident investigation · Final report · Aug 19, 1988 · N295CK · No damage Next page: https://openairdocs.org/ntsb-phases/500/cases.md?page=170 ## 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 = 500) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=169 --- 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.