Ongoing NTSB investigations, GA
3 cases where the sequence of events included Powerplant sys/comp malf/fail.
Cases per year
| 2025 | 1 |
|---|---|
| 2026 | 2 |
Where
Open the mapLatest cases
Query with SQL
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\" = 'GA' 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\" = '340' 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" = 'GA' 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" = '340' 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 ENG26LA029Incident · No injuriesClass 3 · LimitedPreliminary reportBoeing 757 · Atlanta, GAOn July 24, 2026, about 14:32 Coordinated Universal Time, a Delta Air Lines Boeing 757-200, N662DN, powered by two Pratt & Whitney PW2037 turbofan engines, experienced a No. 1 (left) engine fire during initial climb from Hartsfield-Jackson Atlanta…NTSB ERA26FA270Accident · 1 fatalClass 3 · FieldPreliminary reportBeech 95-B55 (T42A) · Metter, GAOn July 13, 2026, about 1114 eastern daylight time, a Beechcraft 95-B55, twin-engine airplane, N55FD, was destroyed when it was involved in an accident near Metter, Georgia. The commercial pilot was fatally injured. The airplane was operated as a Title 14…NTSB DCA25LA139Incident · Minor injuriesClass 3 · LimitedPreliminary reportBoeing 717 · Atlanta, GAOn February 24, 2025, at 0848 eastern standard time, Delta Air Lines flight 876, a Boeing 717-200, N942AT, experienced smoke in the cabin and cockpit during takeoff from Atlanta Hartsfield/Jackson International Airport (ATL), Atlanta Georgia. The airplane…