# NTSB investigations: Culver LFA, 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 LAX00LA348](https://openairdocs.org/ntsb/LAX00LA348.md): Culver LFA · Ione, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 26, 2000 · N37820 · Destroyed
  > The failure of the right brake during the landing roll resulting in loss of directional control and subsequent nose over of the airplane.
- [NTSB LAX93LA349](https://openairdocs.org/ntsb/LAX93LA349.md): Culver LFA · Sonoma, CA · Accident · Serious injuries · Limited investigation · Final report · Sep 11, 1993 · N41729 · Substantial damage
  > the airport management's failure to provide notice of the banner operation and to close the runway. An additional cause was the banner operator's failure to ensure that the runway on which he placed his banner equipment was closed.
- [NTSB LAX87DVD02](https://openairdocs.org/ntsb/LAX87DVD02.md): Culver Cadet LFA · Antioch, CA · Accident · 1 fatal · Final report · Mar 24, 1987 · N37838 · Destroyed
  > During a local pleasure flt, witnesses observed the acft take-off into a headwind. At aprx 1000 ft AGL, the nose of the acft came up then down. The acft entered a spin and collided with the terrain. They also stated that the propeller appeared to be slowing…
- [NTSB LAX74FUG07](https://openairdocs.org/ntsb/LAX74FUG07.md): Culver LCA · Corona, CA · Accident · No injuries · Closed · Jul 14, 1973 · N41638 · Substantial damage
- [NTSB OAK68D0008](https://openairdocs.org/ntsb/OAK68D0008.md): Culver LFA · Watsonville, CA · Accident · Minor injuries · Closed · May 10, 1967 · N41617 · Substantial damage

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

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