NTSB investigations, 2018, PA
6 cases where the sequence of events included Loss of engine power (total).
Cases per year
| 2008 | 5 |
|---|---|
| 2009 | 4 |
| 2010 | 4 |
| 2011 | 3 |
| 2012 | 4 |
| 2013 | 4 |
| 2014 | 1 |
| 2015 | 5 |
| 2016 | 3 |
| 2017 | 6 |
| 2018 | 6 |
| 2019 | 4 |
| 2020 | 2 |
| 2021 | 5 |
| 2022 | 1 |
| 2024 | 1 |
| 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\") = 2018
AND c.\"eventStateOrRegion\" = 'PA' 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") = 2018 AND c."eventStateOrRegion" = 'PA' 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 ERA19LA063Accident · No injuriesClass 3 · LimitedFinal reportLancair LC41 · Moscow, PAA total loss of engine power and catastrophic engine failure due to the failure of the left turbocharger, which resulted in oil loss and oil starvation. Contributing to the accident was the failure of maintenance personnel to overhaul the turbocharger in…NTSB ERA19LA024Accident · Minor injuriesLimited investigationFinal reportBeech 35 · State College, PAThe pilot's mismanagement of the available fuel, which resulted in a total loss of engine power due to fuel starvation.NTSB GAA19CA015Accident · No injuriesData collectionFinal reportTitan Titan Tornado 912 · Corry, PAThe pilot’s improper preflight fuel planning, which resulted in fuel exhaustion and the subsequent total loss of engine power.NTSB ERA18LA243Accident · No injuriesClass 3 · LimitedFinal reportPiper PA12 · Cochranton, PAA total loss of engine power for reasons that could not be determined based on the available information.NTSB ERA18LA163Accident · Minor injuriesLimited investigationFinal reportVans RV4 · Butler, PAThe pilot's improper decision to fly the airplane with a known engine problem and his improper modification of the engine control unit fuel delivery software, which led to the engine running too lean and resulted in a total loss of engine power during climb.NTSB ERA18LA072Accident · Minor injuriesClass 3 · LimitedFinal reportCessna P210N · Farmington, PAA total loss of engine power due to fatigue failure of the crankshaft drive gear teeth.