OpenAirDocs.org

NTSB investigations: Piper PA-36-285

7 cases on aircraft the registry lists as Piper PA-36-285, where the first occurrence was “In flight collision with object”. 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

19872026

Where

Open the map

Latest 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 ('7103610', '7103611')
      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\" = 220))
  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.

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 · DestroyedNTSB FTW94FA009Accident · 1 fatalField investigationFinal reportPiper PA-36-285 · Estelline, TXClearance not maintained by the pilot.Oct 10, 1993 · N57577 · DestroyedNTSB CHI91DER06Accident · No injuriesFinal reportPiper PA-36-285 · Fergus Falls, MNThe pilot's failure to maintain adequate clearance from obstacles during aerial apllication operations.Jun 17, 1991 · N57824 · Substantial damageNTSB DEN89LA170Accident · Minor injuriesLimited investigationFinal reportPiper PA-36 · Haswell, COInadequate visual lookout by the pilot (failed to see & avoid) which resulted in his failure to maintain clearance from the obstruction. Contributing factors were: the unmarked guy wire & the pilot's lack of visual cues (visual perception).Jul 17, 1989 · N57622 · DestroyedNTSB LAX89DUM02Accident · Serious injuriesFinal reportPiper PA-36-285 · Brawley, CAAt the completion of aerial application, the plt attempted flight beneath power lines. The aircraft contacted and severed four power lines and then collided with terrain. A post-impact fire ensued.Oct 18, 1988 · N57591 · DestroyedNTSB DEN88LA161Accident · No injuriesLimited investigationFinal reportPiper PA-36-285 · Buchanan, NDThe plt said he made several swath runs passing under a transmission line and over a power line that crossed the end of the fld being sprayed. He said as he passed under the transmission line during a run the vert stab collided with the line and was damaged.…Jul 18, 1988 · N9990P · Substantial damageNTSB CHI87DEP07Accident · Serious injuriesFinal reportPiper PA-36 · Plover, WIAfter spraying most of a bean crop, the plt was making clean-up swaths over an area at the north side of the field. This area had bldgs to the west & trees to the east. To avoid flying toward the bldgs, the plt elected to make the passes to the east (toward…Jun 22, 1987 · N57791 · Destroyed