NTSB investigations: Piper PA-25, MN

10 cases on aircraft the registry lists as Piper PA-25. 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

19642026

NTSB investigations: Piper PA-25, MN per year, 1964–2026: 10 cases
1964	2
1967	1
1975	1
1979	1
1980	1
1981	1
1983	2
1987	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."eventStateOrRegion" = 'MN' 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 ('7102502')) 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\" = 'MN' 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 ('7102502'))
  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" = 'MN' 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 ('7102502'))
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 CHI87DER05Accident · Minor injuriesFinal reportPiper PA-25 · Henning, MNAfter experiencing a rough running engine the pilot initiated an emergency landing. During the off airport landing, the aircraft received substantial damage and the pilot reported minor injuries. This was this pilot's first experience in this type of…Apr 10, 1987 · N6384Z · Substantial damage NTSB CHI83FA393Accident · 1 fatalField investigationFinal reportPiper PA-25-150 · Graceville, MNWhile spraying a field adjacent to a house the acft struck a guy wire which had been strung between a 82 ft tower on the house & a 28 ft pole supported by wires.Aug 26, 1983 · N6253Z · Destroyed NTSB CHI83LA287Accident · Minor injuriesLimited investigationFinal reportPiper PA-25 · Morgan, MNThe acft collided with trees while turning during aerial application. The pilot reported that the acft controls felt soft. Thinking he was stalling he reduced bank, lowered the nose and at 85 mph indicated with full power continued levelflt until a wing hit a…Jul 1, 1983 · N6002Z · Substantial damage NTSB CHI81FER39Accident · Serious injuriesClosedPiper PA-25 · Lake Elmo, MNMay 31, 1981 · N6140Z · Destroyed NTSB CHI80FER49Accident · 1 fatalClosedPiper PA-25 · Grove City, MNJun 16, 1980 · N6444Z · Destroyed NTSB MKC79DER40Accident · No injuriesClosedPiper PA-25 · Watson, MNMay 25, 1979 · N6337Z · Substantial damage NTSB MKC75FER65Accident · 1 fatalClosedPiper PA-25 · Benson, MNApr 16, 1975 · N6027Z · Destroyed NTSB MKC68F0228Accident · Minor injuriesClosedPiper PA-25 · Fairfax, MNSep 2, 1967 · N6985Z · Destroyed NTSB UNK64X3705Accident · Serious injuriesClosedPiper PA25 · Prior Lake, MNAug 31, 1964 · N6276Z · Substantial damage NTSB UNK64X1496Accident · No injuriesClosedPiper PA24 · Howard Lake, MNApr 28, 1964 · N6293Z · Substantial damage