# NTSB investigations: Eiriavion PIK 20D, CA

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 LAX96LA144](https://openairdocs.org/ntsb/LAX96LA144.md): Eiriavion PIK 20D · Hollister, CA · Accident · No injuries · Limited investigation · Final report · Mar 23, 1996 · N4HT · Substantial damage
  > the pilot's improper in-flight decision to take a longer than necessary route back to the airport during a period of marginal lift.
- [NTSB LAX88LA156](https://openairdocs.org/ntsb/LAX88LA156.md): Eiriavion PIK 20D · Saint Helena, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 11, 1988 · N1NZ · Minor damage
  > The flight departed vacaville gliderport on an aero tow. The plt intended to fly to calistoga, CA and return. After passing st. Helena, CA, the thermal activity began to decrease. The plt executed a 180 deg turn to return to vacaville. When the flt was over…
- [NTSB LAX84LA320](https://openairdocs.org/ntsb/LAX84LA320.md): Eiriavion PIK 20D · Boron, CA · Accident · No injuries · Limited investigation · Final report · May 28, 1984 · N37V · Destroyed
  > Plt stated that while soaring a 'heavy sink' was encountered. He attempted to reach borax airport but was unable to and landed in terrain 1/4 mile west of the airport. Lancaster, CA, fss stated pilot reports of 'moderate turbulence' were received throughout…

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

This list as a web page: https://openairdocs.org/ntsb?model=5760206&state=CA

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