# Ongoing NTSB investigations: Cessna 172N

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 WPR27LA009](https://openairdocs.org/ntsb/WPR27LA009.md): Cessna 172N · Knights Landing, CA · Accident · Serious injuries · Limited investigation · Investigation open · Oct 1, 2026 · N75513
- [NTSB WPR26FA330](https://openairdocs.org/ntsb/WPR26FA330.md): Cessna 172N · San Diego, CA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Sep 8, 2026 · N734ZK · Destroyed
  > On September 7, 2026, about 1720 Pacific daylight time, a Cessna 172N, N734ZK, was destroyed when it was involved in an accident near San Diego, California. The flight instructor and student pilot were fatally injured. The airplane was being operated as a…
- [NTSB ERA26LA342](https://openairdocs.org/ntsb/ERA26LA342.md): Cessna 172N · Panama City, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Sep 7, 2026 · N734NM · Substantial damage
  > On September 7, 2026, about 1059 central daylight time, a Cessna 172N airplane, N734NM, was substantially damaged when it was involved in an accident near Panama City, Florida. The student pilot and flight instructor were not injured. The airplane was…
- [NTSB CEN26FA192](https://openairdocs.org/ntsb/CEN26FA192.md): Cessna 172N · Westerly, RI · Accident · 1 fatal · Class 3 · Field · Preliminary report · May 18, 2026 · N733CP · Substantial damage
  > On May 18, 2026, about 1205 eastern daylight time, a Cessna 172N, N733CP, was substantially damaged when it was involved in an accident near Westerly, Rhode Island. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal…
- [NTSB ERA26LA134](https://openairdocs.org/ntsb/ERA26LA134.md): Cessna 172N · Newburgh, NY · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Mar 3, 2026 · N1560E · Substantial damage
  > On March 2, 2026, at 1910 eastern standard time, a Cessna 172N, N1560E, was substantially damaged when it was involved in an accident near Newberg, New York. The flight instructor and student pilot incurred minor injuries. The airplane was operated as a Title…
- [NTSB ERA26FA084](https://openairdocs.org/ntsb/ERA26FA084.md): Cessna 172 · Provincetown, MA · Accident · 1 fatal · Class 3 · Field · Preliminary report · Jan 4, 2026 · N9360E · Substantial damage
  > On January 4, 2026, at 1504 eastern standard time, a Cessna 172N, N9360E, was substantially damaged when it was involved in an accident near Provincetown, Massachusetts. The private pilot was fatally injured. The airplane was operated as a Title 14 Code of…
- [NTSB CEN26FA051](https://openairdocs.org/ntsb/CEN26FA051.md): Cessna 172N · New Orleans, LA · Accident · 2 fatal · Class 3 · Field · Preliminary report · Nov 25, 2025 · N80FP · Destroyed
  > On November 24, 2025, at 1824 central standard time, a Cessna 172N airplane, N80FP, was destroyed when it was involved in an accident near New Orleans, Louisiana. The flight instructor and pilot receiving instruction were fatally injured. The flight was…
- [NTSB ERA26LA046](https://openairdocs.org/ntsb/ERA26LA046.md): Cessna 172 · Palm Bay, FL · Accident · Minor injuries · Class 3 · Limited · Preliminary report · Nov 18, 2025 · N6124D · Substantial damage
  > On November 17, 2025, about 1900 eastern standard time, a Cessna 172N, N6124D, was substantially damaged when it was involved in an accident near Palm Bay, Florida. The private pilot sustained minor injuries. The airplane was operated as a Title 14 Code of…
- [NTSB ANC26LA001](https://openairdocs.org/ntsb/ANC26LA001.md): Cessna 172N · Petersburg, AK · Accident · No injuries · Class 3 · Limited · Preliminary report · Oct 7, 2025 · N80628 · Substantial damage
  > On October 7, 2025, at 1456 Alaska daylight time, a Cessna 172 airplane, N80628, was substantially damaged when it was involved in an accident near Petersburg, Alaska. The student pilot and flight instructor were not injured. The airplane was operated as a…
- [NTSB ERA25LA288](https://openairdocs.org/ntsb/ERA25LA288.md): Cessna 172N · Pembroke Pines, FL · Accident · No injuries · Class 3 · Limited · Preliminary report · Aug 5, 2025 · N1213F · Substantial damage
  > On August 05, 2025, about 0820 eastern daylight time, a Cessna 172N, N1213F, was substantially damaged when it was involved in an accident near Pembroke Pines, Florida. The flight instructor and student pilot were not injured. The airplane was operated as a…

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

This list as a web page: https://openairdocs.org/ntsb?model=2072434&status=ongoing

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