NTSB investigations: Piper PA-28-181, NE

8 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases per year

19782026

NTSB investigations: Piper PA-28-181, NE per year, 1978–2026: 8 cases
1978	1
1985	1
1987	2
1994	2
2013	1
2015	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" = 'NE' 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

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\" = 'NE' 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" = 'NE' 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

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 GAA15CA261Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Lexington, NEThe pilot's improper fuel planning which resulted in fuel exhaustion, and loss of engine power. Additionally, the pilot's failure to maintain pitch control during the emergency landing, which resulted in an aerodynamic stall.Sep 13, 2015 · N121LK · Substantial damage NTSB CEN14CA063Accident · No injuriesData collectionFinal reportPiper PA 28-181 · Burwell, NEAn inadvertent collision with a deer during landing.Nov 18, 2013 · N30260 · Substantial damage NTSB CHI94LA174Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Weeping Water, NEthe pilot-in-command's misjudging compensation for wind conditions. Factors were tailwind, and wind information confusing.May 25, 1994 · N2331M · Substantial damage NTSB CHI94LA149Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Chapman, NEThe pilot-in-command's attempted VFR flight into instrument weather conditions which resulted in spatial disorientation. Factors associated with the accident were the pilot-in-command's over confidence in his personal ability.May 6, 1994 · N2938Q · Destroyed NTSB MKC87LA140Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Adams, NEAfter a normal approach and landing on a private sod strip, the pilot stated the aircraft swerved to the left of the runway to an adjoining plowed field. The aircraft struck a large hay bale followed by a large mound of dirt. Post accident investigation…Jul 15, 1987 · N8097S · Substantial damage NTSB MKC87FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Valley, NEAt aprx 2020 CDT, witnesses saw the acft as the plt made svrl low passes over the platte river near Valley, NE. On the last pass, the acft struck power lines, then crashed in the river. The wreckage came to rest in the main channel of the river in aprx 25 ft…Apr 26, 1987 · N1145Q · Destroyed NTSB MKC85LA129Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Ogallala, NEPlt reports that the eng quit due to fuel exhaustion. The power loss occurred 2 hrs. After t/o, 3 mi from dest. Plt had to maneuver around obstacle in field during landing and landed hard.Jun 13, 1985 · N83815 · Substantial damage NTSB MKC78FA046Accident · 1 fatalClosedPiper PA-28 · Omaha, NEJun 4, 1978 · N1790H · Destroyed