NTSB investigations: Lycoming 0-320 series, IN
11 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
| 1984 | 1 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 1993 | 2 |
| 1994 | 1 |
| 1996 | 1 |
| 1998 | 1 |
| 2003 | 1 |
| 2004 | 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\" = 'IN' 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" = 'IN' 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 CHI04LA248Accident · No injuriesLimited investigationFinal reportCessna 172 · Gary, INThe failure of the nose wheel for undetermined reasons. A factor associated with the accident was the student pilot's failure to properly flare the airplane.NTSB CHI03LA229Accident · No injuriesLimited investigationFinal reportCessna 172P · Huntingburg, INThe pilot's inadequate flare and the failure to perform a go-around during landing. The planned approach with a quartering tailwind were contributing factors.NTSB CHI99LA039Accident · No injuriesLimited investigationFinal reportCessna 172N · Evansville, INThe pilot's improper flare and improper recovery from a bounced landing.NTSB CHI96LA283Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Rensselaer, INthe student pilot's improper flare and improper recovery from a bounced landing.NTSB CHI94LA335Accident · No injuriesLimited investigationFinal reportPiper PA-28-161 · W. Lafayette, INThe pilot's improper level-off and recovery from a bounced landing. A factor in the accident was the pilot's lack of training for recovery from bounced landings and/or aborted takeoffs.NTSB CHI93LA338Accident · No injuriesLimited investigationFinal reportBeech 19 · Elkhart, INinadequate remedial action by the flight instructor. Factors related to the accident were the excessive descent rate and the overload failure of the landing gear.NTSB CHI93LA190Accident · No injuriesLimited investigationFinal reportPiper PA-28 · Indianapolis, INa misjudged flare and subsequent hard landing by the student pilot. A factor in the accident was the student pilot's failure to perform a go-around.NTSB CHI87LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Marion, INThe plt stated that on final aprx he did not flare soon enough and the nosewheel 'hit the rwy hard.: he further stated that the acft 'ballooned up' and he attempted to 'flare out again without success. ' according to the plt, the acft bounced up and down an…NTSB CHI86LA076Accident · No injuriesLimited investigationFinal reportCessna 177 · Indianapolis, INThe student pilot flared too high, damaging the aircraft upon touchdown.NTSB CHI85LA243Accident · No injuriesLimited investigationFinal reportCessna 172 M · Decatur, INThe pilot landing rnwy 36 winds were 210 degrees, 12 knots gusts 18 knots stalled out high onthe wet on the wet sod runway the nose wheel dug in and then broke off the acft then nosed over inverted.NTSB CHI84LA321Accident · No injuriesLimited investigationFinal reportCessna 177 · Hobart, INThe plt figured he was high and hot during landing so he said he just pushed the nose over and forced the acft onto the rwy. The acft hit hard on the nose gear and bounced. After recovery the plt found the nose gear tire flat and taxiied off the rwy into the…