NTSB investigations: Piper PA-28-180, WV
15 cases on aircraft the registry lists as Piper PA-28-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
| 1964 | 1 |
|---|---|
| 1968 | 1 |
| 1970 | 2 |
| 1972 | 1 |
| 1974 | 2 |
| 1975 | 2 |
| 1976 | 1 |
| 1977 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 2003 | 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\" = 'WV' 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 ('7102808'))
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" = 'WV' 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 ('7102808'))
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 NYC03FA113Accident · 1 fatalField investigationFinal reportPiper PA-28-180 · Bruceton Mills, WVThe pilot's intentional decision to continue visual flight into instrument meteorological conditions, and his failure to maintain obstacle clearance which resulted in the airplane striking a guy wire on the communications antenna. A factor was the fog.NTSB BFO89LA070Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-180 · Clendenin, WVInadequate preflight planning/preparation by the pilot which resulted in fuel exhaustion. The weather conditions, the pilot's delay in diverting to an alternate airport, and the light pole were contributing factors.NTSB BFO88LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-180 · Racine, WVThe pilot was on the first leg of a ferry flight to west germany. The aircraft was about 30 miles from charleston when the pilot noticed the fuel gauges indicated about 5 & 11 gals respectively remaining in the left & right fuel tanks. He proceeded to…NTSB ATL83LA314Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Normantown, WVThe plt noticed smoke in the cockpit, & soon thereafter observed the oil press gage reading zero. The plt was given radar vectors to the nearest arpt but he was unable to reach it. The acft collided with trees & a powerline during the forced landing.…NTSB IAD78FA012Accident · 1 fatalClosedPiper PA28 · Ashford, WVNTSB IAD76FIJ10Accident · Serious injuriesClosedPiper PA-28 · Greenwood, WVNTSB IAD76FIJ01Accident · No injuriesClosedPiper PA-28 · Weston, WVNTSB IAD75FIJ20Accident · No injuriesClosedPiper PA-28 · Taplin, WVNTSB IAD75AI029Accident · 3 fatalClosedPiper PA-28 · Morgantown, WVNTSB IAD74DIJ16Accident · No injuriesClosedPiper PA-28 · S.Charleston, WVNTSB NYC73FIG17Accident · No injuriesClosedPiper PA-28 · Martinsburg, WVNTSB IAD71DIJ13Accident · No injuriesClosedPiper PA-28 · Morgantown, WVNTSB IAD71AI022Accident · 2 fatalClosedPiper PA-28 · Terra Alta, WVNTSB DIA68D0150Accident · No injuriesClosedPiper PA-28 · Summersville, WVNTSB UNK65X0588Accident · No injuriesClosedPiper PA-28 · Parkersburg, WV