Skip to content

NTSB investigations: Piper PA-24-250, NC

22 cases on aircraft the registry lists as Piper PA-24-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

19642026

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" = 'NC' 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 ('7102404')) 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\" = 'NC' 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 ('7102404'))
  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" = 'NC' 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 ('7102404'))
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 ERA21FA333Accident · 2 fatalClass 3 · FieldFinal reportPiper PA24 · Wadesboro, NCA partial loss of engine power during takeoff for reasons that could not be determined. Contributing was the pilot’s loss of airplane control, resulting in an aerodynamic stall and impact with trees and terrain.Aug 20, 2021 · N8262P · Destroyed NTSB ATL06LA094Accident · 1 fatalLimited investigationFinal reportPiper PA-24-250 · Wilkesboro, NCThe pilot's improper fuel consumption calculations and improper in-flight planning/decision which resulted in a total loss of engine power due to fuel exhaustion, a forced landing, and collision with terrain.Jun 20, 2006 · N5626P · Substantial damage NTSB ATL99LA082Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Southern Pines, NCA failure of the left main landing gear retraction assembly as a result of the disconnection of the left main landing gear strap bracket assembly from the main gear spring attachment bracket due to the missing nut. A factor was the ditch.May 8, 1999 · N7001P · Substantial damage NTSB ATL94LA052Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kinston, NCA loss of engine power due to a partial blockage of the induction air system by a foreign object (silicon baffling material).Feb 21, 1994 · N6253P · Substantial damage NTSB ATL93FA162Accident · 4 fatalField investigationFinal reportPiper PA-24-250 · Boone, NCThe pilot's improper preflight planning, his failure to retract the landing gear after departure, and his failure to maintain control of the aircraft. Factors in the accident were the high density altitude, and the mountainous terrain.Sep 26, 1993 · N5586P · Destroyed NTSB ATL91LA158Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Waxhaw, NCThe spatial disorientation experienced by the pilot in IMC, his failure to maintain aircraft control, and the exceeding of the design stress limits of the aircraft. Factor(s) in this accident were: the pilot's inadequate preflight planning, the VFR flight…Aug 14, 1991 · N6262P · Substantial damage NTSB ATL90LA149Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Concord, NCThe pilot's inadequate preflight planning and preparation, in that he did not fully consider the effects of high obstructions and a poor runway surface condition.Jul 27, 1990 · N5278P · Substantial damage NTSB ATL89LA206Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Hickory, NCPilot's failure to adequately monitor the engine fuel consumption in flight.Sep 2, 1989 · N5210P · Substantial damage NTSB ATL87LA126Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Pinehurst, NCThe pilot called approach control and reported he was out of fuel and didn't think he was going to make the airport. He had landed at an airport enroute but had not refueled. He stated that he started descending when he got within ten miles of the airport. He…Apr 27, 1987 · N7136P · Destroyed NTSB IAD76DKM44Accident · No injuriesClosedPiper PA-24 · Waynesville, NCAug 22, 1976 · N740W · Substantial damage NTSB IAD76DLJ22Accident · No injuriesClosedPiper PA-24 · Vanceboro, NCApr 30, 1976 · N7940P · Substantial damage NTSB IAD75FLJ30Accident · No injuriesClosedPiper PA-24 · Ocean Isle, NCJun 7, 1975 · N6849P · Substantial damage NTSB IAD71DLJ21Accident · No injuriesClosedPiper PA-24 · Hatteras, NCApr 25, 1971 · N7460P · Substantial damage NTSB DIA69D0201Accident · No injuriesClosedPiper PA-24 · Asheboro, NCApr 21, 1969 · N7746P · Substantial damage NTSB DIA69D0102Accident · No injuriesClosedPiper PA-24 · Charlotte, NCNov 3, 1968 · N7865P · Substantial damage NTSB DIA68F0210Accident · No injuriesClosedPiper PA-24 · Gastonia, NCApr 30, 1968 · N7460P · Substantial damage NTSB DIA68F0107Accident · No injuriesClosedPiper PA-24 · Hamlet, NCOct 21, 1967 · N8165P · Substantial damage NTSB DIA67F0058Accident · No injuriesClosedPiper PA-24 · High Point, NCMar 17, 1967 · N5838P · Substantial damage NTSB MIA66F0409Accident · No injuriesClosedPiper PA-24 · New Bern, NCDec 14, 1965 · N6830P · Substantial damage NTSB MIA66F0324Accident · No injuriesClosedPiper PA-24 · Statesville, NCNov 26, 1965 · N6922P · Substantial damage NTSB UNK64X2160Accident · 2 fatalClosedPiper PA-24 · Mt Guyot, NCJun 6, 1964 · N7152P · Destroyed NTSB UNK64X2123Accident · No injuriesClosedPiper PA24 · Charlotte, NCJun 5, 1964 · N7812P · Substantial damage