NTSB investigations: Piper PA-28-181, TN
12 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 |
|---|---|
| 1982 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2007 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2020 | 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.\"eventStateOrRegion\" = 'TN' 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" = 'TN' 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 ERA25LA233Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28 · Knoxville, TNA collision with a deer during the landing roll.NTSB ERA20LA309Accident · 3 fatalClass 3 · LimitedFinal reportPiper PA28 · McMinnville, TNA total loss of engine power due to a fatigue failure in a cylinder, and the pilot’s subsequent failure to maintain airspeed and her exceedance of the airplane’s critical angle-of-attack while maneuvering at low altitude.NTSB ERA15LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Corryton, TNThe failure of the No. 4 engine cylinder due to fatigue, resulting in a catastrophic failure of the engine.NTSB ERA14LA227Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Covington, TNThe pilot’s improper preflight and in-flight fuel planning, which resulted in fuel exhaustion and a subsequent total loss of engine power over unsuitable terrain.NTSB NYC07LA206Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sevierville, TNThe pilot misjudged his speed and distance resulting in an overrun. Contributing to the accident was the wet turf runway and the lack of any information in the pilot operating handbook regarding landing distance on a wet turf runway.NTSB ATL07LA067Accident · 1 fatalLimited investigationFinal reportPiper PA28-181 · New Tazewell, TNThe pilot's failure to maintain aircraft control. Contributing to the accident was the non-instrument rated pilot's continued flight from visual meteorological conditions into instrument meteorological conditions, and a low cloud ceiling.NTSB ATL02FA008Accident · 3 fatalField investigationFinal reportPiper PA-28-181 · McEwen, TNThe pilot initiated a VFR flight into known IMC conditions which resulted in a loss of control of the airplane due to spatial disorientation. Factors were the low ceilings.NTSB MIA97LA098Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Nashville, TNimproper planning/decision by the pilot, by failing to ensure there was sufficient fuel to reach a suitable landing area, which resulted in fuel exhaustion, loss of engine power, a forced landing, and collision with a tree. The faulty fuel indication was a…NTSB ATL89LA216Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Cleveland, TNThe improper handling of the airplane by the pilot in command; a delayed go-around, and the premature retractions of the flaps.NTSB ATL84FLT15Accident · No injuriesFinal reportPiper PA-28-181 · Jackson, TNDuring a go-around, the engine lost all power. The pilot was able to land on the rwy. The acft went off the end of the rwy, went through a ditch, struck a fence and came to rest on an adjacent road. Examination disclosed no fuel in the left tank. The right…NTSB ATL83FA014Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Athens, TNThe plt had not flown for a couple of years. On 10/15/82 he received dual instruction in a C-172 & on the day of the accident was checked out in the PA-28. His certificate was not valid for night flight. At 1716 the plt activated a VFR flt plan. At…NTSB IAD76FKW27Accident · No injuriesClosedPiper PA-31T · Cleveland, TN