NTSB investigations: Piper PA-28-181, VA
15 cases on aircraft the registry lists as Piper PA-28-181. 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
| 1976 | 1 |
|---|---|
| 1977 | 1 |
| 1978 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 2002 | 1 |
| 2017 | 1 |
| 2018 | 2 |
| 2022 | 1 |
| 2023 | 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.\"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 ('7102807', '7102832'))
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 ('7102807', '7102832'))
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 ERA23LA368Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Culpeper, VAThe airplane’s impact with a deer while performing a takeoff at night.NTSB ERA23LA065Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Manassas, VAAn engine fire caused by chafing and subsequent electrical arcing of the alternator wire near a fuel source.NTSB ERA19LA033Accident · No injuriesLimited investigationFinal reportPiper PA28 · New Market, VAA loss of engine power on takeoff due to restricted air flow to the engine.NTSB ERA18LA101Accident · No injuriesLimited investigationFinal reportPiper PA28 · Chesapeake, VAThe pilot's failure to apply carburetor heat during the approach for a touch-and-go landing, which resulted in a total loss of engine power during the subsequent takeoff.NTSB ERA17CA186Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Bristow, VAThe flight instructor’s and pilot’s mismanagement of the available fuel, which resulted in exhaustion of the fuel in the selected fuel tank and a subsequent total loss of engine power.NTSB NYC02LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Manassas, VAThe pilot's inadequate pre-flight planning, and his inadequate visual lookout while taxing on an off airport road. A factor related to the accident was the dark night conditions.NTSB BFO94LA132Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Waynesboro, VAThe pilot's misjudgement of speed and distance which resulted in a landing overrun. A contributing factor is the pilot's delay in intiating a go-around.NTSB BFO93LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Chesterfield, VAFatigue failure of the engine crankshaft at the number 1 journal. A factor related to the accident was unsuitable terrain in the emergency landing area.NTSB BFO88LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Reedville, VAAfter back-taxiing on the pvt airstrip, the plt made a 180 deg turn to line up for takeoff. During the turn the right main gear contacted a ditch in a tall grass area off the end of the rwy. The plt applied power to prevent the acft from becoming stuck in the…NTSB BFO86LA045Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Fredericksburg, VAThe acft nosed over drg a forced lndg following a total loss of pwr due to fuel exhaustion. The plt rprtd that both he &the passengers visually checked the fuel tanks prior to departure to verify that they were full of fuel. The pwr loss occurred aprx 25 mi…NTSB ATL82FIA03Accident · Serious injuriesClosedPiper PA-28 · Pender, VANTSB ATL80F1A06Accident · Serious injuriesClosedPiper PA-28 · Front Royal, VANTSB IAD78FA050Accident · 2 fatalClosedPiper PA-28 · Melfa, VANTSB IAD78DIJ01Accident · Serious injuriesClosedPiper PA-28 · Abingdon, VANTSB IAD76AI070Accident · 3 fatalClosedPiper PA-28 · Big Island, VA