# Ongoing NTSB investigations: Approach

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 2 of 3 · 107 cases

## Cases, newest first

- [NTSB ERA26LA078](https://openairdocs.org/ntsb/ERA26LA078.md): Beech B90 · Atlanta, GA · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 28, 2025 · N40BA · Substantial damage
  > On December 28, 2025, about 0935 eastern standard time, a Beech B90 airplane, N40BA, was substantially damaged when it was involved in an accident near Atlanta, Georgia. The pilot received minor injuries, and the copilot was seriously injured. The airplane…
- [NTSB WPR26FA067](https://openairdocs.org/ntsb/WPR26FA067.md): Beechcraft B300 · Galveston, TX · Accident · 6 fatal · Class 3 · Field · Preliminary report · Dec 22, 2025 · ANX1209 · Destroyed
  > On December 22, 2025, about 1505 central standard time, a Beechcraft B300, ANX1209, was substantially damaged when it was involved in an accident near Galveston, Texas. The pilot, co-pilot, two flight crew, two passengers were fatally injured and two…
- [NTSB CEN26LA080](https://openairdocs.org/ntsb/CEN26LA080.md): Cessna 150 · Prospect Heights, IL · Accident · No injuries · Class 3 · Limited · Preliminary report · Dec 21, 2025 · N3103V · Substantial damage
  > On December 21, 2025, about 1342 central standard time, a Cessna 150M, N3103V, was substantially damaged when it was involved in an accident near Prospect Heights, Illinois. The student pilot was not injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN26LA060](https://openairdocs.org/ntsb/CEN26LA060.md): Sonerai II · Cresson, TX · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Dec 12, 2025 · N28MD · Substantial damage
  > On December 12, 2025, about 1431 central standard time, a Sonerai II airplane, registration N28MD, was substantially damaged when it was involved in an accident near Cresson, Texas. The pilot was seriously injured. The airplane was operated as a Title 14 Code…
- [NTSB CEN26FA051](https://openairdocs.org/ntsb/CEN26FA051.md): Cessna 172N · New Orleans, LA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 25, 2025 · N80FP · Destroyed
  > On November 24, 2025, at 1824 central standard time, a Cessna 172N airplane, N80FP, was destroyed when it was involved in an accident near New Orleans, Louisiana. The flight instructor and pilot receiving instruction were fatally injured. The flight was…
- [NTSB CEN26FA050](https://openairdocs.org/ntsb/CEN26FA050.md): Socata TBM 700 · Monroe, WI · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 24, 2025 · N700PT · Substantial damage
  > On November 24, 2025, about 1713 central standard time (CST), a Socata TBM 700 airplane, N700PT, was destroyed when it was involved in an accident near Monroe, Wisconsin. The pilot and pilot-rated passenger sustained fatal injuries. The airplane was operated…
- [NTSB CEN26FA049](https://openairdocs.org/ntsb/CEN26FA049.md): Piper PA-28R-201 · Pittsfield, IL · Accident · 1 fatal · Class 3 · Field · Preliminary report · Nov 24, 2025 · N47700 · Substantial damage
  > On November 23, 2025, about 2137 central standard time (all referenced times are CST), a Piper PA-28R-201 airplane, N47700, was substantially damaged when it was involved in an accident near Pittsfield, Illinois. The pilot was fatally injured, and the 2…
- [NTSB WPR26LA045](https://openairdocs.org/ntsb/WPR26LA045.md): Piper PA-28-181 · Mesa, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Nov 17, 2025 · N4402N · Substantial damage
  > On November 17, 2025, about 0830 mountain standard time, a Piper PA 28-181, N4402N, was substantially damaged when it was involved in an accident near Mesa, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…
- [NTSB CEN26LA044](https://openairdocs.org/ntsb/CEN26LA044.md): Cirrus Design SR20 · Chesterfield, MO · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 11, 2025 · N866CD · Substantial damage
  > On November 11, 2025, about 1750 central standard time, a Cirrus SR20, N866CD, was substantially damaged when it was involved in an accident near Chesterfield, Missouri. The pilot and copilot received minor injuries. The airplane was operated as a Title 14…
- [NTSB CEN26FA023](https://openairdocs.org/ntsb/CEN26FA023.md): JMB VL-3LSA-912 · Erie, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 19, 2025 · N594TT · Substantial damage
  > On October 19, 2025, about 1531 mountain daylight time, a JMB Aircraft VL-3LSA-912, N594TT, was substantially damaged when it was involved in an accident near Erie, Colorado. The pilot receiving instruction and the flight instructor were fatally injured. The…
- [NTSB ERA26FA010](https://openairdocs.org/ntsb/ERA26FA010.md): Beech C90 · Fort Worth, TX · Accident · 2 fatal · Class 3 · Field · Preliminary report · Oct 12, 2025 · N291CC · Destroyed
  > On October 12, 2025, about 1334 central daylight time, a Beech C90, N291CC, was destroyed when it was involved in an accident near Fort Worth, Texas. The private pilot and pilot-rated passenger were fatally injured. The airplane was operated as a Title 14…
- [NTSB WPR25LA292](https://openairdocs.org/ntsb/WPR25LA292.md): Cessna 182N · Fallbrook, CA · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Sep 23, 2025 · N766EE · Substantial damage
  > On September 23, 2025, about 1400 Pacific daylight time, N766EE, a Cessna 182N, was substantially damaged when it was involved in an accident near Fallbrook, California. The pilot received minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB ERA25FA352](https://openairdocs.org/ntsb/ERA25FA352.md): Cirrus Design SR22T · Franklin, NC · Accident · 3 fatal · Class 3 · Field · Preliminary report · Sep 18, 2025 · N218VB · Substantial damage
  > On September 18, 2025, at 1456 eastern daylight time, a Cirrus SR22T, N218VB, was substantially damaged when it was involved in an accident near Franklin, North Carolina. The private pilot and two passengers were fatally injured. The airplane was operated as…
- [NTSB WPR25FA279](https://openairdocs.org/ntsb/WPR25FA279.md): Bellanca 17-30A · Moriarty, NM · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 16, 2025 · N432DM · Substantial damage
  > On September 16, 2025, about 1132 mountain daylight time, a Bellanca 17-30A, N432DM, was substantially damaged when it was involved in an accident near Moriarty, New Mexico. The pilot receiving instruction was fatally injured and the flight instructor…
- [NTSB ERA25LA345](https://openairdocs.org/ntsb/ERA25LA345.md): Cessna 172 · Williston, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 13, 2025 · N345QA · Substantial damage
  > On September 13, 2025, about 0733 eastern daylight time, a Cessna 172G, N345QA, was substantially damaged when it was involved in an accident near Williston, Florida. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB CEN25LA379](https://openairdocs.org/ntsb/CEN25LA379.md): Pegasus Quantum 15 · Bedford, IN · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 13, 2025 · N36TJ · Substantial damage
  > On September 13, 2025, at 1625 eastern daylight time, a Pegasus Quantum 15 weight-shift controlled aircraft, N36TJ, sustained substantial damage when it was involved in an accident near Bedford, Indiana. The pilot received serious injuries. The airplane was…
- [NTSB ANC25LA105](https://openairdocs.org/ntsb/ANC25LA105.md): Maule M-5-235C · Point MacKenzie, AK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Sep 13, 2025 · N343GA · Substantial damage
  > On September 13, 2025, about 12:28 Alaska daylight time, a Maule M5-235C airplane, N343GA, was substantially damaged when it was involved in an accident near Point McKenzie, Alaska. The commercial pilot sustained serious injuries. The airplane was operated…
- [NTSB CEN25FA366](https://openairdocs.org/ntsb/CEN25FA366.md): Beech P35 · Englewood, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 5, 2025 · N463T · Destroyed
  > On September 5, 2025, about 0623 mountain daylight time, a Beech P35 airplane, N463T, was destroyed when it was involved in an accident near Englewood, Colorado. The pilot receiving instruction and flight instructor were both fatally injured. The airplane was…
- [NTSB CEN25FA364](https://openairdocs.org/ntsb/CEN25FA364.md): Beech K35 · Cambridge, MN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Sep 4, 2025 · N6021E · Substantial damage
  > On September 4, 2025, about 1105 central daylight time, a Beech K35 airplane, N6021E, sustained substantial damage when it was involved in an accident near Cambridge, Minnesota. The pilot sustained fatal injuries. The airplane was operated as a Title 14 Code…
- [NTSB WPR25FA268](https://openairdocs.org/ntsb/WPR25FA268.md): Cessna 172M · Fort Morgan, CO · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 31, 2025 · N61657 · 2 aircraft · Destroyed
  > On August 31, 2025, about 1040 mountain daylight time, a Cessna 172M, N61657, and an Extra Flugzeugproduktions-UND EA 300/LC, N330AN, were both destroyed when they collided midair near Fort Morgan, Colorado. The pilot and safety pilot of the Cessna received…
- [NTSB CEN25FA348](https://openairdocs.org/ntsb/CEN25FA348.md): Cessna 210D · Kearney, NE · Accident · 2 fatal · Class 3 · Field · Preliminary report · Aug 28, 2025 · N3806Y · Substantial damage
  > On August 27, 2025, about 20:57 central daylight time, a Cessna 210D, N3806Y was destroyed when it was involved in an accident near Kearney, Nebraska. Both pilots were fatally injured. The flight was operated under the provisions of Title 14 Code of Federal…
- [NTSB ERA25LA316](https://openairdocs.org/ntsb/ERA25LA316.md): Piper PA-28-140 · Seneca, SC · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Aug 26, 2025 · N1684J · Substantial damage
  > On August 26, 2025, at 0831 eastern standard time, a Piper PA28-140, N1684J, was substantially damaged when it was involved in an accident near Seneca, South Carolina. The sole occupant, a student pilot, received minor injuries. The airplane was operated as a…
- [NTSB ERA25LA313](https://openairdocs.org/ntsb/ERA25LA313.md): Raytheon A36 · Gulf Shores, AL · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Aug 24, 2025 · N855DC · Substantial damage
  > On August 24, 2025, about 1500 eastern daylight time, a Raytheon Aircraft Company A36, N855DC, was substantially damaged when it was involved in an accident near Gulf Shores, Alabama. The pilot and passenger were seriously injured. The airplane was operated…
- [NTSB ERA25FA310](https://openairdocs.org/ntsb/ERA25FA310.md): Cessna 310Q · Milledgeville, GA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Aug 23, 2025 · N7664Q · Destroyed
  > On August 23, 2025, about 1825 eastern daylight time, a Cessna 310Q, N7664Q was destroyed when it was involved in an accident near Milledgeville, Georgia. The commercial pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB WPR25FA240](https://openairdocs.org/ntsb/WPR25FA240.md): Beech 300 · Chinle, AZ · Accident · 4 fatal · Class 3 · Field · Preliminary report · Aug 5, 2025 · N534AW · Destroyed
  > On August 5, 2025, about 1245 mountain daylight time, a Beech 300, N534AW, was destroyed when it was involved in an accident near Chinle, Arizona. The pilot, co-pilot and two medical crew members were fatally injured. The airplane was operated as a Title 14…
- [NTSB WPR25LA230](https://openairdocs.org/ntsb/WPR25LA230.md): Ballisodare Lancair Evolution · Coeur d' Alene, ID · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 27, 2025 · N505RF · Destroyed
  > On July 27, 2025, about 1010 Pacific daylight time, an experimental amateur-built Lancair Evolution airplane, N505RF, was destroyed when it was involved in an accident near Coeur d’Alene, Idaho. The pilot and two passengers sustained minor injuries. The…
- [NTSB WPR25FA224](https://openairdocs.org/ntsb/WPR25FA224.md): Beech 95-B55 (T42A) · Pacific Grove, CA · Accident · 3 fatal · Class 3 · Field · Preliminary report · Jul 27, 2025 · N8796R · Substantial damage
  > On July 26, 2025, about 2237 Pacific daylight time, a Beech 95-B55, N8976R, was substantially damaged when it was involved in an accident near Pacific Grove, California. The pilot and two passengers were fatally injured. The airplane was operated as a Title…
- [NTSB ERA25LA277](https://openairdocs.org/ntsb/ERA25LA277.md): Mangels Leighton LANCAIR360 · Hardinsburg, KY · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Jul 24, 2025 · N50LM · Substantial damage
  > On July 24, 2025, about 1000 central daylight time, an experimental amateur-built Lancair 360, N50LM, was substantially damaged when it was involved in an accident near Hardinsburg, Kentucky. The pilot and the passenger sustained minor injuries. The airplane…
- [NTSB WPR25LA228](https://openairdocs.org/ntsb/WPR25LA228.md): Beech V35 · Astoria, OR · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 23, 2025 · N3785Q · Substantial damage
  > On July 22, 2025, about 1706 Pacific daylight time, a Beechcraft Bonanza V35, N3785Q, sustained substantial damage when it was involved in an accident near Astoria, Oregon. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…
- [NTSB CEN25FA270](https://openairdocs.org/ntsb/CEN25FA270.md): Van's RV-14 · Lowell, MI · Accident · 2 fatal · Class 3 · Field · Preliminary report · Jul 21, 2025 · N21KL · Destroyed
  > On July 21, 2025, about 1627 eastern daylight time, a Van’s Aircraft RV-14A airplane, N21KL, was destroyed when it was involved in an accident near Lowell, Michigan. The pilot and the pilot-rated passenger sustained fatal injuries. The airplane was operated…
- [NTSB OPS25LA052](https://openairdocs.org/ntsb/OPS25LA052.md): Embraer-Empresa Brasileira De ERJ 170-200 LR · Minot, ND · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 19, 2025 · N604CZ · 3 aircraft · No damage
  > On July 18, 2025, about 1948 central daylight time (CDT), WarBird03 (WBD03), a US Air Force (USAF) B-52H, enroute to conduct an aerial flyby at the North Dakota Fairgrounds, was involved with a loss of separation event approximately two miles south of Minot…
- [NTSB OPS25LA048](https://openairdocs.org/ntsb/OPS25LA048.md): Embraer ERJ 170-200 LR · Monterey, CA · Incident · No injuries · Class 3 · Limited · Preliminary report · Jul 15, 2025 · N185SY · No damage
  > On July 15, 2025, about 0005 Pacific Daylight Time (PDT), SkyWest Airlines (SKW) flight 3005, an Embraer 170-200LR, N185SY, conducted a pilot-initiated go-around approximately 4 miles from the threshold of runway 10R at Monterey Regional Airport (MRY),…
- [NTSB CEN25LA250](https://openairdocs.org/ntsb/CEN25LA250.md): Game Composites GB1 Gamebird · Tarkio, MO · Accident · No injuries · Class 3 · Limited · Preliminary report · Jul 12, 2025 · N588AF · 2 aircraft · Substantial damage
  > On July 12, 2025, about 0830 central daylight time, a Game Composites GB-1 Gamebird airplane, N588AF, was substantially damaged, and a Vans RV-8, N931KZ, sustained minor damage, when they were involved in an accident near the Gould Peterson Municipal Airport…
- [NTSB ANC25LA055](https://openairdocs.org/ntsb/ANC25LA055.md): Piper PA-32R-300 · Big Lake, AK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · Jun 24, 2025 · N3609Q · Substantial damage
  > On June 24, 2025, about 0934 Alaska daylight time, a Piper PA-32R-300 airplane, N3609Q, was substantially damaged when it was involved in an accident near Big Lake, Alaska. The pilot and flight instructor were seriously injured. The airplane was operated as a…
- [NTSB CEN25LA192](https://openairdocs.org/ntsb/CEN25LA192.md): Piper PA-32RT-300T · Tulsa, OK · Accident · Serious injuries · Class 3 · Limited · Preliminary report · May 30, 2025 · N130XR · Substantial damage
  > On May 30, 2025, about 1627 central daylight time, a Piper PA-32RT-300T airplane, N130XR, was substantially damaged when it was involved in an accident near Tulsa, Oklahoma. The pilot sustained serious injuries, and the pilot-rated passenger sustained minor…
- [NTSB WPR25FA161](https://openairdocs.org/ntsb/WPR25FA161.md): Cessna S550 · San Diego, CA · Accident · 6 fatal · Class 3 · Field · Preliminary report · May 22, 2025 · N666DS · Destroyed
  > On May 22, 2025, at 0347 Pacific daylight time (PDT), a Cessna Citation S550, N666DS, was destroyed when it was involved in an accident near San Diego, California. The pilot and five passengers were fatally injured. Eight people on the ground received minor…
- [NTSB CEN25FA178](https://openairdocs.org/ntsb/CEN25FA178.md): Beech 95-B55 (T42A) · Broomfield, CO · Accident · 2 fatal · Class 3 · Field · Preliminary report · May 17, 2025 · N4321Z · Destroyed
  > On May 17, 2025, about 1003 mountain daylight time, a Beechcraft 95-B55, was destroyed when it was involved in an accident near Broomfield, Colorado. The pilot and pilot-rated passenger sustained fatal injuries. The flight was being operated as a Title 14…
- [NTSB OPS25LA034](https://openairdocs.org/ntsb/OPS25LA034.md): Embraer ERJ 170-100 LR · Washington, DC · Incident · Class 3 · Limited · Preliminary report · May 1, 2025 · N879RW · 2 aircraft · No damage
  > On May 1, 2025, about 1433 eastern daylight time (EDT), Priority Air Transport flight 23 (PAT23), (tail number forthcoming), a UH-60 Blackhawk helicopter landing at the Pentagon Heliport (JPN), and Republic Airways flight 5825 (RPA5825), an Embraer 170,…
- [NTSB ERA25FA187](https://openairdocs.org/ntsb/ERA25FA187.md): Mooney M20TN · Sparta, TN · Accident · 3 fatal · Class 3 · Field · Preliminary report · Apr 26, 2025 · N242RE · Substantial damage
  > On April 26, 2025, about 1147 central daylight time, a Mooney M20TN, N242RE, was substantially damaged when it was involved in an accident near Sparta, Tennessee. The private pilot and two passengers were fatally injured. The airplane was operated as a Title…
- [NTSB WPR25LA136](https://openairdocs.org/ntsb/WPR25LA136.md): D'Apuzzo Senior Aero Sport · Phoenix, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Apr 19, 2025 · N321WC · Substantial damage
  > On April 19, 2025, about 1106 Pacific daylight time, an experimental amateur built D'Apuzzo Senior Aero Sport, N321WC, was substantially damaged when it was involved in an accident near Phoenix, Arizona. The pilot was not injured. The airplane was operated as…
- [NTSB WPR25FA127](https://openairdocs.org/ntsb/WPR25FA127.md): Azalea Saberwing · Justin, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 12, 2025 · N121DF · Destroyed
  > On April 11, 2025, about 1906 central daylight time (CDT), an experimental amateur-built Azalea Aviation LLC Saberwing, N121DF, was destroyed when it was involved in an accident near Justin, Texas. The pilot was fatally injured. The airplane was operated as a…
- [NTSB CEN25FA148](https://openairdocs.org/ntsb/CEN25FA148.md): Anusiewicz Cassutt III M · Haskell, OK · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 8, 2025 · N5RR · Substantial damage
  > On April 8, 2025, about 1459 central daylight time, a Cassutt III M airplane, N5RR, was substantially damaged when it was involved in an accident near Haskell, Oklahoma. The pilot was fatally injured. The aircraft was operated as a Title 14 Code of Federal…
- [NTSB CEN25FA144](https://openairdocs.org/ntsb/CEN25FA144.md): Cessna 210L · Raceland, LA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Apr 3, 2025 · N1574P · Destroyed
  > On April 2, 2025, at 2030 central daylight time, a Cessna 210L airplane, N1574P, was destroyed when it was involved in an accident near Raceland, Louisiana. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB ERA25FA163](https://openairdocs.org/ntsb/ERA25FA163.md): Cessna 310Q · Midvale, OH · Accident · 1 fatal · Class 3 · Field · Preliminary report · Apr 1, 2025 · N8242Q · Substantial damage
  > On April 1, 2025, about 1704 eastern daylight time, a Cessna 310Q, N8242Q, was substantially damaged when it was involved in an accident near Midvale, Ohio. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…
- [NTSB CEN25FA141](https://openairdocs.org/ntsb/CEN25FA141.md): Socata TBM700A · Brooklyn Park, MN · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 29, 2025 · N721MB · Destroyed
  > On March 29, 2025, about 1221 central daylight time, a Socata TBM700A airplane, N721MB, was destroyed when it was involved in an accident near Brooklyn Park, Minnesota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB OPS25LA025](https://openairdocs.org/ntsb/OPS25LA025.md): Boeing 737-823 · Goodyear, AZ · Incident · Class 4 · Limited · Investigation open · Feb 26, 2025 · N955NN · 2 aircraft · No damage
- [NTSB CEN25LA103](https://openairdocs.org/ntsb/CEN25LA103.md): Starduster II · Azle, TX · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 24, 2025 · N78WT · Destroyed
  > On February 24, 2025, at 1430 central standard time, a Starduster II airplane, N78WT, was destroyed when it was involved in an accident near Azle, Texas. The private pilot and a passenger received minor injuries. The airplane was operated as a Title 14 Code…
- [NTSB WPR25FA097](https://openairdocs.org/ntsb/WPR25FA097.md): Lancair 360 · Marana, AZ · Accident · 2 fatal · Class 3 · Field · Preliminary report · Feb 19, 2025 · N3602M · 2 aircraft · Destroyed
  > On February 19, 2025, about 0828 mountain standard time, a Lancair 360 Mk II, N3602M, was destroyed, and a Cessna 172S, N463ER, sustained minor damage when they were involved in a mid-air collision near Marana Regional Airport (AVQ), Marana, Arizona. The…
- [NTSB ERA25LA113](https://openairdocs.org/ntsb/ERA25LA113.md): Vulcanair S P A Vulcanair V1.0 · Cheswold, DE · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Feb 8, 2025 · N186DS · Substantial damage
  > On February 7, 2025, at 2233 eastern standard time, a Vulcanair S.p.A V1.0, N186DS, was substantially damaged when it was involved in an accident near Cheswold, Delaware. The private pilot and pilot-rated passenger were uninjured. The airplane was operated as…
- [NTSB WPR25LA084](https://openairdocs.org/ntsb/WPR25LA084.md): Cessna P210N · Prescott, AZ · Accident · No injuries · Class 3 · Limited · Preliminary report · Jan 18, 2025 · N4626K · Substantial damage
  > On January 18, 2025, about 1210 Mountain standard time, a Cessna P210N, N4626K, sustained substantial damage when it was involved in an accident near Prescott, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…

Next page: https://openairdocs.org/ntsb-phases/500/cases.md?status=ongoing&page=3

## 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."completionStatus" = 'Ongoing'
  AND c."mKey" IN (SELECT case_mkey FROM case_phases WHERE main = 500)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-phases/500/cases?page=2&status=ongoing

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
