NTSB investigations: Piper PA-23-250, NV
11 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 | 1 |
|---|---|
| 1969 | 1 |
| 1971 | 1 |
| 1973 | 1 |
| 1974 | 1 |
| 1977 | 2 |
| 1982 | 1 |
| 1994 | 1 |
| 1997 | 1 |
| 2018 | 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\" = 'NV' 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" = 'NV' 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 WPR18FA073Accident · 1 fatalField investigationFinal reportPiper PA 23-250 · Elko, NVThe pilot's inadequate preflight weather planning, which resulted in the flight over mountainous terrain into forecast instrument meteorological conditions, icing, and mountain wave, and resulted in an uncontrolled descent and collision with terrain.NTSB LAX98FA048Accident · 4 fatalField investigationFinal reportPiper PA-23-250 · Carson City, NVThe failure of the pilot to maintain airspeed after being distracted by the nose baggage door opening in-flight resulting in a stall/spin. Factors contributing to the accident were the pilot's inadequate preflight inspection and lack of experience in the type…NTSB LAX94LA127Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Las Vegas, NVThe cfi's improper remedial action by failing to go-around instead of landing, the cfi's excessive touchdown speed, and his failure to obtain the proper touchdown point. The dual student's initial excessive airspeed and the ditch were factors in this accident.NTSB LAX82FVW04Accident · Serious injuriesFinal reportPiper PA-23-250 · Panaca, NVThe plt encountered thunderstorm activity at 1900. The left fuel gauge was inop & he had no communication equipment. There was only one nav receiver operative, no instrument lights or slaved dg available. As it became darker he was unable to see the…NTSB OAK78FVW06Accident · Serious injuriesClosedPiper PA-23 · Tonopah, NVNTSB OAK77DXQ06Accident · No injuriesClosedPiper PA-23 · Ely, NVNTSB OAK75DXQ07Accident · No injuriesClosedPiper PA-23 · Pyramid, NVNTSB OAK74FVW10Accident · No injuriesClosedPiper PA-23 · Las Vegas, NVNTSB OAK71FVW24Accident · No injuriesClosedPiper PA-23 · Pahrump, NVNTSB OAK69A0045Accident · 1 fatalClosedPiper PA-23 · Sparks, NVNTSB OAK66F0176Accident · No injuriesClosedPiper PA-23 · Reno, NV