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 “In flight collision with object”. 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 |
| 1987 | 1 |
| 1999 | 1 |
| 2002 | 1 |
| 2003 | 1 |
| 2007 | 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\" = 220))
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" = 220))
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 CHI07CA311Accident · Minor injuriesData collectionFinal reportGrumman American AA-5 Traveler · Warrenton, MOThe low airspeed gust factor by the pilot, the altitude/clearance not maintained by the pilot, and the inadequate compensation for wind conditions by the pilot during the landing approach. Contributing factors were the trees and wind gusts.NTSB CHI03LA182Accident · 1 fatalLimited investigationFinal reportRobinson R-22 Beta · Dexter, MOThe pilot's inadequate visual lookout and failure to maintain clearance from the wires during the aerial application flight. Factors contributing to the accident were the helicopter's low altitude and the transmission wires.NTSB CHI02LA205Accident · Serious injuriesLimited investigationFinal reportPiper PA28-140 · El Dorado Sprgs, MOThe failure by the flight crew to abort the takeoff, as well as a failure by the flight instructor to properly monitor takeoff performance. Contributing factors to the accident were the flight crew's failure to calculate required takeoff distance, considering…NTSB CHI99LA135Accident · No injuriesLimited investigationFinal reportCessna 172M · Mayview, MOthe pilot's selection of unsuitable terrain for the attempted precautionary landing. Factors to the accident were the overcast weather condition, inadequate preflight planning by the pilot, the inadvertent flight into instrument meteorological conditions, and…NTSB MKC87FA094Accident · 2 fatalField investigationFinal reportPiper PA-28-140 · Neelyville, MOWitnesses stated that the p.I.c. had aborted several takeoff attempts while trying to depart to the north--the winds were originating from the southwest at approximately 5 mph. The aircraft eventually departed from, and almost used the full length of, runway…NTSB MKC85LA196Accident · No injuriesLimited investigationFinal reportCessna 172 M · Gravois Mills, MOThe plt reports that he began his takeoff on rwy 07 which is 2550 ft long, has an asphalt surface and a downhill slope. Plt said the rwy is rough. He said the acft did not achieve the speed desired and he reduced power to abort. He then decided to attempt the…NTSB MKC82DA120Accident · No injuriesFinal reportPiper PA-22-160 · Stockton, MOThe aircraft was one of a flight of four, making demonstration flybys at the airport. The pilot stated that he was slow flying, about 80 to 85 ft AGL, when the aircraft started to sink. At that time, he was about 1000 to 1500 ft behind, to the right, and 20…