# NTSB investigations, CA: Training

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 DCA19IA036](https://openairdocs.org/ntsb/DCA19IA036.md): Boeing 737 · Burbank, CA · Incident · No injuries · Class 3 · Incident · Final report · Dec 6, 2018 · N752SW · Minor damage
  > (1) The flight crewmembers’ decision, due to plan continuation bias, to continue the approach despite indications of windshear and a higher-than-expected tailwind and (2) the flight crew’s misperception of the airplane’s touchdown point, which was farther…
- [NTSB WPR19IA030](https://openairdocs.org/ntsb/WPR19IA030.md): Cessna 208 · Bakersfield, CA · Incident · Minor injuries · Class 3 · Incident · Final report · Nov 24, 2018 · N781FE · No damage
  > The pilot's loss of consciousness while taxiing due to an accumulation of toxic levels of carbon dioxide gas inside the airplane as a result of dry ice sublimation. Also causal was the pilot's decision to fly the airplane in an unventilated configuration, the…
- [NTSB WPR14TA357](https://openairdocs.org/ntsb/WPR14TA357.md): Airbus Helicopters AS 350 B3 · Hemet, CA · Accident · Minor injuries · Final report · Aug 28, 2014 · N991SD · Substantial damage
  > The flight instructor's failure to adequately brief and demonstrate the simulated emergency procedure to the pilot under instruction and his delayed remedial action and inadequate supervision during the maneuver, which resulted in an excessive sink rate and a…
- [NTSB DCA13MA120](https://openairdocs.org/ntsb/DCA13MA120.md): Boeing 777-200ER · San Francisco, CA · Accident · 3 fatal · Class 1 · Major · Final report · Jul 6, 2013 · HL7742 · Destroyed
  > The flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…

## 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 f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '040310'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/040310/cases?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.