NTSB investigations: Piper PA-28-180, MT

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

19662026

NTSB investigations: Piper PA-28-180, MT per year, 1966–2026: 7 cases
1966	1
1967	1
1972	1
1976	1
1977	1
2015	1
2025	1

Where

Open the map

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."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102808')) 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.\"eventStateOrRegion\" = 'MT' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102808'))
  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."eventStateOrRegion" = 'MT' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102808'))
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 WPR25FA214Accident · 3 fatalClass 3 · FieldPreliminary reportPiper PA-28-180 · West Yellowstone, MTOn July 17, 2025, about 2358 mountain daylight time, a Piper PA-28-180, N7186W, was substantially damaged when it was involved in an accident near West Yellowstone, Montana. The pilot and two pilot rated passengers were fatally injured. The airplane was…Jul 18, 2025 · N7186W · Substantial damage NTSB GAA15CA050Accident · No injuriesData collectionFinal reportPiper PA 28-180 · Deer Lodge, MTThe pilot's inadequate recovery from a bounced landing, resulting in a loss of control and collision with terrain.Apr 17, 2015 · N7374W · Substantial damage NTSB SEA77FTA30Accident · No injuriesClosedPiper PA-28 · Miles City, MTAug 26, 1977 · N5358L · Substantial damage NTSB SEA76DTI37Accident · Minor injuriesClosedPiper PA-28 · Turner, MTAug 16, 1976 · N9051J · Substantial damage NTSB SEA73FTI03Accident · No injuriesClosedPiper PA-28 · Twin Bridges, MTJul 16, 1972 · N7805W · Substantial damage NTSB SEA68D0121Accident · Minor injuriesClosedPiper PA-28 · Swan Lake, MTJul 29, 1967 · N9456J · Destroyed NTSB SEA67D0035Accident · No injuriesClosedPiper PA-28 · Butte, MTJul 15, 1966 · N7392W · Substantial damage