# NTSB investigations, 2023, ND: Task performance

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 CEN23LA347](https://openairdocs.org/ntsb/CEN23LA347.md): Air Tractor AT-401 · Jamestown, ND · Accident · No injuries · Class 4 · Limited · Final report · Aug 3, 2023 · N6015W · Substantial damage
  > The pilot’s failure to maintain proper airspeed after liftoff, which resulted in the airplane exceeding its critical angle of attack and an aerodynamic stall.
- [NTSB CEN23LA255](https://openairdocs.org/ntsb/CEN23LA255.md): Piper PA-25-235 · Westhope, ND · Accident · Serious injuries · Class 4 · Limited · Final report · Jun 22, 2023 · N7419Z · Substantial damage
  > The pilot’s failure to maintain aircraft control that resulted in an impact with terrain after takeoff.
- [NTSB CEN23LA210](https://openairdocs.org/ntsb/CEN23LA210.md): Piper PA-18-150 · St. Anthony, ND · Accident · Minor injuries · Class 4 · Limited · Final report · May 30, 2023 · N7343L · Substantial damage
  > The pilot’s failure to maintain clearance from terrain while maneuvering at low attitude.
- [NTSB CEN23LA234](https://openairdocs.org/ntsb/CEN23LA234.md): Piper PA-28-181 · Grand Forks, ND · Accident · No injuries · Class 4 · Limited · Final report · May 28, 2023 · N771ND · Substantial damage
  > The student pilot’s failure to attain a proper takeoff attitude while demonstrating a soft field takeoff and his improper control inputs resulting in a dragged wing. Contributing to the accident were the gusting wind conditions.
- [NTSB CEN23LA103](https://openairdocs.org/ntsb/CEN23LA103.md): Cessna 425 · Bismarck, ND · Accident · Minor injuries · Class 3 · Limited · Final report · Feb 6, 2023 · N425Z · Substantial damage
  > A loss of braking due to inadequate servicing of brake fluid by the pilot/mechanic, which resulted in a loss of airplane control on the ground.

## 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 year(c."eventDate") = 2023
  AND c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT f.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_findings.parquet' f WHERE starts_with(f."findingCode", '0206'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/0206/cases?state=ND&year=2023

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
