NTSB investigations: Piper PA-24-250, 1997, TX
2 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.
Cases per year
| 1964 | 13 |
|---|---|
| 1965 | 11 |
| 1966 | 13 |
| 1967 | 14 |
| 1968 | 5 |
| 1969 | 7 |
| 1970 | 4 |
| 1971 | 4 |
| 1972 | 2 |
| 1973 | 1 |
| 1974 | 2 |
| 1975 | 4 |
| 1976 | 1 |
| 1977 | 7 |
| 1978 | 2 |
| 1979 | 2 |
| 1980 | 5 |
| 1981 | 2 |
| 1982 | 1 |
| 1985 | 3 |
| 1987 | 2 |
| 1989 | 1 |
| 1993 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 1996 | 2 |
| 1997 | 2 |
| 1999 | 1 |
| 2000 | 1 |
| 2001 | 1 |
| 2004 | 1 |
| 2006 | 1 |
| 2007 | 1 |
| 2009 | 1 |
| 2011 | 1 |
| 2012 | 2 |
| 2014 | 1 |
| 2015 | 1 |
| 2019 | 1 |
| 2020 | 1 |
| 2025 | 1 |
Where
Latest cases
Query with SQL
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 year(c.\"eventDate\") = 1997
AND c.\"eventStateOrRegion\" = 'TX' 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 year(c."eventDate") = 1997
AND c."eventStateOrRegion" = 'TX' 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" DESCRun 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 FTW98LA060Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Lubbock, TXThe inadequate maintenance of the landing gear assembly by maintenance personnel resulting in a partial gear extension, and the pilot's misjudgment of a proper touchdown point to intentionally shut down the engine resulting in the airplane landing short of…NTSB FTW97LA316Accident · Minor injuriesLimited investigationFinal reportPiper PA-24-250 · Caldwell, TXThe loss of engine power due to fuel exhaustion which resulted from a leaking fuel cap. Factors were the dark night conditions, and the lack of suitable terrain for the forced landing.