# Final NTSB investigations, ND: Terrain

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 GAA18CA241](https://openairdocs.org/ntsb/GAA18CA241.md): Aeronca 65 LB · Carrington, ND · Accident · No injuries · Data collection · Final report · Apr 28, 2018 · N34459 · Substantial damage
  > The pilot’s failure to maintain directional control and his subsequent excessive brake application during landing, which resulted in a nose-over.
- [NTSB CEN16LA314](https://openairdocs.org/ntsb/CEN16LA314.md): Aero Commander S2R · Valley City, ND · Accident · No injuries · Limited investigation · Final report · Aug 5, 2016 · N5599X · Substantial damage
  > The pilot's inadequate preflight inspection and fuel planning, which resulted in a loss of engine power due to fuel exhaustion.
- [NTSB CEN16LA012](https://openairdocs.org/ntsb/CEN16LA012.md): Refling RV8 · Bottineau, ND · Accident · No injuries · Limited investigation · Final report · Oct 6, 2015 · UNREG · Substantial damage
  > The pilot/builder’s failure to ensure that the fuel line was properly secured, which resulted in fuel starvation and the subsequent total loss of engine power.
- [NTSB CEN12LA437](https://openairdocs.org/ntsb/CEN12LA437.md): Piper PA-25-235 · Mott, ND · Accident · No injuries · Limited investigation · Final report · Jul 12, 2012 · N8801L · Substantial damage
  > The rupture of a corroded oil line, which resulted in a total loss of engine power due to oil starvation.
- [NTSB CEN12CA430](https://openairdocs.org/ntsb/CEN12CA430.md): Bellanca 7KCAB · Williston, ND · Accident · No injuries · Data collection · Final report · Jul 9, 2012 · N8709V · Substantial damage
  > The pilot's failure to ensure a suitable landing surface.
- [NTSB CEN11CA477](https://openairdocs.org/ntsb/CEN11CA477.md): Piper PA-25-235 · Minot, ND · Accident · No injuries · Data collection · Final report · Jul 14, 2011 · N7709Z · Substantial damage
  > The pilot's inadequate inspection of the takeoff area which resulted in a collision with terrain and the subsequent loss of control during takeoff.

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

This list as a web page: https://openairdocs.org/ntsb-findings/030210/cases?state=ND&status=final

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