NTSB investigations: Piper PA-28-140, TX
10 cases on aircraft the registry lists as Piper PA-28-140, where the first occurrence was “Loss of engine power(total) - nonmechanical”. 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.
Cases per year
| 1985 | 1 |
|---|---|
| 1987 | 3 |
| 1992 | 1 |
| 1993 | 1 |
| 1996 | 2 |
| 2000 | 2 |
Where
Latest cases
Query with SQL
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 ('7102802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 353))
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 ('7102802')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 353))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 FTW00LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Ennis, TXThe loss of engine power due to fuel starvation, which resulted from the pilot's improper fuel selector positioning.NTSB FTW00LA198Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Leonard, TXThe inadvertent stall. A factor was the improperly positioned fuel selector.NTSB FTW96LA206Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Claude, TXthe pilot's improper planning/decision, which resulted in fuel exhaustion due to an inadequate supply of fuel. Soft terrain was a related factor concerning nose over in the emergency landing area.NTSB FTW96LA146Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Gladewater, TXfuel starvation due to the pilot inadvertently turning the fuel selector to the OFF position. A factor was the lack of suitable terrain for the forced landing.NTSB FTW93LA247Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Grand Prairie, TXThe fuel exhaustion induced power loss, the pilot's miscalculation of the amount of fuel required for the flight, and his failure to refuel. Factors were the dark night conditions and the lack of suitable terrain onto which a forced landing could be executed.NTSB FTW93LA056Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Slaton, TXThe total loss of engine power due to fuel starvation as a result of improper fuel tank selection. A factor the unsuitable terrain.NTSB FTW87LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Port Aransas, TXThe engine lost power while on the downwind leg of the traffic pattern. The pilot made a 180 degree turn and attempted to reach the runway. Touchdown occurred about 15 feet short and the landing gear impacted a sandy embankment. The aircraft then slid to a…NTSB FTW87FA087Accident · Serious injuriesField investigationFinal reportPiper PA-28-140 · Leakey, TXFlight instructor and student pilot flying Piper PA-28-140 departed uncontrolled airport after switching fuel tanks on runway. Fuel selector valve was inadvertently moved to off position by student pilot. Aircraft engine quit on initial climb at approximately…NTSB FTW87LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Waxahachie, TXThe aircraft received substantial damage during an emergency landing. According to the pilot, the engine failed because of carburetor icing. Atmospheric conditions at the time of the accident were conducive to carburetor icing. No mechanical failure or…NTSB FTW85LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Falfurrias, TXThe plt experienced in-flt directional gyro problems (exessive precessing) which resulted in large deviations on either side of his planning flt path. After realizing it was inaccurate he continued using it for some of his heading info. The acft continued to…