Skip to content

NTSB investigations: Piper PA-23-250, MI

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

19652026

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" = 'MI' 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 ('7102308')) 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\" = 'MI' 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 ('7102308'))
  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" = 'MI' 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 ('7102308'))
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 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…Aug 14, 2006 · N133BH · Destroyed NTSB CHI05FA049Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Ironwood, MIFatigue fracture of an engine cylinder resulting in a loss of power on the left engine. Additional causes were the pilot's failure to maintain minimum control airspeed (Vmc), the resulting loss of aircraft control, and an inadvertent stall/spin. Contributing…Dec 28, 2004 · N5398M · Substantial damage NTSB CHI05FA024Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Detroit, MIThe pilot's failure to feather the propeller and to maintain control of the airplane following the loss of engine power which resulted from undetermined reasons. Factors associated with the accident were the power lines and the house that the airplane…Nov 8, 2004 · N63887 · Destroyed NTSB CHI03LA029Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Stalwart, MIThe pilot's improper fuel management during the flight and the pilot's improper decision not to select the outboard fuel tank when a loss of engine power was experienced, resulting in fuel starvation, a sustained loss of engine power, and subsequent forced…Nov 23, 2002 · N5985Y · Substantial damage NTSB CHI98LA345Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Grosse Ile, MIthe pilot in command (CFI)'s diverted attention and his failure to select landing gear extension.Aug 26, 1998 · N33MP · Substantial damage NTSB CHI98LA200Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Albion, MIthe pilot's improper preflight planning/preparation and his not refueling the airplane to avoid fuel exhaustion. Factors were the pilot's lack of certification, his not feathering the engine, and the trees.Jun 13, 1998 · N4617P · Substantial damage NTSB CHI98LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Charlotte, MIimproper positioning of the fuel selector by the second pilot, which resulted in fuel starvation; inadequate supervision by the pilot-in-command; and failure of the flight crew to follow the published emergency procedures for loss of engine power.Oct 9, 1997 · N54738 · Substantial damage NTSB CHI95LA171Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Plymouth, MIthe failure of the nose wheel collar assembly as a result of the loss of a bolt.Jun 5, 1995 · N40540 · Substantial damage 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.Sep 15, 1994 · N13909 · Destroyed NTSB CHI88FA082Accident · Minor injuriesField investigationFinal reportPiper PA-23-250 · Alma, MIDrg arrival, the plt was provided vectors for an sdf rwy 9 apch. No wx rprt was available for the destn (Alma), but the plt was adzd the saginaw wx was: indefinite ceiling, 200' obscured, vis 1/2 mi with fog, temp 41, dew point 31, wind 100 deg at 8 KTS,…Mar 25, 1988 · N54848 · Destroyed NTSB CHI82DA346Accident · No injuriesFinal reportPiper PA-23-250 · Holland, MIPilot taxiing to takeoff collided with fuel pumps.Sep 8, 1982 · N54847 · Substantial damage NTSB CHI80FA065Accident · 4 fatalClosedPiper PA-23 · East Tawas, MIAug 27, 1980 · N44EM · Destroyed NTSB CHI79FEM08Accident · No injuriesClosedPiper PA-23 · Muskegon Hgts, MIJan 5, 1979 · N5120Y · Substantial damage NTSB CHI78FEC21Accident · No injuriesClosedPiper PA-23 · Lake Orion, MIFeb 25, 1978 · N300PC · Substantial damage NTSB NYC73AN086Accident · 2 fatalClosedPiper PA-23 · New Boston, MIDec 20, 1972 · N6303Y · Destroyed NTSB CHI73ACO34Accident · 3 fatalClosedPiper PA-23 · Hubbard Lk, MISep 18, 1972 · N5695Y · Destroyed NTSB CHI71AC093Accident · 1 fatalClosedPiper PA-23 · Royal Oak, MIJun 28, 1971 · N5187Y · Destroyed NTSB CHI71FBJ55Accident · No injuriesClosedPiper PA-23 · Traverse Cty, MIJan 29, 1971 · N5896Y · Substantial damage NTSB CHI71AC046Accident · No injuriesClosedPiper PA-23 · Romulus, MIDec 22, 1970 · N6748Y · Substantial damage NTSB CHI71FBJ10Accident · No injuriesClosedPiper PA-23 · Grand Rapids, MIJul 17, 1970 · N5459Y · Substantial damage NTSB CHI71AC002Accident · Minor injuriesClosedPiper PA-23 · Haslett, MIJul 11, 1970 · N5126Y · Destroyed NTSB CHI70FBJ04Accident · Minor injuriesClosedPiper PA-23 · Conway, MIJan 22, 1970 · N5245Y · Destroyed NTSB CHI69D0567Accident · No injuriesClosedPiper PA-23 · Drummond, MIMar 29, 1969 · N5157Y · Substantial damage NTSB CHI68F0215Accident · No injuriesClosedPiper PA-23 · Grand Haven, MIJul 15, 1967 · N4634P · Substantial damage NTSB CHI66F0571Accident · No injuriesClosedPiper PA-23 · Dowagiac, MIFeb 2, 1966 · N5655Y · Substantial damage NTSB CHI66A0055Accident · No injuriesClosedPiper PA-23 · Detroit, MIDec 6, 1965 · N5700Y · Substantial damage NTSB CHI65F0171Accident · Minor injuriesClosedPiper PA-23 · Negaunee, MIMar 24, 1965 · N5250Y · Substantial damage