# NTSB investigations: CFM International CFM56 series, CA: Airframe/component/system failure/malfunction

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 LAX07IA014](https://openairdocs.org/ntsb/LAX07IA014.md): Boeing 737-790 · Los Angeles, CA · Incident · No injuries · Incident investigation · Final report · Oct 19, 2006 · N614AS · No damage
  > A complete failure and depressurization of both hydraulic systems due to two separate events: 1) the failure of a engine driven pump on the 'A' system, and 2) the fatigue fracture and failure of a hydraulic line on the 'B' system.
- [NTSB LAX02IA002](https://openairdocs.org/ntsb/LAX02IA002.md): Boeing 737-700 · Santa Ana, CA · Incident · No injuries · Incident investigation · Final report · Oct 10, 2001 · N615AS · No damage
  > The failure of the stabilizer electric trim motor as a result of internal mechanical seizure.
- [NTSB LAX96IA184](https://openairdocs.org/ntsb/LAX96IA184.md): Boeing 737-300-3H4 · Ontario, CA · Incident · No injuries · Incident investigation · Final report · Apr 30, 1996 · N331SW · Minor damage
  > The repair facility's improper assembly of the landing gear oleo strut during overhaul.

## 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.engine_model_code IN ('13802')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=13802&occurrence=130&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, except the copies of manufacturers’ service documents, which belong to their rights holders.
