# NTSB investigations, 2023, ND: Conditions/weather/phenomena

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 CEN23LA233](https://openairdocs.org/ntsb/CEN23LA233.md): Piper PA-25-235 · Carrington, ND · Accident · No injuries · Class 3 · Limited · Final report · Jun 3, 2023 · N8843L · Substantial damage
  > A total loss of engine power as a result of carburetor ice that formed while the engine was operating at a low power setting for an extended period of time before departure.
- [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 CEN23LA126](https://openairdocs.org/ntsb/CEN23LA126.md): Beech C90 · Bismark, ND · Accident · No injuries · Class 4 · Limited · Final report · Mar 9, 2023 · N46CV · Substantial damage
  > The ground vehicle driver’s failure to see and maintain clearance from the airplane while conducting ground operations.

## 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", '0303'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-findings/0303/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.
