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

9 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

19752026

NTSB investigations: Piper PA-28R-200, IA per year, 1975–2026: 9 cases
1975	2
1978	1
1980	2
1981	1
1982	1
1983	1
1998	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" = 'IA' 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\" = 'IA' 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" = 'IA' 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 CHI98FA309Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · New Hampton, IAThe pilot's inadequate preflight/planning inspection and his continued flight into known adverse weather conditions that led to spatial disorientation and loss of aircraft control. Also causal was the pilot exceeded the design limits of the airplane causing…Aug 10, 1998 · N9350N · Destroyed NTSB MKC84LA009Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Carlisle, IAThe pilot said the fuel gauges read full on the ground but as he leveled off in cruise they dropped to a reading of much less than full. The acft ran out of fuel short of destination. The pilot blamed the flu and fatigue for his oversight.Oct 16, 1983 · N2825T · Substantial damage NTSB MKC82FA161Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Mediapolis, IADuring the 1725 CDT wx briefing the plt was informed that the Kansas city area would be 1600 ft broken, occassional 800 ft broken, 3/4 mi visibility with thunderstorms & moderate rain with strong surface winds about 35K. The forecast was valid to 2200 CDT.…Aug 30, 1982 · N56373 · Destroyed NTSB MKC81FA044Accident · 5 fatalClosedPiper PA-28R · Colo, IAJul 25, 1981 · N16328 · Destroyed NTSB MKC80DCD27Accident · No injuriesClosedPiper PA-28R · Humboldt, IAJul 30, 1980 · N2CL · Substantial damage NTSB MKC80FCD11Accident · No injuriesClosedPiper PA-28R · Ankeny, IAJan 27, 1980 · N57305 · Substantial damage NTSB MKC78FCD31Accident · No injuriesClosedPiper PA-28R · Iowa City, IAMay 30, 1978 · N2895T · Substantial damage NTSB MKC76FCD02Accident · No injuriesClosedPiper PA-28R · Council Bluffs, IAJul 17, 1975 · N4970S · Substantial damage NTSB MKC75PCD31Accident · No injuriesClosedPiper PA-28R · Burlington, IAJan 3, 1975 · N2989R · Substantial damage