# NTSB investigations: Schempp-Hirth VENTUS-B

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 LAX02LA277](https://openairdocs.org/ntsb/LAX02LA277.md): Schempp-Hirth Ventus-B · Peoria, AZ · Accident · 1 fatal · Limited investigation · Final report · Sep 7, 2002 · N114RP · Destroyed
  > The pilot's abrupt maneuver, which resulted in an inadvertent stall.
- [NTSB LAX98LA092](https://openairdocs.org/ntsb/LAX98LA092.md): Schempp-Hirth VENTUS-B · Williams, CA · Accident · No injuries · Limited investigation · Final report · Feb 23, 1998 · N948B · Substantial damage
  > The pilot's failure to maintain an adequate clearance from the oil drilling rig due to his attention being diverted inside the cockpit in order the secure the landing gear control.
- [NTSB LAX91LA378](https://openairdocs.org/ntsb/LAX91LA378.md): Schempp-Hirth VENTUS-B · Mojave, CA · Accident · Serious injuries · Limited investigation · Final report · Aug 31, 1991 · N901DH · Destroyed
  > The glider pilot's inadequate altitude to clear terrain. Factors which related to the pilot being low could not be established because the pilot had no memory of the accident, and no witnesses were identified who observed the glider other than during its…

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

This list as a web page: https://openairdocs.org/ntsb?model=3802051

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