NTSB investigations: Piper PA-32-260
16 cases on aircraft the registry lists as Piper PA-32-260, where the first occurrence was “Loss of engine power(total) - mech failure/malf”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 2 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1989 | 3 |
| 1990 | 1 |
| 1991 | 1 |
| 1994 | 1 |
| 1995 | 2 |
Where
Open the mapLatest 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103206')
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\" = 351))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103206')
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" = 351))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 NYC95LA130Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Ashland, VAa loss of engine power due to a subsurface fatigue crack in the crankshaft which led to failure of the crankshaft.NTSB MIA95LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · N. Miami Beach, FLInadequate annual inspection by maintenance personnel for failure to identify a hardened oil hose from the oil pump to the oil cooler inlet inside a protective fire sleeve. Additionally, unsuitable terrain encountered during the forced landing contributed to…NTSB ANC94FA106Accident · 3 fatalField investigationFinal reportPiper PA-32-260 · Kenai, AKInadequate engine maintenance and/or inspection, and fatigue cracking of the engine case, which resulted in eventual damage to the #3 cylinder studs/engine through-bolts, subsequent separation of the #3 cylinder and piston, and an in-flight fire.NTSB MIA91LA168Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Culebra, PROil exhaustion for undetermined reasons.NTSB FTW90LA102Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Tulsa, OKAn engine failure due to a disconnect in the magneto drive train caused by the crankshaft gear not being properly installed and secured during a recent engine overhaul.NTSB ATL89LA110Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Kershaw, SCFatigue failure of the crankshaft dowel pin. Factors related to the accident were: failure of maintenance personnel to follow the applicable service bulletin and darkness.NTSB SEA89LA056Accident · No injuriesLimited investigationFinal reportPiper PA-32 · Seabeck, WAA fatigue failure of the engine crankshaft. Contributing to the accident was the lack of suitable landing area.NTSB FTW89LA051Accident · Minor injuriesLimited investigationFinal reportPiper PA-32-260 · Conroe, TXFailure of the engine crankshaft due to fatigue. The low ceiling, dark night, and trees in the emergency landing area were factors.NTSB ANC88LA096Accident · Serious injuriesLimited investigationFinal reportPiper PA-32 · Sand Point, AKThe pilot reported that the aircraft had high oil temp and moderate vibrations. The aircraft was landed at Sand Point and a company mechanic arrived to inspect the aircraft. The oil quantity was checked and a run-up performed. The mechanic reported that no…NTSB FTW88FA064Accident · No injuriesField investigationFinal reportPiper PA-32-260 · Laplace, LAPlt was in level crz flt at night when he observed sparks and flame coming from the eng cowling. Shortly thereafter, the eng began running rough and then seized. After declaring an emergency and being cleared straight in to a runway about 28 miles away, the…NTSB ATL88FA055Accident · 4 fatalField investigationFinal reportPiper PA-32-260 · Lagrange, GAPlt lost power in cruise, in day, VMC. Made apch to interstate hwy I85. Hit overpass support column at 15 feet AGL. Engine overhauled 51 hours before accident. Overhaul records indicated magneto repair. Annual insp records indicated compliance with AD…NTSB MKC86LA175Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Wilson, KSThe pilot stated that before the flight the spark plugs were cleaned and inspected and the engine was serviced with eleven quarts of oil. Three hours into the flight instrument meteorological conditions (IMC) with rain was encountered and shortly thereafter…NTSB CHI84LA359Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Woodstock, ILThe acft collided with the terrain during a forced landing. The wx was VMC & no flt plan was filed. During the forced landing in a farm field the right main gear was sheared off and the nose gear bent. The left wing was also substantiallydamaged. The engine…NTSB ANC84LA097Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Igiugig, AKDuring flt, the plt heard a 'loud bang' & then the eng lost power. He transmitted a mayday call & made an emergency landing on rolling tundra. During the landing, the nose & left main gear failed & the wing & prop were damaged. An exam revealed that the eng…NTSB MKC84LA038Accident · No injuriesLimited investigationFinal reportPiper PA-32-260 · Sikeston, MOThe acft nose gear collapsed during a forced landing after engine failure. During a x-country flt the engine popped and quit. The plt approached a road to land but saw a vehicle during approach and veered off into a field. Post accident investigation revealed…NTSB FTW82FRD16Accident · 1 fatalFinal reportPiper PA-32-260 · Belle Chasse, LAThe acft departed southern seaplane's land rwy 20 & climbed to approximately 200-300 ft where it was observed trailing white smoke. It travelled approximately 1.6 mi from its departure point & struck a tree on the bank of the algiers outfall canal. Eng tear…