NTSB investigations: Piper PA-38-112
15 cases on aircraft the registry lists as Piper PA-38-112, where the first occurrence was “In flight encounter with weather”. 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 | 2 |
|---|---|
| 1984 | 2 |
| 1986 | 2 |
| 1987 | 2 |
| 1990 | 1 |
| 1992 | 1 |
| 1998 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 1 |
| 2007 | 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 ('7103812')
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\" = 240))
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 ('7103812')
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" = 240))
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 ATL07FA081Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Dawsonville, GAThe pilot’s improper decision to continue visual flight rules flight into instrument meteorological conditions, with a low cloud ceiling, over mountainous terrain.NTSB FTW04LA087Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Sugar Land, TXThe pilot's improper weather evaluation, and his encounter with adverse weather conditions. A contributing factor was the lack of suitable terrain for the precautionary landing.NTSB FTW03FA111Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Prattsville, ARThe pilot's execution of VFR flight into IMC and his failure to maintain obstacle clearance. Fog conditions and the pilot's lack of an instrument rating are contributing factors.NTSB LAX00FA354Accident · 1 fatalField investigationFinal reportPiper PA-38 · San Luis Obispo, CAThe pilot's failure to maintain clearance from terrain while turning to reverse course following inadvertent nighttime flight into instrument meteorological conditions. A factor in the accident was the pilot's lack of experience in nighttime operations.NTSB FTW98FA086Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Tremonton, UTThe pilot's continued VFR flight into instrument meteorological conditions, becoming spatially disoriented and his subsequent loss of aircraft control. Factors were the dark night and weather conditions that included obscuration and snow.NTSB MIA92LA117Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Brooksville, FLThe pilot's inadequate compensation for wind conditions during the landing flare, in gusty winds.NTSB SEA90FA072Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Jean, NVSevere downdrafts/windshear which exceeded the airplane's performance capabilities.NTSB LAX88LA066Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Dunsmuir, CAA Piper PA-38-112 collided with terrain while on a night VFR cross country flight. Night instrument meteorological conditions prevailed at the time and no flight plan was filed. The pilot received a weather briefing prior to departure. His destination weather…NTSB MIA87LA088Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · New Smyrna Bch, FLWhile in cruise flt at an alt of aprx 800 feet the plt reported that the eng began to lose RPM. Unable to maintain alt a forced landing was made on a road. The acft then ground looped due to contact with scrub oak trees, which resulted in severing of the left…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 DEN86LA237Accident · Minor injuriesLimited investigationFinal reportPiper PA-38 · Santa Fe, NMWhile flying through a mountain pass at an alt of 1,000 ft AGL, the plt encountered downdraft wind currents. The acft entered an uncontrollable descent and impacted in an alpine meadow.NTSB CHI85LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Byron Township, WIThe low time 55 hr pilot was wx briefed on unfavorable flt conditions en route to destination. He departed no flt plan. As he approached destination, 8 mi south, the ceiling had lowered to 200 ft, visibility one mi; icing on windshield. While following…NTSB ATL85LA021Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Cumming, GADespite a fss forecast of thunderstorm activity for the next 24 hours the plt departed in order to evaluate wx situation for himself. Conditions were as forecasted and the plt elected to return to the arpt from which he had departed. Due to the movement of…NTSB CHI82DA315Accident · No injuriesFinal reportPiper PA-38 · New Haven, ILThe pilot reported that before departing on a routine pipe line patrol, he obtained a weather briefing. After about 30 minutes of flight, the visibility began to decrease due to ground fog. The pilot elected to land on a gravel road. During the landing roll,…NTSB SEA82DA088Accident · No injuriesFinal reportPiper PA-38-112 · Oakley, IDAt about 1045 MDT, the pilot departed ogden, ut on a solo, cross-country flight to jackpot, NV, pocatello, ID and return. While en route to jackpot, he encountered turbulence and decreasing visibility over a mountainous area and descended from 8500 ft MSL to…