NTSB investigations: Piper PA-16, MI

9 cases on aircraft the registry lists as Piper PA-16. 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-16, MI per year, 1964–2026: 9 cases
1964	1
1965	1
1966	1
1970	1
1972	1
1973	1
2000	1
2004	1
2011	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" = 'MI' 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 ('7101602')) 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\" = 'MI' 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 ('7101602'))
  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" = 'MI' 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 ('7101602'))
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 CEN11LA642Accident · No injuriesLimited investigationFinal reportPiper PA16 · Muskegan, MIThe pilot's loss of directional control during the takeoff roll and the flight instructor's inability to apply remedial action due to the opposite corrective control inputs by the pilot.Sep 11, 2011 · N5383H · Substantial damage NTSB CHI04CA296Accident · No injuriesData collectionFinal reportPiper PA-16 · Port Huron, MIThe pilot's failure to maintain directional control of the airplane during the landing roll which resulted in the overload failure of the right main landing gear.Sep 18, 2004 · N5891H · Substantial damage NTSB CHI00LA282Accident · 1 fatalLimited investigationFinal reportPiper PA-16 · Chesaning, MIThe pilot failed to maintain clearance from the trees. A factor was the trees.Sep 18, 2000 · N5943H · Destroyed NTSB CHI74DEM18Accident · No injuriesClosedPiper PA-16 · Lake City, MIAug 31, 1973 · N5868H · Substantial damage NTSB CHI73FEM07Accident · Serious injuriesClosedPiper PA-16 · Cedarville, MIAug 5, 1972 · N5984H · Substantial damage NTSB CHI70FDW18Accident · No injuriesClosedPiper PA-16 · South Rockwd, MIMay 25, 1970 · N5345H · Substantial damage NTSB CHI66F0490Accident · Serious injuriesClosedPiper PA-16 · Union Lake, MIJan 1, 1966 · N6808K · Substantial damage NTSB CHI66F0380Accident · No injuriesClosedPiper PA-16 · Blissfield, MIOct 19, 1965 · N5900H · Substantial damage NTSB UNK64X0162Accident · No injuriesClosedPiper PA16 · Muskegon, MIJan 5, 1964 · N5973H · Substantial damage