# NTSB investigations: Cessna 172G, 2003

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 CHI03LA303](https://openairdocs.org/ntsb/CHI03LA303.md): Cessna 172G · Greenville, MI · Accident · No injuries · Limited investigation · Final report · Sep 7, 2003 · N3811L · Substantial damage
  > The pilot's inadequate takeoff procedure with the use of 20 degrees of flaps. Contributing factors were the interrelated effects of high aircraft weight, the density altitude, and the relative humidity. An additional factor was the trees.
- [NTSB CHI03LA266](https://openairdocs.org/ntsb/CHI03LA266.md): Cessna 172G · Bowdon, ND · Accident · No injuries · Limited investigation · Final report · Aug 16, 2003 · N6057R · Substantial damage
  > The pilot's failure to maintain adequate airspeed which led to a stall. Contributing to the accident was the pilot's lack of experience, the crosswind condition, wind gusts and power lines.
- [NTSB NYC03LA112](https://openairdocs.org/ntsb/NYC03LA112.md): Cessna 172G · Ocean City, NJ · Accident · Serious injuries · Limited investigation · Final report · May 20, 2003 · N3985L · Substantial damage
  > The pilot's failure to maintain directional control during an aborted landing. A factor was a crosswind.
- [NTSB SEA03LA049](https://openairdocs.org/ntsb/SEA03LA049.md): Cessna 172G · Packwood, WA · Accident · No injuries · Limited investigation · Final report · Mar 24, 2003 · N4150L · Substantial damage
  > Loss of partial engine power for undetermined reasons during the initial climb after takeoff. Loose gravel/sandy was a factor during the landing roll.

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

This list as a web page: https://openairdocs.org/ntsb?model=2072420&year=2003

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