Skip to content

NTSB investigations: Piper PA-28-161, MN

18 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

19772026

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" = 'MN' 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\" = 'MN' 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" = 'MN' 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 CEN23LA141Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-161 · Maple Lake, MNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.Mar 19, 2023 · N9088D · Substantial damage NTSB GAA18CA092Accident · Minor injuriesData collectionFinal reportPiper PA28 · Mankato, MNThe student pilot’s improper landing flare, which resulted in a hard, bounced landing and subsequent go-around during which the student exceeded the airplane’s critical angle of attack, which resulted in an aerodynamic stall.Dec 20, 2017 · N284MK · Substantial damage NTSB CEN13CA550Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Princeton, MNAn in-flight collision with a bald eagle.Sep 13, 2013 · N526PU · Substantial damage NTSB CEN11LA183Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Minneapolis, MNThe pilot's loss of directional control during the landing.Feb 12, 2011 · N536PU · Substantial damage NTSB CEN09CA008Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Crookston, MNThe student pilot's failure to maintain directional control during landing. A contributing factor was the student pilot's limited flight experience. Additional factors were the presence of the ditch adjacent to the runway and the resulting collapse of the…Oct 1, 2008 · N251ND · Substantial damage NTSB CHI08CA285Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Lakeville, MNThe pilot's lack of clearance from the approach lights and the distraction of those bright approach lights during his night approach.Sep 18, 2008 · N4349K · Substantial damage NTSB CHI08CA265Accident · No injuriesData collectionFinal reportPiper PA-28-161 · New Ulm, MNThe failure of airport personnel to correct a hazardous condition on the airport. A factor was the uncovered manhole.Aug 24, 2008 · N523PU · Substantial damage NTSB CHI04LA173Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Waubun, MNThe pilot's failure to get the proper rest prior to the night cross country flight and the pilot's failure to maintain altitude. Contributing factors to the accident were fatigue as a result of inadequate sleep, conditions conducive to fatigue, and night.Jul 8, 2004 · N248ND · Substantial damage NTSB CHI02LA031Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · New Ulm, MNThe student and flight instructor not using all of the available runway, the inadequate supervision by the flight instructor and the unsuccessful remedial action by the flight instructor. The student not attaining the proper touchdown point and the plowed…Nov 6, 2001 · N523PU · Substantial damage NTSB CHI00LA154Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Minneapolis, MNthe failure of the engine and the unsuitable terrain for landing encountered by the pilot-in-command. Factors to the accident were the fracture of the crankshaft due to fatigue, excessive main bearing wear, and the swampy terrain condition.Jun 8, 2000 · N8189T · Substantial damage NTSB CHI96LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Warren, MNthe dual student's failure to maintain a proper glidepath and inadequate supervision by the instructor.Feb 13, 1996 · N145ND · Substantial damage NTSB MKC89LA193Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Chanhassen, MNEngine assembly dowell pin sheared causing total powerplant failure and inadequate visual lookout by the driver of the ground vehicle.Sep 5, 1989 · N8068C · Substantial damage NTSB CHI86FA033Accident · 3 fatalField investigationFinal reportPiper PA-28-161 · Duluth, MNThe pilot departed crystal lake for a flight to visit relatives for thanksgiving. He did not obtain a preflight weather briefing nor did he contact any ground facility during the flight. He was qualified to fly in VFR conditions only. The aircraft impacted…Nov 28, 1985 · N8082B · Destroyed NTSB CHI82DA351Accident · Serious injuriesFinal reportPiper PA-28-161 · Angle Inlet, MNJust after takeoff, the aircraft lost altitude and crashed beyond the departure end of the runway. The pilot stated that just after takeoff, the stall warning was heard. Also, he reported that when the aircraft reached an altitude of about 60 ft AGL, there…Sep 12, 1982 · N8067V · Substantial damage NTSB CHI82DA300Accident · No injuriesFinal reportPiper PA-28-161 · Brainerd, MNWhile on the landing roll, the engine quit operating and the pilot turned off onto a taxiway. He then attempted to restart the hot engine. During this time, smoke began coming from under the engine cowling. The pilot exited from the aircraft and noted a small…Aug 5, 1982 · N43745 · Substantial damage NTSB MKC79DER24Accident · Serious injuriesClosedPiper PA-28 · Lindstrom, MNFeb 12, 1979 · N9746K · Substantial damage NTSB MKC78DER54Accident · No injuriesClosedPiper PA-28 · Belle Plaine, MNJun 13, 1978 · N9062K · Substantial damage NTSB MKC78FER07Accident · No injuriesClosedPiper PA-28 · Anoka, MNNov 9, 1977 · N47350 · 2 aircraft · Substantial damage