NTSB investigations: Lycoming 0-320 series, TX
25 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 | 3 |
|---|---|
| 1985 | 1 |
| 1986 | 1 |
| 1987 | 2 |
| 1988 | 1 |
| 1989 | 2 |
| 1991 | 1 |
| 1993 | 1 |
| 1996 | 1 |
| 1998 | 2 |
| 1999 | 2 |
| 2000 | 2 |
| 2002 | 2 |
| 2003 | 2 |
| 2004 | 1 |
| 2005 | 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\" = 'TX' 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" = 'TX' 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 DFW05CA100Accident · No injuriesData collectionFinal reportCessna 172L · Stephenville, TXThe pilot's improper recovery from a bounced landing, which resulted in a hard landing. A contributing factor was the prevailing crosswind.NTSB FTW04LA146Accident · No injuriesLimited investigationFinal reportCessna 172P · Mesquite, TXThe student pilot's delayed landing flare and the improper supervision provided by the flight instructor.NTSB FTW03FA184Accident · 2 fatalField investigationFinal reportCessna 172M · McAllen, TXThe pilot's failure to recover from a bounced landing which resulted in a loss of control. Contributing factors were the gusty winds.NTSB FTW03LA161Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Conroe, TXthe student pilot's inadequate compensation for wind. A contributing factor was the gusting wind conditions.NTSB FTW02LA175Accident · Serious injuriesLimited investigationFinal reportCessna 177 · Sherman, TXThe hard landing as result of the pilot's failure to maintain aircraft control during landing. A contributing factor was the gusty crosswinds.NTSB FTW02LA147Accident · No injuriesLimited investigationFinal reportCessna 172P · McKinney, TXthe student pilot's failure to properly recover from a bounced landing which resulted in the airplane porpoising. A contributing factor was the student pilot's improper landing flare which resulted in a bounced landing.NTSB FTW00LA193Accident · Minor injuriesLimited investigationFinal reportPiper PA-28-140 · Greenville, TXThe pilot's improper flare, which resulted in a hard landing.NTSB FTW00LA077Accident · No injuriesLimited investigationFinal reportRobinson R22 Beta · Sarita, TXThe failure of the pilot to maintain main rotor rpm, which resulted in a hard landing.NTSB FTW99LA269Accident · No injuriesLimited investigationFinal reportCessna 172N · Longview, TXThe pilot's improper touchdown technique, which resulted in the airplane porpoising.NTSB FTW99LA118Accident · No injuriesLimited investigationFinal reportPiper PA-28-140 · Cleburne, TXThe pilot's improper flare which resulted in a hard landing and his improper recovery procedures from a bounced landing.NTSB FTW98LA282Accident · No injuriesLimited investigationFinal reportBeech B19 · Frisco, TXThe student pilot's improper landing flare which resulted in a hard larding. Factors were the inadequate supervision of the flight by the flight instructor and the high winds.NTSB FTW98LA240Accident · No injuriesLimited investigationFinal reportCessna 172P · La Porte, TXThe pilot's premature landing flare and improper recovery procedures from a bounced landing. A factor was the gusty winds.NTSB FTW96LA191Accident · No injuriesLimited investigationFinal reportCessna 172P · Denton, TXthe student pilot's delayed landing flare and his improper bounced landing recovery technique.NTSB FTW93LA210Accident · No injuriesLimited investigationFinal reportCessna 172M · Lamesa, TXThe pilot's improper flare, improper recovery from a bounced landing and the inadvertent stall. A factor was the gusty wind.NTSB FTW91LA135Accident · No injuriesLimited investigationFinal reportBeech BE-19 · Mesquite, TXThe flight instructor's inadequate supervision of the student. Factors were the dual student's misjudgement of altitude and premature flare of the airplane.NTSB FTW90LA026Accident · No injuriesLimited investigationFinal reportCessna 172K · Fabens, TXThe pilot's improper flare during landing and inadequate recovery from the ensuing bounced landing. The unfavorable wind was a related factor.NTSB FTW89LA173Accident · No injuriesLimited investigationFinal reportBeech B-19 · Mckinney, TXPilot's improper technique in recovery from a bounced landing. Factors contributing to the accident were the pilot's failure to maintain directional control during the go around.NTSB FTW88LA107Accident · No injuriesLimited investigationFinal reportCessna 172N · Graham, TXThe student pilot was on a solo round-robin cross country training flight. He made a hard landing on the nose wheel that resulted in a propeller ground strike and damaged engine firewall. Gusty surface winds prevailed at the time of the accident.NTSB FTW87LA207Accident · Minor injuriesLimited investigationFinal reportMooney M20 · Livingston, TXDrg a practice touch-&-go lndg, the acft bounced. The plt applied power to abort the lndg, but lost directional control of the acft. It drifted left toward trees, so he initiated a climb to fly over the obstructions. However, the acft stalled & collided with…NTSB FTW87LA076Accident · No injuriesLimited investigationFinal reportCessna 172P · Roanoke, TXAircraft ballooned twice after touchdown followed by hard landing on nosegear resulting in substantial damage.NTSB FTW87LA006Accident · Minor injuriesLimited investigationFinal reportCessna 177 · Jacksboro, TXThe pilot reports that after a hard landing, the aircraft ballooned, bounced hard and veered off the runway due to gusty crosswinds. The winds for the area were reported to be from 140 degrees at 11 knots with no gusts.NTSB FTW85LA263Accident · No injuriesLimited investigationFinal reportCessna 172N · Temple, TXThe student pilot, who was carrying a passenger during a night flight, made a hard landing on the municipal airport at Temple, TX. This resulted in substantial damage to the aircraft but no injury to its two occupants. The student pilot's flying experience is…NTSB FTW82DA389Accident · No injuriesFinal reportCessna 172M · College Station, TXThe aircraft crashed during landing on runway 16 at College Station TX. The accident occurred on a dark night and the airport was not lighted. The aircraft was stolen by the pilot. The pilot said he was too high and fast on the approach. The propeller and…NTSB FTW82DA140Accident · No injuriesFinal reportCessna 172M · Breckenridge, TXThe accident occurred at an en route airport while the student pilot was on a cross-country flight. Upon arrival at the en route airport, he entered traffic for a landing on runway 03 in winds from 010 degrees at 10 KTS gusting to 27 KTS. The student reported…NTSB FTW82DA097Accident · No injuriesFinal reportCessna 172M · Tyler, TXWhile the instructor pilot was demonstrating a barrier/obstacle landing, the aircraft touched down hard and bounced. A power recovery was made and the flight was terminated. The pilots inspected the aircraft after landing, but no damage was noted until four…