NTSB investigations: Piper PA-28-181
25 cases on aircraft the registry lists as Piper PA-28-181, where the first occurrence was “In flight collision with object”. 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
| 1982 | 1 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1988 | 2 |
| 1990 | 2 |
| 1991 | 1 |
| 1993 | 3 |
| 1994 | 2 |
| 1997 | 2 |
| 1998 | 2 |
| 1999 | 1 |
| 2001 | 1 |
| 2003 | 1 |
| 2007 | 2 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102807', '7102832')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 220))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102807', '7102832')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 220))
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 NYC07CA179Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Montauk, NYThe pilot's delayed decision to abort the landing, which resulted in an impact with a tree.NTSB NYC07CA067Accident · No injuriesData collectionFinal reportPiper PA-28-181 · Millbrook, NYThe pilot's failure to maintain a proper glidepath to the runway.NTSB FTW04FA037Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Sugar Land, TXThe pilots failure to maintain clearance with powerlines during a VFR approach. Contributing factors were the prevailing dark night conditions,and the high winds.NTSB SEA01LA130Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Tekoa, WAThe non-current pilot's failure to maintain sufficient altitude or clearance with wheat crops on short final, and the flight instructor's inadequate remedial action. Factors included wheat crops and a dirt bank on short final, the runway's lack of a visual…NTSB LAX99LA073Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Arlington, AZThe flight instructor's inadequate supervision of his student and his failure to initiate timely remedial action. Contributing factors were the student's failure to maintain the proper glidepath under the existing downdraft condition, the flight instructor's…NTSB DEN99FA009Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Montrose, COThe pilot's improper inflight planning/decision. Factors were a reduction in the airplane's climb and turn capabilities, the aft c.g. limit being exceeded, and the pilot's lack of familiarity with the geographic area and his lack of experience in the airplane…NTSB NYC98LA162Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · West Liberty, KYThe pilot's inadequate planning for a downslope landing. A factor was the pilot's lack of training for downslope landing situations.NTSB ATL98FA030Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Tallahassee, FLThe pilot's failure to maintain the proper glidepath and adequate obstacle clearance which resulted in collision with a power transmission line.NTSB NYC97LA107Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Walton, NYThe pilot's improper inflight decision to establish an approach without confirming the landing area, and his delayed go-around, which resulted in the inflight collision with trees.NTSB NYC95FA033Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Doylestown, PAthe pilot's descent below the published minimum circling altitude, and his failure to execute the published missed approach procedure during a night IFR instrument approach, which resulted in an in-flight collision with trees.NTSB BFO94LA148Accident · No injuriesLimited investigationFinal reportPiper PA -28-181 · Skowhegan, METhe pilot's failure to do a go around which resulted in an inflight collision with trees during a delayed aborted landing to avoid a runway overrun.NTSB LAX94LA077Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · San Diego, CAThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain a proper glidepath.NTSB CHI94LA024Accident · 1 fatalLimited investigationFinal reportPiper PA-28-181 · Woonsocket, SDthe pilot misjudging the airplane's clearance under the wires. Factors related to the accident were the performance of a low pass and the wires which were contacted.NTSB FTW93LA208Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Baton Rouge, LAThe student pilot's failure to abort the landing in a timely manner and his failure to maintain directional control.NTSB SEA91LA204Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Sunriver, ORThe pilot's inadequate compensation for wind conditions, which resulted in a failure to maintain runway alignment. The gusty crosswind was a related factor.NTSB CHI90LA275Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Amana, IAProper touchdown point not attained and go-around delayed by the pilot in command. Contributing factors were ATC communications inadequate and wet, grass runway with a tailwind environment plus a fence.NTSB NYC90FA063Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Fairfield, CTThe intoxicated pilot's failure to attain/maintain a safe altitude to provide clearance from the tree.NTSB MIA89FA033Accident · 4 fatalField investigationFinal reportPiper PA-28-181 · Jacksonville, FLDrg a ngt arrival, the plt requested a special VFR clnc to the arpt & was adzd that the wx was partially obscured, vis was 1 mi with fog & the wind was calm. As he contd the apch, all flts were adzd the vis had dropped to 1/2 mi. The plt requested clnc for an…NTSB CHI88LA247Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Orleans, INThe pilot failed to maintain an adequate visual lookout and to maintain adequate clearance from the utility pole and transmission wire. Contributing to the cause were the pilot's total lack of experience, task overload, and anxiety, stemming from a partial…NTSB MKC87FA092Accident · 2 fatalField investigationFinal reportPiper PA-28-181 · Valley, NEAt aprx 2020 CDT, witnesses saw the acft as the plt made svrl low passes over the platte river near Valley, NE. On the last pass, the acft struck power lines, then crashed in the river. The wreckage came to rest in the main channel of the river in aprx 25 ft…NTSB LAX86LA169Accident · No injuriesLimited investigationFinal reportPiper PA-28-181 · Hesperia, CADuring a solo instructional flight the student plt attempted to land on a 3910-foot-long rwy which had its landing threshold displaced by 550 feet. The wind was light & variable, & the student plt was low on short final approach. The acft collided with the…NTSB DEN85LA187Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Kiowa, COThe acft collided with a telephone wire and crashed. The plt admitted he had been flying over a boy scout ranch at 7500 ft MSL (about 500 ft AGL). He could not recall any other details. One witness said he saw the acft cross in front of his pickup truck at…NTSB SEA84FA139Accident · 1 fatalField investigationFinal reportPiper PA-28-181 · Burley, WAThe non-rated plt was employed as an acft cleaner & had access to the ignition keys of several acft, including N6950J. Earlier during the evening, he was seen consuming beer. At about 0024 PDT, he took off from rwy 18. About 1 min later, the acft collided…NTSB LAX84LA098Accident · Serious injuriesLimited investigationFinal reportPiper PA-28-181 · Livermore, CADuring arrival in IFR conditions, the plt was vectored for an ILS rwy 25 apch. At about 0909 PST, he was cleared for the apch & instructed to maintain 3000 ft until intercepting the localizer. A short time later, the controller instructed the plt to contact…NTSB SEA82DA069Accident · No injuriesFinal reportPiper PA 28-181 · Port Angeles, WAAbout 10 minutes after takeoff, the pilot realized that he was south of course. After beginning a shallow turn back to course, he realized that he was in close proximity to mountainous terrain. He made an abrupt 40 degree left bank to get away from the…