Skip to content

Ongoing NTSB investigations, 2025

18 cases where the sequence of events included Aerodynamic stall/spin.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20242026

Where

Latest cases

Query with SQL

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 year(c."eventDate") = 2025 AND c."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

duckdb -csv -c "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 year(c.\"eventDate\") = 2025
    AND c.\"completionStatus\" = 'Ongoing'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\"))
  ORDER BY c.\"eventDate\" DESC, c.\"ntsbNumber\" DESC"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

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 year(c."eventDate") = 2025
  AND c."completionStatus" = 'Ongoing'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

NTSB ERA26FA034Accident · 1 fatalClass 3 · FieldPreliminary reportExtra Flugzeugproduktions EA 300/SC · Keystone Heights, FLOn 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…Nov 8, 2025 · N330SL · Destroyed NTSB CEN26LA001Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28R-200 · Colorado Springs, COOn October 1, 2025, about 0412 mountain daylight time, a Piper PA-28R-200 airplane, N999AD, was substantially damaged during an accident near Colorado Springs, Colorado. The pilot sustained minor injuries, and the 2 passengers were not injured. The airplane…Oct 1, 2025 · N999AD · Substantial damage NTSB ANC25LA105Accident · Serious injuriesClass 3 · LimitedPreliminary reportMaule M-5-235C · Point MacKenzie, AKOn 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…Sep 13, 2025 · N343GA · Substantial damage NTSB ERA25FA332Accident · 1 fatalClass 3 · FieldPreliminary reportCzech Sport Sportcruiser · Fryeburg, MEOn September 4, 2025, about 1418 eastern daylight time, a Czech Sport Aircraft Sportcruiser, N336SC, was substantially damaged when it was involved in an accident near Fryeburg, Maine. The private pilot was fatally injured. The airplane was operated as a…Sep 4, 2025 · N336SC · Substantial damage NTSB CEN25FA339Accident · 1 fatalClass 3 · FieldPreliminary reportRans S-12 Airaile · Concordia, KSOn 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…Aug 25, 2025 · N2757A · Substantial damage NTSB WPR25FA257Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 140 · Shelter Cove, CAOn August 17, 2025 about 1521 Pacific daylight time, a Cessna 140, N89447, was involved in an accident near Shelter Cove, California. The student pilot was fatally injured, and the passenger sustained serious injuries. The airplane was operated as a Title 14…Aug 17, 2025 · N89447 NTSB ANC25LA084Accident · Serious injuriesClass 3 · LimitedPreliminary reportAeronca 7AC · Willow, AKOn August 5, 2025, about 1600 Alaska daylight time, an Aeronca 7AC airplane, N84726, was substantially damaged when it was involved in an accident at the Willow Airport (UUO) in Willow, Alaska. The student pilot sustained serious injuries. The airplane was…Aug 6, 2025 · N84726 · Substantial damage NTSB ANC25LA080Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 150J · Soldotna, AKOn July 31, 2025, about 1300 Alaska daylight time, a Cessna 150J airplane, N60509, was substantially damaged when it was involved in an accident near Soldotna, Alaska. The instructor pilot sustained minor injuries and the pilot receiving instruction was…Jul 31, 2025 · N60509 · Substantial damage NTSB WPR25FA225Accident · 3 fatalClass 3 · FieldPreliminary reportMooney M20J · Nampa, IDOn August 27, 2025, about 1741 mountain daylight time, a Mooney M20J, N5764H, was destroyed when it was involved in an accident near Nampa, Idaho. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code of Federal…Jul 27, 2025 · N5764H · Substantial damage NTSB WPR25LA211Accident · Serious injuriesClass 3 · LimitedPreliminary reportCessna 172S · Sisters, OROn July 13, 2025, about 1106 Pacific daylight time, a Cessna 172S, N787LF, was substantially damaged when it was involved in an accident near Sisters, Oregon. The flight instructor was seriously injured, and the student pilot and pilot rated passenger…Jul 13, 2025 · N787LF · Destroyed NTSB ERA25LA265Accident · Serious injuriesClass 3 · LimitedPreliminary reportMoyes Liteflite PTY C Dragonfly · Charlestown, NHOn July 13, 2025, about 1915 eastern daylight time, a Moyes Liteflite Model C Dragonfly airplane, N4010E, was substantially damaged when it was involved in an accident near Charleston, New Hampshire. The pilot was seriously injured. The airplane was operated…Jul 13, 2025 · N4010E · Substantial damage NTSB ERA25FA248Accident · 1 fatalClass 3 · FieldPreliminary reportRobert Fidler Lancair 320/360 · Zeeland, MIOn June 29, 2025, at 10:49 eastern daylight time, an experimental, amateur-built Lancair 360, N360RF, was destroyed when it was involved in an accident near Zeeland, Michigan. The private pilot was fatally injured. The airplane was operated as a Title 14 Code…Jun 29, 2025 · N360RF · Destroyed NTSB CEN25FA224Accident · 2 fatalClass 3 · FieldPreliminary reportVans RV-10 · Capron, ILOn June 28, 2025, about 0934 central daylight time, a Vans RV-10 airplane, N847CS, was substantially damaged during an accident near Capron, Illinois. The pilot and flight instructor were fatally injured. The airplane was operated as a Title 14 Code of…Jun 28, 2025 · N847CS · Substantial damage NTSB WPR25FA182Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Billings, MTOn June 19, 2025, at 1412 mountain daylight time, a Cessna 172K airplane, N79306, was destroyed when it was involved in an accident near Billings, Montana. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…Jun 19, 2025 · N79306 · Substantial damage NTSB CEN25FA178Accident · 2 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Broomfield, COOn 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…May 17, 2025 · N4321Z · Destroyed NTSB ERA25LA177Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech A24 · Greenville, SCOn April 17, 2025, about 1540 eastern daylight time, a Beech A24 airplane, N8060R, was substantially damaged when it was involved in an accident at the Greenville Downtown Airport (GMU), Greenville, South Carolina. The pilot sustained minor injuries. The…Apr 17, 2025 · N8060R · Substantial damage NTSB ERA25FA163Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 310Q · Midvale, OHOn 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…Apr 1, 2025 · N8242Q · Substantial damage NTSB CEN25LA103Accident · Minor injuriesClass 3 · LimitedPreliminary reportStarduster II · Azle, TXOn 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…Feb 24, 2025 · N78WT · Destroyed