Skip to content

NTSB investigations: Piper PA-24-250, VA

28 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" = 'VA' 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\" = 'VA' 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" = 'VA' 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 ERA20LA195Accident · No injuriesClass 3 · LimitedFinal reportPiper PA24 · South Boston, VAThe powerplant mechanic’s failure to properly affix the engine crankshaft gear lockplate during overhaul, resulting in a total loss of engine power.May 26, 2020 · N5948P · Substantial damage NTSB GAA18CA574Accident · No injuriesData collectionFinal reportPiper PA24 · Crewe, VAThe pilot’s failure to maintain adequate airspeed and his exceedance of the airplane’s critical angle of attack, which resulted in an aerodynamic stall. Contributing to the accident was the pilot’s improper fuel management, which resulted in fuel starvation…Sep 29, 2018 · N6148P · Substantial damage NTSB ERA12LA486Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Blacksburg, VAThe pilot’s inadequate preflight planning and improper in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.Jul 27, 2012 · N6248P · Substantial damage NTSB IAD01FA039Accident · 1 fatalField investigationFinal reportPiper PA-24-250 · Paris, VApilot's continued visual flight into instrument meteorological conditions.Mar 31, 2001 · N5841P · Substantial damage NTSB NYC00FA245Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Lexington, VAThe pilot's attempted VFR flight into instrument meteorological conditions that resulted in spatial disorientation. A factor in this accident was the pilot's inadequate preflight planning.Aug 30, 2000 · N6411P · Destroyed NTSB BFO90LA060Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Newport News, VAFuel exhaustion caused by pilot misjudging the fuel supply. Contributing to the accident was inaccurate fuel gages.Jun 22, 1990 · N8337P · Substantial damage NTSB BFO89LA011Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Port Royal, VAThe plt received a wx briefing which forecast IFR after 1800 EST. He departed dca in light drizzle conditions. Arpx 35 NM from dca, radar service was terminated and the plt attempted to contact ATC to no avail. He reported that near the brook VOR the VOR…Nov 19, 1988 · N8215P · Substantial damage NTSB BFO85LA014Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Chantilly, VAWhile retracting the landing gear after takeoff, the gear hesitated briefly at about midpoint before retracting fully. Attempts to extend the gear through normal and emergency procedures failed. The acft landed at dulles international airport with the gear in…Feb 4, 1985 · N5682P · Substantial damage NTSB IAD76FID11Accident · No injuriesClosedPiper PA-24 · Blacksburg, VASep 28, 1975 · N7189P · Substantial damage NTSB IAD75AI022Accident · 3 fatalClosedPiper PA-24 · Saxis, VAOct 11, 1974 · N6876P · 2 aircraft · Destroyed NTSB IAD74FID21Accident · No injuriesClosedPiper PA-24 · Hopewell, VANov 1, 1973 · N6191P · Substantial damage NTSB NYC73FID11Accident · No injuriesClosedPiper PA-24 · Hopewell, VANov 25, 1972 · N6946P · Substantial damage NTSB NYC72FIA20Accident · No injuriesClosedPiper PA-24 · Manassas, VAApr 19, 1972 · N8104P · Substantial damage NTSB IAD71FIJ11Accident · No injuriesClosedPiper PA-24 · Independence, VANov 8, 1970 · N7690P · Substantial damage NTSB IAD71FID05Accident · No injuriesClosedPiper PA-24 · Norfolk, VAAug 15, 1970 · N7821P · Substantial damage NTSB DIA69A0049Accident · 2 fatalClosedPiper PA-24 · Rapidan, VAMar 20, 1969 · N6788P · Destroyed NTSB DIA69F0129Accident · No injuriesClosedPiper PA-24 · Sandston, VADec 18, 1968 · N5379P · Substantial damage NTSB DIA69A0012Accident · 2 fatalClosedPiper PA-24 · Rocky Gap, VASep 10, 1968 · N6537P · Destroyed NTSB DIA69D0018Accident · No injuriesClosedPiper PA-24 · Dulles, VAJun 26, 1968 · N6843P · Substantial damage NTSB DIA68D0231Accident · No injuriesClosedPiper PA-24 · Alexandria, VAMay 19, 1968 · N5454P · Substantial damage NTSB DIA68D0189Accident · No injuriesClosedPiper PA-24 · Gloucester, VAMar 27, 1968 · N8382P · Substantial damage NTSB NYC67F0414Accident · No injuriesClosedPiper PA-24 · Baileys Xroads, VAOct 16, 1966 · N6641P · Substantial damage NTSB NYC66F0577Accident · No injuriesClosedPiper PA-24 · Sandston, VAMar 7, 1966 · N5379P · Substantial damage NTSB NYC66F0394Accident · No injuriesClosedPiper PA-24 · Richmond, VADec 26, 1965 · N7720P · Substantial damage NTSB NYC65A0116Accident · 1 fatalClosedPiper PA24 · Montvale, VAMar 17, 1965 · N8293P · Destroyed NTSB UNK65X0554Accident · No injuriesClosedPiper PA24 · Farmville, VANov 4, 1964 · N6849P · Substantial damage NTSB UNK64X1862Accident · No injuriesClosedPiper PA24 · Richmond, VAMay 20, 1964 · N9897Z · Substantial damage NTSB UNK64X0469Accident · No injuriesClosedPiper PA24 · Blackstone, VAFeb 5, 1964 · N8294P · Substantial damage