# NTSB investigations: Task scheduling

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 ANC25LA013](https://openairdocs.org/ntsb/ANC25LA013.md): Cessna 182B · Waimea, HI · Accident · No injuries · Class 3 · Limited · Final report · Dec 23, 2024 · N7143E · Substantial damage
  > The pilot’s inadequate monitoring of the fuel status while en route, which resulted in a total loss of engine power due to fuel starvation.
- [NTSB ERA20CA236](https://openairdocs.org/ntsb/ERA20CA236.md): Cessna 172 · Meadville, PA · Accident · No injuries · Class 4 · Data collection · Final report · Jul 1, 2020 · N9127H · Substantial damage
  > The pilot's distraction while taxiing, which resulted in a taxiway excursion.
- [NTSB WPR15MA243](https://openairdocs.org/ntsb/WPR15MA243.md): Cessna 172M · San Diego, CA · Accident · 5 fatal · Major investigation · Final report · Aug 16, 2015 · N1285U · 2 aircraft · Destroyed
  > The local controller's (LC) failure to properly identify the aircraft in the pattern and to ensure control instructions provided to the intended Cessna on downwind were being performed before turning Eagle1 into its path for landing. Contributing to the LC's…
- [NTSB CEN11CA609](https://openairdocs.org/ntsb/CEN11CA609.md): Mooney M20C · Allen, OK · Accident · Minor injuries · Data collection · Final report · Aug 30, 2011 · N5501Q · Substantial damage
  > A total loss of engine power in flight due to fuel starvation as a result of the pilot’s inadequate fuel management.
- [NTSB OPS10IA574](https://openairdocs.org/ntsb/OPS10IA574.md): Airbus Industrie A320-214 · Minneapolis, MN · Incident · No injuries · Incident investigation · Final report · Sep 16, 2010 · N122US · 2 aircraft · No damage
  > The Local North Controller's issuance of a left-turn heading to the Airbus without establishing the position and heading of the Beech. Contributing to the incident was the Local South Controller's distraction with a ground movement operation and lack of…

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

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