NTSB investigations: Lycoming O-360-J2A, AZ
7 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
| 2007 | 2 |
|---|---|
| 2009 | 2 |
| 2014 | 1 |
| 2016 | 1 |
| 2021 | 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\" = 'AZ' 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" = 'AZ' 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 WPR22FA001Accident · 2 fatalClass 3 · FieldFinal reportRobinson Helicopter R22 · Chandler, AZThe failure of the pilots onboard the airplane to see and avoid the helicopter while maneuvering in the traffic pattern, which resulted in a midair collision.NTSB WPR16LA156Accident · Minor injuriesLimited investigationFinal reportRobinson R22 · Prescott, AZThe flight instructor’s delayed remedial action to address a low rotor rpm condition, which resulted in an excessive descent rate and a subsequent hard landing.NTSB WPR15IA080Incident · No injuriesIncident investigationFinal reportRobinson Helicopter R22 Beta II · Phoenix, AZThe failure of the fanshaft due to fatigue.NTSB WPR09FA284Accident · 1 fatalField investigationFinal reportRobinson Helicopter R22 Beta · Morristown, AZThe pilot's failure to maintain clearance from the power line.NTSB WPR09CA173Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Chandler, AZThe certified flight instructor's inadequate supervision of the student pilot during a hover demonstration and his subsequent loss of helicopter control that resulted in a dynamic rollover.NTSB SEA07CA233Accident · No injuriesData collectionFinal reportRobinson R-22 Beta II · Tucson, AZThe student pilot's failure to maintain rotor RPM during landing approach, and the delayed remedial action by the flight instructor. A contributing factor was the high density altitude weather condition.NTSB LAX07CA090Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Tucson, AZThe failure of the student pilot to maintain an adequate main rotor rpm and the instructor’s failure to maintain control of the aircraft.