NTSB investigations: Piper PA-23-160
7 cases on aircraft the registry lists as Piper PA-23-160, 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
| 1985 | 1 |
|---|---|
| 1987 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 2000 | 1 |
| 2004 | 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 ('7102304')
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 ('7102304')
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 SEA04FA133Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Ontario, ORThe pilot's failure to maintain airspeed resulting in an aerodynamic stall while maneuvering for an approach to land.NTSB MIA00FA163Accident · 1 fatalField investigationFinal reportPiper PA-23-160 · Titusville, FLThe failure of the PIC to maintain control of the aircraft while in the simulated engine inoperative configuration in the landing pattern during a checkout flight resulting in an uncontrolled descent and collision with trees. A factor in the accident is the…NTSB IAD97LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Hampton, NHThe pilot's poor judgement for intentionally shutting down an engine to perform a practice single engine landing, which led to a single engine go-around due to conflicting traffic.NTSB FTW95FA226Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Palestine, TXLoss of aircraft control during a go-around, due to failure of the flight instructor (CFI) to assure that the minimum control speed (VMC) was maintained. Factors relating to the accident were: shutdown of the left engine, which would have prevented normal…NTSB MIA88FA239Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Avon Park, FLThe CFI radioed that he would be conducting a simulated engine-out aprch. 2 plt witnesses, 1 of whom was a CFI, stated that acft was seen on final aprch at about 200 ft with the left prop feathered & the gear & flaps down. They stated that although the acft…NTSB NYC87FA241Accident · 3 fatalField investigationFinal reportPiper PA-23-160 · Selinsgrove, PAThe pilot was conducting a demonstration flight in an overweight aircraft in conditions of low ceilings and fog. After a touch and go landing the aircraft stalled during the takeoff then collided with the ground. Exam of the wreckage did not disclose any…NTSB FTW85LA144Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · El Campo, TXAttempting a single-engine take-off, the pilot was unable to maintain VMC or retract the landing gear. He lost control of the aircraft and collided with a tree.