Skip to content

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

18 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

Where

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" = 'MD' 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\" = 'MD' 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" = 'MD' 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 ERA23FA313Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28R · Churchville, MDThe pilot’s exceedance of the airplane’s critical angle of attack during initial climb, which resulted in an aerodynamic stall/spin and loss of control that the pilot did not recover from.Jul 25, 2023 · N34PT · Substantial damage NTSB ERA19LA160Accident · No injuriesLimited investigationFinal reportPiper PA28R · Easton, MDThe loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.Mar 13, 2019 · N33305 · Substantial damage NTSB ERA11CA052Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Cambridge, MDThe commercial pilot’s inadequate flare during landing and the certificated flight instructor's delayed remedial action, which resulted in a hard landing.Oct 23, 2010 · N56101 · Substantial damage NTSB NYC03LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gaithersburg, MDThe pilot’s failure to maintain airspeed, resulting in an inadvertent stall.May 15, 2003 · N1514X · Substantial damage NTSB NYC00LA008Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Berlin, MDThe failure of the number 3-cylinder exhaust valve stem due to fatigue cracking.Oct 8, 1999 · N56094 · Substantial damage NTSB NYC95LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Westminister, MDthe failure of the flight instructor to take timely remedial action during an approach, resulting in an inadvertent stall, hard landing and subsequent collapse of the landing gear. A factor related to the accident was the flight instructor's lack of…Apr 15, 1995 · N41767 · Substantial damage NTSB NYC94LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oakland, MDthe pilot's inadequate preflight planning and preparation in which the pilot attempted a high density altitude takeoff, up-slope, with the airplane over the maximum allowable gross weight, utilizing a rolling takeoff technique with an improper flap setting.…Sep 20, 1994 · N2815T · Destroyed NTSB BFO94LA127Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Edgewater, MDThe pilot's inadequate preflight inspection which failed to detect water contaminated fuel which resulted in fuel starvation.Aug 6, 1994 · N5242T · Destroyed NTSB BFO94LA054Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Hagerstown, MDThe loss of partial engine power for undetermined reasons.Mar 17, 1994 · N4465T · Substantial damage NTSB BFO90FA064Accident · Serious injuriesField investigationFinal reportPiper PA-28-200 · Baltimore, MDThe pilot failed to maintain adequate airspeed which resulted in a stall. Contributing was the loss of power for undetermined reasons.Jul 19, 1990 · N32975 · Destroyed NTSB BFO88IA012Incident · No injuriesIncident investigationFinal reportMcdonnell Douglas DC-9-32 · Baltimore, MDTwa flt 388 (DC-9, N924L) was in clouds climbing to 7000' when Baltimore (bwi) TRACON adzd that an acft (Piper PA-28R) was straight ahead at 3 mi dscndg fm 6700'. Flt 388 had passed 6000' & the capt requested a traffic avoidance vector. The TRACON ctlr…Dec 5, 1987 · N924L · 2 aircraft · No damage NTSB BFO88LA005Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dares Beach, MDThe plt stated that after climbing about 2000' & proceeding aprx 3 to 4 mi out over the chesapeake bay, the oil temp began to rise & the oil pressure decreased. He turned toward land, but the eng lost power. Subsequently, he was forced to land in a swampy…Oct 10, 1987 · N55936 · Substantial damage NTSB BFO87FA004Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Mount Pleasant, MDThe acft was on the second apch attempt for ILS rwy 23 when the accident occurred- on the first attempt the pilot flew outbound instead of inbound on the localizer course. For the second attempt the pilot was cleared for a full apch for ILS rwy 23; which…Oct 26, 1986 · N4347X · Destroyed NTSB BFO86FA023Accident · Minor injuriesField investigationFinal reportPiper PA-28R-200 · Camp Springs, MDDuring a flt to prepare the student for a CFI check ride, both the student and the CFI could not obtain a green light confirming the nose gear was down and locked. After numerous attempts to assure it was down and locked the acft was landed at andrews afb.…Apr 14, 1986 · N32613 · Substantial damage NTSB ATL80FIG14Accident · No injuriesClosedPiper PA-28R · Chester, MDAug 7, 1980 · N3994F · Substantial damage NTSB IAD79FIA02Accident · Serious injuriesClosedPiper PA-28R · Morganza, MDOct 15, 1978 · N1235T · Substantial damage NTSB IAD78FA060Accident · Serious injuriesClosedPiper PA-28R · California, MDApr 19, 1978 · N4448X · Destroyed NTSB IAD74AI010Accident · No injuriesClosedPiper PA-28R · Churchville, MDAug 13, 1973 · N56086 · 2 aircraft · Substantial damage