NTSB investigations: Piper PA-28-140, GA

6 cases on aircraft the registry lists as Piper PA-28-140, where the first occurrence was “In flight collision with object”. 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.

Cases per year

19822026
NTSB investigations: Piper PA-28-140, GA per year, 1982–2026: 6 cases
19822
19851
19921
19961
20041

Latest cases

Query with SQL
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\" = 'GA' 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 ('7102802')
      AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
  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.

NTSB ATL04LA150Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-140 · Cumming, GAThe pilot's failure to obtain takeoff performance data, and his intentional takeoff from a closed and short runway which resulted in an in-flight collision with a tree.Jul 10, 2004 · N56776 · Substantial damageNTSB MIA96LA147Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Barbour Island, GAthe pilot's failure to adequately compensate for gusty wind conditions.May 31, 1996 · N6351W · Substantial damageNTSB ATL92FA076Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Young Harris, GAThe failure of the pilot to maintain clearance from terrain. Factors in the accident were the dark night, rain, and mountainous terrain.Apr 12, 1992 · N7248J · DestroyedNTSB ATL85LKG06Accident · Serious injuriesFinal reportPiper PA-28-140 · Brooklet, GAThe plt stated that 2 approaches were made to rwy 09 and he could not locate a wind indicator. He was also unable to contact anyone over the UNICOM to obtain wind information. The plt attempted a landing on rwy 09 during which the acft bounced and a go-around…May 25, 1985 · N32826 · DestroyedNTSB ATL82DA090Accident · No injuriesFinal reportPiper PA-28-140 · Hazlehurst, GAThe pilot made a successful precautionary landing after becoming disoriented due to problems with his communication and navigation radios. After finding out his location he attempted to depart from a soft field covered with tall grass that was approximately…Apr 1, 1982 · N1360H · Substantial damageNTSB ATL82FLA01Accident · Serious injuriesFinal reportPiper PA-28-140 · Hoboken, GAThe pilot reported that during takeoff, he accelerated to 68 mph, then realized he would be unable to clear trees. He stated that he closed the throttle and mixture, aimed the aircraft at an opening in the trees, and maintained a level attitude until impact.…Mar 23, 1982 · N5841U · Destroyed