# NTSB investigations: Personnel records

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 WPR24FA080](https://openairdocs.org/ntsb/WPR24FA080.md): Swanson R/Swanson S RV-6 · Concord, CA · Accident · 1 fatal · Class 3 · Field · Final report · Jan 30, 2024 · N30AK · Substantial damage
  > A total loss of engine power during takeoff due to a separated fuel line and the pilot’s subsequent failure to maintain control of the airplane. Contributing to the accident were the pilot's medical condition and the effects of multiple impairing substances.
- [NTSB ANC19FA019](https://openairdocs.org/ntsb/ANC19FA019.md): De Havilland DHC 2 · Metlakatla, AK · Accident · 2 fatal · Class 2 · Field · Final report · May 20, 2019 · N67667 · Substantial damage
  > The pilot’s inadequate compensation for a quartering tailwind during a water landing, which resulted in a loss of control and subsequent nose-over. Contributing to the accident was the company’s inadequate operational control of the flight release process,…
- [NTSB DCA19MA086](https://openairdocs.org/ntsb/DCA19MA086.md): Boeing 767 · Trinity Bay, TX · Accident · 3 fatal · Class 1 · Major · Final report · Feb 23, 2019 · N1217A · Destroyed
  > The inappropriate response by the first officer as the pilot flying to an inadvertent activation of the go-around mode, which led to his spatial disorientation and nose-down control inputs that placed the airplane in a steep descent from which the crew did…
- [NTSB GAA16CA512](https://openairdocs.org/ntsb/GAA16CA512.md): Air Tractor AT802 · Wilson, AR · Accident · No injuries · Data collection · Final report · Sep 6, 2016 · N519EP · Substantial damage
  > The pilot’s failure to adequately survey the area of operation and his subsequent failure to maintain clearance from power lines during an agricultural application flight.
- [NTSB CEN15LA199](https://openairdocs.org/ntsb/CEN15LA199.md): Cessna 421B · Diboll, TX · Accident · Serious injuries · Limited investigation · Final report · Apr 17, 2015 · N421PK · Substantial damage
  > The total loss of engine power due to the use of an improper fuel type. Contributing to the accident were the servicing of the airplane with the improper fuel, noncompliance with an airworthiness directive, and the fuel nozzle installed on the fueling truck.
- [NTSB DCA09MA027](https://openairdocs.org/ntsb/DCA09MA027.md): Bombardier DHC-8-402 · Clarence Center, NY · Accident · 50 fatal · Class 1 · Major · Final report · Feb 13, 2009 · N200WQ · Destroyed
  > The captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…

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

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