Skip to content

NTSB investigations: Piper PA-28-151, TX

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

19742026

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 ('7102805', '7104223')) 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 ('7102805', '7104223'))
  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 ('7102805', '7104223'))
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 CEN21LA306Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-151 · Pottsboro, TXThe airplane’s degraded performance from the rough, grass runway surface and the pilot’s delayed decision to abort the takeoff resulting in a runway excursion.Jul 3, 2021 · N181BW · Substantial damage NTSB DFW06CA160Accident · Serious injuriesData collectionFinal reportPiper PA-28-151 · Brownwood, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Jun 10, 2006 · N5963F · Substantial damage NTSB FTW04LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Goldwaite, TXThe loss of engine power for undetermined reasons. A contributing factor was the lack of suitable terrain for the forced landing.Mar 17, 2004 · N43656 · Substantial damage NTSB FTW03LA232Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Beaumont, TXThe loss of engine power for undetermined reasons.Sep 26, 2003 · N43376 · Substantial damage NTSB FTW02LA251Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Masterson, TXThe loss of engine power due to fuel starvation as a result of a blockage of the carburetor. A contributing factor was the lack of suitable terrain for the emergency landing.Aug 8, 2002 · N43473 · Substantial damage NTSB FTW99LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-151 · Springtown, TXThe pilot's failure to maintain clearance with the trees during the initial takeoff climb. A factor was the high density altitude.Jul 14, 1999 · N44677 · Substantial damage NTSB FTW97LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Brownsville, TXthe pilot's failure to refuel the airplane which led to fuel exhaustion and subsequent loss of engine power. Factors were the pilot's lack of preflight planning and the lack of suitable terrain for the forced landing.Jan 27, 1997 · N8478F · Substantial damage NTSB FTW96LA266Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Abilene, TXfuel mismanagement by the pilot, which resulted in fuel starvation; and the pilot's failure to reposition the fuel selector (follow emergency procedure) while attempting to restart the engine. A factor relating to aircraft damage was: concrete debris (rocks)…Jun 21, 1996 · N40954 · Substantial damage NTSB FTW94LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Mckinney, TXThe pilot's improper approach angle.Jan 1, 1994 · N44015 · Substantial damage NTSB FTW80DPD26Accident · No injuriesClosedPiper PA-28 · Frisco, TXApr 28, 1980 · N9371K · Substantial damage NTSB FTW79FRG22Accident · No injuriesClosedPiper PA-28 · Kerrville, TXMar 7, 1979 · N75058 · Substantial damage NTSB FTW79DA055Accident · Minor injuriesClosedPiper PA-28 · Zapata, TXFeb 24, 1979 · N54388 · Destroyed NTSB FTW78FQG26Accident · No injuriesClosedPiper PA-28 · Ropesville, TXApr 14, 1978 · N41622 · Substantial damage NTSB FTW78FRA09Accident · Serious injuriesClosedPiper PA-28 · Baytown, TXDec 3, 1977 · N41261 · 2 aircraft · Destroyed NTSB FTW77FA065Accident · 1 fatalClosedPiper PA-28 · Wichita Falls, TXAug 2, 1977 · N5912F · Destroyed NTSB FTW77FRA29Accident · No injuriesClosedPiper PA-28 · Baytown, TXJul 5, 1977 · N44761 · Substantial damage NTSB FTW77FRA16Accident · No injuriesClosedPiper PA-28 · Tomball, TXMar 20, 1977 · N75270 · Substantial damage NTSB FTW76DRJ35Accident · No injuriesClosedPiper PA-28 · Mims, TXAug 1, 1976 · N8218C · Substantial damage NTSB FTW76AF089Accident · 2 fatalClosedPiper PA-28 · Lenorah, TXApr 26, 1976 · N43405 · Destroyed NTSB FTW75AF001Accident · 4 fatalClosedPiper PA-28 · Beaumont, TXJul 1, 1974 · N40706 · Destroyed