NTSB investigations: Piper PA-23-250
14 cases on aircraft the registry lists as Piper PA-23-250, where the first occurrence was “Fire”. 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
| 1982 | 1 |
|---|---|
| 1984 | 2 |
| 1985 | 3 |
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 1994 | 2 |
| 1995 | 2 |
| 2003 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 171))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.aircraft_model_code IN ('7102308')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 171))
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 NYC04LA047Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Buffalo, NYThe pilot's improper procedure with regard to the cabin heater, which resulted in the over temperature of the heater and subsequent fire.NTSB BFO96IA012Incident · No injuriesIncident investigationFinal reportPiper PA-23 · Beckley, WVan in-flight fire (behind the right side of the instrument panel), which occurred for undetermined reason(s).NTSB CHI95LA234Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Michigan City, INreason for the occurrence was undetermined.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 FTW95LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Fredericksburg, TXImproper maintenance resulting in an engine fire, and the pilot's improper propeller feathering procedure, causing the propeller not to feather and the airplane's engine out capability to be exceeded. A factor was the unsuitable terrain conditions.NTSB MIA92LA143Accident · 4 fatalLimited investigationFinal reportPiper PA-23-250 · St. ThomasIn-flight fire for undetermined reasons, and in-flight collision with the water.NTSB ATL89LA087Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Huntersville, NCFire resulting from an oil leak of undetermined origin in the area of the left engine.NTSB MKC86LA154Accident · No injuriesLimited investigationFinal reportPiper PA-23-250T · Norfolk, NEA fire started inflight in the left wheel well and nacelle area just after the pilot turned on the electric fuel pumps during the turn to final approach. The airplane was landed and the pilot evacuated safely. According to witnesses, the airplane appeared to…NTSB MIA85LA198Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Atlantic Ocean (Atlantic Ocean)The plt reported that during an overwater flt, a fire began in the front section of the acft while he was cruising at 10,500 ft. he radioed his position on the emergency freq (121.5 mhz) & squawked an emergency code (7700) on his transponder. Subsequently, he…NTSB FTW85FA137Accident · 1 fatalField investigationFinal reportPiper PA-23-250 · Foss, OKInflt fire at rear of lft eng caused by fitting of inlet fuel line to eng driven fuel pump being more than 1 & 1/2 turns from finger tight plt was A&P mech and did maint on a/c and had helped install lft eng 19.8 hrs prior to accident . Lft wing separated…NTSB ATL85LA103Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-250 · Reidsville, GAThe acft was found burning in the woods by the foresty service. No persons or baggage were found. The date, time & cause of the accident is unknown. Suspected drug related activity. According to FAA records, the acft was not officially registered. It had been…NTSB SEA85LA018Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Aurora, ORThe acft caught fire during start. The FAA inspectors said that AD 72-11-01 had not been followed in compliance.NTSB CHI85LA001Accident · No injuriesLimited investigationFinal reportPiper PA-23-250 · Greenbush, MNFollowing an uneventful approach and landing, the plt was taxiing back up the runway when the right engine quit. The right seat passenger immediately noted flames coming from the engine and notified the plt, who swung the acft into positon for wind to keep…NTSB DEN82DA146Accident · Minor injuriesFinal reportPiper PA-23C-250 · Gunnison, CODuring takeoff, the pilot was distracted by inbound traffic and delayed retracting his gear. At the same time, the engines were not synchronized and he was having difficulty getting them to sound good. He then noticed that a fire had started in the vicinity…