# NTSB investigations, CA: Missing aircraft

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 LAX03FAMS3](https://openairdocs.org/ntsb/LAX03FAMS3.md): Cessna 172B · Little River, CA · Accident · 1 fatal · Missing aircraft · Final report · May 26, 2003 · N7555X · Destroyed
  > Aircraft is missing.
- [NTSB LAX01FAMS1](https://openairdocs.org/ntsb/LAX01FAMS1.md): Cessna 172N · Monterey, CA · Accident · 1 fatal · Missing aircraft · Final report · Jan 15, 2001 · N6452D · Destroyed
  > Undetermined.
- [NTSB LAX97FAMS2](https://openairdocs.org/ntsb/LAX97FAMS2.md): Piper PA-28-161 · Avalon, CA · Accident · 1 fatal · Missing aircraft · Final report · Feb 11, 1997 · N8436X · Destroyed
  > undetermined.
- [NTSB LAX93FAMS2](https://openairdocs.org/ntsb/LAX93FAMS2.md): Piper PA-28-181 · Missing Acft, CA · Accident · 4 fatal · Missing aircraft · Final report · Dec 6, 1992 · N81453 · Destroyed
  > Undetermined.
- [NTSB LAX91LA365](https://openairdocs.org/ntsb/LAX91LA365.md): Piper PA-38-112 · Oceano, CA · Accident · 2 fatal · Limited investigation · Final report · Aug 18, 1991 · N2526C · Destroyed
  > Unknown. The main airplane wreckage and the body of the pilot are presumed lost at sea.
- [NTSB LAX87FAMS4](https://openairdocs.org/ntsb/LAX87FAMS4.md): Cessna 172P · Missing Acft, CA · Accident · 1 fatal · Missing aircraft · Final report · Aug 30, 1987 · N65797 · Destroyed
  > The pilot told family and friends that he was going to fly along the coast and return at night. He did not return. The civil air patrol searched for the aircraft and pilot for several days without success. The flight originated at van nuys airport, van nuys,…
- [NTSB LAX86FVM01](https://openairdocs.org/ntsb/LAX86FVM01.md): Pitts Special G-1 · Salinas, CA · Accident · No injuries · Final report · Dec 19, 1985 · N14JD · Destroyed
  > On December 19, 1985, an experimental Pitts-special, N14JD, owned and operated by the owner crashed under unknown circumstances near Salinas, California. The pilot survived but the aircraft was not recovered. The pilot stated that he had an unknown flight…
- [NTSB LAX86LA008](https://openairdocs.org/ntsb/LAX86LA008.md): Piper PA-23-250 · Santa Barbara, CA · Accident · 2 fatal · Limited investigation · Final report · Oct 4, 1985 · N6726Y · No damage
  > On oct. 3, 1985, pipter PA-23-250 crashed into the pacific ocean while on an air sampling flt near Santa Barbara, CA. The ac was destroyed and the two plts were fatally injured. The flt was to be flown along a predermined route utilizing loran navaids. The ac…
- [NTSB LAX84LAMS3](https://openairdocs.org/ntsb/LAX84LAMS3.md): Bellanca 17-31A · CA · Accident · 1 fatal · Final report · Jun 1, 1984 · N6602V · Destroyed
  > Between may 31 & June 1, 1984, the private plt is believed to have driven to the airport, parked his car, & boarded his aircraft for a presumed personal flt. The plt's wife became concerned about her husband's failure to appear at work, & she notified local…

## 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" = 420)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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