# NTSB investigations, 2023, Outside the U.S.: Powerplant sys/comp malf/fail

NTSB aviation accident and incident investigations since 1962: the probable cause, findings, aircraft, crew, weather and docket of each, linked to the FAA registry and the FAA’s own reports.

## Latest cases

- [NTSB ENG24WA007](https://openairdocs.org/ntsb/ENG24WA007.md): Grumman G21 · Bella Bella, Canada · Incident · Minor injuries · Class 5 · Foreign · Dec 18, 2023 · C-GDDJ · Substantial damage
- [NTSB ENG24WA008](https://openairdocs.org/ntsb/ENG24WA008.md): Airbus A321 · Islamabad, Pakistan · Incident · No injuries · Class 3 · Foreign · Oct 30, 2023 · AP-BOD · No damage
- [NTSB ENG24WA002](https://openairdocs.org/ntsb/ENG24WA002.md): Boeing 737 · Rio de Janeiro, Brazil · Incident · Class 5 · Foreign · Sep 2, 2023 · PR-GUM · Minor damage
- [NTSB DCA23WA458](https://openairdocs.org/ntsb/DCA23WA458.md): Boeing 767-332 · Prague, Czechia · Incident · No injuries · Class 3 · Foreign · Sep 1, 2023 · N175DN · No damage
- [NTSB ENG23WA035](https://openairdocs.org/ntsb/ENG23WA035.md): Airbus A321 · Jeddah, Saudi Arabia · Occurrence · Class 5 · Foreign · Aug 22, 2023 · VT-IUD · No damage
- [NTSB GAA23WA214](https://openairdocs.org/ntsb/GAA23WA214.md): Bell 206B · Thetford Mines, Canada · Accident · No injuries · Class 5 · Foreign · Jun 23, 2023 · N717LM · Substantial damage
- [NTSB GAA23WA164](https://openairdocs.org/ntsb/GAA23WA164.md): Piper PA-24-250 · Guadalajara, Mexico · Accident · Class 5 · Foreign · Jun 6, 2023 · XB-GOO
- [NTSB DCA23WA306](https://openairdocs.org/ntsb/DCA23WA306.md): Boeing 737 · Merida, Mexico · Incident · No injuries · Class 5 · Foreign · Jun 1, 2023 · XA-PPP · No damage
- [NTSB GAA23WA154](https://openairdocs.org/ntsb/GAA23WA154.md): Cirrus Design SR22 · Norman's Cay, Bahamas · Accident · No injuries · Class 5 · Foreign · May 26, 2023 · N522AR · Substantial damage
- [NTSB GAA23WA162](https://openairdocs.org/ntsb/GAA23WA162.md): Piper PA18 · Oldenburg, Germany · Accident · Class 5 · Foreign · May 18, 2023 · D-EJIM · Destroyed
- [NTSB GAA23WA106](https://openairdocs.org/ntsb/GAA23WA106.md): Cessna 172 · Madrid, Spain · Incident · No injuries · Class 5 · Foreign · Mar 22, 2023 · EC-GVD · Minor damage
- [NTSB ENG23WA024](https://openairdocs.org/ntsb/ENG23WA024.md): Airbus A320 · Kota Kinabalu, Malaysia · Incident · No injuries · Class 5 · Foreign · Mar 22, 2023 · RP-C4106 · No damage
- [NTSB GAA23WA115](https://openairdocs.org/ntsb/GAA23WA115.md): Cirrus SR22 · Salto, Uruguay · Occurrence · No injuries · Class 5 · Foreign · Mar 4, 2023 · LV-GZQ · No damage
- [NTSB GAA23WA075](https://openairdocs.org/ntsb/GAA23WA075.md): Piper PA46 · Dessau, Germany · Accident · No injuries · Class 5 · Foreign · Feb 22, 2023 · D-ETTG · Substantial damage
- [NTSB ENG23WA019](https://openairdocs.org/ntsb/ENG23WA019.md): Airbus A320 · Amritsar, India · Incident · Class 5 · Foreign · Feb 5, 2023 · VT-ISE · Substantial damage
- [NTSB GAA23WA066](https://openairdocs.org/ntsb/GAA23WA066.md): Cessna 206 · Stann Creek, Belize · Incident · No injuries · Class 5 · Foreign · Feb 3, 2023 · V3-HES
- [NTSB ENG23WA012](https://openairdocs.org/ntsb/ENG23WA012.md): Boeing 737 · Sydney, Australia · Incident · No injuries · Class 5 · Foreign · Jan 18, 2023 · VH-XZB · No damage
- [NTSB ENG23WA014](https://openairdocs.org/ntsb/ENG23WA014.md): Learjet 35 · Hohn, Germany · Incident · Class 5 · Foreign · Jan 16, 2023 · D-CGFC · Minor damage
- [NTSB ENG23WA009](https://openairdocs.org/ntsb/ENG23WA009.md): Boeing 767 · Incheon, South Korea · Incident · Class 5 · Foreign · Jan 3, 2023 · N496MM · Minor damage

## The whole list in SQL

Runs in DuckDB 1.2 or later on the release's Parquet files over HTTPS:

```sql
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") = 2023
  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" = '340' 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
```

This list as a web page: https://openairdocs.org/ntsb-events/340/sequence?state=OF&year=2023

---
OpenAirDocs.org is an independent research project of [Contrail Labs](https://contraillabs.com/). It is not affiliated with the FAA or the NTSB. Source documents are U.S. government works in the public domain.