Skip to content

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

30 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

19722026

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" = 'IL' 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\" = 'IL' 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" = 'IL' 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 CEN17FA064Accident · 4 fatalField investigationFinal reportPiper PA 28R-200 · Vienna, ILThe non-instrument rated pilot's decision to descend through an overcast layer of weather during dark night conditions, which resulted in the airplane impacting trees.Dec 31, 2016 · N2806R · Destroyed NTSB GAA17CA109Accident · No injuriesData collectionFinal reportPiper PA28R · Kewanee, ILThe pilot’s failure to extend the landing gear during the approach to land.Dec 16, 2016 · N55484 · Substantial damage NTSB CEN12IA377Incident · No injuriesIncident investigationFinal reportPiper PA-28R-200 · Lacon, ILThe propeller blade’s failure due to a fatigue crack that originated from a surface gouge that resulted from foreign object damage to the propeller blade that occurred at an unknown time.Jun 18, 2012 · N4350T · Minor damage NTSB CHI08LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Watseka, ILThe loss of engine power for undetermined reasons.Jun 22, 2008 · N6144J · Substantial damage NTSB CHI04LA087Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Peru, ILThe inadvertent landing gear retraction by the dual student during the landing roll.Mar 13, 2004 · N15118 · Substantial damage NTSB CHI02FA177Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Steward, ILA loss of engine power due to the fatigue failure of several number three cylinder through bolts and case studs, which resulted in the separation of the number three engine cylinder. A factor contributing to the accident was the rough terrain.Jun 26, 2002 · N76SA · Substantial damage NTSB CHI99FA278Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Grayslake, ILthe pilot not maintaining altitude and clearance. Factors were the light condition of night, the pilot's lack of recent experience in night operations, and the transmission wire.Aug 6, 1999 · N56718 · Destroyed NTSB CHI99LA217Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Dongola, ILthe failure of the pilot to maintain a proper glidepath on the landing approach, and the failure of the pilot to select a proper touchdown point. Factors to the accident were the lack of runway lights, the dusk light condition, and the ditch.Jul 4, 1999 · N1996T · Substantial damage NTSB CHI98LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · East Hannibal, ILthe pilot's inadequate preflight planning/preparation, and his improper in-flight planning/decision. A factor was fuel exhaustion.May 3, 1998 · N75306 · Substantial damage NTSB CHI95LA039Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Rochelle, ILthe student pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the student pilot's improper use of the brakes.Nov 11, 1994 · N32196 · Substantial damage NTSB CHI94LA088Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sandwich, ILthe private pilot's failure to maintain directional control of the airplane while landing on a snow and ice covered runway. Factors are the snow on the runway and the snowbank.Feb 14, 1994 · N76SA · Substantial damage NTSB CHI94LA054Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Lacon, ILThe pilot misjudged the landing flare. Factors related to the accident were: the dark night, the pilot's lack of recent night experience, and the failure of the airplane's electrical system.Dec 13, 1993 · N66CS · Substantial damage NTSB CHI90LA237Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Roseville, ILMisjudged flare for landing, an improper recovery from a bounced landing, and his failure to maintain directional control.Aug 19, 1990 · N2731R · Substantial damage NTSB CHI90LA101Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Monee, ILEngine failure due to oil starvation resulting from improper maintenance and directive compliance associated with the failed part.Mar 23, 1990 · N4490X · Substantial damage NTSB CHI90LA094Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Wonder Lake, ILThe pilot's inadequate compensation for wind conditions, and his faiiure to maintain proper altitude on final approach to land. Factors related to the accident were: the trees & snowbank.Mar 3, 1990 · N55030 · Substantial damage NTSB CHI89FA109Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Saint Charles, ILThe failure of the mechanic to properly inspect the alternate air door during annual inspection. This failure led to air starvation, loss of power, and a forced landing by the pilot onto rough terrain.Jun 16, 1989 · N5242T · Substantial damage NTSB CHI83LA308Accident · No injuriesLimited investigationFinal reportPiper PA 28-180 · Chandlerville, ILThe acft made a forced landing after losing power at 1500 ft the pilot said the engine ran rough, oil pressure went to zero and the engine stopped. This pilot had been forced to land the same acft 3 days earlier when the engine lost power during takeoff.…Jul 10, 1983 · N6952J · Substantial damage NTSB CHI79DA074Accident · No injuriesClosedPiper PA-28R · Moline, ILSep 9, 1979 · N56373 · Substantial damage NTSB CHI78DEE09Accident · No injuriesClosedPiper PA-28R · Joliet, ILNov 27, 1977 · N4980S · Substantial damage NTSB CHI76DEE49Accident · No injuriesClosedPiper PA-28R · Sugar Grove, ILApr 5, 1976 · N111DJ · Substantial damage NTSB CHI76AC056Accident · 1 fatalClosedPiper PA-28R · Blue Mound, ILMar 31, 1976 · N55919 · 2 aircraft · Substantial damage NTSB CHI76FEV23Accident · No injuriesClosedPiper PA-28R · Galesburg, ILJan 4, 1976 · N55649 · Substantial damage NTSB CHI76FEE35Accident · No injuriesClosedPiper PA-28R · Chicago, ILNov 28, 1975 · N43688 · Substantial damage NTSB CHI76FEE28Accident · Serious injuriesClosedPiper PA-28R · Polo, ILNov 4, 1975 · N9381N · Destroyed NTSB CHI76DEV13Accident · No injuriesClosedPiper PA-28R · Centralia, ILSep 2, 1975 · N4909S · Substantial damage NTSB CHI75FEV25Accident · No injuriesClosedPiper PA-28R · Hammond, ILMar 18, 1975 · N1349T · Substantial damage NTSB CHI75AC029Accident · 2 fatalClosedPiper PA-28R · Crestwood, ILSep 29, 1974 · N9477N · Destroyed NTSB CHI74FEV39Accident · No injuriesClosedPiper PA-28R · Tuscola, ILFeb 24, 1974 · N5099S · Substantial damage NTSB CHI73FEE49Accident · Minor injuriesClosedPiper PA-28R · Elgin, ILApr 4, 1973 · N9430N · Destroyed NTSB CHI73AC040Accident · 2 fatalClosedPiper PA-28R · Bloomington, ILOct 14, 1972 · N2831R · Destroyed