Skip to content

NTSB investigations: Piper PA-28-180, MD

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

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" = 'MD' 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\" = 'MD' 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" = 'MD' 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 ERA21LA210Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Friendly, MDThe pilot’s failure to attain a proper touchdown point on landing, which resulted in a collision with the runway lip.Apr 28, 2021 · N32592 · Substantial damage NTSB ERA14LA404Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Gaithersburg, MDThe loss of engine power due to fuel starvation for reasons that could not be determined during postaccident examination of the fuel supply and fuel vent systems.Aug 23, 2014 · N9095J · Substantial damage NTSB IAD05LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Denton, MDA loss of engine power for undetermined reasons.Jul 18, 2005 · N4797L · Substantial damage NTSB NYC94LA022Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Centreville, MDThe loss of engine power for undetermined reasons.Oct 25, 1993 · N16493 · Destroyed NTSB BFO93FA129Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · California, MDThe pilot initiating VFR flight in instrument meteorological conditions. Factors which contributed to the accident were: the pilot's failure to obtain a weather briefing, his lack of sleep, and the existing weather conditions.Jul 1, 1993 · N5291L · Destroyed NTSB BFO88LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Annapolis, MDThe plt said he did a preflight inspection of the acft which included a check for water in the fuel. Tanks were partially full- 17 gals in each one. A pre-takeoff eng runup was normal. During the initial takeoff climb the eng had a partial power loss. After…Feb 21, 1988 · N32019 · Substantial damage NTSB NYC84LA281Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · White Marsh, MDThe acft was descended for aprx 7 miles at low power & slow rate for the landing at White Marsh arpt. The descent started at 2800 ft & continued straight in to rwy 27. At about 200 yds from the rwy & at 200 ft AGL the plt decided he needed power to land…Aug 18, 1984 · N44325 · Destroyed NTSB ATL83LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Westminster, MDThe plt stated that he intended to fly to a 1600 ft private strip with trees on both ends. During the approach, he had planned to make a full stop landing. However, after touchdown, he decided to make it a touch-and-go landing. After lift-off, he felt the…Jun 5, 1983 · N16402 · Substantial damage NTSB ATL80FIG16Accident · No injuriesClosedPiper PA-28 · Elkton, MDAug 21, 1980 · N7251W · Substantial damage NTSB IAD79FIG06Accident · Minor injuriesClosedPiper PA-28 · Oakland, MDMay 10, 1979 · N56112 · Substantial damage NTSB IAD75AI016Accident · No injuriesClosedCessna 172M · Indianhead, MDSep 26, 1974 · N20271 · 2 aircraft · Substantial damage NTSB IAD74FIA03Accident · No injuriesClosedPiper PA-28 · Newburg, MDAug 10, 1973 · N9096J · Substantial damage NTSB NYC73DIG02Accident · No injuriesClosedPiper PA-28 · Churchville, MDJul 4, 1972 · N8941J · Substantial damage NTSB NYC72AN119Accident · 1 fatalClosedPiper PA-28 · Laytonsville, MDMar 29, 1972 · N4353T · Destroyed NTSB IAD72AI003Accident · 1 fatalClosedPiper PA-28 · St.Michaels, MDJul 20, 1971 · N5298L · Destroyed NTSB IAD71FIG10Accident · No injuriesClosedPiper PA-28 · Chestertown, MDAug 31, 1970 · N6455J · Substantial damage NTSB DIA69F0207Accident · No injuriesClosedPiper PA-28 · Gaithersburg, MDMay 10, 1969 · N7705W · Substantial damage NTSB DIA69F0147Accident · No injuriesClosedPiper PA-28 · Laurel, MDFeb 25, 1969 · N9611J · Substantial damage NTSB DIA69A0001Accident · 1 fatalClosedPiper PA-28 · Chase, MDJul 5, 1968 · N9399J · Destroyed NTSB DIA68D0087Accident · No injuriesClosedPiper PA-28 · Laurel, MDOct 9, 1967 · N9611J · Substantial damage NTSB DIA68F0061Accident · Minor injuriesClosedPiper PA-28 · Laurel, MDAug 9, 1967 · N9399J · Substantial damage NTSB DIA67D0062Accident · No injuriesClosedPiper PA-28 · Westminster, MDFeb 24, 1967 · N8237W · Substantial damage NTSB DIA67D0041Accident · No injuriesClosedPiper PA-28 · Essex, MDFeb 11, 1967 · N7007J · Substantial damage NTSB DIA67F0014Accident · No injuriesClosedPiper PA-28 · Friendship, MDDec 10, 1966 · N7959W · Substantial damage NTSB NYC65A0141Accident · 4 fatalClosedPiper PA-28 · Granite, MDMay 26, 1965 · N6356W · 2 aircraft · Destroyed NTSB UNK64X4101Accident · No injuriesClosedPiper PA28 · Edgewater, MDSep 22, 1964 · N7747W · Substantial damage NTSB UNK64X2975Accident · No injuriesClosedPiper PA28 · Baltimore, MDJul 22, 1964 · N7735W · Substantial damage