NTSB investigations: Piper PA-23-250, AL
19 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
| 1965 | 4 |
|---|---|
| 1966 | 2 |
| 1967 | 1 |
| 1970 | 1 |
| 1972 | 1 |
| 1973 | 2 |
| 1974 | 1 |
| 1977 | 2 |
| 1980 | 1 |
| 1986 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 2024 | 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\" = 'AL' 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" = 'AL' 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 ERA24LA275Accident · No injuriesClass 4 · LimitedFinal reportPiper PA23 · Montgomery, ALThe failure of the nose landing gear actuator to maintain a fully down and locked position.NTSB ATL96FA095Accident · 5 fatalField investigationFinal reportPiper PA-23-250 · Clanton, ALcorrosion pitting of the number six cylinder on the left engine, and subsequent fatigue fracture and separation of the cylinder, which led to an engine compartment fire, wing fire, and an in-flight separation of the left wing.NTSB ATL95FA007Accident · 2 fatalField investigationFinal reportPiper PA-23-250 · Newville, ALFailure of maintenance personnel to properly install the marmon clamp on the discharge side of the turbocharger.NTSB ATL86LA260Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Montgomery, ALDuring initial climb phase of an experimental flt from mgm, AL, the plt rpted that the left engine had failed and an attempt was made to feather the prop. The plt radioed dannelly tower that the acft was returning to the arpt. Then the plt rpted that the…NTSB MIA80FA028Accident · No injuriesClosedPiper PA-23 · Mobile, ALNTSB MIA77FKJ61Accident · No injuriesClosedPiper PA-23 · Montgomery, ALNTSB MIA77DKJ13Accident · No injuriesClosedPiper PA-23C · Enterprise, ALNTSB MIA75FKJ13Accident · No injuriesClosedPiper PA-23 · Birmingham, ALNTSB MIA74DKJ25Accident · No injuriesClosedPiper PA-23 · Robertsdale, ALNTSB MIA74DKJ05Accident · No injuriesClosedPiper PA-23 · Huntsville, ALNTSB MIA73FKJ30Accident · No injuriesClosedPiper PA-23 · Alabaster, ALNTSB MIA70AM055Accident · Serious injuriesClosedPiper PA-23 · Bay Minette, ALNTSB MIA68F0281Accident · No injuriesClosedPiper PA-23 · Muscle Shoals, ALNTSB MIA67F0303Accident · No injuriesClosedPiper PA-23 · Birmingham, ALNTSB MIA66A0149Accident · 4 fatalClosedPiper PA-23 · Ashland, ALNTSB MIA66A0071Accident · No injuriesClosedPiper PA-23 · Huntsville, ALNTSB MIA66F0053Accident · No injuriesClosedPiper PA-23 · Oxford, ALNTSB MIA65A0095Accident · 3 fatalClosedPiper PA-23 · Drewry, ALNTSB UNK65X1403Accident · No injuriesClosedPiper PA23 · Tuscaloosa, AL