NTSB investigations: Lycoming 0-320 series, NM
9 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1984 | 1 |
| 1989 | 1 |
| 1995 | 1 |
| 1998 | 1 |
| 2000 | 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\" = 'NM' 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o.\"occurrenceNumber\" = 1 AND o.\"occurrenceCode\" = 200))
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" = 'NM' 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_occurrences.parquet' o WHERE o.case_mkey = x.case_mkey AND o.aircrafts_position = x.position AND o."occurrenceNumber" = 1 AND o."occurrenceCode" = 200))
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 DEN00LA114Accident · No injuriesLimited investigationFinal reportCessna 172 · Abuquerque, NMThe pilot's improper flare and his inadequate recovery from a bounced landing.NTSB DEN00LA081Accident · No injuriesLimited investigationFinal reportHutchins RV4 · Los Alamos, NMThe pilot's failure to maintain control of the aircraft after initiating a go-around following a hard bounced landing. Factors were variable shifting winds and a high-density altitude.NTSB FTW98LA417Accident · No injuriesLimited investigationFinal reportCessna 172N · Gallup, NMThe pilot's inadequate landing flare. Factors were his misjudgement of altitude and his excessive airspeed.NTSB FTW95LA121Accident · No injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's delayed landing flare and the improper bounced landing recovery.NTSB DEN89LA052Accident · No injuriesLimited investigationFinal reportBeech 19 · Santa Fe, NMThe pilot's improper flare and improper recovery from a bounced landing, which resulted in a hard landing.NTSB DEN85LA003Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Silver City, NMThe plt stated after the accident that he was attempting to land on rwy 33. He continued to state that immediately prior to the landing flare, a 'terrific downdraft' forced the acft down on the rwy. The acft landed hard and the plt attempted a go-around. He…NTSB FTW84LA043Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Capitan, NMThe plt reported that the acft bounced on landing, resulting in the collapse of the main gear & damage to the prop & left wing. An exam revealed that the u-bolt which attaches the left main gear strut to the fuselage had failed due to tensile overload.…NTSB FTW82DA348Accident · No injuriesFinal reportCessna 172P · Albuquerque, NMThe student pilot lost control of the aircraft after a bounced landing. The aircraft ran off the side of the runway, encountered sandy terrain, and was damaged. The density altitude was about 7000 ft.NTSB FTW82DA184Accident · No injuriesFinal reportCessna 172P · Las Cruces, NMThe student pilot reported that during landing, the airspeed was too high. Reportedly, the aircraft touched down hard on all three gear, propoised, and subsequently, the plane was damaged. The wind was reported as light and variable.