Skip to content

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

24 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" = 'AZ' 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\" = 'AZ' 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" = 'AZ' 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 WPR21FA352Accident · 1 fatalClass 3 · FieldFinal reportPiper PA-28R-200 · Page, AZThe pilot’s improper fuel planning for a cross-country flight, which resulted in fuel exhaustion and a total loss of engine power.Sep 22, 2021 · N3906X · Substantial damage NTSB WPR19LA180Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28R · Chandler, AZThe pilot's failure to maintain directional control during landing in a gusting right quartering headwind, which resulted in a collapse of the left main landing gear.Jun 30, 2019 · N786N · Substantial damage NTSB WPR15CA078Accident · No injuriesData collectionFinal reportPiper PA 28R-200 · Sedona, AZThe pilot's loss of directional control during the landing roll.Jan 4, 2015 · N3811M · Substantial damage NTSB WPR10CA086Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Nogales, AZThe student's improper landing flare and the flight instructor's inadequate remedial action.Dec 3, 2009 · N2085T · Substantial damage NTSB LAX05LA214Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Happy Jack, AZThe fracture/separation of an engine intake valve during cruise flight, which resulted in a partial loss of engine power and a forced landing.Jun 16, 2005 · N5229T · Substantial damage NTSB LAX05CA181Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Tucson, AZthe improper flare by an undetermined crewmember, which resulted in a hard landing.May 15, 2005 · N55069 · Substantial damage NTSB LAX05LA227Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Phoenix, AZsubstantial damage to the airplane during an unknown phase of flight for undetermined reasons.Mar 11, 2005 · N2882R · Substantial damage NTSB LAX04CA063Accident · No injuriesData collectionFinal reportPiper PA-28R-200 · Morenci, AZthe pilot's excessive landing flare, which resulted in an improper touchdown and hard landing.Dec 3, 2003 · N1451T · Substantial damage 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.Nov 5, 2000 · N3032R · Destroyed NTSB LAX01LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Sedona, AZThe pilot's inadequate compensation for wind conditions while on short final landing approach. A factor was the unfavorable wind condition.Oct 14, 2000 · N4826Q · Substantial damage NTSB LAX99LA046Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Tucson, AZFailure of the instructor pilot to maintain directional control and properly supervise the landing. A contributing factor was the unavailability of brakes on the instructor's side (the right side) of the airplane.Dec 11, 1998 · N9320N · Substantial damage NTSB LAX97LA137Accident · Serious injuriesLimited investigationFinal reportPiper PA-28R-200 · Continental, AZloss of engine power as a result of detonation in the number 2 cylinder for undetermined reasons. A factor in the accident was the unsuitable nature of the forced landing area.Mar 31, 1997 · N2226T · Substantial damage NTSB LAX84LA370Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gila Bend, AZA forced landing was made on a road after the plt shut down the eng due to a 'run-away' prop. During the landing roll, the left wing tip struck a reflector post followed by the right wing striking a sign post. An eng overhaul & an annual inspection had been…Jun 26, 1984 · N4820T · Substantial damage NTSB LAX82DA348Accident · No injuriesFinal reportPiper PA-28R-200 · Prescott, AZAccording to the pilot, he planned a fuel stop at needles, CA, but was unaware that services were not available until after arrival. He departed needles with low fuel in both tanks and attempted to reach Prescott, AZ before dark. However, darkness occurred…Sep 19, 1982 · N7675C · Substantial damage NTSB LAX78FUJ95Accident · Minor injuriesClosedPiper PA-28R · Tuba City, AZAug 19, 1978 · N4951T · Substantial damage NTSB LAX78DUJ29Accident · No injuriesClosedPiper PA-28 · Apache Junct, AZMar 13, 1978 · N9309N · Substantial damage NTSB LAX78FUJ04Accident · Serious injuriesClosedPiper PA-28R · Stanfield, AZOct 7, 1977 · N2881T · Destroyed NTSB LAX77FA016Accident · 2 fatalClosedPiper PA-28R · Scottsdale, AZDec 4, 1976 · N298CC · Destroyed NTSB LAX76DUJ66Accident · No injuriesClosedPiper PA-28R · Grand Canyon, AZApr 4, 1976 · N9309N · Substantial damage NTSB LAX76DUJ34Accident · No injuriesClosedPiper PA-28 · Bagdad, AZOct 2, 1975 · N1593X · Substantial damage NTSB LAX76AL063Accident · 3 fatalClosedPiper PA-28R · Page, AZAug 3, 1975 · N16312 · Destroyed NTSB LAX74DUJ36Accident · No injuriesClosedPiper PA-28R · Gila Bend, AZNov 24, 1973 · N4995S · Substantial damage NTSB LAX73AL023Accident · 3 fatalClosedPiper PA-28 · Dragoon, AZDec 5, 1972 · N5009S · Destroyed NTSB DEN72AD056Accident · No injuriesClosedPiper PA-28R · Lukachukai, AZMay 25, 1972 · N4596T · Substantial damage