# NTSB investigations: Cessna 172S: Airframe/component/system failure/malfunction

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 SEA03LA201](https://openairdocs.org/ntsb/SEA03LA201.md): Cessna 172S · Anacortes, WA · Accident · No injuries · Limited investigation · Final report · Sep 18, 2003 · N3555L · Substantial damage
  > The pilot attempting to taxi the airplane with a known system deficiency. Factors include worn wheel brakes and a drainage ditch.
- [NTSB ATL03FA064](https://openairdocs.org/ntsb/ATL03FA064.md): Cessna 172S · Monroe, GA · Accident · 2 fatal · Field investigation · Final report · Mar 21, 2003 · N219ME · Destroyed
  > The pilot’s exceedence of the design limits of the airplane, which resulted in the overload failure of the horizontal stabilizers, followed by the overload separation of the right wing and subsequent loss of control.
- [NTSB ATL02LA013](https://openairdocs.org/ntsb/ATL02LA013.md): Cessna 172S · Sarasota, FL · Accident · No injuries · Limited investigation · Final report · Nov 11, 2001 · N24485 · Substantial damage
  > The operators failure to ensure adequate training had been provided to the student pilot in autopilot operations, and the student pilot's failure to comply/ follow written instructions (Federal Regulations/172 Skyhawk Information Manual) pertaining to the…
- [NTSB CHI01IA047](https://openairdocs.org/ntsb/CHI01IA047.md): Cessna 172S · St. Cloud, MN · Incident · No injuries · Incident investigation · Final report · Dec 12, 2000 · N582SP · Minor damage
  > the fatigue failure of the propeller blade during the initial takeoff climb. The failure was a result of a material defect, which occurred during the manufacturing process and the manufacturers failure to detect the defect.
- [NTSB CHI99LA092](https://openairdocs.org/ntsb/CHI99LA092.md): Cessna 172RG · Lawrenceville, IL · Accident · No injuries · Limited investigation · Final report · Feb 15, 1999 · N9506D · Substantial damage
  > the fatigue fracture of the landing gear actuator.

## 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072439', '2072442')
    AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 130))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072439&occurrence=130

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