# NTSB investigations: Cessna 172R, 2000

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 CHI00LA287](https://openairdocs.org/ntsb/CHI00LA287.md): Cessna 172R · New Lenox, IL · Accident · No injuries · Limited investigation · Final report · Aug 29, 2000 · N364SA · Substantial damage
  > The pilot's failure to maintain directional control during landing. Factors to the accident were the pipe that was struck, the crosswind, and the pilot's runway selection.
- [NTSB CHI00LA182](https://openairdocs.org/ntsb/CHI00LA182.md): Cessna 172R · Athens, MI · Accident · No injuries · Limited investigation · Final report · Jul 5, 2000 · N996WW · Substantial damage
  > the failure of the student pilot to maintain control of the aircraft, the inadequate supervision by the flight instructor, and the delayed remedial action performed by the flight instructor. A factor to the accident was the runway edge light that was struck…
- [NTSB NYC00LA155](https://openairdocs.org/ntsb/NYC00LA155.md): Cessna 172R · West Milford, NJ · Accident · Minor injuries · Limited investigation · Final report · Jun 9, 2000 · N7274D · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB CHI00LA115](https://openairdocs.org/ntsb/CHI00LA115.md): Cessna 172R · Battle Creek, MI · Accident · No injuries · Limited investigation · Final report · Apr 18, 2000 · N975BC · Substantial damage
  > the student pilot's failure to maintain directional control of the airplane during the landing. Factors associated with the accident were the misjudged landing flare, the student's lack of total experience, the runway lights, and the runway signs.
- [NTSB CHI00LA081](https://openairdocs.org/ntsb/CHI00LA081.md): Cessna 172R · Waterford, MI · Accident · No injuries · Limited investigation · Final report · Feb 21, 2000 · N922TA · Substantial damage
  > the directional control not obtained/maintained by the dual student and the remedial action not performed by the certified flight instructor. Contributing factors were the crosswind and the snow bank.
- [NTSB MIA00LA086](https://openairdocs.org/ntsb/MIA00LA086.md): Cessna 172R · Olive Branch, MS · Accident · No injuries · Limited investigation · Final report · Feb 7, 2000 · N2630B · Substantial damage
  > The student pilot's failure to maintain directional control during landing and the subsequent collision with a taxiway sign and collapsed right main landing gear.
- [NTSB FTW00LA060](https://openairdocs.org/ntsb/FTW00LA060.md): Cessna 172R · Angleton, TX · Accident · No injuries · Limited investigation · Final report · Jan 10, 2000 · N8292 · Substantial damage
  > The pilot's failure to maintain control of the airplane during landing. A factor was the gust of wind.
- [NTSB MIA00FA064](https://openairdocs.org/ntsb/MIA00FA064.md): Cessna 172R · Atlantic Ocean (Atlantic Ocean) · Accident · 1 fatal · Field investigation · Final report · Jan 6, 2000 · N156RA · Destroyed
  > The pilot's lack of total experience in instrument flight, simulated instrument flight, and night flight resulting in the pilot becoming spatially disoriented, and subsequent in-flight collision with water. Contributing to the accident was the dark night with…

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

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

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