# NTSB investigations, CA: Altitude deviation

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 WPR23FA257](https://openairdocs.org/ntsb/WPR23FA257.md): Cessna 550 · Murrieta, CA · Accident · 6 fatal · Class 3 · Field · Final report · Jul 8, 2023 · N819KR · Destroyed
  > The flight crew’s decision to descend below the decision altitude of an instrument approach without having the appropriate runway visual reference(s) distinctively identified and with the visibility below the minimum that was prescribed for the approach,…
- [NTSB WPR23LA029](https://openairdocs.org/ntsb/WPR23LA029.md): Cessna 152 · San Jose, CA · Accident · No injuries · Class 4 · Limited · Final report · Nov 13, 2022 · N5171B · Substantial damage
  > The student pilots unstabilized approach and improper landing flare, which resulted in a hard bounced landing.
- [NTSB WPR22FA197](https://openairdocs.org/ntsb/WPR22FA197.md): Cessna 208B · Oceanside, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jun 3, 2022 · N7581F · Substantial damage
  > The right-seated pilot’s failure to correct the left-seated pilot’s mismanagement of the engine thrust, which resulted in undesired speed and thrust oscillations during the final approach and a subsequent descent into terrain.
- [NTSB WPR19FA080](https://openairdocs.org/ntsb/WPR19FA080.md): Cessna 172 · Desert Hot Springs, CA · Accident · 2 fatal · Class 2 · Field · Final report · Feb 6, 2019 · N20556 · Destroyed
  > The pilot's inadequate and/or improper preparation for the flight in which he selected an altitude too low to assure terrain clearance and resulted in an impact with terrain in turbulent downdraft conditions.
- [NTSB WPR13CA428](https://openairdocs.org/ntsb/WPR13CA428.md): Cessna 182Q · Big Bear, CA · Accident · Minor injuries · Data collection · Final report · Sep 28, 2013 · N759UP · Substantial damage
  > The pilot's failure to maintain a stabilized landing approach, which resulted in a collision with a fence short of the runway.
- [NTSB WPR13CA260](https://openairdocs.org/ntsb/WPR13CA260.md): Wampach Murphy Moose · Galt, CA · Accident · No injuries · Data collection · Final report · Jun 1, 2013 · N331RW · Substantial damage
  > The pilot's improper landing flare, which resulted in an abnormal runway contact.
- [NTSB WPR12FA154](https://openairdocs.org/ntsb/WPR12FA154.md): Cessna T182 · Ludlow, CA · Accident · 1 fatal · Field investigation · Final report · Apr 6, 2012 · N5201F · Substantial damage
  > The in-flight loss of control due to the pilot’s impairment as a result of hypoxia. Contributing to the accident was the pilot’s operation of the airplane above 12,500 feet without the aid of supplemental oxygen.

## 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 s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '282' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent"))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/282/sequence?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.