# NTSB investigations, FL: Task environment

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 ERA22LA119](https://openairdocs.org/ntsb/ERA22LA119.md): Great Lakes 2T-1A-2 · Naples, FL · Accident · No injuries · Class 4 · Limited · Final report · Feb 11, 2022 · N87G · 2 aircraft · Minor damage
  > The biplane pilot’s inadequate visual lookout, which resulted in an on-ground collision with another airplane while taxiing.
- [NTSB DCA19CA153](https://openairdocs.org/ntsb/DCA19CA153.md): Airbus A320 · Fort Lauderdale, FL · Accident · Serious injuries · Class 4 · Data collection · Final report · May 28, 2019 · N507JT · No damage
  > A buildup of pressure in the coffee filter package resulting in the release of hot coffee and grounds when the pot locking lever was raised.
- [NTSB GAA18CA218](https://openairdocs.org/ntsb/GAA18CA218.md): Piper PA 28-161 · Pensacola, FL · Accident · No injuries · Data collection · Final report · Apr 15, 2018 · N8115Y · Substantial damage
  > The pilot’s loss of directional control and long landing in gusting wind conditions due to his shoe getting stuck on the brakes.
- [NTSB ERA17FA143](https://openairdocs.org/ntsb/ERA17FA143.md): Cessna 170B · Edgewater, FL · Accident · 2 fatal · Field investigation · Final report · Apr 1, 2017 · N8082A · 2 aircraft · Destroyed
  > The Cessna pilot's failure to maintain clearance from the Grumman during the transition to a different formation. Contributing to the accident was the stepped down configuration of the formation flight which was composed of dissimilar aircraft.
- [NTSB GAA16CA510](https://openairdocs.org/ntsb/GAA16CA510.md): Great Lakes 2T1A · Port St. Lucie, FL · Accident · No injuries · Data collection · Final report · Sep 16, 2016 · N3771F · Substantial damage
  > The pilot's failure to avoid the drainage pipe during the landing roll on a private grass airstrip. Contributing to the accident was the pilot's reduced forward view from the rear seat.
- [NTSB ERA12MA122](https://openairdocs.org/ntsb/ERA12MA122.md): Bell 206B · Green Cove Springs, FL · Accident · 3 fatal · Major investigation · Final report · Dec 26, 2011 · N5016M · Destroyed
  > The pilot’s improper decision to continue visual flight into night instrument meteorological conditions, which resulted in controlled flight into terrain. Contributing to the pilot’s improper decision was his self-induced pressure to complete the trip.

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

This list as a web page: https://openairdocs.org/ntsb-findings/0304/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.
