NTSB investigations: Piper PA-28R-201T, AZ
7 cases on aircraft the registry lists as Piper PA-28R-201T. 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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1980 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1994 | 1 |
| 2011 | 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.\"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 ('7102813'))
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 ('7102813'))
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 WPR11CA107Accident · No injuriesData collectionFinal reportPiper PA-28R-201T · Meadview, AZThe pilot's failure to properly secure the airplane while manually starting the engine with the propeller, resulting in inadvertent movement of the airplane and collision with the ground.NTSB LAX94LA315Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-201T · Overgaard, AZthe pilot's failure to maintain an adequate airspeed margin, which resulted in an inadvertent stall. Factors in the accident were weather conditions, high density altitude, and shifting wind conditions.NTSB LAX88LA125Accident · Serious injuriesLimited investigationFinal reportPiper PA28R-201T · Bullhead City, AZShortly after takeoff, the engine failed. During the forced landing the aircraft ran into a rock quarry. Inspection of the engine revealed that the fuel injector lines were loose and that one line had separated.NTSB LAX84LA007Accident · No injuriesLimited investigationFinal reportPiper PA-28R-201T · Chandler, AZPrior to landing the plt observed that the gear down light for the right gear did not illuminate. He recycled the gear 2 or 3 times, but the green gear down light would not illuminate. Ground personnel reported to the plt that the gear appeared to be down.…NTSB LAX80FUJ95Accident · Minor injuriesClosedPiper PA-28R · Lakeside, AZNTSB LAX79FA039Accident · 2 fatalClosedPiper PA-28R · Jerome, AZNTSB LAX78DUJ80Accident · No injuriesClosedPiper PA-28R · Dolan Springs, AZ