NTSB investigations: Piper PA-28R-200, AR

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

19732026

NTSB investigations: Piper PA-28R-200, AR per year, 1973–2026: 8 cases
1973	1
1976	1
1977	1
1978	1
1980	2
1986	1
2015	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" = 'AR' 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 ('7102811')) 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\" = 'AR' 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 ('7102811'))
  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" = 'AR' 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 ('7102811'))
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 CEN15LA270Accident · No injuriesLimited investigationFinal reportPiper PA28-200 · Jonesboro, ARMaintenance personnel's improper engine oil drain valve installation, which led to engine oil exhaustion and the subsequent loss of engine power after takeoff at an altitude too low for the pilot to execute a forced landing in a suitable area.Jun 10, 2015 · N872CS · Substantial damage NTSB MKC86LA135Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mammoth Spring, ARThe pilot stated that the aircraft had plenty of oil prior to departure and that the flight was proceeding normally when, suddenly, the oil pressure dropped to zero. While subsequently heading for a nearby airport, the engine lost power and seized, forcing an…Jun 26, 1986 · N44767 · Substantial damage NTSB FTW81DPG08Accident · No injuriesClosedPiper PA-28R · Mountain Home, ARNov 28, 1980 · N43496 · Substantial damage NTSB FTW80DA119Accident · No injuriesClosedPiper PA-28R · Mountain View, ARSep 20, 1980 · N32820 · Substantial damage NTSB FTW78DPG55Accident · No injuriesClosedPiper PA-28R · Dermott, ARJul 2, 1978 · N8539C · Substantial damage NTSB FTW77DPG45Accident · No injuriesClosedPiper PA-28R · Manila, ARJun 10, 1977 · N5057S · Substantial damage NTSB FTW77DPG10Accident · No injuriesClosedPiper PA-28R · Dermott, ARNov 30, 1976 · N55830 · Substantial damage NTSB FTW73FPG39Accident · Serious injuriesClosedPiper PA-28R · Black Fork, ARMar 1, 1973 · N4974T · Destroyed