Skip to content

NTSB investigations: Piper PA-24-250, AL

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

19642026

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" = 'AL' 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 ('7102404')) 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\" = 'AL' 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 ('7102404'))
  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" = 'AL' 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 ('7102404'))
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 ERA14LA325Accident · Minor injuriesLimited investigationFinal reportPiper PA 24-250 · Monroeville, ALA loss of engine power for reasons that could not be determined because postaccident examination of the engine and fuel system revealed no anomalies.Jul 3, 2014 · N5923P · Substantial damage NTSB ATL04LA024Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Troy, ALThe certified flight instructor's improper fuel management resulting in a loss of engine power due to fuel starvation resulting in a forced landing, in-flight collision with trees and ground.Oct 23, 2003 · N5920P · Substantial damage NTSB MIA01LA058Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Pittsview, ALThe failure of the pilot to conduct proper preflight planning, resulting in loss of engine power while in cruise flight due to fuel exhaustion, and the subsequent emergency descent and landing to an open field.Jan 9, 2001 · N5887P · Substantial damage NTSB ATL94LA105Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Foley, ALThe pilot's failure to maintain airspeed during the forced landing, resulting in an inadvertent stall and collision with the ground. The pilot's inadequate preflight and resultant improper positioning of the fuel selector were factors.May 24, 1994 · N5512P · Substantial damage NTSB ATL94FA046Accident · 2 fatalField investigationFinal reportPiper PA-24-250 · Centreville, ALThe pilot's failure to assure that the fuel selector was in the proper position for takeoff.Jan 28, 1994 · N6085P · Substantial damage NTSB ATL89LA002Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Monroeville, ALAccording to the plt, he had requested the acft be fully svcd with fuel before takeoff; however, he did not visually check the fuel. He rprtd that after takeoff, he had flown about 50 min when he noted the rgt tank, which he was using, indcd empty. He said he…Oct 1, 1988 · N100J · Destroyed NTSB MIA77DKJ11Accident · No injuriesClosedPiper PA-24 · Gadsden, ALJan 1, 1977 · N7507P · Substantial damage NTSB MIA77FKJ10Accident · No injuriesClosedPiper PA-24 · Birmingham, ALDec 16, 1976 · N2172M · Substantial damage NTSB MIA76FKJ33Accident · No injuriesClosedPiper PA-24 · Birmingham, ALNov 18, 1975 · N5304P · Substantial damage NTSB MIA75DKJ35Accident · No injuriesClosedPiper PA-24 · Fredonia, ALDec 1, 1974 · N5231P · Substantial damage NTSB MIA75DKJ16Accident · No injuriesClosedPiper PA-24 · Montgomery, ALAug 24, 1974 · N7507P · Substantial damage NTSB MIA72FKJ52Accident · No injuriesClosedPiper PA-24 · Birmingham, ALApr 23, 1972 · N5496P · Substantial damage NTSB MIA72DKJ49Accident · No injuriesClosedPiper PA-24 · Uniontown, ALApr 4, 1972 · N6394P · Substantial damage NTSB MIA72FKJ40Accident · No injuriesClosedPiper PA-24 · Montgomery, ALFeb 3, 1972 · N5663P · Substantial damage NTSB MIA68F0455Accident · No injuriesClosedPiper PA-24 · Selma, ALMar 26, 1968 · N7348P · Substantial damage NTSB MIA68F0339Accident · Minor injuriesClosedPiper PA-24 · Muscle Shoals, ALNov 14, 1967 · N5203P · Substantial damage NTSB MIA68F0225Accident · No injuriesClosedPiper PA-24 · Alabaster, ALOct 4, 1967 · N5949P · Substantial damage NTSB MIA68F0035Accident · No injuriesClosedPiper PA-24 · Mobile, ALJul 8, 1967 · N7749P · Substantial damage NTSB MIA66F0422Accident · No injuriesClosedPiper PA-24 · Montgomery, ALFeb 6, 1966 · N5243P · Substantial damage NTSB MIA66D0427Accident · No injuriesClosedPiper PA-24 · Grove Hill, ALNov 27, 1965 · N6523P · Substantial damage NTSB MIA66F0177Accident · No injuriesClosedPiper PA-24 · Clanton, ALJul 26, 1965 · N6502P · Substantial damage NTSB UNK65X1377Accident · No injuriesClosedPiper PA24 · Gadsden, ALJan 31, 1965 · N7548P · Substantial damage NTSB UNK65X0755Accident · No injuriesClosedPiper PA24 · Montgomery, ALNov 19, 1964 · N7812P · Substantial damage NTSB UNK64X1833Accident · No injuriesClosedPiper PA24 · Birmingham, ALMay 18, 1964 · N6646P · Substantial damage