# NTSB investigations: Oversight, 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 WPR24FA018](https://openairdocs.org/ntsb/WPR24FA018.md): Beech A36 · Covelo, CA · Accident · 2 fatal · Class 3 · Field · Final report · Oct 21, 2023 · N8248K · Destroyed
  > The pilot’s failure to maintain clearance from trees after entering a steep banked turn for unknown reasons. Contributing to the accident was the pilot’s decision to take off toward rising terrain.
- [NTSB ERA13LA134](https://openairdocs.org/ntsb/ERA13LA134.md): Eurocopter Deutschland MBB-BK 117 C-2 · Danville, PA · Accident · No injuries · Limited investigation · Final report · Feb 14, 2013 · N481LF · Substantial damage
  > The pilot’s decision to conduct a straight-in approach to the helipad, which resulted in the main rotor blade impacting a construction crane flag marker. Contributing to the accident was the erroneous information about the construction crane’s operation time…
- [NTSB DCA13IA037](https://openairdocs.org/ntsb/DCA13IA037.md): Boeing 787 · Boston, MA · Incident · No injuries · Class 1 · Incident · Final report · Jan 7, 2013 · JA829J · Minor damage
  > an internal short circuit within a cell of the auxiliary power unit (APU) lithium-ion battery, which led to thermal runaway that cascaded to adjacent cells, resulting in the release of smoke and fire. The incident resulted from Boeing's failure to incorporate…
- [NTSB WPR11LA094](https://openairdocs.org/ntsb/WPR11LA094.md): Rockwell International S-2R · Oakley, CA · Accident · 1 fatal · Limited investigation · Final report · Jan 10, 2011 · N4977X · Substantial damage
  > An in-flight collision with an unmarked meteorological evaluation tower (MET) during an aerial application flight due to the pilot's failure to see and avoid the obstacle. Contributing to the accident was the lack of visual conspicuity of the MET and the lack…
- [NTSB WPR10FA448](https://openairdocs.org/ntsb/WPR10FA448.md): Beech 65 · Redwood City, CA · Accident · 3 fatal · Field investigation · Final report · Sep 2, 2010 · N832B · Substantial damage
  > A loss of power in the right engine for undetermined reasons and the pilot’s subsequent failure to maintain adequate airspeed, which resulted in a loss of control. Contributing to the loss of control was the regulatory certification basis of the airplane that…
- [NTSB ERA10FA404](https://openairdocs.org/ntsb/ERA10FA404.md): Beech 58 · Saltsburg, PA · Accident · 2 fatal · Field investigation · Final report · Aug 7, 2010 · N28MR · Substantial damage
  > The pilot’s loss of control of the airplane during low-airspeed airwork and his failure to promptly recover the airplane from the aerodynamic stall, which resulted in a spin. Contributing to the accident were the pilot and certified flight instructor’s…
- [NTSB ERA09LA020](https://openairdocs.org/ntsb/ERA09LA020.md): Sikorsky S-76C · New York, NY · Accident · No injuries · Limited investigation · Final report · Oct 16, 2008 · N552J · Substantial damage
  > The failure of the flightcrew to stabilize the helicopter over its confined landing area during a hovering left-pedal turn, resulting in tail rotor blade contact with a perimeter fence component and a subsequent loss of directional control. Contributing to…

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

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