NTSB investigations: Piper PA-23-250, MO
14 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 | 4 |
| 1970 | 1 |
| 1976 | 1 |
| 1979 | 2 |
| 1980 | 1 |
| 1983 | 1 |
| 1988 | 2 |
| 2001 | 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\" = 'MO' 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" = 'MO' 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 CHI01LA076Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fulton, MOthe pilot not maintaining altitude/clearance from the power line during the circling approach. Factors were the power transmission wire, the plowed field, and that the pilot's lookout was not possible through the built up ice on the windshield.NTSB MKC88LA074Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Springfield, MOWhile attempting to land on a narrow runway, with approaching thunderstorms within 4 miles of the airport, directional control was lost by the plt during the rollout. Plt stated a sudden change in surface wind direction made it impossible for him to maintain…NTSB MKC88FA067Accident · No injuriesField investigationFinal reportPiper PA-23-250 · Excelsior Spgs, MODuring arrival at night, after using fuel from the inboard tanks, the plt switched to the outboard fuel tanks. Shortly, thereafter, both engs lost power. The plt declared an emergency & obtained vectors to the nearest airport, but was unable to reach it.…NTSB MKC83FA133Accident · 3 fatalField investigationFinal reportPiper PA-24-250 · 3m Se Of Benton, MOAccording to the surviving passenger, a boy, the plt was flying the acft from the right seat. The acft was flown to the vicinity of the plt's property where he made a pass over a farm belonging to a relative. The low pass was made near the operator of a…NTSB MKC80FCG14Accident · No injuriesClosedPiper PA-23 · Kansas City, MONTSB MKC79IA031Incident · No injuriesClosedPiper PA-23 · Kansas City, MONTSB MKC79FCG25Accident · No injuriesClosedPiper PA-23 · Springfield, MONTSB MKC76AK081Accident · Serious injuriesClosedPiper PA-23 · Independence, MONTSB MKC71FCA12Accident · No injuriesClosedPiper PA-23 · Cuba, MONTSB MKC68D0425Accident · No injuriesClosedPiper PA-23 · Montrose, MONTSB MKC68D0390Accident · No injuriesClosedPiper PA-23 · Kansas City, MONTSB MKC68A0004Accident · 2 fatalClosedPiper PA-23 · Benton, MONTSB MKC67D0434Accident · No injuriesClosedPiper PA-23 · Independence, MONTSB UNK65X0672Accident · No injuriesClosedPiper PA-23 · St Louis, MO