NTSB investigations: Piper PA-28R-180
11 cases on aircraft the registry lists as Piper PA-28R-180, where the first occurrence was “Loss of control - in flight”. 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.
Cases per year
| 1982 | 1 |
|---|---|
| 1985 | 2 |
| 1989 | 1 |
| 1992 | 1 |
| 1995 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2001 | 1 |
| 2005 | 1 |
| 2007 | 1 |
Where
Open the mapLatest cases
Query with SQL
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102809')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102809')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESCRun 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 SEA07CA191Accident · No injuriesData collectionFinal reportPiper PA 28R-180 · Henderson, NVThe pilot's failure to maintain control of the airplane during the attempted go-around, which resulted in a hard landing. A contributing factor was the crosswind.NTSB DEN05LA133Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Ogden, UTthe flight instructor's failure to maintain adequate airspeed resulting in an inadvertent stall. Contributing factor's include the flight instructor's improper pre-flight planning and decision in accepting the intersection departure, and the flight…NTSB MIA01FA060Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Bethel, NCthe pilot's failure to maintain control of the airplane due to spatial disorientation, which resulted in an in-flight collision with power lines and the subsequent impact with terrain. A factor in this accident was: the pilot's lack of recent instrument…NTSB NYC98FA009Accident · 4 fatalField investigationFinal reportPiper PA-28R-180 · Morganville, NJThe inadequate maintenance by the flying club and maintenance facility, which resulted in a takeoff with a partially blocked fuel injector nozzle and the failure of the landing gear to retract after takeoff. This resulted in the pilot's diverted attention and…NTSB SEA96FA137Accident · 2 fatalField investigationFinal reportPiper PA-28R-180 · Pray, MTthe pilot's delay in initiating a go-around, and his failure to obtain and/or maintain sufficient airspeed to avoid higher terrain during the go-around, which resulted in a stall and collision with terrain. Factors relating to the accident were: the narrow…NTSB BFO96FA034Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Louisville, KYfailure of the pilot to maintain adequate airspeed, while maneuvering at low altitude, which resulted in an inadvertent stall, loss of altitude, and subsequent collision with obstructions (utility pole and supporting cable).NTSB FTW92FA163Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Bethany, OKThe pilot's failure to maintain control which resulted in an inadvertent stall. The gusty wind was a factor.NTSB CHI89LA096Accident · Minor injuriesLimited investigationFinal reportPiper PA28R-180 · Frankfort, ILPilot's failure to maintain directional control while attempting to land in cross/tailwind conditions.NTSB ATL86FLQ02Accident · Serious injuriesFinal reportPiper PA-28 · Payne Gap, KYThe acft stalled & crashed during a turn to reverse course at low alt to avoid wx. The acft had been following a road to find an arpt when wx was encountered. After the stall the acft clipped trees and wires and came to rest at the base of stairs leading to a…NTSB DEN85LA132Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Reserve, NMPlt stated that shortly after takeoff at an alt of aprx 100 ft AGL, the acft stopped climbing and started descending. Unable to arrest the descent, the plt attempted a forced landing in a field. Prior to touchdown the left main gear contacted the top of a…NTSB ATL82FA054Accident · Serious injuriesField investigationFinal reportPiper PA-28R-180 · Hagerstown, MDThe pilot made an erratic visual approach after performing an ILS approach to within 2 miles of the runway. She varied her flight path from side to side and was corrected verbally by the more experienced co-pilot. The flare was started too high and the…