OpenAirDocs.org

NTSB investigations, 2009

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\") = 2009
    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 ERA10LA084Accident · Minor injuriesLimited investigationFinal reportCessna 150L · Hillsboro Beach, FLA total loss of engine power for undetermined reasons.Nov 29, 2009 · N19318 · Substantial damageNTSB CEN10LA036Accident · Serious injuriesLimited investigationFinal reportBell 206 · High Island A-442AA total loss of engine power due to maintenance personnel's failure to correctly torque the Pc line following removal and reinstallation of the turbine module.Nov 1, 2009 · N272M · Substantial damageNTSB ERA10WA044Accident · 1 fatalForeign investigationBritten Norman BN2A · Kralendijk, Bonaire, NTOn October 22, 2009, about 1417 universal coordinated time, a Britten Norman BN-2A/26, PJ-SUN, experienced a right engine failure during cruise flight, and subsequently ditched in the Caribbean Sea, near Kralendijk, Bonaire, Netherlands Antilles. The airplane…Oct 22, 2009 · PJ-SUN · Substantial damageNTSB ERA10LA013Accident · Minor injuriesLimited investigationFinal reportMooney M20C · Marathon, FLA total loss of engine power for undetermined reasons.Oct 10, 2009 · N2558Y · DestroyedNTSB ERA09LA544Accident · No injuriesLimited investigationFinal reportCelier Xenon RST · Mount Pleasant, SCThe gyroplane's inadequate climb performance for undetermined reasons.Sep 25, 2009 · N4462J · Substantial damageNTSB CEN09LA575Accident · No injuriesLimited investigationFinal reportSchweizer 269C · Preston, TXThe loss of engine power for undetermined reasons.Sep 5, 2009 · N626LH · Substantial damageNTSB ERA09LA421Accident · No injuriesLimited investigationFinal reportRobinson Helicopter R44 II · Dunedin, FLA partial loss of engine power for undetermined reasons.Jul 24, 2009 · N645JC · Substantial damageNTSB ANC09LA042Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Wasilla, AKA loss of engine power due to the blockage of the carburetor air inlet by a piece of engine baffling. Contributing to the accident was a worn engine baffle, and the pilot/owner's failure to have the engine baffle replaced.May 16, 2009 · N7440P · Substantial damageNTSB WPR09WA138Accident · No injuriesForeign investigationEurocopter EC225 · North Sea, United Kingdom.Feb 18, 2009 · G-REDU · Substantial damageNTSB WPR09CA103Accident · No injuriesData collectionFinal reportAeronca 7BC · Half Moon Bay, CAA total loss of engine power due to fuel exhaustion as a result of the pilot's failure to perform an accurate visual fuel quantity check prior to initiating the flight.Jan 29, 2009 · N2805E · DestroyedNTSB DCA09MA026Accident · Serious injuriesClass 1 · MajorFinal reportAirbus A320 · Weehawken, NJThe ingestion of large birds into each engine, which resulted in an almost total loss of thrust in both engines and the subsequent ditching on the Hudson River. Contributing to the fuselage damage and resulting unavailability of the aft slide/rafts were (1)…Jan 15, 2009 · N106US · Substantial damage