NTSB investigations: Lycoming O-360 series
13 cases on aircraft whose registry engine model is Lycoming O-360 series, where the first occurrence was “Loss of control - on ground/water”. 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
| 1985 | 1 |
|---|---|
| 2002 | 1 |
| 2003 | 2 |
| 2004 | 2 |
| 2005 | 4 |
| 2006 | 2 |
| 2007 | 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.\"mKey\" IN (SELECT x.case_mkey FROM 'https://openairdocs.org/data/latest/ntsb_aircrafts.parquet' x WHERE x.engine_model_code IN ('41575')
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\" = 260))
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 ('41575')
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" = 260))
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 ANC07CA098Accident · No injuriesData collectionFinal reportPiper/Cub Crafters PA-18 · Umiat, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in an on ground encounter with terrain, and a nose over.NTSB SEA06CA070Accident · No injuriesData collectionFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain directional control during the landing roll, which resulted in a loss of control and subsequent nose over. Contributing factors were the tailwind and the soft snow-covered terrain.NTSB MIA06CA059Accident · No injuriesData collectionFinal reportPiper PA-18 · SanJuan, PRThe pilot's failure to maintain directional control during landing.NTSB DEN06CA012Accident · No injuriesData collectionFinal reportKucklick Hiperbipe · Watkins, COthe pilot's failure to maintain aircraft control during the landing resulting in a impact with a runway light and ground loop.NTSB ATL06CA010Accident · Minor injuriesData collectionFinal reportRobinson Beta II · Lawrenceville, GAThe pilot's improper use of flight controls which resulted in a collision with a fence.NTSB LAX05CA211Accident · No injuriesData collectionFinal reportAmerican Champion 8GCBC · Phoenix, AZthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB DEN05LA115Accident · No injuriesLimited investigationFinal reportHepperlen RV-8 · Durango, COthe pilot's failure to maintain directional control during the ground roll.NTSB ATL04CA168Accident · No injuriesData collectionFinal reportChristen Industries A1B · Hickory, NCThe pilot’s inadequate compensation for wind conditions and his failure to maintain directional control, during landing roll which resulted in a loss of control and collision with a trailer. The crosswind was a factor in the accident.NTSB MIA04CA106Accident · No injuriesData collectionFinal reportPiper PA-28 · Okeechobee, FLStudent pilot's failure to maintain directional control of the airplane during landing roll, resulting in the airplane departing the runway and impacting a fence incurring substantial damage to the airplane.NTSB SEA03LA167Accident · No injuriesLimited investigationFinal reportAviat A-1B · Driggs, IDThe pilot's failure to maintain control of the aircraft during the landing roll. A contributing factor was the dust devil.NTSB LAX03TA233Accident · No injuriesFinal reportPiper PA-18-150 · Ely, NVThe pilot's failure to maintain proper alignment with the road and the CFI's failure to adequately supervise the second pilot's landing and his delayed remedial action.NTSB LAX02LA067Accident · No injuriesLimited investigationFinal reportFarrand Vans RV6 · San Jose, CAFailure of the pilot to sufficiently slow the airplane prior to exiting the runway, which lead to the left main landing gear collapsing and a subsequent ground loop.NTSB DEN85LA107Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-181 · Kemmerer, WYOn April 2, 1985, an inexperienced pvt plt attempted to land on a runway with a 24KT crosswind at Kemmerer, WY. The favorable runway was closed due to snow accumulations. On the third attempt the acft landed hard and bounced into the air. The plt attempted to…