NTSB investigations: Piper PA-23-250, TN
12 cases on aircraft the registry lists as Piper PA-23-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 | 1 |
|---|---|
| 1967 | 1 |
| 1971 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1980 | 2 |
| 1983 | 1 |
| 1993 | 1 |
| 2017 | 1 |
| 2021 | 1 |
Where
Open the mapLatest 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 c.\"eventStateOrRegion\" = 'TN' 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 ('7102308'))
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" = 'TN' 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 ('7102308'))
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 ERA21LA173Accident · Serious injuriesClass 3 · LimitedFinal reportPiper PA-23-250 · Springfield, TNThe flight instructor’s failure to abort the takeoff following a loss of left engine power due to fuel starvation. Also causal was the inadequate maintenance of the left fuel cap by unknown maintenance personnel, which resulted in a blockage of the fuel…NTSB ANC18LA016Accident · Serious injuriesLimited investigationFinal reportPiper PA 23-250 · Knoxville, TNThe flight instructor’s failure to comply with published engine-out procedures and recommended airspeeds, which resulted in a lack of directional control, collision with trees, and impact with the ground; the left engine lost total power due to fuel…NTSB ATL93LA072Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Elizabethton, TNA loss of engine power on one engine for undetermined reasons.NTSB ATL83LA100Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · St. Joseph, TNThe aircraft overran the end of the runway during a night landing in IMC weather. The runway was a private dirt strip. Flight purpose is not known but it is suspected it was a drug smuggling flight. The aircraft landed long on the 2400 foot strip and went off…NTSB ATL80FLT11Accident · Minor injuriesClosedPiper PA-23 · Jackson, TNNTSB ATL80FA065Accident · 5 fatalClosedPiper PA-23 · Rockford, TNNTSB IAD74FLT04Accident · No injuriesClosedPiper PA-23 · Jackson, TNNTSB IAD73AI010Accident · 4 fatalClosedPiper PA-23 · Gatlinburg, TNNTSB MIA72AM077Accident · 3 fatalClosedPiper PA-23 · Memphis, TNNTSB MIA71DLT20Accident · No injuriesClosedPiper PA-23 · Jackson, TNNTSB MIA68F0224Accident · No injuriesClosedPiper PA-23 · Nashville, TNNTSB UNK64X3232Accident · No injuriesClosedPiper PA23 · Memphis, TN