NTSB investigations: Piper PA-36-375

6 cases on aircraft the registry lists as Piper PA-36-375, where the first occurrence was “Loss of control - in flight”. 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

19822026

NTSB investigations: Piper PA-36-375 per year, 1982–2026: 6 cases
1982	2
1987	2
1991	1
1996	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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103620') 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" = 250)) 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7103620')
      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\" = 250))
  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 ('7103620')
    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" = 250))
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 CHI96LA224Accident · 1 fatalLimited investigationFinal reportPiper PA-36-375 · Windfall, INfailure of the pilot to maintain adequate airspeed, while maneuvering to avoid an obstruction (transmission line), which resulted in a stall and collision with the terrain. His lack of familiarity with the geographic area was a related factor.Jun 28, 1996 · N2459X · Destroyed NTSB CHI91DER07Accident · No injuriesFinal reportPiper PA-36-375 · Breckentidge, MNThe pilot's failure to take adequate remedial action during the attempted climb out. A related factor is the premature lift off.Jun 14, 1991 · N3866E · Substantial damage NTSB NYC87DHD05Accident · Minor injuriesFinal reportPiper PA-36-400 · Mullica Hill, NJThe pilot of the PA-36 was spraying chemicals on trees for control of the gypsy moth. He reported that he was unable to clear power lines and dumped his load. The aircraft settled to the ground. The FAA reported that the weight of the aircraft exceeded the…May 23, 1987 · N2412X · Destroyed NTSB DEN87LA117Accident · No injuriesLimited investigationFinal reportPiper PA-36-375 · Lamar, COThe commercial plt was on takeoff from a dirt strip with a fully loaded ag acft, for an aerial application flt. After lifting off prematurely, the acft settled to the rwy. The left wing struck a post skidding the acft to the left. After crossing an irrigation…May 1, 1987 · N2335X · Substantial damage NTSB MIA82DA183Accident · No injuriesFinal reportPiper PA-36-375 · Astatula, FLThe plt stated the acft failed to become airborne at the usual takeoff point & did not climb when forced into the air. The acft then settled into soft sand.Sep 18, 1982 · N3808E · Substantial damage NTSB FTW82FPD09Accident · 1 fatalFinal reportPiper PA-36-375 · Saint Jo, TXAfter taking off to the south, the plane was observed to climb to about 300 ft AGL, then turn to the southwest. P0WER was reduced, and within three to five miles, the aircraft was turned back toward the airstrip. While approaching the airstrip at about 500 ft…Feb 20, 1982 · N3802E · Destroyed