NTSB investigations, 2015, AZ
4 cases where the sequence of events included Loss of engine power (partial).
Cases per year
| 2008 | 4 |
|---|---|
| 2009 | 4 |
| 2010 | 3 |
| 2011 | 3 |
| 2012 | 1 |
| 2013 | 6 |
| 2014 | 5 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 5 |
| 2018 | 4 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 4 |
| 2022 | 4 |
| 2023 | 2 |
| 2024 | 1 |
| 2025 | 4 |
| 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 year(c.\"eventDate\") = 2015
AND c.\"eventStateOrRegion\" = 'AZ' 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\" = '342' 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") = 2015 AND c."eventStateOrRegion" = 'AZ' 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" = '342' 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 WPR16LA033Accident · No injuriesClass 3 · LimitedFinal reportPiper PA 28-140 · Wickenburg, AZA partial loss of engine power due to a separation of the mixture control cable clamp, which was either not installed or secured correctly during maintenance.NTSB WPR15LA254Accident · Minor injuriesLimited investigationFinal reportRaudenbush Ernie Lancair Super ES · Winkelman, AZA partial loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no anomalies.NTSB WPR15LA139Accident · No injuriesLimited investigationFinal reportBeech H35 · Tucson, AZA partial loss of engine power during initial takeoff climb for reasons that could not be determined because postaccident examination revealed no evidence of a mechanical anomaly that would have precluded normal operation.NTSB WPR15LA131Accident · Serious injuriesLimited investigationFinal reportMccurry Charles P F 1 Rocket · Sedona, AZThe partial loss of engine power during final approach for reasons that could not be determined during postaccident examination of the engine.