# NTSB investigations, CA: Undetermined

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 LAX06CA039](https://openairdocs.org/ntsb/LAX06CA039.md): Cessna 182T · Livermore, CA · Accident · No injuries · Data collection · Final report · Oct 30, 2005 · N51732 · Substantial damage
  > substantial damage to the airplane during unknown phase of flight for undetermined reasons.
- [NTSB LAX87LA058](https://openairdocs.org/ntsb/LAX87LA058.md): Cessna 182L · Oceano, CA · Accident · 2 fatal · Limited investigation · Final report · Nov 30, 1986 · N66CF · Destroyed
  > Witnesses stated that while the acft was climbing after takeoff, it appeared to be lower than normal. One witness rprtd that the eng sounded as if it was running rough. Another witness stated that the acft had begun making a left turn when he saw flames…
- [NTSB LAX82DAMS1](https://openairdocs.org/ntsb/LAX82DAMS1.md): Wing D-1 · Catalina Island, CA · Accident · 2 fatal · Final report · Jun 11, 1982 · N8601M · Destroyed
  > The flt departed torrance at 1259 PDT & VFR conditions existed at the time. When the flt did not return a search was initiated. The search was terminated after 4 days. Friends & relatives speculated this may have been a dual instruction flt in preparation for…

## 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 o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 400)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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