NTSB investigations, 2016
16 cases where NTSB found Wet surface.
Cases per year
| 2008 | 10 |
|---|---|
| 2009 | 7 |
| 2010 | 11 |
| 2011 | 4 |
| 2012 | 7 |
| 2013 | 5 |
| 2014 | 13 |
| 2015 | 2 |
| 2016 | 16 |
| 2017 | 4 |
| 2018 | 9 |
| 2019 | 9 |
| 2020 | 12 |
| 2021 | 4 |
| 2022 | 9 |
| 2023 | 5 |
| 2024 | 10 |
| 2025 | 3 |
| 2026 | 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 year(c.\"eventDate\") = 2016
AND c.\"mKey\" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f.\"findingCode\", '03023010'))
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") = 2016 AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03023010')) 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 GAA17CA052Accident · No injuriesData collectionFinal reportChaudoin George S RV 10 · Portsmouth, NHThe pilot’s failure to go around after recognizing that the airplane was high and fast, which resulted in a long landing on a wet runway and a runway excursion.NTSB ERA16LA323Accident · No injuriesLimited investigationFinal reportLearjet 25 · San Juan, PRThe pilot’s improper decision to land the airplane on a wet runway, in heavy rain, with tires worn beyond safe limits, which resulted in a hydroplaning condition and subsequent loss of directional control.NTSB GAA16CA470Accident · No injuriesData collectionFinal reportCessna 182 · Diller, NEThe pilot's failure to go around after overshooting his intended touchdown point, which resulted in impact with farm equipment and terrain during an aborted landing attempt.NTSB CEN16CA360Accident · No injuriesData collectionFinal reportCessna 140 · Lebanon, INPC The unseen standing water on the runway that abruptly slowed the tailwheel equipped airplane during landing resulting in a nose-over.NTSB GAA16CA445Accident · No injuriesData collectionFinal reportCessna T207 · Nanwalek, AKThe pilot’s unstabilized approach and a subsequent runway overrun while landing on a short runway in variable wind conditions.NTSB GAA16CA437Accident · No injuriesData collectionFinal reportCessna 152 · Belle Plaine, MNThe student pilot's improper pitch technique after rotation during a short field take off, which resulted in the right wing impacting the ground and a nose gear collapse.NTSB ANC16CA053Accident · No injuriesData collectionFinal reportCessna U206G · Sleetmute, AKThe pilot's failure to maintain adequate airspeed during the initial climb after taking off from a wet runway and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall.NTSB CEN16FA286Accident · Minor injuriesClass 3 · FieldFinal reportEmbraer EMB-505 · Sugar Land, TXThe airplane’s hydroplaning during the landing roll, which resulted in a runway excursion. Contributing to the accident was the pilot’s continuation of an unstabilized approach, his decision to land in heavy rain conditions, and his improper use of the main…NTSB CEN16LA288Accident · No injuriesLimited investigationFinal reportCessna 208B · Baldwin, WIThe pilot's decision to land the fully loaded parachutist drop airplane on a wet grass runway that had insufficient length for the landing in high temperature conditions, which resulted in a runway overrun, when a more suitable longer runway was available at…NTSB GAA16CA383Accident · No injuriesData collectionFinal reportAeronca 7AC · Lenoir, NCThe pilot's encounter with instrument meteorological conditions, which resulted in an emergency descent through fog, a runway overrun on a wet grass runway, and a collision with a ditch and vegetation. Contributing to the accident was the pilot's failure to…NTSB GAA16CA353Accident · Minor injuriesData collectionFinal reportCessna 182 · Hungry Horse, MTThe pilot's decision to land on unsuitable wet terrain, and his failure to stop prior to the end of the runway, which resulted in a runway overrun and impact with tree(s).NTSB GAA16CA335Accident · Minor injuriesData collectionFinal reportRans Employee Flying Club Rans S 6S · Richwood, OHThe pilot's exceedance of the critical angle of attack during an initial climb of an aborted landing, which resulted in an inadvertent aerodynamic stall and impact with terrain.NTSB GAA16CA288Accident · No injuriesData collectionFinal reportCessna 172 · Henderson, ARThe pilot's decision to abort the takeoff, which resulted in a hard landing and nose landing gear collapse.NTSB GAA16CA276Accident · No injuriesData collectionFinal reportMooney M20C · Williamstown, NJThe pilot's landing area overshoot and failure to maintain surface speed and braking capability, which resulted in a runway overrun and a collision with a fence.NTSB GAA16CA252Accident · No injuriesData collectionFinal reportPiper PA 20 · Nikolai Creek, AKThe pilot's selection of an unsuitable takeoff area resulting in an airplane nose over during the takeoff roll.NTSB WPR16LA061Accident · No injuriesLimited investigationFinal reportCessna 210 · Lodi, CAThe pilot's failure to attain a proper touchdown point, which led to a runway excursion.