NTSB investigations: Lycoming 0-320 series, CA
13 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the defining event was Hard landing. 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
| 2008 | 3 |
|---|---|
| 2009 | 2 |
| 2011 | 2 |
| 2013 | 1 |
| 2015 | 1 |
| 2016 | 2 |
| 2021 | 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 ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e.\"isDefiningEvent\" AND e.\"tier2Number\" = '092'))
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 ('41508')
AND EXISTS (SELECT 1 FROM 'https://openairdocs.org/data/latest/ntsb_events.parquet' e WHERE e.case_mkey = x.case_mkey AND e.aircrafts_position = x.position AND e."isDefiningEvent" AND e."tier2Number" = '092'))
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 WPR21LA364Accident · No injuriesClass 4 · LimitedFinal reportCessna 172 · Auburn, CAThe student pilot’s inadequate flare which resulted in a hard and bounced landing.NTSB WPR21LA331Accident · No injuriesClass 4 · LimitedFinal reportCessna 172N · Hayward, CAThe pilot's improper landing flare, which resulted in a bounced hard landing.NTSB GAA16CA511Accident · No injuriesData collectionFinal reportCessna 172 · Auburn, CAThe pilot's improper landing flare, which resulted in a hard, bounced landing.NTSB GAA16CA202Accident · No injuriesData collectionFinal reportCessna 172 · Camarillo, CAThe student pilot's incorrect pitch control input, resulting in a porpoise during landing and substantial damage to the airplane's firewall.NTSB GAA15CA063Accident · Minor injuriesData collectionFinal reportCessna 172P · Los Angeles, CAThe student pilot's failure to maintain attitude control during the landing flare, resulting in a hard landing.NTSB WPR14CA074Accident · No injuriesData collectionFinal reportCessna 172M · Fullerton, CAThe pilot's inadequate landing flare, which resulted in a bounced landing.NTSB WPR12CA049Accident · No injuriesData collectionFinal reportCessna 172K · Napa, CAThe student pilot's improper landing flare, inadequate recovery from a bounced landing, and loss of directional control.NTSB WPR11CA086Accident · No injuriesData collectionFinal reportGiorgio Anthony J RV4 · Torrance, CAThe pilot's inadequate landing flare that resulted in a hard landing and a ground loop.NTSB WPR09CA206Accident · No injuriesData collectionFinal reportCessna 172M · Corona, CAThe pilot's improper landing flare.NTSB WPR09CA209Accident · No injuriesData collectionFinal reportCessna 172P · Livermore, CAThe student pilot’s improper recovery from a bounced landing.NTSB LAX08CA165Accident · No injuriesData collectionFinal reportCessna 172M · Byron, CAThe flight instructor's inadequate compensation for the wind conditions, and his inadequate supervision of the student pilot. Factors contributing to the accident were a sudden wind shift and wind gusts.NTSB LAX08CA149Accident · No injuriesData collectionFinal reportCessna 172N · Palo Alto, CAThe pilot's inadequate recovery from a bounced landing.NTSB SEA08CA065Accident · No injuriesData collectionFinal reportRobinson R-22 · Riverside, CAThe pilot's misjudged landing flare and improper use of the collective control.