# NTSB investigations: AiResearch TPE331 series, 2024

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 CEN24LA291](https://openairdocs.org/ntsb/CEN24LA291.md): Ayres S2R-G6 · Antioch, NE · Accident · No injuries · Class 3 · Limited · Final report · Jul 26, 2024 · N6136Z · Substantial damage
  > A total loss of engine power due to fuel contamination from an undetermined source.
- [NTSB CEN24LA318](https://openairdocs.org/ntsb/CEN24LA318.md): Ayres S2R · Stanwood, MI · Accident · No injuries · Class 3 · Limited · Final report · Jun 20, 2024 · N4004K · Substantial damage
  > The pilot’s failure to maintain terrain clearance during a low-level aerial application flight, which resulted in impact with terrain and a subsequent forced landing. Contributing to the accident was the location of the spray boom pressure gauge, which…
- [NTSB WPR24LA165](https://openairdocs.org/ntsb/WPR24LA165.md): Grumman Acft ENG Cor-Schweizer G-164A · Rome, OR · Accident · No injuries · Class 4 · Limited · Final report · May 26, 2024 · N9853 · Substantial damage
  > The pilot’s failure to maintain airplane control during landing.
- [NTSB WPR24FA124](https://openairdocs.org/ntsb/WPR24FA124.md): Gulfstream 695A · San Bernardino, CA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 14, 2024 · N965BC · Destroyed
  > The pilot’s continued use of the airplane’s autopilot after flight into moderate to severe icing conditions, which resulted in an exceedance of the airplane’s critical angle of attack and an aerodynamic stall.
- [NTSB WPR24FA123](https://openairdocs.org/ntsb/WPR24FA123.md): Ayres S2R-G10 · Derner, CA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 9, 2024 · N40261 · Substantial damage
  > The pilot’s failure to adequately monitor his fuel supply, resulting in fuel exhaustion, a total loss of engine power, and the airplane’s impact with terrain.

## 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") = 2024
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('01514', '01517'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=01514&year=2024

---
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.
