# Final NTSB investigations: Cessna 140, ND

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 CEN13CA345](https://openairdocs.org/ntsb/CEN13CA345.md): Cessna 140 · Minot, ND · Accident · Minor injuries · Data collection · Final report · Jun 7, 2013 · N2054V · Substantial damage
  > The pilot's failure to maintain aircraft control during takeoff.
- [NTSB DEN87LA137](https://openairdocs.org/ntsb/DEN87LA137.md): Cessna 140 · Sawyer, ND · Accident · Minor injuries · Limited investigation · Final report · May 30, 1987 · N1677V · Substantial damage
  > The commercial plt and his wife were on a cross country flt and were landing for refueling. On final, the acft began an uncommanded left turn as landing flaps were selected. The plt was unable to correct the turn and struck trees short of the private…
- [NTSB MKC79DTG07](https://openairdocs.org/ntsb/MKC79DTG07.md): Cessna 140 · Bowman, ND · Accident · No injuries · Closed · May 26, 1979 · N1677V · Substantial damage
- [NTSB MKC73FTG11](https://openairdocs.org/ntsb/MKC73FTG11.md): Cessna 140 · Hillsboro, ND · Accident · Serious injuries · Closed · Apr 22, 1973 · N1971N · Destroyed
- [NTSB MKC69F0198](https://openairdocs.org/ntsb/MKC69F0198.md): Cessna 140 · Fargo, ND · Accident · No injuries · Closed · Aug 20, 1968 · N1648V · Substantial damage
- [NTSB MKC69F0127](https://openairdocs.org/ntsb/MKC69F0127.md): Cessna 140 · Foxholm, ND · Accident · No injuries · Closed · Jul 22, 1968 · N76579 · Substantial damage
- [NTSB MKC68D0116](https://openairdocs.org/ntsb/MKC68D0116.md): Cessna 140 · Rutland, ND · Accident · No injuries · Closed · Jul 10, 1967 · N81065 · Substantial damage
- [NTSB MKC68D0061](https://openairdocs.org/ntsb/MKC68D0061.md): Cessna 140 · Harvey, ND · Accident · No injuries · Closed · Apr 25, 1967 · N2063V · Substantial damage
- [NTSB MKC66F0255](https://openairdocs.org/ntsb/MKC66F0255.md): Cessna 140 · Michigan, ND · Accident · No injuries · Closed · Sep 19, 1965 · N89525 · Substantial damage
- [NTSB MKC66F0218](https://openairdocs.org/ntsb/MKC66F0218.md): Cessna 140 · Grand Forks, ND · Accident · No injuries · Closed · Aug 21, 1965 · N2302N · Substantial damage
- [NTSB UNK65X0295](https://openairdocs.org/ntsb/UNK65X0295.md): Cessna 140 · Edgely, ND · Accident · No injuries · Closed · Oct 16, 1964 · N72307 · Substantial damage

## 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 x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2071602', '2071603'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

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