# NTSB investigations: Adequacy of equipment

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 DCA24FA143](https://openairdocs.org/ntsb/DCA24FA143.md): Boeing 737-7CT · Gulf of America (Gulf of Mexico) · Accident · Serious injuries · Class 3 · Field · Final report · Apr 3, 2024 · N567WN · No damage
  > The pilot’s inadvertent encounter with convectively induced turbulence from a broken line of embedded thunderstorms moving across the region. Contributing to the accident was the failure of the air traffic controller to issue pertinent weather information…
- [NTSB DCA23LA465](https://openairdocs.org/ntsb/DCA23LA465.md): Boeing 787-8 · Lake Erie Beach, NY · Accident · Serious injuries · Class 4 · Limited · Final report · Sep 28, 2023 · N804AN · No damage
  > Malfunctioning brakes on a service cart.
- [NTSB CEN14LA390](https://openairdocs.org/ntsb/CEN14LA390.md): Bell 206B · Bennet, NE · Accident · No injuries · Limited investigation · Final report · Jul 26, 2014 · N240SJ · Substantial damage
  > A total loss of engine power due to fuel contamination, which resulted from the pilot’s inadequate preflight inspection. Contributing to the accident was the operator’s failure to properly maintain the fuel storage tank.
- [NTSB CEN14CA391](https://openairdocs.org/ntsb/CEN14CA391.md): Continental Copters Tomcat MK5A · Osage, MN · Accident · No injuries · Data collection · Final report · Jul 25, 2014 · N161SH · Substantial damage
  > The total loss of engine power due to water contamination of the fuel, which resulted in the pilot's forced landing and impact with terrain. Contributing to the accident was the pilot's decision to operate the helicopter without resolving the fuel…

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

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