NTSB investigations: Lycoming O-360-J2A, CA
13 cases on aircraft whose registry engine model is Lycoming O-360-J2A. 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
| 2006 | 1 |
|---|---|
| 2007 | 3 |
| 2008 | 1 |
| 2009 | 1 |
| 2012 | 1 |
| 2015 | 2 |
| 2016 | 1 |
| 2017 | 1 |
| 2018 | 2 |
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.engine_model_code IN ('42314'))
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.engine_model_code IN ('42314'))
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 WPR18LA252Accident · No injuriesClass 3 · LimitedFinal reportGuimbal Cabri · Santa Ana, CAThe flight instructor's delayed application of power during a power recovery following an autorotation, which resulted in an unrecoverable low rotor rpm during the landing flare and subsequent loss of control.NTSB GAA18CA210Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Franklin, CAThe pilot receiving instruction’s abrupt cyclic control input during the touch-down autorotation.NTSB GAA17CA514Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 · Sacramento, CAThe student pilot’s failure to maintain yaw control and the flight instructor’s delayed remedial action.NTSB GAA17CA010Accident · No injuriesData collectionFinal reportJoe Salomone Super CUB SQ2 · Boca Reservoir, CAThe pilot's decision to continue the taxi on unsuitable muddy terrain, which resulted in a nose-over.NTSB GAA15CA244Accident · No injuriesData collectionFinal reportJoe Salomone Super CUB SQ2 · Truckee, CAThe pilot's loss of directional control during the takeoff roll, which resulted in a runway excursion, ground loop, and impact with terrain. Contributing to the accident was the pilot's lack of experience from the back seat.NTSB GAA15CA200Accident · No injuriesData collectionFinal reportRobinson Helicopter R-22 · Corona, CAThe flight instructor's delayed remedial action to arrest the descent rate, which resulted in a running landing, the left skid catching rough terrain, and the main rotor blades impacting the ground.NTSB WPR12LA140Accident · Minor injuriesLimited investigationFinal reportRobinson Helicopter R22 Beta · Palo Alto, CAThe pilot's improper use of the throttle grip, which resulted in the deactivation of the rpm governor and a loss of rotor rpm.NTSB WPR09FA104Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta II · Fillmore, CAAn in-flight break-up while maneuvering as a result of the main rotor blades diverging from the normal plane of rotation and severing the tailboom. The underlying reason for the main rotor divergence could not be determined.NTSB LAX08FA052Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Los Angeles, CAThe pilot's failure to maintain an adequate obstacle clearance altitude from transmission wires during cruise flight. Contributing to the accident was the dark night conditions.NTSB SEA08CA032Accident · Serious injuriesData collectionFinal reportRobinson R22 Beta · Ramona, CAAn excessive descent rate during a simulated 180-degree power-off autorotation, and the flight instructor's failure to initiate corrective action in time to keep the helicopter from impacting the terrain.NTSB LAX07CA273Accident · No injuriesData collectionFinal reportRobinson R22 Beta II · Oakland, CAThe student pilot's failure to adequately compensate for the crosswind conditions and to maintain directional control.NTSB SEA07CA193Accident · No injuriesData collectionFinal reportRobinson R 22 Beta · Long Beach, CAThe student pilot's improper use of the throttle and cyclic, and the certified flight instructor's inadequate supervision, which resulted in the collision with terrain.NTSB LAX06CA250Accident · Minor injuriesData collectionFinal reportRobinson R-22B · Chino, CAthe certified flight instructor's inadequate supervision and incorrect remedial action. A factor was the student pilot's loss of control in a hovering turn.