# NTSB investigations: Aviat A-1, 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 WPR15FA238](https://openairdocs.org/ntsb/WPR15FA238.md): Aviat A 1 · Compton, CA · Accident · 1 fatal · Field investigation · Final report · Aug 9, 2015 · N6090U · Destroyed
  > The pilot's failure to maintain adequate airspeed and/or appropriate pitch attitude during a banner pickup, which resulted in the airplane exceeding its critical angle of attack and experiencing an aerodynamic stall/spin at too low an altitude to allow…
- [NTSB LAX08CA006](https://openairdocs.org/ntsb/LAX08CA006.md): Aviat A-1 · Arroyo Grande, CA · Accident · No injuries · Data collection · Final report · Oct 7, 2007 · N9620Z · Substantial damage
  > The pilot's misjudged altitude and distance on the approach that led to an undershoot and inadequate obstacle clearance.
- [NTSB LAX98GA110](https://openairdocs.org/ntsb/LAX98GA110.md): Christen Industries A-1 · Lebec, CA · Accident · 1 fatal · Final report · Mar 11, 1998 · N9615G · Destroyed
  > The trainee-pilot's failure to maintain altitude during a low level turn. Contributing factors were the pilot-in-command's diverted attention inside the airplane, his failure to report the trainee's deficient airplane handling abilities, and the shoulder…
- [NTSB LAX97LA228](https://openairdocs.org/ntsb/LAX97LA228.md): Aviat A-1 · Novato, CA · Accident · No injuries · Limited investigation · Final report · Jul 2, 1997 · N13HU · Substantial damage
  > the pilot's inadequate compensation for wind conditions during landing, and his subsequent failure to maintain directional control of the aircraft. The gusty crosswind condition was a related factor.
- [NTSB LAX93LA293](https://openairdocs.org/ntsb/LAX93LA293.md): Aviat A-1 · Selma, CA · Accident · No injuries · Limited investigation · Final report · Jul 20, 1993 · N9614L · Substantial damage
  > the pilot-in-command's failure to maintain direction control, inadequate compensation for the existing wind conditions, and improper use of the rudder. The pilot's lack of total experience in the accident airplane make and model is a factor in this accident.

## 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 ('2210302', '2210400'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2210302&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.