Ongoing NTSB investigations: Cessna 172N
10 cases on aircraft the registry lists as Cessna 172N. Aircraft are matched to the registry by N-number and event date, checked against the reported serial number, make and model, so older matches can be wrong.
Cases per year
| 2025 | 4 |
|---|---|
| 2026 | 6 |
Where
Open the mapLatest cases
Query with SQL
duckdb -csv -c "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"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
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" DESCRun it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
NTSB WPR27LA009Accident · Serious injuriesLimited investigationInvestigation openCessna 172N · Knights Landing, CANTSB WPR26FA330Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · San Diego, CAOn 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 ERA26LA342Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Panama City, FLOn 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 CEN26FA192Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172N · Westerly, RIOn 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 ERA26LA134Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172N · Newburgh, NYOn 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 ERA26FA084Accident · 1 fatalClass 3 · FieldPreliminary reportCessna 172 · Provincetown, MAOn 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 CEN26FA051Accident · 2 fatalClass 3 · FieldPreliminary reportCessna 172N · New Orleans, LAOn 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 ERA26LA046Accident · Minor injuriesClass 3 · LimitedPreliminary reportCessna 172 · Palm Bay, FLOn 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 ANC26LA001Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Petersburg, AKOn 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 ERA25LA288Accident · No injuriesClass 3 · LimitedPreliminary reportCessna 172N · Pembroke Pines, FLOn 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…