NTSB investigations: Lycoming O-360-J2A, ID
5 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 | 1 |
| 2015 | 2 |
| 2017 | 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\" = 'ID' 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" = 'ID' 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 GAA17CA496Accident · Minor injuriesData collectionFinal reportMIke Reed Super Cub · Murphy, IDThe pilot’s use of excessive brake pressure during the landing roll, which resulted in a nose-over.NTSB GAA15CA224Accident · Minor injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDThe helicopter flight instructor's delayed remedial action during an autorotation resulting in a loss of control and impact with terrain.NTSB GAA15CA181Accident · No injuriesData collectionFinal reportRobinson Helicopter R22 Beta · Caldwell, IDAbnormal ground contact during a 180 degree autorotation, resulting in a severed tail rotor driveshaft by a main rotor blade. A factor contributing to the accident was the rotor blowback condition due to the aft tilting of the main rotor disk.NTSB SEA08CA019Accident · No injuriesData collectionFinal reportRobinson R22 Beta · Parma, IDThe student pilot's improper use of the flight controls while performing a hovering autorotation and the flight instructor's excessive remedial action which resulted in a hard landing.NTSB SEA06CA160Accident · No injuriesData collectionFinal reportRobinson R-22B · Boise, IDThe instructor pilot's inadvertent excessive descent rate, and his delay of remedial action during the demonstration of a 180 degree autorotation.