NTSB investigations: Piper PA-38-112, NV
8 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 | 2 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 2004 | 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 ('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" = '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 ('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 LAX04FA167Accident · 1 fatalField investigationFinal reportPiper PA-38-112 · Jean, NVThe student pilot's failure to regain control of the aircraft following an upset due to the disconnected primary right aileron control cable. The failure of the company maintenance personnel to detect and correct the improperly secured turnbuckle fitting at…NTSB LAX92FA247Accident · 2 fatalField investigationFinal reportPiper PA-38-112 · Boulder City, NVThe instructor pilot's inadequate supervision of the student pilot to insure the proper flap setting for takeoff which resulted in the proper climb rate not being attained. Contributing to the accident was rising terrain.NTSB SEA90FA072Accident · Serious injuriesField investigationFinal reportPiper PA-38-112 · Jean, NVSevere downdrafts/windshear which exceeded the airplane's performance capabilities.NTSB SEA89LA077Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Gerlach, NVA delay by the pilot in aborting the landing and his failure to assure sufficient airspeed for the go-around (aborted landing). A factor related to the accident was: the unsuitable landing area that was selected by the pilot.NTSB SEA86LA200Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Elko, NVPlt executed forced lndg following pwr loss on initial climb. Acft tanks (16 gal cap ea) had been topped two hours prior, fuel receipt shows 16.6 added, refueler recalled abt 8 gals added per tank. Plt checked visually and on gages during preflight.…NTSB SEA85LA133Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Las Vegas, NVDuring a local instructional flight a bounced landing was made. The acft bounced nose high to about 20 ft AGL. The acft then veered left of the rwy after full power had been added and flaps reduced from 40 degrees to 25 degrees for an attempted go-around at…NTSB LAX80FA102Accident · 1 fatalClosedPiper PA-38 · Las Vegas, NVNTSB LAX80FVW10Accident · No injuriesClosedPiper PA-38 · Hendson, NV