NTSB investigations, 2012, NY
4 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 3 |
|---|---|
| 2009 | 7 |
| 2010 | 6 |
| 2011 | 8 |
| 2012 | 4 |
| 2013 | 4 |
| 2014 | 5 |
| 2015 | 4 |
| 2016 | 6 |
| 2017 | 6 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 2 |
| 2025 | 2 |
| 2026 | 1 |
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 year(c.\"eventDate\") = 2012
AND c.\"eventStateOrRegion\" = 'NY' 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\" = '341' 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") = 2012 AND c."eventStateOrRegion" = 'NY' 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" = '341' 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 ERA13LA060Accident · Minor injuriesLimited investigationFinal reportBeech 35B33 · White Plains, NYThe pilot's improper fuel management and his excessive slip maneuver, which led to fuel starvation and a total loss of engine power, and his failure to activate the electric boost pump during the attempted engine restart.NTSB ERA12LA532Accident · Serious injuriesLimited investigationFinal reportMooney M20C · East Hampton, NYA loss of engine power for reasons that could not be determined because postaccident examination of the engine did not reveal any failures or malfunctions that would have precluded normal operation.NTSB ERA12TA542Accident · No injuriesFinal reportRidge Lowell H Jabiru J230 · Otter Lake, NYA failure of an engine cylinder exhaust valve due to the buildup of lead deposits on the valve stem and fatigue cracking of the valve stem, resulting in a total loss of engine power, and the loss of the propeller. Contributing to the accident was the lack of…NTSB ERA12FA508Accident · 2 fatalField investigationFinal reportBeech A36TC · Clifton Park, NYA total loss of engine power for reasons that could not be determined during the postaccident investigation and testing.