Fatal NTSB investigations: Piper PA-24-250
8 cases on aircraft the registry lists as Piper PA-24-250, where the sequence of events included Aerodynamic stall/spin. 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
| 2010 | 1 |
|---|---|
| 2011 | 1 |
| 2013 | 1 |
| 2015 | 1 |
| 2018 | 2 |
| 2021 | 1 |
| 2026 | 1 |
Where
Open the mapLatest 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.\"highestInjuryLevel\" = 'Fatal'
AND 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s.\"tier2Number\" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE \"isDefiningEvent\")))
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."highestInjuryLevel" = 'Fatal'
AND 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_events.parquet' s WHERE s.case_mkey = x.case_mkey AND s.aircrafts_position = x.position AND s."tier2Number" = '241' AND s.case_mkey IN (SELECT case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' WHERE "isDefiningEvent")))
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 ERA26FA252Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA24 · Hazen, NDOn June 28, 2026, about 1317 central daylight time, a Piper PA-24-250, N6852P, was destroyed when it was involved in an accident near Hazen, North Dakota. The pilot was fatally injured. The airplane was operated as a Title 14 Code of Federal Regulations Part…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 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 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 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…NTSB CEN14FA084Accident · 3 fatalField investigationFinal reportPiper PA 24-250 · Collbran, COThe pilot’s failure to maintain adequate airspeed while maneuvering at a low altitude, which resulted in an aerodynamic stall/spin and subsequent impact with terrain.NTSB WPR11FA248Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Astoria, ORThe student pilot’s failure to maintain adequate airspeed while maneuvering for landing, which resulted in a stall/spin. Contributing to the accident were the pilot's distraction and anxiety from a reported failure of the airplane's electrical system.NTSB WPR10FA239Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Redmond, ORThe pilot's failure to maintain airspeed, which resulted in a stall and collision with terrain.