# NTSB investigations: Aeronautical knowledge

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 CEN21FA198](https://openairdocs.org/ntsb/CEN21FA198.md): Piper PA-46-310P · Danville, AR · Accident · 4 fatal · Class 3 · Field · Final report · Apr 23, 2021 · N461DK · Substantial damage
  > The pilot’s improper decision to continue flight in an area of moderate-to-heavy icing conditions, which resulted in exceedance of the airplane’s anti-icing system capabilities, a degradation of aircraft performance, and subsequent aerodynamic stall.
- [NTSB ERA21LA056](https://openairdocs.org/ntsb/ERA21LA056.md): Cessna 172 · Atlanta, GA · Accident · No injuries · Class 3 · Limited · Final report · Nov 25, 2020 · N8125U · 2 aircraft · Substantial damage
  > The Cessna pilot’s failure to tune his radio to the common traffic advisory frequency, which resulted in a lack of awareness of the other aircraft operating at the airport. Contributing to the accident was the Cessna pilot’s lack of understanding of the…
- [NTSB CEN19FA088](https://openairdocs.org/ntsb/CEN19FA088.md): Piper PA46 · Shreveport, LA · Accident · 2 fatal · Field investigation · Final report · Feb 28, 2019 · N428CD · Substantial damage
  > The pilot's conduct of a departure into instrument meteorological conditions (IMC), which resulted in spatial disorientation and subsequent loss of airplane control. Contributing to the accident was the pilot's poor instrument flying skills and his decision…
- [NTSB GAA16LA199](https://openairdocs.org/ntsb/GAA16LA199.md): Buckeye Industries Dream Machine · Culver, IN · Accident · Serious injuries · Limited investigation · Final report · Apr 23, 2016 · N2564A · Substantial damage
  > The noncertificated pilot’s failure to attain a climb in the powered-parachute and its subsequent impact with a tree.
- [NTSB GAA15CA153](https://openairdocs.org/ntsb/GAA15CA153.md): Grumman American Avn. AA 5A · Mackay, ID · Accident · No injuries · Data collection · Final report · Jul 1, 2015 · N9887U · Substantial damage
  > The student pilot's disorientation in mountainous terrain and course deviation into a canyon, which resulted in the airplane's inability to out climb terrain and a forced landing.
- [NTSB ERA14CA314](https://openairdocs.org/ntsb/ERA14CA314.md): Cessna 172L · Danbury, CT · Accident · No injuries · Data collection · Final report · Jun 28, 2014 · N7867G · Substantial damage
  > The pilot's use of a person unfamiliar with aviation and his failure to properly secure the airplane during hand starting of the engine.
- [NTSB WPR13LA025](https://openairdocs.org/ntsb/WPR13LA025.md): Robinson Helicopter R22 Mariner · Lake Havasu, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 27, 2012 · N2627M · Substantial damage
  > The pilot’s unintentional and unrecognized entry into a vortex ring state as a result of conducting a course reversal turn into a tailwind while at a low altitude and airspeed, which resulted in an uncontrolled descent into water.

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

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