NTSB investigations: Piper PA-28-181, IN
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
| 1986 | 1 |
|---|---|
| 1988 | 2 |
| 1990 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2002 | 1 |
| 2006 | 1 |
| 2021 | 1 |
| 2022 | 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\" = 'IN' 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" = 'IN' 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 CEN22LA095Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Washington, INThe pilot’s failure to maintain directional control while landing in gusty crosswind conditions which resulted in a runway excursion.NTSB CEN21LA353Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Jeffersonville, INA loss of directional control due to failure of the landing gear attachment hardware for reasons that could not be determined based on the available information.NTSB CHI06CA144Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Logansport, INThe pilot's improper flare and inadequate recovery from a bounced landing.NTSB CHI03LA038Accident · Minor injuriesLimited investigationFinal reportPiper PA28-181 · Greensburg, INFailure of the pilot to maintain directional control during the takeoff roll. Contributing factors included inadequate planning/decision by the pilot for attempting to depart from the slush covered runway, the slush covered runway itself, and the falling snow.NTSB CHI00LA156Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Indianapolis, INThe improper in-flight decision of the pilot not to land at the nearest airport at the first loss of engine power. Factors to the accident were fuel exhaustion, the excessive fuel flow, and the airport perimeter fence.NTSB CHI98LA324Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Michigan City, INthe pilot departed into known adverse weather and failed to maintain directional control of the airplane. A factor was the fog.NTSB CHI96FA284Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Muncie, INthe inadvertent flight of the airplane by the pilot-in-command into a thunderstorm. The weather was a factor.NTSB CHI95LA083Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Lafayette, INthe pilot's failure to perform a go-around. The gusty crosswind was a factor in the accident.NTSB CHI90LA127Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Anderson, INThe pilot-in-command failed to select the fuel valve to a tank containing usable fuel resulting in fuel starvation.NTSB CHI88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orleans, INThe pilot failed to maintain an adequate visual lookout and to maintain adequate clearance from the utility pole and transmission wire. Contributing to the cause were the pilot's total lack of experience, task overload, and anxiety, stemming from a partial…NTSB CHI88DET01Accident · Minor injuriesFinal reportPiper PA-28-181 · Fort Wayne, INPilot on night cross country flight with clear, very cold weather, experienced total loss of engine power while cruising at 7500 feet MSL. Approach control gave position of closest field, but pilot elected to continue to destination which was five miles…NTSB CHI86LA229Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Greenwood, INThe brake pads on the aircraft were allowed to wear beyond their limits. When the brakes were applied, the right brake cylinder moved out past its limit and released the o-ring. This resulted in a loss of brake fluid from the right brake. All of this happened…