# NTSB investigations: Approach aid coverage/avail

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 WPR23LA065](https://openairdocs.org/ntsb/WPR23LA065.md): Piper PA42 · Lewistown, MT · Accident · No injuries · Class 4 · Limited · Final report · Dec 13, 2022 · C-GZPU · Substantial damage
  > The pilot’s improper landing flare, which resulted in a hard landing. Contributing to the accident was the out of service visual glideslope indicator and snow obscuring the runway markings.
- [NTSB GAA19CA525](https://openairdocs.org/ntsb/GAA19CA525.md): Cessna 182 · Charleston, WV · Accident · Minor injuries · Data collection · Final report · Sep 5, 2019 · N2408Q · Substantial damage
  > The pilot's improper approach path at night and his misjudgment of the landing point, which resulted in landing short of the runway and impact with the runway's engineered materials arrestor system.
- [NTSB DCA19FA089](https://openairdocs.org/ntsb/DCA19FA089.md): Embraer EMB145 · Presque Isle, ME · Accident · Minor injuries · Class 3 · Field · Final report · Mar 4, 2019 · N14171 · Substantial damage
  > The flight crew’s decision, due to confirmation bias, to continue the descent below the decision altitude when the runway had not been positively identified. Contributing to the accident were (1) the first officer’s fatigue, which exacerbated his confirmation…
- [NTSB GAA19CA001](https://openairdocs.org/ntsb/GAA19CA001.md): Cessna 340 · Keokuk, IA · Accident · No injuries · Data collection · Final report · Oct 1, 2018 · N89AM · Substantial damage
  > The pilot's failure to correctly identify the runway environment during an instrument approach at night in instrument meteorological conditions because he mistook building lights for runway lights, which resulted in landing short of the runway.
- [NTSB OPS18IA015](https://openairdocs.org/ntsb/OPS18IA015.md): Boeing 747 · Chicago, IL · Incident · No injuries · Class 3 · Incident · Final report · Jun 21, 2018 · B-18711 · No damage
  > Interference with the localizer signal resulting in a Multipath condition experienced by CAL5148 while conducting an ILS CAT III (autoland) approach. This condition resulted in a runway excursion and subsequent go-around. The interference was most likely…
- [NTSB CEN16LA097](https://openairdocs.org/ntsb/CEN16LA097.md): Piper PA 28-140 · Sturtevant, WI · Accident · No injuries · Limited investigation · Final report · Feb 1, 2016 · N1572J · Substantial damage
  > The pilot's failure to maintain a proper glidepath during a landing at dusk, which resulted in impact with a moving ground vehicle. Contributing to the accident was the inoperative precision approach path indicator.
- [NTSB CEN16LA016](https://openairdocs.org/ntsb/CEN16LA016.md): Cirrus Design SR22 · Lancaster, TX · Accident · Serious injuries · Limited investigation · Final report · Oct 17, 2015 · N849CD · Destroyed
  > The pilot’s failure to maintain a proper glidepath during a night visual approach, which resulted in impact with a power line. Contributing to the accident was an inoperative precision approach path indicator.
- [NTSB OPS10IA001](https://openairdocs.org/ntsb/OPS10IA001.md): Boeing 767 · Atlanta Hartsfield Intl. Apt. (KATL), GA · Incident · No injuries · Incident investigation · Final report · Oct 19, 2009 · N185DN · No damage
  > The flight crew’s failure to identify the correct landing surface due to fatigue. Contributing to the cause of the incident were (1) the flight crew’s decision to accept a late runway change, (2) the unavailability of the approach light system and the…
- [NTSB ERA09FA053](https://openairdocs.org/ntsb/ERA09FA053.md): Cirrus Design SR22 · Tallahassee, FL · Accident · 2 fatal · Field investigation · Final report · Nov 14, 2008 · N827GM · Substantial damage
  > The pilot's failure to maintain adequate airspeed on final approach, which resulted in a low-altitude aerodynamic stall and spin. Contributing to the accident was the pilot's failure to fly the published instrument approach and his subsequent failure to…
- [NTSB SEA08LA082](https://openairdocs.org/ntsb/SEA08LA082.md): Raytheon 1900D · Kayenta, AZ · Accident · Serious injuries · Limited investigation · Final report · Feb 22, 2008 · N305PC · Substantial damage
  > The flight crew's failure to execute a missed approach, which resulted in a runway excursion after landing. Contributing to the accident were the inoperative lights, weather conditions below published approach minimums, and the slush contaminated runway.

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

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