# NTSB investigations: Ground proximity system

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 CEN19FA024](https://openairdocs.org/ntsb/CEN19FA024.md): Bell 206 · Uvalde, TX · Accident · 3 fatal · Field investigation · Final report · Nov 4, 2018 · N417WT · Destroyed
  > The pilot's controlled flight into terrain during night visual meteorological conditions. Contributing to the accident was the pilot improper decision to inhibit the helicopter's terrain warning systems and flight at low altitude.
- [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 ANC15MA041](https://openairdocs.org/ntsb/ANC15MA041.md): Dehavilland DHC-3 · Ketchikan, AK · Accident · 9 fatal · Class 1 · Major · Final report · Jun 25, 2015 · N270PA · Substantial damage
  > (1) the pilot's decision to continue visual flight into an area of instrument meteorological conditions, which resulted in his geographic disorientation and controlled flight into terrain; and (2) Promech's company culture, which tacitly endorsed flying in…
- [NTSB WPR14LA177](https://openairdocs.org/ntsb/WPR14LA177.md): Airplane Factory Ltd The Sling · Daggett, CA · Accident · Serious injuries · Limited investigation · Final report · Apr 30, 2014 · N511NG · Substantial damage
  > The pilots’ failure to maintain clearance from terrain while operating in dark night, visual meteorological conditions. Contributing to the accident was the pilots’ failure to enable the aural terrain warning system.
- [NTSB DCA13MA133](https://openairdocs.org/ntsb/DCA13MA133.md): Airbus A300 - F4 622R · Birmingham, AL · Accident · 2 fatal · Class 1 · Major · Final report · Aug 14, 2013 · N155UP · Destroyed
  > the flight crew's continuation of an unstabilized approach and their failure to monitor the aircraft's altitude during the approach, which led to an inadvertent descent below the minimum approach altitude and subsequently into terrain. Contributing to the…
- [NTSB WPR12MA046](https://openairdocs.org/ntsb/WPR12MA046.md): Rockwell 690 · Apache Junction, AZ · Accident · 6 fatal · Major investigation · Final report · Nov 24, 2011 · N690SM · Destroyed
  > The pilot's failure to maintain a safe ground track and altitude combination for the moonless night visual flight rules flight, which resulted in controlled flight into terrain. Contributing to the accident were the pilot's complacency and lack of situational…
- [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", '01023444'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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