Ongoing NTSB investigations, NC

6 cases where the sequence of events included Loss of engine power (partial).

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20252026

Ongoing NTSB investigations, NC per year, 2025–2026: 6 cases
2025	1
2026	5

Where

Open the map

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 c."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA' 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" = '342' 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 c.\"eventStateOrRegion\" = 'NC' AND c.\"eventCountry\" = 'USA'
    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\" = '342' 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 c."eventStateOrRegion" = 'NC' AND c."eventCountry" = 'USA'
  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" = '342' 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 ERA27LA007Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-32-260 · Whiteville, NCOn October 7, 2026, at 2219 eastern daylight time, a Piper PA-32-260, N31RF, was substantially damaged when it was involved in an accident near Whiteville, North Carolina. The private pilot and one passenger sustained minor injuries. The airplane was operated…Oct 8, 2026 · N31RF · Substantial damage NTSB WPR26LA347Accident · No injuriesClass 3 · LimitedPreliminary reportBell 206B-III · Creswell, NCOn September 18, 2026, at 1018 eastern daylight time, a Bell 206B-III, N50141, was substantially damaged when it was involved in an accident near Creswell, North Carolina. The pilot was not injured. The helicopter was being operated as a Title 14 Code of…Sep 18, 2026 · N50141 · Substantial damage NTSB ERA26LA219Accident · Serious injuriesClass 3 · LimitedPreliminary reportRainbow Cheetah XLS · Knightdale, NCOn May 27, 2026, about 1420 eastern daylight time, a special light sport Rainbow Cheetah XLS airplane, N146RC, was substantially damaged when it was involved in an accident near Knightdale, North Carolina. The flight instructor and student pilot were…May 27, 2026 · N146RC · Substantial damage NTSB ERA26LA169Accident · Serious injuriesClass 3 · LimitedPreliminary reportEric Vargosko SW-51 · Iron Station, NCOn April 10, 2026, about 1732 eastern daylight time, an experimental amateur built SW-51 airplane, N551EV, sustained minor damage when it was involved in an accident near Iron Station, North Carolina. The front seat pilot sustained minor injuries, and the…Apr 10, 2026 · N551EV · Minor damage NTSB ERA26LA144Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-140 · Indian Trail, NCOn March 8, 2026, about 1100 eastern daylight time, a Piper PA-28-140, N98360, was substantially damaged when it was involved in an accident near Indian Trail, North Carolina. The pilot and passenger were seriously injured. The airplane was operated as a…Mar 8, 2026 · N98360 · Substantial damage NTSB ERA25LA116Accident · No injuriesClass 3 · LimitedPreliminary reportMackey Property Holdings Sparker · Asheboro, NCOn February 11, 2025, about 0635 eastern standard time, an experimental amateur-built Sparker, N769DM, was substantially damaged when it was involved in an accident near Asheboro, North Carolina. The pilot was not injured. The airplane was operated as a Title…Feb 11, 2025 · N769DM