# 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 43 of 718 · 35,883 cases ## Cases, newest first - [NTSB ERA20LA134](https://openairdocs.org/ntsb/ERA20LA134.md): Maule MT-7 · Swansboro, NC · Accident · 2 fatal · Class 3 · Limited · Final report · Mar 24, 2020 · N899ZZ · Destroyed > The airplane’s turning descent into water while enroute in night instrument meteorological conditions for reasons that could not be determined. - [NTSB ANC20WA035](https://openairdocs.org/ntsb/ANC20WA035.md): Bell 206 · Konstantinovsky Cape, Russia · Accident · 1 fatal · Foreign investigation · Mar 23, 2020 · RA-01917 > The government of Russia has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on March 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Russia's investigation under the provisions of… - [NTSB ERA20LA132](https://openairdocs.org/ntsb/ERA20LA132.md): Cessna 310 · Charleston, SC · Accident · 1 fatal · Class 3 · Limited · Final report · Mar 21, 2020 · N8080M · Substantial damage > The pilot’s fuel mismanagement during flight, resulting in a total loss of engine power due to fuel starvation. - [NTSB CEN20LA122](https://openairdocs.org/ntsb/CEN20LA122.md): Cessna 208 · LaCrosse, KS · Accident · 1 fatal · Class 3 · Limited · Final report · Mar 17, 2020 · N274PM · Destroyed > An infight loss of control as a result of pilot impairment, the cause of which could not be determined. - [NTSB CEN20LA123](https://openairdocs.org/ntsb/CEN20LA123.md): Cessna 182 · Baxterville, MS · Accident · No injuries · Class 3 · Limited · Final report · Mar 14, 2020 · N20847 · Substantial damage > The failure of the No. 1 cylinder intake valve due to inadequate valve seating. - [NTSB GAA20WA143](https://openairdocs.org/ntsb/GAA20WA143.md): Piper PA28 · Paquera, Province of Puntarenas, Costa Rica · Accident · 1 fatal · Class 5 · Foreign · Mar 13, 2020 · TI-AGV · Substantial damage - [NTSB ERA20LA123](https://openairdocs.org/ntsb/ERA20LA123.md): Mooney M20C · McIntyre, GA · Accident · No injuries · Class 3 · Limited · Final report · Mar 7, 2020 · N9281M · Substantial damage > A total loss of engine power for reasons that could not be determined. - [NTSB WPR20LA101](https://openairdocs.org/ntsb/WPR20LA101.md): Cessna 210 · Needles, CA · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 5, 2020 · N123CE · Substantial damage > A loss of engine power for undetermined reasons due to a lack of available evidence. - [NTSB CEN20LA113](https://openairdocs.org/ntsb/CEN20LA113.md): Bell 206 · Clark, MO · Accident · No injuries · Class 3 · Limited · Final report · Mar 5, 2020 · N32AE · Substantial damage > The fatigue failure of the pneumatic line for reasons that could not be determined, which resulted in a loss of engine power and subsequent hard landing. - [NTSB WPR20LA098](https://openairdocs.org/ntsb/WPR20LA098.md): Flight Design Ctls · Encino, NM · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 4, 2020 · N505MA · Substantial damage > A partial loss of engine power due to fuel starvation, which likely resulted from a leak in the fuel system. - [NTSB ERA20FA118](https://openairdocs.org/ntsb/ERA20FA118.md): Piper PA46 · Bishop, GA · Accident · 3 fatal · Class 3 · Field · Final report · Mar 3, 2020 · N43368 · Destroyed > The pilot’s encounter with a rain shower updraft and severe turbulence, which resulted in a loss of airplane control and an inflight breakup. Contributing to the accident was the pilot’s reliance on outdated weather information on his in-cockpit weather… - [NTSB CEN20LA107](https://openairdocs.org/ntsb/CEN20LA107.md): Zenith CH601 · Cabool, MO · Accident · No injuries · Class 3 · Limited · Final report · Feb 29, 2020 · N601ND · Substantial damage > The loss of engine power due to failure of the No. 1 cylinder piston for reasons that could not be determined based on available evidence. - [NTSB WPR20LA097](https://openairdocs.org/ntsb/WPR20LA097.md): Cessna 170 · Baker City, OR · Accident · No injuries · Class 3 · Limited · Final report · Feb 27, 2020 · N5478C · Substantial damage > The failure of the No. 2 connecting rod bearing as a result of oil starvation due to a contaminated oil filter screen. - [NTSB DCA20WA094](https://openairdocs.org/ntsb/DCA20WA094.md): Boeing 737 · Monterrey, Mexico · Incident · No injuries · Foreign investigation · Feb 27, 2020 · N379DA > The DGAC of Mexico has notified the NTSB of an incident involving a Boeing 737 airplane that occurred on February 27, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the DGAC's investigation under the provisions of ICAO Annex 13.All… - [NTSB GAA20WA144](https://openairdocs.org/ntsb/GAA20WA144.md): Beech 58 · Buenos Aires, Argentina · Accident · No injuries · Class 4 · Foreign · Feb 23, 2020 · LV-GVG · Substantial damage - [NTSB CEN20WA441](https://openairdocs.org/ntsb/CEN20WA441.md): Ryan Aeronautical ST3KR · Les Chariots, France · Accident · 2 fatal · Class 5 · Foreign · Feb 23, 2020 · N53018 · Destroyed - [NTSB CEN20FA096](https://openairdocs.org/ntsb/CEN20FA096.md): Beech A36 · Rogers, MN · Accident · 1 fatal · Class 3 · Field · Final report · Feb 22, 2020 · N3266Q · Destroyed > Inadequate maintenance that resulted in improper torque to the engine-driven fuel pump inlet fitting, which led to a loss of engine power and forced landing into unsuitable terrain. - [NTSB ANC20CA023](https://openairdocs.org/ntsb/ANC20CA023.md): Robinson R44 · Talkeetna, AK · Accident · Minor injuries · Class 4 · Data collection · Final report · Feb 21, 2020 · N716JL · Substantial damage > The pilot's failure to maintain adequate clearance from snow covered terrain during an en route descent in flat light conditions, which resulted in controlled flight into terrain. - [NTSB CEN20FA093](https://openairdocs.org/ntsb/CEN20FA093.md): Beech 200 · Coleman, TX · Accident · 3 fatal · Class 3 · Field · Final report · Feb 20, 2020 · N860J · Destroyed > The pilot’s loss of airplane control due to spatial disorientation. Contributing to the accident was the pilot’s distraction with a “popped” circuit breaker and communications with air traffic control. - [NTSB CEN20WA124](https://openairdocs.org/ntsb/CEN20WA124.md): Cessna 150 · Les Cedres, Canada · Accident · 2 fatal · Foreign investigation · Feb 17, 2020 · C-GYEV · Destroyed > The government of Canada has notified the NTSB of an accident involving a CESSNA 150 airplane that occurred on February 17, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions… - [NTSB ANC20WA026](https://openairdocs.org/ntsb/ANC20WA026.md): Agustawestland AW139 · Ishikari-City, Hokkaido, Japan · Accident · No injuries · Foreign investigation · Feb 16, 2020 · JA17AR > The government of Japan has notified the NTSB of an accident involving a AGUSTAWESTLAND AW139 helicopter that occurred on February 16, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the… - [NTSB DCA20WA086](https://openairdocs.org/ntsb/DCA20WA086.md): Boeing 737 · Incheon, North Korea · Accident · Serious injuries · Foreign investigation · Feb 15, 2020 · HL8342 · No damage > The government of Korea, Democratic People's Republic Of has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on February 15, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Korea,… - [NTSB ENG20LA015](https://openairdocs.org/ntsb/ENG20LA015.md): Airbus A220 · Bordeaux, France · Incident · No injuries · Class 4 · Limited · Final report · Feb 12, 2020 · YL-AAU · No damage > A No. 1 (left) engine low pressure compressor (LPC) stage 1 integrally bladed rotor (IBR) separation due to a high cycle fatigue crack (HCF) that originated at the runout of an airfoil leading edge root radius. The HCF crack developed because of a… - [NTSB CEN20LA082](https://openairdocs.org/ntsb/CEN20LA082.md): Cessna 560 · Aledo, TX · Accident · No injuries · Class 3 · Limited · Final report · Feb 12, 2020 · N654CE · Substantial damage > The in-flight separation of the upper and lower right engine cowlings for reasons that could not be determined based on available evidence. - [NTSB DCA20WA074](https://openairdocs.org/ntsb/DCA20WA074.md): Boeing 757 · San Jose, Costa Rica · Incident · No injuries · Foreign investigation · Feb 9, 2020 · N200UU · No damage > The Consejo Technico de Aviacion Civil (CTAC)of Costa Rica notified the NTSB of an incident involving a Boeing 757-2B7, which occurred on February 9, 2020. The NTSB has appointed a U.S. Accredited Representative to assist under the provisions of ICAO Annex 13… - [NTSB ERA20FA096](https://openairdocs.org/ntsb/ERA20FA096.md): Cessna 501 · Fairmount, GA · Accident · 4 fatal · Class 3 · Field · Final report · Feb 8, 2020 · N501RG · Substantial damage > The pilots’ loss of control in flight in freezing instrument meteorological conditions due to spatial disorientation and the cumulative effects of task saturation. - [NTSB DCA20CA071](https://openairdocs.org/ntsb/DCA20CA071.md): Bombardier CL-600-2D24 · Waynesville, NC · Accident · Serious injuries · Class 4 · Data collection · Final report · Feb 7, 2020 · N610NN · Minor damage > An encounter with severe convective turbulence associated with a strong sheared environment associated with the jet stream. - [NTSB DCA20IA081](https://openairdocs.org/ntsb/DCA20IA081.md): Aerospatiale AS350BA · Johnson Valley, CA · Incident · No injuries · Class 3 · Incident · Final report · Feb 6, 2020 · N611TC · 2 aircraft · Minor damage > the failure of the small UAS remote pilot to give way to the helicopter, resulting in an inflight collision. Contributing to the incident was the sUAS remote pilot’s failure to assess and mitigate the risks of operations in close proximity to other aircraft.… - [NTSB ANC20FA017](https://openairdocs.org/ntsb/ANC20FA017.md): Piper PA32R · Tuntutuliak, AK · Accident · 5 fatal · Class 3 · Field · Final report · Feb 6, 2020 · N7632C · Substantial damage > The pilot's continued visual flight rules flight into reduced visibility, including likely flat light and/or white out conditions, which resulted in a controlled flight into terrain. Contributing to the accident were the operator’s inadequate operational… - [NTSB DCA20WA070](https://openairdocs.org/ntsb/DCA20WA070.md): Airbus A380 · Los Angeles, CA · Accident · Serious injuries · Foreign investigation · Feb 2, 2020 · A6-EON · No damage > The General Civil Aviation Authority (GCAA) of the United Arab Emirates has informed the NTSB of an accident involving an Airbus A-380, which occurred on February 2, 2020. The NTSB has appointed a U.S Accredited Representative to assist the GCAA investigation… - [NTSB ANC20WA025](https://openairdocs.org/ntsb/ANC20WA025.md): Agustawestland AW139 · Fukushima, Japan · Accident · No injuries · Foreign investigation · Feb 1, 2020 · JA139F > The government of Japan has notified the NTSB of an accident involving a AGUSTAWESTLAND AW139 helicopter that occurred on February 01, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the… - [NTSB CEN20TA071](https://openairdocs.org/ntsb/CEN20TA071.md): Beech 60 · Big Spring, TX · Accident · Minor injuries · Class 3 · Final report · Jan 29, 2020 · N50JR · Substantial damage > A total loss of engine power in both engines due to fuel exhaustion, which resulted in a landing short of the runway. - [NTSB ERA20FA088](https://openairdocs.org/ntsb/ERA20FA088.md): Aeropro CZ A220 · Grafton, WV · Accident · 1 fatal · Class 3 · Field · Final report · Jan 27, 2020 · N214K · Destroyed > The pilot’s decision to continue a visual flight rules flight into instrument meteorological conditions and conditions favorable for airframe icing, which resulted in a loss of control of the airplane. - [NTSB CEN20LA069](https://openairdocs.org/ntsb/CEN20LA069.md): Cirrus SR22 · Woody Creek, CO · Accident · No injuries · Class 3 · Limited · Final report · Jan 27, 2020 · N288WT · Substantial damage > Water trapped in the static system, which resulted in incorrect airspeed display information and the pilot’s forced landing. - [NTSB DCA20MA059](https://openairdocs.org/ntsb/DCA20MA059.md): Sikorsky S76 · Calabasas, CA · Accident · 9 fatal · Class 1 · Major · Final report · Jan 26, 2020 · N72EX · Destroyed > The pilot’s decision to continue flight under visual flight rules into instrument meteorological conditions, which resulted in the pilot’s spatial disorientation and loss of control. Contributing to the accident was the pilot’s likely self-induced pressure… - [NTSB CEN20WA102](https://openairdocs.org/ntsb/CEN20WA102.md): Robinson R44 · Tuzantan, Mexico · Accident · 1 fatal · Foreign investigation · Jan 25, 2020 · XB-KQV · Substantial damage > On January 25, 2020, about 1858 hours universal coordinated time, a Robinson R-44II helicopter, Mexican registration XB-KQV, impacted terrain near Tuzantan, Chiapas, Mexico. The pilot was fatally injured. The flight departed Ángel Albino Corzo / Tuxtla… - [NTSB WPR20FA077](https://openairdocs.org/ntsb/WPR20FA077.md): Stinson V77 · Auburn, CA · Accident · 2 fatal · Class 3 · Field · Final report · Jan 24, 2020 · N50249 · Destroyed > A total loss of engine power due to a combination of mechanical engine anomalies. Contributing to the accident was inadequate maintenance that failed to identify the engine anomalies. - [NTSB DCA20WA061](https://openairdocs.org/ntsb/DCA20WA061.md): Airbus A319 · Panama City, Panama · Incident · No injuries · Foreign investigation · Jan 23, 2020 · N703AV · No damage > The government of Panama has notified the NTSB of an incident involving a Airbus A319 airplane that occurred on January 23, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Panama's investigation under the provisions… - [NTSB CEN20WA081](https://openairdocs.org/ntsb/CEN20WA081.md): Bell 206 · Lac Saint-Jean, Canada · Accident · Serious injuries · Foreign investigation · Jan 23, 2020 · C-GSQA · Substantial damage > The government of Canada has notified the NTSB of an accident involving a BELL 206 helicopter that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Canada's investigation under the provisions of… - [NTSB GAA20WA107](https://openairdocs.org/ntsb/GAA20WA107.md): Piper PA28 · Chatel-St-Denis, Switzerland · Accident · 2 fatal · Foreign investigation · Jan 22, 2020 · HB-PMH · Substantial damage > The government of Switzerland has notified the NTSB of an accident involving a PIPER PA28 airplane that occurred on January 22, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the… - [NTSB ERA20LA084](https://openairdocs.org/ntsb/ERA20LA084.md): Grumman AA5 · Tallahassee, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Jan 21, 2020 · N424WB · Substantial damage > The pilot's improper fuel planning, resulting in fuel exhaustion and a total loss of engine power in cruise flight. - [NTSB WPR20FA063](https://openairdocs.org/ntsb/WPR20FA063.md): Cessna TR182 · Billings, MT · Accident · 4 fatal · Class 3 · Field · Final report · Jan 12, 2020 · N736YU · Destroyed > The pilot’s failure to maintain clearance due to poor decision making in selecting an unsafe altitude during cruise flight. - [NTSB DCA20WA051](https://openairdocs.org/ntsb/DCA20WA051.md): Boeing 737 · Fukuoka, Japan · Accident · Serious injuries · Foreign investigation · Jan 12, 2020 · HL8243 · No damage > The government of Japan has notified the NTSB of an accident involving a BOEING 737 airplane that occurred on January 12, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Japan's investigation under the provisions of… - [NTSB CEN20LA058](https://openairdocs.org/ntsb/CEN20LA058.md): Piper PA46 · Bandera, TX · Accident · No injuries · Class 3 · Limited · Final report · Jan 11, 2020 · N350XL · Substantial damage > The in-flight electrical fire, which resulted in smoke in the cabin and an emergency landing. Contributing to the accident was the unsuitable terrain for the emergency landing. - [NTSB ERA20FA074](https://openairdocs.org/ntsb/ERA20FA074.md): Robinson R66 · Mechanicsburg, PA · Accident · 2 fatal · Class 3 · Field · Final report · Jan 10, 2020 · N450MC · Destroyed > A severe left roll excursion after the onset of pitch and roll oscillations, which were not arrested by the pilot for undetermined reasons. This resulted in main rotor blade contact with the airframe and a subsequent inflight breakup of the helicopter. - [NTSB DCA20CA058](https://openairdocs.org/ntsb/DCA20CA058.md): Airbus A320 · New Orleans, LA · Accident · Serious injuries · Class 4 · Data collection · Final report · Jan 10, 2020 · N1902U · No damage > an encounter with convectively induced turbulence while overflying an area of known convective activity. - [NTSB GAA20WA106](https://openairdocs.org/ntsb/GAA20WA106.md): REims F152 · Buttwil, Switzerland · Accident · 1 fatal · Foreign investigation · Jan 7, 2020 · HB-CCN · Destroyed > The government of Switzerland has notified the NTSB of an accident involving a Reims F152 airplane that occurred on January 07, 2020. The NTSB has appointed a U.S. Accredited Representative to assist the government of Switzerland's investigation under the… - [NTSB ENG20WA012](https://openairdocs.org/ntsb/ENG20WA012.md): Airbus A320 · New Delhi, India · Incident · No injuries · Foreign investigation · Jan 7, 2020 · VT-WGC · No damage > The government of India has notified the NTSB of an incident involving an Airbus A320 airplane that occurred on January 7, 2020. A GoAir Airbus A320-271N Neo powered by two Pratt & Whitney PW1127G-JM geared turbofan engines experienced an engine failure… - [NTSB ERA20FA068](https://openairdocs.org/ntsb/ERA20FA068.md): Cessna 172 · Newborn, GA · Accident · 1 fatal · Class 3 · Field · Final report · Jan 6, 2020 · N1612F · Destroyed > The pilot’s impairment/incapacitation from carbon monoxide poisoning due to a degraded muffler. Contributing to the accident was the pilot’s failure to properly maintain the airplane. - [NTSB WPR20FA057](https://openairdocs.org/ntsb/WPR20FA057.md): Thunder Mustang TM-1 · Santa Clarita, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jan 4, 2020 · N151WR · Destroyed > Engine detonation that resulted in material deformation of the crankcase and led to engine failure and restricted cockpit visibility. Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=44 ## 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=43 --- 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.