# 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 152 of 718 · 35,885 cases ## Cases, newest first - [NTSB CHI03LA052](https://openairdocs.org/ntsb/CHI03LA052.md): Havir Avid Flyer · Cambridge, NE · Accident · 1 fatal · Limited investigation · Final report · Jan 13, 2003 · N248H · Destroyed > The inadvertent stall by the pilot following a total loss of engine power and the seizure of the engine. A factor to the accident was the engine overhaul not performed in accordance with the manufacturer's recommendations. - [NTSB SEA03FA025](https://openairdocs.org/ntsb/SEA03FA025.md): Mooney M20F · Tacoma, WA · Accident · No injuries · Field investigation · Final report · Jan 12, 2003 · N6442Q · Substantial damage > A loss of engine power during cruise flight due to fatigue failure of the crankshaft as a result of an inadequate quality of material during the manufacturing process. Trees were a factor. - [NTSB LAX03IA098](https://openairdocs.org/ntsb/LAX03IA098.md): Boeing 717-200 · Kahului, HI · Incident · No injuries · Incident investigation · Final report · Jan 12, 2003 · N482HA · No damage > the flight crew's failure to follow the checklist and detect an out of trim condition prior to takeoff. - [NTSB LAX03FA066](https://openairdocs.org/ntsb/LAX03FA066.md): Cessna 182H · Parker, AZ · Accident · 2 fatal · Field investigation · Final report · Jan 11, 2003 · N8567S · 2 aircraft · Destroyed > failure of both pilot's to see and avoid one another while maneuvering in the traffic pattern. A factor in the accident was the inability of the Cessna pilot to communicate on the CTAF frequency due to the limitations of his radios. - [NTSB LAX03FA065](https://openairdocs.org/ntsb/LAX03FA065.md): Piper PA-34-200 · Westlake Villag, CA · Accident · Serious injuries · Field investigation · Final report · Jan 11, 2003 · N56484 · Destroyed > a fatigue crack in the propeller hub due to the inadequate design location of the grease fitting and the chamfering process. - [NTSB DEN03IA033](https://openairdocs.org/ntsb/DEN03IA033.md): Boeing 757-222 · Salt Lake City, UT · Incident · No injuries · Incident investigation · Final report · Jan 11, 2003 · N551UA · Minor damage > the arcing wires in the lavatory sensor that resulted in the subsequent fire. - [NTSB FTW03LA081](https://openairdocs.org/ntsb/FTW03LA081.md): Aerospatiale AS-350-BA · Venice, LA · Accident · Minor injuries · Limited investigation · Final report · Jan 9, 2003 · N22TV · Destroyed > The loss of tail rotor drive as a result of baggage coming in contact with the tail rotor blades after the aft cargo door was not secured. A contributing factor was the passenger's failure to follow the procedures for properly securing the helicopter's doors… - [NTSB FTW03LA080](https://openairdocs.org/ntsb/FTW03LA080.md): Bell 206B · Putnam, TX · Accident · Serious injuries · Limited investigation · Final report · Jan 9, 2003 · N115TV · Substantial damage > the pilot's failure to properly interpret and confirm a faulty tachometer instrument indication and his improper flare during the ensuing precautionary autorotation, which resulted in a hard landing. Also causal was the failure of the tachometer. - [NTSB LAX03FA069](https://openairdocs.org/ntsb/LAX03FA069.md): Piper PA-23-250 · Flagstaff, AZ · Accident · 4 fatal · Field investigation · Final report · Jan 8, 2003 · N135LA · Destroyed > the pilot's failure to comply with his instrument clearance route instruction and to maintain his assigned altitude. A factor in the accident was the poor quality of radio communications due to the severance of underground fiber optic voice and data lines for… - [NTSB FTW03LA077](https://openairdocs.org/ntsb/FTW03LA077.md): Carlisle Comp Air 6 · Groesbeck, TX · Accident · No injuries · Limited investigation · Final report · Jan 8, 2003 · N628 · Substantial damage > The pilot's improper fuel selector position which resulted in the loss of engine power due to fuel starvation. A contributing factor was the soft terrain for the forced landing. - [NTSB CHI03LA049](https://openairdocs.org/ntsb/CHI03LA049.md): Cessna 150J · Garner, IA · Accident · No injuries · Limited investigation · Final report · Jan 8, 2003 · N60834 · Substantial damage > The students pilots improper in-flight fuel planning resulting in exhaustion of the fuel supply, and the collapse of the nose gear during the forced landing. Factors were unsuitable landing are encountered by the pilot, the plowed field and the fuel… - [NTSB CHI03FA047](https://openairdocs.org/ntsb/CHI03FA047.md): Piper PA-23-250 · Barrington Hill, IL · Accident · No injuries · Field investigation · Final report · Jan 7, 2003 · N74AA · Substantial damage > The pilot's improper fuel management, which resulted in fuel starvation. An inadequate preflight inspection and the trees encountered during the forced landing were contributing factors. - [NTSB LAX03LA059](https://openairdocs.org/ntsb/LAX03LA059.md): Farmer R B DA5-A · Apple Valley, CA · Accident · Serious injuries · Limited investigation · Final report · Jan 4, 2003 · N7053U · Substantial damage > the detonation of the number 1 and 3 cylinders and the subsequent over temperature of those cylinders and their corresponding pistons. - [NTSB LAX03FA060](https://openairdocs.org/ntsb/LAX03FA060.md): Schweizer 269C · Collinsville, CA · Accident · 1 fatal · Field investigation · Final report · Jan 4, 2003 · N98TH · Destroyed > A loss of engine power for undetermined reasons, and the pilot's failure to maintain main rotor rpm during the subsequent autorotation. A factor in the accident was the unsuitable nature of the terrain for a forced landing. - [NTSB FTW03LA075](https://openairdocs.org/ntsb/FTW03LA075.md): Cessna 401 · Mc Allen, TX · Accident · No injuries · Limited investigation · Final report · Jan 4, 2003 · N968JW · Substantial damage > The pilot's failure to manually extend the landing gear to the full down and locked position. A contributing faction was a loss of electrical power, which resulted in the failure of the landing gear to extend. - [NTSB MIA03LA044](https://openairdocs.org/ntsb/MIA03LA044.md): Cessna 150K · Jessup, GA · Accident · No injuries · Limited investigation · Final report · Jan 3, 2003 · N6098G · Substantial damage > The loss of engine power for undetermined reasons. A contributing factor was unsuitable terrain. - [NTSB ATL03LA029](https://openairdocs.org/ntsb/ATL03LA029.md): Mielec PZL-M-18 · Immokalee, FL · Accident · No injuries · Limited investigation · Final report · Jan 3, 2003 · N45051 · Substantial damage > The pilot's inadequate in-flight planning/decision by his improper fuel management which resulted in fuel starvation. Also causal was the pilot's inadequate preflight planning which resulted in his failure to perform fuel consumption calculations and… - [NTSB SEA03LA023](https://openairdocs.org/ntsb/SEA03LA023.md): Bell 47G · Idaho Falls, ID · Accident · No injuries · Limited investigation · Final report · Jan 2, 2003 · N4759R · Substantial damage > In-flight loss of engine power for undetermined reasons. - [NTSB DEN03LA027](https://openairdocs.org/ntsb/DEN03LA027.md): Aircraft Mfg & Dev. CH2000 · Milford, UT · Accident · Serious injuries · Limited investigation · Final report · Jan 2, 2003 · N8500R · Destroyed > the inadequate altitude chosen by the flight instructor, resulting in inadequate clearance and subsequent collision with mountainous terrain. Contributing factors were the instructor's failure to consult pertinent VFR sectional charts for the area, and the… - [NTSB MIA03LA035](https://openairdocs.org/ntsb/MIA03LA035.md): Lonnie Johnson RV6A · Peachtree City, GA · Accident · Minor injuries · Limited investigation · Final report · Jan 1, 2003 · N559LJ · Substantial damage > The failure of the pilot to activate carburetor heat control during cruise flight after experiencing a loss of engine rpm, inadequate carburetor heat system by the builder, and the unsuitable terrain encountered by the pilot-in-command during the forced… - [NTSB ATL03FA030](https://openairdocs.org/ntsb/ATL03FA030.md): Piper PA-28-180 · Austell, GA · Accident · Serious injuries · Field investigation · Final report · Dec 31, 2002 · N5118G · Substantial damage > The pilot's inadequate preflight and in-flight planning/decision that resulted in fuel exhaustion, and subsequent loss of engine power. - [NTSB LAX03LA056](https://openairdocs.org/ntsb/LAX03LA056.md): Nicholson Lancair 320 · Corona, CA · Accident · No injuries · Limited investigation · Final report · Dec 30, 2002 · N364M · Substantial damage > The pilot/builder's improper maintenance procedure for reattaching a high-pressure oil line, which resulted in the oil line disconnecting during flight, followed by a loss of oil and engine seizure. - [NTSB FTW03LA070](https://openairdocs.org/ntsb/FTW03LA070.md): Cessna T207 · Brownsville, TX · Accident · No injuries · Limited investigation · Final report · Dec 30, 2002 · N1599U · Substantial damage > The loss of engine power due to the separation of the crankshaft. A factor was the lack of suitable terrain for the forced landing. - [NTSB DEN03FA028](https://openairdocs.org/ntsb/DEN03FA028.md): Piper PA-32-300 · Steamboat Spgs, CO · Accident · 1 fatal · Field investigation · Final report · Dec 29, 2002 · N7989C · Destroyed > the pilot's inadequate in-flight planning/decision making resulting in insufficient altitude to fly over the mountain, and the subsequent inadvertent stall/mush into tree covered mountainous terrain. Contributing factors were the tail wind and high density… - [NTSB ANC03LA021](https://openairdocs.org/ntsb/ANC03LA021.md): de Havilland DHC-3 · Nikolai, AK · Accident · No injuries · Limited investigation · Final report · Dec 28, 2002 · N3904 · Substantial damage > An improper and undocumented major repair of the elevator torque tube support assembly by an unknown person, which resulted in an in-flight disconnection of the airplane's right elevator, and a jammed rudder. A factor associated with the accident is the… - [NTSB DEN03FA025](https://openairdocs.org/ntsb/DEN03FA025.md): Cessna 421 · Akron, CO · Accident · 2 fatal · Field investigation · Final report · Dec 25, 2002 · N421D · Destroyed > The fractured connecting rods and the pilot not maintaining aircraft control following the engine failure. Factors contributing to the accident were the low altitude, the pilot not maintaining minimum controllable airspeed following the engine failure, the… - [NTSB ATL03LA031](https://openairdocs.org/ntsb/ATL03LA031.md): Beech F-35 · Hollywood, FL · Accident · No injuries · Limited investigation · Final report · Dec 25, 2002 · N4268B · Substantial damage > The pilot exceeded the design limits of the airplane which resulted in an in flight structural failure. - [NTSB SEA03LA021](https://openairdocs.org/ntsb/SEA03LA021.md): Hughes 369D · Boise, ID · Accident · No injuries · Limited investigation · Final report · Dec 24, 2002 · N8366F · Substantial damage > The failure of the operator's maintenance personnel to properly rig the left/right seat twistgrip throttles to the engine fuel control, the pilot in command's failure to adhere to the rotorcraft flight manual, and the check pilot's premature flare during the… - [NTSB LAX03FA054](https://openairdocs.org/ntsb/LAX03FA054.md): Robinson R22 Beta · Dolan Springs, AZ · Accident · 2 fatal · Field investigation · Final report · Dec 23, 2002 · N888KB · Destroyed > the pilot's inadequate visual lookout and failure to maintain clearance from power lines. A factor was the pilot's decision to conduct cruise flight at a low altitude. - [NTSB FTW03LA066](https://openairdocs.org/ntsb/FTW03LA066.md): Hughes 369E · Fritch, TX · Accident · No injuries · Limited investigation · Final report · Dec 22, 2002 · N5234Y · Substantial damage > The loss of engine power due to the failure of the generator input drive-end bearing, which resulted in excessive vibrations that induced a fatigue fracture of the Pc line leading to the engine fuel control unit. A contributing factor was the lack of suitable… - [NTSB CHI03LA043](https://openairdocs.org/ntsb/CHI03LA043.md): Piper PA-28-235 · Carleton, MI · Accident · No injuries · Limited investigation · Final report · Dec 22, 2002 · N8555W · Substantial damage > The #2 cylinder exhaust valve failed due to undetermined reasons. A factor associated with the accident was the soft terrain encountered during the forced landing. - [NTSB IAD03FA024](https://openairdocs.org/ntsb/IAD03FA024.md): Piper PA-32R-301T · Woodbury, CT · Accident · 2 fatal · Field investigation · Final report · Dec 21, 2002 · N8168G · Destroyed > An engine fire for undetermined reasons, which resulted in the pilot's loss of control, and the airplane's subsequent impact with terrain. - [NTSB ATL03FA025](https://openairdocs.org/ntsb/ATL03FA025.md): Piper PA-32-300 · Macon, GA · Accident · 4 fatal · Field investigation · Final report · Dec 21, 2002 · N47420 · Destroyed > The loss of engine power due to oil starvation. - [NTSB FTW03LA061](https://openairdocs.org/ntsb/FTW03LA061.md): Creekmore Team Rocket F-1 · Rosenberg, TX · Accident · 1 fatal · Limited investigation · Final report · Dec 20, 2002 · N140TC · Destroyed > The in-flight separation of the vertical stabilizer as a result of the builder's failure to install the upper attachment fitting for the vertical fin aft spar. - [NTSB CHI03LA044](https://openairdocs.org/ntsb/CHI03LA044.md): Piper PA-28-180 · Osage Beach, MO · Accident · Minor injuries · Limited investigation · Final report · Dec 20, 2002 · N3236Y · Substantial damage > Fuel Starvation due to the failure of the mechanical fuel pump and the inoperable electric fuel pump caused by the electrical system failure. Factors were the unsuitable terrain and the trees. - [NTSB SEA03LA019](https://openairdocs.org/ntsb/SEA03LA019.md): Eurocopter Deutschland EC-135 P1 · Loon Lake, WA · Accident · No injuries · Limited investigation · Final report · Dec 18, 2002 · N311MS · Substantial damage > The pilot's inadvertent flight into instrument meteorological conditions (IMC) while in cruise flight, and an excessive descent rate. Factors include falling snow, whiteout conditions and dark night conditions. - [NTSB MIA03LA028](https://openairdocs.org/ntsb/MIA03LA028.md): Beech A36 · Laurens, SC · Accident · No injuries · Limited investigation · Final report · Dec 15, 2002 · N12MB · Substantial damage > Improper maintenance and inspection of the airplane by other maintenance personnel, and their failure to install the fuel line support after maintenance had been completed, which resulted in the introduction of vibrational loads and the in-flight separation… - [NTSB MIA03LA033](https://openairdocs.org/ntsb/MIA03LA033.md): Beech 200 · Jacksonville, FL · Accident · No injuries · Limited investigation · Final report · Dec 14, 2002 · N623VP · Substantial damage > Failure of the main landing gear locking mechanism for undetermined reasons, which resulted in the main landing gear collapsing, and damage to the airplane during landing. - [NTSB MIA03LA029](https://openairdocs.org/ntsb/MIA03LA029.md): Piper PA-28-150 · Cashiers, NC · Accident · Minor injuries · Limited investigation · Final report · Dec 14, 2002 · N5899W · Substantial damage > The pilot's inadequate in-flight decision by which he conducted visual flight into instrument meteorological conditions and his failure to maintain terrain clearance. Contributing factors were a low ceiling and mountainous terrain. - [NTSB FTW03LA060](https://openairdocs.org/ntsb/FTW03LA060.md): Piper PA-28-235 · Bryson, TX · Accident · No injuries · Limited investigation · Final report · Dec 14, 2002 · N8925W · Substantial damage > the pilot's inadequate inflight planning and decision which resulted in a loss of engine power due to fuel exhaustion. The pilot's failure to refuel the airplane and dark night conditions were contributing factors. - [NTSB MIA03FA024](https://openairdocs.org/ntsb/MIA03FA024.md): Aaa Aircraft Leasing 192 · Miami, FL · Accident · 2 fatal · Field investigation · Final report · Dec 6, 2002 · N192FW · Destroyed > The inflight fire of undetermined origin, which resulted in pilot incapacitation, loss of aircraft control and an inflight collision with a building. - [NTSB DEN03FA023](https://openairdocs.org/ntsb/DEN03FA023.md): Rockwell Commander 114 · Hot Springs, AR · Accident · 1 fatal · Field investigation · Final report · Dec 6, 2002 · N314M · Destroyed > the loss of engine power due to the failure of the engine ignition system's single-drive dual-magneto, and the magneto's improper installation by unknown maintenance personnel. Contributing factors were the improper installation of the magneto by unknown… - [NTSB CHI03IA033](https://openairdocs.org/ntsb/CHI03IA033.md): Hughes OH-6 · Moberly, MO · Incident · No injuries · Incident investigation · Final report · Dec 5, 2002 · N353RK · Minor damage > The loss of tail rotor effectiveness during cruise flight due to the bellcrank pivot pin becoming separated from the non-rotational swashplate. The plain brass liner of the non-rotating swashplate and the bellcrank pivot pin were worn. - [NTSB SEA03LA016](https://openairdocs.org/ntsb/SEA03LA016.md): Luscombe 8A · Tekoa, WA · Accident · Serious injuries · Limited investigation · Final report · Dec 4, 2002 · C-FIIF · Substantial damage > The pilot's failure to maintain clearance from the terrain while attempting to fly a non-IFR equipped aircraft solely by reference to its instruments after the aircraft's windshield became coated with freezing rain in cruise flight. A factor was the pilot's… - [NTSB NYC03LA028](https://openairdocs.org/ntsb/NYC03LA028.md): Ercoupe 415-CD · Dalton, MA · Accident · No injuries · Limited investigation · Final report · Dec 4, 2002 · C-FXJK · Substantial damage > The pilot's inadequate preflight inspection of the aircraft, which resulted in a total loss of engine power due to fuel contamination. A factor was the cold air temperature. - [NTSB FTW03FA055](https://openairdocs.org/ntsb/FTW03FA055.md): Cessna 421C · Tajique, NM · Accident · 1 fatal · Field investigation · Final report · Dec 4, 2002 · N3855C · Destroyed > The pilot's failure to maintain terrain clearance. Factors contributing to the accident were the high mountains, mountain obscuration, the dark night condition, and the pilot's improper in-flight planning/decision making. - [NTSB MIA03LA023](https://openairdocs.org/ntsb/MIA03LA023.md): Beech 35-B33 · Gainesville, GA · Accident · Minor injuries · Limited investigation · Final report · Dec 3, 2002 · N8578M · Substantial damage > a loss of engine power for undetermined reason resulting in damage to the airplane during the subsequent forced landing. - [NTSB FTW03LA056](https://openairdocs.org/ntsb/FTW03LA056.md): Cessna 172M · Vici, OK · Accident · No injuries · Limited investigation · Final report · Dec 3, 2002 · N4470R · Substantial damage > The pilot's departure and continued flight into adverse weather conditions. Contributing factors were the icing conditions, and the lack of suitable terrain for the precautionary landing. - [NTSB SEA03FA015](https://openairdocs.org/ntsb/SEA03FA015.md): Caron Seawind · Bryant, WA · Accident · 2 fatal · Field investigation · Final report · Nov 30, 2002 · N313FC · Destroyed > A loss of engine power for undetermined reasons and the failure of the flying pilot to maintain flying speed resulting in an inadvertent stall, loss of control and subsequent collision with terrain. - [NTSB SEA03TA014](https://openairdocs.org/ntsb/SEA03TA014.md): Hughes OH-6A · Snohomish, WA · Accident · No injuries · Final report · Nov 29, 2002 · N13SD · Substantial damage > Loss of engine power for undetermined reasons while in cruise flight. A tree was a factor. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=153 ## 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=152 --- 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.