NTSB investigations, 2011
14 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\") = 2011
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") = 2011 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 ERA12LA126Accident · No injuriesLimited investigationFinal reportClassic Waco YMF5 · Marathon, FLThe pilot did not ensure that there was sufficient fuel aboard the airplane before initiating the flight, which resulted in temporary fuel starvation and an interruption in engine power during maneuvering. Contributing to the accident was the pilot’s decision…NTSB ERA12LA085Accident · Serious injuriesLimited investigationFinal reportPiper PA 46-350P · Caribbean Sea, A1The total loss of engine power during cruise flight for reasons that could not be determined because the airplane was not recovered. Contributing to the accident was the pilot’s failure to comply with the airplane and engine limitations, and his decision to…NTSB ERA12LA071Accident · No injuriesLimited investigationFinal reportSiai-Marchetti S205-22R · Okeechobee, FLA partial loss of engine power due to a failure of the drive bearings in the alternator drive system. Contributing to the accident was the inadequate maintenance.NTSB ERA12CA059Accident · Minor injuriesData collectionFinal reportBeech F33A · Chesterfield, VAA total loss of engine power due to fuel starvation, as a result of the pilot's improper fuel management.NTSB ERA12FA002Accident · 1 fatalField investigationFinal reportTemco GC-1B · Ewell, MDThe pilot's improper fuel management in that he did not verify the fuel selector position before beginning the flight or after the power loss, which resulted in a total loss of engine power due to fuel starvation and subsequent ditching.NTSB ANC11LA099Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Unalaska, AKA loss of engine power in cruise flight for undetermined reasons.NTSB ERA11LA429Accident · Minor injuriesLimited investigationFinal reportCessna 172M · Pahokee, FLThe flight instructor's misjudgment of the airplane's position and airspeed relative to the runway while returning to the airport after a partial loss of engine power. Contributing to the accident was the separation of the engine's No. 3 cylinder exhaust…NTSB CEN11CA516Accident · Serious injuriesData collectionFinal reportCessna 150F · Harbor Beach, MIThe pilot's delay in using carburetor heat while operating in carburetor icing conditions, resulting in carburetor ice and subsequent partial loss of engine power.NTSB ANC11LA068Accident · No injuriesLimited investigationFinal reportCessna 185 · Kenai, AKThe loss of engine power for an undetermined reason, resulting in the ditching and sinking of the airplane in ocean waters.NTSB ERA11LA405Accident · Serious injuriesLimited investigationFinal reportCessna U206G · Matinicus Island, METhe pilot’s improper fuel management, which resulted in a total loss of engine power due to fuel starvation.NTSB ERA11LA388Accident · No injuriesLimited investigationFinal reportCessna 172N · Orange Beach, ALThe operation of the airplane using unapproved fuels, which resulted in abnormal combustion and subsequent damage to the No. 3 cylinder. Contributing to the accident was the inadequate 100-hour inspection because the mechanic failed to note the lack of…NTSB WPR11CA208Accident · No injuriesData collectionFinal reportDoktor Fiberglas H101 Salto · Peoria, AZThe glider's encounter with turbulence and loss of lift, which resulted in a ditching in a lake.NTSB CEN11LA311Accident · No injuriesLimited investigationFinal reportMooney M20K · New Orleans, LAA loss of electrical and engine power for undetermined reasons.NTSB ERA11LA112Accident · Serious injuriesLimited investigationFinal reportBeech A23-24 · Venice, FLThe loss of engine power for undetermined reasons.