NTSB investigations: Piper PA-28-181, IL
20 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
| 1980 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1986 | 2 |
| 1988 | 1 |
| 1992 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2004 | 1 |
| 2007 | 1 |
| 2008 | 2 |
| 2011 | 1 |
| 2021 | 1 |
Where
Latest 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\" = 'IL' 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" = 'IL' 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 CEN21LA185Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot’s failure to maintain directional control during the rejected takeoff with a left quartering crosswind that shifted to a tailwind.NTSB CEN11CA647Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Pinckneyville, ILThe pilot's failure to conduct a go-around due to his excessive airspeed while on approach to land, which resulted in a runway excursion.NTSB CHI08CA147Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Dixon, ILThe student pilot improperly raised the flaps during the go-around, did not maintain airspeed, and stalled the airplane. The trees were a factor.NTSB CHI08CA126Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Naperville, ILThe pilot's failure to execute a go-around. Contributing to the accident was the pilot's excessive airspeed during touchdown, which resulted in the runway overrun.NTSB CHI07CA200Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Lake in the Hil, ILThe pilot's failure to achieve a proper touchdown point and delayed decision to abort the landing. Factors contributing to the accident include the chain link fence and the trees.NTSB CHI05CA022Accident · Minor injuriesData collectionFinal reportPiper PA-28-181 · Morris, ILThe pilot's inadequate preflight planning in that he failed to assure that the airplane was properly secured prior to hand propping the engine. Factors associated with the accident were the broken tie down rope and the other airplanes which were contacted.NTSB CHI02LA126Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Sandwich, ILThe driver of the automobile improperly drove his automobile on the active runway and did not maintain visual lookout for landing aircraft.NTSB CHI01LA166Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILThe pilot's failure to maintain aircraft control during the visual approach for landing.NTSB CHI99FA238Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Yorkville, ILthe pilot continuing into known adverse weather conditions, attempting low altitude flight, and not maintaining terrain clearance. Factors to the accident were the thunderstorm and the improper weather evaluation by the pilot following pre-departure and…NTSB CHI97LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grayslake, ILthe pilot's misjudgment of the aircraft's speed and runway distance available. Factors were an off-field ditch and a tailwind condition.NTSB CHI95FA123Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Schaumburg, ILThe pilot's impairment of judgment and performance due to alcohol, his resultant improper planning/decision, and his attempt to perform an apparent aerobatic maneuver at an altitude that was insufficient to assure recovery.NTSB CHI95LA021Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Bloomington, ILthe pilot's failure to maintain airspeed during the landing which resulted in a stall. A factor related to the accident was the loss of engine power for undetermined reasons.NTSB CHI93IA019Incident · No injuriesIncident investigationFinal reportPiper PA-28-181 · Chicago, ILThe failure of the midway arsa controller to coordinate use of the airspace with the Chicago north local controller which resulted in an operational deviation. A factor related to the incident was the pilot's failure to follow his assigned heading.NTSB CHI89LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Plainfield, ILNTSB CHI87FA004Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Charleston, ILN8267W was on practice NDB approach to rwy 29 under ATC clrnc with hooded stu at controls in left seat, ip in right seat, proceeding level at mda for low pass. Evidence indicates N30019 had entered downwind for rwy 24 and was in left turn VFR approach for rwy…NTSB CHI86LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Galesburg, ILThe non-instrament rated pilot, landing in IFR conditions, flared too high resulting in a hard landing, nose gear failure and buckling of the engine mounts.NTSB CHI85LA255Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Kankakee, ILThe aircraft while clearing the runway, shot wide of the taxiway taxiing onto the grass and into a culvert which was difficult to see resulting in substantial damage to the aircraft.NTSB CHI83LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Grayslake, ILDuring arrival, the pilot landed on runway 24 with a left quartering, gusty head wind at 8 to 10 KTS. The pilot reported that during the landing, the aircraft suddenly veered left and went off the runway. After departing the runway, the aircraft hit a…NTSB CHI81DEE54Accident · No injuriesClosedPiper PA-28 · Polo, ILNTSB CHI81FEE01Accident · Serious injuriesClosedPiper PA-28 · Huntley, IL