NTSB investigations: Piper PA-28R-180, WA

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

19682026

NTSB investigations: Piper PA-28R-180, WA per year, 1968–2026: 8 cases
1968	1
1969	1
1970	1
1972	1
1973	1
1978	1
1980	1
1993	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" = 'WA' 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 ('7102809')) 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\" = 'WA' 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 ('7102809'))
  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" = 'WA' 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 ('7102809'))
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 SEA93LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-180 · Ephrata, WAUndetermined loss of power and the lack of suitable terrain. A factor contributing to the accident was dark night conditions.Jun 22, 1993 · N7591J · Destroyed NTSB SEA81DYP02Accident · No injuriesClosedPiper PA-28R · Almira, WAOct 12, 1980 · N4527J · Substantial damage NTSB SEA78FYE25Accident · No injuriesClosedPiper PA-28R · Anderson Is, WAJun 2, 1978 · N322HC · Substantial damage NTSB SEA74FYG16Accident · No injuriesClosedPiper PA-28 · Colville, WAAug 31, 1973 · N4557J · Substantial damage NTSB SEA73DYE13Accident · No injuriesClosedPiper PA-28R · Roche Harbor, WASep 1, 1972 · N4959J · Substantial damage NTSB SEA71DWD20Accident · No injuriesClosedPiper PA-28R · Burlington, WAOct 27, 1970 · N4619J · Substantial damage NTSB SEA69F0240Accident · No injuriesClosedPiper PA-28 · Enumclaw, WAApr 21, 1969 · N4910J · Substantial damage NTSB SEA69D0146Accident · No injuriesClosedPiper PA-28 · Almira, WANov 24, 1968 · N7501J · Substantial damage