NTSB investigations: Lycoming 0-320 series, NM
15 cases on aircraft whose registry engine model is Lycoming 0-320 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
| 1983 | 2 |
|---|---|
| 1984 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1990 | 2 |
| 1991 | 1 |
| 1992 | 2 |
| 1993 | 1 |
| 1994 | 1 |
| 1996 | 1 |
| 1997 | 1 |
| 2006 | 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\" = '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\" = 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."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" = 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 DEN07CA014Accident · No injuriesData collectionFinal reportChampion 7GCB · Farmington, NMthe pilot's failure to maintain directional control during the landing.NTSB FTW98LA090Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Ruidoso, NMthe pilot's inadequate compensation for wind conditions and failure to maintain directional control of the airplane. Related factors were: the gusty crosswind condition, icy runway, and proximity of the snowbank.NTSB FTW96LA246Accident · No injuriesLimited investigationFinal reportCessna 172N · Farmington, NMfailure of the pilot to maintain directional control during a touch-and-go landing, which resulted in a ground swerve and subsequent collision with a parked airplane.NTSB FTW95LA076Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during a touch-and-go landing.NTSB FTW93LA065Accident · Minor injuriesLimited investigationFinal reportCessna 172N · Santa Fe, NMThe pilot's failure to maintain directional control. A factor was the snow conditionsNTSB DEN93LA056Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe pilot's failure to maintain aircraft control and the instructor's inadequate supervision.NTSB FTW92LA057Accident · No injuriesLimited investigationFinal reportCessna 172N · Albuquerque, NMThe pilot's failure to maintain directional control during landing. A factor was his lack of total experience.NTSB FTW92LA021Accident · No injuriesLimited investigationFinal reportCessna 177 · Santa Teresa, NMThe pilot's failure to initiate corrective action in a timely fashion.NTSB DEN90LA177Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Las Vegas, NMThe pilot's inadequate compensation for wind conditions and failure to maintain directional control.NTSB DEN90LA163Accident · No injuriesLimited investigationFinal reportCessna 172 · Grants, NMThe pilot's failure to maintain directional control.NTSB DEN87LA151Accident · No injuriesLimited investigationFinal reportPiper PA-22-160 · Los Lunas, NMThe plt reported that after touchdown, the acft swerved to the right and went into a water filled irrigation ditch. The acft nosed over and came to rest inverted. A post accident inspection revealed a deflated tail wheel which appeared to have blown out. It…NTSB DEN86LA094Accident · No injuriesLimited investigationFinal reportCessna 172M · Quemado, NMThe plt said the wind was variable and gusty. When the takeoff was started there was a quartering headwind but as takeoff speed was reached the wind switched to a tailwind. The acft lifted off but immediately settled back to the rwy. The plt then added flaps…NTSB DEN84LA082Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Albuquerque, NMThe acft swerved off the rwy and collapsed the left main landing gear during landing. The plt said he believes he misused the heel brakes during the landing roll since he was more familiar with acft with toe brakes.NTSB FTW83LA216Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Roswell, NMThe CFI stated, the acft was lined up on the center line at the end of runway 17. The student pilot applied power and the acft veered to the left, he over-corrected to the right. He further stated, 'I reduced the power to idle as the right landing gear…NTSB FTW83LA171Accident · Minor injuriesLimited investigationFinal reportPiper PA-18-150 · Los Lunas, NMDuring the landing roll, the plt lost directional control of the acft & it went off the right side of the rwy & hit an irrigation ditch. Reportedly, there was no acft malfunction or failure prior to the mishap.