Skip to content

Ongoing NTSB investigations: Piper PA-28-181

10 cases on aircraft the registry lists as Piper PA-28-181. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

20252026

Where

Latest cases

Query with 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 ('7102807', '7102832')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7102807', '7102832'))
  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 ('7102807', '7102832'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA27LA021Accident · Serious injuriesClass 3 · LimitedInvestigation openPiper PA-28-181 · Medford, NJOct 23, 2026 · N43956 NTSB CEN26LA329Accident · No injuriesClass 4 · LimitedInvestigation openPiper PA-28-181 · Mason, MISep 26, 2026 · N8086G · Substantial damage NTSB ERA26FA329Accident · 2 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Ludlow, MAOn September 5, 2026, about 2105 eastern daylight time, a Piper PA-28-181, N7653F, was destroyed when it was involved in an accident near Ludlow, Massachusetts. The pilot and passenger were fatally injured. The airplane was operated as a Title 14 Code of…Sep 6, 2026 · N7653F · Destroyed NTSB ERA26FA243Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Bowie, MDOn June 20, 2026, about 2328 eastern daylight time, a Piper PA-28-181, N249WF, was substantially damaged when it was involved in an accident near Bowie, Maryland. The pilot and two passengers were fatally injured. The airplane was operated as a Title 14 Code…Jun 21, 2026 · N249WF · Substantial damage NTSB ERA26LA180Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Indiantown, FLOn April 18, 2026, about 2115 eastern daylight time, a Piper PA-28-181, N643FT, was substantially damaged when it was involved in an accident near Indiantown, Florida. The private pilot was not injured. The airplane was operated as a Title 14 Code of Federal…Apr 19, 2026 · N643FT · Substantial damage NTSB ERA26LA156Accident · Serious injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Philadelphia, PAOn April 1, 2026, about 1541 eastern daylight time, a Piper PA-28-181, N494LA, was substantially damaged when it was involved in an accident near Philadelphia, Pennsylvania. The flight instructor received minor injuries, and the student pilot received serious…Apr 1, 2026 · N494LA · Substantial damage NTSB WPR26LA045Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Mesa, AZOn November 17, 2025, about 0830 mountain standard time, a Piper PA 28-181, N4402N, was substantially damaged when it was involved in an accident near Mesa, Arizona. The flight instructor and student pilot were not injured. The airplane was operated as a…Nov 17, 2025 · N4402N · Substantial damage NTSB ERA25LA350Accident · Minor injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · Astatula, FLOn September 17, 2025 at 1000 eastern daylight time, a Piper PA-28-181 100i, N580JA, was substantially damaged when it was involved in an accident near Astatula, Florida. The student pilot sustained minor injuries. The airplane was operated as a 14 Code of…Sep 17, 2025 · N580JA · Substantial damage NTSB WPR25LA261Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28-181 · San Diego, CAOn August 16, 2025, about 1737 Pacific daylight time, a Piper PA-28-181, N8150J, was substantially damaged when it was involved in an accident near San Diego, California. The pilot and passenger were not injured. The airplane was operated as a Title 14 Code…Aug 17, 2025 · N8150J · Substantial damage NTSB ERA25FA280Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-28-181 · Block Island, RIOn July 30, 2025, about 1210 eastern daylight time, a Piper PA-28-181, N961DA, was substantially damaged when it was involved in an accident near Block Island, Rhode Island. The pilot sustained serious injuries, one passenger received minor injuries, and one…Jul 30, 2025 · N961DA · Substantial damage