# NTSB investigations: Piper PA-18-135: Runway excursion

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 GAA19CA348](https://openairdocs.org/ntsb/GAA19CA348.md): Piper PA18 · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Jun 16, 2019 · N2765A · Substantial damage
  > The pilot receiving instruction's premature pitch control input during takeoff, which resulted in an aborted takeoff and subsequent impact with terrain. Contributing to the accident was the flight instructor's delayed remedial action.
- [NTSB CEN12CA132](https://openairdocs.org/ntsb/CEN12CA132.md): Piper PA-18-135 · Del Norte, CO · Accident · No injuries · Data collection · Final report · Jan 2, 2012 · N9952Q · Substantial damage
  > The pilot's loss of directional control during the landing roll, which resulted in a runway excursion. Contributing to the accident were the sensitivity of the brake system and the certified flight instructor pilot's delayed remedial action.
- [NTSB ANC08CA128](https://openairdocs.org/ntsb/ANC08CA128.md): Piper PA-18 · Fairbanks, AK · Accident · No injuries · Data collection · Final report · Sep 18, 2008 · N2265A · Substantial damage
  > The pilot's selection of an unsuitable takeoff area. A Factor contributing to the accident was a short, rough and uneven takeoff site.

## 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 ('7101820')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '300' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/300/sequence?model=7101820

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