NTSB investigations: Lycoming 0-320 series, NV
17 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
| 1982 | 1 |
|---|---|
| 1985 | 1 |
| 1988 | 1 |
| 1995 | 2 |
| 1997 | 1 |
| 1998 | 3 |
| 2000 | 1 |
| 2001 | 1 |
| 2002 | 1 |
| 2005 | 3 |
| 2006 | 2 |
Where
Latest 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\" = 'NV' 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" = 'NV' 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 LAX07CA006Accident · No injuriesData collectionFinal reportHarry D. Miller Midget Mustang 1 · Reno, NVthe pilot's inadequate compensation for the wind conditions and failure to maintain directional control during the landing rollout.NTSB LAX06CA149Accident · Minor injuriesData collectionFinal reportM.C. Thomas Thorpe T-18 · Reno, NVthe pilot's failure to maintain directional control. A contributing factor was the certified flight instructor's inadequate supervision of the flight.NTSB LAX06LA073Accident · Minor injuriesLimited investigationFinal reportGrumman AA-5 · Boulder City, NVThe pilot's inadequate preflight inspection and failure to follow the airplane's checklist, which resulted in his failure to remove the gust lock prior to flight.NTSB LAX05CA268Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Reno, NVThe pilot's inadequate compensation for the crosswind gust and failure to maintain lateral and directional control during the landing flare.NTSB LAX05CA240Accident · No injuriesData collectionFinal reportCessna 172N · North Las Vegas, NVthe student pilot's failure to maintain directional control.NTSB LAX03LA023Accident · No injuriesLimited investigationFinal reportCessna 172M · Mesquite, NVThe pilot's failure to maintain directional control during takeoff. A contributing factor was the ditch.NTSB LAX01LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · N. Las Vegas, NVThe pilot's inadequate compensation for the existing crosswind condition, and his failure to maintain runway alignment.NTSB LAX00LA351Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · North Las Vegas, NVThe pilot's inadequate compensation for the gusty and variable crosswind conditions. Factors were the variable and gusty crosswinds.NTSB LAX99LA010Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Carson City, NVThe pilot's failure to verify the wind direction and speed, his selection of the wrong runway for the existing wind conditions, and, his inadequate compensation for those wind conditions.NTSB LAX98LA276Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Henderson, NVThe pilot's inadequate compensation for the existing wind conditions and his failure to maintain directional control.NTSB LAX98LA143Accident · No injuriesLimited investigationFinal reportCessna 172M · Henderson, NVThe pilot's decision to attempt a landing in crosswind conditions at or above the demonstrated capability of the aircraft, and his subsequent failure to maintain proper runway alignment.NTSB LAX97LA329Accident · No injuriesLimited investigationFinal reportPiper PA-18-150 · Hawthorne, NVThe pilot's inadequate compensation for the existing wind condition and his subsequent failure to maintain directional control.NTSB LAX95LA267Accident · Minor injuriesLimited investigationFinal reportCessna 172P · Reno, NVthe pilot's loss of directional control during a crosswind landing using full flaps and the lack of familiarity with the crosswind landing component chart for the aircraft.NTSB LAX95LA095Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · Carson City, NVthe pilot's improper use of the brakes.NTSB SEA88LA044Accident · No injuriesLimited investigationFinal reportCessna 172N · Henderson, NVDuring ground landing roll on a touch and go practice session, the solo student pilot allowed the aircraft to drift off the side of the runway and overcorrected in the opposite direction. After applying full power to abort the landing, she realized the flaps…NTSB SEA86LA001Accident · No injuriesLimited investigationFinal reportCessna 172P · Winnemucca, NVDirectional control was lost during takeoff roll due to a flat nose wheel tire. The aircraft continued to veer to the left of the runway despite the student pilots attempts to correct to the right. The aircraft departed the runway where it nosed over.NTSB LAX82DA150Accident · No injuriesFinal reportBellanca 7GCBC · Deeth, NVThe pilot chose to land on an abandoned highway on a heading of 240 degrees. Reportedly, the winds were from the northeast at 8 gusting 18 knots. While making a wheel landing, a gust of wind was encountered about when enough speed had been lost to lower the…