NTSB investigations: Piper PA-38-112, WA
7 cases on aircraft the registry lists as Piper PA-38-112. 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
| 1980 | 1 |
|---|---|
| 1983 | 2 |
| 1986 | 1 |
| 1989 | 1 |
| 1992 | 1 |
| 2002 | 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\" = 'WA' 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 ('7103812'))
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" = 'WA' 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 ('7103812'))
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 SEA02LA155Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Darrington, WALoss of engine power during takeoff due to an undersized gascolator gasket resulting in a loss of fuel flow to the engine. A ditch was a factor.NTSB SEA93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Spokane, WAInadequate preflight planning/preparation. Factors to the accident were: fuel exhaustion and inadequate fuel consumption calculations.NTSB SEA89LA079Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lacey, WAFailure of the pilot to maintain proper alignment during landing.NTSB SEA87FA014Accident · 2 fatalField investigationFinal reportPiper PA-38 · Port Townsend, WAThe plt had flown this acft over the same route many times. While en route, the acft collided with tall trees on rising terrain about 3 miles south of a direct course to the destination. The wx in the vicinity was characterized by low clouds, fog & haze. Aprx…NTSB SEA83LA146Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Dixie, WAAbout an hour after departure the engine began to run rough. The pilot did a magneto check and noted a drop of 300 RPM. A precautionary landing was made into a field of tall wheat. During landing roll the left main landing gear struck a hole. Examination of…NTSB SEA83LA073Accident · No injuriesLimited investigationFinal reportPiper PA-32-112 · Vancouver, WAAccording to the instructor (CFI), the student was approaching the rwy at 60 KTS with the power reduced when he chopped the power & flared at aprx 10 to 15 ft AGL. The right wing dropped & the acft landed hard before the CFI corrected the situation. The right…NTSB SEA80FYP36Accident · No injuriesClosedPiper PA-38 · Stratford, WA