NTSB investigations: Piper PA-28-181, GA
14 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
| 1968 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1987 | 1 |
| 2001 | 2 |
| 2007 | 1 |
| 2013 | 1 |
| 2018 | 2 |
| 2021 | 1 |
| 2023 | 2 |
| 2024 | 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\" = '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 ('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" = '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 ('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 ERA24LA306Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Cochran, GAThe airplane’s impact with a bird resulting in substantial damage to the right wing.NTSB ERA23LA305Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Gray, GAAn in-flight collision with a bird.NTSB ERA23LA127Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Atlanta, GAThe flight instructor’s failure to effectively utilize carburetor heat, which resulted in a total loss of engine power during initial climb due to carburetor ice that formed during the engine run-up and taxi.NTSB ERA22LA073Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Wheeler Heights, GAThe airplane’s impact with a bird while in the traffic pattern.NTSB ERA19FA070Accident · 3 fatalField investigationFinal reportPiper PA28 · Blairsville, GAThe pilot's failure to maintain clearance from trees during a visual approach for landing in night visual meteorological conditions. Contributing to the accident was the pilot's lack of recent experience flying at night.NTSB GAA19CA088Accident · No injuriesData collectionFinal reportPiper PA28 · Cornelia, GAThe flight instructor's failure to maintain the runway heading during an attempted takeoff in gusting crosswind conditions, which resulted in a collision with trees.NTSB ERA13LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Columbus, GAThe pilot's delayed decision to abort the takeoff. Contributing to the accident was the airplane's perceived lack of performance for reasons that could not be determined due to insufficient information.NTSB MIA08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Walthourville, GAThe non-instrument rated pilot's loss of control at night in marginal night VFR operations due to spatial disorientation. A factor in the accident was the pilot's improper decision to continue the flight.NTSB ATL02LA004Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Brunswick, GAThe pilot's improper inflight planning which resulted in fuel exhaustion, and subsequent loss of engine power. A factor was the none suitable terrain.NTSB ATL01FA048Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Jasper, GAThe pilot disregarded preflight weather briefing information, and continued visual flight into known instrument weather conditions and collided with trees.NTSB ATL87LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Albany, GAPlt deptd bowling green with a listed 5.0 hrs fuel on bd. After 3 hr 35 min he arrived over dest after exhausting fuel in the rt tank abt 30 min prior. He stated that the other tank was abt 1/2 full at the time. 15 min after rt tank exhaustion the plt req his…NTSB ATL82DA162Accident · Serious injuriesFinal reportPiper PA-28-181 · Savannah, GAThe pilot obtained a weather briefing and filed a VFR flight plan before takeoff. He was advised that the weather was 6000 ft scattered, 6 miles visibility, possible storms gathering at palatka, FL. After takeoff, he was unable to contact the flight service…NTSB ATL81FA106Accident · 4 fatalClosedPiper PA-28 · Camilla, GANTSB MIA69F0250Accident · 1 fatalClosedPiper PA-18A · Millen, GA