# NTSB investigations: Airbus A320-232, 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 ENG14IA028](https://openairdocs.org/ntsb/ENG14IA028.md): Airbus A320 232 · Long Beach, CA · Incident · No injuries · Incident investigation · Final report · Sep 18, 2014 · N656JB · Minor damage
  > The probable cause of the engine failure and subsequent undercowl engine fire was due to the fatigue fracture of a high pressure turbine stage 2 disk blade retaining lug that released two blades which impacted the low pressure turbine case causing a fuel line…
- [NTSB WPR10IA430](https://openairdocs.org/ntsb/WPR10IA430.md): Airbus A320-232 · Sacramento, CA · Incident · Minor injuries · Incident investigation · Final report · Aug 26, 2010 · N590JB · Minor damage
  > The first officer’s inadvertent activation of the parking brake in flight, which led to the airplane abruptly stopping and all four of its main landing gear tires deflating, and his use of a nonstandard procedure to cancel the airplane's monitoring alert…
- [NTSB LAX05IA312](https://openairdocs.org/ntsb/LAX05IA312.md): Airbus Industrie A320 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Sep 22, 2005 · N536JB · Minor damage
  > The fatigue failure of two anti-rotation lugs due to repeated cyclic pre-landing tests, which allowed the nosewheels to deviate from the 0-degree position on landing gear retraction. A contributing factor was the design of the Brake Steering Control Unit…

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

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