NTSB investigations: Piper PA-23-250
24 cases on aircraft the registry lists as Piper PA-23-250, where the first occurrence was “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
| 1983 | 3 |
|---|---|
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1991 | 1 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1996 | 2 |
| 1997 | 2 |
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 1 |
| 2006 | 2 |
| 2007 | 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 NYC07FA100Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Windham, CTThe pilot's failure to maintain control of the airplane during a go-around.NTSB CHI06FA232Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Sault Ste Marie, MIThe pilot's failure to maintain aircraft control during the circling approach and his failure to perform a missed approach when the airplane was no longer in a position to land using normal flight maneuvers. Contributing to the accident was the pilot's…NTSB MIA06LA106Accident · 2 fatalLimited investigationFinal reportPiper PA-23-250 · Caribbean SeaThe failure of the pilot to maintain control of the airplane. A contributing factor in the accident was the spatial disorientation of the pilot, resulting in the in-flight loss of control.NTSB MIA05LA013Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · San Juan, PRThe pilot-in-command's failure to maintain airspeed while on base to final leg, which resulted in an inadvertent stall/mush and subsequent impact with the runway.NTSB ATL04FA016Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Cordesville, SCThe pilot's failure to maintain adequate airspeed, which resulted in an inadvertent stall and subsequent uncontrolled descent into trees and the ground. A factor was physical impairment.NTSB NYC03LA097Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Buffalo, NYThe pilot's failure to maintain sufficient airspeed to prevent an inadvertent stall. Factors were the variable and gusty winds.NTSB MIA02FA079Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Palm Bay, FLThe in-flight loss of control for undetermined reasons resulting in the in-flight collision with terrain.NTSB LAX98FA048Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Carson City, NVThe failure of the pilot to maintain airspeed after being distracted by the nose baggage door opening in-flight resulting in a stall/spin. Factors contributing to the accident were the pilot's inadequate preflight inspection and lack of experience in the type…NTSB NYC97FA172Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Baptistown, NJfailure of the pilot to maintain control of the airplane for undetermined reason(s), while operating it at low altitude.NTSB LAX97FA070Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Lucerne Valley, CAthe pilot's failure to maintain an adequate airspeed after encountering turbulence, low level wind shear, and an open door.NTSB NYC96FA073Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Bridgeport, WVThe pilot's inablility to maintain aircraft control due to a full nose down trim condition, which resulted in a loss of control and collision with terrain.NTSB ATL96FA010Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Isbela Segunda, PRthe pilot's failure to maintain control of the aircraft resulting in a stall. A factor was the mechanic's failure to properly maintain the forward baggage door locking mechanism.NTSB CHI94FA329Accident · 3 fatalField investigationFinal reportPiper PA-23-250 · Beaver Island, MIThe pilot's failure to maintain control of the airplane. The pilot's buzzing and his impairment of judgment and performance due to alcohol were factors in the accident.NTSB SEA94FA168Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Arco, IDThe pilot's diversion of his attention of controlling the airplane which led to his failure to maintain adequate airspeed. A factor which contributed to the accident was the pilot's failure to assure that the cabin door was closed and locked.NTSB CHI94FA128Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Alliance, NEThe pilot's spatial disorientation and inadvertant entry into a spiral dive. Factors were the pilot's lack of total instrument experience and the weather conditions of blowing snow and turbulence.NTSB FTW93FA132Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Henryetta, OKThe pilot's decision to fly into known adverse weather conditions and the ensuing spatial disorientation. Factors were the weather, and the pilot's decision to fly into IMC with inadequate flight and navigational equipment installed in the aircraft.NTSB ATL91LA048Accident · 1 fatalLimited investigationFinal reportPiper PA-23-250 · Lumberton, NCThe pilot suffered a stroke and lost control of the airplane on final approach.NTSB NYC87LA123Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Nantucket, MAThe Piper PA-23-250 attempted a go-around after crossing the threshold and observing the runway lights were not on during a night instrument approach. The pilot reported that he added full power and retracted the wing flaps. The procedure in the Piper manual…NTSB ATL86LA224Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Wadsworth, OHDuring the landing roll on rwy 02, the pilot lost directional control and the acft veered off the right side of the runway. The reported winds were 290 degrees at 8 knots. The wreckage examination failed to disclose any malfunction or failure. The acft brake…NTSB MKC85FA059Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Hot Springs, ARPilot had been cleared for an ILS approach to Hot Springs, Arkansas. After he crossed the initial approach fix, he said he was going to climb back above the clouds for just a second. He climbed 500 feet in the next 12 seconds, then started a fast descent. The…NTSB MIA84LA182Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Ft. Lauderdale, FLPlt witnesses reported that the acft stalled during the final approach. The plt was not multi-end rated.NTSB MIA83FA158Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Fort Lauderdale, FLDuring flt, the acft was observed flying from west to east across the beach & out over the ocean. Witnesses reported that over the ocean, the sky was dark & thunderstorms were approaching with heavy lightning. As the acft crossed the beach, a distinct eng…NTSB MIA83FA149Accident · 5 fatalField investigationFinal reportPiper PA-23C-250 · Ft. Lauderdale, FLThe acft crashed shortly after takeoff. According to witnesses, the acft veered to the left losing altitude and suddenlyflipped to the left crashing about 1/2 mile from the arpt in a steep left bank. The landing gear was reported in a down position. An…NTSB MIA83FA072Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · San Juan, PRShortly after takeoff the plt requested clearance to return to the arpt & land. According to witnesses the acft was having difficulty maintaining altitude & was flying with the nose 'up and down.' The tower controller stated that the acft didn't seem to get…