Skip to content

NTSB investigations: Piper PA-28-180, OK

28 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

19652026

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" = 'OK' 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\" = 'OK' 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" = 'OK' 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 CEN13CA475Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Poteau, OKThe pilot’s application of excessive left rudder during the takeoff roll, resulting in a loss of directional control, his failure to correct the excursion with opposite rudder, and his failure to abort the takeoff in a timely manner.Aug 10, 2013 · N7811W · Substantial damage NTSB FTW01FA024Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Stillwater, OKthe pilot's failure to maintain altitude/clearance from terrain while performing an instrument approach. Contributing factors were the low ceiling, dark night light condition, the pilot's decision to fly in known adverse weather conditions, and his lack of an…Nov 23, 2000 · N3988R · Destroyed NTSB FTW00LA163Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Tulsa, OKthe loss of engine power for an undetermined reason. A contributing factor was the lack of suitable terrain for the forced landing.Jun 1, 2000 · N7271W · Substantial damage NTSB FTW92LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Mangum, OKThe pilot's failure to maintain proper airplane altitude. A factor was the dark night.Mar 8, 1992 · N8287W · Substantial damage NTSB FTW89FA096Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Boise City, OKAn inadvertent stall resulting from the pilot's failure to maintain control of the aircraft and to maintain sufficient airspeed. The dark night and adverse wind conditions were contributing factors.May 22, 1989 · N2211T · Destroyed NTSB FTW87LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28 · Kingfisher, OKThe pilot stated that he was demonstrating emergency landing procedures to the student pilot. At about 1000 AGL he instructed the student to apply full power for a go around. According to the pilot, the engine developed full power for about 30 sec. And…Feb 4, 1987 · N26RF · Substantial damage NTSB FTW83LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Guthrie, OKThe pilot said he was waiting for an acft to clear the rwy. As he started to turn downfield for takeoff he pushed the throttle in, advancing the power instead of retarding it. The aircraft crossed the runway at an angle, became airborne and hit a tree. The…Mar 18, 1983 · N6501J · Substantial damage NTSB FTW83LA057Accident · 1 fatalLimited investigationFinal reportPiper PA-28-180 · Grandfield, OKShortly after takeoff, a child, who had been allowed to occupy the baggage compartment during the takeoff, fell from the acft when the door opened in flight. The child's grandfather, who occupied the rear seat, allowed the youngster to climb into the baggage…Dec 12, 1982 · N9317J · No damage NTSB FTW82DA105Accident · No injuriesFinal reportPiper PA-28-180 · Norman, OKThe aircraft's engine quit 15 minutes short of the destination on a cross country flight. The aircraft had 36 gallons of fuel on departure at 1600 CST and the accident occurred at 1915. A forced landing was made on a street in Norman, Oklahoma.Mar 29, 1982 · N2153T · Substantial damage NTSB FTW79FPM14Accident · No injuriesClosedPiper PA-28 · Tahlequah, OKSep 13, 1979 · N7049W · Substantial damage NTSB FTW77FPM08Accident · No injuriesClosedPiper PA-28 · Henryetta, OKMay 3, 1977 · N7789N · Substantial damage NTSB FTW76FPM16Accident · No injuriesClosedPiper PA-28 · Founthead Park, OKMar 21, 1976 · N56651 · Substantial damage NTSB FTW76FPM14Accident · Minor injuriesClosedPiper PA-28 · Paden, OKFeb 25, 1976 · N32256 · Substantial damage NTSB FTW75DPJ23Accident · No injuriesClosedPiper PA-28 · Beaver, OKMay 27, 1975 · N5227L · Substantial damage NTSB FTW75FPM03Accident · Serious injuriesClosedPiper PA-28 · Hugo, OKAug 31, 1974 · N8978J · Destroyed NTSB FTW74AF078Accident · 3 fatalClosedPiper PA-28 · Honobia, OKMay 3, 1974 · N6449J · Destroyed NTSB FTW74FPM01Accident · No injuriesClosedPiper PA-28 · Stilwell, OKJul 25, 1973 · N15917 · Substantial damage NTSB FTW73AF034Accident · 2 fatalClosedPiper PA-28 · Octavia, OKDec 28, 1972 · N4899T · Destroyed NTSB FTW72DPJ32Accident · No injuriesClosedPiper PA-28 · Alva, OKFeb 13, 1972 · N3962R · No damage NTSB FTW71DPJ49Accident · No injuriesClosedPiper PA-28 · Oklahoma Cty, OKJun 24, 1971 · N7147W · Substantial damage NTSB FTW71FPM21Accident · No injuriesClosedPiper PA-28 · Tulsa, OKFeb 23, 1971 · N7729N · Substantial damage NTSB FTW71DPJ13Accident · No injuriesClosedPiper PA-28 · Hobart, OKAug 16, 1970 · N3462R · Substantial damage NTSB FTW68A0005Accident · 2 fatalClosedPiper PA-28 · Tonkawa, OKJul 16, 1967 · N8954J · Destroyed NTSB FTW67D0564Accident · No injuriesClosedPiper PA-28 · Wagoner, OKApr 21, 1967 · N8091W · Substantial damage NTSB FTW67D0377Accident · Serious injuriesClosedPiper PA-28 · Boise City, OKDec 26, 1966 · N9314J · Destroyed NTSB FTW67D0375Accident · No injuriesClosedPiper PA-28 · Enid, OKDec 24, 1966 · N8412W · Substantial damage NTSB FTW67F0225Accident · No injuriesClosedPiper PA-28 · Yukon, OKOct 5, 1966 · N9337J · Substantial damage NTSB UNK65X1220Accident · No injuriesClosedPiper PA28 · Weatherford, OKJan 3, 1965 · N7615W · Substantial damage