# NTSB investigations: Cessna 140, 2007

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 DEN08CA026](https://openairdocs.org/ntsb/DEN08CA026.md): Cessna 140 · Poultney, VT · Accident · No injuries · Data collection · Final report · Nov 5, 2007 · N89120 · Substantial damage
  > The pilot's attempt to land on an unimproved airstrip resulting in a ground loop/swerve. Factors contributing to the accident were the pilot's poor judgement in attempting to land on an unsuitable runway and the unsuitable runway conditions.
- [NTSB DFW07CA195](https://openairdocs.org/ntsb/DFW07CA195.md): Cessna 140 · Lubbock, TX · Accident · No injuries · Data collection · Final report · Sep 8, 2007 · N72699 · Substantial damage
  > The pilot's failure to maintain directional control of the airplane while landing. A contributing factor was the flight instructor's delay in taking remedial action.
- [NTSB CHI07CA274](https://openairdocs.org/ntsb/CHI07CA274.md): Cessna 140 · Grant, NE · Accident · No injuries · Data collection · Final report · Aug 17, 2007 · N89492 · Substantial damage
  > The directional control not obtained/maintained by the pilot during landing. Contributing factors were the crosswind, gust, and ditch.
- [NTSB LAX07CA252](https://openairdocs.org/ntsb/LAX07CA252.md): Cessna 140 · Olympia, WA · Accident · No injuries · Data collection · Final report · Aug 15, 2007 · N4084N · Substantial damage
  > The pilot's failure to maintain directional control during landing.
- [NTSB CHI07CA122](https://openairdocs.org/ntsb/CHI07CA122.md): Cessna 140 · Winner, SD · Accident · No injuries · Data collection · Final report · Apr 27, 2007 · N72953 · Substantial damage
  > The pilot's excessive use of braking during the landing roll, causing the aircraft to nose over.
- [NTSB SEA07CA054](https://openairdocs.org/ntsb/SEA07CA054.md): Cessna 140 · Murrieta, CA · Accident · No injuries · Data collection · Final report · Jan 23, 2007 · N2006V · Substantial damage
  > The pilot's excessive application of brakes during taxi after landing, resulting in a nose over.
- [NTSB SEA07CA047](https://openairdocs.org/ntsb/SEA07CA047.md): Cessna 140 · San Jose, CA · Accident · No injuries · Data collection · Final report · Jan 14, 2007 · N18WB · Substantial damage
  > The pilot's excessive use of the airplane's wheel brakes, which resulted in a nose over during landing.

## 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") = 2007
  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&year=2007

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