Ongoing NTSB investigations, AR
5 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2025 | 4 |
|---|---|
| 2026 | 1 |
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\" = 'AR' 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\" = '341' 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" = 'AR' 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" = '341' 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 CEN26FA126Accident · 1 fatalClass 3 · FieldPreliminary reportPeck JODEL-F12 · Rogers, AROn February 26, 2026, about 1330 central standard time, a Peck Jodel-F12, N30P, experimental airplane, was destroyed when it was involved in an accident near Rogers, Arkansas. The pilot sustained fatal injuries. The airplane was operated under Title 14 Code…NTSB CEN26LA029Accident · Serious injuriesClass 3 · LimitedPreliminary reportBeech 35-33 · Flippin, AROn October 23, 2025, about 1713 central daylight time, a Beech 35-33 airplane, N864R, was substantially damaged when it was involved in an accident near Flippin, Arkansas. The pilot sustained serious injuries. The airplane was operated as a Title 14 Code of…NTSB CEN25LA305Accident · No injuriesClass 3 · LimitedPreliminary reportStolp Starduster SA300 · Marshall, AROn August 6, 2025 about 1552 central daylight time, a Stolp Starduster SA 300 airplane was substantially damaged when it was involved in an accident near Marshall, Arkansas. The pilot was not injured. The airplane was operated under the provisions of Title 14…NTSB CEN25LA162Accident · No injuriesClass 3 · LimitedPreliminary reportCessna T210N · Fayetteville, AROn April 22, 2025, about 13:25 central daylight time a Cessna T210N, N4795C was involved in an accident near Fayetteville, Arkansas. The pilot and two passengers were not injured. The flight was operated under the provisions of Title 14 Code of Federal…NTSB CEN25LA094Accident · Minor injuriesClass 3 · LimitedPreliminary reportBeech 58P · Pine Bluff, AROn February 5, 2025, about 1848 central standard time, a Beech 58P airplane, N138TL, was substantially damaged when it was involved in an accident near Pine Bluff, Arkansas. The pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…