NTSB investigations, 2022, Outside the U.S.

16 cases where the defining event was Loss of engine power (partial).

Cases per year

20082026
NTSB investigations, 2022, Outside the U.S. per year, 2008–2026: 227 cases
20087
20091
20103
20112
20126
20134
20146
20157
20166
20179
20189
201920
20204
202128
202216
202327
202431
202533
20268

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\") = 2022
    AND c.\"eventCountry\" <> 'USA'
    AND c.\"mKey\" IN (SELECT e.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.\"isDefiningEvent\" AND e.\"tier2Number\" = '342')
  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 GAA23WA097Accident · 1 fatalClass 5 · ForeignCessna 310F · Puerto Vallarta, MexicoDec 27, 2022 · N541DWNTSB GAA23WA031Accident · 2 fatalClass 5 · ForeignRobinson R66 · Kesova Gora, RussiaNov 27, 2022 · RA- 07390 · DestroyedNTSB GAA22WA288Incident · No injuriesClass 5 · ForeignCessna 172 · Donji Proložac, CroatiaSep 19, 2022 · 9A-BDMNTSB ENG22WA044IncidentClass 3 · ForeignAirbus A320 · Guadalajara, MexicoAug 24, 2022 · XA-VAJ · No damageNTSB GAA22WA258Accident · Minor injuriesClass 5 · ForeignAir Tractor AT-802A · Cranbrook, CanadaAug 3, 2022 · C-FFQS · Substantial damageNTSB GAA22WA266Accident · Serious injuriesClass 5 · ForeignCessna 172 · Qualicum Beach, CanadaJul 25, 2022 · C-GGSN · Substantial damageNTSB GAA22WA309Accident · No injuriesClass 5 · ForeignCassult Racer Iiim · Henstridge, Somerset, United KingdomJul 1, 2022 · G-BPVO · Substantial damageNTSB GAA22WA209Accident · No injuriesClass 5 · ForeignCessna TU206G · Bielsko Biala, PolandJun 24, 2022 · OK-ROY · Substantial damageNTSB ENG22WA032Incident · No injuriesClass 5 · ForeignBoeing 777 · Karachi, PakistanJun 14, 2022 · A7-BEA · Minor damageNTSB GAA22WA183Accident · 2 fatalClass 5 · ForeignCessna 208 · Boituva, BrazilMay 11, 2022 · PT-OQR · Substantial damageNTSB ENG22WA025IncidentClass 5 · ForeignBoeing 767-322 · Lima, Peru, PeruMay 10, 2022 · N651UA · Minor damageNTSB GAA22WA172IncidentClass 5 · ForeignPiper PA-46-600TP · Londrina, BrazilApr 19, 2022 · PS-RJJ · No damageNTSB GAA22WA150Accident · No injuriesClass 5 · ForeignPiper PA11 · Miramar, ArgentinaApr 1, 2022 · LV-YOD · Substantial damageNTSB GAA22WA125Accident · Minor injuriesClass 5 · ForeignCirrus SR22 · Ringsted, DenmarkMar 20, 2022 · N745AJ · Substantial damageNTSB GAA22WA097Accident · Minor injuriesClass 5 · ForeignRobinson R44 · Florianopolis, BrazilJan 19, 2022 · PR-NEW · Substantial damageNTSB GAA22WA087Accident · No injuriesClass 5 · ForeignBeech 58 · Curitiba, BrazilJan 19, 2022 · PR-JGV · Substantial damage