# NTSB investigations: Safety programs, 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 ERA22FA004](https://openairdocs.org/ntsb/ERA22FA004.md): Dassault Falcon 20 · Thomson, GA · Accident · 2 fatal · Class 3 · Field · Final report · Oct 5, 2021 · N283SA · Destroyed
  > The flight crew’s continuation of an unstable dark night visual approach and the captain’s instruction to use air brakes during the approach contrary to airplane operating limitations, which resulted in a descent below the glide path, and a collision with…
- [NTSB CEN19MA141](https://openairdocs.org/ntsb/CEN19MA141.md): De Havilland DHC-2 · Ketchikan, AK · Accident · 6 fatal · Class 1 · Major · Final report · May 13, 2019 · N952DB · 2 aircraft · Destroyed
  > The inherent limitations of the see-and-avoid concept, which prevented the two pilots from seeing the other airplane before the collision, and the absence of visual and aural alerts from both airplanes’ traffic display systems, while operating in a geographic…
- [NTSB WPR17LA075](https://openairdocs.org/ntsb/WPR17LA075.md): Hughes 369A · (Pacific Ocean) · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 2017 · N805LA · Substantial damage
  > The pilot's failure to detect the presence of water in the helicopter fuel system before the flight, which resulted in a total loss of engine power during cruise. Contributing to the accident was the pilot's delayed recognition of the power loss and late…
- [NTSB ANC17MA001](https://openairdocs.org/ntsb/ANC17MA001.md): Cessna 208B · Togiak, AK · Accident · 3 fatal · Class 1 · Major · Final report · Oct 2, 2016 · N208SD · Destroyed
  > The flight crew's decision to continue the visual flight rules flight into deteriorating visibility and their failure to perform an immediate escape maneuver after entry into instrument meteorological conditions, which resulted in controlled flight into…
- [NTSB ANC13GA036](https://openairdocs.org/ntsb/ANC13GA036.md): Eurocopter AS350 · Talkeetna, AK · Accident · 3 fatal · Class 1 · Final report · Mar 31, 2013 · N911AA · Destroyed
  > The pilot's decision to continue flight under visual flight rules into deteriorating weather conditions, which resulted in the pilot's spatial disorientation and loss of control. Also causal was the Alaska Department of Public Safety's punitive culture and…
- [NTSB DCA09MA027](https://openairdocs.org/ntsb/DCA09MA027.md): Bombardier DHC-8-402 · Clarence Center, NY · Accident · 50 fatal · Class 1 · Major · Final report · Feb 13, 2009 · N200WQ · Destroyed
  > The captain’s inappropriate response to the activation of the stick shaker, which led to an aerodynamic stall from which the airplane did not recover. Contributing to the accident were (1) the flight crew's failure to monitor airspeed in relation to the…
- [NTSB MIA08MA203](https://openairdocs.org/ntsb/MIA08MA203.md): Aerospatiale SA365N-1 D · District Heights, MD · Accident · 4 fatal · Class 1 · Major · Final report · Sep 28, 2008 · N92MD · Substantial damage
  > The pilot's attempt to regain visual conditions by performing a rapid descent and his failure to arrest the descent at the minimum descent altitude during a nonprecision approach. Contributing to the accident were (1) the pilot’s limited recent instrument…

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

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