NTSB investigations: Piper PA-24-250
9 cases on aircraft the registry lists as Piper PA-24-250, where NTSB found Angle of attack. 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
| 2015 | 1 |
|---|---|
| 2017 | 1 |
| 2018 | 4 |
| 2021 | 2 |
| 2026 | 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 ('7102404')
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\", '01062042')))
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 ('7102404')
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", '01062042')))
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 CEN26LA146Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Madison, INThe pilot’s failure to maintain proper airspeed during takeoff and exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall and impact with terrain.NTSB ERA21FA333Accident · 2 fatalClass 3 · FieldFinal reportPiper PA24 · Wadesboro, NCA partial loss of engine power during takeoff for reasons that could not be determined. Contributing was the pilot’s loss of airplane control, resulting in an aerodynamic stall and impact with trees and terrain.NTSB CEN21LA104Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA-24-250 · New Hudson, MIThe pilot’s failure to maintain proper airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s lack of an instrument rating and the low visibility at the time…NTSB WPR19FA042Accident · 1 fatalClass 2 · FieldFinal reportPiper PA-24-250 · Aberdeen, IDThe pilot's diverted attention during the takeoff climb due to a loss of engine power, which resulted in the airplane’s exceedance of the critical angle of attack and subsequent stall/spin.NTSB CEN19FA044Accident · 1 fatalField investigationFinal reportPiper PA24 · Valparaiso, INThe pilot's failure to maintain adequate airspeed during the initial climb after takeoff, which resulted in an exceedance of the airplane's critical angle of attack and a subsequent aerodynamic stall and spin.NTSB GAA18CA574Accident · No injuriesData collectionFinal reportPiper PA24 · Crewe, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper fuel management, which resulted in fuel starvation…NTSB ERA18FA200Accident · 2 fatalField investigationFinal reportPiper PA24 · Palatka, FLThe pilot's exceedance of the airplane's critical angle of attack during the initial climb after takeoff, which resulted in an aerodynamic stall and a loss of control.NTSB WPR18LA005Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA 24-250 · Hillsboro, ORThe student's pilot’s failure to maintain adequate airspeed during approach and subsequent exceedance of the critical angle of attack during a go-around, which resulted in an aerodynamic stall and a subsequent hard landing. Contributing to the accident was…NTSB CEN15FA287Accident · 2 fatalField investigationFinal reportPiper PA 24-250 · Quinlan, TXThe pilot's failure to maintain control of the airplane following a loss of engine power during initial climb after takeoff, which resulted in the wing's critical angle-of-attack being exceeded and a subsequent aerodynamic stall. Also causal was the pilot's…