Skip to content

NTSB investigations: Piper PA-32-260, OH

26 cases on aircraft the registry lists as Piper PA-32-260. 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

19672026

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 ('7103206')) 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 ('7103206'))
  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 ('7103206'))
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 CEN22FA131Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-32-260 · Fostoria, OHThe pilot’s loss of airplane control in night instrument meteorological conditions during the procedure turn of an instrument approach due to spatial disorientation, which resulted in a collision with terrain.Feb 23, 2022 · N3952W · Destroyed NTSB CEN14CA285Accident · No injuriesData collectionFinal reportPiper PA 32-260 · Lebanon, OHThe pilot's failure to maintain directional control of the airplane during landing which resulted in a runway excursion.Jun 4, 2014 · N3FN · Substantial damage NTSB NYC99FA187Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · North Lima, OHThe pilot's loss of control of the airplane during a turn. Factors include the pilot's failure maintain sufficient airspeed, and his failure to maintain the airplane in proper trim.Aug 1, 1999 · N5526J · Destroyed NTSB NYC94FA134Accident · 5 fatalField investigationFinal reportPiper PA-32-260 · Minford, OHThe pilot's failure to follow the published instrument departure procedure. A factor in the accident were the weather conditions.Jul 24, 1994 · N33468 · Destroyed NTSB BFO92LA107Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Norwalk, OHLoss of engine power due to undetermined reasons and the lack of suitable terrain for a forced landing.Jul 20, 1992 · N7727J · Destroyed NTSB CHI86LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Mechanicsburg, OHThe plt was on a personal flt when IMC was encountered. The plt elected to climb to a clear area above the IMC when the acft became totally 'socked in.' A 180 deg turn was made, vertigo was experienced and control of the acft was lost. An emergency descent…Jan 18, 1986 · N3414W · Substantial damage NTSB CHI83LA124Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Madeira, OHThe acft crashed into trees during a forced landing after the engine stopped operating while approaching an arpt. The acft was on a cross country flt from dayton to cincinnati in VMC weather. The acft was inspected at the scene and the engine was removed and…Feb 27, 1983 · N6809J · Destroyed NTSB CHI83LA020Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Vandalia, OHThe pilot estimated that he had 40 gal of fuel on board when he departed parkersburg, WV for new carlisle, OH. During a night arrival at new carlisle, he was unable to activate the runway lights by keying his microphone. Therefore, he diverted to Vandalia,…Oct 18, 1982 · N4740S · Substantial damage NTSB CHI77FEG09Accident · No injuriesClosedPiper PA-32 · Hamilton, OHJan 24, 1977 · N3528W · Substantial damage NTSB CHI77FEI10Accident · Minor injuriesClosedPiper PA-32 · Elyria, OHJan 19, 1977 · N5542J · Substantial damage NTSB CHI76FEI47Accident · Minor injuriesClosedPiper PA-32 · Baltic, OHAug 25, 1976 · N43087 · Substantial damage NTSB CHI76FEK26Accident · Minor injuriesClosedPiper PA-32 · Walhonding, OHAug 13, 1976 · N5591J · Substantial damage NTSB CHI75FEI36Accident · Minor injuriesClosedPiper PA-32 · Akron, OHDec 22, 1974 · N56754 · Substantial damage NTSB CHI75AC023Accident · 6 fatalClosedPiper PA-32 · Mcconnelsvle, OHSep 1, 1974 · N5503J · Destroyed NTSB CHI74FEI26Accident · Minor injuriesClosedPiper PA-32 · Cleveland, OHJan 29, 1974 · N3793W · Substantial damage NTSB CHI74FEK08Accident · Minor injuriesClosedPiper PA-32 · Warsaw, OHNov 4, 1973 · N4280T · Substantial damage NTSB CHI74DEG04Accident · No injuriesClosedPiper PA-32 · Vandalia, OHJul 31, 1973 · N4740S · Substantial damage NTSB CHI73AC062Accident · 2 fatalClosedPiper PA-32 · Holland, OHJan 10, 1973 · N1288T · Destroyed NTSB CHI73FEG10Accident · No injuriesClosedPiper PA-32 · Blue Creek, OHOct 27, 1972 · N3821W · Substantial damage NTSB CHI72FEK10Accident · No injuriesClosedPiper PA-32 · Bryan, OHFeb 10, 1972 · N4755S · Substantial damage NTSB CHI71FEI62Accident · No injuriesClosedPiper PA-32 · Bowlng Green, OHJun 6, 1971 · N3922W · Substantial damage NTSB CHI71FGG07Accident · No injuriesClosedPiper PA-32 · Findlay, OHAug 12, 1970 · N3325W · Substantial damage NTSB CHI69A0019Accident · 1 fatalClosedPiper PA-32 · Brunswick, OHAug 15, 1968 · N3393W · Destroyed NTSB CHI68F0721Accident · No injuriesClosedPiper PA-32 · St.Clairvill, OHApr 13, 1968 · N3257W · Substantial damage NTSB CHI68D0613Accident · No injuriesClosedPiper PA-32 · Put-In-Bay, OHJan 21, 1968 · N3411W · Substantial damage NTSB CHI68D0211Accident · No injuriesClosedPiper PA-32 · North Benton, OHJul 16, 1967 · N3694W · Substantial damage