# NTSB investigations: Fairchild C-82A: Undershoot

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 ANC83FA012](https://openairdocs.org/ntsb/ANC83FA012.md): Fairchild C-82 · Nelson Lagoon, AK · Accident · Serious injuries · Field investigation · Final report · Nov 4, 1982 · N4752C · Substantial damage
  > The acft landed short damaging the right boom & horizontal stabilizer. The rwy threshold is marked by light green reflective threshold markers & two red & white striped touchdown panels.
- [NTSB ANC82DA101](https://openairdocs.org/ntsb/ANC82DA101.md): Fairchild C-82A · Karluk, AK · Accident · No injuries · Final report · Sep 27, 1982 · N9701F · Substantial damage
  > The pilot reported that during arrival, the approach to landing seemed normal until just before touchdown. The aircraft touched down short of the runway threshold marks on relatively steep terrain in the safety zone. The pilot estimated that the touchdown…

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('3372004')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 390))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=3372004&occurrence=390

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