Skip to content

NTSB investigations: Piper PA-28-180, AL

23 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

19642026

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" = 'AL' 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\" = 'AL' 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" = 'AL' 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 ERA23LA232Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Selma, ALThe pilot’s improper preflight inspection, during which the left wing fuel sump drain was moved to and left in the open and locked position, allowing for fuel to drain during the flight and resulting in a total loss of engine power due to fuel starvation.…May 12, 2023 · N1347T · Substantial damage NTSB ERA23LA029Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28 · Montgomery, ALThe student pilot’s improper landing flare, which resulted in a hard landing.Oct 14, 2022 · N11NT · Substantial damage NTSB ERA18LA041Accident · No injuriesLimited investigationFinal reportPiper PA28 · Brewton, ALThe pilot's inadequate fuel management, which resulted in a total loss of engine power due to fuel starvation.Dec 5, 2017 · N747KM · Substantial damage NTSB ERA15CA064Accident · Serious injuriesData collectionFinal reportPiper PA 28-180 · Athens, ALThe pilot's failure to maintain adequate altitude while landing in gusty wind conditions, which resulted in a collision with power lines while on final approach.Nov 30, 2014 · N7422W · Substantial damage NTSB ERA12LA253Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Margaret, ALThe pilot's inadequate in-flight fuel management, which resulted in a total loss of engine power during cruise flight due to fuel starvation.Mar 24, 2012 · N7309W · Substantial damage NTSB ERA11CA127Accident · No injuriesData collectionFinal reportPiper PA28 · Monroeville, ALThe pilot's failure to maintain directional control during the landing rollout.Jan 26, 2011 · N9742J · Substantial damage NTSB ATL03LA148Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Talladega, ALThe pilot's failure to use carburetor heat when weather conditions were favorable for carburetor icing.Sep 29, 2003 · N2342T · Substantial damage NTSB MIA96FA233Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Birmingham, ALThe pilot-in-command's improper in-flight planning/decision for electing to continue the flight after observing that the fuel gauges indicated empty. Contributing to the accident was an improperly adjusted economizer jet and an out of adjustment float. Also…Sep 27, 1996 · N8803J · Substantial damage NTSB ATL80DKJ27Accident · Minor injuriesClosedPiper PA-28 · Ashville, ALAug 22, 1980 · N4520T · Substantial damage NTSB MIA76AM079Accident · 3 fatalClosedPiper PA-28 · Dauphin Island, ALApr 23, 1976 · N2894T · Destroyed NTSB MIA76FKJ19Accident · Minor injuriesClosedPiper PA-28 · Clanton, ALSep 1, 1975 · N16252 · Substantial damage NTSB MIA76DKJ03Accident · Minor injuriesClosedPiper PA-28 · Luverne, ALJul 11, 1975 · N7638W · Substantial damage NTSB FTW73AF036Accident · 2 fatalClosedPiper PA-28 · Prattville, ALJan 3, 1973 · N2334R · Destroyed NTSB MIA72AM085Accident · 2 fatalClosedPiper PA-28 · Wing, ALFeb 26, 1972 · N4717L · Destroyed NTSB MIA70DKJ24Accident · No injuriesClosedPiper PA-28 · Catherine, ALApr 9, 1970 · N5395L · Substantial damage NTSB MIA69D0487Accident · No injuriesClosedPiper PA-28 · Laceys Spring, ALApr 25, 1969 · N7931W · Substantial damage NTSB MIA68D0107Accident · No injuriesClosedPiper PA-28 · Fairhope, ALJun 25, 1967 · N9458J · Substantial damage NTSB MIA67D0462Accident · No injuriesClosedPiper PA-28 · Courtland, ALJan 19, 1967 · N7189W · Substantial damage NTSB MIA67A0055Accident · 2 fatalClosedPiper PA-28 · Greenville, ALNov 1, 1966 · N7802W · Destroyed NTSB MIA67F0167Accident · Minor injuriesClosedPiper PA-28 · Auburn, ALAug 25, 1966 · N8118W · Substantial damage NTSB MIA67F0085Accident · Serious injuriesClosedPiper PA-28 · Cullman, ALAug 3, 1966 · N8030W · Substantial damage NTSB MIA66F0298Accident · No injuriesClosedLockheed T-33 · Montgomery, ALOct 12, 1965 · AF80632 · 2 aircraft · Substantial damage NTSB UNK64X4217Accident · No injuriesClosedPiper PA-28 · Fairhope, ALSep 30, 1964 · N7683W · Substantial damage