Ongoing NTSB investigations, WY
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 | 5 |
| 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\" = 'WY' 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" = 'WY' 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 WPR27LA022Accident · No injuriesLimited investigationInvestigation openHonda HA-420 · Alpine, WYNTSB WPR26LA209Accident · No injuriesClass 3 · LimitedPreliminary reportCirrus Design SR22T · Casper, WYOn June 1, 2026, about 1340 mountain daylight time, a Cirrus Design Corp SR22T, N324WY, was substantially damaged when it was involved in an accident near Casper, Wyoming. The pilot was not injured. The airplane was operated as a Title 14 Code of Federal…NTSB WPR25LA299Accident · Serious injuriesClass 3 · LimitedPreliminary reportVans RV3-A · Torrington, WYOn September 27, 2025, about 1600 mountain daylight time, an experimental amateur-built Vans RV-3A, N16MR, sustained substantial damage when it was involved in an accident near Torrington, Wyoming. The pilot was seriously injured. The airplane was operated as…NTSB ANC25FA098Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · Wolf, WYOn September 1, 2025 about 1612 mountain daylight time, a Piper PA-28-180 airplane, N8307W, was substantially damaged when it was involved in an accident near Wolf, Wyoming. The pilot and one passenger were seriously injured; one passenger was fatally…NTSB DCA25LA276Accident · Serious injuriesClass 3 · LimitedPreliminary reportAirbus A330 · Creston, WYOn July 30, 2025, at 1723 mountain daylight time, Delta Air Lines flight 56, an Airbus A330-941, encountered severe turbulence while in cruise flight at an altitude of 37,000 ft near Creston, Wyoming. After determining that injuries had occurred, the flight…NTSB WPR25LA154Accident · No injuriesClass 3 · LimitedPreliminary reportLee JA30 Superstol · Evanston, WYOn May 9, 2025, about 1020 mountain daylight time, an experimental amateur-built Just Aircraft Superstol, N128EL, was substantially damaged when it was involved in an accident near Evanston, Wyoming. The pilot and passenger were not injured. The airplane was…NTSB WPR25FA079Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Rock Springs, WYOn January 14, 2025, about 0622 mountain standard time, a Piper PA-24-250, N6502P, was destroyed when it was involved in an accident near Rock Springs, Wyoming. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations…NTSB WPR25LA045Accident · No injuriesClass 3 · LimitedPreliminary reportBombardier CL-600-2B16 · Jackson, WYOn November 17, 2024, about 0945 mountain standard time, a Bombardier Inc. CL-600-2B16 (Challenger 650), N247QS, was substantially damaged when it was involved in an accident near Jackson, Wyoming. The 2 pilots and 9 passengers were not injured. The airplane…