OpenAirDocs.org

NTSB investigations, 2011, Outside the U.S.

8 cases where the sequence of events included Off-field or emergency landing.

Cases per year

20082026

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\") = 2011
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.\"tier2Number\" = '440' 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 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…Nov 24, 2011 · N534P · Substantial damageNTSB ERA12WA136Accident · No injuriesForeign investigationPiper PA36 · Machala, EcuadorOn November 23, 2011, about 2000 coordinated universal time, a Piper PA-36-300, Ecuadorian registration HC-BHJ, operated by Aerorient Fumigacion Aerea, was substantially damaged when the pilot made a forced landing following loss of engine power in a banana…Nov 23, 2011 · HCBHJ · Substantial damageNTSB ERA12WA092Accident · No injuriesForeign investigationPiper PA-25 · Meteropolitana, ChileOn November 11, 2011, at 1345 UTC, a Piper PA-25-260, Chilean registration CC-ABM, registered to and operated by Sociedad De Ttrabajos Aeros Aeropacifico LTDA as a personal flight experienced a partial loss of engine power on initial takeoff climb, in the…Nov 11, 2011 · CC-ABM · Substantial damageNTSB WPR11WA488Accident · No injuriesForeign investigationEurocopter BO105 · Tari, Papua New GuineaOn July 7, 2011, about 1200 local time, a Eurocopter BO-105C, Papua New Guinea registry P2-LAE, sustained an uncontained engine failure in one of its Rolls-Ropyce 250-C20B engines. A fire consumed the helicopter following a forced landing. The helicopter was…Jul 7, 2011 · P2-LAE · Substantial damageNTSB CEN11WA412Accident · Serious injuriesForeign investigationMcDonnell Douglas Helicopter 369E · Glastonbury, United KingdomOn June 19, 2011, at 1420 universal coordinated time (UTC), a McDonnell Douglas Helicopter Company model 369E, United Kingdom registration G-KSWI, s/n 0204E, was substantially damaged during an emergency landing after experiencing a mechanical failure of the…Jun 19, 2011 · G-KSWI · Substantial damageNTSB ERA11WA268Accident · Minor injuriesForeign investigationGrumman G164 · Volgodonsk, RussiaOn April 20, 2011, about 1010 Universal Coordinated Time (UTC), a Grumman G-164A Agcat, Russian registration RA-1398G, operated by a private individual, was substantially damaged during a forced landing following a loss of engine power near Volgodonsk, Rostov…Apr 20, 2011 · RA-1398G · Substantial damageNTSB ERA11WA252Incident · No injuriesForeign investigationReims-Cessna F-150 · Sotttomarina di Chioggia, ItalyOn March 25, 2011, about 1200 universal coordinated time, a Reims-Cessna F-150 airplane, Italian registration I-NOLV, had a reported engine failure while in cruise flight. The pilot decided to land on the shoreline in the vicinity of Sottomarina di Chioggia,…Mar 25, 2011 · I-NOLV · No damageNTSB ERA11WA362Accident · Minor injuriesForeign investigationCessna 152 · Kingston, JamaicaOn March 4, 2011, about 1000 eastern standard time, a Cessna 152, Jamaican registration 6Y-JGA, was substantially damaged during a forced landing, following a total loss of engine power during initial climb from Norman Manley International Airport (MKJP),…Mar 4, 2011 · 6Y-JGA · Substantial damage