Skip to content

NTSB investigations: Piper PA-28R-200, MI

21 cases on aircraft the registry lists as Piper PA-28R-200. 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

19712026

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" = '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 ('7102811')) 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 ('7102811'))
  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 ('7102811'))
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 CEN15LA157Accident · No injuriesLimited investigationFinal reportPiper PA 28R-200 · Frankenmuth, MIThe failure of the engine due to a lack of oil lubrication for reasons that could not be determined during postaccident examinations.Feb 27, 2015 · N2837R · Substantial damage NTSB CEN10CA522Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Berrien Springs, MIThe flight instructor's delayed remedial action, which resulted in a hard landing.Sep 6, 2010 · N404SE · Substantial damage NTSB CHI06LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hale, MIThe pilot's inadequate compensation for the crosswind condition and failure to maintain clearance from the tree. Factors were the crosswind and the tree.May 25, 2006 · N3310P · Substantial damage NTSB CHI01FA025Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Gaylord, MIThe pilot not maintaining proper glideslope and localizer alignment during the precision instrument approach, the pilot continuing flight below the decision height, the pilot not performing a missed approach, and the pilot not maintaining altitude/clearance…Oct 25, 2000 · N15900 · Destroyed NTSB CHI00LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIaltitude/clearance from the trees not being obtained/maintained by the pilot during the initial climb after takeoff. Factors to the accident were the inadequate preflight planning/preparation by the pilot, including takeoff performance data not being…Jun 10, 2000 · N2379T · Substantial damage NTSB CHI99LA038Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Hancock, MIthe pilot became disoriented while taxiing at an unfamiliar airport and his failure to reduce engine power when the airplane departed the paved surface. Factors associated with the accident were the dark night condition, the pilot did not follow the correct…Nov 25, 1998 · N5256T · Substantial damage NTSB CHI95LA178Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Bay City, MIFailure of the pilot to maintain clearance from obstacles and his intentional buzzing.Jun 13, 1995 · N5256T · Substantial damage NTSB CHI93LA277Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Flushing, MIThe pilot's inadequate preflight planning for determining the proper takeoff profile. A factor in the accident was the high density altitude.Jul 23, 1993 · N9307N · Substantial damage NTSB CHI93FAMS2Accident · 1 fatalMissing aircraftFinal reportPiper PA-28R-200 · Grand Haven, MIundetermined.Mar 15, 1993 · N15206 · Destroyed NTSB CHI87LA097Accident · No injuriesLimited investigationFinal reportPiper PA-28R · Holland, MIDuring a local flight the aircraft's engine lost oil pressure. The engine continued to run for about two minutes and then totally seized. The pilot made a hard landing on 58th street in Holland (the only available landing area he could see in the dark night…Mar 13, 1987 · N5140S · Substantial damage NTSB CHI87FA048Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · N. Manitou Isl., MIThe plt had recvd an unfavorable wx brief that included a SIGMET on flt icing. Enroute during flt over a large body of water he experienced power loss and was at too low a altitude to glide to shore. The plt attempted to ld on a island but crashed in a lake.Dec 11, 1986 · N32693 · Substantial damage NTSB CHI81FA012Accident · 2 fatalClosedPiper PA-28R · Kalkaska, MIDec 12, 1980 · N559PA · Destroyed NTSB CHI79FEC50Accident · No injuriesClosedPiper PA-28R · Hudson, MISep 2, 1979 · N54425 · Substantial damage NTSB CHI79FA071Accident · 3 fatalClosedPiper PA-28R · Grayling, MISep 2, 1979 · N4392T · Destroyed NTSB CHI79DEC08Accident · No injuriesClosedPiper PA-28R · Napoleon, MIDec 25, 1978 · N33867 · Substantial damage NTSB CHI78FEC17Accident · No injuriesClosedPiper PA-28 · Pontiac, MIFeb 15, 1978 · N3077R · Substantial damage NTSB CHI76FEC17Accident · No injuriesClosedPiper PA-28 · Detroit, MIDec 26, 1975 · N56889 · Substantial damage NTSB CHI74FEC44Accident · No injuriesClosedPiper PA-28R · Mt Morris, MIMay 15, 1974 · N2337T · Substantial damage NTSB CHI74AC086Accident · 4 fatalClosedPiper PA-28R · Freeland, MIMay 5, 1974 · N56611 · Destroyed NTSB CHI74FEC11Accident · No injuriesClosedPiper PA-28R · Tecumseh, MISep 1, 1973 · N2944R · Substantial damage NTSB CHI72AC021Accident · Serious injuriesClosedPiper PA-28R · Flint, MISep 7, 1971 · N2070T · 2 aircraft · Destroyed