Skip to content

NTSB investigations: Piper PA-28-180, AR

25 cases on aircraft the registry lists as Piper PA-28-180. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19642026

Where

Latest cases

Query with SQL

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" = 'AR' 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 ('7102808')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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\" = 'AR' 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 ('7102808'))
  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" = 'AR' 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 ('7102808'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 CEN24LA189Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Hot Springs, ARThe student pilot’s selection of an improper fuel tank selector position, which resulted in fuel starvation and a total loss of engine power. Contributing to the accident was the instructor’s inadequate oversight.May 15, 2024 · N6571J · Destroyed NTSB CEN24LA108Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28-180 · Conway, ARThe student pilot's improper movement of the fuel selector to the OFF position, which resulted in fuel starvation and a total loss of engine power.Jan 31, 2024 · N2184T · Substantial damage NTSB CEN12FA072Accident · 4 fatalField investigationFinal reportPiper PA-28-180 · Perryville, ARThe pilot's loss of control in flight.Nov 17, 2011 · N7746W · Substantial damage NTSB CEN11LA441Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Flippin, ARThe loss of engine power due to improper maintenance and resultant oil starvation.Jul 1, 2011 · N56417 · Substantial damage NTSB FTW02LA075Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Berryville, ARthe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the sunglare.Jan 28, 2002 · N32194 · Substantial damage NTSB FTW96LA309Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mountain Home, ARfailure of the pilot to compensate for the tailwind and attain the proper touch down point. The tailwind was a related factor.Jul 17, 1996 · N55369 · Substantial damage NTSB FTW96LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Heber Springs, ARFailure of the pilot to maintain directional control of the airplane during transition from landing roll to taxi. A factor relating to the accident was: a soft area in the grass runway.Nov 16, 1995 · N6551J · Substantial damage NTSB FTW94LA259Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Booneville, ARThe proper touchdown point not obtained due to excessive airspeed during the approach and landing.Aug 3, 1994 · N7276W · Substantial damage NTSB MKC89LA022Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Mena, AROn left crosswind leg, during initial climb, the aircraft experienced a total loss of power. The acft had reached about 800 feet AGL and was about 1 1/2 miles from the departure end of the runway. An emergency ldg was attempted which resulted in substantial…Nov 11, 1988 · N9109J · Substantial damage NTSB MKC88FA021Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Mena, AROn the day of this accident, there was a well-publicized weather system affecting the weather along the pilot's route: warm moist gulf air was moving northward toward a cold front that extended from Mexico to Canada. Residents in the area said the region had…Nov 16, 1987 · N9131J · Destroyed NTSB MKC85LA041Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Stuttgart, ARPlt stated he had attempted an NDB approach to rwy 18 but executed a missed approach when he could not see the rwy when the acft was at 800 ft. the plt pitched the acft to a climb attitude and added full throttle. He continued to state that the acft felt…Dec 27, 1984 · N2320T · Substantial damage NTSB FTW78DPG27Accident · Minor injuriesClosedPiper PA-28 · Weiner, ARApr 28, 1978 · N8318W · Destroyed NTSB FTW76DPG42Accident · No injuriesClosedPiper PA-28 · Bay, ARFeb 24, 1976 · N7281W · Substantial damage NTSB FTW76AF043Accident · 2 fatalClosedPiper PA-28 · Lakeview, ARNov 9, 1975 · N56004 · Destroyed NTSB FTW71FPG50Accident · No injuriesClosedPiper PA-28 · Calico Rock, ARApr 23, 1971 · N5154L · Substantial damage NTSB FTW71FPG33Accident · No injuriesClosedPiper PA-28 · Jonesboro, ARJan 4, 1971 · N6348J · Substantial damage NTSB FTW70D0060Accident · No injuriesClosedPiper PA-28 · Wynne, ARJun 20, 1969 · N9376J · Substantial damage NTSB FTW68D0023Accident · No injuriesClosedPiper PA-28 · Nashville, ARJun 8, 1967 · N7130W · Substantial damage NTSB FTW67D0607Accident · No injuriesClosedPiper PA-28 · Harrison, ARMay 1, 1967 · N8122W · Substantial damage NTSB FTW67F0523Accident · No injuriesClosedPiper PA-28 · Tillar, ARMar 23, 1967 · N7331W · Substantial damage NTSB FTW67F0197Accident · No injuriesClosedPiper PA-28 · Hot Springs, ARSep 5, 1966 · N8157W · Substantial damage NTSB FTW67F0128Accident · Minor injuriesClosedPiper PA-28 · Berryville, ARJul 24, 1966 · N8038W · Substantial damage NTSB FTW66F0475Accident · No injuriesClosedPiper PA-28 · Fayetteville, ARJan 11, 1966 · N7832W · Substantial damage NTSB FTW66D0056Accident · No injuriesClosedPiper PA-28 · El Dorado, ARFeb 28, 1965 · N8011W · Substantial damage NTSB UNK64X3354Accident · Minor injuriesClosedPiper PA28 · Dequeen, ARAug 13, 1964 · N7467W · Destroyed