NTSB investigations: Piper PA-36-285, TX

17 cases on aircraft the registry lists as Piper PA-36-285. 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

19732026

NTSB investigations: Piper PA-36-285, TX per year, 1973–2026: 17 cases
1973	1
1976	3
1977	1
1978	2
1980	1
1981	1
1983	1
1993	2
1999	1
2000	1
2008	2
2010	1

Where

Open the map

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" = 'TX' 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 ('7103610', '7103611')) 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\" = 'TX' 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 ('7103610', '7103611'))
  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" = 'TX' 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 ('7103610', '7103611'))
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 CEN10CA454Accident · No injuriesData collectionFinal reportPiper PA-36-285 · Petersburg, TXThe pilot's failure to maintain clearance from a signpost during an aerial application flight.Jul 29, 2010 · N57706 · Substantial damage NTSB CEN09LA023Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Silverton, TXThe pilot's failure to maintain clearance from a transmission wire.Oct 18, 2008 · N57740 · Substantial damage NTSB DFW08LA196Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Petersburg, TXA partial loss of engine power due to the substandard and incomplete maintenance of the engine.Jul 21, 2008 · N57601 · Substantial damage NTSB FTW00LA189Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Bovina, TXThe pilot's inadequate preflight planning, which resulted in the pilot exceeding the aircraft's takeoff performance. Factors were the high density altitude and the pilot's delayed load jettison.Jun 29, 2000 · N57596 · Substantial damage NTSB FTW00LA005Accident · 1 fatalLimited investigationFinal reportPiper PA-36-285 · Brownfield, TXThe pilot's failure to maintain clearance with power wires while maneuvering during an aerial application flight. A factor was the sunglare.Oct 5, 1999 · N4241U · Destroyed NTSB FTW94FA009Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Estelline, TXClearance not maintained by the pilot.Oct 10, 1993 · N57577 · Destroyed NTSB FTW93FA176Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Texhoma, TXThe pilot's flight into known adverse weather conditions. Factors were the weather, the dark night, the airplane's lack of flight and navigational equipment, and the pilot's lack of instrument training and experience.Jun 4, 1993 · N57592 · Destroyed NTSB FTW83LA266Accident · Serious injuriesLimited investigationFinal reportPiper PA-36-285 · Anson, TXAccording to the plt, while in flt, the eng was running smooth, but seemed to lack power. He checked the instruments & noted that the manifold pressure & eng RPM were normal. Then while at aprx 60 ft AGL, all power was lost. Subsequently, the acft crashed on…Jun 4, 1983 · N57751 · Destroyed NTSB FTW82DPD01Accident · No injuriesClosedPiper PA-36 · Munday, TXOct 5, 1981 · N57600 · Substantial damage NTSB FTW80DPD43Accident · No injuriesClosedPiper PA-36 · Knox City, TXAug 23, 1980 · N57746 · Destroyed NTSB FTW78DPD29Accident · No injuriesClosedPiper PA-36 · Iowa Park, TXAug 28, 1978 · N9963P · Substantial damage NTSB FTW78FQG41Accident · No injuriesClosedPiper PA-36 · Lubbock, TXJul 21, 1978 · N9958P · Substantial damage NTSB FTW78FQG05Accident · Minor injuriesClosedPiper PA-36 · New Deal, TXOct 19, 1977 · N9920P · Destroyed NTSB FTW76FQH02Accident · No injuriesClosedPiper PA-36 · Roby, TXAug 25, 1976 · N57569 · Substantial damage NTSB FTW76DPD51Accident · No injuriesClosedPiper PA-36 · Gilliland, TXJul 17, 1976 · N57600 · Substantial damage NTSB FTW76FQG81Accident · Serious injuriesClosedPiper PA-36 · Earth, TXJun 19, 1976 · N57597 · Substantial damage NTSB FTW74DQG29Accident · No injuriesClosedPiper PA-36 · Slaton, TXOct 22, 1973 · N56590 · Substantial damage