# 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 1 of 377 · 18,848 cases ## Latest cases - [NTSB CEN27LA009](https://openairdocs.org/ntsb/CEN27LA009.md): Simpson Arthur Monnett Sonerai Iilt · Sextonville, WI · Accident · Serious injuries · Class 3 · Limited · Investigation open · Oct 12, 2026 · N473AS - [NTSB WPR27LA018](https://openairdocs.org/ntsb/WPR27LA018.md): Christen Industries Pitts S-2B · Yuma, AZ · Accident · Serious injuries · Class 4 · Limited · Investigation open · Oct 5, 2026 · N12CK - [NTSB CEN26LA326](https://openairdocs.org/ntsb/CEN26LA326.md): Beech 35-A33 · East Troy, WI · Accident · Minor injuries · Limited investigation · Investigation open · Sep 27, 2026 · N1288Z - [NTSB WPR26LA360](https://openairdocs.org/ntsb/WPR26LA360.md): Cessna A185F · Livingston, MT · Accident · No injuries · Class 4 · Limited · Investigation open · Sep 26, 2026 · N185BZ · Substantial damage - [NTSB WPR26FA354](https://openairdocs.org/ntsb/WPR26FA354.md): Cessna 172B · Royal City, WA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 24, 2026 · N44P · Substantial damage > On September 23, 2026, about 1711 Pacific daylight time, a Cessna 172B, N44P, was substantially damaged when it was involved in an accident near Royal City, Washington. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB WPR26LA352](https://openairdocs.org/ntsb/WPR26LA352.md): Beech B95 · Newport, OR · Accident · 1 fatal · Class 4 · Limited · Investigation open · Sep 21, 2026 · N529RB - [NTSB WPR26FA346](https://openairdocs.org/ntsb/WPR26FA346.md): Airbus AS332 · Yosemite Valley, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 20, 2026 · N332N · Destroyed > On September 20, 2026, at 1356 Pacific daylight time, an Airbus AS332 L1 Super Puma, N332N, was destroyed when it was involved in an accident near Yosemite Valley, California. The two pilots were fatally injured. The helicopter was operated as a public use… - [NTSB ERA26LA345](https://openairdocs.org/ntsb/ERA26LA345.md): Cirrus Design SR20 · Asheville, NC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 19, 2026 · N189WM · Substantial damage > On September 19, 2026, at 1045 eastern daylight time, a Cirrus SR-20, N189WM, sustained substantial damage when it was involved in an accident near Ashville, North Carolina. The flight instructor and the student pilot received minor injuries. The airplane was… - [NTSB WPR26FA345](https://openairdocs.org/ntsb/WPR26FA345.md): Eurocopter AS 350 B2 · Chatsworth, CA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Sep 16, 2026 · N358TV · Destroyed > On September 15, 2026, about 1855 Pacific daylight time, an Airbus Helicopters (formerly Eurocopter) AS-350 B2 helicopter, N358TV, was destroyed when it was involved in an accident near Chatsworth, California. The pilot, passenger and one person on the ground… - [NTSB ERA26FA338](https://openairdocs.org/ntsb/ERA26FA338.md): Reed Julian Estill RV-4 · Albertville, AL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 15, 2026 · N469TW · Substantial damage > On September 15, 2026, about 0620 central daylight time, an experimental amateur-built RV-4, N469TW, was substantially damaged when it was involved in an accident near Albertville, Alabama. The pilot was fatally injured. The airplane was operated as a Title… - [NTSB ANC26LA098](https://openairdocs.org/ntsb/ANC26LA098.md): Pitts Model 12 · Lake Stevens, WA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 7, 2026 · N491X · Substantial damage > On September 6, 2026, about 1800 Pacific daylight time, an experimental Pitts Model 12 airplane, N491X, was substantially damaged when it was involved in an accident near Lake Stevens, Washington. The pilot sustained serious injuries. The airplane was… - [NTSB CEN26LA308](https://openairdocs.org/ntsb/CEN26LA308.md): Six Chuter SR7 XL · Amery, WI · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 3, 2026 · N5617X · Substantial damage > On September 2, 2026, about 2007 central daylight time, a Six Chuter SR7XL experimental light-sport powered parachute, N5617X, was involved in an accident near Amery, Wisconsin. The pilot was seriously injured. The powered parachute was operated as a Title 14… - [NTSB WPR26FA320](https://openairdocs.org/ntsb/WPR26FA320.md): Mooney M20C · Mount Hood, OR · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 31, 2026 · N2783W · Substantial damage > On August 31, 2026, about 1131 Pacific daylight time, a Mooney M20C, N2783W, was destroyed when it was involved in an accident near Hood River, Oregon. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB ERA26LA313](https://openairdocs.org/ntsb/ERA26LA313.md): Robinson Helicopter R22 Beta · Milton, FL · Accident · Minor injuries · Class 4 · Limited · Final report · Aug 24, 2026 · N979SH · Substantial damage > The flight instructor’s failure to maintain control of the helicopter during a low hover over a grass area, which resulted in left skid contact with the ground and a dynamic rollover to the left. - [NTSB WPR26LA312](https://openairdocs.org/ntsb/WPR26LA312.md): Schweizer G-164B · Olene, OR · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 20, 2026 · N7501Q · Destroyed > On August 20, 2026, about 9:32 Pacific daylight time, a Schweizer Aircraft Corp., G-164B, N7501Q, was destroyed when it was involved in an accident near Orlene, Oregon. The pilot was seriously injured. The airplane was operated as a Title 14 Code of Federal… - [NTSB ANC26LA088](https://openairdocs.org/ntsb/ANC26LA088.md): Cessna 172L · Micanopy, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 18, 2026 · N3866Q · Substantial damage > On August 18, 2026 at 1100 eastern daylight time, a Cessna 172L, N3866Q, was substantially damaged when it was involved in an accident near Micanopy, Florida. The flight instructor and student pilot were uninjured. The airplane was operated as a Title 14 Code… - [NTSB ERA26LA304](https://openairdocs.org/ntsb/ERA26LA304.md): Robinson Helicopter R22 Beta · Miramar, FL · Accident · No injuries · Class 4 · Limited · Final report · Aug 15, 2026 · N8316N · Substantial damage > The flight instructor’s failure to maintain control of the helicopter during a hover, which resulted in the left skid contacting ground and a subsequent dynamic rollover. - [NTSB ERA26FA294](https://openairdocs.org/ntsb/ERA26FA294.md): Bachem Fritz M Avid Mark IV · Arp, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 9, 2026 · N77FB · Substantial damage > On August 9, 2026, at about 1655 central daylight time, an experimental amateur-built Avid Mark IV, N77FB, was substantially damaged when it was involved in an accident near Arp, Texas. The private pilot was fatally injured. The airplane was operated as a… - [NTSB ANC26FA079](https://openairdocs.org/ntsb/ANC26FA079.md): Helicopter Transport Services CH-54A · Cove Fort, UT · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 7, 2026 · N793HT · Destroyed > On August 7, 2026, about 1044 mountain daylight time, a Helicopter Transport Services (Sikorsky) CH-54A Skycrane Helitanker, N793HT, was destroyed when it was involved in an accident near Cove Fort, Utah. The pilot and copilot were fatally injured. The… - [NTSB WPR26LA291](https://openairdocs.org/ntsb/WPR26LA291.md): Cessna 177B · Perris, CA · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 5, 2026 · N34852 · Substantial damage > On August 5, 2026, at 1117 mountain daylight time, a Cessna 177B, N34852, was substantially damaged when it was involved in an accident near Perris, California. The flight instructor and student pilot were not injured. The airplane was being operated as a… - [NTSB WPR26FA289](https://openairdocs.org/ntsb/WPR26FA289.md): Cirrus Design SR22T · Bend, OR · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 5, 2026 · N625LK · Substantial damage > On August 4, 2026, at about 1845 Pacific daylight time, a Cirrus Design Corporation SR22T airplane, N625LK, was substantially damaged when it was involved in an accident near Bend, Oregon. The pilot was fatally injured. The airplane was operated as Title 14… - [NTSB CEN26LA286](https://openairdocs.org/ntsb/CEN26LA286.md): Cessna T188C · Randolph, NE · Accident · No injuries · Class 4 · Limited · Final report · Aug 1, 2026 · N9998J · Substantial damage > The pilot’s failure to maintain clearance from a tree during a low-level aerial application flight. - [NTSB CEN26LA274](https://openairdocs.org/ntsb/CEN26LA274.md): Cessna A188B · Algona, IA · Accident · No injuries · Class 4 · Limited · Final report · Jul 29, 2026 · N731CQ · Substantial damage > The pilot’s failure to maintain control during a turn, which resulted in an aerodynamic stall. - [NTSB CEN26LA269](https://openairdocs.org/ntsb/CEN26LA269.md): Aero Commander Callair A-9B · Livonia, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 27, 2026 · N7799V · Substantial damage > On July 27, 2026, about 0819 central daylight time, an Aero Commander Callair A-9B airplane, N7799V, was substantially damaged when it was involved in an accident near Livonia, Missouri. The pilot was not injured. The airplane was operated as a Title 14 Code… - [NTSB WPR26LA280](https://openairdocs.org/ntsb/WPR26LA280.md): Harmon Rocket II · Glasgow, MT · Accident · Minor injuries · Class 4 · Limited · Investigation open · Jul 24, 2026 · C-FCPG - [NTSB ERA26LA284](https://openairdocs.org/ntsb/ERA26LA284.md): Piper PA28 · Palmetto, FL · Accident · No injuries · Class 4 · Limited · Final report · Jul 24, 2026 · N44704 · Substantial damage > The flight instructor’s failure to maintain clearance from obstacles during low altitude maneuvering, which resulted in a collision with a fence. - [NTSB WPR26LA275](https://openairdocs.org/ntsb/WPR26LA275.md): Czech Aircraft Works Mermaid Skeeter 2 · Cougar, WA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 22, 2026 · N42SK · Substantial damage > On July 22, 2026, about 1129 Pacific daylight time, an experimental amateur built Czech Aircraft Works Mermaid Skeeter 2 airplane, N42SK, was substantially damaged when it was involved in an accident near Cougar, Washington. The pilot was seriously injured.… - [NTSB WPR26LA277](https://openairdocs.org/ntsb/WPR26LA277.md): Bell 206B · Stonewall, OK · Accident · Serious injuries · Class 4 · Limited · Investigation open · Jul 21, 2026 · N2193X · Substantial damage - [NTSB CEN26LA289](https://openairdocs.org/ntsb/CEN26LA289.md): Robinson Helicopter R44 Raven 1 · Scribner, NE · Accident · No injuries · Class 4 · Limited · Final report · Jul 18, 2026 · N26EH · Substantial damage > The pilot's failure to maintain clearance from power lines while maneuvering at low-level altitude during an agricultural operation. - [NTSB CEN26LA259](https://openairdocs.org/ntsb/CEN26LA259.md): Robinson Helicopter R44 · Adair, IA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 18, 2026 · N484AT · Substantial damage > On July 18, 2026, about 1440 central daylight time, a Robinson Helicopter Company R44, N484AT, was substantially damaged when it was involved in an accident near Adair, Iowa. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal… - [NTSB CEN26LA264](https://openairdocs.org/ntsb/CEN26LA264.md): Bell 206B · Saint Joseph, IL · Accident · Serious injuries · Class 4 · Limited · Investigation open · Jul 17, 2026 · N297CA · Substantial damage - [NTSB CEN26LA256](https://openairdocs.org/ntsb/CEN26LA256.md): Robinson Helicopter R44 II · Coralville, IA · Accident · No injuries · Class 4 · Limited · Final report · Jul 16, 2026 · N322TC · Substantial damage > The pilot’s failure to maintain clearance from a power line during a low-level aerial application flight. - [NTSB ERA26LA274](https://openairdocs.org/ntsb/ERA26LA274.md): Robinson R22 · Monroe, NC · Accident · No injuries · Class 4 · Limited · Investigation open · Jul 14, 2026 · N30CH · Substantial damage - [NTSB CEN26LA252](https://openairdocs.org/ntsb/CEN26LA252.md): Air Tractor AT802 · Whiting, KS · Accident · Minor injuries · Class 4 · Limited · Final report · Jul 13, 2026 · N808HB · Substantial damage > The pilot's failure to maintain clearance from an antenna while maneuvering during a low-level aerial application flight. - [NTSB CEN26FA247](https://openairdocs.org/ntsb/CEN26FA247.md): Kaman Aerospace K-1200 · Silver Jack Reservoir, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jul 12, 2026 · N40HX · Substantial damage > On July 12, 2026, about 1705 mountain daylight time, a Kaman Aerospace Corporation K-1200 (K-MAX) helicopter, N40HX, was substantially damaged when it was involved in an accident at Silver Jack Reservoir, Colorado. The pilot was fatally injured. The… - [NTSB GAA26WA240](https://openairdocs.org/ntsb/GAA26WA240.md): Air Tractor AT502 · Moncoes, Brazil · Accident · No injuries · Class 5 · Foreign · Jun 29, 2026 · PR-TEF · Substantial damage - [NTSB WPR26FA233](https://openairdocs.org/ntsb/WPR26FA233.md): Cessna 195 · Pasco, WA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jun 24, 2026 · N3877V · Substantial damage > On June 24, 2026, about 1428 Pacific daylight time, a float equipped Cessna 195, N3877V, was substantially damaged when it was involved in an accident near Pasco, Washington. The pilot and passenger were fatally injured. The airplane was operated under Title… - [NTSB GAA26WA239](https://openairdocs.org/ntsb/GAA26WA239.md): Supermarine Spitfire · Muluckine, Australia · Accident · 1 fatal · Class 5 · Foreign · Jun 24, 2026 · VH-SFX · Substantial damage - [NTSB CEN26LA234](https://openairdocs.org/ntsb/CEN26LA234.md): Bell 47G-2 · Troy, MO · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 22, 2026 · N65520 · Substantial damage > On June 22, 2026, about 1840 central daylight time, a Bell 47G-2 helicopter, N65520, was substantially damaged when it was involved in an accident near Troy, Missouri. The pilot sustained serious injuries. The helicopter was operated as a Title 14 Code of… - [NTSB ANC26LA055](https://openairdocs.org/ntsb/ANC26LA055.md): Piper PA-18 105 · Petersville, AK · Accident · No injuries · Class 4 · Limited · Investigation open · Jun 18, 2026 · N249T · Substantial damage - [NTSB ANC26LA051](https://openairdocs.org/ntsb/ANC26LA051.md): Robinson R44 · Pembroke Pines, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jun 13, 2026 · N336SG · Substantial damage > On June 13, 2026, about 1318 eastern daylight time, a Robinson R44 Raven I helicopter, N336SG, was substantially damaged when it was involved in an accident at the North Perry Airport (HWO), Hollywood, Florida. The pilot and three passengers sustained minor… - [NTSB WPR26FA216](https://openairdocs.org/ntsb/WPR26FA216.md): Piper PA-36-300 · Henderson, NE · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jun 12, 2026 · N57846 · Substantial damage > On June 11, 2026, at 2103 central daylight time, a Piper PA-36-300, N57846, was substantially damaged when it impacted a rotating beacon tower and terrain near Henderson, Nebraska. The pilot was fatally injured. The airplane was operated as a Title 14 Code of… - [NTSB WPR26LA220](https://openairdocs.org/ntsb/WPR26LA220.md): Cessna 172S · Morgan Hill, CA · Accident · No injuries · Class 4 · Limited · Final report · Jun 11, 2026 · N55231 · Substantial damage > An in-flight collision with a bird. - [NTSB ERA26LA234](https://openairdocs.org/ntsb/ERA26LA234.md): Robinson Helicopter R44 · Mayesville, SC · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 8, 2026 · N144CD · Substantial damage > The pilot’s failure to remain clear of a power line during an aerial application flight. - [NTSB ERA26LA232](https://openairdocs.org/ntsb/ERA26LA232.md): North American SNJ-5C · Midland, VA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 6, 2026 · N98RJ · Substantial damage > On June 6, 2026, about 0940 eastern daylight time, a North American SNJ-5C, N98RJ was substantially damaged when it was involved in an accident near Midland, Virginia. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA218](https://openairdocs.org/ntsb/CEN26LA218.md): Air Tractor AT-602 · Breaux Bridge, LA · Accident · No injuries · Class 3 · Limited · Preliminary report · Jun 3, 2026 · N50050 · Substantial damage > On June 3, 2026, about 1320 central daylight time, an Air Tractor AT-602 airplane, N50050, was substantially damaged when it was involved in an accident near Breaux Bridge, Louisiana. The pilot was not injured. The airplane was operated as a Title 14 Code of… - [NTSB CEN26LA209](https://openairdocs.org/ntsb/CEN26LA209.md): Bellanca 7GCBC · Jonesboro, AR · Accident · No injuries · Class 4 · Limited · Final report · May 30, 2026 · N90932 · Substantial damage > The student pilot's failure to maintain adequate airspeed, which led to the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall. Contributing to the accident was the pilot’s decision to practice slow flight maneuvers at an… - [NTSB CEN26FA207](https://openairdocs.org/ntsb/CEN26FA207.md): Robinson Helicopter R66 · Dawsonville, GA · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 30, 2026 · N4488H · Substantial damage > On May 29, 2026, about 2150 eastern daylight time, a Robinson R66 helicopter, N4488H, was substantially damaged when it was involved in an accident near Dawsonville, Georgia. The commercial pilot and one passenger were fatally injured. The other passenger had… - [NTSB CEN26LA203](https://openairdocs.org/ntsb/CEN26LA203.md): Robinson Helicopter R66 · Fort Worth, TX · Accident · Serious injuries · Class 4 · Limited · Final report · May 27, 2026 · N5488H · Substantial damage > The flight instructor’s delayed remedial action and the student pilot’s failure to maintain helicopter control during hover. - [NTSB WPR26FA198](https://openairdocs.org/ntsb/WPR26FA198.md): Mooney M20J · Woodlake, CA · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 23, 2026 · N4452H · Destroyed > On May 23, 2026, about 1034 Pacific daylight time, a Mooney M20J, N4452H, was destroyed when it was involved in an accident near Woodlake, California. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations part 91… Next page: https://openairdocs.org/ntsb-phases/450/cases.md?page=2 ## 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 --- 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.