Ongoing NTSB investigations, KS
180,604 investigations by the National Transportation Safety Board since 1962: 174,583 accidents, the rest incidents and other occurrences. Each has NTSB’s narrative and, once the investigation is done, its probable cause; since 2008, its findings and sequence of events.
Cases per year
| 2024 | 1 |
|---|---|
| 2025 | 2 |
| 2026 | 4 |
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\" = 'KS' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Ongoing'
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" = 'KS' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Ongoing' 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 CEN27LA017AccidentClass 3 · LimitedInvestigation openDonald K Stovall Pietenpol Aircamper · Syracuse, KSNTSB CEN26LA217Accident · No injuriesClass 3 · LimitedPreliminary reportAutogyro Cavalon · Coffeyville, KSOn June 2, 2026, at 0837 central daylight time, an AutoGyro Cavalon gyroplane, N113CX, was substantially damaged when it was involved in an accident near Coffeyville, Kansas. The pilot was not injured. The gyroplane was operated as a Title 14 Code of Federal…NTSB CEN26LA173Accident · Minor injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Chanute, KSOn April 23, 2026, at about 1445 central daylight time, a Cirrus SR22T was substantially damaged when it was involved in an accident near Chanute, Kansas. The pilot and pilot-rated passenger sustained minor injuries. The airplane was operated as a Title 14…NTSB CEN26LA123Accident · No injuriesClass 3 · LimitedPreliminary reportGrumman AA5 · Admire, KSOn February 23, 2026, about 0958 central standard time, a Grumman AA-5A airplane, N9939U, was substantially damaged when it was involved in an accident near Admire, Kansas. The pilot and passenger were not injured. The airplane operated under the provisions…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…NTSB CEN25FA166Accident · 1 fatalClass 3 · FieldPreliminary reportPiper J3C-65 · Wilson, KSOn May 4, 2025, about 1325 central daylight time, a Piper J3C-65 airplane, N98416 was destroyed when it was involved in an accident near Wilson, Kansas. The pilot was fatally injured. The flight was operated under the provisions of Title 14 Code of Federal…NTSB CEN25LA028Accident · 1 fatalClass 3 · LimitedPreliminary reportCessna 182Q · Rose Hill, KSOn October 26, 2024, about 1440 central daylight time, a Cessna 182Q airplane was not damaged when it was involved in an accident near Rose Hill, Kansas. The pilot was not injured, and a passenger sustained fatal injuries. The airplane was operated as a Title…