# NTSB investigations: Cessna 172L, AZ

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 GAA19CA424](https://openairdocs.org/ntsb/GAA19CA424.md): Cessna 172 · Grand Canyon, AZ · Accident · No injuries · Data collection · Final report · Jul 16, 2019 · N1079M · Substantial damage
  > The pilot's failure to maintain lateral control during landing in gusting wind conditions, which resulted in the left wing striking the ground.
- [NTSB GAA18CA161](https://openairdocs.org/ntsb/GAA18CA161.md): Cessna 172 · Green Valley, AZ · Accident · No injuries · Data collection · Final report · Mar 12, 2018 · N418DD · Substantial damage
  > The pilot’s failure to maintain directional control of the airplane during landing with a tailwind.
- [NTSB WPR17FA213](https://openairdocs.org/ntsb/WPR17FA213.md): Cessna 172L · Perkinsville, AZ · Accident · 2 fatal · Field investigation · Final report · Sep 22, 2017 · N7070Q · Destroyed
  > The pilot's decision to fly into a canyon during wind conditions conducive to turbulence and downdrafts, and his subsequent loss of aircraft control while maneuvering in the canyon. Contributing to the accident was the pilot's limited canyon flying experience.
- [NTSB LAX08LA009](https://openairdocs.org/ntsb/LAX08LA009.md): Cessna 172L · Prescott, AZ · Accident · Minor injuries · Limited investigation · Final report · Oct 10, 2007 · N9897G · Substantial damage
  > The failure of maintenance personnel to detect fatigue cracks in the number 3 exhaust rocker arm, which lead to a partial loss of engine power.
- [NTSB LAX02LA104](https://openairdocs.org/ntsb/LAX02LA104.md): Cessna 172L · Bullhead City, AZ · Accident · No injuries · Limited investigation · Final report · Mar 7, 2002 · N7774G · Substantial damage
  > The pilot's failure to comply with maintenance/inspection requirements that resulted in a propeller failure.
- [NTSB LAX01LA286](https://openairdocs.org/ntsb/LAX01LA286.md): Cessna 172L · Tucson, AZ · Accident · 1 fatal · Limited investigation · Final report · Sep 16, 2001 · N4312Q · Destroyed
  > the pilot's controlled descent into a residence for undetermined reasons.
- [NTSB LAX81FUJ44](https://openairdocs.org/ntsb/LAX81FUJ44.md): Cessna 172 · Scottsdale, AZ · Accident · Minor injuries · Closed · Mar 19, 1981 · N2873Q · Substantial damage
- [NTSB LAX77DUJ81](https://openairdocs.org/ntsb/LAX77DUJ81.md): Cessna 172 · Flagstaff, AZ · Accident · No injuries · Closed · Jul 16, 1977 · N19794 · Substantial damage
- [NTSB LAX77DUJ54](https://openairdocs.org/ntsb/LAX77DUJ54.md): Cessna 172 · Chinle, AZ · Accident · No injuries · Closed · May 28, 1977 · N19770 · Substantial damage
- [NTSB LAX75AVJ57](https://openairdocs.org/ntsb/LAX75AVJ57.md): Cessna 172 · Ajo, AZ · Accident · No injuries · Closed · Feb 8, 1975 · N7266Q · Substantial damage
- [NTSB LAX73DUJ50](https://openairdocs.org/ntsb/LAX73DUJ50.md): Cessna 172 · Buckeye, AZ · Accident · No injuries · Closed · Feb 19, 1973 · N7983G · Substantial damage
- [NTSB LAX73FUJ34](https://openairdocs.org/ntsb/LAX73FUJ34.md): Cessna 172 · Scottsdale, AZ · Accident · Minor injuries · Closed · Nov 3, 1972 · N3824Q · Destroyed
- [NTSB LAX72DUK07](https://openairdocs.org/ntsb/LAX72DUK07.md): Cessna 172L · Bisbee, AZ · Accident · No injuries · Closed · May 23, 1972 · N7917G · Substantial damage
- [NTSB LAX72DUJ48](https://openairdocs.org/ntsb/LAX72DUJ48.md): Cessna 172 · Sprngrville, AZ · Accident · No injuries · Closed · Oct 1, 1971 · N2813Q · Substantial damage
- [NTSB LAX72FUJ34](https://openairdocs.org/ntsb/LAX72FUJ34.md): Cessna 172L · Phoenix, AZ · Accident · No injuries · Closed · Aug 29, 1971 · N7548G · Substantial damage
- [NTSB LAX72DUJ19](https://openairdocs.org/ntsb/LAX72DUJ19.md): Cessna 172 · Glendale, AZ · Accident · No injuries · Closed · Jul 1, 1971 · N7561G · 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" = 'AZ' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('2072432'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb?model=2072432&state=AZ

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