# NTSB investigations: Volkswagen CONVERSION, 1997

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 CHI97FA272](https://openairdocs.org/ntsb/CHI97FA272.md): Kellums Sonerai 1 · Scottsburg, IN · Accident · 1 fatal · Field investigation · Final report · Aug 26, 1997 · N76457 · Destroyed
  > a loss of engine power for undetermined reasons, and the student pilot's failure to maintain airspeed greater than the stalling speed for the airplane. A factor relating to this accident was the student pilot's lack of total experience.
- [NTSB MIA97LA204](https://openairdocs.org/ntsb/MIA97LA204.md): Moran Teenie TWO · Pinehurst, NC · Accident · No injuries · Limited investigation · Final report · Jul 4, 1997 · N9753 · Substantial damage
  > The pilot's decision to takeoff with a tailwind and improper recovery from a bounced landing. This resulted in a premature lift off, in-flight collision with terrain, on-ground loss of directional control, and subsequent on-ground collision with a taxiway…
- [NTSB NYC97LA125](https://openairdocs.org/ntsb/NYC97LA125.md): Shafer SONERAI-I · W.Hampton Beach, NY · Accident · 1 fatal · Limited investigation · Final report · Jun 22, 1997 · N20CS · 2 aircraft · Destroyed
  > failure of the number two pilot (N77TY) to follow race procedures, and failure of the number three pilot (N20CS) to turn and avoid the number two airplane, when it decelerated into the number three pilot's blind spot.
- [NTSB SEA97LA084](https://openairdocs.org/ntsb/SEA97LA084.md): Hutton Rand Robinson KR-2 · Grants Pass, OR · Accident · Minor injuries · Limited investigation · Final report · Apr 6, 1997 · N4GJ · Substantial damage
  > The pilot's failure to adequately compensate for wind conditions, his failure to maintain directional control on takeoff, and his failure to abort the takeoff. Factors contributing to the accident are gusty crosswinds.

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

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

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