NTSB investigations: Piper PA-28R-200, VA
12 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
| 1975 | 1 |
|---|---|
| 1977 | 2 |
| 1979 | 2 |
| 1980 | 1 |
| 1981 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 2002 | 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\" = 'VA' 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" = 'VA' 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 NYC02LA061Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Fredericksburg, VAThe private pilot's failure to verify the fuel tank selector position, which resulted in fuel starvation and a subsequent forced landing.NTSB NYC92FA078Accident · 4 fatalField investigationFinal reportPiper PA-28R-200 · Narrows, VAThe pilot's decision to attempt VFR flight into adverse weather conditions, and the subsequent loss of airplane control. Factors related to the accident were the pilot's lack of an instrument rating, and his disregard of forcasted adverse weather along the…NTSB BFO90LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200 · Petersburg, VAFuel starvation and improper use of emergency procedures (fuel selector) by the pilot.NTSB BFO87LA018Accident · No injuriesLimited investigationFinal reportPiper PA-28R-200R · West Point, VAAfter making a low pass over the uncontrolled airport the CFI decided to let the student pilot make a touch and go landing on runway 27 at West Point municipal airport. West Point, Virginia. The maneuver was successfully completed and the aircraft came around…NTSB BFO86FID09Accident · No injuriesFinal reportPiper PA-28R-200 · Montpelier Sta., VAThe acft collided with 2 fences during an off arpt forced landing after a pwr loss. Post acc eng inspection showed internal failure of the eng. #2 connecting rod bolt failed in fatigue through 40 percent of the diameter. The remainder failed in tension. The…NTSB ATL81IID14Accident · No injuriesClosedPiper PA-28R · Williamsburg, VANTSB ATL81DID06Accident · No injuriesClosedPiper PA-28R · Gloucester, VANTSB IAD80DID05Accident · Minor injuriesClosedPiper PA-28 · Lexington, VANTSB IAD79DIJ08Accident · No injuriesClosedPiper PA-28R · Clinchport, VANTSB IAD77FLJ21Accident · Minor injuriesClosedPiper PA-28R · Danville, VANTSB IAD77FIA12Accident · No injuriesClosedPiper PA-28R · Woodbridge, VANTSB IAD75FID18Accident · Serious injuriesClosedPiper PA-28R · Chesapeake, VA