# NTSB investigations: Communication system, general

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 ERA24LA313](https://openairdocs.org/ntsb/ERA24LA313.md): Trozzi Thomas Searey · Eustis, FL · Accident · No injuries · Class 4 · Limited · Final report · Jul 6, 2024 · N222D · Substantial damage
  > The flight instructor's failure to properly configure the landing gear before performing a water landing.
- [NTSB DCA13MA120](https://openairdocs.org/ntsb/DCA13MA120.md): Boeing 777-200ER · San Francisco, CA · Accident · 3 fatal · Class 1 · Major · Final report · Jul 6, 2013 · HL7742 · Destroyed
  > The flight crew's mismanagement of the airplane's descent during the visual approach, the pilot flying's unintended deactivation of automatic airspeed control, the flight crew's inadequate monitoring of airspeed, and the flight crew's delayed execution of a…
- [NTSB WPR12CA310](https://openairdocs.org/ntsb/WPR12CA310.md): Piper PA-46 · Delano, CA · Accident · No injuries · Data collection · Final report · Jul 17, 2012 · N558RW · Substantial damage
  > The pilot's failure to extend the landing gear before touchdown. Contributing to the accident was the pilot's failure to perform the appropriate checklist due to distractions posed by another airplane inbound to the same airport and a cluttered radio…
- [NTSB WPR12FA184](https://openairdocs.org/ntsb/WPR12FA184.md): Cessna A185F · Blanding, UT · Accident · 3 fatal · Field investigation · Final report · Apr 25, 2012 · N243W · Substantial damage
  > The pilot's failure to maintain airplane control during low-level maneuvering flight. Contributing to the pilot’s death was the lack of a timely emergency rescue response due to the lack of effective emergency signal transmissions from both the airplane’s…
- [NTSB DCA11MA076](https://openairdocs.org/ntsb/DCA11MA076.md): Gulfstream GVI · Roswell, NM · Accident · 4 fatal · Class 1 · Major · Final report · Apr 2, 2011 · N652GD · Substantial damage
  > The National Transportation Safety Board determines the probable cause(s) of this accident as follows: an aerodynamic stall and subsequent uncommanded roll during a one engine-inoperative takeoff flight test, which were the result of (1) Gulfstream’s failure…

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

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