# Final NTSB investigations, ND: Dragged wing,rotor,pod,float or tail/skid

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 CHI07CA226](https://openairdocs.org/ntsb/CHI07CA226.md): Hamilton Rotorway Exec 90 · Harvey, ND · Accident · No injuries · Data collection · Final report · Jul 22, 2007 · C-FWBN · Substantial damage
  > The pilot's failure to maintain clearance from the airport ramp area during the return for landing, which resulted in the landing skid dragging on the edge of the pavement and causing the helicopter to roll over.
- [NTSB CHI01LA201](https://openairdocs.org/ntsb/CHI01LA201.md): Piper J3-C65 · West Fargo, ND · Accident · No injuries · Limited investigation · Final report · Jun 11, 2001 · N3253N · Substantial damage
  > the pilot's inadequate preflight planning and the unsuitable landing area selected by the pilot. Additional factors were the uneven terrain and the failed float assembly in overload.
- [NTSB CHI95LA276](https://openairdocs.org/ntsb/CHI95LA276.md): Cessna A185E · Dickinson, ND · Accident · No injuries · Limited investigation · Final report · Aug 14, 1995 · N47428 · Substantial damage
  > the pilot's inadequate compensation for the wind conditions, and his improper recovery from the bounced landing. The high wind was a factor.
- [NTSB CHI91DTG05](https://openairdocs.org/ntsb/CHI91DTG05.md): Cessna T188C · Bathgate, ND · Accident · No injuries · Final report · Jul 19, 1991 · N2056J · Substantial damage
  > A loss of control inflight which resulted in a collision with the 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 c."eventStateOrRegion" = 'ND' AND c."eventCountry" = 'USA'
  AND c."completionStatus" = 'Completed'
  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" = 160)
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?occurrence=160&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.