Skip to content

NTSB investigations: Piper PA-28-140, NV

31 cases on aircraft the registry lists as Piper PA-28-140. 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

19672026

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" = 'NV' 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 ('7102802')) 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\" = 'NV' 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 ('7102802'))
  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" = 'NV' 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 ('7102802'))
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 WPR23LA282Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-140 · Elko, NVThe pilot’s failure to ensure adequate airplane performance before taking off from a significantly shorter runway than originally planned for.Jul 20, 2023 · N4149J · Substantial damage NTSB WPR23LA232Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-140 · Rochester, NVA broken fuel line fitting that resulted in a total loss of engine power due to fuel starvation.Jun 17, 2023 · N3508K · Substantial damage NTSB WPR15LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA 28 · Elko, NVThe pilot's failure to sufficiently lean the engine’s fuel-to-air mixture for the given density altitude, which resulted in reduced engine power output and the airplane’s inability to climb.Sep 23, 2015 · N56897 · Substantial damage NTSB WPR12CA142Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Jean, NVThe student pilot did not maintain directional control during the landing roll.Mar 22, 2012 · N55634 · Substantial damage NTSB LAX05LA318Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Pioche, NVcontrolled flight into mountainous terrain due to the pilot's inadequate preflight planning and preparation and his inadequate in-flight decisions, which created a low fuel state emergency situation that led directly to the CFIT during flight assist efforts…Sep 26, 2005 · N5031T · Substantial damage NTSB LAX98LA300Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Dayton, NVLoss of engine power for unknown reasons. Factors were conditions conducive to carburetor icing and the use of automotive fuel.Sep 20, 1998 · N5817U · Substantial damage NTSB LAX98LA276Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Henderson, NVThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.Aug 17, 1998 · N291HA · Substantial damage NTSB LAX94LA287Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Elko, NVthe pilots attempted takeoff with a strong and gusty tailwind.Jul 16, 1994 · N6785W · Substantial damage NTSB SEA84LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Boulder City, NVThe acft nosed over after a loss of control following a bounced landing.Apr 24, 1984 · N95434 · Substantial damage NTSB LAX82FA016Accident · 2 fatalClosedPiper PA-28 · Laughlin, NVNov 18, 1981 · N4259J · Destroyed NTSB LAX82FVW01Accident · No injuriesClosedPiper PA-28 · Boulder City, NVOct 4, 1981 · N9690K · Substantial damage NTSB OAK78DXQ29Accident · No injuriesClosedPiper PA-28 · Austin, NVJun 24, 1978 · N41471 · Substantial damage NTSB OAK78DXQ28Accident · Minor injuriesClosedPiper PA-28 · Carson City, NVJun 20, 1978 · N438FL · Destroyed NTSB OAK77FXQ17Accident · 1 fatalClosedPiper PA-28 · Winnemucca, NVApr 23, 1977 · N41176 · Destroyed NTSB OAK77DXQ04Accident · No injuriesClosedPiper PA28 · Winnemucca, NVDec 31, 1976 · N4388X · Substantial damage NTSB OAK75FXQ30Accident · No injuriesClosedPiper PA-28 · Carson City, NVNov 1, 1974 · N55527 · Substantial damage NTSB OAK75FP010Accident · 4 fatalClosedPiper PA-28 · Reno, NVSep 2, 1974 · N6537W · Destroyed NTSB OAK75DXQ21Incident · No injuriesClosedPiper PA-28 · Carson City, NVAug 15, 1974 · N1484T · Minor damage NTSB OAK75FXQ06Accident · No injuriesClosedPiper PA-28 · Carson City, NVJul 28, 1974 · N7316J · Substantial damage NTSB OAK74FXQ04Accident · Minor injuriesClosedPiper PA-28 · Carson City, NVAug 4, 1973 · N7263J · Substantial damage NTSB OAK73FXG20Accident · No injuriesClosedPiper PA-28 · Carson City, NVDec 27, 1972 · N9555W · Substantial damage NTSB OAK17FVW11Accident · Minor injuriesClosedPiper PA-28 · Glendale, NVOct 28, 1972 · N8816N · Substantial damage NTSB OAK73FVW10Accident · No injuriesClosedPiper PA-28 · Henderson, NVOct 7, 1972 · N516FL · Substantial damage NTSB OAK73DXQ12Accident · No injuriesClosedPiper PA-28 · Elko, NVAug 24, 1972 · N8743N · Substantial damage NTSB OAK73DVW03Accident · No injuriesClosedPiper PA-28 · Lathrop Wells, NVJul 7, 1972 · N5966U · Substantial damage NTSB OAK71FXQ38Accident · No injuriesClosedPiper PA-28 · Gardenville, NVMay 2, 1971 · N6492R · Substantial damage NTSB OAK71FVW04Accident · No injuriesClosedPiper PA-28 · Jean, NVAug 16, 1970 · N8734N · Substantial damage NTSB OAK70DXQ07Accident · No injuriesClosedPiper PA-28 · Wilkins, NVApr 11, 1970 · N95049 · Substantial damage NTSB OAK69D0116Accident · No injuriesClosedPiper PA-28 · Battle Mtn., NVSep 10, 1968 · N8485R · Substantial damage NTSB OAK68D0143Accident · No injuriesClosedPiper PA-28 · Reno, NVJul 23, 1967 · N6654W · Substantial damage NTSB OAK67F0309Accident · No injuriesClosedPiper PA-28 · Elko, NVApr 16, 1967 · N6567W · Substantial damage