NTSB investigations, 2015, MI
4 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 6 |
|---|---|
| 2009 | 5 |
| 2010 | 9 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 4 |
| 2016 | 3 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 6 |
| 2020 | 3 |
| 2021 | 4 |
| 2022 | 2 |
| 2023 | 2 |
| 2024 | 2 |
| 2025 | 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 year(c.\"eventDate\") = 2015
AND c.\"eventStateOrRegion\" = 'MI' 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") = 2015 AND c."eventStateOrRegion" = 'MI' 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 CEN15LA421Accident · Serious injuriesLimited investigationFinal reportLerch RV6A · Deckerville, MIThe in-flight loss of engine oil after the oil filter separated from the engine adapter assembly because of an incorrect modification of the oil filter adapter assembly, which resulted in a precautionary landing in a field.NTSB CEN15LA332Accident · Minor injuriesLimited investigationFinal reportAlon A2 · Holland, MIA total loss of engine power due to fuel starvation during cruise flight. Contributing to the accident was the pilot’s inadequate preflight fuel planning.NTSB CEN15LA346Accident · No injuriesLimited investigationFinal reportErcoupe 415 · Saint Martin Island, MIThe failure of a connecting rod bearing, which resulted in a loss of engine power.NTSB CEN15LA157Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Frankenmuth, MIThe failure of the engine due to a lack of oil lubrication for reasons that could not be determined during postaccident examinations.