# NTSB investigations: Development

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.

Page 4 of 4 · 153 cases

## Cases, newest first

- [NTSB CHI08IA152](https://openairdocs.org/ntsb/CHI08IA152.md): Eclipse EA500 · Chicago, IL · Incident · No injuries · Incident investigation · Final report · Jun 5, 2008 · N612KB · No damage
  > The airplane manufacturer's inadequate software design requirements of the engine's full authority digital electronic controls (FADEC) fault logic that resulted in a simultaneous unrecoverable loss of thrust control on both engines when the FADEC's input data…
- [NTSB DCA08IA048](https://openairdocs.org/ntsb/DCA08IA048.md): Boeing 757-200 · Richmond, VA · Incident · No injuries · Incident investigation · Final report · Mar 22, 2008 · N921UW · Minor damage
  > The installed wing panel clips failed due to fatigue, likely caused by the incorrect installation of the fasteners in response to SB 757-57-0027. Contributing to the incorrect installation was the SB's lack of clarity in the instructions and figures on the…
- [NTSB DFW08MA076](https://openairdocs.org/ntsb/DFW08MA076.md): Cessna 500 · Oklahoma City, OK · Accident · 5 fatal · Class 1 · Major · Final report · Mar 4, 2008 · N113SH · Destroyed
  > Airplane wing-structure damage sustained during impact with one or more large birds (American white pelicans), which resulted in a loss of control of the airplane.

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

This list as a web page: https://openairdocs.org/ntsb-findings/0401/cases?page=4

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
