NTSB investigations: Piper PA-28R-200
31 cases on aircraft the registry lists as Piper PA-28R-200, 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
| 1983 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 2 |
| 1989 | 2 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 3 |
| 1993 | 1 |
| 1994 | 3 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 4 |
| 2001 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2005 | 1 |
| 2006 | 1 |
| 2007 | 2 |
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 ('7102811')
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 ('7102811')
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 LAX08FA001Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Cedar City, UTThe pilot's failure to maintain aircraft control while in cruise flight due to spatial disorientation. Contributing to the accident were the dark conditions.NTSB DFW07CA147Accident · No injuriesData collectionFinal reportPiper PA28R-200 · Lubbock, TXThe inadvertent stall and subsequent hard landing as result of the pilot's failure to maintain airspeed and his delayed relinquishing of the airplane's controls when requested by the flight instructor.NTSB NYC06CA210Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · West Milford, NJThe pilot's inadequate compensation for the wind conditions, which resulted in a hard landing. A factor was the wind.NTSB CHI05FA081Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · West Lafayette, INThe pilot's inadvertent flight into instrument conditions and his not maintaining control of the complex airplane during initial climb. Factors in the accident were the low ceiling, the early dawn condition, and the pilots intentional unauthorized use of the…NTSB MIA04LA084Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Everglades City, FLThe failure of the pilot to maintain airspeed during climb after takeoff resulting in an inadvertent stall, uncontrolled descent, and impact in a wooded area.NTSB NYC03LA108Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gaithersburg, MDThe pilot’s failure to maintain airspeed, resulting in an inadvertent stall.NTSB SEA02LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Puyallup, WAThe pilots' failure to maintain aircraft control on short final, resulting in a touchdown off of the prepared landing surface. A factor was grassy terrain encountered on the landing rollout.NTSB LAX01FA036Accident · 2 fatalField investigationFinal reportPiper PA28-200 · Teec Nos Pos, AZIn-flight loss of control resulting in airframe structural failure. Contributing to the accident was the pilot's inadvertant visual flight into instrument meteorological conditions.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…NTSB NYC00LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-200 · Lehighton, PAThe pilot's inadequate compensation for the crosswind. A factor in this accident was the gusty crosswind condition.NTSB MIA00LA081Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fayette, ALThe pilot's failure to maintain directional and altitude control of the airplane during a ago-around maneuver, resulting in collision with a fence and utility pole.NTSB CHI98LA181Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · Sikesville, MOthe deer which ran in front of the airplane during the landing flare. Factors associated with the accident were the inadequate airspeed which resulted in the pilot not being able to maintain directional control of the airplane as he attempted to avoid deer,…NTSB LAX95LA337Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Parker Dam, CAthe pilot's failure to maintain adequate airspeed during a go-around.NTSB NYC94LA180Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Oakland, MDthe pilot's inadequate preflight planning and preparation in which the pilot attempted a high density altitude takeoff, up-slope, with the airplane over the maximum allowable gross weight, utilizing a rolling takeoff technique with an improper flap setting.…NTSB FTW94LA157Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · San Antonio, TXThe pilot continued flight into known adverse weather. The thunderstorm activity was a factor.NTSB MIA94FA098Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Sarasota, FLFailure of the pilot(s) to maintain control of the airplane due to spatial disorientation. Factors related to the accident were: A malfunction that resulted in a loss of normal radio transmission, and the pilot(s) lack of recent experience in this make and…NTSB NYC94FA033Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · New Haven, CTThe pilot's failure to maintain control of the airplane during a night approach in adverse weather conditions. Factors which contributed to the accident were the weather conditions and dark night. In addition, the radar controller's vectoring of the pilot to…NTSB NYC93LA002Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Akron, NYThe failure of the pilot to compensate for adverse winds and wind shear. A factor related to the accident was the adverse wind conditions.NTSB SEA92LA127Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-200 · W. Yellowstone, MTA stall/mush encountered due to poor pre-flight planning/preparation. Factors to the accident were: high density altitude and gross weight exceeded.NTSB LAX92FA172Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Placerville, CAThe pilot's failure to maintain control of the airplane and his improper use of the flight controls which endured airframe loads that exceeded the aircraft's design stress limits. Factors which contributed to the accident related to the pilot's encounter with…NTSB CHI91FA091Accident · 1 fatalField investigationFinal reportPiper PA-28R-200 · Dutchtown, MOThe pilot's failure to maintain control of the airplane in instrument meteorological conditions and the pilot exceeding the design stress limits of the airplane during the loss of control. Contributing factors were the existing weather conditions.NTSB SEA90FA074Accident · 2 fatalField investigationFinal reportPiper PA28R-200 · Prairie City, ORUncontrolled spiralling descent that the pilot did not adequately recover from. The pilots lack of total experience in this type of operation and the dark night condition are a factor.NTSB MIA90FA014Accident · 2 fatalField investigationFinal reportPiper PA-28R-200 · Athens, TNLoss of control of the airplane in instrument flight conditions due to spatial disorientation, which resulted in an inadvertent descending spiral. Lack of total experience in the type of operation (actual instrument conditions) was considered to be a…NTSB CHI89FA040Accident · 3 fatalField investigationFinal reportPiper PA-28-200 · Carmel, INThe pilot's poor understanding of the weather forecast, his failure to utilize the pitot heat in icing conditions and the exceeding of the stress limits of the aircraft.NTSB DEN88LA149Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Cheyenne, WYThe flight originated in omaha, NE. Three passengers and the commercial plt embarked on a fishing trip into Wyoming. The pilot departed Cheyenne after having several problems with the engine and correcting the problem by proper leaning. He said he took off…NTSB CHI88FA145Accident · No injuriesField investigationFinal reportPiper PA-28R-200 · Detroit Lakes, MNNTSB DEN86LA065Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sterling, COAccording to the plt, during the checkride for his commercial plt certificate, the flt examiner gave him a simulated electrical failure & turned the landing lights off. The plt stated that during the night landing flare, he lost visual reference with the rwy…NTSB DEN85LA152Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Los Almos, NMThe plt was making an apch to rwy 27 at the los alamos muni arpt in gusty x-wind conditions. The arpt was located atop a mesa & rwy 27 had a 1.5% uphill rwy gradient. The plt said he selected 2 notches (25 deg) of flaps. The winds were reported to be from 210…NTSB NYC84LA115Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Mount Holly, NJAccording to the plt, a windshear was encountered during the final approach at approximately 100 ft AGL. The acft descended rapidly and bounced at the approach end of the rwy, ascended approximately 30 ft into the air, landed again striking the left wing on…NTSB LAX84FA138Accident · 3 fatalField investigationFinal reportPiper PA-28R-200 · Tracy, CAThe flight departed under instrument meteorological conditions, with visibility restricted to one quarter mile by fog. The ceiling was obscured. After departure witnesses heard the aircraft make what appeared to be a left turn. Next they heard the engine…NTSB FTW83FA253Accident · 1 fatalField investigationFinal reportPiper PA28R200 · Decatur, TXAfter landing due to poor wx the pilot obtained a wx briefing during which he was told of a long line of thunderstorms 150 miles wide covering the area in which he was located. The pilot departed & then attempted to land at an airport 15 miles away in gusty…