NTSB investigations: Piper PA-28-161, LA

10 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

NTSB investigations: Piper PA-28-161, LA per year, 1977–2026: 10 cases
1977	1
1978	1
1980	1
1981	1
1982	1
1984	1
1985	1
1989	1
2010	1
2014	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" = 'LA' 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\" = 'LA' 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" = 'LA' 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 CEN14LA449Accident · No injuriesLimited investigationFinal reportPiper PA 28-161 · New Orleans, LAThe in-flight fatigue failure of the crankshaft gear retaining bolt, which resulted in a total loss of engine power. Contributing to the accident were the pilot/owner’s failure to maintain the airplane in accordance with an airworthiness directive following a…Aug 22, 2014 · N8440N · Substantial damage NTSB CEN10CA547Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Houma, LAThe pilot’s inadequate compensation for the crosswind while landing, which resulted in a loss of directional control.Sep 19, 2010 · N436ND · Substantial damage NTSB FTW89FA065Accident · 4 fatalField investigationFinal reportPiper PA-28-161 · New Orleans, LAThe pilot diverting his attention from flying the aircraft while complying with the departure control instructions, and allowing the aircraft to descend into the water.Mar 12, 1989 · N8369K · Destroyed NTSB FTW86LA021Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Amite, LAThe plt reported a loss of brake effectiveness while landing on a dew-covered sod strip. Unable to stop, the acft slid through a fence, damaging the wings.Oct 21, 1985 · N47558 · Substantial damage NTSB FTW84FA329Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Lake Charles, LAAt aprx 250 ft ag., according to witnesses, eng sounds indicated that power was reduced to idle. The acft rolled into a steep left descending turn followed by the application of power just prior to impact. The CFI was known to have given other students…Jul 30, 1984 · N4314D · Destroyed NTSB FTW82FRD13Accident · 2 fatalFinal reportPiper PA-28-161 · Lake Charles, LAThe plt told the surviving pax he was going to make a short fld takeoff with full (40 deg) flaps. The pax, who is also a plt, disagreed with the plt. The plt said it would be okay & proceeded to take off. During the takeoff roll the pax suggested he change…Jun 6, 1982 · N83006 · Destroyed NTSB FTW81DRJ09Accident · No injuriesClosedPiper PA-28 · Sterlington, LAJan 25, 1981 · N2232W · Substantial damage NTSB FTW81DRD02Accident · No injuriesClosedPiper PA-28 · Lake Charles, LAOct 11, 1980 · N2202W · Substantial damage NTSB FTW78FRJ30Accident · Serious injuriesClosedPiper PA-28 · Haynesville, LAAug 23, 1978 · N38392 · Destroyed NTSB FTW77FRD53Accident · No injuriesClosedPiper PA-28 · Leonville, LASep 27, 1977 · N1041Q · Substantial damage