NTSB investigations: Piper PA-23
8 cases on aircraft the registry lists as Piper PA-23, where the first occurrence was “Loss of engine power(partial) - nonmechanical”. 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
| 1984 | 1 |
|---|---|
| 1986 | 2 |
| 1988 | 1 |
| 1992 | 1 |
| 1995 | 2 |
| 2000 | 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 ('7102302')
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\" = 354))
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 ('7102302')
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" = 354))
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 CHI00FA214Accident · 1 fatalField investigationFinal reportPiper PA-23 · Dodge Center, MNThe pilot not maintaining airplane control in his turn back in the direction of the airport and the pilot not performing an emergency landing straight ahead. Factors were the water and debris contamination found in the fuel screens and carburetor bowl and the…NTSB MIA96LA003Accident · Serious injuriesLimited investigationFinal reportPiper PA-23 · Spring Hill, FLThe pilot's failure to maintain airspeed (VMC) on initial takeoff climb resulting in an in-flight loss of control, and subsequent in-flight collision with the ground and a building. Contributing to the accident was a partial loss of engine power on the left…NTSB CHI95LA085Accident · No injuriesLimited investigationFinal reportPiper PA-23 · Benton Harbor, MIthe pilot's improper use of carburetor heat. Factors were carburetor icing conditions, snow, and blowing snow.NTSB LAX92LA200Accident · No injuriesLimited investigationFinal reportPiper PA23-150 · Modesto, CAAn engine power loss due to fuel contamination.NTSB BFO88FA063Accident · No injuriesField investigationFinal reportPiper PA-23 · Friendly, MDShortly after takeoff at an altitude of 200 ft AGL, a power loss was experienced on the left engine. According to the plt, when the throttle was retarded to verify the engine failure, the engine seemed to 'come back to life'. The throttle was advanced and…NTSB FTW86LA126Accident · Minor injuriesLimited investigationFinal reportPiper PA-23-150 · Georgetown, TXThe instructor pilot was instructing his student pilot in an engine shutdown for a multi-engine instructor rating, after which the engine would not restart. The instructor decided to land at the closest airport. While on final approach another aircraft landed…NTSB MKC86LA171Accident · No injuriesLimited investigationFinal reportPiper PA-23-150 · Iowa City, IAThe flight instructor stated that he had planned to conduct an engine-out drill after takeoff by reducing power to the starboard engine. During the engine-out drill the student reduced power to the operating engine and the aircraft landed hard back on the…NTSB DEN84FA148Accident · Serious injuriesField investigationFinal reportPiper PA-23-150 · Parker, COAccording to the pilot the acft had not been flown for two months and he intended to practice touch and go landings. Maintenance personnel were requested to add 10 gals of fuel to the right main tank just prior to departure. They reported that upon arrival…