# NTSB investigations: Document/info verification

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 CEN23LA014](https://openairdocs.org/ntsb/CEN23LA014.md): Diamond Aircraft Ind DA 62 · Dallas, TX · Accident · No injuries · Class 3 · Limited · Final report · Oct 15, 2022 · N84LT · Substantial damage
  > A total loss of airplane electrical power for undetermined reasons, which resulted in a complete loss of engine power to both engines. Contributing was the worn main battery and the incorrectly wired ECU backup batteries.
- [NTSB CEN22LA430](https://openairdocs.org/ntsb/CEN22LA430.md): Agusta AW139 · Houma, LA · Accident · No injuries · Class 3 · Limited · Final report · Sep 24, 2022 · N811TA · Substantial damage
  > The inflight loss of collective control of the helicopter due to thermal damage of a collective control torque tube that abraded with misrouted electrical wiring, which resulted in an electrical short and inflight fire. Contributing to the accident were the…
- [NTSB CEN15LA057](https://openairdocs.org/ntsb/CEN15LA057.md): Embraer EMB-500 · Sugarland, TX · Accident · No injuries · Limited investigation · Final report · Nov 21, 2014 · N584JS · Substantial damage
  > The pilot's engagement of the emergency parking brake during the landing roll, which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the pilot's decision to engage the emergency parking…
- [NTSB CEN14FA505](https://openairdocs.org/ntsb/CEN14FA505.md): Embraer EMB 505 · Conroe, TX · Accident · No injuries · Field investigation · Final report · Sep 19, 2014 · N322QS · Substantial damage
  > The second-in-command's (SIC) engagement of the emergency parking brake (EPB), which decreased the airplane's braking performance and prevented it from stopping on the available runway. Contributing to the SIC's decision to engage the EPB was the…
- [NTSB ERA12TA538](https://openairdocs.org/ntsb/ERA12TA538.md): Bell 407 · Bath, NY · Accident · Minor injuries · Final report · Aug 31, 2012 · N11SP · Substantial damage
  > The pilot's improper recovery from an in-flight upset, which resulted in the main rotor striking and separating the tail boom. Contributing to the accident was the helicopter manufacturer's failure to warn pilots of unanticipated and unequal aft cyclic…
- [NTSB ANC11LA108](https://openairdocs.org/ntsb/ANC11LA108.md): Eurocopter AS 350 BA · Juneau, AK · Accident · No injuries · Limited investigation · Final report · Sep 26, 2011 · N230CH · Substantial damage
  > Upslope wind conditions while the helicopter was operating at ground idle, which resulted in the helicopter rollover. Contributing to the accident was the lack of manufacturer data regarding the effect of upslope wind conditions on helicopter ground idle…

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

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