Skip to content

NTSB investigations: Piper PA-24-250, MT

22 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" = 'MT' 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\" = 'MT' 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" = 'MT' 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 SEA01LA148Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Thompson Falls, MTThe pilot's inadequate compensation in gusting wind conditions during the landing flare. A tree was a factor.Aug 9, 2001 · N699WL · Substantial damage NTSB SEA00LA006Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Bozeman, MTThe pilot-in-command's (CFI) failure to take remedial action. Factors include the private pilot letting the airspeed get too low.Oct 20, 1999 · N8078P · Substantial damage NTSB SEA99LA083Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Plentywood, MTThe pilot's failure to ensure that the landing gear were properly down and locked for landing.Jun 9, 1999 · N5309P · Substantial damage NTSB SEA95LA086Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Anaconda, MTThe pilot's attempt to conduct visual flight into instrument meteorological conditions, and his failure to maintain clearance from terrain.May 1, 1995 · N6288P · Substantial damage NTSB SEA92LA031Accident · Serious injuriesLimited investigationFinal reportPiper PA-24-250 · Missoula, MTThe pilot's poor in-flight decision, failure to perform a missed approach, and improper altitude. Factors include poor preflight planning/preparation, and weather conditions below approach minimums.Dec 27, 1991 · N6408P · Substantial damage NTSB SEA92LA017Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Belt, MTA blocked fuel vent and an inadequate preflight inspection, which resulted in fuel starvation.Nov 14, 1991 · N6072P · Substantial damage NTSB DEN82AA132Accident · 1 fatalFinal reportPiper PA-24-250 · Billings, MTPlt decided to land enroute due wx. At 0803 he contacted Billings fss & was advised Billings wx was 5,000 ft broken. At 0809 he called Billings approach control (a/c) & advised he was 20 mi for landing. Enroute to arpt he was unable to locate the arpt due wx…Jul 9, 1982 · N5356P · Substantial damage NTSB SEA79DTI13Accident · Serious injuriesClosedPiper PA-24 · Sula, MTApr 20, 1979 · N8372P · Destroyed NTSB SEA76FTI22Accident · Minor injuriesClosedPiper PA-24 · Thompson Falls, MTMar 26, 1976 · N5482P · Substantial damage NTSB SEA75FTI28Accident · No injuriesClosedPiper PA-24 · Boseman, MTMay 1, 1975 · N7487P · Substantial damage NTSB SEA74FTA03Accident · No injuriesClosedPiper PA-24 · Harlowton, MTJul 17, 1973 · N7583P · Substantial damage NTSB SEA72AS042Accident · 2 fatalClosedPiper PA-24 · Ronan, MTMar 23, 1972 · N7843P · Destroyed NTSB SEA70DDG03Incident · No injuriesClosedPiper PA-24 · Anaconda, MTMay 15, 1970 · N7843P · Minor damage NTSB SEA69F0253Accident · 1 fatalClosedPiper PA-24 · Plains, MTApr 29, 1969 · N7311P · Destroyed NTSB SEA69A0039Accident · 4 fatalClosedPiper PA-24 · Great Falls, MTJan 5, 1969 · N7556P · Destroyed NTSB SEA69F0150Accident · No injuriesClosedPiper PA-24 · Butte, MTOct 23, 1968 · N5889P · Substantial damage NTSB SEA68D0132Accident · No injuriesClosedPiper PA-24 · Libby, MTAug 16, 1967 · N5864P · Substantial damage NTSB SEA66F0190Accident · No injuriesClosedPiper PA-24 · Twin Bridges, MTOct 18, 1965 · N6380 · Substantial damage NTSB SEA65A0057Accident · 2 fatalClosedPiper PA-24 · 7se Clinton, MTApr 26, 1965 · N7414P · Destroyed NTSB UNK64X2781Accident · 1 fatalClosedPiper PA-24 · W Yellowstone, MTJul 12, 1964 · N6002P · Destroyed NTSB UNK64X1546Accident · No injuriesClosedPiper PA24 · Billings, MTMay 1, 1964 · N6203P · Substantial damage NTSB UNK64X0814Accident · No injuriesClosedPiper PA24 · Great Falls, MTMar 6, 1964 · N5712P · Substantial damage