NTSB investigations: Piper PA-23-250
13 cases on aircraft the registry lists as Piper PA-23-250, where the sequence of events included Loss of control in flight. 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 |
|---|---|
| 2011 | 1 |
| 2012 | 1 |
| 2013 | 1 |
| 2017 | 3 |
| 2018 | 2 |
| 2019 | 2 |
| 2020 | 1 |
| 2021 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308')
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\" = '240' 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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308')
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" = '240' 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 ERA21LA173Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-23-250 · Springfield, TNThe flight instructor’s failure to abort the takeoff following a loss of left engine power due to fuel starvation. Also causal was the inadequate maintenance of the left fuel cap by unknown maintenance personnel, which resulted in a blockage of the fuel…NTSB ERA20LA202Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA23 · San Juan, PRThe pilot’s intentional operation of the airplane with known deficiencies of the left engine and subsequent in-flight loss of control after takeoff. Contributing to the loss of engine power was internal contamination of the left servo fuel injector.…NTSB WPR19FA093Accident · 5 fatalClass 2 · FieldFinal reportPiper PA23 · Pahokee, FLThe pilot's failure to maintain control of the airplane while maneuvering for landing with one engine inoperative following a loss of engine power for reasons that could not be determined based on the available information.NTSB WPR19LA066Accident · 1 fatalClass 2 · LimitedFinal reportPiper PA23 · Ellensburg, WAThe instrument rated pilot’s loss of control due to spatial disorientation.NTSB ERA19WA040Accident · 1 fatalForeign investigationPiper PA23 · Nassau, BahamasThe government of Bahamas has notified the NTSB of an accident involving a Piper PA23 airplane that occurred on November 08, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the provisions…NTSB ERA18WA063Accident · 6 fatalForeign investigationPiper PA-23-250 · Nicholls Town, BahamasThe government of Bahamas has notified the NTSB of an accident involving a PIPER PA 23-250 airplane that occurred on January 17, 2018. The NTSB has appointed a U.S. Accredited Representative to assist the government of Bahamas's investigation under the…NTSB ANC18LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA 23-250 · Knoxville, TNThe flight instructor’s failure to comply with published engine-out procedures and recommended airspeeds, which resulted in a lack of directional control, collision with trees, and impact with the ground; the left engine lost total power due to fuel…NTSB ERA17FA222Accident · 4 fatalField investigationFinal reportPiper PA23 · Chatsworth, GAThe noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…NTSB ERA17FA195Accident · 1 fatalField investigationFinal reportPiper PA23 · San Juan, PRThe pilot's failure to maintain adequate airspeed, properly correct for left yaw, and his exceedance of the airplane's critical angle of attack during initial climb, which resulted in an aerodynamic stall and subsequent uncontrolled descent into water.NTSB CEN14FA034Accident · 3 fatalField investigationFinal reportPiper PA 23-250 · Caledonia, MNThe pilot's loss of control for reasons that could not be determined because the postaccident airplane examination did not reveal any anomalies that would have precluded normal operation.NTSB CEN12FA628Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bullard, TXThe pilot's maneuver, which exceeded the airplane's structural limit and resulted in an in-flight breakup.NTSB WPR11LA460Accident · Serious injuriesLimited investigationFinal reportPiper PA23 · Truckee, CAThe pilot's failure to maintain an airspeed at or above the airplane's minimum controllable airspeed, which resulted in a loss of airplane control. Contributing to the accident was the partial loss of power from the left engine as a result of a clogged fuel…NTSB DEN08FA058Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Sterling, KSThe loss of pitch control during cruise flight resulting from the separation of the stabilator trim actuator due to inadequate maintenenace.