# NTSB investigations: Cessna 525A: Loss of control in flight

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 CEN25FA119](https://openairdocs.org/ntsb/CEN25FA119.md): Cessna 525 · Mesquite, TX · Accident · 1 fatal · Class 3 · Field · Preliminary report · Mar 13, 2025 · N525CZ · Destroyed
  > On March 13, 2025, about 0733 central daylight time, a Cessna 525A airplane, N525CZ, was destroyed when it was involved in an accident near Mesquite, Texas. The pilot was fatally injured. The airplane was operated under the provisions of Title 14 Code of…
- [NTSB CEN19FA036](https://openairdocs.org/ntsb/CEN19FA036.md): Cessna 525 · Memphis, IN · Accident · 3 fatal · Class 3 · Field · Final report · Nov 30, 2018 · N525EG · Destroyed
  > The pilot’s inability to regain airplane control after a left roll that began for reasons that could not be determined based on the available evidence.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2076615')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '240' 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/240/sequence?model=2076615

---
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.