NTSB investigations: Piper PA-28-236, CA
22 cases on aircraft the registry lists as Piper PA-28-236. 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
| 1983 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1988 | 1 |
| 1990 | 1 |
| 1991 | 1 |
| 1992 | 2 |
| 1996 | 5 |
| 1997 | 1 |
| 2005 | 1 |
| 2008 | 1 |
| 2009 | 1 |
| 2010 | 3 |
| 2018 | 1 |
| 2019 | 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\" = 'CA' 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 ('7102815'))
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" = 'CA' 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 ('7102815'))
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 WPR19LA267Accident · No injuriesClass 3 · LimitedFinal reportPiper PA28 · Modesto, CAA total loss of engine power for reasons that could not be determined based on the available information.NTSB GAA19CA052Accident · No injuriesData collectionFinal reportPiper PA28 · Merced, CAThe pilot's improper glidepath during a landing at night, which resulted in a collision with approach lights.NTSB WPR11LA025Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Dorrington, CAThe pilot’s failure to use carburetor heat while cruising in carburetor icing conditions, which resulted in a loss of engine power.NTSB WPR10CA351Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Fullerton, CAThe pilot’s improper flare and inadequate bounced landing recovery, which resulted in a hard landing and porpoise down the runway.NTSB WPR10CA348Accident · No injuriesData collectionFinal reportPiper PA-28-236 · Moreno Valley, CAA total loss of engine power due to fuel exhaustion.NTSB WPR09FA150Accident · 2 fatalField investigationFinal reportPiper PA28-236 · Pomona, CAThe pilot's spatial disorientation while flying in instrument meteorological conditions that resulted in a loss of control of the airplane. Contributing to the accident was the pilot's lack of recent instrument flying experience.NTSB SEA08CA103Accident · Minor injuriesData collectionFinal reportPiper PA-28-236 · Alturas, CAThe pilot's inadequate compensation for the gusty crosswind conditions. The wind gusts were a contributing factor.NTSB LAX05CA280Accident · No injuriesData collectionFinal reportPiper PA-28-236 · San Martin, CAthe pilot's failure to maintain directional control of the airplane during the landing roll. A factor in the accident was the spongy brakes.NTSB LAX97LA111Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Palo Alto, CAthe pilot's improper flare and improper recovery from a bounced landing, which resulted in a porpoise and subsequent overload failure of the nose gear.NTSB LAX97FA047Accident · 1 fatalField investigationFinal reportPiper PA-28-236 · Lost Hills, CAThe pilot's continued VFR flight into instrument meteorological conditions, which led to spatial disorientation and loss of aircraft control, and the pilot exceeding the aircraft's design stress limits during an attempted recovery. The noninstrument-rated…NTSB LAX96LA301Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Santa Ana, CAthe pilot's decision to turn off the runway while at an excessive speed that did not allow him to maintain directional control of the aircraft.NTSB LAX96FA130Accident · No injuriesField investigationFinal reportBellanca 7GCAA · Los Alamitos, CAthe failure of both pilots to see and avoid each other. Factors were the pilots' failure to use available radar services.NTSB LAX96FA097Accident · Minor injuriesField investigationFinal reportPiper PA-28-236 · Seal Beach, CAa total loss of engine power from an improperly installed magneto that separated from the engine housing due to fatigue from vibration.NTSB LAX96LA320Accident · No injuriesLimited investigationFinal reportPiper PA-28-236 · Paradise, CAThe pilot's attempted flight into known adverse weather conditions.NTSB LAX93LA080Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Big Bear, CAThe pilot's failure to maintain directional control of the aircraft after touchdown.NTSB LAX92FA151Accident · 1 fatalField investigationFinal reportPiper PA 28-236 · Lebec, CAThe pilot's delayed inflight decision to reverse course to avoid forecast adverse weather conditions. Contributing to the accident was icing conditions and lightning.NTSB LAX91LA177Accident · No injuriesLimited investigationFinal reportPiper PA28-236 · Gualala, CAThat the pilot failed to properly use the flight controls and to maintain directional control. Contributing to this accident were the gusty crosswind conditions that existed at the time of the accident.NTSB LAX90LA255Accident · No injuriesLimited investigationFinal reportPiper PA28-236 · S. Lake Tahoe, CAThe pilot's failure to maintain clearance between the aircraft and an obstruction along his ground taxi route. Obstructions along the route and a fence constructed near the ramp are factors in the accident.NTSB LAX88LA120Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-236 · Hesperia, CANTSB LAX86FA233Accident · 4 fatalField investigationFinal reportPiper PA 28-236 · Chino, CAThe private non-instrument rated pilot, overflew his home airport by 23 nautical miles upon returning from a night cross country flight and descended into a hill. Instrument meteorological conditions were reported in the area due to reduced visibility. The…NTSB LAX85LVA01Accident · No injuriesFinal reportPiper PA28-236 · Porterville, CAWhile on final apch to rwy 30 at Porterville arpt, and as the acft flared for landing, the left wheel and left wing touched the rwy, and the acft bounced into the air, stalled, and crashed just left of the rwy. The plt stated, 'a gust of wind pitched the nose…NTSB LAX83LA235Accident · No injuriesLimited investigationFinal reportPiper PA 28-236 · Emigrant Gap, CAThe acft collided with trees during takeoff. The CFI and student had made a landing on a rwy that was 2/3 covered with snow. They thought they could make a short field landing and a short field running takeoff. They nosed down in the snow during the attempted…