NTSB investigations: Piper PA-28R-200
24 cases on aircraft the registry lists as Piper PA-28R-200, where the defining event was Loss of engine power (total). 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.
Cases per year
| 2008 | 1 |
|---|---|
| 2009 | 3 |
| 2010 | 2 |
| 2011 | 1 |
| 2012 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 1 |
| 2019 | 3 |
| 2020 | 1 |
| 2021 | 2 |
| 2022 | 1 |
| 2023 | 1 |
| 2024 | 1 |
| 2025 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102811')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '341'))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102811')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '341'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 WPR26LA034Accident · No injuriesClass 3 · LimitedPreliminary reportPiper PA-28R-200 · La Verne, CAOn October 28, 2025, about 1845 Pacific daylight time, a Piper Arrow PA-28R-200, N5107S, sustained substantial damage when it was involved in an accident near Upland, California. The pilot and passenger were not injured. The airplane was operated as a Title…NTSB WPR25LA046Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Gillette, WYA loss of engine power due to fuel starvation resulting from a loose B-nut at the engine-driven fuel-pump inlet.NTSB WPR23LA094Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Carlsbad, CAA failure of the No. 2 piston connecting rod bearing due to oil starvation for reasons that could not be determined, which resulted in a complete loss of engine power.NTSB ERA22LA417Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Meridianville, ALA loss of engine power that could not be determined based on the available evidence.NTSB ERA22LA067Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Glens Falls, NYA total loss of engine power for reasons that could not be determined.NTSB CEN21LA193Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28R · McKinney, TXA total loss of engine power for reasons that could not be determined based on the available information.NTSB CEN20LA314Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Houston, TXThe loss of engine power for a reason that could not be determined based on available evidence.NTSB CEN20LA016Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Springtown, TXA total loss of engine power for undetermined reasons.NTSB CEN19LA132Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA28R · Prairieville, LAInstallation of an incorrect engine oil drain valve, which resulted in damage to the valve during landing gear retraction and subsequent engine failure due to oil starvation. Contributing to the accident was the failure of maintenance personnel to comply with…NTSB ERA19LA160Accident · No injuriesLimited investigationFinal reportPiper PA28R · Easton, MDThe loss of engine power for reasons that could not be determined because postaccident engine examination and testing revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR18LA101Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Paso Robles, CAThe pilots' inadequate preflight inspection, which failed to ensure that the oil filler cap was secured and resulted in oil starvation and a total loss of engine power.NTSB ERA17LA300Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-200 · St. Augustine, FLA total loss of engine power for reasons that could not be determined because examination of the airplane and engine did not reveal evidence of any preimpact mechanical malfunctions or failures that would have precluded normal operation and because the amount…NTSB ERA17LA266Accident · No injuriesLimited investigationFinal reportPiper PA28R · Pembroke Pines, FLThe loss of engine power for reasons that could not be determined postaccident engine test-runs revealed no preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA16LA276Accident · Minor injuriesLimited investigationFinal reportPiper PA28R · Panama City, FLA total loss of engine power during approach for reasons that could not be determined because postaccident examination did not reveal any evidence of preimpact mechanical malfunctions or failures that would have precluded normal operation.NTSB WPR15LA141Accident · Minor injuriesLimited investigationFinal reportPiper PA 28R-200 · Santa Maria, CAThe engine failure due to oil starvation, which resulted from the installation of an unapproved oil quick drain valve that subsequently led to the inadvertent draining of the oil when the nose landing gear was retracted. Contributing to the accident was the…NTSB CEN15LA157Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Frankenmuth, MIThe failure of the engine due to a lack of oil lubrication for reasons that could not be determined during postaccident examinations.NTSB ERA13LA097Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Lock Haven, PAThe reinstallation of improper connecting rods at engine overhaul, which resulted in abnormal wear of the connecting rod bearings; while the bearings did not meet the manufacturer’s specifications, the use of the unapproved connecting rods more likely caused…NTSB WPR12FA058Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Coupeville, WAThe total loss of engine power for reasons that could not be determined because postaccident examination of the airframe and engine did not reveal evidence of preaccident mechanical malfunctions or failures that would have precluded normal operation.NTSB ERA10LA486Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Barnwell, SCThe failure of the No. 1 connecting rod end cap for undetermined reasons, which resulted in a total loss of engine power.NTSB WPR10LA165Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Eliza Island, WAThe total loss of engine power during cruise flight due to the failure of maintenance personnel to tighten a fitting on the propeller governor oil line, which resulted in a loss of engine oil and catastrophic engine failure.NTSB ERA10FA074Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Wappinger, NYA total loss of engine power due to a delamination of the No. 3 connecting rod bearing. Contributing to the accident was the inadequate maintenance inspection of the engine oil system.NTSB ERA10LA073Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hammonton, NJA total loss of engine power due to a blocked fuel vent.NTSB ERA09LA261Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hilliard, FLA total loss of engine power due to the fatigue failure of the No. 3 cylinder attachment stud as a result of insufficient torque during installation. Contributing to the accident was the pilot’s operation of the airplane with a known mechanical deficiency.NTSB CHI08LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Watseka, ILThe loss of engine power for undetermined reasons.