NTSB investigations: Piper PA-28-180, ID

14 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

19652026

NTSB investigations: Piper PA-28-180, ID per year, 1965–2026: 14 cases
1965	1
1966	1
1967	1
1968	1
1969	2
1972	1
1974	1
1988	1
1989	1
1990	1
1997	1
2002	1
2003	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" = 'ID' 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\" = 'ID' 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" = 'ID' 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 SEA03LA177Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Nampa, IDThe pilot's inadequate in-flight decision by failing to refuel while en route, resulting in fuel exhaustion and the loss of engine power. A factor was the unsuitable terrain for the forced landing.Aug 23, 2003 · N33170 · Substantial damage NTSB SEA02FA180Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Yellow Pine, IDThe pilot's failure to maintain clearance from trees. A factor was trees south of the departure end of the runway.Sep 25, 2002 · N7027W · Destroyed NTSB SEA98LA009Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Midvale, IDThe student pilot's failure to maintain adequate clearance with the pole. A factor contributing to the accident was the pole.Oct 27, 1997 · N9332J · Destroyed NTSB SEA91FA144Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mullan, IDThe pilot's VFR flight into instrument meteorological conditions (IMC). The adverse weather and terrain conditions were related factors.Oct 14, 1990 · N4924L · Destroyed NTSB SEA90LA006Accident · No injuriesLimited investigationFinal reportPiper PA28-180 · Homedale, IDInaccurate preflight planning and fuel consumption calculations by the pilot, and the pilot becoming lost or disoriented which resulted in fuel exhaustion.Oct 14, 1989 · N6651J · Substantial damage NTSB SEA89FA010Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Sun Valley, IDThe pilot flew into a box canyon at a low altitude above the ground near 9000 ft MSL. While attempting to climb over a ridgeline, the aircraft stalled, entered a spin, and descended nose down until impact with the ground.Oct 12, 1988 · N8975J · Destroyed NTSB SEA75FYA05Accident · Serious injuriesClosedPiper PA-28 · Arco, IDJul 25, 1974 · N8289W · Destroyed NTSB SEA72FYA26Accident · No injuriesClosedPiper PA-28 · Caldwell, IDMar 9, 1972 · N9340J · Substantial damage NTSB SEA70D0020Accident · No injuriesClosedPiper PA-28 · Stanley, IDJul 9, 1969 · N9340J · Substantial damage NTSB SEA69A0038Accident · Serious injuriesClosedPiper PA-28 · Bellevue, IDJan 1, 1969 · N5163L · Substantial damage NTSB SEA68D0250Accident · No injuriesClosedPiper PA-28 · Picabo, IDFeb 17, 1968 · N9188J · Substantial damage NTSB SEA67D0338Accident · No injuriesClosedPiper PA-28 · Salmon, IDJun 3, 1967 · N9640J · Substantial damage NTSB SEA67D0024Accident · Serious injuriesClosedPiper PA-28 · Big Springs, IDMay 14, 1966 · N8108W · Destroyed NTSB SEA66D0059Accident · No injuriesClosedPiper PA-28 · Soda Springs, IDJul 21, 1965 · N8108W · Substantial damage