Skip to content

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

19 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

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" = 'TX' 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\" = 'TX' 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" = 'TX' 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 CEN22LA206Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Beach City, TXThe pilot’s failure to maintain directional control in a gusting quartering tailwind that resulted in a loss of control and impact with trees.May 19, 2022 · N7451J · Substantial damage NTSB CEN21LA269Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28R-180 · Corpus Christi, TXThe pilot’s failure to maintain directional control during the takeoff roll.Jun 14, 2021 · N7476J · Substantial damage NTSB CEN12FA654Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Roanoke, TXThe loss of engine power during takeoff due to fuel contamination. Contributing to the accident was maintenance personnel's failure to adequately correct the water contamination effects. Contributing to the severity of the occupants' injuries was the lack of…Sep 22, 2012 · N4567J · Substantial damage NTSB CEN10CA359Accident · Minor injuriesData collectionFinal reportPiper PA28R · McGregor, TXA total loss of engine power for undetermined reasons. Contributing to the severity of injuries was the airplane's lack of shoulder harnesses.Jun 29, 2010 · N4627J · Substantial damage NTSB FTW95LA370Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Lago Vista, TXThe loss of engine power due to the failure of a connecting rod for undetermined reasons. A factor was the lack of suitable terrain for the forced landing.Sep 6, 1995 · N3726T · Substantial damage NTSB FTW86LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-R-180 · Houston, TXPrivate pilot of a Piper PA-28R-180 departed runway 15 at west Houston airport (iws), Houston, Texas. Pilot stated he had departed runway 15 when engine quit at approximately 600 feet AGL. Pilot executed a forced landing approximately 2 miles off the…Aug 9, 1986 · N3930T · Substantial damage NTSB FTW85LA359Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-R · Mount Vernon, TXThe pilot reported he ran out of gas maneuvering under an overcast to find a suitable landing site. He had attempted to circumnavigate a large area of severe weather but exhausted his fuel supply. He stated that the engine quit and he stalled the aircraft at…Sep 29, 1985 · N7554J · Substantial damage NTSB FTW79FPD40Accident · Minor injuriesClosedPiper PA-28R · Wichita Falls, TXSep 10, 1979 · N3902T · Substantial damage NTSB FTW77FQG57Accident · No injuriesClosedPiper PA-28R · Childress, TXSep 25, 1977 · N3724T · Substantial damage NTSB FTW76DQG55Accident · No injuriesClosedPiper PA-28R · Brownfield, TXFeb 18, 1976 · N3784T · Substantial damage NTSB FTW76DQG10Accident · No injuriesClosedPiper PA-28R · Lamesa, TXJul 20, 1975 · N3792T · Substantial damage NTSB FTW74DRG27Accident · No injuriesClosedPiper PA-28R · Weslaco, TXOct 21, 1973 · N4857J · Substantial damage NTSB FTW73DRG55Accident · No injuriesClosedPiper PA-28R · Cotulla, TXMar 4, 1973 · N3945T · Substantial damage NTSB FTW71AF053Accident · 2 fatalClosedPiper PA-28R · Andrews, TXFeb 24, 1971 · N3999T · Destroyed NTSB FTW71DRG63Accident · Minor injuriesClosedPiper PA-28R · Mcallen, TXDec 20, 1970 · N3845T · Substantial damage NTSB FTW69D0529Accident · No injuriesClosedPiper PA-28 · El Paso, TXMay 30, 1969 · N4670J · Substantial damage NTSB FTW69D0528Accident · No injuriesClosedPiper PA-28 · Greenville, TXMay 11, 1969 · N7510J · Substantial damage NTSB FTW69F0364Accident · Minor injuriesClosedPiper PA-28R · El Paso, TXDec 31, 1968 · N7487J · Substantial damage NTSB FTW69D0200Accident · No injuriesClosedPiper PA-28 · Odessa, TXAug 31, 1968 · N4972J · Substantial damage