NTSB investigations: Piper PA-28-151, 1982
9 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 | 12 |
|---|---|
| 1975 | 22 |
| 1976 | 25 |
| 1977 | 29 |
| 1978 | 38 |
| 1979 | 22 |
| 1980 | 18 |
| 1981 | 14 |
| 1982 | 9 |
| 1983 | 10 |
| 1984 | 10 |
| 1985 | 5 |
| 1986 | 5 |
| 1987 | 7 |
| 1988 | 10 |
| 1989 | 4 |
| 1990 | 11 |
| 1991 | 9 |
| 1992 | 4 |
| 1993 | 9 |
| 1994 | 6 |
| 1995 | 11 |
| 1996 | 7 |
| 1997 | 8 |
| 1998 | 6 |
| 1999 | 4 |
| 2000 | 2 |
| 2001 | 4 |
| 2002 | 6 |
| 2003 | 4 |
| 2004 | 5 |
| 2005 | 8 |
| 2006 | 3 |
| 2007 | 7 |
| 2008 | 1 |
| 2009 | 7 |
| 2010 | 4 |
| 2012 | 3 |
| 2013 | 3 |
| 2014 | 3 |
| 2015 | 3 |
| 2016 | 1 |
| 2017 | 2 |
| 2018 | 3 |
| 2019 | 2 |
| 2020 | 5 |
| 2021 | 3 |
| 2022 | 4 |
| 2023 | 2 |
| 2024 | 4 |
| 2025 | 2 |
| 2026 | 3 |
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 year(c.\"eventDate\") = 1982
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 year(c."eventDate") = 1982
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 CHI83LA039Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-151 · New Hudson, MIThe pilot was giving a plane ride to his brother, his brother's grandson and the child's mother. The child's grandmother wanted to take pictures and walked into the parking area next to the taxiway. While looking through the viewfinder, her depth perception…NTSB DEN82DA203Accident · No injuriesFinal reportPiper PA-28-151 · Near Darby, MTSince the shook mountain resort airport was new to the pilot, he called the airport to get further information. He stated that the person who answered reported it was a nice day and the wind sock had blown down. During arrival, he approached from the…NTSB ATL82DA185Accident · No injuriesFinal reportPiper PA-28-151 · Duncan, MSPilot attempted takeoff from strip with 4 inch deep grass and a 75 degree crosswind. Occupants weighed total of 490 lbs. Temperature was 94 degrees. Aircraft mushed back into ground and pushed gear struts through wing.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 DEN82DA107Accident · No injuriesFinal reportPiper PA-28-151 · Jackson, MTThe pilot stated that he overshot the runway by being too high and that it was his intention to go around for a second pass. He further stated that his airspeed was too low and that he was behind the power curve and was not able to climb out of the valley at…NTSB NYC82DA048Accident · No injuriesFinal reportPiper PA-28-151 · Pittstown, NJAfter arriving from alexandria, NJ with an instructor pilot, the student made two practice landing at the Pittstown airport without incident. However, on a subsequent solo flight, the student pilot landed long on the 2000 ft runway. He stated that he ran off…NTSB MKC82DA033Accident · No injuriesFinal reportPiper PA-28-151 · Des Moines, IAThe aircraft had not been refueled after a previous flight of about one hour. The pilot visually checked the fuel and estimated 41 gallons remaining. He believed that he had about 5.2 hours of fuel. During an IFR flight, he diverted for an enroute fuel stop…NTSB CHI82DA052Accident · No injuriesFinal reportPiper PA-28-151 · Monee, ILThe pilot began his takeoff at the approach end of runway 27. He stated that the aircraft rolled straight for 700 ft, then at about 55 mph (lift-off speed), the plane veered left into a snowbank. The runway was 35 ft wide and was reported to have had frozen…NTSB LAX82FVM09Accident · 1 fatalFinal reportPiper 28-151 · Los Gatos, CAThe pilot prepared to depart on a scheduled courier run in a Piper PA-32, but was unable to start the engine. After consulting with company personnel, he rented a Piper PA-28-151, transferred the cargo and departed monterey, CA on a flight to oakland, CA.…