# NTSB investigations, 2020, FL: Nose over/nose down

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 ERA20LA316](https://openairdocs.org/ntsb/ERA20LA316.md): Vans RV6 · Melbourne, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 11, 2020 · N196DJ · Substantial damage
  > A total loss of engine power for reasons that could not be determined based on the available evidence.
- [NTSB ERA20LA299](https://openairdocs.org/ntsb/ERA20LA299.md): Cessna 172 · Weston, FL · Accident · No injuries · Class 3 · Limited · Final report · Aug 27, 2020 · N65645 · Substantial damage
  > A total loss of engine power due to the failure of the Nos. 1 and 3 connecting rods from lack of lubrication.
- [NTSB ERA20CA257](https://openairdocs.org/ntsb/ERA20CA257.md): Kade Aventura II · Astor, FL · Accident · Minor injuries · Class 4 · Data collection · Final report · Jul 16, 2020 · N86KD · Substantial damage
  > The pilot's failure to retract the amphibious airplane’s landing gear prior to the water landing, which resulted in a nose over.
- [NTSB ERA20CA093](https://openairdocs.org/ntsb/ERA20CA093.md): Cessna 172 · Crystal River, FL · Accident · No injuries · Data collection · Final report · Jan 31, 2020 · N739XT · Substantial damage
  > The student pilot's failure to maintain directional control during takeoff, which resulted in a runway excursion and subsequent nose-over.
- [NTSB ERA20CA081](https://openairdocs.org/ntsb/ERA20CA081.md): Pereyra Aventura · East Palatka, FL · Accident · Minor injuries · Data collection · Final report · Jan 14, 2020 · N366RC · Substantial damage
  > The pilot's failure to properly configure the amphibious airplane for a water landing, which resulted in it flipping over.

## 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 year(c."eventDate") = 2020
  AND c."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '096' 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/096/sequence?state=FL&year=2020

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