NTSB investigations: Piper PA-38-112, NJ
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
| 1978 | 1 |
|---|---|
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 1 |
| 1984 | 2 |
| 1988 | 2 |
| 1992 | 1 |
| 2011 | 1 |
| 2014 | 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\" = 'NJ' 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" = 'NJ' 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 ERA14CA119Accident · No injuriesData collectionFinal reportPiper PA 38-112 · West Milford, NJThe failure of the pilot-in-command to maintain directional control during landing.NTSB ERA11CA225Accident · Serious injuriesData collectionFinal reportPiper PA38 · Manville, NJThe pilot’s improper fuel management which resulted in a loss of engine power due to fuel starvation.NTSB NYC92LA068Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Williamstown, NJImproper bounced landing recovery by the pilot which resulted in a loss of control and the airplane striking a parked airplane.NTSB NYC88LA230Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Manville, NJAfter completing six landings with an instructor the student plt was released by the instructor for his first solo flt to be conducted as a series of closed pattern touch-and-go landings. On his first solo landing the student plt landed nose wheel first with…NTSB NYC88LA076Accident · Serious injuriesLimited investigationFinal reportPiper PA-38-112 · Williamstown, NJThe flight departed runway 27 at cross keys airport and upon reaching 250 feet altitude, the engine lost power and began vibrating. The pilot maneuvered to return to the airport but was unable to reach it. The aircraft crashed in a yard about 1/2 mile from…NTSB NYC84LA290Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Caldwell, NJThe instructor plt stated that while he was giving instruction, he made a normal landing. When the wheels touched down, the right main gear snapped off & hit the side of the fuselage. The acft then skidded along the rwy until it came to rest.NTSB NYC84LA289Accident · Minor injuriesLimited investigationFinal reportPiper PA-38-112 · Marlboro, NJThe plt diverted to the Marlboro arpt due to thunderstorm activity in the vicinity of his destination. During an approach to land, the acft encountered turbulence & the plt was injured by a loose object in the cockpit. At about the same time, there was a…NTSB NYC83LA066Accident · No injuriesLimited investigationFinal reportPiper PA-38-112 · Blairstown, NJThe plt lost directional control & the acft swerved into a snowbank.NTSB NYC82DA231Accident · No injuriesFinal reportPiper PA-38-112 · Pomona, NJWhile taxiing from landing, the pilot attempted to pass between a parked aircraft and a parked fuel truck. The wingtip of the taxiing aircraft hit a fender on the truck.NTSB NYC81FHD40Accident · No injuriesClosedPiper PA-38 · Lumberton, NJNTSB NYC79FHD04Accident · No injuriesClosedPiper PA-38 · Albion, NJ