NTSB investigations: Piper PA-38-112, VA
11 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
| 1979 | 1 |
|---|---|
| 1980 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1988 | 1 |
| 1989 | 1 |
| 1992 | 2 |
| 1997 | 1 |
| 1999 | 1 |
| 2006 | 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\" = 'VA' 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" = 'VA' 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 NYC06CA212Accident · No injuriesData collectionFinal reportPiper PA 38-112 · Chesapeake, VAThe presence of deer on the runway during the landing roll, which resulted in a collision. A factor in the accident was the dark night.NTSB IAD99LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38 · Manassas, VAThe student pilot's failure to maintain the proper rate of descend on final approach followed by an improper flare which resulted on a hard landing.NTSB NYC97LA164Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Manassas, VAThe pilot's misjudgment of clearance between the aircraft and fuel truck, which resulted in a collision.NTSB NYC93LA007Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Heathsville, VAThe improper inflight planning and decision by the student pilot resulting in fuel exhaustion.NTSB BFO92LA084Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Moneta, VAFailure of the student pilot to maintain directional control during the landing, which resulted in an inadvertent ground swerve. Factors related to the accident were: the student's improper recovery from a bounced landing and proximity of the tree.NTSB BFO89LA040Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Criders, VAThe pilot failed to maintain directional control of the airplane during the crosswind conditions encountered during the initial takeoff climb.NTSB BFO88FID03Accident · Serious injuriesFinal reportPiper PA-38-112 · Chesapeake, VAThe pilot was doing touch & go landings. During climbout engine power loss occurred at an estimated 300 ft AGL. The pilot radioed mayday and a witness stated he heard the stall horn during the transmission. Afterwards the acft pitched down and spun to the…NTSB ATL83LA162Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Lynchburg, VAThe acft landed hard and bounced several times before collapsing the landing gear. The student pilot was on her first solo flight after 31 hours of dual instruction in the PA-38 acft. The student reported the accident was student induced and that there were…NTSB ATL82FID05Accident · No injuriesFinal reportPiper PA-38-112 · Charlottesville, VAAfter performing four successful night approaches the pilot attempted a short field approach with the landing light off. On final he stated it appeared he was getting too low so he turned the landing light on and continued the approach. The aircraft struck a…NTSB ATL80FA081Accident · 1 fatalClosedPiper PA-38 · Charlottesvle, VANTSB IAD79FA089Accident · 1 fatalClosedPiper PA-38 · Chesterfield, VA