# NTSB investigations, 2006, ND: In flight collision with terrain/water

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 CHI06CA257](https://openairdocs.org/ntsb/CHI06CA257.md): Piper PA-25-235 · Anamoose, ND · Accident · No injuries · Data collection · Final report · Sep 6, 2006 · N8501L · Substantial damage
  > The pilot not maintaining altitude/clearance from terrain during the aerial application pass.
- [NTSB CHI06LA240](https://openairdocs.org/ntsb/CHI06LA240.md): Cessna A188B · Rolla, ND · Accident · No injuries · Limited investigation · Final report · Aug 18, 2006 · N9224R · Substantial damage
  > The pilot's failure to maintain clearance from terrain during the aerial-application flight, and the loss of engine power due to the overstress failure of the engine crankshaft sustained during ground impact. Contributing to the accident was the low-altitude…
- [NTSB CHI06CA229](https://openairdocs.org/ntsb/CHI06CA229.md): Cessna 150 · Jamestown, ND · Accident · No injuries · Data collection · Final report · Aug 12, 2006 · N17015 · Substantial damage
  > The pilot's inadequate preflight planning resulted in the pilot not attaining the proper takeoff climb and failure to maintain terrain clearance. Contributing factors included the transmission wires, the row of trees, and the field of corn.
- [NTSB CHI06CA162](https://openairdocs.org/ntsb/CHI06CA162.md): Weatherly 201B · Bowbells, ND · Accident · Minor injuries · Data collection · Final report · Jun 22, 2006 · N1263W · Substantial damage
  > The pilot's failure to maintain clearance to the rising terrain while maneuvering during the agricultural application flight. Contirbuting factors were the low altitude operation and the rising terrain.
- [NTSB CHI06CA168](https://openairdocs.org/ntsb/CHI06CA168.md): Schweizer 269C · Grand Forks, ND · Accident · No injuries · Data collection · Final report · Jun 17, 2006 · N1675U · Substantial damage
  > The dual student's failure to maintain rotor speed during the recovery from the intentional autorotation and the flight instructor's delayed remedial action. Contributing factors were the flight crew's intentional autorotation and dual student's misjudged…
- [NTSB CHI06CA153](https://openairdocs.org/ntsb/CHI06CA153.md): Cessna R182 · Cooperstown, ND · Accident · No injuries · Data collection · Final report · Jun 9, 2006 · N3360C · Substantial damage
  > The pilot's inability to gain sufficient altitude during the aborted landing. Factors associated with the accident were the tailwind, the pilot's selection of the runway used, the wet runway, the roadway, and the corn crop.

## 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") = 2006
  AND c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT o.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o."occurrenceNumber" = 1 AND o."occurrenceCode" = 230)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=230&state=ND&year=2006

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