NTSB investigations: Lycoming 0-320 series, FL
12 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 | 1 |
| 1984 | 1 |
| 1985 | 1 |
| 1992 | 1 |
| 1993 | 1 |
| 2000 | 1 |
| 2003 | 1 |
| 2004 | 2 |
| 2005 | 1 |
| 2006 | 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\" = 'FL' 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" = 'FL' 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 MIA06CA080Accident · Minor injuriesData collectionFinal reportAero Commander 100 · Englewood, FLThe pilot's failure to abort the takeoff in time to stop on the remaining runway, which resulted in the airplane overrunning the runway.NTSB MIA06CA032Accident · No injuriesData collectionFinal reportCessna 172P · Hialeah, FLThe failure of the CFI to perform a go-around following a long landing resulting in overrun, on ground encounter with soft terrain, and subsequent nose over.NTSB MIA04CA118Accident · No injuriesData collectionFinal reportPiper PA-28-151 · Sugar Loaf Key, FLThe failure of the pilot to attain the proper touchdown point resulting in a landing overrun and subsequent on-ground collision with trees.NTSB MIA04CA094Accident · No injuriesData collectionFinal reportPiper PA-28-140 · Lake Wales, FLThe pilot's delay in aborting the takeoff resulting in an overrun of the runway and subsequent impact with water. A finding in the accident was the pilot's failure to extend the flaps to the second notch (25 degrees).NTSB MIA04CA005Accident · Minor injuriesData collectionFinal reportCessna 172N · Everglades City, FLThe pilot's improper preflight planning/preparation which resulted in the airplane's gust lock being left installed, which resulted in the airplane not being able lift off during the takeoff roll, and damage to the airplane when it overran the runway and…NTSB ATL01LA006Accident · No injuriesLimited investigationFinal reportCessna 172K · Indiantown, FLThe pilot had excessive airspeed, misjudged the landing distance, and did not perform a go-around, which resulted in a nose over. The ditch was a contributing factor.NTSB MIA93LA119Accident · No injuriesLimited investigationFinal reportCessna 172M · Ochopee, FLThe pilot's poor judgement in attempting the takeoff from the parking ramp when a 12,000-FT runway was available.NTSB MIA92LA157Accident · No injuriesLimited investigationFinal reportCessna 172P · Valkaria, FLExcessive airspeed on final approach by the pilot in command resulting in failure to attain the proper touchdown point and running off the runway colliding with a tree.NTSB MIA86IA018Incident · No injuriesIncident investigationFinal reportGrumman American AA-5 · Live Oak, FLThe acft made a downwind landing touching down long on the rwy. The acft could not be stopped & ran off the end of the rwy. The plt stated that he misread the windsock.NTSB MIA84LA191Accident · No injuriesLimited investigationFinal reportCessna 172N · Miami, FLThe plt said he had 'cross channeled' his radios & was having communication problems. He decided to land at the opa-locka west arpt. The acft was landed downwind & after overrunning the end of the rwy, it collided with terrain & was damaged.NTSB MIA83LA142Accident · No injuriesLimited investigationFinal reportCessna 172M · Arcadia, FLThe plt reported that on his approach to land, his speed was higher than normal & the acft touched down well past the normal touchdown point. He was unable to stop on the remaining rwy. The acft went off the end of the rwy & collided with a ditch. The plt…NTSB MIA82DA160Accident · Minor injuriesFinal reportPiper PA-28-140 · Tampa, FLAfter landing long the plt realized that the acft could not be stopped on the rwy remaining & applied power for a go-around. He then became aware that the acft would not clear obstructions beyond the rwy end & aborted the go-around attempt. The acft came to…