NTSB investigations: Piper PA-28-181, NJ

12 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

19762026

NTSB investigations: Piper PA-28-181, NJ per year, 1976–2026: 12 cases
1976	1
1977	1
1978	1
1986	1
1989	1
1996	1
1997	1
2009	1
2023	1
2024	2
2026	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" = 'NJ' 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\" = 'NJ' 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" = 'NJ' 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 ERA27LA021Accident · Serious injuriesClass 3 · LimitedInvestigation openPiper PA-28-181 · Medford, NJOct 23, 2026 · N43956 NTSB ERA25LA092Accident · No injuriesClass 4 · LimitedFinal reportCessna 172M · Englishtown, NJThe high wing airplane flight crew’s failure to maintain directional control while taxiing, which resulted in a collision with the stationary low wing airplane.Dec 14, 2024 · N9137H · 2 aircraft · Substantial damage NTSB ERA24LA369Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA-28-181 · Somerville, NJA total loss of engine power due to an undetermined fuel delivery issue.Sep 4, 2024 · N512AF · Substantial damage NTSB ERA23LA296Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-181 · Lumberton, NJThe student pilot’s improper flight control inputs and the flight instructor’s delayed remedial action during takeoff, which resulted in a runway excursion and impact with the runway edge lights.Jun 10, 2023 · N8126X · Substantial damage NTSB ERA09CA322Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Caldwell, NJThe pilot’s failure to maintain directional control of the airplane during landing. Contributing to the accident was the pilot’s failure to ensure that he could operate the rudder pedals without interference.May 31, 2009 · N811SA · Substantial damage NTSB NYC97LA142Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Jersey City, NJThe pilot's mismangement of the fuel supply, by which he failed to switched fuel tanks, which resulted in fuel starvation and the loss of engine power.Jul 13, 1997 · N84611 · Substantial damage NTSB NYC96FA158Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Sea Bright, NJthe pilot's continued VFR flight into instrument meteorological conditions (IMC), and his failure to maintain control of the airplane, due to spatial disorientation, which resulted in a collision with water. Factors relating to the accident were the pilot's…Jul 24, 1996 · N84280 · Destroyed NTSB NYC89LA104Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Pittstown, NJImproper inflight planning which led to engine failure due to fuel exhaustion.Mar 24, 1989 · N4385L · Destroyed NTSB NYC86LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Matawan, NJThe local sightseeing flight departed marlboro airport at about 1300 hours and returned at about 1400 hours. Entered pattern downwind and flew a normal pattern and approach. During flare, the aircraft was hit by a gust of wind. After touchdown and during…Apr 20, 1986 · N47355 · Substantial damage NTSB NYC78FHA20Accident · No injuriesClosedPiper PA-28 · Pittstown, NJApr 29, 1978 · N3614M · Substantial damage NTSB NYC77FA071Accident · 1 fatalClosedPiper PA-28 · Ocean City, NJJul 9, 1977 · N4257Q · Substantial damage NTSB NYC76FHD39Accident · Serious injuriesClosedPiper PA-28 · W Deptford, NJAug 21, 1976 · N4336F · Destroyed