Skip to content

NTSB investigations: Piper PA-28-161, OH

15 cases on aircraft the registry lists as Piper PA-28-161. 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 ('7102803', '7102834')) 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 ('7102803', '7102834'))
  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 ('7102803', '7102834'))
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 GAA19CA104Accident · No injuriesData collectionFinal reportPiper PA28 · Bowling Green, OHThe student pilot's failure to maintain directional control upon touchdown, which resulted in a runway excursion and impact with a ditch.Jan 6, 2019 · N282BG · Substantial damage NTSB NYC01LA042Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Fremont, OHThe pilot's failure to obtain a proper touchdown point while landing. Factors were the pilot's improper weather evaluation, rain, a low ceiling, and a tailwind.Nov 25, 2000 · N1305H · Substantial damage NTSB NYC00LA149Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Miamisburg, OHThe CFI's delayed remedial action.Jun 2, 2000 · N8234L · Substantial damage NTSB NYC95LA128Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Bluffton, OHan improperly planned approach and touchdown, which resulted in an loss of directional control at touchdown, with the airplane departing the runway, and striking a ravine.May 31, 1995 · N8115L · Substantial damage NTSB NYC93LA014Accident · No injuriesLimited investigationFinal reportPiper PA28-161 · St. Clairsville, OHThe pilot's improper in-flight planning and decision to land on a short grass runway with a tail wind. A factor in this accident was the pilots failure to obtain and evaluate a weather briefing prior to the flight.Oct 10, 1992 · N8333T · Substantial damage NTSB BFO92LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Dayton, OHAn encounter with a strong wind gust which resulted in loss of control and nose over.Jul 16, 1992 · N8432R · Substantial damage NTSB ATL89LA105Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tiffin, OHThe pilots improper recovery from a bounced landing which led to inadvertent porpoising and loss of directional control.Mar 13, 1989 · N2122J · Substantial damage NTSB ATL88LA177Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-161 · Lebanon, OHThe plt was making an apch for a full stop ldg with a quartering right tailwind. He stated that he had been previously told to always land on rwy 27 and takeoff from runway 09 at this apt. Witnesses indicated that the airplane touched down about half way down…May 19, 1988 · N69161 · Substantial damage NTSB CHI84LA337Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Manchester, OHThe accident occurred when the pilot was flying low on a fly-by for photographs. Adjusting her seat, the passenger hit the control yoke, the aircraft pitched down and collided with a tree. The pilot recovered control and completed a safe landing at an airport…Aug 12, 1984 · N3573C · Substantial damage NTSB CHI83FA267Accident · 2 fatalField investigationFinal reportPiper PA28-161 · Cambridge, OHThe acft collided with the ground during a night flt after the plt encountered weather according to the radio transmissions to cleveland center. His statements were 'what have you got me into' and 'what are we into here' when asked by cleveland if he was into…Jun 20, 1983 · N2405U · Destroyed NTSB CHI81FA084Accident · 1 fatalClosedPiper PA-28 · Millbury, OHAug 4, 1981 · N8145N · Destroyed NTSB CHI81FEG11Accident · Serious injuriesClosedPiper PA-28 · New Lebanon, OHMay 2, 1981 · N38212 · Destroyed NTSB CHI80FEG24Accident · Minor injuriesClosedPiper PA-28 · Xenia, OHSep 28, 1980 · N6501C · Substantial damage NTSB CHI80FA033Accident · 3 fatalClosedPiper PA-28 · Medina, OHMar 29, 1980 · N30529 · Destroyed NTSB UNK64X0302Accident · No injuriesClosedPiper PA23 · N Kingsville, OHJan 20, 1964 · N4328P · Substantial damage