# 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 56 of 718 · 35,883 cases ## Cases, newest first - [NTSB ERA18WA274](https://openairdocs.org/ntsb/ERA18WA274.md): Piper PA28 · Nafpaktos, Greece · Accident · 2 fatal · Foreign investigation · Apr 21, 2018 · SX-SEX · Substantial damage > The government of Greece has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on April 21, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Greece's investigation under the provisions of… - [NTSB GAA18CA233](https://openairdocs.org/ntsb/GAA18CA233.md): Mooney M20F · Bulberde, TX · Accident · No injuries · Data collection · Final report · Apr 19, 2018 · N3535X · Substantial damage > The pilot’s unstabilized approach, which resulted in the airplane landing long and fast, and the pilot’s subsequent decision to steer the airplane off the side of the runway to avoid a runway overrun. - [NTSB WPR18TA122](https://openairdocs.org/ntsb/WPR18TA122.md): Wilhelm Puslar · Salton City, CA · Accident · Minor injuries · Class 3 · Final report · Apr 18, 2018 · N332RP · Substantial damage > The pilot's improper fuel management, which resulted in a total loss of engine power due to fuel starvation. Contributing to the accident was the pilot's failure to perform the loss of engine power emergency procedures, which likely would have restored engine… - [NTSB DCA18WA155](https://openairdocs.org/ntsb/DCA18WA155.md): Boeing 737 · Mexico · Incident · No injuries · Foreign investigation · Apr 18, 2018 · XA-UQA · No damage > The government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of… - [NTSB DCA18WA149](https://openairdocs.org/ntsb/DCA18WA149.md): Boeing 737 500 · Cuzco, Peru · Incident · No injuries · Foreign investigation · Apr 18, 2018 · N240AT · No damage > The government of Peru has notified the NTSB of an incident involving a BOEING 737 500 airplane that occurred on April 18, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Peru's investigation under the provisions of… - [NTSB ERA18WA173](https://openairdocs.org/ntsb/ERA18WA173.md): Bell Helicopter 407 · Nova Esperanca, Brazil · Accident · No injuries · Foreign investigation · Apr 17, 2018 · PT-YZJ · Substantial damage > The government of Brazil has notified the NTSB of an accident involving a BELL 407 helicopter that occurred on April 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions of… - [NTSB DCA18MA142](https://openairdocs.org/ntsb/DCA18MA142.md): Boeing 737 7H4 · Philadelphia, PA · Accident · 1 fatal · Class 1 · Major · Final report · Apr 17, 2018 · N772SW · Substantial damage > A low-cycle fatigue crack in the dovetail of fan blade No. 13, which resulted in the fan blade separating in flight and impacting the engine fan case at a location that was critical to the structural integrity and performance of the fan cowl structure. This… - [NTSB ERA18FA127](https://openairdocs.org/ntsb/ERA18FA127.md): Cessna 525 · Crozet, VA · Accident · 1 fatal · Field investigation · Final report · Apr 16, 2018 · N525P · Destroyed > The pilot's loss of control while operating in night instrument meteorological conditions as a result of spatial disorientation. Contributing to the accident was the pilot's decision to operate an airplane after consuming alcohol and his resulting… - [NTSB CEN18FA143](https://openairdocs.org/ntsb/CEN18FA143.md): Beech G33 · Warsaw, OH · Accident · 2 fatal · Field investigation · Final report · Apr 16, 2018 · N9345Q · Substantial damage > The pilot's decision to continue flight in known icing conditions, which resulted in structural icing, degraded airplane performance, and a subsequent loss of control. Contributing to the accident was the pilot's failure to obtain an official weather briefing… - [NTSB CEN18FA140](https://openairdocs.org/ntsb/CEN18FA140.md): Bordiuk Challenger II · Friona, TX · Accident · 2 fatal · Field investigation · Final report · Apr 16, 2018 · N635DT · Substantial damage > An in-flight impact with terrain for reasons that could not be determined due to a lack of evidence. - [NTSB CEN18LA142](https://openairdocs.org/ntsb/CEN18LA142.md): Cessna T210N · Colorado Springs, CO · Accident · Minor injuries · Limited investigation · Final report · Apr 15, 2018 · N6988N · Substantial damage > The pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation. - [NTSB CEN18FA139](https://openairdocs.org/ntsb/CEN18FA139.md): Wittman W10 · San Antonio, TX · Accident · 1 fatal · Field investigation · Final report · Apr 15, 2018 · N625JS · Destroyed > An in-flight fire and subsequent total loss of engine power for reasons that could not be determined due to extensive impact and fire damage, followed by a loss of airplane control. - [NTSB WPR18LA120](https://openairdocs.org/ntsb/WPR18LA120.md): Zenith Stol CH750 · Kernville, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Apr 14, 2018 · N830AZ · Substantial damage > A total loss of engine power due to air or fuel vapor entering the fuel system, which prevented fuel from reaching the engine cylinders, which necessitated an emergency landing, during which the airplane nosed over. - [NTSB ERA18FA128](https://openairdocs.org/ntsb/ERA18FA128.md): S.Z.D. SZD 48 Jantar STD 2 · LaBelle, FL · Accident · 1 fatal · Field investigation · Final report · Apr 14, 2018 · N456RM · Substantial damage > The pilot's failure to maintain control of the glider for reasons that could not be determined based on the available evidence. - [NTSB DCA18WA151](https://openairdocs.org/ntsb/DCA18WA151.md): Boeing 737 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Apr 12, 2018 · XA-UZW · No damage > The government of Mexico has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 12, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions of… - [NTSB DCA18WA157](https://openairdocs.org/ntsb/DCA18WA157.md): Boeing 737 · Lahore, Pakistan · Incident · No injuries · Foreign investigation · Apr 11, 2018 · AP-BMU · Minor damage > The Pakistan Safety Investigation Board has notified the NTSB of an incident involving a BOEING 737 airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Pakistan's investigation under… - [NTSB DCA18WA154](https://openairdocs.org/ntsb/DCA18WA154.md): Embraer S A ERJ170-200LR · Mexico · Incident · No injuries · Foreign investigation · Apr 11, 2018 · N89313 · Minor damage > The government of Mexico has notified the NTSB of an incident involving a EMBRAER S A ERJ170-200LR airplane that occurred on April 11, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the… - [NTSB ANC18LA031](https://openairdocs.org/ntsb/ANC18LA031.md): Cessna 208B · Atqasuk, AK · Accident · Minor injuries · Limited investigation · Final report · Apr 11, 2018 · N814GV · Substantial damage > The pilot's decision to continue a visual flight rules flight into an area of instrument meteorological conditions and his subsequent failure to level the airplane after the autopilot disconnected, which resulted in a collision with terrain. - [NTSB ERA18WA130](https://openairdocs.org/ntsb/ERA18WA130.md): Beech 58 · Tucuman, Argentina · Accident · 4 fatal · Foreign investigation · Apr 10, 2018 · N6926Z · Destroyed - [NTSB DCA18WA153](https://openairdocs.org/ntsb/DCA18WA153.md): Airbus A319 115 · Mexico · Incident · No injuries · Foreign investigation · Apr 10, 2018 · N70020 · No damage > The government of Mexico has notified the NTSB of an incident involving a AIRBUS A319 115 airplane that occurred on April 10, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's investigation under the provisions… - [NTSB ERA18WA131](https://openairdocs.org/ntsb/ERA18WA131.md): Piper PA34-200T · La Pampa, Argentina · Accident · No injuries · Foreign investigation · Apr 8, 2018 · LV-GZK · Destroyed - [NTSB ERA18LA124](https://openairdocs.org/ntsb/ERA18LA124.md): Cirrus SR22 · Lowville, NY · Accident · No injuries · Limited investigation · Final report · Apr 8, 2018 · C-GMDQ · Substantial damage > The pilot's diverted attention, which resulted in his inadequate monitoring of the airplane's attitude and a loss of control in flight. - [NTSB DCA18WA130](https://openairdocs.org/ntsb/DCA18WA130.md): Boeing 737 · Rio de Janeiro, Brazil · Incident · No injuries · Foreign investigation · Apr 6, 2018 · PR-GGE · No damage > The government of Brazil has notified the NTSB of an serious incident involving a BOEING 737 airplane that occurred on April 06, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the… - [NTSB CEN18WA402](https://openairdocs.org/ntsb/CEN18WA402.md): Rotorway Exec · Crestet, France · Accident · 1 fatal · Foreign investigation · Apr 5, 2018 · F-PFBJ · Destroyed > The government of France has notified the NTSB of an accident involving an amateur-built ROTORWAY EXEC helicopter that occurred on April 05, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of France's investigation under… - [NTSB CEN18FA266](https://openairdocs.org/ntsb/CEN18FA266.md): Cessna 210 · Alma, CO · Accident · 1 fatal · Field investigation · Final report · Apr 2, 2018 · N68640 · Substantial damage > The noncertificated pilot's poor decision to depart on a flight over mountainous terrain in an improperly maintained airplane, and the subsequent encounter with mountain wave turbulence, which resulted in the loss of airplane control and impact with terrain.… - [NTSB ERA18WA123](https://openairdocs.org/ntsb/ERA18WA123.md): Robinson R44 · Rosario, Brazil · Accident · 4 fatal · Foreign investigation · Apr 1, 2018 · PP-WVR · Substantial damage - [NTSB ERA18LA119](https://openairdocs.org/ntsb/ERA18LA119.md): Ames Angier M LNC2 · Atlantic Ocean (Atlantic Ocean) · Accident · 2 fatal · Limited investigation · Final report · Mar 31, 2018 · N4ZQ · Substantial damage > The pilot's spatial disorientation after entering instrument meteorological conditions and encountering moderate-to-heavy precipitation, which resulted in a loss of airplane control. - [NTSB CEN18LA131](https://openairdocs.org/ntsb/CEN18LA131.md): Cessna 180 · Grove, OK · Accident · Minor injuries · Limited investigation · Final report · Mar 31, 2018 · N2485C · Substantial damage > A total loss of engine power due to carburetor ice accumulation. Contributing to the accident was the pilot’s failure to apply carburetor heat immediately following the loss of engine power. - [NTSB DCA18WA124](https://openairdocs.org/ntsb/DCA18WA124.md): Boeing 757 · Mexico City, Mexico · Incident · No injuries · Foreign investigation · Mar 29, 2018 · HP1910DAE · No damage > The Direccion General de Aeronautica Civil (DGAC) of Mexico has notified the NTSB of an incident involving a BOEING 757 airplane that occurred on March 29, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Mexico's… - [NTSB ERA18FA118](https://openairdocs.org/ntsb/ERA18FA118.md): Cessna R182 · Ashville, AL · Accident · 1 fatal · Field investigation · Final report · Mar 28, 2018 · N3167C · Destroyed > Descent and impact with terrain for reasons that could not be determined. - [NTSB ERA18FA114](https://openairdocs.org/ntsb/ERA18FA114.md): Beech V35 · Hydro, OK · Accident · 2 fatal · Field investigation · Final report · Mar 26, 2018 · N7019N · Destroyed > The pilot's decision to continue the night visual flight rules flight into instrument meteorological conditions, which resulted in a loss of control due to spatial disorientation. Contributing was the pilot's lack of instrument/night currency, and his failure… - [NTSB CEN18LA127](https://openairdocs.org/ntsb/CEN18LA127.md): MX MXS · Fulton, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 25, 2018 · N540JH · Substantial damage > A total loss of engine power due to the fatigue failure of the crankshaft, which resulted in the pilot’s forced landing to an abandoned airport and the airplane’s subsequent impact with debris on the runway. - [NTSB ERA18LA113](https://openairdocs.org/ntsb/ERA18LA113.md): Fairchild Funk M62C F 23A · Columbia, TN · Accident · No injuries · Limited investigation · Final report · Mar 23, 2018 · N1131Z · Substantial damage > The pilot's inadvertent selection of the fuel selector handle to the off position, which resulted in fuel starvation and a total loss of engine power. - [NTSB ERA18LA112](https://openairdocs.org/ntsb/ERA18LA112.md): Gulfstream Aerospace G V · Miami, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 21, 2018 · N90JE · No damage > The passengers' failure to comply with the fasten seatbelt sign, with resulted in their injury during an inflight turbulence encounter. - [NTSB WPR18LA111](https://openairdocs.org/ntsb/WPR18LA111.md): Pflugradt Kitfox · Clatskanie, OR · Accident · No injuries · Limited investigation · Final report · Mar 20, 2018 · N925DP · Substantial damage > A partial loss of engine power due to an improperly secured throttle cable set screw. - [NTSB GAA18CA172](https://openairdocs.org/ntsb/GAA18CA172.md): Lithuanian Factory Of LAK 12 · Sunriver, OR · Accident · No injuries · Data collection · Final report · Mar 20, 2018 · N63010 · Substantial damage > The glider pilot's inadequate flight planning, which resulted in an off-airport landing. - [NTSB ERA18LA110](https://openairdocs.org/ntsb/ERA18LA110.md): Besarick Skybolt · Punta Gorda, FL · Accident · Minor injuries · Limited investigation · Final report · Mar 17, 2018 · N27265 · Destroyed > A substantial oil leak, which resulted in a partial loss of engine power and failure of the No. 2 connecting rod. - [NTSB GAA18CA168](https://openairdocs.org/ntsb/GAA18CA168.md): Hughes 269 · San Antonio, TX · Accident · Minor injuries · Data collection · Final report · Mar 14, 2018 · N11047 · Substantial damage > The pilot’s decision to relinquish the helicopter flight controls to a non-rated passenger during a 3 ft hover. - [NTSB CEN18LA124](https://openairdocs.org/ntsb/CEN18LA124.md): White Thorpe T 18 · Cleburne, TX · Accident · Serious injuries · Limited investigation · Final report · Mar 14, 2018 · N118RG · Substantial damage > The loss of engine power due to fuel exhaustion. - [NTSB GAA18CA162](https://openairdocs.org/ntsb/GAA18CA162.md): Aeropro CZ Eurofox LSA · Punta Gorda, FL · Accident · Minor injuries · Data collection · Final report · Mar 13, 2018 · N989G · Substantial damage > A collision with a large bird during approach. - [NTSB GAA18CA152](https://openairdocs.org/ntsb/GAA18CA152.md): Piper PA 32R · Big Spring, TX · Accident · Minor injuries · Data collection · Final report · Mar 9, 2018 · N8191B · Substantial damage > The pilot’s failure to manage the airplane’s fuel supply, which resulted in fuel starvation. Contributing to the accident was the pilot’s decision to attempt the flight with an inoperative fuel gauge. - [NTSB CEN18LA118](https://openairdocs.org/ntsb/CEN18LA118.md): Bereznak Lancair Legacy · Temple, TX · Accident · Minor injuries · Limited investigation · Final report · Mar 8, 2018 · N60JN · Destroyed > The failure of the fuel selector valve in a nearly closed position, which resulted in a partial loss of engine power due to fuel starvation. - [NTSB WPR18LA102](https://openairdocs.org/ntsb/WPR18LA102.md): Macdonald Craig MAC CUB · Ogden, UT · Accident · No injuries · Class 3 · Limited · Final report · Mar 5, 2018 · N669WH · Substantial damage > The pilot’s failure to use carburetor heat during the flight, which resulted in a partial loss of engine power due to carburetor icing. - [NTSB WPR18LA098](https://openairdocs.org/ntsb/WPR18LA098.md): Raytheon A36 · Enumclaw, WA · Accident · Serious injuries · Class 3 · Limited · Final report · Mar 4, 2018 · N207PC · Substantial damage > A total loss of engine power due to oil starvation as a result of a loose oil line B-nut. - [NTSB GAA18CA184](https://openairdocs.org/ntsb/GAA18CA184.md): Piper PA32 · Camas, WA · Accident · No injuries · Data collection · Final report · Mar 4, 2018 · N3756W · Substantial damage > The pilot’s inadequate inflight fuel management and his failure to switch to a fuel tank with adequate fuel, which resulted in fuel starvation. - [NTSB GAA18CA149](https://openairdocs.org/ntsb/GAA18CA149.md): Beech B · Ferris, TX · Accident · Minor injuries · Data collection · Final report · Mar 1, 2018 · N77MM · Substantial damage > The pilot’s improper preflight inspection of the fuel level, which resulted in a loss of engine power due to fuel exhaustion. Contributing to the accident was the pilot’s failure to lower the landing gear before the emergency landing. - [NTSB ERA18LA094](https://openairdocs.org/ntsb/ERA18LA094.md): Cessna 172 · Ocean City, MD · Accident · 2 fatal · Limited investigation · Final report · Mar 1, 2018 · N615JA · Destroyed > The pilot's flight in dark night visual meteorological conditions, which resulted in an impact with water for reasons that could not be determined based on the available information. - [NTSB ENG18RA020](https://openairdocs.org/ntsb/ENG18RA020.md): Avro RJ85 · Bishkek, Kyrgyzstan · Incident · No injuries · Foreign investigation · Mar 1, 2018 · EX-27005 · Minor damage > On March 1, 2018, a Tez Jet Airline Avro RJ85, powered by four Honeywell (formally Lycoming) LF507-1F turbofan engines experienced an uncontained No. 1 (left most) engine turbine failure during climb. The airplane returned to the Bishkek-Manas International… - [NTSB CEN18WA133](https://openairdocs.org/ntsb/CEN18WA133.md): Cessna 182P · Abbeville, France · Incident · No injuries · Foreign investigation · Feb 28, 2018 · N609PC · Minor damage > On February 28, 2018, about 0845 universal coordinated time (UTC), a Cessna 182P airplane, N609PC, had an inflight engine failure and subsequent forced landing near Abbeville, France. The pilot and passenger were uninjured, and the airplane sustained minor… - [NTSB ERA18WA100](https://openairdocs.org/ntsb/ERA18WA100.md): Beech V35B · Brasilandia, Mato Grosso do Sul, Brazil · Accident · 1 fatal · Foreign investigation · Feb 27, 2018 · PT-IEL · Substantial damage > The government of Brazil has notified the NTSB of an accident involving a Beech V35B airplane that occurred on February 27, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Brazil's investigation under the provisions… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=57 ## 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=56 --- 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.