# NTSB investigations: Cessna 500, FL

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 GAA16CA454](https://openairdocs.org/ntsb/GAA16CA454.md): Piper PA 34 · Fort Lauderdale, FL · Accident · No injuries · Data collection · Final report · Aug 13, 2016 · N8166U · 2 aircraft · Minor damage
  > The other pilot's failure to ensure that the brake was fully engaged and his subsequent failure to notice that his airplane was rolling forward, which resulted in it hitting another airplane.
- [NTSB ERA14LA159](https://openairdocs.org/ntsb/ERA14LA159.md): Cessna 500 · Zephyrhills, FL · Accident · No injuries · Limited investigation · Final report · Mar 16, 2014 · N125DS · Substantial damage
  > The pilots' inadequate in-flight planning and improper selection of runway 36 for landing, which resulted in a significant quartering tailwind during the landing, exceedance of the airplane's braking capability, and a subsequent runway overrun.
- [NTSB MIA03IA062](https://openairdocs.org/ntsb/MIA03IA062.md): Cessna 500 · Fort Lauderdale, FL · Incident · No injuries · Incident investigation · Final report · Feb 14, 2003 · N891CA · Minor damage
  > Inadequate quality control following overhaul of the high-pressure compressor (HPC) impeller by other maintenance personnel that resulted in a machining groove on the aft face of the HPC impeller being undetected, which resulted in a fatigue fracture and an…

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

This list as a web page: https://openairdocs.org/ntsb?model=2076602&state=FL

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