NTSB investigations: Piper PA-28-140
15 cases on aircraft the registry lists as Piper PA-28-140, where NTSB found Incorrect action performance. 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
| 2008 | 1 |
|---|---|
| 2009 | 1 |
| 2010 | 3 |
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 2 |
| 2014 | 2 |
| 2017 | 1 |
| 2018 | 1 |
| 2019 | 1 |
| 2020 | 1 |
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.\"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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f.\"findingCode\", '02041015')))
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."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_findings.parquet' f WHERE f.case_mkey = x.case_mkey AND f.aircrafts_position = x.position AND starts_with(f."findingCode", '02041015')))
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 ERA21LA081Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28 · Tampa, FLA total loss of engine power due to the student pilot inadvertently moving the fuel selector to the OFF position.NTSB CEN19LA265Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Fairhope, ALFailure of the No. 3 exhaust valve and the subsequent loss of engine power due to engine operation with an excessively lean fuel mixture over a period of time.NTSB ERA18FA084Accident · 1 fatalField investigationFinal reportPiper PA28 · Bonifay, FLA partial loss of engine power due to a stuck exhaust valve. Contributing to the accident was the pilot's decision to operate an airplane with a known mechanical deficiency and his failure to fly an appropriate traffic pattern that would have allowed the…NTSB CEN17FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-140 · Stonewall, TXThe pilot's failure to attain a proper touchdown point following a loss of engine power and his inability to stop the airplane on the short, soft runway. Contributing to the accident was the inadequate maintenance of the airplane by the owner and the mechanic…NTSB CEN14CA378Accident · Serious injuriesData collectionFinal reportPiper PA 28-140 · Fort Worth, TXThe pilot's improper recovery from a bounced landing. Contributing to the accident was the deer on the runway and the pilot's mismanagement of airspeed which resulted in an aerodynamic stall.NTSB ERA14LA285Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Newport, VTThe pilot's failure to maintain adequate airspeed during an aborted landing, which resulted in an aerodynamic stall and collision with the ground. Contributing to the accident was the pilot's alcohol impairment.NTSB ERA13CA260Accident · Minor injuriesData collectionFinal reportPiper PA-28-140 · Ellenville, NYThe student pilot's inadequate preflight planning and failure to maintain clearance from rising terrain, which resulted in controlled flight into terrain.NTSB ERA13CA228Accident · Serious injuriesData collectionFinal reportPiper PA-28-140 · Brogue, PAThe flight instructor's inadequate supervision of the student pilot during takeoff, which resulted in a collision with a power line.NTSB WPR12LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Chehalis, WAThe pilot did not correctly manage his glide profile during a simulated engine-out forced landing. Contributing to the accident was the pilot's decision not to add additional engine power, which resulted in a runway undershoot.NTSB ERA11FA348Accident · 3 fatalField investigationFinal reportPiper PA-28-140 · Guntersville, ALThe pilot's excessive pitch attitude, which resulted in an aerodynamic stall during the takeoff initial climb. Contributing to the accident was the pilot’s failure to comply with weight and balance limitations.NTSB CEN11LA093Accident · 1 fatalLimited investigationFinal reportPiper PA-28-140 · Ponca City, OKThe pilot's loss of control during landing for undetermined reasons.NTSB CEN11CA032Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Rose Hill, KSThe pilot's improper touchdown point during landing, which resulted in a runway overrun.NTSB CEN10LA575Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Basehor, KSThe pilot's improper touchdown point during landing and his delayed decision to execute a go-around. Contributing to the accident was the pilot's vision being obscured by the rain.NTSB WPR10CA035Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Angwin, CAThe pilot's failure to properly identify the runway surface for takeoff and his subsequent failure to abort the takeoff when he realized he was not on the runway. Contributing to the accident was the pilot’s failure to select the appropriate radio frequency…NTSB NYC08CA316Accident · No injuriesData collectionFinal reportPiper PA28-140 · Carrabassett, METhe pilot's improper landing flare.