NTSB investigations: Lycoming 0-320 series, MO
7 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
| 1982 | 2 |
|---|---|
| 1983 | 1 |
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 1 |
| 2002 | 1 |
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\" = 'MO' 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" = 'MO' 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 CHI03LA030Accident · Minor injuriesLimited investigationFinal reportPiper PA-22-150 · Cuba, MOThe pilots inadequate flare and recovery from a bounced landing. Contributing factors to this accident were the crosswind and the ditch.NTSB MKC88LA011Accident · No injuriesLimited investigationFinal reportChampion 7GCB · Warrensburg, MOThe plt indicated that on final app, when ovr the rwy threshold, he leveled the acft off at abt 10 ft and it dropped in. Subsequent inspection revealed that all four wing spars had longitudinal cracks. The plt had recently purchased the acft and had abt 14…NTSB MKC86LA076Accident · No injuriesLimited investigationFinal reportBellanca 7GCBC · St.Charles, MOThe PIC was nervously concerned about an acft that was close behind him in the traffic pattern. The PIC landed fast on the rwy and the right main gear axle broke. The gear leg dug into the rwy and the acft veered off the left side into the soft terrain which…NTSB MKC85LA222Accident · Minor injuriesLimited investigationFinal reportCessna 172I · Cameron, MOThe pilot stated that he was aware of the IFR conditions enroute but was not expecting them so soon. When he was within four minutes of his landing airport, the weather turned very bad but he decided to continue. Visibility was so bad that he had to turn to…NTSB MKC83LA175Accident · No injuriesLimited investigationFinal reportCessna 172P · Kansas City, MOOn landing the aircraft touched down hard, bounced and the right main landing gear broke off. A go around was executed and the flight proceeded to Kansas City where an emergency landing was made. During landing the aircraft swerved off the runway to the right.NTSB MKC83LA016Accident · No injuriesLimited investigationFinal reportBeech A23-19 · Excelsior Spgs., MOThe student pilot reported that he made a landing approach to runway 01 in winds that were from 320 degrees at 5, gusting 8 KTS. During the approach, he lowered full flaps and maintained a left wing low attitude to compensate for the crosswind. The pilot…NTSB MKC82DA118Accident · No injuriesFinal reportCessna 172 · Point Lookout, MOThe aircraft bounced several times during landing and the nose wheel tire blewout. There was substantial damage to the nose strut, firewall and propeller.