NTSB investigations: Piper PA-28R-200, NV
10 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.
Cases per year
| 1973 | 1 |
|---|---|
| 1974 | 1 |
| 1976 | 1 |
| 1978 | 1 |
| 1982 | 1 |
| 2003 | 1 |
| 2009 | 1 |
| 2015 | 1 |
| 2021 | 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.\"eventStateOrRegion\" = 'NV' 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" = 'NV' 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" 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 WPR22LA040Accident · No injuriesClass 3 · LimitedFinal reportPiper PA-28R-200 · Boulder City, NVThe installation of an improper right main landing gear door rod-end bolt, which resulted in the right main landing gear not extending during landing.NTSB WPR21LA222Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-28R-200 · Las Vegas, NVThe flight instructor’s failure to compensate for a downdraft during takeoff, which resulted in a loss of control and collision with terrain.NTSB WPR16LA016Accident · No injuriesLimited investigationFinal reportCessna 310C · Primm, NVThe inadequate visual lookout by the pilots of both airplanes, which resulted in a midair collision. Contributing to the accident was the pilots' failure to tune to, monitor, and communicate over the common traffic advisory frequency their relative positions…NTSB WPR09LA401Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Gerlach, NVThe pilot’s delay in aborting the takeoff, resulting in a runway excursion.NTSB LAX03FA298Accident · Serious injuriesField investigationFinal reportPiper PA-28R-200 · North Las Vegas, NVthe failure of the Federal Aviation Administration Air Traffic Control Tower local controller and local assist controller to effectively monitor the runway operation and ensure proper separation was maintained between aircraft on intersecting runways.NTSB LAX82FVW03Accident · Minor injuriesFinal reportPiper PA-28R-200 · Las Vegas, NVThe pilot reported that during the night landing, he maintained a little more than normal speed and power since this was his first night landing at the mccarran airport. He stated that on final approach for landing, heavy left rudder was needed. He stated he…NTSB OAK78FVW14Accident · No injuriesClosedPiper PA-28R · Las Vegas, NVNTSB OAK76FXQ50Accident · No injuriesClosedPiper PA-28R · Sparks, NVNTSB OAK75AP033Accident · 1 fatalClosedPiper PA-28R · Las Vegas, NVNTSB OAK74DVW09Accident · No injuriesClosedPiper PA-28 · Lathrop Wells, NV