NTSB investigations: Piper PA-28-151, WI
7 cases on aircraft the registry lists as Piper PA-28-151. 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
| 1974 | 1 |
|---|---|
| 1978 | 1 |
| 1982 | 1 |
| 1985 | 1 |
| 1988 | 1 |
| 1995 | 1 |
| 2005 | 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\" = 'WI' 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 ('7102805', '7104223'))
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" = 'WI' 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 ('7102805', '7104223'))
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 CHI05LA086Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Waunakee, WIThe pilot's inadequate preflight planning and the delay in aborting the landing which resulted in the subsequent insufficient airspeed. Factors associated with the accident were the night light conditions, the fence, and the pole which the airplane contacted.NTSB CHI96FA029Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Fond Du Lac, WIthe pilot's intentional VFR flight into instrument meteorological conditions, and his failure to maintain altitude. Factors included the weather obscuration due to snow and fog, the dark night, and the pilot's lack of recent night flight time.NTSB CHI88LA238Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Kenosha, WIWhile on a VFR approach to the airport, at night, the pilot misidentified the street lights in a mobile home park as the runway lights and descended into wires. Afterward the pilot was able to continue to the intended runway and made a successful landing.…NTSB CHI85FA253Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Reedsburg, WINo known witnesses observed the plt preflt the acft or takeoff. He departed in the evening while the arpt was not attended. At aprx 2012 CDT, his son observed & recognized the acft. At that time, the son was at his own home about 1/2 mi from the plt's home.…NTSB CHI82DA219Accident · Minor injuriesFinal reportPiper PA-28-151 · Pardeeville, WIThe pilot reported that he was making an approach to the sod runway (36). He stated that when he was about treetop high, a gust of wind picked up the left wing of the aircraft and it drifted to the right of the runway. Subsequently, the right wing struck a…NTSB CHI78FEP56Accident · No injuriesClosedCessna 172M · Oshkosh, WINTSB CHI74DEP38Accident · No injuriesClosedPiper PA-28 · Sheboygn Fall, WI