Skip to content

NTSB investigations: Piper PA-28-180, IA

39 cases on aircraft the registry lists as Piper PA-28-180. 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

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" = 'IA' 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 ('7102808')) 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\" = 'IA' 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 ('7102808'))
  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" = 'IA' 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 ('7102808'))
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 CEN21FA320Accident · 2 fatalClass 3 · FieldFinal reportPiper PA-28-180 · Muscatine, IAThe noninstrument-rated pilot’s continued visual flight under a thunderstorm, where he encountered reduced visibility due to heavy precipitation, resulting in a loss of control due to spatial disorientation.Jul 14, 2021 · N2801T · Destroyed NTSB GAA17CA338Accident · No injuriesData collectionFinal reportPiper PA 28 · Estherville, IAThe student pilot's failure to maintain crosswind correction during a go-around in gusting wind conditions.Jun 14, 2017 · N33764 · Substantial damage NTSB CEN17FA147Accident · 2 fatalField investigationFinal reportPiper PA-28-180 · Oxford, IAThe failure of the pilot receiving instruction to recover from the practice stall before the airplane entered a spin and the flight instructor's inadequate monitoring of the pilot receiving instruction and delayed remedial action to recover the airplane.Apr 7, 2017 · N9179J · Destroyed NTSB CEN09CA599Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Sibley, IAThe pilot's long and fast landing and her delayed decision to execute a go-around.Sep 21, 2009 · N57354 · Substantial damage NTSB CEN09FA377Accident · 3 fatalField investigationFinal reportPiper PA-28-180 · Sanborn, IAA loss of engine power due to fuel exhaustion as a result of the pilot's improper fuel planning and failure to refuel.Jun 23, 2009 · N7795N · Substantial damage NTSB CHI05CA002Accident · Minor injuriesData collectionFinal reportPiper PA-28-180 · Marion, IAThe pilot's inadequate compensation for the gusting wind conditions and his failure to maintain aircraft control. Factors to the accident were the encountered turbulence, the gusting wind conditions and the airport hangar.Oct 3, 2004 · N7841N · Substantial damage NTSB CHI04LA035Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Bloomfield, IAThe pilot's inadequate compensation for the crosswind condition which resulted in his failure to maintain directional control of the airplane. Factors associated with the accident were the crosswind and the grass which the airplane contacted.Nov 30, 2003 · N7467W · Substantial damage NTSB CHI99LA032Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Iowa Falls, IAthe pilot's improper preflight planning and preparation, and his not refueling the airplane. Factors were fuel exhaustion and the fence.Nov 22, 1998 · N2691T · Substantial damage NTSB CHI96LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-180C · West Liberty, IAthe pilot's inadequate preflight planning/preparation and an intentional ground loop/swerve. A factor in the accident was the wet grass runway.Jan 12, 1996 · N8221W · Substantial damage NTSB MKC83LA020Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Marengo, IAPilot overflew the area and saw no obstructions. Planned to land well down the runway. Saw wires 75 feet from runway. He says wires were 70 feet high and 50 feet from runway.Nov 14, 1982 · N1443T · Substantial damage NTSB MKC82DA064Accident · No injuriesFinal reportPiper PA-28-180 · Estherville, IAThe pilot had not flown for over 90 days and was flying for practice and to become current. During landing, the aircraft bounced back in the air about 20 to 30 feet and then came down hard on the nose gear. The nose gear failed and the plane slid to a stop on…Apr 29, 1982 · N2134R · Substantial damage NTSB MKC82DCD04Accident · No injuriesClosedPiper PA-28 · Iowa Falls, IADec 4, 1981 · N43098 · Destroyed NTSB MKC78DCD56Accident · No injuriesClosedPiper PA-28 · Allison, IASep 7, 1978 · N7840W · Substantial damage NTSB MKC77FCD18Accident · Serious injuriesClosedPiper PA-28 · Iowa City, IAMay 12, 1977 · N5177S · Substantial damage NTSB MKC76AK068Accident · 2 fatalClosedPiper PA-28 · Hiawatha, IAJul 22, 1976 · N6381J · Destroyed NTSB MKC76DCD48Accident · No injuriesClosedPiper PA-28 · Algona, IAJun 8, 1976 · N8066W · Substantial damage NTSB MKC76FCD14Accident · 1 fatalClosedPiper PA-28 · Montezuma, IASep 28, 1975 · N44657 · Substantial damage NTSB MKC75AK045Accident · 1 fatalClosedPiper PA-28 · Clinton, IAFeb 26, 1975 · N5389L · Destroyed NTSB MKC75DCD20Accident · No injuriesClosedPiper PA-28 · Milford, IASep 14, 1974 · N7721N · Substantial damage NTSB MKC74FCD35Accident · Serious injuriesClosedPiper PA-28 · Sac City, IAMay 26, 1974 · N55128 · Substantial damage NTSB MKC73DCD40Accident · No injuriesClosedPiper PA-28 · Waterloo, IANov 19, 1972 · N2189T · Substantial damage NTSB MKC72FCD44Accident · No injuriesClosedPiper PA-28 · Newton, IANov 14, 1971 · N6649J · Substantial damage NTSB MKC71DCD71Accident · No injuriesClosedPiper PA-28 · Pella, IAApr 8, 1971 · N5254L · Substantial damage NTSB MKC70AK049Accident · 4 fatalClosedPiper PA-28 · Newton, IAMar 9, 1970 · N7704N · Destroyed NTSB MKC70D0235Accident · No injuriesClosedPiper PA-28 · Guttenberg, IAAug 29, 1969 · N7235W · Substantial damage NTSB MKC70D0104Accident · No injuriesClosedPiper PA-28 · Epworth, IAJul 24, 1969 · N4839L · Substantial damage NTSB MKC69D0477Accident · No injuriesClosedPiper PA-28 · Des Moines, IAJun 3, 1969 · N6300J · Substantial damage NTSB MKC69D0374Accident · No injuriesClosedPiper PA-28 · Perry, IAMar 12, 1969 · N4886L · Substantial damage NTSB MKC69D0268Accident · No injuriesClosedPiper PA-28 · Dubuque, IAOct 31, 1968 · N7160W · Substantial damage NTSB MKC68D0586Accident · No injuriesClosedPiper PA-28 · Mount Vernon, IAMay 17, 1968 · N5172L · Substantial damage NTSB MKC68D0516Accident · No injuriesClosedPiper PA-28 · Storm Lake, IAApr 11, 1968 · N8949J · Substantial damage NTSB MKC68D0235Accident · No injuriesClosedPiper PA-28 · Chariton, IASep 25, 1967 · N9428J · Destroyed NTSB MKC68D0221Accident · No injuriesClosedPiper PA-28 · Chariton, IASep 21, 1967 · N9428J · Substantial damage NTSB MKC67D0541Accident · No injuriesClosedPiper PA-28 · Shenandoah, IAApr 22, 1967 · N8210W · Substantial damage NTSB MKC67D0309Accident · No injuriesClosedPiper PA-28 · Clare, IANov 6, 1966 · N9239J · Substantial damage NTSB MKC67A0027Accident · 2 fatalClosedPiper PA-28 · Iowa City, IAOct 2, 1966 · N7180W · Destroyed NTSB MKC66D0416Accident · No injuriesClosedPiper PA-28 · Storm Lake, IAFeb 7, 1966 · N7321W · Substantial damage NTSB MKC66F0229Accident · Serious injuriesClosedPiper PA-28 · Pacific Jctn, IASep 21, 1965 · N8282W · Substantial damage NTSB UNK64X3355Accident · No injuriesClosedPiper PA28 · Clarion, IAAug 13, 1964 · N7372W · Substantial damage