NTSB investigations: Piper PA-24-180, FL

9 cases on aircraft the registry lists as Piper PA-24-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

19652026

NTSB investigations: Piper PA-24-180, FL per year, 1965–2026: 9 cases
1965	1
1966	1
1967	1
1970	1
1979	1
1981	1
1982	1
1985	1
1991	1

Where

Open the map

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 ('7102403')) 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 ('7102403'))
  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 ('7102403'))
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 MIA91LA180Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Valparaiso, FLPartial loss of engine power due to fuel contamination due to an inadequate preflight by the pilot in command and failure of the pilot to extend the landing gear during the forced landing.Jul 6, 1991 · N5953P · Substantial damage NTSB MIA85LA118Accident · No injuriesLimited investigationFinal reportPiper PA-24-180 · Zephyrhills, FLThe plt stated that he experienced a complete loss of power & upon making his emerg landing in a pasture, the acft struck fence posts, separating the right main landing gear. Investigation of the fuel system revealed there was no fuel in the left tank &…Mar 14, 1985 · N7639P · Substantial damage NTSB MIA82FA044Accident · 8 fatalField investigationFinal reportCessna 182B · W. Of Homestead, FLCessna N2280G and Piper N7361P collided in midair in a remote area of the everglades national park, Florida.Feb 7, 1982 · N2280G · 2 aircraft · Destroyed NTSB MIA81FA047Accident · 1 fatalClosedPiper PA-24 · Vero Beach, FLFeb 19, 1981 · N7078P · Destroyed NTSB MIA79FA118Accident · 2 fatalClosedPiper PA-24 · Melbourne, FLAug 27, 1979 · N5762P · Destroyed NTSB MIA71FLA24Accident · No injuriesClosedPiper PA-24 · Tallahassee, FLNov 28, 1970 · N5706P · Substantial damage NTSB MIA68D0321Accident · No injuriesClosedPiper PA-24 · W.Palm Beach, FLNov 29, 1967 · N6308P · Substantial damage NTSB MIA66D0556Accident · No injuriesClosedPiper PA-24 · Pensacola, FLApr 6, 1966 · N7566P · Substantial damage NTSB MIA66D0243Accident · No injuriesClosedPiper PA-24 · Chattahoochee, FLAug 7, 1965 · N6617P · Substantial damage