NTSB investigations: Lycoming 0-320 series
930 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, newest first
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 ('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."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 MIA06CA083Accident · No injuriesData collectionFinal reportCessna 172M · Vero Beach, FLThe pilot's failure to maintain directional control while executing a go-around in gusty conditions which resulted in the airplane veering off the runway, colliding with a ditch and nosing over.NTSB NYC06CA088Accident · No injuriesData collectionFinal reportCessna 172-P · Cambridge, MDThe student pilot's improper recovery from a bounced landing.NTSB ATL06CA057Accident · No injuriesData collectionFinal reportCessna 172M · Newnan, GAThe student pilot's failure to maintain directional control on the landing roll out, resulting in the airplane veering off the right side of the runway and colliding with an airport runway sign.NTSB LAX06CA138Accident · No injuriesData collectionFinal reportPiper PA-28-180 · Paso Robles, CAthe pilot's inadequate compensation for the crosswind conditions and failure to maintain directional control.NTSB ANC06CA033Accident · No injuriesData collectionFinal reportChampion 7GCB · Fairbanks, AKThe pilot's failure to maintain directional control during the landing roll, which resulted in the airplane colliding with a snowbank and nosing over.NTSB ANC06CA031Accident · No injuriesData collectionFinal reportRobinson R22 · Anchorage, AKThe pilot's decision to land the helicopter on an icy airport parking ramp, which resulted in a loss of control on touchdown, and subsequent collision with another parked and unoccupied helicopter.NTSB LAX06CA117Accident · No injuriesData collectionFinal reportCessna 172M · Prescott, AZthe pilot's inadequate compensation for the crosswind conditions and his failure to maintain directional control.NTSB CHI06CA083Accident · No injuriesData collectionFinal reportCessna 172N · New Hudson, MIThe solo student pilot's failure to properly compensate for the crosswind, resulting in his failure to maintain directional control during landing. Factors were the crosswind and the snow bank.NTSB DFW06CA065Accident · No injuriesData collectionFinal reportRalph Sanders Murphy Acft Elite · Presidio, TXThe pilot's failure to maintain directional control during the takeoff roll.NTSB LAX06CA097Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Maricopa, AZThe pilot's failure to maintain directional control during landing rollout. A factor was the soft dirt adjacent to the runway.NTSB NYC06CA057Accident · No injuriesData collectionFinal reportPiper PA-28-161 · New Haven, CTThe student pilot's improper flare and inadequate recovery from a bounced landing, which resulted in a loss of aircraft control during landing and subsequent impact with a ditch.NTSB DEN06CA033Accident · No injuriesData collectionFinal reportCessna 172M · Denver, COthe pilot's failure to align the airplane's nose into the direction of the wind while performing the pre-takeoff checklist. A contributing factor was the gusty wind conditions.NTSB DEN06CA030Accident · No injuriesData collectionFinal reportAppel Mustang II · Erie, COthe pilot's inadequate preflight decision to depart in gusty winds, and the pilot's failure to maintain direction control during the departure roll. The high gusty crosswind contributed to the accident.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 NYC06CA051Accident · No injuriesData collectionFinal reportPiper PA-22 · Jamestown, NYThe pilot's failure to maintain directional control during the landing rollout. Factors included the ice on the runway and the soft terrain.NTSB DFW06CA026Accident · No injuriesData collectionFinal reportCessna 172N · Sherman, TXThe pilot's failure to maintain directional control during takeoff.NTSB NYC06CA013Accident · No injuriesData collectionFinal reportCessna 172K · West Milford, NJA loss of aircraft control as a result of the installation of an improper pilot seat which moved during the takeoff roll/run..NTSB MIA06CA011Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Vero Beach, FLThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in the on-ground collision with runway signs.NTSB LAX06CA013Accident · Minor injuriesData collectionFinal reportPiper PA-23-160 · Upland, CAthe pilot's failure to maintain directional control during landing.NTSB CHI06LA006Accident · No injuriesLimited investigationFinal reportBeech 19A · Jackson, MIThe student pilot's inadvertent porpoise during landing, which resulted in a loss of control and a collision with a sign.NTSB NYC05CA143Accident · No injuriesData collectionFinal reportCessna 172P · Caldwell, NJThe student pilot's failure to maintain directional control while landing. A factor in this accident was the crosswind condition.NTSB ANC05CA146Accident · No injuriesData collectionFinal reportPiper PA-18 · Fairbanks, AKThe pilot's failure to maintain control of the airplane during the landing roll, which resulted in a collision with a tree. A factor contributing to the accident was a tailwind.NTSB SEA05LA185Accident · No injuriesLimited investigationFinal reportPiper PA-22-150 · Mead, WASeparation of the tailwheel assembly spring resulting in a loss of directional control and subsequent collision with a berm. The berm was a factor in the accident.NTSB NYC05CA136Accident · Minor injuriesData collectionFinal reportHanek Pitts S1S · Mercer, PAThe pilot's failure to maintain directional control during takeoff, which resulted in an on ground encounter with crops. A factor in this accident was the crosswind condition, as reported by the pilot.NTSB LAX05CA276Accident · No injuriesData collectionFinal reportCessna 172N · Ramona, CAthe pilot's failure to maintain directional control during landing.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 ANC05CA152Accident · No injuriesData collectionFinal reportPiper PA-18 · Wiseman, AKThe pilot's selection of unsuitable terrain for landing, which resulted in a nose over during the landing roll. Factors contributing to the accident were a short landing area, and pressure to conduct the flight, which the pilot stated was a rescue situation.NTSB CHI05CA219Accident · No injuriesData collectionFinal reportAmerican Champion 7GCBC · Watertown, WIThe flightcrew's failure to maintain directional control during landing rollout.NTSB LAX05CA240Accident · No injuriesData collectionFinal reportCessna 172N · North Las Vegas, NVthe student pilot's failure to maintain directional control.NTSB ATL05CA132Accident · No injuriesData collectionFinal reportCessna 172P · Savannah, GAThe pilot's failure to maintain directional control on landing roll out resulting in a ground loop, and on ground collision of the right wing with the ground.NTSB IAD05LA087Accident · No injuriesLimited investigationFinal reportCessna 172M · Marysville, OHThe pilot's failure to maintain directional control during landing.NTSB ATL05CA112Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Dunnellon, FLThe pilot's inadequate compensation for wind and his failure to maintain directional control during the landing roll. The crosswind was a contributing factor.NTSB SEA05CA123Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Ontario, ORThe pilot's failure to maintain aircraft control during landing roll. A contributing factor was the cross wind weather condition.NTSB LAX05CA191Accident · No injuriesData collectionFinal reportCessna 172N · Stockton, CAthe pilot's improper use of the brakes, and his failure to maintain directional control during the landing rollout.NTSB ANC05CA077Accident · No injuriesData collectionFinal reportPiper PA-18 · Dillingham, AKThe instructor pilot's inadequate supervision, and the dual student's failure to maintain directional control. Factors associated with the accident were a crosswind, and an inadvertent ground loop.NTSB LAX05CA148Accident · No injuriesData collectionFinal reportCessna 172N · Palo Alto, CAThe student's failure to maintain directional control and the CFI's failure to adequately supervise the flight.NTSB CHI05CA105Accident · No injuriesData collectionFinal reportPiper PA-28-161 · South Bend, INThe student pilot failed to compensate for the crosswind condition and failed to maintain directional control. Factors included the crosswind and the windsock.NTSB CHI05CA101Accident · No injuriesData collectionFinal reportPiper PA-22-160 · Gordon, NEThe student pilot's failure to maintain direction control during landing. The pilot lack of familiarity with the airplane was a factor.NTSB ANC05CA054Accident · No injuriesData collectionFinal reportPiper PA-18 · Bethel, AKThe pilot's failure to compensate for a crosswind during an aborted landing, which resulted in a loss of directional control. A factor associated with the accident was a crosswind.NTSB LAX05CA127Accident · No injuriesData collectionFinal reportCessna 172L · Chino, CAthe pilot's inadequate compensation for a gusting crosswind and his failure to maintain directional control.NTSB LAX05CA121Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Chandler, AZthe pilot's failure to maintain directional control.NTSB SEA05LA054Accident · 1 fatalLimited investigationFinal reportSimpkins RV-6A · Yamhill, ORThe failure of the pilot to maintain directional control of the airplane during the landing roll resulting in a nose over. Factors contributing to the accident included the wet runway and the embankment.NTSB ANC05LA044Accident · No injuriesLimited investigationFinal reportPiper PA-22 · Anchorage, AKThe pilot's excessive taxi speed during a turn while taxiing from landing, which resulted in the collapse of the left main landing gear, and structural damage to the fuselage.NTSB CHI05CA075Accident · Serious injuriesData collectionFinal reportCessna 172K · Portage, WIThe pilot's failure to maintain adequate airspeed during the aborted landing, which resulted in an inadvertent stall at a low altitude. Factors to the accident were the pilot's lack of experience flying from the right pilot station and his failure to maintain…NTSB LAX05CA098Accident · No injuriesData collectionFinal reportPiper PA-28-161 · Chandler, AZthe students pilot's failure to maintain directional control resulting in a collision with the taxiway sign.NTSB CHI05LA070Accident · No injuriesLimited investigationFinal reportCessna 172N · Grafton, NDThe pilot's inadequate compensation for the wind conditions which resulted in a loss of directional control during the landing. Factors associated with the accident were the crosswind condition and the snow bank.NTSB CHI05CA068Accident · No injuriesData collectionFinal reportPiper PA-18-150 · Larimore, NDThe CFI's delay in applying remedial action which resulted in a loss of directional control of the airplane. Factors associated with the accident were the student's excessive application of rudder and the snow bank which the airplane contacted.NTSB IAD05CA037Accident · No injuriesData collectionFinal reportCessna 172P · Cross Keys, NJThe pilots failure to maintain directional control. Factors contributing to the accident were the pilots lack of experience, and the snow bank.NTSB SEA05CA043Accident · No injuriesData collectionFinal reportCessna 172N · Idaho Falls, IDThe student pilot's failure to maintain directional control and the instructor's inadequate supervision of the flight. A contributing factor was the deep snow beside the runway.NTSB MIA05CA064Accident · No injuriesData collectionFinal reportGrumman American AA-5A · Ocala, FLThe pilot-rated passengers improper use of the rudder control and his failure to maintain directional control resulting in a loss of control on the ground.