# NTSB investigations: Visual approach aid

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 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.

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

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