Skip to content

NTSB investigations: Piper PA-28-235

579 cases on aircraft the registry lists as Piper PA-28-235. 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.

Defining event

Finding

Phase of flight

Aircraft model

Cases, newest first

Query with SQL

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 ('7102810')) ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

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 ('7102810'))
  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 ('7102810'))
ORDER BY c."eventDate" DESC, c."ntsbNumber" DESC

Run 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 MIA84LA114Accident · 4 fatalLimited investigationFinal reportPiper PA-28-235 · Sanibel Island, FLThe acft failed to arrive at its destination. A satellite photo of the area showed wx & cloud cover between the departure & destination arpts. Radar data showed that an acft had left key west, FL, at about 1700, went northbound at 4500 until it encounter bad…Mar 12, 1984 · N39677 · Destroyed NTSB LAX84FA118Accident · No injuriesField investigationFinal reportPiper PA28-235 · Irwindale, CAAccording to the flt instr the eng lost pwr after the stu had completd varous turning maneuvers. He stated that the fuel sel was in the left main position and estimated that there were 18 gals in that tank, 25 gals in the right tank,5 gals in the left tip…Dec 28, 1983 · N55665 · Substantial damage NTSB DEN83FA180Accident · 4 fatalField investigationFinal reportPiper PA-28-235C · Pitkin, COThe acft was on a x-country flt from camarillo, CA to oshkosh, WI. The plt landed at about noon at montrose, CO, where the acft was refueled & the occupants went to a restaurant to eat. After departing montrose, the acft was seen flying low over rising,…Jul 27, 1983 · N9378W · Destroyed NTSB DEN83LA134Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-235 · Hamilton, MTGround roll during takeoff was normal but at liftoff the acft began a roll to the left. The pilot said he began the takeoff with less than full power but added full power as the turn began. He tried to correct with aileron to no avail. The acft was now…Jun 5, 1983 · N8787W · Substantial damage NTSB SEA83LA019Accident · No injuriesLimited investigationFinal reportPiper PA-28-235 · Vernonia, ORThe acft was observed high & fast during the approach & touched down about 300 ft from the departure end of the turf rwy. During the go-around the acft struck a wood fence, crossed a road & crashed in a "stumped off" area.Nov 14, 1982 · N9459W · Destroyed NTSB DEN82DA167Accident · Serious injuriesFinal reportPiper PA-28-235 · Englewood, COThe engine quit on downwind and the pilot attempted to land downwind on the runway but crashed off the airport. The fuelselector was found on an auxiliary tank. According to the pilot and other operators of the aircraft, only about three gallons of fuel are…Aug 18, 1982 · N16541 · Substantial damage NTSB MKC82DA144Accident · No injuriesFinal reportPiper PA-28-235 · Springfield, MOAfter passing over an imaginary obstacle during a short field landing, the student flared high without adding sufficientpower causing the acft to increase the descent rate. The CFI took control but was too late resulting in a hard landing.Aug 10, 1982 · N7904C · Substantial damage NTSB MKC82DA127Accident · No injuriesFinal reportPiper PA-28-235D · Falls City, NEThe pilot reported that while he was landing with a 6 to 7 kt crosswind, the plane was blown toward the left side of the runway. In order to avoid the runway lights, he intentionally maneuvered the aircraft off the side of the runway, into the grass. When he…Jul 18, 1982 · N8532N · Substantial damage NTSB ANC82DAG35Accident · Minor injuriesFinal reportPiper PA-28-140 · Wasilla, AKPilot had opportunity to refuel and did not. On one flight before accident he successfully made a forced landing due to fuel starvation. He figured he had enough fuel for one more flight. During this flight engine quit and the pilot landed in a ditch…Jul 12, 1982 · N9891W · Substantial damage NTSB CHI82DA122Accident · Minor injuriesFinal reportPiper PA-28-235 · Graytown, OHDuring landing roll the aircraft contacted a soft area on the pilot's privately owned sod runway. The nose gear collapsed and the aircraft came to rest with the tail in the air.Apr 15, 1982 · N9010W · Destroyed NTSB FTW82DA106Accident · Minor injuriesFinal reportPiper PA-28-235 · Tulsa, OKThe aircraft experienced a partial power loss during takeoff at an altitude of about 150 AGL. The pilot turned left with the intention of landing on a perpendicular taxiway. During the turn the aircraft developed a high sink-rate and struck the taxiway in a…Mar 26, 1982 · N8904W · Substantial damage NTSB LAX82FA049Accident · 2 fatalField investigationFinal reportMooney M20C · Victorville, CAThe pilot had planned to fly to the big bear airport, but changed his destination to apple valley, California. While on an easterly heading at about 6800 ft MSL, a collision occurred with another aircraft, a Mooney M20C, N7860V. The Piper pilot believed that…Jan 23, 1982 · N7860V · 2 aircraft · Destroyed NTSB LAX82FA050Accident · 1 fatalField investigationFinal reportPiper PA-28-235 · 10nm N. Of Mcna, AZWhile on a cross country flight the pilot flew into weather which included severe to moderate icing conditions. Although the weather was forecast for the intended route of flight in a SIGMET it was not provided to the pilot during the initial weather…Jan 22, 1982 · N41664 · Destroyed NTSB FTW82DQD05Accident · No injuriesClosedPiper PA-28 · Silver City, NMNov 25, 1981 · N15735 · Substantial damage NTSB DEN81FTK24Accident · No injuriesClosedPiper PA-28 · Custer, SDSep 28, 1981 · N15358 · Substantial damage NTSB ANC81DAG90Accident · Minor injuriesClosedPiper PA-28 · Anchorage, AKSep 18, 1981 · N235JC · Substantial damage NTSB SEA81FYM42Accident · Serious injuriesClosedPiper PA-28 · Medical Spgs, ORSep 5, 1981 · N8723W · Substantial damage NTSB ANC81DAG62Accident · Minor injuriesClosedPiper PA-28 · Iliamna, AKJul 29, 1981 · N8542N · Substantial damage NTSB FTW81FPM13Accident · Minor injuriesClosedPiper PA-28 · Tulsa, OKJun 20, 1981 · N8510W · Substantial damage NTSB CHI81FCA07Accident · No injuriesClosedPiper PA-28 · Highland, ILMay 11, 1981 · N49887 · Substantial damage NTSB MKC81DCQ19Accident · No injuriesClosedPiper PA-28 · Hugoton, KSMar 29, 1981 · N9097W · Substantial damage NTSB FTW81DQG14Accident · No injuriesClosedPiper PA-28 · Amarillo, TXFeb 21, 1981 · N419CC · Destroyed NTSB LAX81FA072Accident · 4 fatalClosedPiper PA-28 · Truckee, CAFeb 13, 1981 · N9431W · Destroyed NTSB FTW81FPJ09Accident · No injuriesClosedPiper PA-28 · Enid, OKJan 8, 1981 · N38558 · Substantial damage NTSB LAX81FVA16Accident · Minor injuriesClosedPiper PA-28 · Fresno, CADec 15, 1980 · N9390W · Substantial damage NTSB NYC81DFA05Accident · No injuriesClosedPiper PA-28 · Accord, NYNov 9, 1980 · N9392W · Substantial damage NTSB SEA81DYA02Accident · No injuriesClosedPiper PA-28 · Blackfoot, IDOct 6, 1980 · N15442 · Substantial damage NTSB CHI80FEK24Accident · Minor injuriesClosedPiper PA-28 · Bellefonatine, OHAug 13, 1980 · N8766W · Substantial damage NTSB CHI80FA060Accident · 1 fatalClosedPiper PA-28 · Lake City, MIJul 26, 1980 · N15336 · Destroyed NTSB FTW80DQG29Accident · No injuriesClosedPiper PA-28 · Robert Lee, TXJul 5, 1980 · N56612 · Substantial damage NTSB ATL80FA068Accident · 3 fatalClosedPiper PA-28 · Star Tannery, VAJul 2, 1980 · N5908V · Destroyed NTSB LAX80FA055Accident · 2 fatalClosedPiper PA-28 · Palmdale, CAFeb 17, 1980 · N4517X · Destroyed NTSB LAX80DVG13Accident · No injuriesClosedPiper PA-28 · Vacaville, CAJan 19, 1980 · N8908W · Substantial damage NTSB IAD80FKW05Accident · No injuriesClosedPiper PA-28 · Carryville, TNJan 15, 1980 · N9216W · Substantial damage NTSB LAX79FUG50Accident · No injuriesClosedPiper PA-28 · Temecula, CAAug 1, 1979 · N75308 · Substantial damage NTSB LAX79DUJ88Accident · No injuriesClosedPiper PA-28 · Douglas, AZJun 24, 1979 · N4591X · Substantial damage NTSB MIA79DKT74Accident · Minor injuriesClosedPiper PA-28 · Miami, FLJun 21, 1979 · N57347 · Substantial damage NTSB FTW79FPJ12Accident · 1 fatalClosedPiper PA-28 · Purcell, OKApr 26, 1979 · N8530W · Destroyed NTSB CHI79FEE53Accident · No injuriesClosedPiper PA-28 · Cherry, ILApr 25, 1979 · N5KS · Substantial damage NTSB CHI79FA035Accident · 2 fatalClosedPiper PA-28 · Park Forrest, ILMar 17, 1979 · N9458W · Destroyed NTSB CHI79DEC20Accident · Minor injuriesClosedPiper PA-28 · Pontiac, MIMar 17, 1979 · N8879W · Substantial damage NTSB OAK79FVG19Accident · No injuriesClosedPiper PA-28 · Galt, CAMar 5, 1979 · N56649 · Substantial damage NTSB NYC79FNA05Accident · No injuriesClosedPiper PA-28 · New Bedford, MADec 1, 1978 · N9436W · Substantial damage NTSB IAD79FKM04Accident · Minor injuriesClosedPiper PA-28 · Salisbury, NCOct 29, 1978 · N9056W · Substantial damage NTSB NYC79FHM01Accident · Minor injuriesClosedPiper PA-28 · Caldwell, NJOct 1, 1978 · N9443W · Substantial damage NTSB IAD78FA094Accident · 4 fatalClosedPiper PA-28 · Hemlock, WVAug 13, 1978 · N8789W · Destroyed NTSB DEN78FA057Accident · 5 fatalClosedPiper PA-28 · Silverplume, COAug 12, 1978 · N8719W · Destroyed NTSB OAK78DVG63Accident · No injuriesClosedPiper PA-28 · Redding, CAJul 21, 1978 · N44308 · Substantial damage NTSB MKC78FA050Accident · 2 fatalClosedPiper PA-28 · Columbus, NEJun 23, 1978 · N8993W · Destroyed NTSB DEN78FQA31Accident · No injuriesClosedPiper PA-28 · Albuquerque, NMJun 18, 1978 · N8840W · Substantial damage