Skip to content

NTSB investigations: Piper PA-28-180, TN

35 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" = 'TN' 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\" = 'TN' 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" = 'TN' 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 ERA24LA020Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Jackson, TNThe pilot’s failure to maintain directional control during the landing roll in gusting wind conditions, which resulted in a runway excursion.Oct 20, 2023 · N9101J · Substantial damage NTSB ERA23LA347Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Knoxville, TNAn in-flight fire that resulted from an inadequate 100-hr inspection, which failed to detect and correct improper electrical cable routing in the engine compartment.Jul 27, 2023 · N15417 · Substantial damage NTSB ERA23LA264Accident · Minor injuriesClass 3 · LimitedFinal reportPiper PA28 · Lancaster, TNThe fatigue failure of an exhaust valve, resulting in a partial loss of engine power.May 21, 2023 · N9139J · Substantial damage NTSB ERA21LA273Accident · Minor injuriesClass 4 · LimitedFinal reportPiper PA-28-180 · Woodland, TNThe student pilot’s inadequate monitoring of his fuel state during a solo training flight, which resulted in fuel starvation, a total loss of engine power, and a forced landing.Jun 28, 2021 · N818TF · Substantial damage NTSB GAA17CA096Accident · No injuriesData collectionFinal reportPiper PA28 · Madisonville, TNThe student pilot’s failure to maintain directional control during landing with a gusting crosswind.Dec 15, 2016 · N7646W · Substantial damage NTSB ERA10FA020Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Oliver Springs, TNThe pilot's loss of directional control while landing on a wet turf runway, which resulted in a runway excursion and collision with a tree.Oct 18, 2009 · N7906W · Substantial damage NTSB NYC08CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Fairview, TNA loss of engine power due to fuel exhaustion.Oct 3, 2007 · N7751N · Substantial damage NTSB ATL99LA104Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Chuckey, TNThe loss of engine power for undetermined reasons.Jul 4, 1999 · N9361J · Substantial damage NTSB MIA99LA058Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Knoxville, TNThe engines excessive fuel consumption for undetermined reasons and the pilot's failure to plan the flight with adequate fuel reserves resulting in engine failure due to fuel exhaustion.Dec 26, 1998 · N32679 · Substantial damage NTSB MIA98FA010Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Knoxville, TNfailure of the pilot to maintain control of the airplane, while climbing after takeoff, which resulted in an uncontrolled descent and impact with the water.Oct 12, 1997 · N15331 · Destroyed NTSB ATL91LA028Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Humboldt, TNThe student pilot's failure to maintain directional control during landing. A factor was the student's lack of recent experience.Dec 8, 1990 · N7634W · Substantial damage NTSB ATL85FLT05Accident · Minor injuriesFinal reportPiper PA-28-180 · Arlington, TNThe acft overran the rwy during landing and contacted a ditch. A left quartering tailwind was present at the time of the landing.Apr 20, 1985 · N7406W · Substantial damage NTSB ATL84FA054Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Lexington, TNThe acft collided with the ground in a vertical descent during IMC weather on a x-country flt. The plt had filed an IFR flt plan but he was a student with limited experience and was not instrument rated. Also he was carrying a passenger. The controller who…Nov 27, 1983 · N5396L · Destroyed NTSB IAD76FKW37Accident · No injuriesClosedPiper PA-28 · Blountville, TNSep 7, 1976 · N56405 · Substantial damage NTSB IAD76DKW35Accident · Minor injuriesClosedPiper PA-28 · Bluff City, TNJul 11, 1976 · N7402W · Destroyed NTSB IAD76FKW33Accident · No injuriesClosedPiper PA-28 · Powells Xroads, TNMay 27, 1976 · N5053T · Substantial damage NTSB IAD76FKW24Accident · Minor injuriesClosedPiper PA-28 · Murfreesboro, TNMar 19, 1976 · N5270L · Substantial damage NTSB IAD76AI048Accident · 1 fatalClosedPiper PA-28 · Nashville, TNJan 11, 1976 · N7842W · Destroyed NTSB IAD75DLT13Accident · Minor injuriesClosedPiper PA-28 · Bells, TNJun 29, 1975 · N7382W · Substantial damage NTSB IAD75AI039Accident · 1 fatalClosedPiper PA-28 · Chattanooga, TNJan 9, 1975 · N2066R · Destroyed NTSB IAD74AI040Accident · 4 fatalClosedPiper PA-28 · Speedwell, TNFeb 3, 1974 · N4888L · Destroyed NTSB IAD74AI031Accident · 3 fatalClosedPiper PA-28 · Jamestown, TNDec 1, 1973 · N8477W · Destroyed NTSB MIA73FKW14Accident · No injuriesClosedPiper PA-28 · Chuckey, TNDec 31, 1972 · N8032W · Substantial damage NTSB MIA72DKW14Accident · No injuriesClosedPiper PA-28 · Winfield, TNJan 15, 1972 · N8477W · Substantial damage NTSB MIA72AM068Accident · 2 fatalClosedPiper PA-28 · Oliver Sps, TNJan 9, 1972 · N5323L · Destroyed NTSB MIA71AM110Accident · 2 fatalClosedPiper PA-28 · Murfreesboro, TNJun 9, 1971 · N5115L · Destroyed NTSB MIA71DKW13Accident · No injuriesClosedPiper PA-28 · Crossville, TNSep 13, 1970 · N4905L · Substantial damage NTSB MIA69A0061Accident · 4 fatalClosedPiper PA-28 · Crossville, TNMar 29, 1969 · N5150L · Destroyed NTSB MIA68F0154Accident · No injuriesClosedPiper PA-28 · Dayton, TNSep 2, 1967 · N7904W · Substantial damage NTSB MIA68F0023Accident · No injuriesClosedPiper PA-28 · Doyle, TNJul 2, 1967 · N9146J · Substantial damage NTSB MIA67F0166Accident · No injuriesClosedPiper PA-28 · Bristol, TNSep 2, 1966 · N7866W · Substantial damage NTSB MIA67A0022Accident · 2 fatalClosedPiper PA-28 · Greenville, TNAug 10, 1966 · N9236J · Destroyed NTSB MIA66F0329Accident · No injuriesClosedPiper PA-28 · Columbia, TNNov 25, 1965 · N7918W · Substantial damage NTSB UNK64X1895Accident · No injuriesClosedPiper PA28 · Madison, TNMay 23, 1964 · N7104W · Substantial damage NTSB UNK64X0597Accident · No injuriesClosedPiper PA28 · Chattanooga, TNFeb 17, 1964 · N7422W · Substantial damage