NTSB investigations: Piper PA-28-140, PA
7 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
| 1982 | 1 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1989 | 1 |
| 2007 | 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\" = 'PA' 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" = 'PA' 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 NYC07LA168Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · E.Stroudsburg, PAThe pilot's improper fuel management resulting in loss of engine power.NTSB NYC07LA085Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Catherine Twp., PAThe pilot's improper use of carburetor heat. Contributing to the accident were the weather conditions conducive to the formation of carburetor ice.NTSB NYC90LA027Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Coatesville, PAImproper planning/decision by the pilot which resulted in fuel exhaustion due to an inadequate supply of fuel.NTSB NYC87LA255Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Emmaus, PADrg flt, the eng lost power over a residential area & the plt selected a small fenced-in opening for an emergency lndg. He said he crashed nosewheel 1st, then skidded into a cyclone fence. After the acdnt, the fuel selector was fnd positioned to the rgt tank…NTSB NYC86LA241Accident · No injuriesLimited investigationFinal reportPiper PA-28-140C · Indiana, PAThe acft was substantially damaged during a forced landing following a loss of eng power. Examination of the acft showed the fuel selector was on the the left tank which contained no useable fuel. There was useable fuel remaining in the right tank. The plt…NTSB NYC84FGM07Accident · Serious injuriesFinal reportPiper PA-28-140 · South Fork, PAUpon departure the plt estimated 25 gal of fuel. The total power loss occurred 1 hr and 55 min later. After the forced ldg on unimproved terrain no evidence of fuel remained in the fuel system. There was no indication of any full spill from the ruptured left…NTSB NYC82FGM14Accident · Serious injuriesFinal reportPiper PA-28-140 · Shanksville, PADuring preflight the plt estimated he had about 18 gals of fuel on board. Approximately 10 min after takeoff the eng quit due to fuel exhaustion. The acft collided with a power line pole during the forced landing. The arpt's FBO stated that fuel was not…