NTSB investigations: Lycoming O-360-J2A
6 cases on aircraft whose registry engine model is Lycoming O-360-J2A, where the first occurrence was “Loss of control - in flight”. 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
| 2004 | 1 |
|---|---|
| 2006 | 2 |
| 2007 | 3 |
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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42314')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 250))
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."mKey" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('42314')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 250))
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 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 CHI07CA281Accident · No injuriesData collectionFinal reportRobinson R-22 Beta · St. Clair Rgnl., MOThe pilot overcorrected following a loss of control while practicing a hovering turn.NTSB DEN07CA115Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Albuquerque, NMThe pilot's failure to maintain aircraft control during an encounter with the loss of tail rotor effectiveness. Contributing factors were the high density altitude and the power lines.NTSB DFW06CA213Accident · No injuriesData collectionFinal reportRobinson R22 · Skiatook, OKThe pilot's failure to maintain control of the helicopter following an encounter with dynamic rollover.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.NTSB DEN04CA131Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Logan, UTthe instructor's failure to maintain adequate rotor speed during the landing flare, resulting in a hard landing. Contributing factors include the student's delay in relinquishing the controls and the instructor's improper supervision.