# NTSB investigations, 2019: Aircraft inspection event

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 WPR20CA056](https://openairdocs.org/ntsb/WPR20CA056.md): Cosmos Phase II · Lake Havasu City, AZ · Accident · Serious injuries · Data collection · Final report · Dec 22, 2019 · N5057Z · Substantial damage
  > The total loss of engine power due to fuel exhaustion, which resulted from the pilot's inadequate preflight fuel inspection.
- [NTSB GAA20CA089](https://openairdocs.org/ntsb/GAA20CA089.md): Cessna 172 · DuBois, PA · Accident · No injuries · Data collection · Final report · Nov 17, 2019 · N683SP · Substantial damage
  > The pilot's improper fuel management, which resulted in fuel starvation and a total loss of engine power, and his subsequent improper landing flare, which resulted in a hard, bounced landing. Contributing to the accident were the pilot's improper preflight…
- [NTSB ERA20LA035](https://openairdocs.org/ntsb/ERA20LA035.md): Beech 55 · Griffin, GA · Accident · No injuries · Class 3 · Limited · Final report · Nov 9, 2019 · N686DR · Substantial damage
  > The pilot’s failure to ensure that the airplane was properly configured for takeoff, which resulted in the inadvertent retraction of the landing gear during the takeoff roll and the airplane’s subsequent runway excursion.
- [NTSB CEN19LA252](https://openairdocs.org/ntsb/CEN19LA252.md): Piper PA28 · Miami, FL · Accident · Serious injuries · Class 3 · Limited · Final report · Aug 5, 2019 · N5915U · Substantial damage
  > The flight instructor's and student pilot's inadequate preflight inspection of the fuel system for water contamination, which resulted in a loss of engine power during takeoff and subsequent forced landing.
- [NTSB GAA19CA372](https://openairdocs.org/ntsb/GAA19CA372.md): Cessna T206 · Porterville, CA · Accident · No injuries · Data collection · Final report · Apr 29, 2019 · N189JC · Substantial damage
  > The pilot's failure to verify that the rear cargo portion of the right cabin door was adequately secured before flight, which resulted in both portions of the door opening in flight and substantial damage to the fuselage.
- [NTSB CEN19LA129](https://openairdocs.org/ntsb/CEN19LA129.md): Piper PA 23 · Sulphur Spring, TX · Accident · No injuries · Class 3 · Limited · Final report · Apr 27, 2019 · N233P · Substantial damage
  > The pilot’s inadequate preflight inspection, during which he failed to detect the water contamination in the left fuel, which resulted in a partial loss of power in the left engine. Contributing to the accident was the total loss of power in the right engine…
- [NTSB WPR19FA115](https://openairdocs.org/ntsb/WPR19FA115.md): Beech 60 · Fullerton, CA · Accident · 1 fatal · Class 3 · Field · Final report · Apr 19, 2019 · N65MY · Destroyed
  > The pilot’s use of an unapproved elevator control lock device, and his failure to remove that device and correctly position the elevator before flight, which resulted in a loss of control during takeoff. Contributing to the accident was his failure to perform…

## 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") = 2019
  AND c."mKey" IN (SELECT s.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s."tier2Number" = '050' 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/050/sequence?year=2019

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