# 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 195 of 718 · 35,889 cases ## Cases, newest first - [NTSB CHI98LA097](https://openairdocs.org/ntsb/CHI98LA097.md): Piper PA-23-250 · Peoria, IL · Accident · No injuries · Limited investigation · Final report · Feb 23, 1998 · N54231 · Substantial damage > an improper preflight inspection of the airplane by the pilot and the inadvertant stall/mush which was encountered. A factor associated with this accident was the pilot's decision to continue to use the emergency hydraulic hand pump rather than the CO2 bottle… - [NTSB ANC98LA022](https://openairdocs.org/ntsb/ANC98LA022.md): Piper PA-18 · Tyonek, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 23, 1998 · N1379A · Substantial damage > The pilot's continued VFR over-the-top operation, becoming lost/disoriented, his inadequate in-flight planning/decision making, and subsequent fuel exhaustion. Factors in the accident were the presence of a cloud layer below the pilot's selected altitude, the… - [NTSB MIA98LA081](https://openairdocs.org/ntsb/MIA98LA081.md): Cessna 150A · Gulf Of Mexico · Accident · No injuries · Limited investigation · Final report · Feb 22, 1998 · N757NK · Destroyed > a loss of engine power due to undermined reason resulting in a forced landing, and an in- flight collision with water. - [NTSB LAX98FA091](https://openairdocs.org/ntsb/LAX98FA091.md): Beech 95-B55 · Sutter, CA · Accident · 2 fatal · Field investigation · Final report · Feb 22, 1998 · N67623 · Destroyed > The pilot's in-flight decision(s) to attempt VFR flight in instrument meteorological conditions at an altitude which did not provide for adequate terrain clearance requirements. A factor that contributed to the accident was the pilot's decision to disregard… - [NTSB FTW98IA130](https://openairdocs.org/ntsb/FTW98IA130.md): Saab-Scania 340B · Lawton, OK · Incident · No injuries · Incident investigation · Final report · Feb 22, 1998 · N396AE · Minor damage > the collapse of the left main landing gear during landing roll as result of a shorted weight-on-wheels relay. Contributing factors were the insufficient information available to the flight crew in the company's quick reference handbook (QRH), and the… - [NTSB CHI98FA096](https://openairdocs.org/ntsb/CHI98FA096.md): Wasielak Sonerai II L · Malta, IL · Accident · 2 fatal · Field investigation · Final report · Feb 22, 1998 · N38NL · 2 aircraft · Destroyed > The pilot's failed to maintain adequate clearance from the other aircraft. - [NTSB ATL98FA053](https://openairdocs.org/ntsb/ATL98FA053.md): Piper PA-28-235 · Clinton, MS · Accident · 1 fatal · Field investigation · Final report · Feb 22, 1998 · N9166W · Destroyed > The pilot's lack of recent instrument flight experience that led to spatial disorientation and loss of airplane control; and his improper use of carburetor heat that resulted in a loss of engine power and subsequent collision with the ground during an… - [NTSB ATL98LA051](https://openairdocs.org/ntsb/ATL98LA051.md): PZL-Bielsko SZD-48-3 · Pikeville, TN · Accident · Minor injuries · Limited investigation · Final report · Feb 21, 1998 · N25MZ · Substantial damage > The loss of thermal lift. - [NTSB ATL98LA050](https://openairdocs.org/ntsb/ATL98LA050.md): Piper PA-25-235 · Perry Foley, FL · Accident · No injuries · Limited investigation · Final report · Feb 21, 1998 · N8648L · Substantial damage > a loose (or missing) carburetor drain plug and fuel line, due to an inadequate maintenance/annual inspection, which resulted in a fuel leak, fuel exhaustion, loss of engine power, and a forced landing. The obstructions (trees in the emergency landing area)… - [NTSB CHI98LA094](https://openairdocs.org/ntsb/CHI98LA094.md): Ercoupe 415-C · Wood Lake, NE · Accident · 1 fatal · Limited investigation · Final report · Feb 19, 1998 · N99270 · Destroyed > the pilot's intentional flight into adverse weather conditions, the wing ice, and the inadvertent stall. Factors contributing to this accident were the rain, freezing rain and low ceilings. - [NTSB IAD98LA028](https://openairdocs.org/ntsb/IAD98LA028.md): Beech 55B · Buffalo, NY · Accident · No injuries · Limited investigation · Final report · Feb 18, 1998 · N1072W · Substantial damage > Improper use of the fuel selector, which resulted in fuel starvation and loss of engine power. - [NTSB ATL98LA046](https://openairdocs.org/ntsb/ATL98LA046.md): Cessna 152 · Americus, GA · Accident · No injuries · Limited investigation · Final report · Feb 18, 1998 · N48878 · Substantial damage > the pilot's improper planning/decision, which led to fuel exhaustion, loss of engine power, and a forced landing on unprepared terrain. - [NTSB IAD98FA027](https://openairdocs.org/ntsb/IAD98FA027.md): Beech C-90 · Newton, WV · Accident · 2 fatal · Field investigation · Final report · Feb 16, 1998 · N5WU · Destroyed > The pilot inadequate management of the fuel system which resulted in fuel starvation to both engines. Factors in the accident were the pilot's concern about maintenance being completed prior to executing a scheduled flight later in the day, and operating the… - [NTSB CHI98IA095](https://openairdocs.org/ntsb/CHI98IA095.md): Airbus Industrie A-320-212 · Memphis, TN · Incident · No injuries · Incident investigation · Final report · Feb 16, 1998 · N341NW · Minor damage > the inadequate (bronze) material used by the fuel pump's manufacturer, which wore and ultimately blocked the fuel filter bypass and partially blocked the fuel nozzles, causing the fuel spray to burn through the low pressure turbine case. - [NTSB FTW98LA129](https://openairdocs.org/ntsb/FTW98LA129.md): Enstrom F-28C-2 · Broomfield, CO · Accident · No injuries · Limited investigation · Final report · Feb 15, 1998 · N5693M · Substantial damage > water contamination in the fuel, which resulted in loss of engine power and a forced (autorotative) landing. Factors relating to the accident were: darkness; and a high obstruction in the emergency landing area. - [NTSB LAX98FA086](https://openairdocs.org/ntsb/LAX98FA086.md): Beech J35 · Morgan Hill, CA · Accident · 1 fatal · Field investigation · Final report · Feb 11, 1998 · N8343D · 2 aircraft · Destroyed > The pilot-in-command's failure to maintain visual separation from N8343D approaching from his right. The controller's failure to provide a traffic advisory and the copilot's and flight engineer's inadequate visual lookout were factors. - [NTSB ATL98LA037](https://openairdocs.org/ntsb/ATL98LA037.md): Piper PA-38-112 · Deland, FL · Accident · No injuries · Limited investigation · Final report · Feb 8, 1998 · N925IT · Substantial damage > The loss of engine power due to the pilots inadequate fuel management. - [NTSB FTW98LA125](https://openairdocs.org/ntsb/FTW98LA125.md): Piper PA-18-105 · Sheridan, WY · Accident · No injuries · Limited investigation · Final report · Feb 6, 1998 · N316T · Substantial damage > the pilot's improper use of carburetor heat, which resulted in loss of engine power due to carburetor ice. Factors relating to the accident were: the carburetor icing (weather) condition, and the lack of a suitable area for an emergency landing. - [NTSB ANC98LA020](https://openairdocs.org/ntsb/ANC98LA020.md): Piper PA-31-350 · Nome, AK · Accident · No injuries · Limited investigation · Final report · Feb 6, 1998 · N7678L · Substantial damage > The pilot's poor in-flight planning/decision which led to fuel exhaustion and subsequent loss of engine power. - [NTSB FTW98FA121](https://openairdocs.org/ntsb/FTW98FA121.md): Mooney M20E · Angel Fire, NM · Accident · 1 fatal · Field investigation · Final report · Feb 5, 1998 · N9213M · Destroyed > The pilot attempting VFR flight into instrument meteorological conditions and his lack of an instrument rating. Factors were weather conditions that included mountain wave activity conducive to turbulence, and clouds obscuring the mountainous terrain. - [NTSB FTW98FA117](https://openairdocs.org/ntsb/FTW98FA117.md): Piper PA-34-200 · Graford, TX · Accident · 2 fatal · Field investigation · Final report · Feb 4, 1998 · N15566 · Destroyed > The pilot's failure to maintain clearance with the ground. Factors were the dark night, the rising terrain, and the ground fog obscuring the ground. - [NTSB MIA98LA066](https://openairdocs.org/ntsb/MIA98LA066.md): Cessna 152 · Ochopee, FL · Accident · Serious injuries · Limited investigation · Final report · Feb 1, 1998 · N94929 · Substantial damage > partial loss of engine power due to a fractured number 4 exhaust valve, which resulted in a forced landing; and the lack of sufficient airspeed to maneuver over power lines during an attempt to abort (go around from) an emergency landing, which resulted in an… - [NTSB MIA98LA065](https://openairdocs.org/ntsb/MIA98LA065.md): Cessna 172 · Valkaria, FL · Accident · No injuries · Limited investigation · Final report · Jan 31, 1998 · N6261E · Substantial damage > the pilot's inadequate preflight, and subsequent loss of engine power, due to fuel exhaustion, which resulted in a forced landing and impact with trees. - [NTSB MIA98LA063](https://openairdocs.org/ntsb/MIA98LA063.md): Cessna 172N · Valdosta, GA · Accident · No injuries · Limited investigation · Final report · Jan 31, 1998 · N738YK · Substantial damage > The failure of the student to recover (pull-up) from the intentional maneuver resulting in the in-flight collision with terrain. Contributing to the accident was the ostentatious display by the student. - [NTSB SEA98LA031](https://openairdocs.org/ntsb/SEA98LA031.md): Cessna 150F · Havre, MT · Accident · 1 fatal · Limited investigation · Final report · Jan 30, 1998 · N8798G · Substantial damage > The student pilot's loss of control after his failure to maintain airspeed. Factors include his lack of total flight experience and incapacitation due to alcohol. - [NTSB FTW98LA115](https://openairdocs.org/ntsb/FTW98LA115.md): Cessna 182E · Steamboat Sprng, CO · Accident · No injuries · Limited investigation · Final report · Jan 30, 1998 · N2804Y · Substantial damage > The total nonmechanical power loss due to the formation of carburetor ice. A factor was the deep snow covered field on which the forced landing was made. - [NTSB ANC98LA018](https://openairdocs.org/ntsb/ANC98LA018.md): Cessna 208A · Port Heiden, AK · Accident · Minor injuries · Limited investigation · Final report · Jan 30, 1998 · N9316F · Destroyed > The pilot's inadequate in-flight decision resulting in airframe ice accumulation to the extent that degraded aircraft performance and insufficient airspeed occurred followed by a stall. Contributing factors were freezing rain and icing conditions. - [NTSB FTW98LA112](https://openairdocs.org/ntsb/FTW98LA112.md): Piper PA-28R-201T · Lone Grove, OK · Accident · Serious injuries · Limited investigation · Final report · Jan 29, 1998 · N43763 · Substantial damage > The total loss of engine power for an undetermined reason. Factors were the total loss of electrical power resulting from a separated alternator cable due to improper maintenance by unknown maintenance personnel, the lack of suitable terrain for the forced… - [NTSB MIA98FA060](https://openairdocs.org/ntsb/MIA98FA060.md): Fairchild 24G · Andalusia, AL · Accident · 1 fatal · Field investigation · Final report · Jan 28, 1998 · N16866 · Destroyed > A loss of engine power while in cruise flight caused by a contaminated fuel supply and the subsequent inflight collision with trees and unsuitable terrain during the emergency descent and landing. - [NTSB CHI98FA086](https://openairdocs.org/ntsb/CHI98FA086.md): Piper PA-28-160 · Faribault, MN · Accident · 2 fatal · Field investigation · Final report · Jan 26, 1998 · N5099W · Destroyed > was the pilot's patial incapacitation due to carbon monoxide poisoning. A factor associated with this accident was the mechanic's inadequate inspection of the airplane's muffler and inadequate preflight planning and preparation by the pilot. - [NTSB ATL98LA040](https://openairdocs.org/ntsb/ATL98LA040.md): Piper PA-38-112 · Laurens, SC · Accident · Serious injuries · Limited investigation · Final report · Jan 24, 1998 · N2609K · Substantial damage > The pilot's inadequate weather evaluation that resulted in initiating flight in marginal visual conditions, and resulted in fuel exhaustion. - [NTSB SEA98LA028](https://openairdocs.org/ntsb/SEA98LA028.md): Piper PA-24-250 · Sutherlin, OR · Accident · No injuries · Limited investigation · Final report · Jan 23, 1998 · N8422P · Substantial damage > Loss of engine power for an undetermined reason. - [NTSB FTW98TA104](https://openairdocs.org/ntsb/FTW98TA104.md): Hughes 269C · Brackettville, TX · Accident · Minor injuries · Final report · Jan 22, 1998 · N1093N · Substantial damage > failure of splines on the drive shaft coupling after separation of the forward bubber boot and loss of lubrication (grease), which resulted in a disconnect of the rotor drive system and an autorotation/forced landing. Lack of suitable terrain in the forced… - [NTSB ATL98FA036](https://openairdocs.org/ntsb/ATL98FA036.md): Twin Commander Acft. 695A · Delray Beach, FL · Accident · 3 fatal · Field investigation · Final report · Jan 21, 1998 · N269M · Destroyed > The pilot flew into known convective meterological conditions and lost control of the airplane. Factors were low clouds, and moderate to heavy rain. - [NTSB CHI98LA081](https://openairdocs.org/ntsb/CHI98LA081.md): Piper PA-28RT-201T · Naperville, IL · Accident · Serious injuries · Limited investigation · Final report · Jan 19, 1998 · N8277W · Destroyed > improper preflight planning and preparation by the pilot which resulted in fuel exhaustion. - [NTSB LAX98FA075](https://openairdocs.org/ntsb/LAX98FA075.md): Cessna 402C · Walker, CA · Accident · 1 fatal · Field investigation · Final report · Jan 17, 1998 · N114GP · Destroyed > The pilot's encounter with a downdraft while approaching high terrain at an altitude insufficient to ensure adequate terrain or obstacle clearance. - [NTSB ATL98LA032](https://openairdocs.org/ntsb/ATL98LA032.md): Via Aero Comp AC6 · Rockledge, FL · Accident · 2 fatal · Limited investigation · Final report · Jan 17, 1998 · N656AC · Destroyed > The loss of engine power for undetermined reasons. A factor was the trees in the emergency landing area. - [NTSB ATL98LA031](https://openairdocs.org/ntsb/ATL98LA031.md): Christopher Coats Challenger II · Evergreen, AL · Accident · No injuries · Limited investigation · Final report · Jan 17, 1998 · N132BC · Substantial damage > The undetermined failure of the propeller bolts that resulted in the inflight separation of the propeller assembly. A factor was the overpass bridge. - [NTSB LAX98FA068](https://openairdocs.org/ntsb/LAX98FA068.md): Cessna 182P · Salinas, CA · Accident · 1 fatal · Field investigation · Final report · Jan 10, 1998 · N8158M · Destroyed > A loss of engine power due to a missing valve keeper. Also causal was the failure by engine maintenance personnel during engine top overhaul to install the second valve keeper in the No. 3 cylinder exhaust valve and the failure of inspection personnel to… - [NTSB FTW98FA092](https://openairdocs.org/ntsb/FTW98FA092.md): Aero Commander 500-B · Ennis, TX · Accident · 2 fatal · Field investigation · Final report · Jan 10, 1998 · N556BW · Destroyed > failure of the flight crew to maintain minimum control speed (Vmc) during go-around from a single-engine approach, which resulted in loss of control and collision with power lines and the ground. Related factors were: a ruptured diaphragm in the distributor… - [NTSB FTW98LA091](https://openairdocs.org/ntsb/FTW98LA091.md): Cessna 152 · Boyd, TX · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 1998 · N757CH · Substantial damage > loss of engine power resulting from the pilot's delayed use of carburetor heat during serious carburetor icing conditions. Factors were: the lack of suitable terrain for the forced landing and an evasive maneuver which led to an inadvertent stall. - [NTSB FTW98FA089](https://openairdocs.org/ntsb/FTW98FA089.md): Cameron R-420 · Yeso, NM · Accident · Serious injuries · Field investigation · Final report · Jan 9, 1998 · N298AR · Destroyed > The rupture of the gas cell bottom (diaphragm) due to inadequate manufacturer's design and inadequate manufacturing quality control. A factor was the flight crew's performance of an emergency bailout which allowed the balloon to drift unattended for… - [NTSB FTW98FA088](https://openairdocs.org/ntsb/FTW98FA088.md): Mooney M20K · Vernon, TX · Accident · 2 fatal · Field investigation · Final report · Jan 7, 1998 · N231DS · Destroyed > the loss of control during cruise flight for undetermined reasons. - [NTSB CHI98FA080](https://openairdocs.org/ntsb/CHI98FA080.md): Cessna P210N · Decatur, IL · Accident · 1 fatal · Field investigation · Final report · Jan 7, 1998 · N6669P · Destroyed > The pilot's failure to maintain control of the airplane. Contributing factors were low ceiling and freezing drizzle. - [NTSB MIA98LA054](https://openairdocs.org/ntsb/MIA98LA054.md): Boeing 757-232 · Orlando, FL · Accident · Serious injuries · Limited investigation · Final report · Jan 6, 1998 · N618DL · No damage > inadvertent encounter with turbulence, which resulted spillage of hot coffee in a passenger's lap. - [NTSB FTW98FA086](https://openairdocs.org/ntsb/FTW98FA086.md): Piper PA-38-112 · Tremonton, UT · Accident · 1 fatal · Field investigation · Final report · Jan 4, 1998 · N23371 · Destroyed > The pilot's continued VFR flight into instrument meteorological conditions, becoming spatially disoriented and his subsequent loss of aircraft control. Factors were the dark night and weather conditions that included obscuration and snow. - [NTSB LAX98FA066](https://openairdocs.org/ntsb/LAX98FA066.md): Cessna 172M · Chandler, AZ · Accident · 2 fatal · Field investigation · Final report · Jan 2, 1998 · N20118 · Destroyed > The pilot's intentional flying at a low altitude and failure to see and avoid the power lines during dusk conditions. - [NTSB MIA98FA047](https://openairdocs.org/ntsb/MIA98FA047.md): Cessna 414A · Guyton, GA · Accident · 2 fatal · Field investigation · Final report · Dec 29, 1997 · N414MT · Destroyed > Inadequate maintenance of the cabin pressurization system, which resulted in inadequate pressurization and incapacitation of the pilot due to the hypoxia. Also causal was the pilot's failure to adequately monitor the cabin pressurization system. - [NTSB NYC98LA056](https://openairdocs.org/ntsb/NYC98LA056.md): Mooney M20F · Ferncliff, VA · Accident · Minor injuries · Limited investigation · Final report · Dec 28, 1997 · N9717M · Destroyed > the improper installation of the engine oil temperature probe which resulted in oil starvation and a total loss of engine power. A factor in the accident was the pilot's overflight of available airports in an effort to reach the 'Nearest Airport' displayed on… - [NTSB FTW98LA078](https://openairdocs.org/ntsb/FTW98LA078.md): Beech 35 · Springdale, AR · Accident · No injuries · Limited investigation · Final report · Dec 28, 1997 · N2815V · Substantial damage > The fuel exhaustion due to the pilot's failure to refuel and his inadequate pre-flight planning. Factors were the pilot's disorientation due to instrument meteorological conditions. Another factor, was the lack of suitable terrain for the pilot to execute a… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=196 ## 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=195 --- 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.