# NTSB investigations: Confusion

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 WPR25LA110](https://openairdocs.org/ntsb/WPR25LA110.md): Robinson Helicopter R44 II · Las Vegas, NV · Accident · Minor injuries · Class 3 · Limited · Final report · Mar 10, 2025 · N44KY · Substantial damage
  > The pilot’s loss of helicopter control after the door opened during takeoff. Contributing to the accident was the pilot’s failure to confirm that the door was properly closed before departure.
- [NTSB GAA19CA138](https://openairdocs.org/ntsb/GAA19CA138.md): Cessna 172RG · Atlanta, GA · Accident · No injuries · Data collection · Final report · Feb 13, 2019 · N5223V · Substantial damage
  > The pilot's failure to extend the landing gear before landing. Contributing to the accident were the pilot’s inability to see the landing gear position light because his iPad was blocking his view of it and his feeling of being rushed during the approach and…

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

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