# NTSB investigations: Mooney M20B, 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 WPR12CA166](https://openairdocs.org/ntsb/WPR12CA166.md): Mooney M20B · Rosamond, CA · Accident · Minor injuries · Data collection · Final report · Apr 15, 2012 · N74518 · Substantial damage
  > A loss of engine power during takeoff due to fuel starvation as a result of the pilot’s selection of an empty fuel tank prior to departure.
- [NTSB LAX90LA066](https://openairdocs.org/ntsb/LAX90LA066.md): Mooney M20B · Santa Ana, CA · Accident · Minor injuries · Limited investigation · Final report · Jan 7, 1990 · N74520 · Substantial damage
  > The failure of bolts retaining the idler shaft allowing the cam shift timing to change and by its failure to drive the left magneto.
- [NTSB LAX80FVM25](https://openairdocs.org/ntsb/LAX80FVM25.md): Mooney M20B · San Carlos, CA · Accident · No injuries · Closed · Apr 24, 1980 · N74718 · Substantial damage
- [NTSB OAK78DVG02](https://openairdocs.org/ntsb/OAK78DVG02.md): Mooney M-20B · Georgetown, CA · Accident · No injuries · Closed · Oct 21, 1977 · N123L · Substantial damage
- [NTSB LAX73FUD03](https://openairdocs.org/ntsb/LAX73FUD03.md): Mooney M20B · Compton, CA · Accident · Minor injuries · Closed · Sep 4, 1972 · N74703 · Destroyed
- [NTSB LAX72FUM01](https://openairdocs.org/ntsb/LAX72FUM01.md): Mooney M20B · Chula Vista, CA · Accident · No injuries · Closed · Jul 6, 1971 · N74749 · Substantial damage
- [NTSB OAK71DVW02](https://openairdocs.org/ntsb/OAK71DVW02.md): Mooney M20B · Lone Pine, CA · Accident · No injuries · Closed · Jul 24, 1970 · N74587 · Substantial damage
- [NTSB OAK68D0287](https://openairdocs.org/ntsb/OAK68D0287.md): Mooney M21 · Truckee, CA · Accident · No injuries · Closed · Dec 10, 1967 · N74567 · Substantial damage
- [NTSB OAK67A0004](https://openairdocs.org/ntsb/OAK67A0004.md): Mooney M20B · Antioch, CA · Accident · 3 fatal · Closed · Jul 9, 1966 · N74552 · Destroyed
- [NTSB UNK64X3810](https://openairdocs.org/ntsb/UNK64X3810.md): Mooney M21 · Calpine, CA · Accident · Minor injuries · Closed · Sep 6, 1964 · N74797 · Substantial damage
- [NTSB UNK64X1098](https://openairdocs.org/ntsb/UNK64X1098.md): Mooney M20B · Shafter, CA · Accident · No injuries · Closed · Mar 29, 1964 · N74731 · 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 ('5870206'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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