Skip to content

NTSB investigations: Piper PA-28R-180, FL

25 cases on aircraft the registry lists as Piper PA-28R-180. 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 per year

19692026

Where

Latest cases

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."eventStateOrRegion" = 'FL' 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 ('7102809')) 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.\"eventStateOrRegion\" = 'FL' 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 ('7102809'))
  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" = 'FL' 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 ('7102809'))
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 ERA23LA217Accident · No injuriesClass 4 · LimitedFinal reportPiper PA28R · Defuniak Springs, FLThe pilot's failure to maintain directional control while taking off in a crosswind, which resulted in a runway excursion and impact with a berm. Contributing was the automated weather briefing which failed to include accurate wind information.May 4, 2023 · N3796T · Substantial damage NTSB ERA18LA268Accident · Minor injuriesLimited investigationFinal reportDiamond DA20 · Sebring, FLThe inability of the pilot of the Piper and the student pilot and flight instructor of the Diamond to see and avoid the other airplane. Contributing to the collision was the Piper pilot’s failure to use the correct common traffic advisory frequency to…Sep 29, 2018 · N397JA · 2 aircraft · Substantial damage NTSB ERA15LA289Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fort Lauderdale, FLThe undetected fatigue cracks in the engine and nose landing gear (NLG) strut mount assembly, which prevented the proper alignment of the NLG after it was extended and the pilots from being able to maintain directional control after touchdown.Jul 23, 2015 · N4631J · Substantial damage NTSB ERA13LA049Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Fort Lauderdale, FLThe collapse of the right main landing gear during landing for reasons that could not be duplicated or determined during the postaccident investigation because of the initial unavailability of the airplane after the accident.Nov 5, 2012 · N4534J · Substantial damage NTSB MIA06LA019Accident · Minor injuriesLimited investigationFinal reportPiper PA-28R-180 · Heathrow, FLA partial loss of engine power due to undetermined reasons resulting in a forced landing in a residential area.Nov 16, 2005 · N7453J · Substantial damage NTSB MIA06LA015Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Opa-Locka, FLThe failure of the pilot-in-command/CFI to maintain control of the airplane and his inattentiveness to the altitude while troubleshooting the landing gear system resulting in the in-flight collision with terrain.Nov 6, 2005 · N4652J · Substantial damage NTSB MIA03LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Sarasota, FLA loss of engine power due to the crankshaft bolt losing torque, the gear disengaging, and the engine ceasing to operate as a result of inadequate maintenance installation.Apr 1, 2003 · N4952J · Substantial damage NTSB ATL01LA014Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Merritt Island, FLMaintenance personnel failure to properly install engine cowling fasteners, which allowed the engine cowling to separate in flight.Nov 27, 2000 · N4914J · Substantial damage NTSB MIA99LA179Accident · 1 fatalLimited investigationFinal reportPiper PA-28R-180 · Wimauma, FLa passenger deplaning the airplane while the engine was running struck the propeller.Jun 13, 1999 · N7485J · No damage NTSB MIA92LA016Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · Daytona Beach, FLThe failure of the pilot in command of N136AT to maintain clearance from N3110R while diverting her attention to close her door during taxi to takeoff.Oct 24, 1991 · N136AT · 2 aircraft · Substantial damage NTSB MIA91LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · New Port Richey, FLIn-flight encounter with wind gusts while flaring to land and failure of the pilot to maintain directional control and failure to perform a goaround.Mar 29, 1991 · N7454J · Substantial damage NTSB MIA86LA244Accident · No injuriesLimited investigationFinal reportPiper PA-28-R · Cedar Key, FLThe plt stated that he lost fuel pressure and all attempts to restart the acft were to no avail. He tried to make it to Cedar Key but was unable and ditched in the ocean waters 6 miles northwest of Cedar Key. Post crash examination of the fuel system revealed…Aug 27, 1986 · N4524J · Substantial damage NTSB MIA86LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28R-180 · Tallahassee, FLWhile on final apch the acft was blown to the right of the rwy where the left wing struck a dirt mound. The acft then spun to the left and came to rest aprx 75 ft from the edge of the rwy. The plt stated that he decided to try and salvage the landing during…May 16, 1986 · N4986J · Substantial damage NTSB MIA78FLD62Accident · No injuriesClosedPiper PA-28R · Eustis, FLJul 11, 1978 · N4585J · Substantial damage NTSB MIA77DKT14Accident · Minor injuriesClosedPiper PA-28 · Miami, FLJan 6, 1977 · N4692J · Substantial damage NTSB MIA77FA013Accident · 2 fatalClosedPiper PA-28R · Tallahassee, FLNov 27, 1976 · N4615J · Destroyed NTSB MIA74DLD32Accident · No injuriesClosedPiper PA-28R · Cedar Key, FLSep 23, 1973 · N3777T · Substantial damage NTSB MIA74F1A03Accident · No injuriesClosedPiper PA-28R · Tallahassee, FLJul 24, 1973 · N7445J · Substantial damage NTSB MIA73FLD32Accident · No injuriesClosedPiper PA-28R · Sanford, FLNov 14, 1972 · N7609J · Substantial damage NTSB MIA72FLA08Accident · No injuriesClosedPiper PA-28R · Gainesville, FLSep 6, 1971 · N3923T · Substantial damage NTSB MIA71DLA43Accident · No injuriesClosedPiper PA-28 · Gainesville, FLApr 12, 1971 · N7532J · Substantial damage NTSB MIA71DLD26Accident · No injuriesClosedPiper PA-28R · Clearwater, FLOct 16, 1970 · N7590J · Substantial damage NTSB MIA70D0196Accident · No injuriesClosedPiper PA-28R · Boca Raton, FLOct 6, 1969 · N7626J · Substantial damage NTSB MIA70D0187Accident · No injuriesClosedPiper PA-28R · Tampa, FLSep 20, 1969 · N7588J · Substantial damage NTSB MIA70F0149Accident · No injuriesClosedPiper PA-28R · Tampa, FLAug 8, 1969 · N4524J · Substantial damage