# NTSB investigations: AiResearch TPE331 series, VA

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 IAD01LA026](https://openairdocs.org/ntsb/IAD01LA026.md): Ayres S2R · Crewe, VA · Accident · No injuries · Limited investigation · Final report · Jan 14, 2001 · N222GK · Substantial damage
  > the loss of engine power due to the pilot's inadequate preflight planning and exhaustion of his fuel supply.
- [NTSB IAD01FA021](https://openairdocs.org/ntsb/IAD01FA021.md): Jetstream 4101 · Charlottesville, VA · Accident · Minor injuries · Field investigation · Final report · Dec 30, 2000 · N323UE · Substantial damage
  > The captain's improper application of power after responding to a beta warning light during landing rollout, which resulted in an excessive rollout speed and an inability to stop the airplane before it reached the end of the runway.
- [NTSB IAD99LA045](https://openairdocs.org/ntsb/IAD99LA045.md): Gulfstream American 690C · Hot Springs, VA · Accident · No injuries · Limited investigation · Final report · May 24, 1999 · N840V · Substantial damage
  > A hard landing due to the pilot's inadequate compensation for the wind conditions.
- [NTSB ATL84IA134](https://openairdocs.org/ntsb/ATL84IA134.md): Beech C90 · Herndon, VA · Incident · No injuries · Incident investigation · Final report · Mar 29, 1984 · N66KA · Minor damage
  > The acft entered an uncommanded dive at about 11,000 ft MSL, with recovery made below 2,000 ft MSL. Investigation revealed that during the descent, in order to accomodate other air traffic, the plt exceeded vne speeds. Shortly, thereafter the elevator trim…

## 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 c."eventStateOrRegion" = 'VA' AND c."eventCountry" = 'USA'
  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&state=VA

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