# NTSB investigations: Enroute 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 298 of 718 · 35,885 cases ## Cases, newest first - [NTSB MIA88LA217](https://openairdocs.org/ntsb/MIA88LA217.md): Piper PA-25-235C · Stringer, MS · Accident · No injuries · Limited investigation · Final report · Jul 6, 1988 · N4351Y · Substantial damage > According to the pilot while on a ferry flight during normal cruise at an alt of aprx 2000 ft, the eng quit due to fuel exhaustion. During the forced landing the acft collided with a tree. - [NTSB CHI88IA159](https://openairdocs.org/ntsb/CHI88IA159.md): Boeing 737-130 · Indianapolis, IN · Incident · No injuries · Incident investigation · Final report · Jul 6, 1988 · N409PE · No damage > Failure to ensure proper alignment and closure of the auxillary power unit lower shroud with the fire seal upon completion of a maintenance action. - [NTSB MIA88LA215](https://openairdocs.org/ntsb/MIA88LA215.md): Piper PA-38-112 · Vero Beach, FL · Accident · No injuries · Limited investigation · Final report · Jul 5, 1988 · N2608F · Destroyed > The plt stated that while inbound to Vero Beach, he ran out of fuel in the left tank. The engine quit, and he was unable to restart the engine before he crashed into a grove of trees. - [NTSB LAX88FA246](https://openairdocs.org/ntsb/LAX88FA246.md): Cessna 152 · Verdi, NV · Accident · 1 fatal · Field investigation · Final report · Jul 4, 1988 · N49787 · Destroyed > Failure of the pilot to gain sufficient altitude prior to negotiating mountainous terrain with forecast high winds. Contributing to this accident was the weather phenomena known as 'mountain wave' which created downdrafts that exceeded the aircraft's climb… - [NTSB LAX88FA245](https://openairdocs.org/ntsb/LAX88FA245.md): Cessna 320D · Mammoth Lakes, CA · Accident · 4 fatal · Field investigation · Final report · Jul 4, 1988 · N9HS · Destroyed > The pilot executed a left (south) crosswind departure towards higher terrain after departing runway 27; the plt was following a slower single engine airplane that had preceded his departure. Ground witnesses reported that as the airplane approached the higher… - [NTSB DEN88LA152](https://openairdocs.org/ntsb/DEN88LA152.md): Balloon Works Firefly 8B · Fort Collins, CO · Accident · Serious injuries · Limited investigation · Final report · Jul 4, 1988 · N7420S · Substantial damage > This Balloon flt was part of a rally. The flt departed from a stadium, climbed to 500' and then made a controlled descent and landing. After the next takeoff and climb to about 125' when the burner was turned off the plt noticed that fuel was not flowing to… - [NTSB NYC88LA175](https://openairdocs.org/ntsb/NYC88LA175.md): Cessna 150M · W. Seneca, NY · Accident · No injuries · Limited investigation · Final report · Jul 3, 1988 · N63206 · Substantial damage > The instructor pilot stated that the student pilot conducted the preflight and reported the fuel 'down a little.' The instructor did not visually verify the amount of fuel on board. Investigation revealed that the acft ran out of fuel and was forced to land… - [NTSB DEN88LA146](https://openairdocs.org/ntsb/DEN88LA146.md): Cessna 188 · Sentinel Butte, ND · Accident · No injuries · Limited investigation · Final report · Jul 3, 1988 · N3546Q · Destroyed > The pilot took off from his private airstrip near Sentinel Butte, ND, en route to beach, ND. He said there was a narrow cloud ahead, approximately 5-8 miles long, and emitting lightning, but it did not appear to him to threaten flight safety. The pilot said… - [NTSB ATL88FA254](https://openairdocs.org/ntsb/ATL88FA254.md): Cessna T207 · Petros, TN · Accident · 1 fatal · Field investigation · Final report · Jul 3, 1988 · N1724U · Destroyed - [NTSB MIA88LA211](https://openairdocs.org/ntsb/MIA88LA211.md): Cessna 152 · Marathon, FL · Accident · No injuries · Limited investigation · Final report · Jul 2, 1988 · N25057 · Substantial damage > The student plt was on his 1st solo x-c flt. A portion of the flt included a 30 mi stretch over the Florida bay section of the gulf of Mexico. The flt carried no flotation gear. 5.2 hrs into the flt, the eng quit & a ditching was performed near a pleasure… - [NTSB LAX88DVG07](https://openairdocs.org/ntsb/LAX88DVG07.md): Snow AT-301 · Davis, CA · Accident · No injuries · Final report · Jul 2, 1988 · N5224S · Substantial damage > At the end of an aerial application flight, en route to home base, the engine quit. The pilot made an emergency landing in a field, where during the landing roll the airplane collided with a bale of hay and nosed over. Inspection of the engine revealed that… - [NTSB BFO88IA065](https://openairdocs.org/ntsb/BFO88IA065.md): Cessna T210R · Washington, DC · Incident · No injuries · Incident investigation · Final report · Jul 2, 1988 · N6286U · Minor damage > Improper maintenance resulting in the routing of wire which caused an electrical short and inflight smoke. - [NTSB LAX88LA242](https://openairdocs.org/ntsb/LAX88LA242.md): Piper J3 · Rialto, CA · Accident · No injuries · Limited investigation · Final report · Jul 1, 1988 · N6868H · Substantial damage > During a local flight, the engine quit while descending to the airport. A forced landing was made on a road where during the landing roll a gust of wind pushed the airplane off the road. The airplane ground looped, collided with the terrain and nosed over.… - [NTSB CHI88DEX06](https://openairdocs.org/ntsb/CHI88DEX06.md): Piper J3 · Bedford, IN · Accident · No injuries · Final report · Jul 1, 1988 · N42684 · Substantial damage > Aircraft was in cruise flight at 1000 feet AGL when the pilot heard a backfire from the engine followed by immediate and total loss of power. Forced landing was made in rugged, rocky terrain. Landing gear sheared off on rollout. Investigation revealed failure… - [NTSB ATL88LA208](https://openairdocs.org/ntsb/ATL88LA208.md): Cessna T210L · Thomson, GA · Accident · Minor injuries · Limited investigation · Final report · Jul 1, 1988 · N29238 · Substantial damage > The plt reported that the engine lost pwr about 20 miles from the arpt where he had intended to refuel. The airplane subsequently collided with utility wires as he was attempting to land on a hwy. the plt attributed the pwr loss to fuel exhaustion. Postcrash… - [NTSB ATL88LA206](https://openairdocs.org/ntsb/ATL88LA206.md): Cessna 172M · Spring Creek, NC · Accident · No injuries · Limited investigation · Final report · Jul 1, 1988 · N1534V · Substantial damage > The plt reported that the engine began to run rough & lose power as the airplane climbed through 9,000 ft MSL. She then switched fuel tanks and moved the mixture to full rich, but the engine continued to lose power. Carb heat was not used at any time. A… - [NTSB ATL88FA207](https://openairdocs.org/ntsb/ATL88FA207.md): Piper PA-32 · Uniontown, AL · Accident · 1 fatal · Field investigation · Final report · Jul 1, 1988 · N8324V · Destroyed - [NTSB MIA88LA210](https://openairdocs.org/ntsb/MIA88LA210.md): Piper PA-32R-300 · Atlantic Ocean (Atlantic Ocean) · Accident · No injuries · Limited investigation · Final report · Jun 30, 1988 · N75033 · Destroyed > The plt stated that the eng started running rough. He decided to divert to alt aprt 15 miles away. While enroute, the plt stated that he heard a 'clanking' noise and oil sprayed the windsheild. The eng lost all power. The a/c was ditched in the Atlantic Ocean… - [NTSB LAX88FA241](https://openairdocs.org/ntsb/LAX88FA241.md): Helio HST-550A · Perris, CA · Accident · 1 fatal · Field investigation · Final report · Jun 30, 1988 · N9991F · Destroyed > Failure of the electrical stabilizer trim control that resulted in an uncommanded full nose down elevator trim command. - [NTSB CHI88LA146](https://openairdocs.org/ntsb/CHI88LA146.md): Cessna 150M · Lonsdale, MN · Accident · Minor injuries · Limited investigation · Final report · Jun 30, 1988 · N63178 · Substantial damage > The pilot was executing a power-off glide and when an attempt was made to recover by adding power, the engine did not respond. The pilot was then forced to make an emergency landing in a field. During the forced landing the pilot was unable to maintain… - [NTSB ATL88LA205](https://openairdocs.org/ntsb/ATL88LA205.md): Beech K35 · Greensboro, NC · Accident · No injuries · Limited investigation · Final report · Jun 30, 1988 · N5335R · Substantial damage > The flight was climbing to 11,000 feet with an instrument flight clearance when a propeller blade separated from the hub. The blade was subsequently recovered from the yard of a local resident. The fracture examination disclosed that the cracking originated… - [NTSB LAX88LA238](https://openairdocs.org/ntsb/LAX88LA238.md): Cessna 414A · Agua Caliente, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 29, 1988 · N27332 · Substantial damage > During a cross country flight, the right engine began to run rough. The pilot feathered the propeller and turned to land at the airport. En route, the left engine began to run rough. Unable to land at the airport, a forced landing was made on a road, where,… - [NTSB FTW88DRD11](https://openairdocs.org/ntsb/FTW88DRD11.md): Schweizer G-164B · Cheneyville, LA · Accident · Minor injuries · Final report · Jun 29, 1988 · N48585 · Destroyed > The ag airplane was returning after spraying chemical when the engine started to lose power. During the forced landing on a highway the left wing struck a road sign. No mechanical reason for the engine power loss was found. The acft had an annual inspection… - [NTSB DEN88LA140](https://openairdocs.org/ntsb/DEN88LA140.md): Beech C35 · Brighton, CO · Accident · No injuries · Limited investigation · Final report · Jun 29, 1988 · N8930A · Substantial damage > Shortly after takeoff and while cruise flight, the eng lost pwr. The fuel pressure gauge indicated o PSI. The plt switched on the electric fuel pump. The eng did not respond. The plt activated the auxiliary (wobble) pump and switched fuel tanks. The eng still… - [NTSB SEA88LA119](https://openairdocs.org/ntsb/SEA88LA119.md): Cessna 177B · Elko, NV · Accident · Serious injuries · Limited investigation · Final report · Jun 28, 1988 · N35181 · Substantial damage > Plt had just purchased acft and was on initial leg of cross-country flight. Plt calculated 4.9 hrs endurance, verified by CFI as adequate for proposed flt. After 4.2 hours tach time, fuel exhaustion occurred and a forced landing was executed 21 miles short of… - [NTSB FTW88DRD10](https://openairdocs.org/ntsb/FTW88DRD10.md): Bell 206L-1 · Houma, LA · Accident · No injuries · Final report · Jun 27, 1988 · N2611 · Substantial damage > Shortly after liftoff, the helicopter experienced a power loss at 300 feet. During the emergency landing in a wet swampy area with very high vegetation, the helicopter landed hard, and the main rotor blades struck the tailboom. At a post accident inspection,… - [NTSB DEN88FA141](https://openairdocs.org/ntsb/DEN88FA141.md): Piper PA-28RT-201T · Capitan, NM · Accident · 1 fatal · Field investigation · Final report · Jun 27, 1988 · N29318 · Destroyed - [NTSB BFO88FA060](https://openairdocs.org/ntsb/BFO88FA060.md): Piper PA-32RT-300T · Cambridge, MD · Accident · No injuries · Field investigation · Final report · Jun 27, 1988 · N21312 · Substantial damage > The pilot had departed ocean city, MD aprx 20 minutes after takeoff when nearing the chesapeake bay at an alt of 3000 ft MSL, a total loss of engine power was experienced. The plt attempted to restart the engine to no avail and a forced landing was made in a… - [NTSB ATL88IA195](https://openairdocs.org/ntsb/ATL88IA195.md): Israel Aircraft Industries 1124A · Hebron, KY · Incident · No injuries · Incident investigation · Final report · Jun 27, 1988 · N600J · Minor damage > During en route climb, the left engine failed and the crew executed a safe single engine landing. Examination of the engine revealed an uncontained HP turbine failure in the engine. Metallurgical examination of the failed parts indicated improper steel alloy.… - [NTSB LAX88LA234](https://openairdocs.org/ntsb/LAX88LA234.md): Cessna 172N · La Grange, CA · Accident · No injuries · Limited investigation · Final report · Jun 26, 1988 · N4833E · Substantial damage - [NTSB FTW88FA125](https://openairdocs.org/ntsb/FTW88FA125.md): Piper PA-28-236 · Anson, TX · Accident · 4 fatal · Field investigation · Final report · Jun 26, 1988 · N2889N · Destroyed > Inadequate weather evaluation-pic; flight into known adverse weather, inadvertent-pic; design stress limits exceeded by PIC; thunderstorm - [NTSB DEN88LA137](https://openairdocs.org/ntsb/DEN88LA137.md): Bell 206B3 · Missoula, MT · Accident · No injuries · Limited investigation · Final report · Jun 26, 1988 · N2754A · Substantial damage > A check airman and a commercial plt were performing an instructional flt. During climbout after a practice autorotation, the engine out audio and light warning activated. Both pilots verified an actual engine out and entered an autorotation. The helicopter… - [NTSB DEN88FA138](https://openairdocs.org/ntsb/DEN88FA138.md): Douglas A-26C · Cimarron, NM · Accident · 2 fatal · Field investigation · Final report · Jun 26, 1988 · N4813E · Destroyed > The plt rcvd a wx briefing before takeoff, but did not file a flt plan. Drg the flt, the acft (Douglas A-26C, N4813E) crashed in mountainous terrain at an elev of about 11,200' near baldy mountain. Scouting personnel, who were camped in the vicinity, rprtd… - [NTSB BFO88LA061](https://openairdocs.org/ntsb/BFO88LA061.md): Boeing 737 · Salisbury, MD · Accident · Serious injuries · Limited investigation · Final report · Jun 26, 1988 · N9040U · No damage > Before the flt, the crew received a severe wx warning concerning wx along the route of flt. The captain informed the flight attendants to be prepared to have passenger service completed early and to be seated before the descent. Before encountering… - [NTSB SEA88LA117](https://openairdocs.org/ntsb/SEA88LA117.md): Cessna 210G · Bend, OR · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 1988 · N5923F · Destroyed > On arrival in area of planned fuel stop, pax did not feel well. Plt determined that adequate fuel remained to continue to final destination. However, exhaustion occurred 8 miles short of destination. Plt diverted from initial forced lndg site (road) due… - [NTSB NYC88LA170](https://openairdocs.org/ntsb/NYC88LA170.md): Bell 47J2 · Newburyport, MA · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 1988 · N51711 · Destroyed > The helicopter departed runway 10 at plum island airport, turned left over the plum island river and shortly thereafter the engine quit. The pilot stated that no warning was noted and a check of the instruments indicated no problems. He further stated that… - [NTSB LAX88LA233](https://openairdocs.org/ntsb/LAX88LA233.md): Hughes 269B · Big Bear, CA · Accident · No injuries · Limited investigation · Final report · Jun 25, 1988 · N9350F · Substantial damage > While cruising, the plt perceived he was experiencing a loss of engine & rotor RPM. The plt stated that he attempted to regain RPM by autorotating. The RPM was regained in the autorotative descent. The plt elected to continue the descent to a landing. Upon… - [NTSB FTW88LA126](https://openairdocs.org/ntsb/FTW88LA126.md): Cessna 150F · Temple, TX · Accident · No injuries · Limited investigation · Final report · Jun 25, 1988 · N8979S · Substantial damage > After the descent, the pilot applied power and the engine started running rough. The pilot was able to get the engine running at full power within several minutes but it quit completely approximately 3 to 4 miles from the airport. The airplane was landed in… - [NTSB DEN88LA135](https://openairdocs.org/ntsb/DEN88LA135.md): Bell 47G · Terry, MT · Accident · Serious injuries · Limited investigation · Final report · Jun 25, 1988 · N2243W · Substantial damage > The aircraft was on a ferry flight from alpine, WY. To belfield, ND. The plt departed alpine at approximately 0950 and made several enroute stops to refuel. The plt intended to land at miles city, MT to refuel but he got lost and flew to Terry, MT, located 38… - [NTSB CHI88LA142](https://openairdocs.org/ntsb/CHI88LA142.md): Aeronca 7BCM · Kenosha, WI · Accident · No injuries · Limited investigation · Final report · Jun 25, 1988 · N84405 · Substantial damage > The pilot was picking up the aircraft after being serviced when approximately 20 minutes after taking off the engine quit. The pilot was forced to make an emergency landing in a field. During the landing sequence the aircraft contacted some trees at the edge… - [NTSB MKC88LA115](https://openairdocs.org/ntsb/MKC88LA115.md): Cessna 150 · Trousdale, KS · Accident · No injuries · Limited investigation · Final report · Jun 24, 1988 · N6525F · Substantial damage > During a cross country personal flight, the PIC noticed an excessively high oil temperature. He said he enriched the fuel mixture, and when that failed to cool the engine, he reversed his course back to his departure apt. Shortly after his reversal of course,… - [NTSB LAX88LA231](https://openairdocs.org/ntsb/LAX88LA231.md): Cessna 152 · Stonyford, CA · Accident · Serious injuries · Limited investigation · Final report · Jun 23, 1988 · N4792B · Substantial damage > During a cross country flight, the pilot was flying 500 feet AGL over mountainous terrain when a strong downdraft was encountered. The airplane was unable to climb out of it and subsequently collided with the terrain. - [NTSB FTW88LA123](https://openairdocs.org/ntsb/FTW88LA123.md): Beech B-24R · Blanchard, OK · Accident · No injuries · Limited investigation · Final report · Jun 23, 1988 · N9162S · Substantial damage > According to the private pilot in the left front seat, this was a training flight set up by the commercial pilot flight instructor in one of the rear seats. The private pilot in the left front seat was to practice for his commercial flight test and the… - [NTSB CHI88DEX05](https://openairdocs.org/ntsb/CHI88DEX05.md): Beech V35A · Seymour, IN · Accident · No injuries · Final report · Jun 23, 1988 · N7892R · Substantial damage > Aircraft was in cruise flight at 6500 feet when engine began to run rough. Pilot navigated to nearest airport and made intentional gear-up landing with cruise power. Postcrash investigation revealed number 2 exhaust valve had failed and become wedged between… - [NTSB MIA88LA202](https://openairdocs.org/ntsb/MIA88LA202.md): Cessna 180 · Bimini, Bahamas · Accident · No injuries · Limited investigation · Final report · Jun 22, 1988 · N3634C · Destroyed > Low engine oil pressure and subsequent engine seizure for undetermined reasons. - [NTSB ATL88FA198](https://openairdocs.org/ntsb/ATL88FA198.md): Cessna 150 · Eastman, GA · Accident · 1 fatal · Field investigation · Final report · Jun 22, 1988 · N4282U · Destroyed > The accident occurred after takeoff from a private sod airstrip. A witness saw the aircraft climb to about 500 feet. It then started losing altitude, dropped out of sight, and crashed. The aircraft impacted the ground in a nose low attitude and burned.… - [NTSB MKC88LA114](https://openairdocs.org/ntsb/MKC88LA114.md): Piper PA-28R-200 · Eldon, MO · Accident · Serious injuries · Limited investigation · Final report · Jun 21, 1988 · N4490T · Substantial damage > Total failure of the powerplant due to an oil line rupture, and proper touchdown point not attained by the pilot in command. - [NTSB DEN88LA133](https://openairdocs.org/ntsb/DEN88LA133.md): Cessna 152 · Grand Forks, ND · Accident · No injuries · Limited investigation · Final report · Jun 21, 1988 · N96730 · Substantial damage - [NTSB LAX88LA227](https://openairdocs.org/ntsb/LAX88LA227.md): Cessna 210M · Tres Pinos, CA · Accident · No injuries · Limited investigation · Final report · Jun 20, 1988 · N732KS · Substantial damage - [NTSB MKC88LA113](https://openairdocs.org/ntsb/MKC88LA113.md): Ercoupe 415-C · Florence, MO · Accident · No injuries · Limited investigation · Final report · Jun 19, 1988 · N94045 · Substantial damage > While on a personal flight, PIC said he began to lose engine power. He elected to make a precautionary ldg in a farm field, and during the roll out, the nose wheel struck a ditch. Post flt examination failed to reveal any cause for the partial power loss. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=299 ## 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 = 400) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/400/cases?page=298 --- 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.