# NTSB investigations: Lycoming R680E series, AK

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 ANC86LA052](https://openairdocs.org/ntsb/ANC86LA052.md): Consolidated-Vultee L-13 · Fairbanks, AK · Accident · No injuries · Limited investigation · Final report · May 2, 1986 · N2536B · Substantial damage
  > During the takeoff roll the pilot lost control of the aircraft, the acft exited the runway and rolled over on its right side. The inspection of both tailwheel and tailwheel assembly revealed very loose cables between the locking handle and the tailwheel. At…
- [NTSB ANC69D0032](https://openairdocs.org/ntsb/ANC69D0032.md): Cessna T-50 · Stevens Vill, AK · Accident · Minor injuries · Closed · Sep 1, 1968 · N64700 · Destroyed
- [NTSB ANC66D0001](https://openairdocs.org/ntsb/ANC66D0001.md): Stinson V-77 · Feather Rivr, AK · Accident · No injuries · Closed · Jun 21, 1965 · N58571 · Substantial damage
- [NTSB UNK64X2573](https://openairdocs.org/ntsb/UNK64X2573.md): Cessna T50 · Lost River, AK · Accident · No injuries · Closed · Jun 29, 1964 · N30023 · Substantial damage
- [NTSB UNK64X0548](https://openairdocs.org/ntsb/UNK64X0548.md): Stinson V77 · Diomede Is, AK · Accident · No injuries · Closed · Feb 12, 1964 · N52904 · Substantial damage
- [NTSB ANC63A0060](https://openairdocs.org/ntsb/ANC63A0060.md): Cessna T-50 · Bethel, AK · Accident · No injuries · Closed · Jan 17, 1963 · N67643 · Substantial damage

## 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."eventStateOrRegion" = 'AK' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41545'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=41545&state=AK

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