Final NTSB investigations, UT
8 cases where the defining event was Unknown or undetermined.
Cases per year
| 2011 | 1 |
|---|---|
| 2016 | 1 |
| 2020 | 1 |
| 2021 | 1 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
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.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
AND c.\"completionStatus\" = 'Completed'
AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '000')
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" = 'UT' AND c."eventCountry" = 'USA' AND c."completionStatus" = 'Completed' AND c."mKey" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e."isDefiningEvent" AND e."tier2Number" = '000') 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 WPR25LA027Accident · No injuriesClass 3 · LimitedFinal reportCirrus Design SR20 · St. George, UTA partial loss of power for reasons that could not be determined due to postimpact fire damage.NTSB WPR24LA127Accident · No injuriesClass 3 · LimitedFinal reportSchleicher Alexander ASH 26 E · Heber, UTReduced takeoff performance for reasons that could not be determined, which resulted in a forced landing.NTSB WPR23LA343Accident · Minor injuriesClass 3 · LimitedFinal reportBoeing A75N1(PT17) · Monticello, UTA partial loss of engine power for reasons that could not be determined.NTSB WPR22LA127Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-32R-300 · St. George, UTThe total loss of engine power for undetermined reasons.NTSB WPR22LA064Accident · No injuriesClass 3 · LimitedFinal reportBeech A36 · Tooele, UTThe total loss of engine power for reasons that could not be determined based on available evidence.NTSB WPR21LA068Accident · Serious injuriesClass 3 · LimitedFinal reportCirrus Design SR22 · Ogden, UTThe partial loss of engine power for reasons that cannot be determined due to lack of available evidence.NTSB WPR16FA054Accident · 2 fatalField investigationFinal reportCessna 525 · Cedar Fort, UTThe pilot's loss of control due to spatial disorientation while operating in instrument meteorological conditions, which resulted in an exceedance of the airplane's design stress limitations, and a subsequent in-flight breakup. Contributing to the accident…NTSB WPR11FA429Accident · 1 fatalField investigationFinal reportBrewster LONG-EZ · Kanab, UTThe pilot's loss of airplane control during cruise flight.