Skip to content

NTSB investigations: Piper PA-23-160, FL

21 cases on aircraft the registry lists as Piper PA-23-160. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19662026

Where

Latest cases

Query with SQL

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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA' AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102304')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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.\"eventStateOrRegion\" = 'FL' AND c.\"eventCountry\" = 'USA'
    AND c.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102304'))
  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."eventStateOrRegion" = 'FL' AND c."eventCountry" = 'USA'
  AND c."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102304'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 ERA17CA208Accident · No injuriesData collectionFinal reportPiper PA23 · Cedar Key, FLThe pilot's failure to stop the airplane within the available runway after conducting the approach and landing with a tailwind.Jun 16, 2017 · N4317Y · Substantial damage NTSB MIA04FA047Accident · 2 fatalField investigationFinal reportPiper PA-23-160 · Lake Worth, FLThe pilot's inadequate control of the aircraft by his use of an excessive bank angle, and his failure to maintain airspeed which resulted in a stall and a loss of control following a loss of power in one engine. The reason for the loss of the engine power was…Jan 22, 2004 · N4293P · Destroyed NTSB MIA01LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Milton, FLa loss of right engine power due to chaffed and frayed wiring on the right and left magnetos on the right engine resulting in a forced landing, an inadvertent stall, and subsequent impact with the ground.Jan 13, 2001 · N2407M · Substantial damage NTSB MIA00LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-160 · Winter Haven, FLthe flight instructor's failure to follow procedures/directives and his misjudgment of distance/altitude following a loss of engine power for undetermined reasons, which resulted in the proper touchdown point not being attained, an off airport landing being…Jun 29, 2000 · N3317P · Substantial damage 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…May 19, 2000 · N3492P · Destroyed NTSB ATL00LA029Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-160 · Titusville, FLThe pilot's improper decision to attempt a flight on minimal fuel, which resulted in a total loss of engine power due to fuel exhaustion. A factor was the closed fuel pumps at the departure airport.Feb 28, 2000 · N441WA · Substantial damage 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…Jul 30, 1988 · N3464P · Destroyed NTSB MIA87LA216Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · St Petersburg, FLAfter climbing abv 3000' drg an instrnl flt, the instructor (CFI) had the student lower the gear & flaps to a takeoff configuration & slow the acft below VMC (72 KTS). The CFI then shut off fuel to the left eng. The student followed the correct procedures to…Jul 29, 1987 · N22GM · Substantial damage NTSB MIA80DLA16Accident · No injuriesClosedPiper PA-23 · Bunnell, FLFeb 21, 1980 · N5243Y · Substantial damage NTSB MIA79FA014Accident · 2 fatalClosedPiper PA-23 · Ormond Beach, FLNov 20, 1978 · N3485P · Destroyed NTSB MIA77FA016Accident · 5 fatalClosedPiper PA-23 · Clewiston, FLDec 6, 1976 · N4240P · Destroyed NTSB MIA77DKT90Accident · No injuriesClosedPiper PA-23 · Miami, FLAug 16, 1976 · N3416P · Substantial damage NTSB MIA74AM102Accident · 2 fatalClosedPiper PA-23 · Merritt Is, FLJun 19, 1974 · N4168P · Destroyed NTSB MIA74FLD57Accident · No injuriesClosedPiper PA-23 · Avon Park, FLJan 27, 1974 · N3450P · Substantial damage NTSB MIA70DLD17Accident · No injuriesClosedPiper PA-23 · Lake Placid, FLApr 5, 1970 · N4306Y · Substantial damage NTSB MIA70A0003Accident · 3 fatalClosedPiper PA-23 · Melbourne, FLJul 22, 1969 · N4453P · Destroyed NTSB MIA68D0314Accident · No injuriesClosedPiper PA-23 · Immokalee, FLNov 10, 1967 · N3351P · Substantial damage NTSB MIA68D0007Accident · No injuriesClosedPiper PA-23 · Ft.Lauderdale, FLApr 5, 1967 · N4108P · Substantial damage NTSB MIA67A0020Accident · No injuriesClosedPiper PA-23 · Odessa, FLAug 4, 1966 · N4036P · Substantial damage NTSB MIA67F0189Accident · No injuriesClosedPiper PA-28 · Jacksonville, FLJul 23, 1966 · N8431W · 2 aircraft · Minor damage NTSB MIA67F0082Accident · No injuriesClosedPiper PA-23 · St Augustine, FLJul 8, 1966 · N4032P · Substantial damage