NTSB investigations: Piper PA-28-181, AL

10 cases on aircraft the registry lists as Piper PA-28-181. 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-181, AL per year, 1977–2026: 10 cases
1977	2
1981	2
1982	1
1983	1
1987	1
1988	1
1994	1
1999	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" = '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 ('7102807', '7102832')) 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 ('7102807', '7102832'))
  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 ('7102807', '7102832'))
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 MIA99LA170Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Auburn, ALThe pilot' failure to refuel the airplane prior to fuel exhaustion.Jun 9, 1999 · N983DB · Destroyed NTSB ATL94FA082Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Opelika, ALLoss of aircraft control for an unknown reason. Factors related to the accident were: the weather conditions (clouds with low ceiling), continued VFR flight by the pilot into instrument meteorological conditions (IMC), the pilot's lack of instrument…Apr 15, 1994 · N39770 · Destroyed NTSB ATL89FA222Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Alexander City, ALOn 10/31/88, the plt obtained wx info & filed an IFR flt plan fm vero beach, FL, to huntsville, AL. At aprx 1513 EST, hectcd ATC & rprtd climbing thru 1500' for 3000'. About 2.4 hrs later, he rprtd a loss of eng pwr. Vectors were provided toward an arpt, but…Nov 1, 1988 · N8211P · Substantial damage NTSB ATL88LA047Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Northport, ALBefore reaching the arpt, the eng lost power. Subsequently, the acft was damaged during an emerg landing on an embankment about 1.5 mi short of rwy 29. Only about 1 cup of fuel was found in each fuel tank. The plt thought there was about 12 gal of fuel…Nov 29, 1987 · N8121T · Substantial damage NTSB ATL84LA047Accident · No injuriesLimited investigationFinal reportPiper PA28-181 · Bessemer, ALThe acft collided with a station wagon while taxiing for takeoff during a purchaser demonstration flt. The prospective buyers were a husband and wife and the wife was occupying the left front seat with the CFI in the right seat. The CFI stated, that while…Nov 8, 1983 · N83816 · Substantial damage NTSB ATL83LA058Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Heflin, ALWhile on a pleasure flight the pilot experienced a fluctuation in his alternator indicator. Soon afterwards the alternator panel warning light came on. The pilot assumed his battery had gone dead after his radio lights also ceased to operate. At that point…Dec 10, 1982 · N22199 · Substantial damage NTSB ATL82DKJ01Accident · No injuriesClosedPiper PA-28 · Dothan, ALOct 7, 1981 · N22199 · Substantial damage NTSB ATL81DKJ33Accident · Minor injuriesClosedPiper PA-28 · Brundidge, ALAug 26, 1981 · N2155F · Substantial damage NTSB MIA78DKJ01Accident · No injuriesClosedPiper PA28 · Toxey, ALOct 5, 1977 · N3293Q · Substantial damage NTSB MIA77FKJ50Accident · Minor injuriesClosedPiper PA-28 · Talladega, ALJun 24, 1977 · N75041 · Substantial damage