NTSB investigations: Piper PA-28-151, 1983
10 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\") = 1983
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") = 1983
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 MKC83FA205Accident · 2 fatalField investigationFinal reportPiper PA-24-151 · Chesterfield, MOThe plt landed a lawrenceburg, TN, on the evening of 8/28/83. Thunderstorms were reported in the area at that time. At lawrenceburg, fuel was available during daylight hours. At 0203 the next morning, the plt called the muscle shoals fss & obtained a wx…NTSB MIA83LA195Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Lantana, FLDuring flt the eng started vibrating & the CFI noted zero oil pressure. The eng failed. The acft sustained substantial damage during the forced landing. Exam of the oil line, P/N63901-49, revealed that it was frayed & broken allowing oil to be pumped from the…NTSB FTW83LA321Accident · Minor injuriesLimited investigationFinal reportPiper PA28-151 · Mandeville, LAOn a cross country flight in normal cruise at 2000 ft AGL the engine quit. The pilot made a forced landing to a road. During landing roll the left wing struck a vehicle. The acft then slid into a ditch. Post accident investigation revealed that an oil line…NTSB CHI83LA283Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Alma, MIThe acft collided with the VASI lights during landing. The pilot was landing on rwy 27 with winds from 210 degrees at 12 KTS. He reported gusty winds but gave no estimated velocity of the gusts. He said he touched down on the right main gear with the left…NTSB LAX83FA253Accident · 1 fatalField investigationFinal reportPiper PA-28-151 · Norco, CAThe student plt had flown to the riverton arpt to attend a ground school. Reportedly, prior to his departure at aprx 2235 PDT, stars were visible overhead, but the horizontal visibility was poor & there was a haze layer at about 500 ft AGL. At aprx 2250, a…NTSB CHI83LA227Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Elgin, ILThe acft collided with the roof of a trailer truck during an approach to land over a toll road. The collision separated the left main gear from the acft and damaged the other two landing gear. The impact left two depressions about 2 inches deep in the edge of…NTSB LAX83LA212Accident · No injuriesLimited investigationFinal reportPiper PA-28-151 · Milpitas, CAWhile descending thru 4300 ft, the eng lost power. The plt made an emergency landing on a gulf course, but during the landing roll, the right wing of the acft impacted a pole & was damaged. An exam revealed that the 5/16 inch bolt, pn STD-847, that secured…NTSB LAX83FA387Accident · 2 fatalField investigationFinal reportPiper PA-28-151 · Trinity Center, CAThe acft departed creswell, OR, sometime after 1800 PST on 3/19/83. At 2110 PST, the plt contacted portland flt watch by radio & stated that he was over roseburg, or at 9500 ft. he requested pireps of wx over the siskiyou mountains & into the san francisco…NTSB LAX83LA107Accident · No injuriesLimited investigationFinal reportPiper PA28-151 · Grand Canyon, AZThe acft was blown off the right side of the runway during the flare for landing and the gear collapsed after landing. The pilot received a weather briefing and wind warning. He stated that the acft floated about 2000 feet down the runway after he flared…NTSB NYC83FA062Accident · No injuriesField investigationFinal reportPiper PA-28-151 · Newbury, MAAfter takeoff, the plt leveled at 2500 ft & after cruising for about 20 min, descended to 1500 ft MSL. Shortly after leveling at 1500 ft, there was a slight reduction in engine RPM. The plt stated that he applied carburetor heat, but the RPM continued to…