# NTSB investigations: LE flap control system

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 GAA19CA563](https://openairdocs.org/ntsb/GAA19CA563.md): De Havilland Beaver DHC 2 · Mountain Village, AK · Accident · No injuries · Data collection · Final report · Sep 22, 2019 · N77KZ · Substantial damage
  > The pilot's improper takeoff configuration due to distraction, which resulted in the airplane’s failure to become airborne and its subsequent collision with rising terrain. Contributing to the accident was the pilot's failure to use the Before Takeoff…
- [NTSB ANC17CA038](https://openairdocs.org/ntsb/ANC17CA038.md): Dehavilland DHC 2 · Dilllingham, AK · Accident · No injuries · Data collection · Final report · Jul 21, 2017 · N364RA · Substantial damage
  > The pilot's failure to set the wing flaps to the "takeoff" position, which resulted in a longer-than-normal takeoff run and collision with terrain.
- [NTSB CEN14CA395](https://openairdocs.org/ntsb/CEN14CA395.md): Cessna A188B · Milford, NE · Accident · No injuries · Data collection · Final report · Jul 23, 2014 · N730GU · Substantial damage
  > The pilot's improper engine mixture setting which reduced available engine power, and his inadvertent retraction of flaps which resulted in an impact with crops and terrain.

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

This list as a web page: https://openairdocs.org/ntsb-findings/01022780/cases

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