# Fatal NTSB investigations: Access to equipment/controls

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 CEN22FA331](https://openairdocs.org/ntsb/CEN22FA331.md): Columbia Helicopters CH-47D · North Fork, ID · Accident · 2 fatal · Class 3 · Field · Final report · Jul 21, 2022 · N388RA · Destroyed
  > The failure of the flight crew to properly secure a company-issued iPad, leading to its migration into and jamming of the copilot’s left pedal, preventing the pilot from arresting a left yaw, and resulting in a loss of control.
- [NTSB WPR22FA068](https://openairdocs.org/ntsb/WPR22FA068.md): Gates Learjet 35A · El Cajon, CA · Accident · 4 fatal · Class 3 · Field · Final report · Dec 28, 2021 · N880Z · Destroyed
  > The flight crew’s decision to descend below the published MDA, cancel their IFR clearance to conduct an unauthorized circle-to-land approach to another runway while the airport was in nighttime IFR conditions, and the exceedance of the airplane’s critical…
- [NTSB ERA12FA484](https://openairdocs.org/ntsb/ERA12FA484.md): Cessna 172M · San Juan, PR · Accident · 1 fatal · Field investigation · Final report · Jul 25, 2012 · N73115 · Substantial damage
  > Maintenance personnel’s improper lubrication of the right direct aileron control cable and failure to detect the severe corrosion of the cable during a maintenance inspection, which resulted in the in-flight failure of the cable, the pilot’s subsequent…

## 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."highestInjuryLevel" = 'Fatal'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '03041015'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/03041015/cases?fatal=1

---
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.
