Skip to content

NTSB investigations: Piper PA-28-180, MS

22 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

19662026

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" = 'MS' 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\" = 'MS' 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" = 'MS' 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 CEN19FA120Accident · 1 fatalClass 3 · FieldFinal reportPiper PA28 · Lake, MSThe noninstrument-rated pilot’s loss of control while flying in dark night instrument meteorological weather conditions with convective activity, which resulted in the airplane exceeding its structural limitations and experiencing an in-flight breakup.…Apr 13, 2019 · N4890L · Destroyed NTSB CEN19TA112Accident · Minor injuriesClass 3Final reportPiper PA28 · Aberdeen, MSThe pilot's failure to maintain directional control of the airplane during landing, which resulted in a collision with a fence and impact with terrain during the attempted aborted landing.Mar 29, 2019 · N8397W · Substantial damage NTSB ERA10LA306Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Lucedale, MSThe partial separation of the No. 3 cylinder due to improper torquing of the cylinder hold-down bolts by maintenance personnel during installation of the cylinder.Jun 8, 2010 · N5118L · Substantial damage NTSB DFW07CA213Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Tunica, MSThe pilot's failure to compensate for the existing wind conditions during a crosswind landing. A factor was the crosswind.Aug 15, 2007 · N7906W · Substantial damage NTSB ATL05CA102Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Luka, MSLoss of engine power due to the total failure of the exhaust valve on the number 2 cylinder, and the pilot's misjudgment of speed/distance/altitude which resulted in a overshoot of the runway and subsequent in-flight collision with trees. A factor was the…Jun 18, 2005 · N5TJ · Substantial damage NTSB MIA03LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Ocean Springs, MSA loss of engine power due to starvation as a result of the pilot's continued operation of an airplane with known deficiencies.Jun 16, 2003 · N8378W · Substantial damage NTSB MIA98LA186Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Holly Springs, MSThe pilot's inadequate in-flight decision with the miscalculation of the fuel consumption. Operating with an unreliable fuel gage was a contributing factor.Jun 18, 1998 · N8284W · Substantial damage NTSB ATL97LA084Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Columbus, MSinadequate maintenance/inspection and subsequent corrosion of the air filter, which resulted in pieces of the air filter to block the intake to the carburetor and result in loss of engine power. A factor relating to the accident was: failure of maintenance…Jun 5, 1997 · N7581W · Substantial damage NTSB MIA94LA036Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Tupelo, MSThe pilot-in-commands failure to monitor fuel consumption.Dec 5, 1993 · N2382T · Substantial damage NTSB MIA91LA028Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Inverness, MSThe student pilot's failure to refuel the airplane. Factors were: uel exhaustion, the pilot's lack of total aeronautical experience, and soft terrain.Nov 18, 1990 · N4820L · Substantial damage NTSB ATL81FLT03Accident · No injuriesClosedPiper PA-28 · Olive Branch, MSFeb 12, 1981 · N55784 · Substantial damage NTSB MIA78FKQ08Accident · Serious injuriesClosedPiper PA-28 · Nachez, MSApr 16, 1978 · N4350X · Substantial damage NTSB MIA78FLT01Accident · No injuriesClosedPiper PA-28 · Arkabutla, MSNov 11, 1977 · N15361 · Substantial damage NTSB MIA76FKQ06Accident · No injuriesClosedPiper PA-28 · Greenwood, MSAug 11, 1975 · N3656R · Substantial damage NTSB MIA75FKQ28Accident · Minor injuriesClosedPiper PA-28 · Marks, MSApr 23, 1975 · N3879R · Substantial damage NTSB MIA72FKQ06Accident · No injuriesClosedPiper PA-28 · Fulton, MSAug 15, 1971 · N9778J · Substantial damage NTSB MIA71FKQ23Accident · No injuriesClosedPiper PA-28 · Glen Allen, MSJan 23, 1971 · N5162S · Substantial damage NTSB MIA71DKQ21Accident · No injuriesClosedPiper PA-28 · Picayune, MSNov 26, 1970 · N7134W · Substantial damage NTSB MIA68D0150Accident · No injuriesClosedPiper PA-28 · Doloroso, MSAug 27, 1967 · N7258W · Substantial damage NTSB MIA67A0041Accident · 2 fatalClosedPiper PA-28 · Senatobia, MSSep 28, 1966 · N7878W · Destroyed NTSB MIA67D0148Accident · No injuriesClosedPiper PA-28 · Meridian, MSAug 31, 1966 · N7246W · Substantial damage NTSB MIA67F0142Accident · No injuriesClosedPiper PA-28 · Bruce, MSAug 27, 1966 · N7382W · Substantial damage