NTSB investigations: Piper PA-36-285, CA
17 cases on aircraft the registry lists as Piper PA-36-285. 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
| 1976 | 2 |
|---|---|
| 1977 | 3 |
| 1978 | 5 |
| 1979 | 1 |
| 1980 | 1 |
| 1981 | 1 |
| 1982 | 1 |
| 1983 | 2 |
| 1988 | 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 ('7103610', '7103611'))
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 ('7103610', '7103611'))
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 LAX89DUM02Accident · Serious injuriesFinal reportPiper PA-36-285 · Brawley, CAAt the completion of aerial application, the plt attempted flight beneath power lines. The aircraft contacted and severed four power lines and then collided with terrain. A post-impact fire ensued.NTSB LAX83LA430Accident · No injuriesLimited investigationFinal reportPiper PA-36 · Huron, CAThe plt was spraying lettuce fields on a dark night. According to him, the wind was blowing from the north northwest & gusting to 12 KTS. He reported that during a turn-around over a plowed field, the wind was blowing dust which affected his visibility &…NTSB LAX83LA143Accident · Minor injuriesLimited investigationFinal reportPiper PA-36-285 · Tipton, CADuring takeoff, at aprx 80 ft AGL, the eng backfired then lost power. The plt chose an open field for an emergency landing while trying to dump the load. While landing, the acft bounced, rolled about 600 ft, then hit a dirt berm & subsequently came to rest in…NTSB LAX82FUM07Accident · No injuriesFinal reportPiper PA-36-285 · Imperial, CAThe pilot was unable to maintain airspeed and altitude after taking off from a wet and muddy runway. He closed the throttle and landed in a cotton field, but was unable to stop the aircraft before hitting a ditch. Reportedly, the previous (first) takeoff…NTSB LAX81DVA56Accident · Minor injuriesClosedPiper PA-36 · Mcfarland, CANTSB LAX80FUM29Accident · No injuriesClosedPiper PA-36 · Calipatria, CANTSB OAK79FVA21Accident · 1 fatalClosedPiper PA-36 · Los Banos, CANTSB LAX78DUM31Accident · No injuriesClosedPiper PA-36 · Calexico, CANTSB OAK78DVG50Accident · No injuriesClosedPiper PA-36 · Davis, CANTSB LAX78DVA32Accident · No injuriesClosedPiper PA-36 · Delano, CANTSB LAX78DVM08Accident · Minor injuriesClosedPiper PA-36 · Shandon, CANTSB LAX78DUM11Accident · No injuriesClosedPiper PA-36 · Calexico, CANTSB LAX77DUM39Accident · Minor injuriesClosedPiper PA-36 · Calexico, CANTSB LAX77FUM35Accident · No injuriesClosedPiper PA-36 · Niland, CANTSB OAK77DVA26Accident · No injuriesClosedPiper PA-36 · Tulare, CANTSB LAX77DUM08Accident · No injuriesClosedPiper PA-36 · Holtville, CANTSB OAK76FXQ61Accident · No injuriesClosedPiper PA-36 · Herlong, CA