NTSB investigations
20 cases where NTSB found Choppy surface.
Cases per year
| 2011 | 1 |
|---|---|
| 2013 | 1 |
| 2015 | 2 |
| 2016 | 3 |
| 2017 | 5 |
| 2018 | 1 |
| 2019 | 2 |
| 2020 | 2 |
| 2023 | 2 |
| 2024 | 1 |
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 c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03023030')) 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 c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03023030')) 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 CEN24LA255Accident · No injuriesClass 4 · LimitedFinal reportAir Tractor AT-802 · Brad, TXThe pilot’s failure to maintain airplane control after encountering a large boat wake.NTSB WPR23LA326Accident · No injuriesClass 4 · LimitedFinal reportHenry Steven J JA 30 Superstol · Leavenworth, WAThe pilot's failure to maintain airplane control during taxi, which resulted in a nose over.NTSB CEN23LA290Accident · No injuriesClass 4 · LimitedFinal reportGood James AIR CAM · Caswell Beach, NCThe pilot’s failure to properly evaluate the sea state during an open sea landing and subsequent takeoff attempt resulting in an inadvertent impact with the water.NTSB WPR21LA013Accident · No injuriesClass 4 · LimitedFinal reportRalph C Kimball Sea Rey · Parker Dam, CAThe inadvertent encounter with water wake during the takeoff sequence that degraded the airplane’s airspeed and resulted in the pilot’s failure to maintain clearance from obstacles during the initial climb.NTSB CEN20CA348Accident · No injuriesClass 4 · Data collectionFinal reportProgressive Aerodyne Searey · League City, TXThe pilot's failure to maintain airplane control during a water takeoff after an encounter with the wake from a boat.NTSB ANC19FA035Accident · 1 fatalClass 2 · FieldFinal reportDe Havilland Beaver DHC 2 · Seldovia, AKThe airplane's floats impact with an ocean wave or swell, which exceeded the design load specifications of the flying wire assemblies and resulted in a partial separation of the float assemblies.NTSB ERA19LA156Accident · No injuriesClass 3 · LimitedFinal reportCessna 208 · Key West, FLThe pilot's decision to attempt a takeoff in rough sea conditions, resulting in damage to the floats and the sinking of the seaplane.NTSB GAA18CA336Accident · No injuriesData collectionFinal reportAviat A 1 · Renton, WAThe pilot’s inadequate crosswind correction, which resulted in the right wing impacting the water’s surface.NTSB ANC17LA053Accident · No injuriesLimited investigationFinal reportCessna U206G · Kodiak, AK***This probable cause was modified on November 27, 2018. Please see the docket for this accident to view the original probable cause.*** The pilot's improper decision to takeoff in an area of rough water and ocean swells, which resulted in a failure of the…NTSB CEN17FA287Accident · 2 fatalField investigationFinal reportAerofab Lake LA 4 250 · Oshkosh, WIThe pilot's failure to properly configure the airplane for takeoff and his decision to takeoff with a tailwind in unfavorable water conditions, which resulted in the airplane entering an aerodynamic stall and the pilot losing control.NTSB CEN17LA283Accident · Minor injuriesLimited investigationFinal reportCessna 180 · Austin, TXThe pilot's improper decision to attempt to take off after two previous failed attempts from choppy water with a high outside temperature and the airplane near its maximum gross weight, which degraded the airplane’s performance and resulted in its inability…NTSB GAA17CA574Accident · No injuriesData collectionFinal reportCessna 208 · New York, NYThe airplane’s encounter with boat wake and multiple swells during a water takeoff.NTSB GAA17CA332Accident · No injuriesData collectionFinal reportCessna 208 · Elfin Cove, AKThe pilot’s failure to recognize the magnitude of the swell size during landing, which resulted in a tail-low hard water landing.NTSB GAA16CA524Accident · Minor injuriesData collectionFinal reportVan Hoomissen Gerald J Murphy Elite · Nordman, IDThe floatplane pilot's improper landing flare during landing on choppy water with a tailwind, which resulted in a nose-over. Contributing to the accident was the pilot's failure to determine the wind direction before landing.NTSB GAA16CA370Accident · No injuriesData collectionFinal reportCessna 180 · New Durham, NHThe pilot's failure to maintain directional control during landing after encountering a boat wake, which resulted in the airplane veering left, impacting the water's surface, and subsequently becoming submerged.NTSB GAA16CA310Accident · Minor injuriesData collectionFinal reportConsolidated Aeronautics Lake LA 4 · Greers Ferry, ARThe amphibious airplane pilot's incorrect pitch attitude during landing on choppy water, which resulted in a nose over, and substantial damage to the fuselage.NTSB GAA16CA062Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA-4 · Morganton, NCThe pilot's failure to maintain directional control during the departure, resulting in substantial damage to the airplanes right wing.NTSB GAA15CA078Accident · No injuriesData collectionFinal reportConsolidated Aeronautics Lake LA4-200 · Mineral, VAThe pilot's failure to maintain directional control during a high-speed water taxi in rough water conditions, resulting in a collision with a dock.NTSB WPR13CA140Accident · Minor injuriesData collectionFinal reportWeston SEA-ERA · Bellevue, WAThe pilot’s failure to maintain control during takeoff on choppy water conditions.NTSB ERA12LA358Accident · No injuriesLimited investigationFinal reportCessna 182C · Efland, NCThe pilot’s loss of directional control during the landing roll, which resulted in a collision with a ditch.