# Fatal NTSB investigations: Schempp-Hirth CIRRUS

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 LAX92LA346](https://openairdocs.org/ntsb/LAX92LA346.md): Schempp-Hirth Cirrus · Bishop, CA · Accident · 1 fatal · Limited investigation · Final report · Aug 12, 1992 · N7988 · Destroyed
  > The pilot's poor inflight decision to fly over mountainous terrain at an inadequate altitude.
- [NTSB ATL83LA259](https://openairdocs.org/ntsb/ATL83LA259.md): Schempp-Hirth Cirrus · Damascus, MD · Accident · 1 fatal · Limited investigation · Final report · Jul 7, 1983 · N441UJ · Substantial damage
  > The glider collided with a fence during an off arpt forced landing. The plt stated that she did not see the power lines until she was on the final approach. She maneuvered the glider to miss the powerlines but was unable to miss the fence and landed short.…
- [NTSB LAX76AL072](https://openairdocs.org/ntsb/LAX76AL072.md): Schemp Cirrus · Hemet, CA · Accident · 2 fatal · Closed · Apr 17, 1976 · N240F · 2 aircraft · Destroyed
- [NTSB LAX72AL023](https://openairdocs.org/ntsb/LAX72AL023.md): Schemp Cirrus · Wrightwood, CA · Accident · 1 fatal · Closed · Oct 9, 1971 · N6664 · Destroyed

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

This list as a web page: https://openairdocs.org/ntsb?fatal=1&model=38019VC

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