Fatal NTSB investigations: Piper PA-36-285

14 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

19752026

Fatal NTSB investigations: Piper PA-36-285 per year, 1975–2026: 14 cases
1975	1
1976	1
1977	2
1978	1
1979	2
1982	1
1983	1
1987	1
1993	2
1999	1
2000	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."highestInjuryLevel" = 'Fatal' 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.\"highestInjuryLevel\" = 'Fatal'
    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."highestInjuryLevel" = 'Fatal'
  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 CHI00LA243Accident · 1 fatalLimited investigationFinal reportPiper PA-36-285 · Osborne, KSThe unsuitable terrain for landing encountered by the pilot during the forced landing. Factors were the failure of the number four piston and cylinder, the soft terrain, and the main landing gear overload and subsequent collapse.Aug 5, 2000 · N57616 · Destroyed 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 MKC87DCQ03Accident · 1 fatalFinal reportPiper PA-36 · Nickerson, KSAfter a swath run to the east, the acft was observed to pull up & begin turning back to the west. The witness then saw a big cloud of smoke. She did not see spray coming from the acft drg the last swath run, although her vision was limitedby foliage & bldgs.…Jul 21, 1987 · N9935P · Destroyed NTSB SEA83FA162Accident · 1 fatalField investigationFinal reportPiper PA-36 · Firth, IDAccording to witnesses, the acft was overheard returning to the strip for a second load. Reportedly, it went into a steep bank at about 70 ft AGL & turned toward the strip. As the wings leveled, sounds of high eng power ceased & the acft descend to the…Aug 2, 1983 · N57588 · Destroyed NTSB MKC82FCJ04Accident · 1 fatalFinal reportPiper PA-36 · North Platte, NEThe aircraft ran off the departure end of the runway during takeoff on a planned agricultural flight. After departing the runway, it continued for a distance through uncut wheat until it contacted a shallow washout and small bank, then flipped over. There…Jul 9, 1982 · N57738 · Substantial damage NTSB FTW79FPJ19Accident · 1 fatalClosedPiper PA-36 · Boise City, OKMay 27, 1979 · N9978P · Destroyed NTSB OAK79FVA21Accident · 1 fatalClosedPiper PA-36 · Los Banos, CAMar 14, 1979 · N9946P · Destroyed NTSB LAX78FUJ89Accident · 1 fatalClosedPiper PA-36 · Casa Grande, AZJul 28, 1978 · N57569 · Destroyed NTSB FTW78FPJ04Accident · 1 fatalClosedPiper PA-36 · Garber, OKOct 25, 1977 · N57782 · Destroyed NTSB MKC77FA022Accident · 1 fatalClosedPiper PA-36 · Pierre, SDApr 26, 1977 · N57821 · 2 aircraft · Substantial damage NTSB MIA76FKG91Accident · 1 fatalClosedPiper PA-36 · Blakely, GAJul 29, 1976 · N56322 · Destroyed NTSB CHI76FEM05Accident · 1 fatalClosedPiper PA-36 · Munger, MIJul 23, 1975 · N9919P · Destroyed