NTSB investigations: Piper PA-28R-180, VA
12 cases on aircraft the registry lists as Piper PA-28R-180. 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
| 1971 | 1 |
|---|---|
| 1972 | 1 |
| 1978 | 1 |
| 1979 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1985 | 1 |
| 1990 | 1 |
| 2001 | 2 |
| 2012 | 1 |
| 2013 | 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 ('7102809'))
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 ('7102809'))
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 ERA13CA362Accident · No injuriesData collectionFinal reportPiper PA-28R-180 · Fredericksburg, VAThe pilot’s inadequate pre-flight and in-flight planning and his failure to obtain a weather briefing at his intermediate stops, resulting in a missed approach at his destination and subsequent fuel exhaustion. The pilot’s fatigue due to lack of sleep may…NTSB ERA13CA091Accident · No injuriesData collectionFinal reportPiper PA28R · Newport News, VAThe pilot’s failure to properly monitor the flight controls (toe brake pedals) during engine start.NTSB IAD01FA053Accident · 1 fatalField investigationFinal reportPiper PA-28R-180 · Afton, VAThe pilot's loss of consciousness due to a medical condition, which resulted in his failure to maintain control of the airplane and subsequent impact with rising terrain.NTSB NYC01LA092Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Lexington, VAThe pilot's inadequate compensation for the runway conditions. Factors included the soggy runway conditions, and the lack of available takeoff performance data in the owners manual.NTSB BFO90FA073Accident · 3 fatalField investigationFinal reportPiper PA-28R-180 · Richland, VAThe pilot's inadvertent VFR flight into instrument meteorological conditions (IMC) and failure to maintain proper clearance from high terrain. Darkness and the adverse weather conditions were related factors.NTSB BFO85FID02Accident · Minor injuriesFinal reportPiper PA-28-R-180 · Brookneal, VAThe acft crash landed in small pine trees during a forced lndg after a pwr loss. The eng quit at 200 ft AGL and the acft crashed 1/2 mile from the end of the takeoff rwy. Investigation revealed a malfunction of the eng fuel pump.NTSB ATL84FIA02Accident · No injuriesFinal reportPiper PA-28R-180 · Manassas, VAThe plt reported that during a night landing, the right main gear failed & the acft went off the right side of the rwy. An FAA investigator reported that the acft had touched down hard during the landing.NTSB ATL82DA126Accident · Serious injuriesFinal reportPiper PA-28R-180 · Front Royal, VADuring flight the aircraft engine developed a noise which the pilot described as a hissing. The pilot declared an emergency, was vectored to the nearest airport, and proceeded to shut off the engine at 5000 feet when over the airport. During the forced…NTSB ATL80DID27Accident · No injuriesClosedPiper PA-28R · Norfolk, VANTSB IAD79FIA03Accident · Serious injuriesClosedPiper PA-28R · Standardsville, VANTSB NYC72FIA19Accident · Minor injuriesClosedPiper PA-28R · Mt Clinton, VANTSB NYC72DID11Accident · No injuriesClosedPiper PA-28R · Wingina, VA