Skip to content

NTSB investigations: Piper PA-24-250, NE

26 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" = 'NE' 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\" = 'NE' 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" = 'NE' 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 CEN22LA384Accident · No injuriesClass 4 · LimitedFinal reportPiper PA-24-250 · Kearney, NEThe pilot’s inadequate in-flight planning that resulted in a loss of engine power due to fuel exhaustion.Aug 12, 2022 · N5253P · Substantial damage NTSB MKC87LA056Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Kimball, NEThe PIC rptd landing rwy 10 with a wnd fm 080 at 7 KTS. The acft began veering left and ran through a snow bank which bordered the rwy. The left main landing gear collapsed and the acft spun around 180 deg stopping tail first. Insp of the landing gear noted…Mar 6, 1987 · N5553P · Substantial damage NTSB MKC87LA004Accident · No injuriesLimited investigationFinal reportPiper PA-24-250 · Seward, NEThe plt reports that he was landing on his private grass strip which is 1600 x 60 ft. he said the grass on the edges was thicker then that in the middle. During landing roll the acft drifted to the lt and the lt wing collided with milo growing along the lt…Oct 5, 1986 · N5980P · Substantial damage NTSB MKC83LA176Accident · No injuriesLimited investigationFinal reportPiper PA-24-235 · Alliance, NEThe pilot stated that he departed oshrosh for scottsbluff with an estimated 80 gallons of fuel on board the air craft his ete was 4 hours 30 minutes and fuel consumption at 15 gph. Aprx 37 NM short of scotts bluff he noticed the right fuel gauge indicating…Aug 5, 1983 · N777EE · Substantial damage NTSB MKC77FA007Accident · 3 fatalClosedPiper PA-24 · Kimball, NEDec 5, 1976 · N6973P · Destroyed NTSB MKC76DCJ47Accident · No injuriesClosedPiper PA-24 · Chadron, NEJul 11, 1976 · N7125P · Substantial damage NTSB MKC74DCJ31Accident · No injuriesClosedPiper PA-24 · Fairbury, NEMar 1, 1974 · N7729P · Substantial damage NTSB MKC72FCJ51Accident · No injuriesClosedPiper PA-24 · Gordon, NEMar 13, 1972 · N7124P · Substantial damage NTSB MKC72FCJ44Accident · Minor injuriesClosedPiper PA-24 · Ainsworth, NEJan 13, 1972 · N6066P · Substantial damage NTSB MKC72DCJ26Accident · No injuriesClosedPiper PA-24 · Boelus, NESep 13, 1971 · N6383P · Substantial damage NTSB MKC72DCJ31Accident · No injuriesClosedPiper PA-24 · Fremont, NESep 9, 1971 · N7729P · Substantial damage NTSB MKC72FCJ03Accident · No injuriesClosedPiper PA-24 · Offutt Afb, NEJul 1, 1971 · N5742P · Substantial damage NTSB MKC71DCJ22Accident · No injuriesClosedPiper PA-24 · North Platte, NESep 13, 1970 · N7170P · Substantial damage NTSB MKC70FCJ25Accident · No injuriesClosedPiper PA-24 · Sidney, NEMay 29, 1970 · N5516P · Destroyed NTSB MKC69A0007Accident · Serious injuriesClosedAeronca 7AC · Lexington, NEAug 3, 1968 · N2966E · 2 aircraft · Destroyed NTSB MKC69F0004Accident · No injuriesClosedPiper PA-24 · Norfolk, NEJun 11, 1968 · N6985P · Substantial damage NTSB MKC68F0366Accident · No injuriesClosedPiper PA-24 · Sutherland, NENov 20, 1967 · N6174P · Destroyed NTSB NYC68F0350Accident · No injuriesClosedPiper PA-24A · Omaha, NENov 13, 1967 · N6284P · Substantial damage NTSB MKC68F0308Accident · No injuriesClosedPiper PA-24 · Gordon, NEOct 8, 1967 · N6232P · Substantial damage NTSB MKC67F0451Accident · No injuriesClosedPiper PA-24 · Lincoln, NEMar 2, 1967 · N7232P · Substantial damage NTSB MKC67D0430Accident · No injuriesClosedPiper PA-24 · Creighton, NEFeb 2, 1967 · N6480P · Substantial damage NTSB MKC67D0409Accident · No injuriesClosedPiper PA-24 · Lynch, NEJan 13, 1967 · N8430P · Substantial damage NTSB MKC66F0581Accident · No injuriesClosedPiper PA-24 · Lincoln, NEMay 30, 1966 · N7948P · Substantial damage NTSB MKC66F0510Accident · No injuriesClosedPiper PA-24 · Lincoln, NEApr 30, 1966 · N5776P · Substantial damage NTSB MKC66F0356Accident · No injuriesClosedPiper PA-24 · Omaha, NENov 24, 1965 · N7948P · Substantial damage NTSB UNK64X1047Accident · 5 fatalClosedPiper PA-24 · Alliance, NEMar 26, 1964 · N8206P · Destroyed