Skip to content

NTSB investigations: Piper PA-28-180, LA

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

19652026

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" = '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 ('7102808')) 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 ('7102808'))
  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 ('7102808'))
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 CEN21LA089Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Bossier City, LAThe student pilot’s decision to conduct a flight during night instrument meteorological conditions and his loss of airplane control due to spatial disorientation. Contributing to the accident was the student pilot’s use of an amphetamine and his attention…Dec 16, 2020 · N55168 · Destroyed NTSB CEN20LA199Accident · 2 fatalClass 3 · LimitedFinal reportPiper PA28 · Pineville, LAThe airplane’s inability to gain sufficient airspeed after takeoff due to it being at or over its maximum gross weight, which resulted in a loss of control. Contributing to the accident was the pilot’s decision to operate the airplane at or over its maximum…May 31, 2020 · N6461J · Substantial damage NTSB CEN14TA421Accident · Minor injuriesFinal reportPiper PA 28-180 · Sulphur, LAThe pilot’s failure to properly manage the airplane’s fuel supply, which led to fuel starvation and a total loss of engine power.Aug 8, 2014 · N4286T · Substantial damage NTSB CEN10LA476Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Winnfield, LAA loss of engine power due to fuel exhaustion.Aug 12, 2010 · N9507J · Substantial damage NTSB CEN10LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Alexandria, LAA loss of engine power for undetermined reasons.Dec 27, 2009 · N7230W · Substantial damage NTSB DFW05FA028Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Hammond, LAA loss of engine power due to the pilot's in-flight mismanagement of the available fuel supply by his failure to switch fuel tank position, which resulted in fuel starvation. Factors were the low ceilings and the prevailing dark night conditions.Dec 6, 2004 · N4750L · Destroyed NTSB FTW98LA138Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Monroe, LAThe pilot's improper decision to continue the flight after noting the low fuel quantity indication, which resulted in the loss of engine power due to fuel exhaustion. A factor was the lack of suitable terrain for the forced landing.Feb 27, 1998 · N7998W · Substantial damage NTSB FTW97LA080Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Baton Rouge, LAfuel exhaustion due to the pilot's failure to refuel. A factor was the lack of suitable terrain for the forced landing.Jan 12, 1997 · N33037 · Substantial damage NTSB FTW93LA042Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · New Orleans, LALoss of engine power due to fuel exhaustion. Factors were the inaccurate fuel consumption calculations and the unsuitable terrain.Nov 26, 1992 · N15813 · Substantial damage NTSB FTW79FRD29Accident · No injuriesClosedPiper PA-28 · Patterson, LAMay 16, 1979 · N9301J · Substantial damage NTSB FTW77FA035Accident · 3 fatalClosedPiper PA-28 · Baton Rouge, LAFeb 12, 1977 · N4493T · Destroyed NTSB FTW76FRD27Accident · No injuriesClosedPiper PA-28 · Church Point, LAJan 19, 1976 · N57312 · Substantial damage NTSB FTW75DRJ31Accident · No injuriesClosedPiper PA-28 · Many, LAApr 17, 1975 · N1467T · Substantial damage NTSB FTW75DRD21Accident · No injuriesClosedPiper PA-28 · Lockport, LADec 26, 1974 · N5413S · Substantial damage NTSB FTW74AF036Accident · 1 fatalClosedPiper PA-28 · Slidell, LANov 22, 1973 · N6629J · Destroyed NTSB FTW72DRD19Accident · No injuriesClosedPiper PA-28 · Merryville, LAFeb 6, 1972 · N7736W · Substantial damage NTSB FTW71AF030Accident · 3 fatalClosedPiper PA-28 · Winnsboro, LADec 10, 1970 · N2429R · Destroyed NTSB FTW71DRD22Accident · No injuriesClosedPiper PA-28 · Plaquemine, LAOct 20, 1970 · N3951R · Substantial damage NTSB FTW70DRJ08Accident · No injuriesClosedPiper PA-28 · Hornbeck, LAApr 30, 1970 · N7723N · Substantial damage NTSB FTW70F0129Accident · Minor injuriesClosedPiper PA-28 · St.Martinville, LAJul 10, 1969 · N4916L · Substantial damage NTSB FTW69F0457Accident · No injuriesClosedPiper PA-28 · Abbeville, LAApr 25, 1969 · N9754J · Substantial damage NTSB FTW69F0290Accident · No injuriesClosedPiper PA-28 · Natchitoches, LAOct 30, 1968 · N6541J · Substantial damage NTSB FTW67D0397Accident · No injuriesClosedPiper PA-28 · Bogalusa, LADec 27, 1966 · N7866W · Substantial damage NTSB FTW67F0080Accident · Minor injuriesClosedPiper PA-28 · Dubach, LAJun 25, 1966 · N9041J · Destroyed NTSB FTW66F0376Accident · No injuriesClosedPiper PA-28 · Lafayette, LANov 5, 1965 · N7000W · Substantial damage NTSB FTW66D0260Accident · No injuriesClosedPiper PA-28 · Baton Rouge, LAJul 10, 1965 · N8245W · Substantial damage NTSB UNK65X1435Accident · No injuriesClosedPiper PA-28 · Lake Charles, LAFeb 18, 1965 · N7300W · Substantial damage