NTSB investigations, 2015
10 cases where the sequence of events included Ditching.
Cases per year
| 2008 | 16 |
|---|---|
| 2009 | 11 |
| 2010 | 13 |
| 2011 | 14 |
| 2012 | 17 |
| 2013 | 10 |
| 2014 | 5 |
| 2015 | 10 |
| 2016 | 10 |
| 2017 | 11 |
| 2018 | 6 |
| 2019 | 6 |
| 2020 | 5 |
| 2021 | 11 |
| 2022 | 8 |
| 2023 | 12 |
| 2024 | 7 |
| 2025 | 10 |
| 2026 | 5 |
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.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '441' 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."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '441' 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 ANC16LA005Accident · Serious injuriesLimited investigationFinal reportCessna 180 · Haines, AKA loss of engine power due to fuel exhaustion for reasons that could not be determined based on available evidence and the pilot’s decision to continue the flight after realizing the remaining fuel quantity was near 0.NTSB ERA16LA009Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami Beach, FLA total loss of engine power for reasons that could not be determined because the airplane was not recovered from the ocean after the ditching.NTSB GAA16CA020Accident · No injuriesData collectionFinal reportBeech A36 · Jasper, TXThe pilot's improper fuel planning, which resulted in fuel exhaustion and ditching the airplane in a lake.NTSB WPR15LA257Accident · 1 fatalLimited investigationFinal reportHughes 369HS · Manra Island, KiribatiA The loss of helicopter control for reasons that could not be determined asbecause the helicopter sank in the oceanwater and was not recovered.NTSB CEN15CA353Accident · Minor injuriesData collectionFinal reportRatte James Aventura II · Tyler, TXThe loss of airplane control during a go around, which resulted in impact with the water. Contributing to the accident was the pilot's lack of seaplane rating and inexperience in the accident airplane.NTSB ANC15FA062Accident · 2 fatalField investigationFinal reportPiper PA 18-150 · Chugiak, AKThe loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal any mechanical malfunctions or failures that would have precluded normal operation.NTSB CEN15LA172Accident · Serious injuriesLimited investigationFinal reportBeech B19 · Osage Beach, MOThe failure of the No. 4 piston wrist pin plug and the subsequent entry of its metal shavings into the oil system, which clogged the oil passages and caused the engine to seize. Contributing to the accident was the installation of engine parts that were not…NTSB ERA15LA133Accident · 1 fatalLimited investigationFinal reportJohnson Joel H Rans S-6ES Coyote II · Rincon, PRThe inadequate maintenance and inspection of the fuel system, which resulted in partial blockage of a fuel filter, a partial loss of engine power, and subsequent ditching.NTSB WPR15LA089Accident · No injuriesLimited investigationFinal reportCirrus SR22 - NO Series · Maui (Pacific Ocean)The pilot's inability to transfer fuel from the aft auxiliary fuel tank to the main fuel tanks for reasons that could not be determined because the airplane was ditched and not recovered.NTSB WPR15CA091Accident · Minor injuriesData collectionFinal reportCessna 172N · Makaha, HIA partial loss of engine power for reasons that could not be determined because the airplane was ditched and not recovered.