NTSB investigations, 2015
2 cases where NTSB found Oil system.
Cases per year
| 2009 | 1 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2015 | 2 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 1 |
| 2023 | 1 |
| 2024 | 2 |
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\") = 2015
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '01057261'))
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."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '01057261')) 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 ERA15LA280Accident · No injuriesClass 3 · LimitedFinal reportMD Helicopter 369FF · Vega Baja, PRA total loss of engine power due to insufficient lubrication to the engine's No. 2 bearing, which resulted in the failure of the bearing and a subsequent forced landing.NTSB ERA15LA138Accident · No injuriesLimited investigationFinal reportBell 206 · Sevierville, TNAn uncontained engine failure, which resulted from insufficient lubrication of the No. 4 bearing due to carbon buildup on the filter screen of the bearing's oil supply nozzle.