Skip to content

NTSB investigations: Piper PA-28-235, OH

21 cases on aircraft the registry lists as Piper PA-28-235. 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" = 'OH' 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 ('7102810')) 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\" = 'OH' 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 ('7102810'))
  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" = 'OH' 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 ('7102810'))
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 CEN12CA032Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Radnor, OHThe pilot's failure to properly secure the engine controls prior to manually rotating the propeller, which led to an inadvertent engine start and runaway airplane.Oct 15, 2011 · N8746W · Substantial damage NTSB CEN12LA023Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Wadsworth, OHThe failure of the brake system during the landing roll, which was caused by a loss of hydraulic fluid as a result of a leak in the piston seal due to brake plates worn beyond their service limits.Oct 8, 2011 · N9444W · Substantial damage NTSB CHI08FA146Accident · 2 fatalField investigationFinal reportPiper PA28 · Hillsboro, OHThe pilot's failure to maintain control of the airplane due to an in-flight fire as a result of a corrosion hole in the muffler that was not identified by the mechanic. Contributing to the accident was the improper emergency procedure performed for an…May 30, 2008 · N9376W · Substantial damage NTSB NYC02LA151Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Kelleys Island, OHThe pilot-in-command's failure to obtain a proper touchdown point. A factor was the downdraft.Jul 28, 2002 · N15442 · Substantial damage NTSB IAD99LA053Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Zanesville, OHThe pilot not maintaining a proper descent rate and an inadequate flare.Jul 18, 1999 · N235TL · Substantial damage NTSB ATL89LA181Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Somerset, OHThe pilot's failure to adequately perform an airplane pre-flight inspection and drain water present in the airplane fuel supply. The airplane engine subsequently lost power due to the water contamination.Jul 19, 1989 · N8914W · Substantial damage NTSB ATL86LA170Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-235 · Middle Bass Is., OHHeavy rains had flooded the causeway that connected Middle Bass island to the main island. A family was in need of transportation off the island and the pilot was attempting to fly them to the mainland using the 2,100 foot grass airstrip. The airstrip was wet…Jun 15, 1986 · N9135W · Destroyed NTSB CHI82DA122Accident · Minor injuriesFinal reportPiper PA-28-235 · Graytown, OHDuring landing roll the aircraft contacted a soft area on the pilot's privately owned sod runway. The nose gear collapsed and the aircraft came to rest with the tail in the air.Apr 15, 1982 · N9010W · Destroyed NTSB CHI80FEK24Accident · Minor injuriesClosedPiper PA-28 · Bellefonatine, OHAug 13, 1980 · N8766W · Substantial damage NTSB CHI75FEI48Accident · No injuriesClosedPiper PA-28 · Akron, OHMay 9, 1975 · N9334W · Destroyed NTSB CHI74DEV51Accident · No injuriesClosedPiper PA-28 · Mansfield, OHMay 23, 1974 · N9365W · Substantial damage NTSB CHI73DEG04Accident · No injuriesClosedPiper PA-28 · West Union, OHAug 24, 1972 · N481P · Substantial damage NTSB CHI71FGG29Accident · No injuriesClosedPiper PA-28 · Columbus, OHMar 21, 1971 · N9081W · Substantial damage NTSB CHI71FGA18Accident · No injuriesClosedPiper PA-28 · Middletown, OHMar 4, 1971 · N8664W · Substantial damage NTSB CHI71DGG11Accident · No injuriesClosedPiper PA-28 · Columbus Grv, OHSep 6, 1970 · N8542W · Substantial damage NTSB CHI69D0204Accident · Minor injuriesClosedPiper PA-28 · Tiffin, OHJul 16, 1968 · N8658W · Substantial damage NTSB CHI68F0571Accident · No injuriesClosedPiper PA-28 · Bluffton, OHJan 18, 1968 · N8631W · Substantial damage NTSB CHI68D0040Accident · No injuriesClosedPiper PA-28 · Marengo, OHJun 28, 1967 · N8926W · Substantial damage NTSB CHI67F0299Accident · No injuriesClosedPiper PA-28 · Cleveland, OHOct 20, 1966 · N9022W · Substantial damage NTSB CHI67A0014Accident · 1 fatalClosedPiper PA-28 · Whitehall, OHSep 28, 1966 · N8613W · Destroyed NTSB UNK64X3211Accident · Minor injuriesClosedPiper PA28 · Sabina, OHAug 4, 1964 · N8502W · Substantial damage