# NTSB investigations: Unknown 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 24 of 40 · 1,981 cases ## Cases, newest first - [NTSB CHI88FA190](https://openairdocs.org/ntsb/CHI88FA190.md): Mcdonnell Douglas 269B · Braceville, IL · Accident · 2 fatal · Field investigation · Final report · Aug 2, 1988 · N9522F · Destroyed > Conducting maneuvering flight the PIC failed to monitor the helicopter systems and allowed the main rotor RPM to decay to the point where it would not produce enough lift to sustain flight. - [NTSB MIA88FA232](https://openairdocs.org/ntsb/MIA88FA232.md): Rockwell S2R · O'Brien, FL · Accident · 1 fatal · Field investigation · Final report · Jul 24, 1988 · N4222X · Destroyed > The purpose of the flt was to spray a soybean field about 1/2 mi n of the airstrip. There are no known witnesses to the crash, but a person in the area heard the eng 'pop', then eng sound ceased; seconds later the sound of impact was heard. The acft struck… - [NTSB DEN88LA162](https://openairdocs.org/ntsb/DEN88LA162.md): Cessna 177RG · Santa Teresa, NM · Accident · No injuries · Limited investigation · Final report · Jul 17, 1988 · N34338 · Substantial damage > An unknown person or persons took a Cessna 177RG from a small airport near the mexican border, without permission. State police found it crashed in a field 2 miles southwest of Santa Teresa airport, and notified the owner. No witnesses have been found to… - [NTSB SEA88FA131](https://openairdocs.org/ntsb/SEA88FA131.md): Applebay Zuni 2 · Wellington, NV · Accident · 1 fatal · Field investigation · Final report · Jul 16, 1988 · N14XZ · Destroyed > The plt (with only 13 hrs flt time in the hi performance sailplane) took off at 1330 PDT. Psn rprts with her gnd crew were normal until 1630, then another plt offered to relay messages. After ctcg her gnd crew, the otr plt tried calling her back at aprx 1645,… - [NTSB CHI88FA160](https://openairdocs.org/ntsb/CHI88FA160.md): Cessna 172N · Middletown, IN · Accident · 1 fatal · Field investigation · Final report · Jul 7, 1988 · N6187D · Destroyed > Attempted operation of the accident airplane by the PIC when he was under the influence of alcohol. - [NTSB CHI88FA153](https://openairdocs.org/ntsb/CHI88FA153.md): Piper PA-38-112 · Hamm Lake, MN · Accident · 2 fatal · Field investigation · Final report · Jul 3, 1988 · N2485N · Destroyed > Loss of control in flight, either by the student or by the instructor, at an altitude insufficient to allow for a recovery, by the flight instructor, before the resulting out of control descent caused the accident airplane to strike the terrain. - [NTSB ANC88LA152](https://openairdocs.org/ntsb/ANC88LA152.md): Champion 7AC · Coldfoot, AK · Accident · 1 fatal · Limited investigation · Final report · Jun 11, 1988 · N81725 · Destroyed > Undetermined. - [NTSB ATL89FAMS2](https://openairdocs.org/ntsb/ATL89FAMS2.md): Piper PA-28-140 · Missing · Accident · 1 fatal · Missing aircraft · Final report · Apr 17, 1988 · N98070 · Destroyed > The airplane and pilot reportedly departed moncks corner, SC sometime between 1900 and 2000 EDT on 4/17/88. The airplane was subsequently reported Missing, and search efforts were conducted between 4/20/88 and 4/29/88. Aircraft damage and injury index are… - [NTSB CHI88FA080](https://openairdocs.org/ntsb/CHI88FA080.md): Cessna 310Q · Servia, IN · Accident · 1 fatal · Field investigation · Final report · Mar 24, 1988 · N7797Q · Destroyed > The pilot induced overload to the airplane structure causing material failure of the airplane. Attempted flight into adverse weather, and spatial disorientation of the pilot, are contributing factors in this accident. - [NTSB ATL88IA117](https://openairdocs.org/ntsb/ATL88IA117.md): Aero Commander 680E · New York, NY · Incident · No injuries · Incident investigation · Final report · Mar 14, 1988 · N50 · Minor damage > The airplane had been given a daily insp on 03-10-88 with no structural damage noted. During the next daily inspection on 03-14-88, skin buckling was noted on both wings. Three different pilots had flown the airplane between inspections and all indicated that… - [NTSB MIA88LA104](https://openairdocs.org/ntsb/MIA88LA104.md): Beech 65-88 · Accident · 2 fatal · Limited investigation · Final report · Feb 7, 1988 · N884G · Destroyed > Undetermined. - [NTSB CHI88FAMS1](https://openairdocs.org/ntsb/CHI88FAMS1.md): Cessna 172N · Warsaw, IN · Accident · 4 fatal · Missing aircraft · Final report · Jan 8, 1988 · N4878G · Destroyed > Aircraft departed during the hours of darkness and was declared missing after failing to arrive at its stated destination. The proposed route of flight crossed a large body water and a local lakeshore resident reported hearing an airplane strike the water. No… - [NTSB CHI88DEX01](https://openairdocs.org/ntsb/CHI88DEX01.md): Piper PA-24-250 · Salem, IN · Accident · 1 fatal · Final report · Jan 5, 1988 · N6487P · Destroyed > N6478P crashed during a forced landing near the Salem, IN, airport. The aircraft had experienced an engine failure due to failure of the number 5 connecting rod cap bolt. The aircraft struck a tree during the approach and crashed 100 yards north of the runway. - [NTSB LAX88DUM02](https://openairdocs.org/ntsb/LAX88DUM02.md): Bede BD-5 · Chula Vista, CA · Accident · 1 fatal · Final report · Dec 24, 1987 · N29DT · Destroyed - [NTSB MIA88LA073](https://openairdocs.org/ntsb/MIA88LA073.md): Cessna 152 · Missing · Accident · 1 fatal · Limited investigation · Final report · Dec 21, 1987 · N757EQ · Destroyed > According to the operator the acft departed san juan, PR on a cross country flight to la romana. The acft arrived there & dropped the student off & the plt departed at about 1400 ast on his return trip to san juan. The acft did not arrive at it's destination… - [NTSB DEN88FA036](https://openairdocs.org/ntsb/DEN88FA036.md): Cessna A152 · Benson, AZ · Accident · 1 fatal · Field investigation · Final report · Dec 8, 1987 · N234ZN · Destroyed > Abt 20 min after tkof, the acft crashed in VMC conds, aprx 26 mi along the route fm tucson to las cruces. Initial impactoccurred with the l wing hitting the top of a yucca plant as the acft was in a slgt nose down, l wing low attitude. Justbyd this point, the… - [NTSB BFO88FA003](https://openairdocs.org/ntsb/BFO88FA003.md): Cessna 172H · Indian Head, MD · Accident · 1 fatal · Field investigation · Final report · Oct 16, 1987 · N9WB · Destroyed > The non-certificated plt took the acft without proper authority. A note was found in his automobile that showed he intended to commit suicide. A revolver was found at the crash scene with a spent cartridge under the hammer. Postmortem studies showed the pilot… - [NTSB ANC87LA139](https://openairdocs.org/ntsb/ANC87LA139.md): Cessna 185F · Wasilla, AK · Accident · No injuries · Limited investigation · Final report · Sep 6, 1987 · N93018 · Substantial damage > The pilot stated that after rollout on the grass runway, he lost directional control causing the plane to ground loop. Exmination of the tailwheel revealed that the tire was flat prior to the landing. - [NTSB LAX87FAMS4](https://openairdocs.org/ntsb/LAX87FAMS4.md): Cessna 172P · Missing Acft, CA · Accident · 1 fatal · Missing aircraft · Final report · Aug 30, 1987 · N65797 · Destroyed > The pilot told family and friends that he was going to fly along the coast and return at night. He did not return. The civil air patrol searched for the aircraft and pilot for several days without success. The flight originated at van nuys airport, van nuys,… - [NTSB LAX87LA334](https://openairdocs.org/ntsb/LAX87LA334.md): Cessna 206 · Williams, AZ · Accident · 1 fatal · Limited investigation · Final report · Jul 26, 1987 · N4651Z · Destroyed > The aircraft was reported stolen on July 26, 1987. It is believed that the aircraft departed the grand canyon airport in grand canyon, Arizona on July 26, 1987, at 0300 MST. A search of records or airports in the area revealed that the aircraft was refueled… - [NTSB CHI87DEC03](https://openairdocs.org/ntsb/CHI87DEC03.md): Navion G · Erie, MI · Accident · Serious injuries · Final report · Jun 23, 1987 · N2386T · Destroyed > With the landing gear extended, the aircraft impacted with trees in a near inverted attitude and was destroyed. The pilot, who was the sole occupant was seriously injured. There were no witnesses to the accident and the pilot could not remember the events… - [NTSB ATL87FA173](https://openairdocs.org/ntsb/ATL87FA173.md): Mitsubishi MU-2B · Coral Springs, FL · Accident · 1 fatal · Field investigation · Final report · Jun 18, 1987 · N184MA · Destroyed > The pilot reported to ground personnel at fort lauderdale that he was experiencing an avionics problem and the passengerentry door was sprung the day before when it was slammed; however, the pilot elected to depart. The aircraft wreckage was located on June… - [NTSB NYC87FA160](https://openairdocs.org/ntsb/NYC87FA160.md): Robinson R22 Mariner · So. Windsor, CT · Accident · 2 fatal · Field investigation · Final report · Jun 3, 1987 · N2287L · Destroyed > A loss of control in flight for undetermined reasons. - [NTSB MIA87IA166](https://openairdocs.org/ntsb/MIA87IA166.md): Boeing 747-245F · Caracas, Venezuela · Incident · No injuries · Incident investigation · Final report · May 29, 1987 · N813FT · Minor damage > Flight experienced leakage of a five gallon container of glutaraldehyde listed by the shipper as a class 8 corrosive on the aircrafts upper deck enroute miami, Florida to Caracas, venezuela. The chemical was later found not to be corrosive and the aircraft… - [NTSB MIA87LA164](https://openairdocs.org/ntsb/MIA87LA164.md): Cessna 402C · Missing Acft, Bahamas · Accident · 1 fatal · Limited investigation · Final report · May 27, 1987 · N2652B · Destroyed > On 5/27/87 at about 0915 EDT, the plt departed palm beach intl arpt (pbi) on a flt to marsh harbour, great abaco island, Bahamas. When the Acft did not arrive at the destination, a search was initiated. The Acft was not fnd & was presumed to have been… - [NTSB SEA87FA098](https://openairdocs.org/ntsb/SEA87FA098.md): Piper PA-31-350 · North Las Vegas, NV · Accident · 1 fatal · Field investigation · Final report · May 20, 1987 · N22LV · Destroyed > A mechanic, who was not rated as a plt, took the acft without permission & elected to takeoff at ngt. A witness saw the acft dep at about 0250 PDT. Subsequently, it crashed aprx 3 mi ene of the arpt in an open undeveloped area. The time of the acdnt was not… - [NTSB MIA87LA161](https://openairdocs.org/ntsb/MIA87LA161.md): Piper PA-23-250 · Missing, FL · Accident · 2 fatal · Limited investigation · Final report · May 14, 1987 · N640CC · Destroyed > The acft failed to arrive at its destination on a flight from miami, FL to aruba, netherland antilles via andros is, great inagua & port au prince. According to a flt plan filed by the plt the acft carried enough fuel for 8 hours & 30 minutes of flt, along… - [NTSB CHI87FA124](https://openairdocs.org/ntsb/CHI87FA124.md): Cessna 152 · Ina, IL · Accident · 1 fatal · Field investigation · Final report · May 6, 1987 · N25991 · Destroyed > Before the flt, the plt stated his intentions were to practice ngt lndgs. He took off at 2010 CDT with an estd 1.5 hrs of fuel on board. When the acft did not return, a search was initiated. Subsequently, it was fnd by fishermen, submergedin a lake… - [NTSB MKC87LA080](https://openairdocs.org/ntsb/MKC87LA080.md): Fairchild SA-227 · Springfield, MO · Accident · No injuries · Limited investigation · Final report · Apr 7, 1987 · N26863 · Substantial damage > On April 6, 1987 a crew operating a metro iii, commuter acft noticed damage on both eng nacelles during a preflt insp. The commuter operator chief pilot was notified and an on site insp was made. The crew originally rptng the damage claimed they were not at… - [NTSB ATL87IA083](https://openairdocs.org/ntsb/ATL87IA083.md): Saab-Fairchild SF340A · Covington, KY · Incident · No injuries · Incident investigation · Final report · Mar 10, 1987 · N341CA · Minor damage > After a hydraulic sys malfunction, the capt returned to arpt to exchange acft. Company plt had completed day of flying and was asked to taxi acft to maint hangar. Departing capt was in process of manually pumping hyd sys to sufficient pressure to ensure… - [NTSB LAX87DUG02](https://openairdocs.org/ntsb/LAX87DUG02.md): Prue Standard Unknown · Hemet, CA · Accident · 1 fatal · Final report · Mar 8, 1987 · N9726Z · Destroyed > During a local soaring flight, the acft was seen by a witness to be in a vertical dive and appeared to be intact when it impacted the terrain. Inspection of the aircraft revealed no control system malfunctions. The plts flt time was 38 hrs as of 2/5/85 the… - [NTSB MIA87LA097](https://openairdocs.org/ntsb/MIA87LA097.md): Beech B-65 · Key Largo, FL · Accident · No injuries · Limited investigation · Final report · Mar 3, 1987 · N822Q · Destroyed > The aircraft was found crashed in shallow water near Key Largo FL. Attempts to locate the pilot or current operator were fruitless. The circumstances surrounding the crash and the cause are unknown. - [NTSB LAX87FAMS2](https://openairdocs.org/ntsb/LAX87FAMS2.md): Piper PA-44-180T · Missing Acft (Pacific Ocean) · Accident · 2 fatal · Missing aircraft · Final report · Feb 25, 1987 · N8307H · Destroyed > The instructor plt (CFI) & the single-eng, pvt plt (owner) were on a flt to conduct multi-eng training for the new owner. Drg the flt, the crew contacted los angeles TRACON & requested a VOR apch to the santa monica arpt & said they would not be able to maint… - [NTSB CHI87FA083](https://openairdocs.org/ntsb/CHI87FA083.md): Cessna 172N · Fergus Falls, MN · Accident · 4 fatal · Field investigation · Final report · Feb 12, 1987 · N734MV · Destroyed > Following a 1.5 hour personal flight at night, the aircraft crashed into the side of a low hill near the destination airport. Although the pilot had a total of 6 hours of night time, most of his solo night time was during this last flight. Hazy VFR conditions… - [NTSB MKC87LA046](https://openairdocs.org/ntsb/MKC87LA046.md): Cessna 150M · Kansas City, MO · Accident · No injuries · Limited investigation · Final report · Jan 24, 1987 · N671HA · Substantial damage > The student plt rptd colliding with a parked fuel truck during taxi on 1/24/87. Inspection of the acft revealed only minor leading edge skin damage to the rt wing. The acft was released for further trng flts. The acft operated for more than a wk with no one… - [NTSB SEA87FA062](https://openairdocs.org/ntsb/SEA87FA062.md): Cessna 150 · Ellensburg, WA · Accident · 2 fatal · Field investigation · Final report · Jan 8, 1987 · N704HM · Destroyed > The two commercially certificated instrument rated flight instructors departed Ellensburg at approximately 1120 PST on a local flight. Both pilots had appointments at 1300 hours PST. VFR conditions prevailed in lower terrain near Ellensburg, however, a… - [NTSB NYC87FAMS1](https://openairdocs.org/ntsb/NYC87FAMS1.md): Cessna 310 · Hamburg, NY · Accident · 1 fatal · Missing aircraft · Final report · Dec 31, 1986 · N5462J · Destroyed > The Cessna 310R departed the airport on a svfr departure. The pilot cancelled his clearance a few minutes later and reported in VFR conditions. The aircraft failed to arrive at its destination. Radar tracking showed the aircraft heading toward lake erie. The… - [NTSB DEN87FA024](https://openairdocs.org/ntsb/DEN87FA024.md): Piper PA-28-181 · Stugis, SD · Accident · 1 fatal · Field investigation · Final report · Nov 29, 1986 · N2161B · Destroyed > The plt agreed to ferry the acft for another plt who was not IFR rated & who had been forced to land at kadoka on the previous evening due to low fuel & apchg darkness. IMC prevailed thru-out the area. The commercial/ifr rated plt did not obtain a wx briefing… - [NTSB ATL87FA010](https://openairdocs.org/ntsb/ATL87FA010.md): Cessna 152 II · Pembroke, KY · Accident · 2 fatal · Field investigation · Final report · Oct 22, 1986 · N5083L · Destroyed > The acft was observed shortly after departing the owner/operator's private landing strip. Witnesses rprtd hearing a sudden decrease in eng power, then a short time later, they heard the eng 'fire' or restart momentarily, but decrease in power again. The acft… - [NTSB ANC86FA167](https://openairdocs.org/ntsb/ANC86FA167.md): Piper PA-18 · Port Alsworth, AK · Accident · 2 fatal · Field investigation · Final report · Sep 13, 1986 · N9109D · Destroyed > Undetermined. - [NTSB DEN86FAMS3](https://openairdocs.org/ntsb/DEN86FAMS3.md): Mooney M20F · Cuba, NM · Accident · 2 fatal · Missing aircraft · Final report · Sep 9, 1986 · N2688W · Destroyed > The acft departed a private airstrip in Cuba, NM, for the purpose of viewing real estate property before continuing to taos. State authorities were notified the following day when the plt failed to arrive at work. A search for the acft was conducted until… - [NTSB ATL86FA235](https://openairdocs.org/ntsb/ATL86FA235.md): Piper PA-18 · Wilton, ME · Accident · 2 fatal · Field investigation · Final report · Aug 30, 1986 · N4641H · Destroyed > Witnesses saw the acft go into a nose down attitude prior to crashing into a wooded area near the arpt. Rprtdly, the prop was turning, but no sound was heard from the eng. Subsequently, the acft impacted the gnd in a nose low, inverted attitude. No preimpact… - [NTSB ATL86FLQ06](https://openairdocs.org/ntsb/ATL86FLQ06.md): Bernard Sonerai II · Trenton, KY · Accident · 1 fatal · Final report · Aug 5, 1986 · N325WB · Destroyed > Witnesses reported seeing the acft spin to ground impact with a section of the right wing hanging. Post accident exam revealed the outboard half (aprx 4 ft) of the right wing was bent aprx 120 degrees to the inside half of the right wing. Monnett experimental… - [NTSB NYC86FHM04](https://openairdocs.org/ntsb/NYC86FHM04.md): Ward Skybolt · Cranford, NJ · Accident · 1 fatal · Final report · Aug 4, 1986 · N2TW · Destroyed > Witnesses heard the aircraft engine pop, sputter and then go silent. The aircraft was observed to continually lose altitude, then visual contact was lost due to the tree line. Post-accident wreckage examination disclosed no evidence of fuel on board the… - [NTSB CHI86FA194](https://openairdocs.org/ntsb/CHI86FA194.md): Piper PA-24-250 · Oshkosh, WI · Accident · Serious injuries · Field investigation · Final report · Aug 2, 1986 · N5713P · Substantial damage > The aircraft ran out of fuel after 3+41 hours of flight. The pilot stated that he was sure the tanks were full on takeoff. Flight planning and a documented conservative fuel burn rate indicated that the aircraft should have been able to remain airborne for at… - [NTSB LAX86FA307](https://openairdocs.org/ntsb/LAX86FA307.md): Cherry HP16 · Llano, CA · Accident · 1 fatal · Field investigation · Final report · Jul 27, 1986 · N118PC · Destroyed > The glider pilot departed on a local flight and the wreckage of his glider was spotted a little over an hour later. There were no known witnesses to the accident which occurred in VFR daylight conditions. - [NTSB SEA86FA145](https://openairdocs.org/ntsb/SEA86FA145.md): Grumman AA-5A · Round Mountain, NV · Accident · 2 fatal · Field investigation · Final report · Jun 11, 1986 · N9761U · Destroyed > The pilot and passenger departed on a local flight to spot potential fishing locations in mountainous terrain. High density altitude conditions existed at the time/place of the accident. Kinematics information from the accident site indicates that as the… - [NTSB NYC86FA140](https://openairdocs.org/ntsb/NYC86FA140.md): Aeronca 7AC · Chaumont, NY · Accident · 2 fatal · Field investigation · Final report · Jun 5, 1986 · N82079 · Destroyed > The pilot departed his private strip and crashed about 5 minutes later in a steep nose down attitude. Over 50 per cent of the fluid in the carburetor was a contaminant. - [NTSB MIA86FA148](https://openairdocs.org/ntsb/MIA86FA148.md): Cessna 150H · Vero Beach, FL · Accident · Serious injuries · Field investigation · Final report · May 5, 1986 · N6989S · Destroyed > The CFI & student plt were on a training flt. Witnesses heard the eng sputter, then cut out completely. One witness said he thought the plt would attempt a landing to the south, lengthwise, into a pasture bordered on all sides by trees aprx 50 ft high. The… - [NTSB MIA86LA109](https://openairdocs.org/ntsb/MIA86LA109.md): Piper PA-31-350 · Atlantic Ocean (Atlantic Ocean) · Accident · 6 fatal · Limited investigation · Final report · Mar 26, 1986 · N3527E · Destroyed > The acft failed to arrive at it's destination on a VFR flight from miami FL, to west end, Bahamas. The acft's last reported position was 10 miles west of west end. There was no further contact with the acft. U.S. Coast guard initiated search on March 26, 1986… Next page: https://openairdocs.org/ntsb-phases/990/cases.md?page=25 ## 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 = 990) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/990/cases?page=24 --- 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.