NTSB investigations: Piper PA-28-161, OK

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

19812026

NTSB investigations: Piper PA-28-161, OK per year, 1981–2026: 12 cases
1981	4
1983	1
1984	1
1985	1
1986	1
2001	1
2002	1
2003	1
2006	1

Where

Open the map

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 ('7102803', '7102834')) 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 ('7102803', '7102834'))
  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 ('7102803', '7102834'))
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 DFW06CA132Accident · Minor injuriesData collectionFinal reportPiper PA-28-161 · Marietta, OKThe pilot's failure to maintain airspeed which resulted in an inadvertent stall. Contributing factors were the dark night conditions and the pilot's inadequate preflight planning and preparation.May 21, 2006 · N9419C · Substantial damage NTSB FTW04LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Henryetta, OKA loss of engine power due to fuel starvation. A contributing factor was the inadequate inflight planning procedures for a cross country flight.Oct 26, 2003 · N8090E · Substantial damage NTSB FTW02LA205Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Purcell, OKThe in-flight cabin fire as result of non-compliance with an AD and a Service Bulletin. A contributing factor to the accident was night conditions.Jul 14, 2002 · N96PF · Destroyed NTSB FTW01LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Ardmore, OKthe student pilot's failure to maintain directional control during takeoff roll.Aug 24, 2001 · N81833 · Substantial damage NTSB FTW86LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Lake Murray, OKThe pilot lost control of the aircraft prior to touchdown after the left wing dipped approximately four feet. The left gear touched down alongside the runway and the pilot made an attempt to go around but changed his mind when he saw a group of trees at the…Aug 17, 1986 · N8422M · Destroyed NTSB FTW85LA175Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Carney, OKPlt attempted to abort takeoff from grass strip mowed in pasture. Plt lost control and acft received substantial damage when it ran off rwy and collided with dirt bank rwy estimated to be between 1,000 ft to 1200 ft long.Apr 6, 1985 · N8052T · Substantial damage NTSB FTW84FA344Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Reed, OKArpt manager reported preflight discussion with plt concerning weather to south (intended direction of flight) but plt stated he didn't think there would be any trouble. Mgr observed acft takeoff and disappear into clouds to the south. Witnesses reported…Aug 11, 1984 · N3233Q · Destroyed NTSB FTW83LA355Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Cashion, OKThe plt was told that the sod strip was 1800 ft long. His calculated takeoff distance to clear a 50 ft obstacle was 1720 ft. however, the actual length of the sod strip ws 1300 ft. during the takeoff roll, the plt realized he would not be able to clear the 30…Jul 31, 1983 · N5999V · Substantial damage NTSB FTW82FPM05Accident · Serious injuriesClosedPiper PA-28 · Tulsa, OKNov 18, 1981 · N8307Z · Destroyed NTSB FTW81FPJ35Accident · Minor injuriesClosedPiper PA-28 · Oklahoma City, OKAug 22, 1981 · N3571E · Substantial damage NTSB FTW81FA128Accident · 3 fatalClosedPiper PA-28 · Mcalester, OKJul 30, 1981 · N2209Z · Destroyed NTSB FTW81DPM16Accident · No injuriesClosedPiper PA-28 · Afton, OKJul 20, 1981 · N39533 · Substantial damage