NTSB investigations: Piper PA-30, WI

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

19672026

NTSB investigations: Piper PA-30, WI per year, 1967–2026: 8 cases
1967	1
1973	1
1974	2
1976	1
1981	1
1990	1
2001	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" = 'WI' 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 ('7103002')) 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\" = 'WI' 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 ('7103002'))
  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" = 'WI' 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 ('7103002'))
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 CHI01LA096Accident · No injuriesLimited investigationFinal reportPiper PA-30 · Appleton, WIThe misjudged glidepath and the intentional engine shutdown by the pilot. Factors were the false indication of the landing gear down light and the approach light.Feb 27, 2001 · N8196Y · Substantial damage NTSB CHI90LA187Accident · No injuriesLimited investigationFinal reportPiper PA-30B · Webster, WIThe failure of the nose gear transmission mounting bracket which resulted in nose gear collapse during the landing roll.Jul 14, 1990 · N8095Y · Substantial damage NTSB CHI81FEP45Accident · Minor injuriesClosedPiper PA-30 · Racine, WISep 7, 1981 · N8786Y · Substantial damage NTSB CHI77FEP12Accident · Serious injuriesClosedPiper PA-30A · Madison, WIDec 27, 1976 · N7184Y · Destroyed NTSB CHI75FEP29Accident · Serious injuriesClosedPiper PA-30 · Chippewa Fls, WISep 21, 1974 · N8753Y · Destroyed NTSB CHI75DEP17Accident · No injuriesClosedPiper PA-30 · Madison, WIAug 4, 1974 · N7690Y · Substantial damage NTSB CHI74AC024Accident · 6 fatalClosedPiper PA-30 · Florence, WISep 21, 1973 · N7878Y · Destroyed NTSB CHI67F0674Accident · No injuriesClosedPiper PA-30 · Waukesha, WIMay 18, 1967 · N7925Y · Substantial damage