# 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 3 of 718 · 35,883 cases ## Cases, newest first - [NTSB ERA26LA257](https://openairdocs.org/ntsb/ERA26LA257.md): Cirrus Design SR22 · Lafayette, TN · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 2, 2026 · N127DC · Substantial damage > On July 2, 2026, at 1032 central daylight time, a Cirrus Design Corp SR22, N127DC, was substantially damaged when it was involved in an accident near Lafayette, Tennessee. The pilot and passenger sustained no injuries. The airplane was operated as a Title 14… - [NTSB CEN26FA241](https://openairdocs.org/ntsb/CEN26FA241.md): Beech 95-A55 · Lancaster, SC · Accident · Serious injuries · Class 3 · Field · Preliminary report · Jul 2, 2026 · N7501S · Substantial damage > On July 2, 2026, at 0052 eastern daylight time (EDT), a Beech model 95-A55 airplane, N7501S, was destroyed when it was involved in an accident near Lancaster, South Carolina. Both pilots received serious injuries. The accident flight was operated as a Title… - [NTSB DCA26WA268](https://openairdocs.org/ntsb/DCA26WA268.md): Boeing 737 · Catania, Italy · Accident · Serious injuries · Class 5 · Foreign · Jun 30, 2026 · G-DRTR · No damage - [NTSB DCA26WA254](https://openairdocs.org/ntsb/DCA26WA254.md): Boeing 787 · Ar Rumays, Oman · Incident · No injuries · Class 5 · Foreign · Jun 26, 2026 · A4O-SF · 2 aircraft · No damage - [NTSB WPR26LA236](https://openairdocs.org/ntsb/WPR26LA236.md): Beech S35 · Dome, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 25, 2026 · N6040F · Substantial damage > On June 25, 2026, about 1125 mountain standard time, a Beech S35, N6040F, sustained substantial damage when it was involved in an accident near Dome, Arizona. The pilot and three passengers were not injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26LA235](https://openairdocs.org/ntsb/WPR26LA235.md): Diamond Aircraft Ind DA20-C1 · Nephi, UT · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 25, 2026 · N643DC · Substantial damage > On June 25, 2026, about 0905 mountain daylight time, a Diamond DA20-C1, N643DC, was substantially damaged when it was involved in an accident near Nephi, Utah. The flight instructor and the student pilot were not injured. The airplane was operated as a Title… - [NTSB WPR26FA232](https://openairdocs.org/ntsb/WPR26FA232.md): Cessna 172 · Willard, UT · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 24, 2026 · N387AF · Destroyed > On June 23, 2026, at about 2247 mountain daylight time, a Cessna 172S, N387AF, was destroyed when it was involved in an accident near Willard, Utah. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part 91… - [NTSB DCA26WA249](https://openairdocs.org/ntsb/DCA26WA249.md): Airbus Canada BD500 · Berthoud, CO · Occurrence · No injuries · Class 5 · Foreign · Jun 24, 2026 · CGJYI - [NTSB ANC26LA062](https://openairdocs.org/ntsb/ANC26LA062.md): Textron 208B · Wiseman, AK · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 22, 2026 · N94AW · Substantial damage > On June 22, 2026, about 1043 Alaska standard time, a turbine-powered Cessna 208B airplane N94AW, was substantially damaged when it was involved in an accident near Wiseman, Alaska. The nine passengers were uninjured, the pilot sustained minor injuries. The… - [NTSB WPR26LA227](https://openairdocs.org/ntsb/WPR26LA227.md): Emigh Trojan A2 · Healdsburg, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 21, 2026 · N8329H · Substantial damage > On June 21, 2026, about 1210 Pacific daylight time, an Emigh Trojan A-2, N8329H, was substantially damaged when it was involved in an accident near Healdsburg, California. The flight instructor and student pilot were not injured. The airplane was operated as… - [NTSB ERA26FA243](https://openairdocs.org/ntsb/ERA26FA243.md): Piper PA-28-181 · Bowie, MD · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jun 21, 2026 · N249WF · Substantial damage > On June 20, 2026, about 2328 eastern daylight time, a Piper PA-28-181, N249WF, was substantially damaged when it was involved in an accident near Bowie, Maryland. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code… - [NTSB DCA26WA241](https://openairdocs.org/ntsb/DCA26WA241.md): Boeing 787-9 · Singapore, Singapore · Occurrence · No injuries · Class 5 · Foreign · Jun 21, 2026 · N27997 - [NTSB ANC26LA063](https://openairdocs.org/ntsb/ANC26LA063.md): Cirrus Design SR22 · Windom, WV · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 21, 2026 · N544CD · Substantial damage > On June 21, 2026, about 1132 eastern daylight time, a Cirrus SR22 airplane, N544CD, was substantially damaged when it was involved in an accident near Windom, West Virginia. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26FA223](https://openairdocs.org/ntsb/WPR26FA223.md): Comp Air CA6-WB · Nicholasville, KY · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 20, 2026 · N82BT · Destroyed > On June 20, 2026, about 0846 eastern daylight time, an experimental amateur-built Comp Air CA6-WB, N82BT, was destroyed when it was involved in an accident near Nicholasville, Kentucky. The pilot and passenger were fatally injured. The airplane was operated… - [NTSB CEN26LA230](https://openairdocs.org/ntsb/CEN26LA230.md): Zenith 601 XL · O'Donnell, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 20, 2026 · N165TJ · Substantial damage > On June 20, 2026, about 1147 central daylight time, an experimental Zodiac 601XL airplane, N165TJ, was substantially damaged when it was involved in an accident near O’Donnell, Texas. The pilot sustained serious injuries. The airplane was operated as a Title… - [NTSB GAA26WA221](https://openairdocs.org/ntsb/GAA26WA221.md): Piper PA24 · General Roca, Argentina · Accident · No injuries · Class 5 · Foreign · Jun 18, 2026 · LV-HKG · Minor damage - [NTSB ANC26FA057](https://openairdocs.org/ntsb/ANC26FA057.md): Piper PA20 · Cordova, AK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 18, 2026 · N7635K · Destroyed > On June 18, 2026, at approximately 1200, an experimental Piper PA-20 airplane, N7635K, was destroyed when it was involved in an accident about 44 miles southeast of Cordova, Alaska. The pilot was fatally injured. The airplane was operated as a Title 14 Code… - [NTSB CEN26FA228](https://openairdocs.org/ntsb/CEN26FA228.md): Textron 680A · Laredo, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 17, 2026 · N523QS · Substantial damage > On June 16, 2026, at 2200 central daylight time, a Textron Aviation Inc 680A, N523QS, sustained substantial damage when it was involved in an accident in Laredo, Texas. The captain received serious injuries, the first officer received minor injuries, one… - [NTSB ERA26FA239](https://openairdocs.org/ntsb/ERA26FA239.md): Blessing RV-3A · Lakeland, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 15, 2026 · N696DB · Substantial damage > On June 15, 2026, about 1955 eastern daylight time, an experimental amateur-built Van’s RV-3A, N696DB, was destroyed when it was involved in an accident near Lakeland, Florida. The pilot received fatal injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA225](https://openairdocs.org/ntsb/CEN26LA225.md): Piper PA-30 · Meridian, MS · Accident · No injuries · Class 4 · Limited · Final report · Jun 15, 2026 · N8143Y · Substantial damage > The total loss of power to both engines due to fuel exhaustion. Contributing to the accident was the pilot’s failure to verify the airplane’s fuel quantity before departure. - [NTSB WPR26LA218](https://openairdocs.org/ntsb/WPR26LA218.md): Piper PA-24-400 · Graham, TX · Accident · Minor injuries · Class 4 · Limited · Investigation open · Jun 13, 2026 · N400HL · Substantial damage - [NTSB CEN26LA223](https://openairdocs.org/ntsb/CEN26LA223.md): Cessna T206H · Bryant, AR · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 11, 2026 · N72RK · Substantial damage > On June 10, 2026, about 1223 central daylight time, a Cessna T206H airplane, N72RK, was substantially damaged when it was involved in an accident near Bryant, Arkansas. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB DCA26WA234](https://openairdocs.org/ntsb/DCA26WA234.md): Embraer ERJ190 · Connellan, Australia · Incident · No injuries · Class 5 · Foreign · Jun 4, 2026 · VH-XFM - [NTSB WPR26LA209](https://openairdocs.org/ntsb/WPR26LA209.md): Cirrus Design SR22T · Casper, WY · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 1, 2026 · N324WY · Substantial damage > On June 1, 2026, about 1340 mountain daylight time, a Cirrus Design Corp SR22T, N324WY, was substantially damaged when it was involved in an accident near Casper, Wyoming. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB GAA26WA214](https://openairdocs.org/ntsb/GAA26WA214.md): Beech 200 · Vitoria, Brazil · Accident · No injuries · Class 5 · Foreign · May 31, 2026 · PS-VES · Minor damage - [NTSB CEN26LA215](https://openairdocs.org/ntsb/CEN26LA215.md): Eaa Acro Sport II · Sheridan, AR · Accident · No injuries · Class 4 · Limited · Final report · May 31, 2026 · N23RA · Substantial damage > The pilot’s inadequate preflight inspection which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB WPR26LA204](https://openairdocs.org/ntsb/WPR26LA204.md): Air Tractor AT-602 · Robbins, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 30, 2026 · N5111A · Substantial damage > On May 30, 2026, about 0900 Pacific daylight time, an Air Tractor AT-602, N5111A, was substantially damaged when it was involved in an accident near Robbins, California. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA208](https://openairdocs.org/ntsb/CEN26LA208.md): American AA-1A · Amery, WI · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 30, 2026 · N6416L · Substantial damage > On May 30, 2026, about 1113 central daylight time, a Grumman AA-1A airplane, N6416L, was substantially damaged when it was involved in an accident near Amery, Wisconsin. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA224](https://openairdocs.org/ntsb/ERA26LA224.md): Boeing E75 · Dresden, OH · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 29, 2026 · N181RF · Substantial damage > On May 29, 2026, about 1153 eastern daylight time, a Boeing E75, N181RF, was substantially damaged when it was involved in an accident near Dresden, Ohio. The pilot and passenger were seriously injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ENG26WA024](https://openairdocs.org/ntsb/ENG26WA024.md): Gulfstream Aerospace G-IV · Dushanbe, Tajikistan · Incident · No injuries · Class 5 · Foreign · May 27, 2026 · N899AL · No damage - [NTSB DCA26WA238](https://openairdocs.org/ntsb/DCA26WA238.md): Boeing 737 · Sidi Errabia, Algeria · Incident · Class 5 · Foreign · May 27, 2026 · 7T-VCF - [NTSB ANC26LA044](https://openairdocs.org/ntsb/ANC26LA044.md): Sling Sling LSA · Makanalua, HI · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 25, 2026 · N83PF · Substantial damage > On May 25, 2026, about 1110 Hawaii-Aleutian Standard time, a Sling Aircraft LSA, N83PF, was substantially damaged when it was involved in an accident near Kalaupapa, Hawaii Airport (LUP). The two pilots onboard sustained minor injuries. The airplane was… - [NTSB ENG26LA023](https://openairdocs.org/ntsb/ENG26LA023.md): Bombardier BD-700-1A10 · Atlantic City, NJ · Incident · Class 4 · Limited · Investigation open · May 24, 2026 · N168QS - [NTSB DCA26WA221](https://openairdocs.org/ntsb/DCA26WA221.md): Airbus A321 · Stuarts Creek, Australia · Occurrence · Class 5 · Foreign · May 24, 2026 · VH-OFW · No damage - [NTSB WPR26LA203](https://openairdocs.org/ntsb/WPR26LA203.md): Pzl-Swidnik PW-5 · Soap Lake, WA · Accident · No injuries · Class 4 · Limited · Final report · May 23, 2026 · N157AJ · Substantial damage > The pilot’s failure to ensure the proper preflight assembly of the glider's wing attachment system, which resulted in substantial damage to the wing structure during flight. - [NTSB ERA26LA215](https://openairdocs.org/ntsb/ERA26LA215.md): Textron 172S · Jupiter Farms, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 22, 2026 · N294PL · Substantial damage > On May 22, 2026, about 1518 eastern daylight time, a Textron Aviation 172S, N294PL, was substantially damaged when it was involved in an accident near Jupiter Farms, Florida. The flight instructor and student pilot were not injured. The airplane was operated… - [NTSB GAA26WA211](https://openairdocs.org/ntsb/GAA26WA211.md): New Glasair Glasair Super II · Aquidauana, Brazil · Accident · No injuries · Class 5 · Foreign · May 20, 2026 · PP-ZSZ · Substantial damage - [NTSB CEN26LA194](https://openairdocs.org/ntsb/CEN26LA194.md): Lockwood AIR CAM · Hutchinson, KS · Accident · No injuries · Class 4 · Limited · Final report · May 20, 2026 · N32F · Substantial damage > The pilot’s inadequate fuel planning, which resulted in a total loss of engine power due to fuel exhaustion. - [NTSB WPR26LA196](https://openairdocs.org/ntsb/WPR26LA196.md): Diamond DA40 · Wells, NV · Accident · Serious injuries · Class 4 · Limited · Final report · May 17, 2026 · N787PV · Substantial damage > The pilot’s inability to maintain climb performance and clearance from mountainous terrain due to a downdraft. - [NTSB WPR26FA189](https://openairdocs.org/ntsb/WPR26FA189.md): Piper PA-32-300 · Empire, NV · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 17, 2026 · N8502N · Substantial damage > On May 17, 2026, about 0738 PDT, a Piper PA-32-300, N8502N, was substantially damaged when it was involved in an accident near Empire, Nevada. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB DCA26WA216](https://openairdocs.org/ntsb/DCA26WA216.md): Boeing 737-8 · Liberia, Costa Rica · Incident · Class 5 · Foreign · May 17, 2026 · N8723Q - [NTSB CEN26LA190](https://openairdocs.org/ntsb/CEN26LA190.md): Downer 14-19-3 · Forney, TX · Accident · 1 fatal · Class 3 · Limited · Preliminary report · May 16, 2026 · N7NL · Substantial damage > On May 16, 2026, about 0010 central daylight time, a Downer 14-19-3 airplane, N7NL, was substantially damaged when it was involved in an accident near Forney, Texas. The pilot and one passenger sustained minor injuries. A second passenger initially survived… - [NTSB WPR26LA191](https://openairdocs.org/ntsb/WPR26LA191.md): Bigham Jack L Marquart M 5 Charger · Tucson, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · May 15, 2026 · N987JB · Substantial damage > On May 15, 2026, about 1500 mountain standard time, an experimental amateur built Marquart M5 Charger was substantially damaged when it was involved in an accident near Tucson, Arizona. The pilot was not injured. The airplane was operated as a Title 14 Code… - [NTSB WPR26LA190](https://openairdocs.org/ntsb/WPR26LA190.md): Piper PA-28-140 · Chandler, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · May 15, 2026 · N8714N · Substantial damage > On May 14, 2026, at 2043 mountain standard time, a Piper PA-28, N8714N, was substantially damaged when it was involved in an accident near Chandler, Arizona. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26LA183](https://openairdocs.org/ntsb/WPR26LA183.md): Stinson 108-3 · Quilcene, WA · Accident · No injuries · Class 3 · Limited · Preliminary report · May 12, 2026 · N588C · Substantial damage > On May 12, 2026, at about 1049 Pacific daylight time, a Stinson 108-3 airplane, N588C, was substantially damaged when it was involved in an accident near Quilcene, Washington. The pilot was uninjured. The airplane was operated as a Title 14 Code of Federal… - [NTSB DCA26WA233](https://openairdocs.org/ntsb/DCA26WA233.md): Boeing 737 · Gwaska, Nigeria · Incident · No injuries · Class 5 · Foreign · May 11, 2026 · 5N-DAB - [NTSB GAA26WA298](https://openairdocs.org/ntsb/GAA26WA298.md): Scheibe SF25 · Speyer, Germany · Accident · No injuries · Class 5 · Foreign · May 10, 2026 · D-KSPY · 2 aircraft · Substantial damage - [NTSB DCA26WA228](https://openairdocs.org/ntsb/DCA26WA228.md): Bombardier CL600 2E25 · Manises, Spain · Incident · No injuries · Class 5 · Foreign · May 8, 2026 · EC-MJP · No damage - [NTSB ANC26LA038](https://openairdocs.org/ntsb/ANC26LA038.md): Textron B300C · Salcha, AK · Accident · No injuries · Class 4 · Limited · Final report · May 5, 2026 · N67RF · Substantial damage > An in-flight collision with a bird during cruise flight. - [NTSB ERA26LA197](https://openairdocs.org/ntsb/ERA26LA197.md): Cessna 182 · Lancaster, OH · Accident · Minor injuries · Class 3 · Limited · Preliminary report · May 4, 2026 · N9069X · Substantial damage > On May 3, 2026, about 2241 eastern daylight time, a Cessna 182D, N9069X, was substantially damaged when it was involved in an accident near Lancaster, Ohio. The pilot and one passenger sustained minor injuries. The airplane was operated as a Title 14 Code of… Next page: https://openairdocs.org/ntsb-phases/400/cases.md?page=4 ## 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=3 --- 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.