OpenAirDocs.org

NTSB investigations, 2017

11 cases where the sequence of events included Ditching.

Cases per year

20082026

Where

Open the map

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\") = 2017
    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.

NTSB ERA18WA047Accident · 1 fatalClass 5 · ForeignCessna T210 · West End, BahamasDec 14, 2017 · N727TJ · Substantial damageNTSB ERA18LA062Accident · No injuriesLimited investigationFinal reportPiper PA32 · Oakland Park, FLThe loss of engine power for reasons that could not be determined based on the available evidence.Dec 13, 2017 · C6RVT · Substantial damageNTSB ERA17LA347Accident · No injuriesLimited investigationFinal reportBeech 35 · Marathon, FLA total loss of engine power for reasons that could not be determined because saltwater corrosion precluded a complete examination.Sep 16, 2017 · N3187V · Substantial damageNTSB ANC17LA043Accident · No injuriesClass 3 · LimitedFinal reportCessna T207 · Juneau, AKThe total loss of engine power due to fuel starvation.Aug 14, 2017 · N745KP · Substantial damageNTSB WPR17LA176Accident · Minor injuriesClass 3 · LimitedFinal reportCessna 172S · Seattle, WAThe total loss of engine power due to oil starvation as a result of the loose right magneto, which allowed oil to escape and the engine to seize. Contributing to the accident was inadequate maintenance, which failed to identify the loose magneto bolt.Jul 31, 2017 · N957TA · Substantial damageNTSB WPR17FA146Accident · 1 fatalField investigationFinal reportChicco Miguel E Quicksilver Sport II · Point Mugu, CAA partial loss of engine power for reasons that could not be determined during postaccident examination in combination with the low cruise altitude selected by the pilots, which resulted in an ocean ditching. The lack of personal flotation devices likely…Jul 8, 2017 · N2812NTSB ERA17LA175Accident · No injuriesLimited investigationFinal reportMooney M20R · Myrtle Beach, SCA total loss of engine power during initial climb for reasons that could not be determined because the airplane sank in the ocean and was not recovered.May 9, 2017 · N20835 · Substantial damageNTSB ERA17LA160Accident · No injuriesLimited investigationFinal reportCessna 172 · Yankeetown, FLA total loss of engine power for reasons that could not be determined because postaccident examination of the engine revealed no evidence of any preaccident mechanical malfunctions or failures that would have precluded normal operation.Apr 20, 2017 · N6013E · Substantial damageNTSB ERA17LA128Accident · No injuriesLimited investigationFinal reportPiper PA28 · Tampa, FLA collapsed engine induction duct, which resulted in restricted air flow to the engine and a subsequent loss of engine power. Contributing to the accident was the operator's failure to ensure that the correct induction duct was installed.Mar 12, 2017 · N8447R · Substantial damageNTSB ANC17LA017Accident · Minor injuriesLimited investigationFinal reportBeech G18 · Metlakatla, AKAn engine power loss for reasons that could not be determined because the airplane was not recovered.Mar 3, 2017 · N103AF · Substantial damageNTSB WPR17LA075Accident · Serious injuriesLimited investigationFinal reportHughes 369A · (Pacific Ocean)The pilot's failure to detect the presence of water in the helicopter fuel system before the flight, which resulted in a total loss of engine power during cruise. Contributing to the accident was the pilot's delayed recognition of the power loss and late…Feb 22, 2017 · N805LA · Substantial damage