Skip to content

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

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

19712026

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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 ERA20FA021Accident · 2 fatalClass 3 · FieldFinal reportPiper PA28R · Atlanta, GAThe pilot's loss of control due to spatial disorientation while flying in instrument meteorological conditions. Contributing to the accident was the failure of the vacuum pump and its associated instruments.Oct 30, 2019 · N56258 · Destroyed NTSB ERA18FA137Accident · 1 fatalField investigationFinal reportPiper PA28R · Gainesville, GAA partial loss of engine power due to inadequate thru-bolt and stud preload tension by undetermined maintenance personnel, which resulted in fretting between the engine crankcase halves, and the subsequent separation of the No. 2 cylinder due to the fatigue…Apr 28, 2018 · N4363F · Substantial damage NTSB ERA16LA007Accident · Serious injuriesLimited investigationFinal reportPiper PA28R · Savannah, GAThe pilot's inadequate preflight fuel planning and in-flight fuel management, which resulted in fuel exhaustion and a total loss of engine power during approach. Contributing to the accident were the pilot’s failure to maintain adequate airspeed and his…Oct 10, 2015 · N9312N · Substantial damage NTSB NYC08FA053Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Augusta, GAA loss of engine power due to the fatigue fracture of the number 2 cylinder attach studs, and the subsequent separation of the number 2 cylinder.Dec 5, 2007 · N43274 · Substantial damage NTSB ATL92FA153Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Waynesboro, GAThe pilot misjudged his distance and altitude during final approach as a result of his alcoholic impairment of efficiency and judgement. A factor which contributed to the accident was the dark night.Aug 7, 1992 · N3058R · Substantial damage NTSB ATL91LA029Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Senoia, GAImproper preflight planning and preparation by the pilot which resulted in fuel exhaustion. Factors to the accident were the dark night operation and the collision with utility lines.Dec 9, 1990 · N5003T · Substantial damage NTSB ATL88LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gray, GAInstructor said that after completing a stall series the engine began to backfire continously & power was lost so that he could not maintain altitude. An off airport landing was made and a fence was hit during the landing roll. Eng had been overhauled &…Sep 15, 1988 · N32105 · Substantial damage NTSB ATL88LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Homer, GAThe pilot reported a gradual decrease in power after reaching 4000 feet. The plt was unable to obtain a restart. He then elected to attempt a forced landing in a field. The aircraft collided with a tree prior to landing. The aircraft collided with and came to…Oct 17, 1987 · N1547X · Substantial damage NTSB ATL87FA230Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Offerman, GADuring a local flt the acft was observed flying at a level attitude approx 10 ft above a corn field at high speed. The right wing of the acft struck tree branches approx 60 ft AGL during a pull up. A 6 ft section of the right wing separated. The acft climbed,…Aug 14, 1987 · N55649 · Destroyed NTSB ATL87LA089Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Darien, GADuring normal cruise flight at 6,000' the plt reported hearing a loud bang simultaneous with a total loss of power. The plt declared mayday and made a forced landing in small pine trees. Examination of the engine revealed cyl.#2 connecting rod had become…Mar 21, 1987 · N2948R · Substantial damage NTSB ATL83LA357Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · St. Simons Isl., GADuring arrival, the plt began an apch to rwy 04 on a dark night. The apch to the rwy was over a bay inlet & river confluence. The plt thought that the acft was high when it was on final approach. However it collided with trees, impacted on a road short of the…Sep 4, 1983 · N4992S · Substantial damage NTSB ATL83LA311Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Cornelia, GAThe left main gear reportedly jumped a partially obscured curb during a turn around at the end of the rwy after landing. The curb had been installed for erosion control for water runoff. The left wing and landing gear of the acft were damaged.Jul 24, 1983 · N5088S · Substantial damage NTSB MIA78FLA36Accident · Minor injuriesClosedPiper PA-28R · St.Simons, GAMay 29, 1978 · N5041S · Substantial damage NTSB MIA75FKG76Accident · No injuriesClosedPiper PA-28 · Atlanta, GAJun 5, 1975 · N9411N · Substantial damage NTSB MIA74FKG58Accident · Minor injuriesClosedPiper PA-28R · Toccoa, GAMar 13, 1974 · N5225T · Substantial damage NTSB MIA72AM105Accident · 2 fatalClosedPiper PA-28R · Lafayette, GAMar 31, 1972 · N3091R · Destroyed NTSB MIA72FKG78Accident · Serious injuriesClosedPiper PA-28R · Chamblee, GAMar 6, 1972 · N4384T · Destroyed NTSB MIA71DKG71Accident · No injuriesClosedPiper PA-28 · Fitzgerald, GAMar 30, 1971 · N5041S · Substantial damage