# NTSB investigations, FL: Illness/injury

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 DCA23LA395](https://openairdocs.org/ntsb/DCA23LA395.md): Airbus A320-214 · Fort Lauderdale, FL · Accident · Serious injuries · Class 4 · Limited · Final report · Jul 23, 2023 · N229NV · No damage
  > The flight crew’s abrupt change in pitch in response to a traffic collision advisory system resolution advisory that resulted in a serious injury to a flight attendant.
- [NTSB ERA19FA170](https://openairdocs.org/ntsb/ERA19FA170.md): Piper PA 30 · Naples, FL · Accident · 1 fatal · Class 3 · Field · Final report · May 11, 2019 · N7650Y · Destroyed
  > Incapacitation of the pilot due to a birdstrike through the windshield in front of the pilot's position, while on approach to land.
- [NTSB ERA11CA511](https://openairdocs.org/ntsb/ERA11CA511.md): Boeing 737-823 · Miami, FL · Accident · Serious injuries · Data collection · Final report · Sep 29, 2011 · N804NN · No damage
  > The in-flight encounter with clear air turbulence, which resulted in an injury to a cabin attendant.
- [NTSB ERA11CA322](https://openairdocs.org/ntsb/ERA11CA322.md): Cessna 140A · Quincy, FL · Accident · No injuries · Data collection · Final report · May 26, 2011 · N1137D · Substantial damage
  > The private pilot's inability to maintain directional control of the airplane during the takeoff roll.

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

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