Skip to content

NTSB investigations: Piper PA-32-300, MA

15 cases on aircraft the registry lists as Piper PA-32-300. 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

19692026

Where

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" = 'MA' 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 ('7103212')) 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\" = 'MA' 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 ('7103212'))
  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" = 'MA' 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 ('7103212'))
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 NYC04FA136Accident · 2 fatalField investigationFinal reportPiper PA-32-300 · Leominster, MAThe pilot's failure to follow instrument flight procedures resulting in a collision with trees. A factor related to the accident was the low cloud ceiling, and dark night.Jun 2, 2004 · N21072 · Destroyed NTSB NYC03FA061Accident · 4 fatalField investigationFinal reportPiper PA-32-300 · Monterey, MAThe pilot's improper decision to attempt a visual flight rules (VFR) flight in marginal VFR weather conditions over mountainous terrain, which resulted in an in-flight collision with trees. Factors in this accident were clouds and night light conditions.Mar 3, 2003 · N4072R · Substantial damage NTSB NYC02LA167Accident · No injuriesLimited investigationFinal reportPiper PA32-300 · Chatham, MAThe pilot's improper in-flight decision to continue the landing after losing visual contact with the runway, which resulted in his failure to obtain the proper touchdown point, and the subsequent overrun. Factors in this accident were the clouds and low…Aug 16, 2002 · N20787 · Substantial damage NTSB NYC00LA242Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Nantucket, MAThe pilot's failure to maintain the proper glide path to the runway. Factors related to the accident were the fog conditions and the pilot’s fatigue.Aug 26, 2000 · N8133Z · Destroyed NTSB IAD00LA060Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Fitchburg, MApilot's inadequate compensation for the crosswind. A factor was the crosswind.Jul 8, 2000 · N21072 · Substantial damage NTSB NYC98LA102Accident · 1 fatalLimited investigationFinal reportPiper PA-32-300 · New Bedford, MAThe pilot's impairment due to alcohol, which resulted in an inadequate preflight examination and subsequent takeoff with a control lock installed.Apr 26, 1998 · N15326 · Substantial damage NTSB NYC94LA059Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Norwood, MAThe inadequate supervision by the instructor pilot during the landing, resulting in the improper runway alignment by the student pilot, and the subsequent collision with a snowbank. A factor related to the accident was the incomplete runway snow removal.Mar 16, 1994 · N7303R · Substantial damage NTSB NYC85LA216Accident · No injuriesLimited investigationFinal reportPiper PA-32-300 · Provincetown, MAPlt experience eng pwr loss during tke climb at a height of about 350 ft. the plt headed toward a beach and ditched about 50 yards offshore in order to avoid crowd. The acft submerged underwater afterwards. Examination of the acft disclosed leadlike…Aug 18, 1985 · N15805 · Substantial damage NTSB NYC80FNE01Accident · Minor injuriesClosedPiper PA-32S · W.Springfield, MAOct 20, 1979 · N5223S · Substantial damage NTSB NYC75AN036Accident · 1 fatalClosedPiper PA-32 · New Bedford, MASep 9, 1974 · N4088W · Destroyed NTSB NYC74FNA05Accident · No injuriesClosedPiper PA-32 · Plymouth, MAJul 24, 1973 · N4213R · Substantial damage NTSB NYC73FNA12Accident · Serious injuriesClosedPiper PA-32 · Nantucket, MAAug 13, 1972 · N4196R · Substantial damage NTSB NYC72AN052Accident · No injuriesClosedPiper PA-32 · Fitchburg, MASep 9, 1971 · N294HA · 2 aircraft · Minor damage NTSB NYC70D0081Accident · No injuriesClosedPiper PA-32 · Danvers, MAJul 18, 1969 · N4201R · Substantial damage NTSB NYC69D0435Accident · No injuriesClosedPiper PA-32 · Norwood, MAApr 23, 1969 · N4073R · Substantial damage