# NTSB investigations: Lycoming O-320-A2B: Loss of control - in flight

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 ANC07LA018](https://openairdocs.org/ntsb/ANC07LA018.md): Piper PA-12 · Glennallen, AK · Accident · Minor injuries · Limited investigation · Final report · Feb 1, 2007 · N3233M · Substantial damage
  > The pilot's failure to maintain adequate airspeed to preclude a stall while maneuvering, which resulted in an uncontrolled descent and subsequent collision with terrain. Factors contributing to the accident were variable wind conditions, and an inadvertent…
- [NTSB ANC94LA141](https://openairdocs.org/ntsb/ANC94LA141.md): Artic S-1B2 · Wasilla, AK · Accident · Serious injuries · Limited investigation · Final report · Sep 18, 1994 · N74AT · Substantial damage
  > A failure of the pilot to maintain adequate airspeed. A lack of total aeronautical experience was a factor in the accident.
- [NTSB ANC87LA058](https://openairdocs.org/ntsb/ANC87LA058.md): Piper PA-18 · Valdez, AK · Accident · No injuries · Limited investigation · Final report · Apr 5, 1987 · N9073D · Substantial damage
  > The pilot reported that he could not keep the ski equipped aircraft from banking to the left after take off and elected to reduce power and land. The aircraft sustained substantial damage when the left wing tip struck the ground and cartwheeled during the…
- [NTSB ANC85LA010](https://openairdocs.org/ntsb/ANC85LA010.md): Piper PA-18 · Port Heiden, AK · Accident · Serious injuries · Limited investigation · Final report · Oct 20, 1984 · N4313Y · Substantial damage
  > According to a state police report, the plt assaulted his wife, then loaded his two children into the acft and flew to a refueling area. He refueled the acft, then tookoff & crashed aprx 1 mile north of the departure rwy. A witness reported that after the…

## 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.engine_model_code IN ('42101')
    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" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?engine=42101&occurrence=250

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