Ongoing NTSB investigations
3 cases where the sequence of events included Engine shutdown.
Cases per year
| 2025 | 2 |
|---|---|
| 2026 | 1 |
Where
Latest 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.\"completionStatus\" = 'Ongoing'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '140' 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."completionStatus" = 'Ongoing' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '140' 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 ERA26LA097Accident · No injuriesClass 3 · LimitedPreliminary reportHughes 369 · North Augusta, SCOn January 22, 2026, at 1600 eastern standard time, a Hughes 369D, N105AC, was substantially damaged when it was involved in an accident near North Augusta, South Carolina. The pilot was not injured. The helicopter was operated as a Title 14 Code of Federal…NTSB ERA26LA066Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna TU206 · Pell City, ALOn December 11, 2025, about 1340 central standard time, a Cessna TU206F, N917WC, was substantially damaged when it was involved in an accident near Pell City, Alabama. The commercial pilot was not injured. The single passenger sustained minor injuries. The…NTSB DCA25FA148Incident · No injuriesClass 3 · FieldPreliminary reportBoeing 767 · Newark, NJOn March 1, 2025, at 0800 eastern standard time, FedEx flight 3609, a Boeing 767-300F, powered by two General Electric CF6-80C2 turbofan engines, registration number N178FE, struck birds during initial climb after takeoff from Newark Liberty International…