Skip to content

NTSB investigations: Piper PA-24-250, MO

30 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" = 'MO' 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\" = 'MO' 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" = 'MO' 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 CEN26FA280Accident · 1 fatalClass 3 · FieldPreliminary reportPiper PA-24-250 · Bethany, MOOn August 4, 2026, about 1839 central daylight time, a Piper PA-24-250 airplane, N8422P, was destroyed when it was involved in an accident near Bethany, Missouri. The pilot received fatal injuries. The airplane was operated under Title 14 Code of Federal…Aug 4, 2026 · N8422P · Destroyed NTSB CEN10LA370Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Centerville, MOA loss of engine power due to carburetor icing as a result of the pilot not using carburetor heat.Jul 2, 2010 · N5798P · Substantial damage NTSB CHI05LA069Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Bolivar, MOA loss of engine power due to the pilot's inaccurate preflight and inflight planning which resulted in an inadequate fuel supply for the flight, and the subsequent fuel exhaustion. A factor associated with the accident was the trees that the airplane…Feb 11, 2005 · N5961P · Substantial damage NTSB CHI01FA146Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · Osage Beach, MOAircraft control not being maintained by the pilot during the forced landing and inadequate preflight inspection performed by the pilot. Contributing factors to the accident were the fuel system contamination that resulted in the loss of engine power, the…May 28, 2001 · N7331P · Substantial damage NTSB CHI93LA079Accident · Serious injuriesLimited investigationFinal reportPiper PA-24 · Buffalo, MOThe pilot's failure to refuel the airplane prior to fuel exhaustion.Jan 27, 1993 · N5322P · Substantial damage NTSB MKC87LA180Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Osage Beach, MOWhile performing as PIC during a biennial flt review, the CFI requested that the owner perform a short fld lndg using full flaps in cross wind conditions. The acft struck the terrain 50 feet short of the rwy and bounced onto the approach end of it. The CFI…Sep 26, 1987 · N5279P · Substantial damage NTSB MKC85LA015Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Aurora, MOThe acft was landed gear up. The student plt put the gear down on downwind and then on a pre-landing check on final apchthe student retracted the gear. The CFI said the warning horn never sounded and she did not notice that the gear was up.Nov 2, 1984 · N5274P · Substantial damage NTSB MKC82DA026Accident · No injuriesFinal reportPiper PA-24-250 · Liberty, MOThe instructor pilot reported encountering wind shear at about 12 to 15 ft AGL during a short field landing on runway 19. She stated that there were several obstructions that could create a wind effect. The surface wind was from the northeast at five knots.…Jan 8, 1982 · N7618P · Substantial damage NTSB MKC78FCA06Accident · No injuriesClosedPiper PA-24 · Fenton, MONov 20, 1977 · N6958P · Substantial damage NTSB MKC76FCG92Accident · No injuriesClosedPiper PA-24 · Joplin, MOJul 25, 1976 · N29BJ · Substantial damage NTSB MKC75AK044Accident · 2 fatalClosedPiper PA-24 · Racine, MOFeb 27, 1975 · N5742P · Destroyed NTSB MKC72FCA29Accident · Minor injuriesClosedPiper PA-24 · Tyrone, MOJun 10, 1972 · N5909P · Substantial damage NTSB MKC71DCA04Accident · Minor injuriesClosedPiper PA-24 · New Haven, MOJul 25, 1970 · N5695P · Substantial damage NTSB MKC70F0074Accident · No injuriesClosedPiper PA-24 · Sarcoxie, MOJul 7, 1969 · N487SC · Substantial damage NTSB MKC68F0457Accident · No injuriesClosedPiper PA-24 · De Soto, MOFeb 19, 1968 · N5915P · Substantial damage NTSB MKC68A0034Accident · 2 fatalClosedPiper PA-24 · Aurora, MONov 23, 1967 · N6275P · Destroyed NTSB MKC68F0415Accident · No injuriesClosedPiper PA-24 · Lambert Field, MOOct 31, 1967 · N8016P · Substantial damage NTSB MKC68F0431Accident · No injuriesClosedPiper PA-24 · St.Charles, MOAug 12, 1967 · N7272P · Substantial damage NTSB MKC68D0138Accident · No injuriesClosedPiper PA-24 · Bigelow, MOJul 29, 1967 · N6803P · Substantial damage NTSB MKC67D0550Accident · No injuriesClosedPiper PA-24 · Columbia, MOJan 13, 1967 · N7451P · Substantial damage NTSB MKC67F0335Accident · No injuriesClosedPiper PA-24 · Republic, MONov 28, 1966 · N6264P · Substantial damage NTSB MKC67F0192Accident · Serious injuriesClosedPiper PA-24 · Mt Vernon, MOAug 21, 1966 · N5701P · Substantial damage NTSB MKC66F0190Accident · No injuriesClosedPiper PA-24 · Grain Valley, MOJul 25, 1965 · N5528P · Destroyed NTSB MKC66F0123Accident · No injuriesClosedPiper PA-24 · Cassville, MOJun 22, 1965 · N5915P · Substantial damage NTSB MKC66F0013Accident · No injuriesClosedPiper PA-24 · St Charles, MOApr 30, 1965 · N7272P · Substantial damage NTSB MKC65D0133Accident · No injuriesClosedPiper PA-24 · Chillicothe, MOJan 12, 1965 · N8031P · Substantial damage NTSB UNK65X0457Accident · 4 fatalClosedPiper PA-24 · West Alton, MOOct 27, 1964 · N7013 · Destroyed NTSB UNK64X3719Accident · No injuriesClosedPiper PA24 · Cabool, MOSep 1, 1964 · N8316P · Substantial damage NTSB UNK64X2659Accident · Minor injuriesClosedPiper PA24 · Patton, MOJul 5, 1964 · N5155P · Substantial damage NTSB UNK64X1823Accident · Minor injuriesClosedPiper PA24 · Monett, MOMay 18, 1964 · N7697P · Substantial damage