# Final NTSB investigations: Cessna 172S: Unknown or undetermined

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 ERA24LA033](https://openairdocs.org/ntsb/ERA24LA033.md): Cessna 172S · Orlando, FL · Accident · Minor injuries · Class 3 · Limited · Final report · Nov 10, 2023 · N91PF · Substantial damage
  > A partial loss of engine power during initial climb after takeoff for undetermined reasons.
- [NTSB ERA22LA029](https://openairdocs.org/ntsb/ERA22LA029.md): Cessna 172 · Westhampton Beach, NY · Accident · No injuries · Class 3 · Limited · Final report · Oct 23, 2021 · N1188L · Substantial damage
  > A total loss of engine power during cruise flight for reasons that could not be determined based on the available evidence.
- [NTSB CEN21LA414](https://openairdocs.org/ntsb/CEN21LA414.md): Cessna 172S · LaSalle, CO · Accident · Minor injuries · Class 3 · Limited · Final report · Sep 10, 2021 · N2099J · Substantial damage
  > A loss of engine power for undetermined reasons.
- [NTSB CEN19FA221](https://openairdocs.org/ntsb/CEN19FA221.md): Cessna 172 · Katy, TX · Accident · 1 fatal · Class 3 · Field · Final report · Jul 13, 2019 · N517LA · Destroyed
  > The pilot’s loss of airplane control and subsequent impact with terrain for reasons that could not be determined based on the available information.
- [NTSB WPR19FAMS1](https://openairdocs.org/ntsb/WPR19FAMS1.md): Cessna 172 · Pescadero, CA · Accident · 1 fatal · Missing aircraft · Final report · Jun 27, 2019 · N3504A · Destroyed
  > Impact with the ocean for reasons that could not be determined because the airplane was not located.
- [NTSB GAA19CA282](https://openairdocs.org/ntsb/GAA19CA282.md): Cessna 172 · Edwards Air Force Base, CA · Accident · No injuries · Data collection · Final report · Apr 28, 2019 · N106ED · Substantial damage
  > An undetermined event, which resulted in substantial damage to the airplane for reasons that could not be determined based on the available evidence.
- [NTSB GAA15CA161](https://openairdocs.org/ntsb/GAA15CA161.md): Cessna 172S · Galesburg, IL · Accident · No injuries · Data collection · Final report · Jun 10, 2015 · N740SP · Substantial damage
  > Firewall damage reported by maintenance personnel that occurred during an unknown phase of flight, because the accident flight and pilot could not be determined.
- [NTSB GAA15CA018](https://openairdocs.org/ntsb/GAA15CA018.md): Cessna 172S · Camarillo, CA · Accident · No injuries · Data collection · Final report · Mar 23, 2015 · N2104H · Substantial damage
  > The pilot involved and the phase of flight when the damage occurred were not determined.
- [NTSB WPR13CA348](https://openairdocs.org/ntsb/WPR13CA348.md): Cessna 172S · Phoenix, AZ · Accident · No injuries · Data collection · Final report · Jul 26, 2013 · N635ND · Substantial damage
  > A substantially damaged firewall that occurred during an unknown phase of flight for reasons that could not be determined.
- [NTSB WPR13FA116](https://openairdocs.org/ntsb/WPR13FA116.md): Cessna 172S · Minden, NV · Accident · 1 fatal · Field investigation · Final report · Feb 7, 2013 · N328SP · Destroyed
  > The pilot’s failure to maintain airplane control while maneuvering over mountainous terrain.
- [NTSB CEN10CA325](https://openairdocs.org/ntsb/CEN10CA325.md): Cessna 172 · Traverse City, MI · Accident · No injuries · Data collection · Final report · Jun 15, 2010 · N52519 · Substantial damage
  > Damage to the firewall for undetermined reasons.

## 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."completionStatus" = 'Completed'
  AND 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '000' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC
```

This list as a web page: https://openairdocs.org/ntsb-events/000/sequence?model=2072439&status=final

---
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, except the copies of manufacturers’ service documents, which belong to their rights holders.
