NTSB investigations: Lycoming 0-320 series, IL
10 cases on aircraft whose registry engine model is Lycoming 0-320 series, where the first occurrence was “Overrun”. 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 |
|---|---|
| 1983 | 4 |
| 1984 | 1 |
| 1989 | 1 |
| 1990 | 1 |
| 1992 | 1 |
| 2007 | 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\" = 'IL' 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\" = 340))
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" = 'IL' 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" = 340))
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 CHI08CA038Accident · No injuriesData collectionFinal reportPiper PA-22-150 · Plato Center, ILThe excessive airspeed used by the pilot which resulted in an overrun, impact with a ditch and subsequent nose over. The ditch was a factor.NTSB CHI92LA174Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Rockford, ILThe flight instructor's premature liftoff. Related factors are the instructor's lack of total experience in the accident make and model airplane, and the unsuitable terrain encountered during the roll-out.NTSB CHI90LA063Accident · No injuriesLimited investigationFinal reportCessna 172 · Newark, ILImproper planning/decision by the pilot. The wet condition of the grass runway was a related factor.NTSB CHI89LA081Accident · No injuriesLimited investigationFinal reportCessna 172D · Ottawa, ILStudent pilot's continuing an approach to landing beyond the point where she could bring the aircraft to a controlled stop on the remaining runway surface.NTSB CHI84LA218Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Lansing, ILThe 2432 ft rwy had a 224 ft displaced threshold due to trees near the apch end. The plt stated that when he landed, the acft touched down 'somewhat down the rwy past the treshold' with 25 deg of flaps. He stated that braking had little effect because the…NTSB CHI83LA432Accident · Minor injuriesLimited investigationFinal reportCessna 172 · Carthage, ILThe acft collided with a ditch during landing. The acft bounced and floated during landing. The pilot said he thought hewas too FAR down the rwy for a go-around so he applied the brakes. The acft skidded off the rwy end into a ditch. The pilot thought a gust…NTSB CHI83LA396Accident · No injuriesLimited investigationFinal reportCessna 172 · Princeton, ILThe turf rwy was wet from recent rains. The plt stated that during takeoff, the acft had accelerated to near the rotation speed when it was slowed by a soft spot in the rwy near mid field. At the same point, an upslope portion of the rwy was encountered & the…NTSB CHI83LA217Accident · No injuriesLimited investigationFinal reportCessna 172 · Mchenry, ILThe acft went off the departure end of runway 09 during landing and nosed over. The weather as reported by the operator,was scattered clouds, more than 5 miles visibility and winds calm. Runway 09 had been in use all day. The pilot stated that his approach…NTSB CHI83LA106Accident · No injuriesLimited investigationFinal reportPiper PA-28-180 · Vernon, ILThe aircraft ran off the end of a runway and collided with a ditch. The student pilot on his first solo cross country had become disoriented and landed 95 miles off course. He had been flying 2 hours and 30 minutes. He was supposed to reach enroute stop after…NTSB CHI82DA330Accident · No injuriesFinal reportCessna 172 · Winchester, ILThe pilot elected to land on a 1600 ft grass strip with a crosswind of about 5 KTS. He reported that he crossed the fence at about 60 KTS with 15 deg of flaps, then touched down about 400 ft down the runway. During the landing roll, he saw he would be unable…