# NTSB investigations: Cessna 172D, 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 WPR15LA077](https://openairdocs.org/ntsb/WPR15LA077.md): Cessna 172D · Fresno, CA · Accident · No injuries · Limited investigation · Final report · Jan 4, 2015 · N2948U · Substantial damage
  > The pilot's improper fuel planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB WPR12LA189](https://openairdocs.org/ntsb/WPR12LA189.md): Cessna 172D · Beckwourth, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 28, 2012 · N2559U · Substantial damage
  > The pilot’s failure to maintain sufficient airspeed during initial climb, which resulted in a loss of airplane control.
- [NTSB LAX96FA121](https://openairdocs.org/ntsb/LAX96FA121.md): Cessna 172D · Julian, CA · Accident · 3 fatal · Field investigation · Final report · Feb 26, 1996 · N2598U · Destroyed
  > the pilot's continued VFR flight into instrument meteorological conditions which resulted in an inadvertent stall/spin. The pilot's inadequate preflight/preparation, low clouds, fog, and mountain obscuration were factors in the accident.
- [NTSB LAX93LA268](https://openairdocs.org/ntsb/LAX93LA268.md): Cessna 172 · Danville, CA · Accident · Minor injuries · Limited investigation · Final report · Jun 27, 1993 · N2791U · Substantial damage
  > The pilot's poor fuel consumption calculations. Contributing to this accident was the downsloping terrain.
- [NTSB LAX86LA171](https://openairdocs.org/ntsb/LAX86LA171.md): Cessna 172D · Mojave, CA · Accident · No injuries · Limited investigation · Final report · Apr 10, 1986 · N2762U · Substantial damage
  > The acft wing struck a tree during taxi on a dirt road being used for takeoff. The CFI said that he did not make a survey to identify obstructions before the taxi for takeoff. The acft had landed on the road when the CFI could not regain eng power following a…
- [NTSB LAX79DUA02](https://openairdocs.org/ntsb/LAX79DUA02.md): Cessna 172 · Catalina Is, CA · Accident · No injuries · Closed · Nov 5, 1978 · N2415U · Substantial damage
- [NTSB OAK75DVG50](https://openairdocs.org/ntsb/OAK75DVG50.md): Cessna 172D · Marysville, CA · Accident · No injuries · Closed · Mar 25, 1975 · N2523Y · Destroyed
- [NTSB OAK74DVA80](https://openairdocs.org/ntsb/OAK74DVA80.md): Cessna 172 · Turlock, CA · Accident · No injuries · Closed · Jun 29, 1974 · N2465U · Substantial damage
- [NTSB LAX74FUQ31](https://openairdocs.org/ntsb/LAX74FUQ31.md): Cessna 172D · Simi, CA · Accident · Minor injuries · Closed · Mar 31, 1974 · N2567Y · Substantial damage
- [NTSB OAK73DVA47](https://openairdocs.org/ntsb/OAK73DVA47.md): Cessna 172D · Patterson, CA · Accident · No injuries · Closed · Mar 16, 1973 · N2693U · Substantial damage
- [NTSB OAK71DVA28](https://openairdocs.org/ntsb/OAK71DVA28.md): Cessna 172 · Fresno, CA · Accident · No injuries · Closed · Sep 21, 1970 · N2415U · Substantial damage
- [NTSB OAK70DVW10](https://openairdocs.org/ntsb/OAK70DVW10.md): Cessna 172 · S Pipe Well, CA · Accident · No injuries · Closed · Mar 23, 1970 · N2518Y · Substantial damage
- [NTSB LAX70F0176](https://openairdocs.org/ntsb/LAX70F0176.md): Cessna 172 · Corona, CA · Accident · No injuries · Closed · Oct 5, 1969 · N2755U · 2 aircraft · Substantial damage
- [NTSB LAX70F0216](https://openairdocs.org/ntsb/LAX70F0216.md): Cessna 172D · Los Angeles, CA · Accident · Minor injuries · Closed · Aug 24, 1969 · N2856U · Substantial damage
- [NTSB OAK69D0215](https://openairdocs.org/ntsb/OAK69D0215.md): Cessna 172D · Oroville, CA · Accident · No injuries · Closed · Dec 26, 1968 · N2480U · Substantial damage
- [NTSB OAK69D0164](https://openairdocs.org/ntsb/OAK69D0164.md): Cessna 172 · Burney, CA · Accident · Serious injuries · Closed · Sep 13, 1968 · N2193Y · Destroyed
- [NTSB OAK68D0300](https://openairdocs.org/ntsb/OAK68D0300.md): Cessna 172 · Tahoe City, CA · Accident · Minor injuries · Closed · Feb 16, 1968 · N2529Y · Destroyed
- [NTSB LAX67D0223](https://openairdocs.org/ntsb/LAX67D0223.md): Cessna 172 · Crestline, CA · Accident · Minor injuries · Closed · Nov 6, 1966 · N2775U · Substantial damage
- [NTSB LAX67D0066](https://openairdocs.org/ntsb/LAX67D0066.md): Cessna 172 · Van Nuys, CA · Accident · No injuries · Closed · Jul 15, 1966 · N2931U · Substantial damage
- [NTSB LAX66A0074](https://openairdocs.org/ntsb/LAX66A0074.md): Cessna 172D · Newhall, CA · Accident · 1 fatal · Closed · Mar 27, 1966 · N2958U · Destroyed
- [NTSB OAK66D0162](https://openairdocs.org/ntsb/OAK66D0162.md): Cessna 172D · San Francisco, CA · Accident · No injuries · Closed · Nov 17, 1965 · N2693U · Substantial damage
- [NTSB OAK66D0130](https://openairdocs.org/ntsb/OAK66D0130.md): Cessna 172D · Tracy, CA · Accident · No injuries · Closed · Oct 22, 1965 · N2105Y · Substantial damage
- [NTSB OAK66F0091](https://openairdocs.org/ntsb/OAK66F0091.md): Cessna 172 · Concord, CA · Accident · No injuries · Closed · Jul 25, 1965 · N2559Y · Substantial damage
- [NTSB LAX65A0090](https://openairdocs.org/ntsb/LAX65A0090.md): Cessna 172D · Etiwanda, CA · Accident · 2 fatal · Closed · May 22, 1965 · N2597U · Destroyed
- [NTSB UNK65X0841](https://openairdocs.org/ntsb/UNK65X0841.md): Cessna 172D · Beaumont, CA · Accident · 1 fatal · Closed · Nov 26, 1964 · N2187Y · Destroyed
- [NTSB UNK65X0537](https://openairdocs.org/ntsb/UNK65X0537.md): Cessna 172 · Tracy, CA · Accident · 1 fatal · Closed · Nov 2, 1964 · N2588Y · Destroyed
- [NTSB UNK65X0529](https://openairdocs.org/ntsb/UNK65X0529.md): Cessna 172D · Santa Ana, CA · Accident · No injuries · Closed · Nov 2, 1964 · N2775U · Substantial damage
- [NTSB UNK64X3951](https://openairdocs.org/ntsb/UNK64X3951.md): Cessna 172 · La Verne, CA · Accident · No injuries · Closed · Sep 13, 1964 · N2454U · 2 aircraft · Substantial damage
- [NTSB UNK64X2669](https://openairdocs.org/ntsb/UNK64X2669.md): Cessna 172 · Lake Tahoe, CA · Accident · No injuries · Closed · Jul 5, 1964 · N2341U · Substantial damage
- [NTSB UNK64X2366](https://openairdocs.org/ntsb/UNK64X2366.md): Cessna 172D · Los Angeles, CA · Accident · No injuries · Closed · Jun 19, 1964 · N2754U · Substantial damage
- [NTSB UNK64X2009](https://openairdocs.org/ntsb/UNK64X2009.md): Cessna 172D · Koehn Dry Lke, CA · Accident · No injuries · Closed · May 29, 1964 · N2331U · 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 ('2072410'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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