Skip to content

NTSB investigations: Piper PA-28-235, IN

19 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

19652026

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" = 'IN' 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\" = 'IN' 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" = 'IN' 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 CEN15LA216Accident · Minor injuriesLimited investigationFinal reportPiper PA 28-235 · Huntington, INThe pilot’s inadequate in-flight fuel management, which resulted in a total loss of engine power due to fuel starvation.May 4, 2015 · N8703W · Substantial damage NTSB CEN12CA415Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Richmond, INThe pilot’s failure to ensure that the fuel selector was properly positioned, which resulted in a total loss of engine power due to fuel starvation.Jun 24, 2012 · N8788W · Substantial damage NTSB CEN10CA118Accident · No injuriesData collectionFinal reportPiper PA-28-235 · Connersville, INThe pilot's failure to maintain directional control while landing on an ice- and slush-covered runway.Feb 11, 2010 · N8946W · Substantial damage NTSB CHI02LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Fulton, INA loss of engine power due to excessive clearance of the connecting rod bearing resulting in engine seizure. A related factor was the muddy field.Mar 31, 2002 · N9060W · Substantial damage NTSB CHI93LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Lafayette, INThe pilot-in-command's decision to initiate flight into known icing conditions which resulted in an accummulation of airframe ice. The icing conditions and the pilot's disregard of the weather advisory were factors.Feb 6, 1993 · N8784W · Substantial damage NTSB CHI86FA200Accident · 4 fatalField investigationFinal reportPiper PA-28-235 · Shelby, INThe non-instrument rated pilot initiated the VFR flight from wheeling, IL, to madison, IN, IN marginal weather conditions. The wreckage was found on the afternoon of the following day about 26 miles south of gary, IN. The aircraft sustained an in-flight…Aug 6, 1986 · N4383X · Destroyed NTSB CHI85LA205Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Valparaiso, INAcft contacted a ditch following a loss of directional control during landing roll. Plt reported, 'more experience in handling crosswinds' could have prevented the accident.May 22, 1985 · N8521N · Substantial damage NTSB CHI76DETE5Accident · No injuriesClosedPiper PA-28 · Griffith, INJul 20, 1976 · N9458W · Substantial damage NTSB CHI76FET35Accident · No injuriesClosedPiper PA-28 · Fort Wayne, INMay 22, 1976 · N9236W · Substantial damage NTSB CHI72DET26Accident · No injuriesClosedPiper PA-28 · Syracuse, INMay 16, 1972 · N8733W · Substantial damage NTSB CHI70FBM09Accident · Minor injuriesClosedPiper PA-28 · Warsaw, INMar 30, 1970 · N9425W · 2 aircraft · Substantial damage NTSB CHI70AC056Accident · 1 fatalClosedPiper PA-28 · Gary, INFeb 23, 1970 · N9110W · Destroyed NTSB CHI70D0302Accident · No injuriesClosedPiper PA-28 · Hartford City, INNov 6, 1969 · N8587W · Substantial damage NTSB CHI69F0552Accident · No injuriesClosedPiper PA-28 · Ft.Wayne, INMar 1, 1969 · N8926W · Substantial damage NTSB CHI68D0616Accident · No injuriesClosedPiper PA-28 · Lafayette, INFeb 24, 1968 · N8537W · Substantial damage NTSB CHI68D0626Accident · No injuriesClosedPiper PA-28 · Sunman, INFeb 14, 1968 · N8777W · Substantial damage NTSB CHI68F0280Accident · No injuriesClosedPiper PA-28 · Angola, INAug 4, 1967 · N8769W · Substantial damage NTSB CHI66D0228Accident · No injuriesClosedPiper PA-28 · Chesterton, INAug 25, 1965 · N8606W · Substantial damage NTSB CHI66F0185Accident · No injuriesClosedPiper PA-28 · Culver, INAug 18, 1965 · N9060W · Substantial damage