NTSB investigations: Piper PA-32R-300

9 cases on aircraft the registry lists as Piper PA-32R-300, where the first occurrence was “Loss of engine power”. 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-32R-300 per year, 1982–2026: 9 cases
1982	1
1983	1
1986	1
1997	1
2000	1
2001	1
2004	1
2006	2

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 ('7103213') 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" = 350)) 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 ('7103213')
      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\" = 350))
  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 ('7103213')
    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" = 350))
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 NYC07FA043Accident · 1 fatalField investigationFinal reportPiper PA-32R-300 · Charlottesville, VAA loss of engine power for undetermined reasons.Dec 10, 2006 · N8349C · Destroyed NTSB NYC06LA185Accident · Serious injuriesLimited investigationFinal reportPiper PA-32R-300 · Blacksburg, VAA partial loss of engine power for undetermined reasons, which resulted in a forced landing after takeoff, and subsequent collision with trees.Jul 27, 2006 · N43945 · Substantial damage NTSB FTW04LA169Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Dalhart, TXloss of engine power due to a corroded magneto for undetermined reasons.Jun 25, 2004 · N49KG · Substantial damage NTSB CHI01LA184Accident · Minor injuriesLimited investigationFinal reportPiper PA-32R-300 · Plattsmouth, NEthe loss of engine power for undetermined reasons during the approach and the inadvertent stall that occurred during the forced landing. Factors relating to this accident were the low airspeed, the uphill terrain, and the fence.Jun 21, 2001 · N5659V · Substantial damage NTSB CHI00LA286Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Mason City, IAthe unsuitable terrain for landing encountered by the pilot and the failure of the oil filter converter plate gasket. Factors to the accident were the total loss of oil and the soft terrain condition.Sep 1, 2000 · N8304C · Substantial damage NTSB LAX98LA027Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · Santa Rosa, CALoss of engine power for undetermined reasons.Oct 31, 1997 · N1655H · Substantial damage NTSB LAX87LA048Accident · No injuriesLimited investigationFinal reportPiper PA-32R-300 · San Jose, CAA Piper pa 32R-300 landed short of the rwy after a loss of power. The plt reported during the climb that he turned on the heater and the windshield turned black obscuring outside vision. The plt also indicated that there was a 'pungent odor' at the same time.…Dec 13, 1986 · N2209Q · Substantial damage NTSB MIA83FA180Accident · Serious injuriesField investigationFinal reportPiper PA-32R-300 · Islamorada, FLThe acft was ditched in the Florida bay after the engine malfunctioned. According to the plt, the eng started to run rough and he ditched the acft at about 0600 EDT. However, the acft clock was stopped at 0345 and a commercial fisherman said he saw a low…Jul 11, 1983 · N6207J · Destroyed NTSB FTW82DA335Accident · No injuriesFinal reportPiper PA-32R-300 · Alexandria, LAThe purpose of the flight was to prepare the pilot in the left seat for a commercial flight rating. After a power-off descent from 4000 ft to 2000 ft, the instructor gave the student a simulated forced landing. Reportedly, the throttle was opened briefly at…Aug 17, 1982 · N7744C · Substantial damage