NTSB investigations, 2008, UT
3 cases where the sequence of events included Off-field or emergency landing.
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 10 |
| 2010 | 8 |
| 2011 | 9 |
| 2012 | 2 |
| 2013 | 8 |
| 2014 | 3 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 7 |
| 2018 | 4 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 5 |
| 2022 | 3 |
| 2023 | 1 |
| 2024 | 5 |
| 2025 | 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 year(c.\"eventDate\") = 2008
AND c.\"eventStateOrRegion\" = 'UT' AND c.\"eventCountry\" = 'USA'
AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' 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 year(c."eventDate") = 2008 AND c."eventStateOrRegion" = 'UT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '440' 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 WPR09CA006Accident · No injuriesData collectionFinal reportCessna 210-5(205) · Payson, UTThe total loss of engine power during cruise flight for undetermined reasons. Contributing to the accident were a dark night and a cherry orchard at the location where the pilot executed the forced landing.NTSB LAX08LA240Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Bountiful, UTA partial loss of engine power for undetermined reasons.NTSB SEA08LA160Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · East Carbon, UTThe pilot's inadequate in-flight planning and decision to continue flight into a canyon area with questionable aircraft performance. Contributing to the accident was the lack of suitable terrain for the precautionary landing and a high density altitude…