NTSB investigations: Piper PA-28-181, CO
21 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 |
|---|---|
| 1978 | 1 |
| 1980 | 1 |
| 1985 | 5 |
| 1987 | 1 |
| 1993 | 1 |
| 1995 | 2 |
| 1996 | 1 |
| 1998 | 2 |
| 1999 | 1 |
| 2014 | 2 |
| 2017 | 1 |
| 2019 | 1 |
| 2021 | 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\" = 'CO' 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" = 'CO' 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 CEN21LA383Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Gypsum, COA loss of engine power due to fuel starvation and the pilot's mismanagement of the available fuel.NTSB CEN19LA314Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Colorado Springs, COThe pilot's improper taxi speed and his excessive use of brakes, which resulted in a brake fire and substantial thermal damage to the airplane.NTSB CEN17LA306Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Denver, COThe pilot’s failure to maintain directional control while landing.NTSB CEN15CA055Accident · Minor injuriesData collectionFinal reportPiper PA 28-181 · Strasburg, COThe exhaustion of the fuel supply resulting in a complete loss of engine power.NTSB CEN14LA245Accident · No injuriesLimited investigationFinal reportPiper PA 28-181 · Yuma, COThe pilot's failure to maintain directional control after the airplane encountered a wind gust during takeoff roll. Contributing to the accident was the pilot inadvertently using a runway that resulted in a gusty tailwind condition.NTSB DEN99FA157Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Villa Grove, COThe flight instructor's improper inflight decision to enter a narrow blind/box canyon, and his misjudgment of the vertical and lateral clearances. A factor was the downdrafts.NTSB DEN99LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Rollinsville, COThe pilot's inadequate decision to continue flight into deteriorating weather conditions, that included a downdraft which resulted in a loss of control, and collision with terrain. Contributing factors were the pilot's lack of familiarity with the terrain,…NTSB DEN99FA009Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Montrose, COThe pilot's improper inflight planning/decision. Factors were a reduction in the airplane's climb and turn capabilities, the aft c.g. limit being exceeded, and the pilot's lack of familiarity with the geographic area and his lack of experience in the airplane…NTSB FTW96LA090Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Collbran, COThe pilot's intentional flight at low altitude, which resulted in inadequate terrain clearance to compensate for a downdraft. The downdraft was a related factor.NTSB FTW95LA366Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure by the pilot to properly plan his flight and check NOTAMS prior to departure. A factor was obstructions in the runway construction zone.NTSB FTW95LA369Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Fort Collins, COFailure of the pilot to attain the proper touchdown point for landing. A factor relating to the accident was: a misreading or misunderstanding of the NOTAMS.NTSB DEN93FA043Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Elbert, COThe pilot's inadvertent VFR flight into IMC. Factors were his lack of instrument training/experience, existing weather, and dark night conditions.NTSB DEN88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Durango, COThe two pax had chartered N8266U for a sightseeing flight of the local area. The charter plt, a CFI found that one of the pax was a plt and permitted him to fly the acft. The pax expressed an interest in spotting elk and flew the acft into a canyon, below the…NTSB DEN85LA243Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Holyoke, COThe plt landed her a/c in a right xwind and was unable to prevent the a/c from veering off the r/w. the a/c struck a wind t and came to rest in a corn field. The plt was not injured.NTSB DEN85LA231Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Englewood, COThe pilot stated after the accident that he had approximately 1/2 full tanks of fuel when he departed the airport on a local night flight. He stated that he flew burning fuel from the left fuel tank. The pilot was returning to the airport after a flight of…NTSB DEN85LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Kiowa, COThe acft collided with a telephone wire and crashed. The plt admitted he had been flying over a boy scout ranch at 7500 ft MSL (about 500 ft AGL). He could not recall any other details. One witness said he saw the acft cross in front of his pickup truck at…NTSB DEN85FA102Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Vail, COThe plt did not obtain a wx briefing, file a flight plan or refuel the acft prior to departing for eagle Colorado. The acft departed at 1800 under VFR cond. The plt reported over minturn co at 2019. Witnesses at Vail co stated that the wx cond were poor from…NTSB DEN85LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Yoder, COEngine quit during cruise flight. Pilot made forced landing on dirt road during which the acft veered off the road and collided with a fence post. Fire department officials reported no evidence of fuel either in the fuel tanks or around the acft.NTSB DEN80FTE49Accident · Serious injuriesClosedPiper PA-28 · Colorado Sprgs, CONTSB DEN78FTE84Accident · No injuriesClosedPiper PA-28 · Denver, CONTSB DEN76FTE91Accident · Minor injuriesClosedPiper PA-28 · Peyton, CO