NTSB investigations: Piper PA-28-161, UT
13 cases on aircraft the registry lists as Piper PA-28-161. 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
| 1978 | 1 |
|---|---|
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1985 | 1 |
| 1987 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 1995 | 1 |
| 1998 | 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\" = 'UT' 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 ('7102803', '7102834'))
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" = 'UT' 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 ('7102803', '7102834'))
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 FTW98LA352Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-161 · Huntsville, UTThe flight instructor's failure to ensure adequate altitude/clearance with terrain, resulting in an encounter with a downdraft, loss of airspeed, onset of a stall/mush, and collision with high terrain.. Contributing factors were high density altitude,…NTSB SEA96LA048Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Salt Lake City, UTa carburetor fire.NTSB SEA93LA215Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Tooele, UTThe pilot in command's failure to maintain directional control. A factor contributing to the accident was the fence.NTSB SEA92FA042Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Ogden, UTThe improper decision by the instructor pilot to perform maintenance in flight and his failure to maintain terrain clearance. Factors relating to the accident were the dark night light conditions, mountainous terrain in the area, and the instructor diverting…NTSB SEA92LA012Accident · Minor injuriesLimited investigationFinal reportPiper PA28-161 · Duchesne, UTFuel exhaustion due to the pilot's inattention and becoming lost. A factor to the accident was the night conditions.NTSB DEN90LA062Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Nephi, UTFailure of the pilot to maintain direction control and correct the resultant ground swerve. The snow bank was a related factor.NTSB DEN88FA096Accident · 1 fatalField investigationFinal reportPiper PA-28-161 · Milford, UTThe plt (with a recent instrument rating) rcvd a wx briefing fm cedar city (cdc) fss & filed an IFR flt plan fm provo (pvu) to st george (sgu). Current sgu wx wasn't available, but wx for cdc (abt 45 mi nne) was provided. The plt was adzdof moist unstable…NTSB DEN88FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-161 · Draper, UTDrg a ngt flt to reposition the acft to its home base, the eng lost pwr as the plt was cruising at about 1000' AGL. He transmitted a 'mayday' call & maneuvered the acft to make a forced lndg on an interstate hiway. While apchg to lnd, the acft struck the top…NTSB DEN85LA197Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Bountiful, UTThe student plt departed the arpt to practice touch-&-go landings. On the 5th apch, the acft was observed to be low. The plt failed to add pwr and the acft contacted an arpt boundary fence.NTSB DEN81FTM13Accident · Minor injuriesClosedPiper PA-28 · Alton, UTNTSB DEN80FTM21Accident · No injuriesClosedPiper PA-28 · Nephi, UTNTSB DEN79FA022Accident · 1 fatalClosedPiper PA-28 · Logan, UTNTSB DEN78FTM12Accident · No injuriesClosedPiper PA-28 · Provo, UT