# NTSB investigations: Maneuvering 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 377 · 18,849 cases ## Cases, newest first - [NTSB GAA26WA026](https://openairdocs.org/ntsb/GAA26WA026.md): Robinson R-66 · Wellington, New Zealand · Accident · Class 5 · Foreign · Nov 15, 2025 · ZK-IXT · Substantial damage - [NTSB ERA26FA039](https://openairdocs.org/ntsb/ERA26FA039.md): Jabiru USA Sport J230-SP · New Bavaria, OH · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 14, 2025 · N755J · Substantial damage > On November 14, 2025, at 1708 eastern standard time, a Jabiru USA Sport Aircraft LLC J230-SP, N755J, was substantially damaged when it was involved in an accident near New Bavaria, Ohio. The sport pilot and passenger were fatally injured. The airplane was… - [NTSB GAA26WA025](https://openairdocs.org/ntsb/GAA26WA025.md): Air Tractor AT401 · Jaú, Brazil · Accident · 1 fatal · Class 5 · Foreign · Nov 11, 2025 · PT-WBU · Substantial damage - [NTSB WPR26LA053](https://openairdocs.org/ntsb/WPR26LA053.md): Tecnam P2008 · Blackfoot, ID · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 10, 2025 · N208CM · Substantial damage > The student pilot’s failure to maintain altitude and clearance from trees while maneuvering at night. - [NTSB ERA26FA035](https://openairdocs.org/ntsb/ERA26FA035.md): Airbus Helicopters EC 130 T2 · Lebanon, TN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 8, 2025 · N107VU · Substantial damage > On November 8, 2025, at 1341 central standard time, an Airbus Helicopters EC 130 T2, N107VU, was substantially damaged when it was involved in an accident near Lebanon, Tennessee. The pilot and flight paramedic were seriously injured, and the flight nurse was… - [NTSB ERA26FA034](https://openairdocs.org/ntsb/ERA26FA034.md): Extra Flugzeugproduktions EA 300/SC · Keystone Heights, FL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 8, 2025 · N330SL · Destroyed > On November 8, 2025, at 1038 eastern standard time, an Extra 330/SC, N330SL, was destroyed when it was involved in an accident near Keystone Heights, Florida. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ERA26LA036](https://openairdocs.org/ntsb/ERA26LA036.md): Czech Sport Aircraft A S Sportcruiser · Cuthbert, GA · Accident · Minor injuries · Class 4 · Limited · Final report · Nov 7, 2025 · N549PS · Substantial damage > The pilot’s failure to maintain clearance from trees and terrain while maneuvering for a precautionary landing, at low altitude and at night. - [NTSB CEN26LA036](https://openairdocs.org/ntsb/CEN26LA036.md): Air Tractor AT-502 · Gueydan, LA · Accident · Serious injuries · Class 4 · Limited · Final report · Nov 5, 2025 · N7315L · Substantial damage > The pilot’s failure to maintain situational awareness and clearance from terrain while maneuvering to avoid birds. - [NTSB ERA26FA019](https://openairdocs.org/ntsb/ERA26FA019.md): Cirrus SR22 · Ruston, LA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Oct 21, 2025 · N42BE · Destroyed > On October 21, 2025, about 0944 central daylight time, a Cirrus SR22, N42BE, was destroyed when it was involved in an accident near Ruston, Louisiana. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations… - [NTSB ANC26FA002](https://openairdocs.org/ntsb/ANC26FA002.md): Raytheon Hawker 800XP · Bath, MI · Accident · 3 fatal · Class 3 · Field · Preliminary report · Oct 16, 2025 · XA-JMR · Destroyed > On October 16, 2025, about 1728 eastern standard time, a Raytheon Hawker 800XP airplane, Mexican registration XA-JMR, was destroyed when it was involved in an accident near Bath Township, Michigan. The captain, co-pilot, and passenger were fatally injured.… - [NTSB GAA26WA007](https://openairdocs.org/ntsb/GAA26WA007.md): Robinson R22 · Rutland Plains, Australia · Accident · 1 fatal · Class 5 · Foreign · Oct 9, 2025 · VH-LYD · Destroyed - [NTSB GAA26WA009](https://openairdocs.org/ntsb/GAA26WA009.md): Bell 214B-1 · Squamish, Canada · Accident · Serious injuries · Class 4 · Foreign · Oct 7, 2025 · C-FBBT · Substantial damage - [NTSB ERA26LA007](https://openairdocs.org/ntsb/ERA26LA007.md): Cessna 172 · Miami, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Oct 7, 2025 · N433PT · Substantial damage > On October 07, 2025, at 1440 eastern daylight time, a Cessna 172M, N433PT, was substantially damaged when it was involved in an accident near Miami, Florida. The private pilot and the flight instructor were uninjured. The airplane was operated as a Title 14… - [NTSB ENG26WA002](https://openairdocs.org/ntsb/ENG26WA002.md): Thrush S2R · San Ramón de la Nueva Orán, Argentina · Accident · Class 5 · Foreign · Oct 7, 2025 · LV-WZM - [NTSB ERA26LA003](https://openairdocs.org/ntsb/ERA26LA003.md): Cessna 172 · West Milford, NJ · Accident · Minor injuries · Class 4 · Limited · Final report · Oct 6, 2025 · N677DM · Substantial damage > The pilot’s failure to adequate clearance from obstacles while maneuvering during the landing approach and the instructor pilot’s delayed remedial action, which resulted in the airplane contacting a tree and terrain. - [NTSB WPR26LA015](https://openairdocs.org/ntsb/WPR26LA015.md): Cessna 172S · Lathrop, CA · Accident · No injuries · Class 4 · Limited · Final report · Oct 4, 2025 · N103VK · Substantial damage > An inflight collision with a bird. - [NTSB GAA26WA003](https://openairdocs.org/ntsb/GAA26WA003.md): Robinson R22 · Brogans Creek, Australia · Accident · 1 fatal · Class 4 · Foreign · Oct 3, 2025 · VH-RDL · Destroyed - [NTSB GAA26WA002](https://openairdocs.org/ntsb/GAA26WA002.md): Cirrus SR22 · Al-Maktoum, United Arab Emirates · Accident · No injuries · Class 3 · Foreign · Oct 3, 2025 · A6-CTE · Substantial damage - [NTSB CEN25LA396](https://openairdocs.org/ntsb/CEN25LA396.md): Bell 206 · Archer City, TX · Accident · No injuries · Class 4 · Limited · Final report · Sep 27, 2025 · N565VA · Destroyed > The pilot’s failure to maintain clearance from power lines while herding livestock. - [NTSB WPR25FA294](https://openairdocs.org/ntsb/WPR25FA294.md): Cessna 172F · Battle Ground, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 26, 2025 · N8219U · Destroyed > On September 26, 2025, about 1306, Pacific daylight time a Cessna 172F, N8219U, was destroyed when it was involved in an accident near Battle Ground, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR25LA290](https://openairdocs.org/ntsb/WPR25LA290.md): Eurocopter EC135 · Whittier, WA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 24, 2025 · N955AL · Substantial damage > On September 23, 2025, at 2303 Pacific daylight time, a Eurocopter EC-135 T2+, N955AL, was substantially damaged when it was involved in an accident near Whittier, Washington. The pilot and three medical crew members received minor injuries. The helicopter… - [NTSB CEN25FA388](https://openairdocs.org/ntsb/CEN25FA388.md): North American T-6G · Louise, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 20, 2025 · N32SZ · Substantial damage > On September 20, 2025, about 1724 central daylight time, a North American T-6G airplane, N32SZ, was destroyed when it was involved in an accident near Lousie, Texas. The pilot and passenger sustained fatal injuries. The airplane was operated as a Title 14… - [NTSB WPR25LA278](https://openairdocs.org/ntsb/WPR25LA278.md): Diamond Aircraft Ind DA 40 · Rocky Ridge, UT · Accident · Minor injuries · Class 4 · Limited · Final report · Sep 12, 2025 · N8VT · Substantial damage > The flight instructor’s inadequate supervision and delayed remedial action during an unusual attitude recovery, which resulted in a descent into terrain. - [NTSB ERA25FA344](https://openairdocs.org/ntsb/ERA25FA344.md): Hughes 369D · Jim Thorpe, PA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 11, 2025 · N5072F · Destroyed > On September 11, 2025, about 1402 eastern daylight time, a Hughes (McDonnell Douglas) 369D helicopter, N5072F, was destroyed when it was involved in an accident near Jim Thorpe, Pennsylvania. The commercial pilot and line technician were fatally injured. The… - [NTSB ERA25LA338](https://openairdocs.org/ntsb/ERA25LA338.md): Bell 206 · Monroe, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 10, 2025 · N992MR · Destroyed > On September 10, 2025, about 1100 eastern daylight time, a Bell 206, N992MR, was destroyed when it was involved in an accident near Monroe, Geogia. The flight instructor and student pilot were seriously injured. The helicopter was operated as a Title 14 Code… - [NTSB GAA25WA255](https://openairdocs.org/ntsb/GAA25WA255.md): Air Tractor AT802 · Yeelanna, Australia · Accident · 1 fatal · Class 5 · Foreign · Sep 8, 2025 · VH-ODX · Substantial damage - [NTSB ERA25LA341](https://openairdocs.org/ntsb/ERA25LA341.md): Grumman G-44A · Beaver Cove, ME · Accident · No injuries · Class 4 · Limited · Final report · Sep 6, 2025 · N402E · Substantial damage > The pilot’s distraction and failure to monitor the airplane’s flight path, which resulted in controlled flight into a lake. - [NTSB ERA25LA336](https://openairdocs.org/ntsb/ERA25LA336.md): Let L-23 Super Blanik · Ridgeland, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 6, 2025 · N231LS · Substantial damage > The pilot’s exceedance of the glider’s critical angle of attack which resulted in a loss of control while maneuvering to return for landing after a runway overshoot. - [NTSB WPR25LA272](https://openairdocs.org/ntsb/WPR25LA272.md): American Champion 8KCAB · Jamesburg, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 31, 2025 · N15WJ · Substantial damage > On August 31, 2025, about 1100 Pacific daylight time, an American Champion 8KCAB Super Decathlon 177, N3357T, sustained substantial damage when it was involved in an accident near Jamesburg, California. The pilot and pilot rated passenger sustained minor… - [NTSB CEN25LA359](https://openairdocs.org/ntsb/CEN25LA359.md): Robinson Helicopter R44 II · Nashville, AR · Accident · No injuries · Class 4 · Limited · Final report · Aug 31, 2025 · N442PR · Substantial damage > The pilot’s inadequate fuel planning which resulted in a total loss of power due to fuel exhaustion. Contributing to the accident was the landing zone being unlit. - [NTSB CEN25FA339](https://openairdocs.org/ntsb/CEN25FA339.md): Rans S-12 Airaile · Concordia, KS · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 25, 2025 · N2757A · Substantial damage > On August 24, 2025, about 1926 central daylight time, a Rans S-12 Airaile airplane, N2757A, was substantially damaged when it was involved in an accident near Concordia, Kansas. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN25LA336](https://openairdocs.org/ntsb/CEN25LA336.md): Piper PA-25-235 · Argusville, ND · Accident · No injuries · Class 4 · Limited · Final report · Aug 23, 2025 · N7239Z · Substantial damage > The pilot’s failure to maintain clearance from terrain while maneuvering at low altitude. - [NTSB CEN25LA334](https://openairdocs.org/ntsb/CEN25LA334.md): Kaman Aerospace K-1200 · Eagle, CO · Accident · No injuries · Class 4 · Limited · Final report · Aug 22, 2025 · N171PL · Substantial damage > The pilot’s failure to maintain helicopter control which resulted in an uncontrolled descent and impact with terrain. - [NTSB CEN25LA323](https://openairdocs.org/ntsb/CEN25LA323.md): Grumman American Avn. G-164B · Fowler, IN · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 15, 2025 · N7015N · Substantial damage > On August 15, 2025, about 1910 eastern daylight time, a Grumman American Avn. Corp. G-164-B airplane, N7015N, was substantially damaged when it was involved in an accident near Fowler, Indiana. The pilot was not injured. The airplane was operated under Title… - [NTSB CEN25LA322](https://openairdocs.org/ntsb/CEN25LA322.md): Piper PA-18-150 · Joliet, IL · Accident · No injuries · Class 3 · Limited · Final report · Aug 14, 2025 · N476SM · Substantial damage > The failure of the No. 2 cylinder exhaust valve, which resulted in a total loss of engine power. - [NTSB WPR25FA253](https://openairdocs.org/ntsb/WPR25FA253.md): Pitts S-1T · Goodyear, AZ · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 12, 2025 · N51HC · Substantial damage > On August 12, 2025, about 1019 mountain standard time, a Pitts S-1T, N51HC, was substantially damaged when it was involved in an accident near Goodyear, Arizona. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR25LA246](https://openairdocs.org/ntsb/WPR25LA246.md): Hiller UH-12E · Fobes Hill, WA · Accident · No injuries · Class 4 · Limited · Final report · Aug 11, 2025 · N703WA · Substantial damage > The pilot’s abrupt maneuver to avoid a powerline during an aerial application flight, which resulted in the helicopter’s impact with terrain. - [NTSB ANC25LA085](https://openairdocs.org/ntsb/ANC25LA085.md): Dehavilland DHC-2 MK 1 · Soldotna, AK · Accident · No injuries · Class 4 · Limited · Final report · Aug 9, 2025 · N232KT · Substantial damage > The pilot’s failure to maintain clearance from rising terrain while maneuvering at low altitude. - [NTSB CEN25FA307](https://openairdocs.org/ntsb/CEN25FA307.md): Hughes 369D · West Alton, MO · Accident · 2 fatal · Class 3 · Field · Final report · Aug 7, 2025 · N173AL · Destroyed > The pilot’s failure to maintain helicopter clearance from the powerline during the powerline maintenance operation for reasons that could not be determined. - [NTSB CEN25LA304](https://openairdocs.org/ntsb/CEN25LA304.md): Ayres S2R-G6 · Slayton, MN · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 6, 2025 · N2239V · Substantial damage > On August 6, 2025, about 1300 central daylight time, a Ayres Corporation S2R-G6, airplane, registration N2239V, was substantially damaged when it was involved in an accident near Slayton, Minnesota. The pilot was seriously injured. The airplane was operated… - [NTSB ERA25LA288](https://openairdocs.org/ntsb/ERA25LA288.md): Cessna 172N · Pembroke Pines, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 5, 2025 · N1213F · Substantial damage > On August 05, 2025, about 0820 eastern daylight time, a Cessna 172N, N1213F, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a… - [NTSB WPR25LA239](https://openairdocs.org/ntsb/WPR25LA239.md): Robinson Helicopter R44 II · Ponderosa Pines, MT · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 3, 2025 · N750GT · Substantial damage > The pilot’s improper pedal application during an approach to a hover. - [NTSB CEN25LA302](https://openairdocs.org/ntsb/CEN25LA302.md): Robinson Helicopter R22 Beta · Taylor, TX · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 3, 2025 · N4684S · Substantial damage > The flight instructor’s inadequate supervision and delayed remedial action which resulted in a skid contacting the terrain. Contributing to the accident was the flight instructor’s improper judgement to allow the student pilot to manipulate the flight… - [NTSB GAA25WA224](https://openairdocs.org/ntsb/GAA25WA224.md): Cessna 188 · Guayabal-Meta, Colombia · Accident · No injuries · Class 5 · Foreign · Aug 2, 2025 · HK1635 · Substantial damage - [NTSB GAA25WA222](https://openairdocs.org/ntsb/GAA25WA222.md): Lional Ray Ward Ward F-4 Rocket · Mallorca, Spain · Accident · 2 fatal · Class 5 · Foreign · Aug 2, 2025 · N31VX · Substantial damage - [NTSB ANC25LA083](https://openairdocs.org/ntsb/ANC25LA083.md): Aviat A-1B · Chisana, AK · Accident · No injuries · Class 4 · Limited · Final report · Aug 2, 2025 · N900HY · Substantial damage > The pilot’s failure to maintain clearance from terrain while maneuvering at low altitude. - [NTSB WPR25FA233](https://openairdocs.org/ntsb/WPR25FA233.md): Cessna 152 · Hornell, NY · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 1, 2025 · N6125B · Destroyed > On August 1, 2025, about 1859 eastern daylight time, a Cessna 152, N6125B was destroyed when it was involved in an accident near Hornell, New York. The student pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part… - [NTSB GAA25WA236](https://openairdocs.org/ntsb/GAA25WA236.md): Bell 206 · Ontario, Canada · Accident · Serious injuries · Class 5 · Foreign · Aug 1, 2025 · C-GGAS · Substantial damage - [NTSB CEN25LA298](https://openairdocs.org/ntsb/CEN25LA298.md): Bell 47G · Assumption, MN · Accident · No injuries · Class 4 · Limited · Final report · Jul 31, 2025 · N102SH · Substantial damage > A total loss of engine power due to fuel starvation, which resulted from attitude-inducing unporting of the fuel. - [NTSB ERA25LA282](https://openairdocs.org/ntsb/ERA25LA282.md): Paul Dennis Berg Exec 162F · Holley, NY · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 30, 2025 · N843WB · Substantial damage > The pilot’s failure to maintain clearance with the ground while hovering, which resulted in a dynamic rollover. Next page: https://openairdocs.org/ntsb-phases/450/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 = 450) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC ``` This list as a web page: https://openairdocs.org/ntsb-phases/450/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.