NTSB investigations: Piper PA-28-161
30 cases on aircraft the registry lists as Piper PA-28-161, where the first occurrence was “On ground/water collision with object”. 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
| 1982 | 3 |
|---|---|
| 1983 | 1 |
| 1986 | 2 |
| 1987 | 3 |
| 1988 | 1 |
| 1989 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1994 | 1 |
| 1995 | 1 |
| 1997 | 1 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 2 |
| 2004 | 2 |
| 2005 | 2 |
| 2006 | 3 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102803', '7102834')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 310))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102803', '7102834')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 310))
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 CHI06CA134Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Grayslake, ILThe student pilot's failure to maintain clearance from the parked vehicle during taxi and the flight instructor's inadequate operational oversight. A factor to the accident was the parked vehicle.NTSB NYC06CA093Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Norwood, MAThe student pilot's failure to maintain directional control during the landing rollout.NTSB CHI06CA065Accident · No injuriesData collectionFinal reportPiper PA-28-161 · West Branch, MIAn encounter with a deer during landing.NTSB LAX06CA045Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Panamint Spring, CAthe pilot's improper in-flight selection of unsuitable terrain for landing.NTSB LAX05CA230Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe student pilot's failure to maintain clearance from a fuel truck, and the flight instructor's inadequate supervision.NTSB MIA05CA014Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Valkaria, FLThe inadvertent collision with a deer during takeoff which resulted in damage to the right brake system and the airplane being unable to stop prior to the end of the runway.NTSB LAX04CA208Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Tucson, AZthe backhoe driver's failure to maintain visual lookout while maneuvering near a taxiway, which resulted in its collision with a taxiing airplane.NTSB ATL03LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Eastman, GAThe pilots failure to maintain a visual lookout resulting in the subsequent on ground collision with a hangar.NTSB CHI02LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Grand Forks, NDThe student pilot not maintaining clearance from a parked van while taxiing to the parking area. The van was a factor.NTSB CHI01LA116Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Culver, INthe CFI delayed remedial action during the takeoff. Additional factors were the wrong runway was selected, the tailwind, and the trees.NTSB MIA01LA034Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Melbourne, FLThe student pilot's failure to maintain a visual look out while transitioning from the active runway to a taxiway resulting in an on-ground collision with a taxiway sign.NTSB MIA99LA264Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Covington, GAthe pilot's decision to take off from unsuitable terrain, which resulted in a collision with trees.NTSB MIA97LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLthe pilot's excessive taxispeed.NTSB CHI95LA331Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Poseyville, INthe pilot's poor judgement in making a night takeoff on an unlit runway and his failure to maintain proper runway alignment. Factors associated with the accident were the hay bale, the night conditions and the unlit runway.NTSB MIA94LA184Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Naples, FLFailure of the pilot-in-command to maintain wingtip clearance while taxiing resulting in the on-ground collision with a light pole.NTSB FTW93LA218Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · League City, TXVisual lookout not maintained by the driver of the vehicle. A factor was the driver of the vehicle becoming inadvertently lost.NTSB ATL92LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bainbridge, GAThe pilot's misjudged distance of runway remaining, resulting in a delayed decision to abort the takeoff, and subsequent collision with trees. Factors were the high obstructions (trees) at the departure end of the runway.NTSB BFO90LA056Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chester, MDThe pilot's misidentification of a road for the runway. Factors were sunglare and the pilot's unfamiliarity with the airport, and inadequate visual lookout.NTSB MIA90LA009Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Tampa, FLAn animal (cow) that had wandered onto the arpt.NTSB MKC90LA012Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Jefferson City, MOInadequate visual lookout by the pilot in command. Contributing factors were the dark night & rainy weather.NTSB MIA88LA264Accident · Minor injuriesLimited investigationFinal reportPiper PA-28 · Orlando, FLThe plt had rented the fully fueled aircraft from an FBO at orl which has hard surfaced 4600 & 6000 ft rwys. He flew to a 130 ft MSL arpt with a 2430 ft grass rwy & picked up his wife for a xc flt. He stated that the acft performed normally during the 10 min…NTSB LAX88LA073Accident · No injuriesLimited investigationFinal reportCessna 195A · Burbank, CAWhile holding short of the active rwy, the number one acft,N4309Y, was having radio problems. The tower began to clear other acft for takeoff. Two acft were able to get around the number one acft and takeoff. The third acft cleared to taxi into position did…NTSB SEA88LA030Accident · No injuriesLimited investigationFinal reportPiper PA-23-160 · Aurora, ORA single engine aircraft was taxiing from the south end of the ramp area to the runway. A twin engine aircraft entered the taxiway in front of the single engine aircraft from the right of the taxiway. The single engine aircraft struck the twin engine aircraft…NTSB CHI88LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Detroit, MIThe plt of north American P-51D, N6341T, was southbound on twy alpha as the plt of Piper PA-28 cherokee, N8253E, taxied from the run-up area to the hold line for rwy 33, which was near the intxn of twys alpha & india. The plt of the tail- wheel equipped P-51…NTSB MIA86LA257Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cedar Key, FLDuring taxi after landing the pilot taxied on a parallel roadway that had aircraft parked on it. The left wing of the aircraft struck two parked aircraft causing minor damage to them. The taxiing aircraft sustained substantial damage.NTSB LAX86LA356Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Monterey, CAThe private plt landed her acft & began taxiing toward a parking area. The driver of an acft fuel service truck observed the approaching acft, & he brought his truck to a complete stop in an authorized area for truck traffic. He was clear of the taxiway. The…NTSB FTW83LA434Accident · No injuriesLimited investigationFinal reportPiper PA-28-160 · Cresson, TXDuring arrival, the plt elected to land on an unlighted arpt. After landing & while slowing, the acft drifted to the left side of the rwy. Subsequently, the acft went over a concrete curb & the left main gear failed.NTSB SEA82DA150Accident · No injuriesFinal reportPiper PA-28-161 · Auburn, WAN1338J experienced a brake line failure and taxied into Piper PA-28, N8316A, that was parked in the warm-up area. There were no injuries.NTSB NYC82DA196Accident · No injuriesFinal reportPiper PA-28-161 · Wilkes Barre, PAThe student pilot stated that as he began to taxi, he proceeded about 35 ft and then the aircraft suddenly veered to the left as if the wheel had locked. He applied right rudder, then right brake. However, the aircraft struck a building and an automobile.NTSB LAX82DA112Accident · No injuriesFinal reportPiper PA-28-161 · Glendale, AZWhile taxiing for takeoff, the right wing of the aircraft collided with a sign that was located beside the taxiway.