Skip to content

NTSB investigations: Piper PA-28, TX

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

19642026

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 ('7102801')) 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 ('7102801'))
  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 ('7102801'))
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 CEN25LA065Accident · Serious injuriesClass 4 · LimitedFinal reportPiper PA-28 · New Braunfels, TXThe pilot’s improper in-flight fuel planning which resulted in a total loss of engine power due to fuel starvation and a subsequent off-field landing on rough terrain.Dec 28, 2024 · N5263W · Substantial damage NTSB CEN09CA166Accident · No injuriesData collectionFinal reportPiper PA-28 · Terrell, TXThe commercial pilot's failure to maintain adequate airspeed during the approach which resulted in an aerodynamic stall. Contributing to the accident was the pilot's lack of recent flight experience.Feb 7, 2009 · N5303W · Substantial damage NTSB FTW02FA040Accident · 1 fatalField investigationFinal reportPiper PA-28-160 · Ben Wheeler, TXThe pilot's failure to maintain aircraft control for undetermined reasons.Nov 22, 2001 · N6321W · Destroyed NTSB FTW99LA200Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Alvaredo, TXThe student pilot's failure to maintain a proper glidepath during his short-field approach.Jul 21, 1999 · N5230W · Substantial damage NTSB FTW99LA036Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-160 · Greenville, TXThe partial loss of engine power due to a blocked muffler exhaust pipe/manifold as a result of a loose internal baffle. Factors were the improper maintenance by other maintenance personnel and the lack of suitable terrain for the forced landing.Nov 25, 1998 · N5087W · Minor damage NTSB FTW97LA191Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Weatherford, TXloss of engine power for undetermined reason(s). Uneven terrain beyond the end of the runway was a related factor.May 14, 1997 · N5140W · Substantial damage NTSB FTW86LA013Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Houston, TXThe passengers stated that the pilot was unable to obtain higher power settings on a go-around from a low approach to an airport, and elected to land on a rural street. An examination of the engine revealed insect nests in the intake manifold and water in the…Oct 11, 1985 · N5341W · Substantial damage NTSB FTW82DA275Accident · Serious injuriesFinal reportCessna 402B · Austin, TXBoth acft were approaching from the ssw & flying assigned headings. Neither acft had been assigned an altitude. Just prior to impat, approach control (a/c) told the C-402B to fly 360 to follow traffic & asked what his altitude was. When the plt responded he…Jul 10, 1982 · N87280 · 2 aircraft · Substantial damage NTSB FTW81DRG60Accident · Minor injuriesClosedPiper PA-28 · Leander, TXAug 28, 1981 · N5197W · Substantial damage NTSB FTW80FRA23Accident · Serious injuriesClosedPiper PA-28 · Onalaska, TXMar 30, 1980 · N5294W · Substantial damage NTSB FTW68F0448Accident · No injuriesClosedPiper PA-28 · Lubbock, TXFeb 9, 1968 · N5395W · Substantial damage NTSB FTW68A0024Accident · 3 fatalClosedPiper PA-28 · Yoakum, TXSep 2, 1967 · N8493W · Destroyed NTSB FTW65A0097Accident · 4 fatalClosedPiper PA-28 · Laredo, TXMar 27, 1965 · N7583W · Destroyed NTSB UNK64X3819Accident · No injuriesClosedPiper PA28 · Houston, TXSep 6, 1964 · N5151W · Substantial damage NTSB UNK64X1537Accident · No injuriesClosedPiper PA28 · Post, TXApr 30, 1964 · N5368W · Substantial damage