NTSB investigations: Piper PA-28R-201
12 cases on aircraft the registry lists as Piper PA-28R-201, 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 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1988 | 3 |
| 1992 | 2 |
| 1994 | 1 |
| 1995 | 1 |
| 1999 | 1 |
| 2000 | 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 ('7102816', '7102833')
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 ('7102816', '7102833')
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 CHI00FA234Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Beloit, KSthe inadvertent stall. Factors relating to the accident were the pilot's low altitude, his abrupt pull up, the power lines, and his lack of recent flying experience.NTSB CHI99FA140Accident · 3 fatalField investigationFinal reportPiper PA-28R-201 · Curran, MIthe inadvertent stall/mush. Factor which contributed to this accident were the pilot's inadequate preflight planning, the premature lift-off during the takeoff, the airplane's low airspeed following lift-off, and the trees.NTSB CHI95LA273Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Wheeling, ILthe pilot's abrupt raising of the flaps during the attempted go-around and the resulting stall.NTSB LAX94LA366Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-201 · Fort Bragg, CAthe pilot's failure to adequately anticipate and compensate for the existing crosswind/windshear conditions during the takeoff initial climb.NTSB MIA93FA038Accident · 2 fatalField investigationFinal reportPiper PA-28R-201 · Jacksonville, FLThe pilot-in-command's failure to attain an adequate climb rate during the missed approach in IMC conditions. Contributing to the accident was the pilot's spatial disorientation.NTSB ATL93FA039Accident · 1 fatalField investigationFinal reportPiper PA-28R-201 · Phenix City, ALThe pilot's failure to maintain control of the aircraft in instrument meteorological conditions. A factor was the pilots lack of total experience in instrument flight conditions.NTSB NYC88FA229Accident · 4 fatalField investigationFinal reportPiper PA-28R-201 · Pomfret, CTThe Piper arrow PA-28R-201, had asked ATC for vectors to windam airport. After being vectored the pilot requested his distance from the airport. He was told that he was 12 miles from the airport, the pilot then decided to descend. ATC advised the pilot to…NTSB CHI88LA207Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Dodgeville, WIDuring an attempted landing in gusty wind, the pilot failed to maintain directional control, got blown off to the left side of the runway and experienced a tail strike. The pilot attempted to abort the landing, but was unable to climb out of ground effect,…NTSB CHI88LA139Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201 · Noblesville, INDuring initial climbout the pilot stated that he experienced a partial loss of power and was unable to maintain sufficient rate of climb to continue flight. The pilot executed a forced landing in a field, striking trees. Post-accident investigation failed to…NTSB DEN85LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201 · Angle Fire, NMThe plt stated that shortly after takeoff from the 6700 ft long rwy with a density alt of 10400 ft, turbulence was experienced and the airspeed decreased to aprx 70 KTS. Unable to maintain alt, a forced landing was attempted during which the acft contacted a…NTSB ANC83IA072Incident · No injuriesIncident investigationFinal reportPiper PA-28R-201 · Mcgrath, AKAfter 3 attempts to takeoff from a muddy airstrip and failing, the pilot off-loaded one passenger and some baggage. On the fourth takeoff attempt the aircraft got airborne but settled back to a snow covered frozen river. The snow slowed the aircraft and the…NTSB DEN82DA081Accident · No injuriesFinal reportPiper PA-28R-200 · Medicine Bow, WYDuring takeoff from a muddy field with a density altitude of 7253 feet the aircraft failed to clear a boundary fence. The passengers stated the stall warning sounded steadily from takeoff until impact with the ground. After the collision with the fence the…