Skip to content

NTSB investigations: Piper PA-23-250, GA

20 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

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" = 'GA' 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\" = 'GA' 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" = 'GA' 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 GAA19CA310Accident · No injuriesData collectionFinal reportPiper PA23 · Atlanta, GAThe airplane’s impact with a deer on the runway during landing.May 18, 2019 · N6562A · Substantial damage NTSB ERA17FA222Accident · 4 fatalField investigationFinal reportPiper PA23 · Chatsworth, GAThe noninstrument-rated pilot's continued visual flight rules flight into adverse weather conditions, which resulted in an encounter with severe convective activity, spatial disorientation, a loss of airplane control, and a subsequent in-flight breakup.…Jul 1, 2017 · N44HJ · Destroyed NTSB MIA98FA155Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Fargo, GAthe left engine propeller blades struck the runway surface during takeoff, resulting in the pilot losing control of the airplane, and subsequently impacting with trees.May 7, 1998 · N4BN · Destroyed NTSB ATL93FA041Accident · Serious injuriesField investigationFinal reportPiper PA-23-250 · Atlanta, GAThe pilot's failure to maintain clearance from approach lights while conducting a night landing. A factor was a dark night.Dec 25, 1992 · N2603Z · Substantial damage NTSB ATL91LA062Accident · Serious injuriesLimited investigationFinal reportPiper PA-23-250 · Suches, GAThe pilot's failure to maintain altitude during cruise flight after loss of electrical power for an undetermined reason.Mar 1, 1991 · N6546Y · Destroyed NTSB ATL88FA082Accident · Serious injuriesField investigationFinal reportPiper PA-23 · Augusta, GAJan 19, 1988 · N101JR · Destroyed NTSB MIA85LA108Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Brunswick, GAThe plt stated that his takeoff roll was normal, but just before he rotated, the nose gear collapsed. No determination could be made as to the nature of the malfunction during a post crash exam & retraction test of the landing gear.Mar 1, 1985 · N6429Y · Substantial damage NTSB ATL85LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Reidsville, GAThe acft was found burning in the woods by the foresty service. No persons or baggage were found. The date, time & cause of the accident is unknown. Suspected drug related activity. According to FAA records, the acft was not officially registered. It had been…Feb 28, 1985 · N4565P · Destroyed NTSB MIA78DLA43Accident · No injuriesClosedPiper PA-23 · St Simons Isle, GAJul 5, 1978 · N7AD · Substantial damage NTSB MIA76FKG24Accident · No injuriesClosedPiper PA-23 · Ringgold, GAOct 3, 1975 · N54772 · Substantial damage NTSB MIA75DKG55Accident · Minor injuriesClosedPiper PA-23 · Bruswick, GAJan 9, 1975 · N5667Y · Substantial damage NTSB MIA73DLG27Accident · No injuriesClosedPiper PA-23 · No.Myrtle Bch, GAOct 14, 1972 · N6281Y · Substantial damage NTSB MIA72FKG99Accident · No injuriesClosedPiper PA-23 · Chamblee, GAMay 16, 1972 · N5220Y · Substantial damage NTSB MIA71DKG79Accident · Minor injuriesClosedPiper PA-23 · Augusta, GAMay 6, 1971 · N6019Y · Substantial damage NTSB MIA71AM007Accident · Minor injuriesClosedPiper PA-23 · Fowltown, GAJul 18, 1970 · N6139Y · Destroyed NTSB MIA68D0432Accident · No injuriesClosedPiper PA-23 · Dublin, GAJan 21, 1968 · N4846P · Substantial damage NTSB MIA68F0195Accident · No injuriesClosedPiper PA-23 · Columbus, GASep 2, 1967 · N4584P · Substantial damage NTSB MIA68F0042Accident · No injuriesClosedPiper PA-23 · Augusta, GAJul 5, 1967 · N5557Y · Substantial damage NTSB UNK65X1364Accident · No injuriesClosedPiper PA23 · Atlanta, GAJan 28, 1965 · N5329Y · Substantial damage NTSB UNK64X2893Accident · No injuriesClosedPiper PA23 · Atlanta, GAJul 18, 1964 · N4594P · Substantial damage