NTSB investigations: Piper PA-28R-200, TN

12 cases on aircraft the registry lists as Piper PA-28R-200. 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

19732026

NTSB investigations: Piper PA-28R-200, TN per year, 1973–2026: 12 cases
1973	1
1974	1
1980	2
1981	1
1982	2
1988	1
1989	1
1997	1
2002	1
2003	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" = '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 ('7102811')) 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 ('7102811'))
  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 ('7102811'))
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 ATL03LA139Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Collegedale, TNA loss of engine power due to oil exhaustion as a result of the installation of the incorrect quick-drain valve that opened during flight.Sep 16, 2003 · N2310T · Substantial damage NTSB ATL03LA011Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Laurel Bloomery, TNThe pilot's failure to maintain clearance with terrain, which resulted in an inflight collision with mountainous terrain. Factors were the pilot's inadequate preflight planning and failure to obtain weather information, which resulted in an inflight encounter…Oct 31, 2002 · N15704 · Destroyed NTSB ATL97LA033Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lebanon, TNThe pilot's improper short, soft field takeof. A factor was the pilot's poor in-flight decision to operate over an overcast until near the airplane's maximum endurance.Jan 9, 1997 · N1434X · Substantial damage NTSB MIA90FA014Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Athens, TNLoss of control of the airplane in instrument flight conditions due to spatial disorientation, which resulted in an inadvertent descending spiral. Lack of total experience in the type of operation (actual instrument conditions) was considered to be a…Oct 18, 1989 · N5005S · Destroyed NTSB ATL88LA245Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Charleston, TNThe pilot reported that while in cruise flight he had a partial then total electrical failure. During the off- airport emergency landing on a wet, grassy field, the pilot was unable to stop before sliding into a culvert. Examination of the airplane revealed…Sep 4, 1988 · N1281T · Substantial damage NTSB ATL82DA264Accident · No injuriesFinal reportPiper PA-28R · Sewanee, TNEnroute the oil pressure dropped to zero & shortly thereafter the prop seized due to oil starvation. Post exam revealed a crack in the prop governor oil line, P/N76157, at the bend about 1 inch away from the "b" nut attaching the line to the elbow fitting at…Sep 3, 1982 · N4976S · Substantial damage NTSB ATL82FKW07Accident · Serious injuriesFinal reportPiper PA-28 · Hohenwald, TNOriginally, the pilot departed on a flight from olive branch, ms to lawrenceburg, TN. While en route, he became disoriented and landed at lafayette, TN. From there he proceeded to lawrenceburg via lebanon, TN. After departing lebanon, he became disoriented…Jun 2, 1982 · N1298T · Substantial damage NTSB ATL81FA097Accident · 3 fatalClosedPiper PA-28R · Sweetwater, TNJul 17, 1981 · N8348C · Destroyed NTSB ATL81DLT02Accident · No injuriesClosedPiper PA-28R · Reelfoot Lake, TNDec 13, 1980 · N2141T · Substantial damage NTSB ATL80FA074Accident · 2 fatalClosedPiper PA-28R · Reliance, TNJul 14, 1980 · N32036 · Destroyed NTSB IAD75AI034Accident · 3 fatalClosedPiper PA-28R · Toone, TNNov 30, 1974 · N5092S · Destroyed NTSB IAD74FKW19Accident · Minor injuriesClosedPiper PA-28R · Knoxville, TNOct 17, 1973 · N21LK · Substantial damage